[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: fnd_message.raise_error;
2300: --
2301: end if;
2298: fnd_message.set_name('PER', 'IRC_412152_VAC_EMP_CON_WARN');
2299: fnd_message.raise_error;
2300: --
2301: end if;
2302: hr_utility.set_location(' Leaving:'||l_proc,30);
2303: --
2304: exception
2305: when app_exception.application_exception then
2306: if hr_multi_message.exception_add
2305: when app_exception.application_exception then
2306: if hr_multi_message.exception_add
2307: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
2308: ) then
2309: hr_utility.set_location(' Leaving:'||l_proc,60);
2310: raise;
2311: end if;
2312: end chk_employee_contractor;
2313: --
2346: l_api_updating boolean;
2347: l_ret boolean;
2348: --
2349: begin
2350: hr_utility.set_location('Entering:'||l_proc,10);
2351: if p_keywords is not null then
2352: --
2353: hr_utility.set_location(l_proc,20);
2354: l_api_updating := irc_isc_shd.api_updating
2349: begin
2350: hr_utility.set_location('Entering:'||l_proc,10);
2351: if p_keywords is not null then
2352: --
2353: hr_utility.set_location(l_proc,20);
2354: l_api_updating := irc_isc_shd.api_updating
2355: (p_search_criteria_id => p_search_criteria_id
2356: ,p_object_version_number => p_object_version_number
2357: );
2355: (p_search_criteria_id => p_search_criteria_id
2356: ,p_object_version_number => p_object_version_number
2357: );
2358: --
2359: hr_utility.set_location(l_proc,30);
2360: if ((l_api_updating and
2361: p_keywords <>
2362: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)
2363: ) or (NOT l_api_updating)) then
2360: if ((l_api_updating and
2361: p_keywords <>
2362: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)
2363: ) or (NOT l_api_updating)) then
2364: hr_utility.set_location(l_proc,40);
2365: --
2366: -- Check the validity of the keywords by using the
2367: -- procedure irc_query_parser_pkg.isInvalidKeyword()
2368: --
2367: -- procedure irc_query_parser_pkg.isInvalidKeyword()
2368: --
2369: l_ret := irc_query_parser_pkg.isInvalidKeyword (input_text => p_keywords);
2370: if l_ret then
2371: hr_utility.set_location(l_proc,45);
2372: fnd_message.set_name('PER','IRC_INVALID_KEYWORDS');
2373: fnd_message.raise_error;
2374: end if;
2375: end if;
2374: end if;
2375: end if;
2376: end if;
2377: --
2378: hr_utility.set_location(' Leaving:'||l_proc,50);
2379: exception
2380: when app_exception.application_exception then
2381: if hr_multi_message.exception_add
2382: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2380: when app_exception.application_exception then
2381: if hr_multi_message.exception_add
2382: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2383: ) then
2384: hr_utility.set_location(' Leaving:'||l_proc,60);
2385: raise;
2386: end if;
2387: hr_utility.set_location(' Leaving:'||l_proc,70);
2388: end chk_keywords;
2383: ) then
2384: hr_utility.set_location(' Leaving:'||l_proc,60);
2385: raise;
2386: end if;
2387: hr_utility.set_location(' Leaving:'||l_proc,70);
2388: end chk_keywords;
2389: --
2390: -- ----------------------------------------------------------------------------
2391: -- |---------------------------< insert_validate >----------------------------|
2397: --
2398: l_proc varchar2(72) := g_package||'insert_validate';
2399: --
2400: Begin
2401: hr_utility.set_location('Entering:'||l_proc, 5);
2402: --
2403: -- Validate Important Attributes
2404: --
2405: -- Call all supporting business operations
2411: -- one error has been found then abort further validation.
2412: --
2413: -- Validate Dependent Attributes
2414: --
2415: hr_utility.set_location(l_proc, 20);
2416: if p_rec.object_type in ('PERSON','WPREF') then
2417: --
2418: hr_utility.set_location(l_proc, 30);
2419: hr_api.mandatory_arg_error
2414: --
2415: hr_utility.set_location(l_proc, 20);
2416: if p_rec.object_type in ('PERSON','WPREF') then
2417: --
2418: hr_utility.set_location(l_proc, 30);
2419: hr_api.mandatory_arg_error
2420: (p_api_name => l_proc
2421: ,p_argument => 'EFFECTIVE_DATE'
2422: ,p_argument_value => p_effective_date
2421: ,p_argument => 'EFFECTIVE_DATE'
2422: ,p_argument_value => p_effective_date
2423: );
2424: --
2425: hr_utility.set_location(l_proc, 40);
2426: irc_isc_bus.chk_person_id(
2427: p_person_id => p_rec.object_id
2428: ,p_effective_date => p_effective_date
2429: );
2427: p_person_id => p_rec.object_id
2428: ,p_effective_date => p_effective_date
2429: );
2430: --
2431: hr_utility.set_location(l_proc, 50);
2432: irc_isc_bus.chk_search_name(
2433: p_search_name => p_rec.search_name
2434: ,p_person_id => p_rec.object_id
2435: ,p_search_criteria_id => p_rec.search_criteria_id
2435: ,p_search_criteria_id => p_rec.search_criteria_id
2436: ,p_object_version_number => p_rec.object_version_number
2437: );
2438: --
2439: hr_utility.set_location(l_proc, 60);
2440: irc_isc_bus.chk_distance_to_location(
2441: p_distance_to_location => p_rec.distance_to_location
2442: ,p_geocode_location => p_rec.geocode_location
2443: ,p_search_criteria_id => p_rec.search_criteria_id
2443: ,p_search_criteria_id => p_rec.search_criteria_id
2444: ,p_object_version_number => p_rec.object_version_number
2445: );
2446: --
2447: hr_utility.set_location(l_proc, 63);
2448: irc_isc_bus.chk_location_id(
2449: p_location_id => p_rec.location_id
2450: ,p_search_criteria_id => p_rec.search_criteria_id
2451: ,p_object_version_number => p_rec.object_version_number
2450: ,p_search_criteria_id => p_rec.search_criteria_id
2451: ,p_object_version_number => p_rec.object_version_number
2452: );
2453: --
2454: hr_utility.set_location(l_proc, 66);
2455: irc_isc_bus.chk_longitude_latitude(
2456: p_longitude => p_rec.longitude
2457: ,p_latitude => p_rec.latitude
2458: ,p_search_criteria_id => p_rec.search_criteria_id
2458: ,p_search_criteria_id => p_rec.search_criteria_id
2459: ,p_object_version_number => p_rec.object_version_number
2460: );
2461: --
2462: hr_utility.set_location(l_proc, 70);
2463: irc_isc_bus.chk_use_for_matching(
2464: p_use_for_matching => p_rec.use_for_matching
2465: ,p_search_criteria_id => p_rec.search_criteria_id
2466: ,p_object_version_number => p_rec.object_version_number
2465: ,p_search_criteria_id => p_rec.search_criteria_id
2466: ,p_object_version_number => p_rec.object_version_number
2467: );
2468: --
2469: hr_utility.set_location(l_proc, 80);
2470: irc_isc_bus.chk_match_competence(
2471: p_match_competence => p_rec.match_competence
2472: ,p_search_criteria_id => p_rec.search_criteria_id
2473: ,p_object_version_number => p_rec.object_version_number
2472: ,p_search_criteria_id => p_rec.search_criteria_id
2473: ,p_object_version_number => p_rec.object_version_number
2474: );
2475: --
2476: hr_utility.set_location(l_proc, 90);
2477: irc_isc_bus.chk_match_qualification(
2478: p_match_qualification => p_rec.match_qualification
2479: ,p_search_criteria_id => p_rec.search_criteria_id
2480: ,p_object_version_number => p_rec.object_version_number
2479: ,p_search_criteria_id => p_rec.search_criteria_id
2480: ,p_object_version_number => p_rec.object_version_number
2481: );
2482: --
2483: hr_utility.set_location(l_proc, 100);
2484: irc_isc_bus.chk_min_salary(
2485: p_min_salary => p_rec.min_salary
2486: ,p_search_criteria_id => p_rec.search_criteria_id
2487: ,p_object_version_number => p_rec.object_version_number
2489: --
2490: end if;
2491:
2492: if p_rec.object_type= 'WPREF' then
2493: hr_utility.set_location(l_proc, 114);
2494: irc_isc_bus.chk_unique_work (
2495: p_object_id => p_rec.object_id
2496: );
2497: hr_utility.set_location(l_proc, 117);
2493: hr_utility.set_location(l_proc, 114);
2494: irc_isc_bus.chk_unique_work (
2495: p_object_id => p_rec.object_id
2496: );
2497: hr_utility.set_location(l_proc, 117);
2498: irc_isc_bus.chk_work_at_home(
2499: p_work_at_home => p_rec.work_at_home
2500: ,p_effective_date => p_effective_date
2501: ,p_search_criteria_id => p_rec.search_criteria_id
2500: ,p_effective_date => p_effective_date
2501: ,p_search_criteria_id => p_rec.search_criteria_id
2502: ,p_object_version_number => p_rec.object_version_number
2503: );
2504: hr_utility.set_location(l_proc, 119);
2505: irc_isc_bus.chk_keywords(
2506: p_keywords => p_rec.keywords
2507: ,p_search_criteria_id => p_rec.search_criteria_id
2508: ,p_object_version_number => p_rec.object_version_number
2508: ,p_object_version_number => p_rec.object_version_number
2509: );
2510: end if;
2511: --
2512: hr_utility.set_location(l_proc, 110);
2513: if p_rec.object_type= 'VACANCY' then
2514: --
2515: hr_utility.set_location(l_proc, 70);
2516: irc_isc_bus.chk_vacancy_id(
2511: --
2512: hr_utility.set_location(l_proc, 110);
2513: if p_rec.object_type= 'VACANCY' then
2514: --
2515: hr_utility.set_location(l_proc, 70);
2516: irc_isc_bus.chk_vacancy_id(
2517: p_vacancy_id => p_rec.object_id
2518: ,p_effective_date => p_effective_date
2519: );
2517: p_vacancy_id => p_rec.object_id
2518: ,p_effective_date => p_effective_date
2519: );
2520: --
2521: hr_utility.set_location(l_proc, 120);
2522: irc_isc_bus.chk_min_qual_level(
2523: p_min_qual_level => p_rec.min_qual_level
2524: ,p_search_criteria_id => p_rec.search_criteria_id
2525: ,p_object_version_number => p_rec.object_version_number
2524: ,p_search_criteria_id => p_rec.search_criteria_id
2525: ,p_object_version_number => p_rec.object_version_number
2526: );
2527: --
2528: hr_utility.set_location(l_proc, 130);
2529: irc_isc_bus.chk_min_salary(
2530: p_min_salary => p_rec.min_salary
2531: ,p_search_criteria_id => p_rec.search_criteria_id
2532: ,p_object_version_number => p_rec.object_version_number
2531: ,p_search_criteria_id => p_rec.search_criteria_id
2532: ,p_object_version_number => p_rec.object_version_number
2533: );
2534: --
2535: hr_utility.set_location(l_proc, 140);
2536: irc_isc_bus.chk_max_salary(
2537: p_max_salary => p_rec.max_salary
2538: ,p_min_salary => p_rec.min_salary
2539: ,p_search_criteria_id => p_rec.search_criteria_id
2539: ,p_search_criteria_id => p_rec.search_criteria_id
2540: ,p_object_version_number => p_rec.object_version_number
2541: );
2542: --
2543: hr_utility.set_location(l_proc, 145);
2544: irc_isc_bus.chk_qual_rank(
2545: p_min_qual_level => p_rec.min_qual_level
2546: ,p_max_qual_level => p_rec.max_qual_level
2547: );
2545: p_min_qual_level => p_rec.min_qual_level
2546: ,p_max_qual_level => p_rec.max_qual_level
2547: );
2548: --
2549: hr_utility.set_location(l_proc, 147);
2550: irc_isc_bus.chk_employee_contractor(
2551: p_employee => p_rec.employee
2552: ,p_contractor => p_rec.contractor
2553: );
2553: );
2554: --
2555: end if;
2556: --
2557: hr_utility.set_location(l_proc, 150);
2558: irc_isc_bus.chk_salary_currency
2559: (p_salary_currency => p_rec.salary_currency
2560: ,p_min_salary => p_rec.min_salary
2561: ,p_max_salary => p_rec.max_salary
2564: ,p_object_version_number => p_rec.object_version_number
2565: );
2566: --
2567: --
2568: hr_utility.set_location(l_proc, 155);
2569: irc_isc_bus.chk_salary_period(
2570: p_salary_period => p_rec.salary_period
2571: ,p_min_salary => p_rec.min_salary
2572: ,p_max_salary => p_rec.max_salary
2574: ,p_search_criteria_id => p_rec.search_criteria_id
2575: ,p_object_version_number => p_rec.object_version_number
2576: );
2577: --
2578: hr_utility.set_location(l_proc, 160);
2579: irc_isc_bus.chk_employee(
2580: p_employee => p_rec.employee
2581: ,p_search_criteria_id => p_rec.search_criteria_id
2582: ,p_object_version_number => p_rec.object_version_number
2581: ,p_search_criteria_id => p_rec.search_criteria_id
2582: ,p_object_version_number => p_rec.object_version_number
2583: );
2584: --
2585: hr_utility.set_location(l_proc, 170);
2586: irc_isc_bus.chk_contractor(
2587: p_contractor => p_rec.contractor
2588: ,p_search_criteria_id => p_rec.search_criteria_id
2589: ,p_object_version_number => p_rec.object_version_number
2588: ,p_search_criteria_id => p_rec.search_criteria_id
2589: ,p_object_version_number => p_rec.object_version_number
2590: );
2591: --
2592: hr_utility.set_location(l_proc, 180);
2593: irc_isc_bus.chk_professional_area(
2594: p_professional_area => p_rec.professional_area
2595: ,p_effective_date => p_effective_date
2596: ,p_search_criteria_id => p_rec.search_criteria_id
2596: ,p_search_criteria_id => p_rec.search_criteria_id
2597: ,p_object_version_number => p_rec.object_version_number
2598: );
2599: --
2600: hr_utility.set_location(l_proc, 190);
2601: irc_isc_bus.chk_employment_category(
2602: p_employment_category => p_rec.employment_category
2603: ,p_effective_date => p_effective_date
2604: ,p_search_criteria_id => p_rec.search_criteria_id
2604: ,p_search_criteria_id => p_rec.search_criteria_id
2605: ,p_object_version_number => p_rec.object_version_number
2606: );
2607: --
2608: hr_utility.set_location(l_proc, 200);
2609: irc_isc_bus.chk_work_at_home(
2610: p_work_at_home => p_rec.work_at_home
2611: ,p_effective_date => p_effective_date
2612: ,p_search_criteria_id => p_rec.search_criteria_id
2612: ,p_search_criteria_id => p_rec.search_criteria_id
2613: ,p_object_version_number => p_rec.object_version_number
2614: );
2615: --
2616: hr_utility.set_location(l_proc, 210);
2617: irc_isc_bus.chk_travel_percentage(
2618: p_travel_percentage => p_rec.travel_percentage
2619: ,p_effective_date => p_effective_date
2620: ,p_search_criteria_id => p_rec.search_criteria_id
2620: ,p_search_criteria_id => p_rec.search_criteria_id
2621: ,p_object_version_number => p_rec.object_version_number
2622: );
2623: --
2624: hr_utility.set_location(l_proc, 215);
2625: irc_isc_bus.chk_date_posted(
2626: p_date_posted => p_rec.date_posted
2627: ,p_effective_date => p_effective_date
2628: ,p_search_criteria_id => p_rec.search_criteria_id
2628: ,p_search_criteria_id => p_rec.search_criteria_id
2629: ,p_object_version_number => p_rec.object_version_number
2630: );
2631: --
2632: hr_utility.set_location(l_proc, 220);
2633: irc_isc_bus.chk_ddf(p_rec);
2634: --
2635: hr_utility.set_location(l_proc, 230);
2636: irc_isc_bus.chk_df(p_rec);
2631: --
2632: hr_utility.set_location(l_proc, 220);
2633: irc_isc_bus.chk_ddf(p_rec);
2634: --
2635: hr_utility.set_location(l_proc, 230);
2636: irc_isc_bus.chk_df(p_rec);
2637: --
2638: hr_utility.set_location(' Leaving:'||l_proc, 240);
2639: End insert_validate;
2634: --
2635: hr_utility.set_location(l_proc, 230);
2636: irc_isc_bus.chk_df(p_rec);
2637: --
2638: hr_utility.set_location(' Leaving:'||l_proc, 240);
2639: End insert_validate;
2640: --
2641: -- ----------------------------------------------------------------------------
2642: -- |---------------------------< update_validate >----------------------------|
2648: --
2649: l_proc varchar2(72) := g_package||'update_validate';
2650: --
2651: Begin
2652: hr_utility.set_location('Entering:'||l_proc, 10);
2653: --
2654: -- Validate Important Attributes
2655: --
2656: -- Call all supporting business operations
2661: -- one error has been found then abort further validation.
2662: --
2663: -- Validate Dependent Attributes
2664: --
2665: hr_utility.set_location(l_proc,15);
2666: chk_non_updateable_args
2667: (p_effective_date => p_effective_date
2668: ,p_rec => p_rec
2669: );
2668: ,p_rec => p_rec
2669: );
2670: --
2671: --
2672: hr_utility.set_location(l_proc, 20);
2673:
2674: if p_rec.object_type in( 'PERSON','WPREF') then
2675: --
2676: hr_utility.set_location(l_proc, 30);
2672: hr_utility.set_location(l_proc, 20);
2673:
2674: if p_rec.object_type in( 'PERSON','WPREF') then
2675: --
2676: hr_utility.set_location(l_proc, 30);
2677: irc_isc_bus.chk_search_name(
2678: p_search_name => p_rec.search_name
2679: ,p_person_id => p_rec.object_id
2680: ,p_search_criteria_id => p_rec.search_criteria_id
2680: ,p_search_criteria_id => p_rec.search_criteria_id
2681: ,p_object_version_number => p_rec.object_version_number
2682: );
2683: --
2684: hr_utility.set_location(l_proc, 40);
2685: irc_isc_bus.chk_distance_to_location(
2686: p_distance_to_location => p_rec.distance_to_location
2687: ,p_geocode_location => p_rec.geocode_location
2688: ,p_search_criteria_id => p_rec.search_criteria_id
2688: ,p_search_criteria_id => p_rec.search_criteria_id
2689: ,p_object_version_number => p_rec.object_version_number
2690: );
2691: --
2692: hr_utility.set_location(l_proc, 43);
2693: irc_isc_bus.chk_location_id(
2694: p_location_id => p_rec.location_id
2695: ,p_search_criteria_id => p_rec.search_criteria_id
2696: ,p_object_version_number => p_rec.object_version_number
2695: ,p_search_criteria_id => p_rec.search_criteria_id
2696: ,p_object_version_number => p_rec.object_version_number
2697: );
2698: --
2699: hr_utility.set_location(l_proc, 46);
2700: irc_isc_bus.chk_longitude_latitude(
2701: p_longitude => p_rec.longitude
2702: ,p_latitude => p_rec.latitude
2703: ,p_search_criteria_id => p_rec.search_criteria_id
2703: ,p_search_criteria_id => p_rec.search_criteria_id
2704: ,p_object_version_number => p_rec.object_version_number
2705: );
2706: --
2707: hr_utility.set_location(l_proc, 50);
2708: irc_isc_bus.chk_use_for_matching(
2709: p_use_for_matching => p_rec.use_for_matching
2710: ,p_search_criteria_id => p_rec.search_criteria_id
2711: ,p_object_version_number => p_rec.object_version_number
2710: ,p_search_criteria_id => p_rec.search_criteria_id
2711: ,p_object_version_number => p_rec.object_version_number
2712: );
2713: --
2714: hr_utility.set_location(l_proc, 60);
2715: irc_isc_bus.chk_match_competence(
2716: p_match_competence => p_rec.match_competence
2717: ,p_search_criteria_id => p_rec.search_criteria_id
2718: ,p_object_version_number => p_rec.object_version_number
2717: ,p_search_criteria_id => p_rec.search_criteria_id
2718: ,p_object_version_number => p_rec.object_version_number
2719: );
2720: --
2721: hr_utility.set_location(l_proc, 70);
2722: irc_isc_bus.chk_match_qualification(
2723: p_match_qualification => p_rec.match_qualification
2724: ,p_search_criteria_id => p_rec.search_criteria_id
2725: ,p_object_version_number => p_rec.object_version_number
2724: ,p_search_criteria_id => p_rec.search_criteria_id
2725: ,p_object_version_number => p_rec.object_version_number
2726: );
2727: --
2728: hr_utility.set_location(l_proc, 80);
2729: irc_isc_bus.chk_min_salary(
2730: p_min_salary => p_rec.min_salary
2731: ,p_search_criteria_id => p_rec.search_criteria_id
2732: ,p_object_version_number => p_rec.object_version_number
2731: ,p_search_criteria_id => p_rec.search_criteria_id
2732: ,p_object_version_number => p_rec.object_version_number
2733: );
2734: --
2735: hr_utility.set_location(l_proc, 85);
2736: irc_isc_bus.chk_date_posted(
2737: p_date_posted => p_rec.date_posted
2738: ,p_effective_date => p_effective_date
2739: ,p_search_criteria_id => p_rec.search_criteria_id
2742: --
2743: end if;
2744: --
2745: if p_rec.object_type= 'WPREF' then
2746: hr_utility.set_location(l_proc, 87);
2747: irc_isc_bus.chk_work_at_home(
2748: p_work_at_home => p_rec.work_at_home
2749: ,p_effective_date => p_effective_date
2750: ,p_search_criteria_id => p_rec.search_criteria_id
2757: ,p_object_version_number => p_rec.object_version_number
2758: );
2759: end if;
2760: --
2761: hr_utility.set_location(l_proc, 90);
2762: if p_rec.object_type= 'VACANCY' then
2763: --
2764: hr_utility.set_location(l_proc, 100);
2765: irc_isc_bus.chk_min_qual_level(
2760: --
2761: hr_utility.set_location(l_proc, 90);
2762: if p_rec.object_type= 'VACANCY' then
2763: --
2764: hr_utility.set_location(l_proc, 100);
2765: irc_isc_bus.chk_min_qual_level(
2766: p_min_qual_level => p_rec.min_qual_level
2767: ,p_search_criteria_id => p_rec.search_criteria_id
2768: ,p_object_version_number => p_rec.object_version_number
2767: ,p_search_criteria_id => p_rec.search_criteria_id
2768: ,p_object_version_number => p_rec.object_version_number
2769: );
2770: --
2771: hr_utility.set_location(l_proc, 110);
2772: irc_isc_bus.chk_min_salary(
2773: p_min_salary => p_rec.min_salary
2774: ,p_search_criteria_id => p_rec.search_criteria_id
2775: ,p_object_version_number => p_rec.object_version_number
2774: ,p_search_criteria_id => p_rec.search_criteria_id
2775: ,p_object_version_number => p_rec.object_version_number
2776: );
2777: --
2778: hr_utility.set_location(l_proc, 120);
2779: irc_isc_bus.chk_max_salary(
2780: p_max_salary => p_rec.max_salary
2781: ,p_min_salary => p_rec.min_salary
2782: ,p_search_criteria_id => p_rec.search_criteria_id
2782: ,p_search_criteria_id => p_rec.search_criteria_id
2783: ,p_object_version_number => p_rec.object_version_number
2784: );
2785: --
2786: hr_utility.set_location(l_proc, 125);
2787: irc_isc_bus.chk_qual_rank(
2788: p_min_qual_level => p_rec.min_qual_level
2789: ,p_max_qual_level => p_rec.max_qual_level
2790: );
2788: p_min_qual_level => p_rec.min_qual_level
2789: ,p_max_qual_level => p_rec.max_qual_level
2790: );
2791: --
2792: hr_utility.set_location(l_proc, 127);
2793: irc_isc_bus.chk_employee_contractor(
2794: p_employee => p_rec.employee
2795: ,p_contractor => p_rec.contractor
2796: );
2796: );
2797: --
2798: end if;
2799: --
2800: hr_utility.set_location(l_proc, 130);
2801: irc_isc_bus.chk_salary_currency
2802: (p_salary_currency => p_rec.salary_currency
2803: ,p_min_salary => p_rec.min_salary
2804: ,p_max_salary => p_rec.max_salary
2806: ,p_search_criteria_id => p_rec.search_criteria_id
2807: ,p_object_version_number => p_rec.object_version_number
2808: );
2809: --
2810: hr_utility.set_location(l_proc, 135);
2811: irc_isc_bus.chk_salary_period(
2812: p_salary_period => p_rec.salary_period
2813: ,p_min_salary => p_rec.min_salary
2814: ,p_max_salary => p_rec.max_salary
2816: ,p_search_criteria_id => p_rec.search_criteria_id
2817: ,p_object_version_number => p_rec.object_version_number
2818: );
2819: --
2820: hr_utility.set_location(l_proc, 140);
2821: irc_isc_bus.chk_employee(
2822: p_employee => p_rec.employee
2823: ,p_search_criteria_id => p_rec.search_criteria_id
2824: ,p_object_version_number => p_rec.object_version_number
2823: ,p_search_criteria_id => p_rec.search_criteria_id
2824: ,p_object_version_number => p_rec.object_version_number
2825: );
2826: --
2827: hr_utility.set_location(l_proc, 150);
2828: irc_isc_bus.chk_contractor(
2829: p_contractor => p_rec.contractor
2830: ,p_search_criteria_id => p_rec.search_criteria_id
2831: ,p_object_version_number => p_rec.object_version_number
2830: ,p_search_criteria_id => p_rec.search_criteria_id
2831: ,p_object_version_number => p_rec.object_version_number
2832: );
2833: --
2834: hr_utility.set_location(l_proc, 160);
2835: irc_isc_bus.chk_professional_area(
2836: p_professional_area => p_rec.professional_area
2837: ,p_effective_date => p_effective_date
2838: ,p_search_criteria_id => p_rec.search_criteria_id
2838: ,p_search_criteria_id => p_rec.search_criteria_id
2839: ,p_object_version_number => p_rec.object_version_number
2840: );
2841: --
2842: hr_utility.set_location(l_proc, 170);
2843: irc_isc_bus.chk_employment_category(
2844: p_employment_category => p_rec.employment_category
2845: ,p_effective_date => p_effective_date
2846: ,p_search_criteria_id => p_rec.search_criteria_id
2846: ,p_search_criteria_id => p_rec.search_criteria_id
2847: ,p_object_version_number => p_rec.object_version_number
2848: );
2849: --
2850: hr_utility.set_location(l_proc, 180);
2851: irc_isc_bus.chk_work_at_home(
2852: p_work_at_home => p_rec.work_at_home
2853: ,p_effective_date => p_effective_date
2854: ,p_search_criteria_id => p_rec.search_criteria_id
2854: ,p_search_criteria_id => p_rec.search_criteria_id
2855: ,p_object_version_number => p_rec.object_version_number
2856: );
2857: --
2858: hr_utility.set_location(l_proc, 190);
2859: irc_isc_bus.chk_travel_percentage(
2860: p_travel_percentage => p_rec.travel_percentage
2861: ,p_effective_date => p_effective_date
2862: ,p_search_criteria_id => p_rec.search_criteria_id
2862: ,p_search_criteria_id => p_rec.search_criteria_id
2863: ,p_object_version_number => p_rec.object_version_number
2864: );
2865: --
2866: hr_utility.set_location(l_proc, 200);
2867: irc_isc_bus.chk_ddf(p_rec);
2868: --
2869: hr_utility.set_location(l_proc, 210);
2870: irc_isc_bus.chk_df(p_rec);
2865: --
2866: hr_utility.set_location(l_proc, 200);
2867: irc_isc_bus.chk_ddf(p_rec);
2868: --
2869: hr_utility.set_location(l_proc, 210);
2870: irc_isc_bus.chk_df(p_rec);
2871: --
2872: hr_utility.set_location(' Leaving:'||l_proc, 10);
2873: End update_validate;
2868: --
2869: hr_utility.set_location(l_proc, 210);
2870: irc_isc_bus.chk_df(p_rec);
2871: --
2872: hr_utility.set_location(' Leaving:'||l_proc, 10);
2873: End update_validate;
2874: --
2875: -- ----------------------------------------------------------------------------
2876: -- |---------------------------< delete_validate >----------------------------|
2881: --
2882: l_proc varchar2(72) := g_package||'delete_validate';
2883: --
2884: Begin
2885: hr_utility.set_location('Entering:'||l_proc, 5);
2886: --
2887: -- Call all supporting business operations
2888: --
2889: hr_utility.set_location(' Leaving:'||l_proc, 10);
2885: hr_utility.set_location('Entering:'||l_proc, 5);
2886: --
2887: -- Call all supporting business operations
2888: --
2889: hr_utility.set_location(' Leaving:'||l_proc, 10);
2890: End delete_validate;
2891: --
2892: end irc_isc_bus;