Search Results igs_ge_s_log_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_GE_S_LOG_PKG package body is a generated table-handler package within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as API classification OTHER. Its principal business function is to encapsulate the standard Data Manipulation Language (DML) operations for the IGS_GE_S_LOG table, which serves as the general logging table within the Student Systems (IGS) product family. Rather than allowing direct manipulation of the log table, the package provides a controlled, reusable interface through which other PL/SQL objects can insert, update, lock, delete, and validate log records. The package is an internal infrastructure object rather than a business-facing API; it centralises the mechanics of row management so that logging activity across the IGS modules remains consistent and maintainable.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within this package body, all conforming to the standard Oracle Forms-generated table handler pattern:

  • INSERT_ROW — Inserts a new row into the IGS_GE_S_LOG table.
  • LOCK_ROW — Issues a locking read against an existing log row, typically to support concurrent update control.
  • UPDATE_ROW — Applies modifications to an existing log row.
  • ADD_ROW — Populates the table handler's internal row structure prior to an insert or update operation.
  • DELETE_ROW — Removes an existing log row from the table.
  • GET_PK_FOR_VALIDATION — Returns primary key information used to validate that a referenced row exists.
  • CHECK_CONSTRAINTS — Performs constraint validation logic before DML is committed.
  • BEFORE_DML — Executes pre-DML processing and defaulting logic that must occur before the row is written.

Parameter lists are not exposed in the documented metadata and are therefore not reproduced here.

Tables Accessed

The only documented table referenced by this package is IGS_GE_S_LOG, accessed through an APPS synonym. This table stores the log entries generated by the IGS general subsystem. All of the DML procedures above operate exclusively against this table, with INSERT_ROW, UPDATE_ROW, and DELETE_ROW performing the physical row changes and LOCK_ROW and CHECK_CONSTRAINTS providing concurrency and integrity safeguards. The dependency listing further confirms that the package relies on supporting infrastructure objects, including APP_EXCEPTION, FND_GLOBAL, FND_MESSAGE, IGS_GE_MSG_STACK, IGS_GE_S_LOG_ENTRY_PKG, and IGS_LOOKUPS_VIEW_PKG, which supply error handling, session context, message resolution, and lookup validation respectively.

Usage Notes

IGS_GE_S_LOG_PKG is invoked indirectly by other PL/SQL objects rather than by end users directly. The ETRM records that it is referenced by six other packages, and that it is not itself referenced by any database object at a higher level — confirming its position as a lower-tier utility package. It is typically called from Oracle Forms-based IGS application windows, from concurrent programs that generate log output, and from custom extensions that need to write to the IGS log table in a manner consistent with standard EBS behaviour. Because the package encapsulates constraint checking and pre-DML processing, custom code should invoke these procedures rather than issuing direct DML against IGS_GE_S_LOG. As with all generated table handlers, the package is regenerated whenever the underlying table definition changes, so direct modification of its source is not advisable.