1198: -- Commit all imports
1199: COMMIT;
1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: retcode := 2 ;
1204: cn_message_pkg.end_batch(l_process_audit_id);
1205: FND_MSG_PUB.count_and_get
1206: (p_count => l_msg_count ,
1204: cn_message_pkg.end_batch(l_process_audit_id);
1205: FND_MSG_PUB.count_and_get
1206: (p_count => l_msg_count ,
1207: p_data => errbuf ,
1208: p_encoded => FND_API.G_FALSE
1209: );
1210:
1211: WHEN OTHERS THEN
1212: err_num := SQLCODE;
1221: END IF;
1222: FND_MSG_PUB.count_and_get
1223: (p_count => l_msg_count ,
1224: p_data => errbuf ,
1225: p_encoded => FND_API.G_FALSE
1226: );
1227: END IF;
1228: cn_message_pkg.set_error(l_api_name,errbuf);
1229: cn_message_pkg.end_batch(l_process_audit_id);