115: open c1(p_table_name, p_col_name, l_oracle_schema );
116: fetch c1 into l_dummy;
117: if c1%notfound then
118: close c1;
119: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
120: fnd_message.raise_error;
121: end if;
122: close c1;
123:
116: fetch c1 into l_dummy;
117: if c1%notfound then
118: close c1;
119: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
120: fnd_message.raise_error;
121: end if;
122: close c1;
123:
124: --
125: -- Check operation is valid
126: --
127: if p_event not in ('CREATE','DELETE') then
128: --
129: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
130: fnd_message.set_token('PROC',l_proc);
131: fnd_message.set_token('EVENT',p_event);
132: fnd_message.raise_error;
133: --
126: --
127: if p_event not in ('CREATE','DELETE') then
128: --
129: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
130: fnd_message.set_token('PROC',l_proc);
131: fnd_message.set_token('EVENT',p_event);
132: fnd_message.raise_error;
133: --
134: end if;
127: if p_event not in ('CREATE','DELETE') then
128: --
129: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
130: fnd_message.set_token('PROC',l_proc);
131: fnd_message.set_token('EVENT',p_event);
132: fnd_message.raise_error;
133: --
134: end if;
135: --
128: --
129: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
130: fnd_message.set_token('PROC',l_proc);
131: fnd_message.set_token('EVENT',p_event);
132: fnd_message.raise_error;
133: --
134: end if;
135: --
136: if p_event = 'CREATE' then
533: p_argument_value => p_vrbl_rt_prfl_id);
534: --
535: if p_event not in ('CREATE','DELETE') then
536: --
537: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
538: fnd_message.set_token('PROC',l_proc);
539: fnd_message.set_token('EVENT',p_event);
540: fnd_message.raise_error;
541: --
534: --
535: if p_event not in ('CREATE','DELETE') then
536: --
537: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
538: fnd_message.set_token('PROC',l_proc);
539: fnd_message.set_token('EVENT',p_event);
540: fnd_message.raise_error;
541: --
542: end if;
535: if p_event not in ('CREATE','DELETE') then
536: --
537: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
538: fnd_message.set_token('PROC',l_proc);
539: fnd_message.set_token('EVENT',p_event);
540: fnd_message.raise_error;
541: --
542: end if;
543: --
536: --
537: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
538: fnd_message.set_token('PROC',l_proc);
539: fnd_message.set_token('EVENT',p_event);
540: fnd_message.raise_error;
541: --
542: end if;
543: --
544: if p_event = 'CREATE' then