Page 1 of 1
FRM-404000 trahsaction complete 1 record applied a
Posted: Fri Jun 16, 2006 4:39 am
by 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
Posted: Fri Jun 16, 2006 5:21 am
by admin
Is this issue different than the following already discussed one,
topic.asp?TOPIC_ID=143
Posted: Fri Jun 16, 2006 8:23 am
by 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
Posted: Fri Jun 16, 2006 8:31 am
by 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
Posted: Fri Jun 16, 2006 9:38 am
by 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.
Posted: Fri Jun 16, 2006 10:25 am
by 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
Posted: Sat Jun 17, 2006 1:43 am
by admin
Only wanted to provide info about different levels.