461: || SQLERRM);
462: END IF;
463:
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
466: END cancel_batch;
467:
468:
469:
755: x_return_status := fnd_api.g_ret_sts_error;
756: WHEN fnd_api.g_exc_unexpected_error THEN
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: WHEN OTHERS THEN
759: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761:
762: IF g_debug <= gme_debug.g_log_unexpected THEN
763: gme_debug.put_line ( 'When others exception in '
831: x_return_status := fnd_api.g_ret_sts_error;
832: WHEN fnd_api.g_exc_unexpected_error THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834: WHEN OTHERS THEN
835: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF g_debug <= gme_debug.g_log_unexpected THEN
839: gme_debug.put_line ( 'When others exception in '