DBA Data[Home] [Help]

APPS.AME_ITEM_CLASS_SWI dependencies on AME_ITEM_CLASS_SWI

Line 1: Package Body ame_item_class_swi As

1: Package Body ame_item_class_swi As
2: /* $Header: amitcswi.pkb 120.1 2005/12/08 21:02 santosin noship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'ame_item_class_swi.';

2: /* $Header: amitcswi.pkb 120.1 2005/12/08 21:02 santosin noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'ame_item_class_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_ame_item_class >------------------------|
10: -- ----------------------------------------------------------------------------

Line 35: savepoint create_ame_item_class_swi;

31: hr_utility.set_location(' Entering:' || l_proc,10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_ame_item_class_swi;
36: --
37: -- Initialise Multiple Message Detection
38: --
39: hr_multi_message.enable_message_list;

Line 89: rollback to create_ame_item_class_swi;

85: -- Catch the Multiple Message List exception which
86: -- indicates API processing has been aborted because
87: -- at least one message exists in the list.
88: --
89: rollback to create_ame_item_class_swi;
90: --
91: -- Reset IN OUT parameters and set OUT parameters
92: --
93: p_object_version_number := null;

Line 106: rollback to create_ame_item_class_swi;

102: -- exceptions. Adding appropriate details to the
103: -- Multiple Message List. Otherwise re-raise the
104: -- error.
105: --
106: rollback to create_ame_item_class_swi;
107: if hr_multi_message.unexpected_error_add(l_proc) then
108: hr_utility.set_location(' Leaving:' || l_proc,40);
109: raise;
110: end if;

Line 146: savepoint update_ame_item_class_swi;

142: hr_utility.set_location(' Entering:' || l_proc,10);
143: --
144: -- Issue a savepoint
145: --
146: savepoint update_ame_item_class_swi;
147: --
148: -- Initialise Multiple Message Detection
149: --
150: hr_multi_message.enable_message_list;

Line 197: rollback to update_ame_item_class_swi;

193: -- Catch the Multiple Message List exception which
194: -- indicates API processing has been aborted because
195: -- at least one message exists in the list.
196: --
197: rollback to update_ame_item_class_swi;
198: --
199: -- Reset IN OUT parameters and set OUT parameters
200: --
201: p_object_version_number := l_object_version_number;

Line 214: rollback to update_ame_item_class_swi;

210: -- exceptions. Adding appropriate details to the
211: -- Multiple Message List. Otherwise re-raise the
212: -- error.
213: --
214: rollback to update_ame_item_class_swi;
215: if hr_multi_message.unexpected_error_add(l_proc) then
216: hr_utility.set_location(' Leaving:' || l_proc,40);
217: raise;
218: end if;

Line 253: savepoint delete_ame_item_class_swi;

249: hr_utility.set_location(' Entering:' || l_proc,10);
250: --
251: -- Issue a savepoint
252: --
253: savepoint delete_ame_item_class_swi;
254: --
255: -- Initialise Multiple Message Detection
256: --
257: hr_multi_message.enable_message_list;

Line 303: rollback to delete_ame_item_class_swi;

299: -- Catch the Multiple Message List exception which
300: -- indicates API processing has been aborted because
301: -- at least one message exists in the list.
302: --
303: rollback to delete_ame_item_class_swi;
304: --
305: -- Reset IN OUT parameters and set OUT parameters
306: --
307: p_object_version_number := l_object_version_number;

Line 320: rollback to delete_ame_item_class_swi;

316: -- exceptions. Adding appropriate details to the
317: -- Multiple Message List. Otherwise re-raise the
318: -- error.
319: --
320: rollback to delete_ame_item_class_swi;
321: if hr_multi_message.unexpected_error_add(l_proc) then
322: hr_utility.set_location(' Leaving:' || l_proc,40);
323: raise;
324: end if;

Line 686: end ame_item_class_swi;

682: p_end_date := null;
683: p_return_status := hr_multi_message.get_return_status_disable;
684: hr_utility.set_location(' Leaving:' || l_proc,50);
685: end delete_ame_item_class_usage;
686: end ame_item_class_swi;