asked on

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

Hi Guys,

I have a problem. I am getting the following error in the status bar:

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

The problem situation is like this. I have a order entry form in which i will be entering the orders. For each order, i should enter the diff items that needs to be ordered along with its item details. How much Qty, item name, date etc.

This item price details of how much each item costs are stored in a different form. In the order entry form, in the items form we have QTY and UOM which are database items. Along with this, we have created two non-database of QTY and UOM for a different distribution to enter the details over there.

While entering the item details, when i enter the QTY to some number and try to proceed to next item, It doesnt move from that item and stops there and displays the above error in the status bar down the form. I cant move forward or backward.

In the item price details form, if the item has only one line, then it works fine. but if the same item has two lines, then this problem is occuring. For ex:- We closed one item and opened the same item with a diff price on a diff start active date. we closed the item by giving end active date and started the same item by giving a date greater than the end active date.

If the item is opened once with start active date and not ended, then it works fine. But only for the case above, its giving the problem.

Help Appreciated from you form gurus....

Thanks

raopsn

Can you post the trigger code ?

schwertner

You have to include EXCEPTION section in the trigger code.
In this section try to print the most important data values
in order to understand what happens.

amankhan

ASKER

Here is the trigger code,

OE_LINES.Ordered_Quantity('WHEN-VALIDATE-ITEM');
if :system.mode != 'QUERY' then
phs_custom.ordering_quantity('WHEN-VALIDATE-ITEM');
end if;

Hi Schertner,

I didnt get you what you mean. Could you be some more specific sir. Help Appreciated.

Thanks

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

amankhan

ASKER

Hi Schertner,

Thanks for the help. Are there any good documents or material by which we can master oracle forms and reports. If you have any good links or stuff, pls recommend me or else assist me in how to become comfortable in handling forms and reports

help appreciated.

Thanks

schwertner

There are many books for Forms and Reports.
Also in Oracle OTN (register for free) you can download
in Oracle Application Server docs good docs about Forms and Reports.
Forms and Reports are complex - I pass 5 exams to get certified in Forms/Reports.

amankhan

ASKER

Hi Schwetner,

Thanks for the help. Still I am facing with that problem. Can i send u the .fmb form so that you can take a look at it. Can i have you email address so that i can send that file to you.

Help Appreciated.

Thanks