92: savepoint create_appraisal_template_swi;
93: --
94: -- Initialise Multiple Message Detection
95: --
96: hr_multi_message.enable_message_list;
97: --
98: -- Remember IN OUT parameter IN values
99: --
100: --
185: -- Derive the API return status value based on whether
186: -- messages of any type exist in the Multiple Message List.
187: -- Also disable Multiple Message Detection.
188: --
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,20);
191: --
192: exception
193: when hr_multi_message.error_message_exist then
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,20);
191: --
192: exception
193: when hr_multi_message.error_message_exist then
194: --
195: -- Catch the Multiple Message List exception which
196: -- indicates API processing has been aborted because
197: -- at least one message exists in the list.
200: --
201: -- Reset IN OUT parameters and set OUT parameters
202: --
203: p_object_version_number := null;
204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc, 30);
206: when others then
207: --
208: -- When Multiple Message Detection is enabled catch
211: -- Multiple Message List. Otherwise re-raise the
212: -- error.
213: --
214: rollback to create_appraisal_template_swi;
215: if hr_multi_message.unexpected_error_add(l_proc) then
216: hr_utility.set_location(' Leaving:' || l_proc,40);
217: raise;
218: end if;
219: --
219: --
220: -- Reset IN OUT and set OUT parameters
221: --
222: p_object_version_number := null;
223: p_return_status := hr_multi_message.get_return_status_disable;
224: hr_utility.set_location(' Leaving:' || l_proc,50);
225: end create_appraisal_template;
226: -- ----------------------------------------------------------------------------
227: -- |-----------------------< delete_appraisal_template >----------------------|
248: savepoint delete_appraisal_template_swi;
249: --
250: -- Initialise Multiple Message Detection
251: --
252: hr_multi_message.enable_message_list;
253: --
254: -- Remember IN OUT parameter IN values
255: --
256: --
281: -- Derive the API return status value based on whether
282: -- messages of any type exist in the Multiple Message List.
283: -- Also disable Multiple Message Detection.
284: --
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,20);
287: --
288: exception
289: when hr_multi_message.error_message_exist then
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,20);
287: --
288: exception
289: when hr_multi_message.error_message_exist then
290: --
291: -- Catch the Multiple Message List exception which
292: -- indicates API processing has been aborted because
293: -- at least one message exists in the list.
295: rollback to delete_appraisal_template_swi;
296: --
297: -- Reset IN OUT parameters and set OUT parameters
298: --
299: p_return_status := hr_multi_message.get_return_status_disable;
300: hr_utility.set_location(' Leaving:' || l_proc, 30);
301: when others then
302: --
303: -- When Multiple Message Detection is enabled catch
306: -- Multiple Message List. Otherwise re-raise the
307: -- error.
308: --
309: rollback to delete_appraisal_template_swi;
310: if hr_multi_message.unexpected_error_add(l_proc) then
311: hr_utility.set_location(' Leaving:' || l_proc,40);
312: raise;
313: end if;
314: --
313: end if;
314: --
315: -- Reset IN OUT and set OUT parameters
316: --
317: p_return_status := hr_multi_message.get_return_status_disable;
318: hr_utility.set_location(' Leaving:' || l_proc,50);
319: end delete_appraisal_template;
320: -- ----------------------------------------------------------------------------
321: -- |-----------------------< update_appraisal_template >----------------------|
403: savepoint update_appraisal_template_swi;
404: --
405: -- Initialise Multiple Message Detection
406: --
407: hr_multi_message.enable_message_list;
408: --
409: -- Remember IN OUT parameter IN values
410: --
411: l_object_version_number := p_object_version_number;
496: -- Derive the API return status value based on whether
497: -- messages of any type exist in the Multiple Message List.
498: -- Also disable Multiple Message Detection.
499: --
500: p_return_status := hr_multi_message.get_return_status_disable;
501: hr_utility.set_location(' Leaving:' || l_proc,20);
502:
503:
504: --
502:
503:
504: --
505: exception
506: when hr_multi_message.error_message_exist then
507: --
508: -- Catch the Multiple Message List exception which
509: -- indicates API processing has been aborted because
510: -- at least one message exists in the list.
513: --
514: -- Reset IN OUT parameters and set OUT parameters
515: --
516: p_object_version_number := l_object_version_number;
517: p_return_status := hr_multi_message.get_return_status_disable;
518: hr_utility.set_location(' Leaving:' || l_proc, 30);
519:
520: when others then
521: --
525: -- Multiple Message List. Otherwise re-raise the
526: -- error.
527: --
528: rollback to update_appraisal_template_swi;
529: if hr_multi_message.unexpected_error_add(l_proc) then
530: hr_utility.set_location(' Leaving:' || l_proc,40);
531: raise;
532: end if;
533: --
533: --
534: -- Reset IN OUT and set OUT parameters
535: --
536: p_object_version_number := l_object_version_number;
537: p_return_status := hr_multi_message.get_return_status_disable;
538: hr_utility.set_location(' Leaving:' || l_proc,50);
539:
540: end update_appraisal_template;
541: end hr_appraisal_templates_swi;