Search Results record_error




Overview
Explore in AI Chat

Overview

RRS_ATTR_PANE is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the attribute pane rendering framework used by Oracle's Regulatory and Revenue Services (RRS) module. The package is responsible for assembling the primary attribute records and secondary attribute page definitions that drive the display of RRS business objects — most notably sites — inside the EBS user interface. The header comment ($Header: RRSGATPB.pls 120.18 2010/12/06) identifies the file as a "G" (general) library member, and the package is classified as OTHER rather than as a public API, indicating that it is intended primarily for internal use by RRS forms and related components rather than as a documented integration surface.

The central design pattern in the package is the construction of strongly typed record structures (for example, rrs_primary_attribute_rec) and error message collections (rrs_error_msg_tab) that are passed to and from the UI layer. Object type determines which query is executed; the code explicitly branches on values such as 'SITE' and enforces row-level security through RRS_SECURITY_PUB.Check_Object_View_Privilege before returning attribute data.

Key Procedures and Functions

  • GET_PRIMARY_ATTRIBUTES — Populates the principal attributes for a given object type and identifier. It reads the ICX date format profile to honour the user's date preference (fix for Bug 9027024), selects the appropriate base table by object type, and returns a primary attribute record plus any error messages. It performs an RBAC check for site objects.
  • GET_ATTRIBUTE_PAGE — Retrieves the definition of an attribute page, drawing on page settings so that the correct layout and field set is presented for the object being viewed.
  • GET_DISPLAY_VALUE — Resolves the display (formatted, user-facing) value of a given attribute, applying lookups, date masks, and address formatting as required.
  • GET_DISP_VALUE_WITHOUT_UOM — A variant of the display value routine that returns the formatted value while deliberately omitting unit-of-measure decoration.
  • TO_CLIENT_TIMEZONE — Converts a date/time value into the client's time zone, ensuring that timestamps shown to the user reflect the correct local offset.
  • RECORD_ERROR — The procedure most directly relevant to the "record_error" search. It appends an error message to the rrs_error_msg_tab collection, providing a consistent mechanism for accumulating validation or lookup failures encountered during attribute retrieval so that they can be surfaced together in the UI instead of raising an immediate exception.

Tables Accessed

Utility access is provided through the DUAL and DBMS_UTILITY synonyms; DBMS_OUTPUT is referenced for diagnostic output, and PLITBLM for PL/SQL table management. Lookup views such as RRS_LOOKUPS_V, RRS_LOCATIONS_V, and the RRS site view are queried in the same manner.

Usage Notes

RRS_ATTR_PANE is documented as being referenced by zero other packages, confirming that it sits at the top of its call stack: it is invoked by RRS forms and client-side UI components, not by other PL/SQL libraries. Customisations that require error capture should call RECORD_ERROR rather than raising exceptions, matching the package's collection-based error model. Because the package is classified as OTHER, it is not a supported public API and should not be called from customer integration code without analysing the impact of upgrades; the date-format behaviour driven by the ICX_DATE_FORMAT_MASK profile option should also be considered in any custom invocation.