Display message with confirmation buttons in oracle forms

I'm using form customization in oracle R12 and i developed forms in template fmb . i need to show confirmation messages for button click event. when i click the button then want to show message box with two buttons (Ex: OK and Cancel) then when i click OK then transaction must be done when I click the Cancel then cancel the transaction. is there any way for prompt message with confirmation button in template fmb.

Thanks
Macks.

Edited by: Macks on Oct 29, 2011 5:56 PM

how to display message from package to forms

I have written package in back end.i am calling teh package from form, i ahev done some complex calculations.i want to see the intermedite values from form.how can i do this.any help will be appreciated ...

How do I display an informative message to the user on Oracle Forms?

I have been asked to create a database trigger to fire when a user tries to update a column with existing data in it. If the column however has no data in it then the user can update the column with a value.I tried using the RAISE_APPLICATION_ERROR technique but somehow no message shows up on the fr ...

Oracle How to display a confirmation message before deletion

I have an application and I want to display a confirmation message before people delete a record. The button on page 42 is number 90 "Supprimer cette fiche". It is a Submit as "DELETE_ALL". I have seen that the delete buttons are redirections to the url javascript:confirmDelete(htmldb_delete_message ...

jQuery How to display a Dialog Box (with confirmation buttons) when external link is clicked

jQuery Newbie question.I work for a state government and need to display a message lettingthe user know a link is to an external site. In the past I haveobviously used a javascript alert() but would rather use somethingnicer which could hopefully allow the use of a background image andreadable text. ...

jQuery How to display a Dialog Box (with confirmation buttons) when external link is clicked

jQuery Newbie question.I work for a state government and need to display a message lettingthe user know a link is to an external site.  In the past I haveobviously used a javascript alert() but would rather use somethingnicer which could hopefully allow the use of a background image andreadable ...

Oracle Forms Error Message

I am using Forms 9i Version 9.0.2.9.0 and Database Oracle 9i Enterprise Edition Release 9.0.1.1.1.Database and Developer are in the same computer (Windows XP Professional). Folders are ora90 and 9iDSHome respectively. OC4J is running properly. My problems are:1)After building a form, when I am runni ...

Oracle PO Inbound ACKPO XML Message Confirmation

Can we get any documentation on the seeded workflow mentioned in the subject. Its internal name is PO_ACKPO.I tried to search for it on Metalink, OTN...everywhere...but couldn't find it. ...

Oracle Forms 6i Buttons

I'm a bit newbie in Oracle and i'm wonderingif there is a way to change the visual propertiesof a button to, for example, a flat button?i searched in properties but i canĀ“t find itand if i add visual properties they only focus on the text.Thnks in advance.Paul ...

Iconic buttons in Oracle Forms

My requirement is to create iconic buttons in oracle forms. I want the procedure. ...

Oracle Any Other ways to display Message

Is there any other way (other than dbms_output.put_line) to display message to the user/developer?Since dbms_output.put_line gives message at the end of the script execution from the buffer, I would like to know any other way to display the message in PL/SQL as soon as the program executes that stat ...

Oracle Forms Wizard does not display Japanese correctly in UTF-8...

For some reason, when I set my NLS in the Registry to:JAPANESE_JAPAN.UTF8Form Builder 6i does not display proper Japanese characters in its Wizard dialog screens. See screenshots at: - http://www.danielrod.com/Wizard_UTF-8_01.jpg- http://www.danielrod.com/Wizard_UTF-8_02.jpg Note: Setting the Regist ...

Oracle How to display message box

In my application i have used check constraint ,on violation of check constraint i want to display my own message box same as when at time of deleting a page it display message.Secondly in my region when iam trying to create frames through html coding the frame is not getting created,when same codin ...

Oracle HOW TO DISPLAY MESSAGE WHILE PROCESSING IS GOINGON UNTIL PROCESS COMPLETE -

Please i have a serious problems with forms6i in my project. I have a form on which consecutive text boxes are there and a push button is there which runs a long procedures and fetch values into textboxes.This process take 10 to 15 minutes. what is my requirement is once i pressed the pushbutton at ...

Oracle Examples of Add and Delete buttons in Forms

Hello, I have group project and we are having a hard time finding examples of how to add and delete records. We have tried for the add:INSERT INTO order_line VALUES(:orders.o_id,:order_line.inv_id,:order_line.ol_quantity);COMMIT;And this for the Delete:DELETE FROM order_line WHEREo_id = :orders.o_id ...

Oracle Display Message if no rows returned.

Is threre any way I can display a message if no rows returned using a sql statement. Something like nvl usage for null values. If sql returns no rows, then display a message. ...

How to display message using default lock in ORACLE 9i?

I am using ORACLE 9i I am inserting a same record in a same table (which is having primary key) of same user with different sql editor (or from different machines).with same time.One person is able to insert the record.. But other one is in processing state, once the inserted person give commit,then ...

How to display message using default lock in ORACLE 9i

I am using ORACLE 9i I am inserting a same record in a same table (which is having primary key) of same user with different sql editor (or from different machines).with same time.One person is able to insert the record.. But other one is in processing state, once the inserted person give commit,then ...

Oracle how to display message / require user response within page process

I have a page process that does some permissions checking and application startup tasks. Midway though the process, and depending on what user has logged in, the process needs to display a message that instructs the user to take an external action -- open up a tunnel to a remote database -- and then ...

Oracle Alignment for buttons in forms region

Very poor in designing please, help me.In the form region the #body# is one table and the buttons are in another table ie <td> <table>#Body#</table> <table>#buttons#</table> </td> hope In apex, this is how the form region is created. If not, correct me.i want to a ...

Oracle display template based buttons side by side, not on top of each other?

I have created 2 buttons located in the same region. These buttons have a button style of Template Based Button. I created a Button Template that is used by them. And the 2 buttons have a mouseover effect (another image shows up when the mouse is over it). The button alignment is set to right. Seque ...

Oracle How to check if database is unavailable and display message

I have an Application Express application that has a link set up to another database. I would like to be able to check the availability of that database and if it is unavailable display a message to the user. I know how to set the availability of the Applicatiion Express application, but that requir ...

Oracle how to darken screen/fade it and display message box in javascript or css

So there are some really neat websites out in internet land. There is a technique of when a button is pressed the current screen will appear to have a grey transparent film/color over it and then a message box will popup. The current screen looks like it is in the background and faded.Does anyone kn ...

Oracle Forms to APEX Conversion - buttons are being treated as columns

When I convert a Form to XML then import into APEX I get errors because buttons are treated as columns and are in the select list. In some cases I can create a custom query for a block in other cases that option is not available. Is there a setting in Forms that is causing buttons to be treated as c ...

Oracle display message with hidden and protected item

I have a plsql process in which i am checking a condiiton for a particular column in my report. I also have an hidden item on my report :P53_HITEM Now I want to display an conditional message(like whenever condition fails) using the hidden item.The thing is that I am able to display a message using ...

display message in oracle and sqlserver

Is there a common command to display message in Oracle and sqlserver. (LIKE IN ORACLE IT IS PROMPT AND IN SQLSERVER IT IS PRINT)I want to create a .sql file that will display a message in oracle and sqlserver.like declarePROMPT MAKE A CHOICE ENTER VALUE (1 OR 2)v_choice number;beginv_choice:= ...

Oracle Javascript to Display message and return to home page

HiI have a requirement to display an acknowledgement message after a button has been pressed and return to home page. I created some JS and tested on a standalone button.<script type="text/javascript">function GoToHome_ack(){alert("Authorisation Created!");// goto to page 1location.href = "f?p ...

Display record in Oracle Forms based Group clause Parameter.

Please find the query Nothing but Table which i'm using in Form for populating Data : query :SELECT A.ZONE_CD,A.DIST_CD,A.POST_CD,A.HOUS_TYPE,A.PART,A.CUST_TYPE,A.AGE,a.NATIONALITY,a.group_cd,A.REP_FLG,COUNT(A.do_no)CNT,NVL(SUM(A.Sales_Amt),0) slsAMT,NVL((ROUND(SUM(A.Sales_Amt)/COUNT(A.do_no))),0) A ...

Oracle display message in different color

I use an item (:P10_MESSAGE) to display message like the following. &P10_message. is put in the messages tab My problem is I would like to display it in Green when it is matched , in red when not matched. But I don't know how ? declare v_item_amt number;beginv_item_amt := nvl(:P10_item1,0)+nvl(: ...

Oracle Display message to User

This is what i was trying to achieve.When a Contact Record is picked/selected while creating a New Service Request, based on a attribute from the Contact record I need to display a pop-up message to User.Using Worklfows i can do this for Before Modified Record Saved trigger event, but I need this to ...