222: p_effective_date => p_effective_date) then
223: --
224: -- raise error as does not exist as lookup
225: --
226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
227: fnd_message.set_token('FIELD','p_actn_typ_due_dt_cd');
228: fnd_message.set_token('TYPE','BEN_ACTN_TYP_DUE_DT');
229: fnd_message.raise_error;
230: --
223: --
224: -- raise error as does not exist as lookup
225: --
226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
227: fnd_message.set_token('FIELD','p_actn_typ_due_dt_cd');
228: fnd_message.set_token('TYPE','BEN_ACTN_TYP_DUE_DT');
229: fnd_message.raise_error;
230: --
231: end if;
224: -- raise error as does not exist as lookup
225: --
226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
227: fnd_message.set_token('FIELD','p_actn_typ_due_dt_cd');
228: fnd_message.set_token('TYPE','BEN_ACTN_TYP_DUE_DT');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
225: --
226: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
227: fnd_message.set_token('FIELD','p_actn_typ_due_dt_cd');
228: fnd_message.set_token('TYPE','BEN_ACTN_TYP_DUE_DT');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
233: end if;
292: or not l_api_updating) then
293: --
294: if (p_actn_typ_due_dt_cd = 'RL' and p_actn_typ_due_dt_rl is null) then
295: --
296: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
297: fnd_message.raise_error;
298: --
299: end if;
300: --
293: --
294: if (p_actn_typ_due_dt_cd = 'RL' and p_actn_typ_due_dt_rl is null) then
295: --
296: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
297: fnd_message.raise_error;
298: --
299: end if;
300: --
301: if nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2) <> 'RL'
300: --
301: if nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2) <> 'RL'
302: and p_actn_typ_due_dt_rl is not null then
303: --
304: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
305: fnd_message.raise_error;
306: --
307: end if;
308: --
301: if nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2) <> 'RL'
302: and p_actn_typ_due_dt_rl is not null then
303: --
304: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
305: fnd_message.raise_error;
306: --
307: end if;
308: --
309: end if;