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

Line 27: hr_utility.set_location('After cursor formula_id = '||to_char(l_formula_id),10);

23: (p_formula_name => p_formula_name
24: ,p_effective_date => l_effective_date
25: ,p_effective_start_date => l_start_date);
26: --
27: hr_utility.set_location('After cursor formula_id = '||to_char(l_formula_id),10);
28: hr_utility.set_location('After cursor date = '||to_char(l_start_date),10);
29: hr_utility.set_location('Formula name = '||p_formula_name, 10);
30: --
31: ff_exec.init_formula (l_formula_id,

Line 28: hr_utility.set_location('After cursor date = '||to_char(l_start_date),10);

24: ,p_effective_date => l_effective_date
25: ,p_effective_start_date => l_start_date);
26: --
27: hr_utility.set_location('After cursor formula_id = '||to_char(l_formula_id),10);
28: hr_utility.set_location('After cursor date = '||to_char(l_start_date),10);
29: hr_utility.set_location('Formula name = '||p_formula_name, 10);
30: --
31: ff_exec.init_formula (l_formula_id,
32: l_start_date,

Line 29: hr_utility.set_location('Formula name = '||p_formula_name, 10);

25: ,p_effective_start_date => l_start_date);
26: --
27: hr_utility.set_location('After cursor formula_id = '||to_char(l_formula_id),10);
28: hr_utility.set_location('After cursor date = '||to_char(l_start_date),10);
29: hr_utility.set_location('Formula name = '||p_formula_name, 10);
30: --
31: ff_exec.init_formula (l_formula_id,
32: l_start_date,
33: g_inputs,

Line 36: hr_utility.set_location('Leaving init',10);

32: l_start_date,
33: g_inputs,
34: g_outputs);
35: --
36: hr_utility.set_location('Leaving init',10);
37: End init_formula;
38:
39: Function get_aubry_II_rebate (p_date_earned in date
40: ,p_assignment_id in number

Line 61: hr_utility.set_location('Entering pay_fr_rebates.get_aubry_II_rebate ',7);

57: ,p_message out nocopy varchar2) return number is
58: --
59: Begin
60: --
61: hr_utility.set_location('Entering pay_fr_rebates.get_aubry_II_rebate ',7);
62: --
63: init_formula('FR_AUBRY_II_REBATE');
64: --
65: -- Set up parameter values for the formula

Line 95: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

91: g_inputs(i).value := p_asg_action_id;
92: elsif g_inputs(i).name = 'BUSINESS_GROUP_ID' then
93: g_inputs(i).value := p_business_group_id;
94: else
95: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
96: end if;
97: --
98: end loop;
99: --

Line 102: hr_utility.set_location('Prior to execute the formula',8);

98: end loop;
99: --
100: -- Run the formula
101: --
102: hr_utility.set_location('Prior to execute the formula',8);
103: ff_exec.run_formula (g_inputs ,
104: g_outputs
105: );
106: --

Line 107: hr_utility.set_location('End run formula',9);

103: ff_exec.run_formula (g_inputs ,
104: g_outputs
105: );
106: --
107: hr_utility.set_location('End run formula',9);
108: --
109: for l_out_cnt in g_outputs.first..g_outputs.last loop
110: --
111: if g_outputs(l_out_cnt).name = 'L_AUBRY_II_REBATE' then

Line 130: hr_utility.set_location('get_aubry_II_rebate: Returning -1',10);

126: --
127: end loop;
128: --
129: if (p_aubry_II_contribution_id = -1 or p_aubry_II_zrr_contribution_id = -1) then
130: hr_utility.set_location('get_aubry_II_rebate: Returning -1',10);
131: return -1;
132: else
133: hr_utility.set_location('get_aubry_II_rebate: Returning 0',10);
134: return 0;

Line 133: hr_utility.set_location('get_aubry_II_rebate: Returning 0',10);

129: if (p_aubry_II_contribution_id = -1 or p_aubry_II_zrr_contribution_id = -1) then
130: hr_utility.set_location('get_aubry_II_rebate: Returning -1',10);
131: return -1;
132: else
133: hr_utility.set_location('get_aubry_II_rebate: Returning 0',10);
134: return 0;
135: end if;
136: --
137: End get_aubry_II_rebate;

Line 150: hr_utility.set_location('Entering pay_fr_rebates.get_aubry_I_rebate ',7);

146: ,p_aubry_I_contribution_id out nocopy number) return number is
147: --
148: Begin
149: --
150: hr_utility.set_location('Entering pay_fr_rebates.get_aubry_I_rebate ',7);
151: --
152: init_formula('FR_AUBRY_I_REBATE');
153: --
154: -- Set up parameter values for the formula

Line 168: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

164: g_inputs(i).value := p_assignment_id;
165: elsif g_inputs(i).name = 'TAX_UNIT_ID' then
166: g_inputs(i).value := p_tax_unit_id;
167: else
168: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
169: end if;
170: --
171: end loop;
172: --

Line 175: hr_utility.set_location(' Prior to execute the formula',8);

171: end loop;
172: --
173: -- Run the formula
174: --
175: hr_utility.set_location(' Prior to execute the formula',8);
176: ff_exec.run_formula (g_inputs ,
177: g_outputs
178: );
179: --

Line 180: hr_utility.set_location(' End run formula',9);

176: ff_exec.run_formula (g_inputs ,
177: g_outputs
178: );
179: --
180: hr_utility.set_location(' End run formula',9);
181: --
182: for l_out_cnt in g_outputs.first..g_outputs.last loop
183: --
184: if g_outputs(l_out_cnt).name = 'L_AUBRY_I_REBATE' then

Line 197: hr_utility.set_location('get_aubry_I_rebate: Returning -1',10);

193: --
194: end loop;
195: --
196: if p_aubry_I_contribution_id = -1 then
197: hr_utility.set_location('get_aubry_I_rebate: Returning -1',10);
198: return -1;
199: else
200: hr_utility.set_location('get_aubry_I_rebate: Returning 0',10);
201: return 0;

Line 200: hr_utility.set_location('get_aubry_I_rebate: Returning 0',10);

196: if p_aubry_I_contribution_id = -1 then
197: hr_utility.set_location('get_aubry_I_rebate: Returning -1',10);
198: return -1;
199: else
200: hr_utility.set_location('get_aubry_I_rebate: Returning 0',10);
201: return 0;
202: end if;
203: --
204: End get_aubry_I_rebate;

Line 219: hr_utility.set_location('Entering pay_fr_rebates.get_robien_rebate ',7);

215: ,p_robien_contribution_id out nocopy number) return number is
216: --
217: Begin
218: --
219: hr_utility.set_location('Entering pay_fr_rebates.get_robien_rebate ',7);
220: --
221: init_formula('FR_ROBIEN_REBATE');
222: --
223: -- Set up parameter values for the formula

Line 239: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

235: g_inputs(i).value := p_contributions_base;
236: elsif g_inputs(i).name = 'TAX_UNIT_ID' then
237: g_inputs(i).value := p_tax_unit_id;
238: else
239: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
240: end if;
241: --
242: end loop;
243: --

Line 246: hr_utility.set_location(' Prior to execute the formula',8);

242: end loop;
243: --
244: -- Run the formula
245: --
246: hr_utility.set_location(' Prior to execute the formula',8);
247: ff_exec.run_formula (g_inputs ,
248: g_outputs
249: );
250: --

Line 251: hr_utility.set_location(' End run formula',9);

247: ff_exec.run_formula (g_inputs ,
248: g_outputs
249: );
250: --
251: hr_utility.set_location(' End run formula',9);
252: --
253: for l_out_cnt in g_outputs.first..g_outputs.last loop
254: --
255: if g_outputs(l_out_cnt).name = 'L_ROBIEN_REBATE' then

Line 270: hr_utility.set_location('get_robien_rebate: Returning -1',10);

266: --
267: end loop;
268: --
269: if p_robien_contribution_id = -1 then
270: hr_utility.set_location('get_robien_rebate: Returning -1',10);
271: return -1;
272: else
273: hr_utility.set_location('get_robien_rebate: Returning 0',10);
274: return 0;

Line 273: hr_utility.set_location('get_robien_rebate: Returning 0',10);

269: if p_robien_contribution_id = -1 then
270: hr_utility.set_location('get_robien_rebate: Returning -1',10);
271: return -1;
272: else
273: hr_utility.set_location('get_robien_rebate: Returning 0',10);
274: return 0;
275: end if;
276: --
277: End get_robien_rebate;

Line 291: hr_utility.set_location('Entering pay_fr_rebates.get_part_time_rebate ',7);

287: ,p_part_time_contribution_id out nocopy number) return number is
288: --
289: Begin
290: --
291: hr_utility.set_location('Entering pay_fr_rebates.get_part_time_rebate ',7);
292: --
293: init_formula('FR_PART_TIME_REBATE');
294: --
295: -- Set up parameter values for the formula

Line 311: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

307: g_inputs(i).value := p_assignment_id;
308: elsif g_inputs(i).name = 'TAX_UNIT_ID' then
309: g_inputs(i).value := p_tax_unit_id;
310: else
311: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
312: end if;
313: --
314: end loop;
315: --

Line 318: hr_utility.set_location(' Prior to execute the formula',8);

314: end loop;
315: --
316: -- Run the formula
317: --
318: hr_utility.set_location(' Prior to execute the formula',8);
319: ff_exec.run_formula (g_inputs,
320: g_outputs
321: );
322: --

Line 323: hr_utility.set_location(' End run formula',9);

319: ff_exec.run_formula (g_inputs,
320: g_outputs
321: );
322: --
323: hr_utility.set_location(' End run formula',9);
324: --
325: for l_out_cnt in g_outputs.first..g_outputs.last loop
326: --
327: if g_outputs(l_out_cnt).name = 'L_PART_TIME_REBATE' then

Line 340: hr_utility.set_location('get_part_time_rebate: Returning -1',10);

336: --
337: end loop;
338: --
339: if p_part_time_contribution_id = -1 then
340: hr_utility.set_location('get_part_time_rebate: Returning -1',10);
341: return -1;
342: else
343: hr_utility.set_location('get_part_time_rebate: Returning 0',10);
344: return 0;

Line 343: hr_utility.set_location('get_part_time_rebate: Returning 0',10);

339: if p_part_time_contribution_id = -1 then
340: hr_utility.set_location('get_part_time_rebate: Returning -1',10);
341: return -1;
342: else
343: hr_utility.set_location('get_part_time_rebate: Returning 0',10);
344: return 0;
345: end if;
346: --
347: End get_part_time_rebate;

Line 365: hr_utility.set_location('Entering pay_fr_rebates.get_ss_lower_rebate ',7);

361: ,p_ss_lower_contribution_id out nocopy number) return number is
362: --
363: Begin
364: --
365: hr_utility.set_location('Entering pay_fr_rebates.get_ss_lower_rebate ',7);
366: --
367: init_formula('FR_SS_LOWER_REBATE');
368: --
369: -- Set up parameter values for the formula

Line 393: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

389: g_inputs(i).value := p_tax_unit_id;
390: elsif g_inputs(i).name = 'BUSINESS_GROUP_ID' then
391: g_inputs(i).value := p_business_group_id;
392: else
393: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
394: end if;
395: --
396: end loop;
397: --

Line 400: hr_utility.set_location(' Prior to execute the formula',8);

396: end loop;
397: --
398: -- Run the formula
399: --
400: hr_utility.set_location(' Prior to execute the formula',8);
401: --
402: ff_exec.run_formula (g_inputs,
403: g_outputs
404: );

Line 406: hr_utility.set_location(' End run formula',9);

402: ff_exec.run_formula (g_inputs,
403: g_outputs
404: );
405: --
406: hr_utility.set_location(' End run formula',9);
407: --
408: for l_out_cnt in g_outputs.first..g_outputs.last loop
409: --
410: if g_outputs(l_out_cnt).name = 'L_SS_LOWER_REBATE' then

Line 423: hr_utility.set_location('get_ss_lower_rebate: Returning -1',10);

419: --
420: end loop;
421: --
422: if p_ss_lower_contribution_id = -1 then
423: hr_utility.set_location('get_ss_lower_rebate: Returning -1',10);
424: return -1;
425: else
426: hr_utility.set_location('get_ss_lower_rebate: Returning 0',10);
427: return 0;

Line 426: hr_utility.set_location('get_ss_lower_rebate: Returning 0',10);

422: if p_ss_lower_contribution_id = -1 then
423: hr_utility.set_location('get_ss_lower_rebate: Returning -1',10);
424: return -1;
425: else
426: hr_utility.set_location('get_ss_lower_rebate: Returning 0',10);
427: return 0;
428: end if;
429: --
430: End get_ss_lower_rebate;

Line 499: hr_utility.set_location('Entering pay_fr_rebates.contribution info ', 10);

495: l_contribution_code pay_fr_contribution_usages.contribution_code%type;
496: --
497: Begin
498: --
499: hr_utility.set_location('Entering pay_fr_rebates.contribution info ', 10);
500: --
501: l_contribution_usage := pay_fr_general.get_contribution_usage
502: (p_process_type => p_process_type
503: ,p_element_name => p_element_name

Line 514: hr_utility.set_location('Contribution code = '||l_contribution_usage.contribution_code, 10);

510: --
511: p_contribution_code := l_contribution_code;
512: p_contribution_id := l_contribution_usage.contribution_usage_id;
513: --
514: hr_utility.set_location('Contribution code = '||l_contribution_usage.contribution_code, 10);
515: hr_utility.set_location('Contribution id = '||to_char(l_contribution_usage.contribution_usage_id), 10);
516: --
517: mesg := ' ';
518: --

Line 515: hr_utility.set_location('Contribution id = '||to_char(l_contribution_usage.contribution_usage_id), 10);

511: p_contribution_code := l_contribution_code;
512: p_contribution_id := l_contribution_usage.contribution_usage_id;
513: --
514: hr_utility.set_location('Contribution code = '||l_contribution_usage.contribution_code, 10);
515: hr_utility.set_location('Contribution id = '||to_char(l_contribution_usage.contribution_usage_id), 10);
516: --
517: mesg := ' ';
518: --
519: hr_utility.set_location('Entering pay_fr_rebates.contribution info = 0', 10);

Line 519: hr_utility.set_location('Entering pay_fr_rebates.contribution info = 0', 10);

515: hr_utility.set_location('Contribution id = '||to_char(l_contribution_usage.contribution_usage_id), 10);
516: --
517: mesg := ' ';
518: --
519: hr_utility.set_location('Entering pay_fr_rebates.contribution info = 0', 10);
520: return 0;
521: --
522: Exception when others then
523: fnd_message.set_name('PAY','PAY_74918_SD_NO_CNU_DATA');

Line 530: hr_utility.set_location('Leaving pay_fr_rebates.contribution info = -1', 10);

526: fnd_message.set_token('UT',p_usage_type);
527: mesg := fnd_message.get;
528: p_contribution_id := -1;
529: p_contribution_code := ' ';
530: hr_utility.set_location('Leaving pay_fr_rebates.contribution info = -1', 10);
531: return -1;
532: --
533: End contribution_info;
534:

Line 561: hr_utility.set_location('FORMULA Initialised ' ,10);

557: --
558: Begin
559: --
560: init_formula('FR_GET_REBATE_ELIGIBILITY');
561: hr_utility.set_location('FORMULA Initialised ' ,10);
562: --
563: -- Set up parameter values for the formula
564: for i in g_inputs.first..g_inputs.last loop
565: --

Line 581: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);

577: g_inputs(i).value := p_asg_action_id;
578: elsif g_inputs(i).name = 'PAYROLL_ACTION_ID' then
579: g_inputs(i).value := p_pay_action_id;
580: else
581: hr_utility.set_location('ERROR value = '||g_inputs(i).name ,7);
582: end if;
583: --
584: end loop;
585: --

Line 588: hr_utility.set_location(' Prior to execute the formula',8);

584: end loop;
585: --
586: -- Run the formula
587: --
588: hr_utility.set_location(' Prior to execute the formula',8);
589: --
590: ff_exec.run_formula (g_inputs,
591: g_outputs
592: );

Line 594: hr_utility.set_location(' End run formula',9);

590: ff_exec.run_formula (g_inputs,
591: g_outputs
592: );
593: --
594: hr_utility.set_location(' End run formula',9);
595: --
596: for l_out_cnt in g_outputs.first..g_outputs.last loop
597: --
598: if g_outputs(l_out_cnt).name = 'AUBRY_II_USED' then

Line 623: hr_utility.set_location('Output = '||g_outputs(l_out_cnt).name, 10);

619: p_director_mesg := g_outputs(l_out_cnt).value;
620: elsif g_outputs(l_out_cnt).name = 'L_FILLON_PART_TIME_MESG' then
621: p_fillon_part_time_mesg := g_outputs(l_out_cnt).value;
622: else
623: hr_utility.set_location('Output = '||g_outputs(l_out_cnt).name, 10);
624: end if;
625: --
626: end loop;
627: --

Line 634: hr_utility.set_location(' Returning -1',10);

630: -- Returns either PAY_74972_PART_TIME_ELIG_ERROR
631: -- or PAY_79999_NO_AUBRY_II
632: fnd_message.set_name('PAY', l_err);
633: p_mesg := fnd_message.get;
634: hr_utility.set_location(' Returning -1',10);
635: return -1;
636: else
637:
638: if l_warn = 'PAY_74972_PART_TIME_ELIG_WARN' then

Line 663: hr_utility.set_location(' Returning -2',10);

659: l_warn_flag := 'Y';
660: end if;
661:
662: if l_warn_flag = 'Y' then
663: hr_utility.set_location(' Returning -2',10);
664: return -2;
665: end if;
666:
667: end if;

Line 670: hr_utility.set_location(' Returning 0',10);

666:
667: end if;
668:
669: --
670: hr_utility.set_location(' Returning 0',10);
671: return 0;
672: --
673: End get_eligibility;
674:

Line 704: hr_utility.set_location('In function ', 10);

700: l_assignment_action_id number := -1;
701: --
702: Begin
703: --
704: hr_utility.set_location('In function ', 10);
705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);

Line 708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);

704: hr_utility.set_location('In function ', 10);
705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);
711: --
712: if l_err = 0 then

Line 709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);

705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);
711: --
712: if l_err = 0 then
713: --

Line 710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);

706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);
711: --
712: if l_err = 0 then
713: --
714: open csr_get_assignment_action;

Line 717: hr_utility.set_location('Action id = '||to_char(l_assignment_action_id),10);

713: --
714: open csr_get_assignment_action;
715: fetch csr_get_assignment_action into l_assignment_action_id;
716: close csr_get_assignment_action;
717: hr_utility.set_location('Action id = '||to_char(l_assignment_action_id),10);
718: if l_assignment_action_id > -1 then
719: --
720: /* now call bue for the asg hours balance using this assignment action id
721: - this should get balance for previous period (at the end) */