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

Line 101: hr_utility.set_location('Entering '||l_procedure,1);

97: l_procedure varchar2(200) ;
98:
99: begin
100: l_procedure := g_package||'range_code';
101: hr_utility.set_location('Entering '||l_procedure,1);
102:
103: -- Archive the payroll action level data and EIT defintions.
104: pay_apac_payslip_archive.range_code( p_payroll_action_id => p_payroll_action_id);
105: /*Bug#3363519 */

Line 109: hr_utility.set_location('Leaving '||l_procedure,1000);

105: /*Bug#3363519 */
106: pay_core_payslip_utils.range_cursor(p_payroll_action_id,
107: p_sql);
108:
109: hr_utility.set_location('Leaving '||l_procedure,1000);
110:
111: end range_code;
112:
113: --------------------------------------------------------------------

Line 129: hr_utility.set_location('Entering '||l_procedure,1);

125: l_procedure varchar2(200) ;
126:
127: begin
128: l_procedure := g_package||'initialization_code';
129: hr_utility.set_location('Entering '||l_procedure,1);
130:
131: g_arc_payroll_action_id := p_payroll_action_id;
132: hr_utility.set_location('g_arc_payroll_action_id......='||g_arc_payroll_action_id,10);
133:

Line 132: hr_utility.set_location('g_arc_payroll_action_id......='||g_arc_payroll_action_id,10);

128: l_procedure := g_package||'initialization_code';
129: hr_utility.set_location('Entering '||l_procedure,1);
130:
131: g_arc_payroll_action_id := p_payroll_action_id;
132: hr_utility.set_location('g_arc_payroll_action_id......='||g_arc_payroll_action_id,10);
133:
134: -- initialization_code to to set the global tables for EIT
135: -- that will be used by each thread in multi-threading.
136: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);

Line 141: hr_utility.set_location('Leaving '||l_procedure,1000);

137:
138: /* Bug 4169557 - Introduced calls to populate defined balance ID's */
139: pay_au_soe_pkg.populate_defined_balances;
140:
141: hr_utility.set_location('Leaving '||l_procedure,1000);
142:
143: exception
144: when others then
145: hr_utility.set_location('Error in '||l_procedure,999999);

Line 145: hr_utility.set_location('Error in '||l_procedure,999999);

141: hr_utility.set_location('Leaving '||l_procedure,1000);
142:
143: exception
144: when others then
145: hr_utility.set_location('Error in '||l_procedure,999999);
146: raise;
147: end initialization_code;
148:
149: --------------------------------------------------------------------

Line 169: hr_utility.set_location('Entering ' || l_procedure,1);

165: l_procedure varchar2(200) ;
166:
167: begin
168: l_procedure := g_package||'assignment_action_code';
169: hr_utility.set_location('Entering ' || l_procedure,1);
170: /*Bug#3363519 */
171: pay_core_payslip_utils.action_creation (
172: p_payroll_action_id,
173: p_start_person,

Line 181: hr_utility.set_location('Error in '||l_procedure,999999);

177: 'AU');
178:
179: exception
180: when others then
181: hr_utility.set_location('Error in '||l_procedure,999999);
182: raise;
183: end assignment_action_code;
184:
185: --------------------------------------------------------------------

Line 221: hr_utility.set_location('Entering ' || l_procedure,1);

217: -- l_rate number;
218:
219: begin
220: l_procedure := g_package||'archive_stat_elements';
221: hr_utility.set_location('Entering ' || l_procedure,1);
222: --
223: -- Loop through the processed elements and archive the data
224: -- into the flexfield structure APAC_ELEMENTS.
225: --

Line 228: hr_utility.set_location('Archiving APAC Element Details',20);

224: -- into the flexfield structure APAC_ELEMENTS.
225: --
226: FOR csr_rec IN csr_std_elements(p_pre_assignment_action_id)
227: LOOP
228: hr_utility.set_location('Archiving APAC Element Details',20);
229: /* Bug:3260854 Added the following check to avoid
230: divide by zero error. */
231:
232: /* Bug 5914696 */

Line 267: hr_utility.set_location('Leaving ' || l_procedure,1000);

263: , p_action_information9 => fnd_number.number_to_canonical(csr_rec.rate) -- Bug: 3604094
264: );
265: END IF;
266: END LOOP;
267: hr_utility.set_location('Leaving ' || l_procedure,1000);
268: exception
269: when others
270: then
271: hr_utility.set_location('Error in '||l_procedure,999999);

Line 271: hr_utility.set_location('Error in '||l_procedure,999999);

267: hr_utility.set_location('Leaving ' || l_procedure,1000);
268: exception
269: when others
270: then
271: hr_utility.set_location('Error in '||l_procedure,999999);
272: raise;
273: end archive_stat_elements;
274:
275: --------------------------------------------------------------------

Line 297: hr_utility.set_location('Entering ' || l_procedure,1);

293: l_ovn number;
294: l_procedure varchar2(200) ;
295: begin
296: l_procedure := g_package||'archive_balances';
297: hr_utility.set_location('Entering ' || l_procedure,1);
298:
299: pay_action_information_api.create_action_information
300: (p_action_information_id => l_action_info_id
301: ,p_action_context_id => p_arc_assignment_action_id

Line 315: hr_utility.set_location('Leaving ' || l_procedure,1000);

311: ,p_action_information4 => fnd_number.number_to_canonical(p_ytd) -- Bug: 3604094
312: ,p_action_information5 => fnd_number.number_to_canonical(p_tp) -- Bug 3891564, Bug: 3604094
313: );
314:
315: hr_utility.set_location('Leaving ' || l_procedure,1000);
316: exception
317: when others then
318: hr_utility.set_location('Error in '||l_procedure,999999);
319: raise;

Line 318: hr_utility.set_location('Error in '||l_procedure,999999);

314:
315: hr_utility.set_location('Leaving ' || l_procedure,1000);
316: exception
317: when others then
318: hr_utility.set_location('Error in '||l_procedure,999999);
319: raise;
320: end archive_balances;
321:
322: --------------------------------------------------------------------

Line 369: hr_utility.set_location('Entering ' || l_procedure,1);

365:
366: l_get_le_level_bal :='Y'; --3935483
367: l_fetch_only_ytd_value :='N'; --3935483
368: l_procedure := g_package||'archive_stat_balances';
369: hr_utility.set_location('Entering ' || l_procedure,1);
370: --
371: -- Get the balance values
372: --
373: /* Bug 3891564 - Added four new parameters to the procedure call to return taxable income

Line 406: hr_utility.set_location(l_narrative||' = '||l_gross_ytd,30);

402: l_net_payment_this_pay := l_gross_this_pay - l_pre_tax_deductions_this_pay - l_other_deductions_this_pay - l_tax_deductions_this_pay + l_direct_pay_this_pay;
403:
404:
405: l_narrative := 'Gross Earnings';
406: hr_utility.set_location(l_narrative||' = '||l_gross_ytd,30);
407:
408: -- Archive Gross Earnings
409: archive_balances
410: (p_arc_assignment_action_id => p_arc_assignment_action_id

Line 418: hr_utility.set_location(l_narrative||' = '||l_non_tax_allow_ytd,40);

414: ,p_tp => l_gross_this_pay
415: );
416:
417: l_narrative := 'Non Taxable Earnings';
418: hr_utility.set_location(l_narrative||' = '||l_non_tax_allow_ytd,40);
419:
420: -- Archive Non Taxable Earnings
421: archive_balances
422: (p_arc_assignment_action_id => p_arc_assignment_action_id

Line 430: hr_utility.set_location(l_narrative||' = '||l_pre_tax_deductions_ytd,50);

426: ,p_tp => l_non_tax_allow_this_pay
427: );
428:
429: l_narrative := 'Pre Tax Deductions';
430: hr_utility.set_location(l_narrative||' = '||l_pre_tax_deductions_ytd,50);
431:
432: -- Archive Pre Tax Deductions
433: archive_balances
434: (p_arc_assignment_action_id => p_arc_assignment_action_id

Line 442: hr_utility.set_location(l_narrative||' = '||l_tax_income_ytd,60);

438: ,p_tp => l_pre_tax_deductions_this_pay
439: );
440:
441: l_narrative := 'Taxable Gross';
442: hr_utility.set_location(l_narrative||' = '||l_tax_income_ytd,60);
443:
444: -- Archive Taxable Earnings
445: archive_balances
446: (p_arc_assignment_action_id => p_arc_assignment_action_id

Line 454: hr_utility.set_location(l_narrative||' = '||l_tax_deductions_ytd,70);

450: ,p_tp => l_tax_income_this_pay
451: );
452:
453: l_narrative := 'Tax Deductions';
454: hr_utility.set_location(l_narrative||' = '||l_tax_deductions_ytd,70);
455:
456: -- Archive Tax Deductions
457: archive_balances
458: (p_arc_assignment_action_id => p_arc_assignment_action_id

Line 466: hr_utility.set_location(l_narrative||' = '||l_other_deductions_ytd,80);

462: ,p_tp => l_tax_deductions_this_pay
463: );
464:
465: l_narrative := 'Post Tax Deductions';
466: hr_utility.set_location(l_narrative||' = '||l_other_deductions_ytd,80);
467:
468:
469: -- Archive Post Tax Deductions
470: archive_balances

Line 479: hr_utility.set_location(l_narrative||' = '||l_direct_pay_ytd,90);

475: ,p_tp => l_other_deductions_this_pay
476: );
477:
478: l_narrative := 'Direct Payments';
479: hr_utility.set_location(l_narrative||' = '||l_direct_pay_ytd,90);
480:
481:
482: -- Archive Direct Payments
483: archive_balances

Line 492: hr_utility.set_location(l_narrative||' = '||l_net_payment_ytd,100);

488: ,p_tp => l_direct_pay_this_pay
489: );
490:
491: l_narrative := 'Net Payment';
492: hr_utility.set_location(l_narrative||' = '||l_net_payment_ytd,100);
493:
494: -- Archive Net Payment
495: archive_balances
496: (p_arc_assignment_action_id => p_arc_assignment_action_id

Line 503: hr_utility.set_location('Leaving ' || l_procedure,1000);

499: ,p_ytd => l_net_payment_ytd
500: ,p_tp => l_net_payment_this_pay
501: );
502:
503: hr_utility.set_location('Leaving ' || l_procedure,1000);
504:
505: exception
506: when others then
507: hr_utility.set_location('Error in '||l_procedure,999999);

Line 507: hr_utility.set_location('Error in '||l_procedure,999999);

503: hr_utility.set_location('Leaving ' || l_procedure,1000);
504:
505: exception
506: when others then
507: hr_utility.set_location('Error in '||l_procedure,999999);
508: raise;
509: end archive_stat_balances;
510:
511: ---------------------------------------------------------------------------

Line 574: hr_utility.set_location('Entering ' || l_procedure,1);

570: l_procedure varchar2(200) ;
571: --
572: begin
573: l_procedure := g_package||'archive_accruals';
574: hr_utility.set_location('Entering ' || l_procedure,1);
575: --
576: -- 1. Get the accrual_plan_id for this assignment action
577: --
578:

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

583: --
584: -- Get the balance of leave for this accrual plan at the period_end_date
585: --
586: --
587: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
588: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
589: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
590: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
591: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);

Line 588: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);

584: -- Get the balance of leave for this accrual plan at the period_end_date
585: --
586: --
587: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
588: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
589: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
590: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
591: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
592:

Line 589: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);

585: --
586: --
587: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
588: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
589: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
590: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
591: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
592:
593: l_balance := hr_au_holidays.get_net_accrual

Line 590: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);

586: --
587: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
588: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
589: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
590: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
591: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
592:
593: l_balance := hr_au_holidays.get_net_accrual
594: (p_assignment_id => p_assignment_id

Line 591: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);

587: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
588: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
589: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
590: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
591: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
592:
593: l_balance := hr_au_holidays.get_net_accrual
594: (p_assignment_id => p_assignment_id
595: ,p_payroll_id => csr_rec.payroll_id

Line 601: hr_utility.set_location('annual leave balance..........= '||to_char(l_balance),30);

597: ,p_plan_id => csr_rec.accrual_plan_id
598: ,p_calculation_date => p_calculation_date
599: );
600:
601: hr_utility.set_location('annual leave balance..........= '||to_char(l_balance),30);
602:
603: IF csr_rec.accrual_plan_name IS NOT NULL THEN /* Bug No : 2525895 */
604:
605: pay_action_information_api.create_action_information

Line 624: hr_utility.set_location('Leaving '|| l_procedure,1000);

620:
621: END IF; /* Bug No : 2525895 */
622: END LOOP;
623:
624: hr_utility.set_location('Leaving '|| l_procedure,1000);
625:
626: exception
627: when others then
628: hr_utility.set_location('Error in '||l_procedure,999999);

Line 628: hr_utility.set_location('Error in '||l_procedure,999999);

624: hr_utility.set_location('Leaving '|| l_procedure,1000);
625:
626: exception
627: when others then
628: hr_utility.set_location('Error in '||l_procedure,999999);
629: raise;
630: end archive_accruals;
631:
632: ------------------------------------------------------------------------------

Line 752: hr_utility.set_location('Entering '||l_procedure,1);

748:
749: l_exists := 'N' ;
750: i := 1 ;
751: l_procedure := g_package||'archive_leave_details';
752: hr_utility.set_location('Entering '||l_procedure,1);
753: --
754: -- Get all leave taken for this assignment for the given time period
755: --
756: FOR csr_rec IN csr_leave_taken1(p_time_period_id, p_assignment_id)

Line 783: hr_utility.trace('Entering csr_leave_taken1');

779:
780: tab_row_id(i) := csr_rec.row_id ;
781: i := i + 1 ;
782:
783: hr_utility.trace('Entering csr_leave_taken1');
784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

Line 784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);

780: tab_row_id(i) := csr_rec.row_id ;
781: i := i + 1 ;
782:
783: hr_utility.trace('Entering csr_leave_taken1');
784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
788: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

Line 785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);

781: i := i + 1 ;
782:
783: hr_utility.trace('Entering csr_leave_taken1');
784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
788: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
789:

Line 786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);

782:
783: hr_utility.trace('Entering csr_leave_taken1');
784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
788: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
789:
790: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

Line 787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

783: hr_utility.trace('Entering csr_leave_taken1');
784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
788: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
789:
790: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
791: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

Line 788: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

784: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
785: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
786: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
787: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
788: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
789:
790: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
791: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
792:

Line 848: hr_utility.trace('Entering csr_leave_taken1');

844:
845: tab_row_id(i) := csr_rec.row_id ;
846: i := i + 1 ;
847:
848: hr_utility.trace('Entering csr_leave_taken1');
849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

Line 849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);

845: tab_row_id(i) := csr_rec.row_id ;
846: i := i + 1 ;
847:
848: hr_utility.trace('Entering csr_leave_taken1');
849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
853: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

Line 850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);

846: i := i + 1 ;
847:
848: hr_utility.trace('Entering csr_leave_taken1');
849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
853: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
854:

Line 851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);

847:
848: hr_utility.trace('Entering csr_leave_taken1');
849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
853: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
854:
855: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

Line 852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

848: hr_utility.trace('Entering csr_leave_taken1');
849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
853: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
854:
855: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
856: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

Line 853: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

849: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
850: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
851: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
852: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
853: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
854:
855: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
856: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
857:

Line 913: hr_utility.trace('Entering csr_leave_taken1');

909:
910: tab_row_id(i) := csr_rec.row_id ;
911: i := i + 1 ;
912:
913: hr_utility.trace('Entering csr_leave_taken1');
914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

Line 914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);

910: tab_row_id(i) := csr_rec.row_id ;
911: i := i + 1 ;
912:
913: hr_utility.trace('Entering csr_leave_taken1');
914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
918: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

Line 915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);

911: i := i + 1 ;
912:
913: hr_utility.trace('Entering csr_leave_taken1');
914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
918: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
919:

Line 916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);

912:
913: hr_utility.trace('Entering csr_leave_taken1');
914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
918: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
919:
920: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

Line 917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

913: hr_utility.trace('Entering csr_leave_taken1');
914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
918: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
919:
920: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
921: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

Line 918: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

914: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
915: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
916: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
917: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
918: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
919:
920: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
921: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
922:

Line 977: hr_utility.trace('Entering csr_leave_taken1');

973:
974: tab_row_id(i) := csr_rec.row_id ;
975: i := i + 1 ;
976:
977: hr_utility.trace('Entering csr_leave_taken1');
978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

Line 978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);

974: tab_row_id(i) := csr_rec.row_id ;
975: i := i + 1 ;
976:
977: hr_utility.trace('Entering csr_leave_taken1');
978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
982: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

Line 979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);

975: i := i + 1 ;
976:
977: hr_utility.trace('Entering csr_leave_taken1');
978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
982: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
983:

Line 980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);

976:
977: hr_utility.trace('Entering csr_leave_taken1');
978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
982: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
983:
984: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

Line 981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

977: hr_utility.trace('Entering csr_leave_taken1');
978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
982: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
983:
984: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
985: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

Line 982: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

978: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
979: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
980: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
981: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
982: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
983:
984: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
985: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
986:

Line 1040: hr_utility.trace('Entering csr_leave_taken1');

1036:
1037: tab_row_id(i) := csr_rec.row_id ;
1038: i := i + 1 ;
1039:
1040: hr_utility.trace('Entering csr_leave_taken1');
1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

Line 1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);

1037: tab_row_id(i) := csr_rec.row_id ;
1038: i := i + 1 ;
1039:
1040: hr_utility.trace('Entering csr_leave_taken1');
1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1045: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

Line 1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);

1038: i := i + 1 ;
1039:
1040: hr_utility.trace('Entering csr_leave_taken1');
1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1045: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1046:

Line 1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);

1039:
1040: hr_utility.trace('Entering csr_leave_taken1');
1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1045: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1046:
1047: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

Line 1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

1040: hr_utility.trace('Entering csr_leave_taken1');
1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1045: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1046:
1047: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1048: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

Line 1045: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

1041: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1042: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1043: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1044: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1045: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1046:
1047: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1048: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1049:

Line 1074: hr_utility.set_location('Leaving '||l_procedure,1000);

1070: end if;
1071:
1072: END LOOP;
1073:
1074: hr_utility.set_location('Leaving '||l_procedure,1000);
1075:
1076: exception
1077: when others
1078: then

Line 1079: hr_utility.set_location('Error in '||l_procedure,999999);

1075:
1076: exception
1077: when others
1078: then
1079: hr_utility.set_location('Error in '||l_procedure,999999);
1080: raise;
1081: END archive_absences;
1082:
1083: --

Line 1208: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);

1204: l_object_version_number_1 NUMBER ;
1205:
1206: BEGIN
1207: lv_procedure_name := '.archive_offset_payment_method';
1208: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1209: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1210: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1211: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1212:

Line 1209: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);

1205:
1206: BEGIN
1207: lv_procedure_name := '.archive_offset_payment_method';
1208: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1209: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1210: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1211: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1212:
1213: open c_net_pay(p_pre_pay_action_id

Line 1210: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

1206: BEGIN
1207: lv_procedure_name := '.archive_offset_payment_method';
1208: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1209: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1210: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1211: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1212:
1213: open c_net_pay(p_pre_pay_action_id
1214: ,p_assignment_id

Line 1211: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);

1207: lv_procedure_name := '.archive_offset_payment_method';
1208: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1209: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1210: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1211: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1212:
1213: open c_net_pay(p_pre_pay_action_id
1214: ,p_assignment_id
1215: ,p_curr_pymt_eff_date

Line 1218: hr_utility.trace('Opened cursor c_net_pay ');

1214: ,p_assignment_id
1215: ,p_curr_pymt_eff_date
1216: ,p_ppp_source_action_id
1217: ,p_action_context_id);
1218: hr_utility.trace('Opened cursor c_net_pay ');
1219:
1220: loop
1221: fetch c_net_pay into lv_segment1
1222: ,lv_segment2

Line 1236: hr_utility.trace('Fetched c_net_pay ');

1232: ,ln_pre_payment_id
1233: ,ln_org_payment_method_id
1234: ,lv_org_payment_method_name
1235: ,ln_emp_payment_method_id;
1236: hr_utility.trace('Fetched c_net_pay ');
1237: if c_net_pay%notfound then
1238: exit;
1239: end if;
1240:

Line 1284: hr_utility.set_location('Leaving pay_au_payslip_archive'|| lv_procedure_name,100);

1280: p_action_information30 => null
1281: );
1282: end loop;
1283: close c_net_pay;
1284: hr_utility.set_location('Leaving pay_au_payslip_archive'|| lv_procedure_name,100);
1285: END archive_offset_payment_method;
1286: --
1287: --------------------------------------------------------------------------------------
1288: --

Line 1421: hr_utility.set_location('Entering '|| l_procedure,1);

1417: l_child_action_id pay_assignment_actions.assignment_action_id%type;
1418:
1419: begin
1420: l_procedure := g_package||'archive_employee_details';
1421: hr_utility.set_location('Entering '|| l_procedure,1);
1422:
1423: l_step := null ; /* Bug 5504354 Initializing l_step */
1424:
1425: -- Need to get the end date of the latest runs period.

Line 1438: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);

1434: fetch csr_tax_unit
1435: into l_tax_unit_id;
1436: close csr_tax_unit;
1437:
1438: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);

Line 1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);

1435: into l_tax_unit_id;
1436: close csr_tax_unit;
1437:
1438: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);

Line 1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);

1436: close csr_tax_unit;
1437:
1438: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */

Line 1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);

1437:
1438: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1445: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);

Line 1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);

1438: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1445: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1446:

Line 1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);

1439: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1445: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1446:
1447: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */

Line 1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */

1440: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1445: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1446:
1447: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */
1448:

Line 1445: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);

1441: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1442: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1443: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1444: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1445: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1446:
1447: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */
1448:
1449: pay_emp_action_arch.get_personal_information

Line 1462: hr_utility.set_location('AU Finished get_personal_information',15);

1458: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No : 2491444 */
1459: , p_ppp_source_action_id => NULL
1460: );
1461:
1462: hr_utility.set_location('AU Finished get_personal_information',15);
1463:
1464:
1465: /* Bug#5681819 Call procedure only incase of offset payroll
1466: Bug#6962336 Modified Date from Regular Payment Date to Prepayment Effective Date

Line 1492: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);

1488: );
1489: end if;
1490:
1491: -- Get the annual leave balance
1492: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);

Line 1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);

1489: end if;
1490:
1491: -- Get the annual leave balance
1492: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);

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

1490:
1491: -- Get the annual leave balance
1492: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1498: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);

Line 1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);

1491: -- Get the annual leave balance
1492: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1498: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1499:

Line 1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);

1492: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1498: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1499:
1500: /* Bug No : 2491444 -- In all the procedure calls below the value passed for time_period_id changed */

Line 1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);

1493: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1498: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1499:
1500: /* Bug No : 2491444 -- In all the procedure calls below the value passed for time_period_id changed */
1501:

Line 1498: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);

1494: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1495: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1496: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1497: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1498: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1499:
1500: /* Bug No : 2491444 -- In all the procedure calls below the value passed for time_period_id changed */
1501:
1502: archive_accruals

Line 1510: hr_utility.set_location(l_procedure,21);

1506: ,p_arc_assignment_action_id => p_arc_assignment_action_id
1507: ,p_calculation_date => p_period_end_date -- Calculate the balance as at period end date
1508: );
1509:
1510: hr_utility.set_location(l_procedure,21);
1511:
1512: archive_absences
1513: (p_assignment_id => p_assignment_id
1514: ,p_pre_effective_date => p_pre_effective_date

Line 1520: hr_utility.set_location(l_procedure,22);

1516: ,p_arc_assignment_action_id => p_arc_assignment_action_id
1517: ,p_run_assignment_action_id => p_run_assignment_action_id
1518: );
1519:
1520: hr_utility.set_location(l_procedure,22);
1521:
1522: /* Bug# 4363057 - Modified call to archive_stat_balances passing prepayment run action_id*/
1523: archive_stat_balances
1524: (p_pre_assignment_action_id => p_pre_assignment_action_id -- prepayment run assignment action, latest

Line 1532: hr_utility.set_location(l_procedure,23);

1528: ,p_calculation_date => p_period_end_date -- date to calculate the balances at
1529: );
1530:
1531:
1532: hr_utility.set_location(l_procedure,23);
1533:
1534: pay_apac_payslip_archive.archive_user_balances
1535: (p_arch_assignment_action_id => p_arc_assignment_action_id -- archive run assignment action
1536: ,p_run_assignment_action_id => p_run_assignment_action_id -- payroll run assignment action

Line 1540: hr_utility.set_location(l_procedure,24);

1536: ,p_run_assignment_action_id => p_run_assignment_action_id -- payroll run assignment action
1537: ,p_pre_effective_date => p_pre_effective_date -- prepayment run effective_date
1538: );
1539:
1540: hr_utility.set_location(l_procedure,24);
1541:
1542: archive_stat_elements
1543: (p_pre_assignment_action_id => p_pre_assignment_action_id -- prepayment run assignment action
1544: ,p_pre_effective_date => p_pre_effective_date -- prepayment run effective date used to archive

Line 1549: hr_utility.set_location(l_procedure,25);

1545: ,p_assignment_id => p_assignment_id -- assignment id
1546: ,p_arc_assignment_action_id => p_arc_assignment_action_id -- archive run assignment action
1547: );
1548:
1549: hr_utility.set_location(l_procedure,25);
1550:
1551: pay_apac_payslip_archive.archive_user_elements
1552: (p_arch_assignment_action_id => p_arc_assignment_action_id -- archive run assignment action
1553: ,p_pre_assignment_action_id => p_pre_assignment_action_id -- prepayment run assignment action

Line 1558: hr_utility.set_location(l_procedure,26);

1554: ,p_latest_run_assact_id => p_run_assignment_action_id -- payroll run assignment action
1555: ,p_pre_effective_date => p_pre_effective_date -- prepayment run effective_date
1556: );
1557:
1558: hr_utility.set_location(l_procedure,26);
1559:
1560: /* Bug 5504354 - Archive Pay Advice Date */
1561: /* Bug 6032985 - added parameter p_pre_effective_date */
1562: open csr_pay_advice_date(p_run_assignment_action_id,p_run_date_earned,p_pre_effective_date);

Line 1571: hr_utility.set_location('Archiving AU EMPLOYEE DETAILS',30);

1567: open csr_abn(p_assignment_id, p_pre_effective_date);
1568: fetch csr_abn into l_abn;
1569: close csr_abn;
1570:
1571: hr_utility.set_location('Archiving AU EMPLOYEE DETAILS',30);
1572:
1573: pay_action_information_api.create_action_information
1574: ( p_action_information_id => l_action_info_id
1575: , p_action_context_id => p_arc_assignment_action_id

Line 1612: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);

1608: /* Bug 5504354- This grade step will be mapped to an additional person information
1609: detail item in Payslip. Grade step will be mapped to Action Information9
1610: and will be archived with action_information_category as ADDL EMPLOYEE DETAILS */
1611:
1612: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1613:
1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);

Line 1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);

1610: and will be archived with action_information_category as ADDL EMPLOYEE DETAILS */
1611:
1612: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1613:
1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1617: hr_utility.trace('Value of l_step is '||l_step);
1618: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);

Line 1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);

1611:
1612: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1613:
1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1617: hr_utility.trace('Value of l_step is '||l_step);
1618: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1619:

Line 1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);

1612: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1613:
1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1617: hr_utility.trace('Value of l_step is '||l_step);
1618: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1619:
1620:

Line 1617: hr_utility.trace('Value of l_step is '||l_step);

1613:
1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1617: hr_utility.trace('Value of l_step is '||l_step);
1618: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1619:
1620:
1621: pay_action_information_api.create_action_information (

Line 1618: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);

1614: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1615: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1616: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1617: hr_utility.trace('Value of l_step is '||l_step);
1618: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1619:
1620:
1621: pay_action_information_api.create_action_information (
1622: p_action_information_id => l_action_info_id

Line 1633: hr_utility.set_location('Leaving '|| l_procedure,1000);

1629: ,p_action_information_category => 'ADDL EMPLOYEE DETAILS'
1630: ,p_action_information9 => l_step
1631: );
1632:
1633: hr_utility.set_location('Leaving '|| l_procedure,1000);
1634: exception
1635: when others
1636: then
1637: hr_utility.set_location('Error in '||l_procedure,999999);

Line 1637: hr_utility.set_location('Error in '||l_procedure,999999);

1633: hr_utility.set_location('Leaving '|| l_procedure,1000);
1634: exception
1635: when others
1636: then
1637: hr_utility.set_location('Error in '||l_procedure,999999);
1638: raise;
1639: END archive_employee_details;
1640:
1641: ----------------------------

Line 1706: hr_utility.set_location('Entering '||l_procedure,1);

1702:
1703:
1704: begin
1705: l_procedure := g_package||'archive_code';
1706: hr_utility.set_location('Entering '||l_procedure,1);
1707:
1708: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1709: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1710: /*Bug#3363519 */

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

1704: begin
1705: l_procedure := g_package||'archive_code';
1706: hr_utility.set_location('Entering '||l_procedure,1);
1707:
1708: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1709: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1710: /*Bug#3363519 */
1711: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id,
1712: p_effective_date);

Line 1709: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);

1705: l_procedure := g_package||'archive_code';
1706: hr_utility.set_location('Entering '||l_procedure,1);
1707:
1708: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1709: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1710: /*Bug#3363519 */
1711: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id,
1712: p_effective_date);
1713:

Line 1717: hr_utility.set_location(l_procedure,50);

1713:
1714: -- For each payslip to be generated
1715: for payslip_rec in get_payslip_aa(p_assignment_action_id) loop
1716: --
1717: hr_utility.set_location(l_procedure,50);
1718:
1719: archive_employee_details
1720: (p_assignment_id => payslip_rec.assignment_id
1721: ,p_arc_assignment_action_id => payslip_rec.chld_arc_assignment_action_id -- archive run assignment action

Line 1732: hr_utility.set_location(l_procedure,60);

1728: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
1729: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
1730: );
1731:
1732: hr_utility.set_location(l_procedure,60);
1733: --
1734: end loop;
1735:
1736: hr_utility.set_location('Leaving '||l_procedure,1000);

Line 1736: hr_utility.set_location('Leaving '||l_procedure,1000);

1732: hr_utility.set_location(l_procedure,60);
1733: --
1734: end loop;
1735:
1736: hr_utility.set_location('Leaving '||l_procedure,1000);
1737:
1738: exception
1739: when others then
1740: hr_utility.set_location('Error in '||l_procedure,999999);

Line 1740: hr_utility.set_location('Error in '||l_procedure,999999);

1736: hr_utility.set_location('Leaving '||l_procedure,1000);
1737:
1738: exception
1739: when others then
1740: hr_utility.set_location('Error in '||l_procedure,999999);
1741: raise;
1742: end archive_code;
1743: end pay_au_payslip_archive;