87: savepoint create_activity_version_swi;
88: --
89: -- Initialise Multiple Message Detection
90: --
91: hr_multi_message.enable_message_list;
92: --
93: -- Remember IN OUT parameter IN values
94: --
95: --
180: -- Derive the API return status value based on whether
181: -- messages of any type exist in the Multiple Message List.
182: -- Also disable Multiple Message Detection.
183: --
184: p_return_status := hr_multi_message.get_return_status_disable;
185: hr_utility.set_location(' Leaving:' || l_proc,20);
186: --
187: exception
188: when hr_multi_message.error_message_exist then
184: p_return_status := hr_multi_message.get_return_status_disable;
185: hr_utility.set_location(' Leaving:' || l_proc,20);
186: --
187: exception
188: when hr_multi_message.error_message_exist then
189: --
190: -- Catch the Multiple Message List exception which
191: -- indicates API processing has been aborted because
192: -- at least one message exists in the list.
195: --
196: -- Reset IN OUT parameters and set OUT parameters
197: --
198: p_object_version_number := null;
199: p_return_status := hr_multi_message.get_return_status_disable;
200: hr_utility.set_location(' Leaving:' || l_proc, 30);
201: when others then
202: --
203: -- When Multiple Message Detection is enabled catch
206: -- Multiple Message List. Otherwise re-raise the
207: -- error.
208: --
209: rollback to create_activity_version_swi;
210: if hr_multi_message.unexpected_error_add(l_proc) then
211: hr_utility.set_location(' Leaving:' || l_proc,40);
212: raise;
213: end if;
214: --
214: --
215: -- Reset IN OUT and set OUT parameters
216: --
217: p_object_version_number := null;
218: p_return_status := hr_multi_message.get_return_status_disable;
219: hr_utility.set_location(' Leaving:' || l_proc,50);
220: end create_activity_version;
221: -- ----------------------------------------------------------------------------
222: -- |------------------------< delete_activity_version >-----------------------|
243: savepoint delete_activity_version_swi;
244: --
245: -- Initialise Multiple Message Detection
246: --
247: hr_multi_message.enable_message_list;
248: --
249: -- Remember IN OUT parameter IN values
250: --
251: --
276: -- Derive the API return status value based on whether
277: -- messages of any type exist in the Multiple Message List.
278: -- Also disable Multiple Message Detection.
279: --
280: p_return_status := hr_multi_message.get_return_status_disable;
281: hr_utility.set_location(' Leaving:' || l_proc,20);
282: --
283: exception
284: when hr_multi_message.error_message_exist then
280: p_return_status := hr_multi_message.get_return_status_disable;
281: hr_utility.set_location(' Leaving:' || l_proc,20);
282: --
283: exception
284: when hr_multi_message.error_message_exist then
285: --
286: -- Catch the Multiple Message List exception which
287: -- indicates API processing has been aborted because
288: -- at least one message exists in the list.
290: rollback to delete_activity_version_swi;
291: --
292: -- Reset IN OUT parameters and set OUT parameters
293: --
294: p_return_status := hr_multi_message.get_return_status_disable;
295: hr_utility.set_location(' Leaving:' || l_proc, 30);
296: when others then
297: --
298: -- When Multiple Message Detection is enabled catch
301: -- Multiple Message List. Otherwise re-raise the
302: -- error.
303: --
304: rollback to delete_activity_version_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;
309: --
308: end if;
309: --
310: -- Reset IN OUT and set OUT parameters
311: --
312: p_return_status := hr_multi_message.get_return_status_disable;
313: hr_utility.set_location(' Leaving:' || l_proc,50);
314: end delete_activity_version;
315: -- ----------------------------------------------------------------------------
316: -- |------------------------< update_activity_version >-----------------------|
395: savepoint update_activity_version_swi;
396: --
397: -- Initialise Multiple Message Detection
398: --
399: hr_multi_message.enable_message_list;
400: --
401: -- Remember IN OUT parameter IN values
402: --
403: l_object_version_number := p_object_version_number;
486: -- Derive the API return status value based on whether
487: -- messages of any type exist in the Multiple Message List.
488: -- Also disable Multiple Message Detection.
489: --
490: p_return_status := hr_multi_message.get_return_status_disable;
491: hr_utility.set_location(' Leaving:' || l_proc,20);
492: --
493: exception
494: when hr_multi_message.error_message_exist then
490: p_return_status := hr_multi_message.get_return_status_disable;
491: hr_utility.set_location(' Leaving:' || l_proc,20);
492: --
493: exception
494: when hr_multi_message.error_message_exist then
495: --
496: -- Catch the Multiple Message List exception which
497: -- indicates API processing has been aborted because
498: -- at least one message exists in the list.
501: --
502: -- Reset IN OUT parameters and set OUT parameters
503: --
504: p_object_version_number := l_object_version_number;
505: p_return_status := hr_multi_message.get_return_status_disable;
506: hr_utility.set_location(' Leaving:' || l_proc, 30);
507: when others then
508: --
509: -- When Multiple Message Detection is enabled catch
512: -- Multiple Message List. Otherwise re-raise the
513: -- error.
514: --
515: rollback to update_activity_version_swi;
516: if hr_multi_message.unexpected_error_add(l_proc) then
517: hr_utility.set_location(' Leaving:' || l_proc,40);
518: raise;
519: end if;
520: --
520: --
521: -- Reset IN OUT and set OUT parameters
522: --
523: p_object_version_number := l_object_version_number;
524: p_return_status := hr_multi_message.get_return_status_disable;
525: hr_utility.set_location(' Leaving:' || l_proc,50);
526: end update_activity_version;
527: -- ----------------------------------------------------------------------------
528: -- |------------------------< validate_delete_act_ver >-----------------------|
544: savepoint validate_delete_act_ver_swi;
545: --
546: -- Initialise Multiple Message Detection
547: --
548: hr_multi_message.enable_message_list;
549: --
550: -- Remember IN OUT parameter IN values
551: --
552: --
575: --
576: ota_tav_bus.check_if_crt_exists( p_activity_version_id );
577:
578: --
579: p_return_status := hr_multi_message.get_return_status_disable;
580: hr_utility.set_location(' Leaving:' || l_proc,20);
581: --
582: exception
583: when hr_multi_message.error_message_exist then
579: p_return_status := hr_multi_message.get_return_status_disable;
580: hr_utility.set_location(' Leaving:' || l_proc,20);
581: --
582: exception
583: when hr_multi_message.error_message_exist then
584: --
585: -- Catch the Multiple Message List exception which
586: -- indicates API processing has been aborted because
587: -- at least one message exists in the list.
589: rollback to validate_delete_act_ver_swi;
590: --
591: -- Reset IN OUT parameters and set OUT parameters
592: --
593: p_return_status := hr_multi_message.get_return_status_disable;
594: hr_utility.set_location(' Leaving:' || l_proc, 30);
595: when others then
596: --
597: -- When Multiple Message Detection is enabled catch
600: -- Multiple Message List. Otherwise re-raise the
601: -- error.
602: --
603: rollback to validate_delete_act_ver_swi;
604: if hr_multi_message.unexpected_error_add(l_proc) then
605: hr_utility.set_location(' Leaving:' || l_proc,40);
606: raise;
607: end if;
608: --
607: end if;
608: --
609: -- Reset IN OUT and set OUT parameters
610: --
611: p_return_status := hr_multi_message.get_return_status_disable;
612: hr_utility.set_location(' Leaving:' || l_proc,50);
613: end validate_delete_act_ver;
614: end ota_activity_version_swi;