225: END LOOP;
226: end if;
227:
228:
229: x_return_status :=fnd_api.g_ret_sts_success;
230:
231: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
232: p_data => x_msg_data);
233:
234: EXCEPTION
235:
236: when fnd_api.g_exc_error then
237: x_return_status:=fnd_api.g_ret_sts_error;
238:
239: when fnd_api.g_exc_unexpected_error then
240: x_return_status:=fnd_api.g_ret_sts_unexp_error;
233:
234: EXCEPTION
235:
236: when fnd_api.g_exc_error then
237: x_return_status:=fnd_api.g_ret_sts_error;
238:
239: when fnd_api.g_exc_unexpected_error then
240: x_return_status:=fnd_api.g_ret_sts_unexp_error;
241:
235:
236: when fnd_api.g_exc_error then
237: x_return_status:=fnd_api.g_ret_sts_error;
238:
239: when fnd_api.g_exc_unexpected_error then
240: x_return_status:=fnd_api.g_ret_sts_unexp_error;
241:
242: when others then
243: x_return_status:=fnd_api.g_ret_sts_unexp_error;
236: when fnd_api.g_exc_error then
237: x_return_status:=fnd_api.g_ret_sts_error;
238:
239: when fnd_api.g_exc_unexpected_error then
240: x_return_status:=fnd_api.g_ret_sts_unexp_error;
241:
242: when others then
243: x_return_status:=fnd_api.g_ret_sts_unexp_error;
244:
239: when fnd_api.g_exc_unexpected_error then
240: x_return_status:=fnd_api.g_ret_sts_unexp_error;
241:
242: when others then
243: x_return_status:=fnd_api.g_ret_sts_unexp_error;
244:
245: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
246: p_data => x_msg_data);
247: