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

[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on HR_UTILITY

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

62: ** 23-Aug-2007 priupadh 115.41 Bug# 6192381 Added function au_check_trans
63: ** 17-Sep-2007 avenkatk 115.42 Bug# 6430072 Function calculate_etp_tax - Added condition to convert User Tables value using
64: ** fnd_number.canonical_to_number
65: */
66: g_debug constant boolean := hr_utility.debug_enabled;
67: g_package constant varchar2(60) := 'pay_au_terminations.';
68: --
69: -------------------------------------------------------------------------------------------------
70: --

Line 93: -- hr_utility

89: -- p_post_aug_1993 - net leave amount from 18-AUG-1993 until effective_date
90: --
91: -- Uses : per_accrual_calc_functions
92: -- pay_au_terminations
93: -- hr_utility
94: --
95: ------------------------------------------------------------------------------------------------
96: function get_long_service_leave
97: (p_assignment_id in number

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

137: l_long_service_leave := 'AULSL';
138:
139:
140: IF g_debug THEN
141: hr_utility.trace('-----------------------------------------');
142: hr_utility.set_location('Entering : '||l_procedure, 1);
143: END IF;
144: --
145: -- Get the accrual plan for long service leave

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

138:
139:
140: IF g_debug THEN
141: hr_utility.trace('-----------------------------------------');
142: hr_utility.set_location('Entering : '||l_procedure, 1);
143: END IF;
144: --
145: -- Get the accrual plan for long service leave
146: --

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

149: ,p_effective_date => p_effective_date
150: ,p_plan_category => l_long_service_leave
151: );
152: IF g_debug THEN
153: hr_utility.trace('plan id := '||to_char(l_plan_id));
154: END IF;
155: --
156: ---------------------------
157: -- Calculate pre aug 1978

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

158: ---------------------------
159: -- Accrual pre-aug-1978
160: --
161: IF g_debug THEN
162: hr_utility.set_location(l_procedure, 10);
163: END IF;
164: per_accrual_calc_functions.get_accrual
165: (p_assignment_id => p_assignment_id
166: ,p_calculation_date => l_pre_16_aug_1978 - 1

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

205: l_pre78_accrual:=l_pre78_accrual + l_others_entitlement_pre78 + l_accrual_init_pre78 + l_entitlement_init_pre78 ;
206:
207: -- Bug #1942971 -- End
208: IF g_debug THEN
209: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
210: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
211: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
212: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
213: END IF;

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

206:
207: -- Bug #1942971 -- End
208: IF g_debug THEN
209: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
210: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
211: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
212: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
213: END IF;
214: --

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

207: -- Bug #1942971 -- End
208: IF g_debug THEN
209: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
210: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
211: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
212: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
213: END IF;
214: --
215: -- Absences for pre-aug-1978

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

208: IF g_debug THEN
209: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
210: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
211: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
212: hr_utility.trace('pre78 accrual := '||to_char((l_pre78_accrual)));
213: END IF;
214: --
215: -- Absences for pre-aug-1978
216: --

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

214: --
215: -- Absences for pre-aug-1978
216: --
217: IF g_debug THEN
218: hr_utility.set_location(l_procedure, 15);
219: END IF;
220: l_pre78_absence := per_accrual_calc_functions.get_absence
221: (p_assignment_id => p_assignment_id
222: ,p_plan_id => l_plan_id

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

223: ,p_calculation_date => l_pre_16_aug_1978 - 1
224: ,p_start_date => l_start_date
225: );
226: IF g_debug THEN
227: hr_utility.trace('pre78 absence := '||to_char(l_pre78_absence));
228: END IF;
229: --
230: ---------------------------
231: -- Calculate post aug 1978

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

232: ---------------------------
233: -- Accrual post-aug-1978
234: --
235: IF g_debug THEN
236: hr_utility.set_location(l_procedure, 30);
237: END IF;
238: --
239: if p_effective_date < l_post_17_aug_1993 and p_effective_date > l_pre_16_aug_1978 then
240: per_accrual_calc_functions.get_accrual

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

295: l_post78_accrual := l_post78_accrual - l_pre78_accrual + l_others_entitlement_post78 + l_accrual_init_post78 + l_entitlement_init_post78;
296: --
297: -- Bug #1942971 -- End
298: IF g_debug THEN
299: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
300: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
301: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
302: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
303: END IF;

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

296: --
297: -- Bug #1942971 -- End
298: IF g_debug THEN
299: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
300: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
301: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
302: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
303: END IF;
304: --

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

297: -- Bug #1942971 -- End
298: IF g_debug THEN
299: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
300: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
301: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
302: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
303: END IF;
304: --
305: -- Absences for post-aug-1978

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

298: IF g_debug THEN
299: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
300: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
301: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
302: hr_utility.trace('post78 accrual := '||to_char((l_post78_accrual)));
303: END IF;
304: --
305: -- Absences for post-aug-1978
306: --

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

304: --
305: -- Absences for post-aug-1978
306: --
307: IF g_debug THEN
308: hr_utility.set_location(l_procedure, 35);
309: END IF;
310: l_post78_absence := per_accrual_calc_functions.get_absence
311: (p_assignment_id => p_assignment_id
312: ,p_plan_id => l_plan_id

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

313: ,p_calculation_date => l_post_17_aug_1993
314: ,p_start_date => l_post_15_aug_1978 + 1
315: );
316: IF g_debug THEN
317: hr_utility.trace('post78 absence := '||to_char(l_post78_absence));
318: END IF;
319: --
320: ---------------------------
321: -- Calculate post aug 1993

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

322: ---------------------------
323: -- Accrual post-aug-1993
324: --
325: IF g_debug THEN
326: hr_utility.set_location(l_procedure, 50);
327: END IF;
328: per_accrual_calc_functions.get_accrual
329: (p_assignment_id => p_assignment_id
330: ,p_calculation_date => p_effective_date

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

370: l_post93_accrual := l_post93_accrual - l_pre78_accrual - l_post78_accrual + l_accrual_init_post93 + l_entitlement_init_post93 ;
371: --
372: -- Bug #1942971 -- End
373: IF g_debug THEN
374: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
375: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
376: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
377: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
378: END IF;

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

371: --
372: -- Bug #1942971 -- End
373: IF g_debug THEN
374: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
375: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
376: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
377: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
378: END IF;
379: --

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

372: -- Bug #1942971 -- End
373: IF g_debug THEN
374: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
375: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
376: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
377: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
378: END IF;
379: --
380: -- Absences for post-aug-1993

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

373: IF g_debug THEN
374: hr_utility.trace('p_start_date := '||to_char(l_start_date,'dd-MM-yyyy'));
375: hr_utility.trace('p_end_date := '||to_char(l_end_date,'dd-MM-yyyy'));
376: hr_utility.trace('p_accrual_end_date := '||to_char(l_accrual_end_date,'dd-MM-yyyy'));
377: hr_utility.trace('post93 accrual := '||to_char((l_post93_accrual)));
378: END IF;
379: --
380: -- Absences for post-aug-1993
381: --

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

379: --
380: -- Absences for post-aug-1993
381: --
382: IF g_debug THEN
383: hr_utility.set_location(l_procedure, 55);
384: END IF;
385:
386: l_post93_absence := per_accrual_calc_functions.get_absence
387: (p_assignment_id => p_assignment_id

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

389: ,p_calculation_date => p_effective_date
390: ,p_start_date => l_post_17_aug_1993 + 1
391: );
392: IF g_debug THEN
393: hr_utility.trace('post93 absence := '||to_char(l_post93_absence));
394: END IF;
395: --
396: -- Absence are taken from accruals LIFO
397: --

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

395: --
396: -- Absence are taken from accruals LIFO
397: --
398: IF g_debug THEN
399: hr_utility.set_location(l_procedure, 70);
400: END IF;
401: if l_post93_absence > l_post93_accrual
402: then
403: IF g_debug THEN

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

400: END IF;
401: if l_post93_absence > l_post93_accrual
402: then
403: IF g_debug THEN
404: hr_utility.set_location(l_procedure, 72);
405: END IF;
406: p_post_aug_1993 := 0;
407: --
408: -- Move excess absences from post aug 1993 to absence for post aug 1978, previous bucket

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

409: --
410: l_post78_absence := l_post78_absence + (l_post93_absence - l_post93_accrual);
411: else
412: IF g_debug THEN
413: hr_utility.set_location(l_procedure, 74);
414: END IF;
415: p_post_aug_1993 := l_post93_accrual - l_post93_absence;
416: end if;
417: --

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

415: p_post_aug_1993 := l_post93_accrual - l_post93_absence;
416: end if;
417: --
418: IF g_debug THEN
419: hr_utility.set_location(l_procedure, 80);
420: END IF;
421: if l_post78_absence > l_post78_accrual
422: then
423: IF g_debug THEN

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

420: END IF;
421: if l_post78_absence > l_post78_accrual
422: then
423: IF g_debug THEN
424: hr_utility.set_location(l_procedure, 82);
425: END IF;
426: p_post_aug_1978 := 0;
427: --
428: -- Move excess absences from post aug 1978 to absence for pre aug 1978, previous bucket

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

429: --
430: l_pre78_absence := l_pre78_absence + (l_post78_absence - l_post78_accrual);
431: else
432: IF g_debug THEN
433: hr_utility.set_location(l_procedure, 84);
434: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);
435: hr_utility.trace('l_post78_absence:'||l_post78_absence);
436: END IF;
437: p_post_aug_1978 := l_post78_accrual - l_post78_absence;

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

430: l_pre78_absence := l_pre78_absence + (l_post78_absence - l_post78_accrual);
431: else
432: IF g_debug THEN
433: hr_utility.set_location(l_procedure, 84);
434: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);
435: hr_utility.trace('l_post78_absence:'||l_post78_absence);
436: END IF;
437: p_post_aug_1978 := l_post78_accrual - l_post78_absence;
438: end if;

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

431: else
432: IF g_debug THEN
433: hr_utility.set_location(l_procedure, 84);
434: hr_utility.trace('l_post78_accrual:'||l_post78_accrual);
435: hr_utility.trace('l_post78_absence:'||l_post78_absence);
436: END IF;
437: p_post_aug_1978 := l_post78_accrual - l_post78_absence;
438: end if;
439: --

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

437: p_post_aug_1978 := l_post78_accrual - l_post78_absence;
438: end if;
439: --
440: IF g_debug THEN
441: hr_utility.set_location(l_procedure, 90);
442: END IF;
443: if l_pre78_absence > l_pre78_accrual
444: then
445: IF g_debug THEN

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

442: END IF;
443: if l_pre78_absence > l_pre78_accrual
444: then
445: IF g_debug THEN
446: hr_utility.set_location(l_procedure, 92);
447: END IF;
448: -- Just set to zero, as we will not use negative amounts
449: p_pre_aug_1978 := 0;
450: else

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

448: -- Just set to zero, as we will not use negative amounts
449: p_pre_aug_1978 := 0;
450: else
451: IF g_debug THEN
452: hr_utility.set_location(l_procedure, 94);
453: END IF;
454: p_pre_aug_1978 := l_pre78_accrual - l_pre78_absence;
455: end if;
456: --

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

454: p_pre_aug_1978 := l_pre78_accrual - l_pre78_absence;
455: end if;
456: --
457: IF g_debug THEN
458: hr_utility.set_location('Leaving : '||l_procedure, 999);
459: hr_utility.trace('-----------------------------------------');
460: END IF;
461: return 1;
462: end get_long_service_leave;

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

455: end if;
456: --
457: IF g_debug THEN
458: hr_utility.set_location('Leaving : '||l_procedure, 999);
459: hr_utility.trace('-----------------------------------------');
460: END IF;
461: return 1;
462: end get_long_service_leave;
463: --

Line 594: -- USES: hr_utility

590: -- accrual plan category - annual leave or long service leave
591: -- OUT:
592: --
593: --
594: -- USES: hr_utility
595: -- hr_au_holidays
596: --
597: function get_accrual_plan_by_category
598: (p_assignment_id in number

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

623: --
624: begin
625: l_proc := g_package||'get_accrual_plan_by_category' ;
626: IF g_debug THEN
627: hr_utility.set_location(' Entering::'||l_proc,5);
628: END IF;
629: open csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
630: fetch csr_get_accrual_plan_id
631: into l_accrual_plan_id;

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

639: if csr_get_accrual_plan_id%found
640: then
641: close csr_get_accrual_plan_id;
642: IF g_debug THEN
643: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
644: END IF;
645: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
646: hr_utility.raise_error;
647: end if;

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

641: close csr_get_accrual_plan_id;
642: IF g_debug THEN
643: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
644: END IF;
645: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
646: hr_utility.raise_error;
647: end if;
648: close csr_get_accrual_plan_id;
649: IF g_debug THEN

Line 646: hr_utility.raise_error;

642: IF g_debug THEN
643: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
644: END IF;
645: hr_utility.set_message(801, 'HR_AU_TOO_MANY_ACCRUAL_PLANS');
646: hr_utility.raise_error;
647: end if;
648: close csr_get_accrual_plan_id;
649: IF g_debug THEN
650: hr_utility.set_location('Leaving:'||l_proc,20);

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

646: hr_utility.raise_error;
647: end if;
648: close csr_get_accrual_plan_id;
649: IF g_debug THEN
650: hr_utility.set_location('Leaving:'||l_proc,20);
651: END IF;
652: return l_accrual_plan_id;
653: END get_accrual_plan_by_category;
654: --

Line 674: -- USES: hr_utility

670: -- p_tax_instalment_deduction - used by formula to convert back to period amount
671: -- OUT:
672: --
673: --
674: -- USES: hr_utility
675: -- hr_au_holidays
676: --
677: function calculate_marginal_tax
678: ( p_date_earned in date

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

704: begin
705:
706:
707: IF g_debug THEN
708: hr_utility.set_location(l_procedure, 1);
709: hr_utility.trace('p_tax_variation_type = '||p_tax_variation_type);
710: END IF;
711: --
712: -- Which Tax method to use : Exempt, Fixed %, Fixed Amt or Marginal Rate

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

705:
706:
707: IF g_debug THEN
708: hr_utility.set_location(l_procedure, 1);
709: hr_utility.trace('p_tax_variation_type = '||p_tax_variation_type);
710: END IF;
711: --
712: -- Which Tax method to use : Exempt, Fixed %, Fixed Amt or Marginal Rate
713: --

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

741: -- The amount used here is assumed to be a weekly amount
742: -- so it must be converted back to a period amount
743: --
744: IF g_debug THEN
745: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));
746: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));
747: hr_utility.trace('average pay = '||to_char(p_average_pay));
748: END IF;
749: --

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

742: -- so it must be converted back to a period amount
743: --
744: IF g_debug THEN
745: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));
746: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));
747: hr_utility.trace('average pay = '||to_char(p_average_pay));
748: END IF;
749: --
750: -- Calculate the average termination pay

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

743: --
744: IF g_debug THEN
745: hr_utility.trace('p_a_variable1 = '||to_char(p_a_variable1));
746: hr_utility.trace('p_b_variable1 = '||to_char(p_b_variable1));
747: hr_utility.trace('average pay = '||to_char(p_average_pay));
748: END IF;
749: --
750: -- Calculate the average termination pay
751: --

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

753:
754: lv_average_pay := pay_au_paye_ff.convert_to_week(p_pay_freq,p_average_pay);
755: IF g_debug THEN
756:
757: hr_utility.trace('lv_average_term_pay_period = '||to_char(lv_average_term_pay_period));
758: hr_utility.trace('average term pay = '||to_char(lv_average_pay));
759: END IF;
760: --
761: -- Calculate tax on the average pay + average term pay

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

754: lv_average_pay := pay_au_paye_ff.convert_to_week(p_pay_freq,p_average_pay);
755: IF g_debug THEN
756:
757: hr_utility.trace('lv_average_term_pay_period = '||to_char(lv_average_term_pay_period));
758: hr_utility.trace('average term pay = '||to_char(lv_average_pay));
759: END IF;
760: --
761: -- Calculate tax on the average pay + average term pay
762: --

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

767: else
768: l_average_pay_tax := trunc(l_average_pay_tax);
769: end if;
770: IF g_debug THEN
771: hr_utility.trace('average pay tax = '||to_char(l_average_pay_tax));
772: END IF;
773: --
774: -- Calculate tax on the average pay
775: --

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

773: --
774: -- Calculate tax on the average pay
775: --
776: IF g_debug THEN
777: hr_utility.trace('p_a_variable2 = '||to_char(p_a_variable2));
778: hr_utility.trace('p_b_variable2 = '||to_char(p_b_variable2));
779: END IF;
780:
781: l_average_term_pay_tax := (p_a_variable2 * lv_average_pay) - p_b_variable2;

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

774: -- Calculate tax on the average pay
775: --
776: IF g_debug THEN
777: hr_utility.trace('p_a_variable2 = '||to_char(p_a_variable2));
778: hr_utility.trace('p_b_variable2 = '||to_char(p_b_variable2));
779: END IF;
780:
781: l_average_term_pay_tax := (p_a_variable2 * lv_average_pay) - p_b_variable2;
782: if p_tax_scale <> 4

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

786: l_average_term_pay_tax := trunc(l_average_term_pay_tax);
787: end if;
788: --
789: IF g_debug THEN
790: hr_utility.trace('average term tax = '||to_char(l_average_term_pay_tax));
791: END IF;
792: --
793: -- Total tax payable equals the difference between the tax amounts multiplied by 52
794: --

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

797: --
798:
799: --
800: IF g_debug THEN
801: hr_utility.trace('l_lump_tax = '||to_char(l_lump_tax));
802: END IF;
803: return l_lump_tax;
804: --
805: else

Line 824: -- USES: hr_utility

820: -- ETP payment components which can be free of tax
821: --
822: -- RETURNS: maximum tax free amount
823: --
824: -- USES: hr_utility
825: --
826: function max_etp_tax_free
827: (p_years_of_service in number
828: ,p_lump_d_tax_free in number

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

834: --
835: begin
836: --
837: IF g_debug THEN
838: hr_utility.set_location(l_procedure, 1);
839: END IF;
840: return p_lump_d_tax_free + p_lump_d_service_increment * p_years_of_service;
841: --
842: end max_etp_tax_free;

Line 859: -- USES: hr_utility

855: -- p_maximum_rollover - the maximum allowable amount a user may elect to roll into a super fund
856: --
857: -- OUT: p_message - error message containing token for maximum amount to roll over
858: --
859: -- USES: hr_utility
860: -- fnd_message
861: --
862: function check_rollover
863: (p_rollover_amount in number

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

869: l_message varchar2(500);
870: begin
871:
872: IF g_debug THEN
873: hr_utility.set_location(l_procedure,1);
874: hr_utility.trace('p_rollover_amount '||to_char(p_rollover_amount));
875: END IF;
876: if p_rollover_amount > p_maximum_rollover
877: then

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

870: begin
871:
872: IF g_debug THEN
873: hr_utility.set_location(l_procedure,1);
874: hr_utility.trace('p_rollover_amount '||to_char(p_rollover_amount));
875: END IF;
876: if p_rollover_amount > p_maximum_rollover
877: then
878: IF g_debug THEN

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

875: END IF;
876: if p_rollover_amount > p_maximum_rollover
877: then
878: IF g_debug THEN
879: hr_utility.trace('rollover exceeded - maximum '||to_char(p_maximum_rollover));
880: END IF;
881: fnd_message.set_name('PAY','HR_AU_SUPER_ROLL_NOT_VALID');
882: fnd_message.set_token('rollover_amount', p_maximum_rollover);
883: p_message := fnd_message.get;

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

882: fnd_message.set_token('rollover_amount', p_maximum_rollover);
883: p_message := fnd_message.get;
884: l_message := p_message;
885: IF g_debug THEN
886: hr_utility.trace('message = '||l_message);
887: END IF;
888: return 0;
889: else
890: return 1;

Line 911: -- USES: hr_utility

907: --
908: -- OUT: p_pre01jul1983_ratio - ratio to use when calculating the pre 01 July 1983 portion of ETP
909: -- p_post30jun1983_ratio - ratio to use when calculating the post 30 June 1983 portion of ETP
910: --
911: -- USES: hr_utility
912: -- fffunc
913: -- hr_au_holidays
914: --
915: function etp_prepost_ratios

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

990: p_le_etp_service_date :=null; /* bug 4177679 */
991: l_calc_date_entered := 'Y'; /* Bug 4177679 */
992:
993: IF g_debug THEN
994: hr_utility.set_location(l_procedure,1);
995: hr_utility.trace('p_assignment_id :'||p_assignment_id);
996: hr_utility.trace('p_hire_date :'||p_hire_date);
997: END IF;
998:

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

991: l_calc_date_entered := 'Y'; /* Bug 4177679 */
992:
993: IF g_debug THEN
994: hr_utility.set_location(l_procedure,1);
995: hr_utility.trace('p_assignment_id :'||p_assignment_id);
996: hr_utility.trace('p_hire_date :'||p_hire_date);
997: END IF;
998:
999: open c_get_etp_information(p_assignment_id);

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

992:
993: IF g_debug THEN
994: hr_utility.set_location(l_procedure,1);
995: hr_utility.trace('p_assignment_id :'||p_assignment_id);
996: hr_utility.trace('p_hire_date :'||p_hire_date);
997: END IF;
998:
999: open c_get_etp_information(p_assignment_id);
1000: fetch c_get_etp_information

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

1001: into l_actual_pre, l_actual_post, l_calculation_date;
1002: IF c_get_etp_information%FOUND then
1003: close c_get_etp_information;
1004: IF g_debug THEN
1005: hr_utility.trace('l_actual_pre :'||l_actual_pre);
1006: hr_utility.trace('l_actual_post :'||l_actual_post);
1007: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1008: END IF;
1009: l_actual_total := l_actual_pre + l_actual_post;

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

1002: IF c_get_etp_information%FOUND then
1003: close c_get_etp_information;
1004: IF g_debug THEN
1005: hr_utility.trace('l_actual_pre :'||l_actual_pre);
1006: hr_utility.trace('l_actual_post :'||l_actual_post);
1007: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1008: END IF;
1009: l_actual_total := l_actual_pre + l_actual_post;
1010: END IF;

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

1003: close c_get_etp_information;
1004: IF g_debug THEN
1005: hr_utility.trace('l_actual_pre :'||l_actual_pre);
1006: hr_utility.trace('l_actual_post :'||l_actual_post);
1007: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1008: END IF;
1009: l_actual_total := l_actual_pre + l_actual_post;
1010: END IF;
1011: IF g_debug THEN

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

1008: END IF;
1009: l_actual_total := l_actual_pre + l_actual_post;
1010: END IF;
1011: IF g_debug THEN
1012: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1013: END IF;
1014:
1015: IF l_actual_pre is not null and l_actual_post is not null
1016: and l_term_form_called = 'N' then

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

1016: and l_term_form_called = 'N' then
1017:
1018: -- Use the pre/post days for the calculation of the pre/post ratios.
1019: IF g_debug THEN
1020: hr_utility.set_location(l_procedure, 30);
1021: END IF;
1022: p_pre01jul1983_days := l_actual_pre;
1023: p_post30jun1983_days := l_actual_post;
1024: IF (p_pre01jul1983_days = 0 and p_post30jun1983_days = 0) then

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

1035: p_etp_service_date := l_calculation_date;
1036: p_le_etp_service_date := l_calculation_date; /* Bug 4177679 */
1037: END IF;
1038: IF g_debug THEN
1039: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1040: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1041: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1042: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1043: END IF;

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

1036: p_le_etp_service_date := l_calculation_date; /* Bug 4177679 */
1037: END IF;
1038: IF g_debug THEN
1039: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1040: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1041: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1042: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1043: END IF;
1044: return 1;

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

1037: END IF;
1038: IF g_debug THEN
1039: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1040: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1041: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1042: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1043: END IF;
1044: return 1;
1045:

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

1038: IF g_debug THEN
1039: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1040: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1041: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1042: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1043: END IF;
1044: return 1;
1045:
1046: END IF;

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

1054: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1055: p_le_etp_service_date := null; /* Bug 4177679 */
1056:
1057: IF g_debug THEN
1058: hr_utility.trace('p_hire_date : '||p_hire_date);
1059: END IF;
1060: END IF;
1061:
1062: IF l_term_form_called = 'Y' and p_hire_date is not null then

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

1067: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1068: p_le_etp_service_date := null; /* Bug 4177679 */
1069: END IF;
1070: IF g_debug THEN
1071: hr_utility.trace('l_calculation_date :'||l_calculation_date);
1072: END IF;
1073: /* End of Bug#2819479 */
1074:
1075: --

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

1077: --
1078: if l_calculation_date >= l_pre_date
1079: then
1080: IF g_debug THEN
1081: hr_utility.set_location(l_procedure, 15);
1082: END IF;
1083: p_pre01jul1983_days := 0;
1084: p_pre01jul1983_ratio := 0;
1085: p_post30jun1983_ratio := 1;

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

1097: --
1098: elsif p_termination_date <= l_post_date
1099: then
1100: IF g_debug THEN
1101: hr_utility.set_location(l_procedure, 16);
1102: END IF;
1103: p_post30jun1983_days := 0;
1104: p_post30jun1983_ratio := 0;
1105: p_pre01jul1983_ratio := 1;

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

1113: end if;
1114: return 1;
1115: else
1116: IF g_debug THEN
1117: hr_utility.set_location(l_procedure, 20);
1118: END IF;
1119: --
1120: -- Calculate the number of days worked for pre, post and total
1121: --

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

1135: --
1136: if (l_actual_pre < 0) or (l_actual_post < 0) or (l_actual_total < 0)
1137: then
1138: IF g_debug THEN
1139: hr_utility.set_location(l_procedure, 21);
1140: END IF;
1141: return 0;
1142: end if;
1143: --

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

1152: p_le_etp_service_date := l_calculation_date;
1153: end if;
1154:
1155: IF g_debug THEN
1156: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1157: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1158: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1159: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1160: END IF;

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

1153: end if;
1154:
1155: IF g_debug THEN
1156: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1157: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1158: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1159: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1160: END IF;
1161: return 1;

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

1154:
1155: IF g_debug THEN
1156: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1157: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1158: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1159: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1160: END IF;
1161: return 1;
1162:

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

1155: IF g_debug THEN
1156: hr_utility.trace('p_pre01jul1983_days:'||p_pre01jul1983_days);
1157: hr_utility.trace('p_post30jun1983_days:'||p_post30jun1983_days);
1158: hr_utility.trace('p_pre01jul1983_ratio:'||p_pre01jul1983_ratio);
1159: hr_utility.trace('p_post30jun1983_ratio:'||p_post30jun1983_ratio);
1160: END IF;
1161: return 1;
1162:
1163: END IF;

Line 1182: -- USES: hr_utility

1178: -- p_accrual_plan_id - id of the particular long service leave accrual plan
1179: --
1180: -- OUT: p_eligibility_years - number of years until eligible
1181: --
1182: -- USES: hr_utility
1183: --
1184: --
1185: function term_lsl_eligibility_years
1186: (p_date_earned in date

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

1219: --
1220: begin
1221:
1222: IF g_debug THEN
1223: hr_utility.set_location(l_procedure, 10);
1224: END IF;
1225: open csr_get_years(p_date_earned, p_accrual_plan_id);
1226: fetch csr_get_years
1227: into l_years;

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

1234: close csr_get_years;
1235: --
1236: p_eligibility_years := l_years;
1237: IF g_debug THEN
1238: hr_utility.trace('LSL eligibility years : '||to_char(l_years));
1239: END IF;
1240: return 1;
1241: --
1242: end term_lsl_eligibility_years;

Line 1448: g_debug := hr_utility.debug_enabled;

1444: p_pre_tax_spread := 0; /*Bug 4474896*/
1445: p_pre_tax_fixed := 0; /*Bug 4474896*/
1446: p_pre_tax_prog := 0; /*Bug 4474896*/
1447: i := 1;
1448: g_debug := hr_utility.debug_enabled;
1449: l_flag := -1;
1450:
1451: OPEN c_get_payroll_effective_date; /*Bug 4538463*/
1452: FETCH c_get_payroll_effective_date INTO l_eff_date; /*Bug 4538463*/

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

1452: FETCH c_get_payroll_effective_date INTO l_eff_date; /*Bug 4538463*/
1453: CLOSE c_get_payroll_effective_date; /*Bug 4538463*/
1454:
1455: IF g_debug THEN
1456: hr_utility.set_location(' '||l_procedure, 10);
1457: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);

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

1453: CLOSE c_get_payroll_effective_date; /*Bug 4538463*/
1454:
1455: IF g_debug THEN
1456: hr_utility.set_location(' '||l_procedure, 10);
1457: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);

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

1454:
1455: IF g_debug THEN
1456: hr_utility.set_location(' '||l_procedure, 10);
1457: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);

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

1455: IF g_debug THEN
1456: hr_utility.set_location(' '||l_procedure, 10);
1457: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);

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

1456: hr_utility.set_location(' '||l_procedure, 10);
1457: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);

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

1457: hr_utility.set_location(' p_assignment_id : ' ||p_assignment_id,10);
1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1465: hr_utility.set_location(' p_case ' ||p_case,10);

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

1458: hr_utility.set_location(' p_business_group_id ' ||p_business_group_id,10);
1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1465: hr_utility.set_location(' p_case ' ||p_case,10);
1466: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);

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

1459: hr_utility.set_location(' p_date_earned ' ||p_date_earned,10);
1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1465: hr_utility.set_location(' p_case ' ||p_case,10);
1466: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1467: END IF;

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

1460: hr_utility.set_location(' p_tax_unit_id ' ||p_tax_unit_id,10);
1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1465: hr_utility.set_location(' p_case ' ||p_case,10);
1466: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1467: END IF;
1468:

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

1461: hr_utility.set_location(' p_termination_date ' ||p_termination_date,10);
1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1465: hr_utility.set_location(' p_case ' ||p_case,10);
1466: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1467: END IF;
1468:
1469: -- Find the Financial Year Start and End Dates

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

1462: hr_utility.set_location(' p_hire_date ' ||p_hire_date,10);
1463: hr_utility.set_location(' p_period_start_date ' ||p_period_start_date,10);
1464: hr_utility.set_location(' p_period_end_date ' ||p_period_end_date,10);
1465: hr_utility.set_location(' p_case ' ||p_case,10);
1466: hr_utility.set_location(' to_char(p_date_earned,ddmm) ' ||to_char(p_date_earned,'ddmm'),10);
1467: END IF;
1468:
1469: -- Find the Financial Year Start and End Dates
1470: /*Bug 4538463 - Modified logic to get financial year start date and end dates

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

1496:
1497: -- Use the cursor to check whether any periods in this Financial Year got processed
1498: -- before this RUN
1499: IF g_debug THEN
1500: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1501: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1502:
1503: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1504: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);

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

1497: -- Use the cursor to check whether any periods in this Financial Year got processed
1498: -- before this RUN
1499: IF g_debug THEN
1500: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1501: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1502:
1503: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1504: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);
1505: END IF;

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

1499: IF g_debug THEN
1500: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1501: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1502:
1503: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1504: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);
1505: END IF;
1506:
1507: /*Bug 4538463 - Use the cursor below to check if this is the first run for the assignment in the

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

1500: hr_utility.set_location('l_fin_start_date: '|| l_fin_start_date, 20);
1501: hr_utility.set_location('l_fin_end_date: '|| l_fin_end_date, 20);
1502:
1503: hr_utility.set_location('l_prev_yr_fin_start_date: '|| l_prev_yr_fin_start_date, 20);
1504: hr_utility.set_location('l_prev_yr_fin_end_date: '|| l_prev_yr_fin_end_date, 20);
1505: END IF;
1506:
1507: /*Bug 4538463 - Use the cursor below to check if this is the first run for the assignment in the
1508: current financial year*/

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

1522: CLOSE c_get_prev_year_max_asg_act_id;
1523: IF nvl(l_asg_act_id,-99999) <> -99999 THEN /*Bug 4538463*/
1524: l_flag := 1; /* Flag is set to 1 when we take YTD earnings for previous year for the current legal employer*/
1525: END IF;
1526: hr_utility.trace('Inside 1');
1527: ELSE
1528: OPEN c_get_pre_le_max_asg_act_id(p_assignment_id, p_business_group_id, l_fin_start_date, l_eff_date);
1529: 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;
1530: CLOSE c_get_pre_le_max_asg_act_id;

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

1530: CLOSE c_get_pre_le_max_asg_act_id;
1531: IF nvl(l_asg_act_id,-99999) <> -99999 THEN /*Bug 4538463*/
1532: l_flag := 2; /* Flag is set to 2 when we take YTD earnings for current year for the previous legal employer*/
1533: END IF;
1534: hr_utility.trace('Inside 2');
1535: END IF;
1536:
1537: IF l_flag = -1 THEN
1538: 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 1543: hr_utility.trace('Inside 3');

1539: 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;
1540: CLOSE c_get_pre_le_max_asg_act_id;
1541: l_flag := 3; /* Bug 4538463 - Flag is set to 3 when we take YTD earnings for previous year for the legal employer effective on
1542: on the last run of year*/
1543: hr_utility.trace('Inside 3');
1544: END IF;
1545:
1546: IF g_debug THEN
1547: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);

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

1543: hr_utility.trace('Inside 3');
1544: END IF;
1545:
1546: IF g_debug THEN
1547: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1548: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1549: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1550: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1551: END IF;

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

1544: END IF;
1545:
1546: IF g_debug THEN
1547: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1548: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1549: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1550: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1551: END IF;
1552:

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

1545:
1546: IF g_debug THEN
1547: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1548: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1549: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1550: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1551: END IF;
1552:
1553:

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

1546: IF g_debug THEN
1547: hr_utility.set_location('l_asg_act_id: '|| l_asg_act_id, 30);
1548: hr_utility.set_location('g_context_table(1).tax_unit_id: '|| l_tax_unit_id, 30);
1549: hr_utility.set_location('l_payroll_id: '||l_payroll_id, 30);
1550: hr_utility.set_location('p_tax_unit_id :'||p_tax_unit_id, 30);
1551: END IF;
1552:
1553:
1554: IF nvl(l_asg_act_id,-99999) = -99999 THEN

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

1560: Average_Earnings will not be calculated.
1561: */
1562: p_case := 'POPULATE_MSG';
1563: IF g_debug THEN
1564: hr_utility.set_location('p_case: '|| p_case, 40);
1565: END IF;
1566: RETURN 110;
1567:
1568: ELSE

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

1590:
1591:
1592:
1593: IF g_debug THEN
1594: hr_utility.set_location('p_paid_periods: '|| p_paid_periods, 50);
1595: END IF;
1596:
1597:
1598: IF NOT g_ytd_def_bals_populated THEN

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

1650: and g_ytd_bals(i).balance_name = 'Earnings_Standard'
1651: THEN
1652: p_earnings_standard := nvl(g_ytd_result_table(i).balance_value,0);
1653: IF g_debug THEN
1654: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);
1655: END IF;
1656: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1657: and g_ytd_bals(i).balance_name = 'Pre Tax Spread Deductions'
1658: THEN

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

1657: and g_ytd_bals(i).balance_name = 'Pre Tax Spread Deductions'
1658: THEN
1659: p_pre_tax_spread := nvl(g_ytd_result_table(i).balance_value,0);
1660: IF g_debug THEN
1661: hr_utility.set_location('p_pre_tax_spread_deductions: '||p_pre_tax_spread, 60);
1662: END IF;
1663:
1664: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1665: and g_ytd_bals(i).balance_name = 'Pre Tax Fixed Deductions' and p_use_tax_flag = 'Y'

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

1666: /*bug4363057*/
1667: THEN
1668: p_pre_tax_fixed := nvl(g_ytd_result_table(i).balance_value,0);
1669: IF g_debug THEN
1670: hr_utility.set_location('p_pre_tax_fixed_deductions: '||p_pre_tax_fixed, 60);
1671: END IF;
1672: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1673: and g_ytd_bals(i).balance_name = 'Pre Tax Progressive Deductions' and p_use_tax_flag = 'Y'
1674: /*bug4363057*/

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

1674: /*bug4363057*/
1675: THEN
1676: p_pre_tax_prog := nvl(g_ytd_result_table(i).balance_value,0);
1677: IF g_debug THEN
1678: hr_utility.set_location('p_pre_tax_progressive_deductions: '||p_pre_tax_prog, 60);
1679: END IF;
1680:
1681: END IF;
1682: END LOOP;

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

1720: AND pap.accrual_plan_element_type_id = pet.element_type_id
1721: AND pap.accrual_category = p_plan_category ;
1722:
1723: BEGIN
1724: hr_utility.set_location(' Entering::'||l_proc,1);
1725: l_hours_flag := 'N';
1726: l_days_flag := 'N';
1727: l_hours := 0;
1728: l_error := 'N';

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

1746: end loop;
1747:
1748: IF l_error = 'Y'
1749: THEN
1750: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
1751: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1752: hr_utility.raise_error;
1753: END IF;
1754:

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

1747:
1748: IF l_error = 'Y'
1749: THEN
1750: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
1751: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1752: hr_utility.raise_error;
1753: END IF;
1754:
1755: hr_utility.set_location('Leaving:'||l_proc,2);

Line 1752: hr_utility.raise_error;

1748: IF l_error = 'Y'
1749: THEN
1750: hr_utility.set_location('Enrolled in Multiple Plans '||l_proc,15);
1751: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1752: hr_utility.raise_error;
1753: END IF;
1754:
1755: hr_utility.set_location('Leaving:'||l_proc,2);
1756:

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

1751: hr_utility.set_message(801, 'HR_AU_MULTIPLE_ACCRUAL_PLANS');
1752: hr_utility.raise_error;
1753: END IF;
1754:
1755: hr_utility.set_location('Leaving:'||l_proc,2);
1756:
1757: RETURN l_hours;
1758:
1759: -- EXCEPTION

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

1757: RETURN l_hours;
1758:
1759: -- EXCEPTION
1760: -- WHEN OTHERS THEN
1761: -- hr_utility.set_location('Leaving:'||l_proc,99);
1762: -- RETURN NULL;
1763: END get_total_accrual_hours;
1764:
1765: --------------------------------------------------

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

1836: BEGIN
1837:
1838: l_procedure := 'calculate_etp_tax';
1839: IF g_debug THEN
1840: hr_utility.set_location(' '||l_procedure, 10);
1841: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);

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

1837:
1838: l_procedure := 'calculate_etp_tax';
1839: IF g_debug THEN
1840: hr_utility.set_location(' '||l_procedure, 10);
1841: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);

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

1838: l_procedure := 'calculate_etp_tax';
1839: IF g_debug THEN
1840: hr_utility.set_location(' '||l_procedure, 10);
1841: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);

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

1839: IF g_debug THEN
1840: hr_utility.set_location(' '||l_procedure, 10);
1841: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1847: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);

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

1840: hr_utility.set_location(' '||l_procedure, 10);
1841: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1847: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1848: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);

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

1841: hr_utility.set_location('IN p_business_group_id ' ||p_business_group_id,10);
1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1847: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1848: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1849:

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

1842: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1847: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1848: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1849:
1850: END IF;

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

1843: hr_utility.set_location('IN p_etp_amount ' ||p_etp_amount,10);
1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1847: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1848: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1849:
1850: END IF;
1851:

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

1844: hr_utility.set_location('IN p_trans_etp ' ||p_trans_etp,10);
1845: hr_utility.set_location('IN p_death_benefit_type ' ||p_death_benefit_type,10);
1846: hr_utility.set_location('IN p_over_pres_age ' ||p_over_pres_age,10);
1847: hr_utility.set_location('IN p_tfn_for_non_dependent ' ||p_tfn_for_non_dependent,10);
1848: hr_utility.set_location('IN p_medicare_levy ' ||p_medicare_levy,10);
1849:
1850: END IF;
1851:
1852: lv_etp_tax:=0;

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

1887: FETCH csr_get_etp_tax into lv_etp_tax;
1888: CLOSE csr_get_etp_tax;
1889:
1890: IF g_debug THEN
1891: hr_utility.set_location('lv_user_table ' ||lv_user_table,10);
1892: hr_utility.set_location('RETURN lv_etp_tax '||lv_etp_tax,10);
1893: END IF;
1894: RETURN lv_etp_tax;
1895:

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

1888: CLOSE csr_get_etp_tax;
1889:
1890: IF g_debug THEN
1891: hr_utility.set_location('lv_user_table ' ||lv_user_table,10);
1892: hr_utility.set_location('RETURN lv_etp_tax '||lv_etp_tax,10);
1893: END IF;
1894: RETURN lv_etp_tax;
1895:
1896: END calculate_etp_tax;

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

1911: BEGIN
1912:
1913: l_procedure := 'get_fin_year_end';
1914: IF g_debug THEN
1915: hr_utility.set_location(' '||l_procedure, 10);
1916: hr_utility.set_location('IN p_date ' ||p_date,10);
1917: END IF;
1918:
1919: ld_fin_year_end := to_date('01/01/1900','DD/MM/YYYY');

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

1912:
1913: l_procedure := 'get_fin_year_end';
1914: IF g_debug THEN
1915: hr_utility.set_location(' '||l_procedure, 10);
1916: hr_utility.set_location('IN p_date ' ||p_date,10);
1917: END IF;
1918:
1919: ld_fin_year_end := to_date('01/01/1900','DD/MM/YYYY');
1920:

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

1927: ld_fin_year_end := ADD_MONTHS(to_date('30/06/'||to_char(p_date,'YYYY'),'DD/MM/YYYY'),12);
1928: END IF;
1929:
1930: IF g_debug THEN
1931: hr_utility.set_location('RETURN ld_fin_year_end '||ld_fin_year_end,10);
1932: END IF;
1933:
1934: RETURN ld_fin_year_end;
1935:

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

1990: BEGIN
1991:
1992: l_procedure := 'get_prev_age';
1993: IF g_debug THEN
1994: hr_utility.set_location(' '||l_procedure, 10);
1995: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);
1996: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1997: END IF;
1998:

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

1991:
1992: l_procedure := 'get_prev_age';
1993: IF g_debug THEN
1994: hr_utility.set_location(' '||l_procedure, 10);
1995: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);
1996: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1997: END IF;
1998:
1999: ln_prev_age :=0;

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

1992: l_procedure := 'get_prev_age';
1993: IF g_debug THEN
1994: hr_utility.set_location(' '||l_procedure, 10);
1995: hr_utility.set_location('IN p_date_of_birth ' ||p_date_of_birth,10);
1996: hr_utility.set_location('IN p_date_paid ' ||p_date_paid,10);
1997: END IF;
1998:
1999: ln_prev_age :=0;
2000:

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

2002: fetch csr_get_prev_age into ln_prev_age;
2003: close csr_get_prev_age;
2004:
2005: IF g_debug THEN
2006: hr_utility.set_location('RETURN ln_prev_age '||ln_prev_age,10);
2007: END IF;
2008:
2009: RETURN ln_prev_age;
2010:

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

2050: BEGIN
2051:
2052: l_procedure := 'au_check_trans';
2053: IF g_debug THEN
2054: hr_utility.set_location(' '||l_procedure, 10);
2055: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2056: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
2057: END IF;
2058:

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

2051:
2052: l_procedure := 'au_check_trans';
2053: IF g_debug THEN
2054: hr_utility.set_location(' '||l_procedure, 10);
2055: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2056: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
2057: END IF;
2058:
2059: lv_check_trans :='N';

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

2052: l_procedure := 'au_check_trans';
2053: IF g_debug THEN
2054: hr_utility.set_location(' '||l_procedure, 10);
2055: hr_utility.set_location('IN p_assignment_id ' ||p_assignment_id,10);
2056: hr_utility.set_location('IN p_date_earned ' ||p_date_earned,10);
2057: END IF;
2058:
2059: lv_check_trans :='N';
2060: ln_tmp := 0 ;

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

2068: end if;
2069: close csr_check_trans;
2070:
2071: IF g_debug THEN
2072: hr_utility.set_location('RETURN lv_check_trans '||lv_check_trans,10);
2073: END IF;
2074:
2075: RETURN lv_check_trans;
2076: