125: --
126: open c1;
127: fetch c1 into l_dummy;
128: if c1%found then
129: fnd_message.set_name('BEN','BEN_91790_PL_TYP_AND_OPT');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
126: open c1;
127: fetch c1 into l_dummy;
128: if c1%found then
129: fnd_message.set_name('BEN','BEN_91790_PL_TYP_AND_OPT');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
191: p_effective_date => p_effective_date) then
192: --
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', 'p_pl_typ_opt_typ_cd');
197: fnd_message.set_token('TYPE', 'BEN_OPT_TYP');
198: fnd_message.raise_error;
199: --
192: --
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', 'p_pl_typ_opt_typ_cd');
197: fnd_message.set_token('TYPE', 'BEN_OPT_TYP');
198: fnd_message.raise_error;
199: --
200: end if;
193: -- raise error as does not exist as lookup
194: --
195: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', 'p_pl_typ_opt_typ_cd');
197: fnd_message.set_token('TYPE', 'BEN_OPT_TYP');
198: fnd_message.raise_error;
199: --
200: end if;
201: --
194: --
195: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
196: fnd_message.set_token('FIELD', 'p_pl_typ_opt_typ_cd');
197: fnd_message.set_token('TYPE', 'BEN_OPT_TYP');
198: fnd_message.raise_error;
199: --
200: end if;
201: --
202: end if;
308: --
309: -- An unhandled or unexpected error has occurred which
310: -- we must report
311: --
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','15');
315: fnd_message.raise_error;
316: End dt_update_validate;
309: -- An unhandled or unexpected error has occurred which
310: -- we must report
311: --
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','15');
315: fnd_message.raise_error;
316: End dt_update_validate;
317: --
310: -- we must report
311: --
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','15');
315: fnd_message.raise_error;
316: End dt_update_validate;
317: --
318: -- ----------------------------------------------------------------------------
311: --
312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
313: fnd_message.set_token('PROCEDURE', l_proc);
314: fnd_message.set_token('STEP','15');
315: fnd_message.raise_error;
316: End dt_update_validate;
317: --
318: -- ----------------------------------------------------------------------------
319: -- |--------------------------< dt_delete_validate >--------------------------|
429: --
430: -- An unhandled or unexpected error has occurred which
431: -- we must report
432: --
433: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
434: fnd_message.set_token('PROCEDURE', l_proc);
435: fnd_message.set_token('STEP','15');
436: fnd_message.raise_error;
437: End dt_delete_validate;
430: -- An unhandled or unexpected error has occurred which
431: -- we must report
432: --
433: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
434: fnd_message.set_token('PROCEDURE', l_proc);
435: fnd_message.set_token('STEP','15');
436: fnd_message.raise_error;
437: End dt_delete_validate;
438: --
431: -- we must report
432: --
433: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
434: fnd_message.set_token('PROCEDURE', l_proc);
435: fnd_message.set_token('STEP','15');
436: fnd_message.raise_error;
437: End dt_delete_validate;
438: --
439: -- ----------------------------------------------------------------------------
432: --
433: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
434: fnd_message.set_token('PROCEDURE', l_proc);
435: fnd_message.set_token('STEP','15');
436: fnd_message.raise_error;
437: End dt_delete_validate;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |---------------------------< insert_validate >----------------------------|
601: close csr_leg_code;
602: --
603: -- The primary key is invalid therefore we must error
604: --
605: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
606: fnd_message.raise_error;
607: --
608: end if;
609: --
602: --
603: -- The primary key is invalid therefore we must error
604: --
605: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
606: fnd_message.raise_error;
607: --
608: end if;
609: --
610: close csr_leg_code;