1: Package Body ame_approver_type_swi As
2: /* $Header: amaptswi.pkb 120.1 2006/04/21 08:41 avarri noship $ */
3: --
4: -- Package variables
5: --
2: /* $Header: amaptswi.pkb 120.1 2006/04/21 08:41 avarri noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'ame_approver_type_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_ame_approver_type >-----------------------|
10: -- ----------------------------------------------------------------------------
30: hr_utility.set_location(' Entering:' || l_proc,10);
31: --
32: -- Issue a savepoint
33: --
34: savepoint create_ame_approver_type_swi;
35: --
36: -- Initialise Multiple Message Detection
37: --
38: hr_multi_message.enable_message_list;
83: -- Catch the Multiple Message List exception which
84: -- indicates API processing has been aborted because
85: -- at least one message exists in the list.
86: --
87: rollback to create_ame_approver_type_swi;
88: --
89: -- Reset IN OUT parameters and set OUT parameters
90: --
91: p_object_version_number := null;
100: -- exceptions. Adding appropriate details to the
101: -- Multiple Message List. Otherwise re-raise the
102: -- error.
103: --
104: rollback to create_ame_approver_type_swi;
105: if hr_multi_message.unexpected_error_add(l_proc) then
106: hr_utility.set_location(' Leaving:' || l_proc,40);
107: raise;
108: end if;
222: p_return_status := hr_multi_message.get_return_status_disable;
223: hr_utility.set_location(' Leaving:' || l_proc,50);
224: end delete_ame_approver_type;
225:
226: end ame_approver_type_swi;