Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How does one suppress or customize error messages in Forms?
How does one suppress or customize error messages in Forms?
✍: Guest
One can either set the message level using the system variable SYSTEM.MESSAGE_LEVEL or trap errors using the ON-ERROR or ON-MESSAGE triggers.
MESSAGE_LEVEL:
Set to 0, 5, 10, 15, 20, 25 to suppress all messages with severity below this level. The default level is 0. Messages with a level higher than 25 cannot be suppressed. See the "Forms Error Messages Manual" for more details about the various MESSAGE_LEVEL's:
* 0 - Default value. All types of messages from the other levels of severity.
* 5 - Reaffirms an obvious condition.
* 10 - Indicates that the operator has made a procedural mistake.
* 15 - Declares that the operator is attempting to perform a function for which the form is not designed.
* 20 - Indicates a condition where the operator cannot continue an intended action due to a problem with a trigger or another outstanding condition.
* 25 - Indicates a condition that could result in the form performing incorrectly.
* >25 - Indicates a message severity level that you cannot suppress via the SYSTEM.MESSAGE_LEVEL system variable.
Examples:
:SYSTEM.MESSAGE_LEVEL := '25';
COMMIT;
:SYSTEM.MESSAGE_LEVEL := '0';
/* For suppressing FRM-40100: At first record. */
:SYSTEM.MESSAGE_LEVEL := '5';
FIRST_RECORD;
:SYSTEM.MESSAGE_LEVEL := '0';
/* For suppressing FRM-40350: Query caused no records to be retrieved. */
:SYSTEM.MESSAGE_LEVEL := '5';
EXECUTE_QUERY;
:SYSTEM.MESSAGE_LEVEL := '0';
2011-04-05, 5140👍, 0💬
Popular Posts:
From performance point of view how do they rate ? Repeater is fastest followed by Datalist and final...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
What will be printed as the result of the operation below: #define swap(a,b) a=a+b;b=a-b;a=a-b; void...
What's the difference between J2SDK 1.5 and J2SDK 5.0? There is no difference, Sun Microsystems just...
Can you explain the fundamentals of “GetGlobalResourceObject ”and “GetLocalResourceObject” function...