Thursday, December 16, 2010
FORMS Questions and Answers: PART5 (51-60)
51. When a form is run, which are the triggers fire, and in what sequence they fire?
52. What is the utility used to call the report from the forms?
53. What is a Property Class? Different methods of creating property class?
Ans: Property Class is defining properties of objects along with their settings. The property class inheritance allows the user to perform global changes very quickly and efficiently.
Object Navigator Method
Properties Window Method
54. WHEN-NEW-FORM trigger written at Form Level, Block Level and Item Level
which one will fire first?
Ans: The trigger written at the lower level Item Level Fires first.
55. In the previous question circumstance, is it possible to change the order of trigger Execution? If Yes, where it needs to be changed?
Ans: Yes, in the trigger property (Before, After, Default)by changing the attributes.
56. Form Registration Steps
Ans: Save as the TEMPLATE.fmb as your continent form name such as emp.fmb
Delete the BLOCK_NAME, DATA_BLOCK, BLOCK_NAME and BLOCK_NAME in Data Block, Canvas and Window list.
Create window, canvas and block in the module and assign the subclass information to properties of them.
Change the code in the package of app_custom in the program units.
if (wnd = 'window_name') then
if (wnd = 'window_name') then
Change the code in the pre_form trigger as bellow
Copy the fmb and pll file into AU_TOP/forms/US and AU_TOP/resource directories respectively and compile them.
f60gen F20601.fmb Userid=apps/g00g1e
mv F20601.fmx /apps/qoedv2/appl_top/xxcpd/11.5.0/forms/US
f60gen Module=XXCPDLXPLAVA.pll Module_Type=LIBRARY Userid=apps/g00g1e
In front-end application, go to the following path
Application DeveloperàApplicationàform and create one new record
Application DeveloperàApplicationàFunction create one function and link the form to this function.
Application DeveloperàApplicationàMenu and create the menu and link the function to this menu.
57. Create the messages in Apps.
Ans: Go to Application DeveloperàApplicationàmessage and create one message in the form and run request.
Go to Viewàrequests, select submit new request
Select the ‘Generate Message’ program and give input parameters for this form.
You can access this messages in the form level code as below.
2. Fnd_message.set_name(‘Application_id’, ‘Message_Name’)
Fnd_message.set_token(‘Token_varialbe in the message Dictionary’, Value)
58. PRE– FORM
59. To Code the Zooms into Custom.pll
Open the $AU_TOP/RES/PLSQL/CUSTOM.PLL
Code the custom function Zoom_available this function return Boolean we check here the form name and block name and return true.
And then code the event procedure here we check for event if it is ZOOM then we check for the form and the block name and using FND_FUNCTION.EXECUTE open the new form fnd_function.execute takes 4 parameters
60. Find Window
Copy the query_find object from appsstand.fmb
New Button: When-Button-Pressed write this code :- app_find.new(‘Resultant Block’);
Find button: When-button-Pressed write this code :- apps_find.new(‘Resultant Block’);
2) Pre-Query trgger at resultant block execution style before
if :parameter.g_query_find =’TRUE’ Then
Source , destination
3) Create user defined trigger QUERY_FIND BLOCK level (override)
App_find.query_find(Resultant window , find window , find block);
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.