7: hr_application_error exception;
8: pragma exception_init (hr_application_error, -20001);
9:
10:
11: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;
12:
13: -- ----------------------------------------------------------------------------
14: -- |--------------------------------< debug >---------------------------------|
15: -- ----------------------------------------------------------------------------
20: --
21: BEGIN
22: --
23:
24: pqp_utilities.DEBUG (
25: p_trace_message => p_trace_message
26: ,p_trace_location => p_trace_location
27: );
28: --
40: IS
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
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
50: );
51: END IF;
64: IS
65: BEGIN
66: --
67: IF g_debug THEN
68: pqp_utilities.debug_exit (
69: p_proc_name => p_proc_name
70: ,p_trace_off => p_trace_off
71: );
72:
69: p_proc_name => p_proc_name
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: --
86: PROCEDURE debug_others (p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
87: IS
88: BEGIN
89: --
90: pqp_utilities.debug_others (
91: p_proc_name => p_proc_name
92: ,p_proc_step => p_proc_step
93: );
94: --