764: WHEN OTHERS THEN
765: rollback to one;
766: debug('In OTHERS in CSIINVHB - Check CSI_TXN_ERRORS for Details');
767:
768: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
769: fnd_message.set_token('API_NAME',l_api_name);
770: fnd_message.set_token('SQL_ERROR',SQLERRM);
771:
772: x_trx_error_rec := l_trx_error_rec;
765: rollback to one;
766: debug('In OTHERS in CSIINVHB - Check CSI_TXN_ERRORS for Details');
767:
768: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
769: fnd_message.set_token('API_NAME',l_api_name);
770: fnd_message.set_token('SQL_ERROR',SQLERRM);
771:
772: x_trx_error_rec := l_trx_error_rec;
773: x_trx_error_rec.error_text := fnd_message.get;
766: debug('In OTHERS in CSIINVHB - Check CSI_TXN_ERRORS for Details');
767:
768: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
769: fnd_message.set_token('API_NAME',l_api_name);
770: fnd_message.set_token('SQL_ERROR',SQLERRM);
771:
772: x_trx_error_rec := l_trx_error_rec;
773: x_trx_error_rec.error_text := fnd_message.get;
774: x_trx_error_rec.transaction_id := NULL;
769: fnd_message.set_token('API_NAME',l_api_name);
770: fnd_message.set_token('SQL_ERROR',SQLERRM);
771:
772: x_trx_error_rec := l_trx_error_rec;
773: x_trx_error_rec.error_text := fnd_message.get;
774: x_trx_error_rec.transaction_id := NULL;
775: x_trx_error_rec.transaction_type_id := l_trx_error_rec.transaction_type_id;
776: x_trx_error_rec.source_type := p_transaction_type;
777: x_trx_error_rec.source_id := p_transaction_id;