82: savepoint create_offering_swi;
83: --
84: -- Initialise Multiple Message Detection
85: --
86: hr_multi_message.enable_message_list;
87: --
88: -- Remember IN OUT parameter IN values
89: --
90: --
166: -- Derive the API return status value based on whether
167: -- messages of any type exist in the Multiple Message List.
168: -- Also disable Multiple Message Detection.
169: --
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc,20);
172: --
173: exception
174: when hr_multi_message.error_message_exist then
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc,20);
172: --
173: exception
174: when hr_multi_message.error_message_exist then
175: --
176: -- Catch the Multiple Message List exception which
177: -- indicates API processing has been aborted because
178: -- at least one message exists in the list.
181: --
182: -- Reset IN OUT parameters and set OUT parameters
183: --
184: p_object_version_number := null;
185: p_return_status := hr_multi_message.get_return_status_disable;
186: hr_utility.set_location(' Leaving:' || l_proc, 30);
187: when others then
188: --
189: -- When Multiple Message Detection is enabled catch
192: -- Multiple Message List. Otherwise re-raise the
193: -- error.
194: --
195: rollback to create_offering_swi;
196: if hr_multi_message.unexpected_error_add(l_proc) then
197: hr_utility.set_location(' Leaving:' || l_proc,40);
198: raise;
199: end if;
200: --
200: --
201: -- Reset IN OUT and set OUT parameters
202: --
203: p_object_version_number := null;
204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc,50);
206: end create_offering;
207: -- ----------------------------------------------------------------------------
208: -- |----------------------------< delete_offering >---------------------------|
229: savepoint delete_offering_swi;
230: --
231: -- Initialise Multiple Message Detection
232: --
233: hr_multi_message.enable_message_list;
234: --
235: -- Remember IN OUT parameter IN values
236: --
237: --
262: -- Derive the API return status value based on whether
263: -- messages of any type exist in the Multiple Message List.
264: -- Also disable Multiple Message Detection.
265: --
266: p_return_status := hr_multi_message.get_return_status_disable;
267: hr_utility.set_location(' Leaving:' || l_proc,20);
268: --
269: exception
270: when hr_multi_message.error_message_exist then
266: p_return_status := hr_multi_message.get_return_status_disable;
267: hr_utility.set_location(' Leaving:' || l_proc,20);
268: --
269: exception
270: when hr_multi_message.error_message_exist then
271: --
272: -- Catch the Multiple Message List exception which
273: -- indicates API processing has been aborted because
274: -- at least one message exists in the list.
276: rollback to delete_offering_swi;
277: --
278: -- Reset IN OUT parameters and set OUT parameters
279: --
280: p_return_status := hr_multi_message.get_return_status_disable;
281: hr_utility.set_location(' Leaving:' || l_proc, 30);
282: when others then
283: --
284: -- When Multiple Message Detection is enabled catch
287: -- Multiple Message List. Otherwise re-raise the
288: -- error.
289: --
290: rollback to delete_offering_swi;
291: if hr_multi_message.unexpected_error_add(l_proc) then
292: hr_utility.set_location(' Leaving:' || l_proc,40);
293: raise;
294: end if;
295: --
294: end if;
295: --
296: -- Reset IN OUT and set OUT parameters
297: --
298: p_return_status := hr_multi_message.get_return_status_disable;
299: hr_utility.set_location(' Leaving:' || l_proc,50);
300: end delete_offering;
301: -- ----------------------------------------------------------------------------
302: -- |----------------------------< update_offering >---------------------------|
375: savepoint update_offering_swi;
376: --
377: -- Initialise Multiple Message Detection
378: --
379: hr_multi_message.enable_message_list;
380: --
381: -- Remember IN OUT parameter IN values
382: --
383: l_object_version_number := p_object_version_number;
459: -- Derive the API return status value based on whether
460: -- messages of any type exist in the Multiple Message List.
461: -- Also disable Multiple Message Detection.
462: --
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,20);
465: --
466: exception
467: when hr_multi_message.error_message_exist then
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,20);
465: --
466: exception
467: when hr_multi_message.error_message_exist then
468: --
469: -- Catch the Multiple Message List exception which
470: -- indicates API processing has been aborted because
471: -- at least one message exists in the list.
474: --
475: -- Reset IN OUT parameters and set OUT parameters
476: --
477: p_object_version_number := l_object_version_number;
478: p_return_status := hr_multi_message.get_return_status_disable;
479: hr_utility.set_location(' Leaving:' || l_proc, 30);
480: when others then
481: --
482: -- When Multiple Message Detection is enabled catch
485: -- Multiple Message List. Otherwise re-raise the
486: -- error.
487: --
488: rollback to update_offering_swi;
489: if hr_multi_message.unexpected_error_add(l_proc) then
490: hr_utility.set_location(' Leaving:' || l_proc,40);
491: raise;
492: end if;
493: --
493: --
494: -- Reset IN OUT and set OUT parameters
495: --
496: p_object_version_number := l_object_version_number;
497: p_return_status := hr_multi_message.get_return_status_disable;
498: hr_utility.set_location(' Leaving:' || l_proc,50);
499: end update_offering;
500: end ota_offering_swi;