Search Results finp_ss_get_cur

Overview

IGS_FI_GEN_GL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, delivered as part of the Oracle Student System (formerly Oracle Student Financials, branded under the IGS product family). The package was originally created on 05-NOV-2002 by SYKRISHN to consolidate generic procedures and functions required for General Ledger (GL) interface processing, following the GL Interface Technical Design. It is classified under the "OTHER" API category, meaning it is not published as a formally supported public API but serves as an internal utility library consumed widely across the financials and GL interface modules. The current source header (IGSFI75S.pls 120.1) reflects a modification on 12-MAY-2006 by abshriva to add the GET_FORMATTED_AMOUNT function.

The package encapsulates logic that was previously scattered across the GL interface code base, centralising currency resolution, transaction-validity checks, period status determination, and lookup translation. Its scope ranges from simple currency retrieval to complex validation of GL applicability for invoices and credits.

Key Procedures and Functions

• FINP_GET_CUR — A procedure that returns the currency code and its description, along with a status message name. This is the primary routine for retrieving the functional currency context for a transaction.
• FINP_SS_GET_CUR — A function returning a VARCHAR2 value, providing currency information in a simplified (single-value) form. This relates directly to the user's search on "finp_ss_get_cur" and is commonly referenced in customisations that need just the currency code without the descriptor. The "SS" convention typically denotes a secondary or shortcut variant of the main routine.
• CHECK_UNPOSTED_TXNS_EXIST — A function returning BOOLEAN that tests whether unposted transactions exist within a given date range and for a specified accounting method. It supports period-close and posting controls.
• GET_PERIOD_STATUS_FOR_DATE — Determines the closing status of the accounting period that applies to a supplied date, returning the status and a message name.
• CHECK_GL_DT_APPL_NOT_VALID — A BOOLEAN function that validates whether a GL date is inapplicable for a given invoice and credit, used to prevent posting to invalid accounting dates.
• CHECK_NEG_CHGADJ_EXISTS — Tests for the existence of negative charge adjustment records for a given invoice.
• GET_LKP_MEANING — Retrieves the display meaning for a lookup code, providing a reusable translation utility.
• GET_FORMATTED_AMOUNT — Added in 2006, returns an amount formatted according to currency conventions.

Tables Accessed

The package references a broad set of APPS synonyms. Currency work relies on FND_CURRENCIES and FND_CURRENCIES_TL, while messaging uses FND_NEW_MESSAGES. Financial transaction validation draws on IGS_FI_INVLN_INT_ALL and IGS_FI_POSTING_INT_ALL (the invoice-line and posting interface tables), IGS_FI_APPLICATIONS, IGS_FI_CONTROL_ALL, IGS_FI_CREDITS_ALL, IGS_FI_CR_ACTIVITIES, and IGS_FI_CR_TYPES_ALL. IGS_AD_APP_REQ supports application-request context. These tables provide the data required for currency resolution, unposted-transaction detection, period status, and GL-date validity checks.

Usage Notes

IGS_FI_GEN_GL is invoked predominantly from GL interface concurrent programs and the student financials forms layer, where currency defaults and posting validations are required. The ETRM metadata records that it is referenced by 49 other packages, confirming its role as a foundational utility rather than a standalone entry point. Custom extensions that call FINP_SS_GET_CUR should be aware that the package is not a formally published API; behaviour may change without a compatibility guarantee, and callers should avoid embedding assumptions about return formats that are not documented.