OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Error when closing form (FRM-40110 At first block problem )

Home » Applications » Oracle Fusion Apps & E-Business Suite » Error when closing form (FRM-40110 At first block problem )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error when closing form (FRM-40110 At first block problem ) [message #287686]

Thu, 13 December 2007 03:15

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

Littlefoot
Messages: 21823
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?

Report message to a moderator

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

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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...

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Approved Supplier List
Next Topic:	Automatic offset method

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 18:05:19 CST 2024