[Home] [Help]
115: --
116: -- Other variables
117: l_proc varchar2(72) := g_package ||'create_accommodation';
118: Begin
119: hr_utility.set_location(' Entering:' || l_proc,10);
120: --
121: -- Issue a savepoint
122: --
123: savepoint create_accommodation_swi;
250: -- messages of any type exist in the Multiple Message List.
251: -- Also disable Multiple Message Detection.
252: --
253: p_return_status := hr_multi_message.get_return_status_disable;
254: hr_utility.set_location(' Leaving:' || l_proc,20);
255: --
256: exception
257: when hr_multi_message.error_message_exist then
258: --
268: p_object_version_number := null;
269: p_effective_start_date := null;
270: p_effective_end_date := null;
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc, 30);
273: when others then
274: --
275: -- When Multiple Message Detection is enabled catch
276: -- any Application specific or other unexpected
279: -- error.
280: --
281: rollback to create_accommodation_swi;
282: if hr_multi_message.unexpected_error_add(l_proc) then
283: hr_utility.set_location(' Leaving:' || l_proc,40);
284: raise;
285: end if;
286: --
287: -- Reset IN OUT and set OUT parameters
290: p_object_version_number := null;
291: p_effective_start_date := null;
292: p_effective_end_date := null;
293: p_return_status := hr_multi_message.get_return_status_disable;
294: hr_utility.set_location(' Leaving:' || l_proc,50);
295: end create_accommodation;
296: -- ----------------------------------------------------------------------------
297: -- |-------------------------< delete_accommodation >-------------------------|
298: -- ----------------------------------------------------------------------------
315: --
316: -- Other variables
317: l_proc varchar2(72) := g_package ||'delete_accommodation';
318: Begin
319: hr_utility.set_location(' Entering:' || l_proc,10);
320: --
321: -- Issue a savepoint
322: --
323: savepoint delete_accommodation_swi;
362: -- messages of any type exist in the Multiple Message List.
363: -- Also disable Multiple Message Detection.
364: --
365: p_return_status := hr_multi_message.get_return_status_disable;
366: hr_utility.set_location(' Leaving:' || l_proc,20);
367: --
368: exception
369: when hr_multi_message.error_message_exist then
370: --
379: p_object_version_number := l_object_version_number;
380: p_effective_start_date := null;
381: p_effective_end_date := null;
382: p_return_status := hr_multi_message.get_return_status_disable;
383: hr_utility.set_location(' Leaving:' || l_proc, 30);
384: when others then
385: --
386: -- When Multiple Message Detection is enabled catch
387: -- any Application specific or other unexpected
390: -- error.
391: --
392: rollback to delete_accommodation_swi;
393: if hr_multi_message.unexpected_error_add(l_proc) then
394: hr_utility.set_location(' Leaving:' || l_proc,40);
395: raise;
396: end if;
397: --
398: -- Reset IN OUT and set OUT parameters
400: p_object_version_number := l_object_version_number;
401: p_effective_start_date := null;
402: p_effective_end_date := null;
403: p_return_status := hr_multi_message.get_return_status_disable;
404: hr_utility.set_location(' Leaving:' || l_proc,50);
405: end delete_accommodation;
406: -- ----------------------------------------------------------------------------
407: -- |-------------------------< update_accommodation >-------------------------|
408: -- ----------------------------------------------------------------------------
515: --
516: -- Other variables
517: l_proc varchar2(72) := g_package ||'update_accommodation';
518: Begin
519: hr_utility.set_location(' Entering:' || l_proc,10);
520: --
521: -- Issue a savepoint
522: --
523: savepoint update_accommodation_swi;
652: -- messages of any type exist in the Multiple Message List.
653: -- Also disable Multiple Message Detection.
654: --
655: p_return_status := hr_multi_message.get_return_status_disable;
656: hr_utility.set_location(' Leaving:' || l_proc,20);
657: --
658: exception
659: when hr_multi_message.error_message_exist then
660: --
669: p_object_version_number := l_object_version_number;
670: p_effective_start_date := null;
671: p_effective_end_date := null;
672: p_return_status := hr_multi_message.get_return_status_disable;
673: hr_utility.set_location(' Leaving:' || l_proc, 30);
674: when others then
675: --
676: -- When Multiple Message Detection is enabled catch
677: -- any Application specific or other unexpected
680: -- error.
681: --
682: rollback to update_accommodation_swi;
683: if hr_multi_message.unexpected_error_add(l_proc) then
684: hr_utility.set_location(' Leaving:' || l_proc,40);
685: raise;
686: end if;
687: --
688: -- Reset IN OUT and set OUT parameters
690: p_object_version_number := l_object_version_number;
691: p_effective_start_date := null;
692: p_effective_end_date := null;
693: p_return_status := hr_multi_message.get_return_status_disable;
694: hr_utility.set_location(' Leaving:' || l_proc,50);
695: end update_accommodation;
696: end pqh_accommodations_swi;