[Home] [Help]
59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: fnd_message.raise_error;
65: --
66: else
67: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: fnd_message.raise_error;
65: --
66: else
67: close csr_sec_grp;
68: --
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
146: -- Set the global variables so the values are
376: IF NOT hr_pdt_shd.api_updating
377: (p_person_deployment_id => p_rec.person_deployment_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
377: (p_person_deployment_id => p_rec.person_deployment_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --
386: if nvl(p_rec.from_business_group_id,hr_api.g_number)
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --
386: if nvl(p_rec.from_business_group_id,hr_api.g_number)
387: <> nvl(hr_pdt_shd.g_old_rec.from_business_group_id,hr_api.g_number) then
477: open csr_bg_exists(p_from_business_group_id);
478: fetch csr_bg_exists into l_dummy;
479: if csr_bg_exists%notfound then
480: close csr_bg_exists;
481: fnd_message.set_name('PER','HR_449627_PDT_FROM_BG_NOTEXIST');
482: hr_multi_message.add
483: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID');
484: else
485: close csr_bg_exists;
488: open csr_bg_exists(p_to_business_group_id);
489: fetch csr_bg_exists into l_dummy;
490: if csr_bg_exists%notfound then
491: close csr_bg_exists;
492: fnd_message.set_name('PER','HR_449628_PDT_TO_BG_NOTEXIST');
493: hr_multi_message.add
494: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID');
495: else
496: close csr_bg_exists;
596: fetch csr_check_person into l_dummy;
597: if csr_check_person%notfound then
598: close csr_check_person;
599: --
600: fnd_message.set_name('PER','HR_449629_PDT_FR_PER_NOTEXIST');
601: fnd_message.raise_error;
602: else
603: close csr_check_person;
604: end if;
597: if csr_check_person%notfound then
598: close csr_check_person;
599: --
600: fnd_message.set_name('PER','HR_449629_PDT_FR_PER_NOTEXIST');
601: fnd_message.raise_error;
602: else
603: close csr_check_person;
604: end if;
605: --
744: fetch csr_check_person into l_dummy;
745: if csr_check_person%notfound then
746: close csr_check_person;
747: --
748: fnd_message.set_name('PER','HR_449630_PDT_TO_PER_NOTEXIST');
749: fnd_message.raise_error;
750: else
751: close csr_check_person;
752: --
745: if csr_check_person%notfound then
746: close csr_check_person;
747: --
748: fnd_message.set_name('PER','HR_449630_PDT_TO_PER_NOTEXIST');
749: fnd_message.raise_error;
750: else
751: close csr_check_person;
752: --
753: -- only check person type in host if we are in DRAFT status or
758: open csr_check_per_type(p_to_person_id);
759: fetch csr_check_per_type into l_dummy;
760: if csr_check_per_type%found then
761: close csr_check_per_type;
762: fnd_message.set_name('PER','HR_449631_PDT_TO_PER_FUT_PER');
763: fnd_message.raise_error;
764: else
765: close csr_check_per_type;
766: end if; --check future person types
759: fetch csr_check_per_type into l_dummy;
760: if csr_check_per_type%found then
761: close csr_check_per_type;
762: fnd_message.set_name('PER','HR_449631_PDT_TO_PER_FUT_PER');
763: fnd_message.raise_error;
764: else
765: close csr_check_per_type;
766: end if; --check future person types
767: --
770: open csr_check_per_type2(p_to_person_id);
771: fetch csr_check_per_type2 into l_dummy;
772: if csr_check_per_type2%found then
773: close csr_check_per_type2;
774: fnd_message.set_name('PER','HR_449631_PDT_TO_PER_FUT_PER');
775: fnd_message.raise_error;
776: else
777: close csr_check_per_type2;
778: end if; --check future person types
771: fetch csr_check_per_type2 into l_dummy;
772: if csr_check_per_type2%found then
773: close csr_check_per_type2;
774: fnd_message.set_name('PER','HR_449631_PDT_TO_PER_FUT_PER');
775: fnd_message.raise_error;
776: else
777: close csr_check_per_type2;
778: end if; --check future person types
779: --
782: --
783: end if; --to_person_id not null
784: --
785: if p_to_person_id is null and (p_status='ACTIVE' or p_status='COMPLETE') then
786: fnd_message.set_name('PER','HR_449632_PDT_TO_PER_NULL');
787: fnd_message.raise_error;
788: end if; --status check
789: --
790: end if; --api updating
783: end if; --to_person_id not null
784: --
785: if p_to_person_id is null and (p_status='ACTIVE' or p_status='COMPLETE') then
786: fnd_message.set_name('PER','HR_449632_PDT_TO_PER_NULL');
787: fnd_message.raise_error;
788: end if; --status check
789: --
790: end if; --api updating
791: end if; --multi message
875: open csr_check_per_type;
876: fetch csr_check_per_type into l_sys_type,l_bg_id,l_active_flag;
877: if csr_check_per_type%notfound then
878: close csr_check_per_type;
879: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
880: fnd_message.raise_error;
881: else
882: close csr_check_per_type;
883: --
876: fetch csr_check_per_type into l_sys_type,l_bg_id,l_active_flag;
877: if csr_check_per_type%notfound then
878: close csr_check_per_type;
879: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
880: fnd_message.raise_error;
881: else
882: close csr_check_per_type;
883: --
884: if l_sys_type <> 'EMP' then
881: else
882: close csr_check_per_type;
883: --
884: if l_sys_type <> 'EMP' then
885: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
886: fnd_message.raise_error;
887: end if;
888: if l_bg_id <> p_to_business_group_id then
889: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
882: close csr_check_per_type;
883: --
884: if l_sys_type <> 'EMP' then
885: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
886: fnd_message.raise_error;
887: end if;
888: if l_bg_id <> p_to_business_group_id then
889: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
890: fnd_message.raise_error;
885: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
886: fnd_message.raise_error;
887: end if;
888: if l_bg_id <> p_to_business_group_id then
889: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
890: fnd_message.raise_error;
891: end if;
892: if l_active_flag <> 'Y' then
893: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
886: fnd_message.raise_error;
887: end if;
888: if l_bg_id <> p_to_business_group_id then
889: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
890: fnd_message.raise_error;
891: end if;
892: if l_active_flag <> 'Y' then
893: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
894: fnd_message.raise_error;
889: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
890: fnd_message.raise_error;
891: end if;
892: if l_active_flag <> 'Y' then
893: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
894: fnd_message.raise_error;
895: end if;
896: end if; --csr notfound
897:
890: fnd_message.raise_error;
891: end if;
892: if l_active_flag <> 'Y' then
893: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
894: fnd_message.raise_error;
895: end if;
896: end if; --csr notfound
897:
898: end if; --api updating
978: /*
979: -- Added check for COMPLETED deployments: Bug 5494622
980: if (p_status = 'COMPLETE' and p_start_date > nvl(p_end_date,hr_api.g_eot))
981: then
982: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
983: fnd_message.raise_error;
984: end if;
985:
986: if (p_status <> 'COMPLETE' and p_start_date >= nvl(p_end_date,hr_api.g_eot))
979: -- Added check for COMPLETED deployments: Bug 5494622
980: if (p_status = 'COMPLETE' and p_start_date > nvl(p_end_date,hr_api.g_eot))
981: then
982: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
983: fnd_message.raise_error;
984: end if;
985:
986: if (p_status <> 'COMPLETE' and p_start_date >= nvl(p_end_date,hr_api.g_eot))
987: then
984: end if;
985:
986: if (p_status <> 'COMPLETE' and p_start_date >= nvl(p_end_date,hr_api.g_eot))
987: then
988: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
989: fnd_message.raise_error;
990: end if;
991: --
992: */
985:
986: if (p_status <> 'COMPLETE' and p_start_date >= nvl(p_end_date,hr_api.g_eot))
987: then
988: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
989: fnd_message.raise_error;
990: end if;
991: --
992: */
993: -- added the following piece of code
994: -- bug fix 5665505
995: --
996: if p_start_date > nvl(p_end_date,hr_api.g_eot)
997: then
998: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
999: fnd_message.raise_error;
1000: end if;
1001: --
1002: -- End of Additions
995: --
996: if p_start_date > nvl(p_end_date,hr_api.g_eot)
997: then
998: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
999: fnd_message.raise_error;
1000: end if;
1001: --
1002: -- End of Additions
1003: end if;
1072: open csr_get_min_st_date;
1073: fetch csr_get_min_st_date into l_emp_date_start;
1074:
1075: if csr_get_min_st_date%notfound then
1076: fnd_message.set_name('PER','HR_449629_PDT_FR_PER_NOTEXIST');
1077: fnd_message.raise_error;
1078: end if;
1079:
1080: if(l_dep_start_date < l_emp_date_start) then
1073: fetch csr_get_min_st_date into l_emp_date_start;
1074:
1075: if csr_get_min_st_date%notfound then
1076: fnd_message.set_name('PER','HR_449629_PDT_FR_PER_NOTEXIST');
1077: fnd_message.raise_error;
1078: end if;
1079:
1080: if(l_dep_start_date < l_emp_date_start) then
1081: return 'Y';
1154: <> nvl(p_end_date,hr_api.g_date))
1155: or not l_api_updating) then
1156: --
1157: if (p_permanent <> 'Y' and p_permanent <> 'N' and p_permanent is not null) then
1158: fnd_message.set_name('PER','HR_449633_PDT_PERM_INVALID');
1159: fnd_message.raise_error;
1160: end if;
1161: --
1162: if (p_permanent is not null and p_permanent = 'Y') then
1155: or not l_api_updating) then
1156: --
1157: if (p_permanent <> 'Y' and p_permanent <> 'N' and p_permanent is not null) then
1158: fnd_message.set_name('PER','HR_449633_PDT_PERM_INVALID');
1159: fnd_message.raise_error;
1160: end if;
1161: --
1162: if (p_permanent is not null and p_permanent = 'Y') then
1163: if nvl(p_end_date,hr_api.g_date) <> hr_api.g_date then
1160: end if;
1161: --
1162: if (p_permanent is not null and p_permanent = 'Y') then
1163: if nvl(p_end_date,hr_api.g_date) <> hr_api.g_date then
1164: fnd_message.set_name('PER','HR_449634_PDT_PERM_NO_END');
1165: fnd_message.raise_error;
1166: end if;
1167: --
1168: open csr_check_fut_home_per;
1161: --
1162: if (p_permanent is not null and p_permanent = 'Y') then
1163: if nvl(p_end_date,hr_api.g_date) <> hr_api.g_date then
1164: fnd_message.set_name('PER','HR_449634_PDT_PERM_NO_END');
1165: fnd_message.raise_error;
1166: end if;
1167: --
1168: open csr_check_fut_home_per;
1169: fetch csr_check_fut_home_per into l_dummy;
1167: --
1168: open csr_check_fut_home_per;
1169: fetch csr_check_fut_home_per into l_dummy;
1170: if csr_check_fut_home_per%found then
1171: fnd_message.set_name('PER','HR_449635_PDT_HOME_FUTPER');
1172: fnd_message.raise_error;
1173: end if;
1174: --
1175: end if;
1168: open csr_check_fut_home_per;
1169: fetch csr_check_fut_home_per into l_dummy;
1170: if csr_check_fut_home_per%found then
1171: fnd_message.set_name('PER','HR_449635_PDT_HOME_FUTPER');
1172: fnd_message.raise_error;
1173: end if;
1174: --
1175: end if;
1176: --
1259: ,p_lookup_type => 'HR_DEPLOYMENT_REASONS'
1260: ,p_lookup_code => p_deployment_reason
1261: )
1262: then
1263: fnd_message.set_name('PER','HR_449636_PDT_REAS_NOTEXIST');
1264: fnd_message.raise_error;
1265: end if;
1266: end if; --api updating
1267: end if; --multi message
1260: ,p_lookup_code => p_deployment_reason
1261: )
1262: then
1263: fnd_message.set_name('PER','HR_449636_PDT_REAS_NOTEXIST');
1264: fnd_message.raise_error;
1265: end if;
1266: end if; --api updating
1267: end if; --multi message
1268: --
1376: l_global_num_set := fnd_profile.value('PER_GLOBAL_EMP_NUM');
1377: --
1378: if l_numgen_method='N'
1379: or (l_numgen_method='A' and l_global_num_set <> 'Y') then
1380: fnd_message.set_name('PER','HR_449637_PDT_NUMGENMETH');
1381: fnd_message.raise_error;
1382: end if;
1383: --
1384: if p_to_person_id is not null then
1377: --
1378: if l_numgen_method='N'
1379: or (l_numgen_method='A' and l_global_num_set <> 'Y') then
1380: fnd_message.set_name('PER','HR_449637_PDT_NUMGENMETH');
1381: fnd_message.raise_error;
1382: end if;
1383: --
1384: if p_to_person_id is not null then
1385: open csr_check_host_number;
1386: fetch csr_check_host_number into l_host_empnum;
1387: close csr_check_host_number;
1388: --
1389: if l_host_empnum <> p_employee_number then
1390: fnd_message.set_name('PER','HR_449638_PDT_NUM_HOST');
1391: fnd_message.raise_error;
1392: end if;
1393: elsif p_to_person_id is null
1394: and not(l_numgen_method = 'A' and l_global_num_set = 'Y') then
1387: close csr_check_host_number;
1388: --
1389: if l_host_empnum <> p_employee_number then
1390: fnd_message.set_name('PER','HR_449638_PDT_NUM_HOST');
1391: fnd_message.raise_error;
1392: end if;
1393: elsif p_to_person_id is null
1394: and not(l_numgen_method = 'A' and l_global_num_set = 'Y') then
1395: --
1398: open csr_check_num_unique;
1399: fetch csr_check_num_unique into l_dummy;
1400: if csr_check_num_unique%found then
1401: close csr_check_num_unique;
1402: fnd_message.set_name('PER','HR_449639_PDT_NUM_USED');
1403: fnd_message.raise_error;
1404: else
1405: close csr_check_num_unique;
1406: end if;
1399: fetch csr_check_num_unique into l_dummy;
1400: if csr_check_num_unique%found then
1401: close csr_check_num_unique;
1402: fnd_message.set_name('PER','HR_449639_PDT_NUM_USED');
1403: fnd_message.raise_error;
1404: else
1405: close csr_check_num_unique;
1406: end if;
1407: end if; --p_to_person_id not null
1488: or not l_api_updating) then
1489: --
1490: if p_leaving_reason is not null then
1491: if nvl(p_permanent,'N') = 'Y' then
1492: fnd_message.set_name('PER','HR_449640_PDT_PERM_LEAV_REAS');
1493: fnd_message.raise_error;
1494: end if;
1495: --
1496: if hr_api.not_exists_in_leg_lookups
1489: --
1490: if p_leaving_reason is not null then
1491: if nvl(p_permanent,'N') = 'Y' then
1492: fnd_message.set_name('PER','HR_449640_PDT_PERM_LEAV_REAS');
1493: fnd_message.raise_error;
1494: end if;
1495: --
1496: if hr_api.not_exists_in_leg_lookups
1497: (p_effective_date => p_start_date
1497: (p_effective_date => p_start_date
1498: ,p_lookup_type => 'LEAV_REAS'
1499: ,p_lookup_code => p_leaving_reason
1500: ) then
1501: fnd_message.set_name('PER','HR_7485_PDS_INV_LR');
1502: fnd_message.raise_error;
1503: end if; -- lookup validation
1504: end if; --leaving reason not null
1505: end if; --api updating
1498: ,p_lookup_type => 'LEAV_REAS'
1499: ,p_lookup_code => p_leaving_reason
1500: ) then
1501: fnd_message.set_name('PER','HR_7485_PDS_INV_LR');
1502: fnd_message.raise_error;
1503: end if; -- lookup validation
1504: end if; --leaving reason not null
1505: end if; --api updating
1506: end if; --multi message
1590: or not l_api_updating)
1591: and p_leaving_person_type_id is not null) then
1592: --
1593: if nvl(p_permanent,'N') = 'Y' then
1594: fnd_message.set_name('PER','HR_449641_PDT_PERM_LEAV_TYPE');
1595: fnd_message.raise_error;
1596: end if;
1597: --
1598: open csr_check_per_type;
1591: and p_leaving_person_type_id is not null) then
1592: --
1593: if nvl(p_permanent,'N') = 'Y' then
1594: fnd_message.set_name('PER','HR_449641_PDT_PERM_LEAV_TYPE');
1595: fnd_message.raise_error;
1596: end if;
1597: --
1598: open csr_check_per_type;
1599: fetch csr_check_per_type into l_sys_type,l_bg_id,l_active_flag;
1598: open csr_check_per_type;
1599: fetch csr_check_per_type into l_sys_type,l_bg_id,l_active_flag;
1600: if csr_check_per_type%notfound then
1601: close csr_check_per_type;
1602: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
1603: fnd_message.raise_error;
1604: else
1605: close csr_check_per_type;
1606: --
1599: fetch csr_check_per_type into l_sys_type,l_bg_id,l_active_flag;
1600: if csr_check_per_type%notfound then
1601: close csr_check_per_type;
1602: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
1603: fnd_message.raise_error;
1604: else
1605: close csr_check_per_type;
1606: --
1607: if l_sys_type <> 'EX_EMP' then
1604: else
1605: close csr_check_per_type;
1606: --
1607: if l_sys_type <> 'EX_EMP' then
1608: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
1609: fnd_message.raise_error;
1610: end if;
1611: if l_bg_id <> p_to_business_group_id then
1612: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
1605: close csr_check_per_type;
1606: --
1607: if l_sys_type <> 'EX_EMP' then
1608: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
1609: fnd_message.raise_error;
1610: end if;
1611: if l_bg_id <> p_to_business_group_id then
1612: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
1613: fnd_message.raise_error;
1608: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
1609: fnd_message.raise_error;
1610: end if;
1611: if l_bg_id <> p_to_business_group_id then
1612: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
1613: fnd_message.raise_error;
1614: end if;
1615: if l_active_flag <> 'Y' then
1616: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
1609: fnd_message.raise_error;
1610: end if;
1611: if l_bg_id <> p_to_business_group_id then
1612: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
1613: fnd_message.raise_error;
1614: end if;
1615: if l_active_flag <> 'Y' then
1616: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
1617: fnd_message.raise_error;
1612: fnd_message.set_name('PER','HR_7974_PER_TYPE_INV_BUS_GROUP');
1613: fnd_message.raise_error;
1614: end if;
1615: if l_active_flag <> 'Y' then
1616: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
1617: fnd_message.raise_error;
1618: end if;
1619: end if; --csr notfound
1620:
1613: fnd_message.raise_error;
1614: end if;
1615: if l_active_flag <> 'Y' then
1616: fnd_message.set_name('PER','HR_7973_PER_TYPE_NOT_ACTIVE');
1617: fnd_message.raise_error;
1618: end if;
1619: end if; --csr notfound
1620:
1621: end if; --api updating
1705: (p_effective_date => p_start_date
1706: ,p_lookup_type => 'HR_DEPLOYMENT_STATUSES'
1707: ,p_lookup_code => p_status
1708: ) then
1709: fnd_message.set_name('PER','HR_7485_PDS_INV_LR');
1710: fnd_message.raise_error;
1711: end if;
1712: --
1713: if not l_api_updating and (p_status='ACTIVE' or p_status='COMPLETE') then
1706: ,p_lookup_type => 'HR_DEPLOYMENT_STATUSES'
1707: ,p_lookup_code => p_status
1708: ) then
1709: fnd_message.set_name('PER','HR_7485_PDS_INV_LR');
1710: fnd_message.raise_error;
1711: end if;
1712: --
1713: if not l_api_updating and (p_status='ACTIVE' or p_status='COMPLETE') then
1714: fnd_message.set_name('PER','HR_449642_PDT_INS_STATUS');
1710: fnd_message.raise_error;
1711: end if;
1712: --
1713: if not l_api_updating and (p_status='ACTIVE' or p_status='COMPLETE') then
1714: fnd_message.set_name('PER','HR_449642_PDT_INS_STATUS');
1715: fnd_message.raise_error;
1716: end if;
1717:
1718: end if; --api updating
1711: end if;
1712: --
1713: if not l_api_updating and (p_status='ACTIVE' or p_status='COMPLETE') then
1714: fnd_message.set_name('PER','HR_449642_PDT_INS_STATUS');
1715: fnd_message.raise_error;
1716: end if;
1717:
1718: end if; --api updating
1719: end if; --multi message
1768: begin
1769: hr_utility.set_location('Entering:'||l_proc, 10);
1770: --
1771: if p_deplymt_policy_id is not null then
1772: fnd_message.set_name('PER','HR_449643_PDT_INV_POLICY');
1773: fnd_message.raise_error;
1774: end if;
1775: --
1776: hr_utility.set_location('Leaving:'||l_proc, 20);
1769: hr_utility.set_location('Entering:'||l_proc, 10);
1770: --
1771: if p_deplymt_policy_id is not null then
1772: fnd_message.set_name('PER','HR_449643_PDT_INV_POLICY');
1773: fnd_message.raise_error;
1774: end if;
1775: --
1776: hr_utility.set_location('Leaving:'||l_proc, 20);
1777: --
1862: ,p_object_version_number => p_object_version_number);
1863: --
1864: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N'
1865: and p_from_business_group_id <> p_to_business_group_id then
1866: fnd_message.set_name('PER','HR_449644_PDT_RETAIN_REPS');
1867: fnd_message.raise_error;
1868: end if;
1869: --
1870: if ( (l_api_updating and
1863: --
1864: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N'
1865: and p_from_business_group_id <> p_to_business_group_id then
1866: fnd_message.set_name('PER','HR_449644_PDT_RETAIN_REPS');
1867: fnd_message.raise_error;
1868: end if;
1869: --
1870: if ( (l_api_updating and
1871: nvl(hr_pdt_shd.g_old_rec.retain_direct_reports,hr_api.g_varchar2)
1874: --
1875: if (p_retain_direct_reports <> 'Y'
1876: and p_retain_direct_reports <> 'N'
1877: and p_retain_direct_reports is not null) then
1878: fnd_message.set_name('PER','HR_449645_PDT_RET_REPS_INV');
1879: fnd_message.raise_error;
1880: end if;
1881: --
1882: end if; --api updating
1875: if (p_retain_direct_reports <> 'Y'
1876: and p_retain_direct_reports <> 'N'
1877: and p_retain_direct_reports is not null) then
1878: fnd_message.set_name('PER','HR_449645_PDT_RET_REPS_INV');
1879: fnd_message.raise_error;
1880: end if;
1881: --
1882: end if; --api updating
1883: end if; --multi mesage
1977: open csr_check_int_org;
1978: fetch csr_check_int_org into l_dummy;
1979: if csr_check_int_org%notfound then
1980: close csr_check_int_org;
1981: fnd_message.set_name('PER','HR_34983_ASG_INVALID_ORG');
1982: fnd_message.raise_error;
1983: else
1984: close csr_check_int_org;
1985: end if;
1978: fetch csr_check_int_org into l_dummy;
1979: if csr_check_int_org%notfound then
1980: close csr_check_int_org;
1981: fnd_message.set_name('PER','HR_34983_ASG_INVALID_ORG');
1982: fnd_message.raise_error;
1983: else
1984: close csr_check_int_org;
1985: end if;
1986: --
1987: open csr_check_hr_org;
1988: fetch csr_check_hr_org into l_dummy;
1989: if csr_check_hr_org%notfound then
1990: close csr_check_hr_org;
1991: fnd_message.set_name('PER','HR_51277_ASG_INV_HR_ORG');
1992: fnd_message.raise_error;
1993: else
1994: close csr_check_hr_org;
1995: end if;
1988: fetch csr_check_hr_org into l_dummy;
1989: if csr_check_hr_org%notfound then
1990: close csr_check_hr_org;
1991: fnd_message.set_name('PER','HR_51277_ASG_INV_HR_ORG');
1992: fnd_message.raise_error;
1993: else
1994: close csr_check_hr_org;
1995: end if;
1996: end if; --api updating
2088: open csr_check_loc;
2089: fetch csr_check_loc into l_inactive_date;
2090: if csr_check_loc%notfound then
2091: close csr_check_loc;
2092: fnd_message.set_name('PER','HR_7382_ASG_NON_EXIST_LOCATION');
2093: fnd_message.raise_error;
2094: else
2095: close csr_check_loc;
2096: if p_start_date < l_inactive_date then
2089: fetch csr_check_loc into l_inactive_date;
2090: if csr_check_loc%notfound then
2091: close csr_check_loc;
2092: fnd_message.set_name('PER','HR_7382_ASG_NON_EXIST_LOCATION');
2093: fnd_message.raise_error;
2094: else
2095: close csr_check_loc;
2096: if p_start_date < l_inactive_date then
2097: fnd_message.set_name('PER','HR_51215_ASG_INACT_LOCATION');
2093: fnd_message.raise_error;
2094: else
2095: close csr_check_loc;
2096: if p_start_date < l_inactive_date then
2097: fnd_message.set_name('PER','HR_51215_ASG_INACT_LOCATION');
2098: fnd_message.raise_error;
2099: end if;
2100: end if; -- csr_check_loc notfound
2101: --
2094: else
2095: close csr_check_loc;
2096: if p_start_date < l_inactive_date then
2097: fnd_message.set_name('PER','HR_51215_ASG_INACT_LOCATION');
2098: fnd_message.raise_error;
2099: end if;
2100: end if; -- csr_check_loc notfound
2101: --
2102: end if; --location not null
2204: open csr_check_job;
2205: fetch csr_check_job into l_dummy;
2206: if csr_check_job%notfound then
2207: close csr_check_job;
2208: fnd_message.set_name('PER','HR_51172_ASG_INV_DT_JOB');
2209: fnd_message.raise_error;
2210: else
2211: close csr_check_job;
2212: end if;
2205: fetch csr_check_job into l_dummy;
2206: if csr_check_job%notfound then
2207: close csr_check_job;
2208: fnd_message.set_name('PER','HR_51172_ASG_INV_DT_JOB');
2209: fnd_message.raise_error;
2210: else
2211: close csr_check_job;
2212: end if;
2213: end if; --job not null
2316: open csr_check_position;
2317: fetch csr_check_position into l_dummy;
2318: if csr_check_position%notfound then
2319: close csr_check_position;
2320: fnd_message.set_name('PER','HR_51000_ASG_INVALID_POS');
2321: fnd_message.raise_error;
2322: else
2323: close csr_check_position;
2324: end if;
2317: fetch csr_check_position into l_dummy;
2318: if csr_check_position%notfound then
2319: close csr_check_position;
2320: fnd_message.set_name('PER','HR_51000_ASG_INVALID_POS');
2321: fnd_message.raise_error;
2322: else
2323: close csr_check_position;
2324: end if;
2325: end if; --position not null
2423: open csr_check_grade;
2424: fetch csr_check_grade into l_dummy;
2425: if csr_check_grade%notfound then
2426: close csr_check_grade;
2427: fnd_message.set_name('PER','HR_7393_ASG_INVALID_GRADE');
2428: fnd_message.raise_error;
2429: else
2430: close csr_check_grade;
2431: end if;
2424: fetch csr_check_grade into l_dummy;
2425: if csr_check_grade%notfound then
2426: close csr_check_grade;
2427: fnd_message.set_name('PER','HR_7393_ASG_INVALID_GRADE');
2428: fnd_message.raise_error;
2429: else
2430: close csr_check_grade;
2431: end if;
2432: end if; --grade not null
2530: open csr_check_pos_job;
2531: fetch csr_check_pos_job into l_dummy;
2532: if csr_check_pos_job%notfound then
2533: close csr_check_pos_job;
2534: fnd_message.set_name('PER','HR_51056_ASG_INV_POS_JOB_COMB');
2535: fnd_message.raise_error;
2536: else
2537: close csr_check_pos_job;
2538: end if;
2531: fetch csr_check_pos_job into l_dummy;
2532: if csr_check_pos_job%notfound then
2533: close csr_check_pos_job;
2534: fnd_message.set_name('PER','HR_51056_ASG_INV_POS_JOB_COMB');
2535: fnd_message.raise_error;
2536: else
2537: close csr_check_pos_job;
2538: end if;
2539: end if; --pos and job not null
2868: open csr_check_pos_org;
2869: fetch csr_check_pos_org into l_dummy;
2870: if csr_check_pos_org%notfound then
2871: close csr_check_pos_org;
2872: fnd_message.set_name('PER','HR_51056_ASG_INV_POS_ORG_COMB');
2873: fnd_message.raise_error;
2874: else
2875: close csr_check_pos_org;
2876: end if;
2869: fetch csr_check_pos_org into l_dummy;
2870: if csr_check_pos_org%notfound then
2871: close csr_check_pos_org;
2872: fnd_message.set_name('PER','HR_51056_ASG_INV_POS_ORG_COMB');
2873: fnd_message.raise_error;
2874: else
2875: close csr_check_pos_org;
2876: end if;
2877: end if; --pos and org not null
2983: open csr_check_payroll;
2984: fetch csr_check_payroll into l_dummy;
2985: if csr_check_payroll%notfound then
2986: close csr_check_payroll;
2987: fnd_message.set_name('PER','HR_7370_ASG_INVALID_PAYROLL');
2988: fnd_message.raise_error;
2989: else
2990: close csr_check_payroll;
2991: end if;
2984: fetch csr_check_payroll into l_dummy;
2985: if csr_check_payroll%notfound then
2986: close csr_check_payroll;
2987: fnd_message.set_name('PER','HR_7370_ASG_INVALID_PAYROLL');
2988: fnd_message.raise_error;
2989: else
2990: close csr_check_payroll;
2991: end if;
2992: --
3001: OR ( l_legislation_code = 'US'
3002: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
3003: p_legislation => 'US')))
3004: then
3005: fnd_message.set_name('PER','HR_449646_PDT_NO_PAYROLL');
3006: fnd_message.raise_error;
3007: end if; -- leg code check
3008: end if; --payroll not null
3009: end if; --api updating
3002: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
3003: p_legislation => 'US')))
3004: then
3005: fnd_message.set_name('PER','HR_449646_PDT_NO_PAYROLL');
3006: fnd_message.raise_error;
3007: end if; -- leg code check
3008: end if; --payroll not null
3009: end if; --api updating
3010: end if; --multi message
3123: open csr_check_asg_status(l_legislation_code);
3124: fetch csr_check_asg_status into l_active_flag,l_per_system_status;
3125: if csr_check_asg_status%notfound then
3126: close csr_check_asg_status;
3127: fnd_message.set_name('PER','HR_7940_ASG_INV_ASG_STAT_TYPE');
3128: fnd_message.raise_error;
3129: else
3130: close csr_check_asg_status;
3131: if l_active_flag <> 'Y' then
3124: fetch csr_check_asg_status into l_active_flag,l_per_system_status;
3125: if csr_check_asg_status%notfound then
3126: close csr_check_asg_status;
3127: fnd_message.set_name('PER','HR_7940_ASG_INV_ASG_STAT_TYPE');
3128: fnd_message.raise_error;
3129: else
3130: close csr_check_asg_status;
3131: if l_active_flag <> 'Y' then
3132: fnd_message.set_name('PER','HR_51206_ASG_INV_AST_ACT_FLG');
3128: fnd_message.raise_error;
3129: else
3130: close csr_check_asg_status;
3131: if l_active_flag <> 'Y' then
3132: fnd_message.set_name('PER','HR_51206_ASG_INV_AST_ACT_FLG');
3133: fnd_message.raise_error;
3134: end if;
3135: --
3136: if l_per_system_status <> 'ACTIVE_ASSIGN' then
3129: else
3130: close csr_check_asg_status;
3131: if l_active_flag <> 'Y' then
3132: fnd_message.set_name('PER','HR_51206_ASG_INV_AST_ACT_FLG');
3133: fnd_message.raise_error;
3134: end if;
3135: --
3136: if l_per_system_status <> 'ACTIVE_ASSIGN' then
3137: fnd_message.set_name('PER','HR_7941_ASG_INV_STAT_NOT_ACT');
3133: fnd_message.raise_error;
3134: end if;
3135: --
3136: if l_per_system_status <> 'ACTIVE_ASSIGN' then
3137: fnd_message.set_name('PER','HR_7941_ASG_INV_STAT_NOT_ACT');
3138: fnd_message.raise_error;
3139: end if;
3140: end if;
3141: else
3134: end if;
3135: --
3136: if l_per_system_status <> 'ACTIVE_ASSIGN' then
3137: fnd_message.set_name('PER','HR_7941_ASG_INV_STAT_NOT_ACT');
3138: fnd_message.raise_error;
3139: end if;
3140: end if;
3141: else
3142: close csr_check_asg_status_amend;
3246: if p_supervisor_id is not null then
3247: --
3248: if p_supervisor_id = nvl(p_to_person_id,-1)
3249: or p_supervisor_id = p_from_person_id then
3250: fnd_message.set_name('PER','HR_51143_ASG_EMP_EQUAL_SUP');
3251: fnd_message.raise_error;
3252: end if;
3253: --
3254: open csr_party_id(p_from_person_id);
3247: --
3248: if p_supervisor_id = nvl(p_to_person_id,-1)
3249: or p_supervisor_id = p_from_person_id then
3250: fnd_message.set_name('PER','HR_51143_ASG_EMP_EQUAL_SUP');
3251: fnd_message.raise_error;
3252: end if;
3253: --
3254: open csr_party_id(p_from_person_id);
3255: fetch csr_party_id into l_per_party_id;
3259: fetch csr_party_id into l_sup_party_id;
3260: close csr_party_id;
3261: --
3262: if l_per_party_id = l_sup_party_id then
3263: fnd_message.set_name('PER','HR_449603_ASG_SUP_DUP_PER');
3264: fnd_message.raise_error;
3265: end if;
3266: --
3267: open csr_check_sup;
3260: close csr_party_id;
3261: --
3262: if l_per_party_id = l_sup_party_id then
3263: fnd_message.set_name('PER','HR_449603_ASG_SUP_DUP_PER');
3264: fnd_message.raise_error;
3265: end if;
3266: --
3267: open csr_check_sup;
3268: fetch csr_check_sup into l_sup_bg_id;
3267: open csr_check_sup;
3268: fetch csr_check_sup into l_sup_bg_id;
3269: if csr_check_sup%notfound then
3270: close csr_check_sup;
3271: fnd_message.set_name('PER','PAY_7599_SYS_SUP_DT_OUTDATE');
3272: fnd_message.raise_error;
3273: else
3274: close csr_check_sup;
3275: if (p_to_business_group_id <> l_sup_bg_id AND
3268: fetch csr_check_sup into l_sup_bg_id;
3269: if csr_check_sup%notfound then
3270: close csr_check_sup;
3271: fnd_message.set_name('PER','PAY_7599_SYS_SUP_DT_OUTDATE');
3272: fnd_message.raise_error;
3273: else
3274: close csr_check_sup;
3275: if (p_to_business_group_id <> l_sup_bg_id AND
3276: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N') then
3273: else
3274: close csr_check_sup;
3275: if (p_to_business_group_id <> l_sup_bg_id AND
3276: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N') then
3277: fnd_message.set_name('PER','HR_51145_ASG_SUP_BG_NE_EMP_BG');
3278: fnd_message.raise_error;
3279: end if;
3280: end if;
3281: end if; --supervisor id not null
3274: close csr_check_sup;
3275: if (p_to_business_group_id <> l_sup_bg_id AND
3276: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N') then
3277: fnd_message.set_name('PER','HR_51145_ASG_SUP_BG_NE_EMP_BG');
3278: fnd_message.raise_error;
3279: end if;
3280: end if;
3281: end if; --supervisor id not null
3282: end if; --api updating
3378: open csr_check_sup_asg;
3379: fetch csr_check_sup_asg into l_sup_asg_type;
3380: if csr_check_sup_asg%notfound then
3381: close csr_check_sup_asg;
3382: fnd_message.set_name('PER','HR_50146_SUP_ASG_INVALID');
3383: fnd_message.raise_error;
3384: else
3385: close csr_check_sup_asg;
3386: if (l_sup_asg_type = 'E'
3379: fetch csr_check_sup_asg into l_sup_asg_type;
3380: if csr_check_sup_asg%notfound then
3381: close csr_check_sup_asg;
3382: fnd_message.set_name('PER','HR_50146_SUP_ASG_INVALID');
3383: fnd_message.raise_error;
3384: else
3385: close csr_check_sup_asg;
3386: if (l_sup_asg_type = 'E'
3387: or (l_sup_asg_type = 'C' and
3387: or (l_sup_asg_type = 'C' and
3388: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y')) then
3389: null;
3390: else
3391: fnd_message.set_name('PER','HR_50147_SUP_ASG_WRONG_TYPE');
3392: fnd_message.raise_error;
3393: end if;
3394: end if;
3395:
3388: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y')) then
3389: null;
3390: else
3391: fnd_message.set_name('PER','HR_50147_SUP_ASG_WRONG_TYPE');
3392: fnd_message.raise_error;
3393: end if;
3394: end if;
3395:
3396: end if;
3469: open csr_check_pay_basis;
3470: fetch csr_check_pay_basis into l_business_group_id;
3471: if csr_check_pay_basis%notfound then
3472: close csr_check_pay_basis;
3473: fnd_message.set_name('PER','HR_51168_ASG_INV_PAY_BASIS_ID');
3474: fnd_message.raise_error;
3475: else
3476: close csr_check_pay_basis;
3477: if p_to_business_group_id <> l_business_group_id then
3470: fetch csr_check_pay_basis into l_business_group_id;
3471: if csr_check_pay_basis%notfound then
3472: close csr_check_pay_basis;
3473: fnd_message.set_name('PER','HR_51168_ASG_INV_PAY_BASIS_ID');
3474: fnd_message.raise_error;
3475: else
3476: close csr_check_pay_basis;
3477: if p_to_business_group_id <> l_business_group_id then
3478: fnd_message.set_name('PER','HR_51169_ASG_INV_PAY_BAS_BG');
3474: fnd_message.raise_error;
3475: else
3476: close csr_check_pay_basis;
3477: if p_to_business_group_id <> l_business_group_id then
3478: fnd_message.set_name('PER','HR_51169_ASG_INV_PAY_BAS_BG');
3479: fnd_message.raise_error;
3480: end if;
3481: end if;
3482: end if; -- pay basis not null
3475: else
3476: close csr_check_pay_basis;
3477: if p_to_business_group_id <> l_business_group_id then
3478: fnd_message.set_name('PER','HR_51169_ASG_INV_PAY_BAS_BG');
3479: fnd_message.raise_error;
3480: end if;
3481: end if;
3482: end if; -- pay basis not null
3483: end if; --api updating
3584: open csr_check_grp;
3585: fetch csr_check_grp into l_enabled_flag,l_id_flex_num;
3586: if csr_check_grp%notfound then
3587: close csr_check_grp;
3588: fnd_message.set_name('PER','HR_7385_ASG_INV_PEOPLE_GROUP');
3589: fnd_message.raise_error;
3590: else
3591: close csr_check_grp;
3592: if l_enabled_flag <> 'Y' then
3585: fetch csr_check_grp into l_enabled_flag,l_id_flex_num;
3586: if csr_check_grp%notfound then
3587: close csr_check_grp;
3588: fnd_message.set_name('PER','HR_7385_ASG_INV_PEOPLE_GROUP');
3589: fnd_message.raise_error;
3590: else
3591: close csr_check_grp;
3592: if l_enabled_flag <> 'Y' then
3593: fnd_message.set_name('PER','HR_51252_ASG_INV_PGP_ENBD_FLAG');
3589: fnd_message.raise_error;
3590: else
3591: close csr_check_grp;
3592: if l_enabled_flag <> 'Y' then
3593: fnd_message.set_name('PER','HR_51252_ASG_INV_PGP_ENBD_FLAG');
3594: fnd_message.raise_error;
3595: end if;
3596: --
3597: open csr_get_bg_flex;
3590: else
3591: close csr_check_grp;
3592: if l_enabled_flag <> 'Y' then
3593: fnd_message.set_name('PER','HR_51252_ASG_INV_PGP_ENBD_FLAG');
3594: fnd_message.raise_error;
3595: end if;
3596: --
3597: open csr_get_bg_flex;
3598: fetch csr_get_bg_flex into l_bg_id_flex_num;
3598: fetch csr_get_bg_flex into l_bg_id_flex_num;
3599: close csr_get_bg_flex;
3600: --
3601: if to_number(l_bg_id_flex_num) <> l_id_flex_num then
3602: fnd_message.set_name('PER','HR_7386_ASG_INV_PEOP_GRP_LINK');
3603: fnd_message.raise_error;
3604: end if;
3605: --
3606: end if; --csr_check_grp not found
3599: close csr_get_bg_flex;
3600: --
3601: if to_number(l_bg_id_flex_num) <> l_id_flex_num then
3602: fnd_message.set_name('PER','HR_7386_ASG_INV_PEOP_GRP_LINK');
3603: fnd_message.raise_error;
3604: end if;
3605: --
3606: end if; --csr_check_grp not found
3607: end if; --people group not null
3726: open csr_check_scl;
3727: fetch csr_check_scl into l_dummy;
3728: if csr_check_scl%notfound then
3729: close csr_check_scl;
3730: fnd_message.set_name('PER','HR_7383_ASG_INV_KEYFLEX');
3731: hr_multi_message.add
3732: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SOFT_CODING_KEYFLEX_ID' ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE');
3733: else
3734: close csr_check_scl;
3746: fetch csr_pay_legislation_rules into l_dummy;
3747: if csr_pay_legislation_rules%found then
3748: close csr_pay_legislation_rules;
3749: if l_legislation_code = 'US' then
3750: fnd_message.set_name('PER','HR_50001_EMP_ASS_NO_GRE');
3751: hr_multi_message.add
3752: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');
3753: else
3754: open csr_tax_unit_message('HR_INV_LEG_ENT_'||l_legislation_code);
3754: open csr_tax_unit_message('HR_INV_LEG_ENT_'||l_legislation_code);
3755: fetch csr_tax_unit_message into l_dummy;
3756: if csr_tax_unit_message%found then
3757: close csr_tax_unit_message;
3758: fnd_message.set_name('PER','HR_INV_LEG_ENT_'||l_legislation_code);
3759: else
3760: close csr_tax_unit_message;
3761: fnd_message.set_name('PER','HR_34024_IP_INV_LEG_ENT');
3762: end if;
3757: close csr_tax_unit_message;
3758: fnd_message.set_name('PER','HR_INV_LEG_ENT_'||l_legislation_code);
3759: else
3760: close csr_tax_unit_message;
3761: fnd_message.set_name('PER','HR_34024_IP_INV_LEG_ENT');
3762: end if;
3763: hr_multi_message.add
3764: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');
3765: end if; --legislation code
3848: (p_effective_date => p_start_date
3849: ,p_lookup_type => 'EMP_CAT'
3850: ,p_lookup_code => p_assignment_category
3851: ) then
3852: fnd_message.set_name('PER','HR_51028_ASG_INV_EMP_CATEGORY');
3853: fnd_message.raise_error;
3854: end if; --assignment category not null
3855: end if; --api updating
3856: end if; --multi message
3849: ,p_lookup_type => 'EMP_CAT'
3850: ,p_lookup_code => p_assignment_category
3851: ) then
3852: fnd_message.set_name('PER','HR_51028_ASG_INV_EMP_CATEGORY');
3853: fnd_message.raise_error;
3854: end if; --assignment category not null
3855: end if; --api updating
3856: end if; --multi message
3857: --
3915: open csr_deployment;
3916: fetch csr_deployment into l_start_date,l_status;
3917: if csr_deployment%notfound then
3918: close csr_deployment;
3919: fnd_message.set_name('PER','HR_449647_PDT_DPL_DEL_PK');
3920: fnd_message.raise_error;
3921: else
3922: close csr_deployment;
3923: if l_status = 'ACTIVE' then
3916: fetch csr_deployment into l_start_date,l_status;
3917: if csr_deployment%notfound then
3918: close csr_deployment;
3919: fnd_message.set_name('PER','HR_449647_PDT_DPL_DEL_PK');
3920: fnd_message.raise_error;
3921: else
3922: close csr_deployment;
3923: if l_status = 'ACTIVE' then
3924: fnd_message.set_name('PER','HR_449648_PDT_DPL_DEL_STATUS');
3920: fnd_message.raise_error;
3921: else
3922: close csr_deployment;
3923: if l_status = 'ACTIVE' then
3924: fnd_message.set_name('PER','HR_449648_PDT_DPL_DEL_STATUS');
3925: fnd_message.raise_error;
3926: end if;
3927: end if;
3928: --
3921: else
3922: close csr_deployment;
3923: if l_status = 'ACTIVE' then
3924: fnd_message.set_name('PER','HR_449648_PDT_DPL_DEL_STATUS');
3925: fnd_message.raise_error;
3926: end if;
3927: end if;
3928: --
3929: hr_utility.set_location('Leaving:'||l_proc, 20);