101: COMMIT WORK;
102: END IF;
103:
104: -- Debug Message
105: aso_utility_pvt.debug_message (
106: fnd_msg_pub.g_msg_lvl_debug_low,
107: 'Public API: ' || l_api_name || 'end'
108: );
109: -- Standard call to get message count and if count is 1, get message info.
113: );
114: EXCEPTION
115: WHEN fnd_api.g_exc_error
116: THEN
117: aso_utility_pvt.handle_exceptions (
118: p_api_name => l_api_name,
119: p_pkg_name => g_pkg_name,
120: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
121: p_package_type => aso_utility_pvt.g_pub,
117: aso_utility_pvt.handle_exceptions (
118: p_api_name => l_api_name,
119: p_pkg_name => g_pkg_name,
120: p_exception_level => fnd_msg_pub.g_msg_lvl_error,
121: p_package_type => aso_utility_pvt.g_pub,
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: x_return_status => x_return_status
125: );
124: x_return_status => x_return_status
125: );
126: WHEN fnd_api.g_exc_unexpected_error
127: THEN
128: aso_utility_pvt.handle_exceptions (
129: p_api_name => l_api_name,
130: p_pkg_name => g_pkg_name,
131: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
132: p_package_type => aso_utility_pvt.g_pub,
128: aso_utility_pvt.handle_exceptions (
129: p_api_name => l_api_name,
130: p_pkg_name => g_pkg_name,
131: p_exception_level => fnd_msg_pub.g_msg_lvl_unexp_error,
132: p_package_type => aso_utility_pvt.g_pub,
133: x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data,
135: x_return_status => x_return_status
136: );
135: x_return_status => x_return_status
136: );
137: WHEN OTHERS
138: THEN
139: aso_utility_pvt.handle_exceptions (
140: p_api_name => l_api_name,
141: p_pkg_name => g_pkg_name,
142: p_exception_level => aso_utility_pvt.g_exc_others,
143: p_package_type => aso_utility_pvt.g_pub,
138: THEN
139: aso_utility_pvt.handle_exceptions (
140: p_api_name => l_api_name,
141: p_pkg_name => g_pkg_name,
142: p_exception_level => aso_utility_pvt.g_exc_others,
143: p_package_type => aso_utility_pvt.g_pub,
144: x_msg_count => x_msg_count,
145: x_msg_data => x_msg_data,
146: x_return_status => x_return_status
139: aso_utility_pvt.handle_exceptions (
140: p_api_name => l_api_name,
141: p_pkg_name => g_pkg_name,
142: p_exception_level => aso_utility_pvt.g_exc_others,
143: p_package_type => aso_utility_pvt.g_pub,
144: x_msg_count => x_msg_count,
145: x_msg_data => x_msg_data,
146: x_return_status => x_return_status
147: );