Sujith S
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/M M/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
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/M
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.