69: close csr_sec_grp;
70: --
71: -- The primary key is invalid therefore we must error
72: --
73: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
74: fnd_message.raise_error;
75: --
76: end if;
77: close csr_sec_grp;
70: --
71: -- The primary key is invalid therefore we must error
72: --
73: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
74: fnd_message.raise_error;
75: --
76: end if;
77: close csr_sec_grp;
78: --
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: end if;
149: hr_utility.set_location(l_proc,30);
150: --
143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: end if;
149: hr_utility.set_location(l_proc,30);
150: --
151: -- Set the global variables so the values are
233: ,p_organization_id => p_parent_organization_id);
234: fetch c_valid_org_for_bg_and_date into l_org_id;
235: if c_valid_org_for_bg_and_date%notfound then
236: close c_valid_org_for_bg_and_date;
237: fnd_message.set_name('PER', 'HR_DE_ORG_BUS_GRP_CHK');
238: fnd_message.raise_error;
239: else
240: close c_valid_org_for_bg_and_date;
241: end if;
234: fetch c_valid_org_for_bg_and_date into l_org_id;
235: if c_valid_org_for_bg_and_date%notfound then
236: close c_valid_org_for_bg_and_date;
237: fnd_message.set_name('PER', 'HR_DE_ORG_BUS_GRP_CHK');
238: fnd_message.raise_error;
239: else
240: close c_valid_org_for_bg_and_date;
241: end if;
242: --
250: (p_organization_id => p_parent_organization_id);
251: fetch c_valid_hr_org into l_org_id;
252: if c_valid_hr_org%notfound then
253: close c_valid_hr_org;
254: fnd_message.set_name('PER', 'HR_DE_ORG_HR_CHK');
255: fnd_message.raise_error;
256: else
257: close c_valid_hr_org;
258: end if;
251: fetch c_valid_hr_org into l_org_id;
252: if c_valid_hr_org%notfound then
253: close c_valid_hr_org;
254: fnd_message.set_name('PER', 'HR_DE_ORG_HR_CHK');
255: fnd_message.raise_error;
256: else
257: close c_valid_hr_org;
258: end if;
259: --
340: ,p_organization_id => p_child_organization_id);
341: fetch c_valid_org_for_bg_and_date into l_org_id;
342: if c_valid_org_for_bg_and_date%notfound then
343: close c_valid_org_for_bg_and_date;
344: fnd_message.set_name('PER', 'HR_DE_ORG_CHILD_BUS_GRP_CHK');
345: fnd_message.raise_error;
346: else
347: close c_valid_org_for_bg_and_date;
348: end if;
341: fetch c_valid_org_for_bg_and_date into l_org_id;
342: if c_valid_org_for_bg_and_date%notfound then
343: close c_valid_org_for_bg_and_date;
344: fnd_message.set_name('PER', 'HR_DE_ORG_CHILD_BUS_GRP_CHK');
345: fnd_message.raise_error;
346: else
347: close c_valid_org_for_bg_and_date;
348: end if;
349: --
358: ,p_org_link_type => p_org_link_type);
359: fetch c_valid_org_class into l_org_id;
360: if c_valid_org_class%notfound then
361: close c_valid_org_class;
362: fnd_message.set_name('PER', 'HR_DE_ORG_CHILD_CLASS_CHK');
363: fnd_message.raise_error;
364: else
365: close c_valid_org_class;
366: end if;
359: fetch c_valid_org_class into l_org_id;
360: if c_valid_org_class%notfound then
361: close c_valid_org_class;
362: fnd_message.set_name('PER', 'HR_DE_ORG_CHILD_CLASS_CHK');
363: fnd_message.raise_error;
364: else
365: close c_valid_org_class;
366: end if;
367: --
540: (p_business_group_id => p_business_group_id);
541: fetch c_valid_legislation into l_dummy;
542: if c_valid_legislation%notfound then
543: close c_valid_legislation;
544: fnd_message.set_name('PER', 'HR_DE_BUS_GRP_LEG_CHK');
545: fnd_message.raise_error;
546: else
547: close c_valid_legislation;
548: end if;
541: fetch c_valid_legislation into l_dummy;
542: if c_valid_legislation%notfound then
543: close c_valid_legislation;
544: fnd_message.set_name('PER', 'HR_DE_BUS_GRP_LEG_CHK');
545: fnd_message.raise_error;
546: else
547: close c_valid_legislation;
548: end if;
549: --
593: -- matches the link type.
594: --
595: if p_org_link_info_category is not null then
596: if not (p_org_link_info_category = p_org_link_type) then
597: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_ORG_INFO_CHK');
598: fnd_message.raise_error;
599: end if;
600: end if;
601: --
594: --
595: if p_org_link_info_category is not null then
596: if not (p_org_link_info_category = p_org_link_type) then
597: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_ORG_INFO_CHK');
598: fnd_message.raise_error;
599: end if;
600: end if;
601: --
602: hr_utility.set_location(l_proc, 20);
606: -- 'DE_SOCIAL_INSURANCE' or 'DE_LIABILITY_INSURANCE'.
607: --
608: if p_org_link_type in ('DE_SOCIAL_INSURANCE', 'DE_LIABILITY_INSURANCE') then
609: if not (nvl(p_org_link_info_category, hr_api.g_varchar2) = p_org_link_type) then
610: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_MAN_CHK');
611: fnd_message.raise_error;
612: end if;
613: end if;
614: --
607: --
608: if p_org_link_type in ('DE_SOCIAL_INSURANCE', 'DE_LIABILITY_INSURANCE') then
609: if not (nvl(p_org_link_info_category, hr_api.g_varchar2) = p_org_link_type) then
610: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_MAN_CHK');
611: fnd_message.raise_error;
612: end if;
613: end if;
614: --
615: hr_utility.set_location(' Leaving:'|| l_proc, 50);
652: --
653: -- Cannot delete the record when it is for a liability insurance provider.
654: --
655: if p_org_link_type = 'DE_LIABILITY_INSURANCE' then
656: fnd_message.set_name('PER', 'HR_DE_CANT_DEL_LIABILITY_INS');
657: fnd_message.raise_error;
658: end if;
659: --
660: hr_utility.set_location(' Leaving:'|| l_proc, 20);
653: -- Cannot delete the record when it is for a liability insurance provider.
654: --
655: if p_org_link_type = 'DE_LIABILITY_INSURANCE' then
656: fnd_message.set_name('PER', 'HR_DE_CANT_DEL_LIABILITY_INS');
657: fnd_message.raise_error;
658: end if;
659: --
660: hr_utility.set_location(' Leaving:'|| l_proc, 20);
661: end chk_organization_link_delete;
1058: IF NOT hr_ord_shd.api_updating
1059: (p_organization_link_id => p_rec.organization_link_id
1060: ,p_object_version_number => p_rec.object_version_number
1061: ) THEN
1062: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1063: fnd_message.set_token('PROCEDURE ', l_proc);
1064: fnd_message.set_token('STEP ', '5');
1065: fnd_message.raise_error;
1066: END IF;
1059: (p_organization_link_id => p_rec.organization_link_id
1060: ,p_object_version_number => p_rec.object_version_number
1061: ) THEN
1062: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1063: fnd_message.set_token('PROCEDURE ', l_proc);
1064: fnd_message.set_token('STEP ', '5');
1065: fnd_message.raise_error;
1066: END IF;
1067: --
1060: ,p_object_version_number => p_rec.object_version_number
1061: ) THEN
1062: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1063: fnd_message.set_token('PROCEDURE ', l_proc);
1064: fnd_message.set_token('STEP ', '5');
1065: fnd_message.raise_error;
1066: END IF;
1067: --
1068: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1061: ) THEN
1062: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1063: fnd_message.set_token('PROCEDURE ', l_proc);
1064: fnd_message.set_token('STEP ', '5');
1065: fnd_message.raise_error;
1066: END IF;
1067: --
1068: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1069: nvl(hr_ord_shd.g_old_rec.business_group_id, hr_api.g_number) then