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

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

21:
22: BEGIN
23:
24: l_proc := 'per_abs_shadow_booking_pkg.validate_params';
25: hr_utility.set_location('Entering: '|| l_proc, 10);
26:
27: IF p_mode IN ('CRE','UPD','DEL','GET') THEN
28: -- Check that either person id or assignment id is supplied
29: IF p_person_id IS NULL AND p_assignment_id IS NULL THEN

Line 34: hr_utility.set_location(l_proc, 20);

30: RAISE e_invalid_params;
31: END IF;
32: END IF;
33:
34: hr_utility.set_location(l_proc, 20);
35:
36: IF p_mode IN ('CRE','UPD','DEL') THEN
37: -- Check that absence id is supplied
38: IF p_absence_id IS NULL THEN

Line 43: hr_utility.set_location(l_proc, 30);

39: RAISE e_invalid_params;
40: END IF;
41: END IF;
42:
43: hr_utility.set_location(l_proc, 30);
44:
45: IF p_mode IN ('CRE') THEN
46: -- Check that start date is supplied
47: IF p_start_date IS NULL THEN

Line 52: hr_utility.set_location('Leaving: '|| l_proc, 40);

48: RAISE e_invalid_params;
49: END IF;
50: END IF;
51:
52: hr_utility.set_location('Leaving: '|| l_proc, 40);
53:
54: RETURN TRUE;
55:
56: EXCEPTION

Line 59: hr_utility.set_location('Leaving: '|| l_proc, 50);

55:
56: EXCEPTION
57:
58: WHEN e_invalid_params THEN
59: hr_utility.set_location('Leaving: '|| l_proc, 50);
60: RETURN FALSE;
61:
62: WHEN OTHERS THEN
63: hr_utility.set_location('Leaving: '|| l_proc, 60);

Line 63: hr_utility.set_location('Leaving: '|| l_proc, 60);

59: hr_utility.set_location('Leaving: '|| l_proc, 50);
60: RETURN FALSE;
61:
62: WHEN OTHERS THEN
63: hr_utility.set_location('Leaving: '|| l_proc, 60);
64: hr_utility.set_location(SQLERRM, 65);
65: RETURN FALSE;
66:
67: END validate_params;

Line 64: hr_utility.set_location(SQLERRM, 65);

60: RETURN FALSE;
61:
62: WHEN OTHERS THEN
63: hr_utility.set_location('Leaving: '|| l_proc, 60);
64: hr_utility.set_location(SQLERRM, 65);
65: RETURN FALSE;
66:
67: END validate_params;
68:

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

94:
95: BEGIN
96:
97: l_proc := 'per_abs_shadow_booking_pkg.get_primary_asg';
98: hr_utility.set_location('Entering: '|| l_proc, 10);
99:
100: OPEN c_prim_asg ( p_person_id
101: , p_start_date
102: , p_end_date

Line 107: hr_utility.set_location('PerId:'||p_person_id||

103: );
104: FETCH c_prim_asg INTO l_assignment_id;
105: CLOSE c_prim_asg;
106:
107: hr_utility.set_location('PerId:'||p_person_id||
108: ' AsgId:'||l_assignment_id, 20);
109:
110: RETURN l_assignment_id;
111:

Line 115: hr_utility.set_location('Leaving: '|| l_proc, 30);

111:
112: EXCEPTION
113:
114: WHEN OTHERS THEN
115: hr_utility.set_location('Leaving: '|| l_proc, 30);
116: hr_utility.set_location(SQLERRM, 35);
117: RETURN NULL;
118:
119: END get_primary_asg;

Line 116: hr_utility.set_location(SQLERRM, 35);

112: EXCEPTION
113:
114: WHEN OTHERS THEN
115: hr_utility.set_location('Leaving: '|| l_proc, 30);
116: hr_utility.set_location(SQLERRM, 35);
117: RETURN NULL;
118:
119: END get_primary_asg;
120:

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

137:
138: BEGIN
139:
140: l_proc := 'per_abs_shadow_booking_pkg.get_bkg_type_id';
141: hr_utility.set_location('Entering: '|| l_proc, 10);
142:
143: OPEN c_bkg_type_id ( p_bkg_type
144: );
145: FETCH c_bkg_type_id INTO l_bkg_type_id;

Line 148: hr_utility.set_location('BkgTypId:'||l_bkg_type_id, 20);

144: );
145: FETCH c_bkg_type_id INTO l_bkg_type_id;
146: CLOSE c_bkg_type_id;
147:
148: hr_utility.set_location('BkgTypId:'||l_bkg_type_id, 20);
149:
150: RETURN l_bkg_type_id;
151:
152: EXCEPTION

Line 155: hr_utility.set_location('Leaving: '|| l_proc, 30);

151:
152: EXCEPTION
153:
154: WHEN OTHERS THEN
155: hr_utility.set_location('Leaving: '|| l_proc, 30);
156: hr_utility.set_location(SQLERRM, 35);
157: RETURN NULL;
158:
159: END get_bkg_type_id;

Line 156: hr_utility.set_location(SQLERRM, 35);

152: EXCEPTION
153:
154: WHEN OTHERS THEN
155: hr_utility.set_location('Leaving: '|| l_proc, 30);
156: hr_utility.set_location(SQLERRM, 35);
157: RETURN NULL;
158:
159: END get_bkg_type_id;
160:

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

183:
184: BEGIN
185:
186: l_proc := 'per_abs_shadow_booking_pkg.get_bkg_id';
187: hr_utility.set_location('Entering: '|| l_proc, 10);
188:
189: OPEN c_bkg_id ( p_abs_id );
190: FETCH c_bkg_id INTO l_bkg_id
191: ,l_bkg_ovn;

Line 194: hr_utility.set_location('BkgId:'||l_bkg_id||' BkgOVN:'||l_bkg_ovn, 20);

190: FETCH c_bkg_id INTO l_bkg_id
191: ,l_bkg_ovn;
192: CLOSE c_bkg_id;
193:
194: hr_utility.set_location('BkgId:'||l_bkg_id||' BkgOVN:'||l_bkg_ovn, 20);
195:
196: p_bkg_id := l_bkg_id;
197: p_bkg_ovn := l_bkg_ovn;
198:

Line 202: hr_utility.set_location('Leaving: '|| l_proc, 30);

198:
199: EXCEPTION
200:
201: WHEN OTHERS THEN
202: hr_utility.set_location('Leaving: '|| l_proc, 30);
203: hr_utility.set_location(SQLERRM, 35);
204:
205: END get_bkg_id;
206:

Line 203: hr_utility.set_location(SQLERRM, 35);

199: EXCEPTION
200:
201: WHEN OTHERS THEN
202: hr_utility.set_location('Leaving: '|| l_proc, 30);
203: hr_utility.set_location(SQLERRM, 35);
204:
205: END get_bkg_id;
206:
207: -----------------------------------------------------------------------------

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

232:
233: BEGIN
234:
235: l_proc := 'per_abs_shadow_booking_pkg.create_shadow_booking';
236: hr_utility.set_location('Entering: '|| l_proc, 10);
237: x_booking_id := NULL;
238: x_return_status := '0';
239: x_return_message := '';
240:

Line 251: hr_utility.set_location(l_proc, 20);

247: ) THEN
248: RAISE e_invalid_params;
249: END IF;
250:
251: hr_utility.set_location(l_proc, 20);
252:
253: IF p_person_id IS NOT NULL AND p_assignment_id IS NULL THEN
254: l_assignment_id := get_primary_asg( p_person_id
255: , p_start_date

Line 260: hr_utility.set_location(l_proc, 30);

256: , p_end_date
257: );
258: END IF;
259:
260: hr_utility.set_location(l_proc, 30);
261:
262: -- Setup up the booking record details
263: lr_new_booking.booking_id := NULL;
264: lr_new_booking.resource_type_code := 'PERSON_ASSIGNMENT';

Line 279: hr_utility.set_location(l_proc, 40);

275: lr_new_booking.source_object_id := p_absence_id;
276: lr_new_booking.booking_subject := 'ABSENCE BOOKING';
277: lr_new_booking.freebusytype := 'BUSY';
278:
279: hr_utility.set_location(l_proc, 40);
280:
281: -- Invoke JTF Bookings API
282: cac_bookings_pub.create_booking
283: ( p_api_version => 1.0

Line 293: hr_utility.set_location(l_proc, 50);

289: , x_msg_count => l_msg_count
290: , x_msg_data => l_msg_data
291: );
292:
293: hr_utility.set_location(l_proc, 50);
294:
295: CASE l_return_status
296: WHEN 'S' THEN
297: x_return_status := '0';

Line 303: hr_utility.set_location('Leaving: '|| l_proc, 60);

299: x_return_status := '2';
300: x_return_message := l_msg_data;
301: END CASE;
302:
303: hr_utility.set_location('Leaving: '|| l_proc, 60);
304:
305: EXCEPTION
306:
307: WHEN e_invalid_params THEN

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

304:
305: EXCEPTION
306:
307: WHEN e_invalid_params THEN
308: hr_utility.set_location('Leaving: '|| l_proc, 70);
309: x_return_status := '2';
310:
311: WHEN OTHERS THEN
312: hr_utility.set_location('Leaving: '|| l_proc, 80);

Line 312: hr_utility.set_location('Leaving: '|| l_proc, 80);

308: hr_utility.set_location('Leaving: '|| l_proc, 70);
309: x_return_status := '2';
310:
311: WHEN OTHERS THEN
312: hr_utility.set_location('Leaving: '|| l_proc, 80);
313: hr_utility.set_location(SQLERRM, 85);
314: x_return_status := '2';
315: x_return_message := SQLERRM;
316:

Line 313: hr_utility.set_location(SQLERRM, 85);

309: x_return_status := '2';
310:
311: WHEN OTHERS THEN
312: hr_utility.set_location('Leaving: '|| l_proc, 80);
313: hr_utility.set_location(SQLERRM, 85);
314: x_return_status := '2';
315: x_return_message := SQLERRM;
316:
317: END create_shadow_booking;

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

344:
345: BEGIN
346:
347: l_proc := 'per_abs_shadow_booking_pkg.update_shadow_booking';
348: hr_utility.set_location('Entering: '|| l_proc, 10);
349: x_return_status := '0';
350: x_return_message := '';
351:
352: IF NOT validate_params('UPD' -- Mode

Line 362: hr_utility.set_location(l_proc, 20);

358: ) THEN
359: RAISE e_invalid_params;
360: END IF;
361:
362: hr_utility.set_location(l_proc, 20);
363:
364: IF p_person_id IS NOT NULL AND p_assignment_id IS NULL THEN
365: l_assignment_id := get_primary_asg( p_person_id
366: , p_start_date

Line 371: hr_utility.set_location(l_proc, 30);

367: , p_end_date
368: );
369: END IF;
370:
371: hr_utility.set_location(l_proc, 30);
372:
373: -- Get the booking details
374: get_bkg_id( p_absence_id
375: , lr_booking.booking_id

Line 379: hr_utility.set_location(l_proc, 40);

375: , lr_booking.booking_id
376: , l_booking_ovn
377: );
378:
379: hr_utility.set_location(l_proc, 40);
380:
381: -- Setup up the booking record details
382: lr_booking.resource_type_code := 'PERSON_ASSIGNMENT';
383: IF p_assignment_id IS NULL THEN

Line 397: hr_utility.set_location(l_proc, 50);

393: lr_booking.source_object_id := p_absence_id;
394: lr_booking.booking_subject := 'ABSENCE BOOKING';
395: lr_booking.freebusytype := 'BUSY';
396:
397: hr_utility.set_location(l_proc, 50);
398:
399: -- Invoke JTF Bookings API
400: cac_bookings_pub.update_booking
401: ( p_api_version => 1.0

Line 411: hr_utility.set_location(l_proc, 60);

407: , x_msg_count => l_msg_count
408: , x_msg_data => l_msg_data
409: );
410:
411: hr_utility.set_location(l_proc, 60);
412:
413: CASE l_return_status
414: WHEN 'S' THEN
415: x_return_status := '0';

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

417: x_return_status := '2';
418: x_return_message := l_msg_data;
419: END CASE;
420:
421: hr_utility.set_location('Leaving: '|| l_proc, 70);
422:
423: EXCEPTION
424:
425: WHEN e_invalid_params THEN

Line 426: hr_utility.set_location('Leaving: '|| l_proc, 80);

422:
423: EXCEPTION
424:
425: WHEN e_invalid_params THEN
426: hr_utility.set_location('Leaving: '|| l_proc, 80);
427: x_return_status := '2';
428:
429: WHEN OTHERS THEN
430: hr_utility.set_location('Leaving: '|| l_proc, 90);

Line 430: hr_utility.set_location('Leaving: '|| l_proc, 90);

426: hr_utility.set_location('Leaving: '|| l_proc, 80);
427: x_return_status := '2';
428:
429: WHEN OTHERS THEN
430: hr_utility.set_location('Leaving: '|| l_proc, 90);
431: hr_utility.set_location(SQLERRM, 95);
432: x_return_status := '2';
433: x_return_message := SQLERRM;
434:

Line 431: hr_utility.set_location(SQLERRM, 95);

427: x_return_status := '2';
428:
429: WHEN OTHERS THEN
430: hr_utility.set_location('Leaving: '|| l_proc, 90);
431: hr_utility.set_location(SQLERRM, 95);
432: x_return_status := '2';
433: x_return_message := SQLERRM;
434:
435: END update_shadow_booking;

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

460:
461: BEGIN
462:
463: l_proc := 'per_abs_shadow_booking_pkg.delete_shadow_booking';
464: hr_utility.set_location('Entering: '|| l_proc, 10);
465: x_return_status := '0';
466: x_return_message := '';
467:
468: IF NOT validate_params('DEL' -- Mode

Line 478: hr_utility.set_location(l_proc, 20);

474: ) THEN
475: RAISE e_invalid_params;
476: END IF;
477:
478: hr_utility.set_location(l_proc, 20);
479:
480: IF p_person_id IS NOT NULL AND p_assignment_id IS NULL THEN
481: l_assignment_id := get_primary_asg( p_person_id
482: , NULL -- start date

Line 487: hr_utility.set_location(l_proc, 30);

483: , NULL -- end date
484: );
485: END IF;
486:
487: hr_utility.set_location(l_proc, 30);
488:
489: -- Get the booking details
490: get_bkg_id( p_absence_id
491: , l_booking_id

Line 495: hr_utility.set_location(l_proc, 40);

491: , l_booking_id
492: , l_booking_ovn
493: );
494:
495: hr_utility.set_location(l_proc, 40);
496:
497: -- Invoke JTF Bookings API
498: cac_bookings_pub.delete_booking
499: ( p_api_version => 1.0

Line 509: hr_utility.set_location(l_proc, 50);

505: , x_msg_count => l_msg_count
506: , x_msg_data => l_msg_data
507: );
508:
509: hr_utility.set_location(l_proc, 50);
510:
511: CASE l_return_status
512: WHEN 'S' THEN
513: x_return_status := '0';

Line 519: hr_utility.set_location('Leaving: '|| l_proc, 60);

515: x_return_status := '2';
516: x_return_message := l_msg_data;
517: END CASE;
518:
519: hr_utility.set_location('Leaving: '|| l_proc, 60);
520:
521: EXCEPTION
522:
523: WHEN e_invalid_params THEN

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

520:
521: EXCEPTION
522:
523: WHEN e_invalid_params THEN
524: hr_utility.set_location('Leaving: '|| l_proc, 70);
525: x_return_status := '2';
526:
527: WHEN OTHERS THEN
528: hr_utility.set_location('Leaving: '|| l_proc, 80);

Line 528: hr_utility.set_location('Leaving: '|| l_proc, 80);

524: hr_utility.set_location('Leaving: '|| l_proc, 70);
525: x_return_status := '2';
526:
527: WHEN OTHERS THEN
528: hr_utility.set_location('Leaving: '|| l_proc, 80);
529: hr_utility.set_location(SQLERRM, 85);
530: x_return_status := '2';
531: x_return_message := SQLERRM;
532:

Line 529: hr_utility.set_location(SQLERRM, 85);

525: x_return_status := '2';
526:
527: WHEN OTHERS THEN
528: hr_utility.set_location('Leaving: '|| l_proc, 80);
529: hr_utility.set_location(SQLERRM, 85);
530: x_return_status := '2';
531: x_return_message := SQLERRM;
532:
533: END delete_shadow_booking;

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

560:
561: BEGIN
562:
563: l_proc := 'per_abs_shadow_booking_pkg.get_shadow_booking';
564: hr_utility.set_location('Entering: '|| l_proc, 10);
565: l_booking_obj := per_abs_booking_obj(NULL,NULL,NULL,NULL,NULL,
566: NULL,NULL,NULL,NULL,NULL);
567: x_bookings := per_abs_booking_varray();
568: x_return_status := '0';

Line 581: hr_utility.set_location(l_proc, 20);

577: ) THEN
578: RAISE e_invalid_params;
579: END IF;
580:
581: hr_utility.set_location(l_proc, 20);
582:
583: -- Cursor to fetch bookings
584: OPEN c_bkgs FOR ' SELECT T.task_id'||
585: ',T.source_object_id'||

Line 603: hr_utility.set_location(l_proc, 30);

599: USING p_assignment_id
600: ,p_start_date
601: ,p_end_date;
602:
603: hr_utility.set_location(l_proc, 30);
604:
605: LOOP -- loop for bookings
606: FETCH c_bkgs INTO l_booking_obj.booking_id
607: ,l_booking_obj.absence_id

Line 614: hr_utility.set_location('BkgId:'||l_booking_obj.booking_id||

610: ,l_booking_obj.end_date
611: ,l_booking_obj.free_busy;
612: EXIT WHEN c_bkgs%NOTFOUND;
613:
614: hr_utility.set_location('BkgId:'||l_booking_obj.booking_id||
615: ' AbsId:'||l_booking_obj.absence_id, 35);
616:
617: -- Save object to array
618: x_bookings.EXTEND(1);

Line 624: hr_utility.set_location('Leaving: '|| l_proc, 40);

620:
621: END LOOP; -- loop for bookings
622: CLOSE c_bkgs;
623:
624: hr_utility.set_location('Leaving: '|| l_proc, 40);
625:
626: EXCEPTION
627:
628: WHEN e_invalid_params THEN

Line 629: hr_utility.set_location('Leaving: '|| l_proc, 50);

625:
626: EXCEPTION
627:
628: WHEN e_invalid_params THEN
629: hr_utility.set_location('Leaving: '|| l_proc, 50);
630: x_return_status := '2';
631:
632: WHEN OTHERS THEN
633: hr_utility.set_location('Leaving: '|| l_proc, 60);

Line 633: hr_utility.set_location('Leaving: '|| l_proc, 60);

629: hr_utility.set_location('Leaving: '|| l_proc, 50);
630: x_return_status := '2';
631:
632: WHEN OTHERS THEN
633: hr_utility.set_location('Leaving: '|| l_proc, 60);
634: hr_utility.set_location(SQLERRM, 65);
635: x_return_status := '2';
636: x_return_message := SQLERRM;
637:

Line 634: hr_utility.set_location(SQLERRM, 65);

630: x_return_status := '2';
631:
632: WHEN OTHERS THEN
633: hr_utility.set_location('Leaving: '|| l_proc, 60);
634: hr_utility.set_location(SQLERRM, 65);
635: x_return_status := '2';
636: x_return_message := SQLERRM;
637:
638: END get_shadow_booking;