Subversion Repositories SmartDukaan

        // Scheme/CN-backed reference types (CN_WALLET_REFERENCES) must flow through the scheme/offer code

        // paths that also reject the offer_payout / scheme_in_out, so the month-end MARGINS credit note

        // reverses with them. Posting one manually from this sheet leaves the payout un-rejected -> the CN

        // is over-issued and the account-statement scheme-adjustment line breaks (see the Jul-2026 re-tag

        // fix). Reject the whole sheet up-front (this endpoint is not transactional, so validate before any

        // row posts); manual scheme recoveries must be posted as OTHERS.

        List<WalletHistoryModel> blockedRows = walletHistoryModelList.stream()

                .filter(x -> WalletService.CN_WALLET_REFERENCES.contains(x.getWalletReferenceType()))

                .collect(Collectors.toList());

        if (!blockedRows.isEmpty()) {

            String offending = blockedRows.stream()

                    .map(x -> "fofoId " + x.getFofoId() + " => " + x.getWalletReferenceType())

                    .collect(Collectors.joining(", "));

            throw new ProfitMandiBusinessException("Wallet", "Wallet",

                    "Scheme/CN-backed reference types cannot be posted from the wallet bulk sheet - they must go "

                            + "through the scheme/offer flow so the credit note reverses. Post manual scheme recoveries as OTHERS. "

                            + "Offending rows: " + offending);

        }