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

Line 87: g_debug constant boolean := hr_utility.debug_enabled;

83: ** 11-Jan-2013 skshin 115.67 Bug# 15852244 Modifed calculate_etp_tax_2012 function to reduce ETP CAP with Non Excluded amount at under cap rate
84: ** 21-Feb-2013 skshin 115.68 Bug# 16319860 Modifed calculate_marginal_tax to ignore the cents from lv_average_term_pay_period
85: */
86:
87: g_debug constant boolean := hr_utility.debug_enabled;
88: g_package constant varchar2(60) := 'pay_au_terminations.';
89: --
90: -------------------------------------------------------------------------------------------------
91: --

Line 114: -- hr_utility

110: -- p_post_aug_1993 - net leave amount from 18-AUG-1993 until effective_date
111: --
112: -- Uses : per_accrual_calc_functions
113: -- pay_au_terminations
114: -- hr_utility
115: --
116: ------------------------------------------------------------------------------------------------
117: function get_long_service_leave
118: (p_assignment_id in number

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

169: l_long_service_leave := 'AULSL';
170:
171:
172: IF g_debug THEN
173: hr_utility.trace('-----------------------------------------');
174: hr_utility.set_location('Entering : '||l_procedure, 1);
175: END IF;
176: --
177: -- Get the accrual plan for long service leave

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

170:
171:
172: IF g_debug THEN
173: hr_utility.trace('-----------------------------------------');
174: hr_utility.set_location('Entering : '||l_procedure, 1);
175: END IF;
176: --
177: -- Get the accrual plan for long service leave
178: --

Line 185: hr_utility.trace('plan id := '||to_char(l_plan_id));

181: ,p_effective_date => p_effective_date
182: ,p_plan_category => l_long_service_leave
183: );
184: IF g_debug THEN
185: hr_utility.trace('plan id := '||to_char(l_plan_id));
186: END IF;
187: --
188: ---------------------------
189: -- Calculate pre aug 1978

Line 194: hr_utility.set_location(l_procedure, 10);

190: ---------------------------
191: -- Accrual pre-aug-1978
192: --
193: IF g_debug THEN
194: hr_utility.set_location(l_procedure, 10);
195: END IF;
196: per_accrual_calc_functions.get_accrual
197: (p_assignment_id => p_assignment_id
198: ,p_calculation_date => l_pre_16_aug_1978 - 1

Line 241: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));

237: l_pre78_accrual:=l_pre78_accrual + l_others_entitlement_pre78 + l_accrual_init_pre78 + l_entitlement_init_pre78 ;
238:
239: -- Bug #1942971 -- End
240: IF g_debug THEN
241: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
242: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
243: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
244: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
245: END IF;

Line 242: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));

238:
239: -- Bug #1942971 -- End
240: IF g_debug THEN
241: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
242: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
243: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
244: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
245: END IF;
246: --

Line 243: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));

239: -- Bug #1942971 -- End
240: IF g_debug THEN
241: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
242: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
243: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
244: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
245: END IF;
246: --
247: -- Absences for pre-aug-1978

Line 244: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));

240: IF g_debug THEN
241: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
242: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
243: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
244: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
245: END IF;
246: --
247: -- Absences for pre-aug-1978
248: --

Line 250: hr_utility.set_location(l_procedure, 15);

246: --
247: -- Absences for pre-aug-1978
248: --
249: IF g_debug THEN
250: hr_utility.set_location(l_procedure, 15);
251: END IF;
252: l_pre78_absence := per_accrual_calc_functions.get_absence
253: (p_assignment_id => p_assignment_id
254: ,p_plan_id => l_plan_id

Line 259: hr_utility.trace('pre78 absence := '||to_char(l_pre78_absence));

255: ,p_calculation_date => l_pre_16_aug_1978 - 1
256: ,p_start_date => l_start_date
257: );
258: IF g_debug THEN
259: hr_utility.trace('pre78 absence := '||to_char(l_pre78_absence));
260: END IF;
261: --
262: ---------------------------
263: -- Calculate post aug 1978

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

264: ---------------------------
265: -- Accrual post-aug-1978
266: --
267: IF g_debug THEN
268: hr_utility.set_location(l_procedure, 30);
269: END IF;
270: --
271: if p_effective_date < l_post_17_aug_1993 and p_effective_date > l_pre_16_aug_1978 then
272: per_accrual_calc_functions.get_accrual

Line 331: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));

327: l_post78_accrual := l_post78_accrual - l_pre78_accrual + l_others_entitlement_post78 + l_accrual_init_post78 + l_entitlement_init_post78;
328: --
329: -- Bug #1942971 -- End
330: IF g_debug THEN
331: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
332: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
333: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
334: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
335: END IF;

Line 332: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));

328: --
329: -- Bug #1942971 -- End
330: IF g_debug THEN
331: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
332: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
333: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
334: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
335: END IF;
336: --

Line 333: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));

329: -- Bug #1942971 -- End
330: IF g_debug THEN
331: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
332: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
333: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
334: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
335: END IF;
336: --
337: -- Absences for post-aug-1978

Line 334: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));

330: IF g_debug THEN
331: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
332: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
333: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
334: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
335: END IF;
336: --
337: -- Absences for post-aug-1978
338: --

Line 340: hr_utility.set_location(l_procedure, 35);

336: --
337: -- Absences for post-aug-1978
338: --
339: IF g_debug THEN
340: hr_utility.set_location(l_procedure, 35);
341: END IF;
342: l_post78_absence := per_accrual_calc_functions.get_absence
343: (p_assignment_id => p_assignment_id
344: ,p_plan_id => l_plan_id

Line 349: hr_utility.trace('post78 absence := '||to_char(l_post78_absence));

345: ,p_calculation_date => l_post_17_aug_1993
346: ,p_start_date => greatest(l_post_15_aug_1978 + 1, l_start_date) -- bug9507714
347: );
348: IF g_debug THEN
349: hr_utility.trace('post78 absence := '||to_char(l_post78_absence));
350: END IF;
351: --
352: ---------------------------
353: -- Calculate post aug 1993

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

354: ---------------------------
355: -- Accrual post-aug-1993
356: --
357: IF g_debug THEN
358: hr_utility.set_location(l_procedure, 50);
359: END IF;
360:
361: per_accrual_calc_functions.get_accrual
362: (p_assignment_id => p_assignment_id

Line 414: hr_utility.set_location('l_fw_others_ent_post93 '||l_fw_others_ent_post93,2000);

410: END IF;
411:
412: IF g_debug
413: THEN
414: hr_utility.set_location('l_fw_others_ent_post93 '||l_fw_others_ent_post93,2000);
415: hr_utility.set_location('l_fw_post93_absence '||l_fw_post93_absence,2000);
416: END IF;
417:
418: /* End Bug 9950136 */

Line 415: hr_utility.set_location('l_fw_post93_absence '||l_fw_post93_absence,2000);

411:
412: IF g_debug
413: THEN
414: hr_utility.set_location('l_fw_others_ent_post93 '||l_fw_others_ent_post93,2000);
415: hr_utility.set_location('l_fw_post93_absence '||l_fw_post93_absence,2000);
416: END IF;
417:
418: /* End Bug 9950136 */
419:

Line 456: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));

452: l_post93_accrual := l_post93_accrual - l_pre78_accrual - l_post78_accrual + l_accrual_init_post93 + l_entitlement_init_post93 ;
453: --
454: -- Bug #1942971 -- End
455: IF g_debug THEN
456: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
457: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
458: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
459: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
460: END IF;

Line 457: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));

453: --
454: -- Bug #1942971 -- End
455: IF g_debug THEN
456: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
457: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
458: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
459: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
460: END IF;
461: --

Line 458: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));

454: -- Bug #1942971 -- End
455: IF g_debug THEN
456: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
457: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
458: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
459: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
460: END IF;
461: --
462: -- Absences for post-aug-1993

Line 459: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));

455: IF g_debug THEN
456: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
457: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
458: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
459: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
460: END IF;
461: --
462: -- Absences for post-aug-1993
463: --

Line 465: hr_utility.set_location(l_procedure, 55);

461: --
462: -- Absences for post-aug-1993
463: --
464: IF g_debug THEN
465: hr_utility.set_location(l_procedure, 55);
466: END IF;
467:
468: l_post93_absence := per_accrual_calc_functions.get_absence
469: (p_assignment_id => p_assignment_id

Line 477: hr_utility.trace('post93 absence := '||to_char(l_post93_absence));

473: );
474: l_post93_absence := l_post93_absence + l_fw_post93_absence ; /* Bug 9950136 */
475:
476: IF g_debug THEN
477: hr_utility.trace('post93 absence := '||to_char(l_post93_absence));
478: END IF;
479: --
480: -- Absence are taken from accruals LIFO
481: --

Line 483: hr_utility.set_location(l_procedure, 70);

479: --
480: -- Absence are taken from accruals LIFO
481: --
482: IF g_debug THEN
483: hr_utility.set_location(l_procedure, 70);
484: END IF;
485: if l_post93_absence > l_post93_accrual
486: then
487: IF g_debug THEN

Line 488: hr_utility.set_location(l_procedure, 72);

484: END IF;
485: if l_post93_absence > l_post93_accrual
486: then
487: IF g_debug THEN
488: hr_utility.set_location(l_procedure, 72);
489: END IF;
490: p_post_aug_1993 := 0;
491: --
492: -- Move excess absences from post aug 1993 to absence for post aug 1978, previous bucket

Line 497: hr_utility.set_location(l_procedure, 74);

493: --
494: l_post78_absence := l_post78_absence + (l_post93_absence - l_post93_accrual);
495: else
496: IF g_debug THEN
497: hr_utility.set_location(l_procedure, 74);
498: END IF;
499: p_post_aug_1993 := l_post93_accrual - l_post93_absence;
500: end if;
501: --

Line 503: hr_utility.set_location(l_procedure, 80);

499: p_post_aug_1993 := l_post93_accrual - l_post93_absence;
500: end if;
501: --
502: IF g_debug THEN
503: hr_utility.set_location(l_procedure, 80);
504: END IF;
505: if l_post78_absence > l_post78_accrual
506: then
507: IF g_debug THEN

Line 508: hr_utility.set_location(l_procedure, 82);

504: END IF;
505: if l_post78_absence > l_post78_accrual
506: then
507: IF g_debug THEN
508: hr_utility.set_location(l_procedure, 82);
509: END IF;
510: p_post_aug_1978 := 0;
511: --
512: -- Move excess absences from post aug 1978 to absence for pre aug 1978, previous bucket

Line 517: hr_utility.set_location(l_procedure, 84);

513: --
514: l_pre78_absence := l_pre78_absence + (l_post78_absence - l_post78_accrual);
515: else
516: IF g_debug THEN
517: hr_utility.set_location(l_procedure, 84);
518: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);
519: hr_utility.trace('l_post78_absence:'||l_post78_absence);
520: END IF;
521: p_post_aug_1978 := l_post78_accrual - l_post78_absence;

Line 518: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);

514: l_pre78_absence := l_pre78_absence + (l_post78_absence - l_post78_accrual);
515: else
516: IF g_debug THEN
517: hr_utility.set_location(l_procedure, 84);
518: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);
519: hr_utility.trace('l_post78_absence:'||l_post78_absence);
520: END IF;
521: p_post_aug_1978 := l_post78_accrual - l_post78_absence;
522: end if;

Line 519: hr_utility.trace('l_post78_absence:'||l_post78_absence);

515: else
516: IF g_debug THEN
517: hr_utility.set_location(l_procedure, 84);
518: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);
519: hr_utility.trace('l_post78_absence:'||l_post78_absence);
520: END IF;
521: p_post_aug_1978 := l_post78_accrual - l_post78_absence;
522: end if;
523: --

Line 525: hr_utility.set_location(l_procedure, 90);

521: p_post_aug_1978 := l_post78_accrual - l_post78_absence;
522: end if;
523: --
524: IF g_debug THEN
525: hr_utility.set_location(l_procedure, 90);
526: END IF;
527: if l_pre78_absence > l_pre78_accrual
528: then
529: IF g_debug THEN

Line 530: hr_utility.set_location(l_procedure, 92);

526: END IF;
527: if l_pre78_absence > l_pre78_accrual
528: then
529: IF g_debug THEN
530: hr_utility.set_location(l_procedure, 92);
531: END IF;
532: -- Just set to zero, as we will not use negative amounts
533: p_pre_aug_1978 := 0;
534: else

Line 536: hr_utility.set_location(l_procedure, 94);

532: -- Just set to zero, as we will not use negative amounts
533: p_pre_aug_1978 := 0;
534: else
535: IF g_debug THEN
536: hr_utility.set_location(l_procedure, 94);
537: END IF;
538: p_pre_aug_1978 := l_pre78_accrual - l_pre78_absence;
539: end if;
540: --

Line 542: hr_utility.set_location('Leaving : '||l_procedure, 999);

538: p_pre_aug_1978 := l_pre78_accrual - l_pre78_absence;
539: end if;
540: --
541: IF g_debug THEN
542: hr_utility.set_location('Leaving : '||l_procedure, 999);
543: hr_utility.trace('-----------------------------------------');
544: END IF;
545: return 1;
546: end get_long_service_leave;

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

539: end if;
540: --
541: IF g_debug THEN
542: hr_utility.set_location('Leaving : '||l_procedure, 999);
543: hr_utility.trace('-----------------------------------------');
544: END IF;
545: return 1;
546: end get_long_service_leave;
547: --

Line 678: -- USES: hr_utility

674: -- accrual plan category - annual leave or long service leave
675: -- OUT:
676: --
677: --
678: -- USES: hr_utility
679: -- hr_au_holidays
680: --
681: function get_accrual_plan_by_category
682: (p_assignment_id in number

Line 717: hr_utility.set_location(' Entering::'||l_proc,5);

713: --
714: begin
715: l_proc := g_package||'get_accrual_plan_by_category' ;
716: IF g_debug THEN
717: hr_utility.set_location(' Entering::'||l_proc,5);
718: END IF;
719: open csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
720: fetch csr_get_accrual_plan_id
721: into l_accrual_plan_id;

Line 733: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);

729: if csr_get_accrual_plan_id%found
730: then
731: close csr_get_accrual_plan_id;
732: IF g_debug THEN
733: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
734: END IF;
735: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
736: hr_utility.raise_error;
737: end if;

Line 735: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');

731: close csr_get_accrual_plan_id;
732: IF g_debug THEN
733: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
734: END IF;
735: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
736: hr_utility.raise_error;
737: end if;
738: close csr_get_accrual_plan_id;
739: IF g_debug THEN

Line 736: hr_utility.raise_error;

732: IF g_debug THEN
733: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
734: END IF;
735: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
736: hr_utility.raise_error;
737: end if;
738: close csr_get_accrual_plan_id;
739: IF g_debug THEN
740: hr_utility.set_location('Leaving:'||l_proc,20);

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

736: hr_utility.raise_error;
737: end if;
738: close csr_get_accrual_plan_id;
739: IF g_debug THEN
740: hr_utility.set_location('Leaving:'||l_proc,20);
741: END IF;
742: return l_accrual_plan_id;
743: END get_accrual_plan_by_category;
744: --

Line 764: -- USES: hr_utility

760: -- p_tax_instalment_deduction - used by formula to convert back to period amount
761: -- OUT:
762: --
763: --
764: -- USES: hr_utility
765: -- hr_au_holidays
766: --
767: function calculate_marginal_tax
768: ( p_date_earned in date

Line 798: hr_utility.set_location(l_procedure, 1);

794: begin
795:
796:
797: IF g_debug THEN
798: hr_utility.set_location(l_procedure, 1);
799: hr_utility.trace('p_tax_variation_type = '||p_tax_variation_type);
800: END IF;
801: --
802: -- Which Tax method to use : Exempt, Fixed %, Fixed Amt or Marginal Rate

Line 799: hr_utility.trace('p_tax_variation_type = '||p_tax_variation_type);

795:
796:
797: IF g_debug THEN
798: hr_utility.set_location(l_procedure, 1);
799: hr_utility.trace('p_tax_variation_type = '||p_tax_variation_type);
800: END IF;
801: --
802: -- Which Tax method to use : Exempt, Fixed %, Fixed Amt or Marginal Rate
803: --

Line 835: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));

831: -- The amount used here is assumed to be a weekly amount
832: -- so it must be converted back to a period amount
833: --
834: IF g_debug THEN
835: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));
836: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));
837: hr_utility.trace('average pay = '||to_char(p_average_pay));
838: END IF;
839: --

Line 836: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));

832: -- so it must be converted back to a period amount
833: --
834: IF g_debug THEN
835: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));
836: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));
837: hr_utility.trace('average pay = '||to_char(p_average_pay));
838: END IF;
839: --
840: -- Calculate the average termination pay

Line 837: hr_utility.trace('average pay = '||to_char(p_average_pay));

833: --
834: IF g_debug THEN
835: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));
836: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));
837: hr_utility.trace('average pay = '||to_char(p_average_pay));
838: END IF;
839: --
840: -- Calculate the average termination pay
841: --

Line 847: hr_utility.trace('lv_average_term_pay_period = '||to_char(lv_average_term_pay_period));

843:
844: lv_average_pay := pay_au_paye_ff.convert_to_week(p_pay_freq,p_average_pay);
845: IF g_debug THEN
846:
847: hr_utility.trace('lv_average_term_pay_period = '||to_char(lv_average_term_pay_period));
848: hr_utility.trace('average term pay = '||to_char(lv_average_pay));
849: END IF;
850: --
851: -- Calculate tax on the average pay + average term pay

Line 848: hr_utility.trace('average term pay = '||to_char(lv_average_pay));

844: lv_average_pay := pay_au_paye_ff.convert_to_week(p_pay_freq,p_average_pay);
845: IF g_debug THEN
846:
847: hr_utility.trace('lv_average_term_pay_period = '||to_char(lv_average_term_pay_period));
848: hr_utility.trace('average term pay = '||to_char(lv_average_pay));
849: END IF;
850: --
851: -- Calculate tax on the average pay + average term pay
852: --

Line 861: hr_utility.trace('average pay tax = '||to_char(l_average_pay_tax));

857: else
858: l_average_pay_tax := trunc(l_average_pay_tax);
859: end if;
860: IF g_debug THEN
861: hr_utility.trace('average pay tax = '||to_char(l_average_pay_tax));
862: END IF;
863: --
864: -- Calculate tax on the average pay
865: --

Line 867: hr_utility.trace('p_a_variable2 = '||to_char(p_a_variable2));

863: --
864: -- Calculate tax on the average pay
865: --
866: IF g_debug THEN
867: hr_utility.trace('p_a_variable2 = '||to_char(p_a_variable2));
868: hr_utility.trace('p_b_variable2 = '||to_char(p_b_variable2));
869: END IF;
870:
871: l_average_term_pay_tax := (p_a_variable2 * lv_average_pay) - p_b_variable2;

Line 868: hr_utility.trace('p_b_variable2 = '||to_char(p_b_variable2));

864: -- Calculate tax on the average pay
865: --
866: IF g_debug THEN
867: hr_utility.trace('p_a_variable2 = '||to_char(p_a_variable2));
868: hr_utility.trace('p_b_variable2 = '||to_char(p_b_variable2));
869: END IF;
870:
871: l_average_term_pay_tax := (p_a_variable2 * lv_average_pay) - p_b_variable2;
872: if p_tax_scale <> 4

Line 880: hr_utility.trace('average term tax = '||to_char(l_average_term_pay_tax));

876: l_average_term_pay_tax := trunc(l_average_term_pay_tax);
877: end if;
878: --
879: IF g_debug THEN
880: hr_utility.trace('average term tax = '||to_char(l_average_term_pay_tax));
881: END IF;
882: --
883: -- Total tax payable equals the difference between the tax amounts multiplied by 52
884: --

Line 891: hr_utility.trace('l_lump_tax = '||to_char(l_lump_tax));

887: --
888:
889: --
890: IF g_debug THEN
891: hr_utility.trace('l_lump_tax = '||to_char(l_lump_tax));
892: END IF;
893: return l_lump_tax;
894: --
895: else

Line 914: -- USES: hr_utility

910: -- ETP payment components which can be free of tax
911: --
912: -- RETURNS: maximum tax free amount
913: --
914: -- USES: hr_utility
915: --
916: function max_etp_tax_free
917: (p_years_of_service in number
918: ,p_lump_d_tax_free in number

Line 928: hr_utility.set_location(l_procedure, 1);

924: --
925: begin
926: --
927: IF g_debug THEN
928: hr_utility.set_location(l_procedure, 1);
929: END IF;
930: return p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;
931: --
932: end max_etp_tax_free;

Line 953: -- USES: hr_utility

949: /* End 8769345 */
950: --
951: -- OUT: p_message - error message containing token for maximum amount to roll over
952: --
953: -- USES: hr_utility
954: -- fnd_message
955: --
956: function check_rollover
957: (p_rollover_amount in number

Line 968: hr_utility.set_location(l_procedure,1);

964: l_message varchar2(500);
965: begin
966:
967: IF g_debug THEN
968: hr_utility.set_location(l_procedure,1);
969: hr_utility.trace('p_rollover_amount '||to_char(p_rollover_amount));
970: END IF;
971: if p_rollover_amount > p_maximum_rollover
972: then

Line 969: hr_utility.trace('p_rollover_amount '||to_char(p_rollover_amount));

965: begin
966:
967: IF g_debug THEN
968: hr_utility.set_location(l_procedure,1);
969: hr_utility.trace('p_rollover_amount '||to_char(p_rollover_amount));
970: END IF;
971: if p_rollover_amount > p_maximum_rollover
972: then
973: IF g_debug THEN

Line 974: hr_utility.trace('rollover exceeded - maximum '||to_char(p_maximum_rollover));

970: END IF;
971: if p_rollover_amount > p_maximum_rollover
972: then
973: IF g_debug THEN
974: hr_utility.trace('rollover exceeded - maximum '||to_char(p_maximum_rollover));
975: END IF;
976: fnd_message.set_name('PAY','HR_AU_SUPER_ROLL_NOT_VALID');
977: fnd_message.set_token('rollover_amount', p_maximum_rollover);
978: fnd_message.set_token('etp_component', p_etp_component);

Line 982: hr_utility.trace('message = '||l_message);

978: fnd_message.set_token('etp_component', p_etp_component);
979: p_message := fnd_message.get;
980: l_message := p_message;
981: IF g_debug THEN
982: hr_utility.trace('message = '||l_message);
983: END IF;
984: return 0;
985: else
986: return 1;

Line 1007: -- USES: hr_utility

1003: --
1004: -- OUT: p_pre01jul1983_ratio - ratio to use when calculating the pre 01 July 1983 portion of ETP
1005: -- p_post30jun1983_ratio - ratio to use when calculating the post 30 June 1983 portion of ETP
1006: --
1007: -- USES: hr_utility
1008: -- fffunc
1009: -- hr_au_holidays
1010: --
1011: function etp_prepost_ratios

Line 1090: hr_utility.set_location(l_procedure,1);

1086: p_le_etp_service_date :=null; /* bug 4177679 */
1087: l_calc_date_entered := 'Y'; /* Bug 4177679 */
1088:
1089: IF g_debug THEN
1090: hr_utility.set_location(l_procedure,1);
1091: hr_utility.trace('p_assignment_id :'||p_assignment_id);
1092: hr_utility.trace('p_hire_date :'||p_hire_date);
1093: END IF;
1094:

Line 1091: hr_utility.trace('p_assignment_id :'||p_assignment_id);

1087: l_calc_date_entered := 'Y'; /* Bug 4177679 */
1088:
1089: IF g_debug THEN
1090: hr_utility.set_location(l_procedure,1);
1091: hr_utility.trace('p_assignment_id :'||p_assignment_id);
1092: hr_utility.trace('p_hire_date :'||p_hire_date);
1093: END IF;
1094:
1095: open c_get_etp_information(p_assignment_id);

Line 1092: hr_utility.trace('p_hire_date :'||p_hire_date);

1088:
1089: IF g_debug THEN
1090: hr_utility.set_location(l_procedure,1);
1091: hr_utility.trace('p_assignment_id :'||p_assignment_id);
1092: hr_utility.trace('p_hire_date :'||p_hire_date);
1093: END IF;
1094:
1095: open c_get_etp_information(p_assignment_id);
1096: fetch c_get_etp_information

Line 1101: hr_utility.trace('l_actual_pre :'||l_actual_pre);

1097: into l_actual_pre, l_actual_post, l_calculation_date;
1098: IF c_get_etp_information%FOUND then
1099: close c_get_etp_information;
1100: IF g_debug THEN
1101: hr_utility.trace('l_actual_pre :'||l_actual_pre);
1102: hr_utility.trace('l_actual_post :'||l_actual_post);
1103: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1104: END IF;
1105: l_actual_total := l_actual_pre + l_actual_post;

Line 1102: hr_utility.trace('l_actual_post :'||l_actual_post);

1098: IF c_get_etp_information%FOUND then
1099: close c_get_etp_information;
1100: IF g_debug THEN
1101: hr_utility.trace('l_actual_pre :'||l_actual_pre);
1102: hr_utility.trace('l_actual_post :'||l_actual_post);
1103: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1104: END IF;
1105: l_actual_total := l_actual_pre + l_actual_post;
1106: END IF;

Line 1103: hr_utility.trace('l_calculation_date :'||l_calculation_date);

1099: close c_get_etp_information;
1100: IF g_debug THEN
1101: hr_utility.trace('l_actual_pre :'||l_actual_pre);
1102: hr_utility.trace('l_actual_post :'||l_actual_post);
1103: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1104: END IF;
1105: l_actual_total := l_actual_pre + l_actual_post;
1106: END IF;
1107: IF g_debug THEN

Line 1108: hr_utility.trace('l_calculation_date :'||l_calculation_date);

1104: END IF;
1105: l_actual_total := l_actual_pre + l_actual_post;
1106: END IF;
1107: IF g_debug THEN
1108: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1109: END IF;
1110:
1111: IF l_actual_pre is not null and l_actual_post is not null
1112: and l_term_form_called = 'N' then

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

1112: and l_term_form_called = 'N' then
1113:
1114: -- Use the pre/post days for the calculation of the pre/post ratios.
1115: IF g_debug THEN
1116: hr_utility.set_location(l_procedure, 30);
1117: END IF;
1118: p_pre01jul1983_days := l_actual_pre;
1119: p_post30jun1983_days := l_actual_post;
1120: IF (p_pre01jul1983_days = 0 and p_post30jun1983_days = 0) then

Line 1135: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);

1131: p_etp_service_date := l_calculation_date;
1132: p_le_etp_service_date := l_calculation_date; /* Bug 4177679 */
1133: END IF;
1134: IF g_debug THEN
1135: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1136: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1137: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1138: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1139: END IF;

Line 1136: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);

1132: p_le_etp_service_date := l_calculation_date; /* Bug 4177679 */
1133: END IF;
1134: IF g_debug THEN
1135: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1136: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1137: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1138: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1139: END IF;
1140: return 1;

Line 1137: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);

1133: END IF;
1134: IF g_debug THEN
1135: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1136: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1137: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1138: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1139: END IF;
1140: return 1;
1141:

Line 1138: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);

1134: IF g_debug THEN
1135: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1136: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1137: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1138: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1139: END IF;
1140: return 1;
1141:
1142: END IF;

Line 1154: hr_utility.trace('p_hire_date : '||p_hire_date);

1150: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1151: p_le_etp_service_date := null; /* Bug 4177679 */
1152:
1153: IF g_debug THEN
1154: hr_utility.trace('p_hire_date : '||p_hire_date);
1155: END IF;
1156: END IF;
1157:
1158: IF l_term_form_called = 'Y' and p_hire_date is not null then

Line 1167: hr_utility.trace('l_calculation_date :'||l_calculation_date);

1163: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1164: p_le_etp_service_date := null; /* Bug 4177679 */
1165: END IF;
1166: IF g_debug THEN
1167: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1168: END IF;
1169: /* End of Bug#2819479 */
1170:
1171: --

Line 1177: hr_utility.set_location(l_procedure, 15);

1173: --
1174: if l_calculation_date >= l_pre_date
1175: then
1176: IF g_debug THEN
1177: hr_utility.set_location(l_procedure, 15);
1178: END IF;
1179: p_pre01jul1983_days := 0;
1180: p_pre01jul1983_ratio := 0;
1181: p_post30jun1983_ratio := 1;

Line 1197: hr_utility.set_location(l_procedure, 16);

1193: --
1194: elsif p_termination_date <= l_post_date
1195: then
1196: IF g_debug THEN
1197: hr_utility.set_location(l_procedure, 16);
1198: END IF;
1199: p_post30jun1983_days := 0;
1200: p_post30jun1983_ratio := 0;
1201: p_pre01jul1983_ratio := 1;

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

1209: end if;
1210: return 1;
1211: else
1212: IF g_debug THEN
1213: hr_utility.set_location(l_procedure, 20);
1214: END IF;
1215: --
1216: -- Calculate the number of days worked for pre, post and total
1217: --

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

1231: --
1232: if (l_actual_pre < 0) or (l_actual_post < 0) or (l_actual_total < 0)
1233: then
1234: IF g_debug THEN
1235: hr_utility.set_location(l_procedure, 21);
1236: END IF;
1237: return 0;
1238: end if;
1239: --

Line 1252: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);

1248: p_le_etp_service_date := l_calculation_date;
1249: end if;
1250:
1251: IF g_debug THEN
1252: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1253: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1254: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1255: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1256: END IF;

Line 1253: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);

1249: end if;
1250:
1251: IF g_debug THEN
1252: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1253: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1254: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1255: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1256: END IF;
1257: return 1;

Line 1254: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);

1250:
1251: IF g_debug THEN
1252: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1253: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1254: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1255: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1256: END IF;
1257: return 1;
1258:

Line 1255: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);

1251: IF g_debug THEN
1252: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1253: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1254: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1255: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1256: END IF;
1257: return 1;
1258:
1259: END IF;

Line 1278: -- USES: hr_utility

1274: -- p_accrual_plan_id - id of the particular long service leave accrual plan
1275: --
1276: -- OUT: p_eligibility_years - number of years until eligible
1277: --
1278: -- USES: hr_utility
1279: --
1280: --
1281: function term_lsl_eligibility_years
1282: (p_date_earned in date

Line 1319: hr_utility.set_location(l_procedure, 10);

1315: --
1316: begin
1317:
1318: IF g_debug THEN
1319: hr_utility.set_location(l_procedure, 10);
1320: END IF;
1321: open csr_get_years(p_date_earned, p_accrual_plan_id);
1322: fetch csr_get_years
1323: into l_years;

Line 1334: hr_utility.trace('LSL eligibility years : '||to_char(l_years));

1330: close csr_get_years;
1331: --
1332: p_eligibility_years := l_years;
1333: IF g_debug THEN
1334: hr_utility.trace('LSL eligibility years : '||to_char(l_years));
1335: END IF;
1336: return 1;
1337: --
1338: end term_lsl_eligibility_years;

Line 1545: g_debug := hr_utility.debug_enabled;

1541: p_pre_tax_spread := 0; /*Bug 4474896*/
1542: p_pre_tax_fixed := 0; /*Bug 4474896*/
1543: p_pre_tax_prog := 0; /*Bug 4474896*/
1544: i := 1;
1545: g_debug := hr_utility.debug_enabled;
1546: l_flag := -1;
1547:
1548: OPEN c_get_payroll_effective_date; /*Bug 4538463*/
1549: FETCH c_get_payroll_effective_date INTO l_eff_date; /*Bug 4538463*/

Line 1553: hr_utility.set_location(' '||l_procedure, 10);

1549: FETCH c_get_payroll_effective_date INTO l_eff_date; /*Bug 4538463*/
1550: CLOSE c_get_payroll_effective_date; /*Bug 4538463*/
1551:
1552: IF g_debug THEN
1553: hr_utility.set_location(' '||l_procedure, 10);
1554: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);

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

1550: CLOSE c_get_payroll_effective_date; /*Bug 4538463*/
1551:
1552: IF g_debug THEN
1553: hr_utility.set_location(' '||l_procedure, 10);
1554: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);

Line 1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);

1551:
1552: IF g_debug THEN
1553: hr_utility.set_location(' '||l_procedure, 10);
1554: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);

Line 1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);

1552: IF g_debug THEN
1553: hr_utility.set_location(' '||l_procedure, 10);
1554: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);

Line 1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);

1553: hr_utility.set_location(' '||l_procedure, 10);
1554: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);

Line 1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);

1554: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1562: hr_utility.set_location(' p_case ' ||p_case,10);

Line 1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);

1555: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1562: hr_utility.set_location(' p_case ' ||p_case,10);
1563: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);

Line 1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);

1556: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1562: hr_utility.set_location(' p_case ' ||p_case,10);
1563: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1564: END IF;

Line 1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);

1557: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1562: hr_utility.set_location(' p_case ' ||p_case,10);
1563: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1564: END IF;
1565:

Line 1562: hr_utility.set_location(' p_case ' ||p_case,10);

1558: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1562: hr_utility.set_location(' p_case ' ||p_case,10);
1563: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1564: END IF;
1565:
1566: -- Find the Financial Year Start and End Dates

Line 1563: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);

1559: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1560: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1561: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1562: hr_utility.set_location(' p_case ' ||p_case,10);
1563: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1564: END IF;
1565:
1566: -- Find the Financial Year Start and End Dates
1567: /*Bug 4538463 - Modified logic to get financial year start date and end dates

Line 1597: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);

1593:
1594: -- Use the cursor to check whether any periods in this Financial Year got processed
1595: -- before this RUN
1596: IF g_debug THEN
1597: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1598: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1599:
1600: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1601: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);

Line 1598: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);

1594: -- Use the cursor to check whether any periods in this Financial Year got processed
1595: -- before this RUN
1596: IF g_debug THEN
1597: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1598: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1599:
1600: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1601: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);
1602: END IF;

Line 1600: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);

1596: IF g_debug THEN
1597: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1598: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1599:
1600: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1601: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);
1602: END IF;
1603:
1604: /*Bug 4538463 - Use the cursor below to check if this is the first run for the assignment in the

Line 1601: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);

1597: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1598: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1599:
1600: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1601: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);
1602: END IF;
1603:
1604: /*Bug 4538463 - Use the cursor below to check if this is the first run for the assignment in the
1605: current financial year*/

Line 1623: hr_utility.trace('Inside 1');

1619: CLOSE c_get_prev_year_max_asg_act_id;
1620: IF nvl(l_asg_act_id,-99999) <> -99999 THEN /*Bug 4538463*/
1621: l_flag := 1; /* Flag is set to 1 when we take YTD earnings for previous year for the current legal employer*/
1622: END IF;
1623: hr_utility.trace('Inside 1');
1624: ELSE
1625: OPEN c_get_pre_le_max_asg_act_id(p_assignment_id, p_business_group_id, l_fin_start_date, l_eff_date);
1626: FETCH c_get_pre_le_max_asg_act_id into l_asg_act_id, l_tax_unit_id, l_payroll_id, l_pay_eff_date;
1627: CLOSE c_get_pre_le_max_asg_act_id;

Line 1631: hr_utility.trace('Inside 2');

1627: CLOSE c_get_pre_le_max_asg_act_id;
1628: IF nvl(l_asg_act_id,-99999) <> -99999 THEN /*Bug 4538463*/
1629: l_flag := 2; /* Flag is set to 2 when we take YTD earnings for current year for the previous legal employer*/
1630: END IF;
1631: hr_utility.trace('Inside 2');
1632: END IF;
1633:
1634: IF l_flag = -1 THEN
1635: OPEN c_get_pre_le_max_asg_act_id(p_assignment_id, p_business_group_id, l_prev_yr_fin_start_date, l_prev_yr_fin_end_date);

Line 1640: hr_utility.trace('Inside 3');

1636: FETCH c_get_pre_le_max_asg_act_id into l_asg_act_id, l_tax_unit_id, l_payroll_id, l_pay_eff_date;
1637: CLOSE c_get_pre_le_max_asg_act_id;
1638: l_flag := 3; /* Bug 4538463 - Flag is set to 3 when we take YTD earnings for previous year for the legal employer effective on
1639: on the last run of year*/
1640: hr_utility.trace('Inside 3');
1641: END IF;
1642:
1643: IF g_debug THEN
1644: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);

Line 1644: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);

1640: hr_utility.trace('Inside 3');
1641: END IF;
1642:
1643: IF g_debug THEN
1644: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1645: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1646: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1647: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1648: END IF;

Line 1645: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);

1641: END IF;
1642:
1643: IF g_debug THEN
1644: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1645: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1646: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1647: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1648: END IF;
1649:

Line 1646: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);

1642:
1643: IF g_debug THEN
1644: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1645: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1646: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1647: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1648: END IF;
1649:
1650:

Line 1647: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);

1643: IF g_debug THEN
1644: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1645: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1646: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1647: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1648: END IF;
1649:
1650:
1651: IF nvl(l_asg_act_id,-99999) = -99999 THEN

Line 1661: hr_utility.set_location('p_case: '|| p_case, 40);

1657: Average_Earnings will not be calculated.
1658: */
1659: p_case := 'POPULATE_MSG';
1660: IF g_debug THEN
1661: hr_utility.set_location('p_case: '|| p_case, 40);
1662: END IF;
1663: RETURN 110;
1664:
1665: ELSE

Line 1691: hr_utility.set_location('p_paid_periods: '|| p_paid_periods, 50);

1687:
1688:
1689:
1690: IF g_debug THEN
1691: hr_utility.set_location('p_paid_periods: '|| p_paid_periods, 50);
1692: END IF;
1693:
1694:
1695: IF NOT g_ytd_def_bals_populated THEN

Line 1751: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);

1747: and g_ytd_bals(i).balance_name = 'Earnings_Standard'
1748: THEN
1749: p_earnings_standard := nvl(g_ytd_result_table(i).balance_value,0);
1750: IF g_debug THEN
1751: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);
1752: END IF;
1753: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1754: and g_ytd_bals(i).balance_name = 'Pre Tax Spread Deductions'
1755: THEN

Line 1758: hr_utility.set_location('p_pre_tax_spread_deductions: '||p_pre_tax_spread, 60);

1754: and g_ytd_bals(i).balance_name = 'Pre Tax Spread Deductions'
1755: THEN
1756: p_pre_tax_spread := nvl(g_ytd_result_table(i).balance_value,0);
1757: IF g_debug THEN
1758: hr_utility.set_location('p_pre_tax_spread_deductions: '||p_pre_tax_spread, 60);
1759: END IF;
1760:
1761: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1762: and g_ytd_bals(i).balance_name = 'Pre Tax Fixed Deductions' and p_use_tax_flag = 'Y'

Line 1767: hr_utility.set_location('p_pre_tax_fixed_deductions: '||p_pre_tax_fixed, 60);

1763: /*bug4363057*/
1764: THEN
1765: p_pre_tax_fixed := nvl(g_ytd_result_table(i).balance_value,0);
1766: IF g_debug THEN
1767: hr_utility.set_location('p_pre_tax_fixed_deductions: '||p_pre_tax_fixed, 60);
1768: END IF;
1769: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1770: and g_ytd_bals(i).balance_name = 'Pre Tax Progressive Deductions' and p_use_tax_flag = 'Y'
1771: /*bug4363057*/

Line 1775: hr_utility.set_location('p_pre_tax_progressive_deductions: '||p_pre_tax_prog, 60);

1771: /*bug4363057*/
1772: THEN
1773: p_pre_tax_prog := nvl(g_ytd_result_table(i).balance_value,0);
1774: IF g_debug THEN
1775: hr_utility.set_location('p_pre_tax_progressive_deductions: '||p_pre_tax_prog, 60);
1776: END IF;
1777:
1778: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1779: and g_ytd_bals(i).balance_name = 'Earnings_Leave_Loading' and p_use_tax_flag = 'Y'

Line 1784: hr_utility.set_location('l_earnings_leave_loading: '||l_leave_loading, 60);

1780: /*bug8725341*/
1781: THEN
1782: l_leave_loading := nvl(g_ytd_result_table(i).balance_value,0);
1783: IF g_debug THEN
1784: hr_utility.set_location('l_earnings_leave_loading: '||l_leave_loading, 60);
1785: END IF;
1786:
1787:
1788: END IF;

Line 1836: hr_utility.set_location(' Entering::'||l_proc,1);

1832: AND pap.accrual_plan_element_type_id = pet.element_type_id
1833: AND pap.accrual_category = p_plan_category ;
1834:
1835: BEGIN
1836: hr_utility.set_location(' Entering::'||l_proc,1);
1837: l_hours_flag := 'N';
1838: l_days_flag := 'N';
1839: l_hours := 0;
1840: l_error := 'N';

Line 1862: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);

1858: end loop;
1859:
1860: IF l_error = 'Y'
1861: THEN
1862: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
1863: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1864: hr_utility.raise_error;
1865: END IF;
1866:

Line 1863: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');

1859:
1860: IF l_error = 'Y'
1861: THEN
1862: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
1863: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1864: hr_utility.raise_error;
1865: END IF;
1866:
1867: hr_utility.set_location('Leaving:'||l_proc,2);

Line 1864: hr_utility.raise_error;

1860: IF l_error = 'Y'
1861: THEN
1862: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
1863: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1864: hr_utility.raise_error;
1865: END IF;
1866:
1867: hr_utility.set_location('Leaving:'||l_proc,2);
1868:

Line 1867: hr_utility.set_location('Leaving:'||l_proc,2);

1863: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1864: hr_utility.raise_error;
1865: END IF;
1866:
1867: hr_utility.set_location('Leaving:'||l_proc,2);
1868:
1869: RETURN l_hours;
1870:
1871: -- EXCEPTION

Line 1873: -- hr_utility.set_location('Leaving:'||l_proc,99);

1869: RETURN l_hours;
1870:
1871: -- EXCEPTION
1872: -- WHEN OTHERS THEN
1873: -- hr_utility.set_location('Leaving:'||l_proc,99);
1874: -- RETURN NULL;
1875: END get_total_accrual_hours;
1876:
1877: --------------------------------------------------

Line 1952: hr_utility.set_location(' '||l_procedure, 10);

1948: BEGIN
1949:
1950: l_procedure := 'calculate_etp_tax';
1951: IF g_debug THEN
1952: hr_utility.set_location(' '||l_procedure, 10);
1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

Line 1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);

1949:
1950: l_procedure := 'calculate_etp_tax';
1951: IF g_debug THEN
1952: hr_utility.set_location(' '||l_procedure, 10);
1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

Line 1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);

1950: l_procedure := 'calculate_etp_tax';
1951: IF g_debug THEN
1952: hr_utility.set_location(' '||l_procedure, 10);
1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

Line 1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);

1951: IF g_debug THEN
1952: hr_utility.set_location(' '||l_procedure, 10);
1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

Line 1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

1952: hr_utility.set_location(' '||l_procedure, 10);
1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1960: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

Line 1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

1953: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1960: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1961:

Line 1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

1954: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1960: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1961:
1962: END IF;

Line 1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

1955: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1960: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1961:
1962: END IF;
1963:

Line 1960: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

1956: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1957: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1958: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1959: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1960: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1961:
1962: END IF;
1963:
1964: lv_etp_tax:=0;

Line 2003: hr_utility.set_location('lv_user_table ' ||lv_user_table,10);

1999: FETCH csr_get_etp_tax into lv_etp_tax;
2000: CLOSE csr_get_etp_tax;
2001:
2002: IF g_debug THEN
2003: hr_utility.set_location('lv_user_table ' ||lv_user_table,10);
2004: hr_utility.set_location('RETURN lv_etp_tax '||lv_etp_tax,10);
2005: END IF;
2006: RETURN lv_etp_tax;
2007:

Line 2004: hr_utility.set_location('RETURN lv_etp_tax '||lv_etp_tax,10);

2000: CLOSE csr_get_etp_tax;
2001:
2002: IF g_debug THEN
2003: hr_utility.set_location('lv_user_table ' ||lv_user_table,10);
2004: hr_utility.set_location('RETURN lv_etp_tax '||lv_etp_tax,10);
2005: END IF;
2006: RETURN lv_etp_tax;
2007:
2008: END calculate_etp_tax;

Line 2027: hr_utility.set_location(' '||l_procedure, 10);

2023: BEGIN
2024:
2025: l_procedure := 'get_fin_year_end';
2026: IF g_debug THEN
2027: hr_utility.set_location(' '||l_procedure, 10);
2028: hr_utility.set_location('IN p_date ' ||p_date,10);
2029: END IF;
2030:
2031: ld_fin_year_end := to_date('01/01/1900','DD/MM/YYYY');

Line 2028: hr_utility.set_location('IN p_date ' ||p_date,10);

2024:
2025: l_procedure := 'get_fin_year_end';
2026: IF g_debug THEN
2027: hr_utility.set_location(' '||l_procedure, 10);
2028: hr_utility.set_location('IN p_date ' ||p_date,10);
2029: END IF;
2030:
2031: ld_fin_year_end := to_date('01/01/1900','DD/MM/YYYY');
2032:

Line 2043: hr_utility.set_location('RETURN ld_fin_year_end '||ld_fin_year_end,10);

2039: ld_fin_year_end := ADD_MONTHS(to_date('30/06/'||to_char(p_date,'YYYY'),'DD/MM/YYYY'),12);
2040: END IF;
2041:
2042: IF g_debug THEN
2043: hr_utility.set_location('RETURN ld_fin_year_end '||ld_fin_year_end,10);
2044: END IF;
2045:
2046: RETURN ld_fin_year_end;
2047:

Line 2106: hr_utility.set_location(' '||l_procedure, 10);

2102: BEGIN
2103:
2104: l_procedure := 'get_prev_age';
2105: IF g_debug THEN
2106: hr_utility.set_location(' '||l_procedure, 10);
2107: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);
2108: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2109: END IF;
2110:

Line 2107: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);

2103:
2104: l_procedure := 'get_prev_age';
2105: IF g_debug THEN
2106: hr_utility.set_location(' '||l_procedure, 10);
2107: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);
2108: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2109: END IF;
2110:
2111: ln_prev_age :=0;

Line 2108: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);

2104: l_procedure := 'get_prev_age';
2105: IF g_debug THEN
2106: hr_utility.set_location(' '||l_procedure, 10);
2107: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);
2108: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2109: END IF;
2110:
2111: ln_prev_age :=0;
2112:

Line 2118: hr_utility.set_location('RETURN ln_prev_age '||ln_prev_age,10);

2114: fetch csr_get_prev_age into ln_prev_age;
2115: close csr_get_prev_age;
2116:
2117: IF g_debug THEN
2118: hr_utility.set_location('RETURN ln_prev_age '||ln_prev_age,10);
2119: END IF;
2120:
2121: RETURN ln_prev_age;
2122:

Line 2166: hr_utility.set_location(' '||l_procedure, 10);

2162: BEGIN
2163:
2164: l_procedure := 'au_check_trans';
2165: IF g_debug THEN
2166: hr_utility.set_location(' '||l_procedure, 10);
2167: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2168: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
2169: END IF;
2170:

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

2163:
2164: l_procedure := 'au_check_trans';
2165: IF g_debug THEN
2166: hr_utility.set_location(' '||l_procedure, 10);
2167: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2168: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
2169: END IF;
2170:
2171: lv_check_trans :='N';

Line 2168: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);

2164: l_procedure := 'au_check_trans';
2165: IF g_debug THEN
2166: hr_utility.set_location(' '||l_procedure, 10);
2167: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2168: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
2169: END IF;
2170:
2171: lv_check_trans :='N';
2172: ln_tmp := 0 ;

Line 2184: hr_utility.set_location('RETURN lv_check_trans '||lv_check_trans,10);

2180: end if;
2181: close csr_check_trans;
2182:
2183: IF g_debug THEN
2184: hr_utility.set_location('RETURN lv_check_trans '||lv_check_trans,10);
2185: END IF;
2186:
2187: RETURN lv_check_trans;
2188:

Line 2291: hr_utility.set_location(l_procedure, 1);

2287:
2288: begin
2289: --
2290: IF g_debug THEN
2291: hr_utility.set_location(l_procedure, 1);
2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);

Line 2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);

2288: begin
2289: --
2290: IF g_debug THEN
2291: hr_utility.set_location(l_procedure, 1);
2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);

Line 2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);

2289: --
2290: IF g_debug THEN
2291: hr_utility.set_location(l_procedure, 1);
2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);

Line 2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);

2290: IF g_debug THEN
2291: hr_utility.set_location(l_procedure, 1);
2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);

Line 2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);

2291: hr_utility.set_location(l_procedure, 1);
2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);

Line 2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);

2292: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);

Line 2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);

2293: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);
2301: hr_utility.set_location('p_all_etp_payments '||p_all_etp_payments, 1);

Line 2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);

2294: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);
2301: hr_utility.set_location('p_all_etp_payments '||p_all_etp_payments, 1);
2302: END IF;

Line 2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);

2295: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);
2301: hr_utility.set_location('p_all_etp_payments '||p_all_etp_payments, 1);
2302: END IF;
2303:

Line 2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);

2296: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);
2301: hr_utility.set_location('p_all_etp_payments '||p_all_etp_payments, 1);
2302: END IF;
2303:
2304: l_max_lump_d := p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;

Line 2301: hr_utility.set_location('p_all_etp_payments '||p_all_etp_payments, 1);

2297: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
2298: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
2299: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
2300: hr_utility.set_location('p_etp_all_pay_ytd '||p_etp_all_pay_ytd, 1);
2301: hr_utility.set_location('p_all_etp_payments '||p_all_etp_payments, 1);
2302: END IF;
2303:
2304: l_max_lump_d := p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;
2305:

Line 2307: hr_utility.set_location('l_max_lump_d '||l_max_lump_d, 10);

2303:
2304: l_max_lump_d := p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;
2305:
2306: IF g_debug THEN
2307: hr_utility.set_location('l_max_lump_d '||l_max_lump_d, 10);
2308: END IF;
2309:
2310: FOR rec in csr_get_etp_entry LOOP
2311: l_count := l_count + rec.etp_no;

Line 2318: hr_utility.set_location('l_case is TRUE', 10);

2314: end if;
2315: END LOOP;
2316:
2317: IF l_case THEN
2318: hr_utility.set_location('l_case is TRUE', 10);
2319: END IF;
2320:
2321: open csr_get_curr_atd;
2322: fetch csr_get_curr_atd into l_acutal_termination_date;

Line 2331: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);

2327: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
2328: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2329:
2330: IF g_debug THEN
2331: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
2332: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
2333: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
2334: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
2335: END IF;

Line 2332: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);

2328: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2329:
2330: IF g_debug THEN
2331: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
2332: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
2333: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
2334: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
2335: END IF;
2336:

Line 2333: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);

2329:
2330: IF g_debug THEN
2331: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
2332: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
2333: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
2334: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
2335: END IF;
2336:
2337: IF l_year_end_atd = l_year_end_paid THEN -- paid in the termination year

Line 2334: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);

2330: IF g_debug THEN
2331: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
2332: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
2333: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
2334: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
2335: END IF;
2336:
2337: IF l_year_end_atd = l_year_end_paid THEN -- paid in the termination year
2338:

Line 2351: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);

2347: l_max := l_max_lump_d - p_etp_all_pay_ytd;
2348: else
2349:
2350: IF g_debug THEN
2351: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2352: END IF;
2353:
2354: IF (pay_au_paye_ff.g_lumpsum_d + p_etp_all_pay_ytd) < l_max_lump_d THEN
2355: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+p_etp_all_pay_ytd);

Line 2365: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);

2361:
2362: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2363:
2364: IF g_debug THEN
2365: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2366: END IF;
2367:
2368: END IF;
2369:

Line 2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);

2380: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then
2381: l_max := l_max_lump_d;
2382: else
2383: IF g_debug THEN
2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2385: END IF;
2386:
2387: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2388: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;

Line 2398: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);

2394:
2395: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2396:
2397: IF g_debug THEN
2398: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2399: END IF;
2400:
2401: END IF;
2402: END IF;

Line 2423: hr_utility.set_location('l_add '||l_add, 50);

2419:
2420: l_tot_prev_etp := l_tot_prev_etp + l_prev_etp;
2421:
2422: IF g_debug THEN
2423: hr_utility.set_location('l_add '||l_add, 50);
2424: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 50);
2425: hr_utility.set_location('l_prev_etp '||l_prev_etp, 50);
2426: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 50);
2427: END IF;

Line 2424: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 50);

2420: l_tot_prev_etp := l_tot_prev_etp + l_prev_etp;
2421:
2422: IF g_debug THEN
2423: hr_utility.set_location('l_add '||l_add, 50);
2424: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 50);
2425: hr_utility.set_location('l_prev_etp '||l_prev_etp, 50);
2426: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 50);
2427: END IF;
2428:

Line 2425: hr_utility.set_location('l_prev_etp '||l_prev_etp, 50);

2421:
2422: IF g_debug THEN
2423: hr_utility.set_location('l_add '||l_add, 50);
2424: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 50);
2425: hr_utility.set_location('l_prev_etp '||l_prev_etp, 50);
2426: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 50);
2427: END IF;
2428:
2429: l_add := l_add + 12;

Line 2426: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 50);

2422: IF g_debug THEN
2423: hr_utility.set_location('l_add '||l_add, 50);
2424: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 50);
2425: hr_utility.set_location('l_prev_etp '||l_prev_etp, 50);
2426: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 50);
2427: END IF;
2428:
2429: l_add := l_add + 12;
2430:

Line 2449: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);

2445: l_max := l_max_lump_d - l_tot_prev_etp;
2446: else
2447:
2448: IF g_debug THEN
2449: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2450: END IF;
2451:
2452: IF (pay_au_paye_ff.g_lumpsum_d + l_tot_prev_etp) < l_max_lump_d THEN
2453: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+l_tot_prev_etp);

Line 2463: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);

2459:
2460: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2461:
2462: IF g_debug THEN
2463: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2464: END IF;
2465:
2466: END IF;
2467:

Line 2485: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);

2481: l_max := l_max_lump_d;
2482: else
2483:
2484: IF g_debug THEN
2485: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2486: END IF;
2487:
2488: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2489: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;

Line 2498: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);

2494:
2495: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2496:
2497: IF g_debug THEN
2498: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2499: END IF;
2500:
2501: END IF;
2502:

Line 2510: hr_utility.set_location('l_max '||l_max, 90);

2506:
2507: l_lump_sum_d := least(l_max, p_all_etp_payments);
2508:
2509: IF g_debug THEN
2510: hr_utility.set_location('l_max '||l_max, 90);
2511: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);
2512: END IF;
2513:
2514: return l_lump_sum_d;

Line 2511: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);

2507: l_lump_sum_d := least(l_max, p_all_etp_payments);
2508:
2509: IF g_debug THEN
2510: hr_utility.set_location('l_max '||l_max, 90);
2511: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);
2512: END IF;
2513:
2514: return l_lump_sum_d;
2515:

Line 2663: hr_utility.set_location('Entering '||l_procedure, 10);

2659:
2660: l_procedure := 'calculate_etp_tax_2010';
2661:
2662: IF g_debug THEN
2663: hr_utility.set_location('Entering '||l_procedure, 10);
2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);

Line 2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);

2660: l_procedure := 'calculate_etp_tax_2010';
2661:
2662: IF g_debug THEN
2663: hr_utility.set_location('Entering '||l_procedure, 10);
2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

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

2661:
2662: IF g_debug THEN
2663: hr_utility.set_location('Entering '||l_procedure, 10);
2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

Line 2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);

2662: IF g_debug THEN
2663: hr_utility.set_location('Entering '||l_procedure, 10);
2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

Line 2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);

2663: hr_utility.set_location('Entering '||l_procedure, 10);
2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

Line 2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

2664: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

Line 2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

2665: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);

Line 2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

2666: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);

Line 2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

2667: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);

Line 2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

2668: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);

Line 2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);

2669: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);

Line 2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);

2670: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);

Line 2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);

2671: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);
2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);

Line 2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);

2672: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);
2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);
2680: hr_utility.set_location('IN p_etp_tran_ppt_run ' ||p_etp_tran_ppt_run,10);

Line 2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);

2673: hr_utility.set_location('IN p_etp_notran_noppt_ytd ' ||p_etp_notran_noppt_ytd,10);
2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);
2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);
2680: hr_utility.set_location('IN p_etp_tran_ppt_run ' ||p_etp_tran_ppt_run,10);
2681: END IF;

Line 2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);

2674: hr_utility.set_location('IN p_etp_notran_ppt_ytd ' ||p_etp_notran_ppt_ytd,10);
2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);
2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);
2680: hr_utility.set_location('IN p_etp_tran_ppt_run ' ||p_etp_tran_ppt_run,10);
2681: END IF;
2682:

Line 2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);

2675: hr_utility.set_location('IN p_etp_tran_noppt_ytd ' ||p_etp_tran_noppt_ytd,10);
2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);
2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);
2680: hr_utility.set_location('IN p_etp_tran_ppt_run ' ||p_etp_tran_ppt_run,10);
2681: END IF;
2682:
2683: lv_medicare_levy := p_medicare_levy;

Line 2680: hr_utility.set_location('IN p_etp_tran_ppt_run ' ||p_etp_tran_ppt_run,10);

2676: hr_utility.set_location('IN p_etp_tran_ppt_ytd ' ||p_etp_tran_ppt_ytd,10);
2677: hr_utility.set_location('IN p_etp_notran_noppt_run ' ||p_etp_notran_noppt_run,10);
2678: hr_utility.set_location('IN p_etp_notran_ppt_run ' ||p_etp_notran_ppt_run,10);
2679: hr_utility.set_location('IN p_etp_tran_noppt_run ' ||p_etp_tran_noppt_run,10);
2680: hr_utility.set_location('IN p_etp_tran_ppt_run ' ||p_etp_tran_ppt_run,10);
2681: END IF;
2682:
2683: lv_medicare_levy := p_medicare_levy;
2684:

Line 2696: if g_debug then hr_utility.set_location('death user table '||ld_user_table, 1); end if;

2692: lv_medicare_levy:=0;
2693: END IF;
2694: END IF;
2695:
2696: if g_debug then hr_utility.set_location('death user table '||ld_user_table, 1); end if;
2697:
2698: ELSE
2699:
2700: IF (p_etp_notran_noppt_run+p_etp_notran_ppt_run) <> 0 THEN

Line 2707: if g_debug then hr_utility.set_location('notran user table '||ln_user_table, 1); end if;

2703: ELSIF p_over_pres_age ='Y' THEN
2704: ln_user_table := 'TAX_SCALE_NON_TRANS_OVER_PREV_AGE';
2705: END IF;
2706:
2707: if g_debug then hr_utility.set_location('notran user table '||ln_user_table, 1); end if;
2708:
2709: END IF;
2710:
2711: IF (p_etp_tran_noppt_run+p_etp_tran_ppt_run) <> 0 THEN

Line 2718: if g_debug then hr_utility.set_location('tran user table '||lt_user_table, 1); end if;

2714: ELSIF p_over_pres_age ='Y' THEN
2715: lt_user_table := 'TAX_SCALE_TRANS_OVER_PREV_AGE';
2716: END IF;
2717:
2718: if g_debug then hr_utility.set_location('tran user table '||lt_user_table, 1); end if;
2719:
2720: END IF;
2721:
2722: END IF;

Line 2734: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 30);

2730: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
2731: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2732:
2733: IF g_debug THEN
2734: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 30);
2735: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 30);
2736: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 30);
2737: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 30);
2738: END IF;

Line 2735: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 30);

2731: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
2732:
2733: IF g_debug THEN
2734: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 30);
2735: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 30);
2736: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 30);
2737: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 30);
2738: END IF;
2739:

Line 2736: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 30);

2732:
2733: IF g_debug THEN
2734: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 30);
2735: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 30);
2736: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 30);
2737: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 30);
2738: END IF;
2739:
2740: IF l_year_end_atd = l_year_end_paid THEN

Line 2737: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 30);

2733: IF g_debug THEN
2734: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 30);
2735: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 30);
2736: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 30);
2737: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 30);
2738: END IF;
2739:
2740: IF l_year_end_atd = l_year_end_paid THEN
2741:

Line 2750: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 41); end if;

2746: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ld_user_table,p_etp_notran_noppt_run,lv_medicare_levy);
2747: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt;
2748: CLOSE csr_get_etp_tax;
2749:
2750: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 41); end if;
2751:
2752: ELSIF p_etp_notran_noppt_run <> 0 and p_etp_notran_noppt_run < p_etp_notran_noppt_ytd THEN
2753:
2754: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ld_user_table,p_etp_notran_noppt_ytd,lv_medicare_levy);

Line 2763: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 42);

2759: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt_prev;
2760: CLOSE csr_get_etp_tax;
2761:
2762: IF g_debug THEN
2763: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 42);
2764: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 42);
2765: END IF;
2766:
2767: l_etp_tax_notran_noppt := l_etp_tax_notran_noppt_ytd - l_etp_tax_notran_noppt_prev;

Line 2764: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 42);

2760: CLOSE csr_get_etp_tax;
2761:
2762: IF g_debug THEN
2763: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 42);
2764: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 42);
2765: END IF;
2766:
2767: l_etp_tax_notran_noppt := l_etp_tax_notran_noppt_ytd - l_etp_tax_notran_noppt_prev;
2768:

Line 2780: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 51); end if;

2776: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ln_user_table,p_etp_notran_noppt_run,lv_medicare_levy);
2777: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt;
2778: CLOSE csr_get_etp_tax;
2779:
2780: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 51); end if;
2781:
2782: ELSIF p_etp_notran_ppt_run <> 0 THEN
2783:
2784: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ln_user_table,(p_etp_notran_noppt_ytd+p_etp_notran_ppt_ytd),lv_medicare_levy);

Line 2793: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 52);

2789: FETCH csr_get_etp_tax into l_etp_tax_notran_ppt_prev;
2790: CLOSE csr_get_etp_tax;
2791:
2792: IF g_debug THEN
2793: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 52);
2794: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 52);
2795: END IF;
2796:
2797: l_etp_tax_notran_ppt := l_etp_tax_notran_ppt_ytd - l_etp_tax_notran_ppt_prev;

Line 2794: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 52);

2790: CLOSE csr_get_etp_tax;
2791:
2792: IF g_debug THEN
2793: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 52);
2794: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 52);
2795: END IF;
2796:
2797: l_etp_tax_notran_ppt := l_etp_tax_notran_ppt_ytd - l_etp_tax_notran_ppt_prev;
2798:

Line 2809: if g_debug then hr_utility.set_location('l_etp_tax_tran_noppt '||l_etp_tax_tran_noppt, 61); end if;

2805: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,lt_user_table,p_etp_tran_noppt_run,lv_medicare_levy);
2806: FETCH csr_get_etp_tax into l_etp_tax_tran_noppt;
2807: CLOSE csr_get_etp_tax;
2808:
2809: if g_debug then hr_utility.set_location('l_etp_tax_tran_noppt '||l_etp_tax_tran_noppt, 61); end if;
2810:
2811: ELSIF p_etp_tran_ppt_run <> 0 THEN
2812:
2813: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,lt_user_table,(p_etp_tran_noppt_ytd+p_etp_tran_ppt_ytd),lv_medicare_levy);

Line 2822: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 62);

2818: FETCH csr_get_etp_tax into l_etp_tax_tran_ppt_prev;
2819: CLOSE csr_get_etp_tax;
2820:
2821: IF g_debug THEN
2822: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 62);
2823: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 62);
2824: END IF;
2825:
2826: l_etp_tax_tran_ppt := l_etp_tax_tran_ppt_ytd - l_etp_tax_tran_ppt_prev;

Line 2823: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 62);

2819: CLOSE csr_get_etp_tax;
2820:
2821: IF g_debug THEN
2822: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 62);
2823: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 62);
2824: END IF;
2825:
2826: l_etp_tax_tran_ppt := l_etp_tax_tran_ppt_ytd - l_etp_tax_tran_ppt_prev;
2827:

Line 2852: hr_utility.set_location('l_notran_noppt_prev '||l_notran_noppt_prev, 65);

2848: fetch csr_get_bal_value into l_notran_noppt_prev;
2849: close csr_get_bal_value;
2850:
2851: IF g_debug THEN
2852: hr_utility.set_location('l_notran_noppt_prev '||l_notran_noppt_prev, 65);
2853: END IF;
2854:
2855: l_tot_prev_etp := l_tot_prev_etp + l_notran_noppt_prev;
2856:

Line 2868: hr_utility.set_location('l_notran_noppt_prev '||l_notran_noppt_prev, 65);

2864: fetch csr_get_bal_value into l_notran_ppt_prev;
2865: close csr_get_bal_value;
2866:
2867: IF g_debug THEN
2868: hr_utility.set_location('l_notran_noppt_prev '||l_notran_noppt_prev, 65);
2869: hr_utility.set_location('l_notran_ppt_prev '||l_notran_ppt_prev, 65);
2870: END IF;
2871:
2872: l_tot_prev_etp := l_tot_prev_etp + l_notran_noppt_prev + l_notran_ppt_prev ;

Line 2869: hr_utility.set_location('l_notran_ppt_prev '||l_notran_ppt_prev, 65);

2865: close csr_get_bal_value;
2866:
2867: IF g_debug THEN
2868: hr_utility.set_location('l_notran_noppt_prev '||l_notran_noppt_prev, 65);
2869: hr_utility.set_location('l_notran_ppt_prev '||l_notran_ppt_prev, 65);
2870: END IF;
2871:
2872: l_tot_prev_etp := l_tot_prev_etp + l_notran_noppt_prev + l_notran_ppt_prev ;
2873: end if;

Line 2885: hr_utility.set_location('l_tran_noppt_prev '||l_tran_noppt_prev, 65);

2881: fetch csr_get_bal_value into l_tran_ppt_prev;
2882: close csr_get_bal_value;
2883:
2884: IF g_debug THEN
2885: hr_utility.set_location('l_tran_noppt_prev '||l_tran_noppt_prev, 65);
2886: hr_utility.set_location('l_tran_ppt_prev '||l_tran_ppt_prev, 65);
2887: END IF;
2888:
2889: l_tot_prev_etp := l_tot_prev_etp + l_tran_noppt_prev + l_tran_ppt_prev ;

Line 2886: hr_utility.set_location('l_tran_ppt_prev '||l_tran_ppt_prev, 65);

2882: close csr_get_bal_value;
2883:
2884: IF g_debug THEN
2885: hr_utility.set_location('l_tran_noppt_prev '||l_tran_noppt_prev, 65);
2886: hr_utility.set_location('l_tran_ppt_prev '||l_tran_ppt_prev, 65);
2887: END IF;
2888:
2889: l_tot_prev_etp := l_tot_prev_etp + l_tran_noppt_prev + l_tran_ppt_prev ;
2890: end if;

Line 2895: hr_utility.set_location('l_add '||l_add, 65);

2891:
2892: end if;
2893:
2894: IF g_debug THEN
2895: hr_utility.set_location('l_add '||l_add, 65);
2896: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 65);
2897: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 65);
2898: END IF;
2899:

Line 2896: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 65);

2892: end if;
2893:
2894: IF g_debug THEN
2895: hr_utility.set_location('l_add '||l_add, 65);
2896: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 65);
2897: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 65);
2898: END IF;
2899:
2900: l_add := l_add + 12;

Line 2897: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 65);

2893:
2894: IF g_debug THEN
2895: hr_utility.set_location('l_add '||l_add, 65);
2896: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 65);
2897: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 65);
2898: END IF;
2899:
2900: l_add := l_add + 12;
2901:

Line 2914: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 71); end if;

2910: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ld_user_table,p_etp_notran_noppt_run,lv_medicare_levy);
2911: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt;
2912: CLOSE csr_get_etp_tax;
2913:
2914: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 71); end if;
2915:
2916: ELSE
2917:
2918: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ld_user_table,(p_etp_notran_noppt_ytd),lv_medicare_levy);

Line 2927: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 72);

2923: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt_prev;
2924: CLOSE csr_get_etp_tax;
2925:
2926: IF g_debug THEN
2927: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 72);
2928: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 72);
2929: END IF;
2930:
2931: l_etp_tax_notran_noppt := l_etp_tax_notran_noppt_ytd - l_etp_tax_notran_noppt_prev;

Line 2928: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 72);

2924: CLOSE csr_get_etp_tax;
2925:
2926: IF g_debug THEN
2927: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 72);
2928: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 72);
2929: END IF;
2930:
2931: l_etp_tax_notran_noppt := l_etp_tax_notran_noppt_ytd - l_etp_tax_notran_noppt_prev;
2932:

Line 2946: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 73);

2942: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt_prev;
2943: CLOSE csr_get_etp_tax;
2944:
2945: IF g_debug THEN
2946: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 73);
2947: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 73);
2948: END IF;
2949:
2950: l_etp_tax_notran_noppt := l_etp_tax_notran_noppt_ytd - l_etp_tax_notran_noppt_prev;

Line 2947: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 73);

2943: CLOSE csr_get_etp_tax;
2944:
2945: IF g_debug THEN
2946: hr_utility.set_location('l_etp_tax_notran_noppt_ytd '||l_etp_tax_notran_noppt_ytd, 73);
2947: hr_utility.set_location('l_etp_tax_notran_noppt_prev '||l_etp_tax_notran_noppt_prev, 73);
2948: END IF;
2949:
2950: l_etp_tax_notran_noppt := l_etp_tax_notran_noppt_ytd - l_etp_tax_notran_noppt_prev;
2951:

Line 2964: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 81); end if;

2960: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,ln_user_table,p_etp_notran_noppt_run,lv_medicare_levy);
2961: FETCH csr_get_etp_tax into l_etp_tax_notran_noppt;
2962: CLOSE csr_get_etp_tax;
2963:
2964: if g_debug then hr_utility.set_location('l_etp_tax_notran_noppt '||l_etp_tax_notran_noppt, 81); end if;
2965:
2966: ELSIF p_etp_notran_ppt_run <> 0 THEN
2967:
2968: IF l_tot_prev_etp = 0 THEN

Line 2980: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 82);

2976: CLOSE csr_get_etp_tax;
2977:
2978:
2979: IF g_debug THEN
2980: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 82);
2981: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 82);
2982: END IF;
2983:
2984: l_etp_tax_notran_ppt := l_etp_tax_notran_ppt_ytd - l_etp_tax_notran_ppt_prev;

Line 2981: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 82);

2977:
2978:
2979: IF g_debug THEN
2980: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 82);
2981: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 82);
2982: END IF;
2983:
2984: l_etp_tax_notran_ppt := l_etp_tax_notran_ppt_ytd - l_etp_tax_notran_ppt_prev;
2985:

Line 2998: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 83);

2994: CLOSE csr_get_etp_tax;
2995:
2996:
2997: IF g_debug THEN
2998: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 83);
2999: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 83);
3000: END IF;
3001:
3002: l_etp_tax_notran_ppt := l_etp_tax_notran_ppt_ytd - l_etp_tax_notran_ppt_prev;

Line 2999: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 83);

2995:
2996:
2997: IF g_debug THEN
2998: hr_utility.set_location('l_etp_tax_notran_ppt_ytd '||l_etp_tax_notran_ppt_ytd, 83);
2999: hr_utility.set_location('l_etp_tax_notran_ppt_prev '||l_etp_tax_notran_ppt_prev, 83);
3000: END IF;
3001:
3002: l_etp_tax_notran_ppt := l_etp_tax_notran_ppt_ytd - l_etp_tax_notran_ppt_prev;
3003:

Line 3018: if g_debug then hr_utility.set_location('l_etp_tax_tran_noppt '||l_etp_tax_tran_noppt, 91); end if;

3014: OPEN csr_get_etp_tax(p_business_group_id,p_date_paid,lt_user_table,p_etp_tran_noppt_run,lv_medicare_levy);
3015: FETCH csr_get_etp_tax into l_etp_tax_tran_noppt;
3016: CLOSE csr_get_etp_tax;
3017:
3018: if g_debug then hr_utility.set_location('l_etp_tax_tran_noppt '||l_etp_tax_tran_noppt, 91); end if;
3019:
3020: ELSIF p_etp_tran_ppt_run <> 0 THEN
3021:
3022: IF l_tot_prev_etp = 0 THEN

Line 3034: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 92);

3030: CLOSE csr_get_etp_tax;
3031:
3032:
3033: IF g_debug THEN
3034: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 92);
3035: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 92);
3036: END IF;
3037:
3038: l_etp_tax_tran_ppt := l_etp_tax_tran_ppt_ytd - l_etp_tax_tran_ppt_prev;

Line 3035: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 92);

3031:
3032:
3033: IF g_debug THEN
3034: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 92);
3035: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 92);
3036: END IF;
3037:
3038: l_etp_tax_tran_ppt := l_etp_tax_tran_ppt_ytd - l_etp_tax_tran_ppt_prev;
3039:

Line 3052: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 93);

3048: CLOSE csr_get_etp_tax;
3049:
3050:
3051: IF g_debug THEN
3052: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 93);
3053: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 93);
3054: END IF;
3055:
3056: l_etp_tax_tran_ppt := l_etp_tax_tran_ppt_ytd - l_etp_tax_tran_ppt_prev;

Line 3053: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 93);

3049:
3050:
3051: IF g_debug THEN
3052: hr_utility.set_location('l_etp_tax_tran_ppt_ytd '||l_etp_tax_tran_ppt_ytd, 93);
3053: hr_utility.set_location('l_etp_tax_tran_ppt_prev '||l_etp_tax_tran_ppt_prev, 93);
3054: END IF;
3055:
3056: l_etp_tax_tran_ppt := l_etp_tax_tran_ppt_ytd - l_etp_tax_tran_ppt_prev;
3057:

Line 3075: hr_utility.set_location('Leaving '||l_procedure, 99);

3071: p_etp_tax_tran_noppt := l_etp_tax_tran_noppt;
3072: p_etp_tax_tran_ppt := l_etp_tax_tran_ppt;
3073:
3074: IF g_debug THEN
3075: hr_utility.set_location('Leaving '||l_procedure, 99);
3076: hr_utility.set_location('p_etp_tax_notran_noppt '||p_etp_tax_notran_noppt, 99);
3077: hr_utility.set_location('p_etp_tax_notran_ppt '||p_etp_tax_notran_ppt, 99);
3078: hr_utility.set_location('p_etp_tax_tran_noppt '||p_etp_tax_tran_noppt, 99);
3079: hr_utility.set_location('p_etp_tax_tran_ppt '||p_etp_tax_tran_ppt, 99);

Line 3076: hr_utility.set_location('p_etp_tax_notran_noppt '||p_etp_tax_notran_noppt, 99);

3072: p_etp_tax_tran_ppt := l_etp_tax_tran_ppt;
3073:
3074: IF g_debug THEN
3075: hr_utility.set_location('Leaving '||l_procedure, 99);
3076: hr_utility.set_location('p_etp_tax_notran_noppt '||p_etp_tax_notran_noppt, 99);
3077: hr_utility.set_location('p_etp_tax_notran_ppt '||p_etp_tax_notran_ppt, 99);
3078: hr_utility.set_location('p_etp_tax_tran_noppt '||p_etp_tax_tran_noppt, 99);
3079: hr_utility.set_location('p_etp_tax_tran_ppt '||p_etp_tax_tran_ppt, 99);
3080: END IF;

Line 3077: hr_utility.set_location('p_etp_tax_notran_ppt '||p_etp_tax_notran_ppt, 99);

3073:
3074: IF g_debug THEN
3075: hr_utility.set_location('Leaving '||l_procedure, 99);
3076: hr_utility.set_location('p_etp_tax_notran_noppt '||p_etp_tax_notran_noppt, 99);
3077: hr_utility.set_location('p_etp_tax_notran_ppt '||p_etp_tax_notran_ppt, 99);
3078: hr_utility.set_location('p_etp_tax_tran_noppt '||p_etp_tax_tran_noppt, 99);
3079: hr_utility.set_location('p_etp_tax_tran_ppt '||p_etp_tax_tran_ppt, 99);
3080: END IF;
3081:

Line 3078: hr_utility.set_location('p_etp_tax_tran_noppt '||p_etp_tax_tran_noppt, 99);

3074: IF g_debug THEN
3075: hr_utility.set_location('Leaving '||l_procedure, 99);
3076: hr_utility.set_location('p_etp_tax_notran_noppt '||p_etp_tax_notran_noppt, 99);
3077: hr_utility.set_location('p_etp_tax_notran_ppt '||p_etp_tax_notran_ppt, 99);
3078: hr_utility.set_location('p_etp_tax_tran_noppt '||p_etp_tax_tran_noppt, 99);
3079: hr_utility.set_location('p_etp_tax_tran_ppt '||p_etp_tax_tran_ppt, 99);
3080: END IF;
3081:
3082: RETURN 0;

Line 3079: hr_utility.set_location('p_etp_tax_tran_ppt '||p_etp_tax_tran_ppt, 99);

3075: hr_utility.set_location('Leaving '||l_procedure, 99);
3076: hr_utility.set_location('p_etp_tax_notran_noppt '||p_etp_tax_notran_noppt, 99);
3077: hr_utility.set_location('p_etp_tax_notran_ppt '||p_etp_tax_notran_ppt, 99);
3078: hr_utility.set_location('p_etp_tax_tran_noppt '||p_etp_tax_tran_noppt, 99);
3079: hr_utility.set_location('p_etp_tax_tran_ppt '||p_etp_tax_tran_ppt, 99);
3080: END IF;
3081:
3082: RETURN 0;
3083:

Line 3130: hr_utility.set_location(' Entering::'||l_proc,1);

3126: AND pap.accrual_category = c_abs_category
3127: AND NVL(pap.information3,'N') = c_fw_plan;
3128:
3129: BEGIN
3130: hr_utility.set_location(' Entering::'||l_proc,1);
3131: l_hours_flag := 'N';
3132: l_days_flag := 'N';
3133: l_std_hours := 0;
3134: l_fw_hours := 0;

Line 3191: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);

3187: END LOOP;
3188:
3189: IF l_error = 'Y'
3190: THEN
3191: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
3192: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
3193: hr_utility.raise_error;
3194: END IF;
3195:

Line 3192: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');

3188:
3189: IF l_error = 'Y'
3190: THEN
3191: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
3192: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
3193: hr_utility.raise_error;
3194: END IF;
3195:
3196: p_std_accrual := l_std_hours;

Line 3193: hr_utility.raise_error;

3189: IF l_error = 'Y'
3190: THEN
3191: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
3192: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
3193: hr_utility.raise_error;
3194: END IF;
3195:
3196: p_std_accrual := l_std_hours;
3197: p_fw_accrual := l_fw_hours;

Line 3199: hr_utility.set_location('Leaving:'||l_proc,2);

3195:
3196: p_std_accrual := l_std_hours;
3197: p_fw_accrual := l_fw_hours;
3198:
3199: hr_utility.set_location('Leaving:'||l_proc,2);
3200:
3201: RETURN (0);
3202:
3203: END get_foreign_accrual;

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

3288:
3289: begin
3290:
3291: IF g_debug THEN
3292: hr_utility.set_location('Entering function '||l_procedure,1);
3293: hr_utility.set_location('p_start_date '||p_start_date,1);
3294: hr_utility.set_location('p_end_date '||p_end_date,1);
3295: END IF;
3296:

Line 3293: hr_utility.set_location('p_start_date '||p_start_date,1);

3289: begin
3290:
3291: IF g_debug THEN
3292: hr_utility.set_location('Entering function '||l_procedure,1);
3293: hr_utility.set_location('p_start_date '||p_start_date,1);
3294: hr_utility.set_location('p_end_date '||p_end_date,1);
3295: END IF;
3296:
3297:

Line 3294: hr_utility.set_location('p_end_date '||p_end_date,1);

3290:
3291: IF g_debug THEN
3292: hr_utility.set_location('Entering function '||l_procedure,1);
3293: hr_utility.set_location('p_start_date '||p_start_date,1);
3294: hr_utility.set_location('p_end_date '||p_end_date,1);
3295: END IF;
3296:
3297:
3298: open csr_get_days_ppl;

Line 3307: hr_utility.set_location('l_get_days_ppl: '||l_get_days_ppl,20) ;

3303: close csr_get_days_ppl;
3304:
3305:
3306: IF g_debug THEN
3307: hr_utility.set_location('l_get_days_ppl: '||l_get_days_ppl,20) ;
3308: hr_utility.set_location('Leaving: '||l_procedure,20) ;
3309: END IF;
3310:
3311: return l_get_days_ppl;

Line 3308: hr_utility.set_location('Leaving: '||l_procedure,20) ;

3304:
3305:
3306: IF g_debug THEN
3307: hr_utility.set_location('l_get_days_ppl: '||l_get_days_ppl,20) ;
3308: hr_utility.set_location('Leaving: '||l_procedure,20) ;
3309: END IF;
3310:
3311: return l_get_days_ppl;
3312:

Line 3353: hr_utility.set_location(' '||l_procedure, 10);

3349:
3350: BEGIN
3351:
3352: IF g_debug THEN
3353: hr_utility.set_location(' '||l_procedure, 10);
3354: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3355: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
3356: END IF;
3357:

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

3350: BEGIN
3351:
3352: IF g_debug THEN
3353: hr_utility.set_location(' '||l_procedure, 10);
3354: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3355: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
3356: END IF;
3357:
3358:

Line 3355: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);

3351:
3352: IF g_debug THEN
3353: hr_utility.set_location(' '||l_procedure, 10);
3354: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3355: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
3356: END IF;
3357:
3358:
3359: open au_count_etps;

Line 3367: hr_utility.set_location('RETURN ln_count '||ln_count,10);

3363: end if;
3364: close au_count_etps;
3365:
3366: IF g_debug THEN
3367: hr_utility.set_location('RETURN ln_count '||ln_count,10);
3368: END IF;
3369:
3370: RETURN ln_count;
3371:

Line 3449: hr_utility.set_location(l_procedure, 1);

3445:
3446: begin
3447: --
3448: IF g_debug THEN
3449: hr_utility.set_location(l_procedure, 1);
3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);

Line 3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);

3446: begin
3447: --
3448: IF g_debug THEN
3449: hr_utility.set_location(l_procedure, 1);
3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);

Line 3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);

3447: --
3448: IF g_debug THEN
3449: hr_utility.set_location(l_procedure, 1);
3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);

Line 3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);

3448: IF g_debug THEN
3449: hr_utility.set_location(l_procedure, 1);
3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);

Line 3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);

3449: hr_utility.set_location(l_procedure, 1);
3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);

Line 3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);

3450: hr_utility.set_location('p_assignment_id '||p_assignment_id, 1);
3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);

Line 3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);

3451: hr_utility.set_location('p_tax_unit_id '||p_tax_unit_id, 1);
3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);
3459: hr_utility.set_location('p_redundancy_pay '||p_redundancy_pay, 1);

Line 3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);

3452: hr_utility.set_location('p_assignment_action_id '||p_assignment_action_id, 1);
3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);
3459: hr_utility.set_location('p_redundancy_pay '||p_redundancy_pay, 1);
3460: END IF;

Line 3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);

3453: hr_utility.set_location('p_date_earned '||p_date_earned, 1);
3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);
3459: hr_utility.set_location('p_redundancy_pay '||p_redundancy_pay, 1);
3460: END IF;
3461:

Line 3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);

3454: hr_utility.set_location('p_date_paid '||p_date_paid, 1);
3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);
3459: hr_utility.set_location('p_redundancy_pay '||p_redundancy_pay, 1);
3460: END IF;
3461:
3462: l_max_lump_d := p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;

Line 3459: hr_utility.set_location('p_redundancy_pay '||p_redundancy_pay, 1);

3455: hr_utility.set_location('p_years_of_service '||p_years_of_service, 1);
3456: hr_utility.set_location('p_lump_d_tax_free '||p_lump_d_tax_free, 1);
3457: hr_utility.set_location('p_lump_d_service_increment '||p_lump_d_service_increment, 1);
3458: hr_utility.set_location('p_redundancy_pay_ytd '||p_redundancy_pay_ytd, 1);
3459: hr_utility.set_location('p_redundancy_pay '||p_redundancy_pay, 1);
3460: END IF;
3461:
3462: l_max_lump_d := p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;
3463:

Line 3465: hr_utility.set_location('l_max_lump_d '||l_max_lump_d, 10);

3461:
3462: l_max_lump_d := p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;
3463:
3464: IF g_debug THEN
3465: hr_utility.set_location('l_max_lump_d '||l_max_lump_d, 10);
3466: END IF;
3467:
3468: open csr_get_curr_atd;
3469: fetch csr_get_curr_atd into l_acutal_termination_date;

Line 3478: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);

3474: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
3475: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3476:
3477: IF g_debug THEN
3478: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
3479: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
3480: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
3481: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
3482: END IF;

Line 3479: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);

3475: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3476:
3477: IF g_debug THEN
3478: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
3479: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
3480: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
3481: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
3482: END IF;
3483:

Line 3480: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);

3476:
3477: IF g_debug THEN
3478: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
3479: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
3480: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
3481: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
3482: END IF;
3483:
3484: IF g_debug THEN

Line 3481: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);

3477: IF g_debug THEN
3478: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 20);
3479: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 20);
3480: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 20);
3481: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
3482: END IF;
3483:
3484: IF g_debug THEN
3485: hr_utility.set_location('previous g_lump_sum_d.assignment_id '||nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0), 21);

Line 3485: hr_utility.set_location('previous g_lump_sum_d.assignment_id '||nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0), 21);

3481: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 20);
3482: END IF;
3483:
3484: IF g_debug THEN
3485: hr_utility.set_location('previous g_lump_sum_d.assignment_id '||nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0), 21);
3486: hr_utility.set_location('previous g_lump_sum_d.value '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 21);
3487: END IF;
3488:
3489: IF l_year_end_atd = l_year_end_paid THEN -- paid in the termination year

Line 3486: hr_utility.set_location('previous g_lump_sum_d.value '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 21);

3482: END IF;
3483:
3484: IF g_debug THEN
3485: hr_utility.set_location('previous g_lump_sum_d.assignment_id '||nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0), 21);
3486: hr_utility.set_location('previous g_lump_sum_d.value '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 21);
3487: END IF;
3488:
3489: IF l_year_end_atd = l_year_end_paid THEN -- paid in the termination year
3490:

Line 3494: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 30); END IF;

3490:
3491: IF p_redundancy_pay_ytd = 0 THEN -- 1st redundancy payment
3492:
3493: IF p_assignment_id = nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0) THEN
3494: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 30); END IF;
3495: l_max := l_max_lump_d - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3496: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3497:
3498: ELSE

Line 3499: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 30); END IF;

3495: l_max := l_max_lump_d - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3496: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3497:
3498: ELSE
3499: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 30); END IF;
3500: l_max := l_max_lump_d;
3501: pay_au_terminations.g_lump_sum_d.value := least(l_max, p_redundancy_pay);
3502:
3503: END IF;

Line 3508: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 31); END IF;

3504:
3505: ELSE -- subsequent redundancy payment
3506:
3507: IF p_assignment_id = nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0) THEN
3508: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 31); END IF;
3509: IF p_redundancy_pay_ytd + nvl(pay_au_terminations.g_lump_sum_d.value,0) < l_max_lump_d THEN
3510: l_max := l_max_lump_d - p_redundancy_pay_ytd - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3511: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3512: ELSE

Line 3516: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 31); END IF;

3512: ELSE
3513: l_max := 0;
3514: END IF;
3515: ELSE
3516: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 31); END IF;
3517: IF p_redundancy_pay_ytd < l_max_lump_d THEN
3518: l_max := l_max_lump_d - p_redundancy_pay_ytd ;
3519: pay_au_terminations.g_lump_sum_d.value := least(l_max, p_redundancy_pay);
3520: ELSE

Line 3546: hr_utility.set_location('l_add '||l_add, 40);

3542:
3543: l_tot_prev_etp := l_tot_prev_etp + l_prev_etp;
3544:
3545: IF g_debug THEN
3546: hr_utility.set_location('l_add '||l_add, 40);
3547: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 40);
3548: hr_utility.set_location('l_prev_etp '||l_prev_etp, 40);
3549: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 40);
3550: END IF;

Line 3547: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 40);

3543: l_tot_prev_etp := l_tot_prev_etp + l_prev_etp;
3544:
3545: IF g_debug THEN
3546: hr_utility.set_location('l_add '||l_add, 40);
3547: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 40);
3548: hr_utility.set_location('l_prev_etp '||l_prev_etp, 40);
3549: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 40);
3550: END IF;
3551:

Line 3548: hr_utility.set_location('l_prev_etp '||l_prev_etp, 40);

3544:
3545: IF g_debug THEN
3546: hr_utility.set_location('l_add '||l_add, 40);
3547: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 40);
3548: hr_utility.set_location('l_prev_etp '||l_prev_etp, 40);
3549: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 40);
3550: END IF;
3551:
3552: l_add := l_add + 12;

Line 3549: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 40);

3545: IF g_debug THEN
3546: hr_utility.set_location('l_add '||l_add, 40);
3547: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 40);
3548: hr_utility.set_location('l_prev_etp '||l_prev_etp, 40);
3549: hr_utility.set_location('l_tot_prev_etp '||l_tot_prev_etp, 40);
3550: END IF;
3551:
3552: l_add := l_add + 12;
3553:

Line 3561: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 60); END IF;

3557:
3558: IF p_redundancy_pay_ytd = 0 THEN -- 1st redundancy payment
3559:
3560: IF p_assignment_id = nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0) THEN
3561: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 60); END IF;
3562: l_max := l_max_lump_d - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3563: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3564:
3565: ELSE

Line 3566: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 60); END IF;

3562: l_max := l_max_lump_d - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3563: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3564:
3565: ELSE
3566: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 60); END IF;
3567: l_max := l_max_lump_d;
3568: pay_au_terminations.g_lump_sum_d.value := least(l_max, p_redundancy_pay);
3569:
3570: END IF;

Line 3575: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 61); END IF;

3571:
3572: ELSE -- subsequent redundancy payment
3573:
3574: IF p_assignment_id = nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0) THEN
3575: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 61); END IF;
3576: IF p_redundancy_pay_ytd + nvl(pay_au_terminations.g_lump_sum_d.value,0) < l_max_lump_d THEN
3577: l_max := l_max_lump_d - p_redundancy_pay_ytd - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3578: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3579: ELSE

Line 3583: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 61); END IF;

3579: ELSE
3580: l_max := 0;
3581: END IF;
3582: ELSE
3583: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 61); END IF;
3584: IF p_redundancy_pay_ytd < l_max_lump_d THEN
3585: l_max := l_max_lump_d - p_redundancy_pay_ytd ;
3586: pay_au_terminations.g_lump_sum_d.value := least(l_max, p_redundancy_pay);
3587: ELSE

Line 3599: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 62); END IF;

3595:
3596: IF p_redundancy_pay_ytd = 0 THEN -- 1st redundancy payment
3597:
3598: IF p_assignment_id = nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0) THEN
3599: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 62); END IF;
3600: IF l_tot_prev_etp + nvl(pay_au_terminations.g_lump_sum_d.value,0) < l_max_lump_d THEN
3601: l_max := l_max_lump_d - l_tot_prev_etp - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3602: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3603: ELSE

Line 3609: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 62); END IF;

3605: END IF;
3606:
3607: ELSE
3608:
3609: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 62); END IF;
3610: IF l_tot_prev_etp < l_max_lump_d THEN
3611: l_max := l_max_lump_d - l_tot_prev_etp;
3612: pay_au_terminations.g_lump_sum_d.value := least(l_max, p_redundancy_pay);
3613: ELSE

Line 3622: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 63); END IF;

3618:
3619: ELSE -- subsequent redundancy payment
3620:
3621: IF p_assignment_id = nvl(pay_au_terminations.g_lump_sum_d.assignment_id,0) THEN
3622: IF g_debug THEN hr_utility.set_location('retrieving g_lumpsum_d '||nvl(pay_au_terminations.g_lump_sum_d.value,0), 63); END IF;
3623: IF l_tot_prev_etp + p_redundancy_pay_ytd + nvl(pay_au_terminations.g_lump_sum_d.value,0) < l_max_lump_d THEN
3624: l_max := l_max_lump_d - l_tot_prev_etp - p_redundancy_pay_ytd - nvl(pay_au_terminations.g_lump_sum_d.value,0);
3625: pay_au_terminations.g_lump_sum_d.value := nvl(pay_au_terminations.g_lump_sum_d.value,0) + least(l_max, p_redundancy_pay);
3626: ELSE

Line 3632: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 63); END IF;

3628: END IF;
3629:
3630: ELSE
3631:
3632: IF g_debug THEN hr_utility.set_location('not retrieving g_lumpsum_d ', 63); END IF;
3633: IF l_tot_prev_etp + p_redundancy_pay_ytd < l_max_lump_d THEN
3634: l_max := l_max_lump_d - l_tot_prev_etp - p_redundancy_pay_ytd;
3635: pay_au_terminations.g_lump_sum_d.value := least(l_max, p_redundancy_pay);
3636: ELSE

Line 3652: hr_utility.set_location('l_max '||l_max, 90);

3648: l_lump_sum_d := least(l_max, p_redundancy_pay);
3649: pay_au_terminations.g_lump_sum_d.assignment_id := p_assignment_id;
3650:
3651: IF g_debug THEN
3652: hr_utility.set_location('l_max '||l_max, 90);
3653: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);
3654: hr_utility.set_location('setting g_lumpsum_d assignment_id : '||pay_au_terminations.g_lump_sum_d.assignment_id||', value : '|| pay_au_terminations.g_lump_sum_d.value, 90);
3655: hr_utility.set_location('Leaving '||l_procedure, 90);
3656: END IF;

Line 3653: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);

3649: pay_au_terminations.g_lump_sum_d.assignment_id := p_assignment_id;
3650:
3651: IF g_debug THEN
3652: hr_utility.set_location('l_max '||l_max, 90);
3653: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);
3654: hr_utility.set_location('setting g_lumpsum_d assignment_id : '||pay_au_terminations.g_lump_sum_d.assignment_id||', value : '|| pay_au_terminations.g_lump_sum_d.value, 90);
3655: hr_utility.set_location('Leaving '||l_procedure, 90);
3656: END IF;
3657:

Line 3654: hr_utility.set_location('setting g_lumpsum_d assignment_id : '||pay_au_terminations.g_lump_sum_d.assignment_id||', value : '|| pay_au_terminations.g_lump_sum_d.value, 90);

3650:
3651: IF g_debug THEN
3652: hr_utility.set_location('l_max '||l_max, 90);
3653: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);
3654: hr_utility.set_location('setting g_lumpsum_d assignment_id : '||pay_au_terminations.g_lump_sum_d.assignment_id||', value : '|| pay_au_terminations.g_lump_sum_d.value, 90);
3655: hr_utility.set_location('Leaving '||l_procedure, 90);
3656: END IF;
3657:
3658: return l_lump_sum_d;

Line 3655: hr_utility.set_location('Leaving '||l_procedure, 90);

3651: IF g_debug THEN
3652: hr_utility.set_location('l_max '||l_max, 90);
3653: hr_utility.set_location('l_lump_sum_d '||l_lump_sum_d, 90);
3654: hr_utility.set_location('setting g_lumpsum_d assignment_id : '||pay_au_terminations.g_lump_sum_d.assignment_id||', value : '|| pay_au_terminations.g_lump_sum_d.value, 90);
3655: hr_utility.set_location('Leaving '||l_procedure, 90);
3656: END IF;
3657:
3658: return l_lump_sum_d;
3659:

Line 3895: hr_utility.set_location('Entering '||l_procedure, 10);

3891:
3892: l_procedure := 'calculate_etp_tax_2012';
3893:
3894: IF g_debug THEN
3895: hr_utility.set_location('Entering '||l_procedure, 10);
3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);

Line 3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);

3892: l_procedure := 'calculate_etp_tax_2012';
3893:
3894: IF g_debug THEN
3895: hr_utility.set_location('Entering '||l_procedure, 10);
3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);

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

3893:
3894: IF g_debug THEN
3895: hr_utility.set_location('Entering '||l_procedure, 10);
3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

Line 3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);

3894: IF g_debug THEN
3895: hr_utility.set_location('Entering '||l_procedure, 10);
3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

Line 3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);

3895: hr_utility.set_location('Entering '||l_procedure, 10);
3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

Line 3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);

3896: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

Line 3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

3897: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

Line 3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

3898: hr_utility.set_location('IN p_tax_unit_id ' ||p_tax_unit_id,10);
3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);

Line 3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

3899: hr_utility.set_location('IN p_assignment_action_id ' ||p_assignment_action_id,10);
3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);

Line 3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

3900: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);

Line 3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

3901: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);

Line 3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);

3902: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);
3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);

Line 3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);

3903: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);
3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);
3911: hr_utility.set_location('IN p_etp_included_under_ytd ' ||p_etp_included_under_ytd,10);

Line 3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);

3904: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);
3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);
3911: hr_utility.set_location('IN p_etp_included_under_ytd ' ||p_etp_included_under_ytd,10);
3912: END IF;

Line 3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);

3905: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);
3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);
3911: hr_utility.set_location('IN p_etp_included_under_ytd ' ||p_etp_included_under_ytd,10);
3912: END IF;
3913:

Line 3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);

3906: hr_utility.set_location('IN p_current_pay_ytd ' ||p_current_pay_ytd,10);
3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);
3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);
3911: hr_utility.set_location('IN p_etp_included_under_ytd ' ||p_etp_included_under_ytd,10);
3912: END IF;
3913:
3914: l_excluded_ytd := p_etp_excluded_ytd;

Line 3911: hr_utility.set_location('IN p_etp_included_under_ytd ' ||p_etp_included_under_ytd,10);

3907: hr_utility.set_location('IN p_etp_excluded_ytd ' ||p_etp_excluded_ytd,10);
3908: hr_utility.set_location('IN p_etp_included_ytd ' ||p_etp_included_ytd,10);
3909: hr_utility.set_location('IN p_etp_excluded_run ' ||p_etp_excluded_run,10);
3910: hr_utility.set_location('IN p_etp_included_run ' ||p_etp_included_run,10);
3911: hr_utility.set_location('IN p_etp_included_under_ytd ' ||p_etp_included_under_ytd,10);
3912: END IF;
3913:
3914: l_excluded_ytd := p_etp_excluded_ytd;
3915: l_excluded_run := p_etp_excluded_run;

Line 3934: if g_debug then hr_utility.set_location('death user table '||ld_user_table, 21); end if;

3930: lv_medicare_levy:=0;
3931: END IF;
3932: END IF;
3933:
3934: if g_debug then hr_utility.set_location('death user table '||ld_user_table, 21); end if;
3935:
3936: ELSE
3937:
3938: IF p_over_pres_age ='N' THEN

Line 3951: hr_utility.set_location('user table '||ln_user_table, 22);

3947: END IF;
3948: END loop;
3949:
3950: if g_debug then
3951: hr_utility.set_location('user table '||ln_user_table, 22);
3952: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 22);
3953: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 22);
3954: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 22);
3955: end if;

Line 3952: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 22);

3948: END loop;
3949:
3950: if g_debug then
3951: hr_utility.set_location('user table '||ln_user_table, 22);
3952: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 22);
3953: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 22);
3954: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 22);
3955: end if;
3956:

Line 3953: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 22);

3949:
3950: if g_debug then
3951: hr_utility.set_location('user table '||ln_user_table, 22);
3952: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 22);
3953: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 22);
3954: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 22);
3955: end if;
3956:
3957: ELSIF p_over_pres_age ='Y' THEN

Line 3954: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 22);

3950: if g_debug then
3951: hr_utility.set_location('user table '||ln_user_table, 22);
3952: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 22);
3953: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 22);
3954: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 22);
3955: end if;
3956:
3957: ELSIF p_over_pres_age ='Y' THEN
3958: ln_user_table := 'TAX_SCALE_NON_TRANS_OVER_PREV_AGE';

Line 3970: hr_utility.set_location('user table '||ln_user_table, 23);

3966: END IF;
3967: END loop;
3968:
3969: if g_debug then
3970: hr_utility.set_location('user table '||ln_user_table, 23);
3971: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 23);
3972: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 23);
3973: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 23);
3974: end if;

Line 3971: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 23);

3967: END loop;
3968:
3969: if g_debug then
3970: hr_utility.set_location('user table '||ln_user_table, 23);
3971: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 23);
3972: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 23);
3973: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 23);
3974: end if;
3975:

Line 3972: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 23);

3968:
3969: if g_debug then
3970: hr_utility.set_location('user table '||ln_user_table, 23);
3971: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 23);
3972: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 23);
3973: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 23);
3974: end if;
3975:
3976: END IF;

Line 3973: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 23);

3969: if g_debug then
3970: hr_utility.set_location('user table '||ln_user_table, 23);
3971: hr_utility.set_location('l_etp_cap original '||l_etp_cap, 23);
3972: hr_utility.set_location('l_included_rate_prev_age '||l_included_rate_prev_age, 23);
3973: hr_utility.set_location('l_etp_included_rate_all_age '||l_etp_included_rate_all_age, 23);
3974: end if;
3975:
3976: END IF;
3977:

Line 3994: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 31);

3990: l_year_start_paid := hr_au_routes.span_start(p_date_paid, 1, '01-07-');
3991: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3992:
3993: IF g_debug THEN
3994: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 31);
3995: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 31);
3996: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 31);
3997: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 31);
3998: END IF;

Line 3995: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 31);

3991: l_year_end_paid := add_months(l_year_start_paid,12) - 1;
3992:
3993: IF g_debug THEN
3994: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 31);
3995: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 31);
3996: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 31);
3997: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 31);
3998: END IF;
3999:

Line 3996: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 31);

3992:
3993: IF g_debug THEN
3994: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 31);
3995: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 31);
3996: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 31);
3997: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 31);
3998: END IF;
3999:
4000: l_current_pay_ytd := p_current_pay_ytd;

Line 3997: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 31);

3993: IF g_debug THEN
3994: hr_utility.set_location('l_year_start_atd '||l_year_start_atd, 31);
3995: hr_utility.set_location('l_year_end_atd '||l_year_end_atd, 31);
3996: hr_utility.set_location('l_year_start_paid '||l_year_start_paid, 31);
3997: hr_utility.set_location('l_year_end_paid '||l_year_end_paid, 31);
3998: END IF;
3999:
4000: l_current_pay_ytd := p_current_pay_ytd;
4001:

Line 4006: hr_utility.set_location('Rehire --------------------------------', 32);

4002: /* Checking Taxable Income from previous assignments in the current financial year */
4003: FOR rec_rehire in csr_rehired_assignment(l_year_start_paid) LOOP
4004:
4005: if g_debug then
4006: hr_utility.set_location('Rehire --------------------------------', 32);
4007: hr_utility.set_location('Rehire assignment_id '||rec_rehire.assignment_id, 32);
4008: hr_utility.set_location('Rehire final_process_date '||to_char(rec_rehire.final_process_date,'DD-MON-YYYY'), 32);
4009: end if;
4010:

Line 4007: hr_utility.set_location('Rehire assignment_id '||rec_rehire.assignment_id, 32);

4003: FOR rec_rehire in csr_rehired_assignment(l_year_start_paid) LOOP
4004:
4005: if g_debug then
4006: hr_utility.set_location('Rehire --------------------------------', 32);
4007: hr_utility.set_location('Rehire assignment_id '||rec_rehire.assignment_id, 32);
4008: hr_utility.set_location('Rehire final_process_date '||to_char(rec_rehire.final_process_date,'DD-MON-YYYY'), 32);
4009: end if;
4010:
4011: l_rehire_max_asg_action_id := 0;

Line 4008: hr_utility.set_location('Rehire final_process_date '||to_char(rec_rehire.final_process_date,'DD-MON-YYYY'), 32);

4004:
4005: if g_debug then
4006: hr_utility.set_location('Rehire --------------------------------', 32);
4007: hr_utility.set_location('Rehire assignment_id '||rec_rehire.assignment_id, 32);
4008: hr_utility.set_location('Rehire final_process_date '||to_char(rec_rehire.final_process_date,'DD-MON-YYYY'), 32);
4009: end if;
4010:
4011: l_rehire_max_asg_action_id := 0;
4012: l_rehire_ytd := 0;

Line 4018: if g_debug then hr_utility.set_location(' Rehire l_rehire_max_asg_action_id '||l_rehire_max_asg_action_id, 33); end if;

4014: open c_rehire_max_asg_action_id(l_year_start_paid, least(l_year_end_paid, rec_rehire.final_process_date),rec_rehire.assignment_id);
4015: fetch c_rehire_max_asg_action_id into l_rehire_max_asg_action_id;
4016: IF c_rehire_max_asg_action_id%FOUND THEN
4017:
4018: if g_debug then hr_utility.set_location(' Rehire l_rehire_max_asg_action_id '||l_rehire_max_asg_action_id, 33); end if;
4019:
4020: FOR rec_bal in csr_get_balance_name LOOP
4021: open csr_rehire_get_bal_value(rec_bal.balance_name,l_rehire_max_asg_action_id);
4022: fetch csr_rehire_get_bal_value into l_rehire_ytd;

Line 4035: hr_utility.set_location(' Rehire balance_name '||rec_bal.balance_name, 34);

4031: END IF;
4032: close csr_rehire_get_bal_value;
4033:
4034: if g_debug then
4035: hr_utility.set_location(' Rehire balance_name '||rec_bal.balance_name, 34);
4036: hr_utility.set_location(' Rehire balance_value '||l_rehire_ytd, 34);
4037: end if;
4038:
4039: END LOOP;

Line 4036: hr_utility.set_location(' Rehire balance_value '||l_rehire_ytd, 34);

4032: close csr_rehire_get_bal_value;
4033:
4034: if g_debug then
4035: hr_utility.set_location(' Rehire balance_name '||rec_bal.balance_name, 34);
4036: hr_utility.set_location(' Rehire balance_value '||l_rehire_ytd, 34);
4037: end if;
4038:
4039: END LOOP;
4040:

Line 4045: if g_debug then hr_utility.set_location('Rehire l_current_pay_ytd '||l_current_pay_ytd, 35); end if;

4041: END IF;
4042: close c_rehire_max_asg_action_id;
4043:
4044: END LOOP;
4045: if g_debug then hr_utility.set_location('Rehire l_current_pay_ytd '||l_current_pay_ytd, 35); end if;
4046:
4047:
4048: IF l_year_end_atd = l_year_end_paid THEN /* ETP pay date is in the same financial year of Actual Termination Date */
4049:

Line 4063: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 42);

4059: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4060: CLOSE csr_get_etp_tax;
4061:
4062: IF g_debug THEN
4063: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 42);
4064: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 42);
4065: END IF;
4066:
4067: l_etp_tax_excluded := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;

Line 4064: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 42);

4060: CLOSE csr_get_etp_tax;
4061:
4062: IF g_debug THEN
4063: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 42);
4064: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 42);
4065: END IF;
4066:
4067: l_etp_tax_excluded := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4068:

Line 4078: hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 41);

4074:
4075: END IF;
4076:
4077: if g_debug then
4078: hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 41);
4079: end if;
4080:
4081: ELSE -- Non Death type
4082:

Line 4100: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 52);

4096: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4097: CLOSE csr_get_etp_tax;
4098:
4099: IF g_debug THEN
4100: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 52);
4101: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 52);
4102: END IF;
4103:
4104: ELSE

Line 4101: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 52);

4097: CLOSE csr_get_etp_tax;
4098:
4099: IF g_debug THEN
4100: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 52);
4101: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 52);
4102: END IF;
4103:
4104: ELSE
4105:

Line 4123: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 53);

4119: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev2;
4120: CLOSE csr_get_etp_tax;
4121:
4122: IF g_debug THEN
4123: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 53);
4124: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 53);
4125: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 53);
4126: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 53);
4127: END IF;

Line 4124: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 53);

4120: CLOSE csr_get_etp_tax;
4121:
4122: IF g_debug THEN
4123: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 53);
4124: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 53);
4125: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 53);
4126: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 53);
4127: END IF;
4128:

Line 4125: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 53);

4121:
4122: IF g_debug THEN
4123: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 53);
4124: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 53);
4125: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 53);
4126: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 53);
4127: END IF;
4128:
4129: l_etp_tax_excluded_ytd := l_etp_tax_excluded_ytd1 + l_etp_tax_excluded_ytd2;

Line 4126: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 53);

4122: IF g_debug THEN
4123: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 53);
4124: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 53);
4125: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 53);
4126: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 53);
4127: END IF;
4128:
4129: l_etp_tax_excluded_ytd := l_etp_tax_excluded_ytd1 + l_etp_tax_excluded_ytd2;
4130: l_etp_tax_excluded_prev := l_etp_tax_excluded_prev1 + l_etp_tax_excluded_prev2;

Line 4145: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 54);

4141: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4142: CLOSE csr_get_etp_tax;
4143:
4144: IF g_debug THEN
4145: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 54);
4146: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 54);
4147: END IF;
4148:
4149: END IF;

Line 4146: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 54);

4142: CLOSE csr_get_etp_tax;
4143:
4144: IF g_debug THEN
4145: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 54);
4146: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 54);
4147: END IF;
4148:
4149: END IF;
4150:

Line 4164: hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 51);

4160:
4161: END IF;
4162:
4163: IF g_debug THEN
4164: hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 51);
4165: END IF;
4166:
4167: END IF;
4168:

Line 4177: if g_debug then hr_utility.set_location('l_etp_whole_income_cap '||l_etp_whole_income_cap, 61); end if;

4173: else
4174: l_etp_whole_income_cap := l_etp_whole_income_cap - l_current_pay_ytd - l_etp_included_prev;
4175: end if;
4176:
4177: if g_debug then hr_utility.set_location('l_etp_whole_income_cap '||l_etp_whole_income_cap, 61); end if;
4178:
4179: if l_etp_cap - l_excluded_ytd - p_etp_included_under_ytd < 0 then
4180: l_etp_cap := 0 ;
4181: else

Line 4185: if g_debug then hr_utility.set_location('l_etp_cap '||l_etp_cap, 61); end if;

4181: else
4182: l_etp_cap := l_etp_cap - l_excluded_ytd - p_etp_included_under_ytd;
4183: end if;
4184:
4185: if g_debug then hr_utility.set_location('l_etp_cap '||l_etp_cap, 61); end if;
4186:
4187: if l_etp_whole_income_cap <= l_etp_cap then
4188: l_new_etp_cap := l_etp_whole_income_cap;
4189: else

Line 4193: if g_debug then hr_utility.set_location('l_new_etp_cap '||l_new_etp_cap, 61); end if;

4189: else
4190: l_new_etp_cap := l_etp_cap ;
4191: end if;
4192:
4193: if g_debug then hr_utility.set_location('l_new_etp_cap '||l_new_etp_cap, 61); end if;
4194:
4195:
4196: IF l_included_run <= l_new_etp_cap THEN
4197: l_etp_tax_included := round(l_included_run * (l_included_rate_prev_age + lv_medicare_levy));

Line 4206: hr_utility.set_location('l_etp_tax_included '||l_etp_tax_included, 62);

4202: l_included_under_cap := l_new_etp_cap;
4203: END IF;
4204:
4205: if g_debug then
4206: hr_utility.set_location('l_etp_tax_included '||l_etp_tax_included, 62);
4207: end if;
4208:
4209: END IF;
4210:

Line 4237: hr_utility.set_location('l_excluded_prev '||l_excluded_prev, 71);

4233: fetch csr_get_bal_value into l_excluded_prev;
4234: close csr_get_bal_value;
4235:
4236: IF g_debug THEN
4237: hr_utility.set_location('l_excluded_prev '||l_excluded_prev, 71);
4238: END IF;
4239:
4240: l_tot_excluded_prev := l_tot_excluded_prev + l_excluded_prev;
4241:

Line 4249: hr_utility.set_location('l_excluded_prev '||l_excluded_prev, 72);

4245: fetch csr_get_bal_value into l_excluded_prev;
4246: close csr_get_bal_value;
4247:
4248: IF g_debug THEN
4249: hr_utility.set_location('l_excluded_prev '||l_excluded_prev, 72);
4250: END IF;
4251:
4252: l_tot_excluded_prev := l_tot_excluded_prev + l_excluded_prev;
4253:

Line 4259: hr_utility.set_location('l_included_prev '||l_included_prev, 72);

4255: fetch csr_get_bal_value into l_included_prev;
4256: close csr_get_bal_value;
4257:
4258: IF g_debug THEN
4259: hr_utility.set_location('l_included_prev '||l_included_prev, 72);
4260: END IF;
4261:
4262: l_tot_included_prev := l_tot_included_prev + l_included_prev;
4263:

Line 4270: hr_utility.set_location('l_add '||l_add, 74);

4266: end if;
4267: close c_max_asg_action_id;
4268:
4269: IF g_debug THEN
4270: hr_utility.set_location('l_add '||l_add, 74);
4271: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 74);
4272: hr_utility.set_location('l_tot_excluded_prev '||l_tot_excluded_prev, 74);
4273: hr_utility.set_location('l_tot_included_prev '||l_tot_included_prev, 74);
4274: END IF;

Line 4271: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 74);

4267: close c_max_asg_action_id;
4268:
4269: IF g_debug THEN
4270: hr_utility.set_location('l_add '||l_add, 74);
4271: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 74);
4272: hr_utility.set_location('l_tot_excluded_prev '||l_tot_excluded_prev, 74);
4273: hr_utility.set_location('l_tot_included_prev '||l_tot_included_prev, 74);
4274: END IF;
4275:

Line 4272: hr_utility.set_location('l_tot_excluded_prev '||l_tot_excluded_prev, 74);

4268:
4269: IF g_debug THEN
4270: hr_utility.set_location('l_add '||l_add, 74);
4271: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 74);
4272: hr_utility.set_location('l_tot_excluded_prev '||l_tot_excluded_prev, 74);
4273: hr_utility.set_location('l_tot_included_prev '||l_tot_included_prev, 74);
4274: END IF;
4275:
4276: l_add := l_add + 12;

Line 4273: hr_utility.set_location('l_tot_included_prev '||l_tot_included_prev, 74);

4269: IF g_debug THEN
4270: hr_utility.set_location('l_add '||l_add, 74);
4271: hr_utility.set_location('l_max_assignment_action_id '||l_max_assignment_action_id, 74);
4272: hr_utility.set_location('l_tot_excluded_prev '||l_tot_excluded_prev, 74);
4273: hr_utility.set_location('l_tot_included_prev '||l_tot_included_prev, 74);
4274: END IF;
4275:
4276: l_add := l_add + 12;
4277:

Line 4295: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 82);

4291: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4292: CLOSE csr_get_etp_tax;
4293:
4294: IF g_debug THEN
4295: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 82);
4296: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 82);
4297: END IF;
4298:
4299: l_etp_tax_excluded := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;

Line 4296: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 82);

4292: CLOSE csr_get_etp_tax;
4293:
4294: IF g_debug THEN
4295: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 82);
4296: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 82);
4297: END IF;
4298:
4299: l_etp_tax_excluded := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4300:

Line 4310: hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 81);

4306:
4307: END IF;
4308:
4309: if g_debug then
4310: hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 81);
4311: end if;
4312:
4313: ELSIF l_excluded_run <> 0 and l_tot_excluded_prev <> 0 and p_death_benefit_type = 'ND' THEN
4314:

Line 4324: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 83);

4320: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4321: CLOSE csr_get_etp_tax;
4322:
4323: IF g_debug THEN
4324: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 83);
4325: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 83);
4326: END IF;
4327:
4328: l_etp_tax_excluded_pp := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;

Line 4325: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 83);

4321: CLOSE csr_get_etp_tax;
4322:
4323: IF g_debug THEN
4324: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 83);
4325: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 83);
4326: END IF;
4327:
4328: l_etp_tax_excluded_pp := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4329:

Line 4331: hr_utility.set_location('l_etp_tax_excluded_pp '||l_etp_tax_excluded_pp, 83);

4327:
4328: l_etp_tax_excluded_pp := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4329:
4330: if g_debug then
4331: hr_utility.set_location('l_etp_tax_excluded_pp '||l_etp_tax_excluded_pp, 83);
4332: end if;
4333:
4334: END IF;
4335:

Line 4361: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 92);

4357: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4358: CLOSE csr_get_etp_tax;
4359:
4360: IF g_debug THEN
4361: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 92);
4362: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 92);
4363: END IF;
4364:
4365: ELSE

Line 4362: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 92);

4358: CLOSE csr_get_etp_tax;
4359:
4360: IF g_debug THEN
4361: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 92);
4362: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 92);
4363: END IF;
4364:
4365: ELSE
4366:

Line 4384: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 93);

4380: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev2;
4381: CLOSE csr_get_etp_tax;
4382:
4383: IF g_debug THEN
4384: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 93);
4385: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 93);
4386: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 93);
4387: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 93);
4388: END IF;

Line 4385: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 93);

4381: CLOSE csr_get_etp_tax;
4382:
4383: IF g_debug THEN
4384: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 93);
4385: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 93);
4386: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 93);
4387: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 93);
4388: END IF;
4389:

Line 4386: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 93);

4382:
4383: IF g_debug THEN
4384: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 93);
4385: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 93);
4386: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 93);
4387: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 93);
4388: END IF;
4389:
4390: l_etp_tax_excluded_ytd := l_etp_tax_excluded_ytd1 + l_etp_tax_excluded_ytd2;

Line 4387: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 93);

4383: IF g_debug THEN
4384: hr_utility.set_location('l_etp_tax_excluded_ytd1 '||l_etp_tax_excluded_ytd1, 93);
4385: hr_utility.set_location('l_etp_tax_excluded_prev1 '||l_etp_tax_excluded_prev1, 93);
4386: hr_utility.set_location('l_etp_tax_excluded_ytd2 '||l_etp_tax_excluded_ytd2, 93);
4387: hr_utility.set_location('l_etp_tax_excluded_prev2 '||l_etp_tax_excluded_prev2, 93);
4388: END IF;
4389:
4390: l_etp_tax_excluded_ytd := l_etp_tax_excluded_ytd1 + l_etp_tax_excluded_ytd2;
4391: l_etp_tax_excluded_prev := l_etp_tax_excluded_prev1 + l_etp_tax_excluded_prev2;

Line 4406: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 94);

4402: FETCH csr_get_etp_tax into l_etp_tax_excluded_prev;
4403: CLOSE csr_get_etp_tax;
4404:
4405: IF g_debug THEN
4406: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 94);
4407: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 94);
4408: END IF;
4409:
4410: END IF;

Line 4407: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 94);

4403: CLOSE csr_get_etp_tax;
4404:
4405: IF g_debug THEN
4406: hr_utility.set_location('l_etp_tax_excluded_ytd '||l_etp_tax_excluded_ytd, 94);
4407: hr_utility.set_location('l_etp_tax_excluded_prev '||l_etp_tax_excluded_prev, 94);
4408: END IF;
4409:
4410: END IF;
4411:

Line 4414: if g_debug then hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 91); end if;

4410: END IF;
4411:
4412: IF l_tot_excluded_prev = 0 THEN
4413: l_etp_tax_excluded := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4414: if g_debug then hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 91); end if;
4415: ELSE
4416: l_etp_tax_excluded_pp := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4417: if g_debug then hr_utility.set_location('l_etp_tax_excluded_pp '||l_etp_tax_excluded_pp, 91); end if;
4418: END IF;

Line 4417: if g_debug then hr_utility.set_location('l_etp_tax_excluded_pp '||l_etp_tax_excluded_pp, 91); end if;

4413: l_etp_tax_excluded := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4414: if g_debug then hr_utility.set_location('l_etp_tax_excluded '||l_etp_tax_excluded, 91); end if;
4415: ELSE
4416: l_etp_tax_excluded_pp := l_etp_tax_excluded_ytd - l_etp_tax_excluded_prev;
4417: if g_debug then hr_utility.set_location('l_etp_tax_excluded_pp '||l_etp_tax_excluded_pp, 91); end if;
4418: END IF;
4419:
4420:
4421: END IF;

Line 4435: if g_debug then hr_utility.set_location('l_etp_whole_income_cap '||l_etp_whole_income_cap, 101); end if;

4431: else
4432: l_etp_whole_income_cap := l_etp_whole_income_cap - l_current_pay_ytd - l_etp_included_prev;
4433: end if;
4434:
4435: if g_debug then hr_utility.set_location('l_etp_whole_income_cap '||l_etp_whole_income_cap, 101); end if;
4436:
4437: if l_etp_cap - l_tot_excluded_prev - l_tot_included_prev - l_excluded_ytd - p_etp_included_under_ytd < 0 then
4438: l_etp_cap := 0 ;
4439: else

Line 4443: if g_debug then hr_utility.set_location('l_etp_cap '||l_etp_cap, 101); end if;

4439: else
4440: l_etp_cap := l_etp_cap - l_tot_excluded_prev - l_tot_included_prev - l_excluded_ytd - p_etp_included_under_ytd;
4441: end if;
4442:
4443: if g_debug then hr_utility.set_location('l_etp_cap '||l_etp_cap, 101); end if;
4444:
4445: if l_etp_whole_income_cap <= l_etp_cap then
4446: l_new_etp_cap := l_etp_whole_income_cap;
4447: else

Line 4451: if g_debug then hr_utility.set_location('l_new_etp_cap '||l_new_etp_cap, 101); end if;

4447: else
4448: l_new_etp_cap := l_etp_cap ;
4449: end if;
4450:
4451: if g_debug then hr_utility.set_location('l_new_etp_cap '||l_new_etp_cap, 101); end if;
4452:
4453: IF l_included_run <= l_new_etp_cap THEN
4454: l_etp_tax_included:= round(l_included_run * (l_included_rate_prev_age + lv_medicare_levy));
4455: l_included_under_cap := l_included_run;

Line 4466: if g_debug then hr_utility.set_location('l_etp_tax_included_pp '||l_etp_tax_included_pp, 102); end if;

4462: IF l_tot_included_prev <> 0 THEN
4463: l_etp_tax_included_pp := l_etp_tax_included;
4464: l_etp_tax_included := 0;
4465:
4466: if g_debug then hr_utility.set_location('l_etp_tax_included_pp '||l_etp_tax_included_pp, 102); end if;
4467:
4468: ELSE
4469:
4470: if g_debug then hr_utility.set_location('l_etp_tax_included '||l_etp_tax_included, 102); end if;

Line 4470: if g_debug then hr_utility.set_location('l_etp_tax_included '||l_etp_tax_included, 102); end if;

4466: if g_debug then hr_utility.set_location('l_etp_tax_included_pp '||l_etp_tax_included_pp, 102); end if;
4467:
4468: ELSE
4469:
4470: if g_debug then hr_utility.set_location('l_etp_tax_included '||l_etp_tax_included, 102); end if;
4471:
4472: END IF;
4473:
4474: END IF; -- Included

Line 4489: hr_utility.set_location('p_etp_tax_excluded '||p_etp_tax_excluded, 999);

4485:
4486:
4487:
4488: IF g_debug THEN
4489: hr_utility.set_location('p_etp_tax_excluded '||p_etp_tax_excluded, 999);
4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);
4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);
4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);
4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);

Line 4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);

4486:
4487:
4488: IF g_debug THEN
4489: hr_utility.set_location('p_etp_tax_excluded '||p_etp_tax_excluded, 999);
4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);
4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);
4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);
4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);
4494: hr_utility.set_location('Leaving '||l_procedure, 999);

Line 4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);

4487:
4488: IF g_debug THEN
4489: hr_utility.set_location('p_etp_tax_excluded '||p_etp_tax_excluded, 999);
4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);
4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);
4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);
4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);
4494: hr_utility.set_location('Leaving '||l_procedure, 999);
4495: END IF;

Line 4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);

4488: IF g_debug THEN
4489: hr_utility.set_location('p_etp_tax_excluded '||p_etp_tax_excluded, 999);
4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);
4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);
4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);
4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);
4494: hr_utility.set_location('Leaving '||l_procedure, 999);
4495: END IF;
4496:

Line 4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);

4489: hr_utility.set_location('p_etp_tax_excluded '||p_etp_tax_excluded, 999);
4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);
4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);
4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);
4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);
4494: hr_utility.set_location('Leaving '||l_procedure, 999);
4495: END IF;
4496:
4497: RETURN 0;

Line 4494: hr_utility.set_location('Leaving '||l_procedure, 999);

4490: hr_utility.set_location('p_etp_tax_excluded_pp '||p_etp_tax_excluded_pp, 999);
4491: hr_utility.set_location('p_etp_tax_included '||p_etp_tax_included, 999);
4492: hr_utility.set_location('p_etp_tax_included_pp '||p_etp_tax_included_pp, 999);
4493: hr_utility.set_location('p_included_under_cap '||p_included_under_cap, 999);
4494: hr_utility.set_location('Leaving '||l_procedure, 999);
4495: END IF;
4496:
4497: RETURN 0;
4498: