DBA Data[Home] [Help]

APPS.PER_BOOKINGS_SWI dependencies on HR_UTILITY

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

50: -- Other variables
51: l_interview_details_id number;
52: l_proc varchar2(72) := g_package ||'create_per_bookings';
53: Begin
54: hr_utility.set_location(' Entering:' || l_proc,10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_per_bookings_swi;

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

96: ,X_Attribute20 => p_Attribute20
97: ,X_Primary_Interviewer_Flag => p_Primary_Interviewer_Flag
98: );
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc, 20);
101: --
102: exception
103: when hr_multi_message.error_message_exist then
104: --

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

110: --
111: -- Reset IN OUT parameters and set OUT parameters
112: --
113: p_return_status := hr_multi_message.get_return_status_disable;
114: hr_utility.set_location(' Leaving:' || l_proc, 30);
115: when others then
116: --
117: -- When Multiple Message Detection is enabled catch
118: -- any Application specific or other unexpected

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

121: -- error.
122: --
123: rollback to create_per_bookings_swi;
124: if hr_multi_message.unexpected_error_add(l_proc) then
125: hr_utility.set_location(' Leaving:' || l_proc,40);
126: raise;
127: end if;
128: --
129: -- Reset IN OUT and set OUT parameters

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

128: --
129: -- Reset IN OUT and set OUT parameters
130: --
131: p_return_status := hr_multi_message.get_return_status_disable;
132: hr_utility.set_location(' Leaving:' || l_proc,50);
133: end create_per_bookings;
134: --
135: --
136: -- ----------------------------------------------------------------------------

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

185: where booking_id = p_Booking_Id;
186: l_oldrec csr_rowid%ROWTYPE;
187: p_rec per_bookings%ROWTYPE;
188: Begin
189: hr_utility.set_location(' Entering:' || l_proc,10);
190: --
191: -- Issue a savepoint
192: --
193: savepoint update_per_bookings_swi;

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

356: ,X_Attribute20 => p_rec.Attribute20
357: ,X_Primary_Interviewer_Flag => p_rec.Primary_Interviewer_Flag
358: );
359: p_return_status := hr_multi_message.get_return_status_disable;
360: hr_utility.set_location(' Leaving:' || l_proc, 20);
361: --
362: exception
363: when hr_multi_message.error_message_exist then
364: --

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

370: --
371: -- Reset IN OUT parameters and set OUT parameters
372: --
373: p_return_status := hr_multi_message.get_return_status_disable;
374: hr_utility.set_location(' Leaving:' || l_proc, 30);
375: when others then
376: --
377: -- When Multiple Message Detection is enabled catch
378: -- any Application specific or other unexpected

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

381: -- error.
382: --
383: rollback to update_per_bookings_swi;
384: if hr_multi_message.unexpected_error_add(l_proc) then
385: hr_utility.set_location(' Leaving:' || l_proc,40);
386: raise;
387: end if;
388: --
389: -- Reset IN OUT and set OUT parameters

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

388: --
389: -- Reset IN OUT and set OUT parameters
390: --
391: p_return_status := hr_multi_message.get_return_status_disable;
392: hr_utility.set_location(' Leaving:' || l_proc,50);
393: end update_per_bookings;
394: -- ----------------------------------------------------------------------------
395: PROCEDURE delete_per_bookings
396: (p_Booking_Id IN NUMBER

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

402: select rowid
403: from per_bookings
404: where booking_id = p_Booking_Id;
405: begin
406: hr_utility.set_location(' Entering:' || l_proc,10);
407: --
408: -- Issue a savepoint
409: --
410: savepoint delete_per_bookings_swi;

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

428: --
429: per_bookings_pkg.Delete_Row(X_Rowid => l_Rowid);
430: --
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc, 20);
433: ---
434: exception
435: when hr_multi_message.error_message_exist then
436: --

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

442: --
443: -- Reset IN OUT parameters and set OUT parameters
444: --
445: p_return_status := hr_multi_message.get_return_status_disable;
446: hr_utility.set_location(' Leaving:' || l_proc, 30);
447: when others then
448: --
449: -- When Multiple Message Detection is enabled catch
450: -- any Application specific or other unexpected

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

453: -- error.
454: --
455: rollback to delete_per_bookings_swi;
456: if hr_multi_message.unexpected_error_add(l_proc) then
457: hr_utility.set_location(' Leaving:' || l_proc,40);
458: raise;
459: end if;
460: --
461: -- Reset IN OUT and set OUT parameters

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

460: --
461: -- Reset IN OUT and set OUT parameters
462: --
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,50);
465: end delete_per_bookings;
466:
467: --
468: end PER_BOOKINGS_SWI;