Search Results add_message

Overview

PSB_VALIDATE_DATA_EXTRACT_PVT is an Oracle EBS private (PVT) PL/SQL package body owned by APPS. It supports the data extraction and validation process within the Oracle Public Sector/HRMS benefits and salary planning domain (PSB modules). The package's primary business function is to validate data extracts — ensuring that staged data is complete, internally consistent, and ready for downstream processing. As a private API, it is not intended for direct customer invocation and is instead called by other packages within the same module. The ETRM metadata indicates this package is referenced by one other package, confirming its role as a supporting validation utility rather than a top-level entry point.

The package body is dated with a $Header comment from 2005, indicating it is stable legacy code that has been carried forward into EBS 12.1.1 and 12.2.2 releases. Its design follows the standard Oracle API pattern, including the use of FND_API.Compatible_API_Call for version compatibility checking and SAVEPOINT-based transaction control.

Key Procedures and Functions

The ETRM metadata documents three procedures/functions for this package:

DATA_EXTRACT_SUMMARY — This is the primary API procedure. It accepts API version, initialization, commit, and validation-level parameters following the standard FND_API convention, along with an extract method and a data extract ID. It declares a comprehensive set of local variables for position counts, employee counts, salary counts, cost counts, attribute counts, and employee assignment counts. The procedure implements the standard API lifecycle: it establishes a SAVEPOINT, calls FND_API.Compatible_API_Call to verify version compatibility, and performs summary-level validation of the data extract. Output parameters return status, message count, and message data.
VALIDATE_DATA_EXTRACT — This procedure performs the core validation logic for a given data extract, checking the integrity and completeness of extracted data. It is the substantive validation routine invoked within the package.
GET_DEBUG — This function returns the package's debug information stored in the g_dbug variable, supporting diagnostics and troubleshooting during execution.

The package also declares helper procedures message_token and add_message. The add_message procedure accepts an application name and message name, forming part of the FND message token infrastructure used to build user-facing validation messages. Associated package-level collections (TokNameArray and TokValArray) hold message token names and values, tracked by the no_msg_tokens counter.

Tables Accessed

Validation reads from and writes to the following APPS-synonym tables:

PSB_POSITIONS_I — position interface data used to verify position records.
PSB_EMPLOYEES_I — employee interface data for validating employee records.
PSB_EMPLOYEE_ASSIGNMENTS_I — assignment interface data for validating employee-to-position assignments.
PSB_SALARY_I — salary interface data for validating salary components.
PSB_COST_DISTRIBUTIONS_I — cost distribution interface data for validating costing allocations.
PSB_ATTRIBUTE_VALUES_I — attribute value interface data for validating flexible attribute records.
PSB_ERROR_MESSAGES — stores validation error messages generated during processing.

Each interface table holds staged extract data that must pass validation before being transferred to base tables; PSB_ERROR_MESSAGES captures any failures.

Usage Notes

As a private API (PVT classification), this package is not exposed for direct invocation by forms, concurrent programs, or custom code. It is invoked internally by its single referencing package, which orchestrates the data extract workflow. The DATA_EXTRACT_SUMMARY procedure is intended to be called programmatically with a valid data_extract_id and extract method. 12.1.1 and 12.2.2 compatibility is assured via FND_API.Compatible_API_Call. Developers troubleshooting validation failures should enable debug logging and inspect the output of GET_DEBUG and the contents of PSB_ERROR_MESSAGES.

PACKAGE BODY: APPS.PSB_VALIDATE_DATA_EXTRACT_PVT 12.1.1
PACKAGE BODY: APPS.PSB_HR_EXTRACT_PROCESS 12.1.1
PACKAGE BODY: APPS.INV_ITEM_REVISION_PUB 12.1.1
PACKAGE BODY: APPS.INV_ITEM_REVISION_PUB 12.2.2
APPS.FA_SRVR_MSG SQL Statements 12.1.1
PACKAGE: APPS.EAM_EXECUTION_JSP 12.1.1
APPS.PSB_BUDGET_GROUPS_PVT SQL Statements 12.1.1
PACKAGE BODY: APPS.EAM_EXECUTION_JSP 12.2.2
PACKAGE BODY: APPS.EAM_EXECUTION_JSP 12.1.1
PACKAGE BODY: APPS.INV_ITEM_MSG 12.1.1
PACKAGE: APPS.FA_SRVR_MSG 12.2.2
PACKAGE: APPS.EAM_EXECUTION_JSP 12.2.2
PACKAGE: APPS.FA_SRVR_MSG 12.1.1
PACKAGE BODY: APPS.INV_ITEM_MSG 12.2.2
PACKAGE BODY: APPS.ERROR_HANDLER 12.2.2
PACKAGE BODY: APPS.FA_SRVR_MSG 12.2.2
PACKAGE BODY: APPS.ERROR_HANDLER 12.1.1
PACKAGE BODY: APPS.PSB_BUDGET_GROUPS_PVT 12.1.1
PACKAGE BODY: APPS.GL_FUNDS_CHECKER_PKG 12.1.1
PACKAGE: APPS.ASO_UPGRADE_PVT 12.1.1
PACKAGE: APPS.ASO_UPGRADE_PVT 12.2.2
PACKAGE BODY: APPS.FA_SRVR_MSG 12.1.1
TYPE: APPS.JTF_DIAG_SECTION 12.2.2
owner:APPS, object_type:TYPE, object_name:JTF_DIAG_SECTION, status:VALID,
PACKAGE BODY: APPS.GL_FUNDS_CHECKER_PKG 12.2.2
PACKAGE BODY: APPS.PA_RP_UTIL 12.2.2
TYPE: APPS.JTF_DIAG_SECTION 12.1.1
owner:APPS, object_type:TYPE, object_name:JTF_DIAG_SECTION, status:VALID,
PACKAGE BODY: APPS.PA_RP_UTIL 12.1.1
PACKAGE BODY: APPS.GL_FLEX_INSERT_PKG 12.1.1
PACKAGE BODY: APPS.GL_FLEX_INSERT_PKG 12.2.2
PACKAGE: APPS.BIS_VG_UTIL 12.1.1
PACKAGE: APPS.BIS_VG_UTIL 12.2.2
PACKAGE BODY: APPS.POS_PUB_HISTORY_BO_PKG 12.2.2
PACKAGE BODY: APPS.PJI_REP_UTIL 12.1.1
PACKAGE BODY: APPS.PJI_REP_UTIL 12.2.2
PACKAGE BODY: APPS.ASO_UPGRADE_PVT 12.2.2
PACKAGE BODY: APPS.ASO_UPGRADE_PVT 12.1.1
PACKAGE BODY: APPS.IGC_CC_ACCGNWF_PKG 12.1.1
PACKAGE BODY: APPS.PSB_PURGE_DATA_EXTRACT_PVT 12.1.1
PACKAGE BODY: APPS.IGC_CC_ACCGNWF_PKG 12.2.2
PACKAGE BODY: APPS.BIS_VG_UTIL 12.2.2
APPS.INV_ITEM_REVISION_PUB SQL Statements 12.2.2
APPS.INV_ITEM_REVISION_PUB SQL Statements 12.1.1
PACKAGE BODY: APPS.BOM_RTG_ERROR_HANDLER 12.2.2
PACKAGE BODY: APPS.BIS_VG_UTIL 12.1.1
PACKAGE BODY: APPS.BOM_RTG_ERROR_HANDLER 12.1.1
PACKAGE: APPS.INV_ITEM_MSG 12.1.1
APPS.ERROR_HANDLER SQL Statements 12.1.1
APPS.ERROR_HANDLER SQL Statements 12.2.2
PACKAGE: APPS.INV_ITEM_MSG 12.2.2
PACKAGE BODY: APPS.PSB_GL_INTERFACE_PVT 12.1.1