250: END LOOP;
251: end if;
252:
253:
254: x_return_status :=fnd_api.g_ret_sts_success;
255:
256: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
257: p_data => x_msg_data);
258:
257: p_data => x_msg_data);
258:
259: EXCEPTION
260:
261: when fnd_api.g_exc_error then
262: x_return_status:=fnd_api.g_ret_sts_error;
263:
264: when fnd_api.g_exc_unexpected_error then
265: x_return_status:=fnd_api.g_ret_sts_unexp_error;
258:
259: EXCEPTION
260:
261: when fnd_api.g_exc_error then
262: x_return_status:=fnd_api.g_ret_sts_error;
263:
264: when fnd_api.g_exc_unexpected_error then
265: x_return_status:=fnd_api.g_ret_sts_unexp_error;
266:
260:
261: when fnd_api.g_exc_error then
262: x_return_status:=fnd_api.g_ret_sts_error;
263:
264: when fnd_api.g_exc_unexpected_error then
265: x_return_status:=fnd_api.g_ret_sts_unexp_error;
266:
267: when others then
268: x_return_status:=fnd_api.g_ret_sts_unexp_error;
261: when fnd_api.g_exc_error then
262: x_return_status:=fnd_api.g_ret_sts_error;
263:
264: when fnd_api.g_exc_unexpected_error then
265: x_return_status:=fnd_api.g_ret_sts_unexp_error;
266:
267: when others then
268: x_return_status:=fnd_api.g_ret_sts_unexp_error;
269:
264: when fnd_api.g_exc_unexpected_error then
265: x_return_status:=fnd_api.g_ret_sts_unexp_error;
266:
267: when others then
268: x_return_status:=fnd_api.g_ret_sts_unexp_error;
269:
270: fnd_msg_pub.Count_And_Get(p_count => x_msg_count,
271: p_data => x_msg_data);
272: