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

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

98: begin
99: l_proc := g_package || 'get_parameters';
100: -- Removed default assignment to remove GSCC warning
101:
102: hr_utility.set_location('Entering ' || l_proc, 10);
103:
104: hr_utility.set_location('Step ' || l_proc, 20);
105: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
106:

Line 104: hr_utility.set_location('Step ' || l_proc, 20);

100: -- Removed default assignment to remove GSCC warning
101:
102: hr_utility.set_location('Entering ' || l_proc, 10);
103:
104: hr_utility.set_location('Step ' || l_proc, 20);
105: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
106:
107: open csr_parameter_info
108: (

Line 105: hr_utility.set_location('p_token_name = ' || p_token_name, 20);

101:
102: hr_utility.set_location('Entering ' || l_proc, 10);
103:
104: hr_utility.set_location('Step ' || l_proc, 20);
105: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
106:
107: open csr_parameter_info
108: (
109: p_payroll_action_id,

Line 125: hr_utility.set_location('l_token_value = ' || p_token_value, 20);

121: p_token_value := l_token_value;
122:
123: end if;
124:
125: hr_utility.set_location('l_token_value = ' || p_token_value, 20);
126: hr_utility.set_location('Leaving ' || l_proc, 30);
127:
128: exception
129: when others then

Line 126: hr_utility.set_location('Leaving ' || l_proc, 30);

122:
123: end if;
124:
125: hr_utility.set_location('l_token_value = ' || p_token_value, 20);
126: hr_utility.set_location('Leaving ' || l_proc, 30);
127:
128: exception
129: when others then
130: p_token_value := null;

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

221: begin
222: l_proc := g_package || 'get_eit_definitions';
223: -- Removed default assignment to remove GSCC warning
224:
225: hr_utility.set_location('Entering ' || l_proc, 10);
226:
227: hr_utility.set_location('Step ' || l_proc, 20);
228: hr_utility.set_location('p_eit_context = ' || p_eit_context, 20);
229:

Line 227: hr_utility.set_location('Step ' || l_proc, 20);

223: -- Removed default assignment to remove GSCC warning
224:
225: hr_utility.set_location('Entering ' || l_proc, 10);
226:
227: hr_utility.set_location('Step ' || l_proc, 20);
228: hr_utility.set_location('p_eit_context = ' || p_eit_context, 20);
229:
230: -- Loop through all the Org Developer Flex values for the specified context
231: for csr_eit_rec in csr_eit_values

Line 228: hr_utility.set_location('p_eit_context = ' || p_eit_context, 20);

224:
225: hr_utility.set_location('Entering ' || l_proc, 10);
226:
227: hr_utility.set_location('Step ' || l_proc, 20);
228: hr_utility.set_location('p_eit_context = ' || p_eit_context, 20);
229:
230: -- Loop through all the Org Developer Flex values for the specified context
231: for csr_eit_rec in csr_eit_values
232: (

Line 238: hr_utility.set_location('Step ' || l_proc, 30);

234: p_eit_context
235: )
236: loop
237:
238: hr_utility.set_location('Step ' || l_proc, 30);
239:
240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);
241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);

Line 240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);

236: loop
237:
238: hr_utility.set_location('Step ' || l_proc, 30);
239:
240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);
241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);
243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);
244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);

Line 241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);

237:
238: hr_utility.set_location('Step ' || l_proc, 30);
239:
240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);
241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);
243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);
244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);
245: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6, 30);

Line 242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);

238: hr_utility.set_location('Step ' || l_proc, 30);
239:
240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);
241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);
243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);
244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);
245: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6, 30);
246:

Line 243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);

239:
240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);
241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);
243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);
244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);
245: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6, 30);
246:
247: -- Business Group Level Balances

Line 244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);

240: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1, 30);
241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);
243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);
244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);
245: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6, 30);
246:
247: -- Business Group Level Balances
248: if p_eit_context = g_balance_context then

Line 245: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6, 30);

241: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2, 30);
242: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3, 30);
243: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4, 30);
244: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5, 30);
245: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6, 30);
246:
247: -- Business Group Level Balances
248: if p_eit_context = g_balance_context then
249:

Line 269: hr_utility.set_location('g_user_balance_table(l_index).balance_name = ' ||

265: g_user_balance_table(l_index).defined_balance_id;
266:
267: close csr_balance_name;
268:
269: hr_utility.set_location('g_user_balance_table(l_index).balance_name = ' ||
270: g_user_balance_table(l_index).balance_name, 50);
271:
272: hr_utility.set_location('Arch EMEA BALANCE DEFINITION', 99);
273:

Line 272: hr_utility.set_location('Arch EMEA BALANCE DEFINITION', 99);

268:
269: hr_utility.set_location('g_user_balance_table(l_index).balance_name = ' ||
270: g_user_balance_table(l_index).balance_name, 50);
271:
272: hr_utility.set_location('Arch EMEA BALANCE DEFINITION', 99);
273:
274: -- Archive the balance definition in 'EMEA BALANCE DEFINITION' if archive is Y
275: if p_archive = 'Y' then
276:

Line 331: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION', 99);

327: -- Archive the element definition in 'EMEA ELEMENT DEFINITION' if archive is Y
328: -- Note: These are the elements on the Organization Developer Flexfield only
329: if p_archive = 'Y' then
330:
331: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION', 99);
332:
333: pay_action_information_api.create_action_information
334: (
335: p_action_information_id => l_action_info_id,

Line 357: hr_utility.set_location('l_index = ' || l_index, 99);

353: end if;
354:
355: l_index := l_index + 1;
356:
357: hr_utility.set_location('l_index = ' || l_index, 99);
358:
359: end loop;
360:
361: g_max_element_index := l_index;

Line 373: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index, 99);

369: g_element_archive_index := l_index - 1;
370:
371: end if;
372:
373: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index, 99);
374:
375: hr_utility.set_location('Leaving ' || l_proc, 30);
376:
377: end get_eit_definitions;

Line 375: hr_utility.set_location('Leaving ' || l_proc, 30);

371: end if;
372:
373: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index, 99);
374:
375: hr_utility.set_location('Leaving ' || l_proc, 30);
376:
377: end get_eit_definitions;
378:
379: procedure setup_element_definitions

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

442: begin
443: l_proc := g_package || 'setup_element_definitions';
444: -- Removed default assignment to remove GSCC warning
445:
446: hr_utility.set_location('Entering ' || l_proc, 10);
447: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact, 10);
448:
449: -- Loop through all elements for the specified Prepayment and Classifications
450: for csr_element_rec in csr_element_name(p_payroll_pact) loop -- Payroll Action of Prepayments

Line 447: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact, 10);

443: l_proc := g_package || 'setup_element_definitions';
444: -- Removed default assignment to remove GSCC warning
445:
446: hr_utility.set_location('Entering ' || l_proc, 10);
447: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact, 10);
448:
449: -- Loop through all elements for the specified Prepayment and Classifications
450: for csr_element_rec in csr_element_name(p_payroll_pact) loop -- Payroll Action of Prepayments
451:

Line 452: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id, 20);

448:
449: -- Loop through all elements for the specified Prepayment and Classifications
450: for csr_element_rec in csr_element_name(p_payroll_pact) loop -- Payroll Action of Prepayments
451:
452: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id, 20);
453: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name, 20);
454:
455: -- Classify the Element according to Classification
456: -- FIX which classifications should i use?

Line 453: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name, 20);

449: -- Loop through all elements for the specified Prepayment and Classifications
450: for csr_element_rec in csr_element_name(p_payroll_pact) loop -- Payroll Action of Prepayments
451:
452: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id, 20);
453: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name, 20);
454:
455: -- Classify the Element according to Classification
456: -- FIX which classifications should i use?
457: if csr_element_rec.classification_name in ('Normal Income', 'Allowances', 'Direct Payments', 'Lump Sum Amounts') then

Line 471: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION', 99);

467: l_payment_type := 'D'; -- Deduction
468:
469: end if;
470:
471: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION', 99);
472:
473: -- Archive the element definition in 'EMEA ELEMENT DEFINITION'
474: -- Note: These are the Elements from the above Classifications and not the ones on the Org Flex
475: pay_action_information_api.create_action_information

Line 495: hr_utility.set_location('Leaving ' || l_proc, 30);

491: );
492:
493: end loop;
494:
495: hr_utility.set_location('Leaving ' || l_proc, 30);
496:
497: end setup_element_definitions;
498:
499: procedure setup_standard_balance_table is

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

535: l_dimension := '_ASG_TAX_YTD';
536: l_proc := g_package || 'setup_standard_balance_table';
537: -- Removed default assignment to remove GSCC warning
538:
539: hr_utility.set_location('Entering ' || l_proc, 10);
540: hr_utility.set_location('Step ' || l_proc, 20);
541:
542: l_statutory_balance(1 ).balance_name := 'Taxable Income RFI';
543: l_statutory_balance(2 ).balance_name := 'Taxable Income PKG';

Line 540: hr_utility.set_location('Step ' || l_proc, 20);

536: l_proc := g_package || 'setup_standard_balance_table';
537: -- Removed default assignment to remove GSCC warning
538:
539: hr_utility.set_location('Entering ' || l_proc, 10);
540: hr_utility.set_location('Step ' || l_proc, 20);
541:
542: l_statutory_balance(1 ).balance_name := 'Taxable Income RFI';
543: l_statutory_balance(2 ).balance_name := 'Taxable Income PKG';
544: l_statutory_balance(3 ).balance_name := 'Taxable Income NRFI';

Line 755: hr_utility.set_location('Step = ' || l_proc, 30);

751: l_statutory_balance(204).balance_name := 'Retire Pen RAF Prov Fund Ben on Ret or Death NRFI';
752: l_statutory_balance(205).balance_name := 'Tax on Retirement Fund Lump Sums';
753: -- End: TYE 08 Changes
754:
755: hr_utility.set_location('Step = ' || l_proc, 30);
756:
757: for l_index in 1..l_max_stat_balance loop
758:
759: hr_utility.set_location('l_index = ' || l_index, 30);

Line 759: hr_utility.set_location('l_index = ' || l_index, 30);

755: hr_utility.set_location('Step = ' || l_proc, 30);
756:
757: for l_index in 1..l_max_stat_balance loop
758:
759: hr_utility.set_location('l_index = ' || l_index, 30);
760: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name, 30);
761: hr_utility.set_location('l_dimension = ' || l_dimension, 30);
762:
763: open csr_balance_dimension(l_statutory_balance(l_index).balance_name, l_dimension);

Line 760: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name, 30);

756:
757: for l_index in 1..l_max_stat_balance loop
758:
759: hr_utility.set_location('l_index = ' || l_index, 30);
760: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name, 30);
761: hr_utility.set_location('l_dimension = ' || l_dimension, 30);
762:
763: open csr_balance_dimension(l_statutory_balance(l_index).balance_name, l_dimension);
764: fetch csr_balance_dimension

Line 761: hr_utility.set_location('l_dimension = ' || l_dimension, 30);

757: for l_index in 1..l_max_stat_balance loop
758:
759: hr_utility.set_location('l_index = ' || l_index, 30);
760: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name, 30);
761: hr_utility.set_location('l_dimension = ' || l_dimension, 30);
762:
763: open csr_balance_dimension(l_statutory_balance(l_index).balance_name, l_dimension);
764: fetch csr_balance_dimension
765: into l_statutory_bal_id(l_index).defined_balance_id;

Line 775: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 30);

771: end if;
772:
773: close csr_balance_dimension;
774:
775: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 30);
776:
777: end loop;
778:
779: hr_utility.set_location('Step = ' || l_proc, 40);

Line 779: hr_utility.set_location('Step = ' || l_proc, 40);

775: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 30);
776:
777: end loop;
778:
779: hr_utility.set_location('Step = ' || l_proc, 40);
780:
781: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance, 40);
782: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index, 40);
783:

Line 781: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance, 40);

777: end loop;
778:
779: hr_utility.set_location('Step = ' || l_proc, 40);
780:
781: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance, 40);
782: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index, 40);
783:
784: for l_index in 1..l_max_stat_balance loop
785:

Line 782: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index, 40);

778:
779: hr_utility.set_location('Step = ' || l_proc, 40);
780:
781: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance, 40);
782: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index, 40);
783:
784: for l_index in 1..l_max_stat_balance loop
785:
786: l_found := 'N';

Line 790: hr_utility.set_location('l_index = ' || l_index, 40);

786: l_found := 'N';
787:
788: for l_eit_index in 1..g_max_user_balance_index loop
789:
790: hr_utility.set_location('l_index = ' || l_index, 40);
791: hr_utility.set_location('l_eit_index = ' || l_eit_index, 40);
792: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 40);
793: hr_utility.set_location('l_found = ' || l_found, 40);
794:

Line 791: hr_utility.set_location('l_eit_index = ' || l_eit_index, 40);

787:
788: for l_eit_index in 1..g_max_user_balance_index loop
789:
790: hr_utility.set_location('l_index = ' || l_index, 40);
791: hr_utility.set_location('l_eit_index = ' || l_eit_index, 40);
792: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 40);
793: hr_utility.set_location('l_found = ' || l_found, 40);
794:
795: if l_statutory_bal_id(l_index).defined_balance_id

Line 792: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 40);

788: for l_eit_index in 1..g_max_user_balance_index loop
789:
790: hr_utility.set_location('l_index = ' || l_index, 40);
791: hr_utility.set_location('l_eit_index = ' || l_eit_index, 40);
792: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 40);
793: hr_utility.set_location('l_found = ' || l_found, 40);
794:
795: if l_statutory_bal_id(l_index).defined_balance_id
796: = g_user_balance_table(l_eit_index).defined_balance_id then

Line 793: hr_utility.set_location('l_found = ' || l_found, 40);

789:
790: hr_utility.set_location('l_index = ' || l_index, 40);
791: hr_utility.set_location('l_eit_index = ' || l_eit_index, 40);
792: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id, 40);
793: hr_utility.set_location('l_found = ' || l_found, 40);
794:
795: if l_statutory_bal_id(l_index).defined_balance_id
796: = g_user_balance_table(l_eit_index).defined_balance_id then
797:

Line 806: hr_utility.set_location('l_archive_index = ' || l_archive_index, 40);

802: end loop;
803:
804: if l_found = 'N' then
805:
806: hr_utility.set_location('l_archive_index = ' || l_archive_index, 40);
807:
808: l_archive_index := l_archive_index + 1;
809: g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_index).defined_balance_id;
810:

Line 817: hr_utility.set_location('Step ' || l_proc, 50);

813: end loop;
814:
815: g_max_statutory_balance_index := l_archive_index;
816:
817: hr_utility.set_location('Step ' || l_proc, 50);
818: hr_utility.set_location('l_archive_index = ' || l_archive_index, 50);
819:
820: hr_utility.set_location('Leaving ' || l_proc, 60);
821:

Line 818: hr_utility.set_location('l_archive_index = ' || l_archive_index, 50);

814:
815: g_max_statutory_balance_index := l_archive_index;
816:
817: hr_utility.set_location('Step ' || l_proc, 50);
818: hr_utility.set_location('l_archive_index = ' || l_archive_index, 50);
819:
820: hr_utility.set_location('Leaving ' || l_proc, 60);
821:
822: end setup_standard_balance_table;

Line 820: hr_utility.set_location('Leaving ' || l_proc, 60);

816:
817: hr_utility.set_location('Step ' || l_proc, 50);
818: hr_utility.set_location('l_archive_index = ' || l_archive_index, 50);
819:
820: hr_utility.set_location('Leaving ' || l_proc, 60);
821:
822: end setup_standard_balance_table;
823:
824: procedure arch_za_pay_action_level_data(

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

881: begin
882: l_proc := g_package || 'arch_za_pay_action_level_data';
883: -- Removed default assignment to remove GSCC warning
884:
885: hr_utility.set_location('Entering ' || l_proc, 10);
886:
887: hr_utility.set_location('Step ' || l_proc, 20);
888:
889: for rec_get_organization in csr_get_organization(p_payroll_id,p_effective_date)

Line 887: hr_utility.set_location('Step ' || l_proc, 20);

883: -- Removed default assignment to remove GSCC warning
884:
885: hr_utility.set_location('Entering ' || l_proc, 10);
886:
887: hr_utility.set_location('Step ' || l_proc, 20);
888:
889: for rec_get_organization in csr_get_organization(p_payroll_id,p_effective_date)
890:
891: loop

Line 936: hr_utility.set_location('Leaving ' || l_proc, 30);

932: );
933:
934: end loop;
935:
936: hr_utility.set_location('Leaving ' || l_proc, 30);
937:
938: end arch_za_pay_action_level_data;
939:
940: procedure update_employee_information(

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

975:
976: begin
977: l_proc := g_package || 'update_employee_information';
978: -- Removed default assignment to remove GSCC warning
979: hr_utility.set_location('Entering ' || l_proc, 10);
980:
981: hr_utility.set_location('Step ' || l_proc, 20);
982:
983: open csr_get_archive_info(p_action_context_id,p_assignment_id);

Line 981: hr_utility.set_location('Step ' || l_proc, 20);

977: l_proc := g_package || 'update_employee_information';
978: -- Removed default assignment to remove GSCC warning
979: hr_utility.set_location('Entering ' || l_proc, 10);
980:
981: hr_utility.set_location('Step ' || l_proc, 20);
982:
983: open csr_get_archive_info(p_action_context_id,p_assignment_id);
984:
985: loop

Line 1021: hr_utility.set_location('Leaving ' || l_proc, 30);

1017:
1018: end loop;
1019: close csr_get_archive_info;
1020:
1021: hr_utility.set_location('Leaving ' || l_proc, 30);
1022:
1023: end update_employee_information;
1024:
1025: -- This procedure gets called third to do initialization.

Line 1087: -- hr_utility.trace_on(null,'ZA_SOE');

1083: begin
1084: l_proc := g_package || 'archinit';
1085: -- Removed default assignment to remove GSCC warning
1086:
1087: -- hr_utility.trace_on(null,'ZA_SOE');
1088: hr_utility.set_location('Entering ' || l_proc, 10);
1089:
1090: g_archive_pact := p_payroll_action_id; -- Payroll Action of the Archiver
1091:

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

1084: l_proc := g_package || 'archinit';
1085: -- Removed default assignment to remove GSCC warning
1086:
1087: -- hr_utility.trace_on(null,'ZA_SOE');
1088: hr_utility.set_location('Entering ' || l_proc, 10);
1089:
1090: g_archive_pact := p_payroll_action_id; -- Payroll Action of the Archiver
1091:
1092: -- Get the effective date of the payroll action

Line 1140: hr_utility.set_location('Step ' || l_proc, 20);

1136: p_token_name => 'BG_ID',
1137: p_token_value => l_bg_id
1138: );
1139:
1140: hr_utility.set_location('Step ' || l_proc, 20);
1141: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1142: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1143: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1144:

Line 1141: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);

1137: p_token_value => l_bg_id
1138: );
1139:
1140: hr_utility.set_location('Step ' || l_proc, 20);
1141: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1142: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1143: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1144:
1145: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');

Line 1142: hr_utility.set_location('l_start_date = ' || l_start_date, 20);

1138: );
1139:
1140: hr_utility.set_location('Step ' || l_proc, 20);
1141: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1142: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1143: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1144:
1145: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
1146: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');

Line 1143: hr_utility.set_location('l_end_date = ' || l_end_date, 20);

1139:
1140: hr_utility.set_location('Step ' || l_proc, 20);
1141: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1142: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1143: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1144:
1145: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
1146: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
1147:

Line 1153: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);

1149: open csr_input_value_id('ZA_Tax','Tax Status');
1150: fetch csr_input_value_id into g_tax_element_id;
1151: close csr_input_value_id;
1152:
1153: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1154: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set, 20);
1155: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date, 20);
1156: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date, 20);
1157:

Line 1154: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set, 20);

1150: fetch csr_input_value_id into g_tax_element_id;
1151: close csr_input_value_id;
1152:
1153: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1154: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set, 20);
1155: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date, 20);
1156: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date, 20);
1157:
1158: -- Loop through all the prepayments for the specified parameters

Line 1155: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date, 20);

1151: close csr_input_value_id;
1152:
1153: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1154: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set, 20);
1155: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date, 20);
1156: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date, 20);
1157:
1158: -- Loop through all the prepayments for the specified parameters
1159: for rec_payroll_info in csr_payroll_info

Line 1156: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date, 20);

1152:
1153: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1154: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set, 20);
1155: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date, 20);
1156: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date, 20);
1157:
1158: -- Loop through all the prepayments for the specified parameters
1159: for rec_payroll_info in csr_payroll_info
1160: (

Line 1172: hr_utility.set_location('get_eit_definitions - balances', 20);

1168: -- Retrieve and archive user definitions from EITs
1169: -- The definitions are archived again for each prepayment
1170: g_max_user_balance_index := 0;
1171:
1172: hr_utility.set_location('get_eit_definitions - balances', 20);
1173:
1174: pay_za_payslip_archive.get_eit_definitions
1175: (
1176: p_pactid => p_payroll_action_id, -- Payroll Action of the Archiver

Line 1184: hr_utility.set_location('get_eit_definitions - elements', 20);

1180: p_eit_context => g_balance_context,
1181: p_archive => 'N'
1182: );
1183:
1184: hr_utility.set_location('get_eit_definitions - elements', 20);
1185:
1186: pay_za_payslip_archive.get_eit_definitions
1187: (
1188: p_pactid => p_payroll_action_id, -- Payroll Action of the Archiver

Line 1210: hr_utility.set_location('Leaving ' || l_proc, 20);

1206:
1207: -- Setup statutory balances pl/sql table
1208: pay_za_payslip_archive.setup_standard_balance_table;
1209:
1210: hr_utility.set_location('Leaving ' || l_proc, 20);
1211:
1212: end archinit;
1213:
1214: procedure archive_employee_details

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

1235:
1236: begin
1237: l_proc := g_package || 'archive_employee_details';
1238: -- Removed default assignment to remove GSCC warning
1239: hr_utility.set_location('Entering ' || l_proc, 10);
1240:
1241: -- Call generic procedure to retrieve and archive all data for
1242: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1243: hr_utility.set_location('Calling pay_emp_action_arch', 20);

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

1239: hr_utility.set_location('Entering ' || l_proc, 10);
1240:
1241: -- Call generic procedure to retrieve and archive all data for
1242: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1243: hr_utility.set_location('Calling pay_emp_action_arch', 20);
1244:
1245: -- Archive Employee Details through core package
1246: pay_emp_action_arch.get_personal_information
1247: (

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

1256: p_time_period_id => p_time_period_id, -- payroll time_period_id
1257: p_ppp_source_action_id => null
1258: );
1259:
1260: hr_utility.set_location('Returned from pay_emp_action_arch', 30);
1261:
1262: -- Call procedure to archive ZA specific data in generic EMPLOYEE DETAILS
1263:
1264: hr_utility.set_location('Calling update_employee_information', 40);

Line 1264: hr_utility.set_location('Calling update_employee_information', 40);

1260: hr_utility.set_location('Returned from pay_emp_action_arch', 30);
1261:
1262: -- Call procedure to archive ZA specific data in generic EMPLOYEE DETAILS
1263:
1264: hr_utility.set_location('Calling update_employee_information', 40);
1265:
1266: update_employee_information
1267: (
1268: p_action_context_id => p_assactid,

Line 1272: hr_utility.set_location('Returned from update_employee_information', 50);

1268: p_action_context_id => p_assactid,
1269: p_assignment_id => p_assignment_id
1270: );
1271:
1272: hr_utility.set_location('Returned from update_employee_information', 50);
1273:
1274: -- Retrieve the ZA specific employee details
1275: -- Person Id
1276: select max(person_id)

Line 1365: hr_utility.set_location('Archiving ZA EMPLOYEE DETAILS', 50);

1361: l_termination_date := null;
1362:
1363: end;
1364:
1365: hr_utility.set_location('Archiving ZA EMPLOYEE DETAILS', 50);
1366:
1367: -- Archive the ZA specific employee details
1368: pay_action_information_api.create_action_information
1369: (

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

1409:
1410: begin
1411: l_proc := g_package || 'process_balance';
1412: -- Removed default assignment to remove GSCC warning
1413: hr_utility.set_location('Entering ' || l_proc, 10);
1414:
1415: hr_utility.set_location('Step ' || l_proc, 20);
1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);
1417: hr_utility.set_location('p_balance = ' || p_balance, 20);

Line 1415: hr_utility.set_location('Step ' || l_proc, 20);

1411: l_proc := g_package || 'process_balance';
1412: -- Removed default assignment to remove GSCC warning
1413: hr_utility.set_location('Entering ' || l_proc, 10);
1414:
1415: hr_utility.set_location('Step ' || l_proc, 20);
1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);
1417: hr_utility.set_location('p_balance = ' || p_balance, 20);
1418: hr_utility.set_location('p_dimension = ' || p_dimension, 20);
1419: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id, 20);

Line 1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);

1412: -- Removed default assignment to remove GSCC warning
1413: hr_utility.set_location('Entering ' || l_proc, 10);
1414:
1415: hr_utility.set_location('Step ' || l_proc, 20);
1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);
1417: hr_utility.set_location('p_balance = ' || p_balance, 20);
1418: hr_utility.set_location('p_dimension = ' || p_dimension, 20);
1419: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id, 20);
1420:

Line 1417: hr_utility.set_location('p_balance = ' || p_balance, 20);

1413: hr_utility.set_location('Entering ' || l_proc, 10);
1414:
1415: hr_utility.set_location('Step ' || l_proc, 20);
1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);
1417: hr_utility.set_location('p_balance = ' || p_balance, 20);
1418: hr_utility.set_location('p_dimension = ' || p_dimension, 20);
1419: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id, 20);
1420:
1421: l_balance_value := pay_balance_pkg.get_value

Line 1418: hr_utility.set_location('p_dimension = ' || p_dimension, 20);

1414:
1415: hr_utility.set_location('Step ' || l_proc, 20);
1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);
1417: hr_utility.set_location('p_balance = ' || p_balance, 20);
1418: hr_utility.set_location('p_dimension = ' || p_dimension, 20);
1419: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id, 20);
1420:
1421: l_balance_value := pay_balance_pkg.get_value
1422: (

Line 1419: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id, 20);

1415: hr_utility.set_location('Step ' || l_proc, 20);
1416: hr_utility.set_location('p_source_id = ' || p_source_id, 20);
1417: hr_utility.set_location('p_balance = ' || p_balance, 20);
1418: hr_utility.set_location('p_dimension = ' || p_dimension, 20);
1419: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id, 20);
1420:
1421: l_balance_value := pay_balance_pkg.get_value
1422: (
1423: p_defined_balance_id => p_defined_bal_id,

Line 1427: hr_utility.set_location('l_balance_value = ' || l_balance_value, 20);

1423: p_defined_balance_id => p_defined_bal_id,
1424: p_assignment_action_id => p_source_id
1425: );
1426:
1427: hr_utility.set_location('l_balance_value = ' || l_balance_value, 20);
1428:
1429: if p_record_count = 0 then
1430:
1431: l_record_count := null;

Line 1441: hr_utility.set_location('Archiving EMEA BALANCES', 20);

1437: end if;
1438:
1439: if l_balance_value <> 0 then
1440:
1441: hr_utility.set_location('Archiving EMEA BALANCES', 20);
1442:
1443: pay_action_information_api.create_action_information
1444: (
1445: p_action_information_id => l_action_info_id,

Line 1463: hr_utility.set_location('Leaving ' || l_proc, 30);

1459: );
1460:
1461: end if;
1462:
1463: hr_utility.set_location('Leaving ' || l_proc, 30);
1464:
1465: exception
1466: when no_data_found then
1467: null;

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

1508:
1509: l_proc := g_package || 'get_element_info';
1510: -- Removed default assignment to remove GSCC warning
1511:
1512: hr_utility.set_location('Entering ' || l_proc, 10);
1513:
1514: l_column_sequence := 0;
1515: l_element_type_id := 0;
1516: l_main_sequence := 0;

Line 1529: hr_utility.set_location('g_max_element_index = ' || g_max_element_index, 10);

1525: l_record_count := p_record_count + 1;
1526:
1527: end if;
1528:
1529: hr_utility.set_location('g_max_element_index = ' || g_max_element_index, 10);
1530:
1531: for l_index in 1 .. g_max_element_index loop
1532:
1533: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);

Line 1533: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);

1529: hr_utility.set_location('g_max_element_index = ' || g_max_element_index, 10);
1530:
1531: for l_index in 1 .. g_max_element_index loop
1532:
1533: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);
1534: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);
1535: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action, 10);
1536:
1537: for rec_element_value in csr_element_values

Line 1534: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);

1530:
1531: for l_index in 1 .. g_max_element_index loop
1532:
1533: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);
1534: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);
1535: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action, 10);
1536:
1537: for rec_element_value in csr_element_values
1538: (

Line 1535: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action, 10);

1531: for l_index in 1 .. g_max_element_index loop
1532:
1533: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);
1534: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);
1535: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action, 10);
1536:
1537: for rec_element_value in csr_element_values
1538: (
1539: p_child_assignment_action,

Line 1546: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);

1542: )
1543:
1544: loop
1545:
1546: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);
1547: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);
1548: hr_utility.set_location('Archiving EMEA ELEMENT INFO', 20);
1549:
1550: if l_element_type_id <> g_element_table(l_index).element_type_id then

Line 1547: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);

1543:
1544: loop
1545:
1546: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);
1547: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);
1548: hr_utility.set_location('Archiving EMEA ELEMENT INFO', 20);
1549:
1550: if l_element_type_id <> g_element_table(l_index).element_type_id then
1551:

Line 1548: hr_utility.set_location('Archiving EMEA ELEMENT INFO', 20);

1544: loop
1545:
1546: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id, 10);
1547: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id, 10);
1548: hr_utility.set_location('Archiving EMEA ELEMENT INFO', 20);
1549:
1550: if l_element_type_id <> g_element_table(l_index).element_type_id then
1551:
1552: l_main_sequence := l_main_sequence + 1;

Line 1556: hr_utility.set_location('l_main_sequence = ' || l_main_sequence, 20);

1552: l_main_sequence := l_main_sequence + 1;
1553:
1554: end if;
1555:
1556: hr_utility.set_location('l_main_sequence = ' || l_main_sequence, 20);
1557:
1558: l_column_sequence := l_column_sequence + 1;
1559:
1560: -- If the run method is P, Process Separate, then only archive the data if

Line 1744: --hr_utility.trace_on(null, 'ZA_SOE');

1740: begin
1741: l_legislation_code := 'ZA';
1742: -- Removed default assignment to remove GSCC warning
1743: --
1744: --hr_utility.trace_on(null, 'ZA_SOE');
1745: hr_utility.set_location('Entering ' || l_proc, 10);
1746:
1747: -- Retrieve the legislative parameters from the payroll action
1748: pay_za_payslip_archive.get_parameters

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

1741: l_legislation_code := 'ZA';
1742: -- Removed default assignment to remove GSCC warning
1743: --
1744: --hr_utility.trace_on(null, 'ZA_SOE');
1745: hr_utility.set_location('Entering ' || l_proc, 10);
1746:
1747: -- Retrieve the legislative parameters from the payroll action
1748: pay_za_payslip_archive.get_parameters
1749: (

Line 1790: hr_utility.set_location('Step ' || l_proc, 20);

1786: p_token_name => 'BG_ID',
1787: p_token_value => l_bg_id
1788: );
1789:
1790: hr_utility.set_location('Step ' || l_proc, 20);
1791: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1792: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1793: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1794:

Line 1791: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);

1787: p_token_value => l_bg_id
1788: );
1789:
1790: hr_utility.set_location('Step ' || l_proc, 20);
1791: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1792: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1793: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1794:
1795: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');

Line 1792: hr_utility.set_location('l_start_date = ' || l_start_date, 20);

1788: );
1789:
1790: hr_utility.set_location('Step ' || l_proc, 20);
1791: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1792: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1793: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1794:
1795: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');
1796: l_canonical_end_date := to_date(l_end_date, 'yyyy/mm/dd');

Line 1793: hr_utility.set_location('l_end_date = ' || l_end_date, 20);

1789:
1790: hr_utility.set_location('Step ' || l_proc, 20);
1791: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
1792: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
1793: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
1794:
1795: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');
1796: l_canonical_end_date := to_date(l_end_date, 'yyyy/mm/dd');
1797:

Line 1799: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);

1795: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');
1796: l_canonical_end_date := to_date(l_end_date, 'yyyy/mm/dd');
1797:
1798: -- Archive EMEA PAYROLL INFO for each prepayment run identified
1799: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1800: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1801: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1802: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1803: --

Line 1800: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);

1796: l_canonical_end_date := to_date(l_end_date, 'yyyy/mm/dd');
1797:
1798: -- Archive EMEA PAYROLL INFO for each prepayment run identified
1799: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1800: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1801: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1802: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1803: --
1804: -- Loop through all the prepayments for the specified parameters that has not been archived yet

Line 1801: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);

1797:
1798: -- Archive EMEA PAYROLL INFO for each prepayment run identified
1799: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1800: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1801: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1802: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1803: --
1804: -- Loop through all the prepayments for the specified parameters that has not been archived yet
1805: for rec_payroll_info in csr_payroll_info

Line 1802: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);

1798: -- Archive EMEA PAYROLL INFO for each prepayment run identified
1799: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1800: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1801: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1802: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1803: --
1804: -- Loop through all the prepayments for the specified parameters that has not been archived yet
1805: for rec_payroll_info in csr_payroll_info
1806: (l_payroll_id

Line 1856: hr_utility.set_location('Calling arch_pay_action_level_data', 25);

1852: ,l_consolidation_set
1853: ,l_canonical_end_date)
1854: LOOP
1855: -- Start Bug No 3436989 passing rec_payrolls.payroll_id parameter instead of l_payroll_id
1856: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
1857: pay_emp_action_arch.arch_pay_action_level_data
1858: (p_payroll_action_id => pactid
1859: ,p_payroll_id => rec_payrolls.payroll_id -- l_payroll_id
1860: ,p_effective_date => l_canonical_end_date

Line 1863: hr_utility.set_location('Calling arch_za_pay_action_level_data', 27);

1859: ,p_payroll_id => rec_payrolls.payroll_id -- l_payroll_id
1860: ,p_effective_date => l_canonical_end_date
1861: );
1862:
1863: hr_utility.set_location('Calling arch_za_pay_action_level_data', 27);
1864: arch_za_pay_action_level_data
1865: (p_payroll_action_id => pactid
1866: ,p_payroll_id => rec_payrolls.payroll_id -- l_payroll_id
1867: ,p_effective_date => l_canonical_end_date

Line 1894: hr_utility.set_location('Calling arch_pay_action_level_data', 25);

1890: );
1891: --
1892: --
1893: -- Added for Bug 4153551
1894: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
1895: pay_emp_action_arch.arch_pay_action_level_data(
1896: p_payroll_action_id => pactid
1897: ,p_payroll_id => rec_payroll_info.payroll_id -- l_payroll_id (for bug 3436989)
1898: ,p_effective_date => l_canonical_end_date

Line 1901: hr_utility.set_location('Calling arch_za_pay_action_level_data', 27);

1897: ,p_payroll_id => rec_payroll_info.payroll_id -- l_payroll_id (for bug 3436989)
1898: ,p_effective_date => l_canonical_end_date
1899: );
1900:
1901: hr_utility.set_location('Calling arch_za_pay_action_level_data', 27);
1902: arch_za_pay_action_level_data(
1903: p_payroll_action_id => pactid
1904: ,p_payroll_id => rec_payroll_info.payroll_id -- l_payroll_id (for bug 3436989)
1905: ,p_effective_date => l_canonical_end_date

Line 1910: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id, 30);

1906: );
1907: -- End Bug 4153551
1908: --
1909: --
1910: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id, 30);
1911: --
1912: hr_utility.set_location('Archiving EMEA PAYROLL INFO', 30);
1913: --
1914: -- Archive the Payroll Info in 'EMEA PAYROLL INFO'

Line 1912: hr_utility.set_location('Archiving EMEA PAYROLL INFO', 30);

1908: --
1909: --
1910: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id, 30);
1911: --
1912: hr_utility.set_location('Archiving EMEA PAYROLL INFO', 30);
1913: --
1914: -- Archive the Payroll Info in 'EMEA PAYROLL INFO'
1915: -- Note: Actually information on Org DF Tax Details References
1916: pay_action_information_api.create_action_information

Line 1974: hr_utility.set_location('Leaving ' || l_proc, 40);

1970: where ppa.payroll_action_id = :payroll_action_id
1971: and ppf.business_group_id = ppa.business_group_id
1972: order by ppf.person_id';
1973:
1974: hr_utility.set_location('Leaving ' || l_proc, 40);
1975: -- hr_utility.trace_off;
1976:
1977: exception
1978: when others then

Line 1975: -- hr_utility.trace_off;

1971: and ppf.business_group_id = ppa.business_group_id
1972: order by ppf.person_id';
1973:
1974: hr_utility.set_location('Leaving ' || l_proc, 40);
1975: -- hr_utility.trace_off;
1976:
1977: exception
1978: when others then
1979: sqlstr := null;

Line 2070: --hr_utility.trace_on(null, 'ZA_SOE');

2066: begin
2067:
2068: l_proc := g_package || 'action_creation';
2069: -- Removed default assignment to remove GSCC warning
2070: --hr_utility.trace_on(null, 'ZA_SOE');
2071: hr_utility.set_location('Entering ' || l_proc, 10);
2072:
2073: -- Retrieve the legislative parameters from the payroll action
2074: pay_za_payslip_archive.get_parameters

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

2067:
2068: l_proc := g_package || 'action_creation';
2069: -- Removed default assignment to remove GSCC warning
2070: --hr_utility.trace_on(null, 'ZA_SOE');
2071: hr_utility.set_location('Entering ' || l_proc, 10);
2072:
2073: -- Retrieve the legislative parameters from the payroll action
2074: pay_za_payslip_archive.get_parameters
2075: (

Line 2102: hr_utility.set_location('Step ' || l_proc, 20);

2098: p_token_name => 'END_DATE',
2099: p_token_value => l_end_date
2100: );
2101:
2102: hr_utility.set_location('Step ' || l_proc, 20);
2103: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
2104: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
2105: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
2106: hr_utility.set_location('pactid = ' || pactid, 20);

Line 2103: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);

2099: p_token_value => l_end_date
2100: );
2101:
2102: hr_utility.set_location('Step ' || l_proc, 20);
2103: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
2104: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
2105: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
2106: hr_utility.set_location('pactid = ' || pactid, 20);
2107:

Line 2104: hr_utility.set_location('l_start_date = ' || l_start_date, 20);

2100: );
2101:
2102: hr_utility.set_location('Step ' || l_proc, 20);
2103: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
2104: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
2105: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
2106: hr_utility.set_location('pactid = ' || pactid, 20);
2107:
2108: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');

Line 2105: hr_utility.set_location('l_end_date = ' || l_end_date, 20);

2101:
2102: hr_utility.set_location('Step ' || l_proc, 20);
2103: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
2104: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
2105: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
2106: hr_utility.set_location('pactid = ' || pactid, 20);
2107:
2108: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');
2109: l_canonical_end_date := to_date(l_end_date, 'yyyy/mm/dd');

Line 2106: hr_utility.set_location('pactid = ' || pactid, 20);

2102: hr_utility.set_location('Step ' || l_proc, 20);
2103: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
2104: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
2105: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
2106: hr_utility.set_location('pactid = ' || pactid, 20);
2107:
2108: l_canonical_start_date := to_date(l_start_date, 'yyyy/mm/dd');
2109: l_canonical_end_date := to_date(l_end_date, 'yyyy/mm/dd');
2110:

Line 2115: hr_utility.set_location('csr_prepaid_assignments info', 99);

2111: l_prepay_action_id := 0;
2112:
2113: -- Loop through all runs and prepayments that have not already been locked by
2114: -- an Payslip Archive process
2115: hr_utility.set_location('csr_prepaid_assignments info', 99);
2116: hr_utility.set_location('pactid = '||pactid, 99);
2117: hr_utility.set_location('stperson = '||stperson, 99);
2118: hr_utility.set_location('endperson = '||endperson, 99);
2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);

Line 2116: hr_utility.set_location('pactid = '||pactid, 99);

2112:
2113: -- Loop through all runs and prepayments that have not already been locked by
2114: -- an Payslip Archive process
2115: hr_utility.set_location('csr_prepaid_assignments info', 99);
2116: hr_utility.set_location('pactid = '||pactid, 99);
2117: hr_utility.set_location('stperson = '||stperson, 99);
2118: hr_utility.set_location('endperson = '||endperson, 99);
2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);
2120: hr_utility.set_location('l_consolidation_set = '||l_consolidation_set, 99);

Line 2117: hr_utility.set_location('stperson = '||stperson, 99);

2113: -- Loop through all runs and prepayments that have not already been locked by
2114: -- an Payslip Archive process
2115: hr_utility.set_location('csr_prepaid_assignments info', 99);
2116: hr_utility.set_location('pactid = '||pactid, 99);
2117: hr_utility.set_location('stperson = '||stperson, 99);
2118: hr_utility.set_location('endperson = '||endperson, 99);
2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);
2120: hr_utility.set_location('l_consolidation_set = '||l_consolidation_set, 99);
2121: for csr_rec in csr_prepaid_assignments

Line 2118: hr_utility.set_location('endperson = '||endperson, 99);

2114: -- an Payslip Archive process
2115: hr_utility.set_location('csr_prepaid_assignments info', 99);
2116: hr_utility.set_location('pactid = '||pactid, 99);
2117: hr_utility.set_location('stperson = '||stperson, 99);
2118: hr_utility.set_location('endperson = '||endperson, 99);
2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);
2120: hr_utility.set_location('l_consolidation_set = '||l_consolidation_set, 99);
2121: for csr_rec in csr_prepaid_assignments
2122: (

Line 2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);

2115: hr_utility.set_location('csr_prepaid_assignments info', 99);
2116: hr_utility.set_location('pactid = '||pactid, 99);
2117: hr_utility.set_location('stperson = '||stperson, 99);
2118: hr_utility.set_location('endperson = '||endperson, 99);
2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);
2120: hr_utility.set_location('l_consolidation_set = '||l_consolidation_set, 99);
2121: for csr_rec in csr_prepaid_assignments
2122: (
2123: pactid,

Line 2120: hr_utility.set_location('l_consolidation_set = '||l_consolidation_set, 99);

2116: hr_utility.set_location('pactid = '||pactid, 99);
2117: hr_utility.set_location('stperson = '||stperson, 99);
2118: hr_utility.set_location('endperson = '||endperson, 99);
2119: hr_utility.set_location('l_payroll_id = '||l_payroll_id, 99);
2120: hr_utility.set_location('l_consolidation_set = '||l_consolidation_set, 99);
2121: for csr_rec in csr_prepaid_assignments
2122: (
2123: pactid,
2124: stperson,

Line 2152: hr_utility.set_location('creating lock for assignment_id ' || csr_rec.assignment_id, 20);

2148: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, chunk, l_tax_unit_id);
2149:
2150: -- Create the archive to payroll master assignment action interlock and
2151: -- the archive to prepayment assignment action interlock
2152: hr_utility.set_location('creating lock for assignment_id ' || csr_rec.assignment_id, 20);
2153: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id, 20);
2154: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id, 20);
2155:
2156: hr_nonrun_asact.insint(l_actid, csr_rec.prepaid_action_id);

Line 2153: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id, 20);

2149:
2150: -- Create the archive to payroll master assignment action interlock and
2151: -- the archive to prepayment assignment action interlock
2152: hr_utility.set_location('creating lock for assignment_id ' || csr_rec.assignment_id, 20);
2153: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id, 20);
2154: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id, 20);
2155:
2156: hr_nonrun_asact.insint(l_actid, csr_rec.prepaid_action_id);
2157:

Line 2154: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id, 20);

2150: -- Create the archive to payroll master assignment action interlock and
2151: -- the archive to prepayment assignment action interlock
2152: hr_utility.set_location('creating lock for assignment_id ' || csr_rec.assignment_id, 20);
2153: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id, 20);
2154: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id, 20);
2155:
2156: hr_nonrun_asact.insint(l_actid, csr_rec.prepaid_action_id);
2157:
2158: end if;

Line 2165: hr_utility.set_location('Leaving ' || l_proc, 20);

2161: l_prepay_action_id := csr_rec.prepaid_action_id;
2162:
2163: end loop;
2164:
2165: hr_utility.set_location('Leaving ' || l_proc, 20);
2166:
2167: end action_creation;
2168:
2169: -- This procedure gets called fourth to archive each assignment action.

Line 2286: -- hr_utility.trace_on(null, 'ZA_SOE');

2282:
2283:
2284:
2285: -- Removed default assignment to remove GSCC warning
2286: -- hr_utility.trace_on(null, 'ZA_SOE');
2287: hr_utility.set_location('Entering '|| l_proc, 10);
2288:
2289: hr_utility.set_location('Step '|| l_proc, 20);
2290: hr_utility.set_location('p_assactid = ' || p_assactid, 20);

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

2283:
2284:
2285: -- Removed default assignment to remove GSCC warning
2286: -- hr_utility.trace_on(null, 'ZA_SOE');
2287: hr_utility.set_location('Entering '|| l_proc, 10);
2288:
2289: hr_utility.set_location('Step '|| l_proc, 20);
2290: hr_utility.set_location('p_assactid = ' || p_assactid, 20);
2291:

Line 2289: hr_utility.set_location('Step '|| l_proc, 20);

2285: -- Removed default assignment to remove GSCC warning
2286: -- hr_utility.trace_on(null, 'ZA_SOE');
2287: hr_utility.set_location('Entering '|| l_proc, 10);
2288:
2289: hr_utility.set_location('Step '|| l_proc, 20);
2290: hr_utility.set_location('p_assactid = ' || p_assactid, 20);
2291:
2292: -- Retrieve the chunk number for the current assignment action
2293: select paa.chunk_number

Line 2290: hr_utility.set_location('p_assactid = ' || p_assactid, 20);

2286: -- hr_utility.trace_on(null, 'ZA_SOE');
2287: hr_utility.set_location('Entering '|| l_proc, 10);
2288:
2289: hr_utility.set_location('Step '|| l_proc, 20);
2290: hr_utility.set_location('p_assactid = ' || p_assactid, 20);
2291:
2292: -- Retrieve the chunk number for the current assignment action
2293: select paa.chunk_number
2294: into l_chunk_number

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

2303: -- 3693941 initialise the l_pre_assignment_action_id variable.
2304: -- Loop through all the Prepayments and Runs for the current Archiver Assignment Action
2305: for csr_rec in csr_assignment_actions(p_assactid) loop
2306:
2307: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id, 20);
2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);
2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);

Line 2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);

2304: -- Loop through all the Prepayments and Runs for the current Archiver Assignment Action
2305: for csr_rec in csr_assignment_actions(p_assactid) loop
2306:
2307: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id, 20);
2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);
2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);

Line 2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);

2305: for csr_rec in csr_assignment_actions(p_assactid) loop
2306:
2307: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id, 20);
2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);
2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2313:

Line 2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);

2306:
2307: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id, 20);
2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);
2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2313:
2314: if l_record_count = 0 then

Line 2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);

2307: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id, 20);
2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);
2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2313:
2314: if l_record_count = 0 then
2315:

Line 2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);

2308: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id, 20);
2309: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2310: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2311: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2313:
2314: if l_record_count = 0 then
2315:
2316: hr_utility.set_location(' record_count = 0 , starting archive_employee_details' , 23);

Line 2316: hr_utility.set_location(' record_count = 0 , starting archive_employee_details' , 23);

2312: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2313:
2314: if l_record_count = 0 then
2315:
2316: hr_utility.set_location(' record_count = 0 , starting archive_employee_details' , 23);
2317:
2318: -- Archive the Employee Details in 'EMPLOYEE DETAILS', 'ADDRESS DETAILS',
2319: -- 'EMPLOYEE NET PAY DISTRIBUTION' and 'ZA EMPLOYEE DETAILS'
2320: pay_za_payslip_archive.archive_employee_details

Line 2330: hr_utility.set_location(' out of archive_employee_details ' , 25);

2326: p_curr_pymt_eff_date => csr_rec.pre_effective_date, -- prepayment effective_date
2327: p_time_period_id => csr_rec.time_period_id -- payroll time_period_id
2328: );
2329:
2330: hr_utility.set_location(' out of archive_employee_details ' , 25);
2331:
2332: end if;
2333:
2334: pay_za_payslip_archive.get_element_info

Line 2351: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);

2347: -- and the last (i.e. highest action_sequence) Process Separately assignment action
2348: -- (EMEA BALANCES)
2349:
2350: -- Archive user balances
2351: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2352:
2353: l_pre_assignment_action_id := csr_rec.pre_assignment_action_id;
2354:
2355: hr_utility.set_location('Archive User Balances - Starting', 60);

Line 2355: hr_utility.set_location('Archive User Balances - Starting', 60);

2351: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2352:
2353: l_pre_assignment_action_id := csr_rec.pre_assignment_action_id;
2354:
2355: hr_utility.set_location('Archive User Balances - Starting', 60);
2356: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index, 60);
2357: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2358:
2359: for l_index in 1..g_max_user_balance_index loop

Line 2356: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index, 60);

2352:
2353: l_pre_assignment_action_id := csr_rec.pre_assignment_action_id;
2354:
2355: hr_utility.set_location('Archive User Balances - Starting', 60);
2356: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index, 60);
2357: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2358:
2359: for l_index in 1..g_max_user_balance_index loop
2360: -- Bug 5507715

Line 2357: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);

2353: l_pre_assignment_action_id := csr_rec.pre_assignment_action_id;
2354:
2355: hr_utility.set_location('Archive User Balances - Starting', 60);
2356: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index, 60);
2357: hr_utility.set_location('l_pre_assignment_action_id = '|| l_pre_assignment_action_id, 60);
2358:
2359: for l_index in 1..g_max_user_balance_index loop
2360: -- Bug 5507715
2361: pay_za_payslip_archive.process_balance

Line 2401: hr_utility.set_location('Archive User Balances - Complete', 60);

2397: END if;*/
2398:
2399: end loop;
2400:
2401: hr_utility.set_location('Archive User Balances - Complete', 60);
2402:
2403: -- Archive statutory balances
2404: hr_utility.set_location('Archive Statutory Balances - Starting', 70);
2405: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index, 70);

Line 2404: hr_utility.set_location('Archive Statutory Balances - Starting', 70);

2400:
2401: hr_utility.set_location('Archive User Balances - Complete', 60);
2402:
2403: -- Archive statutory balances
2404: hr_utility.set_location('Archive Statutory Balances - Starting', 70);
2405: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index, 70);
2406:
2407: for l_index in 1..g_max_statutory_balance_index loop
2408:

Line 2405: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index, 70);

2401: hr_utility.set_location('Archive User Balances - Complete', 60);
2402:
2403: -- Archive statutory balances
2404: hr_utility.set_location('Archive Statutory Balances - Starting', 70);
2405: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index, 70);
2406:
2407: for l_index in 1..g_max_statutory_balance_index loop
2408:
2409: hr_utility.set_location('l_index = ' || l_index, 70);

Line 2409: hr_utility.set_location('l_index = ' || l_index, 70);

2405: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index, 70);
2406:
2407: for l_index in 1..g_max_statutory_balance_index loop
2408:
2409: hr_utility.set_location('l_index = ' || l_index, 70);
2410: --5507715
2411: pay_za_payslip_archive.process_balance
2412: (
2413: p_action_context_id => l_action_context_id,

Line 2453: hr_utility.set_location('Archive Statutory Balances - Complete', 70);

2449: end loop;
2450: end if;
2451: -- and passed the csr_rec.pre_assignment_action_id instead of master_assignment_action_id
2452: -- End of if condition for the bug 3693941
2453: hr_utility.set_location('Archive Statutory Balances - Complete', 70);
2454:
2455: l_record_count := l_record_count + 1;
2456:
2457: end loop;

Line 2459: hr_utility.set_location('Leaving '|| l_proc, 80);

2455: l_record_count := l_record_count + 1;
2456:
2457: end loop;
2458:
2459: hr_utility.set_location('Leaving '|| l_proc, 80);
2460:
2461: end archive_code;
2462: end;