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