Search Results gl_pll_routine_error




Overview
Explore in AI Chat

Overview

APPS.JG_GLPPOS_PKG is a Global Accounting Localization package body shipped as part of the Oracle E-Business Suite Global Ledger (JG) product family. Its primary business function is to enforce regional statutory posting controls — specifically Greek legal localization requirements — before a General Ledger posting run is permitted to commit. The package acts as a pre-posting validation gate for customers whose installation includes both the European Localization (application_id 7002) and the Regional Localization (application_id 7003) products. When those products are installed and enabled, JG_GLPPOS_PKG intercepts the posting execution and applies statutory cutoff and sequencing rules through calls to JE_GR_STATUTORY. This ensures that journal entries submitted to the ledger comply with country-specific legal and fiscal sequencing requirements, which is a mandatory control for Greek statutory reporting.

Key Procedures and Functions

  • GLPHK — The single documented procedure in the package. It accepts a posting run identifier and serves as the hook invoked during the GL posting cycle. GLPHK determines the active set of books from the GL_SET_OF_BKS_ID profile option, then checks whether both Localization applications 7002 and 7003 are fully installed (db_status and status equal to 'I'). If the install flag is positive, GLPHK delegates to JE_GR_STATUTORY.gl_cutoff to verify statutory cutoff rules and raises a cutoff_error exception when the cutoff routine returns a failure code. A second delegation to JE_GR_STATUTORY.gl_sequence for sequencing validation is present in the source but is commented out in the shipped version. Country determination was historically handled through the global_attribute_category column of GL_SETS_OF_BOOKS and a hard-coded Greece attribute category constant, but both were commented out under bug 5194263.

Tables Accessed

  • FND_PRODUCT_INSTALLATIONS — Queried through a DUAL-driven EXISTS construct to confirm that both European Localization (7002) and Regional Localization (7003) are installed and active. This determines whether statutory processing logic is executed at all.
  • DUAL — Used as the driving row source for the installation-detection SELECT, returning 'Y' into the install flag when the intersection of the two localization product records is non-empty.
  • GL_SETS_OF_BOOKS — Referenced in the source for reading global_attribute_category, although that query is commented out in the current release.

Usage Notes

JG_GLPPOS_PKG is not intended for direct invocation by end users. GLPHK is called internally by the General Ledger posting engine at the point where a posting run is about to process journals, providing a localization hook for statutory validation. It is relevant in EBS 12.1.1 and 12.2.2 environments where Greek localizations are deployed. The package is referenced by one other package in the ETRM repository, confirming its role as a dependent utility within the JG posting flow. The search term "gl_pll_routine_error" suggests users encountering errors are typically investigating a GL posting failure where a localization validation routine returned a non-zero code, causing GLPHK to raise the cutoff_error exception and abort the posting run. Diagnosis generally requires reviewing the JE_GR_STATUTORY cutoff configuration and the associated posting run diagnostics rather than debugging JG_GLPPOS_PKG directly.