552: COMMIT WORK;
553: END IF;
554:
555: -- Debug Message
556: aso_utility_pvt.debug_message (
557: fnd_msg_pub.g_msg_lvl_debug_low,
558: 'Public API: ' || l_api_name || 'end'
559: );
560: -- Standard call to get message count and if count is 1, get message info.
564: );
565: EXCEPTION
566: WHEN fnd_api.g_exc_error
567: THEN
568: aso_utility_pvt.handle_exceptions (
569: p_api_name => l_api_name,
570: p_pkg_name => g_pkg_name,
571: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
572: p_package_type => aso_utility_pvt.g_pvt,
568: aso_utility_pvt.handle_exceptions (
569: p_api_name => l_api_name,
570: p_pkg_name => g_pkg_name,
571: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
572: p_package_type => aso_utility_pvt.g_pvt,
573: x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data,
575: x_return_status => x_return_status
576: );
575: x_return_status => x_return_status
576: );
577: WHEN fnd_api.g_exc_unexpected_error
578: THEN
579: aso_utility_pvt.handle_exceptions (
580: p_api_name => l_api_name,
581: p_pkg_name => g_pkg_name,
582: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
583: p_package_type => aso_utility_pvt.g_pvt,
579: aso_utility_pvt.handle_exceptions (
580: p_api_name => l_api_name,
581: p_pkg_name => g_pkg_name,
582: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
583: p_package_type => aso_utility_pvt.g_pvt,
584: x_msg_count => x_msg_count,
585: x_msg_data => x_msg_data,
586: x_return_status => x_return_status
587: );
586: x_return_status => x_return_status
587: );
588: WHEN OTHERS
589: THEN
590: aso_utility_pvt.handle_exceptions (
591: p_api_name => l_api_name,
592: p_pkg_name => g_pkg_name,
593: p_exception_level => aso_utility_pvt.g_exc_others,
594: p_package_type => aso_utility_pvt.g_pvt,
589: THEN
590: aso_utility_pvt.handle_exceptions (
591: p_api_name => l_api_name,
592: p_pkg_name => g_pkg_name,
593: p_exception_level => aso_utility_pvt.g_exc_others,
594: p_package_type => aso_utility_pvt.g_pvt,
595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,
597: x_return_status => x_return_status
590: aso_utility_pvt.handle_exceptions (
591: p_api_name => l_api_name,
592: p_pkg_name => g_pkg_name,
593: p_exception_level => aso_utility_pvt.g_exc_others,
594: p_package_type => aso_utility_pvt.g_pvt,
595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,
597: x_return_status => x_return_status
598: );