114: -- Check operation is valid
115: --
116: if l_event not in ('CREATE','DELETE','UPGRADE') then
117: --
118: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
119: fnd_message.raise_error;
120: --
121: end if;
122: --
115: --
116: if l_event not in ('CREATE','DELETE','UPGRADE') then
117: --
118: fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');
119: fnd_message.raise_error;
120: --
121: end if;
122: --
123: -- Check for reference table existence.
132: open c_chk_table_exists(p_reference_table
133: ,p_reference_table_column,l_oracle_schema);
134: if c_chk_table_exists%notfound then
135: close c_chk_table_exists;
136: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
137: fnd_message.raise_error;
138: else
139: close c_chk_table_exists;
140: end if;
133: ,p_reference_table_column,l_oracle_schema);
134: if c_chk_table_exists%notfound then
135: close c_chk_table_exists;
136: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
137: fnd_message.raise_error;
138: else
139: close c_chk_table_exists;
140: end if;
141: --
144: open c_chk_table_exists(p_base_table
145: ,p_base_table_column,l_oracle_schema);
146: if c_chk_table_exists%notfound then
147: close c_chk_table_exists;
148: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
149: fnd_message.raise_error;
150: else
151: close c_chk_table_exists;
152: end if;
145: ,p_base_table_column,l_oracle_schema);
146: if c_chk_table_exists%notfound then
147: close c_chk_table_exists;
148: fnd_message.set_name('BEN','BEN_93388_NO_TAB_COL');
149: fnd_message.raise_error;
150: else
151: close c_chk_table_exists;
152: end if;
153: