Home » Applications » Oracle Fusion Apps & E-Business Suite » Error when closing form (FRM-40110 At first block problem )
Error when closing form (FRM-40110 At first block problem ) [message #287686] Thu, 13 December 2007 03:15 Go to next message
amjathkhan.subhankhan
Messages: 9
Registered: December 2007
Location: chennai
Junior Member
I had a customized form embedded in the Oracle Apps 11i. My problem is that everytime I close the form by click the 'X' in the upper right, it wont close the form and prompt message 'FRM-40110 At first block.' in status bar.

Although I can close the form using the File=>Close Form or pressing F4.

Triggers and code
when-window-closed: app_standard.event('WHEN-WINDOW-CLOSED');

close-this-window:
declare
canvas_nm varchar2(30);
win_nm varchar2(30);
begin
canvas_nm := get_item_property(:SYSTEM.CURSOR_ITEM, ITEM_CANVAS);
win_nm := get_view_property(canvas_nm, WINDOW_NAME);
app_custom.close_window(win_nm);
end;

Hoping for you help on this.

Thanks
amjadkhan

[Updated on: Thu, 13 December 2007 03:16]

Report message to a moderator

Re: Error when closing form (FRM-40110 At first block problem ) [message #287697 is a reply to message #287686] Thu, 13 December 2007 03:37 Go to previous messageGo to next message
Littlefoot
Messages: 19609
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know anything about Oracle Apps., but - do you need to code this event? Why wouldn't you just "exit the form"? Does it have to be the WHEN-WINDOW-CLOSED? Why not KEY-EXIT?
Re: Error when closing form (FRM-40110 At first block problem ) [message #389252 is a reply to message #287686] Fri, 27 February 2009 15:51 Go to previous messageGo to next message
okmman
Messages: 1
Registered: February 2009
Location: Chile
Junior Member

AT Form Level Update the On-ERROR Trigger
DECLARE
errcode NUMBER := ERROR_CODE;
begin
--original code
APP_STANDARD.EVENT('ON-ERROR');

--Add this Code
IF errcode = 40110 THEN
null;
end if;
end;
Razz

[Updated on: Fri, 27 February 2009 15:54]

Report message to a moderator

Re: Error when closing form (FRM-40110 At first block problem ) [message #402615 is a reply to message #287686] Mon, 11 May 2009 11:57 Go to previous messageGo to next message
bhargavi_reddy
Messages: 1
Registered: May 2009
Junior Member
You need to replace the current Window name in APP_CUSTOM package body in your form program unit in "when window closed" condition


Re: Error when closing form (FRM-40110 At first block problem ) [message #402617 is a reply to message #402615] Mon, 11 May 2009 12:09 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi,
The problem is partially fixed after applying Patch 6667031 which delivers IGIPDETU.fmb 115.75.
After applying this patch, there is only one extra message displayed on quitting the form.
This extra message will be fixed under the enhancement request 6680293

Please refer Doc ID: 467623.1 for more details in metalink
Re: Error when closing form (FRM-40110 At first block problem ) [message #433659 is a reply to message #287686] Thu, 03 December 2009 09:24 Go to previous messageGo to next message
asmani
Messages: 47
Registered: February 2007
Member
Hi there

I had this same problem and sorted by using on WHEN-WINDOW-CLOSED tigger


exit_form;



Thank you...
Re: Error when closing form (FRM-40110 At first block problem ) [message #564488 is a reply to message #402615] Fri, 24 August 2012 05:19 Go to previous message
manaswinig
Messages: 4
Registered: May 2008
Junior Member
You need to replace the current Window name in APP_CUSTOM package body in your form program unit in "when window closed" condition

the above worked for me
Previous Topic: Approved Supplier List
Next Topic: Automatic offset method
Goto Forum:
  


Current Time: Thu Sep 18 01:39:40 CDT 2014

Total time taken to generate the page: 0.06315 seconds