[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;
446: --
447: if p_assignment_type not in ('E','A','B','O') then
448: --
449: hr_utility.set_message(801, 'HR_51226_ASG_INV_ASG_TYP_PAY');
450: hr_multi_message.add
451: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
452: );
453: --
454: end if;
476: -- of the employee assignment
477: --
478: if p_address_line1 is null then
479: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');
480: hr_multi_message.add
481: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
482: );
483: --
484: end if;
495: if l_style not in ('US','US_GLB_FED') then --10409507
496: if hr_general2.is_legislation_install('PAY','US') then --11933456
497: hr_utility.set_location(l_proc, 54);
498: hr_utility.set_message(800, 'HR_51283_ADD_MUST_BE_US_STYLE');
499: hr_multi_message.add
500: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
501: );
502:
503: end if;
520: fetch csr_payroll_exists into l_exists;
521: if csr_payroll_exists%notfound then
522: close csr_payroll_exists;
523: hr_utility.set_message(801, 'HR_7370_ASG_INVALID_PAYROLL');
524: hr_multi_message.add
525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
527: );
528: else
537: fetch csr_get_bus_grp into l_business_group_id;
538: if l_business_group_id <> p_business_group_id then
539: close csr_get_bus_grp;
540: hr_utility.set_message(801, 'HR_7373_ASG_INVALID_BG_PAYROLL');
541: hr_multi_message.add
542: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
543: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
544: );
545: else
553: if p_assignment_type = 'E' then
554: hr_utility.set_location(l_proc, 75);
555: if p_date_of_birth is null then
556: hr_utility.set_message(801, 'HR_7378_ASG_NO_DATE_OF_BIRTH');
557: hr_multi_message.add
558: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_OF_BIRTH'
559: );
560: end if;
561: hr_utility.set_location(l_proc, 80);
777: --
778: hr_utility.set_location(l_proc, 230);
779: --
780: hr_utility.set_message(801, 'HR_7969_ASG_INV_PAYROLL_PPMS');
781: hr_multi_message.add
782: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
783: );
784: end if;
785: end if;
812: --
813: close csr_any_future_asas;
814: --
815: hr_utility.set_message(801, 'HR_7975_ASG_INV_FUTURE_ASA');
816: hr_multi_message.add
817: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
818: );
819: else
820: --
927: fetch csr_valid_people_group into l_enabled_flag;
928: if csr_valid_people_group%notfound then
929: close csr_valid_people_group;
930: hr_utility.set_message(801, 'HR_7385_ASG_INV_PEOPLE_GROUP');
931: hr_multi_message.add
932: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
933: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
934: );
935: --
941: --
942: If l_enabled_flag <> 'Y' then
943: --
944: hr_utility.set_message(801, 'HR_51252_ASG_INV_PGP_ENBD_FLAG');
945: hr_multi_message.add
946: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
947: );
948: --
949: end if;
959: fetch csr_valid_id_flex_num into l_exists;
960: if csr_valid_id_flex_num%notfound then
961: close csr_valid_id_flex_num;
962: hr_utility.set_message(801, 'HR_7386_ASG_INV_PEOP_GRP_LINK');
963: hr_multi_message.add
964: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
965: );
966: --
967: else
1047: --
1048: if p_assignment_type not in ('E','A','B','O') then
1049: --
1050: hr_utility.set_message(801, 'HR_51178_ASG_INV_ASG_TYP_PRPF');
1051: hr_multi_message.add
1052: (p_associated_column1 =>
1053: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1054: );
1055: --
1071: )
1072: then
1073: --
1074: hr_utility.set_message(801, 'HR_51149_ASG_INV_PRP_FREQ');
1075: hr_multi_message.add
1076: (p_associated_column1 =>
1077: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1078: );
1079: --
1155: --
1156: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1157: exception
1158: when app_exception.application_exception then
1159: if hr_multi_message.exception_add
1160: (p_associated_column1 =>
1161: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1162: ) then
1163: hr_utility.set_location(' Leaving:'|| l_proc, 6);
1184: --
1185: begin
1186: hr_utility.set_location('Entering:'|| l_proc, 1);
1187: --
1188: if hr_multi_message.no_exclusive_error
1189: (p_check_column1 =>
1190: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1191: ,p_check_column2 =>
1192: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1248: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1249: --
1250: exception
1251: when app_exception.application_exception then
1252: if hr_multi_message.exception_add
1253: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1254: ,p_associated_column2 =>
1255: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1256: ) then
1343: --
1344: If p_period_of_service_id is not null then
1345: --
1346: hr_utility.set_message(801, 'HR_51203_ASG_INV_ASG_TYP_PDS');
1347: hr_multi_message.add
1348: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1349: );
1350: --
1351: end if;
1370: fetch csr_valid_pds into l_business_group_id, l_actual_termination_date;
1371: if csr_valid_pds%notfound then
1372: close csr_valid_pds;
1373: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
1374: hr_multi_message.add
1375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1377: );
1378: --
1386: --
1387: If p_business_group_id <> l_business_group_id then
1388: --
1389: hr_utility.set_message(801, 'HR_51320_ASG_INV_PDS_BG');
1390: hr_multi_message.add
1391: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1392: );
1393: --
1394: end if;
1399: --
1400: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then
1401: --
1402: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1403: hr_multi_message.add
1404: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1405: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1406: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1407: );
1465: --
1466: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1467: exception
1468: when app_exception.application_exception then
1469: if hr_multi_message.exception_add
1470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1471: ) then
1472: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1473: raise;
1556: --
1557: if p_assignment_type in ('E','B','C')then
1558: --
1559: hr_utility.set_message(801, 'HR_51224_ASG_INV_ASG_TYP_PRB');
1560: hr_multi_message.add
1561: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1562: );
1563: --
1564: end if;
1569: --
1570: If p_person_referred_by_id = p_person_id then
1571: --
1572: hr_utility.set_message(801, 'HR_51304_ASG_APL_EQUAL_PRB');
1573: hr_multi_message.add
1574: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1575: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1576: );
1577: --
1594: if p_assignment_type <> 'O'
1595: then
1596: --
1597: hr_utility.set_message(801, 'HR_51302_ASG_INV_PER_REF_BY');
1598: hr_multi_message.add
1599: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1600: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1601: );
1602: --
1614: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
1615: then
1616: --
1617: hr_utility.set_message(801, 'HR_51303_ASG_INV_PER_REF_BY_BG');
1618: hr_multi_message.add
1619: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1620: );
1621: --
1622: end if;
1631: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
1632: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1633: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1634: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1635: hr_multi_message.add
1636: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');
1637: --
1638: end if;
1639: hr_utility.set_location(l_proc, 90);
1744: fetch csr_valid_pos into l_pos_bus_group_id;
1745: if csr_valid_pos%notfound then
1746: close csr_valid_pos;
1747: hr_utility.set_message(801, 'HR_51000_ASG_INVALID_POS');
1748: hr_multi_message.add
1749: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1750: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1751: );
1752: else
1759: --
1760: if l_pos_bus_group_id <> p_business_group_id then
1761: --
1762: hr_utility.set_message(801, 'HR_51009_ASG_INVALID_BG_POS');
1763: hr_multi_message.add
1764: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1765: );
1766: --
1767: end if;
1822: begin
1823: --
1824: hr_utility.set_location('Entering:'|| l_proc, 1);
1825: --
1826: if hr_multi_message.no_exclusive_error
1827: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1828: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
1829: ) then
1830: --
1947: begin
1948: --
1949: hr_utility.set_location('Entering:'|| l_proc, 1);
1950: --
1951: if hr_multi_message.no_exclusive_error
1952: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1953: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1954: ) then
1955: --
2017: --
2018: hr_utility.set_location('Leaving'||l_proc, 4);
2019: exception
2020: when app_exception.application_exception then
2021: if hr_multi_message.exception_add
2022: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2023: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
2024: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2025: ) then
2066: --
2067: begin
2068: hr_utility.set_location('Entering:'|| l_proc, 10);
2069: --
2070: if hr_multi_message.no_exclusive_error
2071: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2072: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2073: ) then
2074: --
2125: fetch csr_valid_pos_job_comb into l_exists;
2126: if csr_valid_pos_job_comb%notfound then
2127: close csr_valid_pos_job_comb;
2128: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2129: hr_multi_message.add
2130: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2131: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2132: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2133: );
2139: --
2140: -- Position is not null but job is null
2141: --
2142: hr_utility.set_message(801, 'HR_51057_ASG_JOB_NULL_VALUE');
2143: hr_multi_message.add
2144: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2145: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2146: );
2147: --
2344: or p_assignment_type = 'O' then
2345: --
2346: hr_utility.set_message(801, 'HR_51198_ASG_INV_APL_ASG_PF');
2347: --
2348: hr_multi_message.add
2349: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG');
2350: --
2351: end if;
2352: --
2357: If p_validation_end_date <> hr_api.g_eot then
2358: --
2359: hr_utility.set_message(801, 'HR_51323_ASG_INV_PRIM_ASG_EED');
2360: --
2361: hr_multi_message.add
2362: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2363: --
2364: end if;
2365: --
2364: end if;
2365: --
2366: hr_utility.set_location(l_proc, 60);
2367: --
2368: if hr_multi_message.no_exclusive_error
2369: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2370: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2371: --
2372: hr_utility.set_location(l_proc, 70);
2383: close csr_cwk_asg_exists;
2384: --
2385: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2386: --
2387: hr_multi_message.add
2388: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2389: ,p_associated_column2 =>
2390: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');
2391: --
2411: close csr_asg_exists;
2412: --
2413: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2414: --
2415: hr_multi_message.add
2416: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2417: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');
2418: --
2419: else
2443: -- the entire date range of the non-primary assignment.
2444: --
2445: hr_utility.set_location(l_proc, 140);
2446: --
2447: if hr_multi_message.no_exclusive_error
2448: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2449: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2450: --
2451: hr_utility.set_location(l_proc, 150);
2465: close csr_ins_non_cwk_prim;
2466: --
2467: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2468: --
2469: hr_multi_message.add
2470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2471: ,p_associated_column2 =>
2472: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2473: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2520: close csr_ins_non_prim;
2521: --
2522: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2523: --
2524: hr_multi_message.add
2525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2527: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2528: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2611: end if;
2612: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2613: exception
2614: when app_exception.application_exception then
2615: if hr_multi_message.exception_add
2616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2617: ) then
2618: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2619: raise;
2711: --
2712: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2713: exception
2714: when app_exception.application_exception then
2715: if hr_multi_message.exception_add
2716: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2717: ) then
2718: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2719: raise;
2741: hr_utility.set_location('Entering:'|| l_proc, 1);
2742: --
2743: -- Check mandatory parameters have been set
2744: --
2745: if hr_multi_message.no_exclusive_error
2746: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2747: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2748: ) then
2749: hr_api.mandatory_arg_error
2794: --
2795: hr_utility.set_location(' Leaving:'|| l_proc, 4);
2796: exception
2797: when app_exception.application_exception then
2798: if hr_multi_message.exception_add
2799: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2800: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2801: ) then
2802: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2892: if p_assignment_type in ('E','C','B')
2893: then
2894: --
2895: hr_utility.set_message(801, 'HR_51216_ASG_INV_ASG_TYP_REC');
2896: hr_multi_message.add
2897: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2898: );
2899: --
2900: end if;
2905: --
2906: If p_recruiter_id = p_person_id then
2907: --
2908: hr_utility.set_message(801, 'HR_51289_ASG_APL_EQUAL_RECRUIT');
2909: hr_multi_message.add
2910: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2911: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2912: );
2913: --
2922: into l_business_group_id, l_current_employee_flag, l_current_npw_flag;
2923: if csr_val_recruiter%notfound then
2924: close csr_val_recruiter;
2925: hr_utility.set_message(801, 'HR_51280_ASG_INV_RECRUIT_ID');
2926: hr_multi_message.add
2927: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2928: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2929: );
2930: --
2941: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
2942: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2943: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2944: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2945: hr_multi_message.add
2946: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');
2947: end if;
2948: hr_utility.set_location(l_proc, 100);
2949: --
2954: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N')
2955: then
2956: --
2957: hr_utility.set_message(801, 'HR_51284_ASG_INV_RECRUIT_BG');
2958: hr_multi_message.add
2959: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2960: );
2961: --
2962: end if;
3048: --
3049: if p_assignment_type in ('E','C','B') then
3050: --
3051: hr_utility.set_message(801, 'HR_51223_ASG_INV_ASG_TYP_RCAT');
3052: hr_multi_message.add
3053: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3054: );
3055: --
3056: end if;
3069: --
3070: if p_assignment_type <> 'O'
3071: then
3072: hr_utility.set_message(801, 'HR_51306_ASG_INV_REC_ACT');
3073: hr_multi_message.add
3074: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3075: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3076: );
3077: --
3088: --
3089: If p_business_group_id <> l_business_group_id then
3090: --
3091: hr_utility.set_message(801, 'HR_51307_ASG_INV_REC_ACT_BG');
3092: hr_multi_message.add
3093: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3094: );
3095: --
3096: end if;
3495: --
3496: if p_assignment_type not in ('E','A','B','O') then
3497: --
3498: hr_utility.set_message(801, 'HR_51181_ASG_INV_ASG_TYP_SRPF');
3499: hr_multi_message.add
3500: (p_associated_column1 =>
3501: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3502: );
3503: --
3519: )
3520: then
3521: --
3522: hr_utility.set_message(801, 'HR_51164_ASG_INV_SRP_FREQ');
3523: hr_multi_message.add
3524: (p_associated_column1 =>
3525: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3526: );
3527: --
3601: --
3602: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3603: exception
3604: when app_exception.application_exception then
3605: if hr_multi_message.exception_add
3606: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3607: ) then
3608: hr_utility.set_location(' Leaving:'|| l_proc, 6);
3609: raise;
3629: --
3630: begin
3631: hr_utility.set_location('Entering:'|| l_proc, 1);
3632: --
3633: if hr_multi_message.no_exclusive_error
3634: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3635: ,p_check_column2 =>
3636: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3637: ) then
3687: --
3688: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3689: exception
3690: when app_exception.application_exception then
3691: if hr_multi_message.exception_add
3692: (p_associated_column1 =>
3693: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3694: ,p_associated_column2 =>
3695: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3809: end if;
3810: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3811: exception
3812: when app_exception.application_exception then
3813: if hr_multi_message.exception_add
3814: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'
3815: ) then
3816: hr_utility.set_location(' Leaving:'|| l_proc, 110);
3817: raise;
3915: --
3916: if p_assignment_type not in ('E','A','B','C','O') then
3917: --
3918: hr_utility.set_message(801, 'HR_51227_ASG_INV_ASG_TYP_SCF');
3919: hr_multi_message.add
3920: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3921: );
3922: --
3923: end if;
3930: fetch csr_valid_keyflex into l_exists;
3931: if csr_valid_keyflex%notfound then
3932: close csr_valid_keyflex;
3933: hr_utility.set_message(801, 'HR_7383_ASG_INV_KEYFLEX');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3936: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3937: );
3938: else
3968: hr_utility.set_message(801, 'HR_34024_IP_INV_LEG_ENT');
3969: end if;
3970: close csr_tax_unit_message;
3971: end if;
3972: hr_multi_message.add
3973: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
3974: );
3975: else
3976: close csr_pay_legislation_rules;
4067: --
4068: If l_api_updating then
4069: --
4070: hr_utility.set_message(801, 'HR_51220_ASG_INV_EASG_U_SORG');
4071: hr_multi_message.add
4072: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4073: );
4074: --
4075: else -- inserting an employee assignment
4074: --
4075: else -- inserting an employee assignment
4076: --
4077: hr_utility.set_message(801, 'HR_51219_ASG_INV_EASG_I_SORG');
4078: hr_multi_message.add
4079: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4080: );
4081: --
4082: end if;
4093: fetch csr_val_source_org_id into l_business_group_id;
4094: if csr_val_source_org_id%notfound then
4095: close csr_val_source_org_id;
4096: hr_utility.set_message(801, 'HR_51308_ASG_INV_SOURCE_ORG');
4097: hr_multi_message.add
4098: (p_associated_column1 =>
4099: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4100: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4101: );
4110: --
4111: If p_business_group_id <> l_business_group_id then
4112: --
4113: hr_utility.set_message(801, 'HR_51309_ASG_INV_SOURCE_ORG_BG');
4114: hr_multi_message.add
4115: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4116: );
4117: --
4118: end if;
4208: )
4209: then
4210: --
4211: hr_utility.set_message(801, 'HR_51162_ASG_INV_SOURCE_TYPE');
4212: hr_multi_message.add
4213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4214: );
4215: --
4216: end if;
4230: --
4231: If p_source_type <> nvl(l_rec_act_type, hr_api.g_varchar2) then
4232: --
4233: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4234: hr_multi_message.add
4235: (p_associated_column1 =>
4236: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
4237: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4238: );
4382: --
4383: if p_assignment_type not in ('E','A','B','O') then
4384: --
4385: hr_utility.set_message(801, 'HR_51225_ASG_INV_ASG_TYP_SCS');
4386: hr_multi_message.add
4387: (p_associated_column1 =>
4388: 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4389: );
4390: --
4398: fetch csr_valid_step into l_exists;
4399: if csr_valid_step%notfound then
4400: close csr_valid_step;
4401: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
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.EFFECTIVE_END_DATE'
4406: );
4417: fetch csr_get_bus_grp into l_business_group_id;
4418: if l_business_group_id <> p_business_group_id then
4419: close csr_get_bus_grp;
4420: hr_utility.set_message(801, 'HR_7375_ASG_INV_BG_SP_CLG_STEP');
4421: hr_multi_message.add
4422: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4423: );
4424: else
4425: close csr_get_bus_grp;
4425: close csr_get_bus_grp;
4426: end if;
4427: hr_utility.set_location(l_proc, 70);
4428: --
4429: if hr_multi_message.no_exclusive_error
4430: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4431: ) then
4432: --
4433: -- Check that the special_ceiling_step_id is valid for the grade
4438: fetch csr_valid_step_grade into l_sequence;
4439: if csr_valid_step_grade%notfound then
4440: close csr_valid_step_grade;
4441: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4442: hr_multi_message.add
4443: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4444: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4445: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4446: );
4453: -- If the value for special ceiling step is not null
4454: -- then grade id must also be not null
4455: --
4456: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
4457: hr_multi_message.add
4458: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4459: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4460: );
4461: end if;
4472: fetch csr_low_step into l_exists;
4473: if csr_low_step%found then
4474: close csr_low_step;
4475: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4476: hr_multi_message.add
4477: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4478: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4479: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4480: );
4561: --
4562: begin
4563: hr_utility.set_location('Entering:'|| l_proc, 10);
4564: --
4565: if hr_multi_message.no_exclusive_error
4566: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4567: ) then
4568: --
4569: -- Check mandatory parameters have been set
4620: --
4621: If p_supervisor_id = p_person_id then
4622: --
4623: hr_utility.set_message(801, 'HR_51143_ASG_EMP_EQUAL_SUP');
4624: hr_multi_message.add
4625: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4626: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4627: );
4628: end if;
4641: --
4642: If l_per_party_id = l_sup_party_id
4643: then
4644: hr_utility.set_message(800, 'HR_449603_ASG_SUP_DUP_PER');
4645: hr_multi_message.add
4646: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4647: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4648: );
4649: end if;
4683: if csr_valid_supervisor_id%notfound then
4684: close csr_valid_supervisor_id;
4685: --
4686: hr_utility.set_message(801, 'PAY_7599_SYS_SUP_DT_OUTDATE');
4687: hr_multi_message.add
4688: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4689: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4690: );
4691: else
4701: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N')
4702: then
4703: --
4704: hr_utility.set_message(801, 'HR_51145_ASG_SUP_BG_NE_EMP_BG');
4705: hr_multi_message.add
4706: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4707: );
4708: end if;
4709: hr_utility.set_location(l_proc, 70);
4724: close csr_asg_typ;
4725: if l_assignment_type in ('C','E','B') then
4726: --
4727: hr_utility.set_message(801, 'HR_51346_ASG_SUP_NOT_EMP');
4728: hr_multi_message.add
4729: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID');
4730: --
4731: end if;
4732: --Bug#3917021 ends here
4771: --
4772: begin
4773: hr_utility.set_location('Entering:'|| l_proc, 10);
4774: --
4775: if hr_multi_message.no_exclusive_error
4776: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4777: ) then
4778: --
4779: -- Check mandatory parameters have been set
4849: close csr_supervisor_assignment_id;
4850: --
4851: hr_utility.set_message(800, 'HR_50146_SUP_ASG_INVALID');
4852: hr_utility.raise_error;
4853: /* hr_multi_message.add
4854: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4855: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4856: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4857: ); */
4872: --
4873: hr_utility.set_location(l_proc, 80);
4874: hr_utility.set_message(800, 'HR_50147_SUP_ASG_WRONG_TYPE');
4875: hr_utility.raise_error;
4876: /*hr_multi_message.add
4877: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4878: ); */
4879: --
4880: end if;
4992: hr_utility.set_location(' Leaving:'|| l_proc, 4);
4993: --
4994: exception
4995: when app_exception.application_exception then
4996: if hr_multi_message.exception_add
4997: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4998: ) then
4999: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5000: raise;
5067: fetch csr_chk_term_status into l_exists;
5068: if csr_chk_term_status%found then
5069: close csr_chk_term_status;
5070: hr_utility.set_message(801, 'HR_7412_ASG_ASS_TERM_IN_FUTURE');
5071: hr_multi_message.add
5072: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'
5073: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5074: );
5075: else
5110: --
5111: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5112: exception
5113: when app_exception.application_exception then
5114: if hr_multi_message.exception_add
5115: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'
5116: ) then
5117: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5118: raise;
5162: --
5163: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5164: exception
5165: when app_exception.application_exception then
5166: if hr_multi_message.exception_add
5167: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'
5168: ) then
5169: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5170: raise;
5370: end if;
5371:
5372: exception
5373: when app_exception.application_exception then
5374: if hr_multi_message.exception_add
5375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5377: ) then
5378: hr_utility.set_location(' Leaving:'|| l_proc, 30);
5470: --
5471: If l_api_updating then
5472: --
5473: hr_utility.set_message(801, 'HR_51222_ASG_INV_EASG_U_VAC');
5474: hr_multi_message.add
5475: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5476: );
5477: --
5478: else -- inserting a non employee
5477: --
5478: else -- inserting a non employee
5479: --
5480: hr_utility.set_message(801, 'HR_51221_ASG_INV_EASG_I_VAC');
5481: hr_multi_message.add
5482: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5483: );
5484: --
5485: end if;
5517: if csr_val_vacancy_id%notfound then
5518: close csr_val_vacancy_id;
5519: hr_utility.set_message(801, 'HR_51297_ASG_INV_VACANCY');
5520: hr_utility.raise_error;
5521: /* hr_multi_message.add
5522: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5523: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5524: ); */
5525: --
5571: --
5572: begin
5573: hr_utility.set_location('Entering:'|| l_proc, 1);
5574: --
5575: if hr_multi_message.no_exclusive_error
5576: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5577: ) then
5578: --
5579: -- Check mandatory parameters have been set
5868: --
5869: hr_utility.set_location(' Leaving:'|| l_proc, 60);
5870: exception
5871: when app_exception.application_exception then
5872: if hr_multi_message.exception_add
5873: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'
5874: ) then
5875: hr_utility.set_location(' Leaving:'|| l_proc, 70);
5876: raise;
5960: end if;
5961: hr_utility.set_location('Leaving:'|| l_proc, 70);
5962: exception
5963: when app_exception.application_exception then
5964: if hr_multi_message.exception_add
5965: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'
5966: ) then
5967: raise;
5968: end if;
6060: end if;
6061: hr_utility.set_location('Leaving: '||l_proc, 50);
6062: exception
6063: when app_exception.application_exception then
6064: if hr_multi_message.exception_add
6065: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'
6066: ) then
6067: raise;
6068: end if;