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_HK_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

Line 25: g_debug := hr_utility.debug_enabled;

21:
22:
23: BEGIN
24:
25: g_debug := hr_utility.debug_enabled;
26:
27: IF g_debug THEN
28: hr_utility.set_location('Start of range_code',1);
29: END IF;

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

24:
25: g_debug := hr_utility.debug_enabled;
26:
27: IF g_debug THEN
28: hr_utility.set_location('Start of range_code',1);
29: END IF;
30:
31:
32: --------------------------------------------------------------------------------+

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

40: pay_core_payslip_utils.range_cursor( p_payroll_action_id,
41: p_sql
42: );
43: IF g_debug THEN
44: hr_utility.set_location('End of range_code',2);
45: END IF;
46:
47: EXCEPTION
48: WHEN OTHERS THEN

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

46:
47: EXCEPTION
48: WHEN OTHERS THEN
49: IF g_debug THEN
50: hr_utility.set_location('Error in initialization_code',2);
51: END IF;
52: RAISE;
53:
54: END range_code;

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

67:
68:
69: BEGIN
70: IF g_debug THEN
71: hr_utility.set_location('Start of initialization_code',1);
72: END IF;
73:
74: g_archive_pact := p_payroll_action_id;
75:

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

81:
82: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);
83:
84: IF g_debug THEN
85: hr_utility.set_location('End of initialization_code',2);
86: END IF;
87:
88: EXCEPTION
89: WHEN OTHERS THEN

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

87:
88: EXCEPTION
89: WHEN OTHERS THEN
90: IF g_debug THEN
91: hr_utility.set_location('Error in initialization_code',2);
92: END IF;
93: RAISE;
94:
95: END initialization_code;

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

116: p_chunk IN NUMBER) IS
117:
118: BEGIN
119: IF g_debug THEN
120: hr_utility.trace('Start of assignment action code');
121: END IF;
122:
123: -- Bug#3580617 Logic of generating Assignment actions has been replaced with the following
124: -- Function Call.

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

129: p_chunk,
130: 'HK_PAYSLIP_ARCHIVE',
131: 'HK');
132: IF g_debug THEN
133: hr_utility.trace('End of Assignment action code');
134: END IF;
135:
136: EXCEPTION
137: WHEN OTHERS THEN

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

135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: IF g_debug THEN
139: hr_utility.trace('Error occured in Assignment action code');
140: END IF;
141: RAISE;
142:
143: END assignment_action_code;

Line 192: hr_utility.trace('Run Result ID: ' || p_run_result_id);

188: BEGIN
189: l_result_value := null; -- Bug: 3604131
190: --
191: IF g_debug THEN
192: hr_utility.trace('Run Result ID: ' || p_run_result_id);
193: hr_utility.trace('Assignment action ID: '||p_assignment_action_id);
194: hr_utility.trace('Business_group_id: '||p_business_group_id);
195: END IF;
196: --

Line 193: hr_utility.trace('Assignment action ID: '||p_assignment_action_id);

189: l_result_value := null; -- Bug: 3604131
190: --
191: IF g_debug THEN
192: hr_utility.trace('Run Result ID: ' || p_run_result_id);
193: hr_utility.trace('Assignment action ID: '||p_assignment_action_id);
194: hr_utility.trace('Business_group_id: '||p_business_group_id);
195: END IF;
196: --
197: -- If the pl/sql table is not populated previously. Populate

Line 194: hr_utility.trace('Business_group_id: '||p_business_group_id);

190: --
191: IF g_debug THEN
192: hr_utility.trace('Run Result ID: ' || p_run_result_id);
193: hr_utility.trace('Assignment action ID: '||p_assignment_action_id);
194: hr_utility.trace('Business_group_id: '||p_business_group_id);
195: END IF;
196: --
197: -- If the pl/sql table is not populated previously. Populate
198: -- the table with all the scheme names available in this business

Line 205: hr_utility.trace('Scheme Name: ' || csr_sn_rec.scheme_name);

201: IF g_sn_populated = FALSE THEN
202: FOR csr_sn_rec IN csr_scheme_names(p_business_group_id) LOOP
203: g_scheme_name_table(csr_sn_rec.scheme_id).scheme_name := csr_sn_rec.scheme_name;
204: IF g_debug THEN
205: hr_utility.trace('Scheme Name: ' || csr_sn_rec.scheme_name);
206: hr_utility.trace('Scheme ID: ' ||csr_sn_rec.scheme_id);
207: END IF;
208: END LOOP;
209: g_sn_populated := TRUE;

Line 206: hr_utility.trace('Scheme ID: ' ||csr_sn_rec.scheme_id);

202: FOR csr_sn_rec IN csr_scheme_names(p_business_group_id) LOOP
203: g_scheme_name_table(csr_sn_rec.scheme_id).scheme_name := csr_sn_rec.scheme_name;
204: IF g_debug THEN
205: hr_utility.trace('Scheme Name: ' || csr_sn_rec.scheme_name);
206: hr_utility.trace('Scheme ID: ' ||csr_sn_rec.scheme_id);
207: END IF;
208: END LOOP;
209: g_sn_populated := TRUE;
210: END IF;

Line 227: hr_utility.trace('Result Value: '||nvl(l_result_value, ''));

223: FETCH csr_result_value INTO l_result_value;
224: CLOSE csr_result_value;
225:
226: IF g_debug THEN
227: hr_utility.trace('Result Value: '||nvl(l_result_value, ''));
228: END IF;
229:
230: -- 2. If result value is not null
231: -- Check if the scheme name exists.

Line 235: hr_utility.trace('Success : '||g_scheme_name_table(l_result_value).scheme_name);

231: -- Check if the scheme name exists.
232: -------------------------------------------------
233: IF l_result_value is not null AND g_scheme_name_table.exists(l_result_value) THEN
234: IF g_debug THEN
235: hr_utility.trace('Success : '||g_scheme_name_table(l_result_value).scheme_name);
236: END IF;
237: -- 3. Return the scheme name
238: ----------------------------
239: return g_scheme_name_table(l_result_value).scheme_name;

Line 245: hr_utility.trace('Scheme name does not exists');

241:
242: END IF;
243: --
244: IF g_debug THEN
245: hr_utility.trace('Scheme name does not exists');
246: END IF;
247:
248: -- Scheme Name doesn't exists
249: -----------------------------

Line 286: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.' || l_procedure_name,10);

282: BEGIN
283: l_procedure_name := 'archive_stat_elements'; -- Bug: 3604131
284:
285: IF g_debug THEN
286: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
287:
288: hr_utility.trace('Opening Cursor csr_std_elements');
289: END IF;
290:

Line 288: hr_utility.trace('Opening Cursor csr_std_elements');

284:
285: IF g_debug THEN
286: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
287:
288: hr_utility.trace('Opening Cursor csr_std_elements');
289: END IF;
290:
291: FOR csr_rec IN csr_std_elements(p_assignment_action_id,p_assignment_id)
292:

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

292:
293: LOOP
294:
295: IF g_debug THEN
296: hr_utility.set_location('Archiving Standard Element Details',20);
297: END IF;
298:
299:
300: if csr_rec.classification_name<>'Employer Liabilities' then

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

340:
341:
342: END LOOP;
343: IF g_debug THEN
344: hr_utility.trace('Closing Cursor csr_std_elements');
345: hr_utility.set_location('End of archive Standard Element',4);
346: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
347: END IF;
348:

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

341:
342: END LOOP;
343: IF g_debug THEN
344: hr_utility.trace('Closing Cursor csr_std_elements');
345: hr_utility.set_location('End of archive Standard Element',4);
346: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
347: END IF;
348:
349: EXCEPTION

Line 346: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);

342: END LOOP;
343: IF g_debug THEN
344: hr_utility.trace('Closing Cursor csr_std_elements');
345: hr_utility.set_location('End of archive Standard Element',4);
346: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
347: END IF;
348:
349: EXCEPTION
350: WHEN OTHERS THEN

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

348:
349: EXCEPTION
350: WHEN OTHERS THEN
351: IF g_debug THEN
352: hr_utility.set_location('Error in archiving Standard Elements ',5);
353: END IF;
354: RAISE;
355:
356: END archive_stat_elements;

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

375:
376: l_procedure_name := 'archive_balances'; -- Bug: 3604131
377:
378: IF g_debug THEN
379: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
380: hr_utility.set_location('archiving balances :',10);
381: END IF;
382:
383: -- Archive Statutory balances

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

376: l_procedure_name := 'archive_balances'; -- Bug: 3604131
377:
378: IF g_debug THEN
379: hr_utility.set_location('Entering procedure ' || l_procedure_name,10);
380: hr_utility.set_location('archiving balances :',10);
381: END IF;
382:
383: -- Archive Statutory balances
384:

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

401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF g_debug THEN
405: hr_utility.set_location('Error in archiving balance :',11);
406: END IF;
407: RAISE;
408:
409: END archive_balances;

Line 452: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.' || l_procedure_name,10);

448:
449: l_procedure_name := 'Archive_Stat_Balances'; -- Bug: 3604131
450:
451: IF g_debug THEN
452: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
453: hr_utility.set_location('Calling balance_total from pay_hk_soe_pkg',20);
454: END IF;
455:
456: -- Get the totals of all the balances

Line 453: hr_utility.set_location('Calling balance_total from pay_hk_soe_pkg',20);

449: l_procedure_name := 'Archive_Stat_Balances'; -- Bug: 3604131
450:
451: IF g_debug THEN
452: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
453: hr_utility.set_location('Calling balance_total from pay_hk_soe_pkg',20);
454: END IF;
455:
456: -- Get the totals of all the balances
457:

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

475:
476: l_narrative := 'Total Earnings';
477:
478: IF g_debug THEN
479: hr_utility.set_location('Archiving value for ' || l_narrative,30);
480: END IF;
481:
482: /* Archive This Pay values and YTD Values accordingly*/
483:

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

491:
492: l_narrative := 'Total Deductions';
493:
494: IF g_debug THEN
495: hr_utility.set_location('Archiving value for ' || l_narrative,40);
496: END IF;
497:
498: archive_balances(p_effective_date => p_effective_date
499: ,p_assact_id => p_assact_id

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

505:
506: l_narrative := 'Net Pay';
507:
508: IF g_debug THEN
509: hr_utility.set_location('Archiving value for ' || l_narrative,50);
510: END IF;
511:
512: archive_balances(p_effective_date => p_effective_date
513: ,p_assact_id => p_assact_id

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

519:
520: l_narrative := 'Direct Payments';
521:
522: IF g_debug THEN
523: hr_utility.set_location('Archiving value for ' || l_narrative,60);
524: END IF;
525:
526: archive_balances(p_effective_date => p_effective_date
527: ,p_assact_id => p_assact_id

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

532:
533: l_narrative := 'Total Payment';
534:
535: IF g_debug THEN
536: hr_utility.set_location('Archiving value for ' || l_narrative,70);
537: END IF;
538:
539: archive_balances(p_effective_date => p_effective_date
540: ,p_assact_id => p_assact_id

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

544:
545:
546:
547: IF g_debug THEN
548: hr_utility.set_location('End of Archiving Stat Balances ',80);
549:
550: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,90);
551: END IF;
552:

Line 550: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,90);

546:
547: IF g_debug THEN
548: hr_utility.set_location('End of Archiving Stat Balances ',80);
549:
550: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,90);
551: END IF;
552:
553:
554: EXCEPTION

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

553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF g_debug THEN
557: hr_utility.set_location('Error in calling archive balance code :',11);
558: END IF;
559: RAISE;
560:
561: END archive_stat_balances;

Line 672: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.'|| l_procedure_name,10);

668:
669: l_procedure_name := 'archive_employee_details'; -- Bug: 3604131
670:
671: IF g_debug THEN
672: hr_utility.set_location('Entering Procedure pay_hk_payslip_archive.'|| l_procedure_name,10);
673:
674:
675: -- call generic procedure to retrieve and archive all data for
676: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION

Line 678: hr_utility.trace('Opening Cursor csr_payment_runs');

674:
675: -- call generic procedure to retrieve and archive all data for
676: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
677:
678: hr_utility.trace('Opening Cursor csr_payment_runs');
679: END IF;
680:
681: OPEN csr_payment_runs(p_curr_pymt_ass_act_id);
682: FETCH csr_payment_runs INTO l_tax_unit_id,l_mail_stop;

Line 686: hr_utility.trace('Closing Cursor csr_payment_runs');

682: FETCH csr_payment_runs INTO l_tax_unit_id,l_mail_stop;
683: CLOSE csr_payment_runs;
684:
685: IF g_debug THEN
686: hr_utility.trace('Closing Cursor csr_payment_runs');
687:
688: hr_utility.trace('Opening Cursor csr_get mpf date');
689: END IF;
690:

Line 688: hr_utility.trace('Opening Cursor csr_get mpf date');

684:
685: IF g_debug THEN
686: hr_utility.trace('Closing Cursor csr_payment_runs');
687:
688: hr_utility.trace('Opening Cursor csr_get mpf date');
689: END IF;
690:
691: OPEN csr_get_mpf_date(p_payroll_action_id);
692: FETCH csr_get_mpf_date into l_mpf_due_date;

Line 695: hr_utility.trace('Closing Cursor csr get mpf date');

691: OPEN csr_get_mpf_date(p_payroll_action_id);
692: FETCH csr_get_mpf_date into l_mpf_due_date;
693: CLOSE csr_get_mpf_date;
694: IF g_debug THEN
695: hr_utility.trace('Closing Cursor csr get mpf date');
696: END IF;
697:
698: l_mpf_due_date:=to_char(to_date(l_mpf_due_date,'YYYY/MM/DD'),'DD-Mon-YYYY');
699:

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

697:
698: l_mpf_due_date:=to_char(to_date(l_mpf_due_date,'YYYY/MM/DD'),'DD-Mon-YYYY');
699:
700: IF g_debug THEN
701: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',20);
702: END IF;
703:
704: pay_emp_action_arch.get_personal_information
705: (p_payroll_action_id => p_payroll_action_id -- archive payroll_action_id

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

715: , p_run_action_id => p_pay_assignment_action_id
716: );
717:
718: IF g_debug THEN
719: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);
720:
721: -- Retrieve and Archive the HK specific employee details (mailstop)
722:
723: hr_utility.set_location('Archiving HK EMPLOYEE DETAILS',60);

Line 723: hr_utility.set_location('Archiving HK EMPLOYEE DETAILS',60);

719: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',30);
720:
721: -- Retrieve and Archive the HK specific employee details (mailstop)
722:
723: hr_utility.set_location('Archiving HK EMPLOYEE DETAILS',60);
724: END IF;
725:
726: pay_action_information_api.create_action_information
727: ( p_action_information_id => l_action_info_id

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

740: );
741:
742:
743: IF g_debug THEN
744: hr_utility.trace('Opening Cursor csr_action_information_id');
745: END IF;
746:
747: FOR net_pay_rec in csr_action_information_id(p_assactid)
748:

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

747: FOR net_pay_rec in csr_action_information_id(p_assactid)
748:
749: LOOP
750: IF g_debug THEN
751: hr_utility.trace('Opening Cursor csr_bank_details');
752: END IF;
753: OPEN csr_bank_details(p_curr_pymt_ass_act_id,net_pay_rec.action_information2,net_pay_rec.action_information1); /* Bug No : 2672510 */
754: FETCH csr_bank_details INTO l_branch_code
755: ,l_bank_account

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

757:
758:
759: CLOSE csr_bank_details;
760: IF g_debug THEN
761: hr_utility.trace('Closing Cursor csr_bank_details');
762: END IF;
763:
764: l_ovn := 1;
765: l_account:=null;

Line 772: hr_utility.trace('branch code:'||l_branch_code);

768: l_account:=l_branch_code||'-'||l_bank_account;
769: end if;
770:
771: IF g_debug THEN
772: hr_utility.trace('branch code:'||l_branch_code);
773: hr_utility.trace('account number: '||l_bank_account);
774: hr_utility.trace('action information 2:'||net_pay_rec.action_information2);
775: hr_utility.trace('assignment_action_id:'||p_curr_pymt_ass_act_id);
776: hr_utility.trace('Account:'||l_account);

Line 773: hr_utility.trace('account number: '||l_bank_account);

769: end if;
770:
771: IF g_debug THEN
772: hr_utility.trace('branch code:'||l_branch_code);
773: hr_utility.trace('account number: '||l_bank_account);
774: hr_utility.trace('action information 2:'||net_pay_rec.action_information2);
775: hr_utility.trace('assignment_action_id:'||p_curr_pymt_ass_act_id);
776: hr_utility.trace('Account:'||l_account);
777: END IF;

Line 774: hr_utility.trace('action information 2:'||net_pay_rec.action_information2);

770:
771: IF g_debug THEN
772: hr_utility.trace('branch code:'||l_branch_code);
773: hr_utility.trace('account number: '||l_bank_account);
774: hr_utility.trace('action information 2:'||net_pay_rec.action_information2);
775: hr_utility.trace('assignment_action_id:'||p_curr_pymt_ass_act_id);
776: hr_utility.trace('Account:'||l_account);
777: END IF;
778:

Line 775: hr_utility.trace('assignment_action_id:'||p_curr_pymt_ass_act_id);

771: IF g_debug THEN
772: hr_utility.trace('branch code:'||l_branch_code);
773: hr_utility.trace('account number: '||l_bank_account);
774: hr_utility.trace('action information 2:'||net_pay_rec.action_information2);
775: hr_utility.trace('assignment_action_id:'||p_curr_pymt_ass_act_id);
776: hr_utility.trace('Account:'||l_account);
777: END IF;
778:
779:

Line 776: hr_utility.trace('Account:'||l_account);

772: hr_utility.trace('branch code:'||l_branch_code);
773: hr_utility.trace('account number: '||l_bank_account);
774: hr_utility.trace('action information 2:'||net_pay_rec.action_information2);
775: hr_utility.trace('assignment_action_id:'||p_curr_pymt_ass_act_id);
776: hr_utility.trace('Account:'||l_account);
777: END IF;
778:
779:
780: pay_action_information_api.update_action_information

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

787: END LOOP;
788:
789: IF g_debug THEN
790:
791: hr_utility.trace('Closing Cursor csr_action_information_id');
792:
793: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
794: END IF;
795:

Line 793: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);

789: IF g_debug THEN
790:
791: hr_utility.trace('Closing Cursor csr_action_information_id');
792:
793: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
794: END IF;
795:
796: EXCEPTION
797: WHEN OTHERS THEN

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

795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: IF g_debug THEN
799: hr_utility.set_location('Error in archiving Employee details ',5);
800: END IF;
801: RAISE;
802:
803: END archive_employee_details;

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

883:
884: l_procedure_name := 'archive_employee_details'; -- Bug: 3604131
885:
886: IF g_debug THEN
887: hr_utility.set_location('Start of accrual archival code',1);
888:
889: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
890:
891: hr_utility.trace('Opening Cursor csr_leave_balance');

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

885:
886: IF g_debug THEN
887: hr_utility.set_location('Start of accrual archival code',1);
888:
889: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
890:
891: hr_utility.trace('Opening Cursor csr_leave_balance');
892: END IF;
893:

Line 891: hr_utility.trace('Opening Cursor csr_leave_balance');

887: hr_utility.set_location('Start of accrual archival code',1);
888:
889: hr_utility.set_location('Entering Procedure pay_sg_payslip_archive.' || l_procedure_name,10);
890:
891: hr_utility.trace('Opening Cursor csr_leave_balance');
892: END IF;
893:
894: OPEN csr_leave_balance(p_assignment_action_id,p_assignment_id);
895: FETCH csr_leave_balance INTO

Line 906: hr_utility.trace('Closing Cursor csr_leave_balance');

902:
903: CLOSE csr_leave_balance;
904:
905: IF g_debug THEN
906: hr_utility.trace('Closing Cursor csr_leave_balance');
907:
908: -- Call to get annual leave balance
909:
910: hr_utility.set_location('Archiving Annual leave Balance information',2);

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

906: hr_utility.trace('Closing Cursor csr_leave_balance');
907:
908: -- Call to get annual leave balance
909:
910: hr_utility.set_location('Archiving Annual leave Balance information',2);
911: END IF;
912:
913: per_accrual_calc_functions.get_net_accrual( p_assignment_id => p_assignment_id,
914: p_plan_id => l_accrual_plan_id,

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

921: p_accrual => l_accrual,
922: p_net_entitlement => l_net_entitlement);
923:
924: IF g_debug THEN
925: hr_utility.set_location('Archiving Leave Taken information',2);
926: END IF;
927:
928:
929: IF l_accrual_plan_name IS NOT NULL THEN

Line 949: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);

945:
946: END IF;
947:
948: IF g_debug THEN
949: hr_utility.set_location('Leaving Procedure pay_hk_payslip_archive.' || l_procedure_name,10);
950: END IF;
951:
952:
953: EXCEPTION

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

952:
953: EXCEPTION
954: WHEN OTHERS THEN
955: IF g_debug THEN
956: hr_utility.set_location('Error raised in archiving Accruals and Leave Taken ',5);
957: END IF;
958: RAISE;
959:
960: END archive_accrual_details;

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

1055:
1056: l_pre_pay_assact_id := 0; -- Bug: 3604131
1057:
1058: IF g_debug THEN
1059: hr_utility.set_location('Start of archive code',20);
1060: hr_utility.trace('Opening Cursor get_payslip_aa');
1061: END IF;
1062:
1063: -- Bug# 3580617 Included the following function call pay_core_payslip_utils.generate_child_actions.

Line 1060: hr_utility.trace('Opening Cursor get_payslip_aa');

1056: l_pre_pay_assact_id := 0; -- Bug: 3604131
1057:
1058: IF g_debug THEN
1059: hr_utility.set_location('Start of archive code',20);
1060: hr_utility.trace('Opening Cursor get_payslip_aa');
1061: END IF;
1062:
1063: -- Bug# 3580617 Included the following function call pay_core_payslip_utils.generate_child_actions.
1064:

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

1076: end if;
1077: close csr_payment_date;
1078:
1079: IF g_debug THEN
1080: hr_utility.set_location('csr_rec.run_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
1081: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
1082: END IF;
1083:
1084:

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

1077: close csr_payment_date;
1078:
1079: IF g_debug THEN
1080: hr_utility.set_location('csr_rec.run_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
1081: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
1082: END IF;
1083:
1084:
1085: -- Loop to be executed only once for a prepayment with latest payroll run details

Line 1170: hr_utility.trace('Opening Cursor csr_assignment_actions');

1166:
1167: END LOOP;
1168:
1169: IF g_debug THEN
1170: hr_utility.trace('Opening Cursor csr_assignment_actions');
1171:
1172: hr_utility.set_location('End of archive code',37);
1173: END IF;
1174:

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

1168:
1169: IF g_debug THEN
1170: hr_utility.trace('Opening Cursor csr_assignment_actions');
1171:
1172: hr_utility.set_location('End of archive code',37);
1173: END IF;
1174:
1175: EXCEPTION
1176: WHEN OTHERS THEN

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

1174:
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: IF g_debug THEN
1178: hr_utility.set_location('Error in archive code :',11);
1179: END IF;
1180: RAISE;
1181:
1182: END archive_code;