DBA Data[Home] [Help]

APPS.OTA_CERTIFICATION_SWI dependencies on HR_MULTI_MESSAGE

Line 80: hr_multi_message.enable_message_list;

76: savepoint create_certification_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: --

Line 167: p_return_status := hr_multi_message.get_return_status_disable;

163: -- Derive the API return status value based on whether
164: -- messages of any type exist in the Multiple Message List.
165: -- Also disable Multiple Message Detection.
166: --
167: p_return_status := hr_multi_message.get_return_status_disable;
168: hr_utility.set_location(' Leaving:' || l_proc,20);
169: --
170: exception
171: when hr_multi_message.error_message_exist then

Line 171: when hr_multi_message.error_message_exist then

167: p_return_status := hr_multi_message.get_return_status_disable;
168: hr_utility.set_location(' Leaving:' || l_proc,20);
169: --
170: exception
171: when hr_multi_message.error_message_exist then
172: --
173: -- Catch the Multiple Message List exception which
174: -- indicates API processing has been aborted because
175: -- at least one message exists in the list.

Line 182: p_return_status := hr_multi_message.get_return_status_disable;

178: --
179: -- Reset IN OUT parameters and set OUT parameters
180: --
181: p_object_version_number := null;
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc, 30);
184: when others then
185: --
186: -- When Multiple Message Detection is enabled catch

Line 193: if hr_multi_message.unexpected_error_add(l_proc) then

189: -- Multiple Message List. Otherwise re-raise the
190: -- error.
191: --
192: rollback to create_certification_swi;
193: if hr_multi_message.unexpected_error_add(l_proc) then
194: hr_utility.set_location(' Leaving:' || l_proc,40);
195: raise;
196: end if;
197: --

Line 201: p_return_status := hr_multi_message.get_return_status_disable;

197: --
198: -- Reset IN OUT and set OUT parameters
199: --
200: p_object_version_number := null;
201: p_return_status := hr_multi_message.get_return_status_disable;
202: hr_utility.set_location(' Leaving:' || l_proc,50);
203: end create_certification;
204: -- ----------------------------------------------------------------------------
205: -- |-------------------------< update_certification >-------------------------|

Line 276: hr_multi_message.enable_message_list;

272: savepoint update_certification_swi;
273: --
274: -- Initialise Multiple Message Detection
275: --
276: hr_multi_message.enable_message_list;
277: --
278: -- Remember IN OUT parameter IN values
279: --
280: l_object_version_number := p_object_version_number;

Line 363: p_return_status := hr_multi_message.get_return_status_disable;

359: -- Derive the API return status value based on whether
360: -- messages of any type exist in the Multiple Message List.
361: -- Also disable Multiple Message Detection.
362: --
363: p_return_status := hr_multi_message.get_return_status_disable;
364: hr_utility.set_location(' Leaving:' || l_proc,20);
365: --
366: exception
367: when hr_multi_message.error_message_exist then

Line 367: when hr_multi_message.error_message_exist then

363: p_return_status := hr_multi_message.get_return_status_disable;
364: hr_utility.set_location(' Leaving:' || l_proc,20);
365: --
366: exception
367: when hr_multi_message.error_message_exist then
368: --
369: -- Catch the Multiple Message List exception which
370: -- indicates API processing has been aborted because
371: -- at least one message exists in the list.

Line 378: p_return_status := hr_multi_message.get_return_status_disable;

374: --
375: -- Reset IN OUT parameters and set OUT parameters
376: --
377: p_object_version_number := l_object_version_number;
378: p_return_status := hr_multi_message.get_return_status_disable;
379: hr_utility.set_location(' Leaving:' || l_proc, 30);
380: when others then
381: --
382: -- When Multiple Message Detection is enabled catch

Line 389: if hr_multi_message.unexpected_error_add(l_proc) then

385: -- Multiple Message List. Otherwise re-raise the
386: -- error.
387: --
388: rollback to update_certification_swi;
389: if hr_multi_message.unexpected_error_add(l_proc) then
390: hr_utility.set_location(' Leaving:' || l_proc,40);
391: raise;
392: end if;
393: --

Line 397: p_return_status := hr_multi_message.get_return_status_disable;

393: --
394: -- Reset IN OUT and set OUT parameters
395: --
396: p_object_version_number := l_object_version_number;
397: p_return_status := hr_multi_message.get_return_status_disable;
398: hr_utility.set_location(' Leaving:' || l_proc,50);
399: end update_certification;
400: -- ----------------------------------------------------------------------------
401: -- |-------------------------< delete_certification >-------------------------|

Line 426: hr_multi_message.enable_message_list;

422: savepoint delete_certification_swi;
423: --
424: -- Initialise Multiple Message Detection
425: --
426: hr_multi_message.enable_message_list;
427: --
428: -- Remember IN OUT parameter IN values
429: --
430: --

Line 459: p_return_status := hr_multi_message.get_return_status_disable;

455: -- Derive the API return status value based on whether
456: -- messages of any type exist in the Multiple Message List.
457: -- Also disable Multiple Message Detection.
458: --
459: p_return_status := hr_multi_message.get_return_status_disable;
460: hr_utility.set_location(' Leaving:' || l_proc,20);
461: --
462: exception
463: when hr_multi_message.error_message_exist then

Line 463: when hr_multi_message.error_message_exist then

459: p_return_status := hr_multi_message.get_return_status_disable;
460: hr_utility.set_location(' Leaving:' || l_proc,20);
461: --
462: exception
463: when hr_multi_message.error_message_exist then
464: --
465: -- Catch the Multiple Message List exception which
466: -- indicates API processing has been aborted because
467: -- at least one message exists in the list.

Line 473: p_return_status := hr_multi_message.get_return_status_disable;

469: rollback to delete_certification_swi;
470: --
471: -- Reset IN OUT parameters and set OUT parameters
472: --
473: p_return_status := hr_multi_message.get_return_status_disable;
474: hr_utility.set_location(' Leaving:' || l_proc, 30);
475: when others then
476: --
477: -- When Multiple Message Detection is enabled catch

Line 484: if hr_multi_message.unexpected_error_add(l_proc) then

480: -- Multiple Message List. Otherwise re-raise the
481: -- error.
482: --
483: rollback to delete_certification_swi;
484: if hr_multi_message.unexpected_error_add(l_proc) then
485: hr_utility.set_location(' Leaving:' || l_proc,40);
486: raise;
487: end if;
488: --

Line 491: p_return_status := hr_multi_message.get_return_status_disable;

487: end if;
488: --
489: -- Reset IN OUT and set OUT parameters
490: --
491: p_return_status := hr_multi_message.get_return_status_disable;
492: hr_utility.set_location(' Leaving:' || l_proc,50);
493: end delete_certification;
494:
495: -- ----------------------------------------------------------------------------

Line 601: IF hr_multi_message.exception_add

597: EXCEPTION
598:
599: WHEN app_exception.application_exception THEN
600:
601: IF hr_multi_message.exception_add
602: (p_associated_column1 => 'OTA_CERTIFICATIONS_TL.NAME') THEN
603:
604: hr_utility.set_location(' Leaving:'||l_proc, 92);
605: RAISE;