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
amankhanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

raopsnCommented:
Can you post the trigger code ?
schwertnerCommented:
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.
amankhanAuthor Commented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

schwertnerCommented:
'WHEN-VALIDATE-ITEM' is a trigger that starts automatically when you leave the item.
You have not to invoke it.

About the exception section:

......
EXCEPTION
WHEN No.Data_Found THEN Message('Invalid Commission Plan, Use <List> for help');
RAISE Form_Trigger_Failure;
 WHEN Too_Many_Rows THEN Message('Error. Duplicate entries in COMMPLAN table!');
RAISE Form_Trigger_Failure;

Seeing what you have posted I thing you do not use the trigger in the simple natural way and this cause troubles.

Use online help of Forms to get a correct site on the situation.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
amankhanAuthor Commented:
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
schwertnerCommented:
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.
amankhanAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.