DBA Data[Home] [Help]

APPS.OTA_TPM_SWI dependencies on HR_MULTI_MESSAGE

Line 105: hr_multi_message.enable_message_list;

101: SAVEPOINT create_trng_plan_member_swi;
102: --
103: -- Initialise Multiple Message Detection
104: --
105: hr_multi_message.enable_message_list;
106: --
107: -- Remember IN OUT parameter IN values
108: --
109: --

Line 164: p_return_status := hr_multi_message.get_return_status_disable;

160: -- If Training Plan is not created, rollback and return
161: if (l_return_status = 'E') then
162: ROLLBACK TO create_trng_plan_member_swi;
163: p_object_version_NUMBER := NULL;
164: p_return_status := hr_multi_message.get_return_status_disable;
165: return;
166: end if;
167:
168: -- Fetch the Training Plan Id Created.

Line 275: p_return_status := hr_multi_message.get_return_status_disable;

271: -- Derive the API return status value based on whether
272: -- messages of any type exist in the Multiple Message List.
273: -- Also disable Multiple Message Detection.
274: --
275: p_return_status := hr_multi_message.get_return_status_disable;
276: hr_utility.set_location(' Leaving:' || l_proc,20);
277: --
278: EXCEPTION
279: WHEN hr_multi_message.error_message_exist THEN

Line 279: WHEN hr_multi_message.error_message_exist THEN

275: p_return_status := hr_multi_message.get_return_status_disable;
276: hr_utility.set_location(' Leaving:' || l_proc,20);
277: --
278: EXCEPTION
279: WHEN hr_multi_message.error_message_exist THEN
280: --
281: -- Catch the Multiple Message List exception which
282: -- indicates API processing has been aborted because
283: -- at least one message exists in the list.

Line 290: p_return_status := hr_multi_message.get_return_status_disable;

286: --
287: -- Reset IN OUT parameters and set OUT parameters
288: --
289: p_object_version_NUMBER := NULL;
290: p_return_status := hr_multi_message.get_return_status_disable;
291: hr_utility.set_location(' Leaving:' || l_proc, 30);
292:
293: WHEN others THEN
294: --

Line 302: IF hr_multi_message.unexpected_error_add(l_proc) THEN

298: -- Multiple Message List. Otherwise re-raise the
299: -- error.
300: --
301: ROLLBACK TO create_trng_plan_member_swi;
302: IF hr_multi_message.unexpected_error_add(l_proc) THEN
303: hr_utility.set_location(' Leaving:' || l_proc,40);
304: RAISE;
305: END IF;
306: --

Line 310: p_return_status := hr_multi_message.get_return_status_disable;

306: --
307: -- Reset IN OUT and set OUT parameters
308: --
309: p_object_version_NUMBER := NULL;
310: p_return_status := hr_multi_message.get_return_status_disable;
311: hr_utility.set_location(' Leaving:' || l_proc,50);
312: END create_training_plan_member;
313:
314:

Line 341: hr_multi_message.enable_message_list;

337: SAVEPOINT delete_trng_plan_member_swi;
338: --
339: -- Initialise Multiple Message Detection
340: --
341: hr_multi_message.enable_message_list;
342: --
343: -- Remember IN OUT parameter IN values
344: --
345: --

Line 374: p_return_status := hr_multi_message.get_return_status_disable;

370: -- Derive the API return status value based on whether
371: -- messages of any type exist in the Multiple Message List.
372: -- Also disable Multiple Message Detection.
373: --
374: p_return_status := hr_multi_message.get_return_status_disable;
375: hr_utility.set_location(' Leaving:' || l_proc,20);
376: --
377: EXCEPTION
378: WHEN hr_multi_message.error_message_exist THEN

Line 378: WHEN hr_multi_message.error_message_exist THEN

374: p_return_status := hr_multi_message.get_return_status_disable;
375: hr_utility.set_location(' Leaving:' || l_proc,20);
376: --
377: EXCEPTION
378: WHEN hr_multi_message.error_message_exist THEN
379: --
380: -- Catch the Multiple Message List exception which
381: -- indicates API processing has been aborted because
382: -- at least one message exists in the list.

Line 388: p_return_status := hr_multi_message.get_return_status_disable;

384: ROLLBACK TO delete_trng_plan_member_swi;
385: --
386: -- Reset IN OUT parameters and set OUT parameters
387: --
388: p_return_status := hr_multi_message.get_return_status_disable;
389: hr_utility.set_location(' Leaving:' || l_proc, 30);
390: WHEN others THEN
391: --
392: -- When Multiple Message Detection is enabled catch

Line 399: IF hr_multi_message.unexpected_error_add(l_proc) THEN

395: -- Multiple Message List. Otherwise re-raise the
396: -- error.
397: --
398: ROLLBACK TO delete_trng_plan_member_swi;
399: IF hr_multi_message.unexpected_error_add(l_proc) THEN
400: hr_utility.set_location(' Leaving:' || l_proc,40);
401: RAISE;
402: END IF;
403: --

Line 406: p_return_status := hr_multi_message.get_return_status_disable;

402: END IF;
403: --
404: -- Reset IN OUT and set OUT parameters
405: --
406: p_return_status := hr_multi_message.get_return_status_disable;
407: hr_utility.set_location(' Leaving:' || l_proc,50);
408: END delete_training_plan_member;
409: -- ----------------------------------------------------------------------------
410: -- |----------------------< update_training_plan_member >---------------------|

Line 479: hr_multi_message.enable_message_list;

475: SAVEPOINT update_trng_plan_member_swi;
476: --
477: -- Initialise Multiple Message Detection
478: --
479: hr_multi_message.enable_message_list;
480: --
481: -- Remember IN OUT parameter IN values
482: --
483: l_object_version_NUMBER := p_object_version_number;

Line 555: p_return_status := hr_multi_message.get_return_status_disable;

551: -- Derive the API return status value based on whether
552: -- messages of any type exist in the Multiple Message List.
553: -- Also disable Multiple Message Detection.
554: --
555: p_return_status := hr_multi_message.get_return_status_disable;
556: hr_utility.set_location(' Leaving:' || l_proc,20);
557: --
558: EXCEPTION
559: WHEN hr_multi_message.error_message_exist THEN

Line 559: WHEN hr_multi_message.error_message_exist THEN

555: p_return_status := hr_multi_message.get_return_status_disable;
556: hr_utility.set_location(' Leaving:' || l_proc,20);
557: --
558: EXCEPTION
559: WHEN hr_multi_message.error_message_exist THEN
560: --
561: -- Catch the Multiple Message List exception which
562: -- indicates API processing has been aborted because
563: -- at least one message exists in the list.

Line 570: p_return_status := hr_multi_message.get_return_status_disable;

566: --
567: -- Reset IN OUT parameters and set OUT parameters
568: --
569: p_object_version_NUMBER := l_object_version_number;
570: p_return_status := hr_multi_message.get_return_status_disable;
571: hr_utility.set_location(' Leaving:' || l_proc, 30);
572: WHEN others THEN
573: --
574: -- When Multiple Message Detection is enabled catch

Line 581: IF hr_multi_message.unexpected_error_add(l_proc) THEN

577: -- Multiple Message List. Otherwise re-raise the
578: -- error.
579: --
580: ROLLBACK TO update_trng_plan_member_swi;
581: IF hr_multi_message.unexpected_error_add(l_proc) THEN
582: hr_utility.set_location(' Leaving:' || l_proc,40);
583: RAISE;
584: END IF;
585: --

Line 589: p_return_status := hr_multi_message.get_return_status_disable;

585: --
586: -- Reset IN OUT and set OUT parameters
587: --
588: p_object_version_NUMBER := l_object_version_number;
589: p_return_status := hr_multi_message.get_return_status_disable;
590: hr_utility.set_location(' Leaving:' || l_proc,50);
591: END update_training_plan_member;
592: END ota_tpm_swi;