APPS.IRC_ASG_STATUS_SWI dependencies on IRC_ASG_STATUS_SWI

Line 1: Package Body irc_asg_status_swi As

1: Package Body irc_asg_status_swi As
2: /* $Header: iriasswi.pkb 120.0 2005/07/26 15:04:24 mbocutt noship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: iriasswi.pkb 120.0 2005/07/26 15:04:24 mbocutt noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'irc_asg_status_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_irc_asg_status >-------------------------|
10: -- ----------------------------------------------------------------------------

Line 35: savepoint create_irc_asg_status_swi;

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

Line 89: rollback to create_irc_asg_status_swi;

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

Line 104: rollback to create_irc_asg_status_swi;

100: -- exceptions. Adding appropriate details to the
101: -- Multiple Message List. Otherwise re-raise
102: -- the error.
103: --
104: rollback to create_irc_asg_status_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;

Line 138: savepoint delete_irc_asg_status_swi;

134: hr_utility.set_location(' Entering:' || l_proc,10);
135: --
136: -- Issue a savepoint
137: --
138: savepoint delete_irc_asg_status_swi;
139: --
140: -- Initialise Multiple Message Detection
141: --
142: hr_multi_message.enable_message_list;

Line 185: rollback to delete_irc_asg_status_swi;

181: -- Catch the Multiple Message List exception which
182: -- indicates API processing has been aborted because
183: -- at least one error message exists in the list.
184: --
185: rollback to delete_irc_asg_status_swi;
186: --
187: -- Reset IN OUT paramters and set OUT parameters
188: --
189: p_return_status := hr_multi_message.get_return_status_disable;

Line 199: rollback to delete_irc_asg_status_swi;

195: -- exceptions. Adding appropriate details to the
196: -- Multiple Message List. Otherwise re-raise
197: -- the error.
198: --
199: rollback to delete_irc_asg_status_swi;
200: if hr_multi_message.unexpected_error_add(l_proc) then
201: hr_utility.set_location(' Leaving:' || l_proc, 40);
202: raise;
203: end if;

Line 235: savepoint update_irc_asg_status_swi;

231: hr_utility.set_location(' Entering:' || l_proc,10);
232: --
233: -- Issue a savepoint
234: --
235: savepoint update_irc_asg_status_swi;
236: --
237: -- Initialise Multiple Message Detection
238: --
239: hr_multi_message.enable_message_list;

Line 285: rollback to update_irc_asg_status_swi;

281: -- Catch the Multiple Message List exception which
282: -- indicates API processing has been aborted because
283: -- at least one error message exists in the list.
284: --
285: rollback to update_irc_asg_status_swi;
286: --
287: -- Reset IN OUT paramters and set OUT parameters
288: --
289: p_object_version_number := l_object_version_number;

Line 300: rollback to update_irc_asg_status_swi;

296: -- exceptions. Adding appropriate details to the
297: -- Multiple Message List. Otherwise re-raise
298: -- the error.
299: --
300: rollback to update_irc_asg_status_swi;
301: if hr_multi_message.unexpected_error_add(l_proc) then
302: hr_utility.set_location(' Leaving:' || l_proc, 40);
303: raise;
304: end if;

Line 312: end irc_asg_status_swi;

308: p_object_version_number := l_object_version_number;
309: p_return_status := hr_multi_message.get_return_status_disable;
310: hr_utility.set_location(' Leaving: ' || l_proc, 50);
311: end update_irc_asg_status;
312: end irc_asg_status_swi;