8: -- Exceptions
9: hr_application_error exception;
10: pragma exception_init (hr_application_error, -20001);
11:
12: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;
13: -- ----------------------------------------------------------------------------
14: -- |--------------------------------< debug >---------------------------------|
15: -- ----------------------------------------------------------------------------
16:
20: --
21: BEGIN
22: --
23: IF g_debug THEN
24: pqp_utilities.DEBUG (
25: p_trace_message => p_trace_message
26: ,p_trace_location => p_trace_location
27: );
28: END IF;
41: IS
42: BEGIN
43: --
44: IF g_debug THEN
45: IF pqp_utilities.g_nested_level = 0 THEN
46: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
47: END IF;
48: pqp_utilities.debug_enter (
49: p_proc_name => p_proc_name
44: IF g_debug THEN
45: IF pqp_utilities.g_nested_level = 0 THEN
46: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
47: END IF;
48: pqp_utilities.debug_enter (
49: p_proc_name => p_proc_name
50: ,p_trace_on => p_trace_on
51: );
52: END IF;
65: IS
66: BEGIN
67: --
68: IF g_debug THEN
69: pqp_utilities.debug_exit (
70: p_proc_name => p_proc_name
71: ,p_trace_off => p_trace_off
72: );
73:
70: p_proc_name => p_proc_name
71: ,p_trace_off => p_trace_off
72: );
73:
74: IF pqp_utilities.g_nested_level = 0 THEN
75: hr_utility.trace_off;
76: END IF;
77: END IF;
78: --
88: PROCEDURE debug_others (p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
89: IS
90: BEGIN
91: --
92: pqp_utilities.debug_others (
93: p_proc_name => p_proc_name
94: ,p_proc_step => p_proc_step
95: );
96: --
107: )
108: IS
109: l_include varchar2(1) := 'Y';
110: l_proc varchar2(72) := g_package||'.set_address_extract_globals';
111: l_config_values PQP_UTILITIES.t_config_values;
112: BEGIN
113: debug_enter(l_proc);
114:
115: -- set global business group id
132: -- set the address types
133: -- fetch the configuration values for PQP_GB_PENSERVER_ADDRESS_MAP
134: -- if there is no configuration value an error will be raised at
135: -- extract level
136: PQP_UTILITIES.get_config_type_values(
137: p_configuration_type => c_configuration_type
138: ,p_business_group_id => g_business_group_id
139: ,p_legislation_code => g_legislation_code
140: ,p_tab_config_values => l_config_values