Search Results validate_data_extract




Overview
Explore in AI Chat

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:

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.