135: open c;
136: fetch c into tlinfo;
137: if (c%notfound) then
138: close c;
139: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
140: fnd_msg_pub.add;
141: raise fnd_api.g_exc_unexpected_error;
142: end if;
143: close c;
142: end if;
143: close c;
144:
145: if (tlinfo.object_version_number <> x_object_version_number) then
146: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
147: fnd_msg_pub.add;
148: raise fnd_api.g_exc_unexpected_error;
149: end if;
150:
223: delete from cn_rate_dimensions
224: where rate_dimension_id = x_rate_dimension_id;
225:
226: if (sql%notfound) then
227: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
228: fnd_msg_pub.add;
229: raise fnd_api.g_exc_unexpected_error;
230: end if;
231: