[Home] [Help]
27: l_proc varchar2(72) := g_package||'set_security_group_id';
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Ensure that all the mandatory parameter are not null
34: --
35: hr_api.mandatory_arg_error
37: ,p_argument => 'search_criteria_id'
38: ,p_argument_value => p_search_criteria_id
39: );
40: --
41: hr_utility.set_location(' Leaving:'|| l_proc, 20);
42: --
43: end set_security_group_id;
44: --
45: -- ---------------------------------------------------------------------------
57: l_proc varchar2(72) := g_package||'return_legislation_code';
58: --
59: Begin
60: --
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
67: ,p_argument => 'search_criteria_id'
68: ,p_argument_value => p_search_criteria_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 40);
72: return l_legislation_code;
73: end return_legislation_code;
74: --
75: -- ----------------------------------------------------------------------------
106: --
107: l_proc varchar2(72) := g_package || 'chk_ddf';
108: --
109: begin
110: hr_utility.set_location('Entering:'||l_proc,10);
111: --
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
245: ,p_attribute30_value => p_rec.isc_information30
246: );
247: end if;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc,20);
250: end chk_ddf;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |------------------------------< chk_df >----------------------------------|
283: --
284: l_proc varchar2(72) := g_package || 'chk_df';
285: --
286: begin
287: hr_utility.set_location('Entering:'||l_proc,10);
288: --
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
422: ,p_attribute30_value => p_rec.attribute30
423: );
424: end if;
425: --
426: hr_utility.set_location(' Leaving:'||l_proc,20);
427: end chk_df;
428: --
429: -- ----------------------------------------------------------------------------
430: -- |-----------------------< chk_non_updateable_args >------------------------|
542: and trunc(p_effective_date) between ppf.effective_start_date
543: and ppf.effective_end_date;
544: --
545: begin
546: hr_utility.set_location('Entering:'||l_proc,10);
547: -- Check that Person_ID is not null.
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc
550: ,p_argument => 'PERSON_ID'
550: ,p_argument => 'PERSON_ID'
551: ,p_argument_value => p_person_id
552: );
553: -- Check that Person_ID(Object_id) exists in per_all_people_f
554: hr_utility.set_location(l_proc,20);
555: open csr_person_id;
556: fetch csr_person_id into l_person_id;
557: hr_utility.set_location(l_proc,30);
558: if csr_person_id%NOTFOUND then
553: -- Check that Person_ID(Object_id) exists in per_all_people_f
554: hr_utility.set_location(l_proc,20);
555: open csr_person_id;
556: fetch csr_person_id into l_person_id;
557: hr_utility.set_location(l_proc,30);
558: if csr_person_id%NOTFOUND then
559: close csr_person_id;
560: fnd_message.set_name('PER','IRC_412008_BAD_PARTY_PERSON_ID');
561: fnd_message.raise_error;
560: fnd_message.set_name('PER','IRC_412008_BAD_PARTY_PERSON_ID');
561: fnd_message.raise_error;
562: end if;
563: close csr_person_id;
564: hr_utility.set_location(' Leaving:'||l_proc,40);
565: exception
566: when app_exception.application_exception then
567: if hr_multi_message.exception_add
568: (p_associated_column1 =>
567: if hr_multi_message.exception_add
568: (p_associated_column1 =>
569: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
570: ) then
571: hr_utility.set_location(' Leaving:'||l_proc,50);
572: raise;
573: end if;
574: hr_utility.set_location(' Leaving:'||l_proc,60);
575: end chk_person_id;
570: ) then
571: hr_utility.set_location(' Leaving:'||l_proc,50);
572: raise;
573: end if;
574: hr_utility.set_location(' Leaving:'||l_proc,60);
575: end chk_person_id;
576: --
577: -- ----------------------------------------------------------------------------
578: -- |-----------------------------< chk_unique_work >--------------------------|
609: and isc.object_type = 'WPREF';
610: l_dummy number;
611: --
612: begin
613: hr_utility.set_location('Entering:'||l_proc,10);
614: open csr_work_choices;
615: fetch csr_work_choices into l_dummy;
616: hr_utility.set_location(l_proc,20);
617: if csr_work_choices%found then
612: begin
613: hr_utility.set_location('Entering:'||l_proc,10);
614: open csr_work_choices;
615: fetch csr_work_choices into l_dummy;
616: hr_utility.set_location(l_proc,20);
617: if csr_work_choices%found then
618: close csr_work_choices;
619: fnd_message.set_name('PER','IRC_412127_TOO_MANY_WORK_CH');
620: fnd_message.raise_error;
620: fnd_message.raise_error;
621: else
622: close csr_work_choices;
623: end if;
624: hr_utility.set_location(' Leaving:'||l_proc,40);
625: exception
626: when app_exception.application_exception then
627: if hr_multi_message.exception_add
628: (p_associated_column1 =>
627: if hr_multi_message.exception_add
628: (p_associated_column1 =>
629: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
630: ) then
631: hr_utility.set_location(' Leaving:'||l_proc,50);
632: raise;
633: end if;
634: hr_utility.set_location(' Leaving:'||l_proc,60);
635: end chk_unique_work;
630: ) then
631: hr_utility.set_location(' Leaving:'||l_proc,50);
632: raise;
633: end if;
634: hr_utility.set_location(' Leaving:'||l_proc,60);
635: end chk_unique_work;
636: --
637: -- ----------------------------------------------------------------------------
638: -- |-----------------------------< chk_search_name >--------------------------|
676: where isc.search_name = p_search_name
677: and isc.object_id = p_person_id ;
678: --
679: begin
680: hr_utility.set_location('Entering:'||l_proc,10);
681: if p_search_name is not null then
682: --
683: hr_utility.set_location(l_proc,20);
684: l_api_updating := irc_isc_shd.api_updating
679: begin
680: hr_utility.set_location('Entering:'||l_proc,10);
681: if p_search_name is not null then
682: --
683: hr_utility.set_location(l_proc,20);
684: l_api_updating := irc_isc_shd.api_updating
685: (p_search_criteria_id => p_search_criteria_id
686: ,p_object_version_number => p_object_version_number
687: );
684: l_api_updating := irc_isc_shd.api_updating
685: (p_search_criteria_id => p_search_criteria_id
686: ,p_object_version_number => p_object_version_number
687: );
688: hr_utility.set_location(l_proc,30);
689: if (l_api_updating and
690: p_search_name <>
691: NVL(irc_isc_shd.g_old_rec.search_name,hr_api.g_varchar2)
692: ) or (NOT l_api_updating) then
690: p_search_name <>
691: NVL(irc_isc_shd.g_old_rec.search_name,hr_api.g_varchar2)
692: ) or (NOT l_api_updating) then
693: -- Check that search_name is unique for a person_id
694: hr_utility.set_location(l_proc,40);
695: open csr_search_name;
696: fetch csr_search_name into l_search_name;
697: hr_utility.set_location(l_proc,50);
698: if csr_search_name%FOUND then
693: -- Check that search_name is unique for a person_id
694: hr_utility.set_location(l_proc,40);
695: open csr_search_name;
696: fetch csr_search_name into l_search_name;
697: hr_utility.set_location(l_proc,50);
698: if csr_search_name%FOUND then
699: close csr_search_name;
700: fnd_message.set_name('PER','IRC_412009_SEARCH_NAME_EXISTS');
701: fnd_message.raise_error;
702: end if;
703: close csr_search_name;
704: end if;
705: end if;
706: hr_utility.set_location(' Leaving:'||l_proc,60);
707: exception
708: when app_exception.application_exception then
709: if hr_multi_message.exception_add
710: (p_associated_column1 =>
709: if hr_multi_message.exception_add
710: (p_associated_column1 =>
711: 'IRC_SEARCH_CRITERIA.SEARCH_NAME'
712: ) then
713: hr_utility.set_location(' Leaving:'||l_proc,70);
714: raise;
715: end if;
716: hr_utility.set_location(' Leaving:'||l_proc,80);
717: end chk_search_name;
712: ) then
713: hr_utility.set_location(' Leaving:'||l_proc,70);
714: raise;
715: end if;
716: hr_utility.set_location(' Leaving:'||l_proc,80);
717: end chk_search_name;
718: --
719: -- ----------------------------------------------------------------------------
720: -- |-------------------------< chk_distance_to_location >----------------------|
755: l_proc varchar2(72) := g_package || 'chk_distance_to_location';
756: l_api_updating boolean;
757: --
758: begin
759: hr_utility.set_location('Entering:'||l_proc,10);
760: if p_distance_to_location is not null then
761: --
762: hr_utility.set_location(l_proc,20);
763: l_api_updating := irc_isc_shd.api_updating
758: begin
759: hr_utility.set_location('Entering:'||l_proc,10);
760: if p_distance_to_location is not null then
761: --
762: hr_utility.set_location(l_proc,20);
763: l_api_updating := irc_isc_shd.api_updating
764: (p_search_criteria_id => p_search_criteria_id
765: ,p_object_version_number => p_object_version_number
766: );
764: (p_search_criteria_id => p_search_criteria_id
765: ,p_object_version_number => p_object_version_number
766: );
767: --
768: hr_utility.set_location(l_proc,30);
769: if (l_api_updating and
770: p_distance_to_location <>
771: NVL(irc_isc_shd.g_old_rec.distance_to_location,hr_api.g_number))
772: or (NOT l_api_updating) then
770: p_distance_to_location <>
771: NVL(irc_isc_shd.g_old_rec.distance_to_location,hr_api.g_number))
772: or (NOT l_api_updating) then
773: -- Check that distance_to_location is a valid positive number.
774: hr_utility.set_location(l_proc,40);
775: if p_distance_to_location < 0 then
776: fnd_message.set_name('PER','IRC_412010_BAD_DISTANCE_TO_LOC');
777: hr_multi_message.add
778: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
778: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
779: );
780: else
781: -- Check that location is a valid.
782: hr_utility.set_location(l_proc,50);
783: if p_geocode_location is null then
784: fnd_message.set_name('PER','IRC_412011_BAD_LOCATION');
785: hr_multi_message.add
786: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOCODE_LOCATION'
789: end if;
790: end if;
791: else
792: -- the distance to location is null - check that the geocode location is too
793: hr_utility.set_location(l_proc,60);
794: if p_geocode_location is not null then
795: fnd_message.set_name('PER','IRC_412164_NO_DISTANCE');
796: hr_multi_message.add
797: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
797: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
798: );
799: end if;
800: end if;
801: hr_utility.set_location(' Leaving:'||l_proc,60);
802: end chk_distance_to_location;
803: --
804: -- ----------------------------------------------------------------------------
805: -- |-------------------------< chk_location_id >-----------------------------|
841: select 1 from hr_locations_all
842: where location_id=p_location_id;
843: --
844: begin
845: hr_utility.set_location('Entering:'||l_proc,10);
846: if p_location_id is not null then
847: --
848: hr_utility.set_location(l_proc,20);
849: l_api_updating := irc_isc_shd.api_updating
844: begin
845: hr_utility.set_location('Entering:'||l_proc,10);
846: if p_location_id is not null then
847: --
848: hr_utility.set_location(l_proc,20);
849: l_api_updating := irc_isc_shd.api_updating
850: (p_search_criteria_id => p_search_criteria_id
851: ,p_object_version_number => p_object_version_number
852: );
850: (p_search_criteria_id => p_search_criteria_id
851: ,p_object_version_number => p_object_version_number
852: );
853: --
854: hr_utility.set_location(l_proc,30);
855: if (l_api_updating and
856: p_location_id <>
857: NVL(irc_isc_shd.g_old_rec.location_id,hr_api.g_number))
858: or (NOT l_api_updating) then
856: p_location_id <>
857: NVL(irc_isc_shd.g_old_rec.location_id,hr_api.g_number))
858: or (NOT l_api_updating) then
859: -- Check that location_id is a valid
860: hr_utility.set_location(l_proc,40);
861: open chk_loc;
862: fetch chk_loc into l_dummy;
863: if chk_loc%notfound then
864: close chk_loc;
870: close chk_loc;
871: end if;
872: end if;
873: end if;
874: hr_utility.set_location(' Leaving:'||l_proc,60);
875: end chk_location_id;
876: --
877: -- ----------------------------------------------------------------------------
878: -- |-------------------------< chk_longitude_latitude >-----------------------|
911: --
912: l_proc varchar2(72) := g_package || 'chk_longitude_latitude';
913: --
914: begin
915: hr_utility.set_location('Entering:'||l_proc,10);
916: if (p_longitude is not null and p_latitude is null)
917: or (p_longitude is null and p_latitude is not null) then
918: --
919: hr_utility.set_location(l_proc,20);
915: hr_utility.set_location('Entering:'||l_proc,10);
916: if (p_longitude is not null and p_latitude is null)
917: or (p_longitude is null and p_latitude is not null) then
918: --
919: hr_utility.set_location(l_proc,20);
920: fnd_message.set_name('PER','IRC_412166_LONG_LAT');
921: hr_multi_message.add
922: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOMETRY'
923: );
921: hr_multi_message.add
922: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOMETRY'
923: );
924: end if;
925: hr_utility.set_location(' Leaving:'||l_proc,60);
926: end chk_longitude_latitude;
927: --
928: -- ----------------------------------------------------------------------------
929: -- |----------------------------< chk_use_for_matching >----------------------|
960: l_proc varchar2(72) := g_package || 'chk_use_for_matching';
961: l_api_updating boolean;
962: --
963: begin
964: hr_utility.set_location('Entering:'||l_proc,10);
965: if p_use_for_matching is not null then
966: --
967: hr_utility.set_location(l_proc,20);
968: l_api_updating := irc_isc_shd.api_updating
963: begin
964: hr_utility.set_location('Entering:'||l_proc,10);
965: if p_use_for_matching is not null then
966: --
967: hr_utility.set_location(l_proc,20);
968: l_api_updating := irc_isc_shd.api_updating
969: (p_search_criteria_id => p_search_criteria_id
970: ,p_object_version_number => p_object_version_number
971: );
969: (p_search_criteria_id => p_search_criteria_id
970: ,p_object_version_number => p_object_version_number
971: );
972: --
973: hr_utility.set_location(l_proc,30);
974: if (l_api_updating and
975: p_use_for_matching <>
976: NVL(irc_isc_shd.g_old_rec.use_for_matching,hr_api.g_varchar2)
977: ) or (NOT l_api_updating) then
975: p_use_for_matching <>
976: NVL(irc_isc_shd.g_old_rec.use_for_matching,hr_api.g_varchar2)
977: ) or (NOT l_api_updating) then
978: -- Check that use_for_matching is having a valid value of 'Y' or 'N'
979: hr_utility.set_location(l_proc,40);
980: if not p_use_for_matching in ('Y','N') then
981: fnd_message.set_name('PER','IRC_412012_BAD_USE_FOR_MATCHIN');
982: fnd_message.raise_error;
983: end if;
982: fnd_message.raise_error;
983: end if;
984: end if;
985: end if;
986: hr_utility.set_location(' Leaving:'||l_proc,50);
987: exception
988: when app_exception.application_exception then
989: if hr_multi_message.exception_add
990: (p_associated_column1 =>
989: if hr_multi_message.exception_add
990: (p_associated_column1 =>
991: 'IRC_SEARCH_CRITERIA.USE_FOR_MATCHING'
992: ) then
993: hr_utility.set_location(' Leaving:'||l_proc,60);
994: raise;
995: end if;
996: hr_utility.set_location(' Leaving:'||l_proc,70);
997: end chk_use_for_matching;
992: ) then
993: hr_utility.set_location(' Leaving:'||l_proc,60);
994: raise;
995: end if;
996: hr_utility.set_location(' Leaving:'||l_proc,70);
997: end chk_use_for_matching;
998: --
999: -- ----------------------------------------------------------------------------
1000: -- |----------------------------< chk_match_competence >----------------------|
1031: l_proc varchar2(72) := g_package || 'chk_match_competence';
1032: l_api_updating boolean;
1033: --
1034: begin
1035: hr_utility.set_location('Entering:'||l_proc,10);
1036: if p_match_competence is not null then
1037: hr_utility.set_location(l_proc,20);
1038: l_api_updating := irc_isc_shd.api_updating
1039: (p_search_criteria_id => p_search_criteria_id
1033: --
1034: begin
1035: hr_utility.set_location('Entering:'||l_proc,10);
1036: if p_match_competence is not null then
1037: hr_utility.set_location(l_proc,20);
1038: l_api_updating := irc_isc_shd.api_updating
1039: (p_search_criteria_id => p_search_criteria_id
1040: ,p_object_version_number => p_object_version_number
1041: );
1039: (p_search_criteria_id => p_search_criteria_id
1040: ,p_object_version_number => p_object_version_number
1041: );
1042: --
1043: hr_utility.set_location(l_proc,30);
1044: if (l_api_updating and
1045: p_match_competence <>
1046: NVL(irc_isc_shd.g_old_rec.match_competence,hr_api.g_varchar2)
1047: ) or (NOT l_api_updating) then
1045: p_match_competence <>
1046: NVL(irc_isc_shd.g_old_rec.match_competence,hr_api.g_varchar2)
1047: ) or (NOT l_api_updating) then
1048: -- Check that match_competence is having a valid value of 'Y' or 'N'
1049: hr_utility.set_location(l_proc,40);
1050: if not p_match_competence in ('Y','N') then
1051: fnd_message.set_name('PER','IRC_412013_BAD_MATCH_COMPETENC');
1052: fnd_message.raise_error;
1053: end if;
1052: fnd_message.raise_error;
1053: end if;
1054: end if;
1055: end if;
1056: hr_utility.set_location(' Leaving:'||l_proc,50);
1057: exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 =>
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 =>
1061: 'IRC_SEARCH_CRITERIA.MATCH_COMPETENCE'
1062: ) then
1063: hr_utility.set_location(' Leaving:'||l_proc,60);
1064: raise;
1065: end if;
1066: hr_utility.set_location(' Leaving:'||l_proc,70);
1067: end chk_match_competence;
1062: ) then
1063: hr_utility.set_location(' Leaving:'||l_proc,60);
1064: raise;
1065: end if;
1066: hr_utility.set_location(' Leaving:'||l_proc,70);
1067: end chk_match_competence;
1068: --
1069: -- ----------------------------------------------------------------------------
1070: -- |--------------------------< chk_match_qualification >----------------------|
1101: l_proc varchar2(72) := g_package || 'chk_match_qualification';
1102: l_api_updating boolean;
1103: --
1104: begin
1105: hr_utility.set_location('Entering:'||l_proc,10);
1106: if p_match_qualification is not null then
1107: --
1108: hr_utility.set_location(l_proc,20);
1109: l_api_updating := irc_isc_shd.api_updating
1104: begin
1105: hr_utility.set_location('Entering:'||l_proc,10);
1106: if p_match_qualification is not null then
1107: --
1108: hr_utility.set_location(l_proc,20);
1109: l_api_updating := irc_isc_shd.api_updating
1110: (p_search_criteria_id => p_search_criteria_id
1111: ,p_object_version_number => p_object_version_number
1112: );
1110: (p_search_criteria_id => p_search_criteria_id
1111: ,p_object_version_number => p_object_version_number
1112: );
1113: --
1114: hr_utility.set_location(l_proc,30);
1115: if (l_api_updating and
1116: p_match_qualification <>
1117: NVL(irc_isc_shd.g_old_rec.match_qualification,hr_api.g_varchar2)
1118: ) or (NOT l_api_updating) then
1116: p_match_qualification <>
1117: NVL(irc_isc_shd.g_old_rec.match_qualification,hr_api.g_varchar2)
1118: ) or (NOT l_api_updating) then
1119: -- Check that match_qualification is having a valid value of 'Y' or 'N'
1120: hr_utility.set_location(l_proc,40);
1121: if not p_match_qualification in ('Y','N') then
1122: fnd_message.set_name('PER','IRC_412014_BAD_MATCH_QUALIFICA');
1123: fnd_message.raise_error;
1124: end if;
1123: fnd_message.raise_error;
1124: end if;
1125: end if;
1126: end if;
1127: hr_utility.set_location(' Leaving:'||l_proc,50);
1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1132: 'IRC_SEARCH_CRITERIA.MATCH_QUALIFICATION'
1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,60);
1135: raise;
1136: end if;
1137: hr_utility.set_location(' Leaving:'||l_proc,70);
1138: end chk_match_qualification;
1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,60);
1135: raise;
1136: end if;
1137: hr_utility.set_location(' Leaving:'||l_proc,70);
1138: end chk_match_qualification;
1139: --
1140: -- ----------------------------------------------------------------------------
1141: -- |------------------------------< chk_vacancy_id >---------------------------|
1173: select null from per_all_vacancies pav
1174: where pav.vacancy_id = p_vacancy_id;
1175: --
1176: begin
1177: hr_utility.set_location('Entering:'||l_proc,10);
1178: -- Check that Vacancy_id is not null.
1179: hr_api.mandatory_arg_error
1180: (p_api_name => l_proc
1181: ,p_argument => 'VACANCY_ID'
1181: ,p_argument => 'VACANCY_ID'
1182: ,p_argument_value => p_vacancy_id
1183: );
1184: -- Check that vacancy_id exists in per_all_vacancies.
1185: hr_utility.set_location(l_proc,20);
1186: open csr_vacancy_id;
1187: fetch csr_vacancy_id into l_vacancy_id;
1188: hr_utility.set_location(l_proc,30);
1189: if csr_vacancy_id%NOTFOUND then
1184: -- Check that vacancy_id exists in per_all_vacancies.
1185: hr_utility.set_location(l_proc,20);
1186: open csr_vacancy_id;
1187: fetch csr_vacancy_id into l_vacancy_id;
1188: hr_utility.set_location(l_proc,30);
1189: if csr_vacancy_id%NOTFOUND then
1190: close csr_vacancy_id;
1191: fnd_message.set_name('PER','IRC_412015_BAD_VACANCY_ID');
1192: fnd_message.raise_error;
1191: fnd_message.set_name('PER','IRC_412015_BAD_VACANCY_ID');
1192: fnd_message.raise_error;
1193: end if;
1194: close csr_vacancy_id;
1195: hr_utility.set_location(' Leaving:'||l_proc,40);
1196: exception
1197: when app_exception.application_exception then
1198: if hr_multi_message.exception_add
1199: (p_associated_column1 =>
1198: if hr_multi_message.exception_add
1199: (p_associated_column1 =>
1200: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
1201: ) then
1202: hr_utility.set_location(' Leaving:'||l_proc,50);
1203: raise;
1204: end if;
1205: hr_utility.set_location(' Leaving:'||l_proc,60);
1206: end chk_vacancy_id;
1201: ) then
1202: hr_utility.set_location(' Leaving:'||l_proc,50);
1203: raise;
1204: end if;
1205: hr_utility.set_location(' Leaving:'||l_proc,60);
1206: end chk_vacancy_id;
1207: --
1208: -- ----------------------------------------------------------------------------
1209: -- |----------------------------< chk_min_qual_level >-------------------------|
1245: select null from per_qualification_types pqt
1246: where pqt.qualification_type_id = p_min_qual_level;
1247: --
1248: begin
1249: hr_utility.set_location('Entering:'||l_proc,10);
1250: if p_min_qual_level is not null then
1251: --
1252: hr_utility.set_location(l_proc,20);
1253: l_api_updating := irc_isc_shd.api_updating
1248: begin
1249: hr_utility.set_location('Entering:'||l_proc,10);
1250: if p_min_qual_level is not null then
1251: --
1252: hr_utility.set_location(l_proc,20);
1253: l_api_updating := irc_isc_shd.api_updating
1254: (p_search_criteria_id => p_search_criteria_id
1255: ,p_object_version_number => p_object_version_number
1256: );
1254: (p_search_criteria_id => p_search_criteria_id
1255: ,p_object_version_number => p_object_version_number
1256: );
1257: --
1258: hr_utility.set_location(l_proc,30);
1259: if (l_api_updating and
1260: p_min_qual_level <>
1261: NVL(irc_isc_shd.g_old_rec.min_qual_level,hr_api.g_number)
1262: ) or (NOT l_api_updating) then
1259: if (l_api_updating and
1260: p_min_qual_level <>
1261: NVL(irc_isc_shd.g_old_rec.min_qual_level,hr_api.g_number)
1262: ) or (NOT l_api_updating) then
1263: hr_utility.set_location(l_proc,40);
1264: open csr_min_qual_level;
1265: fetch csr_min_qual_level into l_min_qual_level ;
1266: hr_utility.set_location(l_proc,50);
1267: -- Check that min_qual_level exists in per_qualification_types
1262: ) or (NOT l_api_updating) then
1263: hr_utility.set_location(l_proc,40);
1264: open csr_min_qual_level;
1265: fetch csr_min_qual_level into l_min_qual_level ;
1266: hr_utility.set_location(l_proc,50);
1267: -- Check that min_qual_level exists in per_qualification_types
1268: if csr_min_qual_level%NOTFOUND then
1269: close csr_min_qual_level;
1270: fnd_message.set_name('PER','IRC_412016_BAD_MIN_QUAL_LEVEL');
1272: end if;
1273: close csr_min_qual_level;
1274: end if;
1275: end if;
1276: hr_utility.set_location(' Leaving:'||l_proc,60);
1277: exception
1278: when app_exception.application_exception then
1279: if hr_multi_message.exception_add
1280: (p_associated_column1 =>
1279: if hr_multi_message.exception_add
1280: (p_associated_column1 =>
1281: 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1282: ) then
1283: hr_utility.set_location(' Leaving:'||l_proc,70);
1284: raise;
1285: end if;
1286: hr_utility.set_location(' Leaving:'||l_proc,80);
1287: end chk_min_qual_level;
1282: ) then
1283: hr_utility.set_location(' Leaving:'||l_proc,70);
1284: raise;
1285: end if;
1286: hr_utility.set_location(' Leaving:'||l_proc,80);
1287: end chk_min_qual_level;
1288: --
1289: -- ----------------------------------------------------------------------------
1290: -- |----------------------------< chk_qual_rank >-----------------------------|
1322: cursor csr_qual_rank(c_qual_type_id per_qualification_types.qualification_type_id%TYPE) is
1323: select rank from per_qualification_types where qualification_type_id = c_qual_type_id;
1324: --
1325: begin
1326: hr_utility.set_location('Entering:'||l_proc,10);
1327: -- Only proceed with rank validation when multiple message list does not
1328: -- already contain an error associated with the min_qual_level or max_qual_level
1329: -- columns.
1330: hr_utility.set_location(l_proc,15);
1326: hr_utility.set_location('Entering:'||l_proc,10);
1327: -- Only proceed with rank validation when multiple message list does not
1328: -- already contain an error associated with the min_qual_level or max_qual_level
1329: -- columns.
1330: hr_utility.set_location(l_proc,15);
1331: if hr_multi_message.no_all_inclusive_error
1332: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1333: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1334: ) then
1332: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1333: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1334: ) then
1335: --
1336: hr_utility.set_location(l_proc,20);
1337: if ( p_min_qual_level is not null) AND (p_max_qual_level is not null) then
1338: hr_utility.set_location(l_proc,25);
1339: open csr_qual_rank(p_min_qual_level);
1340: fetch csr_qual_rank into l_min_qual_rank;
1334: ) then
1335: --
1336: hr_utility.set_location(l_proc,20);
1337: if ( p_min_qual_level is not null) AND (p_max_qual_level is not null) then
1338: hr_utility.set_location(l_proc,25);
1339: open csr_qual_rank(p_min_qual_level);
1340: fetch csr_qual_rank into l_min_qual_rank;
1341: close csr_qual_rank;
1342: open csr_qual_rank(p_max_qual_level);
1343: fetch csr_qual_rank into l_max_qual_rank;
1344: close csr_qual_rank;
1345: end if;
1346: if (l_min_qual_rank > l_max_qual_rank)then
1347: hr_utility.set_location(l_proc,30);
1348: fnd_message.set_name('PER', 'IRC_412139_MIN_MAX_QUAL_RANK');
1349: fnd_message.raise_error;
1350: end if;
1351: end if;
1348: fnd_message.set_name('PER', 'IRC_412139_MIN_MAX_QUAL_RANK');
1349: fnd_message.raise_error;
1350: end if;
1351: end if;
1352: hr_utility.set_location('Leaving:'||l_proc,40);
1353: exception
1354: when app_exception.application_exception then
1355: if hr_multi_message.exception_add
1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1355: if hr_multi_message.exception_add
1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1357: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1358: ) then
1359: hr_utility.set_location(' Leaving:'||l_proc,50);
1360: raise;
1361: end if;
1362: hr_utility.set_location(' Leaving:'||l_proc,60);
1363: end chk_qual_rank;
1358: ) then
1359: hr_utility.set_location(' Leaving:'||l_proc,50);
1360: raise;
1361: end if;
1362: hr_utility.set_location(' Leaving:'||l_proc,60);
1363: end chk_qual_rank;
1364: --
1365: -- ----------------------------------------------------------------------------
1366: -- |------------------------------< chk_min_salary >---------------------------|
1400: l_min_salary varchar2(1);
1401: l_api_updating boolean;
1402: --
1403: begin
1404: hr_utility.set_location('Entering:'||l_proc,10);
1405: if p_min_salary is not null then
1406: --
1407: hr_utility.set_location(l_proc,20);
1408: l_api_updating := irc_isc_shd.api_updating
1403: begin
1404: hr_utility.set_location('Entering:'||l_proc,10);
1405: if p_min_salary is not null then
1406: --
1407: hr_utility.set_location(l_proc,20);
1408: l_api_updating := irc_isc_shd.api_updating
1409: (p_search_criteria_id => p_search_criteria_id
1410: ,p_object_version_number => p_object_version_number
1411: );
1409: (p_search_criteria_id => p_search_criteria_id
1410: ,p_object_version_number => p_object_version_number
1411: );
1412: --
1413: hr_utility.set_location(l_proc,30);
1414: if (l_api_updating and
1415: p_min_salary <>
1416: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number)
1417: ) or (NOT l_api_updating) then
1415: p_min_salary <>
1416: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number)
1417: ) or (NOT l_api_updating) then
1418: -- Check that min_salary is a valid positive number.
1419: hr_utility.set_location(l_proc,40);
1420: if p_min_salary < 0 then
1421: fnd_message.set_name('PER','IRC_412017_BAD_MIN_SALARY');
1422: fnd_message.raise_error;
1423: end if;
1422: fnd_message.raise_error;
1423: end if;
1424: end if;
1425: end if;
1426: hr_utility.set_location(' Leaving:'||l_proc,50);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1431: ) then
1432: hr_utility.set_location(' Leaving:'||l_proc,60);
1433: raise;
1434: end if;
1435: hr_utility.set_location(' Leaving:'||l_proc,70);
1436: end chk_min_salary;
1431: ) then
1432: hr_utility.set_location(' Leaving:'||l_proc,60);
1433: raise;
1434: end if;
1435: hr_utility.set_location(' Leaving:'||l_proc,70);
1436: end chk_min_salary;
1437: --
1438: -- ----------------------------------------------------------------------------
1439: -- |------------------------------< chk_max_salary >---------------------------|
1476: l_min_salary varchar2(1);
1477: l_api_updating boolean;
1478: --
1479: begin
1480: hr_utility.set_location('Entering:'||l_proc,10);
1481: --
1482: -- Only proceed with max_salary validation when multiple message list does not
1483: -- already contain an error associated with the min_salary columns.
1484: hr_utility.set_location(l_proc,15);
1480: hr_utility.set_location('Entering:'||l_proc,10);
1481: --
1482: -- Only proceed with max_salary validation when multiple message list does not
1483: -- already contain an error associated with the min_salary columns.
1484: hr_utility.set_location(l_proc,15);
1485: if hr_multi_message.no_exclusive_error(
1486: p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1487: ) then
1488: if p_max_salary is not null then
1486: p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1487: ) then
1488: if p_max_salary is not null then
1489: --
1490: hr_utility.set_location(l_proc,20);
1491: l_api_updating := irc_isc_shd.api_updating
1492: (p_search_criteria_id => p_search_criteria_id
1493: ,p_object_version_number => p_object_version_number
1494: );
1492: (p_search_criteria_id => p_search_criteria_id
1493: ,p_object_version_number => p_object_version_number
1494: );
1495: --
1496: hr_utility.set_location(l_proc,30);
1497: if (l_api_updating and
1498: p_max_salary <>
1499: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number)
1500: ) or (NOT l_api_updating) then
1498: p_max_salary <>
1499: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number)
1500: ) or (NOT l_api_updating) then
1501: -- Check that max_salary is greater then min salary.
1502: hr_utility.set_location(l_proc,40);
1503: if p_max_salary < 0 or p_max_salary < NVL(p_min_salary,hr_api.g_number)
1504: then
1505: fnd_message.set_name('PER','IRC_412019_MAX_BELOW_MIN_SAL');
1506: fnd_message.raise_error;
1508: end if;
1509: end if;
1510: end if;
1511: --
1512: hr_utility.set_location(' Leaving:'||l_proc,50);
1513: exception
1514: -- When Multiple error detection is enabled handle the application errors
1515: -- which have been raised by this procedure. Transfer the error to the
1516: -- Multiple message list and associate the error with max_salary and
1519: if hr_multi_message.exception_add
1520: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1521: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
1522: ) then
1523: hr_utility.set_location(' Leaving:'||l_proc,60);
1524: raise;
1525: end if;
1526: hr_utility.set_location(' Leaving:'||l_proc,70);
1527: end chk_max_salary;
1522: ) then
1523: hr_utility.set_location(' Leaving:'||l_proc,60);
1524: raise;
1525: end if;
1526: hr_utility.set_location(' Leaving:'||l_proc,70);
1527: end chk_max_salary;
1528: --
1529: -- ----------------------------------------------------------------------------
1530: -- |-----------------------------< chk_employee >-----------------------------|
1561: l_proc varchar2(72) := g_package || 'chk_employee';
1562: l_api_updating boolean;
1563: --
1564: begin
1565: hr_utility.set_location('Entering:'||l_proc,10);
1566: l_api_updating := irc_isc_shd.api_updating
1567: (p_search_criteria_id => p_search_criteria_id
1568: ,p_object_version_number => p_object_version_number
1569: );
1567: (p_search_criteria_id => p_search_criteria_id
1568: ,p_object_version_number => p_object_version_number
1569: );
1570: --
1571: hr_utility.set_location(l_proc,20);
1572: if (l_api_updating and p_employee <> irc_isc_shd.g_old_rec.employee)
1573: or (NOT l_api_updating) then
1574: -- Check that employee is having a valid value of 'Y' or 'N'
1575: hr_utility.set_location(l_proc,30);
1571: hr_utility.set_location(l_proc,20);
1572: if (l_api_updating and p_employee <> irc_isc_shd.g_old_rec.employee)
1573: or (NOT l_api_updating) then
1574: -- Check that employee is having a valid value of 'Y' or 'N'
1575: hr_utility.set_location(l_proc,30);
1576: if (p_employee is null) or (p_employee Not in ('Y','N')) then
1577: fnd_message.set_name('PER','IRC_412020_BAD_EMPLOYEE');
1578: fnd_message.raise_error;
1579: end if;
1577: fnd_message.set_name('PER','IRC_412020_BAD_EMPLOYEE');
1578: fnd_message.raise_error;
1579: end if;
1580: end if;
1581: hr_utility.set_location(' Leaving:'||l_proc,40);
1582: exception
1583: when app_exception.application_exception then
1584: if hr_multi_message.exception_add
1585: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
1583: when app_exception.application_exception then
1584: if hr_multi_message.exception_add
1585: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
1586: ) then
1587: hr_utility.set_location(' Leaving:'||l_proc,50);
1588: raise;
1589: end if;
1590: hr_utility.set_location(' Leaving:'||l_proc,60);
1591: end chk_employee;
1586: ) then
1587: hr_utility.set_location(' Leaving:'||l_proc,50);
1588: raise;
1589: end if;
1590: hr_utility.set_location(' Leaving:'||l_proc,60);
1591: end chk_employee;
1592: -- ----------------------------------------------------------------------------
1593: -- |-----------------------------< chk_contractor >---------------------------|
1594: -- ----------------------------------------------------------------------------
1624: l_proc varchar2(72) := g_package || 'chk_contractor';
1625: l_api_updating boolean;
1626: --
1627: begin
1628: hr_utility.set_location('Entering:'||l_proc,10);
1629: l_api_updating := irc_isc_shd.api_updating
1630: (p_search_criteria_id => p_search_criteria_id
1631: ,p_object_version_number => p_object_version_number
1632: );
1629: l_api_updating := irc_isc_shd.api_updating
1630: (p_search_criteria_id => p_search_criteria_id
1631: ,p_object_version_number => p_object_version_number
1632: );
1633: hr_utility.set_location(l_proc,20);
1634: if (l_api_updating and p_contractor <> irc_isc_shd.g_old_rec.contractor)
1635: or (NOT l_api_updating) then
1636: -- Check that contractor is having a valid value of 'Y' or 'N'
1637: hr_utility.set_location(l_proc,30);
1633: hr_utility.set_location(l_proc,20);
1634: if (l_api_updating and p_contractor <> irc_isc_shd.g_old_rec.contractor)
1635: or (NOT l_api_updating) then
1636: -- Check that contractor is having a valid value of 'Y' or 'N'
1637: hr_utility.set_location(l_proc,30);
1638: if (p_contractor is null) or (p_contractor Not in ('Y','N')) then
1639: fnd_message.set_name('PER','IRC_412021_BAD_CONTRACTOR');
1640: fnd_message.raise_error;
1641: end if;
1639: fnd_message.set_name('PER','IRC_412021_BAD_CONTRACTOR');
1640: fnd_message.raise_error;
1641: end if;
1642: end if;
1643: hr_utility.set_location(' Leaving:'||l_proc,40);
1644: exception
1645: when app_exception.application_exception then
1646: if hr_multi_message.exception_add
1647: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.CONTRACTOR'
1645: when app_exception.application_exception then
1646: if hr_multi_message.exception_add
1647: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.CONTRACTOR'
1648: ) then
1649: hr_utility.set_location(' Leaving:'||l_proc,50);
1650: raise;
1651: end if;
1652: hr_utility.set_location(' Leaving:'||l_proc,60);
1653: end chk_contractor;
1648: ) then
1649: hr_utility.set_location(' Leaving:'||l_proc,50);
1650: raise;
1651: end if;
1652: hr_utility.set_location(' Leaving:'||l_proc,60);
1653: end chk_contractor;
1654: -- ----------------------------------------------------------------------------
1655: -- |------------------------< chk_professional_area >-------------------------|
1656: -- ----------------------------------------------------------------------------
1689: l_api_updating boolean;
1690: l_ret boolean;
1691: --
1692: begin
1693: hr_utility.set_location('Entering:'||l_proc,10);
1694: l_api_updating := irc_isc_shd.api_updating
1695: (p_search_criteria_id => p_search_criteria_id
1696: ,p_object_version_number => p_object_version_number
1697: );
1694: l_api_updating := irc_isc_shd.api_updating
1695: (p_search_criteria_id => p_search_criteria_id
1696: ,p_object_version_number => p_object_version_number
1697: );
1698: hr_utility.set_location(l_proc,20);
1699: if p_professional_area is not null then
1700: hr_utility.set_location(l_proc,30);
1701: if (l_api_updating and
1702: p_professional_area <>
1696: ,p_object_version_number => p_object_version_number
1697: );
1698: hr_utility.set_location(l_proc,20);
1699: if p_professional_area is not null then
1700: hr_utility.set_location(l_proc,30);
1701: if (l_api_updating and
1702: p_professional_area <>
1703: NVL(irc_isc_shd.g_old_rec.professional_area,hr_api.g_varchar2)
1704: ) or (NOT l_api_updating) then
1702: p_professional_area <>
1703: NVL(irc_isc_shd.g_old_rec.professional_area,hr_api.g_varchar2)
1704: ) or (NOT l_api_updating) then
1705: -- Check that professional_area exists in hr_lookups
1706: hr_utility.set_location(l_proc,40);
1707: l_ret := hr_api.not_exists_in_hr_lookups(
1708: p_effective_date => p_effective_date
1709: ,p_lookup_type => 'IRC_PROFESSIONAL_AREA'
1710: ,p_lookup_code => p_professional_area);
1713: fnd_message.raise_error;
1714: end if;
1715: end if;
1716: end if;
1717: hr_utility.set_location(' Leaving:'||l_proc,50);
1718: exception
1719: when app_exception.application_exception then
1720: if hr_multi_message.exception_add
1721: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.PROFESSIONAL_AREA'
1719: when app_exception.application_exception then
1720: if hr_multi_message.exception_add
1721: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.PROFESSIONAL_AREA'
1722: ) then
1723: hr_utility.set_location(' Leaving:'||l_proc,60);
1724: raise;
1725: end if;
1726: hr_utility.set_location(' Leaving:'||l_proc,70);
1727: end chk_professional_area;
1722: ) then
1723: hr_utility.set_location(' Leaving:'||l_proc,60);
1724: raise;
1725: end if;
1726: hr_utility.set_location(' Leaving:'||l_proc,70);
1727: end chk_professional_area;
1728: --
1729: -- ----------------------------------------------------------------------------
1730: -- |------------------------< chk_employment_category >------------------------|
1764: l_api_updating boolean;
1765: l_ret boolean;
1766: --
1767: begin
1768: hr_utility.set_location('Entering:'||l_proc,10);
1769: if p_employment_category is not null then
1770: --
1771: hr_utility.set_location(l_proc,20);
1772: l_api_updating := irc_isc_shd.api_updating
1767: begin
1768: hr_utility.set_location('Entering:'||l_proc,10);
1769: if p_employment_category is not null then
1770: --
1771: hr_utility.set_location(l_proc,20);
1772: l_api_updating := irc_isc_shd.api_updating
1773: (p_search_criteria_id => p_search_criteria_id
1774: ,p_object_version_number => p_object_version_number
1775: );
1773: (p_search_criteria_id => p_search_criteria_id
1774: ,p_object_version_number => p_object_version_number
1775: );
1776: --
1777: hr_utility.set_location(l_proc,30);
1778: if (l_api_updating and
1779: p_employment_category <>
1780: NVL(irc_isc_shd.g_old_rec.employment_category,hr_api.g_varchar2)
1781: ) or (NOT l_api_updating) then
1779: p_employment_category <>
1780: NVL(irc_isc_shd.g_old_rec.employment_category,hr_api.g_varchar2)
1781: ) or (NOT l_api_updating) then
1782: -- Check that employment_category exists in hr_lookups
1783: hr_utility.set_location(l_proc,40);
1784: l_ret := hr_api.not_exists_in_hr_lookups(
1785: p_effective_date => p_effective_date
1786: ,p_lookup_type => 'IRC_EMP_CAT'
1787: ,p_lookup_code => p_employment_category);
1790: fnd_message.raise_error;
1791: end if;
1792: end if;
1793: end if;
1794: hr_utility.set_location(' Leaving:'||l_proc,50);
1795: exception
1796: when app_exception.application_exception then
1797: if hr_multi_message.exception_add
1798: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYMENT_CATEGORY'
1796: when app_exception.application_exception then
1797: if hr_multi_message.exception_add
1798: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYMENT_CATEGORY'
1799: ) then
1800: hr_utility.set_location(' Leaving:'||l_proc,60);
1801: raise;
1802: end if;
1803: hr_utility.set_location(' Leaving:'||l_proc,70);
1804: end chk_employment_category;
1799: ) then
1800: hr_utility.set_location(' Leaving:'||l_proc,60);
1801: raise;
1802: end if;
1803: hr_utility.set_location(' Leaving:'||l_proc,70);
1804: end chk_employment_category;
1805: --
1806: -- ----------------------------------------------------------------------------
1807: -- |--------------------------< chk_work_at_home >----------------------------|
1841: l_api_updating boolean;
1842: l_ret boolean;
1843: --
1844: begin
1845: hr_utility.set_location('Entering:'||l_proc,10);
1846: if p_work_at_home is not null then
1847: --
1848: hr_utility.set_location(l_proc,20);
1849: l_api_updating := irc_isc_shd.api_updating
1844: begin
1845: hr_utility.set_location('Entering:'||l_proc,10);
1846: if p_work_at_home is not null then
1847: --
1848: hr_utility.set_location(l_proc,20);
1849: l_api_updating := irc_isc_shd.api_updating
1850: (p_search_criteria_id => p_search_criteria_id
1851: ,p_object_version_number => p_object_version_number
1852: );
1850: (p_search_criteria_id => p_search_criteria_id
1851: ,p_object_version_number => p_object_version_number
1852: );
1853: --
1854: hr_utility.set_location(l_proc,30);
1855: if (l_api_updating and
1856: p_work_at_home <>
1857: NVL(irc_isc_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
1858: ) or (NOT l_api_updating) then
1856: p_work_at_home <>
1857: NVL(irc_isc_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
1858: ) or (NOT l_api_updating) then
1859: -- Check that work_at_home exists in hr_lookups
1860: hr_utility.set_location(l_proc,40);
1861: l_ret := hr_api.not_exists_in_hr_lookups(
1862: p_effective_date => p_effective_date
1863: ,p_lookup_type => 'IRC_WORK_AT_HOME'
1864: ,p_lookup_code => p_work_at_home);
1867: fnd_message.raise_error;
1868: end if;
1869: end if;
1870: end if;
1871: hr_utility.set_location(' Leaving:'||l_proc,50);
1872: exception
1873: when app_exception.application_exception then
1874: if hr_multi_message.exception_add
1875: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.WORK_AT_HOME'
1873: when app_exception.application_exception then
1874: if hr_multi_message.exception_add
1875: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.WORK_AT_HOME'
1876: ) then
1877: hr_utility.set_location(' Leaving:'||l_proc,60);
1878: raise;
1879: end if;
1880: hr_utility.set_location(' Leaving:'||l_proc,70);
1881: end chk_work_at_home;
1876: ) then
1877: hr_utility.set_location(' Leaving:'||l_proc,60);
1878: raise;
1879: end if;
1880: hr_utility.set_location(' Leaving:'||l_proc,70);
1881: end chk_work_at_home;
1882: --
1883: -- ----------------------------------------------------------------------------
1884: -- |------------------------< chk_travel_percentage >--------------------------|
1918: l_api_updating boolean;
1919: l_ret boolean;
1920: --
1921: begin
1922: hr_utility.set_location('Entering:'||l_proc,10);
1923: if p_travel_percentage is not null then
1924: --
1925: hr_utility.set_location(l_proc,20);
1926: l_api_updating := irc_isc_shd.api_updating
1921: begin
1922: hr_utility.set_location('Entering:'||l_proc,10);
1923: if p_travel_percentage is not null then
1924: --
1925: hr_utility.set_location(l_proc,20);
1926: l_api_updating := irc_isc_shd.api_updating
1927: (p_search_criteria_id => p_search_criteria_id
1928: ,p_object_version_number => p_object_version_number
1929: );
1927: (p_search_criteria_id => p_search_criteria_id
1928: ,p_object_version_number => p_object_version_number
1929: );
1930: --
1931: hr_utility.set_location(l_proc,30);
1932: if (l_api_updating and
1933: p_travel_percentage <>
1934: NVL(irc_isc_shd.g_old_rec.travel_percentage,hr_api.g_number))
1935: or (NOT l_api_updating) then
1933: p_travel_percentage <>
1934: NVL(irc_isc_shd.g_old_rec.travel_percentage,hr_api.g_number))
1935: or (NOT l_api_updating) then
1936: -- Check that travel_percentage exists in hr_lookups
1937: hr_utility.set_location(l_proc,40);
1938: l_ret := hr_api.not_exists_in_hr_lookups(
1939: p_effective_date => p_effective_date
1940: ,p_lookup_type => 'IRC_TRAVEL_PERCENTAGE'
1941: ,p_lookup_code => to_char(p_travel_percentage));
1944: fnd_message.raise_error;
1945: end if;
1946: end if;
1947: end if;
1948: hr_utility.set_location(' Leaving:'||l_proc,50);
1949: exception
1950: when app_exception.application_exception then
1951: if hr_multi_message.exception_add
1952: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.TRAVEL_PERCENTAGE'
1950: when app_exception.application_exception then
1951: if hr_multi_message.exception_add
1952: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.TRAVEL_PERCENTAGE'
1953: ) then
1954: hr_utility.set_location(' Leaving:'||l_proc,60);
1955: raise;
1956: end if;
1957: hr_utility.set_location(' Leaving:'||l_proc,70);
1958: end chk_travel_percentage;
1953: ) then
1954: hr_utility.set_location(' Leaving:'||l_proc,60);
1955: raise;
1956: end if;
1957: hr_utility.set_location(' Leaving:'||l_proc,70);
1958: end chk_travel_percentage;
1959: --
1960: -- ----------------------------------------------------------------------------
1961: -- |---------------------------< chk_salary_period >--------------------------|
1999: l_min_salary irc_search_criteria.max_salary%type;
2000: l_ret boolean;
2001: --
2002: begin
2003: hr_utility.set_location('Entering:'||l_proc,10);
2004: l_api_updating := irc_isc_shd.api_updating
2005: (p_search_criteria_id => p_search_criteria_id
2006: ,p_object_version_number => p_object_version_number
2007: );
2004: l_api_updating := irc_isc_shd.api_updating
2005: (p_search_criteria_id => p_search_criteria_id
2006: ,p_object_version_number => p_object_version_number
2007: );
2008: hr_utility.set_location(l_proc,20);
2009: if (p_max_salary = hr_api.g_number) then
2010: l_max_salary :=irc_isc_shd.g_old_rec.max_salary;
2011: else
2012: l_max_salary := p_max_salary;
2017: else
2018: l_min_salary := p_min_salary;
2019: end if;
2020: --
2021: hr_utility.set_location(l_proc,30);
2022: if (l_api_updating and
2023: p_salary_period <>
2024: NVL(irc_isc_shd.g_old_rec.salary_period,hr_api.g_varchar2)
2025: ) or (NOT l_api_updating) then
2030: fnd_message.raise_error;
2031: end if;
2032: if p_salary_period is not null then
2033: -- Check that p_salary_period exists in hr_lookups
2034: hr_utility.set_location(l_proc,40);
2035: if hr_api.not_exists_in_hr_lookups(
2036: p_effective_date => p_effective_date
2037: ,p_lookup_type => 'PAY_BASIS'
2038: ,p_lookup_code => p_salary_period)
2041: fnd_message.raise_error;
2042: end if;
2043: end if;
2044: end if;
2045: hr_utility.set_location(' Leaving:'||l_proc,50);
2046: exception
2047: when app_exception.application_exception then
2048: if hr_multi_message.exception_add
2049: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.SALARY_PERIOD'
2047: when app_exception.application_exception then
2048: if hr_multi_message.exception_add
2049: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.SALARY_PERIOD'
2050: ) then
2051: hr_utility.set_location(' Leaving:'||l_proc,60);
2052: raise;
2053: end if;
2054: hr_utility.set_location(' Leaving:'||l_proc,70);
2055: end chk_salary_period;
2050: ) then
2051: hr_utility.set_location(' Leaving:'||l_proc,60);
2052: raise;
2053: end if;
2054: hr_utility.set_location(' Leaving:'||l_proc,70);
2055: end chk_salary_period;
2056: --
2057: -- ----------------------------------------------------------------------------
2058: -- |--------------------------< chk_salary_currency >--------------------------|
2103: nvl(fc.start_date_active, p_effective_date)
2104: and nvl(fc.end_date_active, p_effective_date);
2105: --
2106: begin
2107: hr_utility.set_location('Entering:'||l_proc,10);
2108: -- Only proceed with max_salary validation when multiple message list does not
2109: -- already contain an error associated with the min_salary or max_salary
2110: -- columns.
2111: hr_utility.set_location(l_proc,15);
2107: hr_utility.set_location('Entering:'||l_proc,10);
2108: -- Only proceed with max_salary validation when multiple message list does not
2109: -- already contain an error associated with the min_salary or max_salary
2110: -- columns.
2111: hr_utility.set_location(l_proc,15);
2112: if hr_multi_message.no_all_inclusive_error
2113: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2114: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2115: ) then
2118: (p_search_criteria_id => p_search_criteria_id
2119: ,p_object_version_number => p_object_version_number
2120: );
2121: --
2122: hr_utility.set_location(l_proc,20);
2123: if (l_api_updating and
2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2134: --
2135: -- Check that salary currency is not null if either min_sal or max_sal is
2136: -- not null.
2137: --
2138: hr_utility.set_location(l_proc,30);
2139: if (p_min_salary is not null or p_max_salary is not null) and
2140: (p_salary_currency is null) then
2141: fnd_message.set_name('PER','IRC_412018_CURRENCY_NOT_FOUND');
2142: fnd_message.raise_error;
2144: --
2145: -- Check that salary_currency exists in fnd_currencies.
2146: --
2147: if p_salary_currency is not null then
2148: hr_utility.set_location(l_proc,40);
2149: open csr_salary_currency;
2150: fetch csr_salary_currency into l_salary_currency;
2151: hr_utility.set_location(l_proc,50);
2152: if csr_salary_currency%NOTFOUND then
2147: if p_salary_currency is not null then
2148: hr_utility.set_location(l_proc,40);
2149: open csr_salary_currency;
2150: fetch csr_salary_currency into l_salary_currency;
2151: hr_utility.set_location(l_proc,50);
2152: if csr_salary_currency%NOTFOUND then
2153: close csr_salary_currency;
2154: fnd_message.set_name('PER','IRC_412026_BAD_SALARY_CURRENCY');
2155: fnd_message.raise_error;
2157: close csr_salary_currency;
2158: end if;
2159: end if;
2160: end if;
2161: hr_utility.set_location(' Leaving:'||l_proc,60);
2162: exception
2163: --
2164: -- When Multiple error detection is enabled handle the application errors
2165: -- which have been raised by this procedure. Transfer the error to the
2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'
2173: ) then
2174: hr_utility.set_location(' Leaving:'||l_proc,70);
2175: raise;
2176: end if;
2177: hr_utility.set_location(' Leaving:'||l_proc,80);
2178: end chk_salary_currency;
2173: ) then
2174: hr_utility.set_location(' Leaving:'||l_proc,70);
2175: raise;
2176: end if;
2177: hr_utility.set_location(' Leaving:'||l_proc,80);
2178: end chk_salary_currency;
2179: --
2180: -- ----------------------------------------------------------------------------
2181: -- |------------------------< chk_date_posted >-------------------------------|
2215: l_api_updating boolean;
2216: l_ret boolean;
2217: --
2218: begin
2219: hr_utility.set_location('Entering:'||l_proc,10);
2220: if p_date_posted is not null then
2221: --
2222: hr_utility.set_location(l_proc,20);
2223: l_api_updating := irc_isc_shd.api_updating
2218: begin
2219: hr_utility.set_location('Entering:'||l_proc,10);
2220: if p_date_posted is not null then
2221: --
2222: hr_utility.set_location(l_proc,20);
2223: l_api_updating := irc_isc_shd.api_updating
2224: (p_search_criteria_id => p_search_criteria_id
2225: ,p_object_version_number => p_object_version_number
2226: );
2224: (p_search_criteria_id => p_search_criteria_id
2225: ,p_object_version_number => p_object_version_number
2226: );
2227: --
2228: hr_utility.set_location(l_proc,30);
2229: if (l_api_updating and
2230: p_date_posted <>
2231: NVL(irc_isc_shd.g_old_rec.date_posted,hr_api.g_varchar2)
2232: ) or (NOT l_api_updating) then
2230: p_date_posted <>
2231: NVL(irc_isc_shd.g_old_rec.date_posted,hr_api.g_varchar2)
2232: ) or (NOT l_api_updating) then
2233: -- Check that date_posted exists in hr_lookups
2234: hr_utility.set_location(l_proc,40);
2235: l_ret := hr_api.not_exists_in_hr_lookups(
2236: p_effective_date => p_effective_date
2237: ,p_lookup_type => 'IRC_VACANCY_SEARCH_DATE'
2238: ,p_lookup_code => p_date_posted);
2241: fnd_message.raise_error;
2242: end if;
2243: end if;
2244: end if;
2245: hr_utility.set_location(' Leaving:'||l_proc,50);
2246: exception
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DATE_POSTED'
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DATE_POSTED'
2250: ) then
2251: hr_utility.set_location(' Leaving:'||l_proc,60);
2252: raise;
2253: end if;
2254: hr_utility.set_location(' Leaving:'||l_proc,70);
2255: end chk_date_posted;
2250: ) then
2251: hr_utility.set_location(' Leaving:'||l_proc,60);
2252: raise;
2253: end if;
2254: hr_utility.set_location(' Leaving:'||l_proc,70);
2255: end chk_date_posted;
2256: --
2257: -- ----------------------------------------------------------------------------
2258: -- |------------------------< chk_employee_contractor>------------------------|
2290: l_api_updating boolean;
2291: l_ret boolean;
2292: --
2293: begin
2294: hr_utility.set_location('Entering:'||l_proc,10);
2295: if p_employee = 'N' and p_contractor = 'N' then
2296: --
2297: hr_utility.set_location(l_proc,20);
2298: fnd_message.set_name('PER', 'IRC_412152_VAC_EMP_CON_WARN');
2293: begin
2294: hr_utility.set_location('Entering:'||l_proc,10);
2295: if p_employee = 'N' and p_contractor = 'N' then
2296: --
2297: hr_utility.set_location(l_proc,20);
2298: fnd_message.set_name('PER', 'IRC_412152_VAC_EMP_CON_WARN');
2299: hr_multi_message.add
2300: (p_message_type => hr_multi_message.g_warning_msg
2301: );
2300: (p_message_type => hr_multi_message.g_warning_msg
2301: );
2302: --
2303: end if;
2304: hr_utility.set_location(' Leaving:'||l_proc,30);
2305: --
2306: end chk_employee_contractor;
2307: --
2308: -- ----------------------------------------------------------------------------
2340: l_api_updating boolean;
2341: l_ret boolean;
2342: --
2343: begin
2344: hr_utility.set_location('Entering:'||l_proc,10);
2345: if p_keywords is not null then
2346: --
2347: hr_utility.set_location(l_proc,20);
2348: l_api_updating := irc_isc_shd.api_updating
2343: begin
2344: hr_utility.set_location('Entering:'||l_proc,10);
2345: if p_keywords is not null then
2346: --
2347: hr_utility.set_location(l_proc,20);
2348: l_api_updating := irc_isc_shd.api_updating
2349: (p_search_criteria_id => p_search_criteria_id
2350: ,p_object_version_number => p_object_version_number
2351: );
2349: (p_search_criteria_id => p_search_criteria_id
2350: ,p_object_version_number => p_object_version_number
2351: );
2352: --
2353: hr_utility.set_location(l_proc,30);
2354: if ((l_api_updating and
2355: p_keywords <>
2356: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)
2357: ) or (NOT l_api_updating)) then
2354: if ((l_api_updating and
2355: p_keywords <>
2356: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)
2357: ) or (NOT l_api_updating)) then
2358: hr_utility.set_location(l_proc,40);
2359: --
2360: -- Check the validity of the keywords by using the
2361: -- procedure irc_query_parser_pkg.isInvalidKeyword()
2362: --
2361: -- procedure irc_query_parser_pkg.isInvalidKeyword()
2362: --
2363: l_ret := irc_query_parser_pkg.isInvalidKeyword (input_text => p_keywords);
2364: if l_ret then
2365: hr_utility.set_location(l_proc,45);
2366: fnd_message.set_name('PER','IRC_INVALID_KEYWORDS');
2367: fnd_message.raise_error;
2368: end if;
2369: end if;
2368: end if;
2369: end if;
2370: end if;
2371: --
2372: hr_utility.set_location(' Leaving:'||l_proc,50);
2373: exception
2374: when app_exception.application_exception then
2375: if hr_multi_message.exception_add
2376: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2374: when app_exception.application_exception then
2375: if hr_multi_message.exception_add
2376: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2377: ) then
2378: hr_utility.set_location(' Leaving:'||l_proc,60);
2379: raise;
2380: end if;
2381: hr_utility.set_location(' Leaving:'||l_proc,70);
2382: end chk_keywords;
2377: ) then
2378: hr_utility.set_location(' Leaving:'||l_proc,60);
2379: raise;
2380: end if;
2381: hr_utility.set_location(' Leaving:'||l_proc,70);
2382: end chk_keywords;
2383: --
2384: -- ----------------------------------------------------------------------------
2385: -- |---------------------------< insert_validate >----------------------------|
2391: --
2392: l_proc varchar2(72) := g_package||'insert_validate';
2393: --
2394: Begin
2395: hr_utility.set_location('Entering:'||l_proc, 5);
2396: --
2397: -- Validate Important Attributes
2398: --
2399: -- Call all supporting business operations
2405: -- one error has been found then abort further validation.
2406: --
2407: -- Validate Dependent Attributes
2408: --
2409: hr_utility.set_location(l_proc, 20);
2410: if p_rec.object_type in ('PERSON','WPREF') then
2411: --
2412: hr_utility.set_location(l_proc, 30);
2413: hr_api.mandatory_arg_error
2408: --
2409: hr_utility.set_location(l_proc, 20);
2410: if p_rec.object_type in ('PERSON','WPREF') then
2411: --
2412: hr_utility.set_location(l_proc, 30);
2413: hr_api.mandatory_arg_error
2414: (p_api_name => l_proc
2415: ,p_argument => 'EFFECTIVE_DATE'
2416: ,p_argument_value => p_effective_date
2415: ,p_argument => 'EFFECTIVE_DATE'
2416: ,p_argument_value => p_effective_date
2417: );
2418: --
2419: hr_utility.set_location(l_proc, 40);
2420: irc_isc_bus.chk_person_id(
2421: p_person_id => p_rec.object_id
2422: ,p_effective_date => p_effective_date
2423: );
2421: p_person_id => p_rec.object_id
2422: ,p_effective_date => p_effective_date
2423: );
2424: --
2425: hr_utility.set_location(l_proc, 50);
2426: irc_isc_bus.chk_search_name(
2427: p_search_name => p_rec.search_name
2428: ,p_person_id => p_rec.object_id
2429: ,p_search_criteria_id => p_rec.search_criteria_id
2429: ,p_search_criteria_id => p_rec.search_criteria_id
2430: ,p_object_version_number => p_rec.object_version_number
2431: );
2432: --
2433: hr_utility.set_location(l_proc, 60);
2434: irc_isc_bus.chk_distance_to_location(
2435: p_distance_to_location => p_rec.distance_to_location
2436: ,p_geocode_location => p_rec.geocode_location
2437: ,p_search_criteria_id => p_rec.search_criteria_id
2437: ,p_search_criteria_id => p_rec.search_criteria_id
2438: ,p_object_version_number => p_rec.object_version_number
2439: );
2440: --
2441: hr_utility.set_location(l_proc, 63);
2442: irc_isc_bus.chk_location_id(
2443: p_location_id => p_rec.location_id
2444: ,p_search_criteria_id => p_rec.search_criteria_id
2445: ,p_object_version_number => p_rec.object_version_number
2444: ,p_search_criteria_id => p_rec.search_criteria_id
2445: ,p_object_version_number => p_rec.object_version_number
2446: );
2447: --
2448: hr_utility.set_location(l_proc, 66);
2449: irc_isc_bus.chk_longitude_latitude(
2450: p_longitude => p_rec.longitude
2451: ,p_latitude => p_rec.latitude
2452: ,p_search_criteria_id => p_rec.search_criteria_id
2452: ,p_search_criteria_id => p_rec.search_criteria_id
2453: ,p_object_version_number => p_rec.object_version_number
2454: );
2455: --
2456: hr_utility.set_location(l_proc, 70);
2457: irc_isc_bus.chk_use_for_matching(
2458: p_use_for_matching => p_rec.use_for_matching
2459: ,p_search_criteria_id => p_rec.search_criteria_id
2460: ,p_object_version_number => p_rec.object_version_number
2459: ,p_search_criteria_id => p_rec.search_criteria_id
2460: ,p_object_version_number => p_rec.object_version_number
2461: );
2462: --
2463: hr_utility.set_location(l_proc, 80);
2464: irc_isc_bus.chk_match_competence(
2465: p_match_competence => p_rec.match_competence
2466: ,p_search_criteria_id => p_rec.search_criteria_id
2467: ,p_object_version_number => p_rec.object_version_number
2466: ,p_search_criteria_id => p_rec.search_criteria_id
2467: ,p_object_version_number => p_rec.object_version_number
2468: );
2469: --
2470: hr_utility.set_location(l_proc, 90);
2471: irc_isc_bus.chk_match_qualification(
2472: p_match_qualification => p_rec.match_qualification
2473: ,p_search_criteria_id => p_rec.search_criteria_id
2474: ,p_object_version_number => p_rec.object_version_number
2473: ,p_search_criteria_id => p_rec.search_criteria_id
2474: ,p_object_version_number => p_rec.object_version_number
2475: );
2476: --
2477: hr_utility.set_location(l_proc, 100);
2478: irc_isc_bus.chk_min_salary(
2479: p_min_salary => p_rec.min_salary
2480: ,p_search_criteria_id => p_rec.search_criteria_id
2481: ,p_object_version_number => p_rec.object_version_number
2483: --
2484: end if;
2485:
2486: if p_rec.object_type= 'WPREF' then
2487: hr_utility.set_location(l_proc, 114);
2488: irc_isc_bus.chk_unique_work (
2489: p_object_id => p_rec.object_id
2490: );
2491: hr_utility.set_location(l_proc, 117);
2487: hr_utility.set_location(l_proc, 114);
2488: irc_isc_bus.chk_unique_work (
2489: p_object_id => p_rec.object_id
2490: );
2491: hr_utility.set_location(l_proc, 117);
2492: irc_isc_bus.chk_work_at_home(
2493: p_work_at_home => p_rec.work_at_home
2494: ,p_effective_date => p_effective_date
2495: ,p_search_criteria_id => p_rec.search_criteria_id
2494: ,p_effective_date => p_effective_date
2495: ,p_search_criteria_id => p_rec.search_criteria_id
2496: ,p_object_version_number => p_rec.object_version_number
2497: );
2498: hr_utility.set_location(l_proc, 119);
2499: irc_isc_bus.chk_keywords(
2500: p_keywords => p_rec.keywords
2501: ,p_search_criteria_id => p_rec.search_criteria_id
2502: ,p_object_version_number => p_rec.object_version_number
2502: ,p_object_version_number => p_rec.object_version_number
2503: );
2504: end if;
2505: --
2506: hr_utility.set_location(l_proc, 110);
2507: if p_rec.object_type= 'VACANCY' then
2508: --
2509: hr_utility.set_location(l_proc, 70);
2510: irc_isc_bus.chk_vacancy_id(
2505: --
2506: hr_utility.set_location(l_proc, 110);
2507: if p_rec.object_type= 'VACANCY' then
2508: --
2509: hr_utility.set_location(l_proc, 70);
2510: irc_isc_bus.chk_vacancy_id(
2511: p_vacancy_id => p_rec.object_id
2512: ,p_effective_date => p_effective_date
2513: );
2511: p_vacancy_id => p_rec.object_id
2512: ,p_effective_date => p_effective_date
2513: );
2514: --
2515: hr_utility.set_location(l_proc, 120);
2516: irc_isc_bus.chk_min_qual_level(
2517: p_min_qual_level => p_rec.min_qual_level
2518: ,p_search_criteria_id => p_rec.search_criteria_id
2519: ,p_object_version_number => p_rec.object_version_number
2518: ,p_search_criteria_id => p_rec.search_criteria_id
2519: ,p_object_version_number => p_rec.object_version_number
2520: );
2521: --
2522: hr_utility.set_location(l_proc, 130);
2523: irc_isc_bus.chk_min_salary(
2524: p_min_salary => p_rec.min_salary
2525: ,p_search_criteria_id => p_rec.search_criteria_id
2526: ,p_object_version_number => p_rec.object_version_number
2525: ,p_search_criteria_id => p_rec.search_criteria_id
2526: ,p_object_version_number => p_rec.object_version_number
2527: );
2528: --
2529: hr_utility.set_location(l_proc, 140);
2530: irc_isc_bus.chk_max_salary(
2531: p_max_salary => p_rec.max_salary
2532: ,p_min_salary => p_rec.min_salary
2533: ,p_search_criteria_id => p_rec.search_criteria_id
2533: ,p_search_criteria_id => p_rec.search_criteria_id
2534: ,p_object_version_number => p_rec.object_version_number
2535: );
2536: --
2537: hr_utility.set_location(l_proc, 145);
2538: irc_isc_bus.chk_qual_rank(
2539: p_min_qual_level => p_rec.min_qual_level
2540: ,p_max_qual_level => p_rec.max_qual_level
2541: );
2539: p_min_qual_level => p_rec.min_qual_level
2540: ,p_max_qual_level => p_rec.max_qual_level
2541: );
2542: --
2543: hr_utility.set_location(l_proc, 147);
2544: irc_isc_bus.chk_employee_contractor(
2545: p_employee => p_rec.employee
2546: ,p_contractor => p_rec.contractor
2547: );
2547: );
2548: --
2549: end if;
2550: --
2551: hr_utility.set_location(l_proc, 150);
2552: irc_isc_bus.chk_salary_currency
2553: (p_salary_currency => p_rec.salary_currency
2554: ,p_min_salary => p_rec.min_salary
2555: ,p_max_salary => p_rec.max_salary
2558: ,p_object_version_number => p_rec.object_version_number
2559: );
2560: --
2561: --
2562: hr_utility.set_location(l_proc, 155);
2563: irc_isc_bus.chk_salary_period(
2564: p_salary_period => p_rec.salary_period
2565: ,p_min_salary => p_rec.min_salary
2566: ,p_max_salary => p_rec.max_salary
2568: ,p_search_criteria_id => p_rec.search_criteria_id
2569: ,p_object_version_number => p_rec.object_version_number
2570: );
2571: --
2572: hr_utility.set_location(l_proc, 160);
2573: irc_isc_bus.chk_employee(
2574: p_employee => p_rec.employee
2575: ,p_search_criteria_id => p_rec.search_criteria_id
2576: ,p_object_version_number => p_rec.object_version_number
2575: ,p_search_criteria_id => p_rec.search_criteria_id
2576: ,p_object_version_number => p_rec.object_version_number
2577: );
2578: --
2579: hr_utility.set_location(l_proc, 170);
2580: irc_isc_bus.chk_contractor(
2581: p_contractor => p_rec.contractor
2582: ,p_search_criteria_id => p_rec.search_criteria_id
2583: ,p_object_version_number => p_rec.object_version_number
2582: ,p_search_criteria_id => p_rec.search_criteria_id
2583: ,p_object_version_number => p_rec.object_version_number
2584: );
2585: --
2586: hr_utility.set_location(l_proc, 180);
2587: irc_isc_bus.chk_professional_area(
2588: p_professional_area => p_rec.professional_area
2589: ,p_effective_date => p_effective_date
2590: ,p_search_criteria_id => p_rec.search_criteria_id
2590: ,p_search_criteria_id => p_rec.search_criteria_id
2591: ,p_object_version_number => p_rec.object_version_number
2592: );
2593: --
2594: hr_utility.set_location(l_proc, 190);
2595: irc_isc_bus.chk_employment_category(
2596: p_employment_category => p_rec.employment_category
2597: ,p_effective_date => p_effective_date
2598: ,p_search_criteria_id => p_rec.search_criteria_id
2598: ,p_search_criteria_id => p_rec.search_criteria_id
2599: ,p_object_version_number => p_rec.object_version_number
2600: );
2601: --
2602: hr_utility.set_location(l_proc, 200);
2603: irc_isc_bus.chk_work_at_home(
2604: p_work_at_home => p_rec.work_at_home
2605: ,p_effective_date => p_effective_date
2606: ,p_search_criteria_id => p_rec.search_criteria_id
2606: ,p_search_criteria_id => p_rec.search_criteria_id
2607: ,p_object_version_number => p_rec.object_version_number
2608: );
2609: --
2610: hr_utility.set_location(l_proc, 210);
2611: irc_isc_bus.chk_travel_percentage(
2612: p_travel_percentage => p_rec.travel_percentage
2613: ,p_effective_date => p_effective_date
2614: ,p_search_criteria_id => p_rec.search_criteria_id
2614: ,p_search_criteria_id => p_rec.search_criteria_id
2615: ,p_object_version_number => p_rec.object_version_number
2616: );
2617: --
2618: hr_utility.set_location(l_proc, 215);
2619: irc_isc_bus.chk_date_posted(
2620: p_date_posted => p_rec.date_posted
2621: ,p_effective_date => p_effective_date
2622: ,p_search_criteria_id => p_rec.search_criteria_id
2622: ,p_search_criteria_id => p_rec.search_criteria_id
2623: ,p_object_version_number => p_rec.object_version_number
2624: );
2625: --
2626: hr_utility.set_location(l_proc, 220);
2627: irc_isc_bus.chk_ddf(p_rec);
2628: --
2629: hr_utility.set_location(l_proc, 230);
2630: irc_isc_bus.chk_df(p_rec);
2625: --
2626: hr_utility.set_location(l_proc, 220);
2627: irc_isc_bus.chk_ddf(p_rec);
2628: --
2629: hr_utility.set_location(l_proc, 230);
2630: irc_isc_bus.chk_df(p_rec);
2631: --
2632: hr_utility.set_location(' Leaving:'||l_proc, 240);
2633: End insert_validate;
2628: --
2629: hr_utility.set_location(l_proc, 230);
2630: irc_isc_bus.chk_df(p_rec);
2631: --
2632: hr_utility.set_location(' Leaving:'||l_proc, 240);
2633: End insert_validate;
2634: --
2635: -- ----------------------------------------------------------------------------
2636: -- |---------------------------< update_validate >----------------------------|
2642: --
2643: l_proc varchar2(72) := g_package||'update_validate';
2644: --
2645: Begin
2646: hr_utility.set_location('Entering:'||l_proc, 10);
2647: --
2648: -- Validate Important Attributes
2649: --
2650: -- Call all supporting business operations
2655: -- one error has been found then abort further validation.
2656: --
2657: -- Validate Dependent Attributes
2658: --
2659: hr_utility.set_location(l_proc,15);
2660: chk_non_updateable_args
2661: (p_effective_date => p_effective_date
2662: ,p_rec => p_rec
2663: );
2662: ,p_rec => p_rec
2663: );
2664: --
2665: --
2666: hr_utility.set_location(l_proc, 20);
2667:
2668: if p_rec.object_type in( 'PERSON','WPREF') then
2669: --
2670: hr_utility.set_location(l_proc, 30);
2666: hr_utility.set_location(l_proc, 20);
2667:
2668: if p_rec.object_type in( 'PERSON','WPREF') then
2669: --
2670: hr_utility.set_location(l_proc, 30);
2671: irc_isc_bus.chk_search_name(
2672: p_search_name => p_rec.search_name
2673: ,p_person_id => p_rec.object_id
2674: ,p_search_criteria_id => p_rec.search_criteria_id
2674: ,p_search_criteria_id => p_rec.search_criteria_id
2675: ,p_object_version_number => p_rec.object_version_number
2676: );
2677: --
2678: hr_utility.set_location(l_proc, 40);
2679: irc_isc_bus.chk_distance_to_location(
2680: p_distance_to_location => p_rec.distance_to_location
2681: ,p_geocode_location => p_rec.geocode_location
2682: ,p_search_criteria_id => p_rec.search_criteria_id
2682: ,p_search_criteria_id => p_rec.search_criteria_id
2683: ,p_object_version_number => p_rec.object_version_number
2684: );
2685: --
2686: hr_utility.set_location(l_proc, 43);
2687: irc_isc_bus.chk_location_id(
2688: p_location_id => p_rec.location_id
2689: ,p_search_criteria_id => p_rec.search_criteria_id
2690: ,p_object_version_number => p_rec.object_version_number
2689: ,p_search_criteria_id => p_rec.search_criteria_id
2690: ,p_object_version_number => p_rec.object_version_number
2691: );
2692: --
2693: hr_utility.set_location(l_proc, 46);
2694: irc_isc_bus.chk_longitude_latitude(
2695: p_longitude => p_rec.longitude
2696: ,p_latitude => p_rec.latitude
2697: ,p_search_criteria_id => p_rec.search_criteria_id
2697: ,p_search_criteria_id => p_rec.search_criteria_id
2698: ,p_object_version_number => p_rec.object_version_number
2699: );
2700: --
2701: hr_utility.set_location(l_proc, 50);
2702: irc_isc_bus.chk_use_for_matching(
2703: p_use_for_matching => p_rec.use_for_matching
2704: ,p_search_criteria_id => p_rec.search_criteria_id
2705: ,p_object_version_number => p_rec.object_version_number
2704: ,p_search_criteria_id => p_rec.search_criteria_id
2705: ,p_object_version_number => p_rec.object_version_number
2706: );
2707: --
2708: hr_utility.set_location(l_proc, 60);
2709: irc_isc_bus.chk_match_competence(
2710: p_match_competence => p_rec.match_competence
2711: ,p_search_criteria_id => p_rec.search_criteria_id
2712: ,p_object_version_number => p_rec.object_version_number
2711: ,p_search_criteria_id => p_rec.search_criteria_id
2712: ,p_object_version_number => p_rec.object_version_number
2713: );
2714: --
2715: hr_utility.set_location(l_proc, 70);
2716: irc_isc_bus.chk_match_qualification(
2717: p_match_qualification => p_rec.match_qualification
2718: ,p_search_criteria_id => p_rec.search_criteria_id
2719: ,p_object_version_number => p_rec.object_version_number
2718: ,p_search_criteria_id => p_rec.search_criteria_id
2719: ,p_object_version_number => p_rec.object_version_number
2720: );
2721: --
2722: hr_utility.set_location(l_proc, 80);
2723: irc_isc_bus.chk_min_salary(
2724: p_min_salary => p_rec.min_salary
2725: ,p_search_criteria_id => p_rec.search_criteria_id
2726: ,p_object_version_number => p_rec.object_version_number
2725: ,p_search_criteria_id => p_rec.search_criteria_id
2726: ,p_object_version_number => p_rec.object_version_number
2727: );
2728: --
2729: hr_utility.set_location(l_proc, 85);
2730: irc_isc_bus.chk_date_posted(
2731: p_date_posted => p_rec.date_posted
2732: ,p_effective_date => p_effective_date
2733: ,p_search_criteria_id => p_rec.search_criteria_id
2736: --
2737: end if;
2738: --
2739: if p_rec.object_type= 'WPREF' then
2740: hr_utility.set_location(l_proc, 87);
2741: irc_isc_bus.chk_work_at_home(
2742: p_work_at_home => p_rec.work_at_home
2743: ,p_effective_date => p_effective_date
2744: ,p_search_criteria_id => p_rec.search_criteria_id
2751: ,p_object_version_number => p_rec.object_version_number
2752: );
2753: end if;
2754: --
2755: hr_utility.set_location(l_proc, 90);
2756: if p_rec.object_type= 'VACANCY' then
2757: --
2758: hr_utility.set_location(l_proc, 100);
2759: irc_isc_bus.chk_min_qual_level(
2754: --
2755: hr_utility.set_location(l_proc, 90);
2756: if p_rec.object_type= 'VACANCY' then
2757: --
2758: hr_utility.set_location(l_proc, 100);
2759: irc_isc_bus.chk_min_qual_level(
2760: p_min_qual_level => p_rec.min_qual_level
2761: ,p_search_criteria_id => p_rec.search_criteria_id
2762: ,p_object_version_number => p_rec.object_version_number
2761: ,p_search_criteria_id => p_rec.search_criteria_id
2762: ,p_object_version_number => p_rec.object_version_number
2763: );
2764: --
2765: hr_utility.set_location(l_proc, 110);
2766: irc_isc_bus.chk_min_salary(
2767: p_min_salary => p_rec.min_salary
2768: ,p_search_criteria_id => p_rec.search_criteria_id
2769: ,p_object_version_number => p_rec.object_version_number
2768: ,p_search_criteria_id => p_rec.search_criteria_id
2769: ,p_object_version_number => p_rec.object_version_number
2770: );
2771: --
2772: hr_utility.set_location(l_proc, 120);
2773: irc_isc_bus.chk_max_salary(
2774: p_max_salary => p_rec.max_salary
2775: ,p_min_salary => p_rec.min_salary
2776: ,p_search_criteria_id => p_rec.search_criteria_id
2776: ,p_search_criteria_id => p_rec.search_criteria_id
2777: ,p_object_version_number => p_rec.object_version_number
2778: );
2779: --
2780: hr_utility.set_location(l_proc, 125);
2781: irc_isc_bus.chk_qual_rank(
2782: p_min_qual_level => p_rec.min_qual_level
2783: ,p_max_qual_level => p_rec.max_qual_level
2784: );
2782: p_min_qual_level => p_rec.min_qual_level
2783: ,p_max_qual_level => p_rec.max_qual_level
2784: );
2785: --
2786: hr_utility.set_location(l_proc, 127);
2787: irc_isc_bus.chk_employee_contractor(
2788: p_employee => p_rec.employee
2789: ,p_contractor => p_rec.contractor
2790: );
2790: );
2791: --
2792: end if;
2793: --
2794: hr_utility.set_location(l_proc, 130);
2795: irc_isc_bus.chk_salary_currency
2796: (p_salary_currency => p_rec.salary_currency
2797: ,p_min_salary => p_rec.min_salary
2798: ,p_max_salary => p_rec.max_salary
2800: ,p_search_criteria_id => p_rec.search_criteria_id
2801: ,p_object_version_number => p_rec.object_version_number
2802: );
2803: --
2804: hr_utility.set_location(l_proc, 135);
2805: irc_isc_bus.chk_salary_period(
2806: p_salary_period => p_rec.salary_period
2807: ,p_min_salary => p_rec.min_salary
2808: ,p_max_salary => p_rec.max_salary
2810: ,p_search_criteria_id => p_rec.search_criteria_id
2811: ,p_object_version_number => p_rec.object_version_number
2812: );
2813: --
2814: hr_utility.set_location(l_proc, 140);
2815: irc_isc_bus.chk_employee(
2816: p_employee => p_rec.employee
2817: ,p_search_criteria_id => p_rec.search_criteria_id
2818: ,p_object_version_number => p_rec.object_version_number
2817: ,p_search_criteria_id => p_rec.search_criteria_id
2818: ,p_object_version_number => p_rec.object_version_number
2819: );
2820: --
2821: hr_utility.set_location(l_proc, 150);
2822: irc_isc_bus.chk_contractor(
2823: p_contractor => p_rec.contractor
2824: ,p_search_criteria_id => p_rec.search_criteria_id
2825: ,p_object_version_number => p_rec.object_version_number
2824: ,p_search_criteria_id => p_rec.search_criteria_id
2825: ,p_object_version_number => p_rec.object_version_number
2826: );
2827: --
2828: hr_utility.set_location(l_proc, 160);
2829: irc_isc_bus.chk_professional_area(
2830: p_professional_area => p_rec.professional_area
2831: ,p_effective_date => p_effective_date
2832: ,p_search_criteria_id => p_rec.search_criteria_id
2832: ,p_search_criteria_id => p_rec.search_criteria_id
2833: ,p_object_version_number => p_rec.object_version_number
2834: );
2835: --
2836: hr_utility.set_location(l_proc, 170);
2837: irc_isc_bus.chk_employment_category(
2838: p_employment_category => p_rec.employment_category
2839: ,p_effective_date => p_effective_date
2840: ,p_search_criteria_id => p_rec.search_criteria_id
2840: ,p_search_criteria_id => p_rec.search_criteria_id
2841: ,p_object_version_number => p_rec.object_version_number
2842: );
2843: --
2844: hr_utility.set_location(l_proc, 180);
2845: irc_isc_bus.chk_work_at_home(
2846: p_work_at_home => p_rec.work_at_home
2847: ,p_effective_date => p_effective_date
2848: ,p_search_criteria_id => p_rec.search_criteria_id
2848: ,p_search_criteria_id => p_rec.search_criteria_id
2849: ,p_object_version_number => p_rec.object_version_number
2850: );
2851: --
2852: hr_utility.set_location(l_proc, 190);
2853: irc_isc_bus.chk_travel_percentage(
2854: p_travel_percentage => p_rec.travel_percentage
2855: ,p_effective_date => p_effective_date
2856: ,p_search_criteria_id => p_rec.search_criteria_id
2856: ,p_search_criteria_id => p_rec.search_criteria_id
2857: ,p_object_version_number => p_rec.object_version_number
2858: );
2859: --
2860: hr_utility.set_location(l_proc, 200);
2861: irc_isc_bus.chk_ddf(p_rec);
2862: --
2863: hr_utility.set_location(l_proc, 210);
2864: irc_isc_bus.chk_df(p_rec);
2859: --
2860: hr_utility.set_location(l_proc, 200);
2861: irc_isc_bus.chk_ddf(p_rec);
2862: --
2863: hr_utility.set_location(l_proc, 210);
2864: irc_isc_bus.chk_df(p_rec);
2865: --
2866: hr_utility.set_location(' Leaving:'||l_proc, 10);
2867: End update_validate;
2862: --
2863: hr_utility.set_location(l_proc, 210);
2864: irc_isc_bus.chk_df(p_rec);
2865: --
2866: hr_utility.set_location(' Leaving:'||l_proc, 10);
2867: End update_validate;
2868: --
2869: -- ----------------------------------------------------------------------------
2870: -- |---------------------------< delete_validate >----------------------------|
2875: --
2876: l_proc varchar2(72) := g_package||'delete_validate';
2877: --
2878: Begin
2879: hr_utility.set_location('Entering:'||l_proc, 5);
2880: --
2881: -- Call all supporting business operations
2882: --
2883: hr_utility.set_location(' Leaving:'||l_proc, 10);
2879: hr_utility.set_location('Entering:'||l_proc, 5);
2880: --
2881: -- Call all supporting business operations
2882: --
2883: hr_utility.set_location(' Leaving:'||l_proc, 10);
2884: End delete_validate;
2885: --
2886: end irc_isc_bus;