eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY pqp_gb_tp_contribution_report AS
2: /* $Header: pqpgbtpcontrep.pkb 120.11.12020000.1 2013/03/11 11:20:00 sgmaram noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: g_package VARCHAR2(35) := 'PQP_GB_TP_CONTRIBUTION_REPORT.';
5: EOL VARCHAR2(5) := fnd_global.local_chr(10);
6: -------------------------------------------------------------------------------
7:

Line 16: hr_utility.set_location('Entering: is_this_retro ', 10);

12: RETURN NUMBER
13: IS
14: A NUMBER;
15: BEGIN
16: hr_utility.set_location('Entering: is_this_retro ', 10);
17: hr_utility.set_location(' Assignment ID '||p_assignment_id , 20);
18: BEGIN
19: SELECT 0
20: INTO A

Line 17: hr_utility.set_location(' Assignment ID '||p_assignment_id , 20);

13: IS
14: A NUMBER;
15: BEGIN
16: hr_utility.set_location('Entering: is_this_retro ', 10);
17: hr_utility.set_location(' Assignment ID '||p_assignment_id , 20);
18: BEGIN
19: SELECT 0
20: INTO A
21: FROM PAY_PAYROLL_ACTIONS

Line 28: hr_utility.set_location('**** This is retro ' , 30);

24: FROM PAY_ASSIGNMENT_ACTIONS
25: WHERE ASSIGNMENT_ID = p_assignment_id
26: )
27: AND ACTION_TYPE IN ('L','G','O');
28: hr_utility.set_location('**** This is retro ' , 30);
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: hr_utility.set_location('**** This is Normal Payroll ' , 40);
32: A := 1;

Line 31: hr_utility.set_location('**** This is Normal Payroll ' , 40);

27: AND ACTION_TYPE IN ('L','G','O');
28: hr_utility.set_location('**** This is retro ' , 30);
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: hr_utility.set_location('**** This is Normal Payroll ' , 40);
32: A := 1;
33: END;
34: RETURN A;
35: END IS_THIS_RETRO;

Line 93: hr_utility.trace('Entering : TPS_Pension_tier');

89: l_count NUMBER ;
90:
91:
92: BEGIN
93: hr_utility.trace('Entering : TPS_Pension_tier');
94: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;
95: hr_utility.trace('source_action_id :'|| l_source_action_id);
96:
97: OPEN c_element_type_id;

Line 95: hr_utility.trace('source_action_id :'|| l_source_action_id);

91:
92: BEGIN
93: hr_utility.trace('Entering : TPS_Pension_tier');
94: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;
95: hr_utility.trace('source_action_id :'|| l_source_action_id);
96:
97: OPEN c_element_type_id;
98: FETCH c_element_type_id INTO l_element_id;
99: CLOSE c_element_type_id;

Line 100: hr_utility.trace('p_business_group_id::'||p_business_group_id);

96:
97: OPEN c_element_type_id;
98: FETCH c_element_type_id INTO l_element_id;
99: CLOSE c_element_type_id;
100: hr_utility.trace('p_business_group_id::'||p_business_group_id);
101: hr_utility.trace('p_payroll_id::'||p_payroll_id);
102: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
103: hr_utility.trace('p_element_type_id::'||l_element_id);
104: hr_utility.trace('p_assignment_id::'||p_assignment_id);

Line 101: hr_utility.trace('p_payroll_id::'||p_payroll_id);

97: OPEN c_element_type_id;
98: FETCH c_element_type_id INTO l_element_id;
99: CLOSE c_element_type_id;
100: hr_utility.trace('p_business_group_id::'||p_business_group_id);
101: hr_utility.trace('p_payroll_id::'||p_payroll_id);
102: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
103: hr_utility.trace('p_element_type_id::'||l_element_id);
104: hr_utility.trace('p_assignment_id::'||p_assignment_id);
105: IF is_this_retro(p_assignment_id) = 0 THEN

Line 102: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);

98: FETCH c_element_type_id INTO l_element_id;
99: CLOSE c_element_type_id;
100: hr_utility.trace('p_business_group_id::'||p_business_group_id);
101: hr_utility.trace('p_payroll_id::'||p_payroll_id);
102: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
103: hr_utility.trace('p_element_type_id::'||l_element_id);
104: hr_utility.trace('p_assignment_id::'||p_assignment_id);
105: IF is_this_retro(p_assignment_id) = 0 THEN
106: --This is retro run, so fetch the original payroll run's result values

Line 103: hr_utility.trace('p_element_type_id::'||l_element_id);

99: CLOSE c_element_type_id;
100: hr_utility.trace('p_business_group_id::'||p_business_group_id);
101: hr_utility.trace('p_payroll_id::'||p_payroll_id);
102: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
103: hr_utility.trace('p_element_type_id::'||l_element_id);
104: hr_utility.trace('p_assignment_id::'||p_assignment_id);
105: IF is_this_retro(p_assignment_id) = 0 THEN
106: --This is retro run, so fetch the original payroll run's result values
107: OPEN c_tier_prrv(l_element_id);

Line 104: hr_utility.trace('p_assignment_id::'||p_assignment_id);

100: hr_utility.trace('p_business_group_id::'||p_business_group_id);
101: hr_utility.trace('p_payroll_id::'||p_payroll_id);
102: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
103: hr_utility.trace('p_element_type_id::'||l_element_id);
104: hr_utility.trace('p_assignment_id::'||p_assignment_id);
105: IF is_this_retro(p_assignment_id) = 0 THEN
106: --This is retro run, so fetch the original payroll run's result values
107: OPEN c_tier_prrv(l_element_id);
108: FETCH c_tier_prrv INTO p_rv_a,p_rv_b,p_rv_c;

Line 112: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);

108: FETCH c_tier_prrv INTO p_rv_a,p_rv_b,p_rv_c;
109: p_rv_a := NVL(p_rv_a,0);
110: p_rv_b := NVL(p_rv_b,0);
111: p_rv_c := NVL(p_rv_c,0);
112: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
113: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
114: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
115: CLOSE c_tier_prrv;
116:

Line 113: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);

109: p_rv_a := NVL(p_rv_a,0);
110: p_rv_b := NVL(p_rv_b,0);
111: p_rv_c := NVL(p_rv_c,0);
112: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
113: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
114: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
115: CLOSE c_tier_prrv;
116:
117: END IF;

Line 114: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);

110: p_rv_b := NVL(p_rv_b,0);
111: p_rv_c := NVL(p_rv_c,0);
112: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
113: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
114: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
115: CLOSE c_tier_prrv;
116:
117: END IF;
118:

Line 122: hr_utility.trace('Error in the Function PQP_GB_TP_CONTRIBUTION_REPORT.TPS_PENSION_TIER.');

118:
119: RETURN 1; -- 1 = Success
120: EXCEPTION
121: WHEN OTHERS THEN
122: hr_utility.trace('Error in the Function PQP_GB_TP_CONTRIBUTION_REPORT.TPS_PENSION_TIER.');
123: RETURN 0; -- 0 = Failure
124: END TPS_PENSION_TIER;
125:
126: --

Line 212: hr_utility.trace('Entering : TPS_Pension_Input_values');

208: l_count NUMBER ;
209:
210:
211: BEGIN
212: hr_utility.trace('Entering : TPS_Pension_Input_values');
213: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;
214: hr_utility.trace('source_action_id :'|| l_source_action_id);
215:
216: OPEN c_element_type_id;

Line 214: hr_utility.trace('source_action_id :'|| l_source_action_id);

210:
211: BEGIN
212: hr_utility.trace('Entering : TPS_Pension_Input_values');
213: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;
214: hr_utility.trace('source_action_id :'|| l_source_action_id);
215:
216: OPEN c_element_type_id;
217: FETCH c_element_type_id INTO l_element_id;
218: CLOSE c_element_type_id;

Line 219: hr_utility.trace('p_business_group_id::'||p_business_group_id);

215:
216: OPEN c_element_type_id;
217: FETCH c_element_type_id INTO l_element_id;
218: CLOSE c_element_type_id;
219: hr_utility.trace('p_business_group_id::'||p_business_group_id);
220: hr_utility.trace('p_payroll_id::'||p_payroll_id);
221: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
222: hr_utility.trace('p_element_type_id::'||l_element_id);
223: hr_utility.trace('p_assignment_id::'||p_assignment_id);

Line 220: hr_utility.trace('p_payroll_id::'||p_payroll_id);

216: OPEN c_element_type_id;
217: FETCH c_element_type_id INTO l_element_id;
218: CLOSE c_element_type_id;
219: hr_utility.trace('p_business_group_id::'||p_business_group_id);
220: hr_utility.trace('p_payroll_id::'||p_payroll_id);
221: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
222: hr_utility.trace('p_element_type_id::'||l_element_id);
223: hr_utility.trace('p_assignment_id::'||p_assignment_id);
224: IF is_this_retro(p_assignment_id) = 0 THEN

Line 221: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);

217: FETCH c_element_type_id INTO l_element_id;
218: CLOSE c_element_type_id;
219: hr_utility.trace('p_business_group_id::'||p_business_group_id);
220: hr_utility.trace('p_payroll_id::'||p_payroll_id);
221: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
222: hr_utility.trace('p_element_type_id::'||l_element_id);
223: hr_utility.trace('p_assignment_id::'||p_assignment_id);
224: IF is_this_retro(p_assignment_id) = 0 THEN
225: --This is retro run, so fetch the original payroll run's result values

Line 222: hr_utility.trace('p_element_type_id::'||l_element_id);

218: CLOSE c_element_type_id;
219: hr_utility.trace('p_business_group_id::'||p_business_group_id);
220: hr_utility.trace('p_payroll_id::'||p_payroll_id);
221: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
222: hr_utility.trace('p_element_type_id::'||l_element_id);
223: hr_utility.trace('p_assignment_id::'||p_assignment_id);
224: IF is_this_retro(p_assignment_id) = 0 THEN
225: --This is retro run, so fetch the original payroll run's result values
226: OPEN c_tier_prrv(l_element_id);

Line 223: hr_utility.trace('p_assignment_id::'||p_assignment_id);

219: hr_utility.trace('p_business_group_id::'||p_business_group_id);
220: hr_utility.trace('p_payroll_id::'||p_payroll_id);
221: hr_utility.trace('P_DATE_EARNED::'||P_DATE_EARNED);
222: hr_utility.trace('p_element_type_id::'||l_element_id);
223: hr_utility.trace('p_assignment_id::'||p_assignment_id);
224: IF is_this_retro(p_assignment_id) = 0 THEN
225: --This is retro run, so fetch the original payroll run's result values
226: OPEN c_tier_prrv(l_element_id);
227: FETCH c_tier_prrv INTO p_rv_a,p_rv_b,p_rv_c,p_pp_a,p_pp_b,p_pp_c,p_ee_a,p_ee_b,p_ee_c,p_er_a,p_er_b,p_er_c,p_af_a,p_af_b,p_af_c;

Line 244: hr_utility.trace('PENSION TIER');

240: p_af_a := NVL(p_af_a,0);
241: p_af_b := NVL(p_af_b,0);
242: p_af_c := NVL(p_af_c,0);
243:
244: hr_utility.trace('PENSION TIER');
245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');

Line 245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);

241: p_af_b := NVL(p_af_b,0);
242: p_af_c := NVL(p_af_c,0);
243:
244: hr_utility.trace('PENSION TIER');
245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);

Line 246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);

242: p_af_c := NVL(p_af_c,0);
243:
244: hr_utility.trace('PENSION TIER');
245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);

Line 247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);

243:
244: hr_utility.trace('PENSION TIER');
245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);

Line 248: hr_utility.trace('PENSION PAY');

244: hr_utility.trace('PENSION TIER');
245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');

Line 249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);

245: hr_utility.trace('After fetch Return Value - A:'||p_rv_a);
246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);

Line 250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);

246: hr_utility.trace('After fetch Return Value - B:'||p_rv_b);
247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);

Line 251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);

247: hr_utility.trace('After fetch Return Value - C:'||p_rv_c);
248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);

Line 252: hr_utility.trace('EMPLOYEE CONTRIBUTION');

248: hr_utility.trace('PENSION PAY');
249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');

Line 253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);

249: hr_utility.trace('After fetch Return Value - A:'||p_pp_a);
250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);

Line 254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);

250: hr_utility.trace('After fetch Return Value - B:'||p_pp_b);
251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);

Line 255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);

251: hr_utility.trace('After fetch Return Value - C:'||p_pp_c);
252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);

Line 256: hr_utility.trace('EMPLOYER CONTRIBUTION');

252: hr_utility.trace('EMPLOYEE CONTRIBUTION');
253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');

Line 257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);

253: hr_utility.trace('After fetch Return Value - A:'||p_ee_a);
254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);

Line 258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);

254: hr_utility.trace('After fetch Return Value - B:'||p_ee_b);
255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);
262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);

Line 259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);

255: hr_utility.trace('After fetch Return Value - C:'||p_ee_c);
256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);
262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);
263: hr_utility.trace('After fetch Return Value - C:'||p_af_c);

Line 260: hr_utility.trace('ANNUAL FTE SALARY');

256: hr_utility.trace('EMPLOYER CONTRIBUTION');
257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);
262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);
263: hr_utility.trace('After fetch Return Value - C:'||p_af_c);
264: CLOSE c_tier_prrv;

Line 261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);

257: hr_utility.trace('After fetch Return Value - A:'||p_er_a);
258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);
262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);
263: hr_utility.trace('After fetch Return Value - C:'||p_af_c);
264: CLOSE c_tier_prrv;
265:

Line 262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);

258: hr_utility.trace('After fetch Return Value - B:'||p_er_b);
259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);
262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);
263: hr_utility.trace('After fetch Return Value - C:'||p_af_c);
264: CLOSE c_tier_prrv;
265:
266: END IF;

Line 263: hr_utility.trace('After fetch Return Value - C:'||p_af_c);

259: hr_utility.trace('After fetch Return Value - C:'||p_er_c);
260: hr_utility.trace('ANNUAL FTE SALARY');
261: hr_utility.trace('After fetch Return Value - A:'||p_af_a);
262: hr_utility.trace('After fetch Return Value - B:'||p_af_b);
263: hr_utility.trace('After fetch Return Value - C:'||p_af_c);
264: CLOSE c_tier_prrv;
265:
266: END IF;
267:

Line 271: hr_utility.trace('Error in the Function PQP_GB_TP_CONTRIBUTION_REPORT.TPS_PENSION_TIER.');

267:
268: RETURN 1; -- 1 = Success
269: EXCEPTION
270: WHEN OTHERS THEN
271: hr_utility.trace('Error in the Function PQP_GB_TP_CONTRIBUTION_REPORT.TPS_PENSION_TIER.');
272: RETURN 0; -- 0 = Failure
273: END TPS_PENSION_INPUT_VALUES;
274: --
275:

Line 540: hr_utility.set_location(' Entering Procedure GENERATE',1);

536:
537: -------------------------------------------------------------------------------
538: BEGIN
539: IF g_debug THEN
540: hr_utility.set_location(' Entering Procedure GENERATE',1);
541: END IF;
542:
543: OPEN csr_period_details(p_period);
544: FETCH csr_period_details INTO r_period_details;

Line 700: hr_utility.set_location(' Leaving Procedure GENERATE',2);

696: p_xml := l_xml;
697: dbms_lob.freeTemporary(l_xml);
698:
699: IF g_debug THEN
700: hr_utility.set_location(' Leaving Procedure GENERATE',2);
701: END IF;
702:
703: EXCEPTION
704: WHEN others THEN

Line 706: hr_utility.set_location('Error raised in GENERATE ',9);

702:
703: EXCEPTION
704: WHEN others THEN
705: IF g_debug THEN
706: hr_utility.set_location('Error raised in GENERATE ',9);
707: hr_utility.trace('Error: '||sqlerrm);
708: END IF;
709: RAISE;
710: END generate;

Line 707: hr_utility.trace('Error: '||sqlerrm);

703: EXCEPTION
704: WHEN others THEN
705: IF g_debug THEN
706: hr_utility.set_location('Error raised in GENERATE ',9);
707: hr_utility.trace('Error: '||sqlerrm);
708: END IF;
709: RAISE;
710: END generate;
711:

Line 747: hr_utility.set_location('Entering '||l_proc,10);

743: l_pension_tier number := 0;
744:
745: begin
746:
747: hr_utility.set_location('Entering '||l_proc,10);
748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);

Line 748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

744:
745: begin
746:
747: hr_utility.set_location('Entering '||l_proc,10);
748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);

Line 749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

745: begin
746:
747: hr_utility.set_location('Entering '||l_proc,10);
748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);

Line 750: hr_utility.set_location('p_date_worked '||p_date_worked,10);

746:
747: hr_utility.set_location('Entering '||l_proc,10);
748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);

Line 751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);

747: hr_utility.set_location('Entering '||l_proc,10);
748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);
755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);

Line 752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);

748: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);
755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);
756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);

Line 753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);

749: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);
755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);
756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);
757:

Line 754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);

750: hr_utility.set_location('p_date_worked '||p_date_worked,10);
751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);
755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);
756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);
757:
758:

Line 755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);

751: hr_utility.set_location('p_sal_rate1 '||p_sal_rate1,10);
752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);
755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);
756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);
757:
758:
759: hr_utility.set_location(l_proc||'Inside Claim element:'||p_date_worked, 30);

Line 756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);

752: hr_utility.set_location('p_sal_rate2 '||p_sal_rate2,10);
753: hr_utility.set_location('p_sal_rate3 '||p_sal_rate3,10);
754: hr_utility.set_location('p_allow_rate1 '||p_allow_rate1,10);
755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);
756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);
757:
758:
759: hr_utility.set_location(l_proc||'Inside Claim element:'||p_date_worked, 30);
760:

Line 759: hr_utility.set_location(l_proc||'Inside Claim element:'||p_date_worked, 30);

755: hr_utility.set_location('p_allow_rate2 '||p_allow_rate2,10);
756: hr_utility.set_location('p_allow_rate3 '||p_allow_rate3,10);
757:
758:
759: hr_utility.set_location(l_proc||'Inside Claim element:'||p_date_worked, 30);
760:
761: if trim(p_sal_rate1) is not null then
762: l_annual_fte_rate := l_annual_fte_rate +
763: pqp_rates_history_calc.get_historic_rate(

Line 772: hr_utility.set_location(l_proc||'l_annual_fte_rate:'||l_annual_fte_rate, 31);

768: p_rate_type_or_element => 'R'
769: );
770: end if;
771:
772: hr_utility.set_location(l_proc||'l_annual_fte_rate:'||l_annual_fte_rate, 31);
773:
774: if trim(p_sal_rate2) is not null then
775: l_annual_fte_rate := l_annual_fte_rate +
776: pqp_rates_history_calc.get_historic_rate(

Line 829: hr_utility.set_location(l_proc||'Annual FTE Rate:'||l_annual_fte_rate, 35);

825: p_rate_type_or_element => 'R'
826: );
827: end if;
828:
829: hr_utility.set_location(l_proc||'Annual FTE Rate:'||l_annual_fte_rate, 35);
830:
831: l_band_ee_percent := hruserdt.get_table_value(
832: p_bus_group_id => p_business_group_id,
833: p_table_name => 'PQP_TPA_PENSIONABLE_PAY_RANGE',

Line 838: hr_utility.set_location(l_proc||'EE Percentage:'||l_band_ee_percent, 36);

834: p_col_name => 'Employee Contribution Rate',
835: p_row_value => to_char(l_annual_fte_rate),
836: p_effective_date => p_date_worked );
837:
838: hr_utility.set_location(l_proc||'EE Percentage:'||l_band_ee_percent, 36);
839:
840: l_band_er_percent := hruserdt.get_table_value(
841: p_bus_group_id => p_business_group_id,
842: p_table_name => 'PQP_TPA_PENSIONABLE_PAY_RANGE',

Line 847: hr_utility.set_location(l_proc||'ER Percentage:'||l_band_er_percent, 36);

843: p_col_name => 'Employer Contribution Rate',
844: p_row_value => to_char(l_annual_fte_rate),
845: p_effective_date => p_date_worked );
846:
847: hr_utility.set_location(l_proc||'ER Percentage:'||l_band_er_percent, 36);
848:
849: l_pension_tier := hruserdt.get_table_value(
850: p_bus_group_id => p_business_group_id,
851: p_table_name => 'PQP_TPA_PENSIONABLE_PAY_RANGE',

Line 856: hr_utility.set_location(l_proc||'Pension Tier:'||l_pension_tier, 37);

852: p_col_name => 'Pension Tier',
853: p_row_value => to_char(l_annual_fte_rate),
854: p_effective_date => p_date_worked );
855:
856: hr_utility.set_location(l_proc||'Pension Tier:'||l_pension_tier, 37);
857:
858: p_annual_fte_rate := l_annual_fte_rate;
859: p_tier := l_pension_tier;
860: p_ee_percentage := l_band_ee_percent;

Line 863: hr_utility.set_location('Leaving '||l_proc,100);

859: p_tier := l_pension_tier;
860: p_ee_percentage := l_band_ee_percent;
861: p_er_percentage := l_band_er_percent;
862:
863: hr_utility.set_location('Leaving '||l_proc,100);
864: return 0;
865: exception
866: when others then
867: hr_utility.set_location('Exception '||l_proc||':'||sqlerrm,-100);

Line 867: hr_utility.set_location('Exception '||l_proc||':'||sqlerrm,-100);

863: hr_utility.set_location('Leaving '||l_proc,100);
864: return 0;
865: exception
866: when others then
867: hr_utility.set_location('Exception '||l_proc||':'||sqlerrm,-100);
868: return -1;
869: end supply_pension_bands;
870: --------------------------------------------------------------------
871: