[Home] [Help]
83: --
84: if p_assignment_type not in ('E','A','B','O') then
85: --
86: hr_utility.set_message(801, 'HR_51176_ASG_INV_ASG_TYP_PBS');
87: hr_multi_message.add
88: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
89: );
90: --
91: end if;
97: fetch csr_chk_pay_basis into l_business_group_id;
98: if csr_chk_pay_basis%notfound then
99: close csr_chk_pay_basis;
100: hr_utility.set_message(801, 'HR_51168_ASG_INV_PAY_BASIS_ID');
101: hr_multi_message.add
102: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
103: );
104: else
105: close csr_chk_pay_basis;
111: --
112: If p_business_group_id <> l_business_group_id then
113: --
114: hr_utility.set_message(801, 'HR_51169_ASG_INV_PAY_BAS_BG');
115: hr_multi_message.add
116: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
117: );
118: --
119: end if;
136: --
137: if l_max_pp_chg_date > p_validation_start_date then
138: --
139: hr_utility.set_message(801, 'HR_51171_ASG_INV_PB_PP_CD');
140: hr_multi_message.add
141: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
142: );
143: --
144: end if;
436: --
437: if p_assignment_type not in ('E','A','B','O') then
438: --
439: hr_utility.set_message(801, 'HR_51226_ASG_INV_ASG_TYP_PAY');
440: hr_multi_message.add
441: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
442: );
443: --
444: end if;
466: -- of the employee assignment
467: --
468: if p_address_line1 is null then
469: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');
470: hr_multi_message.add
471: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
472: );
473: --
474: end if;
485: fetch csr_payroll_exists into l_exists;
486: if csr_payroll_exists%notfound then
487: close csr_payroll_exists;
488: hr_utility.set_message(801, 'HR_7370_ASG_INVALID_PAYROLL');
489: hr_multi_message.add
490: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
491: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
492: );
493: else
502: fetch csr_get_bus_grp into l_business_group_id;
503: if l_business_group_id <> p_business_group_id then
504: close csr_get_bus_grp;
505: hr_utility.set_message(801, 'HR_7373_ASG_INVALID_BG_PAYROLL');
506: hr_multi_message.add
507: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
508: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
509: );
510: else
518: if p_assignment_type = 'E' then
519: hr_utility.set_location(l_proc, 75);
520: if p_date_of_birth is null then
521: hr_utility.set_message(801, 'HR_7378_ASG_NO_DATE_OF_BIRTH');
522: hr_multi_message.add
523: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_OF_BIRTH'
524: );
525: end if;
526: hr_utility.set_location(l_proc, 80);
741: --
742: hr_utility.set_location(l_proc, 230);
743: --
744: hr_utility.set_message(801, 'HR_7969_ASG_INV_PAYROLL_PPMS');
745: hr_multi_message.add
746: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
747: );
748: end if;
749: end if;
772: --
773: close csr_any_future_asas;
774: --
775: hr_utility.set_message(801, 'HR_7975_ASG_INV_FUTURE_ASA');
776: hr_multi_message.add
777: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
778: );
779: else
780: --
887: fetch csr_valid_people_group into l_enabled_flag;
888: if csr_valid_people_group%notfound then
889: close csr_valid_people_group;
890: hr_utility.set_message(801, 'HR_7385_ASG_INV_PEOPLE_GROUP');
891: hr_multi_message.add
892: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
893: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
894: );
895: --
901: --
902: If l_enabled_flag <> 'Y' then
903: --
904: hr_utility.set_message(801, 'HR_51252_ASG_INV_PGP_ENBD_FLAG');
905: hr_multi_message.add
906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
907: );
908: --
909: end if;
919: fetch csr_valid_id_flex_num into l_exists;
920: if csr_valid_id_flex_num%notfound then
921: close csr_valid_id_flex_num;
922: hr_utility.set_message(801, 'HR_7386_ASG_INV_PEOP_GRP_LINK');
923: hr_multi_message.add
924: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
925: );
926: --
927: else
1007: --
1008: if p_assignment_type not in ('E','A','B','O') then
1009: --
1010: hr_utility.set_message(801, 'HR_51178_ASG_INV_ASG_TYP_PRPF');
1011: hr_multi_message.add
1012: (p_associated_column1 =>
1013: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1014: );
1015: --
1031: )
1032: then
1033: --
1034: hr_utility.set_message(801, 'HR_51149_ASG_INV_PRP_FREQ');
1035: hr_multi_message.add
1036: (p_associated_column1 =>
1037: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1038: );
1039: --
1115: --
1116: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1117: exception
1118: when app_exception.application_exception then
1119: if hr_multi_message.exception_add
1120: (p_associated_column1 =>
1121: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1122: ) then
1123: hr_utility.set_location(' Leaving:'|| l_proc, 6);
1144: --
1145: begin
1146: hr_utility.set_location('Entering:'|| l_proc, 1);
1147: --
1148: if hr_multi_message.no_exclusive_error
1149: (p_check_column1 =>
1150: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1151: ,p_check_column2 =>
1152: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1208: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1209: --
1210: exception
1211: when app_exception.application_exception then
1212: if hr_multi_message.exception_add
1213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1214: ,p_associated_column2 =>
1215: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1216: ) then
1303: --
1304: If p_period_of_service_id is not null then
1305: --
1306: hr_utility.set_message(801, 'HR_51203_ASG_INV_ASG_TYP_PDS');
1307: hr_multi_message.add
1308: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1309: );
1310: --
1311: end if;
1330: fetch csr_valid_pds into l_business_group_id, l_actual_termination_date;
1331: if csr_valid_pds%notfound then
1332: close csr_valid_pds;
1333: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
1334: hr_multi_message.add
1335: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1336: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1337: );
1338: --
1346: --
1347: If p_business_group_id <> l_business_group_id then
1348: --
1349: hr_utility.set_message(801, 'HR_51320_ASG_INV_PDS_BG');
1350: hr_multi_message.add
1351: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1352: );
1353: --
1354: end if;
1359: --
1360: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then
1361: --
1362: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1363: hr_multi_message.add
1364: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1365: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1366: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1367: );
1425: --
1426: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1431: ) then
1432: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1433: raise;
1516: --
1517: if p_assignment_type in ('E','B','C')then
1518: --
1519: hr_utility.set_message(801, 'HR_51224_ASG_INV_ASG_TYP_PRB');
1520: hr_multi_message.add
1521: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1522: );
1523: --
1524: end if;
1529: --
1530: If p_person_referred_by_id = p_person_id then
1531: --
1532: hr_utility.set_message(801, 'HR_51304_ASG_APL_EQUAL_PRB');
1533: hr_multi_message.add
1534: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1535: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1536: );
1537: --
1554: if p_assignment_type <> 'O'
1555: then
1556: --
1557: hr_utility.set_message(801, 'HR_51302_ASG_INV_PER_REF_BY');
1558: hr_multi_message.add
1559: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1560: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1561: );
1562: --
1574: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
1575: then
1576: --
1577: hr_utility.set_message(801, 'HR_51303_ASG_INV_PER_REF_BY_BG');
1578: hr_multi_message.add
1579: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1580: );
1581: --
1582: end if;
1591: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
1592: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1593: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1594: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1595: hr_multi_message.add
1596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');
1597: --
1598: end if;
1599: hr_utility.set_location(l_proc, 90);
1704: fetch csr_valid_pos into l_pos_bus_group_id;
1705: if csr_valid_pos%notfound then
1706: close csr_valid_pos;
1707: hr_utility.set_message(801, 'HR_51000_ASG_INVALID_POS');
1708: hr_multi_message.add
1709: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1710: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1711: );
1712: else
1719: --
1720: if l_pos_bus_group_id <> p_business_group_id then
1721: --
1722: hr_utility.set_message(801, 'HR_51009_ASG_INVALID_BG_POS');
1723: hr_multi_message.add
1724: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1725: );
1726: --
1727: end if;
1782: begin
1783: --
1784: hr_utility.set_location('Entering:'|| l_proc, 1);
1785: --
1786: if hr_multi_message.no_exclusive_error
1787: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1788: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
1789: ) then
1790: --
1907: begin
1908: --
1909: hr_utility.set_location('Entering:'|| l_proc, 1);
1910: --
1911: if hr_multi_message.no_exclusive_error
1912: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1913: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1914: ) then
1915: --
1977: --
1978: hr_utility.set_location('Leaving'||l_proc, 4);
1979: exception
1980: when app_exception.application_exception then
1981: if hr_multi_message.exception_add
1982: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1983: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1984: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1985: ) then
2026: --
2027: begin
2028: hr_utility.set_location('Entering:'|| l_proc, 10);
2029: --
2030: if hr_multi_message.no_exclusive_error
2031: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2032: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2033: ) then
2034: --
2085: fetch csr_valid_pos_job_comb into l_exists;
2086: if csr_valid_pos_job_comb%notfound then
2087: close csr_valid_pos_job_comb;
2088: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2089: hr_multi_message.add
2090: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2091: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2092: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2093: );
2099: --
2100: -- Position is not null but job is null
2101: --
2102: hr_utility.set_message(801, 'HR_51057_ASG_JOB_NULL_VALUE');
2103: hr_multi_message.add
2104: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2105: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2106: );
2107: --
2304: or p_assignment_type = 'O' then
2305: --
2306: hr_utility.set_message(801, 'HR_51198_ASG_INV_APL_ASG_PF');
2307: --
2308: hr_multi_message.add
2309: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG');
2310: --
2311: end if;
2312: --
2317: If p_validation_end_date <> hr_api.g_eot then
2318: --
2319: hr_utility.set_message(801, 'HR_51323_ASG_INV_PRIM_ASG_EED');
2320: --
2321: hr_multi_message.add
2322: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2323: --
2324: end if;
2325: --
2324: end if;
2325: --
2326: hr_utility.set_location(l_proc, 60);
2327: --
2328: if hr_multi_message.no_exclusive_error
2329: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2330: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2331: --
2332: hr_utility.set_location(l_proc, 70);
2343: close csr_cwk_asg_exists;
2344: --
2345: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2346: --
2347: hr_multi_message.add
2348: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2349: ,p_associated_column2 =>
2350: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');
2351: --
2371: close csr_asg_exists;
2372: --
2373: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2374: --
2375: hr_multi_message.add
2376: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2377: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');
2378: --
2379: else
2403: -- the entire date range of the non-primary assignment.
2404: --
2405: hr_utility.set_location(l_proc, 140);
2406: --
2407: if hr_multi_message.no_exclusive_error
2408: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2409: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2410: --
2411: hr_utility.set_location(l_proc, 150);
2425: close csr_ins_non_cwk_prim;
2426: --
2427: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2428: --
2429: hr_multi_message.add
2430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2431: ,p_associated_column2 =>
2432: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2433: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2480: close csr_ins_non_prim;
2481: --
2482: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2483: --
2484: hr_multi_message.add
2485: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2486: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2487: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2488: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2571: end if;
2572: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2573: exception
2574: when app_exception.application_exception then
2575: if hr_multi_message.exception_add
2576: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2577: ) then
2578: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2579: raise;
2671: --
2672: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2673: exception
2674: when app_exception.application_exception then
2675: if hr_multi_message.exception_add
2676: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2677: ) then
2678: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2679: raise;
2701: hr_utility.set_location('Entering:'|| l_proc, 1);
2702: --
2703: -- Check mandatory parameters have been set
2704: --
2705: if hr_multi_message.no_exclusive_error
2706: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2707: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2708: ) then
2709: hr_api.mandatory_arg_error
2754: --
2755: hr_utility.set_location(' Leaving:'|| l_proc, 4);
2756: exception
2757: when app_exception.application_exception then
2758: if hr_multi_message.exception_add
2759: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2760: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2761: ) then
2762: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2852: if p_assignment_type in ('E','C','B')
2853: then
2854: --
2855: hr_utility.set_message(801, 'HR_51216_ASG_INV_ASG_TYP_REC');
2856: hr_multi_message.add
2857: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2858: );
2859: --
2860: end if;
2865: --
2866: If p_recruiter_id = p_person_id then
2867: --
2868: hr_utility.set_message(801, 'HR_51289_ASG_APL_EQUAL_RECRUIT');
2869: hr_multi_message.add
2870: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2871: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2872: );
2873: --
2882: into l_business_group_id, l_current_employee_flag, l_current_npw_flag;
2883: if csr_val_recruiter%notfound then
2884: close csr_val_recruiter;
2885: hr_utility.set_message(801, 'HR_51280_ASG_INV_RECRUIT_ID');
2886: hr_multi_message.add
2887: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2888: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2889: );
2890: --
2901: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
2902: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2903: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2904: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2905: hr_multi_message.add
2906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');
2907: end if;
2908: hr_utility.set_location(l_proc, 100);
2909: --
2914: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N')
2915: then
2916: --
2917: hr_utility.set_message(801, 'HR_51284_ASG_INV_RECRUIT_BG');
2918: hr_multi_message.add
2919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2920: );
2921: --
2922: end if;
3008: --
3009: if p_assignment_type in ('E','C','B') then
3010: --
3011: hr_utility.set_message(801, 'HR_51223_ASG_INV_ASG_TYP_RCAT');
3012: hr_multi_message.add
3013: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3014: );
3015: --
3016: end if;
3029: --
3030: if p_assignment_type <> 'O'
3031: then
3032: hr_utility.set_message(801, 'HR_51306_ASG_INV_REC_ACT');
3033: hr_multi_message.add
3034: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3035: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3036: );
3037: --
3048: --
3049: If p_business_group_id <> l_business_group_id then
3050: --
3051: hr_utility.set_message(801, 'HR_51307_ASG_INV_REC_ACT_BG');
3052: hr_multi_message.add
3053: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3054: );
3055: --
3056: end if;
3455: --
3456: if p_assignment_type not in ('E','A','B','O') then
3457: --
3458: hr_utility.set_message(801, 'HR_51181_ASG_INV_ASG_TYP_SRPF');
3459: hr_multi_message.add
3460: (p_associated_column1 =>
3461: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3462: );
3463: --
3479: )
3480: then
3481: --
3482: hr_utility.set_message(801, 'HR_51164_ASG_INV_SRP_FREQ');
3483: hr_multi_message.add
3484: (p_associated_column1 =>
3485: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3486: );
3487: --
3561: --
3562: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3563: exception
3564: when app_exception.application_exception then
3565: if hr_multi_message.exception_add
3566: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3567: ) then
3568: hr_utility.set_location(' Leaving:'|| l_proc, 6);
3569: raise;
3589: --
3590: begin
3591: hr_utility.set_location('Entering:'|| l_proc, 1);
3592: --
3593: if hr_multi_message.no_exclusive_error
3594: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3595: ,p_check_column2 =>
3596: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3597: ) then
3647: --
3648: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3649: exception
3650: when app_exception.application_exception then
3651: if hr_multi_message.exception_add
3652: (p_associated_column1 =>
3653: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3654: ,p_associated_column2 =>
3655: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3769: end if;
3770: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3771: exception
3772: when app_exception.application_exception then
3773: if hr_multi_message.exception_add
3774: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'
3775: ) then
3776: hr_utility.set_location(' Leaving:'|| l_proc, 110);
3777: raise;
3875: --
3876: if p_assignment_type not in ('E','A','B','C','O') then
3877: --
3878: hr_utility.set_message(801, 'HR_51227_ASG_INV_ASG_TYP_SCF');
3879: hr_multi_message.add
3880: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3881: );
3882: --
3883: end if;
3890: fetch csr_valid_keyflex into l_exists;
3891: if csr_valid_keyflex%notfound then
3892: close csr_valid_keyflex;
3893: hr_utility.set_message(801, 'HR_7383_ASG_INV_KEYFLEX');
3894: hr_multi_message.add
3895: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3896: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3897: );
3898: else
3928: hr_utility.set_message(801, 'HR_34024_IP_INV_LEG_ENT');
3929: end if;
3930: close csr_tax_unit_message;
3931: end if;
3932: hr_multi_message.add
3933: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
3934: );
3935: else
3936: close csr_pay_legislation_rules;
4027: --
4028: If l_api_updating then
4029: --
4030: hr_utility.set_message(801, 'HR_51220_ASG_INV_EASG_U_SORG');
4031: hr_multi_message.add
4032: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4033: );
4034: --
4035: else -- inserting an employee assignment
4034: --
4035: else -- inserting an employee assignment
4036: --
4037: hr_utility.set_message(801, 'HR_51219_ASG_INV_EASG_I_SORG');
4038: hr_multi_message.add
4039: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4040: );
4041: --
4042: end if;
4053: fetch csr_val_source_org_id into l_business_group_id;
4054: if csr_val_source_org_id%notfound then
4055: close csr_val_source_org_id;
4056: hr_utility.set_message(801, 'HR_51308_ASG_INV_SOURCE_ORG');
4057: hr_multi_message.add
4058: (p_associated_column1 =>
4059: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4060: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4061: );
4070: --
4071: If p_business_group_id <> l_business_group_id then
4072: --
4073: hr_utility.set_message(801, 'HR_51309_ASG_INV_SOURCE_ORG_BG');
4074: hr_multi_message.add
4075: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4076: );
4077: --
4078: end if;
4168: )
4169: then
4170: --
4171: hr_utility.set_message(801, 'HR_51162_ASG_INV_SOURCE_TYPE');
4172: hr_multi_message.add
4173: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4174: );
4175: --
4176: end if;
4190: --
4191: If p_source_type <> nvl(l_rec_act_type, hr_api.g_varchar2) then
4192: --
4193: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4194: hr_multi_message.add
4195: (p_associated_column1 =>
4196: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
4197: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4198: );
4342: --
4343: if p_assignment_type not in ('E','A','B','O') then
4344: --
4345: hr_utility.set_message(801, 'HR_51225_ASG_INV_ASG_TYP_SCS');
4346: hr_multi_message.add
4347: (p_associated_column1 =>
4348: 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4349: );
4350: --
4358: fetch csr_valid_step into l_exists;
4359: if csr_valid_step%notfound then
4360: close csr_valid_step;
4361: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
4362: hr_multi_message.add
4363: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4364: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4365: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4366: );
4377: fetch csr_get_bus_grp into l_business_group_id;
4378: if l_business_group_id <> p_business_group_id then
4379: close csr_get_bus_grp;
4380: hr_utility.set_message(801, 'HR_7375_ASG_INV_BG_SP_CLG_STEP');
4381: hr_multi_message.add
4382: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4383: );
4384: else
4385: close csr_get_bus_grp;
4385: close csr_get_bus_grp;
4386: end if;
4387: hr_utility.set_location(l_proc, 70);
4388: --
4389: if hr_multi_message.no_exclusive_error
4390: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4391: ) then
4392: --
4393: -- Check that the special_ceiling_step_id is valid for the grade
4398: fetch csr_valid_step_grade into l_sequence;
4399: if csr_valid_step_grade%notfound then
4400: close csr_valid_step_grade;
4401: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4402: hr_multi_message.add
4403: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4404: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4405: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4406: );
4413: -- If the value for special ceiling step is not null
4414: -- then grade id must also be not null
4415: --
4416: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
4417: hr_multi_message.add
4418: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4419: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4420: );
4421: end if;
4432: fetch csr_low_step into l_exists;
4433: if csr_low_step%found then
4434: close csr_low_step;
4435: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4436: hr_multi_message.add
4437: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4438: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4439: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4440: );
4511: --
4512: begin
4513: hr_utility.set_location('Entering:'|| l_proc, 10);
4514: --
4515: if hr_multi_message.no_exclusive_error
4516: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4517: ) then
4518: --
4519: -- Check mandatory parameters have been set
4570: --
4571: If p_supervisor_id = p_person_id then
4572: --
4573: hr_utility.set_message(801, 'HR_51143_ASG_EMP_EQUAL_SUP');
4574: hr_multi_message.add
4575: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4576: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4577: );
4578: end if;
4591: --
4592: If l_per_party_id = l_sup_party_id
4593: then
4594: hr_utility.set_message(800, 'HR_449603_ASG_SUP_DUP_PER');
4595: hr_multi_message.add
4596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4597: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4598: );
4599: end if;
4611: if csr_valid_supervisor_id%notfound then
4612: close csr_valid_supervisor_id;
4613: --
4614: hr_utility.set_message(801, 'PAY_7599_SYS_SUP_DT_OUTDATE');
4615: hr_multi_message.add
4616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4617: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4618: );
4619: else
4628: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
4629: then
4630: --
4631: hr_utility.set_message(801, 'HR_51145_ASG_SUP_BG_NE_EMP_BG');
4632: hr_multi_message.add
4633: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4634: );
4635: end if;
4636: hr_utility.set_location(l_proc, 70);
4651: close csr_asg_typ;
4652: if l_assignment_type in ('C','E','B') then
4653: --
4654: hr_utility.set_message(801, 'HR_51346_ASG_SUP_NOT_EMP');
4655: hr_multi_message.add
4656: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID');
4657: --
4658: end if;
4659: --Bug#3917021 ends here
4698: --
4699: begin
4700: hr_utility.set_location('Entering:'|| l_proc, 10);
4701: --
4702: if hr_multi_message.no_exclusive_error
4703: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4704: ) then
4705: --
4706: -- Check mandatory parameters have been set
4776: close csr_supervisor_assignment_id;
4777: --
4778: hr_utility.set_message(800, 'HR_50146_SUP_ASG_INVALID');
4779: hr_utility.raise_error;
4780: /* hr_multi_message.add
4781: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4782: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4783: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4784: ); */
4799: --
4800: hr_utility.set_location(l_proc, 80);
4801: hr_utility.set_message(800, 'HR_50147_SUP_ASG_WRONG_TYPE');
4802: hr_utility.raise_error;
4803: /*hr_multi_message.add
4804: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4805: ); */
4806: --
4807: end if;
4914: hr_utility.set_location(' Leaving:'|| l_proc, 4);
4915: --
4916: exception
4917: when app_exception.application_exception then
4918: if hr_multi_message.exception_add
4919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4920: ) then
4921: hr_utility.set_location(' Leaving:'|| l_proc, 5);
4922: raise;
4989: fetch csr_chk_term_status into l_exists;
4990: if csr_chk_term_status%found then
4991: close csr_chk_term_status;
4992: hr_utility.set_message(801, 'HR_7412_ASG_ASS_TERM_IN_FUTURE');
4993: hr_multi_message.add
4994: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'
4995: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4996: );
4997: else
5032: --
5033: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5034: exception
5035: when app_exception.application_exception then
5036: if hr_multi_message.exception_add
5037: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'
5038: ) then
5039: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5040: raise;
5084: --
5085: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5086: exception
5087: when app_exception.application_exception then
5088: if hr_multi_message.exception_add
5089: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'
5090: ) then
5091: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5092: raise;
5164: --
5165: end if;
5166: exception
5167: when app_exception.application_exception then
5168: if hr_multi_message.exception_add
5169: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5170: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5171: ) then
5172: hr_utility.set_location(' Leaving:'|| l_proc, 30);
5265: --
5266: If l_api_updating then
5267: --
5268: hr_utility.set_message(801, 'HR_51222_ASG_INV_EASG_U_VAC');
5269: hr_multi_message.add
5270: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5271: );
5272: --
5273: else -- inserting a non employee
5272: --
5273: else -- inserting a non employee
5274: --
5275: hr_utility.set_message(801, 'HR_51221_ASG_INV_EASG_I_VAC');
5276: hr_multi_message.add
5277: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5278: );
5279: --
5280: end if;
5312: if csr_val_vacancy_id%notfound then
5313: close csr_val_vacancy_id;
5314: hr_utility.set_message(801, 'HR_51297_ASG_INV_VACANCY');
5315: hr_utility.raise_error;
5316: /* hr_multi_message.add
5317: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5318: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5319: ); */
5320: --
5366: --
5367: begin
5368: hr_utility.set_location('Entering:'|| l_proc, 1);
5369: --
5370: if hr_multi_message.no_exclusive_error
5371: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5372: ) then
5373: --
5374: -- Check mandatory parameters have been set
5663: --
5664: hr_utility.set_location(' Leaving:'|| l_proc, 60);
5665: exception
5666: when app_exception.application_exception then
5667: if hr_multi_message.exception_add
5668: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'
5669: ) then
5670: hr_utility.set_location(' Leaving:'|| l_proc, 70);
5671: raise;
5755: end if;
5756: hr_utility.set_location('Leaving:'|| l_proc, 70);
5757: exception
5758: when app_exception.application_exception then
5759: if hr_multi_message.exception_add
5760: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'
5761: ) then
5762: raise;
5763: end if;
5855: end if;
5856: hr_utility.set_location('Leaving: '||l_proc, 50);
5857: exception
5858: when app_exception.application_exception then
5859: if hr_multi_message.exception_add
5860: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'
5861: ) then
5862: raise;
5863: end if;