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.

[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

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

82: l_proc VARCHAR2(50) := g_package || 'get_parameters';
83:
84: BEGIN
85:
86: hr_utility.set_location('Entering ' || l_proc,10);
87:
88: hr_utility.set_location('Step ' || l_proc,20);
89: hr_utility.set_location('p_token_name = ' || p_token_name,20);
90:

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

84: BEGIN
85:
86: hr_utility.set_location('Entering ' || l_proc,10);
87:
88: hr_utility.set_location('Step ' || l_proc,20);
89: hr_utility.set_location('p_token_name = ' || p_token_name,20);
90:
91: OPEN csr_parameter_info(p_payroll_action_id,
92: p_token_name);

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

85:
86: hr_utility.set_location('Entering ' || l_proc,10);
87:
88: hr_utility.set_location('Step ' || l_proc,20);
89: hr_utility.set_location('p_token_name = ' || p_token_name,20);
90:
91: OPEN csr_parameter_info(p_payroll_action_id,
92: p_token_name);
93:

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

107: p_token_value := l_token_value;
108:
109: END IF;
110:
111: hr_utility.set_location('l_token_value = ' || l_token_value,20);
112: hr_utility.set_location('Leaving ' || l_proc,30);
113:
114: END get_parameters;
115:

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

108:
109: END IF;
110:
111: hr_utility.set_location('l_token_value = ' || l_token_value,20);
112: hr_utility.set_location('Leaving ' || l_proc,30);
113:
114: END get_parameters;
115:
116: PROCEDURE get_eit_definitions(p_pactid IN NUMBER,

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

176: l_proc VARCHAR2(50) := g_package || 'get_eit_definitions';
177:
178: BEGIN
179:
180: hr_utility.set_location('Entering ' || l_proc,10);
181:
182: hr_utility.set_location('Step ' || l_proc,20);
183: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
184:

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

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

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

179:
180: hr_utility.set_location('Entering ' || l_proc,10);
181:
182: hr_utility.set_location('Step ' || l_proc,20);
183: hr_utility.set_location('p_eit_context = ' || p_eit_context,20);
184:
185: FOR csr_eit_rec IN csr_eit_values(p_business_group_id,
186: p_eit_context)
187:

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

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

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

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

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

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

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

190: hr_utility.set_location('Step ' || l_proc,30);
191:
192: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
193: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
194: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
195: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
196: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
197: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
198:

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

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

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

192: hr_utility.set_location('org_information1 = ' || csr_eit_rec.org_information1,30);
193: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
194: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
195: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
196: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
197: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
198:
199: IF p_eit_context = g_balance_context
200:

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

193: hr_utility.set_location('org_information2 = ' || csr_eit_rec.org_information2,30);
194: hr_utility.set_location('org_information3 = ' || csr_eit_rec.org_information3,30);
195: hr_utility.set_location('org_information4 = ' || csr_eit_rec.org_information4,30);
196: hr_utility.set_location('org_information5 = ' || csr_eit_rec.org_information5,30);
197: hr_utility.set_location('org_information6 = ' || csr_eit_rec.org_information6,30);
198:
199: IF p_eit_context = g_balance_context
200:
201: THEN

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

227: -- then it is a total of all categories for that particular balance.
228: -- This type of balance is identified here and given an
229: -- n_type_ind of T.
230:
231: hr_utility.set_location('g_user_balance_table(l_index).balance_name = ' ||
232: g_user_balance_table(l_index).balance_name,50);
233:
234: IF g_user_balance_table(l_index).balance_name = 'NI Employer'
235:

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

249: g_user_balance_table(l_index).ni_type_ind := ' ';
250:
251: END IF;
252:
253: hr_utility.set_location('Arch EMEA BALANCE DEFINITION',99);
254:
255: IF p_archive = 'Y'
256:
257: THEN

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

312: IF p_archive = 'Y'
313:
314: THEN
315:
316: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
317:
318: pay_action_information_api.create_action_information (
319: p_action_information_id => l_action_info_id
320: , p_action_context_id => p_pactid

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

336: END IF;
337:
338: l_index := l_index + 1;
339:
340: hr_utility.set_location('l_index = ' || l_index,99);
341:
342: END LOOP;
343:
344: g_max_element_index := l_index;

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

354: g_element_archive_index := l_index - 1;
355:
356: END IF;
357:
358: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index,99);
359:
360: hr_utility.set_location('Leaving ' || l_proc,30);
361:
362: END get_eit_definitions;

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

356: END IF;
357:
358: hr_utility.set_location('g_balance_archive_index = ' || g_balance_archive_index,99);
359:
360: hr_utility.set_location('Leaving ' || l_proc,30);
361:
362: END get_eit_definitions;
363:
364: PROCEDURE setup_element_definitions (p_pactid IN NUMBER,

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

395: l_proc VARCHAR2(60) := g_package || 'setup_element_definitions';
396:
397: BEGIN
398:
399: hr_utility.set_location('Entering ' || l_proc,10);
400:
401: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact,10);
402:
403: FOR csr_element_rec IN csr_element_name(p_business_group_id,

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

397: BEGIN
398:
399: hr_utility.set_location('Entering ' || l_proc,10);
400:
401: hr_utility.set_location('p_payroll_pact = ' || p_payroll_pact,10);
402:
403: FOR csr_element_rec IN csr_element_name(p_business_group_id,
404: p_effective_date)
405:

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

404: p_effective_date)
405:
406: LOOP
407:
408: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id,20);
409: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name,20);
410:
411: IF csr_element_rec.classification_name = 'Earnings'
412:

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

405:
406: LOOP
407:
408: hr_utility.set_location('csr_element_rec.element_type_id = ' || csr_element_rec.element_type_id,20);
409: hr_utility.set_location('csr_element_rec.element_name = ' || csr_element_rec.element_name,20);
410:
411: IF csr_element_rec.classification_name = 'Earnings'
412:
413: THEN

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

425: l_payment_type := 'D';
426:
427: END IF;
428:
429: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
430:
431: pay_action_information_api.create_action_information (
432: p_action_information_id => l_action_info_id
433: , p_action_context_id => p_pactid

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

445: , p_action_information6 => csr_element_rec.uom);
446:
447: END LOOP;
448:
449: hr_utility.set_location('Leaving ' || l_proc,30);
450:
451: END setup_element_definitions;
452:
453: PROCEDURE setup_standard_balance_table

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

485:
486:
487: BEGIN
488:
489: hr_utility.set_location('Entering ' || l_proc,10);
490:
491: hr_utility.set_location('Step ' || l_proc,20);
492:
493: l_statutory_balance(1).balance_name := 'Gross Pay';

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

487: BEGIN
488:
489: hr_utility.set_location('Entering ' || l_proc,10);
490:
491: hr_utility.set_location('Step ' || l_proc,20);
492:
493: l_statutory_balance(1).balance_name := 'Gross Pay';
494: l_statutory_balance(2).balance_name := 'Notional Pay';
495: l_statutory_balance(3).balance_name := 'Taxable Pay';

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

503: l_statutory_balance(11).balance_name := 'NI Ers Rebate';
504: l_statutory_balance(12).balance_name := 'Student Loan';
505: l_statutory_balance(13).balance_name := 'Superannuation Total';
506:
507: hr_utility.set_location('Step = ' || l_proc,30);
508:
509: FOR l_index IN 1 .. l_max_stat_balance
510:
511: LOOP

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

509: FOR l_index IN 1 .. l_max_stat_balance
510:
511: LOOP
512:
513: hr_utility.set_location('l_index = ' || l_index,30);
514: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
515: hr_utility.set_location('l_dimension = ' || l_dimension,30);
516:
517: OPEN csr_balance_dimension(l_statutory_balance(l_index).balance_name,

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

510:
511: LOOP
512:
513: hr_utility.set_location('l_index = ' || l_index,30);
514: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
515: hr_utility.set_location('l_dimension = ' || l_dimension,30);
516:
517: OPEN csr_balance_dimension(l_statutory_balance(l_index).balance_name,
518: l_dimension);

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

511: LOOP
512:
513: hr_utility.set_location('l_index = ' || l_index,30);
514: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
515: hr_utility.set_location('l_dimension = ' || l_dimension,30);
516:
517: OPEN csr_balance_dimension(l_statutory_balance(l_index).balance_name,
518: l_dimension);
519:

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

529: END IF;
530:
531: CLOSE csr_balance_dimension;
532:
533: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,30);
534:
535: END LOOP;
536:
537: hr_utility.set_location('Step = ' || l_proc,40);

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

533: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,30);
534:
535: END LOOP;
536:
537: hr_utility.set_location('Step = ' || l_proc,40);
538:
539: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
540: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
541:

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

535: END LOOP;
536:
537: hr_utility.set_location('Step = ' || l_proc,40);
538:
539: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
540: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
541:
542: FOR l_index IN 1 .. l_max_stat_balance
543:

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

536:
537: hr_utility.set_location('Step = ' || l_proc,40);
538:
539: hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
540: hr_utility.set_location('g_max_user_balance_index = ' || g_max_user_balance_index,40);
541:
542: FOR l_index IN 1 .. l_max_stat_balance
543:
544: LOOP

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

548: FOR l_eit_index IN 1 .. g_max_user_balance_index
549:
550: LOOP
551:
552: hr_utility.set_location('l_index = ' || l_index,40);
553: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
554: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
555: hr_utility.set_location('l_found = ' || l_found,40);
556:

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

549:
550: LOOP
551:
552: hr_utility.set_location('l_index = ' || l_index,40);
553: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
554: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
555: hr_utility.set_location('l_found = ' || l_found,40);
556:
557: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id

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

550: LOOP
551:
552: hr_utility.set_location('l_index = ' || l_index,40);
553: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
554: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
555: hr_utility.set_location('l_found = ' || l_found,40);
556:
557: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id
558:

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

551:
552: hr_utility.set_location('l_index = ' || l_index,40);
553: hr_utility.set_location('l_eit_index = ' || l_eit_index,40);
554: hr_utility.set_location('defined_balance_id = ' || l_statutory_bal_id(l_index).defined_balance_id,40);
555: hr_utility.set_location('l_found = ' || l_found,40);
556:
557: IF l_statutory_bal_id(l_index).defined_balance_id = g_user_balance_table(l_eit_index).defined_balance_id
558:
559: THEN

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

567: IF l_found = 'N'
568:
569: THEN
570:
571: hr_utility.set_location('l_archive_index = ' || l_archive_index,40);
572:
573: l_archive_index := l_archive_index + 1;
574:
575: g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_index).defined_balance_id;

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

581: END LOOP;
582:
583: g_max_statutory_balance_index := l_archive_index;
584:
585: hr_utility.set_location('Step ' || l_proc,50);
586: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
587:
588: hr_utility.set_location('Leaving ' || l_proc,60);
589:

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

582:
583: g_max_statutory_balance_index := l_archive_index;
584:
585: hr_utility.set_location('Step ' || l_proc,50);
586: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
587:
588: hr_utility.set_location('Leaving ' || l_proc,60);
589:
590: END setup_standard_balance_table;

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

584:
585: hr_utility.set_location('Step ' || l_proc,50);
586: hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
587:
588: hr_utility.set_location('Leaving ' || l_proc,60);
589:
590: END setup_standard_balance_table;
591:
592: PROCEDURE archinit (p_payroll_action_id IN NUMBER)

Line 624: -- hr_utility.trace_on(NULL,'UKPS0');

620: l_start_date VARCHAR2(30);
621:
622: BEGIN
623:
624: -- hr_utility.trace_on(NULL,'UKPS0');
625:
626: hr_utility.set_location('Entering ' || l_proc,10);
627:
628: g_archive_pact := p_payroll_action_id;

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

622: BEGIN
623:
624: -- hr_utility.trace_on(NULL,'UKPS0');
625:
626: hr_utility.set_location('Entering ' || l_proc,10);
627:
628: g_archive_pact := p_payroll_action_id;
629:
630: OPEN csr_archive_effective_date(p_payroll_action_id);

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

663: p_payroll_action_id => p_payroll_action_id
664: , p_token_name => 'BG_ID'
665: , p_token_value => l_bg_id);
666:
667: hr_utility.set_location('Step ' || l_proc,20);
668: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
669: hr_utility.set_location('l_start_date = ' || l_start_date,20);
670: hr_utility.set_location('l_end_date = ' || l_end_date,20);
671:

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

664: , p_token_name => 'BG_ID'
665: , p_token_value => l_bg_id);
666:
667: hr_utility.set_location('Step ' || l_proc,20);
668: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
669: hr_utility.set_location('l_start_date = ' || l_start_date,20);
670: hr_utility.set_location('l_end_date = ' || l_end_date,20);
671:
672: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

665: , p_token_value => l_bg_id);
666:
667: hr_utility.set_location('Step ' || l_proc,20);
668: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
669: hr_utility.set_location('l_start_date = ' || l_start_date,20);
670: hr_utility.set_location('l_end_date = ' || l_end_date,20);
671:
672: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
673: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

666:
667: hr_utility.set_location('Step ' || l_proc,20);
668: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
669: hr_utility.set_location('l_start_date = ' || l_start_date,20);
670: hr_utility.set_location('l_end_date = ' || l_end_date,20);
671:
672: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
673: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
674:

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

710: g_paye_tax_basis_id;
711:
712: CLOSE csr_input_value_id;
713:
714: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
715: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
716: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
717: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
718:

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

711:
712: CLOSE csr_input_value_id;
713:
714: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
715: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
716: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
717: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
718:
719: -- retrieve and archive user defintions from EITs

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

712: CLOSE csr_input_value_id;
713:
714: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
715: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
716: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
717: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
718:
719: -- retrieve and archive user defintions from EITs
720:

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

713:
714: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
715: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
716: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
717: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
718:
719: -- retrieve and archive user defintions from EITs
720:
721: g_max_user_balance_index := 0;

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

719: -- retrieve and archive user defintions from EITs
720:
721: g_max_user_balance_index := 0;
722:
723: hr_utility.set_location('get_eit_definitions - balances',20);
724:
725: pay_gb_payslip_archive.get_eit_definitions (
726: p_pactid => p_payroll_action_id
727: , p_business_group_id => l_bg_id

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

729: , p_effective_date => l_canonical_start_date
730: , p_eit_context => g_balance_context
731: , p_archive => 'N');
732:
733: hr_utility.set_location('get_eit_definitions - elements',20);
734:
735: pay_gb_payslip_archive.get_eit_definitions (
736: p_pactid => p_payroll_action_id
737: , p_business_group_id => l_bg_id

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

746: -- setup statutory balances pl/sql table
747:
748: pay_gb_payslip_archive.setup_standard_balance_table;
749:
750: hr_utility.set_location('Leaving ' || l_proc,20);
751:
752: END archinit;
753:
754: PROCEDURE archive_employee_details (

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

767: l_proc VARCHAR2(50) := g_package || 'archive_employee_details';
768:
769: BEGIN
770:
771: hr_utility.set_location('Entering ' || l_proc,10);
772:
773: -- call generic procedure to retrieve and archive all data for
774: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
775:

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

772:
773: -- call generic procedure to retrieve and archive all data for
774: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
775:
776: hr_utility.set_location('Calling pay_emp_action_arch',20);
777:
778: pay_emp_action_arch.get_personal_information (
779: p_payroll_action_id => g_archive_pact -- archive payroll_action_id
780: , p_assactid => p_assactid -- archive assignment_action_id

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

786: , p_tax_unit_id => NULL -- only required for US
787: , p_time_period_id => p_time_period_id -- payroll time_period_id
788: , p_ppp_source_action_id => NULL);
789:
790: hr_utility.set_location('Returned from pay_emp_action_arch',30);
791:
792: END archive_employee_details;
793:
794: PROCEDURE archive_gb_employee_details (

Line 825: hr_utility.set_location('l_tax_code = ' || l_tax_code,40);

821: , p_input_value_id => g_tax_code_id
822: , p_paye_input_value_id => g_paye_tax_code_id
823: , p_date_earned => to_char(p_effective_date,'yyyy/mm/dd'));
824:
825: hr_utility.set_location('l_tax_code = ' || l_tax_code,40);
826:
827: l_tax_basis := pay_gb_payroll_actions_pkg.get_tax_details (
828: p_run_assignment_action_id => p_curr_pymt_ass_act_id
829: , p_input_value_id => g_tax_basis_id

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

829: , p_input_value_id => g_tax_basis_id
830: , p_paye_input_value_id => g_paye_tax_basis_id
831: , p_date_earned => to_char(p_effective_date,'yyyy/mm/dd'));
832:
833: hr_utility.set_location('l_tax_basis = ' || l_tax_basis,40);
834:
835: IF l_tax_basis = 'C'
836:
837: THEN

Line 853: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS',50);

849: l_tax_basis_det := l_tax_basis;
850:
851: END IF;
852:
853: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS',50);
854:
855: pay_action_information_api.create_action_information (
856: p_action_information_id => l_action_info_id
857: , p_action_context_id => p_assactid

Line 1037: --hr_utility.trace_on(null, 'PARC');

1033: v_csr_reference csr_get_reference%ROWTYPE;
1034:
1035: BEGIN
1036:
1037: --hr_utility.trace_on(null, 'PARC');
1038:
1039: hr_utility.set_location('Entering ' || l_proc,10);
1040:
1041: OPEN csr_get_agg_info(p_assignment_id);

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

1035: BEGIN
1036:
1037: --hr_utility.trace_on(null, 'PARC');
1038:
1039: hr_utility.set_location('Entering ' || l_proc,10);
1040:
1041: OPEN csr_get_agg_info(p_assignment_id);
1042: FETCH csr_get_agg_info into l_agg_flag;
1043: CLOSE csr_get_agg_info;

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

1147: END IF;
1148: -- end of court order context sensitive balances
1149:
1150: ELSE
1151: hr_utility.set_location('Step ' || l_proc,20);
1152: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1153: hr_utility.set_location('p_balance = ' || p_balance,20);
1154: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1155: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);

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

1148: -- end of court order context sensitive balances
1149:
1150: ELSE
1151: hr_utility.set_location('Step ' || l_proc,20);
1152: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1153: hr_utility.set_location('p_balance = ' || p_balance,20);
1154: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1155: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1156: hr_utility.set_location('ni_type = ' || nvl(p_ni_type,'NULL'),20);

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

1149:
1150: ELSE
1151: hr_utility.set_location('Step ' || l_proc,20);
1152: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1153: hr_utility.set_location('p_balance = ' || p_balance,20);
1154: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1155: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1156: hr_utility.set_location('ni_type = ' || nvl(p_ni_type,'NULL'),20);
1157:

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

1150: ELSE
1151: hr_utility.set_location('Step ' || l_proc,20);
1152: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1153: hr_utility.set_location('p_balance = ' || p_balance,20);
1154: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1155: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1156: hr_utility.set_location('ni_type = ' || nvl(p_ni_type,'NULL'),20);
1157:
1158: IF p_ni_type = ' '

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

1151: hr_utility.set_location('Step ' || l_proc,20);
1152: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1153: hr_utility.set_location('p_balance = ' || p_balance,20);
1154: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1155: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1156: hr_utility.set_location('ni_type = ' || nvl(p_ni_type,'NULL'),20);
1157:
1158: IF p_ni_type = ' '
1159:

Line 1156: hr_utility.set_location('ni_type = ' || nvl(p_ni_type,'NULL'),20);

1152: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1153: hr_utility.set_location('p_balance = ' || p_balance,20);
1154: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1155: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1156: hr_utility.set_location('ni_type = ' || nvl(p_ni_type,'NULL'),20);
1157:
1158: IF p_ni_type = ' '
1159:
1160: THEN

Line 1172: hr_utility.set_location('l_ni_balance = ' || l_ni_balance,20);

1168: THEN
1169:
1170: l_ni_balance := SUBSTR(p_balance,1,3) || SUBSTR(p_balance,6);
1171:
1172: hr_utility.set_location('l_ni_balance = ' || l_ni_balance,20);
1173:
1174: l_balance_value := pay_gb_payroll_actions_pkg.report_all_ni_balance (
1175: p_balance_name => l_ni_balance
1176: , p_assignment_action_id => p_source_id

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

1183: ,p_balance_dimension => p_dimension);
1184:
1185: END IF;
1186:
1187: hr_utility.set_location('l_balance_value = ' || l_balance_value,20);
1188:
1189: IF p_record_count = 0
1190:
1191: THEN

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

1202: IF l_balance_value <> 0
1203:
1204: THEN
1205:
1206: hr_utility.set_location('Archiving EMEA BALANCES',20);
1207:
1208: pay_action_information_api.create_action_information (
1209: p_action_information_id => l_action_info_id
1210: , p_action_context_id => p_action_context_id

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

1223:
1224: END IF;
1225: END IF;
1226:
1227: hr_utility.set_location('Leaving ' || l_proc,30);
1228:
1229: EXCEPTION
1230:
1231: WHEN NO_DATA_FOUND

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

1267: l_result_value pay_run_result_values.result_value%TYPE;
1268:
1269: BEGIN
1270:
1271: hr_utility.set_location('Entering get_element_info',10);
1272:
1273: l_column_sequence := 0;
1274: l_element_type_id := 0;
1275: l_main_sequence := 0;

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

1286: l_record_count := p_record_count + 1;
1287:
1288: END IF;
1289:
1290: hr_utility.set_location('g_max_element_index = ' || g_max_element_index,10);
1291:
1292: FOR l_index IN 1 .. g_max_element_index
1293:
1294: LOOP

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

1292: FOR l_index IN 1 .. g_max_element_index
1293:
1294: LOOP
1295:
1296: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1297: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1298: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1299:
1300: FOR rec_element_value IN csr_element_values (

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

1293:
1294: LOOP
1295:
1296: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1297: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1298: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1299:
1300: FOR rec_element_value IN csr_element_values (
1301: p_child_assignment_action

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

1294: LOOP
1295:
1296: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1297: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1298: hr_utility.set_location('p_child_assignment_action = ' || p_child_assignment_action,10);
1299:
1300: FOR rec_element_value IN csr_element_values (
1301: p_child_assignment_action
1302: , g_element_table(l_index).element_type_id

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

1303: , g_element_table(l_index).input_value_id)
1304:
1305: LOOP
1306:
1307: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1308: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1309: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1310:
1311: hr_utility.set_location('l_element_type_id = ' || l_element_type_id,20);

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

1304:
1305: LOOP
1306:
1307: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1308: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1309: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1310:
1311: hr_utility.set_location('l_element_type_id = ' || l_element_type_id,20);
1312: hr_utility.set_location('g_element_table.element_type_id = ' || g_element_table(l_index).element_type_id,20);

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

1305: LOOP
1306:
1307: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1308: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1309: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1310:
1311: hr_utility.set_location('l_element_type_id = ' || l_element_type_id,20);
1312: hr_utility.set_location('g_element_table.element_type_id = ' || g_element_table(l_index).element_type_id,20);
1313:

Line 1311: hr_utility.set_location('l_element_type_id = ' || l_element_type_id,20);

1307: hr_utility.set_location('element_type_id = ' || g_element_table(l_index).element_type_id,10);
1308: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1309: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1310:
1311: hr_utility.set_location('l_element_type_id = ' || l_element_type_id,20);
1312: hr_utility.set_location('g_element_table.element_type_id = ' || g_element_table(l_index).element_type_id,20);
1313:
1314:
1315: IF l_element_type_id <> g_element_table(l_index).element_type_id

Line 1312: hr_utility.set_location('g_element_table.element_type_id = ' || g_element_table(l_index).element_type_id,20);

1308: hr_utility.set_location('input_value_id = ' || g_element_table(l_index).input_value_id,10);
1309: hr_utility.set_location('Archiving EMEA ELEMENT INFO',20);
1310:
1311: hr_utility.set_location('l_element_type_id = ' || l_element_type_id,20);
1312: hr_utility.set_location('g_element_table.element_type_id = ' || g_element_table(l_index).element_type_id,20);
1313:
1314:
1315: IF l_element_type_id <> g_element_table(l_index).element_type_id
1316:

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

1319: l_main_sequence := l_main_sequence + 1;
1320:
1321: END IF;
1322:
1323: hr_utility.set_location('l_main_sequence = ' || l_main_sequence,20);
1324:
1325: l_column_sequence := l_column_sequence + 1;
1326:
1327: -- If the run method is P, Process Separate, then only archive the data if

Line 1508: -- hr_utility.trace_on(NULL,'UKPS1');

1504: l_tax_period_no VARCHAR2(30);
1505:
1506: BEGIN
1507:
1508: -- hr_utility.trace_on(NULL,'UKPS1');
1509:
1510: hr_utility.set_location('Entering ' || l_proc,10);
1511:
1512: pay_gb_payslip_archive.get_parameters (

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

1506: BEGIN
1507:
1508: -- hr_utility.trace_on(NULL,'UKPS1');
1509:
1510: hr_utility.set_location('Entering ' || l_proc,10);
1511:
1512: pay_gb_payslip_archive.get_parameters (
1513: p_payroll_action_id => pactid
1514: , p_token_name => 'PAYROLL'

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

1538: p_payroll_action_id => pactid
1539: , p_token_name => 'BG_ID'
1540: , p_token_value => l_bg_id);
1541:
1542: hr_utility.set_location('Step ' || l_proc,20);
1543: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1544: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1545: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1546:

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

1539: , p_token_name => 'BG_ID'
1540: , p_token_value => l_bg_id);
1541:
1542: hr_utility.set_location('Step ' || l_proc,20);
1543: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1544: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1545: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1546:
1547: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

1540: , p_token_value => l_bg_id);
1541:
1542: hr_utility.set_location('Step ' || l_proc,20);
1543: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1544: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1545: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1546:
1547: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1548: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

1541:
1542: hr_utility.set_location('Step ' || l_proc,20);
1543: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1544: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1545: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1546:
1547: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1548: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1549:

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

1548: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1549:
1550: -- archive EMEA PAYROLL INFO for each prepayment run identified
1551:
1552: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1553: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1554: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1555: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1556:

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

1549:
1550: -- archive EMEA PAYROLL INFO for each prepayment run identified
1551:
1552: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1553: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1554: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1555: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1556:
1557: g_max_user_balance_index := 0;

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

1550: -- archive EMEA PAYROLL INFO for each prepayment run identified
1551:
1552: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1553: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1554: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1555: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1556:
1557: g_max_user_balance_index := 0;
1558:

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

1551:
1552: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1553: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
1554: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
1555: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
1556:
1557: g_max_user_balance_index := 0;
1558:
1559: pay_gb_payslip_archive.get_eit_definitions (

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

1585: l_consolidation_set,
1586: l_canonical_end_date)
1587: LOOP
1588:
1589: hr_utility.set_location('Calling arch_pay_action_level_data',25);
1590:
1591: pay_emp_action_arch.arch_pay_action_level_data (
1592: p_payroll_action_id => pactid
1593: , p_payroll_id => rec_payrolls.payroll_id

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

1608:
1609: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
1610: , rec_payroll_info.payroll_action_id);
1611:
1612: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1613: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
1614: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
1615: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
1616:

Line 1613: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);

1609: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
1610: , rec_payroll_info.payroll_action_id);
1611:
1612: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1613: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
1614: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
1615: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
1616:
1617: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);

Line 1614: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);

1610: , rec_payroll_info.payroll_action_id);
1611:
1612: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1613: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
1614: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
1615: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
1616:
1617: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1618:

Line 1615: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);

1611:
1612: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
1613: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
1614: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
1615: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
1616:
1617: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1618:
1619: -- Added for 4071160

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

1613: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
1614: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
1615: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
1616:
1617: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1618:
1619: -- Added for 4071160
1620: pay_emp_action_arch.arch_pay_action_level_data (
1621: p_payroll_action_id => pactid

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

1682: if l_payroll_id is null then
1683: --
1684: -- Use full cursor not restricting by payroll
1685: --
1686: hr_utility.trace('Range Cursor Not using Payroll Restriction');
1687: sqlstr := 'SELECT DISTINCT person_id
1688: FROM per_people_f ppf,
1689: pay_payroll_actions ppa
1690: WHERE ppa.payroll_action_id = :payroll_action_id

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

1693: else
1694: --
1695: -- The Payroll ID was used as parameter, so restrict by this
1696: --
1697: hr_utility.trace('Range Cursor using Payroll Restriction');
1698: sqlstr := 'SELECT DISTINCT ppf.person_id
1699: FROM per_all_people_f ppf,
1700: pay_payroll_actions ppa,
1701: per_all_assignments_f paaf

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

1705: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||
1706: ' ORDER BY ppf.person_id';
1707: end if;
1708: --
1709: hr_utility.set_location('Leaving ' || l_proc,40);
1710:
1711: END range_cursor;
1712: ---------------------------------------------------------------------------
1713: -- Function: range_person_on.

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

1735: l_action_param_val varchar2(30);
1736: l_report_param_val varchar2(30);
1737: --
1738: BEGIN
1739: hr_utility.set_location('range_person_on',10);
1740: --
1741: BEGIN
1742: open csr_action_parameter;
1743: fetch csr_action_parameter into l_action_param_val;

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

1742: open csr_action_parameter;
1743: fetch csr_action_parameter into l_action_param_val;
1744: close csr_action_parameter;
1745: --
1746: hr_utility.set_location('range_person_on',20);
1747: open csr_range_format_param;
1748: fetch csr_range_format_param into l_report_param_val;
1749: close csr_range_format_param;
1750: --

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

1747: open csr_range_format_param;
1748: fetch csr_range_format_param into l_report_param_val;
1749: close csr_range_format_param;
1750: --
1751: hr_utility.set_location('range_person_on',30);
1752: EXCEPTION WHEN NO_DATA_FOUND THEN
1753: l_return := FALSE;
1754: END;
1755: --

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

1752: EXCEPTION WHEN NO_DATA_FOUND THEN
1753: l_return := FALSE;
1754: END;
1755: --
1756: hr_utility.set_location('range_person_on',40);
1757: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
1758: l_return := TRUE;
1759: hr_utility.trace('Range Person = True');
1760: ELSE

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

1755: --
1756: hr_utility.set_location('range_person_on',40);
1757: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
1758: l_return := TRUE;
1759: hr_utility.trace('Range Person = True');
1760: ELSE
1761: l_return := FALSE;
1762: END IF;
1763: --

Line 1881: -- hr_utility.trace_on(null,'UKPS3');

1877:
1878: l_proc VARCHAR2(50) := g_package||'action_creation';
1879:
1880: BEGIN
1881: -- hr_utility.trace_on(null,'UKPS3');
1882: hr_utility.set_location('Entering ' || l_proc,10);
1883:
1884: pay_gb_payslip_archive.get_parameters (
1885: p_payroll_action_id => pactid

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

1878: l_proc VARCHAR2(50) := g_package||'action_creation';
1879:
1880: BEGIN
1881: -- hr_utility.trace_on(null,'UKPS3');
1882: hr_utility.set_location('Entering ' || l_proc,10);
1883:
1884: pay_gb_payslip_archive.get_parameters (
1885: p_payroll_action_id => pactid
1886: , p_token_name => 'PAYROLL'

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

1900: p_payroll_action_id => pactid
1901: , p_token_name => 'END_DATE'
1902: , p_token_value => l_end_date);
1903:
1904: hr_utility.set_location('Step ' || l_proc,20);
1905: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1906: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1907: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1908:

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

1901: , p_token_name => 'END_DATE'
1902: , p_token_value => l_end_date);
1903:
1904: hr_utility.set_location('Step ' || l_proc,20);
1905: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1906: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1907: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1908:
1909: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

1902: , p_token_value => l_end_date);
1903:
1904: hr_utility.set_location('Step ' || l_proc,20);
1905: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1906: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1907: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1908:
1909: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1910: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

1903:
1904: hr_utility.set_location('Step ' || l_proc,20);
1905: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
1906: hr_utility.set_location('l_start_date = ' || l_start_date,20);
1907: hr_utility.set_location('l_end_date = ' || l_end_date,20);
1908:
1909: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
1910: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
1911:

Line 1934: hr_utility.trace('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id);

1930: --
1931: -- Create Archive to master action interlock and
1932: -- the archive to prepayment asg action interlock
1933: --
1934: hr_utility.trace('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id);
1935: hr_utility.trace('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id);
1936: --
1937: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
1938: END IF;

Line 1935: hr_utility.trace('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id);

1931: -- Create Archive to master action interlock and
1932: -- the archive to prepayment asg action interlock
1933: --
1934: hr_utility.trace('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id);
1935: hr_utility.trace('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id);
1936: --
1937: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
1938: END IF;
1939: --

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

1967:
1968: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
1969: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
1970:
1971: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
1972: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
1973:
1974: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
1975:

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

1968: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
1969: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
1970:
1971: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
1972: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
1973:
1974: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
1975:
1976: END IF;

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

1982: END LOOP;
1983: --
1984: END IF; -- Range Person Code check.
1985:
1986: hr_utility.set_location('Leaving ' || l_proc,20);
1987:
1988: END action_creation;
1989:
1990: PROCEDURE archive_code (p_assactid in number,

Line 2085: -- hr_utility.trace_on(NULL,'UKPS2');

2081: l_proc VARCHAR2(50) := g_package || 'archive_code';
2082:
2083: BEGIN
2084:
2085: -- hr_utility.trace_on(NULL,'UKPS2');
2086:
2087: hr_utility.set_location('Entering '|| l_proc,10);
2088:
2089: hr_utility.set_location('Step '|| l_proc,20);

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

2083: BEGIN
2084:
2085: -- hr_utility.trace_on(NULL,'UKPS2');
2086:
2087: hr_utility.set_location('Entering '|| l_proc,10);
2088:
2089: hr_utility.set_location('Step '|| l_proc,20);
2090: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2091:

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

2085: -- hr_utility.trace_on(NULL,'UKPS2');
2086:
2087: hr_utility.set_location('Entering '|| l_proc,10);
2088:
2089: hr_utility.set_location('Step '|| l_proc,20);
2090: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2091:
2092: -- retrieve the chunk number for the current assignment action
2093: SELECT paa.chunk_number

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

2086:
2087: hr_utility.set_location('Entering '|| l_proc,10);
2088:
2089: hr_utility.set_location('Step '|| l_proc,20);
2090: hr_utility.set_location('p_assactid = ' || p_assactid,20);
2091:
2092: -- retrieve the chunk number for the current assignment action
2093: SELECT paa.chunk_number
2094: INTO l_chunk_number

Line 2109: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||

2105: *****************************************************************/
2106: OPEN csr_assignment_actions(p_assactid);
2107: LOOP
2108: fetch csr_assignment_actions into csr_rec;
2109: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
2110: csr_rec.master_assignment_action_id,20);
2111: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||
2112: csr_rec.pre_assignment_action_id,20);
2113:

Line 2111: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||

2107: LOOP
2108: fetch csr_assignment_actions into csr_rec;
2109: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
2110: csr_rec.master_assignment_action_id,20);
2111: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||
2112: csr_rec.pre_assignment_action_id,20);
2113:
2114: /*****************************************************************
2115: ** Archive the employee details for the last row returned by

Line 2169: hr_utility.set_location('csr_child_rec.run_type = ' ||

2165: SELECT pay_assignment_actions_s.NEXTVAL
2166: INTO l_actid
2167: FROM dual;
2168:
2169: hr_utility.set_location('csr_child_rec.run_type = ' ||
2170: csr_child_rec.run_type,30);
2171: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
2172: csr_rec.master_assignment_action_id,30);
2173:

Line 2171: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||

2167: FROM dual;
2168:
2169: hr_utility.set_location('csr_child_rec.run_type = ' ||
2170: csr_child_rec.run_type,30);
2171: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
2172: csr_rec.master_assignment_action_id,30);
2173:
2174: hr_nonrun_asact.insact(
2175: lockingactid => l_actid

Line 2185: hr_utility.set_location('creating lock3 ' || l_actid || ' to ' ||

2181: ,status => 'C'
2182: ,source_act => p_assactid);
2183:
2184: IF csr_child_rec.run_type = 'S' THEN
2185: hr_utility.set_location('creating lock3 ' || l_actid || ' to ' ||
2186: csr_child_rec.child_assignment_action_id,30);
2187:
2188: hr_nonrun_asact.insint(
2189: lockingactid => l_actid

Line 2241: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' ||

2237: csr_rec.pay_payroll_action_id,
2238: csr_rec.assignment_id,
2239: csr_rec.effective_date)
2240: LOOP
2241: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' ||
2242: csr_np_rec.np_assignment_action_id,30);
2243:
2244: hr_nonrun_asact.insint(
2245: lockingactid => l_actid

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

2269: -- Both User and Statutory Balances are archived for all Separate
2270: -- Payment assignment actions and the last (i.e. highest action_sequence)
2271: -- Process Separately assignment action (EMEA BALANCES) archive
2272: -- user balances
2273: hr_utility.set_location('Archive User Balances - Starting',60);
2274: hr_utility.set_location('g_max_user_balance_index = '||
2275: g_max_user_balance_index,60);
2276:
2277: FOR l_index IN 1 .. g_max_user_balance_index

Line 2274: hr_utility.set_location('g_max_user_balance_index = '||

2270: -- Payment assignment actions and the last (i.e. highest action_sequence)
2271: -- Process Separately assignment action (EMEA BALANCES) archive
2272: -- user balances
2273: hr_utility.set_location('Archive User Balances - Starting',60);
2274: hr_utility.set_location('g_max_user_balance_index = '||
2275: g_max_user_balance_index,60);
2276:
2277: FOR l_index IN 1 .. g_max_user_balance_index
2278: LOOP

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

2288: , p_record_count => l_record_count);
2289:
2290: END LOOP;
2291:
2292: hr_utility.set_location('Archive User Balances - Complete',60);
2293:
2294: -- archive statutory balances
2295: hr_utility.set_location('Archive Statutory Balances - Starting',70);
2296: hr_utility.set_location('g_max_statutory_balance_index = '||

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

2291:
2292: hr_utility.set_location('Archive User Balances - Complete',60);
2293:
2294: -- archive statutory balances
2295: hr_utility.set_location('Archive Statutory Balances - Starting',70);
2296: hr_utility.set_location('g_max_statutory_balance_index = '||
2297: g_max_statutory_balance_index,70);
2298:
2299: FOR l_index IN 1 .. g_max_statutory_balance_index

Line 2296: hr_utility.set_location('g_max_statutory_balance_index = '||

2292: hr_utility.set_location('Archive User Balances - Complete',60);
2293:
2294: -- archive statutory balances
2295: hr_utility.set_location('Archive Statutory Balances - Starting',70);
2296: hr_utility.set_location('g_max_statutory_balance_index = '||
2297: g_max_statutory_balance_index,70);
2298:
2299: FOR l_index IN 1 .. g_max_statutory_balance_index
2300: LOOP

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

2297: g_max_statutory_balance_index,70);
2298:
2299: FOR l_index IN 1 .. g_max_statutory_balance_index
2300: LOOP
2301: hr_utility.set_location('l_index = ' || l_index,70);
2302: pay_gb_payslip_archive.process_balance (
2303: p_action_context_id => l_action_context_id
2304: , p_assignment_id => csr_rec.assignment_id
2305: , p_source_id => csr_child_rec.child_assignment_action_id

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

2310: , p_ni_type => g_statutory_balance_table(l_index).ni_type_ind
2311: , p_record_count => l_record_count);
2312: END LOOP;
2313:
2314: hr_utility.set_location('Archive Statutory Balances - Complete',70);
2315:
2316: END LOOP; -- child assignment actions
2317:
2318: l_record_count := l_record_count + 1;

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

2319:
2320: END LOOP;
2321: close csr_assignment_actions;
2322:
2323: hr_utility.set_location('Leaving '|| l_proc,80);
2324:
2325: END archive_code;
2326:
2327: --Added for bug fix 5209228

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

2416:
2417:
2418: BEGIN
2419:
2420: hr_utility.set_location('Entering ' || l_proc,10);
2421:
2422:
2423: -- To avoid re-archiving while Retry
2424: delete from pay_action_information pai

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

2463: , p_token_name => 'BG_ID'
2464: , p_token_value => l_bg_id);
2465:
2466:
2467: hr_utility.set_location('Step ' || l_proc,20);
2468: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2469: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2470: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2471:

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

2464: , p_token_value => l_bg_id);
2465:
2466:
2467: hr_utility.set_location('Step ' || l_proc,20);
2468: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2469: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2470: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2471:
2472: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

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

2465:
2466:
2467: hr_utility.set_location('Step ' || l_proc,20);
2468: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2469: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2470: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2471:
2472: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2473: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

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

2466:
2467: hr_utility.set_location('Step ' || l_proc,20);
2468: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2469: hr_utility.set_location('l_start_date = ' || l_start_date,20);
2470: hr_utility.set_location('l_end_date = ' || l_end_date,20);
2471:
2472: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
2473: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
2474:

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

2473: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
2474:
2475: -- archive EMEA PAYROLL INFO for each prepayment run identified
2476:
2477: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2478: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2479: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2480: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2481:

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

2474:
2475: -- archive EMEA PAYROLL INFO for each prepayment run identified
2476:
2477: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2478: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2479: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2480: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2481:
2482:

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

2475: -- archive EMEA PAYROLL INFO for each prepayment run identified
2476:
2477: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2478: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2479: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2480: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2481:
2482:
2483: --Archiving contexts EMPLOYEE OTHER INFORMATION for MESG and

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

2476:
2477: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
2478: hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
2479: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
2480: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
2481:
2482:
2483: --Archiving contexts EMPLOYEE OTHER INFORMATION for MESG and
2484: --ADDRESS DETAILS for Employer Address

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

2499: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
2500: , rec_payroll_info.payroll_action_id);
2501:
2502:
2503: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2504: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
2505: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
2507:

Line 2504: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);

2500: , rec_payroll_info.payroll_action_id);
2501:
2502:
2503: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2504: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
2505: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
2507:
2508: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);

Line 2505: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);

2501:
2502:
2503: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2504: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
2505: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
2507:
2508: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2509:

Line 2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);

2502:
2503: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2504: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
2505: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
2507:
2508: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2509:
2510: pay_action_information_api.create_action_information (

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

2504: hr_utility.set_location('rec_payroll_info.tax_office_name = ' || rec_payroll_info.tax_office_name,30);
2505: hr_utility.set_location('rec_payroll_info.tax_office_phone_no = ' || rec_payroll_info.tax_office_phone_no,30);
2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
2507:
2508: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2509:
2510: pay_action_information_api.create_action_information (
2511: p_action_information_id => l_action_info_id
2512: , p_action_context_id => p_payroll_action_id

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

2558: END IF;
2559:
2560: END LOOP;
2561:
2562: hr_utility.set_location('Leaving ' || l_proc,40);
2563:
2564:
2565: END ARCHIVE_DEINIT;
2566: