5: hr_application_error exception;
6: pragma exception_init (hr_application_error, -20001);
7:
8:
9: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;
10:
11: -- ----------------------------------------------------------------------------
12: -- |--------------------------------< debug >---------------------------------|
13: -- ----------------------------------------------------------------------------
18: --
19: BEGIN
20: --
21:
22: pqp_utilities.DEBUG (
23: p_trace_message => p_trace_message
24: ,p_trace_location => p_trace_location
25: );
26: --
38: IS
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
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
48: );
49: END IF;
62: IS
63: BEGIN
64: --
65: IF g_debug THEN
66: pqp_utilities.debug_exit (
67: p_proc_name => p_proc_name
68: ,p_trace_off => p_trace_off
69: );
70:
67: p_proc_name => p_proc_name
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: --
85: PROCEDURE debug_others (p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
86: IS
87: BEGIN
88: --
89: pqp_utilities.debug_others (
90: p_proc_name => p_proc_name
91: ,p_proc_step => p_proc_step
92: );
93: --