DBA Data[Home] [Help]

APPS.HXT_TIME_CLOCK dependencies on HXT_TIME_GEN

Line 658: l_timecard_id := hxt_time_gen.Get_HXT_Seqno;

654: END IF;
655: g_batch_err_id := l_batch_id;
656: HXT_UTIL.DEBUG('Batch id is: '||TO_CHAR(l_batch_id));--DEBUG ONLY --HXT115
657: /* Generate a unique timecard id for the new timecard */
658: l_timecard_id := hxt_time_gen.Get_HXT_Seqno;
659: IF l_timecard_id = NULL THEN
660: RAISE l_tim_id_creation_error;
661: END IF;
662: HXT_UTIL.DEBUG('Timecard id is: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115

Line 698: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating timecard id in hxt_time_gen.Get_HXT_Seqno','Timecard Creation', NULL);

694: RETURN l_retcode;
695: WHEN l_tim_id_creation_error THEN
696: FND_MESSAGE.SET_NAME('HXT','HXT_39407_CREATE_TIM'); -- HXT11
697: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', NULL);
698: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating timecard id in hxt_time_gen.Get_HXT_Seqno','Timecard Creation', NULL);
699: RETURN 2;
700: WHEN OTHERS THEN
701: FND_MESSAGE.SET_NAME('HXT','HXT_39408_CREATE_TIM_FUNC'); -- HXT11
702: l_retcode := log_clock_errors(FALSE, NULL,'Timecard Creation', SQLERRM);

Line 787: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating batch id in hxt_time_gen.Get_Next_Batch_Id','Timecard Creation', SQLERRM);

783: EXCEPTION
784: WHEN l_batch_id_error THEN
785: FND_MESSAGE.SET_NAME('HXT','HXT_39409_CREATE_BATCH'); -- HXT11
786: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', SQLERRM);
787: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating batch id in hxt_time_gen.Get_Next_Batch_Id','Timecard Creation', SQLERRM);
788: RETURN 2;
789:
790: WHEN l_reference_num_error THEN
791: FND_MESSAGE.SET_NAME('HXT','HXT_39410_CREATE_REF_FUNC'); -- HXT11

Line 1166: l_hours_worked_id := hxt_time_gen.Get_HXT_Seqno;

1162: IF b_generate_holiday = TRUE THEN
1163: l_hol_yn := 'Y';
1164: END IF;
1165: /*Obtain a unique hours worked id*/
1166: l_hours_worked_id := hxt_time_gen.Get_HXT_Seqno;
1167: IF l_hours_worked_id = NULL THEN
1168: RAISE l_hours_worked_id_error;
1169: END IF;
1170: g_hours_worked_err_id := l_hours_worked_id;

Line 1305: --HXT11l_retcode := log_clock_errors(TRUE, 'Error while attempting to obtain hours worked id from hxt_time_gen.Get_HXT_Seqno.','Record Hours', SQLERRM);

1301:
1302: WHEN l_hours_worked_id_error THEN
1303: FND_MESSAGE.SET_NAME('HXT','HXT_39416_GET_HRW_ID'); -- HXT11
1304: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1305: --HXT11l_retcode := log_clock_errors(TRUE, 'Error while attempting to obtain hours worked id from hxt_time_gen.Get_HXT_Seqno.','Record Hours', SQLERRM);
1306: RETURN 2;
1307:
1308: WHEN l_generate_details_error THEN
1309: FND_MESSAGE.SET_NAME('HXT','HXT_39417_PROB_GEN_DET'); -- HXT11