109: savepoint create_posting_content_swi;
110: --
111: -- Initialise Multiple Message Detection
112: --
113: hr_multi_message.enable_message_list;
114: --
115: -- Remember IN OUT parameter IN values
116: --
117: --
223: -- Derive the API return status value based on whether
224: -- messages of any type exist in the Multiple Message List.
225: -- Also disable Multiple Message Detection.
226: --
227: p_return_status := hr_multi_message.get_return_status_disable;
228: hr_utility.set_location(' Leaving:' || l_proc,20);
229: --
230: exception
231: when hr_multi_message.error_message_exist then
227: p_return_status := hr_multi_message.get_return_status_disable;
228: hr_utility.set_location(' Leaving:' || l_proc,20);
229: --
230: exception
231: when hr_multi_message.error_message_exist then
232: --
233: -- Catch the Multiple Message List exception which
234: -- indicates API processing has been aborted because
235: -- at least one message exists in the list.
238: --
239: -- Reset IN OUT parameters and set OUT parameters
240: --
241: p_object_version_number := null;
242: p_return_status := hr_multi_message.get_return_status_disable;
243: hr_utility.set_location(' Leaving:' || l_proc, 30);
244: when others then
245: --
246: -- When Multiple Message Detection is enabled catch
249: -- Multiple Message List. Otherwise re-raise the
250: -- error.
251: --
252: rollback to create_posting_content_swi;
253: if hr_multi_message.unexpected_error_add(l_proc) then
254: hr_utility.set_location(' Leaving:' || l_proc,40);
255: raise;
256: end if;
257: --
257: --
258: -- Reset IN OUT and set OUT parameters
259: --
260: p_object_version_number := null;
261: p_return_status := hr_multi_message.get_return_status_disable;
262: hr_utility.set_location(' Leaving:' || l_proc,50);
263: end create_posting_content;
264: -- ----------------------------------------------------------------------------
265: -- |------------------------< delete_posting_content >------------------------|
286: savepoint delete_posting_content_swi;
287: --
288: -- Initialise Multiple Message Detection
289: --
290: hr_multi_message.enable_message_list;
291: --
292: -- Remember IN OUT parameter IN values
293: --
294: --
319: -- Derive the API return status value based on whether
320: -- messages of any type exist in the Multiple Message List.
321: -- Also disable Multiple Message Detection.
322: --
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc,20);
325: --
326: exception
327: when hr_multi_message.error_message_exist then
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc,20);
325: --
326: exception
327: when hr_multi_message.error_message_exist then
328: --
329: -- Catch the Multiple Message List exception which
330: -- indicates API processing has been aborted because
331: -- at least one message exists in the list.
333: rollback to delete_posting_content_swi;
334: --
335: -- Reset IN OUT parameters and set OUT parameters
336: --
337: p_return_status := hr_multi_message.get_return_status_disable;
338: hr_utility.set_location(' Leaving:' || l_proc, 30);
339: when others then
340: --
341: -- When Multiple Message Detection is enabled catch
344: -- Multiple Message List. Otherwise re-raise the
345: -- error.
346: --
347: rollback to delete_posting_content_swi;
348: if hr_multi_message.unexpected_error_add(l_proc) then
349: hr_utility.set_location(' Leaving:' || l_proc,40);
350: raise;
351: end if;
352: --
351: end if;
352: --
353: -- Reset IN OUT and set OUT parameters
354: --
355: p_return_status := hr_multi_message.get_return_status_disable;
356: hr_utility.set_location(' Leaving:' || l_proc,50);
357: end delete_posting_content;
358: -- ----------------------------------------------------------------------------
359: -- |------------------------< update_posting_content >------------------------|
459: savepoint update_posting_content_swi;
460: --
461: -- Initialise Multiple Message Detection
462: --
463: hr_multi_message.enable_message_list;
464: --
465: -- Remember IN OUT parameter IN values
466: --
467: l_object_version_number := p_object_version_number;
571: -- Derive the API return status value based on whether
572: -- messages of any type exist in the Multiple Message List.
573: -- Also disable Multiple Message Detection.
574: --
575: p_return_status := hr_multi_message.get_return_status_disable;
576: hr_utility.set_location(' Leaving:' || l_proc,20);
577: --
578: exception
579: when hr_multi_message.error_message_exist then
575: p_return_status := hr_multi_message.get_return_status_disable;
576: hr_utility.set_location(' Leaving:' || l_proc,20);
577: --
578: exception
579: when hr_multi_message.error_message_exist then
580: --
581: -- Catch the Multiple Message List exception which
582: -- indicates API processing has been aborted because
583: -- at least one message exists in the list.
586: --
587: -- Reset IN OUT parameters and set OUT parameters
588: --
589: p_object_version_number := l_object_version_number;
590: p_return_status := hr_multi_message.get_return_status_disable;
591: hr_utility.set_location(' Leaving:' || l_proc, 30);
592: when others then
593: --
594: -- When Multiple Message Detection is enabled catch
597: -- Multiple Message List. Otherwise re-raise the
598: -- error.
599: --
600: rollback to update_posting_content_swi;
601: if hr_multi_message.unexpected_error_add(l_proc) then
602: hr_utility.set_location(' Leaving:' || l_proc,40);
603: raise;
604: end if;
605: --
605: --
606: -- Reset IN OUT and set OUT parameters
607: --
608: p_object_version_number := l_object_version_number;
609: p_return_status := hr_multi_message.get_return_status_disable;
610: hr_utility.set_location(' Leaving:' || l_proc,50);
611: end update_posting_content;
612:
613: -- ----------------------------------------------------------------------------