Application Express :: How To Show Alert Message In Home Page

Jun 11, 2012

I have leave application form based on the LEAVE table, it has the following columns,

leave_id(primary key)
emp_name
from_date
to_date
no_of_days

Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?

View 5 Replies


ADVERTISEMENT

Application Express :: No Navigation Region On Home Page?

Sep 21, 2012

I've created a new appliacation which has a home page and I've created a report page which updates a table. I want to add a link to my homepage, as a text line for example UpdateTable, and when I click the link, it goes to my report page. I've had a look in my Apex CookBook, and it says I do this by using the Navigation region in my home page. The problem is I don't seem to have a navigation region in my home page. I thought initially it meant the navigation bar, but I now realise this is the header bar. Do you know how I can create a navigation region in my home page..?

View 2 Replies View Related

Application Express :: Menu List Look Change Between Home Page And Other Pages

May 18, 2013

APEX Version : 4.2.2
Application : TRQ_APP

[URL].......

I have a menu list defined in page 0 - when the menu list is displayed in home page (Page 1) it looks fine but in others pages it displays differently

To have the menu list displayed in all pages of application as it is in page 1.

View 5 Replies View Related

Application Express :: How To Show Alert When Data Not Exist In Table And Clear Field

Jun 8, 2012

Recently i created a form which contains emp_name,deptno,supervisor_name.For emp_name if i type the emp name (eg:allen) it will show me a list of employees named allen as a select list.For that i used a jquery script on page header

<link rel="stylesheet" href="URL.....
<script type="text/javascript" src="URL....
<script type="text/javascript">
[code]....

and i have created a dynamic action for emp name to fetch the deptno,supervisor_name if select the employee name it is working fine is if i type a emp_name which doesn't exist in the employee table it will show me a alert message employee does not exist and it will clears all the fields.

View 0 Replies View Related

Application Express :: Display Success Message Without Reloading Page

Feb 22, 2013

I have the following problem.

By clicking on a button on my page, I execute a Dynamic Action. That Dynamic Action consists of several True Actions, one of which is Execute PL/SQL code where I execute a procedure. I'm doing this without submitting the page, and that works fine.

However, I would like to display an error message on the top of the page, in case my procedure returns an error, and I would like to do that without submitting the page.

Is this possible?

View 6 Replies View Related

Application Express :: Show Progress Bar While Only On Page Load?

Nov 13, 2012

I want to show progress bar every time when page loads.

Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.

//written on Header Text of Page
<script type="text/javascript">
<!--
function html_Submit_Progress(pThis){
$x_Show('AjaxLoading');
window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100);
}

[code]...

I want only to show only page loads.

Apex Version : Apex 4.1
DB Version : 10g

View 2 Replies View Related

Application Express :: Dynamically Hide Show Page Items

Dec 14, 2012

Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.

In my page (form) I have 5 fileds iitems.

- Customer No
- Edit
- First Name
- Last Name
- Address

I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.

So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes

But it not working for me? Where am I go wrong?

View 2 Replies View Related

Application Express :: Hide And Show Region In A Page With Some Validations

Aug 4, 2012

I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.

View 2 Replies View Related

Application Express :: Dynamic Action To Show Skill-builders Pop Up Only Works When Page Refresh?

May 28, 2013

I have a report with a link column:

'<a href="f?....................................class=show_popup"........

I have a dynamic action defined like this:

Event: click.
type: jquery selector
selector: a.show_popup
no condition.

action: skillbuildersmodalpage 2.0.0
URL: attribute of triggering element.

This works fine, but after the popup is shown and closed, the link is not working until the page is entirely refreshed again.

after the popup is closed, i only refresh the report with $a_report , ( in another dynamic action on the "auto close skillbuolders" event) i don't want to submit all the page....the partial refresh is working fine too, but not the link, it only works again by refreshing or submiting all page

View 2 Replies View Related

Application Express :: To Change The Default Behavior Of Hide / Show Region To Show

Jun 26, 2012

I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.

View 16 Replies View Related

Application Express :: Clearing Cache From Home Link

Sep 29, 2012

I am using theme 4, topaz. Region_Position_06 is a home link.

I have placed a company graphic at this position on page zero, and when a user clicks it on any page, she exits that page and goes to the home page, a main menu page. So no matter how deep a user may be into the application's pages, she may always click this logo image and return directly to the main menu page.

This is convenient, but there is one problem. Clicking this logo does not clear the cache on the page the user is exiting or, for that matter, on any page in the trail of pages the user took to get to the current page. I navigate primarily with buttons and always clear the cache on a page when I exit it. I need to find a way to do this when a user clicks the logo image.

View 7 Replies View Related

Application Express :: Can Open Page 306 As Modal Window But Page Closes Immediately

Nov 13, 2012

i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.

Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.

as defined in my button attributes.

Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.

View 3 Replies View Related

Application Express :: Add Field In Page Title Or Repeat Header On Each Print Page

Jun 4, 2013

We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.

Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.

View 1 Replies View Related

Application Express :: How To Create A Text That Links To Another Page From The Login Page

May 21, 2013

In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.

With a button, its simple because its inbuilt there,but I do not want a button,just this: Register

I want also to have the text in color not black.

View 6 Replies View Related

Application Express :: Passing Item Value To Another Page Via Button Set To Redirect To Page

Jul 16, 2013

I am new to APEX and I am developing an application to manage Oracle database user accounts.  I have a page (8) that has text items for the username and the database name.  I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account.  I have another button that should:

get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11

The issue is that FIND_USER_IN_DB does not get populated and page 11

which is a simple report with the following query:

SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB; 

How do I accomplish this?

View 8 Replies View Related

Application Express :: Navigate To Authorized User Page 5 - Keeps On Going To Page 1

Aug 17, 2012

I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .

View 8 Replies View Related

How To Set Tablespace Alert Message

Aug 11, 2012

How can i set alert message for users tablespace.

for ex

My users(tablespace) data file size is 100m . If 90m reached , i need some alert message through email or mobile.

Os : linux 4
version :10.2.0

View 2 Replies View Related

Backup & Recovery :: Warning Message In Alert Logfile?

Nov 25, 2012

I see following warning message in alert log file.

Quote:WARNING: OMF is enabled on this database. Creating a physical standby controlfile, when OMF is enabled on the primary database, requires manual RMAN intervention to resolve OMF datafile pathnames.

NOTE: Please refer to the RMAN documentation for procedures describing how to manually resolve OMF datafile pathnames.

Is it just an information or something like warning message we need to look into it.

View 1 Replies View Related

Application Express :: Message Box With Report?

Nov 1, 2012

I created a report and in this report there is a likeable colummn and when its been cliked I need its show a message box containing a text that cames from field on a tables in my database.

View 1 Replies View Related

Forms :: Customize Position Of ALERT Message On Screen As Per Requirement

Mar 19, 2010

I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.

View 4 Replies View Related

Application Express :: Showing A Message From A Button?

May 22, 2013

I have a button with an dynamic action , with sql:

declare
errors varchar2(100);
begin
apex_application.g_print_success_message := 'test message';
errors:=package.function_some_process_returning_varchar100_with_errors_or_sucess;
HTP.p ('<script language="JavaScript"> alert('''||errors||'''); </script>');
end;

The first "test message" is not shown.and after the function (it is executed fine) i get the next error:

Error:Parsererror - SysntaxError: Unexpected token <

i i only leve the first line (g_print_sucess) nothing occurs clicking the button.

I only want to show on a popup the result from the function, but g_print_sucess seems not to work for some reason.

View 1 Replies View Related

Application Express :: How To Make Error Message Red

May 20, 2013

A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,

I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?

View 2 Replies View Related

How To Keep Date Time Line collected Alert Message In Linux Platform

Aug 20, 2012

In linux server for 11g oracle. how do I keep date time line for each error message?example as

cat alert_test.log | grep 'ORA'
grep 'ORA' alert_test.log

I like output as
Mon Aug 20 01:54:29 2012
ORA-01560 caused by SQL...........

I know we can use diag... But I want to some linux command for my debug.

View 3 Replies View Related

Forms :: Logo And Home Page Picture Quality?

Nov 29, 2012

, i want to use picture on my home page (main.fmx) & logo picture on top of my oracle forms 11gR2 application.i try with 2 different ways, but i am loosing the quality of picture.

A. Form Menu - Edit - Import - Image - Even i select excellent quality
B. Through Webutil Read_Image_File ()

View 2 Replies View Related

Application Express :: Message Display Before Submit To Record

Nov 5, 2012

I have created two page process with two buttons "APPROVE" AND "CANCEL" button. first page process running approve invoice procedure on approve button and second page process running cancel invoice procedure on cancel button. i want to display massage before approve invoice and cancel invoice (DO you want to approve invoice) on approve button and (Do you want to cancel invoice on ) cancel button.

Working with apex4.1.

View 4 Replies View Related

Application Express :: Delete Message Not Displaying When Upgrade To 4.1

Jul 31, 2012

I am in the middle of upgrading my application to Apex 4.1 from 3.2.1. I have been using the default delete message and now it won't work.

<script langues="javascript" type ="text/javascript"
<!--
htmldb_delete_message='"DELETE_CONFRIM_MSG"';
//-->
</script>
button action

redirect to url ----> javascript:confirmDelete(htmldb_delete_message,'DELETE_RATING');

now all I receive is a message from the webpage, instead of the message.

View 4 Replies View Related

Application Express :: 4.1.1 - Tabular Form Updated Row Message

Oct 31, 2012

In my Application I have a tabular form and they other I edited 1 row & 1 entry and clicked on the update button. The message on the top says:

16 rows updated, 0 rows inserted (the standard message).

I do not have any page processes before or after applyMRU and its one of those freaky one-off issue that I can't reproduce again. Update 1 row and shows 15 updates.

Here are some info regarding my tabular form:

8 columns, pagination enabled for 20+ rows, no insert or delete functionailty, just updates.

View 0 Replies View Related

Forms :: How To Create Library Functions To Show Alert

May 24, 2010

Am using Oracle 10g Forms and Databse.

My form Consists data block blk_user with two items username and password

Both user name and Password are required Fields.

When user left these items Empty To show Alert

I Created Below Procedure and Called in Form_Level ON-ERROR Trigger.

PROCEDURE pcd_io_alert IS
itm_name VARCHAR2(20);
BEGIN

[Code].....

how to call or create this procedure as Library functions and call the created library in form To Show Alert. Actually I want to create library functions to Validate and Show Alert Mesages.

View 1 Replies View Related

Application Express :: Reset Data Picker Page Item By Selection Page Item

Aug 23, 2012

Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.

Issue here is unable to find a way to set the page range item values based on the quarter field selection

how to reset the page item fields.

View 0 Replies View Related

Application Express :: Image To Show Up In Application

Jul 22, 2013

i am trying to make an image to show up in an application am developing but is only appearing like a box but when i click on the edit pencil icon the image will appear.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved