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