76: savepoint create_learning_path_swi;
77: --
78: -- Initialise Multiple Message Detection
79: --
80: hr_multi_message.enable_message_list;
81: --
82: -- Remember IN OUT parameter IN values
83: --
84: --
178: -- Derive the API return status value based on whether
179: -- messages of any type exist in the Multiple Message List.
180: -- Also disable Multiple Message Detection.
181: --
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc,20);
184: --
185: exception
186: when hr_multi_message.error_message_exist then
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc,20);
184: --
185: exception
186: when hr_multi_message.error_message_exist then
187: --
188: -- Catch the Multiple Message List exception which
189: -- indicates API processing has been aborted because
190: -- at least one message exists in the list.
193: --
194: -- Reset IN OUT parameters and set OUT parameters
195: --
196: p_object_version_number := null;
197: p_return_status := hr_multi_message.get_return_status_disable;
198: hr_utility.set_location(' Leaving:' || l_proc, 30);
199: when others then
200: --
201: -- When Multiple Message Detection is enabled catch
204: -- Multiple Message List. Otherwise re-raise the
205: -- error.
206: --
207: rollback to create_learning_path_swi;
208: if hr_multi_message.unexpected_error_add(l_proc) then
209: hr_utility.set_location(' Leaving:' || l_proc,40);
210: raise;
211: end if;
212: --
212: --
213: -- Reset IN OUT and set OUT parameters
214: --
215: p_object_version_number := null;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,50);
218: end create_learning_path;
219: -- ----------------------------------------------------------------------------
220: -- |-------------------------< delete_learning_path >-------------------------|
241: savepoint delete_learning_path_swi;
242: --
243: -- Initialise Multiple Message Detection
244: --
245: hr_multi_message.enable_message_list;
246: --
247: -- Remember IN OUT parameter IN values
248: --
249: --
274: -- Derive the API return status value based on whether
275: -- messages of any type exist in the Multiple Message List.
276: -- Also disable Multiple Message Detection.
277: --
278: p_return_status := hr_multi_message.get_return_status_disable;
279: hr_utility.set_location(' Leaving:' || l_proc,20);
280: --
281: exception
282: when hr_multi_message.error_message_exist then
278: p_return_status := hr_multi_message.get_return_status_disable;
279: hr_utility.set_location(' Leaving:' || l_proc,20);
280: --
281: exception
282: when hr_multi_message.error_message_exist then
283: --
284: -- Catch the Multiple Message List exception which
285: -- indicates API processing has been aborted because
286: -- at least one message exists in the list.
288: rollback to delete_learning_path_swi;
289: --
290: -- Reset IN OUT parameters and set OUT parameters
291: --
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 delete_learning_path_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: --
306: end if;
307: --
308: -- Reset IN OUT and set OUT parameters
309: --
310: p_return_status := hr_multi_message.get_return_status_disable;
311: hr_utility.set_location(' Leaving:' || l_proc,50);
312: end delete_learning_path;
313: -- ----------------------------------------------------------------------------
314: -- |-------------------------< update_learning_path >-------------------------|
378: savepoint update_learning_path_swi;
379: --
380: -- Initialise Multiple Message Detection
381: --
382: hr_multi_message.enable_message_list;
383: --
384: -- Remember IN OUT parameter IN values
385: --
386: l_object_version_number := p_object_version_number;
465: -- Derive the API return status value based on whether
466: -- messages of any type exist in the Multiple Message List.
467: -- Also disable Multiple Message Detection.
468: --
469: p_return_status := hr_multi_message.get_return_status_disable;
470: hr_utility.set_location(' Leaving:' || l_proc,20);
471: --
472: exception
473: when hr_multi_message.error_message_exist then
469: p_return_status := hr_multi_message.get_return_status_disable;
470: hr_utility.set_location(' Leaving:' || l_proc,20);
471: --
472: exception
473: when hr_multi_message.error_message_exist then
474: --
475: -- Catch the Multiple Message List exception which
476: -- indicates API processing has been aborted because
477: -- at least one message exists in the list.
480: --
481: -- Reset IN OUT parameters and set OUT parameters
482: --
483: p_object_version_number := l_object_version_number;
484: p_return_status := hr_multi_message.get_return_status_disable;
485: hr_utility.set_location(' Leaving:' || l_proc, 30);
486: when others then
487: --
488: -- When Multiple Message Detection is enabled catch
491: -- Multiple Message List. Otherwise re-raise the
492: -- error.
493: --
494: rollback to update_learning_path_swi;
495: if hr_multi_message.unexpected_error_add(l_proc) then
496: hr_utility.set_location(' Leaving:' || l_proc,40);
497: raise;
498: end if;
499: --
499: --
500: -- Reset IN OUT and set OUT parameters
501: --
502: p_object_version_number := l_object_version_number;
503: p_return_status := hr_multi_message.get_return_status_disable;
504: hr_utility.set_location(' Leaving:' || l_proc,50);
505: end update_learning_path;
506:
507: -- ----------------------------------------------------------------------------
663: EXCEPTION
664:
665: WHEN app_exception.application_exception THEN
666:
667: IF hr_multi_message.exception_add
668: (p_associated_column1 => 'OTA_LEARNING_PATHS.NAME') THEN
669:
670: hr_utility.set_location(' Leaving:'||l_proc, 92);
671: RAISE;