Forms :: Skipping Other When Validate Trigger?

Mar 1, 2012

I am using when validate trigger in the item level for baserate, markup, and rate my requirement is

1.if markup and rate are null then all the trigger should fire which means baserate value should show calculating entered markup in the rate field.

2.if the rate is change markup should get change as per the entered rate

3. when second time the baserate is changed only markup should change not the rate.

View 3 Replies


ADVERTISEMENT

Forms :: Trigger When Validate Item

Dec 18, 2012

i need to pop up an alert using a trigger to test the data type of a field per example if the input is not a number an alert will popup "Please insert a number"

View 5 Replies View Related

Forms :: Validate Item Trigger?

Aug 22, 2011

i have a text field where i am putting values from an LOV and i want to check for wrong entries like if the user enters a wrong code it should display the message "wrong code".so this is the code i am using in the when validate item trigger:

begin
declare
pc number;
begin
select count(*)

[code]...

But it doesn;t work, it acepts the wrong code also.

View 6 Replies View Related

Forms :: Validate Record Trigger

May 26, 2011

I am trying to write a procedure using when-validate-record that will clear all fields, display a message and ignore all commits if user is not authorized to have access to make changes to the form.

I have tried to use Clear_form(no_validate)and clear_record and neither works

View 6 Replies View Related

Forms :: Wrong Updation In When Validate Trigger?

Sep 14, 2013

In when-Validate-Item trigger,I am checking a condition like
if %>=90 and days<=7 then status='Y'
else status='N'

It is working fine in 95% cases But in Some cases it is wrongly updating like even if both conditions are true status ='N'

This is happening in user side on rare occasions so what we do currently is ask the user to delete that line and insert it again and it is working

What I need is how to recreate that scenario which is wrongly updating?

View 37 Replies View Related

Forms :: Created Trigger Using When-Validate-Item

Jun 20, 2013

in data block... in empno text item.. I created trigger using When-Validate-Item in that pl/sql block I written this code

declare
BTN number;
begin
if length(:emp.EMPNO)<4 THEN
BTN :=SHOW_ALERT('ALERT2');
END IF;
END;

but it is not showing the alert message when enter the empno more than 4 letters.i used Pre-Text-Item.

View 2 Replies View Related

Forms :: When-validate-item Trigger Doesn't Fire?

Jul 9, 2013

I am trying to make a particular field (called reason_code) "required" on a form I am working on.
Now this field has two fields before it, and I have to tab to reach my reason_code field.

But the functionality I want is that when I tab into the reason_code field, the WHEN-VALIDATE-ITEM trigger should fire even when this field is NULL.

IF :REASON_CODE IS NULL THEN
MESSAGE ("Please enter a reason code!");
end if;

The trigger doesn't fire when I don't enter a reason_code field and I can tab past this field and not get the ("Please enter a reason code!") error message.

On researching the problem, I saw that this field has to be of status "CHANGED" in order for the trigger to fire.

View 17 Replies View Related

Forms :: WHEN-VALIDATE-ITEM Trigger Raise Unhandled Exception ORA-01422

Sep 15, 2011

I have a form (StaffDetail) with three different blcoks. One of them is an Application Assignment block which consists of nothing but Assignment Type, Staff (Name), Last Updated By and Last Updated Date.. The Assignment Type and Staff has LOVs assigned to them individually.. Assignment type lets me pick all different types except for Project Manager. As soon as I select this option, i get the following error :

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception...

This does not even let me select any other Assignment type, then i have to go close all sessions and come back into the same screen.

Also, this form was first created and tested on the development environment and later moved to QA environment. All selections work in the development environment.. I checked for the roles in QA for individual Users..

View 2 Replies View Related

Forms :: Ora-04062 When-validate-item-trigger Raise Unhanded Exception?

Oct 15, 2011

I have Written this code in WHEN-VALIDATE-ITEM-TRIGGER on PO_DATE field

if not( :PO_HEADER.PO_DATE IS NOT NULL ) then
:po_header.po_date := trunc(sysdate);
end if;
if trunc(:PO_HEADER.PO_DATE)>trunc(sysdate) then
displayerror.errmsg('PO date cannot be future date!');

[code]...

when i am navigating through po_DATE field in the form its showing the error that

WHEN-VALIDATE-ITEM-TRIGGER raised unhandled exception.

View 2 Replies View Related

Forms :: Frm-40375 / When-validate-item Trigger Raised Unhandled Exception ORA-01403

Mar 6, 2011

frm-40375: when-validate-item trigger raised unhandled exception ORA-01403.

i put a new column which is the birth date and i made a new procedure with regards to the age level for the Plan. and when i run the program, theres an error..

View 14 Replies View Related

SQL & PL/SQL :: Write A Trigger To Validate V_status For Each ID

Dec 30, 2010

I want to write a trigger to validate the v_status for each ID. below is the example

SEQ_NO ID V_STATUS

11 C
21 C
31 F
42 C
52 F
63 C
7 3 F
8 3 C

For each unique id there will be only one F .. if some one tries to update the 2nd F to the same ID it will show the error message that ID is already F.

SEQ_NO ID V_STATUS

11 C
21 C
31 F
42 C
52 F
63 C
7 3 F
8 3 F

View 12 Replies View Related

SQL & PL/SQL :: Skipping Of Records - Oracle External Table?

Sep 24, 2011

I have a flat file on an unix system.The file is required to be loaded through Oracle External Table.

Issue:
Not sure how to skip the first record when loading through Oracle External Table.How to suppress data while loading through External Table.

Requiremen syntax where in I can skip the first record. syntax for suppressing values in columns that are not required. How the same needs to be handled in case of Number datatype and Varchar2 datatype. Example - In case of Number can it be replaced with 0 and for datatype can be same be replaced with NULL.

View 9 Replies View Related

SQL & PL/SQL :: External Table For CSV Delimited File Skipping Columns?

Jan 24, 2013

I need to load csv file using an external table.

Structure of External Table:
---------------------------
create table A (col1 varchar2(30), col3 varchar2(30), col5 varchar2(30));

CSV FILE:
-----------
col1,col2,col3,col4,col5
A,B,C,D,E
1,2,3,4,5

The table data should look like

COL1 COL3 COL5
A C E
1 3 5

need to skip the columns in CSV file.

View 5 Replies View Related

Server Utilities :: SQL Loader - Skipping One Column Which Shouldn't

Mar 25, 2013

CONTROL FILE:
LOAD DATA
INFILE 'sample.txt'
INSERT
INTO TABLE TEST_RECORDS
WHEN REC_TYPE_HDR='HDR'
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
[code]....

The value 603 should have loaded into TRAN_TYPE field or column, instead it loaded into the next field or column LINE_COMP.

View 3 Replies View Related

Forms :: Set Validate Item From LOV To Yes

May 29, 2011

i have a table called equipment containing engine_type_id.in the equipment form that is based on the equipment table, i added a non database item called engine_type.

i added an LOV for the engine type field, so that the user can choose the engine type from the the egine types table. i made the engine type id hidden. and set the validate item from LOV to yes.on post query trigger, i selected the engine type into the nondatabase field.

the form is working properly.

when i push CTRL F11 (query) and scroll, even if i didnt change anything the form builder asks me , do u want to save changes.

View 2 Replies View Related

Forms :: Validate From List

Mar 25, 2009

I have a non-database text item (name: profession_temp) on a block and it is a also return item for an lov.

When I change the property "validate from list" of the item(name: profession_temp), to YES, and closing the form without inserting, updating, deleting any record , a message is displayed "do you want to save the changes?".

When I change the above property back to "No", the message is not displayed in this case. I wonder why this message appears while there is no change occurred in the underlying records?

View 13 Replies View Related

Forms :: Use Of Validate From List Property

Jul 19, 2013

What is the uses of "Validate From List" Property(Yes/No) in LOV's Properties.

View 3 Replies View Related

Forms :: How To Validate List Item

Nov 22, 2010

I am working on form 6i..

I have developed a form with some text items,a list item and a image item...

list item......account_list(values....company,individual)
text_item..... company_name..
text_item.....image_path...

i have attached a pop up menu to image item... Add image and upload image...

When i click on 'Add image' the image path is getting enabled.. it is fine but when i am changing the account_list i need enable and disable the 'Company_name' text item... How can i achieve this??

I have tried it in when-validate-trigger on account_list...

if account_list=individual then
set_item_property('company_name',enabled,property_false);
else
set_item_property('company_name',enabled,property_true);
end if;

But no use of this....

how can i achieve it??

View 5 Replies View Related

Forms :: How To Validate Primary Key Fields In 6i

Mar 5, 2011

i have a emp block with multiple rows in which col1,col2,col3,col4,col5,col6 are the columns...In emp block col1,col2,col3 are the primary key fields.. i need to validate the primary key columns such that it should not allow duplicates values in the primary key col's with out checking the database values with out using enforce primary key property

View 2 Replies View Related

Forms :: Validate After Write In Textitem?

Jun 30, 2011

how to Validate after write every character in textitem to do event ?

exmple :

to make filter on lov from this textitem

when write M ---> lov list all name start with M
when write O ---> lov list all name start with MO
when write H ---> lov list all name start with MOH
os ....

View 3 Replies View Related

Forms :: Validate Time On Field

Aug 22, 2010

I have a varchar field and user will enter the time in that field as per the format HH:MI HOURS:MINUTES.Actually there is no control on this field and user is making mistakes like instead of HH:MI he is entering HH;MI.

View 1 Replies View Related

Forms :: How To Validate Salary Regarding To Its MIN And MAX Value From Another Table

Jun 16, 2012

I have a created data block using employees table so am trying to validate item salary using max_salary and min_salary from table jobs how to do this kind of validation.

[How can i validate input number into a Field of type char in oracle form?]

View 1 Replies View Related

Forms :: Triggers - Key Next And When Validate Item?

Jan 18, 2006

Suppose if I have defined two triggers Key-next and When-validate-item on the same item.

If my key-next is going to fire first and When-validate-item laterhow can the validation happen if I write a code like go_item('XXXX') in my Key-next.Does it mean that if u write a code in key-next to jump to some other item, no validation takes pLace?

View 14 Replies View Related

Forms :: Validate Field To Be Valid Email ID?

Feb 16, 2011

want to validate a field to be a valid email id.

View 1 Replies View Related

Forms :: Validate Item Value In Multiple Records?

Nov 4, 2013

This is my first post in the form and also i'm new to oracle forms technology.

I have the following issue:

In my form i have two Text-Fields to store some information for a claim:

A --> Profit and
B --> Loss
(only one of the filed can have value)

Also i have a data block where i store the reason of the claim (status). Reason can take three values 1, 2, 3. For each claim i can have more than one reasons stored in db table.

if the user input more than one reasons, then if one of them is 1 Profit should be set unprotected and Loss should be set to protected.

I have the following issue.

user creates a records with reason 1 : Profit text field is set to unprotected and Loss text filed is set protected.

user creates another record with reason 2: Profit text field is set to Protected and Loss text filed is set to unprotected. --> wrong

How can i validate the values of the two records and create the desired functionality?

I have used the POST-TEXT-ITEM trigger but it works correct only for one record. i insert two records with the above order i have the issue i describe.

View 3 Replies View Related

Forms :: How To Validate Alphanumeric And Symbol In Textbox

Nov 12, 2012

I have created a form that have a button to check the character in the textbox is alphanumeric and symbol. Here attached the code, that i tried from other post.

View 5 Replies View Related

Forms :: How To Use When-validate-item In Enter-query Mode

Oct 14, 2012

I have to create a form and i have to use trigger when-validate-item in enter-query mode . I have read trigger when-validate-item can not use Enter Query Mode . Is there any way to do this when i enter-query?

View 5 Replies View Related

Forms :: Post-change Versus Validate Item

Oct 20, 2010

tell me excat diff. between when- validate -item vs. post-change in a simple way...

View 4 Replies View Related

Application Express :: 4.2 - Validate Field In Tabular Forms?

May 13, 2013

1.- i have a product_item field (wich is a lov and user choose one value), so i need to call a function (sending it the selected value product_item) that will return me some data about the product i selected, for example :

if the function return 'A' then
disable the next item on tabular form, lets say quantity
else
enable the next item on tabular form, lets say quantity
end if

2.- i need to determine the result of two items operations:
total := final_quantity - start_quantity
the user will introduce start and final quantity and i will determine the total.

View 0 Replies View Related

Forms :: Call One Trigger Of Item In Trigger Of Form?

Jul 1, 2011

How can "call one trigger of item in trigger of form"

View 5 Replies View Related







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