58: savepoint create_per_bookings_swi;
59: --
60: -- Initialise Multiple Message Detection
61: --
62: hr_multi_message.enable_message_list;
63: --
64: -- Remember IN OUT parameter IN values
65: --
66: -- Call API
95: ,X_Attribute19 => p_Attribute19
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
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: --
105: -- Catch the Multiple Message List exception which
106: -- indicates API processing has been aborted because
107: -- at least one message exists in the list.
109: rollback to create_per_bookings_swi;
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
120: -- Multiple Message List. Otherwise re-raise the
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: --
127: end if;
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: --
191: savepoint update_per_bookings_swi;
192: --
193: -- Initialise Multiple Message Detection
194: --
195: hr_multi_message.enable_message_list;
196: --
197: open csr_rowid;
198: fetch csr_rowid into p_Rowid;
199: if csr_rowid%found then
237: ,X_Attribute19 => p_Attribute19
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
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: --
247: -- Catch the Multiple Message List exception which
248: -- indicates API processing has been aborted because
249: -- at least one message exists in the list.
251: rollback to update_per_bookings_swi;
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
262: -- Multiple Message List. Otherwise re-raise the
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: --
269: end if;
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
292: savepoint delete_per_bookings_swi;
293: --
294: -- Initialise Multiple Message Detection
295: --
296: hr_multi_message.enable_message_list;
297: --
298: open csr_rowid;
299: fetch csr_rowid into l_Rowid;
300: if csr_rowid%found then
309: -- Call API
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
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: --
319: -- Catch the Multiple Message List exception which
320: -- indicates API processing has been aborted because
321: -- at least one message exists in the list.
323: rollback to delete_per_bookings_swi;
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
334: -- Multiple Message List. Otherwise re-raise the
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: --
341: end if;
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: --