Home » Developer & Programmer » Forms » Not getting the FRM- 40200 Message
Not getting the FRM- 40200 Message [message #247609] Tue, 26 June 2007 08:59 Go to next message
rajiv.datta
Messages: 21
Registered: June 2007
Location: London
Junior Member

Hi,

I am facing a typical problem with my form.

Problem goes as follows
I have a form with multi tab functionality, in that some of the text fields UPDATE property is set to NO.

But when i deploy the form and access it through the application the text field works perfectly i.e. it doesn’t allow me to update the field. But the problem is it doesn’t show me the default message that “FRM- 40200 Field is protected against update" that gets displayed in the STATUS BAR of the form.
I even tried by setting the Message level to 0 but it didn’t help me.
Can anyone pls help me this.

Rajiv Datta

[Updated on: Tue, 26 June 2007 09:00]

Report message to a moderator

Re: Not getting the FRM- 40200 Message [message #249272 is a reply to message #247609] Tue, 03 July 2007 20:34 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

What message you're getting if you press backspace?
Re: Not getting the FRM- 40200 Message [message #251803 is a reply to message #247609] Mon, 16 July 2007 13:02 Go to previous messageGo to next message
trevisolli
Messages: 2
Registered: June 2007
Location: Brazil
Junior Member

Rajiv,

Try this code (ON-ERROR trigger):

/*  

** Built-in:  ERROR_CODE,ERROR_TEXT,ERROR_TYPE 
** Example:   Reword certain FRM error messages by checking 
**            the Error_Code in an ON-ERROR trigger 
** Trigger:   On-Error 
*/ 
DECLARE 
  errnum NUMBER       := ERROR_CODE; 
  errtxt VARCHAR2(80) := ERROR_TEXT; 
  errtyp VARCHAR2(3)  := ERROR_TYPE; 
BEGIN 
  IF errnum = 40301 THEN 
    Message('Your search criteria identified no matches... 
              Try Again.'); 
  ELSIF errnum = 40350 THEN 
    Message('Your selection does not correspond to an employee.'); 
  ELSE 
    /* 
    ** Print the Normal Message that would have appeared 
    ** 
    ** Default Error Message Text Goes Here 
    */ 
    Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt); 
    RAISE Form_Trigger_Failure; 
  END IF; 
END; 
 

Regards,

Trevisolli

[Updated on: Mon, 16 July 2007 13:03]

Report message to a moderator

Re: Not getting the FRM- 40200 Message [message #301859 is a reply to message #247609] Fri, 22 February 2008 00:42 Go to previous message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Thank sir,

This query is most useful to me to solve the problem.
Previous Topic: Change a display item at run time
Next Topic: Validation(Duplicate checking)
Goto Forum:
  


Current Time: Sat Dec 03 00:57:16 CST 2016

Total time taken to generate the page: 0.08484 seconds