Home » Developer & Programmer » Forms » state where no record match LOV
state where no record match LOV [message #206905] Sat, 02 December 2006 02:34 Go to next message
SPRAS881
Messages: 2
Registered: December 2006
Junior Member
hi

i have a column ins_co_id, insurance_name, co_pay_rate which retrive values from LOV
here the problem is a customer may or may not have insurance
in case of having insurance the code works fine
but when the customer does not have insurance
im getting error
my code is

PROCEDURE Compute_Amounts
IS
BEGIN
  IF :refill.Ins_co_Id IS NULL  THEN
    :refill.Ins_co_Name := NULL;
    :refill.Ins_co_Pay := 0;
    :refill.Amt_Due := :refill.Total_Charge - :refill.Ins_co_Pay;
  ELSE
    Get_Ins_desc;
    :refill.Ins_co_Pay := :refill.Total_Charge - (:refill.Total_Charge * (100 - :refill.cUst_Ins_co_Pay_Rate) * .01);
    :refill.Amt_Due := :refill.Total_Charge - :refill.Ins_co_Pay;
  END IF;
END;

and the error is
FRM-40735:WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403

thanks

Upd-mod: Add 'code' tags.

[Updated on: Mon, 04 December 2006 00:24] by Moderator

Report message to a moderator

Re: state where no record match LOV [message #207044 is a reply to message #206905] Mon, 04 December 2006 00:32 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Which line is failing? Put a 'message; pause;' pair after each line to determine which one is failing. Then verify your datatype. Which version of Forms are you using? Maybe you need a 'to_number(null)' instead of 'null'.

David
Previous Topic: validate item on varchar
Next Topic: commit problem
Goto Forum:
  


Current Time: Wed Dec 07 16:41:51 CST 2016

Total time taken to generate the page: 0.31207 seconds