88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: ROLLBACK;
92: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
93: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
94:
95: errbuf := FND_MESSAGE.get;
96: retcode := 2;
89: EXCEPTION
90: WHEN OTHERS THEN
91: ROLLBACK;
92: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
93: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
94:
95: errbuf := FND_MESSAGE.get;
96: retcode := 2;
97:
91: ROLLBACK;
92: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
93: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
94:
95: errbuf := FND_MESSAGE.get;
96: retcode := 2;
97:
98: UPDATE hz_imp_batch_summary
99: SET import_status = 'ERROR'