135: p_effective_date => p_effective_date) then
136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
144: end if;
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
144: end if;
145: --
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
144: end if;
145: --
146: end if;
206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
212: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
213: fnd_message.raise_error;
214: --
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
212: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
213: fnd_message.raise_error;
214: --
215: end if;
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
212: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
212: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;
277: open c1;
278: fetch c1 into l_dummy;
279: if c1%found then
280: close c1;
281: fnd_message.set_name('BEN','BEN_92338_CD_AND_RL_UNIQUE');
282: fnd_message.raise_error;
283: end if;
284: --
285: hr_utility.set_location('Leaving:'||l_proc, 15);
278: fetch c1 into l_dummy;
279: if c1%found then
280: close c1;
281: fnd_message.set_name('BEN','BEN_92338_CD_AND_RL_UNIQUE');
282: fnd_message.raise_error;
283: end if;
284: --
285: hr_utility.set_location('Leaving:'||l_proc, 15);
286: End chk_cd_and_rl_unique;
342: p_effective_date => p_effective_date) then
343: --
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
347: fnd_message.set_token('FIELD','p_rqd_flag');
348: fnd_message.set_token('TYPE','YES_NO');
349: fnd_message.raise_error;
350: --
343: --
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
347: fnd_message.set_token('FIELD','p_rqd_flag');
348: fnd_message.set_token('TYPE','YES_NO');
349: fnd_message.raise_error;
350: --
351: end if;
344: -- raise error as does not exist as lookup
345: --
346: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
347: fnd_message.set_token('FIELD','p_rqd_flag');
348: fnd_message.set_token('TYPE','YES_NO');
349: fnd_message.raise_error;
350: --
351: end if;
352: --
345: --
346: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
347: fnd_message.set_token('FIELD','p_rqd_flag');
348: fnd_message.set_token('TYPE','YES_NO');
349: fnd_message.raise_error;
350: --
351: end if;
352: --
353: end if;