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