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
Sujith SAsked:
Who is Participating?
 
johnsoneConnect With a Mentor Senior Oracle DBACommented:
First, format your code so you can see the matching if and ends.
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 

Open in new window

Looks like you are missing one else case:
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; 
    ELSE              -- this is missing 
      RETURN ( ??? ); -- this is missing 
    END IF; 
  ELSE 
    RETURN ( FALSE ); 
  END IF; 
END 

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.