787: WHEN OTHERS THEN
788: rollback to one;
789: debug('In OTHERS in CSIINVHB - Check CSI_TXN_ERRORS for Details');
790:
791: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
792: fnd_message.set_token('API_NAME',l_api_name);
793: fnd_message.set_token('SQL_ERROR',SQLERRM);
794:
795: x_trx_error_rec := l_trx_error_rec;
788: rollback to one;
789: debug('In OTHERS in CSIINVHB - Check CSI_TXN_ERRORS for Details');
790:
791: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
792: fnd_message.set_token('API_NAME',l_api_name);
793: fnd_message.set_token('SQL_ERROR',SQLERRM);
794:
795: x_trx_error_rec := l_trx_error_rec;
796: x_trx_error_rec.error_text := fnd_message.get;
789: debug('In OTHERS in CSIINVHB - Check CSI_TXN_ERRORS for Details');
790:
791: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
792: fnd_message.set_token('API_NAME',l_api_name);
793: fnd_message.set_token('SQL_ERROR',SQLERRM);
794:
795: x_trx_error_rec := l_trx_error_rec;
796: x_trx_error_rec.error_text := fnd_message.get;
797: x_trx_error_rec.transaction_id := NULL;
792: fnd_message.set_token('API_NAME',l_api_name);
793: fnd_message.set_token('SQL_ERROR',SQLERRM);
794:
795: x_trx_error_rec := l_trx_error_rec;
796: x_trx_error_rec.error_text := fnd_message.get;
797: x_trx_error_rec.transaction_id := NULL;
798: x_trx_error_rec.transaction_type_id := l_trx_error_rec.transaction_type_id;
799: x_trx_error_rec.source_type := p_transaction_type;
800: x_trx_error_rec.source_id := p_transaction_id;