Search Results p_debug_mode

Overview

PA_FC_RES_MAP is an Oracle EBS Application Object Library package body owned by APPS and classified as an OTHER-type API within the Oracle Projects (PA) module. Its role is to manage the mapping between resource list assignments and the resource maps that govern how transactions are matched to resource list members. In Oracle EBS 12.1.1 and 12.2.2, this package supports the resource management and forecasting functionality used by Oracle Projects, allowing transactions to be associated with specific resources that participate in a project's labor and non-labor resource lists. The package handles the deletion of existing resource maps for a given resource list assignment and the mapping of transactions to appropriate resource list members based on a range of project, person, job, organization, vendor, and expenditure attributes.

Key Procedures and Functions

The package exposes two documented procedures:

• DELETE_RES_MAPS_ON_ASGN_ID — Removes resource map rows from PA_RESOURCE_MAPS for a given resource list assignment identifier. When the assignment identifier is null, the procedure issues an unqualified delete against the table; otherwise it deletes only the rows matching the supplied assignment identifier. It returns a standard FND_API return status and error message code, and it honors the PA_DEBUG_MODE profile via the p_debug_mode variable, emitting debug messages through PA_FCK_UTIL when debugging is enabled.
• MAP_TRANS — Maps a transaction to the appropriate resource list member by accepting project, resource list, person, job, organization, vendor, expenditure type, event type, non-labor resource, expenditure category, revenue category, event type classification, and system linkage function attributes. It returns the resolved resource list member identifier along with the standard API return status and error message code. This procedure is the core mapping engine of the package, determining which resource list member corresponds to the transaction attributes supplied by the caller.

Tables Accessed

The package accesses PA_RESOURCE_MAPS through an APPS synonym. PA_RESOURCE_MAPS stores the resource map definitions that link resource list assignments to the attributes used during transaction matching. DELETE_RES_MAPS_ON_ASGN_ID performs delete operations against this table, either in full or scoped to a specific resource list assignment. MAP_TRANS depends on the same mapping data to resolve the correct resource list member for a transaction, effectively reading the configured mappings to support the lookup logic.

Usage Notes

PA_FC_RES_MAP is an internal Oracle Projects utility rather than a public integration API. It is referenced by zero other packages according to the ETRM metadata, indicating that it is invoked directly by Oracle Projects forms, concurrent programs, or internal processing that manages resource list assignments and transaction mapping. The p_debug_mode variable, initialized from the PA_DEBUG_MODE profile option, controls diagnostic output, so administrators can enable debug messages through that profile when troubleshooting resource mapping behavior. Because the procedures raise exceptions and return FND_API status codes, callers should check x_return_status and x_error_message_code after invocation. Custom code should avoid calling the private debugging machinery directly and instead rely on the standard API contract when extending resource mapping logic.