413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: ROLLBACK;
417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
418: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
419:
420: errbuf := FND_MESSAGE.get;
421: retcode := 2;
414: EXCEPTION
415: WHEN OTHERS THEN
416: ROLLBACK;
417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
418: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
419:
420: errbuf := FND_MESSAGE.get;
421: retcode := 2;
422:
416: ROLLBACK;
417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
418: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
419:
420: errbuf := FND_MESSAGE.get;
421: retcode := 2;
422:
423: UPDATE hz_imp_batch_summary
424: SET import_status = 'ERROR'