error FRM - 41039 Invalid Alert ID [message #322985] |
Tue, 27 May 2008 00:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|