DBA Data[Home] [Help]

APPS.PER_REI_BUS dependencies on FND_MESSAGE

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

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'CONTACT_EXTRA_INFO_ID')
64: );

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

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

Line 220: fnd_message.set_name('PER', 'HR_INV_REL_ID');

216: OPEN c_valid_rel;
217: FETCH c_valid_rel INTO l_dummy;
218: IF c_valid_rel%NOTFOUND THEN
219: CLOSE c_valid_rel;
220: fnd_message.set_name('PER', 'HR_INV_REL_ID');
221: fnd_message.raise_error;
222: END IF;
223: CLOSE c_valid_rel;
224: --

Line 221: fnd_message.raise_error;

217: FETCH c_valid_rel INTO l_dummy;
218: IF c_valid_rel%NOTFOUND THEN
219: CLOSE c_valid_rel;
220: fnd_message.set_name('PER', 'HR_INV_REL_ID');
221: fnd_message.raise_error;
222: END IF;
223: CLOSE c_valid_rel;
224: --
225: hr_utility.set_location(' Leaving:' || l_proc, 3);

Line 296: fnd_message.set_name('PER', 'HR_INV_INFO_TYPE');

292: open csr_information_type;
293: fetch csr_information_type into l_rec;
294: if csr_information_type%notfound then
295: close csr_information_type;
296: fnd_message.set_name('PER', 'HR_INV_INFO_TYPE');
297: fnd_message.raise_error;
298: end if;
299: close csr_information_type;
300: --

Line 297: fnd_message.raise_error;

293: fetch csr_information_type into l_rec;
294: if csr_information_type%notfound then
295: close csr_information_type;
296: fnd_message.set_name('PER', 'HR_INV_INFO_TYPE');
297: fnd_message.raise_error;
298: end if;
299: close csr_information_type;
300: --
301: -- The following validation is only done when INSERTING

Line 309: fnd_message.set_name('PER', 'HR_INV_INFO_TYPE');

305: -- Check the information_type is available in current legislation.
306: --
307: if (l_rec.legislation_code is not null and
308: l_rec.legislation_code <> per_ctr_bus.return_legislation_code(p_contact_relationship_id)) then
309: fnd_message.set_name('PER', 'HR_INV_INFO_TYPE');
310: fnd_message.raise_error;
311: end if;
312: --
313: -- Raise an error when specified information type is inactive.

Line 310: fnd_message.raise_error;

306: --
307: if (l_rec.legislation_code is not null and
308: l_rec.legislation_code <> per_ctr_bus.return_legislation_code(p_contact_relationship_id)) then
309: fnd_message.set_name('PER', 'HR_INV_INFO_TYPE');
310: fnd_message.raise_error;
311: end if;
312: --
313: -- Raise an error when specified information type is inactive.
314: --

Line 316: fnd_message.set_name('PER', 'HR_INACTIVE_INFO_TYPE');

312: --
313: -- Raise an error when specified information type is inactive.
314: --
315: if l_rec.active_inactive_flag = 'N' then
316: fnd_message.set_name('PER', 'HR_INACTIVE_INFO_TYPE');
317: fnd_message.raise_error;
318: end if;
319: end if;
320: --

Line 317: fnd_message.raise_error;

313: -- Raise an error when specified information type is inactive.
314: --
315: if l_rec.active_inactive_flag = 'N' then
316: fnd_message.set_name('PER', 'HR_INACTIVE_INFO_TYPE');
317: fnd_message.raise_error;
318: end if;
319: end if;
320: --
321: -- Check the information_type is unique on arbitrary date

Line 355: fnd_message.set_name('PER', 'HR_MORE_THAN_1_EXTRA_INFO');

351: hr_utility.trace('min_esd : ' || l_min_esd);
352: --
353: if l_min_esd is not null then
354: if l_min_esd <= p_validation_start_date then
355: fnd_message.set_name('PER', 'HR_MORE_THAN_1_EXTRA_INFO');
356: fnd_message.raise_error;
357: end if;
358: --
359: p_validation_end_date := l_min_esd - 1;

Line 356: fnd_message.raise_error;

352: --
353: if l_min_esd is not null then
354: if l_min_esd <= p_validation_start_date then
355: fnd_message.set_name('PER', 'HR_MORE_THAN_1_EXTRA_INFO');
356: fnd_message.raise_error;
357: end if;
358: --
359: p_validation_end_date := l_min_esd - 1;
360: --

Line 414: fnd_message.set_name('PER', 'HR_7438_FLEX_INV_REF_FIELD_VAL');

410: -- The cost of this checking is very low, so the validation is done
411: -- whenever this procedure is called.
412: --
413: if p_rec.information_type <> p_rec.cei_information_category then
414: fnd_message.set_name('PER', 'HR_7438_FLEX_INV_REF_FIELD_VAL');
415: fnd_message.raise_error;
416: end if;
417: --
418: if ((p_rec.contact_extra_info_id is not null) and (

Line 415: fnd_message.raise_error;

411: -- whenever this procedure is called.
412: --
413: if p_rec.information_type <> p_rec.cei_information_category then
414: fnd_message.set_name('PER', 'HR_7438_FLEX_INV_REF_FIELD_VAL');
415: fnd_message.raise_error;
416: end if;
417: --
418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

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

744: (p_contact_extra_info_id => p_rec.contact_extra_info_id
745: ,p_effective_date => p_effective_date
746: ,p_object_version_number => p_rec.object_version_number
747: ) THEN
748: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
749: fnd_message.set_token('PROCEDURE ', l_proc);
750: fnd_message.set_token('STEP ', '5');
751: fnd_message.raise_error;
752: END IF;

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

745: ,p_effective_date => p_effective_date
746: ,p_object_version_number => p_rec.object_version_number
747: ) THEN
748: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
749: fnd_message.set_token('PROCEDURE ', l_proc);
750: fnd_message.set_token('STEP ', '5');
751: fnd_message.raise_error;
752: END IF;
753: --

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

746: ,p_object_version_number => p_rec.object_version_number
747: ) THEN
748: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
749: fnd_message.set_token('PROCEDURE ', l_proc);
750: fnd_message.set_token('STEP ', '5');
751: fnd_message.raise_error;
752: END IF;
753: --
754: -- Check if contact_relationship_id is updated.

Line 751: fnd_message.raise_error;

747: ) THEN
748: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
749: fnd_message.set_token('PROCEDURE ', l_proc);
750: fnd_message.set_token('STEP ', '5');
751: fnd_message.raise_error;
752: END IF;
753: --
754: -- Check if contact_relationship_id is updated.
755: -- Raise an error when contact_relationship_id is updated.

Line 872: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

868: --
869: -- An unhandled or unexpected error has occurred which
870: -- we must report
871: --
872: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
873: fnd_message.set_token('PROCEDURE', l_proc);
874: fnd_message.set_token('STEP','15');
875: fnd_message.raise_error;
876: End dt_update_validate;

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

869: -- An unhandled or unexpected error has occurred which
870: -- we must report
871: --
872: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
873: fnd_message.set_token('PROCEDURE', l_proc);
874: fnd_message.set_token('STEP','15');
875: fnd_message.raise_error;
876: End dt_update_validate;
877: --

Line 874: fnd_message.set_token('STEP','15');

870: -- we must report
871: --
872: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
873: fnd_message.set_token('PROCEDURE', l_proc);
874: fnd_message.set_token('STEP','15');
875: fnd_message.raise_error;
876: End dt_update_validate;
877: --
878: -- ----------------------------------------------------------------------------

Line 875: fnd_message.raise_error;

871: --
872: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
873: fnd_message.set_token('PROCEDURE', l_proc);
874: fnd_message.set_token('STEP','15');
875: fnd_message.raise_error;
876: End dt_update_validate;
877: --
878: -- ----------------------------------------------------------------------------
879: -- |--------------------------< dt_delete_validate >--------------------------|

Line 969: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

965: --
966: -- An unhandled or unexpected error has occurred which
967: -- we must report
968: --
969: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
970: fnd_message.set_token('PROCEDURE', l_proc);
971: fnd_message.set_token('STEP','15');
972: fnd_message.raise_error;
973: --

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

966: -- An unhandled or unexpected error has occurred which
967: -- we must report
968: --
969: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
970: fnd_message.set_token('PROCEDURE', l_proc);
971: fnd_message.set_token('STEP','15');
972: fnd_message.raise_error;
973: --
974: End dt_delete_validate;

Line 971: fnd_message.set_token('STEP','15');

967: -- we must report
968: --
969: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
970: fnd_message.set_token('PROCEDURE', l_proc);
971: fnd_message.set_token('STEP','15');
972: fnd_message.raise_error;
973: --
974: End dt_delete_validate;
975: --

Line 972: fnd_message.raise_error;

968: --
969: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
970: fnd_message.set_token('PROCEDURE', l_proc);
971: fnd_message.set_token('STEP','15');
972: fnd_message.raise_error;
973: --
974: End dt_delete_validate;
975: --
976: -- ----------------------------------------------------------------------------