DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_SWI dependencies on HR_UTILITY

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

42: --
43: -- Other variables
44: l_proc varchar2(72) := g_package ||'create_affectation';
45: Begin
46: hr_utility.set_location(' Entering:' || l_proc,10);
47: --
48: -- Issue a savepoint
49: --
50: savepoint create_affectation_swi;

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

104: -- messages of any type exist in the Multiple Message List.
105: -- Also disable Multiple Message Detection.
106: --
107: p_return_status := hr_multi_message.get_return_status_disable;
108: hr_utility.set_location(' Leaving:' || l_proc,20);
109: --
110: exception
111: when hr_multi_message.error_message_exist then
112: --

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

126: p_effective_start_date := null;
127: p_effective_end_date := null;
128: p_assignment_sequence := null;
129: p_return_status := hr_multi_message.get_return_status_disable;
130: hr_utility.set_location(' Leaving:' || l_proc, 30);
131: when others then
132: --
133: -- When Multiple Message Detection is enabled catch
134: -- any Application specific or other unexpected

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

137: -- error.
138: --
139: rollback to create_affectation_swi;
140: if hr_multi_message.unexpected_error_add(l_proc) then
141: hr_utility.set_location(' Leaving:' || l_proc,40);
142: raise;
143: end if;
144: --
145: -- Reset IN OUT and set OUT parameters

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

152: p_effective_start_date := null;
153: p_effective_end_date := null;
154: p_assignment_sequence := null;
155: p_return_status := hr_multi_message.get_return_status_disable;
156: hr_utility.set_location(' Leaving:' || l_proc,50);
157: end create_affectation;
158: -- ----------------------------------------------------------------------------
159: -- |--------------------------< update_affectation >--------------------------|
160: -- ----------------------------------------------------------------------------

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

192: --
193: -- Other variables
194: l_proc varchar2(72) := g_package ||'update_affectation';
195: Begin
196: hr_utility.set_location(' Entering:' || l_proc,10);
197: --
198: -- Issue a savepoint
199: --
200: savepoint update_affectation_swi;

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

254: -- messages of any type exist in the Multiple Message List.
255: -- Also disable Multiple Message Detection.
256: --
257: p_return_status := hr_multi_message.get_return_status_disable;
258: hr_utility.set_location(' Leaving:' || l_proc,20);
259: --
260: exception
261: when hr_multi_message.error_message_exist then
262: --

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

274: p_effective_start_date := null;
275: p_effective_end_date := null;
276: p_assignment_sequence := null;
277: p_return_status := hr_multi_message.get_return_status_disable;
278: hr_utility.set_location(' Leaving:' || l_proc, 30);
279: when others then
280: --
281: -- When Multiple Message Detection is enabled catch
282: -- any Application specific or other unexpected

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

285: -- error.
286: --
287: rollback to update_affectation_swi;
288: if hr_multi_message.unexpected_error_add(l_proc) then
289: hr_utility.set_location(' Leaving:' || l_proc,40);
290: raise;
291: end if;
292: --
293: -- Reset IN OUT and set OUT parameters

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

298: p_effective_start_date := null;
299: p_effective_end_date := null;
300: p_assignment_sequence := null;
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc,50);
303: end update_affectation;
304: -- ----------------------------------------------------------------------------
305: -- |------------------------< update_employment_terms >-----------------------|
306: -- ----------------------------------------------------------------------------

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

334: --
335: -- Other variables
336: l_proc varchar2(72) := g_package ||'update_employment_terms';
337: Begin
338: hr_utility.set_location(' Entering:' || l_proc,10);
339: --
340: -- Issue a savepoint
341: --
342: savepoint update_employment_terms_swi;

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

392: -- messages of any type exist in the Multiple Message List.
393: -- Also disable Multiple Message Detection.
394: --
395: p_return_status := hr_multi_message.get_return_status_disable;
396: hr_utility.set_location(' Leaving:' || l_proc,20);
397: --
398: exception
399: when hr_multi_message.error_message_exist then
400: --

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

411: p_effective_start_date := null;
412: p_effective_end_date := null;
413: p_assignment_sequence := null;
414: p_return_status := hr_multi_message.get_return_status_disable;
415: hr_utility.set_location(' Leaving:' || l_proc, 30);
416: when others then
417: --
418: -- When Multiple Message Detection is enabled catch
419: -- any Application specific or other unexpected

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

422: -- error.
423: --
424: rollback to update_employment_terms_swi;
425: if hr_multi_message.unexpected_error_add(l_proc) then
426: hr_utility.set_location(' Leaving:' || l_proc,40);
427: raise;
428: end if;
429: --
430: -- Reset IN OUT and set OUT parameters

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

434: p_effective_start_date := null;
435: p_effective_end_date := null;
436: p_assignment_sequence := null;
437: p_return_status := hr_multi_message.get_return_status_disable;
438: hr_utility.set_location(' Leaving:' || l_proc,50);
439: end update_employment_terms;
440: -- ----------------------------------------------------------------------------
441: -- |---------------------< update_administrative_career >---------------------|
442: -- ----------------------------------------------------------------------------

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

467: --
468: -- Other variables
469: l_proc varchar2(72) := g_package ||'update_administrative_career';
470: Begin
471: hr_utility.set_location(' Entering:' || l_proc,10);
472: --
473: -- Issue a savepoint
474: --
475: savepoint update_admin_career_swi;

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

522: -- messages of any type exist in the Multiple Message List.
523: -- Also disable Multiple Message Detection.
524: --
525: p_return_status := hr_multi_message.get_return_status_disable;
526: hr_utility.set_location(' Leaving:' || l_proc,20);
527: --
528: exception
529: when hr_multi_message.error_message_exist then
530: --

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

541: p_effective_start_date := null;
542: p_effective_end_date := null;
543: p_assignment_sequence := null;
544: p_return_status := hr_multi_message.get_return_status_disable;
545: hr_utility.set_location(' Leaving:' || l_proc, 30);
546: when others then
547: --
548: -- When Multiple Message Detection is enabled catch
549: -- any Application specific or other unexpected

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

552: -- error.
553: --
554: rollback to update_admin_career_swi;
555: if hr_multi_message.unexpected_error_add(l_proc) then
556: hr_utility.set_location(' Leaving:' || l_proc,40);
557: raise;
558: end if;
559: --
560: -- Reset IN OUT and set OUT parameters

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

564: p_effective_start_date := null;
565: p_effective_end_date := null;
566: p_assignment_sequence := null;
567: p_return_status := hr_multi_message.get_return_status_disable;
568: hr_utility.set_location(' Leaving:' || l_proc,50);
569: end update_administrative_career;
570:
571: PROCEDURE terminate_affectation
572: (p_validate in number default hr_api.g_false_num

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

588: --
589: -- Other variables
590: l_proc varchar2(72) := g_package ||'terminate_affectation';
591: Begin
592: hr_utility.set_location(' Entering:' || l_proc,10);
593: --
594: -- Issue a savepoint
595: --
596: savepoint terminate_affectation_swi;

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

636: -- messages of any type exist in the Multiple Message List.
637: -- Also disable Multiple Message Detection.
638: --
639: p_return_status := hr_multi_message.get_return_status_disable;
640: hr_utility.set_location(' Leaving:' || l_proc,20);
641: --
642: exception
643: when hr_multi_message.error_message_exist then
644: --

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

654: p_object_version_number := null;
655: p_effective_start_date := null;
656: p_effective_end_date := null;
657: p_return_status := hr_multi_message.get_return_status_disable;
658: hr_utility.set_location(' Leaving:' || l_proc, 30);
659: when others then
660: --
661: -- When Multiple Message Detection is enabled catch
662: -- any Application specific or other unexpected

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

665: -- error.
666: --
667: rollback to terminate_affectation_swi;
668: if hr_multi_message.unexpected_error_add(l_proc) then
669: hr_utility.set_location(' Leaving:' || l_proc,40);
670: raise;
671: end if;
672: --
673: -- Reset IN OUT and set OUT parameters

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

677: p_object_version_number := null;
678: p_effective_start_date := null;
679: p_effective_end_date := null;
680: p_return_status := hr_multi_message.get_return_status_disable;
681: hr_utility.set_location(' Leaving:' || l_proc,50);
682:
683: end terminate_affectation;
684:
685: PROCEDURE suspend_affectation

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

700: --
701: -- Other variables
702: l_proc varchar2(72) := g_package ||'suspend_affectation';
703: Begin
704: hr_utility.set_location(' Entering:' || l_proc,10);
705: --
706: -- Issue a savepoint
707: --
708: savepoint suspend_affectation_swi;

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

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

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

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

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

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

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

786: p_object_version_number := null;
787: p_effective_start_date := null;
788: p_effective_end_date := null;
789: p_return_status := hr_multi_message.get_return_status_disable;
790: hr_utility.set_location(' Leaving:' || l_proc,50);
791:
792: end suspend_affectation;
793:
794: PROCEDURE activate_affectation

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

809: --
810: -- Other variables
811: l_proc varchar2(72) := g_package ||'suspend_affectation';
812: Begin
813: hr_utility.set_location(' Entering:' || l_proc,10);
814: --
815: -- Issue a savepoint
816: --
817: savepoint activate_affectation_swi;

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

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

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

872: p_object_version_number := null;
873: p_effective_start_date := null;
874: p_effective_end_date := null;
875: p_return_status := hr_multi_message.get_return_status_disable;
876: hr_utility.set_location(' Leaving:' || l_proc, 30);
877: when others then
878: --
879: -- When Multiple Message Detection is enabled catch
880: -- any Application specific or other unexpected

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

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

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

895: p_object_version_number := null;
896: p_effective_start_date := null;
897: p_effective_end_date := null;
898: p_return_status := hr_multi_message.get_return_status_disable;
899: hr_utility.set_location(' Leaving:' || l_proc,50);
900:
901: end activate_affectation;
902:
903: end pqh_fr_assignment_swi;