DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_SWI dependencies on HR_MULTI_MESSAGE

Line 354: hr_multi_message.enable_message_list;

350: savepoint create_person_absence_swi;
351: --
352: -- Initialise Multiple Message Detection
353: --
354: hr_multi_message.enable_message_list;
355: --
356: -- Remember IN OUT parameter IN values
357: --
358: -- Bug 6347488 fix starts

Line 524: hr_multi_message.add

520: --
521: if l_validate then
522: if l_dur_dys_less_warning then
523: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
524: hr_multi_message.add
525: (p_message_type => hr_multi_message.g_warning_msg
526: );
527: end if;
528: if l_dur_hrs_less_warning then

Line 525: (p_message_type => hr_multi_message.g_warning_msg

521: if l_validate then
522: if l_dur_dys_less_warning then
523: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
524: hr_multi_message.add
525: (p_message_type => hr_multi_message.g_warning_msg
526: );
527: end if;
528: if l_dur_hrs_less_warning then
529: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');

Line 530: hr_multi_message.add

526: );
527: end if;
528: if l_dur_hrs_less_warning then
529: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');
530: hr_multi_message.add
531: (p_message_type => hr_multi_message.g_warning_msg
532: );
533: end if;
534: if l_exceeds_pto_entit_warning then

Line 531: (p_message_type => hr_multi_message.g_warning_msg

527: end if;
528: if l_dur_hrs_less_warning then
529: hr_utility.set_message(800,'HR_ABS_HOUR_LESS_DURATION');
530: hr_multi_message.add
531: (p_message_type => hr_multi_message.g_warning_msg
532: );
533: end if;
534: if l_exceeds_pto_entit_warning then
535: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');

Line 536: hr_multi_message.add

532: );
533: end if;
534: if l_exceeds_pto_entit_warning then
535: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
536: hr_multi_message.add
537: (p_message_type => hr_multi_message.g_warning_msg
538: );
539: end if;
540: if l_exceeds_run_total_warning then

Line 537: (p_message_type => hr_multi_message.g_warning_msg

533: end if;
534: if l_exceeds_pto_entit_warning then
535: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
536: hr_multi_message.add
537: (p_message_type => hr_multi_message.g_warning_msg
538: );
539: end if;
540: if l_exceeds_run_total_warning then
541: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');

Line 542: hr_multi_message.add

538: );
539: end if;
540: if l_exceeds_run_total_warning then
541: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
542: hr_multi_message.add
543: (p_message_type => hr_multi_message.g_warning_msg
544: );
545: end if;
546: if l_abs_overlap_warning then

Line 543: (p_message_type => hr_multi_message.g_warning_msg

539: end if;
540: if l_exceeds_run_total_warning then
541: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
542: hr_multi_message.add
543: (p_message_type => hr_multi_message.g_warning_msg
544: );
545: end if;
546: if l_abs_overlap_warning then
547: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');

Line 548: hr_multi_message.add

544: );
545: end if;
546: if l_abs_overlap_warning then
547: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
548: hr_multi_message.add
549: (p_message_type => hr_multi_message.g_warning_msg
550: );
551: end if;
552: if l_abs_day_after_warning then

Line 549: (p_message_type => hr_multi_message.g_warning_msg

545: end if;
546: if l_abs_overlap_warning then
547: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
548: hr_multi_message.add
549: (p_message_type => hr_multi_message.g_warning_msg
550: );
551: end if;
552: if l_abs_day_after_warning then
553: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');

Line 554: hr_multi_message.add

550: );
551: end if;
552: if l_abs_day_after_warning then
553: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
554: hr_multi_message.add
555: (p_message_type => hr_multi_message.g_warning_msg
556: );
557: end if;
558:

Line 555: (p_message_type => hr_multi_message.g_warning_msg

551: end if;
552: if l_abs_day_after_warning then
553: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
554: hr_multi_message.add
555: (p_message_type => hr_multi_message.g_warning_msg
556: );
557: end if;
558:
559: if (l_dur_dys_less_warning OR

Line 574: hr_multi_message.add(p_message_type => hr_multi_message.g_warning_msg);

570: l_abs_overlap_warning := chk_overlap(p_person_id,p_business_group_id,nvl(p_date_start,p_date_projected_start),nvl(p_date_end,p_date_projected_end),nvl(p_time_start,p_time_projected_start),nvl(p_time_end,p_time_projected_end));
571:
572: if l_abs_overlap_warning then
573: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
574: hr_multi_message.add(p_message_type => hr_multi_message.g_warning_msg);
575: end if;
576: end if;
577:
578: end if;

Line 584: -- hr_multi_message.add

580: -- We don't raise overwritten warning from SSHR
581: --
582: --if l_dur_overwritten_warning then
583: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
584: -- hr_multi_message.add
585: -- (p_message_type => hr_multi_message.g_warning_msg
586: -- );
587: --end if; --
588: -- Convert API non-warning boolean parameter values

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

581: --
582: --if l_dur_overwritten_warning then
583: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
584: -- hr_multi_message.add
585: -- (p_message_type => hr_multi_message.g_warning_msg
586: -- );
587: --end if; --
588: -- Convert API non-warning boolean parameter values
589: --

Line 595: p_return_status := hr_multi_message.get_return_status_disable;

591: -- Derive the API return status value based on whether
592: -- messages of any type exist in the Multiple Message List.
593: -- Also disable Multiple Message Detection.
594: --
595: p_return_status := hr_multi_message.get_return_status_disable;
596: hr_utility.set_location(' Leaving:' || l_proc,20);
597: --
598: exception
599: when hr_multi_message.error_message_exist then

Line 599: when hr_multi_message.error_message_exist then

595: p_return_status := hr_multi_message.get_return_status_disable;
596: hr_utility.set_location(' Leaving:' || l_proc,20);
597: --
598: exception
599: when hr_multi_message.error_message_exist then
600: --
601: -- Catch the Multiple Message List exception which
602: -- indicates API processing has been aborted because
603: -- at least one message exists in the list.

Line 614: p_return_status := hr_multi_message.get_return_status_disable;

610: p_absence_hours := l_absence_hours;
611: p_absence_attendance_id := null;
612: p_object_version_number := null;
613: p_occurrence := null;
614: p_return_status := hr_multi_message.get_return_status_disable;
615: hr_utility.set_location(' Leaving:' || l_proc, 30);
616: when others then
617: --
618: -- When Multiple Message Detection is enabled catch

Line 625: if hr_multi_message.unexpected_error_add(l_proc) then

621: -- Multiple Message List. Otherwise re-raise the
622: -- error.
623: --
624: rollback to create_person_absence_swi;
625: if hr_multi_message.unexpected_error_add(l_proc) then
626: hr_utility.set_location(' Leaving:' || l_proc,40);
627: raise;
628: end if;
629: l_sqlerrm := sqlerrm;

Line 647: p_return_status := hr_multi_message.get_return_status_disable;

643: p_absence_hours := l_absence_hours;
644: p_absence_attendance_id := null;
645: p_object_version_number := null;
646: p_occurrence := null;
647: p_return_status := hr_multi_message.get_return_status_disable;
648: hr_utility.set_location(' Leaving:' || l_proc,50);
649: end create_person_absence;
650: -- ----------------------------------------------------------------------------
651: -- |-------------------------< update_person_absence >------------------------|

Line 796: hr_multi_message.enable_message_list;

792: savepoint update_person_absence_swi;
793: --
794: -- Initialise Multiple Message Detection
795: --
796: hr_multi_message.enable_message_list;
797: --
798:
799: -- Bug 6347488,8671547 fix starts
800:

Line 956: hr_multi_message.add

952: --
953: if l_validate then
954: if l_dur_dys_less_warning then
955: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
956: hr_multi_message.add
957: (p_message_type => hr_multi_message.g_warning_msg
958: );
959: end if;
960: if l_dur_hrs_less_warning then

Line 957: (p_message_type => hr_multi_message.g_warning_msg

953: if l_validate then
954: if l_dur_dys_less_warning then
955: hr_utility.set_message(800, 'HR_EMP_ABS_SHORT_DURATION');
956: hr_multi_message.add
957: (p_message_type => hr_multi_message.g_warning_msg
958: );
959: end if;
960: if l_dur_hrs_less_warning then
961: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');

Line 962: hr_multi_message.add

958: );
959: end if;
960: if l_dur_hrs_less_warning then
961: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');
962: hr_multi_message.add
963: (p_message_type => hr_multi_message.g_warning_msg
964: );
965: end if;
966: if l_exceeds_pto_entit_warning then

Line 963: (p_message_type => hr_multi_message.g_warning_msg

959: end if;
960: if l_dur_hrs_less_warning then
961: hr_utility.set_message(800, 'HR_ABS_HOUR_LESS_DURATION');
962: hr_multi_message.add
963: (p_message_type => hr_multi_message.g_warning_msg
964: );
965: end if;
966: if l_exceeds_pto_entit_warning then
967: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');

Line 968: hr_multi_message.add

964: );
965: end if;
966: if l_exceeds_pto_entit_warning then
967: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
968: hr_multi_message.add
969: (p_message_type => hr_multi_message.g_warning_msg
970: );
971: end if;
972: if l_exceeds_run_total_warning then

Line 969: (p_message_type => hr_multi_message.g_warning_msg

965: end if;
966: if l_exceeds_pto_entit_warning then
967: hr_utility.set_message(800, 'HR_LOA_EMP_NOT_ENTITLED');
968: hr_multi_message.add
969: (p_message_type => hr_multi_message.g_warning_msg
970: );
971: end if;
972: if l_exceeds_run_total_warning then
973: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');

Line 974: hr_multi_message.add

970: );
971: end if;
972: if l_exceeds_run_total_warning then
973: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
974: hr_multi_message.add
975: (p_message_type => hr_multi_message.g_warning_msg
976: );
977: end if;
978: if l_abs_overlap_warning then

Line 975: (p_message_type => hr_multi_message.g_warning_msg

971: end if;
972: if l_exceeds_run_total_warning then
973: hr_utility.set_message(800, 'HR_LOA_DET_RUNNING_ZERO');
974: hr_multi_message.add
975: (p_message_type => hr_multi_message.g_warning_msg
976: );
977: end if;
978: if l_abs_overlap_warning then
979: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');

Line 980: hr_multi_message.add

976: );
977: end if;
978: if l_abs_overlap_warning then
979: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
980: hr_multi_message.add
981: (p_message_type => hr_multi_message.g_warning_msg
982: );
983: end if;
984: if l_abs_day_after_warning then

Line 981: (p_message_type => hr_multi_message.g_warning_msg

977: end if;
978: if l_abs_overlap_warning then
979: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
980: hr_multi_message.add
981: (p_message_type => hr_multi_message.g_warning_msg
982: );
983: end if;
984: if l_abs_day_after_warning then
985: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');

Line 986: hr_multi_message.add

982: );
983: end if;
984: if l_abs_day_after_warning then
985: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
986: hr_multi_message.add
987: (p_message_type => hr_multi_message.g_warning_msg
988: );
989: end if;
990: --

Line 987: (p_message_type => hr_multi_message.g_warning_msg

983: end if;
984: if l_abs_day_after_warning then
985: hr_utility.set_message(800, 'HR_LOA_DET_ABS_DAY_AFTER');
986: hr_multi_message.add
987: (p_message_type => hr_multi_message.g_warning_msg
988: );
989: end if;
990: --
991: -- We don't raise overwritten warning from SSHR

Line 995: -- hr_multi_message.add

991: -- We don't raise overwritten warning from SSHR
992: --
993: --if l_dur_overwritten_warning then
994: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
995: -- hr_multi_message.add
996: -- (p_message_type => hr_multi_message.g_warning_msg
997: -- );
998: --end if; --
999: if l_del_element_entry_warning then

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

992: --
993: --if l_dur_overwritten_warning then
994: -- hr_utility.set_message(800, 'EDIT_HERE: MESSAGE_NAME ');
995: -- hr_multi_message.add
996: -- (p_message_type => hr_multi_message.g_warning_msg
997: -- );
998: --end if; --
999: if l_del_element_entry_warning then
1000: fnd_message.set_name('EDIT HERE: APP_CODE', 'EDIT_HERE: MESSAGE_NAME ');

Line 1001: hr_multi_message.add

997: -- );
998: --end if; --
999: if l_del_element_entry_warning then
1000: fnd_message.set_name('EDIT HERE: APP_CODE', 'EDIT_HERE: MESSAGE_NAME ');
1001: hr_multi_message.add
1002: (p_message_type => hr_multi_message.g_warning_msg
1003: );
1004: end if;
1005: if (l_dur_dys_less_warning OR

Line 1002: (p_message_type => hr_multi_message.g_warning_msg

998: --end if; --
999: if l_del_element_entry_warning then
1000: fnd_message.set_name('EDIT HERE: APP_CODE', 'EDIT_HERE: MESSAGE_NAME ');
1001: hr_multi_message.add
1002: (p_message_type => hr_multi_message.g_warning_msg
1003: );
1004: end if;
1005: if (l_dur_dys_less_warning OR
1006: l_dur_hrs_less_warning OR

Line 1033: hr_multi_message.add(p_message_type => hr_multi_message.g_warning_msg);

1029:
1030:
1031: if l_abs_overlap_warning then
1032: hr_utility.set_message(800, 'HR_LOA_ABSENCE_OVERLAP');
1033: hr_multi_message.add(p_message_type => hr_multi_message.g_warning_msg);
1034: end if;
1035: end if;
1036:
1037: end if; --

Line 1045: p_return_status := hr_multi_message.get_return_status_disable;

1041: -- Derive the API return status value based on whether
1042: -- messages of any type exist in the Multiple Message List.
1043: -- Also disable Multiple Message Detection.
1044: --
1045: p_return_status := hr_multi_message.get_return_status_disable;
1046: hr_utility.set_location(' Leaving:' || l_proc,20);
1047: --
1048: exception
1049: when hr_multi_message.error_message_exist then

Line 1049: when hr_multi_message.error_message_exist then

1045: p_return_status := hr_multi_message.get_return_status_disable;
1046: hr_utility.set_location(' Leaving:' || l_proc,20);
1047: --
1048: exception
1049: when hr_multi_message.error_message_exist then
1050: --
1051: -- Catch the Multiple Message List exception which
1052: -- indicates API processing has been aborted because
1053: -- at least one message exists in the list.

Line 1062: p_return_status := hr_multi_message.get_return_status_disable;

1058: --
1059: p_absence_days := l_absence_days;
1060: p_absence_hours := l_absence_hours;
1061: p_object_version_number := l_object_version_number;
1062: p_return_status := hr_multi_message.get_return_status_disable;
1063: hr_utility.set_location(' Leaving:' || l_proc, 30);
1064: when others then
1065: --
1066: -- When Multiple Message Detection is enabled catch

Line 1073: if hr_multi_message.unexpected_error_add(l_proc) then

1069: -- Multiple Message List. Otherwise re-raise the
1070: -- error.
1071: --
1072: rollback to update_person_absence_swi;
1073: if hr_multi_message.unexpected_error_add(l_proc) then
1074: hr_utility.set_location(' Leaving:' || l_proc,40);
1075: raise;
1076: end if;
1077: l_sqlerrm := sqlerrm;

Line 1094: p_return_status := hr_multi_message.get_return_status_disable;

1090: --
1091: p_absence_days := l_absence_days;
1092: p_absence_hours := l_absence_hours;
1093: p_object_version_number := l_object_version_number;
1094: p_return_status := hr_multi_message.get_return_status_disable;
1095: hr_utility.set_location(' Leaving:' || l_proc,50);
1096: end update_person_absence;
1097: -- ----------------------------------------------------------------------------
1098: -- |-------------------------< delete_person_absence >------------------------|

Line 1125: hr_multi_message.enable_message_list;

1121: savepoint delete_person_absence_swi;
1122: --
1123: -- Initialise Multiple Message Detection
1124: --
1125: hr_multi_message.enable_message_list;
1126: --
1127: -- Remember IN OUT parameter IN values
1128: --
1129: --

Line 1158: p_return_status := hr_multi_message.get_return_status_disable;

1154: -- Derive the API return status value based on whether
1155: -- messages of any type exist in the Multiple Message List.
1156: -- Also disable Multiple Message Detection.
1157: --
1158: p_return_status := hr_multi_message.get_return_status_disable;
1159: hr_utility.set_location(' Leaving:' || l_proc,20);
1160: --
1161: exception
1162: when hr_multi_message.error_message_exist then

Line 1162: when hr_multi_message.error_message_exist then

1158: p_return_status := hr_multi_message.get_return_status_disable;
1159: hr_utility.set_location(' Leaving:' || l_proc,20);
1160: --
1161: exception
1162: when hr_multi_message.error_message_exist then
1163: --
1164: -- Catch the Multiple Message List exception which
1165: -- indicates API processing has been aborted because
1166: -- at least one message exists in the list.

Line 1172: p_return_status := hr_multi_message.get_return_status_disable;

1168: rollback to delete_person_absence_swi;
1169: --
1170: -- Reset IN OUT parameters and set OUT parameters
1171: --
1172: p_return_status := hr_multi_message.get_return_status_disable;
1173: hr_utility.set_location(' Leaving:' || l_proc, 30);
1174: when others then
1175: --
1176: -- When Multiple Message Detection is enabled catch

Line 1183: if hr_multi_message.unexpected_error_add(l_proc) then

1179: -- Multiple Message List. Otherwise re-raise the
1180: -- error.
1181: --
1182: rollback to delete_person_absence_swi;
1183: if hr_multi_message.unexpected_error_add(l_proc) then
1184: hr_utility.set_location(' Leaving:' || l_proc,40);
1185: raise;
1186: end if;
1187: --

Line 1190: p_return_status := hr_multi_message.get_return_status_disable;

1186: end if;
1187: --
1188: -- Reset IN OUT and set OUT parameters
1189: --
1190: p_return_status := hr_multi_message.get_return_status_disable;
1191: hr_utility.set_location(' Leaving:' || l_proc,50);
1192: end delete_person_absence;
1193:
1194:

Line 1450: hr_multi_message.enable_message_list;

1446: savepoint attachments_person_absence_swi;
1447: --
1448: -- Initialise Multiple Message Detection
1449: --
1450: hr_multi_message.enable_message_list;
1451:
1452: for attached_documents_rec in csr_get_attached_doc loop
1453: OPEN C (attached_documents_rec.attached_document_id);
1454: FETCH C INTO l_rowid;

Line 1468: p_return_status := hr_multi_message.get_return_status_disable;

1464: ,p_rowid=>l_rowid);
1465:
1466: end loop;
1467:
1468: p_return_status := hr_multi_message.get_return_status_disable;
1469:
1470: hr_utility.set_location(' Leaving:' || l_proc,20);
1471: --
1472: exception

Line 1482: if hr_multi_message.unexpected_error_add(l_proc) then

1478: -- Multiple Message List. Otherwise re-raise the
1479: -- error.
1480: --
1481: rollback to attachments_person_absence_swi;
1482: if hr_multi_message.unexpected_error_add(l_proc) then
1483: hr_utility.set_location(' Leaving:' || l_proc,40);
1484: raise;
1485: end if;
1486: --

Line 1488: p_return_status := hr_multi_message.get_return_status_disable;

1484: raise;
1485: end if;
1486: --
1487: -- Reset IN OUT and set OUT parameters
1488: p_return_status := hr_multi_message.get_return_status_disable;
1489:
1490: hr_utility.set_location(' Leaving:' || l_proc,50);
1491: end merge_attachments;
1492:

Line 1846: hr_multi_message.enable_message_list;

1842: ) is
1843:
1844: begin
1845:
1846: hr_multi_message.enable_message_list;
1847: hr_person_absence_api.otl_hr_check (
1848: p_person_id => p_person_id,
1849: p_date_start => p_date_start ,
1850: p_date_end => p_date_end ,