147: open c;
148: fetch c into tlinfo;
149: if (c%notfound) then
150: close c;
151: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
152: fnd_msg_pub.add;
153: raise fnd_api.g_exc_unexpected_error;
154: end if;
155: close c;
154: end if;
155: close c;
156:
157: if (tlinfo.object_version_number <> x_object_version_number) then
158: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
159: fnd_msg_pub.add;
160: raise fnd_api.g_exc_unexpected_error;
161: end if;
162:
225: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
226: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;
227:
228: if (sql%notfound) then
229: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
230: fnd_msg_pub.add;
231: raise fnd_api.g_exc_unexpected_error;
232: end if;
233: end UPDATE_ROW;
238: delete from CN_RATE_DIM_TIERS
239: where RATE_DIM_TIER_ID = X_RATE_DIM_TIER_ID;
240:
241: if (sql%notfound) then
242: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
243: fnd_msg_pub.add;
244: raise fnd_api.g_exc_unexpected_error;
245: end if;
246: