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:
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: /*
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643: */
644: l_progress := '040';
645:
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: /*
736: IF FND_API.to_Boolean( p_init_msg_list ) THEN
737: FND_MSG_PUB.initialize;
738: END IF;
739: */
740: l_progress := '040';
741: