OraFAQ Forum: Forms » state where no record match LOV

Home » Developer & Programmer » Forms » state where no record match LOV

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

state where no record match LOV [message #206905]

Sat, 02 December 2006 02:34

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Previous Topic:	validate item on varchar
Next Topic:	commit problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:40:13 CDT 2024