Search Results sub_request

Overview

GMS_INSTALL_EXTN is a Grants Management (GMS) installation and seed-data loading package body owned by APPS. Its principal purpose is to bootstrap language-dependent reference data required by the Grants Management module immediately after installation or patching. The package orchestrates a two-stage load process: first it submits a driver concurrent program (GMSPIDRV) that performs the core GMS installation logic, and then it iterates over every installed language defined in FND_LANGUAGES to upload localized seed data through the FNDLOAD utility. This design reflects the standard Oracle EBS practice of separating programmatic installation steps from flat-file (.ldt) data loads executed by the generic FNDLOAD loader.

Key Procedures and Functions

• RUN_PROCESS — The sole documented procedure in the package, and the entry point exposed to the concurrent manager. It accepts the standard concurrent program OUT parameters (errbuf and retcode) used for status and error communication. RUN_PROCESS declares a configuration file prefix of '@GMS:patch/115/import/', opens a cursor over FND_LANGUAGES to identify languages whose installed_flag is 'I' or 'B' (installed or base), and then: (1) submits GMSPIDRV via FND_REQUEST.SUBMIT_REQUEST with sub_request set to FALSE; and (2) for each installed language, submits consecutive FNDLOAD requests to upload the localized lookup and budget-entry-method seed files (for example gmspilkp.ldt and gmspibem.ldt) using matching .lct control files. If any submit_request call returns zero, the procedure retrieves the error via FND_MESSAGE.GET, sets retcode to 2, and raises FND_API.G_EXC_ERROR. A SAVEPOINT named Run_Process_PVT is established at the start of execution to support controlled rollback of the transactional bookkeeping within the procedure.

Tables Accessed

• FND_LANGUAGES — Queried through the APPS synonym to obtain the language_code of every language flagged as installed ('I') or base ('B'). This cursor drives the loop that determines which localized .ldt seed files must be uploaded, ensuring the installation loads reference data appropriate to each active language. The package does not directly manipulate application data tables; all seed data is written indirectly by the spawned FNDLOAD concurrent requests.

Usage Notes

GMS_INSTALL_EXTN.RUN_PROCESS is intended to be invoked as a concurrent program, typically during initial Grants Management installation, upgrade, or when seed data must be refreshed. Because the procedure relies on FND_REQUEST.SUBMIT_REQUEST, it must run within a concurrent manager session; the return value of each submission is checked immediately so that a failure to enqueue any child request aborts the remaining work. The use of sub_request = FALSE means GMSPIDRV and the FNDLOAD jobs are submitted as standalone concurrent requests rather than as sub-requests of a parent, so their completion must be monitored separately. No other documented packages reference GMS_INSTALL_EXTN, and its API classification is OTHER, indicating it is not part of a published business API surface. Customizations should avoid modifying this package directly; localized seed data should instead be managed through supported FNDLOAD conventions. The package carries a header revision of 115.6 dated 2002, indicating it has remained stable across the 12.1.1 and 12.2.2 releases.