391: || SQLERRM);
392: END IF;
393:
394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
396: END cancel_batch;
397:
398:
399:
616: x_return_status := fnd_api.g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: WHEN OTHERS THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
621: x_return_status := fnd_api.g_ret_sts_unexp_error;
622:
623: IF g_debug <= gme_debug.g_log_unexpected THEN
624: gme_debug.put_line ( 'When others exception in '
692: x_return_status := fnd_api.g_ret_sts_error;
693: WHEN fnd_api.g_exc_unexpected_error THEN
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: WHEN OTHERS THEN
696: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
697: x_return_status := fnd_api.g_ret_sts_unexp_error;
698:
699: IF g_debug <= gme_debug.g_log_unexpected THEN
700: gme_debug.put_line ( 'When others exception in '