133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_prtt_ro_of_unusd_amt_flag');
139: fnd_message.set_token('VALUE',p_prtt_ro_of_unusd_amt_flag);
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_prtt_ro_of_unusd_amt_flag');
139: fnd_message.set_token('VALUE',p_prtt_ro_of_unusd_amt_flag);
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_prtt_ro_of_unusd_amt_flag');
139: fnd_message.set_token('VALUE',p_prtt_ro_of_unusd_amt_flag);
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: end if;
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_prtt_ro_of_unusd_amt_flag');
139: fnd_message.set_token('VALUE',p_prtt_ro_of_unusd_amt_flag);
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_prtt_ro_of_unusd_amt_flag');
139: fnd_message.set_token('VALUE',p_prtt_ro_of_unusd_amt_flag);
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
145: end if;
207: p_effective_date => p_effective_date) then
208: --
209: -- raise error as does not exist as lookup
210: --
211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
212: fnd_message.set_token('FIELD','p_acty_ref_perd_cd');
213: fnd_message.set_token('VALUE',p_acty_ref_perd_cd);
214: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
215: fnd_message.raise_error;
208: --
209: -- raise error as does not exist as lookup
210: --
211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
212: fnd_message.set_token('FIELD','p_acty_ref_perd_cd');
213: fnd_message.set_token('VALUE',p_acty_ref_perd_cd);
214: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
215: fnd_message.raise_error;
216: --
209: -- raise error as does not exist as lookup
210: --
211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
212: fnd_message.set_token('FIELD','p_acty_ref_perd_cd');
213: fnd_message.set_token('VALUE',p_acty_ref_perd_cd);
214: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
215: fnd_message.raise_error;
216: --
217: end if;
210: --
211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
212: fnd_message.set_token('FIELD','p_acty_ref_perd_cd');
213: fnd_message.set_token('VALUE',p_acty_ref_perd_cd);
214: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
215: fnd_message.raise_error;
216: --
217: end if;
218: if hr_api.not_exists_in_hr_lookups
211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
212: fnd_message.set_token('FIELD','p_acty_ref_perd_cd');
213: fnd_message.set_token('VALUE',p_acty_ref_perd_cd);
214: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
215: fnd_message.raise_error;
216: --
217: end if;
218: if hr_api.not_exists_in_hr_lookups
219: (p_lookup_type => 'BEN_ACTY_REF_PERD',
221: p_effective_date => p_effective_date) then
222: --
223: -- raise error as does not exist as lookup
224: --
225: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
226: fnd_message.set_token('FIELD','p_cmcd_ref_perd_cd');
227: fnd_message.set_token('VALUE',p_cmcd_ref_perd_cd);
228: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
229: fnd_message.raise_error;
222: --
223: -- raise error as does not exist as lookup
224: --
225: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
226: fnd_message.set_token('FIELD','p_cmcd_ref_perd_cd');
227: fnd_message.set_token('VALUE',p_cmcd_ref_perd_cd);
228: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
229: fnd_message.raise_error;
230: --
223: -- raise error as does not exist as lookup
224: --
225: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
226: fnd_message.set_token('FIELD','p_cmcd_ref_perd_cd');
227: fnd_message.set_token('VALUE',p_cmcd_ref_perd_cd);
228: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
229: fnd_message.raise_error;
230: --
231: end if;
224: --
225: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
226: fnd_message.set_token('FIELD','p_cmcd_ref_perd_cd');
227: fnd_message.set_token('VALUE',p_cmcd_ref_perd_cd);
228: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
225: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
226: fnd_message.set_token('FIELD','p_cmcd_ref_perd_cd');
227: fnd_message.set_token('VALUE',p_cmcd_ref_perd_cd);
228: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
233: end if;