238: end if;
239: end if;
240:
241:
242: x_return_status :=fnd_api.g_ret_sts_success;
243:
244: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
245: p_data => x_msg_data);
246:
245: p_data => x_msg_data);
246:
247: EXCEPTION
248:
249: when fnd_api.g_exc_error then
250: x_return_status:=fnd_api.g_ret_sts_error;
251:
252: when fnd_api.g_exc_unexpected_error then
253: x_return_status:=fnd_api.g_ret_sts_unexp_error;
246:
247: EXCEPTION
248:
249: when fnd_api.g_exc_error then
250: x_return_status:=fnd_api.g_ret_sts_error;
251:
252: when fnd_api.g_exc_unexpected_error then
253: x_return_status:=fnd_api.g_ret_sts_unexp_error;
254:
248:
249: when fnd_api.g_exc_error then
250: x_return_status:=fnd_api.g_ret_sts_error;
251:
252: when fnd_api.g_exc_unexpected_error then
253: x_return_status:=fnd_api.g_ret_sts_unexp_error;
254:
255: when others then
256: x_return_status:=fnd_api.g_ret_sts_unexp_error;
249: when fnd_api.g_exc_error then
250: x_return_status:=fnd_api.g_ret_sts_error;
251:
252: when fnd_api.g_exc_unexpected_error then
253: x_return_status:=fnd_api.g_ret_sts_unexp_error;
254:
255: when others then
256: x_return_status:=fnd_api.g_ret_sts_unexp_error;
257:
252: when fnd_api.g_exc_unexpected_error then
253: x_return_status:=fnd_api.g_ret_sts_unexp_error;
254:
255: when others then
256: x_return_status:=fnd_api.g_ret_sts_unexp_error;
257:
258: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
259: p_data => x_msg_data);
260: