Search Results p_pa_debug_mode

Overview

APPS.PA_PERIOD_MASKS_PUB is a public PL/SQL API package in Oracle Projects that manages period masks — the reusable definitions that specify how a project's transaction stream is divided into reporting or billing periods. A period mask captures a name, description, time-phase code, effective dates, the number of periods, anchor period behavior, and the position relative to the anchor. The package exposes the maintenance and deletion of these masks and their detail lines through a standardized FND-style API contract. The package body identified by header revision PAFPPMMB.pls 120.0.12000000.2 is the version shipped for EBS 12.1.1 and 12.2.2.

The package follows the conventional Oracle EBS public API pattern: an x_return_status out parameter initialized to FND_API.G_RET_STS_SUCCESS, message count and message data out parameters, and a p_init_msg_flag controlling whether FND_MSG_PUB.Initialize is called. Callers pass p_commit_flag and p_init_msg_flag to control transaction boundaries and message stack initialization.

Key Procedures and Functions

• MAINTAIN_PERIOD_MASKS — Creates or updates a period mask header. It accepts the mask identifier, descriptive attributes (name, description, time phase code), effective dates, record version number for optimistic locking, and the period-level attributes (number of periods, anchor period flag, from-anchor position). An error flag table is passed IN OUT NOCOPY to return per-line validation results. The body performs name and other validations before delegating to the underlying utility layer.
• MAINTAIN_PERIOD_MASK_DTLS — Maintains the detail rows belonging to a period mask, operating on PA_PERIOD_MASK_DETAILS and the associated temporary staging structure.
• DELETE_PERIOD_MASK — Removes a period mask definition and its dependent detail rows, subject to the same message and return-status conventions.

Each routine returns x_return_status, x_msg_count, and x_msg_data, allowing callers to branch on FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR and to retrieve errors from the FND message stack.

Tables Accessed

• PA_PERIOD_MASKS_B — the base (non-translated) table holding period mask header rows; read and written during maintenance, and the source of the effective date column types.
• PA_PERIOD_MASKS_TL — the translation table for mask name and description, keyed by language.
• PA_PERIOD_MASKS_S — the sequence surrogate used to generate or validate mask identifiers.
• PA_PERIOD_MASK_DETAILS — the detail rows describing individual periods within a mask.
• PA_FP_PERIOD_MASK_TMP — the temporary/staging table used by the period mask generation logic.
• FND_LANGUAGES — the installed language list, used to write translation rows.
• DUAL — used for scalar evaluations.
• PLITBLM — the FND table used for message token substitution during error reporting.

Usage Notes

PA_PERIOD_MASKS_PUB is typically invoked from the Oracle Projects period mask maintenance forms and from concurrent programs that generate or copy period masks across projects. The declared debug flag P_PA_DEBUG_MODE is initialized from the profile option PA_DEBUG_MODE via FND_PROFILE.value; when set to Y, the body routes diagnostics through PA_DEBUG.init_err_stack, pa_debug.set_curr_function, and pa_fp_gen_amount_utils.fp_debug. This means the search term p_pa_debug_mode refers to the package-level debug switch rather than a formal parameter on the public procedures.

Because the package is classified as PUBLIC and references only APPS synonyms, custom code should call it directly and must honor the FND API contract: always pass p_init_msg_flag and p_commit_flag, inspect x_return_status after every call, and drain messages with FND_MSG_PUB.Count_And_Get. The package is not documented as being referenced by any other shipped package, so it should be treated as an entry point rather than an internal dependency.