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 187: hr_utility.set_location(' Entering:' || l_proc,10);

183: select rowid
184: from per_bookings
185: where booking_id = p_Booking_Id;
186: Begin
187: hr_utility.set_location(' Entering:' || l_proc,10);
188: --
189: -- Issue a savepoint
190: --
191: savepoint update_per_bookings_swi;

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

238: ,X_Attribute20 => p_Attribute20
239: ,X_Primary_Interviewer_Flag => p_Primary_Interviewer_Flag
240: );
241: p_return_status := hr_multi_message.get_return_status_disable;
242: hr_utility.set_location(' Leaving:' || l_proc, 20);
243: --
244: exception
245: when hr_multi_message.error_message_exist then
246: --

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

252: --
253: -- Reset IN OUT parameters and set OUT parameters
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc, 30);
257: when others then
258: --
259: -- When Multiple Message Detection is enabled catch
260: -- any Application specific or other unexpected

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

263: -- error.
264: --
265: rollback to update_per_bookings_swi;
266: if hr_multi_message.unexpected_error_add(l_proc) then
267: hr_utility.set_location(' Leaving:' || l_proc,40);
268: raise;
269: end if;
270: --
271: -- Reset IN OUT and set OUT parameters

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

270: --
271: -- Reset IN OUT and set OUT parameters
272: --
273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,50);
275: end update_per_bookings;
276: -- ----------------------------------------------------------------------------
277: PROCEDURE delete_per_bookings
278: (p_Booking_Id IN NUMBER

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

284: select rowid
285: from per_bookings
286: where booking_id = p_Booking_Id;
287: begin
288: hr_utility.set_location(' Entering:' || l_proc,10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint delete_per_bookings_swi;

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

310: --
311: per_bookings_pkg.Delete_Row(X_Rowid => l_Rowid);
312: --
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving:' || l_proc, 20);
315: ---
316: exception
317: when hr_multi_message.error_message_exist then
318: --

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

324: --
325: -- Reset IN OUT parameters and set OUT parameters
326: --
327: p_return_status := hr_multi_message.get_return_status_disable;
328: hr_utility.set_location(' Leaving:' || l_proc, 30);
329: when others then
330: --
331: -- When Multiple Message Detection is enabled catch
332: -- any Application specific or other unexpected

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

335: -- error.
336: --
337: rollback to delete_per_bookings_swi;
338: if hr_multi_message.unexpected_error_add(l_proc) then
339: hr_utility.set_location(' Leaving:' || l_proc,40);
340: raise;
341: end if;
342: --
343: -- Reset IN OUT and set OUT parameters

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

342: --
343: -- Reset IN OUT and set OUT parameters
344: --
345: p_return_status := hr_multi_message.get_return_status_disable;
346: hr_utility.set_location(' Leaving:' || l_proc,50);
347: end delete_per_bookings;
348:
349: --
350: end PER_BOOKINGS_SWI;