Results for “ce_check_numeric”

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

Overview

The APPS.CE_BANK_AND_ACCOUNT_VALIDATION package body is a central validation utility within the Oracle Cash Management (CE) module of Oracle E-Business Suite. Its principal business function is to enforce data integrity and business rules governing banks, bank branches, bank accounts, and the payment documents and account uses associated with them. Rather than exposing a standalone user interface, the package provides a reusable library of validation routines that other Cash Management and Payments components call before persisting or acting upon bank and account data.

The package consolidates validation logic that spans multiple functional domains: bank and branch definition, organizational access security, currency and country validation, IBAN formatting, and payment document categorization. It is classified as an "OTHER" API in the ETRM registry, indicating that it is an internal validation package rather than a published public API. It is referenced by seven other database objects, confirming its role as a foundational dependency for higher-level Cash Management and Payables processing.

Key Procedures and Functions

The package body documents 21 procedures and functions. The validation routines fall into several logical groups:

• CE_CHECK_NUMERIC — Verifies that a supplied value is numeric, supporting downstream format checks on account and routing data.
• VALIDATE_BANK — Validates a bank record against Cash Management business rules.
• VALIDATE_BRANCH — Validates a bank branch record and its relationship to a parent bank.
• VALIDATE_ORG — Confirms the organizational context of a bank or account is valid.
• VALIDATE_CURRENCY — Checks that a specified currency is valid and enabled.
• VALIDATE_COUNTRY — Validates country references against territory definitions.
• VALIDATE_ACCOUNT_NAME and VALIDATE_SHORT_ACCOUNT_NAME — Enforce naming rules for bank accounts and their short names.
• VALIDATE_IBAN — Performs International Bank Account Number format validation.
• VALIDATE_ACCOUNT_USE — Validates the assignment of a bank account to an account use.
• VALIDATE_ACCOUNT_ACCESS_ORG and VALIDATE_UNIQUE_ORG_ACCESS — Enforce organization access security and prevent duplicate organization-to-account access grants.
• VALIDATE_END_DATE — Validates the end date on an account use or assignment.
• VALIDATE_ALC — Validates Assignment of Legal Classification data tied to the account.
• VALIDATE_DEF_SETTLEMENT — Validates default settlement configuration.
• GET_EMP_NAME — Retrieves an employee name for display or reference purposes.
• GET_ORG_TYPE and GET_ORG_TYPE_CODE — Return the organization type and its code.
• GET_MASKED_ACCOUNT_NUM — Returns a masked bank account number for secure display.
• GET_PAY_DOC_CAT — Retrieves a payment document category.

Tables Accessed

The package reads and validates against core Cash Management, Trading Community, and HR tables. Bank and account data is drawn from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, and CE_PAYMENT_DOCUMENTS. Payment document categories come from CE_AP_PM_DOC_CATEGORIES. Reference data is supplied by FND_CURRENCIES, FND_TERRITORIES, and FND_TERRITORIES_VL. Organization and party data is read from HZ_PARTIES, HZ_ORGANIZATION_PROFILES, HZ_CODE_ASSIGNMENTS, HR_ORGANIZATION_INFORMATION, and PER_EMPLOYEES_X. Validation scratch data uses HZ_BANK_VAL_GT and HZ_ORG_PROFILE_VAL_GT. Security profiles come from CE_SECURITY_PROFILES_V.

Usage Notes

This package is invoked indirectly rather than directly by end users. It is typically called from the Bank and Bank Account setup forms in Cash Management, from Payables payment creation flows, and from other PL/SQL packages that must verify bank or account data before committing. Because it is not referenced by any database object itself and is referenced by seven other packages, customizations should treat it as an internal dependency. Developers extending Cash Management validation should reuse these routines to preserve consistent business rule enforcement.