187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: -- Initialize message list if p_init_msg_list is set to TRUE
190: IF FND_API.to_Boolean(p_init_msg_list) THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193:
194:
195: -- Debug info.
224:
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227:
228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
229: p_count => x_msg_count,
230: p_data => x_msg_data);
231:
232: -- Debug info.
243: END IF;
244: WHEN fnd_api.g_exc_unexpected_error THEN
245: x_return_status := fnd_api.g_ret_sts_unexp_error;
246:
247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data);
250:
251: -- Debug info.
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
267: fnd_message.set_token('ERROR' ,SQLERRM);
268: fnd_msg_pub.add;
269:
270: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
271: p_count => x_msg_count,
272: p_data => x_msg_data);
266: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
267: fnd_message.set_token('ERROR' ,SQLERRM);
268: fnd_msg_pub.add;
269:
270: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
271: p_count => x_msg_count,
272: p_data => x_msg_data);
273:
274: -- Debug info.