Link to home
Start Free TrialLog in
Avatar of Sujith S
Sujith SFlag for United Arab Emirates

asked on

error showing- rep 1401- function returned without value

function B_51FormatTrigger return boolean is
   
  M_REC NUMBER(2);  
  M_AUTH VARCHAR2(10);
begin
M_REC :=0;
IF :invh_cust_code not in ('C00000') then
IF :invH_DT > TO_DATE('31/12/2017','DD/MM/YYYY') THEN
      IF NVL(:CUST_FLEX_07,'0') <> '0'  THEN
            IF NVL(:CS_TAX,-1) <0 THEN
          return (TRUE);
   else
                  return (FALSE);
   end if;
            ELSE
                  RETURN (TRUE);
END IF;
END IF;
else
      return (false);
      end if;
end
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial