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;
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: --
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
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
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: -- ----------------------------------------------------------------------------
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;
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: --
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
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
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
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;
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: --
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
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
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;