DBA Data[Home] [Help]

APPS.PQH_FR_EMP_STAT_SITUATION_SWI dependencies on HR_UTILITY

Line 72: hr_utility.set_location(' Entering:' || l_proc,10);

68: --
69: -- Other variables
70: l_proc varchar2(72) := g_package ||'create_emp_stat_situation';
71: Begin
72: hr_utility.set_location(' Entering:' || l_proc,10);
73: --
74: -- Issue a savepoint
75: --
76: savepoint create_emp_stat_situation_swi;

Line 161: hr_utility.set_location(' Leaving:' || l_proc,20);

157: -- messages of any type exist in the Multiple Message List.
158: -- Also disable Multiple Message Detection.
159: --
160: p_return_status := hr_multi_message.get_return_status_disable;
161: hr_utility.set_location(' Leaving:' || l_proc,20);
162: --
163: exception
164: when hr_multi_message.error_message_exist then
165: --

Line 177: hr_utility.set_location(' Leaving:' || l_proc, 30);

173: --
174: p_emp_stat_situation_id := null;
175: p_object_version_number := null;
176: p_return_status := hr_multi_message.get_return_status_disable;
177: hr_utility.set_location(' Leaving:' || l_proc, 30);
178: when others then
179: --
180: -- When Multiple Message Detection is enabled catch
181: -- any Application specific or other unexpected

Line 188: hr_utility.set_location(' Leaving:' || l_proc,40);

184: -- error.
185: --
186: rollback to create_emp_stat_situation_swi;
187: if hr_multi_message.unexpected_error_add(l_proc) then
188: hr_utility.set_location(' Leaving:' || l_proc,40);
189: raise;
190: end if;
191: --
192: -- Reset IN OUT and set OUT parameters

Line 197: hr_utility.set_location(' Leaving:' || l_proc,50);

193: --
194: p_emp_stat_situation_id := null;
195: p_object_version_number := null;
196: p_return_status := hr_multi_message.get_return_status_disable;
197: hr_utility.set_location(' Leaving:' || l_proc,50);
198: end create_emp_stat_situation;
199: -- ----------------------------------------------------------------------------
200: -- |-----------------------< update_emp_stat_situation >----------------------|
201: -- ----------------------------------------------------------------------------

Line 264: hr_utility.set_location(' Entering:' || l_proc,10);

260: --
261: -- Other variables
262: l_proc varchar2(72) := g_package ||'update_emp_stat_situation';
263: Begin
264: hr_utility.set_location(' Entering:' || l_proc,10);
265: --
266: -- Issue a savepoint
267: --
268: savepoint update_emp_stat_situation_swi;

Line 353: hr_utility.set_location(' Leaving:' || l_proc,20);

349: -- messages of any type exist in the Multiple Message List.
350: -- Also disable Multiple Message Detection.
351: --
352: p_return_status := hr_multi_message.get_return_status_disable;
353: hr_utility.set_location(' Leaving:' || l_proc,20);
354: --
355: exception
356: when hr_multi_message.error_message_exist then
357: --

Line 368: hr_utility.set_location(' Leaving:' || l_proc, 30);

364: -- Reset IN OUT parameters and set OUT parameters
365: --
366: p_object_version_number := l_object_version_number;
367: p_return_status := hr_multi_message.get_return_status_disable;
368: hr_utility.set_location(' Leaving:' || l_proc, 30);
369: when others then
370: --
371: -- When Multiple Message Detection is enabled catch
372: -- any Application specific or other unexpected

Line 379: hr_utility.set_location(' Leaving:' || l_proc,40);

375: -- error.
376: --
377: rollback to update_emp_stat_situation_swi;
378: if hr_multi_message.unexpected_error_add(l_proc) then
379: hr_utility.set_location(' Leaving:' || l_proc,40);
380: raise;
381: end if;
382: --
383: -- Reset IN OUT and set OUT parameters

Line 387: hr_utility.set_location(' Leaving:' || l_proc,50);

383: -- Reset IN OUT and set OUT parameters
384: --
385: p_object_version_number := l_object_version_number;
386: p_return_status := hr_multi_message.get_return_status_disable;
387: hr_utility.set_location(' Leaving:' || l_proc,50);
388: end update_emp_stat_situation;
389: -- ----------------------------------------------------------------------------
390: -- |-----------------------< delete_emp_stat_situation >----------------------|
391: -- ----------------------------------------------------------------------------

Line 407: hr_utility.set_location(' Entering:' || l_proc,10);

403: --
404: -- Other variables
405: l_proc varchar2(72) := g_package ||'delete_emp_stat_situation';
406: Begin
407: hr_utility.set_location(' Entering:' || l_proc,10);
408: --
409: -- Issue a savepoint
410: --
411: savepoint delete_emp_stat_situation_swi;

Line 449: hr_utility.set_location(' Leaving:' || l_proc,20);

445: -- messages of any type exist in the Multiple Message List.
446: -- Also disable Multiple Message Detection.
447: --
448: p_return_status := hr_multi_message.get_return_status_disable;
449: hr_utility.set_location(' Leaving:' || l_proc,20);
450: --
451: exception
452: when hr_multi_message.error_message_exist then
453: --

Line 463: hr_utility.set_location(' Leaving:' || l_proc, 30);

459: --
460: -- Reset IN OUT parameters and set OUT parameters
461: --
462: p_return_status := hr_multi_message.get_return_status_disable;
463: hr_utility.set_location(' Leaving:' || l_proc, 30);
464: when others then
465: --
466: -- When Multiple Message Detection is enabled catch
467: -- any Application specific or other unexpected

Line 474: hr_utility.set_location(' Leaving:' || l_proc,40);

470: -- error.
471: --
472: rollback to delete_emp_stat_situation_swi;
473: if hr_multi_message.unexpected_error_add(l_proc) then
474: hr_utility.set_location(' Leaving:' || l_proc,40);
475: raise;
476: end if;
477: --
478: -- Reset IN OUT and set OUT parameters

Line 481: hr_utility.set_location(' Leaving:' || l_proc,50);

477: --
478: -- Reset IN OUT and set OUT parameters
479: --
480: p_return_status := hr_multi_message.get_return_status_disable;
481: hr_utility.set_location(' Leaving:' || l_proc,50);
482: end delete_emp_stat_situation;
483: -- ----------------------------------------------------------------------------
484: -- |-----------------------< renew_emp_stat_situation >-----------------------|
485: -- ----------------------------------------------------------------------------

Line 508: hr_utility.set_location(' Entering:' || l_proc,10);

504: --
505: -- Other variables
506: l_proc varchar2(72) := g_package ||'renew_emp_stat_situation';
507: Begin
508: hr_utility.set_location(' Entering:' || l_proc,10);
509: --
510: -- Issue a savepoint
511: --
512: savepoint renew_emp_stat_situation_swi;

Line 557: hr_utility.set_location(' Leaving:' || l_proc,20);

553: -- messages of any type exist in the Multiple Message List.
554: -- Also disable Multiple Message Detection.
555: --
556: p_return_status := hr_multi_message.get_return_status_disable;
557: hr_utility.set_location(' Leaving:' || l_proc,20);
558: --
559: exception
560: when hr_multi_message.error_message_exist then
561: --

Line 573: hr_utility.set_location(' Leaving:' || l_proc, 30);

569: --
570: p_emp_stat_situation_id := l_emp_stat_situation_id;
571: p_object_version_number := l_object_version_number;
572: p_return_status := hr_multi_message.get_return_status_disable;
573: hr_utility.set_location(' Leaving:' || l_proc, 30);
574: when others then
575: --
576: -- When Multiple Message Detection is enabled catch
577: -- any Application specific or other unexpected

Line 584: hr_utility.set_location(' Leaving:' || l_proc,40);

580: -- error.
581: --
582: rollback to renew_emp_stat_situation_swi;
583: if hr_multi_message.unexpected_error_add(l_proc) then
584: hr_utility.set_location(' Leaving:' || l_proc,40);
585: raise;
586: end if;
587: --
588: -- Reset IN OUT and set OUT parameters

Line 593: hr_utility.set_location(' Leaving:' || l_proc,50);

589: --
590: p_emp_stat_situation_id := l_emp_stat_situation_id;
591: p_object_version_number := l_object_version_number;
592: p_return_status := hr_multi_message.get_return_status_disable;
593: hr_utility.set_location(' Leaving:' || l_proc,50);
594: end renew_emp_stat_situation;
595: -- ----------------------------------------------------------------------------
596: -- |---------------------< reinstate_emp_stat_situation >---------------------|
597: -- ----------------------------------------------------------------------------

Line 616: hr_utility.set_location(' Entering:' || l_proc,10);

612: --
613: -- Other variables
614: l_proc varchar2(72) := g_package ||'reinstate_emp_stat_situation';
615: Begin
616: hr_utility.set_location(' Entering:' || l_proc,10);
617: --
618: -- Issue a savepoint
619: --
620: savepoint reinstate_emp_stat_situation;

Line 661: hr_utility.set_location(' Leaving:' || l_proc,20);

657: -- messages of any type exist in the Multiple Message List.
658: -- Also disable Multiple Message Detection.
659: --
660: p_return_status := hr_multi_message.get_return_status_disable;
661: hr_utility.set_location(' Leaving:' || l_proc,20);
662: --
663: exception
664: when hr_multi_message.error_message_exist then
665: --

Line 676: hr_utility.set_location(' Leaving:' || l_proc, 30);

672: -- Reset IN OUT parameters and set OUT parameters
673: --
674: p_new_emp_stat_situation_id := null;
675: p_return_status := hr_multi_message.get_return_status_disable;
676: hr_utility.set_location(' Leaving:' || l_proc, 30);
677: when others then
678: --
679: -- When Multiple Message Detection is enabled catch
680: -- any Application specific or other unexpected

Line 687: hr_utility.set_location(' Leaving:' || l_proc,40);

683: -- error.
684: --
685: rollback to reinstate_emp_stat_situation;
686: if hr_multi_message.unexpected_error_add(l_proc) then
687: hr_utility.set_location(' Leaving:' || l_proc,40);
688: raise;
689: end if;
690: --
691: -- Reset IN OUT and set OUT parameters

Line 695: hr_utility.set_location(' Leaving:' || l_proc,50);

691: -- Reset IN OUT and set OUT parameters
692: --
693: p_new_emp_stat_situation_id := null;
694: p_return_status := hr_multi_message.get_return_status_disable;
695: hr_utility.set_location(' Leaving:' || l_proc,50);
696: end reinstate_emp_stat_situation;
697: end pqh_fr_emp_stat_situation_swi;