1: PACKAGE BODY AME_ATTRIBUTE_SWI As
2: /* $Header: amatrswi.pkb 120.0 2005/09/02 03:51 mbocutt noship $ */
3: --
4: -- Package variables
5: --
2: /* $Header: amatrswi.pkb 120.0 2005/09/02 03:51 mbocutt noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'ame_attribute_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_ame_attribute >-------------------------|
10: -- ----------------------------------------------------------------------------
42: hr_utility.set_location(' Entering:' || l_proc,10);
43: --
44: -- Issue a savepoint
45: --
46: savepoint create_ame_attribute_swi;
47: --
48: -- Initialise Multiple Message Detection
49: --
50: hr_multi_message.enable_message_list;
107: -- Catch the Multiple Message List exception which
108: -- indicates API processing has been aborted because
109: -- at least one message exists in the list.
110: --
111: rollback to create_ame_attribute_swi;
112: --
113: -- Reset IN OUT parameters and set OUT parameters
114: --
115: p_atr_object_version_number := null;
127: -- exceptions. Adding appropriate details to the
128: -- Multiple Message List. Otherwise re-raise the
129: -- error.
130: --
131: rollback to create_ame_attribute_swi;
132: if hr_multi_message.unexpected_error_add(l_proc) then
133: hr_utility.set_location(' Leaving:' || l_proc,40);
134: raise;
135: end if;
284: hr_utility.set_location(' Entering:' || l_proc,10);
285: --
286: -- Issue a savepoint
287: --
288: savepoint update_ame_attribute_swi;
289: --
290: -- Initialise Multiple Message Detection
291: --
292: hr_multi_message.enable_message_list;
335: -- Catch the Multiple Message List exception which
336: -- indicates API processing has been aborted because
337: -- at least one message exists in the list.
338: --
339: rollback to update_ame_attribute_swi;
340: --
341: -- Reset IN OUT parameters and set OUT parameters
342: --
343: p_object_version_number := l_object_version_number;
352: -- exceptions. Adding appropriate details to the
353: -- Multiple Message List. Otherwise re-raise the
354: -- error.
355: --
356: rollback to update_ame_attribute_swi;
357: if hr_multi_message.unexpected_error_add(l_proc) then
358: hr_utility.set_location(' Leaving:' || l_proc,40);
359: raise;
360: end if;
588: p_end_date := null;
589: p_return_status := hr_multi_message.get_return_status_disable;
590: hr_utility.set_location(' Leaving:' || l_proc,50);
591: end delete_ame_attribute_usage;
592: end ame_attribute_swi;