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

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

77: l_proc VARCHAR2(50) := g_package || 'get_parameters';
78:
79: BEGIN
80:
81: hr_utility.set_location('Entering ' || l_proc,10);
82:
83: hr_utility.set_location('Step ' || l_proc,20);
84: hr_utility.set_location('p_token_name = ' || p_token_name,20);
85:

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

79: BEGIN
80:
81: hr_utility.set_location('Entering ' || l_proc,10);
82:
83: hr_utility.set_location('Step ' || l_proc,20);
84: hr_utility.set_location('p_token_name = ' || p_token_name,20);
85:
86: OPEN csr_parameter_info(p_payroll_action_id,
87: p_token_name);

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

80:
81: hr_utility.set_location('Entering ' || l_proc,10);
82:
83: hr_utility.set_location('Step ' || l_proc,20);
84: hr_utility.set_location('p_token_name = ' || p_token_name,20);
85:
86: OPEN csr_parameter_info(p_payroll_action_id,
87: p_token_name);
88:

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

102: p_token_value := l_token_value;
103:
104: END IF;
105:
106: hr_utility.set_location('l_token_value = ' || l_token_value,20);
107: hr_utility.set_location('Leaving ' || l_proc,30);
108:
109: END get_parameters;
110:

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

103:
104: END IF;
105:
106: hr_utility.set_location('l_token_value = ' || l_token_value,20);
107: hr_utility.set_location('Leaving ' || l_proc,30);
108:
109: END get_parameters;
110:
111: PROCEDURE get_eit_definitions(p_pactid IN NUMBER,

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

172: l_proc VARCHAR2(50) := g_package || 'get_eit_definitions';
173:
174: BEGIN
175:
176: hr_utility.set_location('Entering ' || l_proc,10);
177:
178: hr_utility.set_location('Step ' || l_proc,20);
179: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
180:

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

174: BEGIN
175:
176: hr_utility.set_location('Entering ' || l_proc,10);
177:
178: hr_utility.set_location('Step ' || l_proc,20);
179: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
180:
181: FOR csr_eit_rec IN csr_eit_values(p_business_group_id,
182: p_eit_context)

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

175:
176: hr_utility.set_location('Entering ' || l_proc,10);
177:
178: hr_utility.set_location('Step ' || l_proc,20);
179: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
180:
181: FOR csr_eit_rec IN csr_eit_values(p_business_group_id,
182: p_eit_context)
183:

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

182: p_eit_context)
183:
184: LOOP
185:
186: hr_utility.set_location('Step ' || l_proc,30);
187:
188: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);

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

184: LOOP
185:
186: hr_utility.set_location('Step ' || l_proc,30);
187:
188: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
191: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
192: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);

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

185:
186: hr_utility.set_location('Step ' || l_proc,30);
187:
188: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
191: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
192: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
193: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);

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

186: hr_utility.set_location('Step ' || l_proc,30);
187:
188: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
191: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
192: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
193: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
194:

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

187:
188: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
191: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
192: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
193: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
194:
195: IF p_eit_context = g_balance_context

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

188: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
191: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
192: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
193: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
194:
195: IF p_eit_context = g_balance_context
196:

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

189: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
190: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
191: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
192: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
193: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
194:
195: IF p_eit_context = g_balance_context
196:
197: THEN

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

212: g_user_balance_table(l_index).defined_balance_id;
213:
214: CLOSE csr_balance_name;
215:
216: hr_utility.set_location('Arch EMEA BALANCE DEFINITION',99);
217:
218: IF p_archive = 'Y'
219:
220: THEN

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

263: IF p_archive = 'Y'
264:
265: THEN
266:
267: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
268:
269: pay_action_information_api.create_action_information (
270: p_action_information_id => l_action_info_id
271: , p_action_context_id => p_pactid

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

287: END IF;
288:
289: l_index := l_index + 1;
290:
291: hr_utility.set_location('l_index = ' || l_index,99);
292:
293: END LOOP;
294:
295: g_max_element_index := l_index;

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

305: g_element_archive_index := l_index - 1;
306:
307: END IF;
308:
309: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index,99);
310:
311: hr_utility.set_location('Leaving ' || l_proc,30);
312:
313: END get_eit_definitions;

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

307: END IF;
308:
309: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index,99);
310:
311: hr_utility.set_location('Leaving ' || l_proc,30);
312:
313: END get_eit_definitions;
314:
315:

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

401: l_proc VARCHAR2(60) := g_package || 'setup_element_definitions';
402:
403: BEGIN
404:
405: hr_utility.set_location('Entering ' || l_proc,10);
406:
407: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact,10);
408:
409:

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

403: BEGIN
404:
405: hr_utility.set_location('Entering ' || l_proc,10);
406:
407: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact,10);
408:
409:
410: FOR csr_element_rec IN csr_element_name(p_business_group_id,
411: p_effective_date)

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

410: FOR csr_element_rec IN csr_element_name(p_business_group_id,
411: p_effective_date)
412: LOOP
413:
414: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id,20);
415: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name,20);
416:
417: IF csr_element_rec.classification_name IN
418: ('Earnings', 'IE Earnings Non PRSIable', 'IE Earnings Non Taxable and Non PRSIable')

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

411: p_effective_date)
412: LOOP
413:
414: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id,20);
415: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name,20);
416:
417: IF csr_element_rec.classification_name IN
418: ('Earnings', 'IE Earnings Non PRSIable', 'IE Earnings Non Taxable and Non PRSIable')
419: -- Bug 2943335 Added 'IE Earnings Non PRSIable' and'IE Earnings Non Taxable and Non PRSIable'

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

449: END IF;
450:
451:
452:
453: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
454:
455: IF l_payment_type_bik='P'
456: THEN
457: pay_action_information_api.create_action_information (

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

512: END IF;
513:
514: END LOOP;
515:
516: hr_utility.set_location('Leaving ' || l_proc,30);
517:
518: END setup_element_definitions;
519:
520: PROCEDURE setup_standard_balance_table

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

572:
573:
574:
575:
576: hr_utility.set_location('Entering ' || l_proc,10);
577:
578: hr_utility.set_location('Step ' || l_proc,20);
579:
580: l_statutory_balance(1).balance_name := 'IE Total Deductions';

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

574:
575:
576: hr_utility.set_location('Entering ' || l_proc,10);
577:
578: hr_utility.set_location('Step ' || l_proc,20);
579:
580: l_statutory_balance(1).balance_name := 'IE Total Deductions';
581: l_statutory_balance(2).balance_name := 'IE Taxable Pay';
582: l_statutory_balance(3).balance_name := 'IE PRSIable Pay';

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

593: l_statutory_balance(12).balance_name := 'IE PRSI K Term Insurable Weeks';
594: l_statutory_balance(13).balance_name := 'IE PRSI M Term Insurable Weeks';
595: l_statutory_balance(14).balance_name := 'IE Term Health Levy';
596:
597: hr_utility.set_location('Step = ' || l_proc,30);
598:
599: FOR l_index IN 1 .. l_max_stat_balance
600:
601: LOOP

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

600:
601: LOOP
602:
603: l_dimension := '_ASG_YTD';
604: hr_utility.set_location('l_index = ' || l_index,30);
605: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
606: hr_utility.set_location('l_dimension = ' || l_dimension,30);
607:
608:

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

601: LOOP
602:
603: l_dimension := '_ASG_YTD';
604: hr_utility.set_location('l_index = ' || l_index,30);
605: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
606: hr_utility.set_location('l_dimension = ' || l_dimension,30);
607:
608:
609: IF l_statutory_balance(l_index).balance_name = 'IE PRSI Insurable Weeks' then

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

602:
603: l_dimension := '_ASG_YTD';
604: hr_utility.set_location('l_index = ' || l_index,30);
605: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
606: hr_utility.set_location('l_dimension = ' || l_dimension,30);
607:
608:
609: IF l_statutory_balance(l_index).balance_name = 'IE PRSI Insurable Weeks' then
610: l_dimension := l_dimension_1;

Line 663: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index_id).defined_balance_id,30);

659: END IF;
660:
661: CLOSE csr_balance_dimension;
662:
663: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index_id).defined_balance_id,30);
664:
665: --6633719
666: l_index_id := l_index_id + 1;
667: OPEN csr_balance_dimension(l_statutory_balance(l_index).balance_name,

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

684: --6633719
685:
686: END LOOP;
687:
688: hr_utility.set_location('Step = ' || l_proc,40);
689:
690: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
691: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
692:

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

686: END LOOP;
687:
688: hr_utility.set_location('Step = ' || l_proc,40);
689:
690: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
691: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
692:
693: FOR l_index IN 1 .. l_index_id
694:

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

687:
688: hr_utility.set_location('Step = ' || l_proc,40);
689:
690: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
691: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
692:
693: FOR l_index IN 1 .. l_index_id
694:
695: LOOP

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

699: FOR l_eit_index IN 1 .. g_max_user_balance_index
700:
701: LOOP
702:
703: hr_utility.set_location('l_index = ' || l_index,40);
704: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
705: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
706: hr_utility.set_location('l_found = ' || l_found,40);
707:

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

700:
701: LOOP
702:
703: hr_utility.set_location('l_index = ' || l_index,40);
704: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
705: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
706: hr_utility.set_location('l_found = ' || l_found,40);
707:
708: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id

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

701: LOOP
702:
703: hr_utility.set_location('l_index = ' || l_index,40);
704: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
705: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
706: hr_utility.set_location('l_found = ' || l_found,40);
707:
708: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id
709:

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

702:
703: hr_utility.set_location('l_index = ' || l_index,40);
704: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
705: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
706: hr_utility.set_location('l_found = ' || l_found,40);
707:
708: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id
709:
710: THEN

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

720: THEN
721:
722: l_archive_index := l_archive_index + 1;
723:
724: hr_utility.set_location('l_archive_index = ' || l_archive_index,40);
725:
726: g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_index).defined_balance_id;
727: g_statutory_balance_table(l_archive_index).balance_name := l_statutory_bal_id(l_index).balance_name; --4879850
728: g_statutory_balance_table(l_archive_index).database_item_suffix := l_statutory_bal_id(l_index).dimension_name; --6633719

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

733: END LOOP;
734:
735: g_max_statutory_balance_index := l_archive_index;
736:
737: hr_utility.set_location('Step ' || l_proc,50);
738: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
739:
740: hr_utility.set_location('Leaving ' || l_proc,60);
741:

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

734:
735: g_max_statutory_balance_index := l_archive_index;
736:
737: hr_utility.set_location('Step ' || l_proc,50);
738: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
739:
740: hr_utility.set_location('Leaving ' || l_proc,60);
741:
742: END setup_standard_balance_table;

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

736:
737: hr_utility.set_location('Step ' || l_proc,50);
738: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
739:
740: hr_utility.set_location('Leaving ' || l_proc,60);
741:
742: END setup_standard_balance_table;
743:
744:

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

823:
824: BEGIN
825:
826: --
827: hr_utility.set_location('Entering ' || l_proc,10);
828:
829: g_archive_pact := p_payroll_action_id;
830:
831: OPEN csr_archive_effective_date(p_payroll_action_id);

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

864: p_payroll_action_id => p_payroll_action_id
865: , p_token_name => 'BG_ID'
866: , p_token_value => l_bg_id);
867:
868: hr_utility.set_location('Step ' || l_proc,20);
869: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
870: hr_utility.set_location('l_start_date = ' || l_start_date,20);
871: hr_utility.set_location('l_end_date = ' || l_end_date,20);
872:

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

865: , p_token_name => 'BG_ID'
866: , p_token_value => l_bg_id);
867:
868: hr_utility.set_location('Step ' || l_proc,20);
869: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
870: hr_utility.set_location('l_start_date = ' || l_start_date,20);
871: hr_utility.set_location('l_end_date = ' || l_end_date,20);
872:
873: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

866: , p_token_value => l_bg_id);
867:
868: hr_utility.set_location('Step ' || l_proc,20);
869: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
870: hr_utility.set_location('l_start_date = ' || l_start_date,20);
871: hr_utility.set_location('l_end_date = ' || l_end_date,20);
872:
873: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
874: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

867:
868: hr_utility.set_location('Step ' || l_proc,20);
869: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
870: hr_utility.set_location('l_start_date = ' || l_start_date,20);
871: hr_utility.set_location('l_end_date = ' || l_end_date,20);
872:
873: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
874: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
875:

Line 878: hr_utility.set_location('Getting Period Type of the Payroll', 30);

874: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
875:
876: -- Get Payroll Period Type
877:
878: hr_utility.set_location('Getting Period Type of the Payroll', 30);
879:
880: OPEN csr_payroll_type(l_payroll_id,
881: g_archive_effective_date);
882:

Line 887: hr_utility.set_location('l_payroll_type = '|| l_payroll_type, 30);

883: FETCH csr_payroll_type INTO l_payroll_type;
884:
885: CLOSE csr_payroll_type;
886:
887: hr_utility.set_location('l_payroll_type = '|| l_payroll_type, 30);
888:
889: IF l_payroll_type in ('Week', 'Bi-Week', 'Lunar Month') THEN
890: l_tax_credit_value := 'Weekly Tax Credit';
891: l_std_cut_off_value := 'Weekly Standard Rate Cutoff';

Line 900: hr_utility.set_location('l_tax_credit_value = '|| l_tax_credit_value, 30);

896: l_std_cut_off_value := 'Monthly Standard Rate Cutoff';
897:
898: END IF;
899:
900: hr_utility.set_location('l_tax_credit_value = '|| l_tax_credit_value, 30);
901: hr_utility.set_location('l_std_cut_off_value = '|| l_std_cut_off_value, 30);
902:
903: -- retrieve ids for tax elements
904:

Line 901: hr_utility.set_location('l_std_cut_off_value = '|| l_std_cut_off_value, 30);

897:
898: END IF;
899:
900: hr_utility.set_location('l_tax_credit_value = '|| l_tax_credit_value, 30);
901: hr_utility.set_location('l_std_cut_off_value = '|| l_std_cut_off_value, 30);
902:
903: -- retrieve ids for tax elements
904:
905: OPEN csr_input_value_id('IE PAYE details',l_tax_credit_value);

Line 912: hr_utility.set_location('g_tax_credit_id = '|| to_char(g_tax_credit_id), 30);

908: g_tax_credit_id;
909:
910: CLOSE csr_input_value_id;
911:
912: hr_utility.set_location('g_tax_credit_id = '|| to_char(g_tax_credit_id), 30);
913:
914: OPEN csr_input_value_id('IE PAYE details',l_std_cut_off_value);
915:
916: FETCH csr_input_value_id INTO g_paye_details_element_id,

Line 921: hr_utility.set_location('g_std_cut_off_id = '|| to_char(g_std_cut_off_id), 30);

917: g_std_cut_off_id;
918:
919: CLOSE csr_input_value_id;
920:
921: hr_utility.set_location('g_std_cut_off_id = '|| to_char(g_std_cut_off_id), 30);
922:
923: OPEN csr_input_value_id('IE PAYE details','Tax Basis');
924:
925: FETCH csr_input_value_id INTO g_paye_details_element_id,

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

959: OPEN csr_get_tax_unit_id(l_bg_id,l_consolidation_set,l_canonical_start_date,l_canonical_end_date);
960: FETCH csr_get_tax_unit_id INTO g_tax_unit_id;
961: CLOSE csr_get_tax_unit_id;
962:
963: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
964: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
965: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
966: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
967:

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

960: FETCH csr_get_tax_unit_id INTO g_tax_unit_id;
961: CLOSE csr_get_tax_unit_id;
962:
963: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
964: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
965: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
966: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
967:
968:

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

961: CLOSE csr_get_tax_unit_id;
962:
963: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
964: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
965: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
966: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
967:
968:
969: -- retrieve and archive user defintions from EITs

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

962:
963: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
964: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
965: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
966: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
967:
968:
969: -- retrieve and archive user defintions from EITs
970:

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

969: -- retrieve and archive user defintions from EITs
970:
971: g_max_user_balance_index := 0;
972:
973: hr_utility.set_location('get_eit_definitions - balances',20);
974:
975: pay_ie_legislative_archive.get_eit_definitions (
976: p_pactid => p_payroll_action_id
977: , p_business_group_id => l_bg_id

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

979: , p_effective_date => l_canonical_start_date
980: , p_eit_context => g_balance_context
981: , p_archive => 'N');
982:
983: hr_utility.set_location('get_eit_definitions - elements',20);
984:
985: pay_ie_legislative_archive.get_eit_definitions (
986: p_pactid => p_payroll_action_id
987: , p_business_group_id => l_bg_id

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

996: -- setup statutory balances pl/sql table
997:
998: pay_ie_legislative_archive.setup_standard_balance_table;
999:
1000: hr_utility.set_location('Leaving ' || l_proc,20);
1001: --
1002:
1003: END archinit;
1004:

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

1018: l_proc VARCHAR2(60) := g_package || 'archive_employee_details';
1019:
1020: BEGIN
1021:
1022: hr_utility.set_location('Entering ' || l_proc,10);
1023:
1024: -- call generic procedure to retrieve and archive all data for
1025: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1026:

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

1023:
1024: -- call generic procedure to retrieve and archive all data for
1025: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1026:
1027: hr_utility.set_location('Calling pay_emp_action_arch',20);
1028:
1029: pay_emp_action_arch.get_personal_information (
1030: p_payroll_action_id => g_archive_pact -- archive payroll_action_id
1031: , p_assactid => p_assactid -- archive assignment_action_id

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

1038: , p_tax_unit_id => NULL -- only required for US
1039: , p_time_period_id => p_time_period_id -- payroll time_period_id
1040: , p_ppp_source_action_id => NULL);
1041: --
1042: hr_utility.set_location('Leaving ' || l_proc,30);
1043: --
1044: END archive_employee_details;
1045:
1046: PROCEDURE archive_ie_employee_details (

Line 1110: hr_utility.trace('First Name : NULL ');

1106: --
1107: EXCEPTION
1108: WHEN NO_DATA_FOUND THEN
1109: l_first_name := NULL;
1110: hr_utility.trace('First Name : NULL ');
1111: return l_first_name;
1112: --
1113: END get_first_name;
1114:

Line 1149: hr_utility.trace('Last Name : NULL ');

1145: --
1146: EXCEPTION
1147: WHEN NO_DATA_FOUND THEN
1148: l_last_name := NULL;
1149: hr_utility.trace('Last Name : NULL ');
1150: RETURN l_last_name;
1151: --
1152: END get_last_name;
1153:

Line 1188: hr_utility.trace('DOB : NULL ');

1184: --
1185: EXCEPTION
1186: WHEN NO_DATA_FOUND THEN
1187: l_dob := NULL;
1188: hr_utility.trace('DOB : NULL ');
1189: return l_dob;
1190: --
1191: END get_dob;
1192:

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

1193:
1194:
1195: BEGIN
1196:
1197: hr_utility.set_location('Entering ' || l_proc,10);
1198:
1199: -- Retrieve and Archive the IE specific employee details
1200:
1201: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (

Line 1206: hr_utility.set_location('l_tax_basis = ' || l_tax_basis,40);

1202: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1203: ,p_input_value_id => g_tax_basis_id
1204: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1205:
1206: hr_utility.set_location('l_tax_basis = ' || l_tax_basis,40);
1207:
1208: l_prsi_cat := pay_ie_archive_detail_pkg.get_tax_details (
1209: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1210: ,p_input_value_id => g_prsi_cat_id

Line 1213: hr_utility.set_location('l_prsi_cat = ' || l_prsi_cat,40);

1209: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1210: ,p_input_value_id => g_prsi_cat_id
1211: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1212:
1213: hr_utility.set_location('l_prsi_cat = ' || l_prsi_cat,40);
1214:
1215: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1216: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1217: ,p_input_value_id => g_prsi_subcat_id

Line 1220: hr_utility.set_location('l_prsi_subcat = ' || l_prsi_subcat,40);

1216: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1217: ,p_input_value_id => g_prsi_subcat_id
1218: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1219:
1220: hr_utility.set_location('l_prsi_subcat = ' || l_prsi_subcat,40);
1221:
1222: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (
1223: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1224: ,p_input_value_id => g_ins_weeks_id

Line 1227: hr_utility.set_location('l_ins_weeks = ' || l_ins_weeks,40);

1223: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1224: ,p_input_value_id => g_ins_weeks_id
1225: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1226:
1227: hr_utility.set_location('l_ins_weeks = ' || l_ins_weeks,40);
1228:
1229: l_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1230: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1231: ,p_input_value_id => g_tax_credit_id

Line 1234: hr_utility.set_location('l_tax_credit = ' || l_tax_credit,40);

1230: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1231: ,p_input_value_id => g_tax_credit_id
1232: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1233:
1234: hr_utility.set_location('l_tax_credit = ' || l_tax_credit,40);
1235:
1236: l_std_cut_off := pay_ie_archive_detail_pkg.get_tax_details (
1237: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1238: ,p_input_value_id => g_std_cut_off_id

Line 1241: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);

1237: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1238: ,p_input_value_id => g_std_cut_off_id
1239: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1240:
1241: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);
1242:
1243: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);
1244: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);
1245:

Line 1243: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);

1239: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1240:
1241: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);
1242:
1243: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);
1244: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);
1245:
1246: l_prsi_week := pay_balance_pkg.get_value (g_prsi_week_id,
1247: p_curr_pymt_ass_act_id,

Line 1244: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);

1240:
1241: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);
1242:
1243: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);
1244: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);
1245:
1246: l_prsi_week := pay_balance_pkg.get_value (g_prsi_week_id,
1247: p_curr_pymt_ass_act_id,
1248: false);

Line 1250: hr_utility.set_location('l_prsi_week = ' || l_prsi_week,45);

1246: l_prsi_week := pay_balance_pkg.get_value (g_prsi_week_id,
1247: p_curr_pymt_ass_act_id,
1248: false);
1249:
1250: hr_utility.set_location('l_prsi_week = ' || l_prsi_week,45);
1251:
1252: l_firstname := get_first_name(p_curr_pymt_ass_act_id);
1253: l_surname := get_last_name(p_curr_pymt_ass_act_id);
1254: l_dob := get_dob(p_curr_pymt_ass_act_id);

Line 1300: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);

1296: l_tax_basis_det := l_tax_basis;
1297:
1298: END IF;
1299:
1300: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1301:
1302: pay_action_information_api.create_action_information (
1303: p_action_information_id => l_action_info_id
1304: , p_action_context_id => p_assactid

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

1323: , p_action_information28 => l_firstname
1324: , p_action_information29 => l_surname);
1325:
1326: --
1327: hr_utility.set_location('Leaving ' || l_proc,60);
1328: --
1329: END archive_ie_employee_details;
1330:
1331: PROCEDURE process_balance (p_action_context_id IN NUMBER,

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

1382: l_proc VARCHAR2(50) := g_package || 'process_balance';
1383:
1384: BEGIN
1385:
1386: hr_utility.set_location('Entering ' || l_proc,10);
1387:
1388: hr_utility.set_location('Step ' || l_proc,20);
1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);

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

1384: BEGIN
1385:
1386: hr_utility.set_location('Entering ' || l_proc,10);
1387:
1388: hr_utility.set_location('Step ' || l_proc,20);
1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);

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

1385:
1386: hr_utility.set_location('Entering ' || l_proc,10);
1387:
1388: hr_utility.set_location('Step ' || l_proc,20);
1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);

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

1386: hr_utility.set_location('Entering ' || l_proc,10);
1387:
1388: hr_utility.set_location('Step ' || l_proc,20);
1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1394: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);

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

1387:
1388: hr_utility.set_location('Step ' || l_proc,20);
1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1394: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1395:

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

1388: hr_utility.set_location('Step ' || l_proc,20);
1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1394: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1395:
1396: -- Added for Bug 2545070 to handle PAYROLL REVERSALS

Line 1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);

1389: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1394: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1395:
1396: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1397: OPEN csr_get_reversal_action_id(p_source_id);

Line 1394: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);

1390: hr_utility.set_location('p_balance = ' || p_balance,20);
1391: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1392: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1393: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1394: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1395:
1396: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1397: OPEN csr_get_reversal_action_id(p_source_id);
1398: FETCH csr_get_reversal_action_id INTO l_rev_asg_action_id;

Line 1402: hr_utility.set_location('l_source_id = ' || l_source_id,20);

1398: FETCH csr_get_reversal_action_id INTO l_rev_asg_action_id;
1399: CLOSE csr_get_reversal_action_id;
1400: l_source_id := NVL(l_rev_asg_action_id,p_source_id);
1401:
1402: hr_utility.set_location('l_source_id = ' || l_source_id,20);
1403:
1404: OPEN Cur_Act_Contexts;
1405: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1406: CLOSE Cur_Act_Contexts;

Line 1408: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_ID= ' || v_Cur_Act_Contexts.CONTEXT_ID,20);

1404: OPEN Cur_Act_Contexts;
1405: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1406: CLOSE Cur_Act_Contexts;
1407:
1408: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_ID= ' || v_Cur_Act_Contexts.CONTEXT_ID,20);
1409: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_VALUE= ' || v_Cur_Act_Contexts.CONTEXT_VALUE,20);
1410:
1411: -- Added if condition for 4879850
1412: -- Instead of checking Balance Name we now check the dimension for passing the Source Text Value to support SOE Balances

Line 1409: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_VALUE= ' || v_Cur_Act_Contexts.CONTEXT_VALUE,20);

1405: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1406: CLOSE Cur_Act_Contexts;
1407:
1408: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_ID= ' || v_Cur_Act_Contexts.CONTEXT_ID,20);
1409: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_VALUE= ' || v_Cur_Act_Contexts.CONTEXT_VALUE,20);
1410:
1411: -- Added if condition for 4879850
1412: -- Instead of checking Balance Name we now check the dimension for passing the Source Text Value to support SOE Balances
1413: -- Defined at BG Level which needs Source Text Context 5192325

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

1434: null,
1435: null);
1436: end if;
1437:
1438: hr_utility.set_location('l_balance_value = ' || l_balance_value,20);
1439: IF p_record_count = 0
1440:
1441: THEN
1442:

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

1449: IF l_balance_value <> 0
1450:
1451: THEN
1452:
1453: hr_utility.set_location('Archiving EMEA BALANCES',20);
1454:
1455: pay_action_information_api.create_action_information (
1456: p_action_information_id => l_action_info_id
1457: , p_action_context_id => p_action_context_id

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

1469: , p_action_information5 => l_record_count);
1470:
1471: END IF;
1472:
1473: hr_utility.set_location('Leaving ' || l_proc,30);
1474:
1475: EXCEPTION
1476:
1477: WHEN NO_DATA_FOUND

Line 1520: hr_utility.set_location('Entering get_element_info',10);

1516:
1517:
1518: BEGIN
1519:
1520: hr_utility.set_location('Entering get_element_info',10);
1521:
1522: l_column_sequence := 0;
1523: l_element_type_id := 0;
1524: l_main_sequence := 0;

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

1535: l_record_count := p_record_count + 1;
1536:
1537: END IF;
1538:
1539: hr_utility.set_location('g_max_element_index = ' || g_max_element_index,10);
1540:
1541: FOR l_index IN 1 .. g_max_element_index
1542:
1543: LOOP

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

1541: FOR l_index IN 1 .. g_max_element_index
1542:
1543: LOOP
1544:
1545: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1546: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1547: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1548:
1549: FOR rec_element_value IN csr_element_values (

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

1542:
1543: LOOP
1544:
1545: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1546: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1547: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1548:
1549: FOR rec_element_value IN csr_element_values (
1550: p_child_assignment_action

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

1543: LOOP
1544:
1545: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1546: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1547: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1548:
1549: FOR rec_element_value IN csr_element_values (
1550: p_child_assignment_action
1551: , g_element_table(l_index).element_type_id

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

1552: , g_element_table(l_index).input_value_id)
1553:
1554: LOOP
1555:
1556: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1557: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1558: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1559:
1560: IF l_element_type_id <> g_element_table(l_index).element_type_id

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

1553:
1554: LOOP
1555:
1556: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1557: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1558: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1559:
1560: IF l_element_type_id <> g_element_table(l_index).element_type_id
1561:

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

1554: LOOP
1555:
1556: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1557: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1558: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1559:
1560: IF l_element_type_id <> g_element_table(l_index).element_type_id
1561:
1562: THEN

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

1564: l_main_sequence := l_main_sequence + 1;
1565:
1566: END IF;
1567:
1568: hr_utility.set_location('l_main_sequence = ' || l_main_sequence,20);
1569:
1570: l_column_sequence := l_column_sequence + 1;
1571:
1572: -- If the run method is P, Process Separate, then only archive the data if

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

1676:
1677:
1678: begin
1679:
1680: hr_utility.set_location('Entering ' || l_proc,10);
1681:
1682: for l_payroll_id in get_payrolls
1683: loop
1684: open get_paye_reference_details(l_payroll_id.payroll_id);

Line 1697: hr_utility.trace('paye ref='||l_paye_value);

1693: g_paye_ref:=l_paye_value;
1694: end if;
1695: end loop;
1696: close get_paye_reference_details;
1697: hr_utility.trace('paye ref='||l_paye_value);
1698: end loop;
1699:
1700: hr_utility.set_location('Leaving ' || l_proc,40);
1701:

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

1696: close get_paye_reference_details;
1697: hr_utility.trace('paye ref='||l_paye_value);
1698: end loop;
1699:
1700: hr_utility.set_location('Leaving ' || l_proc,40);
1701:
1702: exception when c_error then
1703: l_error := 'Y';
1704: g_paye_ref:=null;

Line 1861: --hr_utility.trace_on(null,'IEPS');

1857:
1858:
1859: BEGIN
1860:
1861: --hr_utility.trace_on(null,'IEPS');
1862: hr_utility.set_location('Entering ' || l_proc,10);
1863:
1864: pay_ie_legislative_archive.get_parameters (
1865: p_payroll_action_id => pactid

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

1858:
1859: BEGIN
1860:
1861: --hr_utility.trace_on(null,'IEPS');
1862: hr_utility.set_location('Entering ' || l_proc,10);
1863:
1864: pay_ie_legislative_archive.get_parameters (
1865: p_payroll_action_id => pactid
1866: , p_token_name => 'PAYROLL'

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

1890: p_payroll_action_id => pactid
1891: , p_token_name => 'BG_ID'
1892: , p_token_value => l_bg_id);
1893:
1894: hr_utility.set_location('Step ' || l_proc,20);
1895: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1896: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1897: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1898:

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

1891: , p_token_name => 'BG_ID'
1892: , p_token_value => l_bg_id);
1893:
1894: hr_utility.set_location('Step ' || l_proc,20);
1895: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1896: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1897: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1898:
1899: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

1892: , p_token_value => l_bg_id);
1893:
1894: hr_utility.set_location('Step ' || l_proc,20);
1895: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1896: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1897: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1898:
1899: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1900: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

1893:
1894: hr_utility.set_location('Step ' || l_proc,20);
1895: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1896: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1897: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1898:
1899: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1900: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1901:

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

1900: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1901:
1902: -- archive EMEA PAYROLL INFO for each prepayment run identified
1903:
1904: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1905: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1906: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1907: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1908:

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

1901:
1902: -- archive EMEA PAYROLL INFO for each prepayment run identified
1903:
1904: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1905: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1906: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1907: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1908:
1909: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value

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

1902: -- archive EMEA PAYROLL INFO for each prepayment run identified
1903:
1904: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1905: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1906: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1907: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1908:
1909: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
1910: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);

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

1903:
1904: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1905: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1906: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1907: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1908:
1909: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
1910: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
1911:

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

1963: l_consolidation_set,
1964: l_canonical_end_date)
1965: LOOP
1966:
1967: hr_utility.set_location('Calling arch_pay_action_level_data',25);
1968: --
1969:
1970: pay_emp_action_arch.arch_pay_action_level_data (
1971: p_payroll_action_id => pactid

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

1983:
1984: LOOP
1985: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
1986: , rec_payroll_info.payroll_action_id);
1987: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1988: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
1989: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
1990:
1991: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);

Line 1988: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);

1984: LOOP
1985: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
1986: , rec_payroll_info.payroll_action_id);
1987: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1988: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
1989: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
1990:
1991: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1992:

Line 1989: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);

1985: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
1986: , rec_payroll_info.payroll_action_id);
1987: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1988: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
1989: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
1990:
1991: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1992:
1993: pay_action_information_api.create_action_information (

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

1987: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1988: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
1989: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
1990:
1991: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1992:
1993: pay_action_information_api.create_action_information (
1994: p_action_information_id => l_action_info_id
1995: , p_action_context_id => pactid

Line 2056: hr_utility.trace('Range Cursor Not using Payroll Restriction');

2052:
2053: -- Use full cursor not restricting by payroll
2054: --
2055: -- Used per_all_assignments_f 4555600
2056: hr_utility.trace('Range Cursor Not using Payroll Restriction');
2057: sqlstr := 'SELECT distinct asg.person_id
2058: FROM per_periods_of_service pos,
2059: per_assignments_f asg,
2060: pay_payroll_actions ppa

Line 2071: hr_utility.trace('Range Cursor using Payroll Restriction');

2067: else
2068: --
2069: -- The Payroll ID was used as parameter, so restrict by this
2070: --
2071: hr_utility.trace('Range Cursor using Payroll Restriction');
2072: sqlstr := 'SELECT DISTINCT ppf.person_id
2073: FROM per_people_f ppf,
2074: pay_payroll_actions ppa,
2075: per_assignments_f paaf

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

2079: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||
2080: ' ORDER BY ppf.person_id';
2081: end if;
2082:
2083: hr_utility.set_location('Leaving ' || l_proc,40);
2084: end if;
2085:
2086: END range_cursor;
2087:

Line 2115: hr_utility.set_location('range_person_on',10);

2111: l_action_param_val varchar2(30);
2112: l_report_param_val varchar2(30);
2113: --
2114: BEGIN
2115: hr_utility.set_location('range_person_on',10);
2116: --
2117: BEGIN
2118: open csr_action_parameter;
2119: fetch csr_action_parameter into l_action_param_val;

Line 2122: hr_utility.set_location('range_person_on',20);

2118: open csr_action_parameter;
2119: fetch csr_action_parameter into l_action_param_val;
2120: close csr_action_parameter;
2121: --
2122: hr_utility.set_location('range_person_on',20);
2123: open csr_range_format_param;
2124: fetch csr_range_format_param into l_report_param_val;
2125: close csr_range_format_param;
2126: --

Line 2127: hr_utility.set_location('range_person_on',30);

2123: open csr_range_format_param;
2124: fetch csr_range_format_param into l_report_param_val;
2125: close csr_range_format_param;
2126: --
2127: hr_utility.set_location('range_person_on',30);
2128: EXCEPTION WHEN NO_DATA_FOUND THEN
2129: l_return := FALSE;
2130: END;
2131: --

Line 2132: hr_utility.set_location('range_person_on',40);

2128: EXCEPTION WHEN NO_DATA_FOUND THEN
2129: l_return := FALSE;
2130: END;
2131: --
2132: hr_utility.set_location('range_person_on',40);
2133: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
2134: l_return := TRUE;
2135: hr_utility.trace('Range Person = True');
2136: ELSE

Line 2135: hr_utility.trace('Range Person = True');

2131: --
2132: hr_utility.set_location('range_person_on',40);
2133: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
2134: l_return := TRUE;
2135: hr_utility.trace('Range Person = True');
2136: ELSE
2137: l_return := FALSE;
2138: END IF;
2139: --

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

2259: l_proc VARCHAR2(50) := g_package||'action_creation';
2260:
2261: BEGIN
2262:
2263: hr_utility.set_location('Entering ' || l_proc,10);
2264:
2265: pay_ie_legislative_archive.get_parameters (
2266: p_payroll_action_id => pactid
2267: , p_token_name => 'PAYROLL'

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

2281: p_payroll_action_id => pactid
2282: , p_token_name => 'END_DATE'
2283: , p_token_value => l_end_date);
2284:
2285: hr_utility.set_location('Step ' || l_proc,20);
2286: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2287: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2288: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2289:

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

2282: , p_token_name => 'END_DATE'
2283: , p_token_value => l_end_date);
2284:
2285: hr_utility.set_location('Step ' || l_proc,20);
2286: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2287: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2288: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2289:
2290: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

2283: , p_token_value => l_end_date);
2284:
2285: hr_utility.set_location('Step ' || l_proc,20);
2286: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2287: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2288: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2289:
2290: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2291: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

2284:
2285: hr_utility.set_location('Step ' || l_proc,20);
2286: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2287: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2288: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2289:
2290: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2291: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
2292:

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

2316:
2317: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2318: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2319:
2320: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2321: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2322:
2323: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2324:

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

2317: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2318: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2319:
2320: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2321: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2322:
2323: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2324:
2325: END IF;

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

2354:
2355: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2356: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2357:
2358: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2359: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2360:
2361: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2362:

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

2355: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2356: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2357:
2358: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2359: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2360:
2361: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2362:
2363: END IF;

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

2368:
2369: END LOOP;
2370: END IF;
2371:
2372: hr_utility.set_location('Leaving ' || l_proc,20);
2373:
2374: END action_creation;
2375:
2376: PROCEDURE archive_code (p_assactid in number,

Line 2557: -- hr_utility.trace_on(null,'test123');

2553:
2554: l_proc VARCHAR2(50) := g_package || 'archive_code';
2555:
2556: BEGIN
2557: -- hr_utility.trace_on(null,'test123');
2558: hr_utility.set_location('Entering '|| l_proc,10);
2559:
2560: hr_utility.set_location('Step '|| l_proc,20);
2561: hr_utility.set_location('p_assactid = ' || p_assactid,20);

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

2554: l_proc VARCHAR2(50) := g_package || 'archive_code';
2555:
2556: BEGIN
2557: -- hr_utility.trace_on(null,'test123');
2558: hr_utility.set_location('Entering '|| l_proc,10);
2559:
2560: hr_utility.set_location('Step '|| l_proc,20);
2561: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2562:

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

2556: BEGIN
2557: -- hr_utility.trace_on(null,'test123');
2558: hr_utility.set_location('Entering '|| l_proc,10);
2559:
2560: hr_utility.set_location('Step '|| l_proc,20);
2561: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2562:
2563: -- retrieve the chunk number for the current assignment action
2564:

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

2557: -- hr_utility.trace_on(null,'test123');
2558: hr_utility.set_location('Entering '|| l_proc,10);
2559:
2560: hr_utility.set_location('Step '|| l_proc,20);
2561: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2562:
2563: -- retrieve the chunk number for the current assignment action
2564:
2565: SELECT paa.chunk_number

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

2574: FOR csr_rec IN csr_assignment_actions(p_assactid)
2575:
2576: LOOP
2577:
2578: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2579: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2580: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2581: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2582: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);

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

2575:
2576: LOOP
2577:
2578: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2579: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2580: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2581: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2582: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2583: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);

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

2576: LOOP
2577:
2578: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2579: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2580: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2581: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2582: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2583: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2584:

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

2577:
2578: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2579: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2580: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2581: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2582: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2583: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2584:
2585: IF l_record_count = 0

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

2578: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2579: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2580: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2581: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2582: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2583: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2584:
2585: IF l_record_count = 0
2586:

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

2579: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2580: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2581: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2582: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2583: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2584:
2585: IF l_record_count = 0
2586:
2587: THEN

Line 2618: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);

2614: SELECT pay_assignment_actions_s.NEXTVAL
2615: INTO l_actid
2616: FROM dual;
2617:
2618: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);
2619: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);
2620:
2621: hr_nonrun_asact.insact(
2622: lockingactid => l_actid

Line 2619: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);

2615: INTO l_actid
2616: FROM dual;
2617:
2618: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);
2619: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);
2620:
2621: hr_nonrun_asact.insact(
2622: lockingactid => l_actid
2623: , assignid => csr_rec.assignment_id

Line 2638: hr_utility.set_location('creating lock3 ' || l_actid || ' to ' || csr_child_rec.child_assignment_action_id,30);

2634: IF csr_child_rec.run_type = 'S'
2635:
2636: THEN
2637:
2638: hr_utility.set_location('creating lock3 ' || l_actid || ' to ' || csr_child_rec.child_assignment_action_id,30);
2639:
2640: hr_nonrun_asact.insint(
2641: lockingactid => l_actid
2642: , lockedactid => csr_child_rec.child_assignment_action_id);

Line 2686: hr_utility.set_location('l_ppsn_override = ' || l_ppsn_override,35);

2682: OPEN csr_ppsn_override(csr_rec.assignment_id);
2683: FETCH csr_ppsn_override INTO l_ppsn_override;
2684: CLOSE csr_ppsn_override;
2685:
2686: hr_utility.set_location('l_ppsn_override = ' || l_ppsn_override,35);
2687: --6633719
2688:
2689: IF csr_child_rec.run_type in ('N','P')
2690:

Line 2707: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || csr_child_rec.child_assignment_action_id,30);

2703: csr_rec.effective_date)
2704:
2705: LOOP*/
2706:
2707: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || csr_child_rec.child_assignment_action_id,30);
2708:
2709: hr_nonrun_asact.insint(
2710: lockingactid => l_actid
2711: , lockedactid => csr_child_rec.child_assignment_action_id);

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

2743: -- (EMEA BALANCES)
2744:
2745: -- archive user balances
2746:
2747: hr_utility.set_location('Archive User Balances - Starting',60);
2748: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index,60);
2749:
2750: FOR l_index IN 1 .. g_max_user_balance_index
2751:

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

2744:
2745: -- archive user balances
2746:
2747: hr_utility.set_location('Archive User Balances - Starting',60);
2748: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index,60);
2749:
2750: FOR l_index IN 1 .. g_max_user_balance_index
2751:
2752: LOOP

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

2763: , p_tax_unit_id => g_tax_unit_id);
2764:
2765: END LOOP;
2766:
2767: hr_utility.set_location('Archive User Balances - Complete',60);
2768:
2769: -- archive statutory balances
2770:
2771: hr_utility.set_location('Archive Statutory Balances - Starting',70);

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

2767: hr_utility.set_location('Archive User Balances - Complete',60);
2768:
2769: -- archive statutory balances
2770:
2771: hr_utility.set_location('Archive Statutory Balances - Starting',70);
2772: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
2773:
2774: FOR l_index IN 1 .. g_max_statutory_balance_index
2775:

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

2768:
2769: -- archive statutory balances
2770:
2771: hr_utility.set_location('Archive Statutory Balances - Starting',70);
2772: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
2773:
2774: FOR l_index IN 1 .. g_max_statutory_balance_index
2775:
2776: LOOP

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

2774: FOR l_index IN 1 .. g_max_statutory_balance_index
2775:
2776: LOOP
2777:
2778: hr_utility.set_location('l_index = ' || l_index,70);
2779: --6633719
2780: IF g_statutory_balance_table(l_index).database_item_suffix <> '_PER_PAYE_REF_PPSN_YTD'
2781: OR (l_ppsn_override IS NOT NULL
2782: AND g_statutory_balance_table(l_index).database_item_suffix = '_PER_PAYE_REF_PPSN_YTD')

Line 2785: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);

2781: OR (l_ppsn_override IS NOT NULL
2782: AND g_statutory_balance_table(l_index).database_item_suffix = '_PER_PAYE_REF_PPSN_YTD')
2783: THEN
2784: --6633719
2785: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
2786: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
2787: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
2788:
2789: pay_ie_legislative_archive.process_balance (

Line 2786: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);

2782: AND g_statutory_balance_table(l_index).database_item_suffix = '_PER_PAYE_REF_PPSN_YTD')
2783: THEN
2784: --6633719
2785: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
2786: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
2787: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
2788:
2789: pay_ie_legislative_archive.process_balance (
2790: p_action_context_id => l_action_context_id

Line 2787: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);

2783: THEN
2784: --6633719
2785: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
2786: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
2787: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
2788:
2789: pay_ie_legislative_archive.process_balance (
2790: p_action_context_id => l_action_context_id
2791: , p_assignment_id => csr_rec.assignment_id

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

2799: END IF;
2800:
2801: END LOOP;
2802:
2803: hr_utility.set_location('Archive Statutory Balances - Complete',70);
2804:
2805: END LOOP; -- child assignment actions
2806:
2807: l_record_count := l_record_count + 1;

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

2808:
2809:
2810: END LOOP;
2811:
2812: hr_utility.set_location('Leaving '|| l_proc,80);
2813:
2814: END archive_code;
2815:
2816: Procedure ARCHIVE_DEINIT(p_payroll_action_id IN NUMBER) IS

Line 2980: --hr_utility.trace_on(null,'IEPS');

2976:
2977:
2978: BEGIN
2979:
2980: --hr_utility.trace_on(null,'IEPS');
2981: hr_utility.set_location('Entering ' || l_proc,10);
2982:
2983: l_archived := 0;
2984:

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

2977:
2978: BEGIN
2979:
2980: --hr_utility.trace_on(null,'IEPS');
2981: hr_utility.set_location('Entering ' || l_proc,10);
2982:
2983: l_archived := 0;
2984:
2985: OPEN csr_check_archived(p_payroll_action_id);

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

3017: p_payroll_action_id => p_payroll_action_id
3018: , p_token_name => 'BG_ID'
3019: , p_token_value => l_bg_id);
3020:
3021: hr_utility.set_location('Step ' || l_proc,20);
3022: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3023: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3024: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3025:

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

3018: , p_token_name => 'BG_ID'
3019: , p_token_value => l_bg_id);
3020:
3021: hr_utility.set_location('Step ' || l_proc,20);
3022: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3023: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3024: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3025:
3026: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

3019: , p_token_value => l_bg_id);
3020:
3021: hr_utility.set_location('Step ' || l_proc,20);
3022: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3023: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3024: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3025:
3026: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3027: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

3020:
3021: hr_utility.set_location('Step ' || l_proc,20);
3022: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3023: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3024: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3025:
3026: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3027: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3028:

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

3027: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3028:
3029: -- archive EMEA PAYROLL INFO for each prepayment run identified
3030:
3031: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3032: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3033: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3034: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3035:

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

3028:
3029: -- archive EMEA PAYROLL INFO for each prepayment run identified
3030:
3031: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3032: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3033: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3034: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3035:
3036: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value

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

3029: -- archive EMEA PAYROLL INFO for each prepayment run identified
3030:
3031: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3032: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3033: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3034: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3035:
3036: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
3037: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);

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

3030:
3031: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3032: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3033: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3034: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3035:
3036: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
3037: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3038:

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

3090: l_consolidation_set,
3091: l_canonical_end_date)
3092: LOOP
3093:
3094: hr_utility.set_location('Calling arch_pay_action_level_data',25);
3095: --
3096:
3097: pay_emp_action_arch.arch_pay_action_level_data (
3098: p_payroll_action_id => p_payroll_action_id

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

3111:
3112: LOOP
3113: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3114: , rec_payroll_info.payroll_action_id);
3115: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3116: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3117: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3118:
3119: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);

Line 3116: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);

3112: LOOP
3113: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3114: , rec_payroll_info.payroll_action_id);
3115: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3116: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3117: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3118:
3119: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3120:

Line 3117: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);

3113: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3114: , rec_payroll_info.payroll_action_id);
3115: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3116: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3117: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3118:
3119: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3120:
3121: pay_action_information_api.create_action_information (

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

3115: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3116: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3117: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3118:
3119: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3120:
3121: pay_action_information_api.create_action_information (
3122: p_action_information_id => l_action_info_id
3123: , p_action_context_id => p_payroll_action_id

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

3168: END IF;
3169:
3170: END LOOP;
3171:
3172: hr_utility.set_location('Leaving ' || l_proc,40);
3173: end if;
3174: END IF;
3175: END ARCHIVE_DEINIT;
3176: