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.HR_US_ACCRUAL_PLANS dependencies on HR_UTILITY

Line 141: hr_utility.set_location('get_accrual_ineligibility', 1);

137: -- plan for the absence element the details are being retrieved from. There
138: -- may come a subsequent Enhancement Request to prevent users from setting
139: -- up more than one plan with the same absence element. RMF 05-Jan-96.
140: --
141: hr_utility.set_location('get_accrual_ineligibility', 1);
142:
143: open plan_for_input_value;
144: fetch plan_for_input_value into v_inel_length,
145: v_inel_period_type,

Line 158: hr_utility.set_location('get_accrual_ineligibility', 2);

154: close plan_for_input_value;
155: return;
156: end if;
157: --
158: hr_utility.set_location('get_accrual_ineligibility', 2);
159:
160: close plan_for_input_value;
161:
162: -- Now check for the assignment's enrollment into the plan

Line 185: hr_utility.set_location('get_accrual_ineligibility', 3);

181: --
182:
183: -- First check ineligible period, then check accrual start...
184:
185: hr_utility.set_location('get_accrual_ineligibility', 3);
186: hr_utility.trace('Service Start is: ' || v_service_start);
187: hr_utility.trace('Ineligible length is:' || v_inel_length);
188:
189: IF v_inel_length <> 0 THEN

Line 186: hr_utility.trace('Service Start is: ' || v_service_start);

182:
183: -- First check ineligible period, then check accrual start...
184:
185: hr_utility.set_location('get_accrual_ineligibility', 3);
186: hr_utility.trace('Service Start is: ' || v_service_start);
187: hr_utility.trace('Ineligible length is:' || v_inel_length);
188:
189: IF v_inel_length <> 0 THEN
190:

Line 187: hr_utility.trace('Ineligible length is:' || v_inel_length);

183: -- First check ineligible period, then check accrual start...
184:
185: hr_utility.set_location('get_accrual_ineligibility', 3);
186: hr_utility.trace('Service Start is: ' || v_service_start);
187: hr_utility.trace('Ineligible length is:' || v_inel_length);
188:
189: IF v_inel_length <> 0 THEN
190:
191: hr_utility.set_location('get_accrual_ineligibility', 4);

Line 191: hr_utility.set_location('get_accrual_ineligibility', 4);

187: hr_utility.trace('Ineligible length is:' || v_inel_length);
188:
189: IF v_inel_length <> 0 THEN
190:
191: hr_utility.set_location('get_accrual_ineligibility', 4);
192:
193: -- Calculate how many days are ineligible...
194: IF v_inel_period_type = 'CM' THEN
195:

Line 259: hr_utility.set_location('get_accrual_ineligibility', 5);

255: v_eligible_date := TRUNC(ADD_MONTHS(v_service_start, 12), 'YEAR');
256:
257: END IF;
258:
259: hr_utility.set_location('get_accrual_ineligibility', 5);
260: hr_utility.trace('Eligible Date is: ' || v_eligible_date);
261: hr_utility.trace('Session Date is: ' || p_sess_date);
262:
263: -- Eligible or what?

Line 260: hr_utility.trace('Eligible Date is: ' || v_eligible_date);

256:
257: END IF;
258:
259: hr_utility.set_location('get_accrual_ineligibility', 5);
260: hr_utility.trace('Eligible Date is: ' || v_eligible_date);
261: hr_utility.trace('Session Date is: ' || p_sess_date);
262:
263: -- Eligible or what?
264:

Line 261: hr_utility.trace('Session Date is: ' || p_sess_date);

257: END IF;
258:
259: hr_utility.set_location('get_accrual_ineligibility', 5);
260: hr_utility.trace('Eligible Date is: ' || v_eligible_date);
261: hr_utility.trace('Session Date is: ' || p_sess_date);
262:
263: -- Eligible or what?
264:
265: IF p_sess_date >= nvl(v_eligible_date,p_sess_date) THEN -- #4762608

Line 266: hr_utility.set_location('get_accrual_ineligibility', 6);

262:
263: -- Eligible or what?
264:
265: IF p_sess_date >= nvl(v_eligible_date,p_sess_date) THEN -- #4762608
266: hr_utility.set_location('get_accrual_ineligibility', 6);
267:
268: p_eligible := 'Y';
269:
270: ELSE

Line 271: hr_utility.set_location('get_accrual_ineligibility', 7);

267:
268: p_eligible := 'Y';
269:
270: ELSE
271: hr_utility.set_location('get_accrual_ineligibility', 7);
272:
273: p_eligible := 'N';
274:
275: END IF;

Line 380: hr_utility.set_location('calc_accrual_pay', 11);

376: -- Return immediately when no sick time has been taken.
377:
378: BEGIN
379:
380: hr_utility.set_location('calc_accrual_pay', 11);
381: IF p_mode = 'V' THEN
382:
383: hr_utility.set_location('calc_accrual_pay', 12);
384: OPEN get_vac_hours;

Line 383: hr_utility.set_location('calc_accrual_pay', 12);

379:
380: hr_utility.set_location('calc_accrual_pay', 11);
381: IF p_mode = 'V' THEN
382:
383: hr_utility.set_location('calc_accrual_pay', 12);
384: OPEN get_vac_hours;
385: LOOP
386:
387: hr_utility.set_location('calc_accrual_pay', 13);

Line 387: hr_utility.set_location('calc_accrual_pay', 13);

383: hr_utility.set_location('calc_accrual_pay', 12);
384: OPEN get_vac_hours;
385: LOOP
386:
387: hr_utility.set_location('calc_accrual_pay', 13);
388: FETCH get_vac_hours
389: INTO l_vac_hours;
390: EXIT WHEN get_vac_hours%NOTFOUND;
391:

Line 392: hr_utility.set_location('calc_accrual_pay', 14);

388: FETCH get_vac_hours
389: INTO l_vac_hours;
390: EXIT WHEN get_vac_hours%NOTFOUND;
391:
392: hr_utility.set_location('calc_accrual_pay', 14);
393: hr_utility.set_location('l_vac_hours =', l_vac_hours);
394: l_vac_tot_hrs := l_vac_tot_hrs + l_vac_hours;
395: hr_utility.set_location('l_vac_tot_hrs =', l_vac_tot_hrs);
396:

Line 393: hr_utility.set_location('l_vac_hours =', l_vac_hours);

389: INTO l_vac_hours;
390: EXIT WHEN get_vac_hours%NOTFOUND;
391:
392: hr_utility.set_location('calc_accrual_pay', 14);
393: hr_utility.set_location('l_vac_hours =', l_vac_hours);
394: l_vac_tot_hrs := l_vac_tot_hrs + l_vac_hours;
395: hr_utility.set_location('l_vac_tot_hrs =', l_vac_tot_hrs);
396:
397: END LOOP;

Line 395: hr_utility.set_location('l_vac_tot_hrs =', l_vac_tot_hrs);

391:
392: hr_utility.set_location('calc_accrual_pay', 14);
393: hr_utility.set_location('l_vac_hours =', l_vac_hours);
394: l_vac_tot_hrs := l_vac_tot_hrs + l_vac_hours;
395: hr_utility.set_location('l_vac_tot_hrs =', l_vac_tot_hrs);
396:
397: END LOOP;
398: CLOSE get_vac_hours;
399: hr_utility.set_location('calc_accrual_pay', 15);

Line 399: hr_utility.set_location('calc_accrual_pay', 15);

395: hr_utility.set_location('l_vac_tot_hrs =', l_vac_tot_hrs);
396:
397: END LOOP;
398: CLOSE get_vac_hours;
399: hr_utility.set_location('calc_accrual_pay', 15);
400:
401: IF l_vac_tot_hrs <> 0 THEN
402:
403: hr_utility.set_location('calc_accrual_pay', 16);

Line 403: hr_utility.set_location('calc_accrual_pay', 16);

399: hr_utility.set_location('calc_accrual_pay', 15);
400:
401: IF l_vac_tot_hrs <> 0 THEN
402:
403: hr_utility.set_location('calc_accrual_pay', 16);
404: l_vac_pay := p_hours_taken * p_curr_rate;
405:
406: ELSE
407:

Line 416: hr_utility.set_location('calc_accrual_pay', 17);

412: RETURN l_vac_pay;
413:
414: ELSIF p_mode = 'S' THEN
415:
416: hr_utility.set_location('calc_accrual_pay', 17);
417: OPEN get_sick_hours;
418: LOOP
419:
420: hr_utility.set_location('calc_accrual_pay', 18);

Line 420: hr_utility.set_location('calc_accrual_pay', 18);

416: hr_utility.set_location('calc_accrual_pay', 17);
417: OPEN get_sick_hours;
418: LOOP
419:
420: hr_utility.set_location('calc_accrual_pay', 18);
421: FETCH get_sick_hours
422: INTO l_sick_hours;
423: EXIT WHEN get_sick_hours%NOTFOUND;
424:

Line 425: hr_utility.set_location('calc_accrual_pay', 19);

421: FETCH get_sick_hours
422: INTO l_sick_hours;
423: EXIT WHEN get_sick_hours%NOTFOUND;
424:
425: hr_utility.set_location('calc_accrual_pay', 19);
426: l_sick_tot_hrs := l_sick_tot_hrs + l_sick_hours;
427:
428: END LOOP;
429: CLOSE get_sick_hours;

Line 430: hr_utility.set_location('calc_accrual_pay', 20);

426: l_sick_tot_hrs := l_sick_tot_hrs + l_sick_hours;
427:
428: END LOOP;
429: CLOSE get_sick_hours;
430: hr_utility.set_location('calc_accrual_pay', 20);
431: --
432: -- Rmonge 02/26/2002
433: -- Fix for bug 2006907
434: -- Changing sick_tot_hrs > 0 to sick_tot_hrs <> 0

Line 438: hr_utility.set_location('calc_accrual_pay', 21);

434: -- Changing sick_tot_hrs > 0 to sick_tot_hrs <> 0
435: --
436: IF l_sick_tot_hrs <> 0 THEN
437:
438: hr_utility.set_location('calc_accrual_pay', 21);
439: l_sick_pay := p_hours_taken * p_curr_rate;
440:
441: ELSE
442:

Line 451: hr_utility.set_location('Accrual Pay mode not set to V or S', 99);

447: RETURN l_sick_pay;
448:
449: ELSE
450:
451: hr_utility.set_location('Accrual Pay mode not set to V or S', 99);
452: l_vac_pay := 0;
453: return l_vac_pay;
454:
455: END IF;

Line 468: hr_utility.set_location('accrual_time_taken', 1);

464: l_hours_taken NUMBER(7,3) := 0;
465:
466: BEGIN
467:
468: hr_utility.set_location('accrual_time_taken', 1);
469: select sum(fnd_number.canonical_to_number(pev.screen_entry_value))
470: into l_hours_taken
471: from pay_accrual_plans pap,
472: pay_element_entries_f pee,

Line 484: hr_utility.set_location('accrual_time_taken', 3);

480: and pee.assignment_id = p_asg_id
481: and p_eff_date between pee.effective_start_date
482: and pee.effective_end_date;
483:
484: hr_utility.set_location('accrual_time_taken', 3);
485: return l_hours_taken;
486:
487: EXCEPTION
488:

Line 491: hr_utility.set_location('accrual_time_taken', 5);

487: EXCEPTION
488:
489: WHEN NO_DATA_FOUND THEN
490:
491: hr_utility.set_location('accrual_time_taken', 5);
492: return l_hours_taken;
493:
494: END accrual_time_taken;
495: