631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: ROLLBACK;
635: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
636: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
637:
638: errbuf := FND_MESSAGE.get;
639: retcode := 2;
632: EXCEPTION
633: WHEN OTHERS THEN
634: ROLLBACK;
635: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
636: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
637:
638: errbuf := FND_MESSAGE.get;
639: retcode := 2;
640:
634: ROLLBACK;
635: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
636: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
637:
638: errbuf := FND_MESSAGE.get;
639: retcode := 2;
640:
641: UPDATE hz_imp_batch_summary
642: SET import_status = 'ERROR'