DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_SWI dependencies on HR_UTILITY

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

29: -- Other variables
30: l_approval_group_id number;
31: l_proc varchar2(72) := g_package ||'create_ame_approver_group';
32: Begin
33: hr_utility.set_location(' Entering:' || l_proc,10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_ame_approver_group_s;

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

80: -- messages of any type exist in the Multiple Message List.
81: -- Also disable Multiple Message Detection.
82: --
83: p_return_status := hr_multi_message.get_return_status_disable;
84: hr_utility.set_location(' Leaving:' || l_proc,20);
85: --
86: exception
87: when hr_multi_message.error_message_exist then
88: --

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

97: p_start_date := null;
98: p_end_date := null;
99: p_object_version_number := null;
100: p_return_status := hr_multi_message.get_return_status_disable;
101: hr_utility.set_location(' Leaving:' || l_proc, 30);
102: when others then
103: --
104: -- When Multiple Message Detection is enabled catch
105: -- any Application specific or other unexpected

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

108: -- error.
109: --
110: rollback to create_ame_approver_group_s;
111: if hr_multi_message.unexpected_error_add(l_proc) then
112: hr_utility.set_location(' Leaving:' || l_proc,40);
113: raise;
114: end if;
115: --
116: -- Reset IN OUT and set OUT parameters

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

118: p_start_date := null;
119: p_end_date := null;
120: p_object_version_number := null;
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving:' || l_proc,50);
123: end create_ame_approver_group;
124: -- ----------------------------------------------------------------------------
125: -- |-----------------------< update_ame_approver_group >----------------------|
126: -- ----------------------------------------------------------------------------

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

144: --
145: -- Other variables
146: l_proc varchar2(72) := g_package ||'update_ame_approver_group';
147: Begin
148: hr_utility.set_location(' Entering:' || l_proc,10);
149: --
150: -- Issue a savepoint
151: --
152: savepoint update_ame_approver_group_s;

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

192: -- messages of any type exist in the Multiple Message List.
193: -- Also disable Multiple Message Detection.
194: --
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198: exception
199: when hr_multi_message.error_message_exist then
200: --

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

209: p_object_version_number := l_object_version_number;
210: p_start_date := null;
211: p_end_date := null;
212: p_return_status := hr_multi_message.get_return_status_disable;
213: hr_utility.set_location(' Leaving:' || l_proc, 30);
214: when others then
215: --
216: -- When Multiple Message Detection is enabled catch
217: -- any Application specific or other unexpected

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

220: -- error.
221: --
222: rollback to update_ame_approver_group_s;
223: if hr_multi_message.unexpected_error_add(l_proc) then
224: hr_utility.set_location(' Leaving:' || l_proc,40);
225: raise;
226: end if;
227: --
228: -- Reset IN OUT and set OUT parameters

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

230: p_object_version_number := l_object_version_number;
231: p_start_date := null;
232: p_end_date := null;
233: p_return_status := hr_multi_message.get_return_status_disable;
234: hr_utility.set_location(' Leaving:' || l_proc,50);
235: end update_ame_approver_group;
236: -- ----------------------------------------------------------------------------
237: -- |-----------------------< delete_ame_approver_group >----------------------|
238: -- ----------------------------------------------------------------------------

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

253: --
254: -- Other variables
255: l_proc varchar2(72) := g_package ||'delete_ame_approver_group';
256: Begin
257: hr_utility.set_location(' Entering:' || l_proc,10);
258: --
259: -- Issue a savepoint
260: --
261: savepoint delete_ame_approver_group_s;

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

298: -- messages of any type exist in the Multiple Message List.
299: -- Also disable Multiple Message Detection.
300: --
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc,20);
303: --
304: exception
305: when hr_multi_message.error_message_exist then
306: --

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

315: p_object_version_number := l_object_version_number;
316: p_start_date := null;
317: p_end_date := null;
318: p_return_status := hr_multi_message.get_return_status_disable;
319: hr_utility.set_location(' Leaving:' || l_proc, 30);
320: when others then
321: --
322: -- When Multiple Message Detection is enabled catch
323: -- any Application specific or other unexpected

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

326: -- error.
327: --
328: rollback to delete_ame_approver_group_s;
329: if hr_multi_message.unexpected_error_add(l_proc) then
330: hr_utility.set_location(' Leaving:' || l_proc,40);
331: raise;
332: end if;
333: --
334: -- Reset IN OUT and set OUT parameters

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

336: p_object_version_number := l_object_version_number;
337: p_start_date := null;
338: p_end_date := null;
339: p_return_status := hr_multi_message.get_return_status_disable;
340: hr_utility.set_location(' Leaving:' || l_proc,50);
341: end delete_ame_approver_group;
342: -- ----------------------------------------------------------------------------
343: -- |---------------------< create_approver_group_config >---------------------|
344: -- ----------------------------------------------------------------------------

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

361: --
362: -- Other variables
363: l_proc varchar2(72) := g_package ||'create_approver_group_config';
364: Begin
365: hr_utility.set_location(' Entering:' || l_proc,10);
366: --
367: -- Issue a savepoint
368: --
369: savepoint create_approver_group_config_s;

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

408: -- messages of any type exist in the Multiple Message List.
409: -- Also disable Multiple Message Detection.
410: --
411: p_return_status := hr_multi_message.get_return_status_disable;
412: hr_utility.set_location(' Leaving:' || l_proc,20);
413: --
414: exception
415: when hr_multi_message.error_message_exist then
416: --

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

425: p_object_version_number := null;
426: p_start_date := null;
427: p_end_date := null;
428: p_return_status := hr_multi_message.get_return_status_disable;
429: hr_utility.set_location(' Leaving:' || l_proc, 30);
430: when others then
431: --
432: -- When Multiple Message Detection is enabled catch
433: -- any Application specific or other unexpected

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

436: -- error.
437: --
438: rollback to create_approver_group_config_s;
439: if hr_multi_message.unexpected_error_add(l_proc) then
440: hr_utility.set_location(' Leaving:' || l_proc,40);
441: raise;
442: end if;
443: --
444: -- Reset IN OUT and set OUT parameters

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

446: p_object_version_number := null;
447: p_start_date := null;
448: p_end_date := null;
449: p_return_status := hr_multi_message.get_return_status_disable;
450: hr_utility.set_location(' Leaving:' || l_proc,50);
451: end create_approver_group_config;
452: -- ----------------------------------------------------------------------------
453: -- |---------------------< delete_approver_group_config >---------------------|
454: -- ----------------------------------------------------------------------------

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

470: --
471: -- Other variables
472: l_proc varchar2(72) := g_package ||'delete_approver_group_config';
473: Begin
474: hr_utility.set_location(' Entering:' || l_proc,10);
475: --
476: -- Issue a savepoint
477: --
478: savepoint delete_approver_group_config_s;

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

516: -- messages of any type exist in the Multiple Message List.
517: -- Also disable Multiple Message Detection.
518: --
519: p_return_status := hr_multi_message.get_return_status_disable;
520: hr_utility.set_location(' Leaving:' || l_proc,20);
521: --
522: exception
523: when hr_multi_message.error_message_exist then
524: --

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

533: p_object_version_number := l_object_version_number;
534: p_start_date := null;
535: p_end_date := null;
536: p_return_status := hr_multi_message.get_return_status_disable;
537: hr_utility.set_location(' Leaving:' || l_proc, 30);
538: when others then
539: --
540: -- When Multiple Message Detection is enabled catch
541: -- any Application specific or other unexpected

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

544: -- error.
545: --
546: rollback to delete_approver_group_config_s;
547: if hr_multi_message.unexpected_error_add(l_proc) then
548: hr_utility.set_location(' Leaving:' || l_proc,40);
549: raise;
550: end if;
551: --
552: -- Reset IN OUT and set OUT parameters

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

554: p_object_version_number := l_object_version_number;
555: p_start_date := null;
556: p_end_date := null;
557: p_return_status := hr_multi_message.get_return_status_disable;
558: hr_utility.set_location(' Leaving:' || l_proc,50);
559: end delete_approver_group_config;
560: -- ----------------------------------------------------------------------------
561: -- |---------------------< update_approver_group_config >---------------------|
562: -- ----------------------------------------------------------------------------

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

580: --
581: -- Other variables
582: l_proc varchar2(72) := g_package ||'update_approver_group_config';
583: Begin
584: hr_utility.set_location(' Entering:' || l_proc,10);
585: --
586: -- Issue a savepoint
587: --
588: savepoint update_approver_group_config_s;

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

628: -- messages of any type exist in the Multiple Message List.
629: -- Also disable Multiple Message Detection.
630: --
631: p_return_status := hr_multi_message.get_return_status_disable;
632: hr_utility.set_location(' Leaving:' || l_proc,20);
633: --
634: exception
635: when hr_multi_message.error_message_exist then
636: --

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

645: p_object_version_number := l_object_version_number;
646: p_start_date := null;
647: p_end_date := null;
648: p_return_status := hr_multi_message.get_return_status_disable;
649: hr_utility.set_location(' Leaving:' || l_proc, 30);
650: when others then
651: --
652: -- When Multiple Message Detection is enabled catch
653: -- any Application specific or other unexpected

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

656: -- error.
657: --
658: rollback to update_approver_group_config_s;
659: if hr_multi_message.unexpected_error_add(l_proc) then
660: hr_utility.set_location(' Leaving:' || l_proc,40);
661: raise;
662: end if;
663: --
664: -- Reset IN OUT and set OUT parameters

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

666: p_object_version_number := l_object_version_number;
667: p_start_date := null;
668: p_end_date := null;
669: p_return_status := hr_multi_message.get_return_status_disable;
670: hr_utility.set_location(' Leaving:' || l_proc,50);
671: end update_approver_group_config;
672: -- ----------------------------------------------------------------------------
673: -- |----------------------< create_approver_group_item >----------------------|
674: -- ----------------------------------------------------------------------------

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

693: --
694: -- Other variables
695: l_proc varchar2(72) := g_package ||'create_approver_group_item';
696: Begin
697: hr_utility.set_location(' Entering:' || l_proc,10);
698: --
699: -- Issue a savepoint
700: --
701: savepoint create_approver_group_item_s;

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

744: -- messages of any type exist in the Multiple Message List.
745: -- Also disable Multiple Message Detection.
746: --
747: p_return_status := hr_multi_message.get_return_status_disable;
748: hr_utility.set_location(' Leaving:' || l_proc,20);
749: --
750: exception
751: when hr_multi_message.error_message_exist then
752: --

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

762: p_object_version_number := null;
763: p_start_date := null;
764: p_end_date := null;
765: p_return_status := hr_multi_message.get_return_status_disable;
766: hr_utility.set_location(' Leaving:' || l_proc, 30);
767: when others then
768: --
769: -- When Multiple Message Detection is enabled catch
770: -- any Application specific or other unexpected

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

773: -- error.
774: --
775: rollback to create_approver_group_item_s;
776: if hr_multi_message.unexpected_error_add(l_proc) then
777: hr_utility.set_location(' Leaving:' || l_proc,40);
778: raise;
779: end if;
780: --
781: -- Reset IN OUT and set OUT parameters

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

784: p_object_version_number := null;
785: p_start_date := null;
786: p_end_date := null;
787: p_return_status := hr_multi_message.get_return_status_disable;
788: hr_utility.set_location(' Leaving:' || l_proc,50);
789: end create_approver_group_item;
790: -- ----------------------------------------------------------------------------
791: -- |----------------------< delete_approver_group_item >----------------------|
792: -- ----------------------------------------------------------------------------

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

807: --
808: -- Other variables
809: l_proc varchar2(72) := g_package ||'delete_approver_group_item';
810: Begin
811: hr_utility.set_location(' Entering:' || l_proc,10);
812: --
813: -- Issue a savepoint
814: --
815: savepoint delete_approver_group_item_s;

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

852: -- messages of any type exist in the Multiple Message List.
853: -- Also disable Multiple Message Detection.
854: --
855: p_return_status := hr_multi_message.get_return_status_disable;
856: hr_utility.set_location(' Leaving:' || l_proc,20);
857: --
858: exception
859: when hr_multi_message.error_message_exist then
860: --

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

869: p_object_version_number := l_object_version_number;
870: p_start_date := null;
871: p_end_date := null;
872: p_return_status := hr_multi_message.get_return_status_disable;
873: hr_utility.set_location(' Leaving:' || l_proc, 30);
874: when others then
875: --
876: -- When Multiple Message Detection is enabled catch
877: -- any Application specific or other unexpected

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

880: -- error.
881: --
882: rollback to delete_approver_group_item_s;
883: if hr_multi_message.unexpected_error_add(l_proc) then
884: hr_utility.set_location(' Leaving:' || l_proc,40);
885: raise;
886: end if;
887: --
888: -- Reset IN OUT and set OUT parameters

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

890: p_object_version_number := l_object_version_number;
891: p_start_date := null;
892: p_end_date := null;
893: p_return_status := hr_multi_message.get_return_status_disable;
894: hr_utility.set_location(' Leaving:' || l_proc,50);
895: end delete_approver_group_item;
896: -- ----------------------------------------------------------------------------
897: -- |----------------------< update_approver_group_item >----------------------|
898: -- ----------------------------------------------------------------------------

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

914: --
915: -- Other variables
916: l_proc varchar2(72) := g_package ||'update_approver_group_item';
917: Begin
918: hr_utility.set_location(' Entering:' || l_proc,10);
919: --
920: -- Issue a savepoint
921: --
922: savepoint update_approver_group_item_s;

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

960: -- messages of any type exist in the Multiple Message List.
961: -- Also disable Multiple Message Detection.
962: --
963: p_return_status := hr_multi_message.get_return_status_disable;
964: hr_utility.set_location(' Leaving:' || l_proc,20);
965: --
966: exception
967: when hr_multi_message.error_message_exist then
968: --

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

977: p_object_version_number := l_object_version_number;
978: p_start_date := null;
979: p_end_date := null;
980: p_return_status := hr_multi_message.get_return_status_disable;
981: hr_utility.set_location(' Leaving:' || l_proc, 30);
982: when others then
983: --
984: -- When Multiple Message Detection is enabled catch
985: -- any Application specific or other unexpected

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

988: -- error.
989: --
990: rollback to update_approver_group_item_s;
991: if hr_multi_message.unexpected_error_add(l_proc) then
992: hr_utility.set_location(' Leaving:' || l_proc,40);
993: raise;
994: end if;
995: --
996: -- Reset IN OUT and set OUT parameters

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

998: p_object_version_number := l_object_version_number;
999: p_start_date := null;
1000: p_end_date := null;
1001: p_return_status := hr_multi_message.get_return_status_disable;
1002: hr_utility.set_location(' Leaving:' || l_proc,50);
1003: end update_approver_group_item;
1004: end ame_approver_group_swi;