Search Results validate_resp_id
Overview
PSA_UTILS is a shared utility package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Despite its compact footprint, it serves two distinct purposes within the applications stack. The first is diagnostic infrastructure: a small library of FND_LOG wrapper routines that standardize how PSA-family packages emit debug and error messages. The second, and the reason users search for the identifier psa_get_rfe_ccid, is a set of validation and accounting-correction helpers used by Payables, Purchasing, and Grants-related processing. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than as its owner, which is significant for a utility that resolves accounting flexfield combinations and reverts Subledger Accounting entries. The source header indicates a last revision at version 120.9 dated 26-NOV-2010, so the logic has been stable across the 12.1 and 12.2 codelines.
Key Procedures and Functions
- DEBUG_UNEXPECTED_MSG — FND logging helper invoked from WHEN OTHERS exception handlers; logs the seeded message IGI_LOGGING_UNEXP_ERROR when no specific message is available.
- DEBUG_OTHER_MSG — Logs a message at a caller-supplied logging level, optionally removing the current entry from the call stack.
- DEBUG_OTHER_STRING — Logs a hard-coded string at a specified level via FND_LOG.
- DEBUG_MESG — General-purpose message logging routine.
- PSA_GET_RFE_CCID — Returns the "RFE" (reporting/flexfield extraction) code combination identifier for a passed CCID. This is the routine most frequently referenced in customizations and is the entry point behind the psa_get_rfe_ccid search term.
- UNDO_XLA_ACCOUNTING_FOR_INV / UNDO_XLA_ACCOUNTING_FOR_PO / REDO_XLA_ACCOUNTING_FOR_PO — Reversal and re-creation utilities for Subledger Accounting entries tied to invoice and purchase order transactions.
- VALIDATE_USER_NAME, VALIDATE_USER_ID, VALIDATE_RESP_ID — Lookup and integrity checks against FND_USER and FND_RESPONSIBILITY.
- VALIDATE_INVOICE_ID, VALIDATE_GL_DATE, VALIDATE_TAR_NUMBER, VALIDATE_BUG_NUMBER, VALIDATE_PO_HEADER_ID — Parameter validation helpers covering invoice identifiers, GL accounting dates, TAR and bug references, and PO headers.
Tables Accessed
The package reads and writes a broad set of APPS synonyms. Payables validation routines reference AP_INVOICES_ALL, AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, AP_HOLDS_ALL, AP_PREPAY_APP_DISTS, AP_PREPAY_HISTORY_ALL, and AP_SELF_ASSESSED_TAX_DIST_ALL. Security and responsibility checks query FND_USER and FND_RESPONSIBILITY. Accounting reversal logic touches GL_BC_PACKETS, GL_LEDGERS, and GL_PERIOD_STATUSES to determine open periods and packet state. Logging routines write to FND_LOG_MESSAGES_S, and grants-related processing references GMS_AWARD_DISTRIBUTIONS.
Usage Notes
PSA_UTILS is a support package rather than a user-facing API; it is referenced by approximately thirty other packages, and the PSA prefix ties it to the Public Sector / Grants accounting family. The debug routines are typically called from exception sections of custom and Oracle-delivered PL/SQL. The validation helpers are commonly invoked from Forms-based validations or from concurrent program pre-validation logic. The XLA undo/redo procedures are used during accounting correction scenarios, where a transaction must be backed out of Subledger Accounting and re-created. Because the package is AUTHID CURRENT_USER, callers must hold direct privileges on the underlying tables, and any custom code invoking PSA_GET_RFE_CCID should be tested against the target release, since the 120.9 source line predates some 12.2 accounting schema changes.