Search Results xnp_msg_types_pkg




Overview
Explore in AI Chat

Overview

XNP_MSG_TYPES_PKG is an Oracle Applications (APPS) PL/SQL package that supports the Oracle E-Business Suite message type configuration infrastructure, part of the XNP module (the seeded/extension message framework used by Oracle's eBusiness messaging and mobile/field service notification components). In EBS 12.1.1 and 12.2.2 the package is documented with a status of VALID and is owned by the APPS schema, meaning its declarations and body are compiled and deployed as part of the standard Applications technology stack.

The package is a table-handling (data maintenance) package. It is not a business logic API in the sense of a calculation engine; instead it provides the standard EBS row-level operations for the XNP_MSG_TYPES_B and XNP_MSG_TYPES_TL message type tables, together with the multilingual load and translation utilities used to seed and localize message type definitions. Its API classification is recorded as OTHER, reflecting that it is an internal/managed package rather than a public, published interface. The documented dependency graph confirms that XNP_MSG_TYPES_PKG references SYS.STANDARD and is in turn referenced by the XNP_MESSAGE and XNP_MSG_BUILDER packages, positioning it as a low-level building block in the XNP messaging layer.

Key Procedures and Functions

The package exposes seven documented procedures, which follow Oracle's conventional pattern for seed-data and translation management packages:

  • INSERT_ROW — inserts a new message type record into the base message type structures, typically creating the corresponding translation row.
  • LOCK_ROW — acquires a row-level lock on a message type record, used to serialize concurrent maintenance operations.
  • UPDATE_ROW — updates an existing message type record, including its translated attributes.
  • DELETE_ROW — removes a message type record, with the usual EBS convention of deleting from both the base and translation tables.
  • ADD_LANGUAGE — seeds translation rows in a specified language for message types that were created before that language was installed.
  • LOAD_ROW — loads a message type definition from a staged/seed source into the target tables, supporting upgrade and installation of seed data.
  • TRANSLATE_ROW — writes or refreshes translated message type text for a given language, supporting NLS deployment.

Tables Accessed

The package operates on the following tables, referenced through APPS synonyms:

  • XNP_MSG_TYPES_B — the base (language-independent) message type definition table, holding the core message type attributes.
  • XNP_MSG_TYPES_TL — the translation table that stores the language-dependent text for each message type, keyed by language.
  • FND_LANGUAGES — the Oracle Application Object Library languages table, consulted to validate installed languages and to drive ADD_LANGUAGE and TRANSLATE_ROW processing.

Usage Notes

XNP_MSG_TYPES_PKG is normally invoked indirectly rather than from custom code. Within Oracle EBS it is called by the XNP_MESSAGE and XNP_MSG_BUILDER packages, which use it to resolve and construct message types at runtime. The LOAD_ROW, ADD_LANGUAGE and TRANSLATE_ROW procedures are of the kind executed during patching, upgrade, or seed-data installation, when message types and their translations are deployed or when a new language is added to the instance. INSERT_ROW, UPDATE_ROW, LOCK_ROW and DELETE_ROW support the maintenance forms or concurrent programs that administer message type definitions. Customers performing customizations should treat this package as internal and rely on the supported XNP messaging APIs rather than calling these procedures directly, since direct invocation bypasses validation and audit handled at higher layers.