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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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