74: -- Other variables
75: l_offering_id number;
76: l_proc varchar2(72) := g_package ||'create_offering';
77: Begin
78: hr_utility.set_location(' Entering:' || l_proc,10);
79: --
80: -- Issue a savepoint
81: --
82: savepoint create_offering_swi;
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
175: --
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
190: -- any Application specific or other unexpected
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: --
201: -- Reset IN OUT and set OUT parameters
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 >---------------------------|
209: -- ----------------------------------------------------------------------------
221: --
222: -- Other variables
223: l_proc varchar2(72) := g_package ||'delete_offering';
224: Begin
225: hr_utility.set_location(' Entering:' || l_proc,10);
226: --
227: -- Issue a savepoint
228: --
229: savepoint delete_offering_swi;
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
271: --
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
285: -- any Application specific or other unexpected
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: --
296: -- Reset IN OUT and set OUT parameters
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 >---------------------------|
303: -- ----------------------------------------------------------------------------
367: --
368: -- Other variables
369: l_proc varchar2(72) := g_package ||'update_offering';
370: Begin
371: hr_utility.set_location(' Entering:' || l_proc,10);
372: --
373: -- Issue a savepoint
374: --
375: savepoint update_offering_swi;
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
468: --
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
483: -- any Application specific or other unexpected
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: --
494: -- Reset IN OUT and set OUT parameters
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;