eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TIME_GEN dependencies on FND_MESSAGE

Line 425: fnd_message.set_name ('HXT', 'HXT_39287_AG_ERR_NO_ERN_POL');

421: g_sub_loc := 'Gen_Rot_Plan';
422:
423: IF g_asm_rec.egp_id IS NULL
424: THEN -- SPR C258 by BC
425: fnd_message.set_name ('HXT', 'HXT_39287_AG_ERR_NO_ERN_POL');
426: fnd_message.set_token (
427: 'ASSIGN',
428: g_asm_rec.assignment_number
429: );

Line 426: fnd_message.set_token (

422:
423: IF g_asm_rec.egp_id IS NULL
424: THEN -- SPR C258 by BC
425: fnd_message.set_name ('HXT', 'HXT_39287_AG_ERR_NO_ERN_POL');
426: fnd_message.set_token (
427: 'ASSIGN',
428: g_asm_rec.assignment_number
429: );
430: g_autogen_error := '';

Line 436: fnd_message.set_name ('HXT', 'HXT_39289_AG_ERR_NO_ROT_PLAN');

432: END IF;
433:
434: IF g_asm_rec.rtp_id IS NULL
435: THEN
436: fnd_message.set_name ('HXT', 'HXT_39289_AG_ERR_NO_ROT_PLAN');
437: fnd_message.set_token (
438: 'ASSIGN',
439: g_asm_rec.assignment_number
440: );

Line 437: fnd_message.set_token (

433:
434: IF g_asm_rec.rtp_id IS NULL
435: THEN
436: fnd_message.set_name ('HXT', 'HXT_39289_AG_ERR_NO_ROT_PLAN');
437: fnd_message.set_token (
438: 'ASSIGN',
439: g_asm_rec.assignment_number
440: );
441: g_autogen_error := '';

Line 447: fnd_message.set_name ('HXT', 'HXT_39326_INV_ERN_STRT_DATE');

443: END IF;
444:
445: IF g_asm_rec.effective_start_date > g_asm_rec.end_date
446: THEN
447: fnd_message.set_name ('HXT', 'HXT_39326_INV_ERN_STRT_DATE');
448: g_autogen_error := '';
449: RAISE g_form_level_error;
450: END IF;
451:

Line 454: fnd_message.set_name ('HXT', 'HXT_39325_ERN_POL_EXP');

450: END IF;
451:
452: IF g_asm_rec.effective_end_date < g_asm_rec.start_date
453: THEN
454: fnd_message.set_name ('HXT', 'HXT_39325_ERN_POL_EXP');
455: g_autogen_error := '';
456: RAISE g_form_level_error;
457: END IF;
458:

Line 462: fnd_message.set_name ('HXT', 'HXT_39310_START_DATE_NF');

458:
459: -- generate all autogen hours
460: IF g_asm_rec.start_date = NULL
461: THEN
462: fnd_message.set_name ('HXT', 'HXT_39310_START_DATE_NF');
463: g_autogen_error := '';
464: RAISE g_form_level_error;
465: END IF;
466:

Line 469: fnd_message.set_name ('HXT', 'HXT_39309_END_DATE_NF');

465: END IF;
466:
467: IF g_asm_rec.end_date = NULL
468: THEN
469: fnd_message.set_name ('HXT', 'HXT_39309_END_DATE_NF');
470: g_autogen_error := '';
471: RAISE g_form_level_error;
472: END IF;
473:

Line 513: fnd_message.set_name ('HXT', 'HXT_39364_AUTOGEN_COMP_W_ERRS');

509: -- Check for errors
510: IF g_errors
511: THEN
512: -- begin SPR C348 by BC
513: fnd_message.set_name ('HXT', 'HXT_39364_AUTOGEN_COMP_W_ERRS');
514: errbuf := fnd_message.get;
515: fnd_message.CLEAR;
516: retcode := 2;
517: ELSE

Line 514: errbuf := fnd_message.get;

510: IF g_errors
511: THEN
512: -- begin SPR C348 by BC
513: fnd_message.set_name ('HXT', 'HXT_39364_AUTOGEN_COMP_W_ERRS');
514: errbuf := fnd_message.get;
515: fnd_message.CLEAR;
516: retcode := 2;
517: ELSE
518:

Line 515: fnd_message.CLEAR;

511: THEN
512: -- begin SPR C348 by BC
513: fnd_message.set_name ('HXT', 'HXT_39364_AUTOGEN_COMP_W_ERRS');
514: errbuf := fnd_message.get;
515: fnd_message.CLEAR;
516: retcode := 2;
517: ELSE
518:
519: If not l_tccount then -- added 2772781

Line 520: FND_MESSAGE.SET_NAME('HXT','HXT_AUTOGEN_PROCESS'); -- added 2772781

516: retcode := 2;
517: ELSE
518:
519: If not l_tccount then -- added 2772781
520: FND_MESSAGE.SET_NAME('HXT','HXT_AUTOGEN_PROCESS'); -- added 2772781
521: else
522: fnd_message.set_name ('HXT', 'HXT_39365_AUTOGEN_COMP_NORM');
523: end IF;
524: errbuf := fnd_message.get;

Line 522: fnd_message.set_name ('HXT', 'HXT_39365_AUTOGEN_COMP_NORM');

518:
519: If not l_tccount then -- added 2772781
520: FND_MESSAGE.SET_NAME('HXT','HXT_AUTOGEN_PROCESS'); -- added 2772781
521: else
522: fnd_message.set_name ('HXT', 'HXT_39365_AUTOGEN_COMP_NORM');
523: end IF;
524: errbuf := fnd_message.get;
525: fnd_message.CLEAR;
526: retcode := 0;

Line 524: errbuf := fnd_message.get;

520: FND_MESSAGE.SET_NAME('HXT','HXT_AUTOGEN_PROCESS'); -- added 2772781
521: else
522: fnd_message.set_name ('HXT', 'HXT_39365_AUTOGEN_COMP_NORM');
523: end IF;
524: errbuf := fnd_message.get;
525: fnd_message.CLEAR;
526: retcode := 0;
527: END IF;
528:

Line 525: fnd_message.CLEAR;

521: else
522: fnd_message.set_name ('HXT', 'HXT_39365_AUTOGEN_COMP_NORM');
523: end IF;
524: errbuf := fnd_message.get;
525: fnd_message.CLEAR;
526: retcode := 0;
527: END IF;
528:
529: DELETE FROM fnd_sessions

Line 541: fnd_message.CLEAR;

537: WHERE session_id = USERENV ('SESSIONID');
538:
539: COMMIT;
540: errbuf := g_sqlerrm;
541: fnd_message.CLEAR;
542: call_gen_error (NULL, g_sqlerrm, SQLERRM);
543: retcode := 2;
544: WHEN OTHERS
545: THEN

Line 549: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');

545: THEN
546: DELETE FROM fnd_sessions
547: WHERE session_id = USERENV ('SESSIONID');
548:
549: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');
550: fnd_message.set_token ('SQLERR', SQLERRM);
551: errbuf := fnd_message.get;
552: fnd_message.CLEAR;
553: retcode := 2;

Line 550: fnd_message.set_token ('SQLERR', SQLERRM);

546: DELETE FROM fnd_sessions
547: WHERE session_id = USERENV ('SESSIONID');
548:
549: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');
550: fnd_message.set_token ('SQLERR', SQLERRM);
551: errbuf := fnd_message.get;
552: fnd_message.CLEAR;
553: retcode := 2;
554: COMMIT;

Line 551: errbuf := fnd_message.get;

547: WHERE session_id = USERENV ('SESSIONID');
548:
549: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');
550: fnd_message.set_token ('SQLERR', SQLERRM);
551: errbuf := fnd_message.get;
552: fnd_message.CLEAR;
553: retcode := 2;
554: COMMIT;
555: END;

Line 552: fnd_message.CLEAR;

548:
549: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');
550: fnd_message.set_token ('SQLERR', SQLERRM);
551: errbuf := fnd_message.get;
552: fnd_message.CLEAR;
553: retcode := 2;
554: COMMIT;
555: END;
556:

Line 617: fnd_message.set_name ('HXT', 'HXT_39367_GET_WRK_DAY_ERR');

613: WHEN OTHERS
614: THEN
615:
616: --HXT11 g_autogen_error := 'ERROR Get_Work_Day (' || SQLERRM || ')';
617: fnd_message.set_name ('HXT', 'HXT_39367_GET_WRK_DAY_ERR');
618: fnd_message.set_token ('SQLERR', SQLERRM);
619: g_autogen_error := '';
620: g_sqlerrm := SQLERRM;
621: call_gen_error (NULL, g_autogen_error, g_sqlerrm); --SPR C389

Line 618: fnd_message.set_token ('SQLERR', SQLERRM);

614: THEN
615:
616: --HXT11 g_autogen_error := 'ERROR Get_Work_Day (' || SQLERRM || ')';
617: fnd_message.set_name ('HXT', 'HXT_39367_GET_WRK_DAY_ERR');
618: fnd_message.set_token ('SQLERR', SQLERRM);
619: g_autogen_error := '';
620: g_sqlerrm := SQLERRM;
621: call_gen_error (NULL, g_autogen_error, g_sqlerrm); --SPR C389
622: g_errors := TRUE; --SPR C389

Line 694: fnd_message.set_name ('HXT', 'HXT_39368_GEN_WRK_PLAN_ERR');

690: END LOOP;
691: EXCEPTION
692: WHEN OTHERS
693: THEN
694: fnd_message.set_name ('HXT', 'HXT_39368_GEN_WRK_PLAN_ERR');
695: fnd_message.set_token ('SQLERR', SQLERRM);
696: g_autogen_error := '';
697: hxt_util.DEBUG (g_autogen_error);
698: g_sqlerrm := SQLERRM;

Line 695: fnd_message.set_token ('SQLERR', SQLERRM);

691: EXCEPTION
692: WHEN OTHERS
693: THEN
694: fnd_message.set_name ('HXT', 'HXT_39368_GEN_WRK_PLAN_ERR');
695: fnd_message.set_token ('SQLERR', SQLERRM);
696: g_autogen_error := '';
697: hxt_util.DEBUG (g_autogen_error);
698: g_sqlerrm := SQLERRM;
699: call_gen_error (NULL, g_autogen_error, g_sqlerrm);

Line 761: fnd_message.set_name ('HXT', 'HXT_39288_AG_ERR_DATES');

757: LOOP
758: -- Report error if missing time on first pass
759: IF (l_cntr = 1) AND (a_start <> sch_rec.start_date)
760: THEN
761: fnd_message.set_name ('HXT', 'HXT_39288_AG_ERR_DATES');
762: fnd_message.set_token (
763: 'A_START',
764: fnd_date.date_to_chardate (/*Bug 10621762 */calendar_aware=>FND_date.calendar_aware_alt,dateval=>a_start)
765: );

Line 762: fnd_message.set_token (

758: -- Report error if missing time on first pass
759: IF (l_cntr = 1) AND (a_start <> sch_rec.start_date)
760: THEN
761: fnd_message.set_name ('HXT', 'HXT_39288_AG_ERR_DATES');
762: fnd_message.set_token (
763: 'A_START',
764: fnd_date.date_to_chardate (/*Bug 10621762 */calendar_aware=>FND_date.calendar_aware_alt,dateval=>a_start)
765: );
766: fnd_message.set_token (

Line 766: fnd_message.set_token (

762: fnd_message.set_token (
763: 'A_START',
764: fnd_date.date_to_chardate (/*Bug 10621762 */calendar_aware=>FND_date.calendar_aware_alt,dateval=>a_start)
765: );
766: fnd_message.set_token (
767: 'START_DATE',
768: fnd_date.date_to_chardate (/*Bug 10621762 */calendar_aware=>FND_date.calendar_aware_alt,dateval=>sch_rec.start_date)
769: );
770: call_gen_error (NULL, '');

Line 858: fnd_message.set_name ('HXT', 'HXT_39284_AG_ERR_WRT_BATCHID');

854: RETURN (l_batch_id);
855: EXCEPTION
856: WHEN OTHERS
857: THEN
858: fnd_message.set_name ('HXT', 'HXT_39284_AG_ERR_WRT_BATCHID');
859: fnd_message.set_token ('BATCH_ID', TO_CHAR (l_batch_id));
860: g_autogen_error := '';
861: g_sqlerrm := SQLERRM;
862: RAISE g_form_level_error;

Line 859: fnd_message.set_token ('BATCH_ID', TO_CHAR (l_batch_id));

855: EXCEPTION
856: WHEN OTHERS
857: THEN
858: fnd_message.set_name ('HXT', 'HXT_39284_AG_ERR_WRT_BATCHID');
859: fnd_message.set_token ('BATCH_ID', TO_CHAR (l_batch_id));
860: g_autogen_error := '';
861: g_sqlerrm := SQLERRM;
862: RAISE g_form_level_error;
863: END create_batch;

Line 898: fnd_message.set_name ('HXT', 'HXT_39465_AG_ERR_WRT_REF_ID');

894: COMMIT;
895: EXCEPTION
896: WHEN OTHERS
897: THEN
898: fnd_message.set_name ('HXT', 'HXT_39465_AG_ERR_WRT_REF_ID');
899: fnd_message.set_token ('REF_ID', TO_CHAR (l_batch_id));
900: g_autogen_error := '';
901: g_sqlerrm := SQLERRM;
902: RAISE g_form_level_error;

Line 899: fnd_message.set_token ('REF_ID', TO_CHAR (l_batch_id));

895: EXCEPTION
896: WHEN OTHERS
897: THEN
898: fnd_message.set_name ('HXT', 'HXT_39465_AG_ERR_WRT_REF_ID');
899: fnd_message.set_token ('REF_ID', TO_CHAR (l_batch_id));
900: g_autogen_error := '';
901: g_sqlerrm := SQLERRM;
902: RAISE g_form_level_error;
903: END update_batch_ref;

Line 935: fnd_message.set_name ('HXT', 'HXT_39285_AG_ERR_WRT_TIMCARD');

931: RETURN (l_tim_id);
932: EXCEPTION
933: WHEN OTHERS
934: THEN --DEBUG ONLY
935: fnd_message.set_name ('HXT', 'HXT_39285_AG_ERR_WRT_TIMCARD');
936: fnd_message.set_token ('FIRST_NAME', g_asm_rec.first_name);
937: fnd_message.set_token ('LAST_NAME', g_asm_rec.last_name);
938: fnd_message.set_token ('EMP_NUMBER', TO_CHAR (g_asm_rec.person_id));
939: g_autogen_error := '';

Line 936: fnd_message.set_token ('FIRST_NAME', g_asm_rec.first_name);

932: EXCEPTION
933: WHEN OTHERS
934: THEN --DEBUG ONLY
935: fnd_message.set_name ('HXT', 'HXT_39285_AG_ERR_WRT_TIMCARD');
936: fnd_message.set_token ('FIRST_NAME', g_asm_rec.first_name);
937: fnd_message.set_token ('LAST_NAME', g_asm_rec.last_name);
938: fnd_message.set_token ('EMP_NUMBER', TO_CHAR (g_asm_rec.person_id));
939: g_autogen_error := '';
940: g_sqlerrm := SQLERRM;

Line 937: fnd_message.set_token ('LAST_NAME', g_asm_rec.last_name);

933: WHEN OTHERS
934: THEN --DEBUG ONLY
935: fnd_message.set_name ('HXT', 'HXT_39285_AG_ERR_WRT_TIMCARD');
936: fnd_message.set_token ('FIRST_NAME', g_asm_rec.first_name);
937: fnd_message.set_token ('LAST_NAME', g_asm_rec.last_name);
938: fnd_message.set_token ('EMP_NUMBER', TO_CHAR (g_asm_rec.person_id));
939: g_autogen_error := '';
940: g_sqlerrm := SQLERRM;
941: RAISE g_form_level_error;

Line 938: fnd_message.set_token ('EMP_NUMBER', TO_CHAR (g_asm_rec.person_id));

934: THEN --DEBUG ONLY
935: fnd_message.set_name ('HXT', 'HXT_39285_AG_ERR_WRT_TIMCARD');
936: fnd_message.set_token ('FIRST_NAME', g_asm_rec.first_name);
937: fnd_message.set_token ('LAST_NAME', g_asm_rec.last_name);
938: fnd_message.set_token ('EMP_NUMBER', TO_CHAR (g_asm_rec.person_id));
939: g_autogen_error := '';
940: g_sqlerrm := SQLERRM;
941: RAISE g_form_level_error;
942: END create_timecard;

Line 1196: fnd_message.set_name ('HXT', 'HXT_39268_ERR_IN_TIME_GEN');

1192: -- Check for errors
1193: IF l_retcode = 2
1194: THEN
1195: g_errors := TRUE;
1196: fnd_message.set_name ('HXT', 'HXT_39268_ERR_IN_TIME_GEN');
1197: g_autogen_error := '';
1198: call_gen_error (NULL, g_autogen_error, g_sqlerrm); --SPR C389
1199: END IF;
1200: EXCEPTION

Line 1203: fnd_message.set_name ('HXT', 'HXT_39278_AG_ERR_SEL_SEQNO');

1199: END IF;
1200: EXCEPTION
1201: WHEN l_seq_exceptn
1202: THEN
1203: fnd_message.set_name ('HXT', 'HXT_39278_AG_ERR_SEL_SEQNO');
1204: g_autogen_error := '';
1205: g_sqlerrm := SQLERRM;
1206: RAISE g_date_worked_error;
1207: WHEN OTHERS

Line 1209: fnd_message.set_name ('HXT', 'HXT_39277_AG_ERR_INS_HRS_WKED');

1205: g_sqlerrm := SQLERRM;
1206: RAISE g_date_worked_error;
1207: WHEN OTHERS
1208: THEN
1209: fnd_message.set_name ('HXT', 'HXT_39277_AG_ERR_INS_HRS_WKED');
1210: g_autogen_error := '';
1211: g_sqlerrm := SQLERRM;
1212: RAISE g_date_worked_error;
1213: END create_hrw;

Line 1237: fnd_message.set_name ('HXT', 'HXT_39283_AG_ERR_GET_SEQNO2');

1233: RETURN (l_nextval);
1234: EXCEPTION
1235: WHEN OTHERS
1236: THEN
1237: fnd_message.set_name ('HXT', 'HXT_39283_AG_ERR_GET_SEQNO2');
1238: g_autogen_error := '';
1239: g_sqlerrm := SQLERRM;
1240: RAISE g_form_level_error;
1241: END get_hxt_seqno;

Line 1263: fnd_message.set_name ('HXT', 'HXT_39282_AG_ERR_GET_BATCHID');

1259: EXCEPTION
1260: WHEN OTHERS
1261: THEN
1262: g_sqlerrm := SQLERRM;
1263: fnd_message.set_name ('HXT', 'HXT_39282_AG_ERR_GET_BATCHID');
1264: g_autogen_error := '';
1265: RAISE g_form_level_error;
1266: END get_next_batch_id;
1267:

Line 1328: fnd_message.set_name ('HXT', 'HXT_39280_AG_ERR_DAT_DESC');

1324: );
1325: EXCEPTION
1326: WHEN OTHERS
1327: THEN
1328: fnd_message.set_name ('HXT', 'HXT_39280_AG_ERR_DAT_DESC');
1329: fnd_message.set_token ('DATE', fnd_date.date_to_chardate (/*Bug 10621762 */calendar_aware=>FND_date.calendar_aware_alt,dateval=>l_date));
1330: g_autogen_error := '';
1331: g_sqlerrm := SQLERRM;
1332: RAISE g_date_worked_error;

Line 1329: fnd_message.set_token ('DATE', fnd_date.date_to_chardate (/Bug 10621762 /calendar_aware=>FND_date.calendar_aware_alt,dateval=>l_date));

1325: EXCEPTION
1326: WHEN OTHERS
1327: THEN
1328: fnd_message.set_name ('HXT', 'HXT_39280_AG_ERR_DAT_DESC');
1329: fnd_message.set_token ('DATE', fnd_date.date_to_chardate (/*Bug 10621762 */calendar_aware=>FND_date.calendar_aware_alt,dateval=>l_date));
1330: g_autogen_error := '';
1331: g_sqlerrm := SQLERRM;
1332: RAISE g_date_worked_error;
1333: END convert_time;

Line 1354: fnd_message.set_name ('HXT', 'HXT_39281_AG_ERR_CONV_TIME');

1350: );
1351: EXCEPTION
1352: WHEN OTHERS
1353: THEN
1354: fnd_message.set_name ('HXT', 'HXT_39281_AG_ERR_CONV_TIME');
1355: g_autogen_error := '';
1356: g_sqlerrm := SQLERRM;
1357: RAISE g_date_worked_error;
1358: END convert_time;

Line 1413: fnd_message.set_name ('HXT', 'HXT_39466_TCARD_DEL_FAIL');

1409: COMMIT;
1410: EXCEPTION
1411: WHEN OTHERS
1412: THEN
1413: fnd_message.set_name ('HXT', 'HXT_39466_TCARD_DEL_FAIL');
1414: fnd_message.set_token ('SQLERR', SQLERRM);
1415: g_sqlerrm := fnd_message.get;
1416: RAISE g_del_obs_tim_error;
1417: END del_obsolete_tim;

Line 1414: fnd_message.set_token ('SQLERR', SQLERRM);

1410: EXCEPTION
1411: WHEN OTHERS
1412: THEN
1413: fnd_message.set_name ('HXT', 'HXT_39466_TCARD_DEL_FAIL');
1414: fnd_message.set_token ('SQLERR', SQLERRM);
1415: g_sqlerrm := fnd_message.get;
1416: RAISE g_del_obs_tim_error;
1417: END del_obsolete_tim;
1418:

Line 1415: g_sqlerrm := fnd_message.get;

1411: WHEN OTHERS
1412: THEN
1413: fnd_message.set_name ('HXT', 'HXT_39466_TCARD_DEL_FAIL');
1414: fnd_message.set_token ('SQLERR', SQLERRM);
1415: g_sqlerrm := fnd_message.get;
1416: RAISE g_del_obs_tim_error;
1417: END del_obsolete_tim;
1418:
1419:

Line 1512: fnd_message.set_name ('HXT', 'HXT_39276_AG_ERR_DEL_HRS_WKED');

1508: -- PRIVATE procedure to delete hours-worked that were autogen'ed for this
1509: -- period that will be autogen'ed again. Error records will cascade-delete.
1510: BEGIN
1511: -- Delete existing hour-worked entries
1512: fnd_message.set_name ('HXT', 'HXT_39276_AG_ERR_DEL_HRS_WKED');
1513: g_autogen_error := '';
1514: g_sub_loc := 'DELETE from hxt_det_hours_worked';
1515:
1516: -- Bug 7359347

Line 1540: fnd_message.set_name ('HXT', 'HXT_39275_AG_ERR_DEL_ERRS');

1536: AND effective_end_date; --C421
1537:
1538: COMMIT;
1539: -- Delete existing hxt_errors records for this timecard
1540: fnd_message.set_name ('HXT', 'HXT_39275_AG_ERR_DEL_ERRS');
1541: g_autogen_error := '';
1542:
1543: DELETE FROM hxt_errors
1544: WHERE tim_id = a_tim_id

Line 1599: fnd_message.set_name ('HXT', 'HXT_39286_AG_ERR_SEL_HOL_HRS');

1595: CLOSE cur_hcl;
1596: EXCEPTION
1597: WHEN OTHERS
1598: THEN
1599: fnd_message.set_name ('HXT', 'HXT_39286_AG_ERR_SEL_HOL_HRS');
1600: g_autogen_error := '';
1601: g_sqlerrm := SQLERRM;
1602: RAISE g_date_worked_error;
1603: END get_holiday_info;