196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF fnd_api.to_boolean(p_init_msg_list) THEN
200: fnd_msg_pub.initialize;
201: END IF;
202:
203: -- Initialize API return status to success
204: x_return_status := fnd_api.g_ret_sts_success;
940: COMMIT WORK;
941: END IF;
942:
943: -- Standard call to get message count and if count is 1, get message info.
944: fnd_msg_pub.count_and_get(
945: p_encoded => fnd_api.g_false
946: ,p_count => x_msg_count
947: ,p_data => x_msg_data);
948:
976: AND meavi.process_status = 'E'
977: AND meavi.error_number IS NOT NULL);
978:
979: x_return_status := fnd_api.g_ret_sts_error;
980: fnd_msg_pub.count_and_get(
981: p_encoded => fnd_api.g_false
982: ,p_count => x_msg_count
983: ,p_data => x_msg_data);
984:
988: END IF;
989: WHEN fnd_api.g_exc_error THEN
990: -- ROLLBACK TO import_asset_attr_values_pvt;
991: x_return_status := fnd_api.g_ret_sts_error;
992: fnd_msg_pub.count_and_get(
993: p_encoded => fnd_api.g_false
994: ,p_count => x_msg_count
995: ,p_data => x_msg_data);
996:
1001:
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: -- ROLLBACK TO import_asset_attr_values_pvt;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: fnd_msg_pub.count_and_get(
1006: p_encoded => fnd_api.g_false
1007: ,p_count => x_msg_count
1008: ,p_data => x_msg_data);
1009:
1015: WHEN OTHERS THEN
1016: -- ROLLBACK TO import_asset_attr_values_pvt;
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018:
1019: IF fnd_msg_pub.check_msg_level(
1020: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1021: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1022: END IF;
1023:
1016: -- ROLLBACK TO import_asset_attr_values_pvt;
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018:
1019: IF fnd_msg_pub.check_msg_level(
1020: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1021: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1022: END IF;
1023:
1024: fnd_msg_pub.count_and_get(
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018:
1019: IF fnd_msg_pub.check_msg_level(
1020: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1021: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1022: END IF;
1023:
1024: fnd_msg_pub.count_and_get(
1025: p_encoded => fnd_api.g_false
1020: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1021: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1022: END IF;
1023:
1024: fnd_msg_pub.count_and_get(
1025: p_encoded => fnd_api.g_false
1026: ,p_count => x_msg_count
1027: ,p_data => x_msg_data);
1028: