Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5489
  • Last Modified:

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
0
amankhan
Asked:
amankhan
  • 3
  • 3
1 Solution
 
raopsnCommented:
Can you post the trigger code ?
0
 
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.
0
 
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
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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.
0
 
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
0
 
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.
0
 
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
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now