DBA Data[Home] [Help]

APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on HR_UTILITY

Line 45: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn

41: BEGIN
42: --
43: IF g_debug THEN
44: IF pqp_utilities.g_nested_level = 0 THEN
45: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
46: END IF;
47: pqp_utilities.debug_enter (
48: p_proc_name => p_proc_name
49: ,p_trace_on => p_trace_on

Line 74: hr_utility.trace_off;

70: ,p_trace_off => p_trace_off
71: );
72:
73: IF pqp_utilities.g_nested_level = 0 THEN
74: hr_utility.trace_off;
75: END IF;
76: END IF;
77: --
78: END debug_exit;

Line 145: IF SQLCODE <> hr_utility.hr_error_number

141: debug_exit(l_proc_name);
142: END IF;
143: EXCEPTION
144: WHEN others THEN
145: IF SQLCODE <> hr_utility.hr_error_number
146: THEN
147: debug_others (l_proc_name, l_proc_step);
148: IF g_debug
149: THEN

Line 213: IF SQLCODE <> hr_utility.hr_error_number

209: debug_exit(l_proc_name);
210:
211: EXCEPTION
212: WHEN others THEN
213: IF SQLCODE <> hr_utility.hr_error_number
214: THEN
215: debug_others (l_proc_name, 10);
216: IF g_debug
217: THEN

Line 277: IF SQLCODE <> hr_utility.hr_error_number

273:
274: debug_exit(l_proc_name);
275: EXCEPTION
276: WHEN others THEN
277: IF SQLCODE <> hr_utility.hr_error_number
278: THEN
279: debug_others (l_proc_name, 10);
280: IF g_debug
281: THEN

Line 452: IF SQLCODE <> hr_utility.hr_error_number

448: debug_exit(l_proc_name);
449: RETURN l_include;
450: EXCEPTION
451: WHEN others THEN
452: IF SQLCODE <> hr_utility.hr_error_number
453: THEN
454: debug_others (l_proc_name, 10);
455: IF g_debug
456: THEN

Line 586: IF SQLCODE <> hr_utility.hr_error_number

582: RETURN l_return_flag;
583:
584: EXCEPTION
585: WHEN others THEN
586: IF SQLCODE <> hr_utility.hr_error_number
587: THEN
588: debug_others ('is_next_allow_code_same', 10);
589: IF g_debug
590: THEN

Line 877: IF SQLCODE <> hr_utility.hr_error_number

873: RETURN l_return;
874:
875: EXCEPTION
876: WHEN others THEN
877: IF SQLCODE <> hr_utility.hr_error_number
878: THEN
879: debug_others (l_proc_name, 10);
880: IF g_debug
881: THEN

Line 931: IF SQLCODE <> hr_utility.hr_error_number

927: debug_exit(l_proc_name);
928: return 0;
929: EXCEPTION
930: WHEN others THEN
931: IF SQLCODE <> hr_utility.hr_error_number
932: THEN
933: debug_others (l_proc_name, 10);
934: IF g_debug
935: THEN

Line 997: IF SQLCODE <> hr_utility.hr_error_number

993: debug_exit(l_proc_name);
994: return 0;
995: EXCEPTION
996: WHEN others THEN
997: IF SQLCODE <> hr_utility.hr_error_number
998: THEN
999: debug_others (l_proc_name, 10);
1000: IF g_debug
1001: THEN

Line 1038: IF SQLCODE <> hr_utility.hr_error_number

1034: debug_exit(l_proc_name);
1035: return 0;
1036: EXCEPTION
1037: WHEN others THEN
1038: IF SQLCODE <> hr_utility.hr_error_number
1039: THEN
1040: debug_others (l_proc_name, 10);
1041: IF g_debug
1042: THEN

Line 1110: IF SQLCODE <> hr_utility.hr_error_number

1106: debug_exit(l_proc_name);
1107: return 0;
1108: EXCEPTION
1109: WHEN others THEN
1110: IF SQLCODE <> hr_utility.hr_error_number
1111: THEN
1112: debug_others (l_proc_name, 10);
1113: IF g_debug
1114: THEN

Line 1165: IF SQLCODE <> hr_utility.hr_error_number

1161: debug_exit(l_proc_name);
1162: return 0;
1163: EXCEPTION
1164: WHEN others THEN
1165: IF SQLCODE <> hr_utility.hr_error_number
1166: THEN
1167: debug_others (l_proc_name, 10);
1168: IF g_debug
1169: THEN

Line 1258: IF SQLCODE <> hr_utility.hr_error_number

1254: debug_exit(l_proc_name);
1255: return 0;
1256: EXCEPTION
1257: WHEN others THEN
1258: IF SQLCODE <> hr_utility.hr_error_number
1259: THEN
1260: debug_others (l_proc_name, 10);
1261: IF g_debug
1262: THEN

Line 1325: IF SQLCODE <> hr_utility.hr_error_number

1321: debug_exit(l_proc_name);
1322: return 0;
1323: EXCEPTION
1324: WHEN others THEN
1325: IF SQLCODE <> hr_utility.hr_error_number
1326: THEN
1327: debug_others (l_proc_name, 10);
1328: IF g_debug
1329: THEN

Line 1517: IF SQLCODE <> hr_utility.hr_error_number

1513:
1514:
1515: EXCEPTION
1516: WHEN others THEN
1517: IF SQLCODE <> hr_utility.hr_error_number
1518: THEN
1519: debug_others (l_proc_name, 10);
1520: IF g_debug
1521: THEN

Line 1554: IF SQLCODE <> hr_utility.hr_error_number

1550: RETURN 'Y';
1551:
1552: EXCEPTION
1553: WHEN others THEN
1554: IF SQLCODE <> hr_utility.hr_error_number
1555: THEN
1556: debug_others (l_proc_name, 10);
1557: IF g_debug
1558: THEN