Search Results mass_awards_error_handling

Overview

GHR_MASS_AWARDS_PKG is an Oracle EBS Applications (APPS) PL/SQL package that supports the Mass Awards feature within the Oracle Human Resources / Advanced Benefits framework. It is defined with AUTHID CURRENT_USER, meaning that all unqualified database object references resolve under the privileges of the invoking schema rather than the package owner. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package encapsulates the server-side logic used to create, validate, and process mass award records that generate personnel action (PA) requests for multiple employees simultaneously. It mediates between the Mass Awards user interface, the PA request staging tables, and the nature-of-action (NOA) reference data, allowing HR administrators to apply a common award action to a defined population.

The package is classified as OTHER in the ETRM metadata and exposes 19 documented procedures and functions. It is referenced by one other package and primarily serves as the procedural backbone for the Mass Awards concurrent processing flow.

Key Procedures and Functions

The package exposes a mix of utility functions and processing routines:

• GET_NOA_CODE_DESC / GET_NOA_ID — Retrieve the code, description, and internal identifier for a nature of action, supporting validation and display of award action types.
• GET_BUSINESS_GROUP — Determines the business group associated with a person as of an effective date, used to enforce business-group-level security and defaults.
• GET_PA_REQUEST_ID_OVN — Returns the PA request identifier, with an object version number check to detect concurrent modification (the OVN convention in EBS).
• GET_AWARD_DETAILS / GET_AWARD_DETAILS_SHADOW / GET_AWARD_LAC / GET_AWARD_DETAILS — Populate award detail and legislative action code (LAC) information for award records and their shadow (staging) counterparts.
• MAIN_AWARDS / MARPA_PROCESS / BUILD_RPA_FOR_MASS_AWARDS / REFRESH_AWARD_DETAILS — Core processing routines that drive the mass awards lifecycle, building PA requests and refreshing award detail data.
• UPD_ELIG_FLAG_BEF_SELECTION / DEL_ELIG_FLAG_AFT_SELECTION — Manage eligibility flags before and after the selection step of the mass process.
• SET_EI / CREATE_SHADOW_ROW / UPDATE_SHADOW_ROW / CREATE_REMARKS — Maintain extra information (EI) and shadow rows, and generate remarks attached to PA requests.
• MASS_AWARDS_ERROR_HANDLING — Centralized error handling routine invoked when mass award processing encounters exceptions, logging failures and managing transaction state.
• CHECK_AWARD_AMOUNT — Validates award monetary amounts against configured limits or rules.

Tables Accessed

The package reads and writes a broad set of GHR and PER tables via APPS synonyms:

• GHR_MASS_AWARDS, GHR_NATURE_OF_ACTIONS — Source mass award definitions and nature-of-action reference data.
• GHR_PA_REQUESTS, GHR_PA_REQUEST_SHADOW, GHR_PA_REQUEST_EI_SHADOW, GHR_PA_REQUEST_EXTRA_INFO, GHR_PA_REQUEST_EXTRA_INFO_S — Personnel action request records and their shadow/extra-information staging tables used during processing.
• GHR_GROUPBOXES — Group selection criteria used to identify the population of employees.
• GHR_PA_REMARKS — Remarks generated and attached to PA requests.
• GHR_PA_ROUTING_HISTORY — Routing/approval history for PA requests.
• GHR_PROCESS_LOG_S — Process logging for concurrent execution tracking.
• PER_ASSIGNMENT_EXTRA_INFO — Assignment-level extra information used in eligibility and award processing.

Usage Notes

GHR_MASS_AWARDS_PKG is typically invoked indirectly through the Oracle HRMS Mass Awards form and its associated concurrent programs rather than called directly by end users. The presence of MAIN_AWARDS, MARPA_PROCESS, and BUILD_RPA_FOR_MASS_AWARDS indicates the package is driven from the concurrent manager during mass award batch processing. The error-handling procedure MASS_AWARDS_ERROR_HANDLING is intended to be called from within orchestration logic to manage exceptions and preserve data integrity. Customizations should call these routines only after accounting for the AUTHID CURRENT_USER behavior and the shadow-table staging pattern. Because the package is referenced by one other package, changes may have downstream impacts, and any extension should preserve the documented interface for the 19 public procedures and functions. In 12.1.1 and 12.2.2, the online patching and editioning model in 12.2.2 requires additional care when calling this package from custom code, since editioning views may affect synonym resolution.