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.12010000.2 2009/07/30 03:43:47 vmummidi ship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: iriasswi.pkb 120.0.12010000.2 2009/07/30 03:43:47 vmummidi ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'irc_asg_status_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_irc_asg_status >-------------------------|
10: -- ----------------------------------------------------------------------------

Line 36: savepoint create_irc_asg_status_swi;

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

Line 91: rollback to create_irc_asg_status_swi;

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

Line 106: rollback to create_irc_asg_status_swi;

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

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

Line 187: rollback to delete_irc_asg_status_swi;

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

Line 201: rollback to delete_irc_asg_status_swi;

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

Line 238: savepoint update_irc_asg_status_swi;

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

Line 289: rollback to update_irc_asg_status_swi;

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

Line 304: rollback to update_irc_asg_status_swi;

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

Line 316: end irc_asg_status_swi;

312: p_object_version_number := l_object_version_number;
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving: ' || l_proc, 50);
315: end update_irc_asg_status;
316: end irc_asg_status_swi;