Home » Developer & Programmer » Forms » error FRM - 41039 Invalid Alert ID (Win XP, 10G , 10G developer suit)
error FRM - 41039 Invalid Alert ID [message #322985] Tue, 27 May 2008 00:19 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am facing this error whenever I try to set an alert message, instead of the alert message an error (41039) shows up on the screen. Here is code

declare
	a number;
	
begin
	if error_type='FRM' and error_code=40202 then
		message('Contact person name should be entered');
		
		set_alert_property('ER2',title,'Business rule violation');
		set_alert_property('ER2',Alert_message_text,'Cannot keep it empty');
		a := show_alert('ER2');
	
	else
		message(error_text);
		
	end if;
	
	
end;


When I execute the form only the message ('Contact person name should be entered')gets displayed, instead of the alert two pop ups come on the screen both having the same message
Quote:
error frm - 41039 Invalid Alert ID 0
.

Same is the case in other PL/SQL codes I have written for other objects in the form.

Can anyone tell me why this is happening? and what I can do to rectify this?

- Das
Re: error FRM - 41039 Invalid Alert ID [message #322991 is a reply to message #322985] Tue, 27 May 2008 00:27 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
First, make sure that this (ER2) alert exists.

Then, COMPILE ALL (Ctrl + Shift + K) before running the form. See what happens.
Re: error FRM - 41039 Invalid Alert ID [message #323003 is a reply to message #322991] Tue, 27 May 2008 00:58 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Did I mention that I was new to this..I had not created those Alerts. Now that I have read about alerts things are working just fine.

Thanks a lot.

- Das
Previous Topic: ORA-23401 materialized view "string"."string" does not exist
Next Topic: Changing the display
Goto Forum:
  


Current Time: Sun Feb 09 23:17:00 CST 2025