129: p_effective_date => p_effective_date) then
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_no_formula_flag');
135: fnd_message.set_token('TYPE','YES_NO');
136: fnd_message.raise_error;
137: --
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_no_formula_flag');
135: fnd_message.set_token('TYPE','YES_NO');
136: fnd_message.raise_error;
137: --
138: end if;
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_no_formula_flag');
135: fnd_message.set_token('TYPE','YES_NO');
136: fnd_message.raise_error;
137: --
138: end if;
139: --
132: --
133: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
134: fnd_message.set_token('FIELD','p_no_formula_flag');
135: fnd_message.set_token('TYPE','YES_NO');
136: fnd_message.raise_error;
137: --
138: end if;
139: --
140: end if;
221: close c1;
222: --
223: -- raise error
224: --
225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
226: fnd_message.set_token('ID',p_formula_id);
227: fnd_message.set_token('TYPE_ID',-508);
228: fnd_message.raise_error;
229: --
222: --
223: -- raise error
224: --
225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
226: fnd_message.set_token('ID',p_formula_id);
227: fnd_message.set_token('TYPE_ID',-508);
228: fnd_message.raise_error;
229: --
230: end if;
223: -- raise error
224: --
225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
226: fnd_message.set_token('ID',p_formula_id);
227: fnd_message.set_token('TYPE_ID',-508);
228: fnd_message.raise_error;
229: --
230: end if;
231: --
224: --
225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
226: fnd_message.set_token('ID',p_formula_id);
227: fnd_message.set_token('TYPE_ID',-508);
228: fnd_message.raise_error;
229: --
230: end if;
231: --
232: close c1;
618: --
619: if ( p_event_name in ('ON-COMMIT','KEY-EXIT','WHEN-NEW-FORM-INSTANCE') )
620: and (p_block_name is not null or p_field_name is not null)
621: then
622: fnd_message.set_name('BEN','BEN_94071_BLK_FLD_EVNT');
623: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
624: fnd_message.raise_error;
625: end if;
626: --
619: if ( p_event_name in ('ON-COMMIT','KEY-EXIT','WHEN-NEW-FORM-INSTANCE') )
620: and (p_block_name is not null or p_field_name is not null)
621: then
622: fnd_message.set_name('BEN','BEN_94071_BLK_FLD_EVNT');
623: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
624: fnd_message.raise_error;
625: end if;
626: --
627: if (p_event_name = 'POST-QUERY') and (p_field_name is not null)
620: and (p_block_name is not null or p_field_name is not null)
621: then
622: fnd_message.set_name('BEN','BEN_94071_BLK_FLD_EVNT');
623: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
624: fnd_message.raise_error;
625: end if;
626: --
627: if (p_event_name = 'POST-QUERY') and (p_field_name is not null)
628: then
625: end if;
626: --
627: if (p_event_name = 'POST-QUERY') and (p_field_name is not null)
628: then
629: fnd_message.set_name('BEN','BEN_94072_FLD_EVNT');
630: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
631: fnd_message.raise_error;
632: end if;
633: --
626: --
627: if (p_event_name = 'POST-QUERY') and (p_field_name is not null)
628: then
629: fnd_message.set_name('BEN','BEN_94072_FLD_EVNT');
630: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
631: fnd_message.raise_error;
632: end if;
633: --
634: hr_utility.set_location('Leaving'||l_proc,10);
627: if (p_event_name = 'POST-QUERY') and (p_field_name is not null)
628: then
629: fnd_message.set_name('BEN','BEN_94072_FLD_EVNT');
630: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
631: fnd_message.raise_error;
632: end if;
633: --
634: hr_utility.set_location('Leaving'||l_proc,10);
635: end chk_blk_fld_evnt ;
682: close c1;
683: --
684: -- raise an error as this pop-up name has already been used
685: --
686: fnd_message.set_name('BEN','BEN_94089_POP_NAME_UNIQ');
687: fnd_message.raise_error;
688: --
689: end if;
690: --
683: --
684: -- raise an error as this pop-up name has already been used
685: --
686: fnd_message.set_name('BEN','BEN_94089_POP_NAME_UNIQ');
687: fnd_message.raise_error;
688: --
689: end if;
690: --
691: close c1;