103: -- Other variables
104: l_document_extra_info_id number;
105: l_proc varchar2(72) := g_package ||'create_doc_extra_info';
106: Begin
107: hr_utility.set_location(' Entering:' || l_proc,10);
108: --
109: -- Issue a savepoint
110: --
111: savepoint create_doc_extra_info_swi;
228: -- messages of any type exist in the Multiple Message List.
229: -- Also disable Multiple Message Detection.
230: --
231: p_return_status := hr_multi_message.get_return_status_disable;
232: hr_utility.set_location(' Leaving:' || l_proc,20);
233: --
234: exception
235: when hr_multi_message.error_message_exist then
236: --
243: -- Reset IN OUT parameters and set OUT parameters
244: --
245: p_object_version_number := null;
246: p_return_status := hr_multi_message.get_return_status_disable;
247: hr_utility.set_location(' Leaving:' || l_proc, 30);
248: when others then
249: --
250: -- When Multiple Message Detection is enabled catch
251: -- any Application specific or other unexpected
254: -- error.
255: --
256: rollback to create_doc_extra_info_swi;
257: if hr_multi_message.unexpected_error_add(l_proc) then
258: hr_utility.set_location(' Leaving:' || l_proc,40);
259: raise;
260: end if;
261: --
262: -- Reset IN OUT and set OUT parameters
262: -- Reset IN OUT and set OUT parameters
263: --
264: p_object_version_number := null;
265: p_return_status := hr_multi_message.get_return_status_disable;
266: hr_utility.set_location(' Leaving:' || l_proc,50);
267: end create_doc_extra_info;
268: -- ----------------------------------------------------------------------------
269: -- |-------------------------< update_doc_extra_info >------------------------|
270: -- ----------------------------------------------------------------------------
364: -- Other variables
365: l_proc varchar2(72) := g_package ||'update_doc_extra_info';
366: l_verified_date date;
367: Begin
368: hr_utility.set_location(' Entering:' || l_proc,10);
369: --
370: -- Issue a savepoint
371: --
372: savepoint update_doc_extra_info_swi;
491: -- messages of any type exist in the Multiple Message List.
492: -- Also disable Multiple Message Detection.
493: --
494: p_return_status := hr_multi_message.get_return_status_disable;
495: hr_utility.set_location(' Leaving:' || l_proc,20);
496: --
497: exception
498: when hr_multi_message.error_message_exist then
499: --
506: -- Reset IN OUT parameters and set OUT parameters
507: --
508: p_object_version_number := l_object_version_number;
509: p_return_status := hr_multi_message.get_return_status_disable;
510: hr_utility.set_location(' Leaving:' || l_proc, 30);
511: when others then
512: --
513: -- When Multiple Message Detection is enabled catch
514: -- any Application specific or other unexpected
517: -- error.
518: --
519: rollback to update_doc_extra_info_swi;
520: if hr_multi_message.unexpected_error_add(l_proc) then
521: hr_utility.set_location(' Leaving:' || l_proc,40);
522: raise;
523: end if;
524: --
525: -- Reset IN OUT and set OUT parameters
525: -- Reset IN OUT and set OUT parameters
526: --
527: p_object_version_number := l_object_version_number;
528: p_return_status := hr_multi_message.get_return_status_disable;
529: hr_utility.set_location(' Leaving:' || l_proc,50);
530: end update_doc_extra_info;
531: -- ----------------------------------------------------------------------------
532: -- |-------------------------< delete_doc_extra_info >------------------------|
533: -- ----------------------------------------------------------------------------
545: --
546: -- Other variables
547: l_proc varchar2(72) := g_package ||'delete_doc_extra_info';
548: Begin
549: hr_utility.set_location(' Entering:' || l_proc,10);
550: --
551: -- Issue a savepoint
552: --
553: savepoint delete_doc_extra_info_swi;
587: -- messages of any type exist in the Multiple Message List.
588: -- Also disable Multiple Message Detection.
589: --
590: p_return_status := hr_multi_message.get_return_status_disable;
591: hr_utility.set_location(' Leaving:' || l_proc,20);
592: --
593: exception
594: when hr_multi_message.error_message_exist then
595: --
601: --
602: -- Reset IN OUT parameters and set OUT parameters
603: --
604: p_return_status := hr_multi_message.get_return_status_disable;
605: hr_utility.set_location(' Leaving:' || l_proc, 30);
606: when others then
607: --
608: -- When Multiple Message Detection is enabled catch
609: -- any Application specific or other unexpected
612: -- error.
613: --
614: rollback to delete_doc_extra_info_swi;
615: if hr_multi_message.unexpected_error_add(l_proc) then
616: hr_utility.set_location(' Leaving:' || l_proc,40);
617: raise;
618: end if;
619: --
620: -- Reset IN OUT and set OUT parameters
619: --
620: -- Reset IN OUT and set OUT parameters
621: --
622: p_return_status := hr_multi_message.get_return_status_disable;
623: hr_utility.set_location(' Leaving:' || l_proc,50);
624: end delete_doc_extra_info;
625:
626: -- -------------------------------------------------------------------------------
627: