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: -- For BUG 5998129
15: l_element_of_bonus_type VARCHAR2(1);
16: -- ----------------------------------------------------------------------------
24: --
25: BEGIN
26: --
27: IF g_debug THEN
28: pqp_utilities.DEBUG (
29: p_trace_message => p_trace_message
30: ,p_trace_location => p_trace_location
31: );
32: END IF;
46: IS
47: BEGIN
48: --
49: IF g_debug THEN
50: IF pqp_utilities.g_nested_level = 0 THEN
51: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
52: END IF;
53: pqp_utilities.debug_enter (
54: p_proc_name => p_proc_name
49: IF g_debug THEN
50: IF pqp_utilities.g_nested_level = 0 THEN
51: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
52: END IF;
53: pqp_utilities.debug_enter (
54: p_proc_name => p_proc_name
55: ,p_trace_on => p_trace_on
56: );
57: END IF;
71: IS
72: BEGIN
73: --
74: IF g_debug THEN
75: pqp_utilities.debug_exit (
76: p_proc_name => p_proc_name
77: ,p_trace_off => p_trace_off
78: );
79:
76: p_proc_name => p_proc_name
77: ,p_trace_off => p_trace_off
78: );
79:
80: IF pqp_utilities.g_nested_level = 0 THEN
81: hr_utility.trace_off;
82: END IF;
83: END IF;
84: --
94: PROCEDURE debug_others (p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
95: IS
96: BEGIN
97: --
98: pqp_utilities.debug_others (
99: p_proc_name => p_proc_name
100: ,p_proc_step => p_proc_step
101: );
102: --
109: -- ----------------------------------------------------------------------------
110: PROCEDURE set_bonus_balance_type
111: IS
112: l_proc varchar2(72) := g_package||'.set_bonus_balance_type';
113: l_config_values PQP_UTILITIES.t_config_values;
114: BEGIN
115: debug_enter(l_proc);
116: -- fetch the adj hrs source configuration values
117: PQP_UTILITIES.get_config_type_values(
113: l_config_values PQP_UTILITIES.t_config_values;
114: BEGIN
115: debug_enter(l_proc);
116: -- fetch the adj hrs source configuration values
117: PQP_UTILITIES.get_config_type_values(
118: p_configuration_type => 'PQP_GB_PENSERVER_BONBAL_VALUE'
119: ,p_business_group_id => g_business_group_id
120: ,p_legislation_code => g_legislation_code
121: ,p_tab_config_values => l_config_values