DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_SWI dependencies on HR_MULTI_MESSAGE

Line 179: hr_multi_message.enable_message_list;

175: savepoint create_person_absence_swi;
176: --
177: -- Initialise Multiple Message Detection
178: --
179: hr_multi_message.enable_message_list;
180: --
181: -- Remember IN OUT parameter IN values
182: --
183: -- Bug 6347488 fix starts

Line 338: hr_multi_message.add

334: --
335: if l_validate then
336: if l_dur_dys_less_warning then
337: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
338: hr_multi_message.add
339: (p_message_type => hr_multi_message.g_warning_msg
340: );
341: end if;
342: if l_dur_hrs_less_warning then

Line 339: (p_message_type => hr_multi_message.g_warning_msg

335: if l_validate then
336: if l_dur_dys_less_warning then
337: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
338: hr_multi_message.add
339: (p_message_type => hr_multi_message.g_warning_msg
340: );
341: end if;
342: if l_dur_hrs_less_warning then
343: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');

Line 344: hr_multi_message.add

340: );
341: end if;
342: if l_dur_hrs_less_warning then
343: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');
344: hr_multi_message.add
345: (p_message_type => hr_multi_message.g_warning_msg
346: );
347: end if;
348: if l_exceeds_pto_entit_warning then

Line 345: (p_message_type => hr_multi_message.g_warning_msg

341: end if;
342: if l_dur_hrs_less_warning then
343: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');
344: hr_multi_message.add
345: (p_message_type => hr_multi_message.g_warning_msg
346: );
347: end if;
348: if l_exceeds_pto_entit_warning then
349: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');

Line 350: hr_multi_message.add

346: );
347: end if;
348: if l_exceeds_pto_entit_warning then
349: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
350: hr_multi_message.add
351: (p_message_type => hr_multi_message.g_warning_msg
352: );
353: end if;
354: if l_exceeds_run_total_warning then

Line 351: (p_message_type => hr_multi_message.g_warning_msg

347: end if;
348: if l_exceeds_pto_entit_warning then
349: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
350: hr_multi_message.add
351: (p_message_type => hr_multi_message.g_warning_msg
352: );
353: end if;
354: if l_exceeds_run_total_warning then
355: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');

Line 356: hr_multi_message.add

352: );
353: end if;
354: if l_exceeds_run_total_warning then
355: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
356: hr_multi_message.add
357: (p_message_type => hr_multi_message.g_warning_msg
358: );
359: end if;
360: if l_abs_overlap_warning then

Line 357: (p_message_type => hr_multi_message.g_warning_msg

353: end if;
354: if l_exceeds_run_total_warning then
355: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
356: hr_multi_message.add
357: (p_message_type => hr_multi_message.g_warning_msg
358: );
359: end if;
360: if l_abs_overlap_warning then
361: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');

Line 362: hr_multi_message.add

358: );
359: end if;
360: if l_abs_overlap_warning then
361: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
362: hr_multi_message.add
363: (p_message_type => hr_multi_message.g_warning_msg
364: );
365: end if;
366: if l_abs_day_after_warning then

Line 363: (p_message_type => hr_multi_message.g_warning_msg

359: end if;
360: if l_abs_overlap_warning then
361: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
362: hr_multi_message.add
363: (p_message_type => hr_multi_message.g_warning_msg
364: );
365: end if;
366: if l_abs_day_after_warning then
367: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');

Line 368: hr_multi_message.add

364: );
365: end if;
366: if l_abs_day_after_warning then
367: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
368: hr_multi_message.add
369: (p_message_type => hr_multi_message.g_warning_msg
370: );
371: end if;
372: end if;

Line 369: (p_message_type => hr_multi_message.g_warning_msg

365: end if;
366: if l_abs_day_after_warning then
367: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
368: hr_multi_message.add
369: (p_message_type => hr_multi_message.g_warning_msg
370: );
371: end if;
372: end if;
373: --

Line 378: -- hr_multi_message.add

374: -- We don't raise overwritten warning from SSHR
375: --
376: --if l_dur_overwritten_warning then
377: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
378: -- hr_multi_message.add
379: -- (p_message_type => hr_multi_message.g_warning_msg
380: -- );
381: --end if; --
382: -- Convert API non-warning boolean parameter values

Line 379: -- (p_message_type => hr_multi_message.g_warning_msg

375: --
376: --if l_dur_overwritten_warning then
377: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
378: -- hr_multi_message.add
379: -- (p_message_type => hr_multi_message.g_warning_msg
380: -- );
381: --end if; --
382: -- Convert API non-warning boolean parameter values
383: --

Line 389: p_return_status := hr_multi_message.get_return_status_disable;

385: -- Derive the API return status value based on whether
386: -- messages of any type exist in the Multiple Message List.
387: -- Also disable Multiple Message Detection.
388: --
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then

Line 393: when hr_multi_message.error_message_exist then

389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
394: --
395: -- Catch the Multiple Message List exception which
396: -- indicates API processing has been aborted because
397: -- at least one message exists in the list.

Line 408: p_return_status := hr_multi_message.get_return_status_disable;

404: p_absence_hours := l_absence_hours;
405: p_absence_attendance_id := null;
406: p_object_version_number := null;
407: p_occurrence := null;
408: p_return_status := hr_multi_message.get_return_status_disable;
409: hr_utility.set_location(' Leaving:' || l_proc, 30);
410: when others then
411: --
412: -- When Multiple Message Detection is enabled catch

Line 419: if hr_multi_message.unexpected_error_add(l_proc) then

415: -- Multiple Message List. Otherwise re-raise the
416: -- error.
417: --
418: rollback to create_person_absence_swi;
419: if hr_multi_message.unexpected_error_add(l_proc) then
420: hr_utility.set_location(' Leaving:' || l_proc,40);
421: raise;
422: end if;
423: --

Line 431: p_return_status := hr_multi_message.get_return_status_disable;

427: p_absence_hours := l_absence_hours;
428: p_absence_attendance_id := null;
429: p_object_version_number := null;
430: p_occurrence := null;
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc,50);
433: end create_person_absence;
434: -- ----------------------------------------------------------------------------
435: -- |-------------------------< update_person_absence >------------------------|

Line 565: hr_multi_message.enable_message_list;

561: savepoint update_person_absence_swi;
562: --
563: -- Initialise Multiple Message Detection
564: --
565: hr_multi_message.enable_message_list;
566: --
567:
568: -- Bug 6347488 fix starts
569:

Line 719: hr_multi_message.add

715: --
716: if l_validate then
717: if l_dur_dys_less_warning then
718: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
719: hr_multi_message.add
720: (p_message_type => hr_multi_message.g_warning_msg
721: );
722: end if;
723: if l_dur_hrs_less_warning then

Line 720: (p_message_type => hr_multi_message.g_warning_msg

716: if l_validate then
717: if l_dur_dys_less_warning then
718: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
719: hr_multi_message.add
720: (p_message_type => hr_multi_message.g_warning_msg
721: );
722: end if;
723: if l_dur_hrs_less_warning then
724: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');

Line 725: hr_multi_message.add

721: );
722: end if;
723: if l_dur_hrs_less_warning then
724: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');
725: hr_multi_message.add
726: (p_message_type => hr_multi_message.g_warning_msg
727: );
728: end if;
729: if l_exceeds_pto_entit_warning then

Line 726: (p_message_type => hr_multi_message.g_warning_msg

722: end if;
723: if l_dur_hrs_less_warning then
724: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');
725: hr_multi_message.add
726: (p_message_type => hr_multi_message.g_warning_msg
727: );
728: end if;
729: if l_exceeds_pto_entit_warning then
730: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');

Line 731: hr_multi_message.add

727: );
728: end if;
729: if l_exceeds_pto_entit_warning then
730: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
731: hr_multi_message.add
732: (p_message_type => hr_multi_message.g_warning_msg
733: );
734: end if;
735: if l_exceeds_run_total_warning then

Line 732: (p_message_type => hr_multi_message.g_warning_msg

728: end if;
729: if l_exceeds_pto_entit_warning then
730: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
731: hr_multi_message.add
732: (p_message_type => hr_multi_message.g_warning_msg
733: );
734: end if;
735: if l_exceeds_run_total_warning then
736: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');

Line 737: hr_multi_message.add

733: );
734: end if;
735: if l_exceeds_run_total_warning then
736: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
737: hr_multi_message.add
738: (p_message_type => hr_multi_message.g_warning_msg
739: );
740: end if;
741: if l_abs_overlap_warning then

Line 738: (p_message_type => hr_multi_message.g_warning_msg

734: end if;
735: if l_exceeds_run_total_warning then
736: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
737: hr_multi_message.add
738: (p_message_type => hr_multi_message.g_warning_msg
739: );
740: end if;
741: if l_abs_overlap_warning then
742: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');

Line 743: hr_multi_message.add

739: );
740: end if;
741: if l_abs_overlap_warning then
742: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
743: hr_multi_message.add
744: (p_message_type => hr_multi_message.g_warning_msg
745: );
746: end if;
747: if l_abs_day_after_warning then

Line 744: (p_message_type => hr_multi_message.g_warning_msg

740: end if;
741: if l_abs_overlap_warning then
742: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
743: hr_multi_message.add
744: (p_message_type => hr_multi_message.g_warning_msg
745: );
746: end if;
747: if l_abs_day_after_warning then
748: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');

Line 749: hr_multi_message.add

745: );
746: end if;
747: if l_abs_day_after_warning then
748: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
749: hr_multi_message.add
750: (p_message_type => hr_multi_message.g_warning_msg
751: );
752: end if;
753: --

Line 750: (p_message_type => hr_multi_message.g_warning_msg

746: end if;
747: if l_abs_day_after_warning then
748: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
749: hr_multi_message.add
750: (p_message_type => hr_multi_message.g_warning_msg
751: );
752: end if;
753: --
754: -- We don't raise overwritten warning from SSHR

Line 758: -- hr_multi_message.add

754: -- We don't raise overwritten warning from SSHR
755: --
756: --if l_dur_overwritten_warning then
757: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
758: -- hr_multi_message.add
759: -- (p_message_type => hr_multi_message.g_warning_msg
760: -- );
761: --end if; --
762: if l_del_element_entry_warning then

Line 759: -- (p_message_type => hr_multi_message.g_warning_msg

755: --
756: --if l_dur_overwritten_warning then
757: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
758: -- hr_multi_message.add
759: -- (p_message_type => hr_multi_message.g_warning_msg
760: -- );
761: --end if; --
762: if l_del_element_entry_warning then
763: fnd_message.set_name('EDIT HERE: APP_CODE', 'EDIT_HERE: MESSAGE_NAME ');

Line 764: hr_multi_message.add

760: -- );
761: --end if; --
762: if l_del_element_entry_warning then
763: fnd_message.set_name('EDIT HERE: APP_CODE', 'EDIT_HERE: MESSAGE_NAME ');
764: hr_multi_message.add
765: (p_message_type => hr_multi_message.g_warning_msg
766: );
767: end if;
768: end if; --

Line 765: (p_message_type => hr_multi_message.g_warning_msg

761: --end if; --
762: if l_del_element_entry_warning then
763: fnd_message.set_name('EDIT HERE: APP_CODE', 'EDIT_HERE: MESSAGE_NAME ');
764: hr_multi_message.add
765: (p_message_type => hr_multi_message.g_warning_msg
766: );
767: end if;
768: end if; --
769: -- Convert API non-warning boolean parameter values

Line 776: p_return_status := hr_multi_message.get_return_status_disable;

772: -- Derive the API return status value based on whether
773: -- messages of any type exist in the Multiple Message List.
774: -- Also disable Multiple Message Detection.
775: --
776: p_return_status := hr_multi_message.get_return_status_disable;
777: hr_utility.set_location(' Leaving:' || l_proc,20);
778: --
779: exception
780: when hr_multi_message.error_message_exist then

Line 780: when hr_multi_message.error_message_exist then

776: p_return_status := hr_multi_message.get_return_status_disable;
777: hr_utility.set_location(' Leaving:' || l_proc,20);
778: --
779: exception
780: when hr_multi_message.error_message_exist then
781: --
782: -- Catch the Multiple Message List exception which
783: -- indicates API processing has been aborted because
784: -- at least one message exists in the list.

Line 793: p_return_status := hr_multi_message.get_return_status_disable;

789: --
790: p_absence_days := l_absence_days;
791: p_absence_hours := l_absence_hours;
792: p_object_version_number := l_object_version_number;
793: p_return_status := hr_multi_message.get_return_status_disable;
794: hr_utility.set_location(' Leaving:' || l_proc, 30);
795: when others then
796: --
797: -- When Multiple Message Detection is enabled catch

Line 804: if hr_multi_message.unexpected_error_add(l_proc) then

800: -- Multiple Message List. Otherwise re-raise the
801: -- error.
802: --
803: rollback to update_person_absence_swi;
804: if hr_multi_message.unexpected_error_add(l_proc) then
805: hr_utility.set_location(' Leaving:' || l_proc,40);
806: raise;
807: end if;
808: --

Line 814: p_return_status := hr_multi_message.get_return_status_disable;

810: --
811: p_absence_days := l_absence_days;
812: p_absence_hours := l_absence_hours;
813: p_object_version_number := l_object_version_number;
814: p_return_status := hr_multi_message.get_return_status_disable;
815: hr_utility.set_location(' Leaving:' || l_proc,50);
816: end update_person_absence;
817: -- ----------------------------------------------------------------------------
818: -- |-------------------------< delete_person_absence >------------------------|

Line 845: hr_multi_message.enable_message_list;

841: savepoint delete_person_absence_swi;
842: --
843: -- Initialise Multiple Message Detection
844: --
845: hr_multi_message.enable_message_list;
846: --
847: -- Remember IN OUT parameter IN values
848: --
849: --

Line 878: p_return_status := hr_multi_message.get_return_status_disable;

874: -- Derive the API return status value based on whether
875: -- messages of any type exist in the Multiple Message List.
876: -- Also disable Multiple Message Detection.
877: --
878: p_return_status := hr_multi_message.get_return_status_disable;
879: hr_utility.set_location(' Leaving:' || l_proc,20);
880: --
881: exception
882: when hr_multi_message.error_message_exist then

Line 882: when hr_multi_message.error_message_exist then

878: p_return_status := hr_multi_message.get_return_status_disable;
879: hr_utility.set_location(' Leaving:' || l_proc,20);
880: --
881: exception
882: when hr_multi_message.error_message_exist then
883: --
884: -- Catch the Multiple Message List exception which
885: -- indicates API processing has been aborted because
886: -- at least one message exists in the list.

Line 892: p_return_status := hr_multi_message.get_return_status_disable;

888: rollback to delete_person_absence_swi;
889: --
890: -- Reset IN OUT parameters and set OUT parameters
891: --
892: p_return_status := hr_multi_message.get_return_status_disable;
893: hr_utility.set_location(' Leaving:' || l_proc, 30);
894: when others then
895: --
896: -- When Multiple Message Detection is enabled catch

Line 903: if hr_multi_message.unexpected_error_add(l_proc) then

899: -- Multiple Message List. Otherwise re-raise the
900: -- error.
901: --
902: rollback to delete_person_absence_swi;
903: if hr_multi_message.unexpected_error_add(l_proc) then
904: hr_utility.set_location(' Leaving:' || l_proc,40);
905: raise;
906: end if;
907: --

Line 910: p_return_status := hr_multi_message.get_return_status_disable;

906: end if;
907: --
908: -- Reset IN OUT and set OUT parameters
909: --
910: p_return_status := hr_multi_message.get_return_status_disable;
911: hr_utility.set_location(' Leaving:' || l_proc,50);
912: end delete_person_absence;
913:
914:

Line 1170: hr_multi_message.enable_message_list;

1166: savepoint attachments_person_absence_swi;
1167: --
1168: -- Initialise Multiple Message Detection
1169: --
1170: hr_multi_message.enable_message_list;
1171:
1172: for attached_documents_rec in csr_get_attached_doc loop
1173: OPEN C (attached_documents_rec.attached_document_id);
1174: FETCH C INTO l_rowid;

Line 1188: p_return_status := hr_multi_message.get_return_status_disable;

1184: ,p_rowid=>l_rowid);
1185:
1186: end loop;
1187:
1188: p_return_status := hr_multi_message.get_return_status_disable;
1189:
1190: hr_utility.set_location(' Leaving:' || l_proc,20);
1191: --
1192: exception

Line 1202: if hr_multi_message.unexpected_error_add(l_proc) then

1198: -- Multiple Message List. Otherwise re-raise the
1199: -- error.
1200: --
1201: rollback to attachments_person_absence_swi;
1202: if hr_multi_message.unexpected_error_add(l_proc) then
1203: hr_utility.set_location(' Leaving:' || l_proc,40);
1204: raise;
1205: end if;
1206: --

Line 1208: p_return_status := hr_multi_message.get_return_status_disable;

1204: raise;
1205: end if;
1206: --
1207: -- Reset IN OUT and set OUT parameters
1208: p_return_status := hr_multi_message.get_return_status_disable;
1209:
1210: hr_utility.set_location(' Leaving:' || l_proc,50);
1211: end merge_attachments;
1212: