DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_SWI dependencies on HR_MULTI_MESSAGE

Line 54: hr_multi_message.enable_message_list;

50: savepoint create_affectation_swi;
51: --
52: -- Initialise Multiple Message Detection
53: --
54: hr_multi_message.enable_message_list;
55: --
56: -- Remember IN OUT parameter IN values
57: --
58: l_assignment_number := p_assignment_number;

Line 107: p_return_status := hr_multi_message.get_return_status_disable;

103: -- Derive the API return status value based on whether
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

Line 111: when hr_multi_message.error_message_exist then

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: --
113: -- Catch the Multiple Message List exception which
114: -- indicates API processing has been aborted because
115: -- at least one message exists in the list.

Line 129: p_return_status := hr_multi_message.get_return_status_disable;

125: p_object_version_number := null;
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

Line 140: if hr_multi_message.unexpected_error_add(l_proc) then

136: -- Multiple Message List. Otherwise re-raise the
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: --

Line 155: p_return_status := hr_multi_message.get_return_status_disable;

151: p_object_version_number := null;
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 >--------------------------|

Line 204: hr_multi_message.enable_message_list;

200: savepoint update_affectation_swi;
201: --
202: -- Initialise Multiple Message Detection
203: --
204: hr_multi_message.enable_message_list;
205: --
206: -- Remember IN OUT parameter IN values
207: --
208: l_object_version_number := p_object_version_number;

Line 257: p_return_status := hr_multi_message.get_return_status_disable;

253: -- Derive the API return status value based on whether
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

Line 261: when hr_multi_message.error_message_exist then

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: --
263: -- Catch the Multiple Message List exception which
264: -- indicates API processing has been aborted because
265: -- at least one message exists in the list.

Line 277: p_return_status := hr_multi_message.get_return_status_disable;

273: p_object_version_number := l_object_version_number;
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

Line 288: if hr_multi_message.unexpected_error_add(l_proc) then

284: -- Multiple Message List. Otherwise re-raise the
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: --

Line 301: p_return_status := hr_multi_message.get_return_status_disable;

297: p_object_version_number := l_object_version_number;
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 >-----------------------|

Line 346: hr_multi_message.enable_message_list;

342: savepoint update_employment_terms_swi;
343: --
344: -- Initialise Multiple Message Detection
345: --
346: hr_multi_message.enable_message_list;
347: --
348: -- Remember IN OUT parameter IN values
349: --
350: l_object_version_number := p_object_version_number;

Line 395: p_return_status := hr_multi_message.get_return_status_disable;

391: -- Derive the API return status value based on whether
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

Line 399: when hr_multi_message.error_message_exist then

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: --
401: -- Catch the Multiple Message List exception which
402: -- indicates API processing has been aborted because
403: -- at least one message exists in the list.

Line 414: p_return_status := hr_multi_message.get_return_status_disable;

410: p_object_version_number := l_object_version_number;
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

Line 425: if hr_multi_message.unexpected_error_add(l_proc) then

421: -- Multiple Message List. Otherwise re-raise the
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: --

Line 437: p_return_status := hr_multi_message.get_return_status_disable;

433: p_object_version_number := l_object_version_number;
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 >---------------------|

Line 479: hr_multi_message.enable_message_list;

475: savepoint update_admin_career_swi;
476: --
477: -- Initialise Multiple Message Detection
478: --
479: hr_multi_message.enable_message_list;
480: --
481: -- Remember IN OUT parameter IN values
482: --
483: l_object_version_number := p_object_version_number;

Line 525: p_return_status := hr_multi_message.get_return_status_disable;

521: -- Derive the API return status value based on whether
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

Line 529: when hr_multi_message.error_message_exist then

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: --
531: -- Catch the Multiple Message List exception which
532: -- indicates API processing has been aborted because
533: -- at least one message exists in the list.

Line 544: p_return_status := hr_multi_message.get_return_status_disable;

540: p_object_version_number := l_object_version_number;
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

Line 555: if hr_multi_message.unexpected_error_add(l_proc) then

551: -- Multiple Message List. Otherwise re-raise the
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: --

Line 567: p_return_status := hr_multi_message.get_return_status_disable;

563: p_object_version_number := l_object_version_number;
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

Line 600: hr_multi_message.enable_message_list;

596: savepoint terminate_affectation_swi;
597: --
598: -- Initialise Multiple Message Detection
599: --
600: hr_multi_message.enable_message_list;
601: --
602: -- Remember IN OUT parameter IN values
603: --
604: --

Line 639: p_return_status := hr_multi_message.get_return_status_disable;

635: -- Derive the API return status value based on whether
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

Line 643: when hr_multi_message.error_message_exist then

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: --
645: -- Catch the Multiple Message List exception which
646: -- indicates API processing has been aborted because
647: -- at least one message exists in the list.

Line 657: p_return_status := hr_multi_message.get_return_status_disable;

653: p_group_name := null;
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

Line 668: if hr_multi_message.unexpected_error_add(l_proc) then

664: -- Multiple Message List. Otherwise re-raise the
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: --

Line 680: p_return_status := hr_multi_message.get_return_status_disable;

676: p_group_name := null;
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:

Line 712: hr_multi_message.enable_message_list;

708: savepoint suspend_affectation_swi;
709: --
710: -- Initialise Multiple Message Detection
711: --
712: hr_multi_message.enable_message_list;
713: --
714: -- Remember IN OUT parameter IN values
715: --
716: --

Line 749: p_return_status := hr_multi_message.get_return_status_disable;

745: -- Derive the API return status value based on whether
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

Line 753: when hr_multi_message.error_message_exist then

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: --
755: -- Catch the Multiple Message List exception which
756: -- indicates API processing has been aborted because
757: -- at least one message exists in the list.

Line 766: p_return_status := hr_multi_message.get_return_status_disable;

762: --
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

Line 777: if hr_multi_message.unexpected_error_add(l_proc) then

773: -- Multiple Message List. Otherwise re-raise the
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: --

Line 789: p_return_status := hr_multi_message.get_return_status_disable;

785:
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:

Line 821: hr_multi_message.enable_message_list;

817: savepoint activate_affectation_swi;
818: --
819: -- Initialise Multiple Message Detection
820: --
821: hr_multi_message.enable_message_list;
822: --
823: -- Remember IN OUT parameter IN values
824: --
825: --

Line 858: p_return_status := hr_multi_message.get_return_status_disable;

854: -- Derive the API return status value based on whether
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

Line 862: when hr_multi_message.error_message_exist then

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: --
864: -- Catch the Multiple Message List exception which
865: -- indicates API processing has been aborted because
866: -- at least one message exists in the list.

Line 875: p_return_status := hr_multi_message.get_return_status_disable;

871: --
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

Line 886: if hr_multi_message.unexpected_error_add(l_proc) then

882: -- Multiple Message List. Otherwise re-raise the
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: --

Line 898: p_return_status := hr_multi_message.get_return_status_disable;

894:
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: