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.HR_GENERAL_UTILITIES dependencies on HR_UTILITY

Line 23: g_debug boolean := hr_utility.debug_enabled;

19: || g_replace_string || '"';
20: g_language_attribute VARCHAR2 (200) := ' LANGUAGE="'
21: || g_replace_string || '"';
22: g_execute_handles g_varchar2_tab_type;
23: g_debug boolean := hr_utility.debug_enabled;
24: g_string_cache g_vc32k_tab_type;
25: c_error_msg varchar2 (2000);
26: c_login_msg varchar2 (2000);
27: --

Line 96: g_debug := hr_utility.debug_enabled;

92: AND trunc(p_effective_date)
93: BETWEEN trunc(effective_start_date) AND trunc(effective_end_date);
94: BEGIN
95:
96: g_debug := hr_utility.debug_enabled;
97: IF g_debug THEN
98: l_proc := g_package || ' Get_Person_Record';
99: hr_utility.set_location('Entering : ' || l_proc, 5);
100: END IF;

Line 99: hr_utility.set_location('Entering : ' || l_proc, 5);

95:
96: g_debug := hr_utility.debug_enabled;
97: IF g_debug THEN
98: l_proc := g_package || ' Get_Person_Record';
99: hr_utility.set_location('Entering : ' || l_proc, 5);
100: END IF;
101:
102:
103: OPEN csr_people_rec (p_person_id);

Line 110: hr_utility.set_location('Leaving : ' || l_proc, 10);

106: CLOSE csr_people_rec;
107:
108:
109: IF g_debug THEN
110: hr_utility.set_location('Leaving : ' || l_proc, 10);
111: END IF;
112:
113:
114: -- Fix 2082000 start

Line 278: hr_utility.set_message

274: END IF;
275: --
276: EXCEPTION
277: WHEN OTHERS THEN
278: hr_utility.set_message
279: ( hr_session_utilities.g_PER_application_id
280: , 'HR_52214_CM_NO_PERSON_DATA'
281: );
282: RAISE ;

Line 312: g_debug := hr_utility.debug_enabled;

308: WHERE person_id = p_person_id
309: AND trunc(p_effective_date)
310: BETWEEN trunc(effective_start_date) AND trunc(effective_end_date);
311: BEGIN
312: g_debug := hr_utility.debug_enabled;
313: IF g_debug THEN
314: l_proc := g_package || ' Get_Person_Record';
315: hr_utility.set_location('Entering : ' || l_proc, 5);
316: END IF;

Line 315: hr_utility.set_location('Entering : ' || l_proc, 5);

311: BEGIN
312: g_debug := hr_utility.debug_enabled;
313: IF g_debug THEN
314: l_proc := g_package || ' Get_Person_Record';
315: hr_utility.set_location('Entering : ' || l_proc, 5);
316: END IF;
317:
318:
319: OPEN csr_people_rec (p_person_id);

Line 325: hr_utility.set_location('Leaving : ' || l_proc, 10);

321: IF csr_people_rec%FOUND THEN
322: CLOSE csr_people_rec;
323:
324: IF g_debug THEN
325: hr_utility.set_location('Leaving : ' || l_proc, 10);
326: END IF;
327:
328: RETURN l_person_rec;
329: ELSE

Line 336: hr_utility.set_message

332: END IF;
333: --
334: EXCEPTION
335: WHEN OTHERS THEN
336: hr_utility.set_message
337: ( hr_session_utilities.g_PER_application_id
338: , 'HR_52214_CM_NO_PERSON_DATA'
339: );
340: RAISE ;

Line 363: g_debug := hr_utility.debug_enabled;

359: IS
360: --
361: l_proc VARCHAR2 (72);
362: BEGIN
363: g_debug := hr_utility.debug_enabled;
364: IF g_debug THEN
365: l_proc := g_package || ' Use_Message';
366: hr_utility.set_location('Entering : ' || l_proc, 5);
367: END IF;

Line 366: hr_utility.set_location('Entering : ' || l_proc, 5);

362: BEGIN
363: g_debug := hr_utility.debug_enabled;
364: IF g_debug THEN
365: l_proc := g_package || ' Use_Message';
366: hr_utility.set_location('Entering : ' || l_proc, 5);
367: END IF;
368:
369:
370: IF g_debug THEN

Line 371: hr_utility.set_location('Leaving : ' || l_proc, 10);

367: END IF;
368:
369:
370: IF g_debug THEN
371: hr_utility.set_location('Leaving : ' || l_proc, 10);
372: END IF;
373:
374: fnd_message.set_name (p_application_id, p_message_name);
375: RETURN fnd_message.get;

Line 393: g_debug := hr_utility.debug_enabled;

389: RETURN VARCHAR2
390: IS
391: l_proc VARCHAR2 (72);
392: BEGIN
393: g_debug := hr_utility.debug_enabled;
394: IF g_debug THEN
395: l_proc := g_package || ' IFNOTNULL';
396: hr_utility.set_location('Entering : ' || l_proc, 5);
397: END IF;

Line 396: hr_utility.set_location('Entering : ' || l_proc, 5);

392: BEGIN
393: g_debug := hr_utility.debug_enabled;
394: IF g_debug THEN
395: l_proc := g_package || ' IFNOTNULL';
396: hr_utility.set_location('Entering : ' || l_proc, 5);
397: END IF;
398:
399:
400: IF g_debug THEN

Line 401: hr_utility.set_location('Leaving : ' || l_proc, 10);

397: END IF;
398:
399:
400: IF g_debug THEN
401: hr_utility.set_location('Leaving : ' || l_proc, 10);
402: END IF;
403:
404: IF (str1 is NULL) THEN
405: RETURN (NULL);

Line 535: g_debug := hr_utility.debug_enabled;

531: --
532: --
533: l_proc VARCHAR2 (72);
534: BEGIN
535: g_debug := hr_utility.debug_enabled;
536: IF g_debug THEN
537: l_proc := g_package || ' date2char';
538: hr_utility.set_location('Entering : ' || l_proc, 5);
539: END IF;

Line 538: hr_utility.set_location('Entering : ' || l_proc, 5);

534: BEGIN
535: g_debug := hr_utility.debug_enabled;
536: IF g_debug THEN
537: l_proc := g_package || ' date2char';
538: hr_utility.set_location('Entering : ' || l_proc, 5);
539: END IF;
540:
541: --
542:

Line 544: hr_utility.set_location('Leaving : ' || l_proc, 10);

540:
541: --
542:
543: IF g_debug THEN
544: hr_utility.set_location('Leaving : ' || l_proc, 10);
545: END IF;
546:
547: RETURN to_char(trunc(p_date), p_date_format);
548: --

Line 573: g_debug := hr_utility.debug_enabled;

569: --
570: --
571: l_proc VARCHAR2 (72);
572: BEGIN
573: g_debug := hr_utility.debug_enabled;
574: IF g_debug THEN
575: l_proc := g_package || ' char2date';
576: hr_utility.set_location('Entering : ' || l_proc, 5);
577: END IF;

Line 576: hr_utility.set_location('Entering : ' || l_proc, 5);

572: BEGIN
573: g_debug := hr_utility.debug_enabled;
574: IF g_debug THEN
575: l_proc := g_package || ' char2date';
576: hr_utility.set_location('Entering : ' || l_proc, 5);
577: END IF;
578:
579:
580: IF g_debug THEN

Line 581: hr_utility.set_location('Leaving : ' || l_proc, 10);

577: END IF;
578:
579:
580: IF g_debug THEN
581: hr_utility.set_location('Leaving : ' || l_proc, 10);
582: END IF;
583:
584: RETURN
585: TRUNC

Line 611: g_debug := hr_utility.debug_enabled;

607: --
608: --
609: l_proc VARCHAR2 (72);
610: BEGIN
611: g_debug := hr_utility.debug_enabled;
612: IF g_debug THEN
613: l_proc := g_package || ' IsDateValid';
614: hr_utility.set_location('Entering : ' || l_proc, 5);
615: END IF;

Line 614: hr_utility.set_location('Entering : ' || l_proc, 5);

610: BEGIN
611: g_debug := hr_utility.debug_enabled;
612: IF g_debug THEN
613: l_proc := g_package || ' IsDateValid';
614: hr_utility.set_location('Entering : ' || l_proc, 5);
615: END IF;
616:
617: l_date := to_date (p_string, g_date_format);
618:

Line 620: hr_utility.set_location('Leaving : ' || l_proc, 10);

616:
617: l_date := to_date (p_string, g_date_format);
618:
619: IF g_debug THEN
620: hr_utility.set_location('Leaving : ' || l_proc, 10);
621: END IF;
622:
623: RETURN TRUE;
624: EXCEPTION

Line 648: hr_utility.set_location('Entering : ' || l_proc, 5);

644: BEGIN
645:
646: IF g_debug THEN
647: l_proc := g_package || ' Convert_To_Date';
648: hr_utility.set_location('Entering : ' || l_proc, 5);
649: END IF;
650:
651:
652: IF g_debug THEN

Line 653: hr_utility.set_location('Leaving : ' || l_proc, 10);

649: END IF;
650:
651:
652: IF g_debug THEN
653: hr_utility.set_location('Leaving : ' || l_proc, 10);
654: END IF;
655:
656: IF IsDateValid (p_date_string) THEN
657: RETURN

Line 683: g_debug := hr_utility.debug_enabled;

679: --
680: --
681: l_proc VARCHAR2 (72);
682: BEGIN
683: g_debug := hr_utility.debug_enabled;
684: IF g_debug THEN
685: l_proc := g_package || ' Validate_Between_Dates';
686: hr_utility.set_location('Entering : ' || l_proc, 5);
687: END IF;

Line 686: hr_utility.set_location('Entering : ' || l_proc, 5);

682: BEGIN
683: g_debug := hr_utility.debug_enabled;
684: IF g_debug THEN
685: l_proc := g_package || ' Validate_Between_Dates';
686: hr_utility.set_location('Entering : ' || l_proc, 5);
687: END IF;
688:
689:
690: IF g_debug THEN

Line 691: hr_utility.set_location('Leaving : ' || l_proc, 10);

687: END IF;
688:
689:
690: IF g_debug THEN
691: hr_utility.set_location('Leaving : ' || l_proc, 10);
692: END IF;
693:
694: IF p_date2 >= p_date1 THEN
695: RETURN TRUE;

Line 735: g_debug := hr_utility.debug_enabled;

731: WHERE table_name = p_table_name
732: AND column_name = p_column_name
733: AND owner = l_per_owner;
734: BEGIN
735: g_debug := hr_utility.debug_enabled;
736: IF g_debug THEN
737: hr_utility.set_location('Entering : ' || l_proc, 5);
738: END IF;
739:

Line 737: hr_utility.set_location('Entering : ' || l_proc, 5);

733: AND owner = l_per_owner;
734: BEGIN
735: g_debug := hr_utility.debug_enabled;
736: IF g_debug THEN
737: hr_utility.set_location('Entering : ' || l_proc, 5);
738: END IF;
739:
740:
741: OPEN csr_col_data

Line 758: hr_utility.set_location('Leaving : ' || l_proc, 10);

754: l_data.f_datatype := l_hold_data.c_datatype ;
755: --
756:
757: IF g_debug THEN
758: hr_utility.set_location('Leaving : ' || l_proc, 10);
759: END IF;
760:
761:
762: RETURN l_data;

Line 765: hr_utility.set_message

761:
762: RETURN l_data;
763: EXCEPTION
764: WHEN OTHERS THEN
765: hr_utility.set_message
766: ( hr_session_utilities.g_PER_application_id
767: , 'HR_6153_ALL_PROCEDURE_FAIL'
768: );
769: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 769: hr_utility.set_message_token('PROCEDURE', l_proc);

765: hr_utility.set_message
766: ( hr_session_utilities.g_PER_application_id
767: , 'HR_6153_ALL_PROCEDURE_FAIL'
768: );
769: hr_utility.set_message_token('PROCEDURE', l_proc);
770: hr_utility.set_message_token('STEP', sqlerrm);
771: RAISE hr_session_utilities.g_coding_error;
772: END Get_Column_Data;
773: -- ----------------------------------------------------------------------------

Line 770: hr_utility.set_message_token('STEP', sqlerrm);

766: ( hr_session_utilities.g_PER_application_id
767: , 'HR_6153_ALL_PROCEDURE_FAIL'
768: );
769: hr_utility.set_message_token('PROCEDURE', l_proc);
770: hr_utility.set_message_token('STEP', sqlerrm);
771: RAISE hr_session_utilities.g_coding_error;
772: END Get_Column_Data;
773: -- ----------------------------------------------------------------------------
774: -- |--< Get_lookup_Meaning >--------------------------------------------------|

Line 813: g_debug := hr_utility.debug_enabled;

809: AND enabled_flag = 'Y'
810: AND sysdate between NVL(start_date_active, hr_api.g_sot)
811: AND NVL(end_date_active, hr_api.g_eot);
812: BEGIN
813: g_debug := hr_utility.debug_enabled;
814: IF g_debug THEN
815: l_proc := g_package || ' Get_lookup_Meaning';
816: hr_utility.set_location('Entering : ' || l_proc, 5);
817: END IF;

Line 816: hr_utility.set_location('Entering : ' || l_proc, 5);

812: BEGIN
813: g_debug := hr_utility.debug_enabled;
814: IF g_debug THEN
815: l_proc := g_package || ' Get_lookup_Meaning';
816: hr_utility.set_location('Entering : ' || l_proc, 5);
817: END IF;
818:
819: IF p_schema = 'HR' THEN
820: OPEN csr_hr_lookup

Line 851: hr_utility.set_location('Leaving : ' || l_proc, 10);

847: END IF;
848: --
849:
850: IF g_debug THEN
851: hr_utility.set_location('Leaving : ' || l_proc, 10);
852: END IF;
853:
854: RETURN l_meaning;
855: END Get_lookup_Meaning;

Line 895: g_debug := hr_utility.debug_enabled;

891: AND NVL(end_date_active, hr_api.g_eot)
892: ORDER by meaning;
893:
894: BEGIN
895: g_debug := hr_utility.debug_enabled;
896:
897: IF g_debug THEN
898: l_proc := g_package || ' Get_lookup_values';
899: hr_utility.set_location('Entering : ' || l_proc, 5);

Line 899: hr_utility.set_location('Entering : ' || l_proc, 5);

895: g_debug := hr_utility.debug_enabled;
896:
897: IF g_debug THEN
898: l_proc := g_package || ' Get_lookup_values';
899: hr_utility.set_location('Entering : ' || l_proc, 5);
900: END IF;
901:
902: IF p_schema = 'HR' THEN
903: FOR CursorRecord

Line 934: hr_utility.set_location('Leaving : ' || l_proc, 10);

930: END IF;
931: --
932:
933: IF g_debug THEN
934: hr_utility.set_location('Leaving : ' || l_proc, 10);
935: END IF;
936:
937: RETURN l_array;
938: END Get_lookup_values;

Line 952: g_debug := hr_utility.debug_enabled;

948: l_array g_lookup_values_tab_type;
949: --
950: l_proc VARCHAR2 (72);
951: BEGIN
952: g_debug := hr_utility.debug_enabled;
953: IF g_debug THEN
954: l_proc := g_package || ' DoLookupsExist';
955: hr_utility.set_location('Entering : ' || l_proc, 5);
956: END IF;

Line 955: hr_utility.set_location('Entering : ' || l_proc, 5);

951: BEGIN
952: g_debug := hr_utility.debug_enabled;
953: IF g_debug THEN
954: l_proc := g_package || ' DoLookupsExist';
955: hr_utility.set_location('Entering : ' || l_proc, 5);
956: END IF;
957:
958: l_array :=
959: Get_Lookup_Values

Line 966: hr_utility.set_location('Leaving : ' || l_proc, 10);

962: );
963: --
964:
965: IF g_debug THEN
966: hr_utility.set_location('Leaving : ' || l_proc, 10);
967: END IF;
968:
969: RETURN l_array.count > 0;
970: --

Line 985: g_debug := hr_utility.debug_enabled;

981: IS
982: --
983: l_proc VARCHAR2 (72);
984: BEGIN
985: g_debug := hr_utility.debug_enabled;
986: IF g_debug THEN
987: l_proc := g_package || ' Force_Date_Format';
988: hr_utility.set_location('Entering : ' || l_proc, 5);
989: END IF;

Line 988: hr_utility.set_location('Entering : ' || l_proc, 5);

984: BEGIN
985: g_debug := hr_utility.debug_enabled;
986: IF g_debug THEN
987: l_proc := g_package || ' Force_Date_Format';
988: hr_utility.set_location('Entering : ' || l_proc, 5);
989: END IF;
990:
991:
992: IF g_debug THEN

Line 993: hr_utility.set_location('Leaving : ' || l_proc, 10);

989: END IF;
990:
991:
992: IF g_debug THEN
993: hr_utility.set_location('Leaving : ' || l_proc, 10);
994: END IF;
995:
996: IF IsDateValid
997: ( p_string => p_char_date

Line 1028: g_debug := hr_utility.debug_enabled;

1024: l_lang_type VARCHAR2 (20) := 'javascript';
1025: --
1026: l_proc VARCHAR2 (72);
1027: BEGIN
1028: g_debug := hr_utility.debug_enabled;
1029: IF g_debug THEN
1030: l_proc := g_package || ' ScriptOpen';
1031: hr_utility.set_location('Entering : ' || l_proc, 5);
1032: END IF;

Line 1031: hr_utility.set_location('Entering : ' || l_proc, 5);

1027: BEGIN
1028: g_debug := hr_utility.debug_enabled;
1029: IF g_debug THEN
1030: l_proc := g_package || ' ScriptOpen';
1031: hr_utility.set_location('Entering : ' || l_proc, 5);
1032: END IF;
1033:
1034: IF p_js_library IS NOT NULL THEN
1035: l_attributes :=

Line 1053: hr_utility.set_location('Leaving : ' || l_proc, 10);

1049: --exception not necessary
1050: --
1051:
1052: IF g_debug THEN
1053: hr_utility.set_location('Leaving : ' || l_proc, 10);
1054: END IF;
1055:
1056: END ScriptOpen;
1057: -- ----------------------------------------------------------------------------

Line 1065: g_debug := hr_utility.debug_enabled;

1061: IS
1062: --
1063: l_proc VARCHAR2 (72);
1064: BEGIN
1065: g_debug := hr_utility.debug_enabled;
1066: IF g_debug THEN
1067: l_proc := g_package || ' ScriptClose';
1068: hr_utility.set_location('Entering : ' || l_proc, 5);
1069: END IF;

Line 1068: hr_utility.set_location('Entering : ' || l_proc, 5);

1064: BEGIN
1065: g_debug := hr_utility.debug_enabled;
1066: IF g_debug THEN
1067: l_proc := g_package || ' ScriptClose';
1068: hr_utility.set_location('Entering : ' || l_proc, 5);
1069: END IF;
1070:
1071: htp.p ('');
1072: htp.p ('');

Line 1078: hr_utility.set_location('Leaving : ' || l_proc, 10);

1074: --exception not necessary
1075: --
1076:
1077: IF g_debug THEN
1078: hr_utility.set_location('Leaving : ' || l_proc, 10);
1079: END IF;
1080:
1081: END ScriptClose;
1082: -- ----------------------------------------------------------------------------

Line 1140: g_debug := hr_utility.debug_enabled;

1136: IS
1137: --
1138: l_proc VARCHAR2 (72);
1139: BEGIN
1140: g_debug := hr_utility.debug_enabled;
1141: IF g_debug THEN
1142: l_proc := g_package || ' Find_Item_In_String';
1143: hr_utility.set_location('Entering : ' || l_proc, 5);
1144: END IF;

Line 1143: hr_utility.set_location('Entering : ' || l_proc, 5);

1139: BEGIN
1140: g_debug := hr_utility.debug_enabled;
1141: IF g_debug THEN
1142: l_proc := g_package || ' Find_Item_In_String';
1143: hr_utility.set_location('Entering : ' || l_proc, 5);
1144: END IF;
1145:
1146:
1147: IF g_debug THEN

Line 1148: hr_utility.set_location('Leaving : ' || l_proc, 10);

1144: END IF;
1145:
1146:
1147: IF g_debug THEN
1148: hr_utility.set_location('Leaving : ' || l_proc, 10);
1149: END IF;
1150:
1151: RETURN
1152: INSTR

Line 1250: g_debug := hr_utility.debug_enabled;

1246: l_chk_string VARCHAR2 (200);
1247: l_string_length NUMBER := LENGTH(p_string);
1248: l_proc VARCHAR2 (72);
1249: BEGIN
1250: g_debug := hr_utility.debug_enabled;
1251: IF g_debug THEN
1252: l_proc := g_package || ' Trim_Separator';
1253: hr_utility.set_location('Entering : ' || l_proc, 5);
1254: END IF;

Line 1253: hr_utility.set_location('Entering : ' || l_proc, 5);

1249: BEGIN
1250: g_debug := hr_utility.debug_enabled;
1251: IF g_debug THEN
1252: l_proc := g_package || ' Trim_Separator';
1253: hr_utility.set_location('Entering : ' || l_proc, 5);
1254: END IF;
1255:
1256: --
1257: IF p_string IS NOT NULL THEN

Line 1299: hr_utility.set_location('Leaving : ' || l_proc, 10);

1295: END IF;
1296: --
1297:
1298: IF g_debug THEN
1299: hr_utility.set_location('Leaving : ' || l_proc, 10);
1300: END IF;
1301:
1302: RETURN l_returnval;
1303: END Trim_Separator;

Line 1321: g_debug := hr_utility.debug_enabled;

1317: l_offset NUMBER := 3; -- i.e. the number of fields before the list
1318: -- of parameter / values
1319: l_proc VARCHAR2 (72);
1320: BEGIN
1321: g_debug := hr_utility.debug_enabled;
1322: IF g_debug THEN
1323: l_proc := g_package || ' BPFD';
1324: hr_utility.set_location('Entering : ' || l_proc, 5);
1325: END IF;

Line 1324: hr_utility.set_location('Entering : ' || l_proc, 5);

1320: BEGIN
1321: g_debug := hr_utility.debug_enabled;
1322: IF g_debug THEN
1323: l_proc := g_package || ' BPFD';
1324: hr_utility.set_location('Entering : ' || l_proc, 5);
1325: END IF;
1326:
1327: l_package :=
1328: hr_general_utilities.Find_Item_In_String

Line 1428: hr_utility.set_location('Leaving : ' || l_proc, 10);

1424: --
1425: l_sql_string := l_sql_string || ')';
1426:
1427: IF g_debug THEN
1428: hr_utility.set_location('Leaving : ' || l_proc, 10);
1429: END IF;
1430:
1431: RETURN l_sql_string;
1432: EXCEPTION

Line 1470: g_debug := hr_utility.debug_enabled;

1466: l_empty_values_tab hr_general_utilities.g_vc32k_tab_type;
1467: l_use_bind_values boolean default null;
1468: --
1469: BEGIN
1470: g_debug := hr_utility.debug_enabled;
1471: IF g_debug THEN
1472: hr_utility.set_location('Entering : ' || l_proc, 5);
1473: END IF;
1474:

Line 1472: hr_utility.set_location('Entering : ' || l_proc, 5);

1468: --
1469: BEGIN
1470: g_debug := hr_utility.debug_enabled;
1471: IF g_debug THEN
1472: hr_utility.set_location('Entering : ' || l_proc, 5);
1473: END IF;
1474:
1475: l_package :=
1476: hr_general_utilities.Find_Item_In_String

Line 1697: hr_utility.set_message

1693:
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: p_bind_values_tab := l_empty_values_tab;
1697: hr_utility.set_message
1698: ( hr_session_utilities.g_PER_application_id
1699: , 'HR_6153_ALL_PROCEDURE_FAIL'
1700: );
1701: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 1701: hr_utility.set_message_token('PROCEDURE', l_proc);

1697: hr_utility.set_message
1698: ( hr_session_utilities.g_PER_application_id
1699: , 'HR_6153_ALL_PROCEDURE_FAIL'
1700: );
1701: hr_utility.set_message_token('PROCEDURE', l_proc);
1702: hr_utility.set_message_token('STEP', sqlerrm);
1703: RAISE hr_session_utilities.g_coding_error;
1704:
1705: END BPFD;

Line 1702: hr_utility.set_message_token('STEP', sqlerrm);

1698: ( hr_session_utilities.g_PER_application_id
1699: , 'HR_6153_ALL_PROCEDURE_FAIL'
1700: );
1701: hr_utility.set_message_token('PROCEDURE', l_proc);
1702: hr_utility.set_message_token('STEP', sqlerrm);
1703: RAISE hr_session_utilities.g_coding_error;
1704:
1705: END BPFD;
1706: --

Line 1717: g_debug := hr_utility.debug_enabled;

1713: c_prompts icx_util.g_prompts_table;
1714: c_title VARCHAR2 (200);
1715: l_proc VARCHAR2 (72);
1716: BEGIN
1717: g_debug := hr_utility.debug_enabled;
1718: IF g_debug THEN
1719: l_proc := g_package || ' Get_Date_Hint';
1720: hr_utility.set_location('Entering : ' || l_proc, 5);
1721: END IF;

Line 1720: hr_utility.set_location('Entering : ' || l_proc, 5);

1716: BEGIN
1717: g_debug := hr_utility.debug_enabled;
1718: IF g_debug THEN
1719: l_proc := g_package || ' Get_Date_Hint';
1720: hr_utility.set_location('Entering : ' || l_proc, 5);
1721: END IF;
1722:
1723: -- Bug #1200894 fix
1724: icx_util.getPrompts(601,'HR_PERSONAL_INFORMATION',c_title,c_prompts);

Line 1727: hr_utility.set_location('Leaving : ' || l_proc, 10);

1723: -- Bug #1200894 fix
1724: icx_util.getPrompts(601,'HR_PERSONAL_INFORMATION',c_title,c_prompts);
1725:
1726: IF g_debug THEN
1727: hr_utility.set_location('Leaving : ' || l_proc, 10);
1728: END IF;
1729:
1730: RETURN
1731: '('

Line 1762: g_debug := hr_utility.debug_enabled;

1758: l_string VARCHAR2 (2000);
1759: l_code VARCHAR2 (2000);
1760: l_proc VARCHAR2 (72);
1761: BEGIN
1762: g_debug := hr_utility.debug_enabled;
1763: IF g_debug THEN
1764: l_proc := g_package || ' EPFS';
1765: hr_utility.set_location('Entering : ' || l_proc, 5);
1766: END IF;

Line 1765: hr_utility.set_location('Entering : ' || l_proc, 5);

1761: BEGIN
1762: g_debug := hr_utility.debug_enabled;
1763: IF g_debug THEN
1764: l_proc := g_package || ' EPFS';
1765: hr_utility.set_location('Entering : ' || l_proc, 5);
1766: END IF;
1767:
1768: --
1769: -- this breaks a long string up to 32k into l_max_length bits

Line 1850: hr_utility.set_location('Leaving : ' || l_proc, 10);

1846: --
1847: -- return this value
1848:
1849: IF g_debug THEN
1850: hr_utility.set_location('Leaving : ' || l_proc, 10);
1851: END IF;
1852:
1853: RETURN l_tmp_id;
1854: EXCEPTION

Line 1867: g_debug := hr_utility.debug_enabled;

1863: )
1864: IS
1865: l_proc VARCHAR2 (72) := g_package || ' ASEI';
1866: BEGIN
1867: g_debug := hr_utility.debug_enabled;
1868: IF g_debug THEN
1869: l_proc := g_package || ' ASEI';
1870: hr_utility.set_location('Entering : ' || l_proc, 5);
1871: END IF;

Line 1870: hr_utility.set_location('Entering : ' || l_proc, 5);

1866: BEGIN
1867: g_debug := hr_utility.debug_enabled;
1868: IF g_debug THEN
1869: l_proc := g_package || ' ASEI';
1870: hr_utility.set_location('Entering : ' || l_proc, 5);
1871: END IF;
1872:
1873:
1874: IF g_debug THEN

Line 1875: hr_utility.set_location('Leaving : ' || l_proc, 10);

1871: END IF;
1872:
1873:
1874: IF g_debug THEN
1875: hr_utility.set_location('Leaving : ' || l_proc, 10);
1876: END IF;
1877:
1878: g_execute_handles (g_execute_handles.count + 1) := p_text_id;
1879: END ASEI;

Line 1889: g_debug := hr_utility.debug_enabled;

1885: IS
1886: l_string VARCHAR2 (2000);
1887: l_proc VARCHAR2 (72) := g_package || ' CCEI';
1888: BEGIN
1889: g_debug := hr_utility.debug_enabled;
1890: IF g_debug THEN
1891: hr_utility.set_location('Entering : ' || l_proc, 5);
1892: END IF;
1893:

Line 1891: hr_utility.set_location('Entering : ' || l_proc, 5);

1887: l_proc VARCHAR2 (72) := g_package || ' CCEI';
1888: BEGIN
1889: g_debug := hr_utility.debug_enabled;
1890: IF g_debug THEN
1891: hr_utility.set_location('Entering : ' || l_proc, 5);
1892: END IF;
1893:
1894: IF g_execute_handles.count > 0 THEN
1895: l_string :=

Line 1920: hr_utility.set_location('Leaving : ' || l_proc, 10);

1916: END IF;
1917: --
1918:
1919: IF g_debug THEN
1920: hr_utility.set_location('Leaving : ' || l_proc, 10);
1921: END IF;
1922:
1923: RETURN
1924: icx_call.encrypt2

Line 1934: hr_utility.set_message

1930: -- vc2 length may exceed 2000;
1931: -- this must be a coding error
1932: -- mechanism not really suitable for executing so many sql statements
1933: --
1934: hr_utility.set_message
1935: ( hr_session_utilities.g_PER_application_id
1936: , 'HR_6153_ALL_PROCEDURE_FAIL'
1937: );
1938: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 1938: hr_utility.set_message_token('PROCEDURE', l_proc);

1934: hr_utility.set_message
1935: ( hr_session_utilities.g_PER_application_id
1936: , 'HR_6153_ALL_PROCEDURE_FAIL'
1937: );
1938: hr_utility.set_message_token('PROCEDURE', l_proc);
1939: hr_utility.set_message_token('STEP', sqlerrm);
1940: RAISE hr_session_utilities.g_coding_error;
1941: END CCEI;
1942: -- ----------------------------------------------------------------------------

Line 1939: hr_utility.set_message_token('STEP', sqlerrm);

1935: ( hr_session_utilities.g_PER_application_id
1936: , 'HR_6153_ALL_PROCEDURE_FAIL'
1937: );
1938: hr_utility.set_message_token('PROCEDURE', l_proc);
1939: hr_utility.set_message_token('STEP', sqlerrm);
1940: RAISE hr_session_utilities.g_coding_error;
1941: END CCEI;
1942: -- ----------------------------------------------------------------------------
1943: -- |--< EXPD >----------------------------------------------------------------|

Line 1957: g_debug := hr_utility.debug_enabled;

1953: l_offset NUMBER := 2;
1954: l_string VARCHAR2 (32000);
1955: l_proc VARCHAR2 (72);
1956: BEGIN
1957: g_debug := hr_utility.debug_enabled;
1958: IF g_debug THEN
1959: l_proc := g_package || ' EXPD';
1960: hr_utility.set_location('Entering : ' || l_proc, 5);
1961: END IF;

Line 1960: hr_utility.set_location('Entering : ' || l_proc, 5);

1956: BEGIN
1957: g_debug := hr_utility.debug_enabled;
1958: IF g_debug THEN
1959: l_proc := g_package || ' EXPD';
1960: hr_utility.set_location('Entering : ' || l_proc, 5);
1961: END IF;
1962:
1963:
1964: IF p_string IS NULL THEN

Line 1996: hr_utility.set_location('Leaving : ' || l_proc, 10);

1992: END LOOP;
1993: --
1994:
1995: IF g_debug THEN
1996: hr_utility.set_location('Leaving : ' || l_proc, 10);
1997: END IF;
1998:
1999: RETURN l_string;
2000: END EXPD;

Line 2020: g_debug := hr_utility.debug_enabled;

2016: l_bind_values_list varchar2(32000) default null;
2017: l_use_bind_values boolean default null;
2018:
2019: BEGIN
2020: g_debug := hr_utility.debug_enabled;
2021: IF g_debug THEN
2022: hr_utility.set_location('Entering : ' || l_proc, 5);
2023: END IF;
2024:

Line 2022: hr_utility.set_location('Entering : ' || l_proc, 5);

2018:
2019: BEGIN
2020: g_debug := hr_utility.debug_enabled;
2021: IF g_debug THEN
2022: hr_utility.set_location('Entering : ' || l_proc, 5);
2023: END IF;
2024:
2025: --hrhtml2.debug('entered dex;');
2026: --

Line 2041: hr_utility.set_message

2037: --
2038: -- decrypt2 returns -1 if the session is invalid
2039: --
2040: IF l_index_string = '-1' THEN
2041: hr_utility.set_message
2042: ( hr_session_utilities.g_PER_application_id
2043: , 'PER_DEXL_SESSION_FAIL'
2044: );
2045: RAISE g_fatal_error;

Line 2279: hr_utility.set_location('Leaving : ' || l_proc, 10);

2275: -- use dbms_sql package by calling Execute_Dynamic_SQL procedure.
2276: -- From old code which uses literal SQL statement
2277:
2278: IF g_debug THEN
2279: hr_utility.set_location('Leaving : ' || l_proc, 10);
2280: END IF;
2281:
2282: Execute_Dynamic_SQL
2283: ( p_sql_string => l_sql_string

Line 2291: hr_utility.set_message

2287: END IF; -- end of l_item1 = 'S'
2288: end if;
2289: EXCEPTION
2290: WHEN g_fatal_error THEN
2291: hr_utility.set_message
2292: ( hr_session_utilities.g_PER_application_id
2293: , 'HR_6153_ALL_PROCEDURE_FAIL'
2294: );
2295: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 2295: hr_utility.set_message_token('PROCEDURE', l_proc);

2291: hr_utility.set_message
2292: ( hr_session_utilities.g_PER_application_id
2293: , 'HR_6153_ALL_PROCEDURE_FAIL'
2294: );
2295: hr_utility.set_message_token('PROCEDURE', l_proc);
2296: hr_utility.set_message_token('STEP', sqlerrm);
2297: htp.p (fnd_message.get);
2298: --
2299: -- do not re-raise otherwise fails; nowhere to raise to (may be calling itself)

Line 2296: hr_utility.set_message_token('STEP', sqlerrm);

2292: ( hr_session_utilities.g_PER_application_id
2293: , 'HR_6153_ALL_PROCEDURE_FAIL'
2294: );
2295: hr_utility.set_message_token('PROCEDURE', l_proc);
2296: hr_utility.set_message_token('STEP', sqlerrm);
2297: htp.p (fnd_message.get);
2298: --
2299: -- do not re-raise otherwise fails; nowhere to raise to (may be calling itself)
2300: --

Line 2305: hr_utility.set_message

2301: WHEN OTHERS THEN
2302: --
2303: -- an error trying to decode the string
2304: --
2305: hr_utility.set_message
2306: ( hr_session_utilities.g_PER_application_id
2307: , 'HR_6153_ALL_PROCEDURE_FAIL'
2308: );
2309: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 2309: hr_utility.set_message_token('PROCEDURE', l_proc);

2305: hr_utility.set_message
2306: ( hr_session_utilities.g_PER_application_id
2307: , 'HR_6153_ALL_PROCEDURE_FAIL'
2308: );
2309: hr_utility.set_message_token('PROCEDURE', l_proc);
2310: hr_utility.set_message_token('STEP', sqlerrm);
2311: RAISE hr_session_utilities.g_coding_error;
2312: END DexL;
2313: -- ----------------------------------------------------------------------------

Line 2310: hr_utility.set_message_token('STEP', sqlerrm);

2306: ( hr_session_utilities.g_PER_application_id
2307: , 'HR_6153_ALL_PROCEDURE_FAIL'
2308: );
2309: hr_utility.set_message_token('PROCEDURE', l_proc);
2310: hr_utility.set_message_token('STEP', sqlerrm);
2311: RAISE hr_session_utilities.g_coding_error;
2312: END DexL;
2313: -- ----------------------------------------------------------------------------
2314: -- |--< SDER >----------------------------------------------------------------|

Line 2321: g_debug := hr_utility.debug_enabled;

2317: RETURN VARCHAR2
2318: IS
2319: l_proc VARCHAR2 (72);
2320: BEGIN
2321: g_debug := hr_utility.debug_enabled;
2322: IF g_debug THEN
2323: l_proc := g_package || ' SDER';
2324: hr_utility.set_location('Entering : ' || l_proc, 5);
2325: END IF;

Line 2324: hr_utility.set_location('Entering : ' || l_proc, 5);

2320: BEGIN
2321: g_debug := hr_utility.debug_enabled;
2322: IF g_debug THEN
2323: l_proc := g_package || ' SDER';
2324: hr_utility.set_location('Entering : ' || l_proc, 5);
2325: END IF;
2326:
2327:
2328: IF g_debug THEN

Line 2329: hr_utility.set_location('Leaving : ' || l_proc, 10);

2325: END IF;
2326:
2327:
2328: IF g_debug THEN
2329: hr_utility.set_location('Leaving : ' || l_proc, 10);
2330: END IF;
2331:
2332: RETURN 'hr_general_utilities.DEXL?i=';
2333: END SDER;

Line 2345: g_debug := hr_utility.debug_enabled;

2341: IS
2342: l_string VARCHAR2 (32000);
2343: l_proc VARCHAR2 (72);
2344: BEGIN
2345: g_debug := hr_utility.debug_enabled;
2346: IF g_debug THEN
2347: l_proc := g_package || ' REGS';
2348: hr_utility.set_location('Entering : ' || l_proc, 5);
2349: END IF;

Line 2348: hr_utility.set_location('Entering : ' || l_proc, 5);

2344: BEGIN
2345: g_debug := hr_utility.debug_enabled;
2346: IF g_debug THEN
2347: l_proc := g_package || ' REGS';
2348: hr_utility.set_location('Entering : ' || l_proc, 5);
2349: END IF;
2350:
2351: IF g_string_cache.exists (p_index) THEN
2352: l_string := g_string_cache(p_index);

Line 2359: hr_utility.set_location('Leaving : ' || l_proc, 10);

2355: END IF;
2356: --
2357:
2358: IF g_debug THEN
2359: hr_utility.set_location('Leaving : ' || l_proc, 10);
2360: END IF;
2361:
2362: RETURN l_string;
2363: END REGS;

Line 2372: g_debug := hr_utility.debug_enabled;

2368: IS
2369: l_reset g_vc32k_tab_type;
2370: l_proc VARCHAR2 (72);
2371: BEGIN
2372: g_debug := hr_utility.debug_enabled;
2373: IF g_debug THEN
2374: l_proc := g_package || ' Reset_G_Cache';
2375: hr_utility.set_location('Entering : ' || l_proc, 5);
2376: END IF;

Line 2375: hr_utility.set_location('Entering : ' || l_proc, 5);

2371: BEGIN
2372: g_debug := hr_utility.debug_enabled;
2373: IF g_debug THEN
2374: l_proc := g_package || ' Reset_G_Cache';
2375: hr_utility.set_location('Entering : ' || l_proc, 5);
2376: END IF;
2377:
2378:
2379: IF g_debug THEN

Line 2380: hr_utility.set_location('Leaving : ' || l_proc, 10);

2376: END IF;
2377:
2378:
2379: IF g_debug THEN
2380: hr_utility.set_location('Leaving : ' || l_proc, 10);
2381: END IF;
2382:
2383: g_string_cache := l_reset;
2384:

Line 2408: g_debug := hr_utility.debug_enabled;

2404: l_search_in VARCHAR2 (32000);
2405: l_search_for VARCHAR2 (32000);
2406: l_proc VARCHAR2 (72);
2407: BEGIN
2408: g_debug := hr_utility.debug_enabled;
2409: IF g_debug THEN
2410: l_proc := g_package || ' Locate_Text';
2411: hr_utility.set_location('Entering : ' || l_proc, 5);
2412: END IF;

Line 2411: hr_utility.set_location('Entering : ' || l_proc, 5);

2407: BEGIN
2408: g_debug := hr_utility.debug_enabled;
2409: IF g_debug THEN
2410: l_proc := g_package || ' Locate_Text';
2411: hr_utility.set_location('Entering : ' || l_proc, 5);
2412: END IF;
2413:
2414: IF p_second_instance THEN
2415: l_instance := 2;

Line 2454: hr_utility.set_location('Leaving : ' || l_proc, 10);

2450: END IF;
2451: --
2452:
2453: IF g_debug THEN
2454: hr_utility.set_location('Leaving : ' || l_proc, 10);
2455: END IF;
2456:
2457: RETURN l_returnval;
2458: END Locate_Text;

Line 2476: g_debug := hr_utility.debug_enabled;

2472: l_counter NUMBER := 1;
2473: l_returnval NUMBER := 0;
2474: l_proc VARCHAR2 (72);
2475: BEGIN
2476: g_debug := hr_utility.debug_enabled;
2477: IF g_debug THEN
2478: l_proc := g_package || ' Count_Instances';
2479: hr_utility.set_location('Entering : ' || l_proc, 5);
2480: END IF;

Line 2479: hr_utility.set_location('Entering : ' || l_proc, 5);

2475: BEGIN
2476: g_debug := hr_utility.debug_enabled;
2477: IF g_debug THEN
2478: l_proc := g_package || ' Count_Instances';
2479: hr_utility.set_location('Entering : ' || l_proc, 5);
2480: END IF;
2481:
2482: IF p_ignore_case THEN
2483: l_search_in := UPPER ( p_search_in);

Line 2507: hr_utility.set_location('Leaving : ' || l_proc, 10);

2503: l_returnval := l_counter -1;
2504: --
2505:
2506: IF g_debug THEN
2507: hr_utility.set_location('Leaving : ' || l_proc, 10);
2508: END IF;
2509:
2510: RETURN l_returnval;
2511: END Count_Instances;

Line 2523: g_debug := hr_utility.debug_enabled;

2519: l_cursor_handle NUMBER;
2520: l_exec NUMBER;
2521: l_proc VARCHAR2 (72) := g_package || ' Execute_Dynamic_SQL';
2522: BEGIN
2523: g_debug := hr_utility.debug_enabled;
2524: IF g_debug THEN
2525: hr_utility.set_location('Entering : ' || l_proc, 5);
2526: END IF;
2527:

Line 2525: hr_utility.set_location('Entering : ' || l_proc, 5);

2521: l_proc VARCHAR2 (72) := g_package || ' Execute_Dynamic_SQL';
2522: BEGIN
2523: g_debug := hr_utility.debug_enabled;
2524: IF g_debug THEN
2525: hr_utility.set_location('Entering : ' || l_proc, 5);
2526: END IF;
2527:
2528: l_cursor_handle := dbms_sql.open_cursor;
2529: dbms_sql.parse

Line 2538: hr_utility.set_location('Leaving : ' || l_proc, 10);

2534: l_exec := dbms_sql.execute (l_cursor_handle);
2535: dbms_sql.close_cursor(l_cursor_handle);
2536:
2537: IF g_debug THEN
2538: hr_utility.set_location('Leaving : ' || l_proc, 10);
2539: END IF;
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN

Line 2543: hr_utility.set_message

2539: END IF;
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: hr_utility.set_message
2544: ( hr_session_utilities.g_PER_application_id
2545: , 'HR_6153_ALL_PROCEDURE_FAIL'
2546: );
2547: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 2547: hr_utility.set_message_token('PROCEDURE', l_proc);

2543: hr_utility.set_message
2544: ( hr_session_utilities.g_PER_application_id
2545: , 'HR_6153_ALL_PROCEDURE_FAIL'
2546: );
2547: hr_utility.set_message_token('PROCEDURE', l_proc);
2548: hr_utility.set_message_token('STEP', sqlerrm);
2549: RAISE hr_session_utilities.g_coding_error;
2550: END Execute_Dynamic_SQL;
2551: -- ----------------------------------------------------------------------------

Line 2548: hr_utility.set_message_token('STEP', sqlerrm);

2544: ( hr_session_utilities.g_PER_application_id
2545: , 'HR_6153_ALL_PROCEDURE_FAIL'
2546: );
2547: hr_utility.set_message_token('PROCEDURE', l_proc);
2548: hr_utility.set_message_token('STEP', sqlerrm);
2549: RAISE hr_session_utilities.g_coding_error;
2550: END Execute_Dynamic_SQL;
2551: -- ----------------------------------------------------------------------------
2552: -- |--< Set_Message_Txt_And_Number >------------------------------------------|

Line 2566: g_debug := hr_utility.debug_enabled;

2562: l_short_name VARCHAR2 (2000);
2563: l_msg_name VARCHAR2 (2000);
2564: l_proc VARCHAR2 (72) := g_package || ' Get_Print_Action';
2565: BEGIN
2566: g_debug := hr_utility.debug_enabled;
2567: IF g_debug THEN
2568: hr_utility.set_location('Entering : ' || l_proc, 5);
2569: END IF;
2570:

Line 2568: hr_utility.set_location('Entering : ' || l_proc, 5);

2564: l_proc VARCHAR2 (72) := g_package || ' Get_Print_Action';
2565: BEGIN
2566: g_debug := hr_utility.debug_enabled;
2567: IF g_debug THEN
2568: hr_utility.set_location('Entering : ' || l_proc, 5);
2569: END IF;
2570:
2571:
2572: IF g_debug THEN

Line 2573: hr_utility.set_location('Leaving : ' || l_proc, 10);

2569: END IF;
2570:
2571:
2572: IF g_debug THEN
2573: hr_utility.set_location('Leaving : ' || l_proc, 10);
2574: END IF;
2575:
2576: IF p_message_name IS NOT NULL THEN
2577: fnd_message.set_name

Line 2603: hr_utility.set_message

2599: );
2600: RETURN l_record;
2601: EXCEPTION
2602: WHEN OTHERS THEN
2603: hr_utility.set_message
2604: ( hr_session_utilities.g_PER_application_id
2605: , 'HR_6153_ALL_PROCEDURE_FAIL'
2606: );
2607: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 2607: hr_utility.set_message_token('PROCEDURE', l_proc);

2603: hr_utility.set_message
2604: ( hr_session_utilities.g_PER_application_id
2605: , 'HR_6153_ALL_PROCEDURE_FAIL'
2606: );
2607: hr_utility.set_message_token('PROCEDURE', l_proc);
2608: hr_utility.set_message_token('STEP', sqlerrm);
2609: RAISE hr_session_utilities.g_coding_error;
2610: END Set_Message_Txt_And_Number;
2611: -- ----------------------------------------------------------------------------

Line 2608: hr_utility.set_message_token('STEP', sqlerrm);

2604: ( hr_session_utilities.g_PER_application_id
2605: , 'HR_6153_ALL_PROCEDURE_FAIL'
2606: );
2607: hr_utility.set_message_token('PROCEDURE', l_proc);
2608: hr_utility.set_message_token('STEP', sqlerrm);
2609: RAISE hr_session_utilities.g_coding_error;
2610: END Set_Message_Txt_And_Number;
2611: -- ----------------------------------------------------------------------------
2612: -- |--< Set_Workflow_Section_Attribute >--------------------------------------|

Line 2625: g_debug := hr_utility.debug_enabled;

2621: IS
2622: l_string VARCHAR2 (2000);
2623: l_proc VARCHAR2 (72);
2624: BEGIN
2625: g_debug := hr_utility.debug_enabled;
2626: IF g_debug THEN
2627: l_proc := g_package || ' Set_Workflow_Section_Attribute';
2628: hr_utility.set_location('Entering : ' || l_proc, 5);
2629: END IF;

Line 2628: hr_utility.set_location('Entering : ' || l_proc, 5);

2624: BEGIN
2625: g_debug := hr_utility.debug_enabled;
2626: IF g_debug THEN
2627: l_proc := g_package || ' Set_Workflow_Section_Attribute';
2628: hr_utility.set_location('Entering : ' || l_proc, 5);
2629: END IF;
2630:
2631: IF hr_workflow_service.check_web_page_code
2632: ( p_item_type => p_item_type

Line 2650: hr_utility.set_location('Entering : ' || l_proc, 5);

2646: NULL;
2647: END IF;
2648:
2649: IF g_debug THEN
2650: hr_utility.set_location('Entering : ' || l_proc, 5);
2651: END IF;
2652:
2653: RETURN
2654: l_string;