Search Results link_stages

Overview

FND_SET is a public PL/SQL package in the APPS schema that provides the programmatic interface for defining and maintaining Oracle EBS concurrent program request sets. A request set is a named collection of concurrent programs, optionally organized into stages, that a user submits as a single unit. The package encapsulates the business rules that govern request set creation, stage and program membership, parameter definition, incompatibility relationships, and request set group assignment, so that both the standard Request Sets form and custom code can manipulate request set metadata through a supported API rather than by direct DML against the underlying FND tables.

The package is declared AUTHID CURRENT_USER and its header carries the ETRM lifecycle annotation "active" with a compatibility rating of "S" (supported). It is registered against the BUSINESS_ENTITY category FND_CP_REQUEST_SET and displays under the name "Request Set." The source header identifies it as AFRSSETS.pls, with the last shipped revision dated 2012/07/13, consistent with its role in the 12.1.1 and 12.2.2 code lines.

Error handling is centralized: when validation fails the package raises "ORA-06501: PL/SQL: internal error," and callers retrieve the specific message through the MESSAGE function. Some conditions, notably "duplicate value on index," are not trapped internally and surface directly to the caller.

Key Procedures and Functions

The documented interface exposes 34 procedures and functions, grouped by purpose below. Parameter lists are intentionally omitted; only documented purpose is described.

• Session and diagnostics: DEBUG_ON and DEBUG_OFF toggle package debugging. SET_SESSION_MODE sets the package mode for the current session, distinguishing "seed_data" (for datamerge) from the default "customer_data."
• Error reporting: MESSAGE returns the error message set when validation errors occur.
• Request set lifecycle: CREATE_SET registers a new request set (name, short name, application, description, owner, start and end dates). DELETE_SET removes an existing set. REQUEST_SET_EXISTS tests for prior existence.
• Stages: ADD_STAGE introduces a stage, LINK_STAGES establishes execution order between stages, STAGE_IN_SET validates membership, and REMOVE_STAGE deletes a stage from the set.
• Program membership: ADD_PROGRAM attaches a concurrent program to a request set, and REMOVE_PROGRAM detaches it.
• Parameters: PROGRAM_PARAMETER defines parameter values for a program within the set, and DELETE_PROGRAM_PARAMETER removes them.
• Incompatibilities: INCOMPATIBILITY, DELETE_INCOMPATIBILITY, and INCOMPATIBILITY_EXISTS manage programs that cannot run together.
• Group assignment: ADD_SET_TO_GROUP and REMOVE_SET_FROM_GROUP control request set group membership.

Tables Accessed

FND_SET reads and writes the core concurrent processing dictionary, mostly through APPS synonyms: FND_APPLICATION (owning application), FND_CONCURRENT_PROGRAMS and its _S and _TL variants (program definitions), FND_EXECUTABLES and its _S and _TL variants (executable definitions), FND_CONCURRENT_PROGRAM_SERIAL (serialization control), FND_CONCURRENT_REQUESTS (request data), FND_DESCR_FLEX_COLUMN_USAGES and FND_FLEX_VALUE_SETS (flexfield-based parameters), FND_LOOKUP_VALUES (lookups), FND_PRINTER and FND_PRINTER_STYLES (output defaults), and FND_LANGUAGES (translated content).

Usage Notes

FND_SET is primarily invoked by the Request Sets form in the System Administrator responsibility, and by concurrent programs or custom PL/SQL that need to build or maintain request sets in bulk. It is referenced by two other packages in the EBS codebase. Callers should check MESSAGE after any validation failure and should be prepared to handle untrapped exceptions such as duplicate index errors directly.