Results for “ce_remove_formats”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CE_VALIDATE_BANKINFO is a PL/SQL package in the Oracle E-Business Suite Cash Management (CE) module that centralizes the validation logic applied to banks, bank branches, and bank accounts across Oracle Payables, Receivables, and Cash Management. Its core responsibility is to enforce structural, numeric, and country-specific rules on bank and account identifiers before records are committed to the underlying Cash Management and Payments tables. The package header carries the version stamp cevlbnks.pls 120.18, indicating a long-lived, incrementally maintained component of the EBS codebase applicable to releases 12.1.1 and 12.2.2.

Of particular relevance to searches concerning BIC (Bank Identifier Code) validation, the package exposes the procedure CE_VALIDATE_BIC, which is the documented entry point for validating a BIC/SWIFT code supplied against a bank record. This makes the package the repository of the standard BIC format check used when users enter or import bank information through the EBS user interfaces.

Key Procedures and Functions

• CE_VALIDATE_BIC — Validates a supplied BIC code, returning standard message-list output via its message count, message data, and return status parameters.
• CE_CHECK_NUMERIC — Confirms that a specified range of characters within a value is numeric.
• CE_REMOVE_FORMATS — Strips formatting characters from an input string prior to validation.
• COMPARE_BANK_AND_BRANCH_NUM — Compares a branch number against its parent bank record.
• COMPARE_ACCOUNT_NUM_AND_CD — Compares an account number against a check-digit value, using check-digit length and optional positional offset.
• CE_VAL_UNIQUE_TAX_PAYER_ID, CE_CHECK_CROSS_MODULE_TAX_ID, and CE_TAX_ID_CHECK_ALGORITHM — Validate tax payer identifiers, including uniqueness and cross-module consistency across AR, AP, HR, and bank records.
• CE_UNIQUE_BRANCH_NAME, CE_UNIQUE_BRANCH_NUMBER, CE_UNIQUE_BRANCH_NAME_ALT, and CE_UNIQUE_ACCOUNT_NAME — Enforce uniqueness of branch and account naming attributes.
• Country-specific check-digit validators, including CE_VALIDATE_CD, CE_VALIDATE_CD_PT, CE_VALIDATE_CD_ES, CE_VALIDATE_CD_FR, and CE_VALIDATE_CD_DE, plus the general validators CE_VALIDATE_BANK, CE_VALIDATE_BRANCH, and CE_VALIDATE_ACCOUNT. The metadata documents 113 procedures and functions in total.

Tables Accessed

• CE_BANK_ACCOUNTS — The primary Cash Management bank account entity, read for account-level validation.
• CE_UK_VAL_MODULUS_WEIGHTS and CE_UK_VAL_SUBS_CODES — United Kingdom modulus-weighting and substitution-code reference data used in UK account validation.
• IBY_EXT_BANK_ACCOUNTS — Payments external bank account records.
• HZ_PARTIES, HZ_ORGANIZATION_PROFILES, HZ_RELATIONSHIPS, and HZ_CODE_ASSIGNMENTS — Trading Community Architecture tables used to resolve party, organization, and relationship context.
• DUAL and PLITBLM — Oracle standard single-row and message-list utility objects.

Usage Notes

The package is classified as OTHER (not a formally published public API) yet is referenced by four other packages, indicating it is invoked internally by the EBS bank and account setup flows, including the Bank Account setup forms and bank import processes. Custom code should treat it cautiously: it is callable for diagnostic validation of BIC and account identifiers, but it is not a supported extension API. Where BIC validation is required outside standard forms, the safest approach is to invoke CE_VALIDATE_BIC with an initialized message list and inspect the returned message count, message data, and return status rather than relying on an undocumented boolean outcome.