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: -- Start fix for Bug#8522324

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

195: l_proc VARCHAR2(60) := g_package || ' get_pay_deduct_element_info';
196:
197:
198: BEGIN
199: hr_utility.set_location('Entering ' || l_proc,10);
200: hr_utility.set_location('p_assignment_action_id = ' || p_assignment_action_id,10);
201:
202: if (p_assignment_id is null or p_effective_date is null)
203: then

Line 200: hr_utility.set_location('p_assignment_action_id = ' || p_assignment_action_id,10);

196:
197:
198: BEGIN
199: hr_utility.set_location('Entering ' || l_proc,10);
200: hr_utility.set_location('p_assignment_action_id = ' || p_assignment_action_id,10);
201:
202: if (p_assignment_id is null or p_effective_date is null)
203: then
204: select paa.assignment_id, ppa.effective_date

Line 223: hr_utility.set_location('element_type_id = ' || rec_element_value.element_type_id,20);

219: , 'P'
220: , 'D')
221: loop
222:
223: hr_utility.set_location('element_type_id = ' || rec_element_value.element_type_id,20);
224: hr_utility.set_location('input_value_id = ' || rec_element_value.input_value_id,20);
225: hr_utility.set_location('assignment_id = ' || l_assignment_id,20);
226: hr_utility.set_location('effective_date = ' || l_effective_date,20);
227:

Line 224: hr_utility.set_location('input_value_id = ' || rec_element_value.input_value_id,20);

220: , 'D')
221: loop
222:
223: hr_utility.set_location('element_type_id = ' || rec_element_value.element_type_id,20);
224: hr_utility.set_location('input_value_id = ' || rec_element_value.input_value_id,20);
225: hr_utility.set_location('assignment_id = ' || l_assignment_id,20);
226: hr_utility.set_location('effective_date = ' || l_effective_date,20);
227:
228: if ((rec_element_value.element_type_id is not null)

Line 225: hr_utility.set_location('assignment_id = ' || l_assignment_id,20);

221: loop
222:
223: hr_utility.set_location('element_type_id = ' || rec_element_value.element_type_id,20);
224: hr_utility.set_location('input_value_id = ' || rec_element_value.input_value_id,20);
225: hr_utility.set_location('assignment_id = ' || l_assignment_id,20);
226: hr_utility.set_location('effective_date = ' || l_effective_date,20);
227:
228: if ((rec_element_value.element_type_id is not null)
229: and (rec_element_value.input_value_id is not null)

Line 226: hr_utility.set_location('effective_date = ' || l_effective_date,20);

222:
223: hr_utility.set_location('element_type_id = ' || rec_element_value.element_type_id,20);
224: hr_utility.set_location('input_value_id = ' || rec_element_value.input_value_id,20);
225: hr_utility.set_location('assignment_id = ' || l_assignment_id,20);
226: hr_utility.set_location('effective_date = ' || l_effective_date,20);
227:
228: if ((rec_element_value.element_type_id is not null)
229: and (rec_element_value.input_value_id is not null)
230: and (rec_element_value.payment_type is not null)

Line 234: hr_utility.set_location('Archiving EMEA ELEMENT INFO',30);

230: and (rec_element_value.payment_type is not null)
231: and (rec_element_value.value is not null)
232: and (rec_element_value.narrative is not null))
233: then
234: hr_utility.set_location('Archiving EMEA ELEMENT INFO',30);
235: /* Creating action information */
236: pay_action_information_api.create_action_information (
237: p_action_information_id => l_action_info_id
238: , p_action_context_id => p_assignment_action_id

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

250:
251: end if;
252: end loop;
253:
254: hr_utility.set_location('Leaving ' || l_proc,20);
255:
256: EXCEPTION
257: WHEN OTHERS
258: THEN

Line 259: hr_utility.set_location('Exception occured in get_pay_deduct_element_info '||SQLERRM,50);

255:
256: EXCEPTION
257: WHEN OTHERS
258: THEN
259: hr_utility.set_location('Exception occured in get_pay_deduct_element_info '||SQLERRM,50);
260: RAISE;
261:
262: END get_pay_deduct_element_info;
263: -- End fix for Bug#8522324

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

326: l_proc VARCHAR2(50) := g_package || 'get_eit_definitions';
327:
328: BEGIN
329:
330: hr_utility.set_location('Entering ' || l_proc,10);
331:
332: hr_utility.set_location('Step ' || l_proc,20);
333: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
334:

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

328: BEGIN
329:
330: hr_utility.set_location('Entering ' || l_proc,10);
331:
332: hr_utility.set_location('Step ' || l_proc,20);
333: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
334:
335: FOR csr_eit_rec IN csr_eit_values(p_business_group_id,
336: p_eit_context)

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

329:
330: hr_utility.set_location('Entering ' || l_proc,10);
331:
332: hr_utility.set_location('Step ' || l_proc,20);
333: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
334:
335: FOR csr_eit_rec IN csr_eit_values(p_business_group_id,
336: p_eit_context)
337:

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

336: p_eit_context)
337:
338: LOOP
339:
340: hr_utility.set_location('Step ' || l_proc,30);
341:
342: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);

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

338: LOOP
339:
340: hr_utility.set_location('Step ' || l_proc,30);
341:
342: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
345: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
346: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);

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

339:
340: hr_utility.set_location('Step ' || l_proc,30);
341:
342: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
345: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
346: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
347: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);

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

340: hr_utility.set_location('Step ' || l_proc,30);
341:
342: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
345: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
346: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
347: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
348:

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

341:
342: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
345: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
346: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
347: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
348:
349: IF p_eit_context = g_balance_context

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

342: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
345: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
346: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
347: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
348:
349: IF p_eit_context = g_balance_context
350:

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

343: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
344: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
345: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
346: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
347: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
348:
349: IF p_eit_context = g_balance_context
350:
351: THEN

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

366: g_user_balance_table(l_index).defined_balance_id;
367:
368: CLOSE csr_balance_name;
369:
370: hr_utility.set_location('Arch EMEA BALANCE DEFINITION',99);
371:
372: IF p_archive = 'Y'
373:
374: THEN

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

417: IF p_archive = 'Y'
418:
419: THEN
420:
421: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
422:
423: pay_action_information_api.create_action_information (
424: p_action_information_id => l_action_info_id
425: , p_action_context_id => p_pactid

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

441: END IF;
442:
443: l_index := l_index + 1;
444:
445: hr_utility.set_location('l_index = ' || l_index,99);
446:
447: END LOOP;
448:
449: g_max_element_index := l_index;

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

459: g_element_archive_index := l_index - 1;
460:
461: END IF;
462:
463: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index,99);
464:
465: hr_utility.set_location('Leaving ' || l_proc,30);
466:
467: END get_eit_definitions;

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

461: END IF;
462:
463: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index,99);
464:
465: hr_utility.set_location('Leaving ' || l_proc,30);
466:
467: END get_eit_definitions;
468:
469:

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

558: l_proc VARCHAR2(60) := g_package || 'setup_element_definitions';
559:
560: BEGIN
561:
562: hr_utility.set_location('Entering ' || l_proc,10);
563:
564: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact,10);
565:
566:

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

560: BEGIN
561:
562: hr_utility.set_location('Entering ' || l_proc,10);
563:
564: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact,10);
565:
566:
567: FOR csr_element_rec IN csr_element_name(p_business_group_id,
568: p_effective_date)

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

567: FOR csr_element_rec IN csr_element_name(p_business_group_id,
568: p_effective_date)
569: LOOP
570:
571: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id,20);
572: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name,20);
573:
574: IF csr_element_rec.classification_name IN
575: ('Earnings', 'IE Earnings Non PRSIable', 'IE Earnings Non Taxable and Non PRSIable')

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

568: p_effective_date)
569: LOOP
570:
571: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id,20);
572: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name,20);
573:
574: IF csr_element_rec.classification_name IN
575: ('Earnings', 'IE Earnings Non PRSIable', 'IE Earnings Non Taxable and Non PRSIable')
576: -- Bug 2943335 Added 'IE Earnings Non PRSIable' and'IE Earnings Non Taxable and Non PRSIable'

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

606: END IF;
607:
608:
609:
610: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
611:
612: IF l_payment_type_bik='P'
613: THEN
614: pay_action_information_api.create_action_information (

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

669: END IF;
670:
671: END LOOP;
672:
673: hr_utility.set_location('Leaving ' || l_proc,30);
674:
675: END setup_element_definitions;
676:
677: PROCEDURE setup_standard_balance_table

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

730:
731:
732:
733:
734: hr_utility.set_location('Entering ' || l_proc,10);
735:
736: hr_utility.set_location('Step ' || l_proc,20);
737:
738: l_statutory_balance(1).balance_name := 'IE Total Deductions';

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

732:
733:
734: hr_utility.set_location('Entering ' || l_proc,10);
735:
736: hr_utility.set_location('Step ' || l_proc,20);
737:
738: l_statutory_balance(1).balance_name := 'IE Total Deductions';
739: l_statutory_balance(2).balance_name := 'IE Taxable Pay';
740: l_statutory_balance(3).balance_name := 'IE PRSIable Pay';

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

782:
783: l_statutory_balance(32).balance_name := 'IE PRSA ER Contribution'; --13013273
784: l_statutory_balance(33).balance_name := 'IE Illness Benefit'; --14656910
785:
786: hr_utility.set_location('Step = ' || l_proc,30);
787:
788: FOR l_index IN 1 .. l_max_stat_balance
789:
790: LOOP

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

789:
790: LOOP
791:
792: l_dimension := '_ASG_YTD';
793: hr_utility.set_location('l_index = ' || l_index,30);
794: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
795: hr_utility.set_location('l_dimension = ' || l_dimension,30);
796:
797:

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

790: LOOP
791:
792: l_dimension := '_ASG_YTD';
793: hr_utility.set_location('l_index = ' || l_index,30);
794: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
795: hr_utility.set_location('l_dimension = ' || l_dimension,30);
796:
797:
798: IF l_statutory_balance(l_index).balance_name = 'IE PRSI Insurable Weeks' then

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

791:
792: l_dimension := '_ASG_YTD';
793: hr_utility.set_location('l_index = ' || l_index,30);
794: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
795: hr_utility.set_location('l_dimension = ' || l_dimension,30);
796:
797:
798: IF l_statutory_balance(l_index).balance_name = 'IE PRSI Insurable Weeks' then
799: l_dimension := l_dimension_1;

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

848: END IF;
849:
850: CLOSE csr_balance_dimension;
851:
852: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index_id).defined_balance_id,30);
853:
854: --6633719
855: l_index_id := l_index_id + 1;
856: OPEN csr_balance_dimension(l_statutory_balance(l_index).balance_name,

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

873: --6633719
874:
875: END LOOP;
876:
877: hr_utility.set_location('Step = ' || l_proc,40);
878:
879: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
880: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
881:

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

875: END LOOP;
876:
877: hr_utility.set_location('Step = ' || l_proc,40);
878:
879: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
880: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
881:
882: FOR l_index IN 1 .. l_index_id
883:

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

876:
877: hr_utility.set_location('Step = ' || l_proc,40);
878:
879: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
880: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
881:
882: FOR l_index IN 1 .. l_index_id
883:
884: LOOP

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

888: FOR l_eit_index IN 1 .. g_max_user_balance_index
889:
890: LOOP
891:
892: hr_utility.set_location('l_index = ' || l_index,40);
893: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
894: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
895: hr_utility.set_location('l_found = ' || l_found,40);
896:

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

889:
890: LOOP
891:
892: hr_utility.set_location('l_index = ' || l_index,40);
893: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
894: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
895: hr_utility.set_location('l_found = ' || l_found,40);
896:
897: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id

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

890: LOOP
891:
892: hr_utility.set_location('l_index = ' || l_index,40);
893: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
894: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
895: hr_utility.set_location('l_found = ' || l_found,40);
896:
897: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id
898:

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

891:
892: hr_utility.set_location('l_index = ' || l_index,40);
893: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
894: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
895: hr_utility.set_location('l_found = ' || l_found,40);
896:
897: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id
898:
899: THEN

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

909: THEN
910:
911: l_archive_index := l_archive_index + 1;
912:
913: hr_utility.set_location('l_archive_index = ' || l_archive_index,40);
914:
915: g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_index).defined_balance_id;
916: g_statutory_balance_table(l_archive_index).balance_name := l_statutory_bal_id(l_index).balance_name; --4879850
917: g_statutory_balance_table(l_archive_index).database_item_suffix := l_statutory_bal_id(l_index).dimension_name; --6633719

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

922: END LOOP;
923:
924: g_max_statutory_balance_index := l_archive_index;
925:
926: hr_utility.set_location('Step ' || l_proc,50);
927: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
928:
929: hr_utility.set_location('Leaving ' || l_proc,60);
930:

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

923:
924: g_max_statutory_balance_index := l_archive_index;
925:
926: hr_utility.set_location('Step ' || l_proc,50);
927: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
928:
929: hr_utility.set_location('Leaving ' || l_proc,60);
930:
931: END setup_standard_balance_table;

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

925:
926: hr_utility.set_location('Step ' || l_proc,50);
927: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
928:
929: hr_utility.set_location('Leaving ' || l_proc,60);
930:
931: END setup_standard_balance_table;
932:
933:

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

1027:
1028: BEGIN
1029:
1030: --
1031: hr_utility.set_location('Entering ' || l_proc,10);
1032:
1033: g_archive_pact := p_payroll_action_id;
1034:
1035: OPEN csr_archive_effective_date(p_payroll_action_id);

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

1068: p_payroll_action_id => p_payroll_action_id
1069: , p_token_name => 'BG_ID'
1070: , p_token_value => l_bg_id);
1071:
1072: hr_utility.set_location('Step ' || l_proc,20);
1073: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1074: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1075: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1076:

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

1069: , p_token_name => 'BG_ID'
1070: , p_token_value => l_bg_id);
1071:
1072: hr_utility.set_location('Step ' || l_proc,20);
1073: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1074: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1075: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1076:
1077: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

1070: , p_token_value => l_bg_id);
1071:
1072: hr_utility.set_location('Step ' || l_proc,20);
1073: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1074: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1075: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1076:
1077: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1078: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

1071:
1072: hr_utility.set_location('Step ' || l_proc,20);
1073: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1074: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1075: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1076:
1077: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1078: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1079:

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

1078: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1079:
1080: -- Get Payroll Period Type
1081:
1082: hr_utility.set_location('Getting Period Type of the Payroll', 30);
1083:
1084: OPEN csr_payroll_type(l_payroll_id,
1085: g_archive_effective_date);
1086:

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

1087: FETCH csr_payroll_type INTO l_payroll_type;
1088:
1089: CLOSE csr_payroll_type;
1090:
1091: hr_utility.set_location('l_payroll_type = '|| l_payroll_type, 30);
1092:
1093: IF l_payroll_type in ('Week', 'Bi-Week', 'Lunar Month') THEN
1094: l_tax_credit_value := 'Weekly Tax Credit';
1095: l_std_cut_off_value := 'Weekly Standard Rate Cutoff';

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

1100: l_std_cut_off_value := 'Monthly Standard Rate Cutoff';
1101:
1102: END IF;
1103:
1104: hr_utility.set_location('l_tax_credit_value = '|| l_tax_credit_value, 30);
1105: hr_utility.set_location('l_std_cut_off_value = '|| l_std_cut_off_value, 30);
1106:
1107: -- retrieve ids for tax elements
1108:

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

1101:
1102: END IF;
1103:
1104: hr_utility.set_location('l_tax_credit_value = '|| l_tax_credit_value, 30);
1105: hr_utility.set_location('l_std_cut_off_value = '|| l_std_cut_off_value, 30);
1106:
1107: -- retrieve ids for tax elements
1108:
1109: OPEN csr_input_value_id('IE PAYE details',l_tax_credit_value);

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

1112: g_tax_credit_id;
1113:
1114: CLOSE csr_input_value_id;
1115:
1116: hr_utility.set_location('g_tax_credit_id = '|| to_char(g_tax_credit_id), 30);
1117:
1118: OPEN csr_input_value_id('IE PAYE details',l_std_cut_off_value);
1119:
1120: FETCH csr_input_value_id INTO g_paye_details_element_id,

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

1121: g_std_cut_off_id;
1122:
1123: CLOSE csr_input_value_id;
1124:
1125: hr_utility.set_location('g_std_cut_off_id = '|| to_char(g_std_cut_off_id), 30);
1126:
1127: OPEN csr_input_value_id('IE PAYE details','Tax Basis');
1128:
1129: FETCH csr_input_value_id INTO g_paye_details_element_id,

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

1163: OPEN csr_get_tax_unit_id(l_bg_id,l_consolidation_set,l_canonical_start_date,l_canonical_end_date);
1164: FETCH csr_get_tax_unit_id INTO g_tax_unit_id;
1165: CLOSE csr_get_tax_unit_id;
1166:
1167: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1168: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1169: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1170: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1171:

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

1164: FETCH csr_get_tax_unit_id INTO g_tax_unit_id;
1165: CLOSE csr_get_tax_unit_id;
1166:
1167: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1168: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1169: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1170: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1171:
1172:

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

1165: CLOSE csr_get_tax_unit_id;
1166:
1167: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1168: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1169: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1170: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1171:
1172:
1173: -- retrieve and archive user defintions from EITs

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

1166:
1167: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1168: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1169: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1170: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1171:
1172:
1173: -- retrieve and archive user defintions from EITs
1174:

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

1173: -- retrieve and archive user defintions from EITs
1174:
1175: g_max_user_balance_index := 0;
1176:
1177: hr_utility.set_location('get_eit_definitions - balances',20);
1178:
1179: pay_ie_legislative_archive.get_eit_definitions (
1180: p_pactid => p_payroll_action_id
1181: , p_business_group_id => l_bg_id

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

1183: , p_effective_date => l_canonical_start_date
1184: , p_eit_context => g_balance_context
1185: , p_archive => 'N');
1186:
1187: hr_utility.set_location('get_eit_definitions - elements',20);
1188:
1189: pay_ie_legislative_archive.get_eit_definitions (
1190: p_pactid => p_payroll_action_id
1191: , p_business_group_id => l_bg_id

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

1217: -- setup statutory balances pl/sql table
1218:
1219: pay_ie_legislative_archive.setup_standard_balance_table;
1220:
1221: hr_utility.set_location('Leaving ' || l_proc,20);
1222: --
1223:
1224: END archinit;
1225:

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

1239: l_proc VARCHAR2(60) := g_package || 'archive_employee_details';
1240:
1241: BEGIN
1242:
1243: hr_utility.set_location('Entering ' || l_proc,10);
1244:
1245: -- call generic procedure to retrieve and archive all data for
1246: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1247:

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

1244:
1245: -- call generic procedure to retrieve and archive all data for
1246: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1247:
1248: hr_utility.set_location('Calling pay_emp_action_arch',20);
1249:
1250: pay_emp_action_arch.get_personal_information (
1251: p_payroll_action_id => g_archive_pact -- archive payroll_action_id
1252: , p_assactid => p_assactid -- archive assignment_action_id

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

1259: , p_tax_unit_id => NULL -- only required for US
1260: , p_time_period_id => p_time_period_id -- payroll time_period_id
1261: , p_ppp_source_action_id => NULL);
1262: --
1263: hr_utility.set_location('Leaving ' || l_proc,30);
1264: --
1265: END archive_employee_details;
1266:
1267: PROCEDURE archive_ie_employee_details (

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

1327: --
1328: EXCEPTION
1329: WHEN NO_DATA_FOUND THEN
1330: l_first_name := NULL;
1331: hr_utility.trace('First Name : NULL ');
1332: return l_first_name;
1333: --
1334: END get_first_name;
1335:

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

1366: --
1367: EXCEPTION
1368: WHEN NO_DATA_FOUND THEN
1369: l_last_name := NULL;
1370: hr_utility.trace('Last Name : NULL ');
1371: RETURN l_last_name;
1372: --
1373: END get_last_name;
1374:

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

1405: --
1406: EXCEPTION
1407: WHEN NO_DATA_FOUND THEN
1408: l_dob := NULL;
1409: hr_utility.trace('DOB : NULL ');
1410: return l_dob;
1411: --
1412: END get_dob;
1413:

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

1414:
1415:
1416: BEGIN
1417:
1418: hr_utility.set_location('Entering ' || l_proc,10);
1419:
1420: -- Retrieve and Archive the IE specific employee details
1421:
1422: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (

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

1423: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1424: ,p_input_value_id => g_tax_basis_id
1425: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1426:
1427: hr_utility.set_location('l_tax_basis = ' || l_tax_basis,40);
1428:
1429: l_prsi_cat := pay_ie_archive_detail_pkg.get_tax_details (
1430: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1431: ,p_input_value_id => g_prsi_cat_id

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

1430: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1431: ,p_input_value_id => g_prsi_cat_id
1432: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1433:
1434: hr_utility.set_location('l_prsi_cat = ' || l_prsi_cat,40);
1435:
1436: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1437: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1438: ,p_input_value_id => g_prsi_subcat_id

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

1437: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1438: ,p_input_value_id => g_prsi_subcat_id
1439: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1440:
1441: hr_utility.set_location('l_prsi_subcat = ' || l_prsi_subcat,40);
1442:
1443: l_ins_weeks := pay_ie_archive_detail_pkg.get_tax_details (
1444: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1445: ,p_input_value_id => g_ins_weeks_id

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

1444: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1445: ,p_input_value_id => g_ins_weeks_id
1446: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1447:
1448: hr_utility.set_location('l_ins_weeks = ' || l_ins_weeks,40);
1449:
1450: l_tax_credit := pay_ie_archive_detail_pkg.get_tax_details (
1451: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1452: ,p_input_value_id => g_tax_credit_id

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

1451: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1452: ,p_input_value_id => g_tax_credit_id
1453: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1454:
1455: hr_utility.set_location('l_tax_credit = ' || l_tax_credit,40);
1456:
1457: l_std_cut_off := pay_ie_archive_detail_pkg.get_tax_details (
1458: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1459: ,p_input_value_id => g_std_cut_off_id

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

1458: p_run_assignment_action_id => p_curr_pymt_ass_act_id
1459: ,p_input_value_id => g_std_cut_off_id
1460: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1461:
1462: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);
1463:
1464: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);
1465: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);
1466:

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

1460: ,p_date_earned => to_char(p_effective_date, 'yyyy/mm/dd'));
1461:
1462: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);
1463:
1464: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);
1465: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);
1466:
1467: l_prsi_week := pay_balance_pkg.get_value (g_prsi_week_id,
1468: p_curr_pymt_ass_act_id,

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

1461:
1462: hr_utility.set_location('l_std_cut_off = ' || l_std_cut_off,40);
1463:
1464: hr_utility.set_location('g_prsi_week_id = ' || g_prsi_week_id,41);
1465: hr_utility.set_location('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id,42);
1466:
1467: l_prsi_week := pay_balance_pkg.get_value (g_prsi_week_id,
1468: p_curr_pymt_ass_act_id,
1469: false);

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

1467: l_prsi_week := pay_balance_pkg.get_value (g_prsi_week_id,
1468: p_curr_pymt_ass_act_id,
1469: false);
1470:
1471: hr_utility.set_location('l_prsi_week = ' || l_prsi_week,45);
1472:
1473: l_firstname := get_first_name(p_curr_pymt_ass_act_id);
1474: l_surname := get_last_name(p_curr_pymt_ass_act_id);
1475: l_dob := get_dob(p_curr_pymt_ass_act_id);

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

1517: l_tax_basis_det := l_tax_basis;
1518:
1519: END IF;
1520:
1521: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1522:
1523: pay_action_information_api.create_action_information (
1524: p_action_information_id => l_action_info_id
1525: , p_action_context_id => p_assactid

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

1544: , p_action_information28 => l_firstname
1545: , p_action_information29 => l_surname);
1546:
1547: --
1548: hr_utility.set_location('Leaving ' || l_proc,60);
1549: --
1550: END archive_ie_employee_details;
1551:
1552: PROCEDURE process_balance (p_action_context_id IN NUMBER,

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

1603: l_proc VARCHAR2(50) := g_package || 'process_balance';
1604:
1605: BEGIN
1606:
1607: hr_utility.set_location('Entering ' || l_proc,10);
1608:
1609: hr_utility.set_location('Step ' || l_proc,20);
1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);

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

1605: BEGIN
1606:
1607: hr_utility.set_location('Entering ' || l_proc,10);
1608:
1609: hr_utility.set_location('Step ' || l_proc,20);
1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);

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

1606:
1607: hr_utility.set_location('Entering ' || l_proc,10);
1608:
1609: hr_utility.set_location('Step ' || l_proc,20);
1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1614: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);

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

1607: hr_utility.set_location('Entering ' || l_proc,10);
1608:
1609: hr_utility.set_location('Step ' || l_proc,20);
1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1614: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1615: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);

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

1608:
1609: hr_utility.set_location('Step ' || l_proc,20);
1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1614: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1615: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1616:

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

1609: hr_utility.set_location('Step ' || l_proc,20);
1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1614: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1615: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1616:
1617: -- Added for Bug 2545070 to handle PAYROLL REVERSALS

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

1610: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1614: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1615: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1616:
1617: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1618: OPEN csr_get_reversal_action_id(p_source_id);

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

1611: hr_utility.set_location('p_balance = ' || p_balance,20);
1612: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1613: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1614: hr_utility.set_location('p_tax_unit_id = ' || p_tax_unit_id,20);
1615: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1616:
1617: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1618: OPEN csr_get_reversal_action_id(p_source_id);
1619: FETCH csr_get_reversal_action_id INTO l_rev_asg_action_id;

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

1619: FETCH csr_get_reversal_action_id INTO l_rev_asg_action_id;
1620: CLOSE csr_get_reversal_action_id;
1621: l_source_id := NVL(l_rev_asg_action_id,p_source_id);
1622:
1623: hr_utility.set_location('l_source_id = ' || l_source_id,20);
1624:
1625: OPEN Cur_Act_Contexts;
1626: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1627: CLOSE Cur_Act_Contexts;

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

1625: OPEN Cur_Act_Contexts;
1626: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1627: CLOSE Cur_Act_Contexts;
1628:
1629: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_ID= ' || v_Cur_Act_Contexts.CONTEXT_ID,20);
1630: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_VALUE= ' || v_Cur_Act_Contexts.CONTEXT_VALUE,20);
1631:
1632: -- Added if condition for 4879850
1633: -- Instead of checking Balance Name we now check the dimension for passing the Source Text Value to support SOE Balances

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

1626: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1627: CLOSE Cur_Act_Contexts;
1628:
1629: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_ID= ' || v_Cur_Act_Contexts.CONTEXT_ID,20);
1630: hr_utility.set_location('v_Cur_Act_Contexts.CONTEXT_VALUE= ' || v_Cur_Act_Contexts.CONTEXT_VALUE,20);
1631:
1632: -- Added if condition for 4879850
1633: -- Instead of checking Balance Name we now check the dimension for passing the Source Text Value to support SOE Balances
1634: -- Defined at BG Level which needs Source Text Context 5192325

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

1655: null,
1656: null);
1657: end if;
1658:
1659: hr_utility.set_location('l_balance_value = ' || l_balance_value,20);
1660: IF p_record_count = 0
1661:
1662: THEN
1663:

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

1670: IF l_balance_value <> 0
1671:
1672: THEN
1673:
1674: hr_utility.set_location('Archiving EMEA BALANCES',20);
1675:
1676: pay_action_information_api.create_action_information (
1677: p_action_information_id => l_action_info_id
1678: , p_action_context_id => p_action_context_id

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

1690: , p_action_information5 => l_record_count);
1691:
1692: END IF;
1693:
1694: hr_utility.set_location('Leaving ' || l_proc,30);
1695:
1696: EXCEPTION
1697:
1698: WHEN NO_DATA_FOUND

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

1768:
1769:
1770: BEGIN
1771:
1772: hr_utility.set_location('Entering get_element_info',10);
1773:
1774: l_column_sequence := 0;
1775: l_element_type_id := 0;
1776: l_main_sequence := 0;

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

1787: l_record_count := p_record_count + 1;
1788:
1789: END IF;
1790:
1791: hr_utility.set_location('g_max_element_index = ' || g_max_element_index,10);
1792:
1793: FOR l_index IN 1 .. g_max_element_index
1794:
1795: LOOP

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

1793: FOR l_index IN 1 .. g_max_element_index
1794:
1795: LOOP
1796:
1797: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1798: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1799: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1800: hr_utility.set_location('p_run_method = ' || p_run_method,10);
1801:

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

1794:
1795: LOOP
1796:
1797: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1798: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1799: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1800: hr_utility.set_location('p_run_method = ' || p_run_method,10);
1801:
1802: --12740029

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

1795: LOOP
1796:
1797: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1798: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1799: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1800: hr_utility.set_location('p_run_method = ' || p_run_method,10);
1801:
1802: --12740029
1803: l_child_assignment_action := p_child_assignment_action;

Line 1800: hr_utility.set_location('p_run_method = ' || p_run_method,10);

1796:
1797: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1798: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1799: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1800: hr_utility.set_location('p_run_method = ' || p_run_method,10);
1801:
1802: --12740029
1803: l_child_assignment_action := p_child_assignment_action;
1804: l_run_method := p_run_method;

Line 1815: hr_utility.set_location('csr_element_values NOT FOUND ',10);

1811: , g_element_table(l_index).input_value_id);
1812: FETCH csr_element_values INTO l_result_value1;
1813:
1814: IF csr_element_values%NOTFOUND THEN
1815: hr_utility.set_location('csr_element_values NOT FOUND ',10);
1816: CLOSE csr_element_values;
1817: OPEN c_other_child_asg_act_id(p_assignment_id, p_effective_date, p_child_assignment_action);
1818: FETCH c_other_child_asg_act_id INTO l_oth_child_asg_action_id, l_run_method;
1819: CLOSE c_other_child_asg_act_id;

Line 1823: hr_utility.set_location('csr_element_values FOUND ',10);

1819: CLOSE c_other_child_asg_act_id;
1820: l_child_assignment_action := l_oth_child_asg_action_id;
1821: l_run_method := l_run_method;
1822: ELSE
1823: hr_utility.set_location('csr_element_values FOUND ',10);
1824: CLOSE csr_element_values;
1825: l_child_assignment_action := p_child_assignment_action;
1826: l_run_method := p_run_method;
1827: END IF;

Line 1831: hr_utility.set_location('l_child_assignment_action = ' || l_child_assignment_action,11);

1827: END IF;
1828:
1829: END IF;
1830:
1831: hr_utility.set_location('l_child_assignment_action = ' || l_child_assignment_action,11);
1832: hr_utility.set_location('l_run_method = ' || l_run_method,11);
1833: --12740029
1834:
1835: FOR rec_element_value IN csr_element_values (

Line 1832: hr_utility.set_location('l_run_method = ' || l_run_method,11);

1828:
1829: END IF;
1830:
1831: hr_utility.set_location('l_child_assignment_action = ' || l_child_assignment_action,11);
1832: hr_utility.set_location('l_run_method = ' || l_run_method,11);
1833: --12740029
1834:
1835: FOR rec_element_value IN csr_element_values (
1836: --p_child_assignment_action --12740029

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

1839: , g_element_table(l_index).input_value_id)
1840:
1841: LOOP
1842:
1843: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1844: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1845: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1846:
1847: IF l_element_type_id <> g_element_table(l_index).element_type_id

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

1840:
1841: LOOP
1842:
1843: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1844: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1845: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1846:
1847: IF l_element_type_id <> g_element_table(l_index).element_type_id
1848:

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

1841: LOOP
1842:
1843: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1844: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1845: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1846:
1847: IF l_element_type_id <> g_element_table(l_index).element_type_id
1848:
1849: THEN

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

1851: l_main_sequence := l_main_sequence + 1;
1852:
1853: END IF;
1854:
1855: hr_utility.set_location('l_main_sequence = ' || l_main_sequence,20);
1856:
1857: l_column_sequence := l_column_sequence + 1;
1858:
1859: -- If the run method is P, Process Separate, then only archive the data if

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

1963:
1964:
1965: begin
1966:
1967: hr_utility.set_location('Entering ' || l_proc,10);
1968:
1969: for l_payroll_id in get_payrolls
1970: loop
1971: open get_paye_reference_details(l_payroll_id.payroll_id);

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

1980: g_paye_ref:=l_paye_value;
1981: end if;
1982: end loop;
1983: close get_paye_reference_details;
1984: hr_utility.trace('paye ref='||l_paye_value);
1985: end loop;
1986:
1987: hr_utility.set_location('Leaving ' || l_proc,40);
1988:

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

1983: close get_paye_reference_details;
1984: hr_utility.trace('paye ref='||l_paye_value);
1985: end loop;
1986:
1987: hr_utility.set_location('Leaving ' || l_proc,40);
1988:
1989: exception when c_error then
1990: l_error := 'Y';
1991: g_paye_ref:=null;

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

2144:
2145:
2146: BEGIN
2147:
2148: --hr_utility.trace_on(null,'IEPS');
2149: hr_utility.set_location('Entering ' || l_proc,10);
2150:
2151: pay_ie_legislative_archive.get_parameters (
2152: p_payroll_action_id => pactid

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

2145:
2146: BEGIN
2147:
2148: --hr_utility.trace_on(null,'IEPS');
2149: hr_utility.set_location('Entering ' || l_proc,10);
2150:
2151: pay_ie_legislative_archive.get_parameters (
2152: p_payroll_action_id => pactid
2153: , p_token_name => 'PAYROLL'

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

2177: p_payroll_action_id => pactid
2178: , p_token_name => 'BG_ID'
2179: , p_token_value => l_bg_id);
2180:
2181: hr_utility.set_location('Step ' || l_proc,20);
2182: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2183: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2184: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2185:

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

2178: , p_token_name => 'BG_ID'
2179: , p_token_value => l_bg_id);
2180:
2181: hr_utility.set_location('Step ' || l_proc,20);
2182: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2183: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2184: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2185:
2186: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

2179: , p_token_value => l_bg_id);
2180:
2181: hr_utility.set_location('Step ' || l_proc,20);
2182: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2183: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2184: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2185:
2186: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2187: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

2180:
2181: hr_utility.set_location('Step ' || l_proc,20);
2182: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2183: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2184: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2185:
2186: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2187: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
2188:

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

2187: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
2188:
2189: -- archive EMEA PAYROLL INFO for each prepayment run identified
2190:
2191: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2192: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2193: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2194: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2195:

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

2188:
2189: -- archive EMEA PAYROLL INFO for each prepayment run identified
2190:
2191: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2192: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2193: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2194: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2195:
2196: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value

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

2189: -- archive EMEA PAYROLL INFO for each prepayment run identified
2190:
2191: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2192: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2193: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2194: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2195:
2196: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
2197: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);

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

2190:
2191: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2192: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2193: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2194: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2195:
2196: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
2197: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
2198:

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

2260: l_consolidation_set,
2261: l_canonical_end_date)
2262: LOOP
2263:
2264: hr_utility.set_location('Calling arch_pay_action_level_data',25);
2265: --
2266:
2267: pay_emp_action_arch.arch_pay_action_level_data (
2268: p_payroll_action_id => pactid

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

2280:
2281: LOOP
2282: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
2283: , rec_payroll_info.payroll_action_id);
2284: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2285: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
2286: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
2287:
2288: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);

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

2281: LOOP
2282: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
2283: , rec_payroll_info.payroll_action_id);
2284: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2285: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
2286: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
2287:
2288: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2289:

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

2282: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
2283: , rec_payroll_info.payroll_action_id);
2284: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2285: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
2286: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
2287:
2288: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2289:
2290: pay_action_information_api.create_action_information (

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

2284: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2285: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
2286: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
2287:
2288: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2289:
2290: pay_action_information_api.create_action_information (
2291: p_action_information_id => l_action_info_id
2292: , p_action_context_id => pactid

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

2349:
2350: -- Use full cursor not restricting by payroll
2351: --
2352: -- Used per_all_assignments_f 4555600
2353: hr_utility.trace('Range Cursor Not using Payroll Restriction');
2354: sqlstr := 'SELECT distinct asg.person_id
2355: FROM per_periods_of_service pos,
2356: per_assignments_f asg,
2357: pay_payroll_actions ppa

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

2364: else
2365: --
2366: -- The Payroll ID was used as parameter, so restrict by this
2367: --
2368: hr_utility.trace('Range Cursor using Payroll Restriction');
2369: sqlstr := 'SELECT DISTINCT ppf.person_id
2370: FROM per_people_f ppf,
2371: pay_payroll_actions ppa,
2372: per_assignments_f paaf

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

2376: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||
2377: ' ORDER BY ppf.person_id';
2378: end if;
2379:
2380: hr_utility.set_location('Leaving ' || l_proc,40);
2381: end if;
2382:
2383: END range_cursor;
2384:

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

2408: l_action_param_val varchar2(30);
2409: l_report_param_val varchar2(30);
2410: --
2411: BEGIN
2412: hr_utility.set_location('range_person_on',10);
2413: --
2414: BEGIN
2415: open csr_action_parameter;
2416: fetch csr_action_parameter into l_action_param_val;

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

2415: open csr_action_parameter;
2416: fetch csr_action_parameter into l_action_param_val;
2417: close csr_action_parameter;
2418: --
2419: hr_utility.set_location('range_person_on',20);
2420: open csr_range_format_param;
2421: fetch csr_range_format_param into l_report_param_val;
2422: close csr_range_format_param;
2423: --

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

2420: open csr_range_format_param;
2421: fetch csr_range_format_param into l_report_param_val;
2422: close csr_range_format_param;
2423: --
2424: hr_utility.set_location('range_person_on',30);
2425: EXCEPTION WHEN NO_DATA_FOUND THEN
2426: l_return := FALSE;
2427: END;
2428: --

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

2425: EXCEPTION WHEN NO_DATA_FOUND THEN
2426: l_return := FALSE;
2427: END;
2428: --
2429: hr_utility.set_location('range_person_on',40);
2430: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
2431: l_return := TRUE;
2432: hr_utility.trace('Range Person = True');
2433: ELSE

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

2428: --
2429: hr_utility.set_location('range_person_on',40);
2430: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
2431: l_return := TRUE;
2432: hr_utility.trace('Range Person = True');
2433: ELSE
2434: l_return := FALSE;
2435: END IF;
2436: --

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

2556: l_proc VARCHAR2(50) := g_package||'action_creation';
2557:
2558: BEGIN
2559:
2560: hr_utility.set_location('Entering ' || l_proc,10);
2561:
2562: pay_ie_legislative_archive.get_parameters (
2563: p_payroll_action_id => pactid
2564: , p_token_name => 'PAYROLL'

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

2578: p_payroll_action_id => pactid
2579: , p_token_name => 'END_DATE'
2580: , p_token_value => l_end_date);
2581:
2582: hr_utility.set_location('Step ' || l_proc,20);
2583: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2584: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2585: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2586:

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

2579: , p_token_name => 'END_DATE'
2580: , p_token_value => l_end_date);
2581:
2582: hr_utility.set_location('Step ' || l_proc,20);
2583: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2584: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2585: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2586:
2587: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

2580: , p_token_value => l_end_date);
2581:
2582: hr_utility.set_location('Step ' || l_proc,20);
2583: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2584: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2585: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2586:
2587: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2588: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

2581:
2582: hr_utility.set_location('Step ' || l_proc,20);
2583: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2584: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2585: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2586:
2587: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2588: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
2589:

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

2613:
2614: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2615: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2616:
2617: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2618: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2619:
2620: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2621:

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

2614: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2615: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2616:
2617: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2618: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2619:
2620: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2621:
2622: END IF;

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

2651:
2652: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2653: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2654:
2655: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2656: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2657:
2658: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2659:

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

2652: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
2653: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
2654:
2655: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
2656: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
2657:
2658: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
2659:
2660: END IF;

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

2665:
2666: END LOOP;
2667: END IF;
2668:
2669: hr_utility.set_location('Leaving ' || l_proc,20);
2670:
2671: END action_creation;
2672:
2673: PROCEDURE archive_code (p_assactid in number,

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

2859:
2860: l_proc VARCHAR2(50) := g_package || 'archive_code';
2861:
2862: BEGIN
2863: -- hr_utility.trace_on(null,'test123');
2864: hr_utility.set_location('Entering '|| l_proc,10);
2865:
2866: hr_utility.set_location('Step '|| l_proc,20);
2867: hr_utility.set_location('p_assactid = ' || p_assactid,20);

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

2860: l_proc VARCHAR2(50) := g_package || 'archive_code';
2861:
2862: BEGIN
2863: -- hr_utility.trace_on(null,'test123');
2864: hr_utility.set_location('Entering '|| l_proc,10);
2865:
2866: hr_utility.set_location('Step '|| l_proc,20);
2867: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2868:

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

2862: BEGIN
2863: -- hr_utility.trace_on(null,'test123');
2864: hr_utility.set_location('Entering '|| l_proc,10);
2865:
2866: hr_utility.set_location('Step '|| l_proc,20);
2867: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2868:
2869: -- retrieve the chunk number for the current assignment action
2870:

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

2863: -- hr_utility.trace_on(null,'test123');
2864: hr_utility.set_location('Entering '|| l_proc,10);
2865:
2866: hr_utility.set_location('Step '|| l_proc,20);
2867: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2868:
2869: -- retrieve the chunk number for the current assignment action
2870:
2871: SELECT paa.chunk_number

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

2880: FOR csr_rec IN csr_assignment_actions(p_assactid)
2881:
2882: LOOP
2883:
2884: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2885: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2886: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2887: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2888: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);

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

2881:
2882: LOOP
2883:
2884: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2885: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2886: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2887: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2888: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2889: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);

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

2882: LOOP
2883:
2884: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2885: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2886: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2887: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2888: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2889: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2890:

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

2883:
2884: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2885: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2886: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2887: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2888: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2889: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2890:
2891: IF l_record_count = 0

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

2884: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
2885: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2886: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2887: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2888: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2889: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2890:
2891: IF l_record_count = 0
2892:

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

2885: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
2886: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
2887: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
2888: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
2889: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
2890:
2891: IF l_record_count = 0
2892:
2893: THEN

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

2920: SELECT pay_assignment_actions_s.NEXTVAL
2921: INTO l_actid
2922: FROM dual;
2923:
2924: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);
2925: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);
2926:
2927: hr_nonrun_asact.insact(
2928: lockingactid => l_actid

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

2921: INTO l_actid
2922: FROM dual;
2923:
2924: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);
2925: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);
2926:
2927: hr_nonrun_asact.insact(
2928: lockingactid => l_actid
2929: , assignid => csr_rec.assignment_id

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

2940: IF csr_child_rec.run_type = 'S'
2941:
2942: THEN
2943:
2944: hr_utility.set_location('creating lock3 ' || l_actid || ' to ' || csr_child_rec.child_assignment_action_id,30);
2945:
2946: hr_nonrun_asact.insint(
2947: lockingactid => l_actid
2948: , lockedactid => csr_child_rec.child_assignment_action_id);

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

2988: OPEN csr_ppsn_override(csr_rec.assignment_id);
2989: FETCH csr_ppsn_override INTO l_ppsn_override;
2990: CLOSE csr_ppsn_override;
2991:
2992: hr_utility.set_location('l_ppsn_override = ' || l_ppsn_override,35);
2993: --6633719
2994:
2995: IF csr_child_rec.run_type in ('N','P')
2996:

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

3009: csr_rec.effective_date)
3010:
3011: LOOP*/
3012:
3013: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || csr_child_rec.child_assignment_action_id,30);
3014:
3015: hr_nonrun_asact.insint(
3016: lockingactid => l_actid
3017: , lockedactid => csr_child_rec.child_assignment_action_id);

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

3049: -- (EMEA BALANCES)
3050:
3051: -- archive user balances
3052:
3053: hr_utility.set_location('Archive User Balances - Starting',60);
3054: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index,60);
3055:
3056: FOR l_index IN 1 .. g_max_user_balance_index
3057:

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

3050:
3051: -- archive user balances
3052:
3053: hr_utility.set_location('Archive User Balances - Starting',60);
3054: hr_utility.set_location('g_max_user_balance_index = '|| g_max_user_balance_index,60);
3055:
3056: FOR l_index IN 1 .. g_max_user_balance_index
3057:
3058: LOOP

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

3069: , p_tax_unit_id => g_tax_unit_id);
3070:
3071: END LOOP;
3072:
3073: hr_utility.set_location('Archive User Balances - Complete',60);
3074:
3075: -- archive statutory balances
3076:
3077: hr_utility.set_location('Archive Statutory Balances - Starting',70);

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

3073: hr_utility.set_location('Archive User Balances - Complete',60);
3074:
3075: -- archive statutory balances
3076:
3077: hr_utility.set_location('Archive Statutory Balances - Starting',70);
3078: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
3079:
3080: FOR l_index IN 1 .. g_max_statutory_balance_index
3081:

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

3074:
3075: -- archive statutory balances
3076:
3077: hr_utility.set_location('Archive Statutory Balances - Starting',70);
3078: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
3079:
3080: FOR l_index IN 1 .. g_max_statutory_balance_index
3081:
3082: LOOP

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

3080: FOR l_index IN 1 .. g_max_statutory_balance_index
3081:
3082: LOOP
3083:
3084: hr_utility.set_location('l_index = ' || l_index,70);
3085: --6633719
3086: IF g_statutory_balance_table(l_index).database_item_suffix <> '_PER_PAYE_REF_PPSN_YTD'
3087: OR (l_ppsn_override IS NOT NULL
3088: AND g_statutory_balance_table(l_index).database_item_suffix = '_PER_PAYE_REF_PPSN_YTD')

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

3087: OR (l_ppsn_override IS NOT NULL
3088: AND g_statutory_balance_table(l_index).database_item_suffix = '_PER_PAYE_REF_PPSN_YTD')
3089: THEN
3090: --6633719
3091: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
3092: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
3093: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
3094:
3095: pay_ie_legislative_archive.process_balance (

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

3088: AND g_statutory_balance_table(l_index).database_item_suffix = '_PER_PAYE_REF_PPSN_YTD')
3089: THEN
3090: --6633719
3091: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
3092: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
3093: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
3094:
3095: pay_ie_legislative_archive.process_balance (
3096: p_action_context_id => l_action_context_id

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

3089: THEN
3090: --6633719
3091: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
3092: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
3093: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
3094:
3095: pay_ie_legislative_archive.process_balance (
3096: p_action_context_id => l_action_context_id
3097: , p_assignment_id => csr_rec.assignment_id

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

3105: END IF;
3106:
3107: END LOOP;
3108:
3109: hr_utility.set_location('Archive Statutory Balances - Complete',70);
3110: /*****************************************************************
3111: ** Below call is to address bug #8522324.
3112: ** It archives the payments and deductions details for the employee
3113: ** for the given assignment_action_id.

Line 3117: hr_utility.set_location('Archive Payments and Deductions data - Complete',75);

3113: ** for the given assignment_action_id.
3114: *****************************************************************/
3115: PAY_IE_LEGISLATIVE_ARCHIVE.get_pay_deduct_element_info (p_assactid);
3116:
3117: hr_utility.set_location('Archive Payments and Deductions data - Complete',75);
3118:
3119: END LOOP; -- child assignment actions
3120:
3121: l_record_count := l_record_count + 1;

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

3122:
3123:
3124: END LOOP;
3125:
3126: hr_utility.set_location('Leaving '|| l_proc,80);
3127:
3128: END archive_code;
3129:
3130: Procedure ARCHIVE_DEINIT(p_payroll_action_id IN NUMBER) IS

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

3291:
3292:
3293: BEGIN
3294:
3295: --hr_utility.trace_on(null,'IEPS');
3296: hr_utility.set_location('Entering ' || l_proc,10);
3297:
3298: l_archived := 0;
3299:

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

3292:
3293: BEGIN
3294:
3295: --hr_utility.trace_on(null,'IEPS');
3296: hr_utility.set_location('Entering ' || l_proc,10);
3297:
3298: l_archived := 0;
3299:
3300: OPEN csr_check_archived(p_payroll_action_id);

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

3333: p_payroll_action_id => p_payroll_action_id
3334: , p_token_name => 'BG_ID'
3335: , p_token_value => l_bg_id);
3336:
3337: hr_utility.set_location('Step ' || l_proc,20);
3338: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3339: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3340: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3341:

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

3334: , p_token_name => 'BG_ID'
3335: , p_token_value => l_bg_id);
3336:
3337: hr_utility.set_location('Step ' || l_proc,20);
3338: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3339: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3340: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3341:
3342: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

3335: , p_token_value => l_bg_id);
3336:
3337: hr_utility.set_location('Step ' || l_proc,20);
3338: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3339: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3340: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3341:
3342: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3343: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

3336:
3337: hr_utility.set_location('Step ' || l_proc,20);
3338: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3339: hr_utility.set_location('l_start_date = ' || l_start_date,20);
3340: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3341:
3342: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3343: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3344:

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

3343: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3344:
3345: -- archive EMEA PAYROLL INFO for each prepayment run identified
3346:
3347: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3348: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3349: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3350: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3351:

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

3344:
3345: -- archive EMEA PAYROLL INFO for each prepayment run identified
3346:
3347: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3348: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3349: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3350: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3351:
3352: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value

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

3345: -- archive EMEA PAYROLL INFO for each prepayment run identified
3346:
3347: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3348: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3349: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3350: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3351:
3352: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
3353: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);

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

3346:
3347: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3348: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3349: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3350: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3351:
3352: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
3353: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3354:

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

3408: l_consolidation_set,
3409: l_canonical_end_date)
3410: LOOP
3411:
3412: hr_utility.set_location('Calling arch_pay_action_level_data',25);
3413: --
3414:
3415: pay_emp_action_arch.arch_pay_action_level_data (
3416: p_payroll_action_id => p_payroll_action_id

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

3429:
3430: LOOP
3431: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3432: , rec_payroll_info.payroll_action_id);
3433: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3434: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3435: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3436:
3437: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);

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

3430: LOOP
3431: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3432: , rec_payroll_info.payroll_action_id);
3433: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3434: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3435: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3436:
3437: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3438:

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

3431: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3432: , rec_payroll_info.payroll_action_id);
3433: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3434: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3435: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3436:
3437: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3438:
3439: pay_action_information_api.create_action_information (

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

3433: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3434: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3435: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3436:
3437: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3438:
3439: pay_action_information_api.create_action_information (
3440: p_action_information_id => l_action_info_id
3441: , p_action_context_id => p_payroll_action_id

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

3486: END IF;
3487:
3488: END LOOP;
3489:
3490: hr_utility.set_location('Leaving ' || l_proc,40);
3491: end if;
3492: END IF;
3493: END ARCHIVE_DEINIT;
3494: