'Please Enter An Hours Type' Message When Running Execute_Deposit_Process Api (Doc ID 300282.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Symptoms

 You are using the HXC Timestore API (<Note:223987.1>) which calls the procedure hxc_timestore_deposit.execute_deposit_process to update an existing timecard in 'WORKING' status to 'SUBMITTED' status. The program errors with the message

'Please enter an Hours Type.'

Here is the code to do this from your wrapper

hxc_self_service_time_deposit.get_timecard_tables(
p_timecard_id => c_rec.timecard_bb_id,
p_timecard_ovn => c_rec.timecard_ovn,
p_timecard_blocks => l_timecard_blocks,
p_timecard_app_attributes => l_timecard_app_attributes,
p_time_recipient_id => 1);

hxc_timestore_deposit.execute_deposit_process (
p_validate => TRUE
, p_app_blocks => l_timecard_blocks
, p_app_attributes => l_timecard_app_attributes
, p_messages => l_tbl_messages
, p_mode => 'SUBMIT'
, p_deposit_process => 'OTL Deposit Process'
, p_retrieval_process => 'BEE Retrieval Process'
, p_timecard_id => l_timecard_id
, p_timecard_ovn => l_timecard_ovn
);

Cause