35: savepoint create_vac_consideration_swi;
36: --
37: -- Initialise Multiple Message Detection
38: --
39: hr_multi_message.enable_message_list;
40: --
41: -- Remember IN OUT parameter IN values
42: --
43: --
75: -- Derive the API return status value based on whether
76: -- messages of any type exist in the Multiple Message List.
77: -- Also disable Multiple Message Detection.
78: --
79: p_return_status := hr_multi_message.get_return_status_disable;
80: hr_utility.set_location(' Leaving:' || l_proc,20);
81: --
82: exception
83: when hr_multi_message.error_message_exist then
79: p_return_status := hr_multi_message.get_return_status_disable;
80: hr_utility.set_location(' Leaving:' || l_proc,20);
81: --
82: exception
83: when hr_multi_message.error_message_exist then
84: --
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.
90: --
91: -- Reset IN OUT parameters and set OUT parameters
92: --
93: p_object_version_number := null;
94: p_return_status := hr_multi_message.get_return_status_disable;
95: hr_utility.set_location(' Leaving:' || l_proc, 30);
96: when others then
97: --
98: -- When Multiple Message Detection is enabled catch
101: -- Multiple Message List. Otherwise re-raise the
102: -- error.
103: --
104: rollback to create_vac_consideration_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;
109: --
109: --
110: -- Reset IN OUT and set OUT parameters
111: --
112: p_object_version_number := null;
113: p_return_status := hr_multi_message.get_return_status_disable;
114: hr_utility.set_location(' Leaving:' || l_proc,50);
115: end create_vacancy_consideration;
116: -- ----------------------------------------------------------------------------
117: -- |---------------------< delete_vacancy_consideration >---------------------|
138: savepoint delete_vac_consideration_swi;
139: --
140: -- Initialise Multiple Message Detection
141: --
142: hr_multi_message.enable_message_list;
143: --
144: -- Remember IN OUT parameter IN values
145: --
146: --
171: -- Derive the API return status value based on whether
172: -- messages of any type exist in the Multiple Message List.
173: -- Also disable Multiple Message Detection.
174: --
175: p_return_status := hr_multi_message.get_return_status_disable;
176: hr_utility.set_location(' Leaving:' || l_proc,20);
177: --
178: exception
179: when hr_multi_message.error_message_exist then
175: p_return_status := hr_multi_message.get_return_status_disable;
176: hr_utility.set_location(' Leaving:' || l_proc,20);
177: --
178: exception
179: when hr_multi_message.error_message_exist then
180: --
181: -- Catch the Multiple Message List exception which
182: -- indicates API processing has been aborted because
183: -- at least one message exists in the list.
185: rollback to delete_vac_consideration_swi;
186: --
187: -- Reset IN OUT parameters and set OUT parameters
188: --
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc, 30);
191: when others then
192: --
193: -- When Multiple Message Detection is enabled catch
196: -- Multiple Message List. Otherwise re-raise the
197: -- error.
198: --
199: rollback to delete_vac_consideration_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;
204: --
203: end if;
204: --
205: -- Reset IN OUT and set OUT parameters
206: --
207: p_return_status := hr_multi_message.get_return_status_disable;
208: hr_utility.set_location(' Leaving:' || l_proc,50);
209: end delete_vacancy_consideration;
210: -- ----------------------------------------------------------------------------
211: -- |---------------------< update_vacancy_consideration >---------------------|
236: savepoint update_vac_consideration_swi;
237: --
238: -- Initialise Multiple Message Detection
239: --
240: hr_multi_message.enable_message_list;
241: --
242: -- Remember IN OUT parameter IN values
243: --
244: l_object_version_number := p_object_version_number;
273: -- Derive the API return status value based on whether
274: -- messages of any type exist in the Multiple Message List.
275: -- Also disable Multiple Message Detection.
276: --
277: p_return_status := hr_multi_message.get_return_status_disable;
278: hr_utility.set_location(' Leaving:' || l_proc,20);
279: --
280: exception
281: when hr_multi_message.error_message_exist then
277: p_return_status := hr_multi_message.get_return_status_disable;
278: hr_utility.set_location(' Leaving:' || l_proc,20);
279: --
280: exception
281: when hr_multi_message.error_message_exist then
282: --
283: -- Catch the Multiple Message List exception which
284: -- indicates API processing has been aborted because
285: -- at least one message exists in the list.
288: --
289: -- Reset IN OUT parameters and set OUT parameters
290: --
291: p_object_version_number := l_object_version_number;
292: p_return_status := hr_multi_message.get_return_status_disable;
293: hr_utility.set_location(' Leaving:' || l_proc, 30);
294: when others then
295: --
296: -- When Multiple Message Detection is enabled catch
299: -- Multiple Message List. Otherwise re-raise the
300: -- error.
301: --
302: rollback to update_vac_consideration_swi;
303: if hr_multi_message.unexpected_error_add(l_proc) then
304: hr_utility.set_location(' Leaving:' || l_proc,40);
305: raise;
306: end if;
307: --
307: --
308: -- Reset IN OUT and set OUT parameters
309: --
310: p_object_version_number := l_object_version_number;
311: p_return_status := hr_multi_message.get_return_status_disable;
312: hr_utility.set_location(' Leaving:' || l_proc,50);
313: end update_vacancy_consideration;
314: end irc_vacancy_considerations_swi;