73: savepoint create_rec_activity_swi;
74: --
75: -- Initialise Multiple Message Detection
76: --
77: hr_multi_message.enable_message_list;
78: --
79: -- Remember IN OUT parameter IN values
80: --
81: --
151: -- Derive the API return status value based on whether
152: -- messages of any type exist in the Multiple Message List.
153: -- Also disable Multiple Message Detection.
154: --
155: p_return_status := hr_multi_message.get_return_status_disable;
156: hr_utility.set_location(' Leaving:' || l_proc,20);
157: --
158: exception
159: when hr_multi_message.error_message_exist then
155: p_return_status := hr_multi_message.get_return_status_disable;
156: hr_utility.set_location(' Leaving:' || l_proc,20);
157: --
158: exception
159: when hr_multi_message.error_message_exist then
160: --
161: -- Catch the Multiple Message List exception which
162: -- indicates API processing has been aborted because
163: -- at least one message exists in the list.
166: --
167: -- Reset IN OUT parameters and set OUT parameters
168: --
169: p_object_version_number := null;
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc, 30);
172: when others then
173: --
174: -- When Multiple Message Detection is enabled catch
177: -- Multiple Message List. Otherwise re-raise the
178: -- error.
179: --
180: rollback to create_rec_activity_swi;
181: if hr_multi_message.unexpected_error_add(l_proc) then
182: hr_utility.set_location(' Leaving:' || l_proc,40);
183: raise;
184: end if;
185: --
185: --
186: -- Reset IN OUT and set OUT parameters
187: --
188: p_object_version_number := null;
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,50);
191: end create_recruitment_activity;
192: -- ----------------------------------------------------------------------------
193: -- |----------------------< delete_recruitment_activity >---------------------|
214: savepoint delete_rec_activity_swi;
215: --
216: -- Initialise Multiple Message Detection
217: --
218: hr_multi_message.enable_message_list;
219: --
220: -- Remember IN OUT parameter IN values
221: --
222: --
247: -- Derive the API return status value based on whether
248: -- messages of any type exist in the Multiple Message List.
249: -- Also disable Multiple Message Detection.
250: --
251: p_return_status := hr_multi_message.get_return_status_disable;
252: hr_utility.set_location(' Leaving:' || l_proc,20);
253: --
254: exception
255: when hr_multi_message.error_message_exist then
251: p_return_status := hr_multi_message.get_return_status_disable;
252: hr_utility.set_location(' Leaving:' || l_proc,20);
253: --
254: exception
255: when hr_multi_message.error_message_exist then
256: --
257: -- Catch the Multiple Message List exception which
258: -- indicates API processing has been aborted because
259: -- at least one message exists in the list.
261: rollback to delete_rec_activity_swi;
262: --
263: -- Reset IN OUT parameters and set OUT parameters
264: --
265: p_return_status := hr_multi_message.get_return_status_disable;
266: hr_utility.set_location(' Leaving:' || l_proc, 30);
267: when others then
268: --
269: -- When Multiple Message Detection is enabled catch
272: -- Multiple Message List. Otherwise re-raise the
273: -- error.
274: --
275: rollback to delete_rec_activity_swi;
276: if hr_multi_message.unexpected_error_add(l_proc) then
277: hr_utility.set_location(' Leaving:' || l_proc,40);
278: raise;
279: end if;
280: --
279: end if;
280: --
281: -- Reset IN OUT and set OUT parameters
282: --
283: p_return_status := hr_multi_message.get_return_status_disable;
284: hr_utility.set_location(' Leaving:' || l_proc,50);
285: end delete_recruitment_activity;
286: -- ----------------------------------------------------------------------------
287: -- |----------------------< update_recruitment_activity >---------------------|
350: savepoint update_rec_activity_swi;
351: --
352: -- Initialise Multiple Message Detection
353: --
354: hr_multi_message.enable_message_list;
355: --
356: -- Remember IN OUT parameter IN values
357: --
358: l_object_version_number := p_object_version_number;
425: -- Derive the API return status value based on whether
426: -- messages of any type exist in the Multiple Message List.
427: -- Also disable Multiple Message Detection.
428: --
429: p_return_status := hr_multi_message.get_return_status_disable;
430: hr_utility.set_location(' Leaving:' || l_proc,20);
431: --
432: exception
433: when hr_multi_message.error_message_exist then
429: p_return_status := hr_multi_message.get_return_status_disable;
430: hr_utility.set_location(' Leaving:' || l_proc,20);
431: --
432: exception
433: when hr_multi_message.error_message_exist then
434: --
435: -- Catch the Multiple Message List exception which
436: -- indicates API processing has been aborted because
437: -- at least one message exists in the list.
440: --
441: -- Reset IN OUT parameters and set OUT parameters
442: --
443: p_object_version_number := l_object_version_number;
444: p_return_status := hr_multi_message.get_return_status_disable;
445: hr_utility.set_location(' Leaving:' || l_proc, 30);
446: when others then
447: --
448: -- When Multiple Message Detection is enabled catch
451: -- Multiple Message List. Otherwise re-raise the
452: -- error.
453: --
454: rollback to update_rec_activity_swi;
455: if hr_multi_message.unexpected_error_add(l_proc) then
456: hr_utility.set_location(' Leaving:' || l_proc,40);
457: raise;
458: end if;
459: --
459: --
460: -- Reset IN OUT and set OUT parameters
461: --
462: p_object_version_number := l_object_version_number;
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,50);
465: end update_recruitment_activity;
466: --
467: -- ----------------------------------------------------------------------------