38: savepoint create_offer_status_hist_swi;
39: --
40: -- Initialise Multiple Message Detection
41: --
42: hr_multi_message.enable_message_list;
43: --
44: -- Remember IN OUT parameter IN values
45: --
46: --
81: -- Derive the API return status value based on whether
82: -- messages of any type exist in the Multiple Message List.
83: -- Also disable Multiple Message Detection.
84: --
85: p_return_status := hr_multi_message.get_return_status_disable;
86: hr_utility.set_location(' Leaving:' || l_proc,20);
87: --
88: exception
89: when hr_multi_message.error_message_exist then
85: p_return_status := hr_multi_message.get_return_status_disable;
86: hr_utility.set_location(' Leaving:' || l_proc,20);
87: --
88: exception
89: when hr_multi_message.error_message_exist then
90: --
91: -- Catch the Multiple Message List exception which
92: -- indicates API processing has been aborted because
93: -- at least one message exists in the list.
96: --
97: -- Reset IN OUT parameters and set OUT parameters
98: --
99: p_object_version_number := null;
100: p_return_status := hr_multi_message.get_return_status_disable;
101: hr_utility.set_location(' Leaving:' || l_proc, 30);
102: when others then
103: --
104: -- When Multiple Message Detection is enabled catch
107: -- Multiple Message List. Otherwise re-raise the
108: -- error.
109: --
110: rollback to create_offer_status_hist_swi;
111: if hr_multi_message.unexpected_error_add(l_proc) then
112: hr_utility.set_location(' Leaving:' || l_proc,40);
113: raise;
114: end if;
115: --
115: --
116: -- Reset IN OUT and set OUT parameters
117: --
118: p_object_version_number := null;
119: p_return_status := hr_multi_message.get_return_status_disable;
120: hr_utility.set_location(' Leaving:' || l_proc,50);
121: end create_offer_status_history;
122: -- ----------------------------------------------------------------------------
123: -- |----------------------< update_offer_status_history >---------------------|
151: savepoint update_offer_status_hist_swi;
152: --
153: -- Initialise Multiple Message Detection
154: --
155: hr_multi_message.enable_message_list;
156: --
157: -- Remember IN OUT parameter IN values
158: --
159: --
191: -- Derive the API return status value based on whether
192: -- messages of any type exist in the Multiple Message List.
193: -- Also disable Multiple Message Detection.
194: --
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198: exception
199: when hr_multi_message.error_message_exist then
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198: exception
199: when hr_multi_message.error_message_exist then
200: --
201: -- Catch the Multiple Message List exception which
202: -- indicates API processing has been aborted because
203: -- at least one message exists in the list.
206: --
207: -- Reset IN OUT parameters and set OUT parameters
208: --
209: p_object_version_number := null;
210: p_return_status := hr_multi_message.get_return_status_disable;
211: hr_utility.set_location(' Leaving:' || l_proc, 30);
212: when others then
213: --
214: -- When Multiple Message Detection is enabled catch
217: -- Multiple Message List. Otherwise re-raise the
218: -- error.
219: --
220: rollback to update_offer_status_hist_swi;
221: if hr_multi_message.unexpected_error_add(l_proc) then
222: hr_utility.set_location(' Leaving:' || l_proc,40);
223: raise;
224: end if;
225: --
225: --
226: -- Reset IN OUT and set OUT parameters
227: --
228: p_object_version_number := null;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc,50);
231: end update_offer_status_history;
232: -- ----------------------------------------------------------------------------
233: -- |----------------------< delete_offer_status_history >---------------------|
254: savepoint delete_offer_status_hist_swi;
255: --
256: -- Initialise Multiple Message Detection
257: --
258: hr_multi_message.enable_message_list;
259: --
260: -- Remember IN OUT parameter IN values
261: --
262: --
287: -- Derive the API return status value based on whether
288: -- messages of any type exist in the Multiple Message List.
289: -- Also disable Multiple Message Detection.
290: --
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc,20);
293: --
294: exception
295: when hr_multi_message.error_message_exist then
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc,20);
293: --
294: exception
295: when hr_multi_message.error_message_exist then
296: --
297: -- Catch the Multiple Message List exception which
298: -- indicates API processing has been aborted because
299: -- at least one message exists in the list.
301: rollback to delete_offer_status_hist_swi;
302: --
303: -- Reset IN OUT parameters and set OUT parameters
304: --
305: p_return_status := hr_multi_message.get_return_status_disable;
306: hr_utility.set_location(' Leaving:' || l_proc, 30);
307: when others then
308: --
309: -- When Multiple Message Detection is enabled catch
312: -- Multiple Message List. Otherwise re-raise the
313: -- error.
314: --
315: rollback to delete_offer_status_hist_swi;
316: if hr_multi_message.unexpected_error_add(l_proc) then
317: hr_utility.set_location(' Leaving:' || l_proc,40);
318: raise;
319: end if;
320: --
319: end if;
320: --
321: -- Reset IN OUT and set OUT parameters
322: --
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc,50);
325: end delete_offer_status_history;
326: end irc_offer_status_history_swi;