DBA Data[Home] [Help]

APPS.PQP_GB_PSI_ADDDRESS dependencies on PQP_UTILITIES

Line 12: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;

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:

Line 24: pqp_utilities.DEBUG (

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;

Line 45: IF pqp_utilities.g_nested_level = 0 THEN

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

Line 48: pqp_utilities.debug_enter (

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;

Line 69: pqp_utilities.debug_exit (

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:

Line 74: IF pqp_utilities.g_nested_level = 0 THEN

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: --

Line 92: pqp_utilities.debug_others (

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: --

Line 111: l_config_values PQP_UTILITIES.t_config_values;

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

Line 136: PQP_UTILITIES.get_config_type_values(

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