Home » Developer & Programmer » Reports & Discoverer » displaying user defined error message
displaying user defined error message [message #345293] Tue, 02 September 2008 18:45 Go to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member

function AfterPForm return boolean is
begin
  if :eno1 is not null and :eno2 is not null then
  	:lpe:= ' and a.eno between :eno1 and :eno2';
  	
  elsif (:eno1 = :eno2) then
  	:lpe:=' and a.eno = '|| :eno1;
  	
  elsif :eno1 is null and :eno2 is not null then
  	 :lpe:=' and a.eno <= '||:eno2;
  	 
  elsif :eno1 is not null and :eno2 is null then
  	 :lpe:=' and a.eno >= '||:eno1;
  	 
  elsif :eno1 is null and :eno2 is null then
  	message(' enter the values propoerly');
  	raise form_trigger_failure;
  	 
  else
  	 :lpe:=null;
  	
  end if;  	
  return (TRUE);
end;



i have the above code in my after parameter form trigger
here i am validating the parameters entered, it says
"message" must be declared, and form_trigger_failure must be
declared..
Re: displaying user defined error message [message #345313 is a reply to message #345293] Tue, 02 September 2008 23:39 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
(Certain parts of) Forms PL/SQL <> Reports PL/SQL.

Research use of the SRW built-in package, especially SRW.MESSAGE and SRW.PROGRAM_ABORT).
Previous Topic: drill down reports
Next Topic: Character mode Print
Goto Forum:
  


Current Time: Wed Nov 27 00:41:29 CST 2024