39: BEGIN
40: --
41: IF g_debug THEN
42: IF pqp_utilities.g_nested_level = 0 THEN
43: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
44: END IF;
45: pqp_utilities.debug_enter (
46: p_proc_name => p_proc_name
47: ,p_trace_on => p_trace_on
68: ,p_trace_off => p_trace_off
69: );
70:
71: IF pqp_utilities.g_nested_level = 0 THEN
72: hr_utility.trace_off;
73: END IF;
74: END IF;
75: --
76: END debug_exit;
121: debug_exit(l_proc_name);
122: END IF;
123: EXCEPTION
124: WHEN others THEN
125: IF SQLCODE <> hr_utility.hr_error_number
126: THEN
127: debug_others (l_proc_name, l_proc_step);
128: IF g_debug
129: THEN
226: return l_return;
227:
228: EXCEPTION
229: WHEN others THEN
230: IF SQLCODE <> hr_utility.hr_error_number
231: THEN
232: debug_others (l_proc_name, 10);
233: IF g_debug
234: THEN
298: RETURN 0;
299:
300: EXCEPTION
301: WHEN others THEN
302: IF SQLCODE <> hr_utility.hr_error_number
303: THEN
304: debug_others (l_proc_name, 10);
305: IF g_debug
306: THEN
334: RETURN 'Y';
335:
336: EXCEPTION
337: WHEN others THEN
338: IF SQLCODE <> hr_utility.hr_error_number
339: THEN
340: debug_others (l_proc_name, 10);
341: IF g_debug
342: THEN