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

Line 116: hr_utility.set_location('Entering:'|| l_proc, 10);

112: l_proc varchar2(72) := g_package||'Find_Hours';
113:
114: Begin
115:
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: hr_utility.trace('p_date_start = ' || p_date_start);
118: While l_hours_index < l_monthly_hours.count and l_found = 'N' loop
119: l_hours_index := l_hours_index + 1;
120:

Line 117: hr_utility.trace('p_date_start = ' || p_date_start);

113:
114: Begin
115:
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: hr_utility.trace('p_date_start = ' || p_date_start);
118: While l_hours_index < l_monthly_hours.count and l_found = 'N' loop
119: l_hours_index := l_hours_index + 1;
120:
121: hr_utility.trace('mth hrs st and end = ' || ' ' || l_monthly_hours(l_hours_index).date_from || ' ' || l_monthly_hours(l_hours_index).date_to);

Line 121: hr_utility.trace('mth hrs st and end = ' || ' ' || l_monthly_hours(l_hours_index).date_from || ' ' || l_monthly_hours(l_hours_index).date_to);

117: hr_utility.trace('p_date_start = ' || p_date_start);
118: While l_hours_index < l_monthly_hours.count and l_found = 'N' loop
119: l_hours_index := l_hours_index + 1;
120:
121: hr_utility.trace('mth hrs st and end = ' || ' ' || l_monthly_hours(l_hours_index).date_from || ' ' || l_monthly_hours(l_hours_index).date_to);
122:
123:
124: If p_date_start between l_monthly_hours(l_hours_index).date_from and
125: l_monthly_hours(l_hours_index).date_to Then

Line 133: hr_utility.trace('no monthly reference hours found for date ' || p_date_start);

129:
130: If l_found = 'Y' Then
131: Return l_hours_index;
132: Else
133: hr_utility.trace('no monthly reference hours found for date ' || p_date_start);
134: Return 0;
135: End If;
136:
137: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 137: hr_utility.set_location(' Leaving:'||l_proc, 70);

133: hr_utility.trace('no monthly reference hours found for date ' || p_date_start);
134: Return 0;
135: End If;
136:
137: hr_utility.set_location(' Leaving:'||l_proc, 70);
138:
139: End;
140:
141: Procedure Calculate_Service(p_hours_index in number,

Line 157: hr_utility.set_location('Entering:'|| l_proc, 10);

153: l_proc varchar2(72) := g_package||'Calculate_Service';
154:
155: Begin
156:
157: hr_utility.set_location('Entering:'|| l_proc, 10);
158: hr_utility.trace('p_start = '|| p_start_period || 'p_end_period = ' || p_end_period);
159:
160: l_number_of_months := months_between(p_end_period + 1,p_start_period);
161: IF l_assignments(i).part_time_flag = 'P' THEN

Line 158: hr_utility.trace('p_start = '|| p_start_period || 'p_end_period = ' || p_end_period);

154:
155: Begin
156:
157: hr_utility.set_location('Entering:'|| l_proc, 10);
158: hr_utility.trace('p_start = '|| p_start_period || 'p_end_period = ' || p_end_period);
159:
160: l_number_of_months := months_between(p_end_period + 1,p_start_period);
161: IF l_assignments(i).part_time_flag = 'P' THEN
162: /* Convert the assignment normal hours to a monthly frequency if it is not monthly already */

Line 181: hr_utility.trace('l_actual_months_worked = ' || l_actual_months_worked);

177:
178: l_actual_months_worked := l_number_of_months *
179: (l_normal_monthly_hours/ l_monthly_hours(p_hours_index).monthly_hours);
180:
181: hr_utility.trace('l_actual_months_worked = ' || l_actual_months_worked);
182: hr_utility.trace('l_number_of_months = ' || l_number_of_months );
183: hr_utility.trace('l_normal_monthly_hours = ' || l_normal_monthly_hours);
184: hr_utility.trace('l_monthly_hours(l_indx) = ' || l_monthly_hours(p_hours_index).monthly_hours);
185:

Line 182: hr_utility.trace('l_number_of_months = ' || l_number_of_months );

178: l_actual_months_worked := l_number_of_months *
179: (l_normal_monthly_hours/ l_monthly_hours(p_hours_index).monthly_hours);
180:
181: hr_utility.trace('l_actual_months_worked = ' || l_actual_months_worked);
182: hr_utility.trace('l_number_of_months = ' || l_number_of_months );
183: hr_utility.trace('l_normal_monthly_hours = ' || l_normal_monthly_hours);
184: hr_utility.trace('l_monthly_hours(l_indx) = ' || l_monthly_hours(p_hours_index).monthly_hours);
185:
186: ELSE

Line 183: hr_utility.trace('l_normal_monthly_hours = ' || l_normal_monthly_hours);

179: (l_normal_monthly_hours/ l_monthly_hours(p_hours_index).monthly_hours);
180:
181: hr_utility.trace('l_actual_months_worked = ' || l_actual_months_worked);
182: hr_utility.trace('l_number_of_months = ' || l_number_of_months );
183: hr_utility.trace('l_normal_monthly_hours = ' || l_normal_monthly_hours);
184: hr_utility.trace('l_monthly_hours(l_indx) = ' || l_monthly_hours(p_hours_index).monthly_hours);
185:
186: ELSE
187: l_actual_months_worked := l_number_of_months;

Line 184: hr_utility.trace('l_monthly_hours(l_indx) = ' || l_monthly_hours(p_hours_index).monthly_hours);

180:
181: hr_utility.trace('l_actual_months_worked = ' || l_actual_months_worked);
182: hr_utility.trace('l_number_of_months = ' || l_number_of_months );
183: hr_utility.trace('l_normal_monthly_hours = ' || l_normal_monthly_hours);
184: hr_utility.trace('l_monthly_hours(l_indx) = ' || l_monthly_hours(p_hours_index).monthly_hours);
185:
186: ELSE
187: l_actual_months_worked := l_number_of_months;
188:

Line 189: hr_utility.trace('l_number_of_months = ' || l_number_of_months );

185:
186: ELSE
187: l_actual_months_worked := l_number_of_months;
188:
189: hr_utility.trace('l_number_of_months = ' || l_number_of_months );
190:
191: END IF;
192:
193: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 193: hr_utility.set_location(' Leaving:'||l_proc, 70);

189: hr_utility.trace('l_number_of_months = ' || l_number_of_months );
190:
191: END IF;
192:
193: hr_utility.set_location(' Leaving:'||l_proc, 70);
194:
195: Return l_actual_months_worked;
196:
197: End;

Line 201: hr_utility.set_location('Entering:'|| l_proc, 10);

197: End;
198:
199: Begin
200:
201: hr_utility.set_location('Entering:'|| l_proc, 10);
202:
203: /* Is this service in the pre service period or service in the post period ? We may need to
204: split this service up so that the correct amount is processed in the pre and post periods */
205:

Line 220: hr_utility.set_location(' Leaving:'||l_proc, 70);

216: p_start > l_date_greater_than_10_years Then /* then all post service */
217: l_total_post_service := l_total_post_service + Calculate_Pre_and_Post_Service (p_start, p_end);
218: End if;
219:
220: hr_utility.set_location(' Leaving:'||l_proc, 70);
221:
222: End;
223:
224: Procedure Process_days(p_hours_index in number , p_date_end in date) is

Line 235: hr_utility.set_location('Entering:'|| l_proc, 10);

231: l_proc varchar2(72) := g_package||'Process_days';
232:
233: Begin
234:
235: hr_utility.set_location('Entering:'|| l_proc, 10);
236:
237: l_hours_index := p_hours_index;
238: l_new_date_start := l_assignments(i).effective_start_date;
239: l_new_date_end := least(p_date_end,l_assignments(i).effective_end_date);

Line 252: hr_utility.set_location(' Leaving:'||l_proc, 70);

248: l_found_hours := 'N';
249: End If;
250: End Loop;
251:
252: hr_utility.set_location(' Leaving:'||l_proc, 70);
253:
254: EXCEPTION
255: when others then
256: hr_utility.set_location('process_details',20);

Line 256: hr_utility.set_location('process_details',20);

252: hr_utility.set_location(' Leaving:'||l_proc, 70);
253:
254: EXCEPTION
255: when others then
256: hr_utility.set_location('process_details',20);
257: hr_utility.trace(SQLCODE);
258: hr_utility.trace(SQLERRM);
259: Raise;
260:

Line 257: hr_utility.trace(SQLCODE);

253:
254: EXCEPTION
255: when others then
256: hr_utility.set_location('process_details',20);
257: hr_utility.trace(SQLCODE);
258: hr_utility.trace(SQLERRM);
259: Raise;
260:
261: End Process_days;

Line 258: hr_utility.trace(SQLERRM);

254: EXCEPTION
255: when others then
256: hr_utility.set_location('process_details',20);
257: hr_utility.trace(SQLCODE);
258: hr_utility.trace(SQLERRM);
259: Raise;
260:
261: End Process_days;
262:

Line 269: hr_utility.set_location('Entering:'|| l_proc, 10);

265: l_proc varchar2(72) := g_package||'Process_assignment_row';
266: l_index number :=0;
267: Begin
268:
269: hr_utility.set_location('Entering:'|| l_proc, 10);
270: hr_utility.trace('l_assignments(i).effective_start_date = ' || l_assignments(i).effective_start_date);
271:
272: l_index := Find_Hours(l_assignments(i).effective_start_date); -- will always contain at least one row
273:

Line 270: hr_utility.trace('l_assignments(i).effective_start_date = ' || l_assignments(i).effective_start_date);

266: l_index number :=0;
267: Begin
268:
269: hr_utility.set_location('Entering:'|| l_proc, 10);
270: hr_utility.trace('l_assignments(i).effective_start_date = ' || l_assignments(i).effective_start_date);
271:
272: l_index := Find_Hours(l_assignments(i).effective_start_date); -- will always contain at least one row
273:
274: hr_utility.trace('l_monthly_hours(l_index).date_to = ' || l_monthly_hours(l_index).date_to);

Line 274: hr_utility.trace('l_monthly_hours(l_index).date_to = ' || l_monthly_hours(l_index).date_to);

270: hr_utility.trace('l_assignments(i).effective_start_date = ' || l_assignments(i).effective_start_date);
271:
272: l_index := Find_Hours(l_assignments(i).effective_start_date); -- will always contain at least one row
273:
274: hr_utility.trace('l_monthly_hours(l_index).date_to = ' || l_monthly_hours(l_index).date_to);
275:
276: Process_days(l_index,l_monthly_hours(l_index).date_to);
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 278: hr_utility.set_location(' Leaving:'||l_proc, 70);

274: hr_utility.trace('l_monthly_hours(l_index).date_to = ' || l_monthly_hours(l_index).date_to);
275:
276: Process_days(l_index,l_monthly_hours(l_index).date_to);
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 70);
279:
280: End Process_assignment_row;
281:
282: BEGIN

Line 284: hr_utility.set_location('Entering:'|| l_proc, 10);

280: End Process_assignment_row;
281:
282: BEGIN
283:
284: hr_utility.set_location('Entering:'|| l_proc, 10);
285:
286: l_10_years_ago := add_months (p_termination_date,-120);
287:
288: select distinct person_id

Line 307: hr_utility.trace ('hire date = ' || l_hire_date);

303: -- l_greater_than_10_years_service = 'N';
304: l_date_greater_than_10_years := p_termination_date + 365;
305: END IF;
306:
307: hr_utility.trace ('hire date = ' || l_hire_date);
308: hr_utility.trace ('l_date_greater_than_10_years = ' || l_date_greater_than_10_years);
309:
310: l_indx := 1;
311: For a in assignments(l_person_id) loop

Line 308: hr_utility.trace ('l_date_greater_than_10_years = ' || l_date_greater_than_10_years);

304: l_date_greater_than_10_years := p_termination_date + 365;
305: END IF;
306:
307: hr_utility.trace ('hire date = ' || l_hire_date);
308: hr_utility.trace ('l_date_greater_than_10_years = ' || l_date_greater_than_10_years);
309:
310: l_indx := 1;
311: For a in assignments(l_person_id) loop
312: l_assignments(l_indx).effective_start_date := a.effective_start_date;

Line 330: hr_utility.trace('last period of service_id = ' || l_assignments(l_assignments.last).period_of_service_id);

326: End loop;
327:
328: /* For the last assignment effective end date, make it equal to the last day worked */
329:
330: hr_utility.trace('last period of service_id = ' || l_assignments(l_assignments.last).period_of_service_id);
331: l_period_of_service_id := l_assignments(l_assignments.last).period_of_service_id;
332: Select fnd_date.canonical_to_date(pds_information10)
333: into
334: l_last_day_worked

Line 340: hr_utility.trace ('start date 1 = ' || l_assignments(1).effective_start_date);

336: where period_of_service_id = l_period_of_service_id;
337:
338: l_assignments(l_assignments.last).effective_end_date := l_last_day_worked;
339:
340: hr_utility.trace ('start date 1 = ' || l_assignments(1).effective_start_date);
341:
342: i :=0;
343: While i < l_assignments.last Loop
344: i := i + 1;

Line 357: hr_utility.trace('date from and date to = ' || l_monthly_hours(l_indx).date_from || ' ' || l_monthly_hours(l_indx).date_to);

353: l_monthly_hours(l_indx).monthly_hours := h.monthly_hours;
354: l_monthly_hours(l_indx).date_from := h.date_from;
355: l_monthly_hours(l_indx).date_to := h.date_to;
356:
357: hr_utility.trace('date from and date to = ' || l_monthly_hours(l_indx).date_from || ' ' || l_monthly_hours(l_indx).date_to);
358: l_indx := l_indx + 1;
359: End loop;
360:
361: /* If any historical reference hours were found then add a row at the beginning of the table to cater

Line 367: hr_utility.trace(' 1. l_indx = ' || l_indx || ' count = ' || l_monthly_hours.count);

363: no historical data then we still want to process the assignments so use the current monthly reference
364: hours - store this in the last row.
365: */
366:
367: hr_utility.trace(' 1. l_indx = ' || l_indx || ' count = ' || l_monthly_hours.count);
368:
369: If l_monthly_hours.count > 0 Then
370: IF l_assignments(1).effective_start_date < l_monthly_hours(2).date_from Then
371: l_monthly_hours(1).date_from := l_assignments(1).effective_start_date - 50;

Line 386: hr_utility.trace('l_indx = ' || l_indx || ' count = ' || l_monthly_hours.count);

382: l_monthly_hours(1).monthly_hours := l_monthly_hours(2).monthly_hours;
383: l_monthly_hours(l_indx).monthly_hours := l_current_monthly_ref_hours;
384: l_monthly_hours(l_indx).date_from := l_monthly_hours(l_indx - 1).date_to + 1;
385:
386: hr_utility.trace('l_indx = ' || l_indx || ' count = ' || l_monthly_hours.count);
387: hr_utility.trace(' l_monthly_hours.date to = ' || l_monthly_hours(l_monthly_hours.count).date_to);
388: hr_utility.trace(' l_monthly_hours(l_indx).date_from = ' || l_monthly_hours(l_indx).date_from);
389:
390: l_monthly_hours(l_indx).date_to := l_assignments(l_assignments.last).effective_end_date + 365;

Line 387: hr_utility.trace(' l_monthly_hours.date to = ' || l_monthly_hours(l_monthly_hours.count).date_to);

383: l_monthly_hours(l_indx).monthly_hours := l_current_monthly_ref_hours;
384: l_monthly_hours(l_indx).date_from := l_monthly_hours(l_indx - 1).date_to + 1;
385:
386: hr_utility.trace('l_indx = ' || l_indx || ' count = ' || l_monthly_hours.count);
387: hr_utility.trace(' l_monthly_hours.date to = ' || l_monthly_hours(l_monthly_hours.count).date_to);
388: hr_utility.trace(' l_monthly_hours(l_indx).date_from = ' || l_monthly_hours(l_indx).date_from);
389:
390: l_monthly_hours(l_indx).date_to := l_assignments(l_assignments.last).effective_end_date + 365;
391: Else

Line 388: hr_utility.trace(' l_monthly_hours(l_indx).date_from = ' || l_monthly_hours(l_indx).date_from);

384: l_monthly_hours(l_indx).date_from := l_monthly_hours(l_indx - 1).date_to + 1;
385:
386: hr_utility.trace('l_indx = ' || l_indx || ' count = ' || l_monthly_hours.count);
387: hr_utility.trace(' l_monthly_hours.date to = ' || l_monthly_hours(l_monthly_hours.count).date_to);
388: hr_utility.trace(' l_monthly_hours(l_indx).date_from = ' || l_monthly_hours(l_indx).date_from);
389:
390: l_monthly_hours(l_indx).date_to := l_assignments(l_assignments.last).effective_end_date + 365;
391: Else
392: l_monthly_hours(1).monthly_hours := l_current_monthly_ref_hours;

Line 413: hr_utility.set_location(' Leaving:'||l_proc, 70);

409: -- p_post_service_ratio := round(l_total_post_service);
410:
411: Return 0;
412:
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414:
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN
417: hr_utility.trace('No Data Found');

Line 417: hr_utility.trace('No Data Found');

413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414:
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN
417: hr_utility.trace('No Data Found');
418: p_pre_service_ratio := 0;
419: p_post_service_ratio := 0;
420: RETURN 999;
421:

Line 425: hr_utility.trace('raised exception ZERO_NORMAL_HOURS - raised when part time employee has no values for

421:
422: WHEN ZERO_NORMAL_HOURS THEN
423: p_pre_service_ratio := 0;
424: p_post_service_ratio := 0;
425: hr_utility.trace('raised exception ZERO_NORMAL_HOURS - raised when part time employee has no values for
426: assignment normal hours or frequency');
427: RETURN 998;
428: RAISE;
429:

Line 432: hr_utility.set_location('l_proc',80);

428: RAISE;
429:
430:
431: when others then
432: hr_utility.set_location('l_proc',80);
433: hr_utility.trace(SQLCODE);
434: hr_utility.trace(SQLERRM);
435: p_pre_service_ratio := 0;
436: p_post_service_ratio := 0;

Line 433: hr_utility.trace(SQLCODE);

429:
430:
431: when others then
432: hr_utility.set_location('l_proc',80);
433: hr_utility.trace(SQLCODE);
434: hr_utility.trace(SQLERRM);
435: p_pre_service_ratio := 0;
436: p_post_service_ratio := 0;
437: RETURN 999;

Line 434: hr_utility.trace(SQLERRM);

430:
431: when others then
432: hr_utility.set_location('l_proc',80);
433: hr_utility.trace(SQLCODE);
434: hr_utility.trace(SQLERRM);
435: p_pre_service_ratio := 0;
436: p_post_service_ratio := 0;
437: RETURN 999;
438: Raise;