72: return 'N';
73:
74: EXCEPTION WHEN OTHERS THEN
75: IF g_debug_stmt THEN
76: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
77: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
78: END IF;
79: END IF;
80:
73:
74: EXCEPTION WHEN OTHERS THEN
75: IF g_debug_stmt THEN
76: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
77: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
78: END IF;
79: END IF;
80:
81: RETURN 'N';
143: END IF;
144:
145: EXCEPTION WHEN OTHERS THEN
146: IF g_debug_stmt THEN
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
149: END IF;
150:
151: END IF;
144:
145: EXCEPTION WHEN OTHERS THEN
146: IF g_debug_stmt THEN
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
149: END IF;
150:
151: END IF;
152: