99: -- Check operation is valid
100: --
101: if p_event not in ('CREATE','DELETE') then
102: --
103: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
104: fnd_message.raise_error;
105: --
106: end if;
107: --
100: --
101: if p_event not in ('CREATE','DELETE') then
102: --
103: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
104: fnd_message.raise_error;
105: --
106: end if;
107: --
108: open c1(p_table_name, p_col_name,l_oracle_schema );
108: open c1(p_table_name, p_col_name,l_oracle_schema );
109: fetch c1 into l_dummy;
110: if c1%notfound then
111: close c1;
112: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
113: fnd_message.raise_error;
114: end if;
115: close c1;
116: --
109: fetch c1 into l_dummy;
110: if c1%notfound then
111: close c1;
112: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
113: fnd_message.raise_error;
114: end if;
115: close c1;
116: --
117: --
214: p_argument_value => p_eligy_prfl_id);
215: --
216: if p_event not in ('CREATE','DELETE') then
217: --
218: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
219: fnd_message.raise_error;
220: --
221: end if;
222:
215: --
216: if p_event not in ('CREATE','DELETE') then
217: --
218: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
219: fnd_message.raise_error;
220: --
221: end if;
222:
223: