Forms 5.0 - Script to insert, delete, update & Lock a records using procedure.
Date: Thu, 12 Aug 1999 11:29:51 +0530
From: "Orafin" orafin@sohm.soft.net
Subject: Related to Forms 5.0 feature
In forms 5.0 we can construct a block based on stored procedures.
In Dev.2000 forms 5.0 Help example,
script is available for creation of
1) Package Specification
2) In Package body,
script is available only for querying the records,(using REF CURSOR)
can anyone give script to insert, delete, update & Lock a records using
procedure.
Thanks in advance
regards
Orafin.
Host command in Forms 4.5 on NCA not working AND problem in getting totals of a block in a Form
Date: Thu, 12 Aug 1999 11:37:22 -0700
From: Janet Elmore elmore1@llnl.gov
Subject: Forms 4.5
We are in the mist of converting from 10.7 character to 10.7NCA. We have
several custom forms we are rewriting from 2.3 to 4.5.
We have run into two problems I am hoping someone can shed light onto.
1. Three of our custom forms in 2.3 used the host command without any
problems. We read the manual and doubled checked our syntext, but the host
command in our 4.5 forms on NCA just wont work. The form gets to the
trigger as we can display a message before and after the host command and
it will appear. Can anyone help with this?
2. One of our developers is creating a form where on the block the user is
creating many new records to be inserting into a table. Each record has an
amount of hours. When the person commits it should give an error if the
total of hours for all records does not equal 0. Then the user will change
the record he needs to and commit again. Again it should error if the
total of hours of all the records still does not equal 0. The developer
stated there doesn't appear to be a way to sum all the hours for all the
records on the block. Whenever he sums it returns just the sum of one
record. He tried having a non-base table item so he can add the hours as
the user enters new records which works unless he user gets the error.
Then when the user clicks on a record and changes it his total isn't always
correct. He is still working on this problem. If there is a way to do
this that perhaps we haven't thought of, we would appreciate any ideas.
Thanks,
Janet Elmore
Lawrence Livermore Nat'l Lab
elmore1@llnl.gov
(925)423-9195
Date: Thu, 12 Aug 1999 11:57:02 PDT
From: "Ronald Young" ronaldyoung@hotmail.com
Subject: Re: Forms 4.5
For no 2, can't you just POST and then select the sum of the hours from the
database table? Does anyone else agree or disagree with this?
Date: Thu, 12 Aug 1999 15:07:12 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Forms 4.5
I think Record Groups will solve this problem ( no. 2 )
-chakrapani
Date: Thu, 12 Aug 1999 15:15:30 -0400
From: "Salunke, Pradyot " Pradyot_Salunke@csx.com
Subject: RE: Forms 4.5
For second problem
1) Create one control item say sum_records
2) Create one button, check sum
3) Write when button pressed trigger on that button.
Text
:control_block_name..sum_records := 0;
fnd_message.set_string('Calculation may take some time depending on the no.
of records, Press Ctl C to cancel during the calculation');
fnd_message.show;
APP_RECORD.FOR_ALL_RECORDS('block name where you enter amount of hours',
'FIND_TOTAL_SUM_RECORDS');
-- fnd_message.set_string('Completed the Calculation');
-- fnd_message.show;
If :control_block_name..sum_records != 0 then
fnd_message.set_string('Error Sum is not zero');
go_block('*****');
raise form_trigger_failure ;
end if;
Here find_total_sum_records is a user defined block level trigger on block
where you enter amount of hours
And text is
:control_block_name..sum_records := :control_block_name..sum_records +
:block_name.column_name_of_the_total_hours ;
Now before commiting, if user presses this button, then this thing will work
but if user directly presses commit (save) button. For that you have to
handle this situation in On-commit(form level) trigger.
Pradyot
Date: Thu, 12 Aug 1999 15:27:22 EDT
From: Gautham1@aol.com
Subject: Re: Forms 4.5
There are talking about new records and no the one which are already in the
DB.
The best approch is to use the record group.
Date: Thu, 12 Aug 1999 12:51:24 -0700
From: Janet Elmore elmore1@llnl.gov
Subject: Re: Forms 4.5
Ronald,
The problem with this is we don't want to commit to the table unless the
sum of the hours on the records we are inserting = 0. If we commit first
and then sum it's too late.
Hope this explains my problem better.
Janet....
Date: Thu, 12 Aug 1999 16:18:56 EDT
From: Gautham1@aol.com
Subject: Re: Forms 4.5
That the reason, I have asked to use the record group, with which u could do
the processing in the client side and then post it to the db.
Date: Fri, 13 Aug 1999 19:08:47 +1000
From: "Mckenzie, Rosemary" ROSEMARY.MCKENZIE@cai.com
Subject: RE: Forms 4.5
#2 One of the Oracle Purchasing forms - v4.5 (Enter Purchase Orders POXPOPOE
or Enter Receipts RCVRCERL I'm not on site at the moment) uses the running
total approach with procedures called in the on validate trigger for the
field and the on-delete, clear, etc for the record. I think the procedures
are in the appcore.pll? for financials. You pass it a source_field,
total_field and event and it work's out the running total. All you'll need
to do then is check the total is zero before committing. (I can give you
more information Monday if you need it.)
Date: Fri, 13 Aug 1999 09:16:21 -0700
From: Janet Elmore elmore1@llnl.gov
Subject: RE: Forms 4.5
Thank you to all who have responded to our problem on
forms 4.5.
Problem 1 ended up being a permission problem on the forms server that our
DBA found and fixed.
Problem 2 we got several great ideas and the developer is pursuing them to
decide the method that will work best in our case.
Thanks again for all your help.
Janet....
Custom Form Function does not work
Date: Thu, 12 Aug 1999 13:34:17 -0700 (PDT)
From: impact impact impact599@yahoo.com
Subject: Custom Manufacturing Application
Hi!!!
We are working on Oracle Manufacturing in our company and we have
registered a Custom Manufacturing Application for all the
customizations. I have created one custom form and registerd it in
Applications. After creating a form function and attaching it to a
responsibility, we get it in our custom Menu. But when we click on the
menu option ABSOLUTELY NOTHING happens. The form is not called from the
BASEPATH/forms/US , where we have put it. We have checked all the
permissions on the directory and fmx file also. And amazingly, no error
message also comes on the Toolbar. Please suggest ASAP what can be
wrong?
We are on Oracle Applications Release 11, Oracle 8.0.5 and Sun Solaris
2.6.
Thanks in advance.
Alok Shivpuri.
e-mail :- ashivpuri@chipshot.com
Date: Fri, 20 Aug 1999 18:05:12 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Custom Manufacturing Application
CHECK FOLLOWING
CUSTOM APPLICATION IS REGISTERED
FORM FUNCTION WHERE NEW FORMS ARE ADDED
IN MENU, UR NEW FUNCTION IS ADDED
CHECK U CREATED TOP_MENU
CHECK TOP_MENU IS ATTACHED TO RESPONSIBILITY
RAJ
Data invalid for Heirarchy tree
Date: Thu, 12 Aug 1999 14:13:09 -0700 (PDT)
From: Mohan muthan mmuthan@yahoo.com
Subject: Data Invalid for the Tree
I am trying to populate a Hierarchy tree In Developer2000 version 6.0
with the help of a Recordgroup. The record group contains two columns
with two rows in it. I get the error message saying "INVALID DATA for
the Field". Am I missing something..
Thanks In Advance..
Regards
MOhan
How to ensure contents of a field of a Form gets highlighted on entry of cursor
Date: Fri, 13 Aug 1999 15:06:00 -0500
From: "Gregg Ney (s)" gney@cap.org
Subject: GEN: Default forms behavior in NCA
Does anyone know of a configuration setting (not a forms modification) that
will cause NCA 10.7 (NT workstations, appletviewer) to select the contents
of a field when the cursor enters that field on a form? This was the
behavior in SC, but in NCA we get a flashing cursor only, and the text in
the field is not selected (highlighted). You can't just begin typing and
obliterate the previous contents.
Thanks in advance
Gregg Ney
Project Manager, Oracle Applications
College of American Pathologists
847/832-7276 gney@cap.org
Conversion of Forms 2.3 to 4.5
Date: Mon, 16 Aug 1999 09:30:52 PDT
From: "prince suthakar" prince_sutha@hotmail.com
Subject: Re: Forms 4.5
Hello,
How to convert 2.3 form to 4.5. Could you please give some idea. My client
going to upgrade thier application .
TIA
Query problems in Custom Forms 4.5
Date: Tue, 17 Aug 1999 10:01:53 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: Forms4.5
Hi All,
I am trying to build a custom form using template.fmb. when I query the form
I am having the following problems:
1. when I do a requery it is asking me to save the changes. I did not do any
changes.
2.when I do a enter query and enter a criteria it is getting all the
records.
how can I make this work. Any ideas.....
TIA
-Harish
Date: Tue, 17 Aug 1999 16:28:47 +0100
From: rchalton@dunnes-stores.ie
To: oraapps-l@cpa.qc.ca
Subject: Re: Forms4.5
1. If you populate any other fields, by way of a post-query trigger for
example, you will need to do something like:
SET_RECORD_PROPERTY(GET_BLOCK_PROPERTY('B1',CURRENT_RECORD),'B1',STATUS,QUERY_STATUS);
where B1 is your block name.
2. Is the field you are entering criteria into a base table field - if not
you may need to do some PRE-QUERY triggering!
Rob
Date: Tue, 17 Aug 1999 11:01:07 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: RE: Forms4.5
Rob,
yes, it worked.. Thanks again for the help..
-Harish
How to call Demand Interface Manager from a customer form (GUI)
Date: Tue, 17 Aug 1999 13:25:02 -0400
From: "Maran, Ramanathan (Ramanathan)** CTR **" rammayan@lucent.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Calling Demand Interface Manager -Online
Hi All,
Could anyone tell me how to call Demand interface manager from custom
form (GUI) online to process demand/Reservation function from
mtl_demand_interface table.
Thanks in Advance
Maran
LOV for Date item in Forms 5
Date: Wed, 18 Aug 1999 07:04:02 -0700 (PDT)
From: =?iso-8859-1?q?washesh=20mehra?= washesh@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: LOV for Date Item in Forms 5.0
Hi All,
Has anyone tried to create an LOV for a Date item in Forms 4.5/5.0.?
What are the libraries to be attached for that?
Many Thanx
Washesh
Date: Wed, 18 Aug 1999 16:59:25 +0200
From: "Blaise Rempteaux" brempteaux@auchan.com
To: oraapps-l@cpa.qc.ca
Subject: RE: LOV for Date Item in Forms 5.0
When the user invokes List on Date or Datetime field, the form opens the
Calendar windows.
In forms Designor, when you create your field, the field should use the LOV
'ENABLE_LIST_LAMP' which is included in the TEMPLATE form. Set 'Use LOV for
Validation' to FALSE.
In the trigger Key_LISTVAL of the field, you have the following code
Calendar.show;
Blaise.
Stacked Canvas Form - change and save in individual canvases errors
Date: Wed, 18 Aug 1999 08:43:08 -0700
From: Jason Scherer x139 JasonScherer@trm.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Forms 4.5 Question
Here is a forms question for all the forms gurus. One of the developers
here developed a custom form using the template.fmb and is getting a funny
error. Has anyone ever seen this problem? Here is his problem:
The form in question is being called from a WHEN-BUTTON-PRESSED
trigger in a customized version of CSXCTMCO (Contract screen) . The only
customization in CSXCTMCO is the additon of the button and trigger to call
the form with the error . The form with error is being called with
"FND_FUNCTION.EXECUTE('FORM_NAME' , 'Y' , 'N' )" .
Form is a multiple stacked canvas form . Each of the stacked canvasses
is entry for individual views with each updating a separate table . The form
as a unit works fine if user edits any/all of the stacked canvasses and then
commits the changes . However if user edits data on one of the canvases
and saves and then proceeds to a different canvas, makes changes, and then
saves again the form displays a pop-up error of FRM-40405 ('No Changes to
Apply") . When the OK is clicked on this pop-up the save continues and the
record is properly updated . This error is displayed each time user attempts
to make any additional saves on the form . Debugs indicate the FORM_STATUS,
BLOCK_STATUS, and RECORD_STATUS at the time of the save are all set
to CHANGED .
In additon to this error there is an FRM-40401 error ("No changes to
save." )
which always occurs upon exiting the form when any save has been done . This
error does not do a pop-up but simply displays on the status line . A debug
located
in the POST-FORM trigger of this form is displayed before the FRM-40401
error
is displayed on the status line .
Jason Scherer
ECS Integrated Technology Solutions, LLC
email: jscherer@ecs-its.com
on-site email: jasonscherer@trm.com