177: NVL(l_latest_comp_date, TO_DATE('01/01/1952','MM/DD/YYYY')),
178: p_offer_id
179: );
180:
181: IF x_return_status = FND_API.g_ret_sts_error
182: THEN
183: RAISE FND_API.g_exc_error;
184: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
185: RAISE FND_API.g_exc_unexpected_error;
179: );
180:
181: IF x_return_status = FND_API.g_ret_sts_error
182: THEN
183: RAISE FND_API.g_exc_error;
184: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF;
187:
180:
181: IF x_return_status = FND_API.g_ret_sts_error
182: THEN
183: RAISE FND_API.g_exc_error;
184: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF;
187:
188: ozf_utility_pvt.write_conc_log('-- End refresh Offers --');
181: IF x_return_status = FND_API.g_ret_sts_error
182: THEN
183: RAISE FND_API.g_exc_error;
184: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF;
187:
188: ozf_utility_pvt.write_conc_log('-- End refresh Offers --');
189: IF p_offer_id IS NULL THEN
197: );
198: ozf_utility_pvt.write_conc_log('-- End refresh schedules --');
199:
200:
201: IF x_return_status = FND_API.g_ret_sts_error
202: THEN
203: RAISE FND_API.g_exc_error;
204: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
205: RAISE FND_API.g_exc_unexpected_error;
199:
200:
201: IF x_return_status = FND_API.g_ret_sts_error
202: THEN
203: RAISE FND_API.g_exc_error;
204: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
205: RAISE FND_API.g_exc_unexpected_error;
206: END IF;
207: END IF;
200:
201: IF x_return_status = FND_API.g_ret_sts_error
202: THEN
203: RAISE FND_API.g_exc_error;
204: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
205: RAISE FND_API.g_exc_unexpected_error;
206: END IF;
207: END IF;
208:
201: IF x_return_status = FND_API.g_ret_sts_error
202: THEN
203: RAISE FND_API.g_exc_error;
204: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
205: RAISE FND_API.g_exc_unexpected_error;
206: END IF;
207: END IF;
208:
209:
207: END IF;
208:
209:
210: EXCEPTION
211: WHEN FND_API.g_exc_unexpected_error THEN
212: ozf_utility_pvt.write_conc_log('-- Unexpected Error: --'||ERRBUF);
213:
214: WHEN OTHERS THEN
215: ozf_utility_pvt.write_conc_log('-- Error: --'||ERRBUF);