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

Line 208: g_debug :=hr_utility.debug_enabled ;

204: l_procedure varchar2(200) ;
205:
206: begin
207:
208: g_debug :=hr_utility.debug_enabled ;
209:
210: if g_debug then
211: l_procedure := g_package||'range_code';
212: hr_utility.set_location('Entering '||l_procedure,1);

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

208: g_debug :=hr_utility.debug_enabled ;
209:
210: if g_debug then
211: l_procedure := g_package||'range_code';
212: hr_utility.set_location('Entering '||l_procedure,1);
213: end if ;
214:
215: -- Archive the payroll action level data and EIT defintions.
216: -- sql string to SELECT a range of assignments eligible for archival.

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

221: ' and p.business_group_id = pa.business_group_id' ||
222: ' order by p.person_id';
223:
224: if g_debug then
225: hr_utility.set_location('Leaving '||l_procedure,1000);
226: end if;
227:
228: end range_code;
229:

Line 466: g_debug :=hr_utility.debug_enabled ;

462: begin
463:
464: idx :=1;
465:
466: g_debug :=hr_utility.debug_enabled ;
467: if g_debug then
468: l_procedure := g_package||'initialization_code';
469: hr_utility.set_location('Entering '||l_procedure,1);
470: end if;

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

465:
466: g_debug :=hr_utility.debug_enabled ;
467: if g_debug then
468: l_procedure := g_package||'initialization_code';
469: hr_utility.set_location('Entering '||l_procedure,1);
470: end if;
471:
472: g_balance_value_tab.delete;
473:

Line 490: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

486: g_tax_unit_id := g_parameters.legal_employer;
487:
488: if g_debug
489: then
490: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);

Line 491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);

487:
488: if g_debug
489: then
490: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);

Line 492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);

488: if g_debug
489: then
490: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);

Line 493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

489: then
490: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);

Line 494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);

490: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);

Line 495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);

491: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

Line 496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);

492: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/

Line 497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);

493: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
501: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/

Line 498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);

494: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
501: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
502: end if;

Line 499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

495: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
501: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
502: end if;
503:

Line 500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /Bug 4142159/

496: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
501: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
502: end if;
503:
504:

Line 501: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /Bug 3891577/

497: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
498: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
499: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
500: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
501: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
502: end if;
503:
504:
505: If g_fbt_defined_balance_id is null OR g_fbt_defined_balance_id =0 Then

Line 520: hr_utility.trace('Defined Balance ids for YTD dimension');

516: g_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
517: END LOOP;
518:
519: IF g_debug THEN
520: hr_utility.trace('Defined Balance ids for YTD dimension');
521: hr_utility.trace('-------------------------------------');
522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);

Line 521: hr_utility.trace('-------------------------------------');

517: END LOOP;
518:
519: IF g_debug THEN
520: hr_utility.trace('Defined Balance ids for YTD dimension');
521: hr_utility.trace('-------------------------------------');
522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);

Line 522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);

518:
519: IF g_debug THEN
520: hr_utility.trace('Defined Balance ids for YTD dimension');
521: hr_utility.trace('-------------------------------------');
522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);

Line 523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);

519: IF g_debug THEN
520: hr_utility.trace('Defined Balance ids for YTD dimension');
521: hr_utility.trace('-------------------------------------');
522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);

Line 524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);

520: hr_utility.trace('Defined Balance ids for YTD dimension');
521: hr_utility.trace('-------------------------------------');
522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);

Line 525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);

521: hr_utility.trace('-------------------------------------');
522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);

Line 526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);

522: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);

Line 527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);

523: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);

Line 528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);

524: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);

Line 529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);

525: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);

Line 530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);

526: hr_utility.trace('Involuntary Deductions ===>' || g_balance_value_tab(4).defined_balance_id);
527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);

Line 531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);

527: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);

Line 532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);

528: hr_utility.trace('Termination Deductions ===>' || g_balance_value_tab(6).defined_balance_id);
529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);

Line 533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);

529: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);

Line 534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);

530: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);

Line 535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);

531: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);

Line 536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);

532: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);

Line 537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);

533: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */

Line 538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);

534: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);

Line 539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);

535: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */

Line 540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);

536: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */

Line 541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */

537: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);

Line 542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);

538: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);

Line 543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */

539: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/

Line 544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /start bug 14703826 /

540: hr_utility.trace('Leave Payments Marginal ===>' || g_balance_value_tab(18).defined_balance_id);
541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855

Line 545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);

541: hr_utility.trace('Reportable Employer Super Contri ===>' || g_balance_value_tab(19).defined_balance_id); /* Bug 8587013 */
542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);

Line 546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);

542: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855

Line 547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /end bug 14703826/

543: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_balance_value_tab(22).defined_balance_id); /* Bug 8587013 */
544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);

Line 548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855

544: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_balance_value_tab(23).defined_balance_id); /*start bug 14703826 */
545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);

Line 549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);

545: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_balance_value_tab(24).defined_balance_id);
546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);

Line 550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855

546: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_balance_value_tab(25).defined_balance_id);
547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);

Line 551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);

547: hr_utility.trace('ETP Taxable Payments Non Excluded ===>' || g_balance_value_tab(26).defined_balance_id); /*end bug 14703826*/
548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);

Line 552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);

548: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_balance_value_tab(31).defined_balance_id); -- start 8711855
549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);
556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);

Line 553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);

549: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_balance_value_tab(32).defined_balance_id);
550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);
556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);
557: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_balance_value_tab(40).defined_balance_id);

Line 554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);

550: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_balance_value_tab(33).defined_balance_id); -- end 8711855
551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);
556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);
557: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_balance_value_tab(40).defined_balance_id);
558: end if;

Line 555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);

551: hr_utility.trace('Lump Sum C Deductions ===>' || g_balance_value_tab(34).defined_balance_id);
552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);
556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);
557: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_balance_value_tab(40).defined_balance_id);
558: end if;
559:

Line 556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);

552: hr_utility.trace('Foreign Leave Payments ===>' || g_balance_value_tab(35).defined_balance_id);
553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);
556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);
557: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_balance_value_tab(40).defined_balance_id);
558: end if;
559:
560:

Line 557: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_balance_value_tab(40).defined_balance_id);

553: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_balance_value_tab(36).defined_balance_id);
554: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_balance_value_tab(37).defined_balance_id);
555: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_balance_value_tab(38).defined_balance_id);
556: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_balance_value_tab(39).defined_balance_id);
557: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_balance_value_tab(40).defined_balance_id);
558: end if;
559:
560:
561: p_lump_sum_E_ptd_tab.delete;

Line 567: hr_utility.set_location('Defined Balance Ids for Lump Sume E PTD are:' , 15);

563: p_lump_sum_E_ptd_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
564: end loop;
565:
566: if g_debug then
567: hr_utility.set_location('Defined Balance Ids for Lump Sume E PTD are:' , 15);
568: hr_utility.trace('--------------------------------------------');
569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);

Line 568: hr_utility.trace('--------------------------------------------');

564: end loop;
565:
566: if g_debug then
567: hr_utility.set_location('Defined Balance Ids for Lump Sume E PTD are:' , 15);
568: hr_utility.trace('--------------------------------------------');
569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);
572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);

Line 569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);

565:
566: if g_debug then
567: hr_utility.set_location('Defined Balance Ids for Lump Sume E PTD are:' , 15);
568: hr_utility.trace('--------------------------------------------');
569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);
572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);
573: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(5).defined_balance_id);

Line 570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);

566: if g_debug then
567: hr_utility.set_location('Defined Balance Ids for Lump Sume E PTD are:' , 15);
568: hr_utility.trace('--------------------------------------------');
569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);
572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);
573: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(5).defined_balance_id);
574: end if;

Line 571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);

567: hr_utility.set_location('Defined Balance Ids for Lump Sume E PTD are:' , 15);
568: hr_utility.trace('--------------------------------------------');
569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);
572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);
573: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(5).defined_balance_id);
574: end if;
575:

Line 572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);

568: hr_utility.trace('--------------------------------------------');
569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);
572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);
573: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(5).defined_balance_id);
574: end if;
575:
576: /* Changes for 9147438 starts */

Line 573: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(5).defined_balance_id);

569: hr_utility.trace('Lump Sum E Payments ===>' || p_lump_sum_E_ptd_tab(1).defined_balance_id);
570: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(2).defined_balance_id);
571: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(3).defined_balance_id);
572: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(4).defined_balance_id);
573: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_lump_sum_E_ptd_tab(5).defined_balance_id);
574: end if;
575:
576: /* Changes for 9147438 starts */
577:

Line 590: hr_utility.trace('Balance Type IDs for FW Balances ');

586: p_fw_balance_type_tab(csr_rec.sort_index).balance_type_id := csr_rec.balance_type_id;
587: end loop;
588:
589: IF g_debug THEN
590: hr_utility.trace('Balance Type IDs for FW Balances ');
591: hr_utility.trace('-------------------------------------');
592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);

Line 591: hr_utility.trace('-------------------------------------');

587: end loop;
588:
589: IF g_debug THEN
590: hr_utility.trace('Balance Type IDs for FW Balances ');
591: hr_utility.trace('-------------------------------------');
592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);

Line 592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);

588:
589: IF g_debug THEN
590: hr_utility.trace('Balance Type IDs for FW Balances ');
591: hr_utility.trace('-------------------------------------');
592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);

Line 593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);

589: IF g_debug THEN
590: hr_utility.trace('Balance Type IDs for FW Balances ');
591: hr_utility.trace('-------------------------------------');
592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);

Line 594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);

590: hr_utility.trace('Balance Type IDs for FW Balances ');
591: hr_utility.trace('-------------------------------------');
592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);

Line 595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);

591: hr_utility.trace('-------------------------------------');
592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);

Line 596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);

592: hr_utility.trace('FW Frienge Benefits ===>' || p_fw_fbt_bal_type_tab(1).balance_type_id);
593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);

Line 597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);

593: hr_utility.trace('Earnings_Total ===>' || p_fw_balance_type_tab(1).balance_type_id);
594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);

Line 598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);

594: hr_utility.trace('Leave Payments Marginal ===>' || p_fw_balance_type_tab(2).balance_type_id);
595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);

Line 599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);

595: hr_utility.trace('Workplace Giving Deductions ===>' || p_fw_balance_type_tab(3).balance_type_id);
596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);

Line 600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);

596: hr_utility.trace('Lump Sum E Payments ===>' || p_fw_balance_type_tab(4).balance_type_id);
597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);

Line 601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);

597: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || p_fw_balance_type_tab(5).balance_type_id);
598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);

Line 602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);

598: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || p_fw_balance_type_tab(6).balance_type_id);
599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);

Line 603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);

599: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || p_fw_balance_type_tab(7).balance_type_id);
600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);

Line 604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);

600: hr_utility.trace('Total_Tax_Deductions ===>' || p_fw_balance_type_tab(8).balance_type_id);
601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);

Line 605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);

601: hr_utility.trace('Termination Deductions ===>' || p_fw_balance_type_tab(9).balance_type_id);
602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);

Line 606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);

602: hr_utility.trace('Lump Sum C Deductions ===>' || p_fw_balance_type_tab(10).balance_type_id);
603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);

Line 607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);

603: hr_utility.trace('Foreign Tax Deductions ===>' || p_fw_balance_type_tab(11).balance_type_id);
604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);

Line 608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);

604: hr_utility.trace('Lump Sum A Payments ===>' || p_fw_balance_type_tab(12).balance_type_id);
605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);

Line 609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);

605: hr_utility.trace('Lump Sum D Payments ===>' || p_fw_balance_type_tab(13).balance_type_id);
606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);

Line 610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);

606: hr_utility.trace('Reportable Employer Superannuation Contributions ===>' || p_fw_balance_type_tab(14).balance_type_id);
607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);

Line 611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);

607: hr_utility.trace('Union Fees ===>' || p_fw_balance_type_tab(15).balance_type_id);
608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);

Line 612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);

608: hr_utility.trace('CDEP ===>' || p_fw_balance_type_tab(16).balance_type_id);
609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);

Line 613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);

609: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(18).balance_type_id);
610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);

Line 614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);

610: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amoun===>' || p_fw_balance_type_tab(19).balance_type_id);
611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);

Line 615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);

611: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(20).balance_type_id);
612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);

Line 616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);

612: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || p_fw_balance_type_tab(21).balance_type_id);
613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);

Line 617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);

613: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || p_fw_balance_type_tab(22).balance_type_id);
614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);
621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);

Line 618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);

614: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amoun===>' || p_fw_balance_type_tab(23).balance_type_id);
615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);
621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);
622: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || p_fw_balance_type_tab(31).balance_type_id);

Line 619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);

615: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || p_fw_balance_type_tab(24).balance_type_id);
616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);
621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);
622: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || p_fw_balance_type_tab(31).balance_type_id);
623: end if;

Line 620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);

616: hr_utility.trace('Retro Tax GT12 Amount ===>' || p_fw_balance_type_tab(25).balance_type_id);
617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);
621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);
622: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || p_fw_balance_type_tab(31).balance_type_id);
623: end if;
624:

Line 621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);

617: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || p_fw_balance_type_tab(26).balance_type_id);
618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);
621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);
622: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || p_fw_balance_type_tab(31).balance_type_id);
623: end if;
624:
625: /* Changes for 9147438 end */

Line 622: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || p_fw_balance_type_tab(31).balance_type_id);

618: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || p_fw_balance_type_tab(27).balance_type_id);
619: hr_utility.trace('Foreign Leave Payments ===>' || p_fw_balance_type_tab(28).balance_type_id);
620: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || p_fw_balance_type_tab(29).balance_type_id);
621: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || p_fw_balance_type_tab(30).balance_type_id);
622: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || p_fw_balance_type_tab(31).balance_type_id);
623: end if;
624:
625: /* Changes for 9147438 end */
626:

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

629: fetch get_balance_attribute into g_attribute_id;
630: close get_balance_attribute;
631:
632: if g_debug then
633: hr_utility.set_location('Leaving '||l_procedure,1000);
634: end if;
635:
636: exception
637: when others then

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

634: end if;
635:
636: exception
637: when others then
638: hr_utility.set_location('Error in '||l_procedure,999999);
639: raise;
640: end initialization_code;
641:
642: /*

Line 681: g_debug := hr_utility.debug_enabled;

677: l_report_type VARCHAR2(50);
678:
679: BEGIN
680:
681: g_debug := hr_utility.debug_enabled;
682:
683: IF g_debug
684: THEN
685: hr_utility.set_location('range_person_on',10);

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

681: g_debug := hr_utility.debug_enabled;
682:
683: IF g_debug
684: THEN
685: hr_utility.set_location('range_person_on',10);
686: END IF;
687:
688: BEGIN
689:

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

692: close csr_action_parameter;
693:
694: IF g_debug
695: THEN
696: hr_utility.set_location('range_person_on',20);
697: END IF;
698:
699: IF p_report_mode = 'S'
700: THEN

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

708: fetch csr_range_format_param into l_report_param_val;
709: close csr_range_format_param;
710: IF g_debug
711: THEN
712: hr_utility.set_location('range_person_on',30);
713: END IF;
714: EXCEPTION WHEN NO_DATA_FOUND THEN
715: l_return := FALSE;
716: END;

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

716: END;
717: --
718: IF g_debug
719: THEN
720: hr_utility.set_location('range_person_on',40);
721: END IF;
722:
723: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
724: l_return := TRUE;

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

724: l_return := TRUE;
725:
726: IF g_debug
727: THEN
728: hr_utility.trace('Range Person = True');
729: END IF;
730: ELSE
731: l_return := FALSE;
732: END IF;

Line 1066: g_debug :=hr_utility.debug_enabled;

1062: l_lst_fbt_yr_start date;
1063:
1064: begin
1065:
1066: g_debug :=hr_utility.debug_enabled;
1067: if g_debug
1068: then
1069: l_procedure := '.assignment_action_code';
1070: hr_utility.set_location('Entering '||l_procedure,1);

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

1066: g_debug :=hr_utility.debug_enabled;
1067: if g_debug
1068: then
1069: l_procedure := '.assignment_action_code';
1070: hr_utility.set_location('Entering '||l_procedure,1);
1071: end if;
1072:
1073: g_arc_payroll_action_id := p_payroll_action_id;
1074:

Line 1103: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

1099: end if;
1100:
1101: if g_debug
1102: then
1103: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1104: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);

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

1100:
1101: if g_debug
1102: then
1103: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1104: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

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

1101: if g_debug
1102: then
1103: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1104: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);

Line 1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);

1102: then
1103: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1104: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);

Line 1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);

1103: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1104: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);

Line 1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

1104: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);

Line 1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);

1105: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);

Line 1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);

1106: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

Line 1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);

1107: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/

Line 1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);

1108: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);

Line 1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);

1109: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);

Line 1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

1110: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
1118: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/

Line 1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /Bug 4142159/

1111: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
1118: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
1119: end if;

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

1112: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
1118: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
1119: end if;
1120:

Line 1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);

1113: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
1118: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
1119: end if;
1120:
1121: /* SET FBT Defined_balance ID */

Line 1118: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /Bug 3891577/

1114: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1115: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
1116: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
1117: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
1118: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
1119: end if;
1120:
1121: /* SET FBT Defined_balance ID */
1122: If g_fbt_defined_balance_id is null OR g_fbt_defined_balance_id =0 Then

Line 1153: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);

1149: fetch csr_next_action_id into l_next_assignment_action_id;
1150: close csr_next_action_id;
1151:
1152: IF g_debug THEN
1153: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
1154: END if;
1155:
1156: hr_nonrun_asact.insact(l_next_assignment_action_id,
1157: csr_rec.assignment_id,

Line 1194: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);

1190: fetch csr_next_action_id into l_next_assignment_action_id;
1191: close csr_next_action_id;
1192:
1193: IF g_debug THEN
1194: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
1195: END if;
1196:
1197: hr_nonrun_asact.insact(l_next_assignment_action_id,
1198: csr_rec.assignment_id,

Line 1230: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);

1226: fetch csr_next_action_id into l_next_assignment_action_id;
1227: close csr_next_action_id;
1228:
1229: IF g_debug THEN
1230: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
1231: END if;
1232:
1233: hr_nonrun_asact.insact(l_next_assignment_action_id,
1234: csr_rec.assignment_id,

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

1240: END IF; /* End Range Person Check */
1241: END IF;
1242:
1243: if g_debug then
1244: hr_utility.set_location('Leaving '||l_procedure,1000);
1245: end if;
1246: exception
1247: when others then
1248: hr_utility.set_location('Error in '||l_procedure,999999);

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

1244: hr_utility.set_location('Leaving '||l_procedure,1000);
1245: end if;
1246: exception
1247: when others then
1248: hr_utility.set_location('Error in '||l_procedure,999999);
1249: raise;
1250: end assignment_action_code;
1251:
1252: --------------------------------------------------------------------+

Line 1490: g_debug :=hr_utility.debug_enabled ;

1486: /* End bug 10331262 */
1487:
1488: begin
1489:
1490: g_debug :=hr_utility.debug_enabled ;
1491:
1492: if g_debug then
1493: l_procedure := g_package||'archive_code';
1494: hr_utility.set_location('Entering '||l_procedure,300);

Line 1494: hr_utility.set_location('Entering '||l_procedure,300);

1490: g_debug :=hr_utility.debug_enabled ;
1491:
1492: if g_debug then
1493: l_procedure := g_package||'archive_code';
1494: hr_utility.set_location('Entering '||l_procedure,300);
1495: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1496: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1497: end if;
1498:

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

1491:
1492: if g_debug then
1493: l_procedure := g_package||'archive_code';
1494: hr_utility.set_location('Entering '||l_procedure,300);
1495: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1496: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1497: end if;
1498:
1499: if (g_parameters.lst_year_term ='Y' or g_parameters.lst_year_term is NULL )

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

1492: if g_debug then
1493: l_procedure := g_package||'archive_code';
1494: hr_utility.set_location('Entering '||l_procedure,300);
1495: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1496: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1497: end if;
1498:
1499: if (g_parameters.lst_year_term ='Y' or g_parameters.lst_year_term is NULL )
1500: then

Line 1517: hr_utility.set_location('No Employee details found!!',3002);

1513: fetch c_employee_details into l_employee_details;
1514: if c_employee_details%notfound
1515: then
1516: if g_debug then
1517: hr_utility.set_location('No Employee details found!!',3002);
1518: end if;
1519: end if;
1520: close c_employee_details;
1521:

Line 1636: hr_utility.set_location('Assignment_id' ||l_employee_details.assignment_id,300);

1632: g_retro_fw_tax :=0;
1633: /* end bug 9950136*/
1634:
1635: if g_debug then
1636: hr_utility.set_location('Assignment_id' ||l_employee_details.assignment_id,300);
1637: end if;
1638:
1639: open get_max_action(l_employee_details.assignment_id,g_start_date,g_end_date,g_tax_unit_id);
1640: fetch get_max_action into l_assignment_action_id,l_action_sequence;

Line 1650: hr_utility.set_location('Assignment_ACTION_id ' ||l_assignment_action_id,300);

1646: end if;
1647: close get_max_action;
1648:
1649: if g_debug then
1650: hr_utility.set_location('Assignment_ACTION_id ' ||l_assignment_action_id,300);
1651: end if;
1652:
1653: /* Changes for 9147438 start */
1654: if (to_number(to_char(g_start_date,'YYYY')) >= 2010) then

Line 1659: hr_utility.set_location('FW EMP check .. g_fw_check for assignment_id '||l_employee_details.assignment_id||' is '||g_fw_check, 2);

1655:
1656: g_fw_check := pay_au_foreign_workers.check_foreign_worker(l_employee_details.assignment_id, g_tax_unit_id, g_start_date, g_end_date);
1657:
1658: if g_debug then
1659: hr_utility.set_location('FW EMP check .. g_fw_check for assignment_id '||l_employee_details.assignment_id||' is '||g_fw_check, 2);
1660: end if;
1661:
1662: end if;
1663: /* Changes for 9147438 end */

Line 1700: hr_utility.set_location('Value of global variable g_fw_fbt_term_check'||' '||g_fw_fbt_term_check,150);

1696:
1697: end if;
1698:
1699: if g_debug then
1700: hr_utility.set_location('Value of global variable g_fw_fbt_term_check'||' '||g_fw_fbt_term_check,150);
1701: hr_utility.set_location('Value of global variable g_fw_gross_type '||' '||g_fw_gross_type,170);
1702: end if;
1703:
1704: /* Changes for 9147438 end */

Line 1701: hr_utility.set_location('Value of global variable g_fw_gross_type '||' '||g_fw_gross_type,170);

1697: end if;
1698:
1699: if g_debug then
1700: hr_utility.set_location('Value of global variable g_fw_fbt_term_check'||' '||g_fw_fbt_term_check,150);
1701: hr_utility.set_location('Value of global variable g_fw_gross_type '||' '||g_fw_gross_type,170);
1702: end if;
1703:
1704: /* Changes for 9147438 end */
1705:

Line 1708: hr_utility.set_location('FBT Employee Assignment ID======.....'||l_employee_details.assignment_id,300);

1704: /* Changes for 9147438 end */
1705:
1706: if g_debug
1707: then
1708: hr_utility.set_location('FBT Employee Assignment ID======.....'||l_employee_details.assignment_id,300);
1709: end if;
1710:
1711: get_fbt_balance(p_assignment_id => l_employee_details.assignment_id
1712: ,p_start_date => add_months(g_start_date,-3)

Line 1719: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,300);

1715: );
1716:
1717: if g_debug
1718: then
1719: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,300);
1720: end if;
1721:
1722: g_result_table.delete;
1723: FOR i in 1..22

Line 1757: hr_utility.set_location('Value of global variable g_fw_fbt_check'||' '||g_fw_fbt_check,250);

1753:
1754: end if;
1755:
1756: if g_debug then
1757: hr_utility.set_location('Value of global variable g_fw_fbt_check'||' '||g_fw_fbt_check,250);
1758: end if;
1759:
1760: /* Changes for 9147438 end */
1761:

Line 1782: hr_utility.set_location('Assingment Action ID not found for Run in Year!!',300);

1778: p_output_table=>g_result_table);
1779:
1780: else
1781: if g_debug then
1782: hr_utility.set_location('Assingment Action ID not found for Run in Year!!',300);
1783: end if;
1784: end if;
1785:
1786: if g_debug

Line 1788: hr_utility.trace('Balance values for YTD dimension');

1784: end if;
1785:
1786: if g_debug
1787: then
1788: hr_utility.trace('Balance values for YTD dimension');
1789: hr_utility.trace('-------------------------------------');
1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);

Line 1789: hr_utility.trace('-------------------------------------');

1785:
1786: if g_debug
1787: then
1788: hr_utility.trace('Balance values for YTD dimension');
1789: hr_utility.trace('-------------------------------------');
1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);

Line 1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);

1786: if g_debug
1787: then
1788: hr_utility.trace('Balance values for YTD dimension');
1789: hr_utility.trace('-------------------------------------');
1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);

Line 1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);

1787: then
1788: hr_utility.trace('Balance values for YTD dimension');
1789: hr_utility.trace('-------------------------------------');
1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);

Line 1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);

1788: hr_utility.trace('Balance values for YTD dimension');
1789: hr_utility.trace('-------------------------------------');
1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);

Line 1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);

1789: hr_utility.trace('-------------------------------------');
1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);

Line 1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);

1790: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);

Line 1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);

1791: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);

Line 1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);

1792: hr_utility.trace('Workplace Giving Deductions ===>' || g_result_table(21).balance_value);
1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);

Line 1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);

1793: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);

Line 1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);

1794: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);

Line 1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);

1795: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);

Line 1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);

1796: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);

Line 1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);

1797: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);

Line 1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);

1798: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);

Line 1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);

1799: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);

Line 1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);

1800: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);

Line 1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);

1801: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);

Line 1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);

1802: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */

Line 1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);

1803: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);

Line 1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);

1804: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */

Line 1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);

1805: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/

Line 1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */

1806: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);

Line 1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);

1807: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);

Line 1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */

1808: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/

Line 1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /start bug 14703826/

1809: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855

Line 1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);

1810: hr_utility.trace('Reportable Employer Superannuation Contributions ===>'||g_result_table(19).balance_value); /* Bug 8587013 */
1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);

Line 1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);

1811: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855

Line 1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /end bug 14703826/

1812: hr_utility.trace('Exempt Foreign Employment Income ===>'||g_result_table(22).balance_value); /* Bug 8587013 */
1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);

Line 1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855

1813: hr_utility.trace('ETP Tax Free Payments Excluded ===>' || g_result_table(23).balance_value); /*start bug 14703826*/
1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);

Line 1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);

1814: hr_utility.trace('ETP Tax Free Payments Non Excluded ===>' || g_result_table(24).balance_value);
1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);

Line 1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855

1815: hr_utility.trace('ETP Taxable Payments Excluded ===>' || g_result_table(25).balance_value);
1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);

Line 1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);

1816: hr_utility.trace('ETP Taxable Payments NOn Excluded ===>' || g_result_table(26).balance_value); /*end bug 14703826*/
1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);

Line 1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);

1817: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amount ===>' || g_result_table(31).balance_value); -- start 8711855
1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);
1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);

Line 1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);

1818: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_result_table(32).balance_value);
1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);
1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);
1826: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_result_table(40).balance_value);

Line 1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);

1819: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_result_table(33).balance_value); -- end 8711855
1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);
1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);
1826: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_result_table(40).balance_value);
1827: end if;

Line 1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);

1820: hr_utility.trace('Lump Sum C Deductions ===>' || g_result_table(34).balance_value);
1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);
1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);
1826: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_result_table(40).balance_value);
1827: end if;
1828:

Line 1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);

1821: hr_utility.trace('Foreign Leave Payments ===>' || g_result_table(35).balance_value);
1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);
1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);
1826: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_result_table(40).balance_value);
1827: end if;
1828:
1829: g_net_balance := g_net_balance + (g_result_table(1).balance_value + g_result_table(21).balance_value + g_result_table(18).balance_value )+

Line 1826: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_result_table(40).balance_value);

1822: hr_utility.trace('Foreign Leave Payments Marginal ===>' || g_result_table(36).balance_value);
1823: hr_utility.trace('Foreign Lump Sum A Payments ===>' || g_result_table(37).balance_value);
1824: hr_utility.trace('Foreign Leave Component Deduction ===>' || g_result_table(38).balance_value);
1825: hr_utility.trace('Foreign Lump Sum A Deduction ===>' || g_result_table(39).balance_value);
1826: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_result_table(40).balance_value);
1827: end if;
1828:
1829: g_net_balance := g_net_balance + (g_result_table(1).balance_value + g_result_table(21).balance_value + g_result_table(18).balance_value )+
1830: (g_result_table(8).balance_value + g_result_table(6).balance_value - g_result_table(34).balance_value) +

Line 1868: hr_utility.set_location('t_fw_gross_type.count '||t_fw_gross_type.count,2);

1864: g_fw_gross_type := t_fw_gross_type(1);
1865: end if;
1866:
1867: if g_debug then
1868: hr_utility.set_location('t_fw_gross_type.count '||t_fw_gross_type.count,2);
1869: hr_utility.set_location('g_fw_gross_type '||g_fw_gross_type,3);
1870: end if;
1871:
1872: For i_idx in t_fw_gross_type.first .. t_fw_gross_type.last loop

Line 1869: hr_utility.set_location('g_fw_gross_type '||g_fw_gross_type,3);

1865: end if;
1866:
1867: if g_debug then
1868: hr_utility.set_location('t_fw_gross_type.count '||t_fw_gross_type.count,2);
1869: hr_utility.set_location('g_fw_gross_type '||g_fw_gross_type,3);
1870: end if;
1871:
1872: For i_idx in t_fw_gross_type.first .. t_fw_gross_type.last loop
1873:

Line 1875: hr_utility.set_location('FW Gross Type : ' ||t_fw_gross_type(i_idx),10);

1871:
1872: For i_idx in t_fw_gross_type.first .. t_fw_gross_type.last loop
1873:
1874: if g_debug then
1875: hr_utility.set_location('FW Gross Type : ' ||t_fw_gross_type(i_idx),10);
1876: end if;
1877:
1878: g_fw_result_table.delete;
1879: IF t_fw_gross_type(i_idx) = 'F' THEN

Line 1900: hr_utility.trace('FW Balance Values are ');

1896: g_fw_result_table) ;
1897: END IF;
1898:
1899: IF g_debug THEN
1900: hr_utility.trace('FW Balance Values are ');
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);

Line 1901: hr_utility.trace('-------------------------------------');

1897: END IF;
1898:
1899: IF g_debug THEN
1900: hr_utility.trace('FW Balance Values are ');
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);

Line 1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);

1898:
1899: IF g_debug THEN
1900: hr_utility.trace('FW Balance Values are ');
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);

Line 1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);

1899: IF g_debug THEN
1900: hr_utility.trace('FW Balance Values are ');
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);

Line 1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);

1900: hr_utility.trace('FW Balance Values are ');
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);

Line 1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);

1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);

Line 1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);

1902: hr_utility.trace('Earnings_Total ===>' || g_fw_result_table(1).balance_value);
1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);

Line 1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);

1903: hr_utility.trace('Leave Payments Marginal ===>' || g_fw_result_table(2).balance_value);
1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);

Line 1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);

1904: hr_utility.trace('Workplace Giving Deductions ===>' || g_fw_result_table(3).balance_value);
1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);

Line 1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);

1905: hr_utility.trace('Lump Sum E Payments ===>' || g_fw_result_table(4).balance_value);
1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);

Line 1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);

1906: hr_utility.trace('Retro Earnings Leave Loading GT 12 Mths Amoun===>' || g_fw_result_table(5).balance_value);
1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);

Line 1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);

1907: hr_utility.trace('Retro Earnings Spread GT 12 Mths Amount ===>' || g_fw_result_table(6).balance_value);
1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);

Line 1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);

1908: hr_utility.trace('Retro Pre Tax GT 12 Mths Amount ===>' || g_fw_result_table(7).balance_value);
1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);

Line 1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);

1909: hr_utility.trace('Total_Tax_Deductions ===>' || g_fw_result_table(8).balance_value);
1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);

Line 1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);

1910: hr_utility.trace('Termination Deductions ===>' || g_fw_result_table(9).balance_value);
1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);

Line 1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);

1911: hr_utility.trace('Lump Sum C Deductions ===>' || g_fw_result_table(10).balance_value);
1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);

Line 1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);

1912: hr_utility.trace('Foreign Tax Deductions ===>' || g_fw_result_table(11).balance_value);
1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);

Line 1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);

1913: hr_utility.trace('Lump Sum A Payments ===>' || g_fw_result_table(12).balance_value);
1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);

Line 1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);

1914: hr_utility.trace('Lump Sum D Payments ===>' || g_fw_result_table(13).balance_value);
1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);

Line 1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);

1915: hr_utility.trace('Reportable Employer Superannuation Contrib ===>' || g_fw_result_table(14).balance_value);
1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);

Line 1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);

1916: hr_utility.trace('Union Fees ===>' || g_fw_result_table(15).balance_value);
1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);

Line 1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);

1917: hr_utility.trace('CDEP ===>' || g_fw_result_table(16).balance_value);
1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);

Line 1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);

1918: hr_utility.trace('Exempt Foreign Employment Income ===>' || g_fw_result_table(17).balance_value);
1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);

Line 1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);

1919: hr_utility.trace('Retro LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(18).balance_value);
1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);

Line 1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);

1920: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(19).balance_value);
1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);

Line 1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);

1921: hr_utility.trace('Retro Earnings Spread LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(20).balance_value);
1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);

Line 1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);

1922: hr_utility.trace('Retro Pre Tax LT 12 Mths Prev Yr Amount ===>' || g_fw_result_table(21).balance_value);
1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);

Line 1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);

1923: hr_utility.trace('Retro LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(22).balance_value);
1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);
1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);

Line 1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);

1924: hr_utility.trace('Retro Earnings Leave Loading LT 12 Mths Curr Yr Amount ===>' || g_fw_result_table(23).balance_value);
1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);
1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);
1932: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || g_fw_result_table(31).balance_value);

Line 1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);

1925: hr_utility.trace('Retro Earnings Spread LT 12 Mths Curr Amount ===>' || g_fw_result_table(24).balance_value);
1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);
1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);
1932: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || g_fw_result_table(31).balance_value);
1933: end if;

Line 1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);

1926: hr_utility.trace('Retro Tax GT12 Amount ===>' || g_fw_result_table(25).balance_value);
1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);
1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);
1932: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || g_fw_result_table(31).balance_value);
1933: end if;
1934:

Line 1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);

1927: hr_utility.trace('Retro Tax LT12 Prev Amount ===>' || g_fw_result_table(26).balance_value);
1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);
1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);
1932: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || g_fw_result_table(31).balance_value);
1933: end if;
1934:
1935:

Line 1932: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || g_fw_result_table(31).balance_value);

1928: hr_utility.trace('Retro Tax LT12 Curr Amount ===>' || g_fw_result_table(27).balance_value);
1929: hr_utility.trace('Foreign Leave Payments ===>' || g_fw_result_table(28).balance_value);
1930: hr_utility.trace('Retro Earnings Additional GT 12 Mths Amount ===>' || g_fw_result_table(29).balance_value);
1931: hr_utility.trace('Retro Earnings Additional LT12 Prev Mths Amount ===>' || g_fw_result_table(30).balance_value);
1932: hr_utility.trace('Retro Earnings Additional LT12 Curr Mths Amount ===>' || g_fw_result_table(31).balance_value);
1933: end if;
1934:
1935:
1936: /* Bug 10331262 - Reporting of Termination Payments and Foreign Leave Payments

Line 1947: hr_utility.set_location('Anitha I enter here',1000);

1943: */
1944: IF (i_idx = 1)
1945: THEN
1946:
1947: hr_utility.set_location('Anitha I enter here',1000);
1948: l_term_earnings := g_result_table(36).balance_value;
1949: l_lumpsuma := g_result_table(37).balance_value;
1950: l_term_tax := g_result_table(38).balance_value + g_result_table(39).balance_value;
1951:

Line 1977: hr_utility.set_location('2: Anitha I enter here',1000);

1973:
1974: END IF;
1975: /* End Bug 10331262 */
1976:
1977: hr_utility.set_location('2: Anitha I enter here',1000);
1978:
1979: /* Bug 10331262 - Modified termination payments added to earnings */
1980: g_fw_earnings := g_fw_earnings
1981: + g_fw_result_table(1).balance_value

Line 2060: hr_utility.set_location(' g_fw_earnings '||g_fw_earnings,41);

2056:
2057: end if;
2058:
2059: if g_debug then
2060: hr_utility.set_location(' g_fw_earnings '||g_fw_earnings,41);
2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);
2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);

Line 2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);

2057: end if;
2058:
2059: if g_debug then
2060: hr_utility.set_location(' g_fw_earnings '||g_fw_earnings,41);
2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);
2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);

Line 2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);

2058:
2059: if g_debug then
2060: hr_utility.set_location(' g_fw_earnings '||g_fw_earnings,41);
2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);
2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);

Line 2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);

2059: if g_debug then
2060: hr_utility.set_location(' g_fw_earnings '||g_fw_earnings,41);
2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);
2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);

Line 2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);

2060: hr_utility.set_location(' g_fw_earnings '||g_fw_earnings,41);
2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);
2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);

Line 2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);

2061: hr_utility.set_location(' g_fw_lump_sumE '||g_fw_lump_sumE,41);
2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);
2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);

Line 2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);

2062: hr_utility.set_location(' g_fw_Total_Tax '||g_fw_Total_Tax,41);
2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);
2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);
2070: hr_utility.set_location(' l_fw_tot_sub_balance '||l_fw_tot_sub_balance,41);

Line 2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);

2063: hr_utility.set_location(' g_fw_lump_sumA '||g_fw_lump_sumA,41);
2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);
2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);
2070: hr_utility.set_location(' l_fw_tot_sub_balance '||l_fw_tot_sub_balance,41);
2071: end if;

Line 2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);

2064: hr_utility.set_location(' g_fw_lump_sumD '||g_fw_lump_sumD,41);
2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);
2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);
2070: hr_utility.set_location(' l_fw_tot_sub_balance '||l_fw_tot_sub_balance,41);
2071: end if;
2072:

Line 2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);

2065: hr_utility.set_location(' g_fw_resc '||g_fw_resc,41);
2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);
2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);
2070: hr_utility.set_location(' l_fw_tot_sub_balance '||l_fw_tot_sub_balance,41);
2071: end if;
2072:
2073: if l_fw_tot_net_balance <> 0 then

Line 2070: hr_utility.set_location(' l_fw_tot_sub_balance '||l_fw_tot_sub_balance,41);

2066: hr_utility.set_location(' g_fw_fbt_balance '||g_fw_fbt_balance,41);
2067: hr_utility.set_location(' g_fw_cdep '||g_fw_cdep,41);
2068: hr_utility.set_location(' g_net_balance '||g_net_balance,41);
2069: hr_utility.set_location(' l_fw_tot_net_balance '||l_fw_tot_net_balance,41);
2070: hr_utility.set_location(' l_fw_tot_sub_balance '||l_fw_tot_sub_balance,41);
2071: end if;
2072:
2073: if l_fw_tot_net_balance <> 0 then
2074: if (g_net_balance - l_fw_tot_net_balance) <> 0 then

Line 2092: hr_utility.set_location(' g_payg_fw_type '||g_payg_fw_type,41);

2088: end if;
2089: end if;
2090:
2091: if g_debug then
2092: hr_utility.set_location(' g_payg_fw_type '||g_payg_fw_type,41);
2093: end if;
2094: /* Changes for 9147438 ends*/
2095:
2096: /* Call procedure to Adjust Lump SUM E Payments Value

Line 2102: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);

2098: Adjust_lumpsum_E_payments(l_employee_details.assignment_id);
2099:
2100: if g_debug
2101: then
2102: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
2103: end if;
2104:
2105: /* If Lump Sum C Payments get Pre-Post Ratios
2106: */

Line 2165: hr_utility.set_location('Leaving '||l_procedure,300);

2161: ,l_post30jun1983_ratio
2162: ,l_action_sequence);
2163:
2164: if g_debug then
2165: hr_utility.set_location('Leaving '||l_procedure,300);
2166: end if;
2167:
2168: end archive_code;
2169:

Line 2237: g_debug := hr_utility.debug_enabled;

2233:
2234: begin
2235: g_fw_reporting_fbt:=0;
2236: g_fw_fbt_balance :=0;
2237: g_debug := hr_utility.debug_enabled;
2238:
2239: if g_debug then
2240: l_procedure := g_package||'.Get_fbt_balance' ;
2241: hr_utility.set_location('Entering '||l_procedure,400);

Line 2241: hr_utility.set_location('Entering '||l_procedure,400);

2237: g_debug := hr_utility.debug_enabled;
2238:
2239: if g_debug then
2240: l_procedure := g_package||'.Get_fbt_balance' ;
2241: hr_utility.set_location('Entering '||l_procedure,400);
2242: end if;
2243:
2244: open c_max_assignment_action_id(p_assignment_id,g_tax_unit_id,p_start_date,p_end_date);
2245: fetch c_max_assignment_action_id into l_max_assignment_action_id,l_max_action_sequence;

Line 2283: hr_utility.set_location('Fringe Balance Value got := '||l_bal_value,302);

2279: g_net_balance:=g_net_balance+l_bal_value;
2280: /* Changes for 9147438 end */
2281:
2282: if g_debug then
2283: hr_utility.set_location('Fringe Balance Value got := '||l_bal_value,302);
2284: hr_utility.set_location('Value to be archived := '||g_fbt_balance_value,302);
2285: end if;
2286:
2287: p_action_sequence := l_max_action_sequence;

Line 2284: hr_utility.set_location('Value to be archived := '||g_fbt_balance_value,302);

2280: /* Changes for 9147438 end */
2281:
2282: if g_debug then
2283: hr_utility.set_location('Fringe Balance Value got := '||l_bal_value,302);
2284: hr_utility.set_location('Value to be archived := '||g_fbt_balance_value,302);
2285: end if;
2286:
2287: p_action_sequence := l_max_action_sequence;
2288:

Line 2291: hr_utility.set_location('Starting FW FBT check .. '||

2287: p_action_sequence := l_max_action_sequence;
2288:
2289: /* Changes for 9147438 start */
2290: if g_debug then
2291: hr_utility.set_location('Starting FW FBT check .. '||
2292: 'g_fw_fbt_term_check '||g_fw_fbt_term_check||' , g_fw_fbt_check '||g_fw_fbt_check, 5);
2293: end if;
2294:
2295: if g_fw_fbt_term_check <> 'NN' or g_fw_fbt_check <> 'NN' then

Line 2411: hr_utility.set_location('Leaving FW FBT g_fw_fbt_balance : '||g_fw_fbt_balance,5);

2407: END IF;
2408: end if;
2409:
2410: if g_debug then
2411: hr_utility.set_location('Leaving FW FBT g_fw_fbt_balance : '||g_fw_fbt_balance,5);
2412: end if;
2413:
2414:
2415: end if;

Line 2419: hr_utility.set_location('Leaving '||l_procedure,400);

2415: end if;
2416: /* Changes for 9147438 end */
2417:
2418: if g_debug then
2419: hr_utility.set_location('Leaving '||l_procedure,400);
2420: end if;
2421:
2422: end;
2423:

Line 2658: g_debug := hr_utility.debug_enabled;

2654: counter number;
2655:
2656: begin
2657:
2658: g_debug := hr_utility.debug_enabled;
2659: l_prev_bal_type_id := 0;
2660:
2661: if g_debug
2662: then

Line 2664: hr_utility.set_location('Entering ' || l_procedure,500);

2660:
2661: if g_debug
2662: then
2663: l_procedure := g_package||'Element_Details';
2664: hr_utility.set_location('Entering ' || l_procedure,500);
2665: end if;
2666:
2667: FOR csr_ele_det IN c_ps_element_details(p_assignment_id,g_business_group_id,g_tax_unit_id,g_start_date,g_end_date)
2668: LOOP

Line 2672: hr_utility.set_location('Element Name '||csr_ele_det.element_name,500);

2668: LOOP
2669:
2670: if g_debug
2671: then
2672: hr_utility.set_location('Element Name '||csr_ele_det.element_name,500);
2673: hr_utility.set_location('Classification Name '||csr_ele_det.classification_name,500);
2674: end if;
2675:
2676: insert into pay_action_information (

Line 2673: hr_utility.set_location('Classification Name '||csr_ele_det.classification_name,500);

2669:
2670: if g_debug
2671: then
2672: hr_utility.set_location('Element Name '||csr_ele_det.element_name,500);
2673: hr_utility.set_location('Classification Name '||csr_ele_det.classification_name,500);
2674: end if;
2675:
2676: insert into pay_action_information (
2677: action_information_id,

Line 2708: hr_utility.set_location('After Inserting Element Values ',500);

2704: csr_ele_det.payment,
2705: p_assignment_id);
2706:
2707: if g_debug then
2708: hr_utility.set_location('After Inserting Element Values ',500);
2709: end if;
2710: END LOOP;
2711:
2712: FOR csr_alw_det IN c_ps_alw_details(p_assignment_id,g_business_group_id,g_tax_unit_id,g_start_date,g_end_date) LOOP

Line 2716: hr_utility.set_location('Element Name '||csr_alw_det.element_name,600);

2712: FOR csr_alw_det IN c_ps_alw_details(p_assignment_id,g_business_group_id,g_tax_unit_id,g_start_date,g_end_date) LOOP
2713:
2714: if g_debug
2715: then
2716: hr_utility.set_location('Element Name '||csr_alw_det.element_name,600);
2717: end if;
2718:
2719: /* Bug 8760756 - As hours and rate columns are removed from c_ps_alw_details cursor query ,
2720: the corresponding column values in pay_action_information table are made null */

Line 2754: hr_utility.set_location('After Inserting Allowance Element Values ',600);

2750: csr_alw_det.payment,
2751: p_assignment_id);
2752:
2753: if g_debug then
2754: hr_utility.set_location('After Inserting Allowance Element Values ',600);
2755: end if;
2756: END LOOP;
2757:
2758: /* Now Archive Lump Sum Payments and Invalidity */

Line 2769: hr_utility.set_location('p_pre01jul1983_ratio........=>'||p_pre01jul1983_ratio,200);

2765: 'Invalidity Payments ===>' g_result_table(16).balance_value
2766: */
2767:
2768: if g_debug then
2769: hr_utility.set_location('p_pre01jul1983_ratio........=>'||p_pre01jul1983_ratio,200);
2770: hr_utility.set_location('p_post30jun1983_ratio........=>'||p_post30jun1983_ratio,200);
2771: end if;
2772:
2773: counter := 0;

Line 2770: hr_utility.set_location('p_post30jun1983_ratio........=>'||p_post30jun1983_ratio,200);

2766: */
2767:
2768: if g_debug then
2769: hr_utility.set_location('p_pre01jul1983_ratio........=>'||p_pre01jul1983_ratio,200);
2770: hr_utility.set_location('p_post30jun1983_ratio........=>'||p_post30jun1983_ratio,200);
2771: end if;
2772:
2773: counter := 0;
2774: if (g_result_table(11).balance_value > 0)

Line 2893: hr_utility.set_location('Leaving '||l_procedure,700 );

2889: end loop;
2890: end if;
2891:
2892: if g_debug then
2893: hr_utility.set_location('Leaving '||l_procedure,700 );
2894: end if;
2895:
2896: end archive_element_details;
2897:

Line 2924: g_debug := hr_utility.debug_enabled;

2920:
2921:
2922: begin
2923:
2924: g_debug := hr_utility.debug_enabled;
2925:
2926: if g_debug then
2927: l_procedure := 'Adjust_lumpsum_E_payments';
2928: hr_utility.set_location('In procedure '||g_package||l_procedure,600);

Line 2928: hr_utility.set_location('In procedure '||g_package||l_procedure,600);

2924: g_debug := hr_utility.debug_enabled;
2925:
2926: if g_debug then
2927: l_procedure := 'Adjust_lumpsum_E_payments';
2928: hr_utility.set_location('In procedure '||g_package||l_procedure,600);
2929: end if;
2930:
2931: /*bug8711855 - The calculation logic is changed to add retro GT12 and call
2932: pay_au_payment_summary.get_lumpsumE_value function to adjust by single Lump Sum E paymetns */

Line 2950: hr_utility.set_location('In procedure '||g_package||l_procedure,600);

2946: g_adjusted_lump_sum_e_pay := v_adj_lump_sum_E_ptd; /* Bug 4201894*/
2947: g_adj_lump_sum_pre_tax := v_adj_lump_sum_pre_tax;
2948:
2949: if g_debug then
2950: hr_utility.set_location('In procedure '||g_package||l_procedure,600);
2951: end if;
2952: end;
2953:
2954: --------------------------------------------------------------------+

Line 3036: g_debug := hr_utility.debug_enabled;

3032: /* Changes for 9147438 end */
3033:
3034: begin
3035:
3036: g_debug := hr_utility.debug_enabled;
3037: if g_debug then
3038: l_procedure := g_package||'.Get_allowance_balances';
3039: hr_utility.set_location('Entering '||l_procedure,700);
3040: end if;

Line 3039: hr_utility.set_location('Entering '||l_procedure,700);

3035:
3036: g_debug := hr_utility.debug_enabled;
3037: if g_debug then
3038: l_procedure := g_package||'.Get_allowance_balances';
3039: hr_utility.set_location('Entering '||l_procedure,700);
3040: end if;
3041:
3042: /* Changes for 9147438 start*/
3043: idx:=1;

Line 3060: hr_utility.set_location(l_procedure, 3);

3056: t_allowance_balance(counter).balance_name := rec_allowance_balances.balance_name;
3057: t_allowance_balance(counter).balance_value := rec_allowance_balances.balance_value;
3058:
3059: if g_debug then
3060: hr_utility.set_location(l_procedure, 3);
3061: hr_utility.trace('t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);
3062: hr_utility.trace('t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);
3063: end if;
3064:

Line 3061: hr_utility.trace('t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);

3057: t_allowance_balance(counter).balance_value := rec_allowance_balances.balance_value;
3058:
3059: if g_debug then
3060: hr_utility.set_location(l_procedure, 3);
3061: hr_utility.trace('t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);
3062: hr_utility.trace('t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);
3063: end if;
3064:
3065: counter := counter +1;

Line 3062: hr_utility.trace('t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);

3058:
3059: if g_debug then
3060: hr_utility.set_location(l_procedure, 3);
3061: hr_utility.trace('t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);
3062: hr_utility.trace('t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);
3063: end if;
3064:
3065: counter := counter +1;
3066:

Line 3209: hr_utility.set_location('Set the Global Balance Value '||g_allowance_balance_value,700);

3205: end if;
3206: /*Changes for 9147438 end */
3207:
3208: if g_debug then
3209: hr_utility.set_location('Set the Global Balance Value '||g_allowance_balance_value,700);
3210: hr_utility.set_location('Set the Global FW Balance Value '||g_fw_alw_total,700);
3211: hr_utility.set_location('Leaving '||l_procedure,700);
3212: end if;
3213: end;

Line 3210: hr_utility.set_location('Set the Global FW Balance Value '||g_fw_alw_total,700);

3206: /*Changes for 9147438 end */
3207:
3208: if g_debug then
3209: hr_utility.set_location('Set the Global Balance Value '||g_allowance_balance_value,700);
3210: hr_utility.set_location('Set the Global FW Balance Value '||g_fw_alw_total,700);
3211: hr_utility.set_location('Leaving '||l_procedure,700);
3212: end if;
3213: end;
3214:

Line 3211: hr_utility.set_location('Leaving '||l_procedure,700);

3207:
3208: if g_debug then
3209: hr_utility.set_location('Set the Global Balance Value '||g_allowance_balance_value,700);
3210: hr_utility.set_location('Set the Global FW Balance Value '||g_fw_alw_total,700);
3211: hr_utility.set_location('Leaving '||l_procedure,700);
3212: end if;
3213: end;
3214:
3215: --------------------------------------------------------------------+

Line 3272: g_debug := hr_utility.debug_enabled;

3268: /* Changes for 9147438 end */
3269:
3270: begin
3271:
3272: g_debug := hr_utility.debug_enabled;
3273: if g_debug then
3274: l_procedure := 'archive_balance_details';
3275: hr_utility.set_location('In procedure '||g_package||l_procedure,800);
3276: end if;

Line 3275: hr_utility.set_location('In procedure '||g_package||l_procedure,800);

3271:
3272: g_debug := hr_utility.debug_enabled;
3273: if g_debug then
3274: l_procedure := 'archive_balance_details';
3275: hr_utility.set_location('In procedure '||g_package||l_procedure,800);
3276: end if;
3277: /*
3278: ===============================================================================================
3279: Balances for Archive are computed in the following manner,

Line 3512: hr_utility.set_location('Leaving '||g_package||l_procedure,800);

3508: g_fw_gross_type
3509: );
3510: /* Changes for 9147438 end */
3511: if g_debug then
3512: hr_utility.set_location('Leaving '||g_package||l_procedure,800);
3513: end if;
3514:
3515: end archive_balance_details;
3516:

Line 3589: g_debug :=hr_utility.debug_enabled ;

3585:
3586: begin
3587: l_count :=0;
3588: ps_request_id :=-1;
3589: g_debug :=hr_utility.debug_enabled ;
3590:
3591: if g_debug then
3592: l_procedure := g_package||' spawn_archive_reports';
3593: hr_utility.set_location('Entering '||l_procedure,999);

Line 3593: hr_utility.set_location('Entering '||l_procedure,999);

3589: g_debug :=hr_utility.debug_enabled ;
3590:
3591: if g_debug then
3592: l_procedure := g_package||' spawn_archive_reports';
3593: hr_utility.set_location('Entering '||l_procedure,999);
3594: end if;
3595:
3596: -- Set User Parameters for Report.
3597:

Line 3627: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);

3623: l_negative_records := 'N'; /* Do not Suppress Records with Negative Earnings */
3624: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
3625:
3626: if g_debug then
3627: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);

Line 3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);

3624: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
3625:
3626: if g_debug then
3627: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);

Line 3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);

3625:
3626: if g_debug then
3627: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);

Line 3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);

3626: if g_debug then
3627: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);

Line 3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);

3627: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);

Line 3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);

3628: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);

Line 3633: hr_utility.set_location('in zero records'||l_zero_records,911);

3629: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);

Line 3634: hr_utility.set_location('in Negative records'||l_negative_records,912);

3630: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);

Line 3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);

3631: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/

Line 3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);

3632: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);

Line 3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);

3633: hr_utility.set_location('in zero records'||l_zero_records,911);
3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
3641: end if;

Line 3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);

3634: hr_utility.set_location('in Negative records'||l_negative_records,912);
3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
3641: end if;
3642:

Line 3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /Bug 4142159/

3635: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
3641: end if;
3642:
3643: if g_debug then

Line 3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);

3636: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3637: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3638: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3639: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
3641: end if;
3642:
3643: if g_debug then
3644: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);

Line 3644: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);

3640: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
3641: end if;
3642:
3643: if g_debug then
3644: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
3645: hr_utility.set_location('Before calling report',900);
3646: end if;
3647:
3648: OPEN csr_get_print_options(p_payroll_action_id);

Line 3645: hr_utility.set_location('Before calling report',900);

3641: end if;
3642:
3643: if g_debug then
3644: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
3645: hr_utility.set_location('Before calling report',900);
3646: end if;
3647:
3648: OPEN csr_get_print_options(p_payroll_action_id);
3649: FETCH csr_get_print_options INTO rec_print_options;

Line 3663: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,900);

3659: save_output => hr_general.char_to_bool(rec_print_options.save_output),
3660: print_together => l_print_together);
3661: -- Submit report
3662: if g_debug then
3663: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,900);
3664: end if;
3665:
3666: ps_request_id := fnd_request.submit_request
3667: ('PAY',

Line 3709: hr_utility.set_location('After calling report',900);

3705: NULL, NULL, NULL, NULL, NULL, NULL,
3706: NULL, NULL, NULL, NULL
3707: );
3708: if g_debug then
3709: hr_utility.set_location('After calling report',900);
3710: end if;
3711:
3712: end;
3713:

Line 3773: g_debug :=hr_utility.debug_enabled ;

3769:
3770: begin
3771: l_count :=0;
3772: ps_request_id :=-1;
3773: g_debug :=hr_utility.debug_enabled ;
3774:
3775: if g_debug then
3776: l_procedure := g_package||' spawn_summary_archive_reports';
3777: hr_utility.set_location('Entering '||l_procedure,999);

Line 3777: hr_utility.set_location('Entering '||l_procedure,999);

3773: g_debug :=hr_utility.debug_enabled ;
3774:
3775: if g_debug then
3776: l_procedure := g_package||' spawn_summary_archive_reports';
3777: hr_utility.set_location('Entering '||l_procedure,999);
3778: end if;
3779:
3780: -- Set User Parameters for Report.
3781:

Line 3793: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);

3789: l_negative_records := 'N'; /* Do not Suppress Records with Negative Earnings */
3790: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
3791:
3792: if g_debug then
3793: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);

Line 3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);

3790: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
3791:
3792: if g_debug then
3793: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);

Line 3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);

3791:
3792: if g_debug then
3793: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);

Line 3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);

3792: if g_debug then
3793: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);

Line 3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);

3793: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);

Line 3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);

3794: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);

Line 3799: hr_utility.set_location('in zero records'||l_zero_records,911);

3795: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);

Line 3800: hr_utility.set_location('in Negative records'||l_negative_records,912);

3796: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);

Line 3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);

3797: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);

Line 3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);

3798: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);

Line 3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);

3799: hr_utility.set_location('in zero records'||l_zero_records,911);
3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
3807: end if;

Line 3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);

3800: hr_utility.set_location('in Negative records'||l_negative_records,912);
3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
3807: end if;
3808:

Line 3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);

3801: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
3807: end if;
3808:
3809: if g_debug then

Line 3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);

3802: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
3803: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
3804: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
3805: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
3807: end if;
3808:
3809: if g_debug then
3810: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);

Line 3810: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);

3806: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
3807: end if;
3808:
3809: if g_debug then
3810: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
3811: hr_utility.set_location('Before calling report',900);
3812: end if;
3813:
3814: OPEN csr_get_print_options(p_payroll_action_id);

Line 3811: hr_utility.set_location('Before calling report',900);

3807: end if;
3808:
3809: if g_debug then
3810: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
3811: hr_utility.set_location('Before calling report',900);
3812: end if;
3813:
3814: OPEN csr_get_print_options(p_payroll_action_id);
3815: FETCH csr_get_print_options INTO rec_print_options;

Line 3829: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,900);

3825: save_output => hr_general.char_to_bool(rec_print_options.save_output),
3826: print_together => l_print_together);
3827: -- Submit report
3828: if g_debug then
3829: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,900);
3830: end if;
3831:
3832: ps_request_id := fnd_request.submit_request
3833: ('PAY',

Line 3875: hr_utility.set_location('After calling report',900);

3871: NULL, NULL, NULL, NULL, NULL, NULL,
3872: NULL, NULL, NULL, NULL
3873: );
3874: if g_debug then
3875: hr_utility.set_location('After calling report',900);
3876: end if;
3877:
3878: end spawn_summary_reports;
3879: