FND FORMAT_CURRENCY TO USD? 1

[audinjm]

FND FORMAT_CURRENCY TO USD?

Can someone please send me code I can use in my rdf to always default my amount field to the USD formatting in XML output?

I was thinking I had to set up a new calculated field and in the sql formula, do this:

function CF_TRANS_AMOUNTFormula return Char is
begin
declare usd_currency_code varchar2(3);
BEGIN
SRW.REFERENCECF_TRANS_AMOUNT);
usd_currency_code:='USD';
SRW.REFERENCE(usd_currency_code);
SRW.USER_EXIT('FND FORMAT_CURRENCY
CODE="usd_currency_code"
DISPLAY_WIDTH="22"
AMOUNT=":trans_amount"
DISPLAY=":CF_trans_amount"');
RETURNCF_trans_amount);
END;
end;

However, when I add this piece of code to my rdf, I am getting an error (though it's not in my log file) and no XML is being generated. What am I doing wrong?

 

[nagornyi]

function CF_TRANS_AMOUNTFormula return Char is
begin
return to_chartrans_amount, '$999,999,999.99');
end;

 

[audinjm]

Thanks!