FRM-404000 trahsaction complete 1 record applied a

[mfa786]

hi master
sir when i commit my form then system give me this message

my code
commit_FORM;
GO_BLOCK('spereport');
EXECUTE_QUERY;

error or message
FRM-404000 trahsaction complete 1 record applied a

how i avoid this message
thank
aamir

[admin]

Is this issue different than the following already discussed one,

topic.asp?TOPIC_ID=143

[Kashif]

The solution u given in that post will not show any Other Message also, which will generate in that form on any other operation.

So there should be any different Solution for this Issue.

Best Regards.

Muhammad Kashif

[Kashif]

error or message
FRM-404000 trahsaction complete 1 record applied a

how i avoid this message

Write the following Code in ON-Message Trigger.
Inshallah it will Solve the Problem

you can Show your Own Message Here instead of Changing Message Level

Code: Select all

Begin
    if message_type = 'FRM' and message_code =40400 then
          :System.Message_Level := 25;
    end if;
End;

Best Regards.

Muhammad Kashif

[admin]

SYSTEM.MESSAGE_LEVEL stores one of the following message severity levels: 0, 5, 10, 15, 20, or 25. The default value is 0.
SYSTEM.MESSAGE_LEVEL can be set to either a character string or a number. The values assigned can be any value between 0 and 25, but values lower than 0 or higher than 25 will generate an error.
During a Runform session, Form Builder suppresses all messages with a severity level that is the same or lower (less severe) than the indicated severity level.

Assign a value to the SYSTEM.MESSAGE_LEVEL system variable with standard PL/SQL syntax:

:System.Message_Level := value;

The legal values for SYSTEM.MESSAGE_LEVEL are 0, 5, 10, 15, 20,and 25. Form Builder does not suppress prompts or vital error messages, no matter what severity level you select.

[Kashif]

[quote]
The legal values for SYSTEM.MESSAGE_LEVEL are 0, 5, 10, 15, 20,and 25. Form Builder does not suppress prompts or vital error messages, no matter what severity level you select.

<i><div align="right">Originally posted by admin

[admin]

Only wanted to provide info about different levels.