The Template Form

Overview of the TEMPLATE Form

The TEMPLATE form is the required starting point for all development of new forms. Start developing each new form by copying the TEMPLATE.fmb file, located in $AU_TOP/forms/US (or your language and platform equivalent), to a local directory and renaming it as appropriate.

TEMPLATE contains the following:

Platform-independent references to object groups in the APPSTAND form (STANDARD_PC_AND_VA, STANDARD_TOOLBAR, and STANDARD_CALENDAR)

Platform-independent attachments of several libraries (including FNDSQF, APPCORE, and APPDAYPK)

Several form-level triggers with required code. See:

Program units that include a spec and a body for the package APP_CUSTOM, which contains default behavior for window opening and closing events. You usually have to modify this code for the specific form under development.

The Applications color palette, containing the two colors required by the referenced visual attributes («canvas» and «button»), «pure» colors (such as «black,» «white,» «blue,» and «red»), and various other colors named after their content of Red, Blue and Green (such as «r40g70b100»).

Many referenced objects (from the object groups) that support the Calendar, the toolbar, alternative regions, and the menu. These objects include LOVs, blocks, parameters, and property classes, and so on.

The TEMPLATE form contains sample objects that show typical items and layout cosmetics. These are provided merely as samples; to remove them entirely from your form, delete the following objects.

blocks: BLOCKNAME, DETAILBLOCK

Libraries in the TEMPLATE Form

The TEMPLATE form includes platform-independent attachments of several libraries. Some of these libraries are attached «directly» to the TEMPLATE (FNDSQF, APPCORE, and APPDAYPK), while the others are attached to these three libraries. However, in Oracle Forms, the different types of attachments are indistinguishable. If more libraries are later attached to any of these libraries, the additional libraries will also appear to be attached directly to TEMPLATE.

The following libraries are all attached to TEMPLATE. You may also see additional libraries, particularly if your site uses Oracle E-Business Suite in multiple countries or if your site uses Oracle Industry Applications.

Warning: You should not modify any Oracle E-Business Suite libraries other than the CUSTOM library, or you could seriously damage your Oracle E-Business Suite products.

APPCORE

APPCORE contains the packages and procedures that are required of all forms to support the menu, Toolbar, and other required standard behaviors. Additionally it contains packages that should be called to achieve specific runtime behaviors in accordance with the Oracle E-Business Suite User Interface Standards for Forms-Based Products, such as the way in which fields are enabled, behaviors of specific types of windows, and the dynamic ‘Special’ menu. Finally, it contains various other utilities for exception handling, message levels, and so on. Some APPCORE event routines call routines in the VERT, GLOBE, and CUSTOM libraries (in that order).

Procedures and functions in APPCORE typically have names beginning with «APP».

APPDAYPK

APPDAYPK contains the packages that control the Oracle E-Business Suite Calendar feature.

FNDSQF

FNDSQF contains packages and procedures for Message Dictionary, flexfields, profiles, and concurrent processing. It also has various other utilities for navigation, multicurrency, WHO, etc.

Procedures and functions in FNDSQF typically have names beginning with «FND».

CUSTOM

The CUSTOM library allows extension of Oracle E-Business Suite forms without modification of Oracle E-Business Suite code. You can use the CUSTOM library for customizations such as Zoom (such as moving to another form and querying up specific records), enforcing business rules (for example, vendor name must be in uppercase letters), and disabling fields that do not apply for your site.

You write code in the CUSTOM library, within the procedure shells that are provided. All logic must branch based on the form and block for which you want it to run. Oracle E-Business Suite sends events to the CUSTOM library. Your custom code can take effect based on these events.

GLOBE

The GLOBE library allows Oracle E-Business Suite developers to incorporate global or regional features into Oracle E-Business Suite forms without modification of the base Oracle E-Business Suite form. Oracle E-Business Suite sends events to the GLOBE library. Regional code can take effect based on these events. The GLOBE library calls routines in the JA, JE, and JL libraries.

The VERT library allows Oracle E-Business Suite developers to incorporate vertical industry features (for automotive, consumer packaged goods, energy, and other industries) into Oracle E-Business Suite forms without modification of the base Oracle E-Business Suite form. Oracle E-Business Suite sends events to the VERT library. Vertical industry code can take effect based on these events. The VERT library calls routines in various other libraries.

The JA library contains code specific to the Asia/Pacific region and is called by the GLOBE library.

The JE library contains code specific to the EMEA (Europe/Middle East/Africa) region and is called by the GLOBE library.

The JL library contains code specific to the Latin America region and is called by the GLOBE library.

Special Triggers in the TEMPLATE form

The TEMPLATE form contains several form-level triggers that must exist in order for other routines to operate properly. Specific rules about modifications you can safely make to these triggers are discussed below.

Important: Under no circumstances may any of these triggers be deleted.

The text within these triggers must remain within the trigger; however, frequently developers need to add text before or after this text. These triggers are listed below.

Warning: You must not change triggers that are referenced into the form, even though it is technically possible in Oracle Forms Developer. Changing referenced triggers may cause problems in your form or may cause problems for future upgrades.

How To Close Window In Oracle Forms 6i

code for «when button pressed» trigger that will close the current window and displays another window.

Similar Messages:

Forms :: Close A Window In Query Mode

How do I close a window in query mode?My form has a button «Populate from Charge Master» which opens a window containing a List Item (Department Names) and 2 buttons,

1. «Select the Dept» and
2. «Cancel»

The WHEN-BUTTON-PRESSED trigger code for «Populate from Charge Master» button is as follows:

Code for «Select» button in the window is:

Code for «Cancel» button in the window is:

Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when «Cancel» button is pressed.

When I remove «enter_query» statement in «populate from charge master» trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.

Forms :: Close Java Applet WebStart Window

I am Trying to use jnlp file to launch my form application and it looks good, all works fine , except one thing

1) When i close form application, the webstart applet window doesn’t close.

Reports & Discoverer :: How To Close Window Automatically Without Manual Intervention

I am running a report which is called for a set of employees picked up in the cursor. For each employee the report is run in a different window. However, the report runs fine and the output gets saved in the local machine but the window doesn’t get closed automatically.

How to close the reports window automatically without manual intervention?

Forms :: Open Dialog Window Using Oracle 10g

i want to open dialog window using oracle forms 10g on button click event.

Forms :: How To Hide Oracle In-built Message Which Appears At Bottom Of Window

How to hide oracle in-built message which appears at the bottom of the window(just above the task-bar) to the left side.

Forms :: DDE Package — How To Close Excel File Without Saving Changes / Messages

I need to rescue some valors from Excel, and then close the excel file without saving changes and without messages.

I am using THe DDE package and when using

DDE.EXECUTE(convid, ‘[Save()]’, 10000);

there is no problem, but the changes are saved. I have tried ‘[Exit()]’ and ‘[Close()]’ but always have error message ORA-106555. Is there any way of doing this without errors?

Forms :: Windows Close / Click On Save Button Data Get Saved

i design one master detail block and one command button for saving the data. as i click on save button data get saved and after that if i want to close form then at this time it again asking me for save changes window..

Forms :: Opening Form Has Attached Libraries Caused Form Close

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

Forms :: How To Get Window Handle

The following code works fine in the form 6i, but in the same form 10g I get map_handle=’0′ and win_handle=’0′ instead of certain value as in 6i.

MAP.MAP_ITEM has Chart Item type.

Forms :: Call Another Canvas In Same Window?

I want to call another canvas in same window.using this code /it not work show_view(‘canvasname’);

Forms :: New Window Opened As Deactivated

i want to open a new window from my form. everything going well but when a new window opened. the control remains on previous form. and the new window is also inactive. i tried go_item with the item belongs to the new canvas but in vain.

Forms :: Icon In Window Title Bar?

I am using Developer 6i and i want to know how to replace the default icon in form window title bar with company’s logo.

Forms :: Hiding Window Failing On 6i

I have to create a new window in a newly developed forms 6i (in Oracle e Business Suite 11i).

This new window is to duplicate the Oracle standard alert systems. I have to create a new one to match the style classes of the other windows in the developed forms. Actually, I did not manage to change the oracle alert I used first, to match fonts, colour and sizes defined in the customised class. Thus, I decided to create a new window and canvas.

It has to display a confirmation message with 2 buttons: OK, Cancel. This window contains a canvas displaying a confirmation message, and 2 buttons : Ok, Cancel attached to my data-block. I manage to show this window, with a show_window command, called from a button on the previous window’s canvas.

I do not manage to hide this new window, and to come back to the previous one, when I click on Cancel button. The window does not hide.

Forms :: Command To Maximize The Window

Some of the items are not getting displayed properly in my form when i run.I want all of them to appear on form. Can i maximize when i open.If so whats the command.

Forms :: Tap And Toolbar Canvas In Same Window

I use forms10g in windows xp, i create a tap and toolbar canvases in content canvas but at runtime i can see only toolbar canvas.

Forms :: Set Size Of Window In Browser?

how i can set the size of runtime window in My browser? I have a larg form ( 800 X 600 )

Forms :: Get Conditional Window Appear In Form

I want to achieve functionality like below:

Let’s say there are two almost identical window and some specific functions associated: W1 and W2.

Depending upon the login profile into the application only one window and associated functions will be appeared. This time the other window will be disabled.

Forms :: Take Pic From Cam Window And Save It To Field In Database

I have a requirement to take pic from a cam window and save it to forms field in database.

Forms :: Maximize Window On Secondary Screen

I’ve already check on internet and the forum if there is a way to maximize a window on the secondary monitor instead of the main one. There is a parameter to make that? or Oracle forms maximize the windows only on the main screen?

Forms :: Navigation Triggers In WHEN-WINDOW-ACTIVATED?

A requisition application shows the latest requisition details in the homepage and allow the users to go particular requisitions (extract) details from a button (CALL_FORM), also they can modify the records in that form.

I want to give an EXECUTE_QUERY (WHEN-WINDOW-ACTIVATED) when im returning to the home page and the cursor should return to the last row where i was.

do this from navigation triggers (with out writing a select statement in when-window-activated).

Oracle 10g Instant Client For Window 7

There are three versions of Oracle 10g instant client (10.2.0.2, 10.2.0.3 and 10.2.0.5) on Oracle website. which one works with Window 7? Where I can find the documentation from Oracle website?

Oracle 10g On Window 7 — Cannot Access EM By Using Command

I installed oracle 10g version 10.2.0.1.0 on window 7 sqlplus is working but when i try to access oracle EM by using command «emctl start dbconsole» it give error

«OC4J Configuration issue. E:\oracle\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_Console_192.168.1.3_orcl not found».

although i have assigned ip address as well .

Forms :: Canvas And Editor Window Sizes Designer?

is there a way to set the default sizes for the canvas, object navigator and properties window in forms designer so that they don’t maximise when opening them. i tried to set them in the caupref and cagpref files to no avail.

Forms :: How To Have Standard Size For Canvas Or Window Of Form

Is it possible to have a standard size for canvas or window of the form? like different users are having different screen resolutions and may have different screen sizes which cause forms not to come proper on the user screen. Is there some solution to avoid the user’s resolution and should work on some standard measurements?

Forms :: How To Create A Browse For File To Upload Window

I have a major issue because I have to finish this project by tomorrow and I don’t know how I could create a button on a form that will pop a window where the user can browse his system for and Image, select it and upload it on the Database.

The idea is that I have this table called APPLICANTS with columns like:

I have created a registration form for the applicant inorder to register to the system but I just can’t figure out how to upload a photo of the applicant.

Forms :: How To Set Window Size Which Should Be Compatible For Any Screen Resolution

Actually i am migrating forms from 6i to 10g Here i need to set the window which should be fit in the browser(internet explorer) resolution and it should be compatible for any resolution?

i have tried by changing width and height in formsweb.cfg file but it is not compatible for different resolutions.

Client Tools :: Installation Of Oracle 10g At Window 7 64 Bit?

can we install oracle 10g,developer 2000 at window7 64 bit

Forms :: Modify Existing Form — Resize Canvas And Window?

I need to modify an existing form, thus I have to resize a canvas and a window for it. In windows, I run it and I got the right display. When I transfer it to dev server running in linux, then I compile and run it, it display the previous/unmodified size. I’m sure my form is the one that running, I placed some text there and it was displayed.

Forms :: Calling URL From Modal Window Lock Form Until Return?

We are in the need of calling Mapping Software from with in Forms, most likely Google Maps, and keep the form locked until selections are made. The attempt was to call the URL from a Modal Window that would in turn lock the form until return.