[Home] [Help]
176: l_future_asgs_count INTEGER := 0;
177: --
178: BEGIN
179: --
180: hr_utility.set_location('Entering:'||l_proc,10);
181: --
182: FOR l_future_asgs_rec IN
183: csr_future_asgs
184: (p_person_id => p_person_id
188: LOOP
189: l_future_asgs_count := l_future_asgs_count + 1;
190: END LOOP;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc,100);
193: --
194: RETURN(l_future_asgs_count);
195: --
196: EXCEPTION
248: l_nonaccepted_asgs_count INTEGER := 0;
249: --
250: BEGIN
251: --
252: hr_utility.set_location('Entering:'||l_proc,10);
253: --
254: FOR l_nonaccepted_asgs_rec IN
255: csr_nonaccepted_asgs
256: (p_person_id => p_person_id
259: LOOP
260: l_nonaccepted_asgs_count := l_nonaccepted_asgs_count + 1;
261: END LOOP;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc,100);
264: --
265: RETURN(l_nonaccepted_asgs_count);
266: --
267: EXCEPTION
319: l_accepted_asgs_count INTEGER := 0;
320: --
321: BEGIN
322: --
323: hr_utility.set_location('Entering:'||l_proc,10);
324: --
325: FOR l_accepted_asgs_rec IN
326: csr_accepted_asgs
327: (p_person_id => p_person_id
330: LOOP
331: l_accepted_asgs_count := l_accepted_asgs_count + 1;
332: END LOOP;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc,100);
335: --
336: RETURN(l_accepted_asgs_count);
337: --
338: EXCEPTION
390: l_primary_asgs_count INTEGER := 0;
391: --
392: BEGIN
393: --
394: hr_utility.set_location('Entering:'||l_proc,10);
395: --
396: FOR l_primary_asgs_rec IN
397: csr_primary_asgs
398: (p_person_id => p_person_id
401: LOOP
402: l_primary_asgs_count := l_primary_asgs_count + 1;
403: END LOOP;
404: --
405: hr_utility.set_location(' Leaving:'||l_proc,100);
406: --
407: RETURN(l_primary_asgs_count);
408: --
409: EXCEPTION
459: l_per_details_rec csr_per_details%ROWTYPE;
460: --
461: BEGIN
462: --
463: hr_utility.set_location('Entering:'||l_proc,10);
464: --
465: OPEN csr_per_details
466: (p_person_id => p_person_id
467: ,p_effective_date => p_effective_date
468: );
469: FETCH csr_per_details INTO l_per_details_rec;
470: IF csr_per_details%NOTFOUND
471: THEN
472: hr_utility.set_location(l_proc,20);
473: CLOSE csr_per_details;
474: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
475: hr_utility.raise_error;
476: END IF;
470: IF csr_per_details%NOTFOUND
471: THEN
472: hr_utility.set_location(l_proc,20);
473: CLOSE csr_per_details;
474: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
475: hr_utility.raise_error;
476: END IF;
477: CLOSE csr_per_details;
478: --
471: THEN
472: hr_utility.set_location(l_proc,20);
473: CLOSE csr_per_details;
474: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
475: hr_utility.raise_error;
476: END IF;
477: CLOSE csr_per_details;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc,100);
475: hr_utility.raise_error;
476: END IF;
477: CLOSE csr_per_details;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc,100);
480: --
481: RETURN(l_per_details_rec);
482: --
483: EXCEPTION
532: l_apl_details_rec csr_apl_details%ROWTYPE;
533: --
534: BEGIN
535: --
536: hr_utility.set_location('Entering:'||l_proc,10);
537: --
538: OPEN csr_apl_details
539: (p_person_id => p_person_id
540: ,p_effective_date => p_effective_date
541: );
542: FETCH csr_apl_details INTO l_apl_details_rec;
543: CLOSE csr_apl_details;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc,100);
546: --
547: RETURN(l_apl_details_rec);
548: --
549: EXCEPTION
598: l_pds_details_rec csr_pds_details%ROWTYPE;
599: --
600: BEGIN
601: --
602: hr_utility.set_location('Entering:'||l_proc,10);
603: --
604: OPEN csr_pds_details
605: (p_person_id => p_person_id
606: ,p_effective_date => p_effective_date
607: );
608: FETCH csr_pds_details INTO l_pds_details_rec;
609: CLOSE csr_pds_details;
610: --
611: hr_utility.set_location(' Leaving:'||l_proc,100);
612: --
613: RETURN(l_pds_details_rec);
614: --
615: EXCEPTION
655: l_oversubscribed_vacancy_id number;
656: --
657: BEGIN
658: --
659: hr_utility.set_location('Entering:'||l_proc,10);
660: --
661: l_per_object_version_number:= p_per_object_version_number;
662: l_employee_number:= p_employee_number;
663: --
681: p_per_effective_start_date:=l_per_effective_start_date;
682: p_per_effective_end_date:=l_per_effective_end_date;
683: p_assign_payroll_warning:=l_assign_payroll_warning;
684: --
685: hr_utility.set_location('Leaving:'||l_proc,20);
686: --
687: end hire_to_employee_applicant;
688: --
689: -- -----------------------------------------------------------------------------
720: l_oversubscribed_vacancy_id number;
721: --
722: BEGIN
723: --
724: hr_utility.set_location('Entering:'||l_proc,10);
725: --
726: l_per_object_version_number:= p_per_object_version_number;
727: l_employee_number:= p_employee_number;
728: --
746: p_per_effective_start_date:=l_per_effective_start_date;
747: p_per_effective_end_date:=l_per_effective_end_date;
748: p_assign_payroll_warning:=l_assign_payroll_warning;
749: --
750: hr_utility.set_location('Leaving:'||l_proc,20);
751: --
752: end hire_to_employee_applicant;
753:
754: --
776: l_proc VARCHAR2(72) := g_package||'hire_to_employee_applicant';
777:
778: BEGIN
779:
780: hr_utility.set_location('Entering:'||l_proc,10);
781:
782: hr_employee_applicant_api.hire_to_employee_applicant
783: (p_validate => p_validate
784: ,p_hire_date => p_hire_date
794: ,p_oversubscribed_vacancy_id => p_oversubscribed_vacancy_id
795: ,p_upload_irec_docs => 'N'
796: );
797:
798: hr_utility.set_location('Leaving:'||l_proc,20);
799:
800: END;
801: -- End changes for bug 9879782
802:
941: ---- Fix For ER: 6136609 Starts ----
942:
943: l_autoApprove:=fnd_profile.value('HR_AUTO_APPROVE_FIRST_PROPOSAL');
944: if(l_autoApprove is null or l_autoApprove ='Y') then
945: hr_utility.set_location(l_proc, 32);
946: l_approved_flag:='Y';
947: end if;
948:
949: ---- Fix For ER: 6136609 Ends ----
964: ---- Fix For Bug: 12612530 Ends ----
965: --
966: BEGIN
967: --
968: hr_utility.set_location('Entering:'||l_proc,10);
969: --
970: -- Ensure mandatory arguments have been passed
971: --
972: hr_api.mandatory_arg_error
988: -- Issue savepoint
989: --
990: SAVEPOINT hire_to_employee_applicant;
991: --
992: hr_utility.set_location(l_proc,20);
993: --
994: -- Get the derived details for the person on the hire date
995: --
996: l_per_details_rec := per_details
997: (p_person_id => p_person_id
998: ,p_effective_date => l_hire_date
999: );
1000: --
1001: hr_utility.set_location(l_proc,40);
1002: --
1003: -- 2264191 changed behaviour: single asg hire requires the assignment id.
1004: -- only hire all accepted if passed the 'Y' flag, not for any other value
1005: -- 'Y' replicates the old behaviour
1007: IF p_hire_all_accepted_asgs is null
1008: OR ( p_hire_all_accepted_asgs <> 'Y'
1009: AND p_hire_all_accepted_asgs is not null)
1010: THEN
1011: hr_utility.set_location(l_proc,45);
1012: l_hire_all_accepted_asgs := 'N';
1013: l_hire_single_asg_id := p_assignment_id;
1014: hr_api.mandatory_arg_error
1015: (p_api_name => l_proc
1042: ,p_hook_type => 'BP'
1043: );
1044: END;
1045: --
1046: hr_utility.set_location(l_proc,50);
1047: --
1048: -- Check the person is of a correct system person type
1049: --
1050: IF l_per_details_rec.system_person_type NOT IN
1049: --
1050: IF l_per_details_rec.system_person_type NOT IN
1051: ('APL','EMP_APL','EX_EMP_APL','APL_EX_APL')
1052: THEN
1053: hr_utility.set_location(l_proc,60);
1054: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
1055: hr_utility.raise_error;
1056: END IF;
1057: --
1050: IF l_per_details_rec.system_person_type NOT IN
1051: ('APL','EMP_APL','EX_EMP_APL','APL_EX_APL')
1052: THEN
1053: hr_utility.set_location(l_proc,60);
1054: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
1055: hr_utility.raise_error;
1056: END IF;
1057: --
1058: hr_utility.set_location(l_proc,70);
1051: ('APL','EMP_APL','EX_EMP_APL','APL_EX_APL')
1052: THEN
1053: hr_utility.set_location(l_proc,60);
1054: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
1055: hr_utility.raise_error;
1056: END IF;
1057: --
1058: hr_utility.set_location(l_proc,70);
1059: --
1054: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
1055: hr_utility.raise_error;
1056: END IF;
1057: --
1058: hr_utility.set_location(l_proc,70);
1059: --
1060: -- Ensure the employee number will not be changed if it exists
1061: --
1062: IF l_per_details_rec.employee_number IS NOT NULL
1061: --
1062: IF l_per_details_rec.employee_number IS NOT NULL
1063: AND NVL(p_employee_number,hr_api.g_number) <> l_per_details_rec.employee_number
1064: THEN
1065: hr_utility.set_location(l_proc,80);
1066: p_employee_number := l_per_details_rec.employee_number;
1067: END IF;
1068: --
1069: hr_utility.set_location(l_proc,90);
1065: hr_utility.set_location(l_proc,80);
1066: p_employee_number := l_per_details_rec.employee_number;
1067: END IF;
1068: --
1069: hr_utility.set_location(l_proc,90);
1070: --
1071: -- Check the person does not have future assignment changes
1072: --
1073: IF l_hire_all_accepted_asgs = 'Y' then
1083: );
1084: END IF;
1085: IF l_future_asgs_count > 0
1086: THEN
1087: hr_utility.set_location(l_proc,100);
1088: hr_utility.set_message(800,'HR_7975_ASG_INV_FUTURE_ASA');
1089: hr_utility.raise_error;
1090: END IF;
1091: --
1084: END IF;
1085: IF l_future_asgs_count > 0
1086: THEN
1087: hr_utility.set_location(l_proc,100);
1088: hr_utility.set_message(800,'HR_7975_ASG_INV_FUTURE_ASA');
1089: hr_utility.raise_error;
1090: END IF;
1091: --
1092: hr_utility.set_location(l_proc,110);
1085: IF l_future_asgs_count > 0
1086: THEN
1087: hr_utility.set_location(l_proc,100);
1088: hr_utility.set_message(800,'HR_7975_ASG_INV_FUTURE_ASA');
1089: hr_utility.raise_error;
1090: END IF;
1091: --
1092: hr_utility.set_location(l_proc,110);
1093: --
1088: hr_utility.set_message(800,'HR_7975_ASG_INV_FUTURE_ASA');
1089: hr_utility.raise_error;
1090: END IF;
1091: --
1092: hr_utility.set_location(l_proc,110);
1093: --
1094: -- If person type id is not null check it corresponds to type EMP_APL is
1095: -- currently active and in the correct business group, otherwise set person
1096: -- type id to the active default for EMP_APL in the correct business group
1104: ,p_business_group_id => l_per_details_rec.business_group_id
1105: ,p_expected_sys_type => l_system_person_type
1106: );
1107: */ --
1108: hr_utility.set_location(l_proc,120);
1109: --
1110: -- 2264191 changed behaviour: If hiring all accepted, ensure there are some nonaccepted
1111: -- applicant assignments that will remain for the person to be an applicant for.
1112: --
1116: );
1117: IF l_nonaccepted_asgs_count = 0
1118: AND l_hire_all_accepted_asgs = 'Y'
1119: THEN
1120: hr_utility.set_location(l_proc,130);
1121: hr_utility.set_message(800,'HR_289149_NOHIR_NO_UNACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1122: hr_utility.raise_error;
1123: END IF;
1124: --
1117: IF l_nonaccepted_asgs_count = 0
1118: AND l_hire_all_accepted_asgs = 'Y'
1119: THEN
1120: hr_utility.set_location(l_proc,130);
1121: hr_utility.set_message(800,'HR_289149_NOHIR_NO_UNACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1122: hr_utility.raise_error;
1123: END IF;
1124: --
1125: hr_utility.set_location(l_proc,140);
1118: AND l_hire_all_accepted_asgs = 'Y'
1119: THEN
1120: hr_utility.set_location(l_proc,130);
1121: hr_utility.set_message(800,'HR_289149_NOHIR_NO_UNACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1122: hr_utility.raise_error;
1123: END IF;
1124: --
1125: hr_utility.set_location(l_proc,140);
1126: --
1121: hr_utility.set_message(800,'HR_289149_NOHIR_NO_UNACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1122: hr_utility.raise_error;
1123: END IF;
1124: --
1125: hr_utility.set_location(l_proc,140);
1126: --
1127: -- Ensure there are some accepted applicant assignments for the person to be
1128: -- hired into (applies pre and post 2264191)
1129: --
1132: ,p_effective_date => l_hire_date
1133: );
1134: IF l_accepted_asgs_count = 0
1135: THEN
1136: hr_utility.set_location(l_proc,150);
1137: hr_utility.set_message(800,'HR_289150_NOHIR_NO_ACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1138: hr_utility.raise_error;
1139: END IF;
1140: --
1133: );
1134: IF l_accepted_asgs_count = 0
1135: THEN
1136: hr_utility.set_location(l_proc,150);
1137: hr_utility.set_message(800,'HR_289150_NOHIR_NO_ACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1138: hr_utility.raise_error;
1139: END IF;
1140: --
1141: -- 2264191 changed behaviour: If hiring a single assignment
1134: IF l_accepted_asgs_count = 0
1135: THEN
1136: hr_utility.set_location(l_proc,150);
1137: hr_utility.set_message(800,'HR_289150_NOHIR_NO_ACCEPTED'); --'PER_52098_APL_INV_ASG_STATUS');
1138: hr_utility.raise_error;
1139: END IF;
1140: --
1141: -- 2264191 changed behaviour: If hiring a single assignment
1142: -- ensure that there is more than one APL assignment to retain
1143: --
1144: IF l_hire_all_accepted_asgs = 'N'
1145: AND l_accepted_asgs_count + l_nonaccepted_asgs_count < 2
1146: THEN
1147: hr_utility.set_location(l_proc,155);
1148: hr_utility.set_message(800,'HR_289151_NOHIR_SGL_NO_RETAIN');
1149: hr_utility.raise_error;
1150: END IF;
1151: --
1144: IF l_hire_all_accepted_asgs = 'N'
1145: AND l_accepted_asgs_count + l_nonaccepted_asgs_count < 2
1146: THEN
1147: hr_utility.set_location(l_proc,155);
1148: hr_utility.set_message(800,'HR_289151_NOHIR_SGL_NO_RETAIN');
1149: hr_utility.raise_error;
1150: END IF;
1151: --
1152: hr_utility.set_location(l_proc,160);
1145: AND l_accepted_asgs_count + l_nonaccepted_asgs_count < 2
1146: THEN
1147: hr_utility.set_location(l_proc,155);
1148: hr_utility.set_message(800,'HR_289151_NOHIR_SGL_NO_RETAIN');
1149: hr_utility.raise_error;
1150: END IF;
1151: --
1152: hr_utility.set_location(l_proc,160);
1153: --
1148: hr_utility.set_message(800,'HR_289151_NOHIR_SGL_NO_RETAIN');
1149: hr_utility.raise_error;
1150: END IF;
1151: --
1152: hr_utility.set_location(l_proc,160);
1153: --
1154: -- 2264191 changed behaviour: Ensure the assignment id has been set
1155: -- if either no current primary employee
1156: -- assignment and multiple accepted applicant assignment exist, or if hiring a single
1163: );
1164: IF l_primary_asgs_count = 0
1165: AND l_hire_all_accepted_asgs = 'Y' --replicate the behaviour pre2264191
1166: THEN
1167: hr_utility.set_location(l_proc,170);
1168: IF p_assignment_id IS NULL
1169: THEN
1170: hr_utility.set_location(l_proc,180);
1171: IF l_accepted_asgs_count = 1
1166: THEN
1167: hr_utility.set_location(l_proc,170);
1168: IF p_assignment_id IS NULL
1169: THEN
1170: hr_utility.set_location(l_proc,180);
1171: IF l_accepted_asgs_count = 1
1172: THEN
1173: hr_utility.set_location(l_proc,190);
1174: OPEN csr_accepted_asgs
1169: THEN
1170: hr_utility.set_location(l_proc,180);
1171: IF l_accepted_asgs_count = 1
1172: THEN
1173: hr_utility.set_location(l_proc,190);
1174: OPEN csr_accepted_asgs
1175: (p_person_id => p_person_id
1176: ,p_effective_date => l_hire_date
1177: );
1178: FETCH csr_accepted_asgs INTO l_accepted_asgs_rec;
1179: CLOSE csr_accepted_asgs;
1180: l_new_primary_asg_id := l_accepted_asgs_rec.assignment_id;
1181: ELSE
1182: hr_utility.set_location(l_proc,200);
1183: hr_api.mandatory_arg_error
1184: (p_api_name => l_proc
1185: ,p_argument => 'assignment_id'
1186: ,p_argument_value => p_assignment_id);
1190: END IF;
1191: ELSIF l_primary_asgs_count = 0 --2264191 hiring single asg, must make it primary
1192: AND l_hire_all_accepted_asgs = 'N'
1193: THEN
1194: hr_utility.set_location(l_proc,205);
1195: l_new_primary_asg_id := p_assignment_id;
1196: ELSE -- a primary already exists
1197: hr_utility.set_location(l_proc,210);
1198: --IF p_assignment_id IS NOT NULL
1193: THEN
1194: hr_utility.set_location(l_proc,205);
1195: l_new_primary_asg_id := p_assignment_id;
1196: ELSE -- a primary already exists
1197: hr_utility.set_location(l_proc,210);
1198: --IF p_assignment_id IS NOT NULL
1199: --THEN
1200: hr_utility.set_location(l_proc,220);
1201: l_new_primary_asg_id := NULL;
1196: ELSE -- a primary already exists
1197: hr_utility.set_location(l_proc,210);
1198: --IF p_assignment_id IS NOT NULL
1199: --THEN
1200: hr_utility.set_location(l_proc,220);
1201: l_new_primary_asg_id := NULL;
1202: --END IF;
1203: END IF;
1204: --
1201: l_new_primary_asg_id := NULL;
1202: --END IF;
1203: END IF;
1204: --
1205: hr_utility.set_location(l_proc,230);
1206: --
1207: -- Ensure any assignment id specified is for the person, has an assignment
1208: -- type of A and a system status of ACCEPTED on the hire date
1209: --
1208: -- type of A and a system status of ACCEPTED on the hire date
1209: --
1210: IF p_assignment_id IS NOT NULL
1211: THEN
1212: hr_utility.set_location(l_proc,240);
1213: OPEN csr_accepted_asgs
1214: (p_person_id => p_person_id
1215: ,p_effective_date => l_hire_date
1216: ,p_assignment_id => p_assignment_id
1217: );
1218: FETCH csr_accepted_asgs INTO l_accepted_asgs_rec;
1219: IF csr_accepted_asgs%NOTFOUND
1220: THEN
1221: hr_utility.set_location(l_proc,250);
1222: CLOSE csr_accepted_asgs;
1223: hr_utility.set_message(800,'HR_289152_NOHIR_ACCEPT_APL_ASG'); --'PER_52099_ASG_INV_ASG_ID');
1224: hr_utility.raise_error;
1225: END IF;
1219: IF csr_accepted_asgs%NOTFOUND
1220: THEN
1221: hr_utility.set_location(l_proc,250);
1222: CLOSE csr_accepted_asgs;
1223: hr_utility.set_message(800,'HR_289152_NOHIR_ACCEPT_APL_ASG'); --'PER_52099_ASG_INV_ASG_ID');
1224: hr_utility.raise_error;
1225: END IF;
1226: CLOSE csr_accepted_asgs;
1227: END IF;
1220: THEN
1221: hr_utility.set_location(l_proc,250);
1222: CLOSE csr_accepted_asgs;
1223: hr_utility.set_message(800,'HR_289152_NOHIR_ACCEPT_APL_ASG'); --'PER_52099_ASG_INV_ASG_ID');
1224: hr_utility.raise_error;
1225: END IF;
1226: CLOSE csr_accepted_asgs;
1227: END IF;
1228: --
1225: END IF;
1226: CLOSE csr_accepted_asgs;
1227: END IF;
1228: --
1229: hr_utility.set_location(l_proc,260);
1230:
1231: -- Start changes for bug 9879782
1232: if p_upload_irec_docs = 'Y' and p_validate = false then
1233: hr_utility.set_location('l_new_primary_asg_id'||l_new_primary_asg_id,326);
1229: hr_utility.set_location(l_proc,260);
1230:
1231: -- Start changes for bug 9879782
1232: if p_upload_irec_docs = 'Y' and p_validate = false then
1233: hr_utility.set_location('l_new_primary_asg_id'||l_new_primary_asg_id,326);
1234: hr_utility.set_location('p_assignment_id'||p_assignment_id,326);
1235:
1236: open csr_get_appl_id(nvl(p_assignment_id,l_new_primary_asg_id));
1237: fetch csr_get_appl_id into l_appl_id;
1230:
1231: -- Start changes for bug 9879782
1232: if p_upload_irec_docs = 'Y' and p_validate = false then
1233: hr_utility.set_location('l_new_primary_asg_id'||l_new_primary_asg_id,326);
1234: hr_utility.set_location('p_assignment_id'||p_assignment_id,326);
1235:
1236: open csr_get_appl_id(nvl(p_assignment_id,l_new_primary_asg_id));
1237: fetch csr_get_appl_id into l_appl_id;
1238: close csr_get_appl_id;
1236: open csr_get_appl_id(nvl(p_assignment_id,l_new_primary_asg_id));
1237: fetch csr_get_appl_id into l_appl_id;
1238: close csr_get_appl_id;
1239:
1240: hr_utility.set_location('l_appl_id'||l_appl_id,326);
1241:
1242: per_fnd_attachment_pkg.upload_irec_docs(
1243: p_person_id => p_PERSON_ID,
1244: p_assignment_id => nvl(p_assignment_id,l_new_primary_asg_id),
1261: -- Update the person details to the new person type, if it has changed
1262: --
1263: IF l_per_details_rec.person_type_id <> l_person_type_id1
1264: THEN
1265: hr_utility.set_location(l_proc,270);
1266: --2931560 added check for future person changes
1267: open csr_future_per_changes(l_hire_date);
1268: fetch csr_future_per_changes into l_dummy;
1269: if csr_future_per_changes%found then
1267: open csr_future_per_changes(l_hire_date);
1268: fetch csr_future_per_changes into l_dummy;
1269: if csr_future_per_changes%found then
1270: close csr_future_per_changes;
1271: -- hr_utility.set_message('PER','HR_289729_FUT_PER_NOHIR');
1272: hr_utility.set_message(800,'HR_289729_FUT_PER_NOHIR'); -- Bug 2931560
1273: hr_utility.raise_error;
1274: else
1275: close csr_future_per_changes;
1268: fetch csr_future_per_changes into l_dummy;
1269: if csr_future_per_changes%found then
1270: close csr_future_per_changes;
1271: -- hr_utility.set_message('PER','HR_289729_FUT_PER_NOHIR');
1272: hr_utility.set_message(800,'HR_289729_FUT_PER_NOHIR'); -- Bug 2931560
1273: hr_utility.raise_error;
1274: else
1275: close csr_future_per_changes;
1276: end if;
1269: if csr_future_per_changes%found then
1270: close csr_future_per_changes;
1271: -- hr_utility.set_message('PER','HR_289729_FUT_PER_NOHIR');
1272: hr_utility.set_message(800,'HR_289729_FUT_PER_NOHIR'); -- Bug 2931560
1273: hr_utility.raise_error;
1274: else
1275: close csr_future_per_changes;
1276: end if;
1277: --
1296: ,p_orig_hire_warning => l_orig_hire_warning
1297: ,p_npw_number => l_per_details_rec.npw_number
1298: );
1299: ELSE
1300: hr_utility.set_location(l_proc,280);
1301: l_per_effective_start_date := l_per_details_rec.effective_start_date;
1302: l_per_effective_end_date := l_per_details_rec.effective_end_date;
1303: END IF;
1304: --
1302: l_per_effective_end_date := l_per_details_rec.effective_end_date;
1303: END IF;
1304: --
1305: --
1306: hr_utility.set_location(l_proc,290);
1307: --
1308: -- Derive the current period of service, and create one if it does not exist
1309: --
1310: l_pds_details_rec := pds_details
1312: ,p_effective_date => l_hire_date
1313: );
1314: IF l_pds_details_rec.period_of_service_id IS NULL
1315: THEN
1316: hr_utility.set_location(l_proc,300);
1317: per_pds_ins.ins
1318: (p_person_id => p_person_id
1319: ,p_business_group_id => l_per_details_rec.business_group_id
1320: ,p_date_start => l_hire_date
1363: END IF;
1364: --
1365: -- PTU : End of changes
1366: --
1367: hr_utility.set_location(l_proc,310);
1368: --
1369: -- Derive assignment status type id for default system status type of
1370: -- ACTIVE_ASSIGN for this business group
1371: --
1375: ,p_legislation_code => l_per_details_rec.legislation_code
1376: ,p_expected_system_status => 'ACTIVE_ASSIGN'
1377: );
1378: --
1379: hr_utility.set_location(l_proc,320);
1380: --
1381: l_oversubscribed_vacancy_id :=null;
1382: --
1383: -- 2264191 changed behaviour: If p_hire_all_accepted_asgs = 'Y' then
1443: --
1444: END IF; --end of test if processing all asgs or matching single asg
1445: END LOOP;
1446: --
1447: hr_utility.set_location(l_proc,325);
1448: --
1449: -- Maintain person type usage record
1450: --
1451: /* Removed for PTU changes, since covered by previous call to maintain
1459: ,p_object_version_number => l_object_version_number
1460: );
1461: */
1462: --
1463: hr_utility.set_location(l_proc,330);
1464:
1465: -- Start chagnes for bug 9879782
1466: if p_upload_irec_docs = 'Y' and p_validate = false then
1467:
1477: p_adjustment_type => 'COMMIT');
1478: end if;
1479: -- End chagnes for bug 9879782
1480:
1481: hr_utility.set_location(l_proc,340);
1482: --
1483: -- Call After Process User Hook
1484: --
1485: BEGIN
1506: ,p_hook_type => 'AP'
1507: );
1508: END;
1509: --
1510: hr_utility.set_location(l_proc,340);
1511: --
1512: -- When in validation only mode raise validate_enabled exception
1513: --
1514: IF p_validate
1524: p_per_effective_end_date := l_per_effective_end_date;
1525: p_assign_payroll_warning := l_assign_payroll_warning;
1526: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id ;
1527: --
1528: hr_utility.set_location(' Leaving:'||l_proc,1000);
1529: --
1530: EXCEPTION
1531: --
1532: WHEN hr_api.validate_enabled
1604: l_oversubscribed_vacancy_id number;
1605: --
1606: begin
1607: --
1608: hr_utility.set_location('Entering:'|| l_proc, 10);
1609: --
1610: l_per_object_version_number:=p_per_object_version_number;
1611: --
1612: hr_employee_applicant_api.hire_employee_applicant
1627: p_per_effective_end_date := l_per_effective_end_date;
1628: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
1629: p_assign_payroll_warning := l_assign_payroll_warning;
1630: --
1631: hr_utility.set_location('Leaving:'|| l_proc, 20);
1632: --
1633: end hire_employee_applicant;
1634:
1635: --
1655: is
1656: l_proc varchar2(72) := g_package||'hire_employee_applicant';
1657: BEGIN
1658:
1659: hr_utility.set_location('Entering:'|| l_proc, 10);
1660:
1661: hr_employee_applicant_api.hire_employee_applicant
1662: (p_validate => p_validate
1663: ,p_hire_date => p_hire_date
1673: ,p_oversubscribed_vacancy_id => p_oversubscribed_vacancy_id
1674: ,p_upload_irec_docs => 'N'
1675: );
1676:
1677: hr_utility.set_location('Leaving:'|| l_proc, 20);
1678:
1679: END;
1680: -- End changes for bug 9879782
1681: --
2038: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
2039: -- ER FPT
2040:
2041: begin
2042: hr_utility.set_location('Entering:'|| l_proc, 10);
2043: --
2044: hr_api.mandatory_arg_error
2045: (p_api_name => l_proc
2046: ,p_argument => 'person_id'
2056: -- Issue a savepoint.
2057: --
2058: savepoint hire_employee_applicant;
2059: --
2060: hr_utility.set_location(l_proc, 20);
2061: --
2062: -- Process Logic
2063: --
2064: -- Truncate the time portion from all date parameters
2091: end;
2092: --
2093: -- Check that there are not any future changes to the assignment
2094: --
2095: hr_utility.set_location(l_proc, 30);
2096: -- ER FPT
2097: open csr_future_asg_changes;
2098: fetch csr_future_asg_changes into l_exists;
2099: if csr_future_asg_changes%FOUND then
2097: open csr_future_asg_changes;
2098: fetch csr_future_asg_changes into l_exists;
2099: if csr_future_asg_changes%FOUND then
2100: --
2101: hr_utility.set_location(l_proc,40);
2102: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2103: open fpt_future_asg_changes;
2104: fetch fpt_future_asg_changes into l_exists;
2105: if fpt_future_asg_changes%found then
2102: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2103: open fpt_future_asg_changes;
2104: fetch fpt_future_asg_changes into l_exists;
2105: if fpt_future_asg_changes%found then
2106: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2107: hr_utility.raise_error;
2108: end if;
2109: close fpt_future_asg_changes;
2110: else
2103: open fpt_future_asg_changes;
2104: fetch fpt_future_asg_changes into l_exists;
2105: if fpt_future_asg_changes%found then
2106: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2107: hr_utility.raise_error;
2108: end if;
2109: close fpt_future_asg_changes;
2110: else
2111: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2107: hr_utility.raise_error;
2108: end if;
2109: close fpt_future_asg_changes;
2110: else
2111: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2112: hr_utility.raise_error;
2113: end if;
2114: end if;
2115: close csr_future_asg_changes;
2108: end if;
2109: close fpt_future_asg_changes;
2110: else
2111: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2112: hr_utility.raise_error;
2113: end if;
2114: end if;
2115: close csr_future_asg_changes;
2116: --
2113: end if;
2114: end if;
2115: close csr_future_asg_changes;
2116: --
2117: hr_utility.set_location(l_proc,45);
2118: --
2119: -- Get the derived details for the person DT instance
2120: --
2121: open csr_get_devived_details;
2130: l_apl_object_version_number;
2131: if csr_get_devived_details%NOTFOUND
2132: then
2133: --
2134: hr_utility.set_location(l_proc,50);
2135: --
2136: close csr_get_devived_details;
2137: --
2138: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
2134: hr_utility.set_location(l_proc,50);
2135: --
2136: close csr_get_devived_details;
2137: --
2138: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
2139: hr_utility.raise_error;
2140: --
2141: end if;
2142: close csr_get_devived_details;
2135: --
2136: close csr_get_devived_details;
2137: --
2138: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
2139: hr_utility.raise_error;
2140: --
2141: end if;
2142: close csr_get_devived_details;
2143: --
2140: --
2141: end if;
2142: close csr_get_devived_details;
2143: --
2144: hr_utility.set_location(l_proc,55);
2145: --
2146: -- Validation in addition to Row Handlers
2147: --
2148: -- If the specified person type id is not null then check that it
2155: ,p_business_group_id => l_business_group_id
2156: ,p_expected_sys_type => 'EMP'
2157: );
2158: --
2159: hr_utility.set_location(l_proc,60);
2160: --
2161: -- Check that corresponding person is of 'EMP_APL'
2162: -- system person type.
2163: --
2163: --
2164: if l_system_person_type <> 'EMP_APL'
2165: then
2166: --
2167: hr_utility.set_location(l_proc,70);
2168: --
2169: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2170: hr_utility.raise_error;
2171: end if;
2165: then
2166: --
2167: hr_utility.set_location(l_proc,70);
2168: --
2169: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2170: hr_utility.raise_error;
2171: end if;
2172: --
2173: hr_utility.set_location(l_proc,80);
2166: --
2167: hr_utility.set_location(l_proc,70);
2168: --
2169: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2170: hr_utility.raise_error;
2171: end if;
2172: --
2173: hr_utility.set_location(l_proc,80);
2174: --
2169: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2170: hr_utility.raise_error;
2171: end if;
2172: --
2173: hr_utility.set_location(l_proc,80);
2174: --
2175: -- Check that corresponding person is of 'ACCEPTED' of
2176: -- assignment status type.
2177: --
2180: --close csr_chk_asg_status; -- Bug 3266844. Commented out.
2181: --
2182: if l_count = 0 then
2183: --
2184: hr_utility.set_location(l_proc,90);
2185: --
2186: close csr_chk_asg_status;
2187: --
2188: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
2184: hr_utility.set_location(l_proc,90);
2185: --
2186: close csr_chk_asg_status;
2187: --
2188: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
2189: hr_utility.raise_error;
2190: --
2191: end if;
2192: --
2185: --
2186: close csr_chk_asg_status;
2187: --
2188: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
2189: hr_utility.raise_error;
2190: --
2191: end if;
2192: --
2193: close csr_chk_asg_status; -- Bug 3266844. Added.
2195: -- must be not null.
2196: --
2197: if p_overwrite_primary='Y' then
2198: --
2199: hr_utility.set_location(l_proc,100);
2200: --
2201: hr_api.mandatory_arg_error
2202: (p_api_name => l_proc
2203: ,p_argument => 'assignment_id'
2203: ,p_argument => 'assignment_id'
2204: ,p_argument_value => p_primary_assignment_id
2205: );
2206: --
2207: hr_utility.set_location(l_proc,110);
2208: else
2209: --the primary assignment id should be null
2210: l_primary_assignment_id:=null;
2211: hr_utility.set_location(l_proc,115);
2207: hr_utility.set_location(l_proc,110);
2208: else
2209: --the primary assignment id should be null
2210: l_primary_assignment_id:=null;
2211: hr_utility.set_location(l_proc,115);
2212: --
2213: end if;
2214: --
2215: hr_utility.set_location(l_proc,120);
2211: hr_utility.set_location(l_proc,115);
2212: --
2213: end if;
2214: --
2215: hr_utility.set_location(l_proc,120);
2216: --
2217: -- Check p_assignment is corresponding data.
2218: -- The assignment record specified by P_ASSIGNMENT_ID on the hire
2219: -- date in the PER_ASSIGNMENTS_F table has assignment status
2220: -- 'ACCEPTED'.
2221: --
2222: if p_primary_assignment_id is not null then
2223: --
2224: hr_utility.set_location(l_proc,130);
2225: --
2226: open csr_chk_assignment_id;
2227: fetch csr_chk_assignment_id
2228: into l_chk_person_id,
2228: into l_chk_person_id,
2229: l_chk_system_status;
2230: if csr_chk_assignment_id%NOTFOUND then
2231: --
2232: hr_utility.set_location(l_proc,140);
2233: --
2234: close csr_chk_assignment_id;
2235: --
2236: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
2232: hr_utility.set_location(l_proc,140);
2233: --
2234: close csr_chk_assignment_id;
2235: --
2236: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
2237: hr_utility.raise_error;
2238: --
2239: end if;
2240: --
2233: --
2234: close csr_chk_assignment_id;
2235: --
2236: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
2237: hr_utility.raise_error;
2238: --
2239: end if;
2240: --
2241: if l_chk_person_id <> p_person_id then
2239: end if;
2240: --
2241: if l_chk_person_id <> p_person_id then
2242: --
2243: hr_utility.set_location(l_proc,150);
2244: --
2245: close csr_chk_assignment_id;
2246: --
2247: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
2243: hr_utility.set_location(l_proc,150);
2244: --
2245: close csr_chk_assignment_id;
2246: --
2247: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
2248: hr_utility.raise_error;
2249: --
2250: end if;
2251: --
2244: --
2245: close csr_chk_assignment_id;
2246: --
2247: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
2248: hr_utility.raise_error;
2249: --
2250: end if;
2251: --
2252: if l_chk_system_status <> 'ACCEPTED' then
2250: end if;
2251: --
2252: if l_chk_system_status <> 'ACCEPTED' then
2253: --
2254: hr_utility.set_location(l_proc,155);
2255: --
2256: close csr_chk_assignment_id;
2257: --
2258: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
2254: hr_utility.set_location(l_proc,155);
2255: --
2256: close csr_chk_assignment_id;
2257: --
2258: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
2259: hr_utility.raise_error;
2260: --
2261: end if;
2262: --
2255: --
2256: close csr_chk_assignment_id;
2257: --
2258: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
2259: hr_utility.raise_error;
2260: --
2261: end if;
2262: --
2263: hr_utility.set_location(l_proc,160);
2259: hr_utility.raise_error;
2260: --
2261: end if;
2262: --
2263: hr_utility.set_location(l_proc,160);
2264: --
2265: close csr_chk_assignment_id;
2266: --
2267: end if;
2265: close csr_chk_assignment_id;
2266: --
2267: end if;
2268: --
2269: hr_utility.set_location(l_proc,170);
2270:
2271: -- Start changes for bug 9879782
2272: if p_upload_irec_docs = 'Y' and p_validate = false then
2273: hr_utility.set_location('p_primary_assignment_id'||p_primary_assignment_id,380);
2269: hr_utility.set_location(l_proc,170);
2270:
2271: -- Start changes for bug 9879782
2272: if p_upload_irec_docs = 'Y' and p_validate = false then
2273: hr_utility.set_location('p_primary_assignment_id'||p_primary_assignment_id,380);
2274:
2275: open csr_get_appl_id(p_primary_assignment_id);
2276: fetch csr_get_appl_id into l_appl_id;
2277: close csr_get_appl_id;
2275: open csr_get_appl_id(p_primary_assignment_id);
2276: fetch csr_get_appl_id into l_appl_id;
2277: close csr_get_appl_id;
2278:
2279: hr_utility.set_location('l_appl_id'||l_appl_id,380);
2280:
2281: per_fnd_attachment_pkg.upload_irec_docs(
2282: p_person_id => p_PERSON_ID,
2283: p_assignment_id => p_primary_assignment_id,
2308: ,p_validation_start_date => l_validation_start_date
2309: ,p_validation_end_date => l_validation_end_date
2310: );
2311: --
2312: hr_utility.set_location(l_proc,180);
2313: --
2314: -- Update the application details by calling the upd procedure in the
2315: -- application table handler:
2316: -- Date_end is set to l_hire_date - 1;
2321: ,p_object_version_number => l_apl_object_version_number
2322: ,p_effective_date => l_hire_date-1
2323: ,p_validate => false
2324: );
2325: hr_utility.set_location(l_proc,190);
2326: --
2327: -- Set all unaccepted applicant assignments to have end date = p_hire_date -1
2328: -- by calling the del procedure in the PER_ASSIGNMENTS_F table handler
2329: -- (This is a datetrack DELETE mode operation)
2334: into l_assignment_id,
2335: l_asg_object_version_number;
2336: exit when csr_get_un_accepted%NOTFOUND;
2337: --
2338: hr_utility.set_location(l_proc,200);
2339: -- ER FPT
2340: open chk_future_changes(l_assignment_id);
2341: fetch chk_future_changes into l_exists;
2342: if chk_future_changes%found then
2340: open chk_future_changes(l_assignment_id);
2341: fetch chk_future_changes into l_exists;
2342: if chk_future_changes%found then
2343: close chk_future_changes;
2344: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2345: hr_utility.raise_error;
2346: end if;
2347: close chk_future_changes;
2348:
2341: fetch chk_future_changes into l_exists;
2342: if chk_future_changes%found then
2343: close chk_future_changes;
2344: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2345: hr_utility.raise_error;
2346: end if;
2347: close chk_future_changes;
2348:
2349: --
2364: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then
2365: per_otherbg_apl_api.close_otherbg_applications(l_assignment_id,l_hire_date-1,'HIRE_END');
2366: end if;
2367:
2368: hr_utility.set_location(l_proc,210);
2369: --
2370: l_unaccepted_asg_del_warning := TRUE;
2371: --
2372: end loop;
2372: end loop;
2373: --
2374: close csr_get_un_accepted;
2375: --
2376: hr_utility.set_location(l_proc, 220);
2377:
2378: -- PTU : Changes
2379:
2380: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
2381: (l_business_group_id,
2382: 'EMP');
2383: -- PTU : End of Changes
2384:
2385: hr_utility.set_location(l_proc, 225);
2386:
2387: --
2388: -- Update the person details by calling upd procedure in
2389: -- the per_all_people_f table.
2410: ,p_orig_hire_warning => l_orig_hire_warning
2411: ,p_npw_number => l_npw_number
2412: );
2413: --
2414: hr_utility.set_location(l_proc,230);
2415:
2416: -- PTU : Following Code has been added
2417: --
2418: hr_per_type_usage_internal.maintain_person_type_usage
2452: ,p_legislation_code => l_legislation_code
2453: ,p_expected_system_status => 'ACTIVE_ASSIGN'
2454: );
2455: --
2456: hr_utility.set_location(l_proc,240);
2457: --
2458: l_oversubscribed_vacancy_id :=null;
2459: --
2460: -- #2468916: Need to retrieve the period of service id
2463: close get_primary;
2464: --
2465: for asg_rec in csr_get_accepted loop
2466: --
2467: hr_utility.set_location(l_proc,250);
2468: -- ER FPT
2469: open chk_future_changes(asg_rec.assignment_id);
2470: fetch chk_future_changes into l_exists;
2471: if chk_future_changes%found then
2469: open chk_future_changes(asg_rec.assignment_id);
2470: fetch chk_future_changes into l_exists;
2471: if chk_future_changes%found then
2472: close chk_future_changes;
2473: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2474: hr_utility.raise_error;
2475: end if;
2476: close chk_future_changes;
2477:
2470: fetch chk_future_changes into l_exists;
2471: if chk_future_changes%found then
2472: close chk_future_changes;
2473: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2474: hr_utility.raise_error;
2475: end if;
2476: close chk_future_changes;
2477:
2478: --
2506: p_org_now_no_manager_warning => l_org_now_no_manager_warning,
2507: p_hourly_salaried_warning => l_hourly_salaried_warning
2508: );
2509: --
2510: hr_utility.set_location(l_proc,260);
2511: --The below has been commented as part of bug fix 5481530
2512: -- if asg_rec.assignment_id = p_primary_assignment_id then
2513: if asg_rec.assignment_id = l_primary_assignment_id then
2514: hr_assignment_api.set_new_primary_asg
2546: -- Bug 4644830 End
2547: -- Bug 4630129 Starts
2548: elsif asg_rec.assignment_id = p_primary_assignment_id and p_overwrite_primary ='Y' then
2549: -- Hire the new secondary Applicant assignment.
2550: hr_utility.set_location(l_proc,261);
2551: per_asg_upd.upd
2552: (p_assignment_id => asg_rec.assignment_id,
2553: p_object_version_number => asg_rec.object_version_number,
2554: p_effective_date => l_hire_date,
2570: p_org_now_no_manager_warning => l_org_now_no_manager_warning,
2571: p_hourly_salaried_warning => l_hourly_salaried_warning
2572: );
2573: -- Make the new secondary Applicant assignment Primary.
2574: hr_utility.set_location(l_proc,262);
2575: hr_assignment_api.set_new_primary_asg
2576: (p_validate => false
2577: ,p_effective_date => l_hire_date
2578: ,p_person_id => p_person_id
2580: ,p_object_version_number => asg_rec.object_version_number
2581: ,p_effective_start_date => l_effective_start_date
2582: ,p_effective_end_date => l_effective_end_date
2583: );
2584: hr_utility.set_location(l_proc,263);
2585: -- Bug 4630129 Ends
2586: -- Bug 4644830 Start
2587: OPEN get_pay_proposal(asg_rec.assignment_id);
2588: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date,l_proposal_reason; --Added Proposal_Reason for Bug # 5987409 --
2618: open get_primary;
2619: fetch get_primary into l_primary_asg_id,l_primary_ovn, l_period_of_service_id; -- #2468916
2620: close get_primary;
2621: --
2622: hr_utility.set_location(l_proc, 264);
2623: --
2624: open get_asg(asg_rec.assignment_id);
2625: fetch get_asg into l_asg_rec;
2626: close get_asg;
2632: if get_primary_approved_proposal%found then
2633: close get_primary_approved_proposal;
2634:
2635: if l_asg_rec.pay_basis_id is null then
2636: hr_utility.set_message(800,'HR_289767_SALARY_BASIS_IS_NULL');
2637: hr_utility.raise_error;
2638: end if;
2639: --Added else to close the cursor--5277866
2640: else
2633: close get_primary_approved_proposal;
2634:
2635: if l_asg_rec.pay_basis_id is null then
2636: hr_utility.set_message(800,'HR_289767_SALARY_BASIS_IS_NULL');
2637: hr_utility.raise_error;
2638: end if;
2639: --Added else to close the cursor--5277866
2640: else
2641: close get_primary_approved_proposal;
2643: ---changes for 4959033 ends here
2644:
2645: if l_asg_rec.people_group_id is not null then
2646: --
2647: hr_utility.set_location(l_proc, 265);
2648: --
2649: open get_pgp(l_asg_rec.people_group_id);
2650: fetch get_pgp into l_pgp_rec;
2651: close get_pgp;
2653: end if;
2654:
2655: if l_asg_rec.soft_coding_keyflex_id is not null then
2656: --
2657: hr_utility.set_location(l_proc, 266);
2658: --
2659: open get_scl(l_asg_rec.soft_coding_keyflex_id);
2660: fetch get_scl into l_scl_rec;
2661: close get_scl;
2663: end if;
2664: --
2665: if l_asg_rec.cagr_grade_def_id is not null then
2666: --
2667: hr_utility.set_location(l_proc, 267);
2668: --
2669: open get_cag(l_asg_rec.cagr_grade_def_id);
2670: fetch get_cag into l_cag_rec;
2671: close get_cag;
2671: close get_cag;
2672: end if;
2673: --
2674:
2675: hr_utility.set_location(l_proc, 268);
2676: --
2677:
2678: --The below call has been commented as per bug 5102160
2679: -- soft_coding_keyflex_id is passed by calling the new update_emp_asg_criteria procedure
2794: ,p_gsp_post_process_warning => l_gsp_post_process_warning -- bug 2999562
2795: );
2796:
2797: --
2798: hr_utility.set_location(l_proc, 269);
2799: --
2800: hr_assignment_api.update_emp_asg
2801: (p_validate => FALSE
2802: ,p_effective_date => l_hire_date
2926: ,p_other_manager_warning => l_dummyb
2927: ,p_hourly_salaried_warning => l_dummyb
2928: );
2929: --
2930: hr_utility.set_location(l_proc, 271);
2931:
2932: --Fix For Bug # 5987409 Starts -----
2933:
2934: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,
2955: ,p_datetrack_mode => 'DELETE'
2956: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
2957: );
2958: --
2959: hr_utility.set_location(l_proc, 272);
2960: --
2961: --
2962:
2963: l_pspl_asg_id :=asg_rec.assignment_id;
3017: -- fix for the bug 5024006 ends here
3018:
3019: else
3020: --
3021: hr_utility.set_location(l_proc, 270);
3022: --
3023: -- we must update the old assignment with the new assignment record
3024: --
3025: open get_primary;
3025: open get_primary;
3026: fetch get_primary into l_primary_asg_id,l_primary_ovn, l_period_of_service_id; -- #2468916
3027: close get_primary;
3028: --
3029: hr_utility.set_location(l_proc, 280);
3030: --
3031: open get_asg(asg_rec.assignment_id);
3032: fetch get_asg into l_asg_rec;
3033: close get_asg;
3031: open get_asg(asg_rec.assignment_id);
3032: fetch get_asg into l_asg_rec;
3033: close get_asg;
3034: --
3035: hr_utility.set_location(l_proc, 290);
3036: --
3037: if l_asg_rec.people_group_id is not null then
3038: --
3039: hr_utility.set_location(l_proc, 300);
3035: hr_utility.set_location(l_proc, 290);
3036: --
3037: if l_asg_rec.people_group_id is not null then
3038: --
3039: hr_utility.set_location(l_proc, 300);
3040: --
3041: open get_pgp(l_asg_rec.people_group_id);
3042: fetch get_pgp into l_pgp_rec;
3043: close get_pgp;
3044: end if;
3045: --
3046: if l_asg_rec.soft_coding_keyflex_id is not null then
3047: --
3048: hr_utility.set_location(l_proc, 310);
3049: --
3050: open get_scl(l_asg_rec.soft_coding_keyflex_id);
3051: fetch get_scl into l_scl_rec;
3052: close get_scl;
3053: end if;
3054: --
3055: if l_asg_rec.cagr_grade_def_id is not null then
3056: --
3057: hr_utility.set_location(l_proc, 320);
3058: --
3059: open get_cag(l_asg_rec.cagr_grade_def_id);
3060: fetch get_cag into l_cag_rec;
3061: close get_cag;
3060: fetch get_cag into l_cag_rec;
3061: close get_cag;
3062: end if;
3063: --
3064: hr_utility.set_location(l_proc, 330);
3065: --
3066: if p_overwrite_primary = 'V' then
3067: --
3068: open get_asg(l_primary_asg_id);
3429: ,p_concatenated_segments => l_concatenated_segments
3430: ,p_gsp_post_process_warning => l_gsp_post_process_warning -- bug 2999562
3431: );
3432: --
3433: hr_utility.set_location(l_proc, 340);
3434: --
3435: hr_assignment_api.update_emp_asg
3436: (p_validate => FALSE
3437: ,p_effective_date => l_hire_date
3561: ,p_other_manager_warning => l_dummyb
3562: ,p_hourly_salaried_warning => l_dummyb
3563: );
3564: --
3565: hr_utility.set_location(l_proc, 350);
3566:
3567:
3568: --Fix For Bug # 5987409 Starts -----
3569:
3591: ,p_datetrack_mode => 'DELETE'
3592: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
3593: );
3594: --
3595: hr_utility.set_location(l_proc, 360);
3596: --
3597: -- added for the bug 4641965
3598: --
3599: if (p_primary_assignment_id is not null ) then
3700: end if;
3701: --
3702: end loop;
3703: --
3704: hr_utility.set_location(l_proc,370);
3705: -- ER FPT
3706: for apl in fut_asg_rec
3707: loop
3708: hr_utility.set_location('Processing Assignment ID = '||apl.assignment_id,375);
3704: hr_utility.set_location(l_proc,370);
3705: -- ER FPT
3706: for apl in fut_asg_rec
3707: loop
3708: hr_utility.set_location('Processing Assignment ID = '||apl.assignment_id,375);
3709:
3710: l_fpt_hire_flag :='Y';
3711:
3712: -- retrieve the max end date of the ASG to update the APLN date_end
3768: end loop;
3769:
3770: if nvl(l_fpt_hire_flag,'N') = 'Y' then
3771:
3772: hr_utility.set_location('HR_EMPLOYEE_APPLICANT_API.HIRE_EMPLOYEE_APPLICANT',377);
3773:
3774: -- loop through the future applications > hire date
3775: for apl in csr_get_apln_details(l_hire_date)
3776: loop
3944: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
3945: p_assign_payroll_warning := l_assign_payroll_warning;
3946: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id ;
3947: --
3948: hr_utility.set_location(' Leaving:'||l_proc, 380);
3949: --
3950: exception
3951: when hr_api.validate_enabled then
3952: --
3966: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
3967: p_assign_payroll_warning := l_assign_payroll_warning;
3968: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id ;
3969: --
3970: hr_utility.set_location(' Leaving:'||l_proc, 390);
3971: --
3972: when others then
3973: --
3974: -- A validation or unexpected error has occurred
3984: --
3985: -- set in out parameters and set out parameters
3986: --
3987:
3988: hr_utility.set_location(' Leaving:'||l_proc, 400);
3989: raise;
3990: --
3991: end hire_employee_applicant;
3992: --
4001: --
4002: l_index number;
4003: l_max_ele number;
4004: begin
4005: hr_utility.set_location('IN locate_element',50);
4006: l_index := 0;
4007: l_max_ele := p_table.COUNT;
4008: hr_utility.trace(' table rows: '||to_char(l_max_ele));
4009: if l_max_ele > 0 then
4004: begin
4005: hr_utility.set_location('IN locate_element',50);
4006: l_index := 0;
4007: l_max_ele := p_table.COUNT;
4008: hr_utility.trace(' table rows: '||to_char(l_max_ele));
4009: if l_max_ele > 0 then
4010: l_index := 1;
4011: loop
4012: if p_table(l_index).id = p_id then
4015: l_index := l_index + 1;
4016: EXIT when l_index > l_max_ele ;
4017: end loop;
4018: end if;
4019: hr_utility.trace(' index found : '||to_char(l_index));
4020: hr_utility.set_location('OUT locate_element',51);
4021:
4022: if l_index > l_max_ele then
4023: return(0);
4016: EXIT when l_index > l_max_ele ;
4017: end loop;
4018: end if;
4019: hr_utility.trace(' index found : '||to_char(l_index));
4020: hr_utility.set_location('OUT locate_element',51);
4021:
4022: if l_index > l_max_ele then
4023: return(0);
4024: else
4570: -- ER FPT
4571:
4572:
4573: begin
4574: hr_utility.set_location('Entering:'|| l_proc, 10);
4575: --
4576: hr_api.mandatory_arg_error
4577: (p_api_name => l_proc
4578: ,p_argument => 'person_id'
4588: -- Issue a savepoint.
4589: --
4590: savepoint hire_employee_applicant;
4591: --
4592: hr_utility.set_location(l_proc, 20);
4593: --
4594: -- Process Logic
4595: --
4596: -- Truncate the time portion from all date parameters
4623: end;
4624: --
4625: -- Check that there are not any future changes to the assignment
4626: --
4627: hr_utility.set_location(l_proc, 30);
4628: --
4629: -- ER FPT
4630: open csr_future_asg_changes;
4631: fetch csr_future_asg_changes into l_exists;
4630: open csr_future_asg_changes;
4631: fetch csr_future_asg_changes into l_exists;
4632: if csr_future_asg_changes%FOUND then
4633: --
4634: hr_utility.set_location(l_proc,40);
4635: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
4636: open fpt_future_asg_changes;
4637: fetch fpt_future_asg_changes into l_exists;
4638: if fpt_future_asg_changes%found then
4635: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
4636: open fpt_future_asg_changes;
4637: fetch fpt_future_asg_changes into l_exists;
4638: if fpt_future_asg_changes%found then
4639: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4640: hr_utility.raise_error;
4641: end if;
4642: close fpt_future_asg_changes;
4643: else
4636: open fpt_future_asg_changes;
4637: fetch fpt_future_asg_changes into l_exists;
4638: if fpt_future_asg_changes%found then
4639: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4640: hr_utility.raise_error;
4641: end if;
4642: close fpt_future_asg_changes;
4643: else
4644: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4640: hr_utility.raise_error;
4641: end if;
4642: close fpt_future_asg_changes;
4643: else
4644: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4645: hr_utility.raise_error;
4646: end if;
4647: end if;
4648: close csr_future_asg_changes;
4641: end if;
4642: close fpt_future_asg_changes;
4643: else
4644: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4645: hr_utility.raise_error;
4646: end if;
4647: end if;
4648: close csr_future_asg_changes;
4649: -- ER FPT
4647: end if;
4648: close csr_future_asg_changes;
4649: -- ER FPT
4650: --
4651: hr_utility.set_location(l_proc,45);
4652: --
4653: -- Get the derived details for the person DT instance
4654: --
4655: open csr_get_devived_details;
4664: l_apl_object_version_number;
4665: if csr_get_devived_details%NOTFOUND
4666: then
4667: --
4668: hr_utility.set_location(l_proc,50);
4669: --
4670: close csr_get_devived_details;
4671: --
4672: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
4668: hr_utility.set_location(l_proc,50);
4669: --
4670: close csr_get_devived_details;
4671: --
4672: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
4673: hr_utility.raise_error;
4674: --
4675: end if;
4676: close csr_get_devived_details;
4669: --
4670: close csr_get_devived_details;
4671: --
4672: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
4673: hr_utility.raise_error;
4674: --
4675: end if;
4676: close csr_get_devived_details;
4677: --
4674: --
4675: end if;
4676: close csr_get_devived_details;
4677: --
4678: hr_utility.set_location(l_proc,55);
4679: --
4680: -- Validation in addition to Row Handlers
4681: --
4682: -- If the specified person type id is not null then check that it
4689: ,p_business_group_id => l_business_group_id
4690: ,p_expected_sys_type => 'EMP'
4691: );
4692: --
4693: hr_utility.set_location(l_proc,60);
4694: --
4695: -- Check that corresponding person is of 'EMP_APL'
4696: -- system person type.
4697: --
4697: --
4698: if l_system_person_type <> 'EMP_APL'
4699: then
4700: --
4701: hr_utility.set_location(l_proc,70);
4702: --
4703: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4704: hr_utility.raise_error;
4705: end if;
4699: then
4700: --
4701: hr_utility.set_location(l_proc,70);
4702: --
4703: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4704: hr_utility.raise_error;
4705: end if;
4706: --
4707: hr_utility.set_location(l_proc,80);
4700: --
4701: hr_utility.set_location(l_proc,70);
4702: --
4703: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4704: hr_utility.raise_error;
4705: end if;
4706: --
4707: hr_utility.set_location(l_proc,80);
4708: --
4703: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4704: hr_utility.raise_error;
4705: end if;
4706: --
4707: hr_utility.set_location(l_proc,80);
4708: --
4709: -- Check that corresponding person is of 'ACCEPTED' of
4710: -- assignment status type.
4711: --
4714: --close csr_chk_asg_status; -- Bug 3266844. Commented out.
4715: --
4716: if l_count = 0 then
4717: --
4718: hr_utility.set_location(l_proc,90);
4719: --
4720: close csr_chk_asg_status;
4721: --
4722: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
4718: hr_utility.set_location(l_proc,90);
4719: --
4720: close csr_chk_asg_status;
4721: --
4722: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
4723: hr_utility.raise_error;
4724: --
4725: end if;
4726: --
4719: --
4720: close csr_chk_asg_status;
4721: --
4722: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
4723: hr_utility.raise_error;
4724: --
4725: end if;
4726: --
4727: close csr_chk_asg_status; -- Bug 3266844. Added.
4729: -- must be not null.
4730: --
4731: if p_overwrite_primary='Y' then
4732: --
4733: hr_utility.set_location(l_proc,100);
4734: --
4735: hr_api.mandatory_arg_error
4736: (p_api_name => l_proc
4737: ,p_argument => 'assignment_id'
4737: ,p_argument => 'assignment_id'
4738: ,p_argument_value => p_primary_assignment_id
4739: );
4740: --
4741: hr_utility.set_location(l_proc,110);
4742: else
4743: --the primary assignment id should be null
4744: l_primary_assignment_id:=null;
4745: hr_utility.set_location(l_proc,115);
4741: hr_utility.set_location(l_proc,110);
4742: else
4743: --the primary assignment id should be null
4744: l_primary_assignment_id:=null;
4745: hr_utility.set_location(l_proc,115);
4746: --
4747: end if;
4748: --
4749: hr_utility.set_location(l_proc,120);
4745: hr_utility.set_location(l_proc,115);
4746: --
4747: end if;
4748: --
4749: hr_utility.set_location(l_proc,120);
4750: --
4751: -- Check p_assignment is corresponding data.
4752: -- The assignment record specified by P_ASSIGNMENT_ID on the hire
4753: -- date in the PER_ASSIGNMENTS_F table has assignment status
4754: -- 'ACCEPTED'.
4755: --
4756: if p_primary_assignment_id is not null then
4757: --
4758: hr_utility.set_location(l_proc,130);
4759: --
4760: open csr_chk_assignment_id;
4761: fetch csr_chk_assignment_id
4762: into l_chk_person_id,
4762: into l_chk_person_id,
4763: l_chk_system_status;
4764: if csr_chk_assignment_id%NOTFOUND then
4765: --
4766: hr_utility.set_location(l_proc,140);
4767: --
4768: close csr_chk_assignment_id;
4769: --
4770: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
4766: hr_utility.set_location(l_proc,140);
4767: --
4768: close csr_chk_assignment_id;
4769: --
4770: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
4771: hr_utility.raise_error;
4772: --
4773: end if;
4774: --
4767: --
4768: close csr_chk_assignment_id;
4769: --
4770: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
4771: hr_utility.raise_error;
4772: --
4773: end if;
4774: --
4775: if l_chk_person_id <> p_person_id then
4773: end if;
4774: --
4775: if l_chk_person_id <> p_person_id then
4776: --
4777: hr_utility.set_location(l_proc,150);
4778: --
4779: close csr_chk_assignment_id;
4780: --
4781: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
4777: hr_utility.set_location(l_proc,150);
4778: --
4779: close csr_chk_assignment_id;
4780: --
4781: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
4782: hr_utility.raise_error;
4783: --
4784: end if;
4785: --
4778: --
4779: close csr_chk_assignment_id;
4780: --
4781: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
4782: hr_utility.raise_error;
4783: --
4784: end if;
4785: --
4786: if l_chk_system_status <> 'ACCEPTED' then
4784: end if;
4785: --
4786: if l_chk_system_status <> 'ACCEPTED' then
4787: --
4788: hr_utility.set_location(l_proc,155);
4789: --
4790: close csr_chk_assignment_id;
4791: --
4792: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
4788: hr_utility.set_location(l_proc,155);
4789: --
4790: close csr_chk_assignment_id;
4791: --
4792: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
4793: hr_utility.raise_error;
4794: --
4795: end if;
4796: --
4789: --
4790: close csr_chk_assignment_id;
4791: --
4792: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
4793: hr_utility.raise_error;
4794: --
4795: end if;
4796: --
4797: hr_utility.set_location(l_proc,160);
4793: hr_utility.raise_error;
4794: --
4795: end if;
4796: --
4797: hr_utility.set_location(l_proc,160);
4798: --
4799: close csr_chk_assignment_id;
4800: --
4801: end if;
4799: close csr_chk_assignment_id;
4800: --
4801: end if;
4802: --
4803: hr_utility.set_location(l_proc,170);
4804: --
4805:
4806: ------ SSHR Enhancement (Bug # 8536819)-------
4807: -- Check if there are any applications for the person other than the
4843: ,p_validation_end_date => l_validation_end_date
4844: );
4845:
4846: --
4847: hr_utility.set_location(l_proc,180);
4848: end if; -- SSHR Enhancement (Bug # 8536819).
4849: --
4850: -- Update the application details by calling the upd procedure in the
4851: -- application table handler:
4862: ,p_object_version_number => l_apl_object_version_number
4863: ,p_effective_date => l_hire_date-1
4864: ,p_validate => false
4865: );
4866: hr_utility.set_location(l_proc,190);
4867: end if; -- SSHR Enhancement (Bug # 8536819).
4868: --
4869: -- Set all unaccepted applicant assignments to have end date = p_hire_date -1
4870: -- by calling the del procedure in the PER_ASSIGNMENTS_F table handler
4887: into l_assignment_id,
4888: l_asg_object_version_number;
4889: exit when csr_get_un_accepted%NOTFOUND;
4890: --
4891: hr_utility.set_location(l_proc,200);
4892:
4893: -- ER FPT
4894: open chk_future_changes(l_assignment_id);
4895: fetch chk_future_changes into l_exists;
4894: open chk_future_changes(l_assignment_id);
4895: fetch chk_future_changes into l_exists;
4896: if chk_future_changes%found then
4897: close chk_future_changes;
4898: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4899: hr_utility.raise_error;
4900: end if;
4901: close chk_future_changes;
4902:
4895: fetch chk_future_changes into l_exists;
4896: if chk_future_changes%found then
4897: close chk_future_changes;
4898: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
4899: hr_utility.raise_error;
4900: end if;
4901: close chk_future_changes;
4902:
4903: --
4913: ,p_datetrack_mode => 'DELETE'
4914: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
4915: );
4916: --
4917: hr_utility.set_location(l_proc,210);
4918: --
4919: per_people3_pkg.get_default_person_type
4920: (p_required_type => 'TERM_APL'
4921: ,p_business_group_id => l_business_group_id
4921: ,p_business_group_id => l_business_group_id
4922: ,p_legislation_code => l_legislation_code
4923: ,p_person_type => l_assignment_status_type_id
4924: );
4925: hr_utility.set_location(l_proc,211);
4926:
4927: IRC_ASG_STATUS_API.create_irc_asg_status
4928: (p_assignment_id => l_assignment_id
4929: , p_assignment_status_type_id => l_assignment_status_type_id
4944: close csr_get_un_accepted;
4945: end if; --12905192
4946: -------------------------------------------------------------------------------*/
4947: --
4948: hr_utility.set_location(l_proc, 220);
4949:
4950: -- PTU : Changes
4951:
4952: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
4953: (l_business_group_id,
4954: 'EMP');
4955: -- PTU : End of Changes
4956:
4957: hr_utility.set_location(l_proc, 225);
4958:
4959: --
4960: -- Update the person details by calling upd procedure in
4961: -- the per_all_people_f table.
4988: ,p_orig_hire_warning => l_orig_hire_warning
4989: ,p_npw_number => l_npw_number
4990: );
4991: --
4992: hr_utility.set_location(l_proc,230);
4993:
4994: -- PTU : Following Code has been added
4995: --
4996: hr_per_type_usage_internal.maintain_person_type_usage
5033: ,p_legislation_code => l_legislation_code
5034: ,p_expected_system_status => 'ACTIVE_ASSIGN'
5035: );
5036: --
5037: hr_utility.set_location(l_proc,240);
5038: --
5039: l_oversubscribed_vacancy_id :=null;
5040:
5041: --- Fix For Bug # 8844816 Starts ---
5062: close get_primary;
5063: --
5064: for asg_rec in csr_get_accepted loop
5065: --
5066: hr_utility.set_location(l_proc,250);
5067:
5068: -- ER FPT
5069: open chk_future_changes(asg_rec.assignment_id);
5070: fetch chk_future_changes into l_exists;
5069: open chk_future_changes(asg_rec.assignment_id);
5070: fetch chk_future_changes into l_exists;
5071: if chk_future_changes%found then
5072: close chk_future_changes;
5073: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
5074: hr_utility.raise_error;
5075: end if;
5076: close chk_future_changes;
5077: --
5070: fetch chk_future_changes into l_exists;
5071: if chk_future_changes%found then
5072: close chk_future_changes;
5073: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
5074: hr_utility.raise_error;
5075: end if;
5076: close chk_future_changes;
5077: --
5078: if asg_rec.effective_start_date=l_hire_date then
5106: p_hourly_salaried_warning => l_hourly_salaried_warning,
5107: p_soft_coding_keyflex_id => l_soft_coding_keyflex_id --- Fix For Bug # 8844816
5108: );
5109: --
5110: hr_utility.set_location(l_proc,260);
5111: --The below has been commented as part of bug fix 5481530
5112: -- if asg_rec.assignment_id = p_primary_assignment_id then
5113: if asg_rec.assignment_id = l_primary_assignment_id then
5114: hr_assignment_api.set_new_primary_asg
5175: elsif asg_rec.assignment_id = p_primary_assignment_id and p_overwrite_primary ='Y' then
5176:
5177:
5178: -- Hire the new secondary Applicant assignment.
5179: hr_utility.set_location(l_proc,261);
5180: per_asg_upd.upd
5181: (p_assignment_id => asg_rec.assignment_id,
5182: p_object_version_number => asg_rec.object_version_number,
5183: p_effective_date => l_hire_date,
5200: p_hourly_salaried_warning => l_hourly_salaried_warning,
5201: p_soft_coding_keyflex_id => l_soft_coding_keyflex_id --- Fix For Bug # 8844816
5202: );
5203: -- Make the new secondary Applicant assignment Primary.
5204: hr_utility.set_location(l_proc,262);
5205: hr_assignment_api.set_new_primary_asg
5206: (p_validate => false
5207: ,p_effective_date => l_hire_date
5208: ,p_person_id => p_person_id
5210: ,p_object_version_number => asg_rec.object_version_number
5211: ,p_effective_start_date => l_effective_start_date
5212: ,p_effective_end_date => l_effective_end_date
5213: );
5214: hr_utility.set_location(l_proc,263);
5215:
5216:
5217: -- added 10376122
5218: if asg_rec.vacancy_id is not null then --fix for bug8488222
5264: --
5265: -- bug 5024006 fix starts here
5266: --
5267:
5268: hr_utility.set_location('p_asg_rec.vacany_id'||p_asg_rec.vacancy_id,100);
5269: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,100);
5270:
5271: if l_check_loop=0 then
5272:
5265: -- bug 5024006 fix starts here
5266: --
5267:
5268: hr_utility.set_location('p_asg_rec.vacany_id'||p_asg_rec.vacancy_id,100);
5269: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,100);
5270:
5271: if l_check_loop=0 then
5272:
5273: open get_primary;
5273: open get_primary;
5274: fetch get_primary into l_primary_asg_id,l_primary_ovn, l_period_of_service_id; -- #2468916
5275: close get_primary;
5276: --
5277: hr_utility.set_location(l_proc, 264);
5278: --
5279: if p_asg_rec.assignment_id is not null then
5280: l_asg_rec := p_asg_rec;
5281: hr_utility.set_location('inside if overwrite'||p_asg_rec.assignment_id,100);
5277: hr_utility.set_location(l_proc, 264);
5278: --
5279: if p_asg_rec.assignment_id is not null then
5280: l_asg_rec := p_asg_rec;
5281: hr_utility.set_location('inside if overwrite'||p_asg_rec.assignment_id,100);
5282:
5283: -- vb 10376122
5284:
5285: open csr_get_vacancy(p_asg_rec.assignment_id);
5291: else
5292: open get_asg(asg_rec.assignment_id);
5293: fetch get_asg into l_asg_rec;
5294: close get_asg;
5295: hr_utility.set_location('inside else overwrite'||l_asg_rec.assignment_id,100);
5296: end if;
5297:
5298:
5299: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,121);
5295: hr_utility.set_location('inside else overwrite'||l_asg_rec.assignment_id,100);
5296: end if;
5297:
5298:
5299: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,121);
5300: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,121);
5301:
5302: hr_utility.set_location('p_asg_rec.vacany_id'||p_asg_rec.vacancy_id,110);
5303: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,110);
5296: end if;
5297:
5298:
5299: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,121);
5300: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,121);
5301:
5302: hr_utility.set_location('p_asg_rec.vacany_id'||p_asg_rec.vacancy_id,110);
5303: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,110);
5304:
5298:
5299: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,121);
5300: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,121);
5301:
5302: hr_utility.set_location('p_asg_rec.vacany_id'||p_asg_rec.vacancy_id,110);
5303: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,110);
5304:
5305: ---changes for 4959033 starts here
5306: open get_primary_approved_proposal(l_primary_asg_id);
5299: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,121);
5300: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,121);
5301:
5302: hr_utility.set_location('p_asg_rec.vacany_id'||p_asg_rec.vacancy_id,110);
5303: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,110);
5304:
5305: ---changes for 4959033 starts here
5306: open get_primary_approved_proposal(l_primary_asg_id);
5307: fetch get_primary_approved_proposal into l_pay_pspl_id;
5309: if get_primary_approved_proposal%found then
5310: close get_primary_approved_proposal;
5311:
5312: if l_asg_rec.pay_basis_id is null then
5313: hr_utility.set_message(800,'HR_289767_SALARY_BASIS_IS_NULL');
5314: hr_utility.raise_error;
5315: end if;
5316: --Added else to close the cursor--5277866
5317: else
5310: close get_primary_approved_proposal;
5311:
5312: if l_asg_rec.pay_basis_id is null then
5313: hr_utility.set_message(800,'HR_289767_SALARY_BASIS_IS_NULL');
5314: hr_utility.raise_error;
5315: end if;
5316: --Added else to close the cursor--5277866
5317: else
5318: close get_primary_approved_proposal;
5320: ---changes for 4959033 ends here
5321:
5322: if l_asg_rec.people_group_id is not null then
5323: --
5324: hr_utility.set_location(l_proc, 265);
5325: --
5326: open get_pgp(l_asg_rec.people_group_id);
5327: fetch get_pgp into l_pgp_rec;
5328: close get_pgp;
5330: end if;
5331:
5332: if l_asg_rec.soft_coding_keyflex_id is not null then
5333: --
5334: hr_utility.set_location(l_proc, 266);
5335: --
5336: open get_scl(l_asg_rec.soft_coding_keyflex_id);
5337: fetch get_scl into l_scl_rec;
5338: close get_scl;
5340: end if;
5341: --
5342: if l_asg_rec.cagr_grade_def_id is not null then
5343: --
5344: hr_utility.set_location(l_proc, 267);
5345: --
5346: open get_cag(l_asg_rec.cagr_grade_def_id);
5347: fetch get_cag into l_cag_rec;
5348: close get_cag;
5348: close get_cag;
5349: end if;
5350: --
5351:
5352: hr_utility.set_location(l_proc, 268);
5353: --
5354:
5355: --The below call has been commented as per bug 5102160
5356: -- soft_coding_keyflex_id is passed by calling the new update_emp_asg_criteria procedure
5471: ,p_gsp_post_process_warning => l_gsp_post_process_warning -- bug 2999562
5472: );
5473:
5474: --
5475: hr_utility.set_location(l_proc, 269);
5476: --
5477: hr_assignment_api.update_emp_asg
5478: (p_validate => FALSE
5479: ,p_effective_date => l_hire_date
5603: ,p_other_manager_warning => l_dummyb
5604: ,p_hourly_salaried_warning => l_dummyb
5605: );
5606: --
5607: hr_utility.set_location(l_proc, 271);
5608:
5609: --Fix For Bug # 5987409 Starts -----
5610:
5611:
5608:
5609: --Fix For Bug # 5987409 Starts -----
5610:
5611:
5612: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,103);
5613: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,103);
5614:
5615: /*
5616: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,
5609: --Fix For Bug # 5987409 Starts -----
5610:
5611:
5612: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,103);
5613: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,103);
5614:
5615: /*
5616: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_asg_rec.vacancy_id ,
5617: PAF.RECRUITER_ID =l_asg_rec.recruiter_id
5636: --Fix For Bug # 5987409 Starts -----
5637: -- 10376122 -- new
5638: if l_aplasg_vacancy_id is not null then --fix for bug8488222
5639:
5640: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,104);
5641: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,105);
5642:
5643: IRC_ASG_STATUS_API.create_irc_asg_status
5644: (p_assignment_id => l_primary_asg_id
5637: -- 10376122 -- new
5638: if l_aplasg_vacancy_id is not null then --fix for bug8488222
5639:
5640: hr_utility.set_location('1_asg_rec.vacany_id'||l_asg_rec.vacancy_id,104);
5641: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,105);
5642:
5643: IRC_ASG_STATUS_API.create_irc_asg_status
5644: (p_assignment_id => l_primary_asg_id
5645: ,p_assignment_status_type_id => l_asg_type_id
5671: ,p_datetrack_mode => 'DELETE'
5672: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
5673: );
5674: --
5675: hr_utility.set_location(l_proc, 272);
5676: --
5677: --
5678: /*
5679: l_change_reason:=fnd_profile.value('HR_APL_CHNG_REASON'); -- 12905192
5767: -- fix for the bug 5024006 ends here
5768:
5769: else
5770: --
5771: hr_utility.set_location(l_proc, 270);
5772: --
5773: -- we must update the old assignment with the new assignment record
5774: --
5775: open get_primary;
5775: open get_primary;
5776: fetch get_primary into l_primary_asg_id,l_primary_ovn, l_period_of_service_id; -- #2468916
5777: close get_primary;
5778: --
5779: hr_utility.set_location(l_proc, 280);
5780: --
5781: if p_asg_rec.assignment_id is not null then
5782: l_asg_rec := p_asg_rec;
5783:
5795: fetch get_asg into l_asg_rec;
5796: close get_asg;
5797: end if;
5798: --
5799: hr_utility.set_location(l_proc, 290);
5800: --
5801: if l_asg_rec.people_group_id is not null then
5802: --
5803: hr_utility.set_location(l_proc, 300);
5799: hr_utility.set_location(l_proc, 290);
5800: --
5801: if l_asg_rec.people_group_id is not null then
5802: --
5803: hr_utility.set_location(l_proc, 300);
5804: --
5805: open get_pgp(l_asg_rec.people_group_id);
5806: fetch get_pgp into l_pgp_rec;
5807: close get_pgp;
5808: end if;
5809: --
5810: if l_asg_rec.soft_coding_keyflex_id is not null then
5811: --
5812: hr_utility.set_location(l_proc, 310);
5813: --
5814: open get_scl(l_asg_rec.soft_coding_keyflex_id);
5815: fetch get_scl into l_scl_rec;
5816: close get_scl;
5817: end if;
5818: --
5819: if l_asg_rec.cagr_grade_def_id is not null then
5820: --
5821: hr_utility.set_location(l_proc, 320);
5822: --
5823: open get_cag(l_asg_rec.cagr_grade_def_id);
5824: fetch get_cag into l_cag_rec;
5825: close get_cag;
5824: fetch get_cag into l_cag_rec;
5825: close get_cag;
5826: end if;
5827: --
5828: hr_utility.set_location(l_proc, 330);
5829: --
5830: if p_overwrite_primary = 'V' then
5831: --
5832:
5829: --
5830: if p_overwrite_primary = 'V' then
5831: --
5832:
5833: hr_utility.set_location('l_aplasg_vacancy_id'||l_aplasg_vacancy_id,180);
5834: hr_utility.set_location('l_aplasg_RECRUITER_ID'||l_aplasg_RECRUITER_ID,180);
5835:
5836: open get_asg(l_primary_asg_id);
5837: fetch get_asg into l_primary_asg_rec;
5830: if p_overwrite_primary = 'V' then
5831: --
5832:
5833: hr_utility.set_location('l_aplasg_vacancy_id'||l_aplasg_vacancy_id,180);
5834: hr_utility.set_location('l_aplasg_RECRUITER_ID'||l_aplasg_RECRUITER_ID,180);
5835:
5836: open get_asg(l_primary_asg_id);
5837: fetch get_asg into l_primary_asg_rec;
5838: close get_asg;
6197: );
6198: --
6199: p_asg_rec.people_group_id := l_dummy;
6200:
6201: hr_utility.set_location(l_proc, 340);
6202: --
6203: hr_assignment_api.update_emp_asg
6204: (p_validate => FALSE
6205: ,p_effective_date => l_hire_date
6331: );
6332: --
6333: p_asg_rec.soft_coding_keyflex_id := l_dummy1;
6334:
6335: hr_utility.set_location(l_proc, 350);
6336:
6337:
6338: --Fix For Bug # 5987409 Starts -----
6339: /*
6346:
6347: --Fix For Bug # 5987409 Starts -----
6348: -- vb 10376122
6349:
6350: hr_utility.set_location('l_aplasg_vacancy_id'||l_aplasg_vacancy_id,180);
6351: hr_utility.set_location('l_aplasg_RECRUITER_ID'||l_aplasg_RECRUITER_ID,180);
6352:
6353: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,180);
6354: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,180);
6347: --Fix For Bug # 5987409 Starts -----
6348: -- vb 10376122
6349:
6350: hr_utility.set_location('l_aplasg_vacancy_id'||l_aplasg_vacancy_id,180);
6351: hr_utility.set_location('l_aplasg_RECRUITER_ID'||l_aplasg_RECRUITER_ID,180);
6352:
6353: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,180);
6354: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,180);
6355:
6349:
6350: hr_utility.set_location('l_aplasg_vacancy_id'||l_aplasg_vacancy_id,180);
6351: hr_utility.set_location('l_aplasg_RECRUITER_ID'||l_aplasg_RECRUITER_ID,180);
6352:
6353: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,180);
6354: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,180);
6355:
6356: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_aplasg_vacancy_id ,
6357: PAF.RECRUITER_ID = l_aplasg_RECRUITER_ID
6350: hr_utility.set_location('l_aplasg_vacancy_id'||l_aplasg_vacancy_id,180);
6351: hr_utility.set_location('l_aplasg_RECRUITER_ID'||l_aplasg_RECRUITER_ID,180);
6352:
6353: hr_utility.set_location('p_asg_rec.assignment_id'||p_asg_rec.assignment_id,180);
6354: hr_utility.set_location('l_asg_rec.assignment_id'||l_asg_rec.assignment_id,180);
6355:
6356: UPDATE PER_ASSIGNMENTS_F PAF SET PAF.VACANCY_ID =l_aplasg_vacancy_id ,
6357: PAF.RECRUITER_ID = l_aplasg_RECRUITER_ID
6358: WHERE PAF.ASSIGNMENT_ID = l_primary_asg_id AND
6401: ,p_datetrack_mode => 'DELETE'
6402: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
6403: );
6404: --
6405: hr_utility.set_location(l_proc, 360);
6406: --
6407: /*
6408: l_change_reason:=fnd_profile.value('HR_APL_CHNG_REASON'); -- 12905192
6409: if l_change_reason is not null then
6544: end if;
6545: --
6546: end loop;
6547: --
6548: hr_utility.set_location(l_proc,370);
6549:
6550: -- ER FPT
6551: for apl in fut_asg_rec
6552: loop
6549:
6550: -- ER FPT
6551: for apl in fut_asg_rec
6552: loop
6553: hr_utility.set_location('Processing Assignment ID = '||apl.assignment_id,195);
6554:
6555: l_fpt_hire_flag :='Y';
6556:
6557: -- retrieve the max end date of the ASG to update the APLN date_end
6613: end loop;
6614:
6615: if nvl(l_fpt_hire_flag,'N') = 'Y' then
6616:
6617: hr_utility.set_location('HR_EMPLOYEE_APPLICANT_API.HIRE_EMPLOYEE_APPLICANT',277);
6618:
6619: -- loop through the future applications > hire date
6620: for apl in csr_get_apln_details(l_hire_date)
6621: loop
6772: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
6773: p_assign_payroll_warning := l_assign_payroll_warning;
6774: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id ;
6775: --
6776: hr_utility.set_location(' Leaving:'||l_proc, 380);
6777: --
6778: exception
6779: when hr_api.validate_enabled then
6780: --
6794: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
6795: p_assign_payroll_warning := l_assign_payroll_warning;
6796: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id ;
6797: --
6798: hr_utility.set_location(' Leaving:'||l_proc, 390);
6799: --
6800: when others then
6801: --
6802: -- A validation or unexpected error has occurred
6812: --
6813: -- set in out parameters and set out parameters
6814: --
6815:
6816: hr_utility.set_location(' Leaving:'||l_proc, 400);
6817: raise;
6818: end hire_employee_applicant;
6819: --
6820: --