103: open c1(p_table_name, p_col_name, l_oracle_schema );
104: fetch c1 into l_dummy;
105: if c1%notfound then
106: close c1;
107: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
108: fnd_message.raise_error;
109: end if;
110: close c1;
111:
104: fetch c1 into l_dummy;
105: if c1%notfound then
106: close c1;
107: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
108: fnd_message.raise_error;
109: end if;
110: close c1;
111:
112: --
113: -- Check operation is valid
114: --
115: if p_event not in ('CREATE','DELETE') then
116: --
117: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
118: fnd_message.set_token('PROC',l_proc);
119: fnd_message.set_token('EVENT',p_event);
120: fnd_message.raise_error;
121: --
114: --
115: if p_event not in ('CREATE','DELETE') then
116: --
117: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
118: fnd_message.set_token('PROC',l_proc);
119: fnd_message.set_token('EVENT',p_event);
120: fnd_message.raise_error;
121: --
122: end if;
115: if p_event not in ('CREATE','DELETE') then
116: --
117: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
118: fnd_message.set_token('PROC',l_proc);
119: fnd_message.set_token('EVENT',p_event);
120: fnd_message.raise_error;
121: --
122: end if;
123: --
116: --
117: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
118: fnd_message.set_token('PROC',l_proc);
119: fnd_message.set_token('EVENT',p_event);
120: fnd_message.raise_error;
121: --
122: end if;
123: --
124: if p_event = 'CREATE' then
521: p_argument_value => p_vrbl_rt_prfl_id);
522: --
523: if p_event not in ('CREATE','DELETE') then
524: --
525: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
526: fnd_message.set_token('PROC',l_proc);
527: fnd_message.set_token('EVENT',p_event);
528: fnd_message.raise_error;
529: --
522: --
523: if p_event not in ('CREATE','DELETE') then
524: --
525: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
526: fnd_message.set_token('PROC',l_proc);
527: fnd_message.set_token('EVENT',p_event);
528: fnd_message.raise_error;
529: --
530: end if;
523: if p_event not in ('CREATE','DELETE') then
524: --
525: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
526: fnd_message.set_token('PROC',l_proc);
527: fnd_message.set_token('EVENT',p_event);
528: fnd_message.raise_error;
529: --
530: end if;
531: --
524: --
525: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
526: fnd_message.set_token('PROC',l_proc);
527: fnd_message.set_token('EVENT',p_event);
528: fnd_message.raise_error;
529: --
530: end if;
531: --
532: if p_event = 'CREATE' then