Search Results pay_evg_shd




Overview
Explore in AI Chat

Overview

APPS.PAY_EVG_SHD is the shadow (row-handler) package body generated for the PAY_EVENT_GROUPS entity in Oracle EBS Payroll. Its role is to provide the table-level Data Manipulation Language and referential-integrity support that the PAY_EVENT_GROUPS table handler invokes: performing inserts, updates, and deletes, enforcing the primary, unique, and foreign key constraints declared on the entity, translating Oracle error conditions into translated FND messages, and providing optimistic locking through the standard _SHD row-handler mechanism. The package does not implement payroll business rules itself; it is a thin, mechanically generated layer that sits beneath the PAY_EVENT_GROUPS API and ensures that database constraint violations surface to the user as actionable, translated error messages rather than raw Oracle error codes.

Key Procedures and Functions

  • CONSTRAINT_ERROR — Maps a violated database constraint name to a specific FND message. When the constraint is PAY_EVENT_GROUPS_PK, it raises HR_7220_INVALID_PRIMARY_KEY, the message that is the subject of the user's search. When PAY_EVENT_GROUPS_UK1 is violated, it raises HR_6123_ALL_UNIQUE_NAME with the token INFORMATION_TYPE set to 'Event Group'. For any other constraint, it raises HR_7877_API_INVALID_CONSTRAINT, passing the procedure name and the offending constraint name as tokens. This procedure is the sole reason HR_7220 appears in the stack when a primary-key conflict is detected.
  • API_UPDATING — A private function used to determine whether the row handler is currently executing in an update context, allowing the generated logic to branch between insert and update processing.
  • LCK — Implements the row-level locking check that supports optimistic concurrency control, verifying the row's last-update information before permitting a modification.
  • CONVERT_ARGS — Normalises and converts the argument values passed into the row handler before they are applied to the entity's columns, reconciling the API's parameter datatypes with those of the underlying table.

Tables Accessed

  • PAY_EVENT_GROUPS — The primary entity maintained by this row handler. The package inserts, updates, and deletes rows in this table and applies the PK, UK1, and foreign-key constraints whose violations drive the CONSTRAINT_ERROR logic.
  • ALL_CONSTRAINTS — Consulted to resolve constraint metadata; the package references ALL_CONSTRAINTS.CONSTRAINT_NAME as the datatype anchor for the constraint_error parameter, enabling consistent, dictionary-driven constraint identification.

Usage Notes

PAY_EVG_SHD is not intended for direct invocation. It is called indirectly from the PAY_EVENT_GROUPS API and referenced by four other packages in the payroll schema. Practically, it is invoked when a user or concurrent program creates or modifies an event group through the Event Groups form or through a payroll API call. The most common diagnostic scenario is the one that generated the search term: a caller attempts to insert or update a PAY_EVENT_GROUPS row with a primary key that already exists, the database raises the PK violation, the row handler routes it to CONSTRAINT_ERROR, and the user receives the message HR_7220_INVALID_PRIMARY_KEY instead of an ORA-00001. When troubleshooting HR_7220, the fault normally lies in the calling API or form passing a duplicate or incorrectly derived EVENT_GROUP_ID, not in PAY_EVG_SHD itself. Custom integrations should use the supported PAY_EVENT_GROUPS API rather than manipulating this shadow package or the base table directly, since bypassing the API also bypasses the locking, argument-conversion, and error-translation behaviour described above.