DBA Data[Home] [Help]

APPS.HR_ORD_BUS dependencies on FND_MESSAGE

Line 73: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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;

Line 74: fnd_message.raise_error;

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: --

Line 146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 147: fnd_message.raise_error;

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

Line 237: fnd_message.set_name('PER', 'HR_DE_ORG_BUS_GRP_CHK');

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;

Line 238: fnd_message.raise_error;

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: --

Line 254: fnd_message.set_name('PER', 'HR_DE_ORG_HR_CHK');

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;

Line 255: fnd_message.raise_error;

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: --

Line 344: fnd_message.set_name('PER', 'HR_DE_ORG_CHILD_BUS_GRP_CHK');

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;

Line 345: fnd_message.raise_error;

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: --

Line 362: fnd_message.set_name('PER', 'HR_DE_ORG_CHILD_CLASS_CHK');

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;

Line 363: fnd_message.raise_error;

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: --

Line 544: fnd_message.set_name('PER', 'HR_DE_BUS_GRP_LEG_CHK');

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;

Line 545: fnd_message.raise_error;

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: --

Line 597: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_ORG_INFO_CHK');

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: --

Line 598: fnd_message.raise_error;

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);

Line 610: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_MAN_CHK');

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: --

Line 611: fnd_message.raise_error;

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);

Line 656: fnd_message.set_name('PER', 'HR_DE_CANT_DEL_LIABILITY_INS');

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);

Line 657: fnd_message.raise_error;

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;

Line 1062: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1063: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 1064: fnd_message.set_token('STEP ', '5');

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) <>

Line 1065: fnd_message.raise_error;

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