Search Results null_alert

Overview

APPS.JS is a server-side PL/SQL utility package that generates client-side JavaScript fragments within Oracle E-Business Suite pages. Its source header identifies it as ICXJAVAS.pls, last revised in October 2005, and it is owned by the APPS schema in both EBS 12.1.1 and 12.2.2. The package falls under the OTHER API classification, meaning Oracle does not publish a formal, supported public interface for it; it exists primarily as an internal helper used by Oracle's own page-rendering code and is exposed to the APPS schema for reuse by dependent objects.

The business function of APPS.JS is to centralize the emission of common JavaScript constructs — script blocks, form tags, buttons, checkboxes, text areas, and client-side validation routines — so that individual EBS modules do not have to hand-code these elements. It sits alongside Oracle's Web Toolkit (HTP and OWA_UTIL) as a thin, purpose-built layer that translates PL/SQL calls into the HTML and JavaScript that a browser ultimately receives. The package is referenced by 39 other packages, confirming its role as shared infrastructure rather than a standalone application component.

Key Procedures and Functions

The documented members are grouped by purpose:

• NUMERIC_CHARACTERS — a procedure that establishes numeric character handling for generated scripts.
• SCRIPTOPEN / SCRIPTCLOSE — each exists as both a function returning VARCHAR2 and a procedure, providing the opening and closing tags (and equivalent string values) for a JavaScript block.
• FORMOPEN — likewise provided as a function and a procedure, emitting the opening markup for a JavaScript form.
• DYNAMICBUTTON — a procedure that renders a dynamically constructed button element.
• BUTTON — function and procedure variants that emit a button with a name, value, and onClick handler.
• CHECKBOX — function and procedure variants that emit a checkbox with name, value, onClick handler, and a checked flag.
• TEXT — function and procedure variants that emit a text area, accepting a name, value, size, and the onBlur, onChange, onFocus, and onSelect handlers.
• MONEY_DECIMAL — a procedure that places a money-decimal script into the HTML, taking a precision argument.
• ARRAYCREATE — a procedure that places a MakeArray script into the page.
• CHECKNUMBER — a procedure that places the checkNumber validation script.
• REPLACEDBQUOTE — a procedure that escapes embedded double quotes as \" in any string.
• CHECKVALUE / CHECKVALUEPOS — procedures that inject the checkNumberValue routine, the latter for positive-value cases.
• NULL_ALERT, SPACES_ALERT, EQUAL_ALERT — procedures that inject client-side alert routines, including the null_alert handler the user searched for, which warns when a required field is left empty.
• FORMAT_NUMBER — formats numeric output within generated scripts.

Tables Accessed

APPS.JS does not read or write application business tables. Its documented dependencies are the APPS synonyms for HTP, OWA_UTIL, and the dynamic performance view V$NLS_PARAMETERS. HTP and OWA_UTIL supply the underlying HTML and HTTP output primitives, while V$NLS_PARAMETERS provides territory- and language-specific formatting behaviour — notably numeric and decimal separators — that the money and number formatting routines must respect.

Usage Notes

APPS.JS is invoked from PL/SQL code that produces HTML for EBS self-service and framework pages, typically inside procedures that build a page fragment before it is returned to the browser. Because the generated output is JavaScript, there is no concurrent program or form trigger that calls it directly; instead it is reached through the 39 dependent packages that generate EBS web content. Client-side validation routines such as NULL_ALERT and CHECKVALUE run in the browser after the page is rendered, complementing server-side validation. Custom code that references APPS.JS should treat it as unsupported and version-sensitive, since Oracle may change its signature or behaviour between releases without notice.