434: g_lookup_desc);
435:
436: IF ( g_lookup_error = 'XXX' )
437: THEN
438: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
439: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
440: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
441: fnd_message.raise_error;
442: END IF;
435:
436: IF ( g_lookup_error = 'XXX' )
437: THEN
438: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
439: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
440: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
441: fnd_message.raise_error;
442: END IF;
443:
436: IF ( g_lookup_error = 'XXX' )
437: THEN
438: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
439: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
440: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
441: fnd_message.raise_error;
442: END IF;
443:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
437: THEN
438: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
439: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
440: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
441: fnd_message.raise_error;
442: END IF;
443:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
445: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
440: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
441: fnd_message.raise_error;
442: END IF;
443:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
445: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
446: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
447: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
448: g_errtab(c_39316_person_nf).errmsg := FND_MESSAGE.GET;
441: fnd_message.raise_error;
442: END IF;
443:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
445: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
446: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
447: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
448: g_errtab(c_39316_person_nf).errmsg := FND_MESSAGE.GET;
449: g_errtab(c_39316_person_nf).errtype := g_lookup_desc;
442: END IF;
443:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
445: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
446: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
447: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
448: g_errtab(c_39316_person_nf).errmsg := FND_MESSAGE.GET;
449: g_errtab(c_39316_person_nf).errtype := g_lookup_desc;
450:
443:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
445: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
446: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
447: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
448: g_errtab(c_39316_person_nf).errmsg := FND_MESSAGE.GET;
449: g_errtab(c_39316_person_nf).errtype := g_lookup_desc;
450:
451:
444: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
445: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
446: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
447: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
448: g_errtab(c_39316_person_nf).errmsg := FND_MESSAGE.GET;
449: g_errtab(c_39316_person_nf).errtype := g_lookup_desc;
450:
451:
452: record_error (
512: g_lookup_desc);
513:
514: IF ( g_lookup_error = 'XXX' )
515: THEN
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
518: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
519: fnd_message.raise_error;
520: END IF;
513:
514: IF ( g_lookup_error = 'XXX' )
515: THEN
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
518: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
519: fnd_message.raise_error;
520: END IF;
521:
514: IF ( g_lookup_error = 'XXX' )
515: THEN
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
518: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
519: fnd_message.raise_error;
520: END IF;
521:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
515: THEN
516: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
517: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
518: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
519: fnd_message.raise_error;
520: END IF;
521:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
523: FND_MESSAGE.set_token('USED_HRS',l_charged_hrs);
518: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
519: fnd_message.raise_error;
520: END IF;
521:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
523: FND_MESSAGE.set_token('USED_HRS',l_charged_hrs);
524: FND_MESSAGE.set_token('ACCRUED_HRS',l_accrued_hrs);
525: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
526: g_errtab(c_39335_exceeded_accrued_hrs).errmsg := FND_MESSAGE.GET;
519: fnd_message.raise_error;
520: END IF;
521:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
523: FND_MESSAGE.set_token('USED_HRS',l_charged_hrs);
524: FND_MESSAGE.set_token('ACCRUED_HRS',l_accrued_hrs);
525: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
526: g_errtab(c_39335_exceeded_accrued_hrs).errmsg := FND_MESSAGE.GET;
527: g_errtab(c_39335_exceeded_accrued_hrs).errtype := g_lookup_desc;
520: END IF;
521:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
523: FND_MESSAGE.set_token('USED_HRS',l_charged_hrs);
524: FND_MESSAGE.set_token('ACCRUED_HRS',l_accrued_hrs);
525: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
526: g_errtab(c_39335_exceeded_accrued_hrs).errmsg := FND_MESSAGE.GET;
527: g_errtab(c_39335_exceeded_accrued_hrs).errtype := g_lookup_desc;
528:
521:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
523: FND_MESSAGE.set_token('USED_HRS',l_charged_hrs);
524: FND_MESSAGE.set_token('ACCRUED_HRS',l_accrued_hrs);
525: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
526: g_errtab(c_39335_exceeded_accrued_hrs).errmsg := FND_MESSAGE.GET;
527: g_errtab(c_39335_exceeded_accrued_hrs).errtype := g_lookup_desc;
528:
529:
522: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
523: FND_MESSAGE.set_token('USED_HRS',l_charged_hrs);
524: FND_MESSAGE.set_token('ACCRUED_HRS',l_accrued_hrs);
525: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
526: g_errtab(c_39335_exceeded_accrued_hrs).errmsg := FND_MESSAGE.GET;
527: g_errtab(c_39335_exceeded_accrued_hrs).errtype := g_lookup_desc;
528:
529:
530: record_error (
858: g_lookup_desc);
859:
860: IF ( g_lookup_error = 'XXX' )
861: THEN
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
864: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
865: fnd_message.raise_error;
866: END IF;
859:
860: IF ( g_lookup_error = 'XXX' )
861: THEN
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
864: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
865: fnd_message.raise_error;
866: END IF;
867:
860: IF ( g_lookup_error = 'XXX' )
861: THEN
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
864: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
865: fnd_message.raise_error;
866: END IF;
867:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
861: THEN
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
864: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
865: fnd_message.raise_error;
866: END IF;
867:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
869: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
864: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
865: fnd_message.raise_error;
866: END IF;
867:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
869: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
870: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
871: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
872: g_errtab(c_39337_timecard_not_apprved).errmsg := FND_MESSAGE.GET;
865: fnd_message.raise_error;
866: END IF;
867:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
869: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
870: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
871: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
872: g_errtab(c_39337_timecard_not_apprved).errmsg := FND_MESSAGE.GET;
873: g_errtab(c_39337_timecard_not_apprved).errtype := g_lookup_desc;
866: END IF;
867:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
869: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
870: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
871: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
872: g_errtab(c_39337_timecard_not_apprved).errmsg := FND_MESSAGE.GET;
873: g_errtab(c_39337_timecard_not_apprved).errtype := g_lookup_desc;
874:
867:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
869: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
870: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
871: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
872: g_errtab(c_39337_timecard_not_apprved).errmsg := FND_MESSAGE.GET;
873: g_errtab(c_39337_timecard_not_apprved).errtype := g_lookup_desc;
874:
875:
868: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
869: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
870: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
871: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
872: g_errtab(c_39337_timecard_not_apprved).errmsg := FND_MESSAGE.GET;
873: g_errtab(c_39337_timecard_not_apprved).errtype := g_lookup_desc;
874:
875:
876: record_error (
1073:
1074:
1075: IF ( g_lookup_error = 'XXX' )
1076: THEN
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1079: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1080: fnd_message.raise_error;
1081: END IF;
1074:
1075: IF ( g_lookup_error = 'XXX' )
1076: THEN
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1079: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1080: fnd_message.raise_error;
1081: END IF;
1082:
1075: IF ( g_lookup_error = 'XXX' )
1076: THEN
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1079: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1080: fnd_message.raise_error;
1081: END IF;
1082:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1076: THEN
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1079: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1080: fnd_message.raise_error;
1081: END IF;
1082:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1084: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
1079: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1080: fnd_message.raise_error;
1081: END IF;
1082:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1084: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
1085: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
1086: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1087: g_errtab(c_39317_empl_inactive).errmsg := FND_MESSAGE.GET;
1080: fnd_message.raise_error;
1081: END IF;
1082:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1084: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
1085: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
1086: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1087: g_errtab(c_39317_empl_inactive).errmsg := FND_MESSAGE.GET;
1088: g_errtab(c_39317_empl_inactive).errtype := g_lookup_desc;
1081: END IF;
1082:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1084: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
1085: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
1086: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1087: g_errtab(c_39317_empl_inactive).errmsg := FND_MESSAGE.GET;
1088: g_errtab(c_39317_empl_inactive).errtype := g_lookup_desc;
1089:
1082:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1084: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
1085: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
1086: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1087: g_errtab(c_39317_empl_inactive).errmsg := FND_MESSAGE.GET;
1088: g_errtab(c_39317_empl_inactive).errtype := g_lookup_desc;
1089:
1090:
1083: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1084: FND_MESSAGE.set_token('PERIOD_END_DATE',period_end_date(p_period_id));
1085: FND_MESSAGE.set_token('TIMECARD_ID',p_tim_id);
1086: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1087: g_errtab(c_39317_empl_inactive).errmsg := FND_MESSAGE.GET;
1088: g_errtab(c_39317_empl_inactive).errtype := g_lookup_desc;
1089:
1090:
1091:
1285: g_lookup_desc);
1286:
1287: IF ( g_lookup_error = 'XXX' )
1288: THEN
1289: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1290: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1291: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1292: fnd_message.raise_error;
1293: END IF;
1286:
1287: IF ( g_lookup_error = 'XXX' )
1288: THEN
1289: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1290: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1291: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1292: fnd_message.raise_error;
1293: END IF;
1294:
1287: IF ( g_lookup_error = 'XXX' )
1288: THEN
1289: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1290: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1291: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1292: fnd_message.raise_error;
1293: END IF;
1294:
1295:
1288: THEN
1289: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1290: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1291: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1292: fnd_message.raise_error;
1293: END IF;
1294:
1295:
1296: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1292: fnd_message.raise_error;
1293: END IF;
1294:
1295:
1296: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1297: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: FND_MESSAGE.set_token('CAL_HRS',l_hol_hours);
1299: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errmsg := FND_MESSAGE.GET;
1300: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errtype := g_lookup_desc;
1293: END IF;
1294:
1295:
1296: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1297: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: FND_MESSAGE.set_token('CAL_HRS',l_hol_hours);
1299: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errmsg := FND_MESSAGE.GET;
1300: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errtype := g_lookup_desc;
1301:
1294:
1295:
1296: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1297: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: FND_MESSAGE.set_token('CAL_HRS',l_hol_hours);
1299: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errmsg := FND_MESSAGE.GET;
1300: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errtype := g_lookup_desc;
1301:
1302:
1295:
1296: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1297: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: FND_MESSAGE.set_token('CAL_HRS',l_hol_hours);
1299: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errmsg := FND_MESSAGE.GET;
1300: g_errtab(c_39334_hrs_chged_ne_cal_hrs).errtype := g_lookup_desc;
1301:
1302:
1303:
1358:
1359:
1360: IF ( g_lookup_error = 'XXX' )
1361: THEN
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1364: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1365: fnd_message.raise_error;
1366: END IF;
1359:
1360: IF ( g_lookup_error = 'XXX' )
1361: THEN
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1364: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1365: fnd_message.raise_error;
1366: END IF;
1367:
1360: IF ( g_lookup_error = 'XXX' )
1361: THEN
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1364: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1365: fnd_message.raise_error;
1366: END IF;
1367:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1361: THEN
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1364: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1365: fnd_message.raise_error;
1366: END IF;
1367:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1369: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1364: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1365: fnd_message.raise_error;
1366: END IF;
1367:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1369: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1371: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1372: g_errtab(c_39333_hol_not_valid_on_cal).errmsg := FND_MESSAGE.GET;
1365: fnd_message.raise_error;
1366: END IF;
1367:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1369: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1371: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1372: g_errtab(c_39333_hol_not_valid_on_cal).errmsg := FND_MESSAGE.GET;
1373: g_errtab(c_39333_hol_not_valid_on_cal).errtype := g_lookup_desc;
1366: END IF;
1367:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1369: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1371: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1372: g_errtab(c_39333_hol_not_valid_on_cal).errmsg := FND_MESSAGE.GET;
1373: g_errtab(c_39333_hol_not_valid_on_cal).errtype := g_lookup_desc;
1374:
1367:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1369: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1371: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1372: g_errtab(c_39333_hol_not_valid_on_cal).errmsg := FND_MESSAGE.GET;
1373: g_errtab(c_39333_hol_not_valid_on_cal).errtype := g_lookup_desc;
1374:
1375:
1368: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1369: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1371: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1372: g_errtab(c_39333_hol_not_valid_on_cal).errmsg := FND_MESSAGE.GET;
1373: g_errtab(c_39333_hol_not_valid_on_cal).errtype := g_lookup_desc;
1374:
1375:
1376: record_error (
1712: g_lookup_desc);
1713:
1714: IF ( g_lookup_error = 'XXX' )
1715: THEN
1716: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1717: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1718: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1719: fnd_message.raise_error;
1720: END IF;
1713:
1714: IF ( g_lookup_error = 'XXX' )
1715: THEN
1716: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1717: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1718: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1719: fnd_message.raise_error;
1720: END IF;
1721:
1714: IF ( g_lookup_error = 'XXX' )
1715: THEN
1716: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1717: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1718: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1719: fnd_message.raise_error;
1720: END IF;
1721:
1722: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1715: THEN
1716: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1717: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1718: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1719: fnd_message.raise_error;
1720: END IF;
1721:
1722: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1723: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1718: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1719: fnd_message.raise_error;
1720: END IF;
1721:
1722: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1723: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1724: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1725: g_errtab(c_39315_max_hrs_exceeded).errmsg := FND_MESSAGE.GET;
1726: g_errtab(c_39315_max_hrs_exceeded).errtype := g_lookup_desc;
1719: fnd_message.raise_error;
1720: END IF;
1721:
1722: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1723: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1724: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1725: g_errtab(c_39315_max_hrs_exceeded).errmsg := FND_MESSAGE.GET;
1726: g_errtab(c_39315_max_hrs_exceeded).errtype := g_lookup_desc;
1727:
1720: END IF;
1721:
1722: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1723: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1724: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1725: g_errtab(c_39315_max_hrs_exceeded).errmsg := FND_MESSAGE.GET;
1726: g_errtab(c_39315_max_hrs_exceeded).errtype := g_lookup_desc;
1727:
1728:
1721:
1722: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1723: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1724: FND_MESSAGE.set_token('NAME',person_name(p_person_id));
1725: g_errtab(c_39315_max_hrs_exceeded).errmsg := FND_MESSAGE.GET;
1726: g_errtab(c_39315_max_hrs_exceeded).errtype := g_lookup_desc;
1727:
1728:
1729: record_error (
1780: g_lookup_desc);
1781:
1782: IF ( g_lookup_error = 'XXX' )
1783: THEN
1784: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1785: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1786: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1787: fnd_message.raise_error;
1788: END IF;
1781:
1782: IF ( g_lookup_error = 'XXX' )
1783: THEN
1784: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1785: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1786: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1787: fnd_message.raise_error;
1788: END IF;
1789:
1782: IF ( g_lookup_error = 'XXX' )
1783: THEN
1784: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1785: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1786: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1787: fnd_message.raise_error;
1788: END IF;
1789:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1783: THEN
1784: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1785: fnd_message.set_token('PROCEDURE', 'HXTBTVAL');
1786: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1787: fnd_message.raise_error;
1788: END IF;
1789:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1791: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1786: fnd_message.set_token('STEP','Invalid HXT_TIMECARD_VALIDATION-'||g_lookup_error);
1787: fnd_message.raise_error;
1788: END IF;
1789:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1791: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1792: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1793: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1794: g_errtab(c_39332_day_on_hol_cal).errmsg := FND_MESSAGE.GET;
1787: fnd_message.raise_error;
1788: END IF;
1789:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1791: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1792: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1793: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1794: g_errtab(c_39332_day_on_hol_cal).errmsg := FND_MESSAGE.GET;
1795: g_errtab(c_39332_day_on_hol_cal).errtype := g_lookup_desc;
1788: END IF;
1789:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1791: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1792: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1793: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1794: g_errtab(c_39332_day_on_hol_cal).errmsg := FND_MESSAGE.GET;
1795: g_errtab(c_39332_day_on_hol_cal).errtype := g_lookup_desc;
1796:
1789:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1791: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1792: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1793: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1794: g_errtab(c_39332_day_on_hol_cal).errmsg := FND_MESSAGE.GET;
1795: g_errtab(c_39332_day_on_hol_cal).errtype := g_lookup_desc;
1796:
1797:
1790: FND_MESSAGE.SET_NAME('HXT',g_lookup_error);
1791: FND_MESSAGE.set_token('DATE_WORKED',to_char(p_day,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1792: FND_MESSAGE.set_token('HOLIDAY_CAL',holiday_calendar_name(p_hol_cal_id));
1793: FND_MESSAGE.set_token('ASSIGN',assignment(p_person_id));
1794: g_errtab(c_39332_day_on_hol_cal).errmsg := FND_MESSAGE.GET;
1795: g_errtab(c_39332_day_on_hol_cal).errtype := g_lookup_desc;
1796:
1797:
1798: record_error (