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.PAY_NZ_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

Line 25: hr_utility.set_location('Start of range_code',1);

21:
22:
23: BEGIN
24:
25: hr_utility.set_location('Start of range_code',1);
26:
27:
28: --------------------------------------------------------------------------------+
29: -- Call to range_code from common apac package 'pay_apac_payslip_archive'

Line 42: hr_utility.set_location('End of range_code',2);

38: --
39: pay_core_payslip_utils.range_cursor(p_payroll_action_id,
40: p_sql);
41:
42: hr_utility.set_location('End of range_code',2);
43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: hr_utility.set_location('Error in initialization_code',2);

Line 46: hr_utility.set_location('Error in initialization_code',2);

42: hr_utility.set_location('End of range_code',2);
43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: hr_utility.set_location('Error in initialization_code',2);
47: RAISE;
48:
49: END range_code;
50:

Line 66: hr_utility.set_location('Start of initialization_code',1);

62:
63:
64: BEGIN
65:
66: hr_utility.set_location('Start of initialization_code',1);
67:
68: g_archive_pact := p_payroll_action_id;
69:
70: ------------------------------------------------------------------+

Line 78: hr_utility.set_location('End of initialization_code',2);

74: ------------------------------------------------------------------+
75:
76: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);
77:
78: hr_utility.set_location('End of initialization_code',2);
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: hr_utility.set_location('Error in initialization_code',2);

Line 82: hr_utility.set_location('Error in initialization_code',2);

78: hr_utility.set_location('End of initialization_code',2);
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: hr_utility.set_location('Error in initialization_code',2);
83: RAISE;
84:
85: END initialization_code;
86:

Line 110: hr_utility.trace('Start of assignment action code');

106: p_chunk IN NUMBER) IS
107:
108: BEGIN
109:
110: hr_utility.trace('Start of assignment action code');
111:
112: --
113: -- Bug 3580568
114: --

Line 125: hr_utility.trace('End of Assignment action code');

121: 'NZ');
122:
123:
124:
125: hr_utility.trace('End of Assignment action code');
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: hr_utility.trace('Error occured in Assignment action code');

Line 129: hr_utility.trace('Error occured in Assignment action code');

125: hr_utility.trace('End of Assignment action code');
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: hr_utility.trace('Error occured in Assignment action code');
130: RAISE;
131:
132: END assignment_action_code;
133:

Line 180: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);

176: l_procedure_name CONSTANT VARCHAR2(80) := 'archive_stat_elements';
177:
178: BEGIN
179:
180: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
181:
182: FOR csr_rec IN csr_std_elements1(p_assignment_action_id,p_assignment_id)
183:
184: LOOP

Line 186: hr_utility.set_location('Archiving Standard Element Details',20);

182: FOR csr_rec IN csr_std_elements1(p_assignment_action_id,p_assignment_id)
183:
184: LOOP
185:
186: hr_utility.set_location('Archiving Standard Element Details',20);
187:
188: pay_action_information_api.create_action_information
189: ( p_action_information_id => l_action_info_id
190: , p_action_context_id => p_assact_id

Line 210: hr_utility.set_location('Archiving Standard Element Details',20);

206: FOR csr_rec IN csr_std_elements2(p_assignment_action_id,p_assignment_id)
207:
208: LOOP
209:
210: hr_utility.set_location('Archiving Standard Element Details',20);
211:
212: pay_action_information_api.create_action_information
213: ( p_action_information_id => l_action_info_id
214: , p_action_context_id => p_assact_id

Line 230: hr_utility.set_location('End of archive Standard Element',4);

226: );
227:
228: END LOOP;
229:
230: hr_utility.set_location('End of archive Standard Element',4);
231: hr_utility.set_location('Leaving procedure ' || l_procedure_name,10);
232:
233: EXCEPTION
234: WHEN OTHERS THEN

Line 231: hr_utility.set_location('Leaving procedure ' || l_procedure_name,10);

227:
228: END LOOP;
229:
230: hr_utility.set_location('End of archive Standard Element',4);
231: hr_utility.set_location('Leaving procedure ' || l_procedure_name,10);
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: hr_utility.set_location('Error raised in archiving Standard Elements ',5);

Line 235: hr_utility.set_location('Error raised in archiving Standard Elements ',5);

231: hr_utility.set_location('Leaving procedure ' || l_procedure_name,10);
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: hr_utility.set_location('Error raised in archiving Standard Elements ',5);
236: RAISE;
237:
238: END archive_stat_elements;
239:

Line 258: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);

254: l_procedure_name CONSTANT VARCHAR2(80) := 'archive_balances';
255:
256: BEGIN
257:
258: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
259: hr_utility.set_location('archiving balances :',10);
260:
261: -- Archive Statutory balances
262:

Line 259: hr_utility.set_location('archiving balances :',10);

255:
256: BEGIN
257:
258: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
259: hr_utility.set_location('archiving balances :',10);
260:
261: -- Archive Statutory balances
262:
263: pay_action_information_api.create_action_information

Line 281: hr_utility.set_location('Error in archiving balance :',11);

277:
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: hr_utility.set_location('Error in archiving balance :',11);
282: RAISE;
283:
284: END archive_balances;
285:

Line 317: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);

313: l_procedure_name CONSTANT VARCHAR2(80) := 'archive_stat_balances';
314:
315: BEGIN
316:
317: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
318: hr_utility.set_location('Calling balance_total from pay_nz_soe_pkg',20);
319:
320: -- Get the totals of the statutory balances
321:

Line 318: hr_utility.set_location('Calling balance_total from pay_nz_soe_pkg',20);

314:
315: BEGIN
316:
317: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
318: hr_utility.set_location('Calling balance_total from pay_nz_soe_pkg',20);
319:
320: -- Get the totals of the statutory balances
321:
322: pay_nz_soe_pkg.balance_totals(p_assignment_id,

Line 347: hr_utility.set_location('Archiving value for ' || l_narrative,30);

343:
344:
345: l_narrative := 'Taxable Earnings';
346:
347: hr_utility.set_location('Archiving value for ' || l_narrative,30);
348:
349: archive_balances(p_effective_date =>p_effective_date
350: ,p_assact_id =>p_assact_id
351: ,p_narrative =>l_narrative

Line 358: hr_utility.set_location('Archiving value for ' || l_narrative,40);

354:
355:
356: l_narrative := 'Non Taxable Allowances';
357:
358: hr_utility.set_location('Archiving value for ' || l_narrative,40);
359:
360: archive_balances(p_effective_date =>p_effective_date
361: ,p_assact_id =>p_assact_id
362: ,p_narrative =>l_narrative

Line 369: hr_utility.set_location('Archiving value for ' || l_narrative,50);

365:
366:
367: l_narrative := 'Tax Deductions';
368:
369: hr_utility.set_location('Archiving value for ' || l_narrative,50);
370:
371: archive_balances(p_effective_date =>p_effective_date
372: ,p_assact_id =>p_assact_id
373: ,p_narrative =>l_narrative

Line 380: hr_utility.set_location('Archiving value for ' || l_narrative,60);

376:
377:
378: l_narrative := 'Other Deductions ';
379:
380: hr_utility.set_location('Archiving value for ' || l_narrative,60);
381:
382: archive_balances(p_effective_date =>p_effective_date
383: ,p_assact_id =>p_assact_id
384: ,p_narrative =>l_narrative

Line 391: hr_utility.set_location('Archiving value for ' || l_narrative,70);

387:
388:
389: l_narrative := 'Net Payment ';
390:
391: hr_utility.set_location('Archiving value for ' || l_narrative,70);
392:
393: archive_balances(p_effective_date =>p_effective_date
394: ,p_assact_id => p_assact_id
395: ,p_narrative => l_narrative

Line 399: hr_utility.set_location('End of Archiving Stat Balances ',80);

395: ,p_narrative => l_narrative
396: ,p_ytd =>l_net_payment_ytd);
397:
398:
399: hr_utility.set_location('End of Archiving Stat Balances ',80);
400:
401: hr_utility.set_location('Leaving procedure ' || l_procedure_name,90);
402:
403: EXCEPTION

Line 401: hr_utility.set_location('Leaving procedure ' || l_procedure_name,90);

397:
398:
399: hr_utility.set_location('End of Archiving Stat Balances ',80);
400:
401: hr_utility.set_location('Leaving procedure ' || l_procedure_name,90);
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: hr_utility.set_location('error in calling archive balance code :',11);

Line 405: hr_utility.set_location('error in calling archive balance code :',11);

401: hr_utility.set_location('Leaving procedure ' || l_procedure_name,90);
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: hr_utility.set_location('error in calling archive balance code :',11);
406: RAISE;
407:
408: END archive_stat_balances;
409:

Line 482: hr_utility.set_location('Entering procedure '|| l_procedure_name,10);

478: l_bank_code VARCHAR2(2);
479:
480: BEGIN
481:
482: hr_utility.set_location('Entering procedure '|| l_procedure_name,10);
483:
484: -- call generic procedure to retrieve and archive all data for
485: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
486:

Line 492: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',20);

488: OPEN csr_tax_unit_id(p_curr_pymt_ass_act_id);
489: FETCH csr_tax_unit_id INTO l_tax_unit_id;
490: CLOSE csr_tax_unit_id;
491:
492: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',20);
493:
494: pay_emp_action_arch.get_personal_information
495: (p_payroll_action_id => p_payroll_action_id -- archive payroll_action_id
496: , p_assactid => p_assactid -- archive assignment_action_id

Line 508: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);

504: , p_ppp_source_action_id => NULL
505: , p_run_action_id => p_pay_assignment_action_id
506: );
507:
508: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);
509:
510: -- Retrieve and Archive the NZ specific(tax code) employee details
511:
512: l_tax_code := pay_nz_soe_pkg.get_tax_code(p_pay_assignment_action_id);

Line 514: hr_utility.set_location('Archiving NZ EMPLOYEE DETAILS',60);

510: -- Retrieve and Archive the NZ specific(tax code) employee details
511:
512: l_tax_code := pay_nz_soe_pkg.get_tax_code(p_pay_assignment_action_id);
513:
514: hr_utility.set_location('Archiving NZ EMPLOYEE DETAILS',60);
515:
516: pay_action_information_api.create_action_information
517: ( p_action_information_id => l_action_info_id
518: , p_action_context_id => p_assactid

Line 532: hr_utility.set_location('Calling update Net Pay Distribution',80);

528: , p_action_information21 => l_tax_code
529: );
530:
531:
532: hr_utility.set_location('Calling update Net Pay Distribution',80);
533:
534: -- Update Net Pay Distribution record with Bank name
535: -- Since Core package puts the bank branch number in action_information5
536: -- the bank name is obtained using this information

Line 558: hr_utility.set_location('End of archive_employee_details',90);

554: );
555:
556: END LOOP;
557:
558: hr_utility.set_location('End of archive_employee_details',90);
559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: hr_utility.set_location('Error raised in archiving Employee details ',5);

Line 562: hr_utility.set_location('Error raised in archiving Employee details ',5);

558: hr_utility.set_location('End of archive_employee_details',90);
559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: hr_utility.set_location('Error raised in archiving Employee details ',5);
563: RAISE;
564:
565: END archive_employee_details;
566:

Line 688: hr_utility.set_location('Start of accrual archival code',1);

684: l_end_date VARCHAR2(20);
685:
686: BEGIN
687:
688: hr_utility.set_location('Start of accrual archival code',1);
689:
690: OPEN csr_leave_balance(p_assignment_action_id,p_assignment_id);
691: FETCH csr_leave_balance INTO
692: l_accrual_plan_name,

Line 709: hr_utility.set_location('Archiving Annual leave information',2);

705: ,l_annual_leave_accrual_plan_id
706: ,p_period_end_date);
707:
708:
709: hr_utility.set_location('Archiving Annual leave information',2);
710:
711: IF l_accrual_plan_name IS NOT NULL AND l_annual_leave_balance IS NULL THEN
712: l_annual_leave_balance := 0;
713: END IF;

Line 734: hr_utility.set_location('End of accrual archival ',1);

730: );
731:
732: END IF;
733:
734: hr_utility.set_location('End of accrual archival ',1);
735:
736: hr_utility.set_location('Start of leave archival code',1);
737:
738: FOR csr_rec IN csr_leave_taken1(p_time_period_id,p_assignment_id,p_date_earned)

Line 736: hr_utility.set_location('Start of leave archival code',1);

732: END IF;
733:
734: hr_utility.set_location('End of accrual archival ',1);
735:
736: hr_utility.set_location('Start of leave archival code',1);
737:
738: FOR csr_rec IN csr_leave_taken1(p_time_period_id,p_assignment_id,p_date_earned)
739:
740: LOOP

Line 842: hr_utility.set_location('End of archive Leaves Taken',4);

838: );
839:
840: END LOOP;
841:
842: hr_utility.set_location('End of archive Leaves Taken',4);
843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: hr_utility.set_location('Error raised in archiving Accruals and Leave Taken ',5);

Line 846: hr_utility.set_location('Error raised in archiving Accruals and Leave Taken ',5);

842: hr_utility.set_location('End of archive Leaves Taken',4);
843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: hr_utility.set_location('Error raised in archiving Accruals and Leave Taken ',5);
847: RAISE;
848:
849: END archive_accrual_details;
850:

Line 958: hr_utility.set_location('Start of archive code',20);

954:
955: BEGIN
956:
957:
958: hr_utility.set_location('Start of archive code',20);
959:
960: --
961: -- Bug 3580568
962: --

Line 974: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);

970: FOR csr_rec IN csr_get_payslip_aa(p_assignment_action_id)
971:
972: LOOP
973:
974: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
975: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
976:
977: /*Bug No:5634580
978: This cursor returns actual termination date if it falls in the pay period */

Line 975: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);

971:
972: LOOP
973:
974: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
975: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
976:
977: /*Bug No:5634580
978: This cursor returns actual termination date if it falls in the pay period */
979:

Line 1066: hr_utility.set_location('End of archive code',37);

1062:
1063:
1064: END LOOP;
1065:
1066: hr_utility.set_location('End of archive code',37);
1067:
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: hr_utility.set_location('Error in archive code :',11);

Line 1070: hr_utility.set_location('Error in archive code :',11);

1066: hr_utility.set_location('End of archive code',37);
1067:
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: hr_utility.set_location('Error in archive code :',11);
1071: RAISE;
1072:
1073: END archive_code;
1074: