DBA Data[Home] [Help]

APPS.AME_CONDITION_SWI dependencies on AME_CONDITION_SWI

Line 1: Package Body ame_condition_swi As

1: Package Body ame_condition_swi As
2: /* $Header: amconswi.pkb 120.0 2005/09/02 03:56 mbocutt noship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: amconswi.pkb 120.0 2005/09/02 03:56 mbocutt noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'ame_condition_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_ame_condition >-------------------------|
10: -- ----------------------------------------------------------------------------

Line 45: savepoint create_ame_condition_swi;

41: hr_utility.set_location(' Entering:' || l_proc,10);
42: --
43: -- Issue a savepoint
44: --
45: savepoint create_ame_condition_swi;
46: --
47: -- Initialise Multiple Message Detection
48: --
49: hr_multi_message.enable_message_list;

Line 109: rollback to create_ame_condition_swi;

105: -- Catch the Multiple Message List exception which
106: -- indicates API processing has been aborted because
107: -- at least one message exists in the list.
108: --
109: rollback to create_ame_condition_swi;
110: --
111: -- Reset IN OUT parameters and set OUT parameters
112: --
113: p_con_start_date := null;

Line 129: rollback to create_ame_condition_swi;

125: -- exceptions. Adding appropriate details to the
126: -- Multiple Message List. Otherwise re-raise the
127: -- error.
128: --
129: rollback to create_ame_condition_swi;
130: if hr_multi_message.unexpected_error_add(l_proc) then
131: hr_utility.set_location(' Leaving:' || l_proc,40);
132: raise;
133: end if;

Line 176: savepoint update_ame_condition_swi;

172: hr_utility.set_location(' Entering:' || l_proc,10);
173: --
174: -- Issue a savepoint
175: --
176: savepoint update_ame_condition_swi;
177: --
178: -- Initialise Multiple Message Detection
179: --
180: hr_multi_message.enable_message_list;

Line 231: rollback to update_ame_condition_swi;

227: -- Catch the Multiple Message List exception which
228: -- indicates API processing has been aborted because
229: -- at least one message exists in the list.
230: --
231: rollback to update_ame_condition_swi;
232: --
233: -- Reset IN OUT parameters and set OUT parameters
234: --
235: p_object_version_number := l_object_version_number;

Line 248: rollback to update_ame_condition_swi;

244: -- exceptions. Adding appropriate details to the
245: -- Multiple Message List. Otherwise re-raise the
246: -- error.
247: --
248: rollback to update_ame_condition_swi;
249: if hr_multi_message.unexpected_error_add(l_proc) then
250: hr_utility.set_location(' Leaving:' || l_proc,40);
251: raise;
252: end if;

Line 287: savepoint delete_ame_condition_swi;

283: hr_utility.set_location(' Entering:' || l_proc,10);
284: --
285: -- Issue a savepoint
286: --
287: savepoint delete_ame_condition_swi;
288: --
289: -- Initialise Multiple Message Detection
290: --
291: hr_multi_message.enable_message_list;

Line 337: rollback to delete_ame_condition_swi;

333: -- Catch the Multiple Message List exception which
334: -- indicates API processing has been aborted because
335: -- at least one message exists in the list.
336: --
337: rollback to delete_ame_condition_swi;
338: --
339: -- Reset IN OUT parameters and set OUT parameters
340: --
341: p_object_version_number := l_object_version_number;

Line 354: rollback to delete_ame_condition_swi;

350: -- exceptions. Adding appropriate details to the
351: -- Multiple Message List. Otherwise re-raise the
352: -- error.
353: --
354: rollback to delete_ame_condition_swi;
355: if hr_multi_message.unexpected_error_add(l_proc) then
356: hr_utility.set_location(' Leaving:' || l_proc,40);
357: raise;
358: end if;

Line 582: end ame_condition_swi;

578: p_end_date := null;
579: p_return_status := hr_multi_message.get_return_status_disable;
580: hr_utility.set_location(' Leaving:' || l_proc,50);
581: end delete_ame_string_value;
582: end ame_condition_swi;