APPS.HXT_TIME_CLOCK dependencies on FND_DATE

Line 147: HXT_UTIL.DEBUG('determine_pay_date returns: '|| fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt));--DEBUG ONLY --FORMS60 --HXT115

143: l_retcode := hxt_clock_user_edits.determine_pay_date( start_time,
144: end_time,
145: l_person_id,
146: l_date_worked);
147: HXT_UTIL.DEBUG('determine_pay_date returns: '|| fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt));--DEBUG ONLY --FORMS60 --HXT115
148: IF l_retcode = 1 THEN
149: RAISE l_pay_date_data_err;
150: ELSIF l_retcode = 2 THEN
151: RAISE l_pay_date_sys_err;

Line 205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115

201: --DEBUG ONLY BEGIN
202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115
209: --DEBUG ONLY END

Line 206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115

202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115
209: --DEBUG ONLY END
210: --

Line 219: fnd_date.date_to_chardate(l_start_date)|| ' end date: '|| -- FORMS60

215: l_start_date,
216: l_end_date);
217: HXT_UTIL.DEBUG('get_time_period returns period: '|| --HXT115
218: TO_CHAR(l_time_period_id)|| ' start date: '||
219: fnd_date.date_to_chardate(l_start_date)|| ' end date: '|| -- FORMS60
220: fnd_date.date_to_chardate(l_end_date));--DEBUG ONLY --FORMS60
221: IF l_retcode = 1 THEN
222: RAISE l_time_per_data_err;
223: ELSIF l_retcode = 2 THEN

Line 220: fnd_date.date_to_chardate(l_end_date));--DEBUG ONLY --FORMS60

216: l_end_date);
217: HXT_UTIL.DEBUG('get_time_period returns period: '|| --HXT115
218: TO_CHAR(l_time_period_id)|| ' start date: '||
219: fnd_date.date_to_chardate(l_start_date)|| ' end date: '|| -- FORMS60
220: fnd_date.date_to_chardate(l_end_date));--DEBUG ONLY --FORMS60
221: IF l_retcode = 1 THEN
222: RAISE l_time_per_data_err;
223: ELSIF l_retcode = 2 THEN
224: RAISE l_time_per_data_err;

Line 397: FND_MESSAGE.SET_TOKEN('DATE_WORKED', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --FORMS60

393:
394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||
395: --HXT11' Payroll: '|| TO_CHAR(l_emp_rec.payroll_id);
396: FND_MESSAGE.SET_NAME('HXT','HXT_39330_CANT_CALC_TIM_PER'); -- HXT11
397: FND_MESSAGE.SET_TOKEN('DATE_WORKED', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --FORMS60
398: FND_MESSAGE.SET_TOKEN('PAYROLL', TO_CHAR(l_emp_rec.payroll_id)); --HXT11
399: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
400: RETURN;
401:

Line 480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60

476: WHEN l_make_hol_data_err THEN
477: ret_code := l_retcode;
478: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
479: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60
481: err_buf := FND_MESSAGE.GET; -- HXT11
482: FND_MESSAGE.CLEAR; -- HXT11
483:
484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||

Line 497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60

493: WHEN l_make_hol_sys_err THEN
494: ret_code := l_retcode;
495: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
496: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60
498: err_buf := FND_MESSAGE.GET; -- HXT11
499: FND_MESSAGE.CLEAR; -- HXT11
500:
501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||

Line 514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60

510: WHEN l_rec_hours_data_err THEN
511: ret_code := l_retcode;
512: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
513: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60
515: err_buf := FND_MESSAGE.GET; -- HXT11
516: FND_MESSAGE.CLEAR; -- HXT11
517:
518: --HXT11l_error_text := 'Data Error occurred in the record hours functionality';

Line 527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60

523: WHEN l_rec_hours_sys_err THEN
524: ret_code := l_retcode;
525: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
526: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60
528: err_buf := FND_MESSAGE.GET; -- HXT11
529: FND_MESSAGE.CLEAR; -- HXT11
530:
531: --HXT11l_error_text := 'System error occurred in the record hours functionality';

Line 549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60

545:
546: WHEN OTHERS THEN
547: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
548: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(dateval=>l_date_worked,/*Bug 10621762*/calendar_aware=>fnd_date.calendar_aware_alt)); --HXT11 --SIR149 --FORMS60
550: err_buf := FND_MESSAGE.GET; -- HXT11
551: FND_MESSAGE.CLEAR; -- HXT11
552:
553: ret_code := 2;

Line 952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115

948: END IF;
949: END IF;
950: --END SIR344
951: HXT_UTIL.DEBUG('The following holiday information was obtained');--DEBUG ONLY --HXT115
952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115
953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115
956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115