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_SG_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: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
28: -- to archive the payroll action level data and EIT defintions.
29: --------------------------------------------------------------------------------+

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

32: pay_core_payslip_utils.range_cursor( p_payroll_action_id,
33: p_sql
34: );
35: --
36: hr_utility.set_location('End of range_code',2);
37: EXCEPTION
38: WHEN OTHERS THEN
39: hr_utility.set_location('Error in range code',2);
40: RAISE;

Line 39: hr_utility.set_location('Error in range code',2);

35: --
36: hr_utility.set_location('End of range_code',2);
37: EXCEPTION
38: WHEN OTHERS THEN
39: hr_utility.set_location('Error in range code',2);
40: RAISE;
41:
42: END range_code;
43:

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

52: PROCEDURE initialization_code (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE) IS
53:
54:
55: BEGIN
56: hr_utility.set_location('Start of initialization_code',1);
57:
58: g_archive_pact := p_payroll_action_id;
59:
60: ------------------------------------------------------------------+

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

64: ------------------------------------------------------------------+
65:
66: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);
67:
68: hr_utility.set_location('End of initialization_code',2);
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: hr_utility.set_location('Error in initialization_code',2);

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

68: hr_utility.set_location('End of initialization_code',2);
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: hr_utility.set_location('Error in initialization_code',2);
73: RAISE;
74:
75: END initialization_code;
76:

Line 100: hr_utility.set_location('Start of Assignment_Action_Code',1);

96: p_start_person IN per_all_people_f.person_id%TYPE,
97: p_end_person IN per_all_people_f.person_id%TYPE,
98: p_chunk IN NUMBER) IS
99: BEGIN
100: hr_utility.set_location('Start of Assignment_Action_Code',1);
101: pay_core_payslip_utils.action_creation ( p_payroll_action_id,
102: p_start_person,
103: p_end_person,
104: p_chunk,

Line 107: hr_utility.set_location('End of Assignment_Action_Code',2);

103: p_end_person,
104: p_chunk,
105: 'SG_PAYSLIP_ARCHIVE',
106: 'SG');
107: hr_utility.set_location('End of Assignment_Action_Code',2);
108: EXCEPTION
109: WHEN OTHERS THEN
110: hr_utility.set_location('Error in Assignment_Action_Code',2);
111: RAISE;

Line 110: hr_utility.set_location('Error in Assignment_Action_Code',2);

106: 'SG');
107: hr_utility.set_location('End of Assignment_Action_Code',2);
108: EXCEPTION
109: WHEN OTHERS THEN
110: hr_utility.set_location('Error in Assignment_Action_Code',2);
111: RAISE;
112: END assignment_action_code;
113:
114:

Line 151: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

147: l_procedure_name VARCHAR2(80) ;
148:
149: BEGIN
150: l_procedure_name := 'archive_stat_elements';
151: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
152:
153: FOR csr_rec IN csr_std_elements(p_assignment_action_id,p_assignment_id)
154:
155: LOOP

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

153: FOR csr_rec IN csr_std_elements(p_assignment_action_id,p_assignment_id)
154:
155: LOOP
156:
157: hr_utility.set_location('Archiving Standard Element Details',20);
158:
159: /* Start of Bug No : 2643038 */
160: IF nvl(csr_rec.exchange_rate,0) <> 0 THEN
161: l_foreign_currency_amount := csr_rec.amount / csr_rec.exchange_rate;

Line 197: hr_utility.trace('Closing Cursor csr_std_elements');

193: , p_action_information12 => csr_rec.foreign_currency_code);
194:
195:
196: END LOOP;
197: hr_utility.trace('Closing Cursor csr_std_elements');
198: hr_utility.set_location('End of archive Standard Element',4);
199: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
200:
201: EXCEPTION

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

194:
195:
196: END LOOP;
197: hr_utility.trace('Closing Cursor csr_std_elements');
198: hr_utility.set_location('End of archive Standard Element',4);
199: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
200:
201: EXCEPTION
202: WHEN OTHERS THEN

Line 199: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

195:
196: END LOOP;
197: hr_utility.trace('Closing Cursor csr_std_elements');
198: hr_utility.set_location('End of archive Standard Element',4);
199: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
200:
201: EXCEPTION
202: WHEN OTHERS THEN
203: hr_utility.set_location('Error in archiving Standard Elements ',5);

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

199: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
200:
201: EXCEPTION
202: WHEN OTHERS THEN
203: hr_utility.set_location('Error in archiving Standard Elements ',5);
204: RAISE;
205:
206: END archive_stat_elements;
207:

Line 226: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

222: l_procedure_name VARCHAR2(80);
223:
224: BEGIN
225: l_procedure_name := 'archive_balances';
226: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
227: hr_utility.set_location('archiving balances :',10);
228:
229: -- Archive Statutory balances
230:

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

223:
224: BEGIN
225: l_procedure_name := 'archive_balances';
226: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
227: hr_utility.set_location('archiving balances :',10);
228:
229: -- Archive Statutory balances
230:
231: pay_action_information_api.create_action_information

Line 246: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

242: , p_action_information3 => NULL
243: , p_action_information4 => fnd_number.number_to_canonical(p_ytd) -- Bug 3604110
244: );
245:
246: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
247:
248:
249: EXCEPTION
250: WHEN OTHERS THEN

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

247:
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: hr_utility.set_location('Error in archiving balance :',11);
252: RAISE;
253:
254: END archive_balances;
255:

Line 273: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

269: l_procedure_name VARCHAR2(80);
270:
271: BEGIN
272: l_procedure_name := 'archive_cpf_balances';
273: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
274: hr_utility.set_location('archiving cpf balances :',10);
275:
276: -- Archive CPF balances
277:

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

270:
271: BEGIN
272: l_procedure_name := 'archive_cpf_balances';
273: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
274: hr_utility.set_location('archiving cpf balances :',10);
275:
276: -- Archive CPF balances
277:
278: pay_action_information_api.create_action_information

Line 294: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

290: , p_action_information4 => fnd_number.number_to_canonical(p_curr) -- Bug 3604110
291: , p_action_information5 => fnd_number.number_to_canonical(p_ytd) -- Bug 3604110
292: );
293:
294: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
295:
296:
297: EXCEPTION
298: WHEN OTHERS THEN

Line 299: hr_utility.set_location('Error in archiving CPF_balances :',11);

295:
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: hr_utility.set_location('Error in archiving CPF_balances :',11);
300: RAISE;
301:
302: END archive_cpf_balances;
303:

Line 347: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

343: /* Bug 2824397 */
344:
345: BEGIN
346: l_procedure_name := 'archive_stat_balances';
347: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
348: hr_utility.set_location('Calling balance_total from pay_sg_soe_pkg',20);
349:
350: /* Bug 2824397 */
351: open c_person_id(p_assignment_id);

Line 348: hr_utility.set_location('Calling balance_total from pay_sg_soe_pkg',20);

344:
345: BEGIN
346: l_procedure_name := 'archive_stat_balances';
347: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
348: hr_utility.set_location('Calling balance_total from pay_sg_soe_pkg',20);
349:
350: /* Bug 2824397 */
351: open c_person_id(p_assignment_id);
352: fetch c_person_id into l_person_id;

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

377: );
378:
379: l_narrative := 'Gross Income';
380:
381: hr_utility.set_location('Archiving value for ' || l_narrative,30);
382:
383: archive_balances(p_effective_date =>p_effective_date
384: ,p_assact_id =>p_assact_id
385: ,p_narrative =>l_narrative

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

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

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

397:
398:
399: l_narrative := 'Other Deductions';
400:
401: hr_utility.set_location('Archiving value for ' || l_narrative,50);
402:
403: archive_balances(p_effective_date => p_effective_date
404: ,p_assact_id => p_assact_id
405: ,p_narrative => l_narrative

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

407:
408:
409: l_narrative := 'Net Payment';
410:
411: hr_utility.set_location('Archiving value for ' || l_narrative,60);
412:
413: archive_balances(p_effective_date => p_effective_date
414: ,p_assact_id => p_assact_id
415: ,p_narrative => l_narrative

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

417:
418:
419: l_narrative := 'Non Payroll Payments';
420:
421: hr_utility.set_location('Archiving value for ' || l_narrative,70);
422:
423: archive_balances(p_effective_date => p_effective_date
424: ,p_assact_id => p_assact_id
425: ,p_narrative => l_narrative

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

427:
428:
429: l_narrative := 'Employee';
430:
431: hr_utility.set_location('Archiving value for ' || l_narrative,70);
432:
433: archive_cpf_balances(p_effective_date => p_effective_date
434: ,p_assact_id => p_assact_id
435: ,p_narrative => l_narrative

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

439:
440:
441: l_narrative := 'Employer';
442:
443: hr_utility.set_location('Archiving value for ' || l_narrative,70);
444:
445: archive_cpf_balances(p_effective_date => p_effective_date
446: ,p_assact_id => p_assact_id
447: ,p_narrative => l_narrative

Line 452: hr_utility.set_location('End of Archiving Stat Balances ',100);

448: ,p_curr => l_employer_cpf_current
449: ,p_ytd => l_employer_cpf_ytd);
450:
451:
452: hr_utility.set_location('End of Archiving Stat Balances ',100);
453:
454: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,110);
455:
456: EXCEPTION

Line 454: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,110);

450:
451:
452: hr_utility.set_location('End of Archiving Stat Balances ',100);
453:
454: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,110);
455:
456: EXCEPTION
457: WHEN OTHERS THEN
458: hr_utility.set_location('error in calling archive balance code :',11);

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

454: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,110);
455:
456: EXCEPTION
457: WHEN OTHERS THEN
458: hr_utility.set_location('error in calling archive balance code :',11);
459: RAISE;
460:
461: END archive_stat_balances;
462:

Line 559: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.'|| l_procedure_name,10);

555: l_currency_code VARCHAR2(15);
556:
557: BEGIN
558: l_procedure_name := 'archive_employee_details';
559: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.'|| l_procedure_name,10);
560:
561:
562: -- call generic procedure to retrieve and archive all data for
563: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION

Line 565: hr_utility.trace('Opening Cursor csr_tax_unit_id');

561:
562: -- call generic procedure to retrieve and archive all data for
563: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
564:
565: hr_utility.trace('Opening Cursor csr_tax_unit_id');
566: OPEN csr_tax_unit_id(p_curr_pymt_ass_act_id);
567: FETCH csr_tax_unit_id INTO l_tax_unit_id;
568: CLOSE csr_tax_unit_id;
569: hr_utility.trace('Closing Cursor csr_tax_unit_id');

Line 569: hr_utility.trace('Closing Cursor csr_tax_unit_id');

565: hr_utility.trace('Opening Cursor csr_tax_unit_id');
566: OPEN csr_tax_unit_id(p_curr_pymt_ass_act_id);
567: FETCH csr_tax_unit_id INTO l_tax_unit_id;
568: CLOSE csr_tax_unit_id;
569: hr_utility.trace('Closing Cursor csr_tax_unit_id');
570: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',20);
571:
572: pay_emp_action_arch.get_personal_information
573: (p_payroll_action_id => p_payroll_action_id -- archive payroll_action_id

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

566: OPEN csr_tax_unit_id(p_curr_pymt_ass_act_id);
567: FETCH csr_tax_unit_id INTO l_tax_unit_id;
568: CLOSE csr_tax_unit_id;
569: hr_utility.trace('Closing Cursor csr_tax_unit_id');
570: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',20);
571:
572: pay_emp_action_arch.get_personal_information
573: (p_payroll_action_id => p_payroll_action_id -- archive payroll_action_id
574: , p_assactid => p_assactid -- archive assignment_action_id

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

582: , p_ppp_source_action_id => NULL
583: , p_run_action_id => p_pay_assignment_action_id
584: );
585:
586: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);
587:
588: hr_utility.set_location('Calling update Net Pay Distribution',80);
589:
590: hr_utility.trace('Opening Cursor csr_action_information_id');

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

584: );
585:
586: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);
587:
588: hr_utility.set_location('Calling update Net Pay Distribution',80);
589:
590: hr_utility.trace('Opening Cursor csr_action_information_id');
591:
592: FOR net_pay_rec in csr_action_information_id(p_assactid)

Line 590: hr_utility.trace('Opening Cursor csr_action_information_id');

586: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);
587:
588: hr_utility.set_location('Calling update Net Pay Distribution',80);
589:
590: hr_utility.trace('Opening Cursor csr_action_information_id');
591:
592: FOR net_pay_rec in csr_action_information_id(p_assactid)
593:
594: LOOP

Line 596: hr_utility.trace('Opening Cursor csr_bank_details');

592: FOR net_pay_rec in csr_action_information_id(p_assactid)
593:
594: LOOP
595:
596: hr_utility.trace('Opening Cursor csr_bank_details');
597: OPEN csr_bank_details(p_curr_pymt_ass_act_id , net_pay_rec.action_information2, net_pay_rec.action_information1); /* Bug No : 2538781,2672510 */
598: FETCH csr_bank_details INTO l_account_type /* Bug 5435029 */
599: , l_bank_name
600: , l_percentage

Line 603: hr_utility.trace('Closing Cursor csr_bank_details');

599: , l_bank_name
600: , l_percentage
601: , l_currency_code;
602: CLOSE csr_bank_details;
603: hr_utility.trace('Closing Cursor csr_bank_details');
604:
605: l_ovn := 1;
606:
607: pay_action_information_api.update_action_information

Line 618: hr_utility.trace('Closing Cursor csr_action_information_id');

614: );
615:
616: END LOOP;
617:
618: hr_utility.trace('Closing Cursor csr_action_information_id');
619:
620: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
621:
622: EXCEPTION

Line 620: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

616: END LOOP;
617:
618: hr_utility.trace('Closing Cursor csr_action_information_id');
619:
620: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: hr_utility.set_location('Error in archiving Employee details ',5);

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

620: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: hr_utility.set_location('Error in archiving Employee details ',5);
625: RAISE;
626:
627: END archive_employee_details;
628:

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

691: l_leave_taken NUMBER;
692:
693: BEGIN
694: l_procedure_name := 'archive_employee_details';
695: hr_utility.set_location('Start of accrual archival code',1);
696:
697: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
698:
699: OPEN csr_leave_balance(p_assignment_action_id,p_assignment_id);

Line 697: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

693: BEGIN
694: l_procedure_name := 'archive_employee_details';
695: hr_utility.set_location('Start of accrual archival code',1);
696:
697: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
698:
699: OPEN csr_leave_balance(p_assignment_action_id,p_assignment_id);
700: FETCH csr_leave_balance INTO
701: l_accrual_plan_name,

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

708: CLOSE csr_leave_balance;
709:
710: -- Call to get annual leave balance
711:
712: hr_utility.set_location('Archiving Annual leave Balance information',2);
713:
714: l_annual_leave_balance := pay_sg_soe.net_accrual( p_assignment_id
715: , l_accrual_plan_id
716: , l_payroll_id

Line 725: hr_utility.set_location('Archiving Leave Taken information',2);

721: IF l_annual_leave_balance IS NULL THEN
722: l_annual_leave_balance := 0;
723: END IF;
724:
725: hr_utility.set_location('Archiving Leave Taken information',2);
726:
727: l_leave_taken := per_accrual_calc_functions.get_absence
728: (p_assignment_id,
729: l_accrual_plan_id,

Line 758: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);

754: );
755:
756: END IF;
757:
758: hr_utility.set_location('Leaving Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
759:
760:
761: EXCEPTION
762: WHEN OTHERS THEN

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

759:
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: hr_utility.set_location('Error raised in archiving Accruals and Leave Taken ',5);
764: RAISE;
765:
766: END archive_accrual_details;
767:

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

857: l_pre_pay_assact_id NUMBER :=0;
858: l_payment_date DATE :=NULL;
859:
860: BEGIN
861: hr_utility.set_location('Start of archive code',20);
862: --
863: pay_core_payslip_utils.generate_child_actions( p_assignment_action_id,
864: p_effective_date
865: );

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

935: END IF;
936: l_pre_pay_assact_id := csr_rec.pre_assignment_action_id;
937: END LOOP;
938: --
939: hr_utility.set_location('End of archive code',37);
940: EXCEPTION
941: WHEN OTHERS THEN
942: hr_utility.set_location('Error in archive code :',11);
943: RAISE;

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

938: --
939: hr_utility.set_location('End of archive code',37);
940: EXCEPTION
941: WHEN OTHERS THEN
942: hr_utility.set_location('Error in archive code :',11);
943: RAISE;
944: END archive_code;
945:
946: