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, 5205👍, 0💬
Popular Posts:
How To Compile a JUnit Test Class? Compiling a JUnit test class is like compiling any other Java cla...
.NET INTERVIEW QUESTIONS - What are types of compatibility in VB6? There are three possible project ...
What's the difference between J2SDK 1.5 and J2SDK 5.0? There is no difference, Sun Microsystems just...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...
What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...