Forms :: Post_change Trigger On Item?

Jul 11, 2011

I am asked to change an existing field (Category_Desc) from a data block (applications) from a current form with a different field (Facility) from another table (Places) that is not used in the current data blocks. How do i do that and how should i populate the data... The common string between the table used in the form (applications) and the non used table (Places) is the ID No.

make this change and also with a possible trigger to generate the data....

View 2 Replies


ADVERTISEMENT

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

Forms :: Next-Item Trigger

Aug 16, 2013

I have a multi row form (Order Entry form in E Business Suite). When I enter data in a row and error down the validate-item trigger fires and runs some code to check for duplicates, etc and after the cursor should go down to the next row. It goes back to the original row.

View 4 Replies View Related

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 :: Pre-text-item Trigger?

Nov 17, 2008

In my form, for an item there is code for pre-text-item trigger. In query mode when i go to next record, previous record etc, whether this trigger gets fired? In other forms it is getting executed. Only in this form it is not getting executed. What should be reason for not executing this pre-text-item? Only this item is enabled and cursor is there.

View 9 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 :: How To Restrict User On Key Next Item Trigger

Sep 16, 2011

SQL Plus version Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 Production
Forms Version : 6i
Reports Version: 6i
O/S : Microsoft Windows Xp professional Version 2002 Service Pack 3

With reference to the above version details here is the requirement. How do I restrict user on key next item trigger i.e I want the cursor to move to next field only when user presses "ENTER" button on the key board any other key like mouse should not allow user to move to the next field.

View 23 Replies View Related

Forms :: After Post Trigger Go To The Specific Item?

Feb 8, 2013

I have this layout

[URL]

and a post trigger insert and update

IF :item1 IS NULL
AND :item3 IS NOT NULL THEN
alert_id := FIND_ALERT('blank_alert');
SET_ALERT_PROPERTY(alert_id,ALERT_MESSAGE_TEXT,'Item3 must have a value.');
v_alert := SHOW_ALERT(alert_id);
RAISE Form_trigger_Failure;
END IF;

My problem was as it fires, the cursor will be on the item1. I've already use

SET_ITEM_INSTANCE_PROPERTY
NEXT_ITEM
GO_ITEM

but it was all illegal. The cursor must be in the item3.

Don't question me why I do not set the item3 to required and why post triggers. It is just that. It is the requirement.

View 4 Replies View Related

Forms :: To Get X-pos Of Item At Radio-change Trigger

Jun 22, 2013

i want to get the x-pos of item at the radio-change trigger but it return the error

declare
x_pos number;
lnum_x_pos number;
lnum_width number;
begin

if :radio_group = 'E' then
lnum_x_pos := Get_item_property('Remarks',x_pos);
Message('Position of x...'||lnum_x_pos);
lnum_width := get_item_property('Remarks',width);
Message('width of remarks field..'||lnum_width);

else
set_item_property('remarks',enabled,property_true);
set_item_property('remarks',visible,property_true);

end if;
end;

error is:::

argument to built in get_item_property/field char can not be null?

View 1 Replies View Related

Forms :: Call A Function On Key-next-item Trigger?

May 20, 2011

how to call a function on key-next-item trigger. atlst the syntax.

View 2 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 :: Post-Block Trigger - Trying To Capture Previous Item?

Aug 12, 2010

I have a form w/a tab canvas. BlkA is on Tab1 and Blk2 is on Tab2. In BlkA I have several items that have when-validate-item triggers. However, the trigger does not fire when I enter a value into item1 of BlkA followed by clicking on Tab2. To solve, I placed validate(form_scope) in the When-Tab-Page-Changed trigger. This works well with invoking the validation. However, focus remains on Tab2 (Blk2).

I would like focus to return to failed validation item in Blk1. I can capture the block name using :system.cursor_block in the Post-Block trigger of BlkA, assign that value to a form parameter and when a validation fails via the When-Tab-Page-Changed trigger I can return user back to BlkA(Tab1). However, I need direction on how to return user to the specific item in BlkA that failed validation

View 2 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 :: Trigger Form When-new-record-instance To Assign Values For Item

Mar 28, 2011

I am developing form, but there is issue when I Press F11 to query data.I make trigger form when-new-record-instance to assign values for item.But when i Press F11 then Block no clear.

View 1 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 40735 Key-next-item Trigger Raised Unhandled Exception ORA 01722

Sep 2, 2011

im updating my program and i got a error message

FRM 40735 key-next-item trigger raised unhandled exception ORA 01722

View 3 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

Forms :: Is There Text Changed Trigger With Text Item Function

May 5, 2010

Is there text changed trigger with text item function like when_list_changed trigger of list item?

View 7 Replies View Related

Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item

May 22, 2010

I have 2 items in my form:

1) Text Item
2) Tlist

Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .

View 1 Replies View Related

Forms :: Move Cursor To Another Item From WHEN-VALIDATE-ITEM

Apr 19, 2012

I need to move to control to another item in a same block from WHEN-VALIDATE-ITEM trigger. [WITH OUT USING ANOTHER TRIGGER]

View 6 Replies View Related

Application Express :: Unable To Trigger JavaScript From Page Item?

Oct 22, 2013

I am using the following code in Java Script function 

function notNull(object){    if(object.value=="")  alert('This field must contain a value.');  } 

I am then calling the function from one of the page item under HTML Form Element Attributes  by using the following

onblur="notNull(this);"  

But it doesn't seem to work. I am using APEX 4.2.3 

View 3 Replies View Related

Forms :: Update Database Item When Non-database Item Is Manually Updated?

Mar 10, 2011

I am having trouble changing a non-displayed field when a displayed field is changed.

When a user wants to un-assign a territory they want to just null the ID field (non-database item). I then need to null the PIDM field(not visible, database item) for that one record.

I tried this, but I end up putting null on all the records instead of just the one record, which ends up un-assigning all the territories not just the one.

Is there a way to assign the null to the PIDM field associated to the ID field of that particular record.

View 6 Replies View Related

Forms :: Text Item In Oracle Forms

Aug 22, 2010

How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.

View 4 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 :: How To Get Menu Item Name

May 5, 2009

I have created a Menu in forms 6i,

I want to get Menu Item Name When i pressed any menu item in runtime..

e.g, i have a menu items like,
MENU1
ITEM1
ITEM2
ITEM3

when i pressed ITEM1 then it should display ' MENU1.ITEM1 ',

how can i get this..?

REMEMBER !! I WANT TO GET MENU ITEM NAME IN RUNTIME , WHICH IS CREATED IN DESIGN TIME.

View 10 Replies View Related

Forms :: Create More Than One LOV To Item?

Feb 19, 2011

how can i give more than one lov item to an item?

View 3 Replies View Related

Forms :: Go-item Not Working?

Feb 1, 2012

I hab a button:

flag:=show_lov('lov16');
if :block.cliente_no is not null then
go_block('clientes');
execute_query;
go_item('block.codigo');
end if;

it calls a LOV and return a value to :block.cliente_no, then execute a query in block clientes, but cursor doesn`t goes to block.codigo it remains in the button ! Why doesn`t works ? Note: if I insert a message before line go_item('block.codigo'); cursor goes to 'block.codigo' (message('hallo');

View 3 Replies View Related

SQL & PL/SQL :: How To Display Missing Item Names For Each Item Code

Feb 16, 2010

I have a table with the following data.

item_code item_name
101 Pen
101 Pencil
101 Scale
102 Pen

[Code]...

My aim is to display the missing itemnames for each itemcode.

For each ITEM_CODE there should be four items i.e Pen,Pencil,Scale and Marker If any itemcode missed any of the itemnames those records should display in the output.

So the output should be like this

101 Marker Because the item Marker is missed.
102 Pencil Because the items Pencil and Marker are missed.
102 Marker Because the items Pencil and Marker are missed.

For itemcode 103 no records should be displayed because it having all four itemnames.

View 21 Replies View Related

Forms :: Shortcut Key For Textbox Item?

Jul 11, 2013

IF on button label, we use ampercent "&" to make its shortcut then is there anyway to make a shortcut for TEXT BOX ITEM ?

View 4 Replies View Related







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