121: open c1;
122: fetch c1 into l_dummy;
123: if c1%found then
124: close c1;
125: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
126: fnd_message.raise_error;
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 15);
122: fetch c1 into l_dummy;
123: if c1%found then
124: close c1;
125: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
126: fnd_message.raise_error;
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 15);
130: End chk_name_unique;
186: p_effective_date => p_effective_date) then
187: --
188: -- raise error as does not exist as lookup
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
187: --
188: -- raise error as does not exist as lookup
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
188: -- raise error as does not exist as lookup
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
196: end if;
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
196: end if;
197: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
196: end if;
197: --
198: end if;
275: --
276: -- A referential integrity check was violated therefore
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
276: -- A referential integrity check was violated therefore
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
284: -- An unhandled or unexpected error has occurred which
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
293: -- ----------------------------------------------------------------------------
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |--------------------------< dt_delete_validate >--------------------------|
412: --
413: -- An unhandled or unexpected error has occurred which
414: -- we must report
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
413: -- An unhandled or unexpected error has occurred which
414: -- we must report
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
421: --
414: -- we must report
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
421: --
422: -- ----------------------------------------------------------------------------
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |---------------------------< insert_validate >----------------------------|
570: close csr_leg_code;
571: --
572: -- The primary key is invalid therefore we must error
573: --
574: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
571: --
572: -- The primary key is invalid therefore we must error
573: --
574: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: close csr_leg_code;