eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

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

107: l_procedure varchar2(200) ;
108:
109: begin
110: l_procedure := g_package||'range_code';
111: hr_utility.set_location('Entering '||l_procedure,1);
112:
113: -- Archive the payroll action level data and EIT defintions.
114: pay_apac_payslip_archive.range_code( p_payroll_action_id => p_payroll_action_id);
115: /*Bug#3363519 */

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

115: /*Bug#3363519 */
116: pay_core_payslip_utils.range_cursor(p_payroll_action_id,
117: p_sql);
118:
119: hr_utility.set_location('Leaving '||l_procedure,1000);
120:
121: end range_code;
122:
123: --------------------------------------------------------------------

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

135: l_procedure varchar2(200) ;
136:
137: begin
138: l_procedure := g_package||'initialization_code';
139: hr_utility.set_location('Entering '||l_procedure,1);
140:
141: g_arc_payroll_action_id := p_payroll_action_id;
142: hr_utility.set_location('g_arc_payroll_action_id......='||g_arc_payroll_action_id,10);
143:

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

138: l_procedure := g_package||'initialization_code';
139: hr_utility.set_location('Entering '||l_procedure,1);
140:
141: g_arc_payroll_action_id := p_payroll_action_id;
142: hr_utility.set_location('g_arc_payroll_action_id......='||g_arc_payroll_action_id,10);
143:
144: -- initialization_code to to set the global tables for EIT
145: -- that will be used by each thread in multi-threading.
146: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);

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

147:
148: /* Bug 4169557 - Introduced calls to populate defined balance ID's */
149: pay_au_soe_pkg.populate_defined_balances;
150:
151: hr_utility.set_location('Leaving '||l_procedure,1000);
152:
153: exception
154: when others then
155: hr_utility.set_location('Error in '||l_procedure,999999);

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

151: hr_utility.set_location('Leaving '||l_procedure,1000);
152:
153: exception
154: when others then
155: hr_utility.set_location('Error in '||l_procedure,999999);
156: raise;
157: end initialization_code;
158:
159: --------------------------------------------------------------------

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

175: l_procedure varchar2(200) ;
176:
177: begin
178: l_procedure := g_package||'assignment_action_code';
179: hr_utility.set_location('Entering ' || l_procedure,1);
180: /*Bug#3363519 */
181: pay_core_payslip_utils.action_creation (
182: p_payroll_action_id,
183: p_start_person,

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

187: 'AU');
188:
189: exception
190: when others then
191: hr_utility.set_location('Error in '||l_procedure,999999);
192: raise;
193: end assignment_action_code;
194:
195: --------------------------------------------------------------------

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

227: -- l_rate number;
228:
229: begin
230: l_procedure := g_package||'archive_stat_elements';
231: hr_utility.set_location('Entering ' || l_procedure,1);
232: --
233: -- Loop through the processed elements and archive the data
234: -- into the flexfield structure APAC_ELEMENTS.
235: --

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

234: -- into the flexfield structure APAC_ELEMENTS.
235: --
236: FOR csr_rec IN csr_std_elements(p_pre_assignment_action_id)
237: LOOP
238: hr_utility.set_location('Archiving APAC Element Details',20);
239: /* Bug:3260854 Added the following check to avoid
240: divide by zero error. */
241:
242: /* Bug 5914696 */

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

273: , p_action_information9 => fnd_number.number_to_canonical(csr_rec.rate) -- Bug: 3604094
274: );
275: END IF;
276: END LOOP;
277: hr_utility.set_location('Leaving ' || l_procedure,1000);
278: exception
279: when others
280: then
281: hr_utility.set_location('Error in '||l_procedure,999999);

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

277: hr_utility.set_location('Leaving ' || l_procedure,1000);
278: exception
279: when others
280: then
281: hr_utility.set_location('Error in '||l_procedure,999999);
282: raise;
283: end archive_stat_elements;
284:
285: --------------------------------------------------------------------

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

303: l_ovn number;
304: l_procedure varchar2(200) ;
305: begin
306: l_procedure := g_package||'archive_balances';
307: hr_utility.set_location('Entering ' || l_procedure,1);
308:
309: pay_action_information_api.create_action_information
310: (p_action_information_id => l_action_info_id
311: ,p_action_context_id => p_arc_assignment_action_id

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

321: ,p_action_information4 => fnd_number.number_to_canonical(p_ytd) -- Bug: 3604094
322: ,p_action_information5 => fnd_number.number_to_canonical(p_tp) -- Bug 3891564, Bug: 3604094
323: );
324:
325: hr_utility.set_location('Leaving ' || l_procedure,1000);
326: exception
327: when others then
328: hr_utility.set_location('Error in '||l_procedure,999999);
329: raise;

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

324:
325: hr_utility.set_location('Leaving ' || l_procedure,1000);
326: exception
327: when others then
328: hr_utility.set_location('Error in '||l_procedure,999999);
329: raise;
330: end archive_balances;
331:
332: --------------------------------------------------------------------

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

375:
376: l_get_le_level_bal :='Y'; --3935483
377: l_fetch_only_ytd_value :='N'; --3935483
378: l_procedure := g_package||'archive_stat_balances';
379: hr_utility.set_location('Entering ' || l_procedure,1);
380: --
381: -- Get the balance values
382: --
383: /* Bug 3891564 - Added four new parameters to the procedure call to return taxable income

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

412: 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;
413:
414:
415: l_narrative := 'Gross Earnings';
416: hr_utility.set_location(l_narrative||' = '||l_gross_ytd,30);
417:
418: -- Archive Gross Earnings
419: archive_balances
420: (p_arc_assignment_action_id => p_arc_assignment_action_id

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

424: ,p_tp => l_gross_this_pay
425: );
426:
427: l_narrative := 'Non Taxable Earnings';
428: hr_utility.set_location(l_narrative||' = '||l_non_tax_allow_ytd,40);
429:
430: -- Archive Non Taxable Earnings
431: archive_balances
432: (p_arc_assignment_action_id => p_arc_assignment_action_id

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

436: ,p_tp => l_non_tax_allow_this_pay
437: );
438:
439: l_narrative := 'Pre Tax Deductions';
440: hr_utility.set_location(l_narrative||' = '||l_pre_tax_deductions_ytd,50);
441:
442: -- Archive Pre Tax Deductions
443: archive_balances
444: (p_arc_assignment_action_id => p_arc_assignment_action_id

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

448: ,p_tp => l_pre_tax_deductions_this_pay
449: );
450:
451: l_narrative := 'Taxable Gross';
452: hr_utility.set_location(l_narrative||' = '||l_tax_income_ytd,60);
453:
454: -- Archive Taxable Earnings
455: archive_balances
456: (p_arc_assignment_action_id => p_arc_assignment_action_id

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

460: ,p_tp => l_tax_income_this_pay
461: );
462:
463: l_narrative := 'Tax Deductions';
464: hr_utility.set_location(l_narrative||' = '||l_tax_deductions_ytd,70);
465:
466: -- Archive Tax Deductions
467: archive_balances
468: (p_arc_assignment_action_id => p_arc_assignment_action_id

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

472: ,p_tp => l_tax_deductions_this_pay
473: );
474:
475: l_narrative := 'Post Tax Deductions';
476: hr_utility.set_location(l_narrative||' = '||l_other_deductions_ytd,80);
477:
478:
479: -- Archive Post Tax Deductions
480: archive_balances

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

485: ,p_tp => l_other_deductions_this_pay
486: );
487:
488: l_narrative := 'Direct Payments';
489: hr_utility.set_location(l_narrative||' = '||l_direct_pay_ytd,90);
490:
491:
492: -- Archive Direct Payments
493: archive_balances

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

498: ,p_tp => l_direct_pay_this_pay
499: );
500:
501: l_narrative := 'Net Payment';
502: hr_utility.set_location(l_narrative||' = '||l_net_payment_ytd,100);
503:
504: -- Archive Net Payment
505: archive_balances
506: (p_arc_assignment_action_id => p_arc_assignment_action_id

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

509: ,p_ytd => l_net_payment_ytd
510: ,p_tp => l_net_payment_this_pay
511: );
512:
513: hr_utility.set_location('Leaving ' || l_procedure,1000);
514:
515: exception
516: when others then
517: hr_utility.set_location('Error in '||l_procedure,999999);

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

513: hr_utility.set_location('Leaving ' || l_procedure,1000);
514:
515: exception
516: when others then
517: hr_utility.set_location('Error in '||l_procedure,999999);
518: raise;
519: end archive_stat_balances;
520:
521: ---------------------------------------------------------------------------

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

580: l_procedure varchar2(200) ;
581: --
582: begin
583: l_procedure := g_package||'archive_accruals';
584: hr_utility.set_location('Entering ' || l_procedure,1);
585: --
586: -- 1. Get the accrual_plan_id for this assignment action
587: --
588:

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

593: --
594: -- Get the balance of leave for this accrual plan at the period_end_date
595: --
596: --
597: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
598: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
599: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
600: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
601: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);

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

594: -- Get the balance of leave for this accrual plan at the period_end_date
595: --
596: --
597: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
598: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
599: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
600: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
601: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
602:

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

595: --
596: --
597: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
598: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
599: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
600: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
601: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
602:
603: l_balance := hr_au_holidays.get_net_accrual

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

596: --
597: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
598: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
599: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
600: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
601: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
602:
603: l_balance := hr_au_holidays.get_net_accrual
604: (p_assignment_id => p_assignment_id

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

597: hr_utility.set_location('p_assignment_id.............= '||to_char(p_assignment_id),20);
598: hr_utility.set_location('l_payroll_id................= '||to_char(csr_rec.payroll_id),20);
599: hr_utility.set_location('l_business_group_id.........= '||to_char(csr_rec.business_group_id),20);
600: hr_utility.set_location('l_accrual_plan_id...........= '||to_char(csr_rec.accrual_plan_id),20);
601: hr_utility.set_location('p_calculation_date..........= '||to_char(p_calculation_date,'DD-MON-YYYY'),20);
602:
603: l_balance := hr_au_holidays.get_net_accrual
604: (p_assignment_id => p_assignment_id
605: ,p_payroll_id => csr_rec.payroll_id

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

607: ,p_plan_id => csr_rec.accrual_plan_id
608: ,p_calculation_date => p_calculation_date
609: );
610:
611: hr_utility.set_location('annual leave balance..........= '||to_char(l_balance),30);
612:
613: IF csr_rec.accrual_plan_name IS NOT NULL THEN /* Bug No : 2525895 */
614:
615: pay_action_information_api.create_action_information

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

630:
631: END IF; /* Bug No : 2525895 */
632: END LOOP;
633:
634: hr_utility.set_location('Leaving '|| l_procedure,1000);
635:
636: exception
637: when others then
638: hr_utility.set_location('Error in '||l_procedure,999999);

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

634: hr_utility.set_location('Leaving '|| l_procedure,1000);
635:
636: exception
637: when others then
638: hr_utility.set_location('Error in '||l_procedure,999999);
639: raise;
640: end archive_accruals;
641:
642: ------------------------------------------------------------------------------

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

789:
790: l_exists := 'N' ;
791: i := 1 ;
792: l_procedure := g_package||'archive_leave_details';
793: hr_utility.set_location('Entering '||l_procedure,1);
794: --
795: -- Get all leave taken for this assignment for the given time period
796: --
797: FOR csr_rec IN csr_leave_taken1(p_time_period_id, p_assignment_id)

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

820:
821: tab_row_id(i) := csr_rec.row_id ;
822: i := i + 1 ;
823:
824: hr_utility.trace('Entering csr_leave_taken1');
825: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
826: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
827: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
828: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

821: tab_row_id(i) := csr_rec.row_id ;
822: i := i + 1 ;
823:
824: hr_utility.trace('Entering csr_leave_taken1');
825: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
826: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
827: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
828: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
829: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

822: i := i + 1 ;
823:
824: hr_utility.trace('Entering csr_leave_taken1');
825: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
826: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
827: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
828: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
829: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
830:

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

823:
824: hr_utility.trace('Entering csr_leave_taken1');
825: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
826: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
827: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
828: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
829: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
830:
831: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

824: hr_utility.trace('Entering csr_leave_taken1');
825: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
826: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
827: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
828: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
829: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
830:
831: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
832: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

825: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
826: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
827: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
828: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
829: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
830:
831: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
832: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
833:

Line 889: hr_utility.trace('Entering csr_leave_taken2');

885:
886: tab_row_id(i) := csr_rec.row_id ;
887: i := i + 1 ;
888:
889: hr_utility.trace('Entering csr_leave_taken2');
890: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
891: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
892: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
893: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

886: tab_row_id(i) := csr_rec.row_id ;
887: i := i + 1 ;
888:
889: hr_utility.trace('Entering csr_leave_taken2');
890: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
891: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
892: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
893: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
894: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

887: i := i + 1 ;
888:
889: hr_utility.trace('Entering csr_leave_taken2');
890: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
891: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
892: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
893: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
894: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
895:

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

888:
889: hr_utility.trace('Entering csr_leave_taken2');
890: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
891: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
892: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
893: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
894: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
895:
896: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

889: hr_utility.trace('Entering csr_leave_taken2');
890: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
891: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
892: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
893: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
894: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
895:
896: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
897: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

890: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
891: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
892: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
893: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
894: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
895:
896: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
897: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
898:

Line 954: hr_utility.trace('Entering csr_leave_taken3');

950:
951: tab_row_id(i) := csr_rec.row_id ;
952: i := i + 1 ;
953:
954: hr_utility.trace('Entering csr_leave_taken3');
955: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
956: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
957: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
958: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

951: tab_row_id(i) := csr_rec.row_id ;
952: i := i + 1 ;
953:
954: hr_utility.trace('Entering csr_leave_taken3');
955: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
956: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
957: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
958: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
959: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

952: i := i + 1 ;
953:
954: hr_utility.trace('Entering csr_leave_taken3');
955: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
956: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
957: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
958: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
959: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
960:

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

953:
954: hr_utility.trace('Entering csr_leave_taken3');
955: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
956: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
957: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
958: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
959: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
960:
961: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

954: hr_utility.trace('Entering csr_leave_taken3');
955: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
956: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
957: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
958: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
959: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
960:
961: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
962: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

955: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
956: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
957: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
958: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
959: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
960:
961: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
962: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
963:

Line 1018: hr_utility.trace('Entering csr_leave_taken4');

1014:
1015: tab_row_id(i) := csr_rec.row_id ;
1016: i := i + 1 ;
1017:
1018: hr_utility.trace('Entering csr_leave_taken4');
1019: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1020: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1021: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1022: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

1015: tab_row_id(i) := csr_rec.row_id ;
1016: i := i + 1 ;
1017:
1018: hr_utility.trace('Entering csr_leave_taken4');
1019: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1020: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1021: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1022: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1023: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

1016: i := i + 1 ;
1017:
1018: hr_utility.trace('Entering csr_leave_taken4');
1019: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1020: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1021: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1022: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1023: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1024:

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

1017:
1018: hr_utility.trace('Entering csr_leave_taken4');
1019: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1020: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1021: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1022: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1023: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1024:
1025: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

1018: hr_utility.trace('Entering csr_leave_taken4');
1019: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1020: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1021: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1022: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1023: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1024:
1025: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1026: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

1019: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1020: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1021: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1022: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1023: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1024:
1025: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1026: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1027:

Line 1081: hr_utility.trace('Entering csr_leave_taken5');

1077:
1078: tab_row_id(i) := csr_rec.row_id ;
1079: i := i + 1 ;
1080:
1081: hr_utility.trace('Entering csr_leave_taken5');
1082: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1083: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1084: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1085: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

1078: tab_row_id(i) := csr_rec.row_id ;
1079: i := i + 1 ;
1080:
1081: hr_utility.trace('Entering csr_leave_taken5');
1082: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1083: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1084: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1085: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1086: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

1079: i := i + 1 ;
1080:
1081: hr_utility.trace('Entering csr_leave_taken5');
1082: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1083: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1084: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1085: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1086: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1087:

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

1080:
1081: hr_utility.trace('Entering csr_leave_taken5');
1082: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1083: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1084: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1085: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1086: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1087:
1088: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

1081: hr_utility.trace('Entering csr_leave_taken5');
1082: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1083: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1084: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1085: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1086: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1087:
1088: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1089: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

1082: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1083: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1084: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1085: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1086: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1087:
1088: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1089: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1090:

Line 1143: hr_utility.trace('Entering csr_leave_taken6');

1139:
1140: tab_row_id(i) := csr_rec.row_id ;
1141: i := i + 1 ;
1142:
1143: hr_utility.trace('Entering csr_leave_taken6');
1144: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1145: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1146: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1147: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

1140: tab_row_id(i) := csr_rec.row_id ;
1141: i := i + 1 ;
1142:
1143: hr_utility.trace('Entering csr_leave_taken6');
1144: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1145: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1146: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1147: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1148: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

1141: i := i + 1 ;
1142:
1143: hr_utility.trace('Entering csr_leave_taken6');
1144: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1145: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1146: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1147: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1148: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1149:

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

1142:
1143: hr_utility.trace('Entering csr_leave_taken6');
1144: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1145: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1146: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1147: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1148: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1149:
1150: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

1143: hr_utility.trace('Entering csr_leave_taken6');
1144: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1145: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1146: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1147: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1148: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1149:
1150: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1151: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

1144: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1145: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1146: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1147: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1148: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1149:
1150: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1151: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1152:

Line 1205: hr_utility.trace('Entering csr_leave_taken7');

1201:
1202: tab_row_id(i) := csr_rec.row_id ;
1203: i := i + 1 ;
1204:
1205: hr_utility.trace('Entering csr_leave_taken7');
1206: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1207: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1208: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1209: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);

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

1202: tab_row_id(i) := csr_rec.row_id ;
1203: i := i + 1 ;
1204:
1205: hr_utility.trace('Entering csr_leave_taken7');
1206: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1207: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1208: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1209: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1210: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);

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

1203: i := i + 1 ;
1204:
1205: hr_utility.trace('Entering csr_leave_taken7');
1206: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1207: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1208: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1209: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1210: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1211:

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

1204:
1205: hr_utility.trace('Entering csr_leave_taken7');
1206: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1207: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1208: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1209: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1210: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1211:
1212: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/

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

1205: hr_utility.trace('Entering csr_leave_taken7');
1206: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1207: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1208: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1209: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1210: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1211:
1212: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1213: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

1206: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.element_reporting_name,50);
1207: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
1208: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
1209: hr_utility.set_location('csr_rec.absence_hours..........= '||csr_rec.absence_hours,50);
1210: hr_utility.set_location('csr_rec.payment................= '||csr_rec.payment,50);
1211:
1212: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date); /*Bug 2438495*/
1213: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
1214:

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

1235: end if;
1236:
1237: END LOOP;
1238:
1239: hr_utility.set_location('Leaving '||l_procedure,1000);
1240:
1241: exception
1242: when others
1243: then

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

1240:
1241: exception
1242: when others
1243: then
1244: hr_utility.set_location('Error in '||l_procedure,999999);
1245: raise;
1246: END archive_absences;
1247:
1248: --

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

1369: l_object_version_number_1 NUMBER ;
1370:
1371: BEGIN
1372: lv_procedure_name := '.archive_offset_payment_method';
1373: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1374: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1375: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1376: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1377:

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

1370:
1371: BEGIN
1372: lv_procedure_name := '.archive_offset_payment_method';
1373: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1374: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1375: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1376: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1377:
1378: open c_net_pay(p_pre_pay_action_id

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

1371: BEGIN
1372: lv_procedure_name := '.archive_offset_payment_method';
1373: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1374: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1375: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1376: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1377:
1378: open c_net_pay(p_pre_pay_action_id
1379: ,p_assignment_id

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

1372: lv_procedure_name := '.archive_offset_payment_method';
1373: hr_utility.set_location('pay_au_payslip_archive' || lv_procedure_name,10);
1374: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
1375: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
1376: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
1377:
1378: open c_net_pay(p_pre_pay_action_id
1379: ,p_assignment_id
1380: ,p_curr_pymt_eff_date

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

1379: ,p_assignment_id
1380: ,p_curr_pymt_eff_date
1381: ,p_ppp_source_action_id
1382: ,p_action_context_id);
1383: hr_utility.trace('Opened cursor c_net_pay ');
1384:
1385: loop
1386: fetch c_net_pay into lv_segment1
1387: ,lv_segment2

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

1397: ,ln_pre_payment_id
1398: ,ln_org_payment_method_id
1399: ,lv_org_payment_method_name
1400: ,ln_emp_payment_method_id;
1401: hr_utility.trace('Fetched c_net_pay ');
1402: if c_net_pay%notfound then
1403: exit;
1404: end if;
1405:

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

1445: p_action_information30 => null
1446: );
1447: end loop;
1448: close c_net_pay;
1449: hr_utility.set_location('Leaving pay_au_payslip_archive'|| lv_procedure_name,100);
1450: END archive_offset_payment_method;
1451: --
1452: --------------------------------------------------------------------------------------
1453: --

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

1582: l_child_action_id pay_assignment_actions.assignment_action_id%type;
1583:
1584: begin
1585: l_procedure := g_package||'archive_employee_details';
1586: hr_utility.set_location('Entering '|| l_procedure,1);
1587:
1588: l_step := null ; /* Bug 5504354 Initializing l_step */
1589:
1590: -- Need to get the end date of the latest runs period.

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

1599: fetch csr_tax_unit
1600: into l_tax_unit_id;
1601: close csr_tax_unit;
1602:
1603: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1604: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);

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

1600: into l_tax_unit_id;
1601: close csr_tax_unit;
1602:
1603: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1604: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);

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

1601: close csr_tax_unit;
1602:
1603: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1604: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */

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

1602:
1603: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1604: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);

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

1603: hr_utility.set_location('p_payroll_action_id........'||g_arc_payroll_action_id,10);
1604: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1611:

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

1604: hr_utility.set_location('p_arc_assignment_action_id '||p_arc_assignment_action_id,10);
1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1611:
1612: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */

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

1605: hr_utility.set_location('p_assignment_id............'||p_assignment_id,10);
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1611:
1612: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */
1613:

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

1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1611:
1612: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */
1613:
1614: pay_emp_action_arch.get_personal_information

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

1623: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No : 2491444 */
1624: , p_ppp_source_action_id => NULL
1625: );
1626:
1627: hr_utility.set_location('AU Finished get_personal_information',15);
1628:
1629:
1630: /* Bug#5681819 Call procedure only incase of offset payroll
1631: Bug#6962336 Modified Date from Regular Payment Date to Prepayment Effective Date

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

1653: );
1654: end if;
1655:
1656: -- Get the annual leave balance
1657: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1658: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);

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

1654: end if;
1655:
1656: -- Get the annual leave balance
1657: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1658: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1662: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);

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

1655:
1656: -- Get the annual leave balance
1657: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1658: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1662: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1663: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);

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

1656: -- Get the annual leave balance
1657: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1658: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1662: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1663: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1664:

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

1657: hr_utility.set_location('p_payroll_action_id.........'||g_arc_payroll_action_id,20);
1658: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1662: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1663: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1664:
1665: /* Bug No : 2491444 -- In all the procedure calls below the value passed for time_period_id changed */

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

1658: hr_utility.set_location('p_time_period_id............'||p_time_period_id,20);
1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1662: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1663: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1664:
1665: /* Bug No : 2491444 -- In all the procedure calls below the value passed for time_period_id changed */
1666:

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

1659: hr_utility.set_location('p_assignment_id.............'||p_assignment_id,20);
1660: hr_utility.set_location('p_run_date_earned...........'||to_char(p_run_date_earned,'DD-MON-YYYY'),20);
1661: hr_utility.set_location('p_arc_assignment_action_id..'||p_arc_assignment_action_id,20);
1662: hr_utility.set_location('p_run_assignment_action_id..'||p_run_assignment_action_id,20);
1663: hr_utility.set_location('Calling pay_apac_payslip_archive.archive_leave_details',20);
1664:
1665: /* Bug No : 2491444 -- In all the procedure calls below the value passed for time_period_id changed */
1666:
1667: archive_accruals

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

1671: ,p_arc_assignment_action_id => p_arc_assignment_action_id
1672: ,p_calculation_date => p_period_end_date -- Calculate the balance as at period end date
1673: );
1674:
1675: hr_utility.set_location(l_procedure,21);
1676:
1677: archive_absences
1678: (p_assignment_id => p_assignment_id
1679: ,p_pre_effective_date => p_pre_effective_date

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

1681: ,p_arc_assignment_action_id => p_arc_assignment_action_id
1682: ,p_run_assignment_action_id => p_run_assignment_action_id
1683: );
1684:
1685: hr_utility.set_location(l_procedure,22);
1686:
1687: /* Bug# 4363057 - Modified call to archive_stat_balances passing prepayment run action_id*/
1688: archive_stat_balances
1689: (p_pre_assignment_action_id => p_pre_assignment_action_id -- prepayment run assignment action, latest

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

1693: ,p_calculation_date => p_period_end_date -- date to calculate the balances at
1694: );
1695:
1696:
1697: hr_utility.set_location(l_procedure,23);
1698:
1699: pay_apac_payslip_archive.archive_user_balances
1700: (p_arch_assignment_action_id => p_arc_assignment_action_id -- archive run assignment action
1701: ,p_run_assignment_action_id => p_run_assignment_action_id -- payroll run assignment action

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

1701: ,p_run_assignment_action_id => p_run_assignment_action_id -- payroll run assignment action
1702: ,p_pre_effective_date => p_pre_effective_date -- prepayment run effective_date
1703: );
1704:
1705: hr_utility.set_location(l_procedure,24);
1706:
1707: archive_stat_elements
1708: (p_pre_assignment_action_id => p_pre_assignment_action_id -- prepayment run assignment action
1709: ,p_pre_effective_date => p_pre_effective_date -- prepayment run effective date used to archive

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

1710: ,p_assignment_id => p_assignment_id -- assignment id
1711: ,p_arc_assignment_action_id => p_arc_assignment_action_id -- archive run assignment action
1712: );
1713:
1714: hr_utility.set_location(l_procedure,25);
1715:
1716: pay_apac_payslip_archive.archive_user_elements
1717: (p_arch_assignment_action_id => p_arc_assignment_action_id -- archive run assignment action
1718: ,p_pre_assignment_action_id => p_pre_assignment_action_id -- prepayment run assignment action

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

1719: ,p_latest_run_assact_id => p_run_assignment_action_id -- payroll run assignment action
1720: ,p_pre_effective_date => p_pre_effective_date -- prepayment run effective_date
1721: );
1722:
1723: hr_utility.set_location(l_procedure,26);
1724:
1725: /* Bug 5504354 - Archive Pay Advice Date */
1726: /* Bug 6032985 - added parameter p_pre_effective_date */
1727: open csr_pay_advice_date(p_run_assignment_action_id,p_run_date_earned,p_pre_effective_date);

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

1732: open csr_abn(p_assignment_id, p_pre_effective_date);
1733: fetch csr_abn into l_abn;
1734: close csr_abn;
1735:
1736: hr_utility.set_location('Archiving AU EMPLOYEE DETAILS',30);
1737:
1738: pay_action_information_api.create_action_information
1739: ( p_action_information_id => l_action_info_id
1740: , p_action_context_id => p_arc_assignment_action_id

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

1773: /* Bug 5504354- This grade step will be mapped to an additional person information
1774: detail item in Payslip. Grade step will be mapped to Action Information9
1775: and will be archived with action_information_category as ADDL EMPLOYEE DETAILS */
1776:
1777: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1778:
1779: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1780: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1781: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);

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

1775: and will be archived with action_information_category as ADDL EMPLOYEE DETAILS */
1776:
1777: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1778:
1779: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1780: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1781: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1782: hr_utility.trace('Value of l_step is '||l_step);
1783: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);

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

1776:
1777: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1778:
1779: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1780: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1781: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1782: hr_utility.trace('Value of l_step is '||l_step);
1783: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1784:

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

1777: hr_utility.set_location('Archiving ADDL EMPLOYEE DETAILS',30);
1778:
1779: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1780: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1781: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1782: hr_utility.trace('Value of l_step is '||l_step);
1783: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1784:
1785:

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

1778:
1779: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1780: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1781: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1782: hr_utility.trace('Value of l_step is '||l_step);
1783: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1784:
1785:
1786: pay_action_information_api.create_action_information (

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

1779: hr_utility.trace('Value of l_action_info_id is '||l_action_info_id);
1780: hr_utility.trace('Value of p_arc_assignment_action_id is '||p_arc_assignment_action_id);
1781: hr_utility.trace('Value of p_pre_effective_date is '||p_pre_effective_date);
1782: hr_utility.trace('Value of l_step is '||l_step);
1783: hr_utility.trace('Value of p_assignment_id is '||p_assignment_id);
1784:
1785:
1786: pay_action_information_api.create_action_information (
1787: p_action_information_id => l_action_info_id

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

1794: ,p_action_information_category => 'ADDL EMPLOYEE DETAILS'
1795: ,p_action_information9 => l_step
1796: );
1797:
1798: hr_utility.set_location('Leaving '|| l_procedure,1000);
1799: exception
1800: when others
1801: then
1802: hr_utility.set_location('Error in '||l_procedure,999999);

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

1798: hr_utility.set_location('Leaving '|| l_procedure,1000);
1799: exception
1800: when others
1801: then
1802: hr_utility.set_location('Error in '||l_procedure,999999);
1803: raise;
1804: END archive_employee_details;
1805:
1806: ----------------------------

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

1830: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1831:
1832: begin
1833: l_procedure := g_package||'archive_data_for_quickpay';
1834: hr_utility.set_location('Entering '||l_procedure,1);
1835:
1836: hr_utility.set_location('p_payroll_action_id......= '|| p_payroll_action_id, 5);
1837: hr_utility.set_location('p_effective_date.........= '|| to_char(p_effective_date,'DD-MON-YYYY'), 7);
1838:

Line 1836: hr_utility.set_location('p_payroll_action_id......= '|| p_payroll_action_id, 5);

1832: begin
1833: l_procedure := g_package||'archive_data_for_quickpay';
1834: hr_utility.set_location('Entering '||l_procedure,1);
1835:
1836: hr_utility.set_location('p_payroll_action_id......= '|| p_payroll_action_id, 5);
1837: hr_utility.set_location('p_effective_date.........= '|| to_char(p_effective_date,'DD-MON-YYYY'), 7);
1838:
1839: hr_utility.set_location('Getting Payroll ID', 10);
1840:

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

1833: l_procedure := g_package||'archive_data_for_quickpay';
1834: hr_utility.set_location('Entering '||l_procedure,1);
1835:
1836: hr_utility.set_location('p_payroll_action_id......= '|| p_payroll_action_id, 5);
1837: hr_utility.set_location('p_effective_date.........= '|| to_char(p_effective_date,'DD-MON-YYYY'), 7);
1838:
1839: hr_utility.set_location('Getting Payroll ID', 10);
1840:
1841: open csr_get_payroll_id(p_payroll_action_id);

Line 1839: hr_utility.set_location('Getting Payroll ID', 10);

1835:
1836: hr_utility.set_location('p_payroll_action_id......= '|| p_payroll_action_id, 5);
1837: hr_utility.set_location('p_effective_date.........= '|| to_char(p_effective_date,'DD-MON-YYYY'), 7);
1838:
1839: hr_utility.set_location('Getting Payroll ID', 10);
1840:
1841: open csr_get_payroll_id(p_payroll_action_id);
1842: fetch csr_get_payroll_id into l_payroll_id;
1843: close csr_get_payroll_id;

Line 1845: hr_utility.set_location('p_payroll_id......= '|| l_payroll_id, 15);

1841: open csr_get_payroll_id(p_payroll_action_id);
1842: fetch csr_get_payroll_id into l_payroll_id;
1843: close csr_get_payroll_id;
1844:
1845: hr_utility.set_location('p_payroll_id......= '|| l_payroll_id, 15);
1846: hr_utility.set_location('Archiving Employer''s Addr', 20);
1847:
1848: pay_emp_action_arch.arch_pay_action_level_data
1849: (p_payroll_action_id => p_payroll_action_id

Line 1846: hr_utility.set_location('Archiving Employer''s Addr', 20);

1842: fetch csr_get_payroll_id into l_payroll_id;
1843: close csr_get_payroll_id;
1844:
1845: hr_utility.set_location('p_payroll_id......= '|| l_payroll_id, 15);
1846: hr_utility.set_location('Archiving Employer''s Addr', 20);
1847:
1848: pay_emp_action_arch.arch_pay_action_level_data
1849: (p_payroll_action_id => p_payroll_action_id
1850: ,p_payroll_id => l_payroll_id

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

1850: ,p_payroll_id => l_payroll_id
1851: ,p_effective_date => p_effective_date);
1852:
1853:
1854: hr_utility.set_location('Leaving '|| l_procedure,1000);
1855: exception
1856: when others
1857: then
1858: hr_utility.set_location('Error in ' || l_procedure, 999999);

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

1854: hr_utility.set_location('Leaving '|| l_procedure,1000);
1855: exception
1856: when others
1857: then
1858: hr_utility.set_location('Error in ' || l_procedure, 999999);
1859: raise;
1860: END insert_quickpay_pa_info;
1861:
1862: ----------------------------

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

1899:
1900: begin
1901:
1902: l_procedure := g_package||'chk_pay_level_info_archived';
1903: hr_utility.set_location('Entering '||l_procedure,1);
1904:
1905: hr_utility.set_location('Fetching payroll_action_id',10);
1906:
1907: open csr_get_payroll_action_id(p_assignment_action_id);

Line 1905: hr_utility.set_location('Fetching payroll_action_id',10);

1901:
1902: l_procedure := g_package||'chk_pay_level_info_archived';
1903: hr_utility.set_location('Entering '||l_procedure,1);
1904:
1905: hr_utility.set_location('Fetching payroll_action_id',10);
1906:
1907: open csr_get_payroll_action_id(p_assignment_action_id);
1908: fetch csr_get_payroll_action_id into l_payroll_action_id;
1909: close csr_get_payroll_action_id;

Line 1911: hr_utility.set_location('Fetching csr_is_employer_addr_archived result',20);

1907: open csr_get_payroll_action_id(p_assignment_action_id);
1908: fetch csr_get_payroll_action_id into l_payroll_action_id;
1909: close csr_get_payroll_action_id;
1910:
1911: hr_utility.set_location('Fetching csr_is_employer_addr_archived result',20);
1912: open csr_is_employer_addr_archived(l_payroll_action_id, p_effective_date);
1913: fetch csr_is_employer_addr_archived into l_is_employer_addr_archived;
1914: close csr_is_employer_addr_archived;
1915:

Line 1916: hr_utility.set_location('Checking if employer''s derailes is archived',30);

1912: open csr_is_employer_addr_archived(l_payroll_action_id, p_effective_date);
1913: fetch csr_is_employer_addr_archived into l_is_employer_addr_archived;
1914: close csr_is_employer_addr_archived;
1915:
1916: hr_utility.set_location('Checking if employer''s derailes is archived',30);
1917: if (l_is_employer_addr_archived = 0) then
1918: hr_utility.set_location('Payroll level data is not archived',40);
1919: insert_quickpay_pa_info
1920: (p_payroll_action_id => l_payroll_action_id

Line 1918: hr_utility.set_location('Payroll level data is not archived',40);

1914: close csr_is_employer_addr_archived;
1915:
1916: hr_utility.set_location('Checking if employer''s derailes is archived',30);
1917: if (l_is_employer_addr_archived = 0) then
1918: hr_utility.set_location('Payroll level data is not archived',40);
1919: insert_quickpay_pa_info
1920: (p_payroll_action_id => l_payroll_action_id
1921: ,p_effective_date => p_effective_date);
1922: end if;

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

1920: (p_payroll_action_id => l_payroll_action_id
1921: ,p_effective_date => p_effective_date);
1922: end if;
1923:
1924: hr_utility.set_location('Leaving '||l_procedure,1000);
1925:
1926: exception
1927: when others
1928: then

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

1925:
1926: exception
1927: when others
1928: then
1929: hr_utility.set_location('Error in ' || l_procedure, 999999);
1930: raise;
1931: end archive_quickpay_pa_info;
1932:
1933: ----------------------------

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

1988: l_procedure varchar2(200);
1989:
1990: begin
1991: l_procedure := g_package||'archive_code';
1992: hr_utility.set_location('Entering '||l_procedure,1);
1993:
1994: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1995: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),15);
1996: /*Bug#3363519 */

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

1990: begin
1991: l_procedure := g_package||'archive_code';
1992: hr_utility.set_location('Entering '||l_procedure,1);
1993:
1994: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1995: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),15);
1996: /*Bug#3363519 */
1997: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id,
1998: p_effective_date);

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

1991: l_procedure := g_package||'archive_code';
1992: hr_utility.set_location('Entering '||l_procedure,1);
1993:
1994: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1995: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),15);
1996: /*Bug#3363519 */
1997: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id,
1998: p_effective_date);
1999:

Line 2000: hr_utility.set_location(l_procedure,20);

1996: /*Bug#3363519 */
1997: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id,
1998: p_effective_date);
1999:
2000: hr_utility.set_location(l_procedure,20);
2001:
2002: /* Added for Bug #15914996. If normal payroll run, or has been archived
2003: * before, this will not archive anything. */
2004: archive_quickpay_pa_info(p_assignment_action_id, p_effective_date);

Line 2006: hr_utility.set_location(l_procedure,30);

2002: /* Added for Bug #15914996. If normal payroll run, or has been archived
2003: * before, this will not archive anything. */
2004: archive_quickpay_pa_info(p_assignment_action_id, p_effective_date);
2005:
2006: hr_utility.set_location(l_procedure,30);
2007:
2008: -- For each payslip to be generated
2009: for payslip_rec in get_payslip_aa(p_assignment_action_id) loop
2010: --

Line 2011: hr_utility.set_location(l_procedure,40);

2007:
2008: -- For each payslip to be generated
2009: for payslip_rec in get_payslip_aa(p_assignment_action_id) loop
2010: --
2011: hr_utility.set_location(l_procedure,40);
2012:
2013: archive_employee_details
2014: (p_assignment_id => payslip_rec.assignment_id
2015: ,p_arc_assignment_action_id => payslip_rec.chld_arc_assignment_action_id -- archive run assignment action

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

2022: ,p_period_end_date => payslip_rec.period_end_date -- end date from per_time_periods
2023: ,p_regular_payment_date => payslip_rec.regular_payment_date -- Regular payment date from per_time_periods /* 5681819 */
2024: );
2025:
2026: hr_utility.set_location(l_procedure,50);
2027: --
2028: end loop;
2029:
2030: hr_utility.set_location('Leaving '||l_procedure,1000);

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

2026: hr_utility.set_location(l_procedure,50);
2027: --
2028: end loop;
2029:
2030: hr_utility.set_location('Leaving '||l_procedure,1000);
2031:
2032: exception
2033: when others then
2034: hr_utility.set_location('Error in '||l_procedure,999999);

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

2030: hr_utility.set_location('Leaving '||l_procedure,1000);
2031:
2032: exception
2033: when others then
2034: hr_utility.set_location('Error in '||l_procedure,999999);
2035: raise;
2036: end archive_code;
2037:
2038: end pay_au_payslip_archive;