formatted amount using Dynamic_currency in XML Data template in BI publisher.

Hi All,

I have developed XML data template in BI publisher.

<element name="D_Commit_Balance"  dataType="varchar2"  value="D_Commit_Balance"/>

FUNCTION D_commit_balanceformula( invoice_currency_code IN VARCHAR2 )

  RETURN VARCHAR2

  IS

    l_formatted_amount VARCHAR2(19);

    v_currency VARCHAR2(10);

  BEGIN

    v_currency:=invoice_currency_code;

      l_formatted_amount := Dynamic_currency ( v_currency, 19, commit_original_amt + commit_total_activity );

      RETURN( l_formatted_amount );

      RETURN NULL;

  EXCEPTION

    WHEN OTHERS THEN

             /*srw.message (5000, 'DEBUG:  Unable to format amount... Returning Commit Balance.');*/

               NULL;

               l_formatted_amount := To_char ( Nvl ( commit_original_amt + commit_total_activity, 0 ) );

               RETURN ( l_formatted_amount );

  END;

commit_original_amt  ,commit_total_activity are  place holder columns defined in another formula columns & there are printing in XML data tags