DBA Data[Home] [Help]

APPS.PQH_SITUATIONS_SWI dependencies on HR_MULTI_MESSAGE

Line 107: hr_multi_message.enable_message_list;

103: savepoint create_situation_swi;
104: --
105: -- Initialise Multiple Message Detection
106: --
107: hr_multi_message.enable_message_list;
108: --
109: -- Remember IN OUT parameter IN values
110: --
111: --

Line 213: p_return_status := hr_multi_message.get_return_status_disable;

209: -- Derive the API return status value based on whether
210: -- messages of any type exist in the Multiple Message List.
211: -- Also disable Multiple Message Detection.
212: --
213: p_return_status := hr_multi_message.get_return_status_disable;
214: hr_utility.set_location(' Leaving:' || l_proc,20);
215: --
216: exception
217: when hr_multi_message.error_message_exist then

Line 217: when hr_multi_message.error_message_exist then

213: p_return_status := hr_multi_message.get_return_status_disable;
214: hr_utility.set_location(' Leaving:' || l_proc,20);
215: --
216: exception
217: when hr_multi_message.error_message_exist then
218: --
219: -- Catch the Multiple Message List exception which
220: -- indicates API processing has been aborted because
221: -- at least one message exists in the list.

Line 229: p_return_status := hr_multi_message.get_return_status_disable;

225: -- Reset IN OUT parameters and set OUT parameters
226: --
227: p_situation_id := null;
228: p_object_version_number := null;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc, 30);
231: when others then
232: --
233: -- When Multiple Message Detection is enabled catch

Line 240: if hr_multi_message.unexpected_error_add(l_proc) then

236: -- Multiple Message List. Otherwise re-raise the
237: -- error.
238: --
239: rollback to create_situation_swi;
240: if hr_multi_message.unexpected_error_add(l_proc) then
241: hr_utility.set_location(' Leaving:' || l_proc,40);
242: raise;
243: end if;
244: --

Line 249: p_return_status := hr_multi_message.get_return_status_disable;

245: -- Reset IN OUT and set OUT parameters
246: --
247: p_situation_id := null;
248: p_object_version_number := null;
249: p_return_status := hr_multi_message.get_return_status_disable;
250: hr_utility.set_location(' Leaving:' || l_proc,50);
251: end create_situation;
252: -- ----------------------------------------------------------------------------
253: -- |---------------------------< delete_situation >---------------------------|

Line 278: hr_multi_message.enable_message_list;

274: savepoint delete_situation_swi;
275: --
276: -- Initialise Multiple Message Detection
277: --
278: hr_multi_message.enable_message_list;
279: --
280: -- Remember IN OUT parameter IN values
281: --
282: --

Line 311: p_return_status := hr_multi_message.get_return_status_disable;

307: -- Derive the API return status value based on whether
308: -- messages of any type exist in the Multiple Message List.
309: -- Also disable Multiple Message Detection.
310: --
311: p_return_status := hr_multi_message.get_return_status_disable;
312: hr_utility.set_location(' Leaving:' || l_proc,20);
313: --
314: exception
315: when hr_multi_message.error_message_exist then

Line 315: when hr_multi_message.error_message_exist then

311: p_return_status := hr_multi_message.get_return_status_disable;
312: hr_utility.set_location(' Leaving:' || l_proc,20);
313: --
314: exception
315: when hr_multi_message.error_message_exist then
316: --
317: -- Catch the Multiple Message List exception which
318: -- indicates API processing has been aborted because
319: -- at least one message exists in the list.

Line 325: p_return_status := hr_multi_message.get_return_status_disable;

321: rollback to delete_situation_swi;
322: --
323: -- Reset IN OUT parameters and set OUT parameters
324: --
325: p_return_status := hr_multi_message.get_return_status_disable;
326: hr_utility.set_location(' Leaving:' || l_proc, 30);
327: when others then
328: --
329: -- When Multiple Message Detection is enabled catch

Line 336: if hr_multi_message.unexpected_error_add(l_proc) then

332: -- Multiple Message List. Otherwise re-raise the
333: -- error.
334: --
335: rollback to delete_situation_swi;
336: if hr_multi_message.unexpected_error_add(l_proc) then
337: hr_utility.set_location(' Leaving:' || l_proc,40);
338: raise;
339: end if;
340: --

Line 343: p_return_status := hr_multi_message.get_return_status_disable;

339: end if;
340: --
341: -- Reset IN OUT and set OUT parameters
342: --
343: p_return_status := hr_multi_message.get_return_status_disable;
344: hr_utility.set_location(' Leaving:' || l_proc,50);
345: end delete_situation;
346: -- ----------------------------------------------------------------------------
347: -- |---------------------------< update_situation >---------------------------|

Line 446: hr_multi_message.enable_message_list;

442: savepoint update_situation_swi;
443: --
444: -- Initialise Multiple Message Detection
445: --
446: hr_multi_message.enable_message_list;
447: --
448: -- Remember IN OUT parameter IN values
449: --
450: l_object_version_number := p_object_version_number;

Line 553: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 557: when hr_multi_message.error_message_exist then

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

Line 568: p_return_status := hr_multi_message.get_return_status_disable;

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

Line 579: if hr_multi_message.unexpected_error_add(l_proc) then

575: -- Multiple Message List. Otherwise re-raise the
576: -- error.
577: --
578: rollback to update_situation_swi;
579: if hr_multi_message.unexpected_error_add(l_proc) then
580: hr_utility.set_location(' Leaving:' || l_proc,40);
581: raise;
582: end if;
583: --

Line 587: p_return_status := hr_multi_message.get_return_status_disable;

583: --
584: -- Reset IN OUT and set OUT parameters
585: --
586: p_object_version_number := l_object_version_number;
587: p_return_status := hr_multi_message.get_return_status_disable;
588: hr_utility.set_location(' Leaving:' || l_proc,50);
589: end update_situation;
590: end pqh_situations_swi;