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
728: RETURN l_return;
729:
730: EXCEPTION
731: WHEN others THEN
732: IF SQLCODE <> hr_utility.hr_error_number
733: THEN
734: debug_others (l_proc_name, 10);
735: IF g_debug
736: THEN
782: debug_exit(l_proc_name);
783: return 0;
784: EXCEPTION
785: WHEN others THEN
786: IF SQLCODE <> hr_utility.hr_error_number
787: THEN
788: debug_others (l_proc_name, 10);
789: IF g_debug
790: THEN
848: debug_exit(l_proc_name);
849: return 0;
850: EXCEPTION
851: WHEN others THEN
852: IF SQLCODE <> hr_utility.hr_error_number
853: THEN
854: debug_others (l_proc_name, 10);
855: IF g_debug
856: THEN
889: debug_exit(l_proc_name);
890: return 0;
891: EXCEPTION
892: WHEN others THEN
893: IF SQLCODE <> hr_utility.hr_error_number
894: THEN
895: debug_others (l_proc_name, 10);
896: IF g_debug
897: THEN
961: debug_exit(l_proc_name);
962: return 0;
963: EXCEPTION
964: WHEN others THEN
965: IF SQLCODE <> hr_utility.hr_error_number
966: THEN
967: debug_others (l_proc_name, 10);
968: IF g_debug
969: THEN
1016: debug_exit(l_proc_name);
1017: return 0;
1018: EXCEPTION
1019: WHEN others THEN
1020: IF SQLCODE <> hr_utility.hr_error_number
1021: THEN
1022: debug_others (l_proc_name, 10);
1023: IF g_debug
1024: THEN
1109: debug_exit(l_proc_name);
1110: return 0;
1111: EXCEPTION
1112: WHEN others THEN
1113: IF SQLCODE <> hr_utility.hr_error_number
1114: THEN
1115: debug_others (l_proc_name, 10);
1116: IF g_debug
1117: THEN
1172: debug_exit(l_proc_name);
1173: return 0;
1174: EXCEPTION
1175: WHEN others THEN
1176: IF SQLCODE <> hr_utility.hr_error_number
1177: THEN
1178: debug_others (l_proc_name, 10);
1179: IF g_debug
1180: THEN
1364:
1365:
1366: EXCEPTION
1367: WHEN others THEN
1368: IF SQLCODE <> hr_utility.hr_error_number
1369: THEN
1370: debug_others (l_proc_name, 10);
1371: IF g_debug
1372: THEN
1401: RETURN 'Y';
1402:
1403: EXCEPTION
1404: WHEN others THEN
1405: IF SQLCODE <> hr_utility.hr_error_number
1406: THEN
1407: debug_others (l_proc_name, 10);
1408: IF g_debug
1409: THEN