Search Results sql_error

Overview

APPS.CE_BANK_AND_ACCOUNT_UTIL is a utility package in the Oracle E-Business Suite Cash Management (CE) module. Its principal business purpose is to provide reusable PL/SQL logic for retrieving, filtering, and masking internal bank account information, thereby centralizing the rules that govern how bank account numbers are presented to users, forms, reports, and other program units. The package is classified in the ETRM documentation as a UTIL (utility) API, indicating that it is not an interface table handler or a business event API, but a supporting library invoked by other code in the Oracle EBS environment.

A distinguishing feature of the package is its dependence on the profile option CE: Mask Internal Bank Account Numbers, exposed internally as the profile name CE_MASK_INTERNAL_BANK_ACCT_NUM. The masking functions in this package translate the setting of that profile into the concrete display format of a bank account number, supporting security-driven obfuscation of account digits.

Key Procedures and Functions

• GET_MASKED_BANK_ACCT_NUM — Public function that accepts a bank account identifier and returns the corresponding bank account number, formatted according to the value of the masking profile option. Based on the documented source, the profile accepts settings such as FIRST FOUR VISIBLE and LAST FOUR VISIBLE, in which case only the leading or trailing four characters are retained and the remaining positions are padded with asterisks; any other value returns the unmasked number.
• GET_MASKED_IBAN — Public function that returns an IBAN (International Bank Account Number) in masked form, applying masking logic analogous to GET_MASKED_BANK_ACCT_NUM for international account identifiers.
• GET_ORG_BANK_ACCT_LIST — Public function that accepts an organization identifier and returns the list of bank accounts to which that organization has access. According to the documented header comment, the returned list is delimited with the '@' character.
• GET_INTERNAL_BANK_ACCTS — Public function that retrieves internal bank accounts, providing the set of accounts treated as internal for downstream consumption by other program units.
• SQL_ERROR — Centralized error-handling procedure. It is invoked from exception handlers within the package (for example, in the WHEN OTHERS block of GET_MASKED_BANK_ACCT_NUM) to log or raise errors with the originating routine name, SQLCODE, and SQLERRM. This routine is the object most directly associated with user searches for "sql_error" in this package.

Tables Accessed

• CE_BANK_ACCOUNTS — The primary source of bank account records. GET_MASKED_BANK_ACCT_NUM reads BANK_ACCOUNT_NUM from this table by BANK_ACCOUNT_ID before applying masking.
• CE_BANK_ACCT_USES_ALL — The bank account uses table, which associates bank accounts with organizations. It supports the retrieval of accounts accessible to a given organization in GET_ORG_BANK_ACCT_LIST and GET_INTERNAL_BANK_ACCTS.
• PLITBLM — A general-purpose PL/SQL table used for in-memory list handling, supporting the construction and return of delimited account lists.

All table references resolve through APPS synonyms in the standard Oracle EBS manner.

Usage Notes

CE_BANK_AND_ACCOUNT_UTIL is referenced by seven other packages in the ETRM metadata, confirming its role as a shared utility. Typical invocation points include Oracle Forms in the Cash Management and Payables product families that must display masked bank account numbers to users, concurrent programs and reports that require organization-scoped bank account lists, and custom PL/SQL that needs consistent masking or list-building behavior. Developers searching for "sql_error" in connection with this object are most likely tracing an error raised from within one of its routines; the SQL_ERROR procedure is the documented exception pathway, and the routine name passed to it identifies the failing function. Because the package is a utility rather than a business event API, it should be called directly rather than registered with an event or workflow subscription. Its behavior is profile-dependent, so the effective masking result for any session is governed by the value of CE: Mask Internal Bank Account Numbers at the site, application, responsibility, or user level.