DBA Data[Home] [Help]

APPS.IRC_APPLICANT_TRACKING_SWI dependencies on HR_UTILITY

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

25: -- Other variables
26: l_profile_snapshot_id number;
27: l_proc varchar2(72) := g_package ||'create_applicant_snapshot';
28: Begin
29: hr_utility.set_location(' Entering:' || l_proc,10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_applicant_snapshot_swi;

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

72: -- messages of any type exist in the Multiple Message List.
73: -- Also disable Multiple Message Detection.
74: --
75: p_return_status := hr_multi_message.get_return_status_disable;
76: hr_utility.set_location(' Leaving:' || l_proc,20);
77: --
78: exception
79: when hr_multi_message.error_message_exist then
80: --

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

87: -- Reset IN OUT parameters and set OUT parameters
88: --
89: p_object_version_number := null;
90: p_return_status := hr_multi_message.get_return_status_disable;
91: hr_utility.set_location(' Leaving:' || l_proc, 30);
92: when others then
93: --
94: -- When Multiple Message Detection is enabled catch
95: -- any Application specific or other unexpected

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

98: -- error.
99: --
100: rollback to create_applicant_snapshot_swi;
101: if hr_multi_message.unexpected_error_add(l_proc) then
102: hr_utility.set_location(' Leaving:' || l_proc,40);
103: raise;
104: end if;
105: --
106: -- Reset IN OUT and set OUT parameters

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

106: -- Reset IN OUT and set OUT parameters
107: --
108: p_object_version_number := null;
109: p_return_status := hr_multi_message.get_return_status_disable;
110: hr_utility.set_location(' Leaving:' || l_proc,50);
111: end create_applicant_snapshot;
112: --
113: -- ----------------------------------------------------------------------------
114: -- |-----------------------< update_applicant_snapshot >----------------------|

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

131: --
132: -- Other variables
133: l_proc varchar2(72) := g_package ||'update_applicant_snapshot';
134: Begin
135: hr_utility.set_location(' Entering:' || l_proc,10);
136: --
137: -- Issue a savepoint
138: --
139: savepoint update_applicant_snapshot_swi;

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

177: -- messages of any type exist in the Multiple Message List.
178: -- Also disable Multiple Message Detection.
179: --
180: p_return_status := hr_multi_message.get_return_status_disable;
181: hr_utility.set_location(' Leaving:' || l_proc,20);
182: --
183: exception
184: when hr_multi_message.error_message_exist then
185: --

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

193: --
194: p_profile_snapshot_id := l_profile_snapshot_id;
195: p_object_version_number := l_object_version_number;
196: p_return_status := hr_multi_message.get_return_status_disable;
197: hr_utility.set_location(' Leaving:' || l_proc, 30);
198: when others then
199: --
200: -- When Multiple Message Detection is enabled catch
201: -- any Application specific or other unexpected

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

204: -- error.
205: --
206: rollback to update_applicant_snapshot_swi;
207: if hr_multi_message.unexpected_error_add(l_proc) then
208: hr_utility.set_location(' Leaving:' || l_proc,40);
209: raise;
210: end if;
211: --
212: -- Reset IN OUT and set OUT parameters

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

213: --
214: p_profile_snapshot_id := l_profile_snapshot_id;
215: p_object_version_number := l_object_version_number;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,50);
218: end update_applicant_snapshot;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------< delete_applicant_snapshot >----------------------|

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

236: --
237: -- Other variables
238: l_proc varchar2(72) := g_package ||'delete_applicant_snapshot';
239: Begin
240: hr_utility.set_location(' Entering:' || l_proc,10);
241: --
242: -- Issue a savepoint
243: --
244: savepoint delete_applicant_snapshot_swi;

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

280: -- messages of any type exist in the Multiple Message List.
281: -- Also disable Multiple Message Detection.
282: --
283: p_return_status := hr_multi_message.get_return_status_disable;
284: hr_utility.set_location(' Leaving:' || l_proc,20);
285: --
286: exception
287: when hr_multi_message.error_message_exist then
288: --

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

294: --
295: -- Reset IN OUT parameters and set OUT parameters
296: --
297: p_return_status := hr_multi_message.get_return_status_disable;
298: hr_utility.set_location(' Leaving:' || l_proc, 30);
299: when others then
300: --
301: -- When Multiple Message Detection is enabled catch
302: -- any Application specific or other unexpected

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

305: -- error.
306: --
307: rollback to delete_applicant_snapshot_swi;
308: if hr_multi_message.unexpected_error_add(l_proc) then
309: hr_utility.set_location(' Leaving:' || l_proc,40);
310: raise;
311: end if;
312: --
313: -- Reset IN OUT and set OUT parameters

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

312: --
313: -- Reset IN OUT and set OUT parameters
314: --
315: p_return_status := hr_multi_message.get_return_status_disable;
316: hr_utility.set_location(' Leaving:' || l_proc,50);
317: end delete_applicant_snapshot;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |------------------------< create_search_criteria >------------------------|

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

337: l_saved_search_criteria_id number;
338: l_proc varchar2(72) := g_package ||'create_search_criteria';
339: Begin
340:
341: hr_utility.set_location(' Entering:' || l_proc,10);
342: --
343: -- Issue a savepoint
344: --
345: savepoint create_search_criteria_swi;

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

383: -- messages of any type exist in the Multiple Message List.
384: -- Also disable Multiple Message Detection.
385: --
386: p_return_status := hr_multi_message.get_return_status_disable;
387: hr_utility.set_location(' Leaving:' || l_proc,20);
388: --
389: exception
390: when hr_multi_message.error_message_exist then
391: --

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

398: -- Reset IN OUT parameters and set OUT parameters
399: --
400: p_object_version_number := null;
401: p_return_status := hr_multi_message.get_return_status_disable;
402: hr_utility.set_location(' Leaving:' || l_proc, 30);
403: when others then
404: --
405: -- When Multiple Message Detection is enabled catch
406: -- any Application specific or other unexpected

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

409: -- error.
410: --
411: rollback to create_search_criteria_swi;
412: if hr_multi_message.unexpected_error_add(l_proc) then
413: hr_utility.set_location(' Leaving:' || l_proc,40);
414: raise;
415: end if;
416: --
417: -- Reset IN OUT and set OUT parameters

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

417: -- Reset IN OUT and set OUT parameters
418: --
419: p_object_version_number := null;
420: p_return_status := hr_multi_message.get_return_status_disable;
421: hr_utility.set_location(' Leaving:' || l_proc,50);
422: end create_search_criteria;
423: --
424: -- ----------------------------------------------------------------------------
425: -- |------------------------< update_search_criteria >------------------------|

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

441: --
442: -- Other variables
443: l_proc varchar2(72) := g_package ||'update_search_criteria';
444: Begin
445: hr_utility.set_location(' Entering:' || l_proc,10);
446: --
447: -- Issue a savepoint
448: --
449: savepoint update_search_criteria_swi;

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

486: -- messages of any type exist in the Multiple Message List.
487: -- Also disable Multiple Message Detection.
488: --
489: p_return_status := hr_multi_message.get_return_status_disable;
490: hr_utility.set_location(' Leaving:' || l_proc,20);
491: --
492: exception
493: when hr_multi_message.error_message_exist then
494: --

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

502: --
503: p_saved_search_criteria_id := l_saved_search_criteria_id;
504: p_object_version_number := l_object_version_number;
505: p_return_status := hr_multi_message.get_return_status_disable;
506: hr_utility.set_location(' Leaving:' || l_proc, 30);
507: when others then
508: --
509: -- When Multiple Message Detection is enabled catch
510: -- any Application specific or other unexpected

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

513: -- error.
514: --
515: rollback to update_search_criteria_swi;
516: if hr_multi_message.unexpected_error_add(l_proc) then
517: hr_utility.set_location(' Leaving:' || l_proc,40);
518: raise;
519: end if;
520: --
521: -- Reset IN OUT and set OUT parameters

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

522: --
523: p_saved_search_criteria_id := l_saved_search_criteria_id;
524: p_object_version_number := l_object_version_number;
525: p_return_status := hr_multi_message.get_return_status_disable;
526: hr_utility.set_location(' Leaving:' || l_proc,50);
527: end update_search_criteria;
528:
529: -- ----------------------------------------------------------------------------
530: -- |------------------------------< delete_search_criteria >-----------------------------|

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

544: --
545: -- Other variables
546: l_proc varchar2(72) := g_package ||'delete_search_criteria';
547: Begin
548: hr_utility.set_location(' Entering:' || l_proc,10);
549: --
550: -- Issue a savepoint
551: --
552: savepoint delete_search_criteria_swi;

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

587: -- messages of any type exist in the Multiple Message List.
588: -- Also disable Multiple Message Detection.
589: --
590: p_return_status := hr_multi_message.get_return_status_disable;
591: hr_utility.set_location(' Leaving:' || l_proc,20);
592: --
593: exception
594: when hr_multi_message.error_message_exist then
595: --

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

601: --
602: -- Reset IN OUT parameters and set OUT parameters
603: --
604: p_return_status := hr_multi_message.get_return_status_disable;
605: hr_utility.set_location(' Leaving:' || l_proc, 30);
606: when others then
607: --
608: -- When Multiple Message Detection is enabled catch
609: -- any Application specific or other unexpected

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

612: -- error.
613: --
614: rollback to delete_search_criteria_swi;
615: if hr_multi_message.unexpected_error_add(l_proc) then
616: hr_utility.set_location(' Leaving:' || l_proc,40);
617: raise;
618: end if;
619: --
620: -- Reset IN OUT and set OUT parameters

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

619: --
620: -- Reset IN OUT and set OUT parameters
621: --
622: p_return_status := hr_multi_message.get_return_status_disable;
623: hr_utility.set_location(' Leaving:' || l_proc,50);
624: end delete_search_criteria;
625: --
626: -- ----------------------------------------------------------------------------
627: -- |-----------------------< create_apl_profile_access >----------------------|

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

642: -- Other variables
643: l_apl_profile_access_id number;
644: l_proc varchar2(72) := g_package ||'create_apl_profile_access';
645: Begin
646: hr_utility.set_location(' Entering:' || l_proc,10);
647: --
648: -- Issue a savepoint
649: --
650: savepoint create_apl_profile_access_swi;

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

685: -- messages of any type exist in the Multiple Message List.
686: -- Also disable Multiple Message Detection.
687: --
688: p_return_status := hr_multi_message.get_return_status_disable;
689: hr_utility.set_location(' Leaving:' || l_proc,20);
690: --
691: exception
692: when hr_multi_message.error_message_exist then
693: --

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

700: -- Reset IN OUT parameters and set OUT parameters
701: --
702: p_object_version_number := null;
703: p_return_status := hr_multi_message.get_return_status_disable;
704: hr_utility.set_location(' Leaving:' || l_proc, 30);
705: when others then
706: --
707: -- When Multiple Message Detection is enabled catch
708: -- any Application specific or other unexpected

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

711: -- error.
712: --
713: rollback to create_apl_profile_access_swi;
714: if hr_multi_message.unexpected_error_add(l_proc) then
715: hr_utility.set_location(' Leaving:' || l_proc,40);
716: raise;
717: end if;
718: --
719: -- Reset IN OUT and set OUT parameters

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

719: -- Reset IN OUT and set OUT parameters
720: --
721: p_object_version_number := null;
722: p_return_status := hr_multi_message.get_return_status_disable;
723: hr_utility.set_location(' Leaving:' || l_proc,50);
724: end create_apl_profile_access;
725: --
726: -- ----------------------------------------------------------------------------
727: -- |-----------------------< update_apl_profile_access >----------------------|

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

743: --
744: -- Other variables
745: l_proc varchar2(72) := g_package ||'update_apl_profile_access';
746: Begin
747: hr_utility.set_location(' Entering:' || l_proc,10);
748: --
749: -- Issue a savepoint
750: --
751: savepoint update_apl_profile_access_swi;

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

788: -- messages of any type exist in the Multiple Message List.
789: -- Also disable Multiple Message Detection.
790: --
791: p_return_status := hr_multi_message.get_return_status_disable;
792: hr_utility.set_location(' Leaving:' || l_proc,20);
793: --
794: exception
795: when hr_multi_message.error_message_exist then
796: --

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

804: --
805: p_apl_profile_access_id := l_apl_profile_access_id;
806: p_object_version_number := l_object_version_number;
807: p_return_status := hr_multi_message.get_return_status_disable;
808: hr_utility.set_location(' Leaving:' || l_proc, 30);
809: when others then
810: --
811: -- When Multiple Message Detection is enabled catch
812: -- any Application specific or other unexpected

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

815: -- error.
816: --
817: rollback to update_apl_profile_access_swi;
818: if hr_multi_message.unexpected_error_add(l_proc) then
819: hr_utility.set_location(' Leaving:' || l_proc,40);
820: raise;
821: end if;
822: --
823: -- Reset IN OUT and set OUT parameters

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

824: --
825: p_apl_profile_access_id := l_apl_profile_access_id;
826: p_object_version_number := l_object_version_number;
827: p_return_status := hr_multi_message.get_return_status_disable;
828: hr_utility.set_location(' Leaving:' || l_proc,50);
829: end update_apl_profile_access;
830: --
831: ------------------------------------------------------------------------------------------
832: -- |------------------------------< delete_apl_profile_access >-----------------------------|

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

846: --
847: -- Other variables
848: l_proc varchar2(72) := g_package ||'delete_apl_profile_access';
849: Begin
850: hr_utility.set_location(' Entering:' || l_proc,10);
851: --
852: -- Issue a savepoint
853: --
854: savepoint delete_apl_profile_access_swi;

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

889: -- messages of any type exist in the Multiple Message List.
890: -- Also disable Multiple Message Detection.
891: --
892: p_return_status := hr_multi_message.get_return_status_disable;
893: hr_utility.set_location(' Leaving:' || l_proc,20);
894: --
895: exception
896: when hr_multi_message.error_message_exist then
897: --

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

903: --
904: -- Reset IN OUT parameters and set OUT parameters
905: --
906: p_return_status := hr_multi_message.get_return_status_disable;
907: hr_utility.set_location(' Leaving:' || l_proc, 30);
908: when others then
909: --
910: -- When Multiple Message Detection is enabled catch
911: -- any Application specific or other unexpected

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

914: -- error.
915: --
916: rollback to delete_apl_profile_access_swi;
917: if hr_multi_message.unexpected_error_add(l_proc) then
918: hr_utility.set_location(' Leaving:' || l_proc,40);
919: raise;
920: end if;
921: --
922: -- Reset IN OUT and set OUT parameters

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

921: --
922: -- Reset IN OUT and set OUT parameters
923: --
924: p_return_status := hr_multi_message.get_return_status_disable;
925: hr_utility.set_location(' Leaving:' || l_proc,50);
926: end delete_apl_profile_access;
927: --
928: end irc_applicant_tracking_swi;