229: EXCEPTION
230: WHEN fnd_api.g_exc_error THEN
231:
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
234: p_data => x_msg_data);
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
238: fnd_msg_pub.count_and_get(p_count => x_msg_count,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241:
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: WHEN OTHERS THEN
241:
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243:
244: fnd_msg_pub.count_and_get(p_count => x_msg_count,
245: p_data => x_msg_data);
246:
247: END;
248: