DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on FND_FILE

Line 142: Fnd_File.Put_Line(Fnd_File.Log,x_Trx_Number||','||x_Third_Party_Name||','|| x_Third_Party_Num);

138: OPEN c_trx_number;
139: FETCH c_trx_number
140: INTO x_Trx_Number, x_Third_Party_Name, x_Third_Party_Num;
141: CLOSE C_trx_number;
142: Fnd_File.Put_Line(Fnd_File.Log,x_Trx_Number||','||x_Third_Party_Name||','|| x_Third_Party_Num);
143:
144: /* SELECT Aca.Check_Number, Pv.Vendor_Name, Pv.Segment1
145: INTO x_Trx_Number, x_Third_Party_Name, x_Third_Party_Num
146: FROM Ap_Checks_All Aca,

Line 180: Fnd_File.Put_Line(Fnd_File.Log,l_invoice_id);

176: l_func_amount_array.EXTEND;
177: l_invoice_num_array(l_Invoice_idx):= l_invoice_num_temp;
178: l_func_amount_array(l_Invoice_idx):=l_func_amount;
179:
180: Fnd_File.Put_Line(Fnd_File.Log,l_invoice_id);
181: END LOOP;
182: CLOSE C_invoice_id;
183:
184: x_Invoice_Num:= l_invoice_num_array;

Line 219: FND_FILE.PUT_LINE(Fnd_File.Log,'AP'||SQLCODE || ':' || SQLERRM);

215: l_Module_Prefix || '.' || l_Proc_Name ||
216: '.Other_Exception AP',
217: SQLCODE || ':' || SQLERRM);
218: END IF; --(l_proc_level >= l_dbg_level)
219: FND_FILE.PUT_LINE(Fnd_File.Log,'AP'||SQLCODE || ':' || SQLERRM);
220: RAISE;
221: END Process_Ap_Detail;
222:
223: --==========================================================================

Line 397: FND_FILE.PUT_LINE(FND_FILE.LOG,

393: '.Other_Exception AR',
394: SQLCODE || ':' || SQLERRM);
395: END IF; --(l_proc_level >= l_dbg_level)
396: /*
397: FND_FILE.PUT_LINE(FND_FILE.LOG,
398: 'ar' ||sqlcode||sqlerrm);
399: fnd_file.put_line(fnd_file.log,'p_Ledger_Id:'||p_Ledger_Id||',p_Ae_Line_Num'||p_Ae_Line_Num||',p_Ae_Header_Id'||p_Ae_Header_Id);*/
400: RAISE;
401: END Process_Ar_Detail;

Line 399: fnd_file.put_line(fnd_file.log,'p_Ledger_Id:'||p_Ledger_Id||',p_Ae_Line_Num'||p_Ae_Line_Num||',p_Ae_Header_Id'||p_Ae_Header_Id);*/

395: END IF; --(l_proc_level >= l_dbg_level)
396: /*
397: FND_FILE.PUT_LINE(FND_FILE.LOG,
398: 'ar' ||sqlcode||sqlerrm);
399: fnd_file.put_line(fnd_file.log,'p_Ledger_Id:'||p_Ledger_Id||',p_Ae_Line_Num'||p_Ae_Line_Num||',p_Ae_Header_Id'||p_Ae_Header_Id);*/
400: RAISE;
401: END Process_Ar_Detail;
402: --==========================================================================
403: -- PROCEDURE NAME:

Line 759: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

755: FROM gl_ledgers
756: WHERE ledger_id=p_ledger_id;
757: --write the parameter infomation into variable
758: --l_xml_parameter and last into l_xml_report
759: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
760: -- '');
761: -- Updated by shujuan for bug 7626489
762: l_characterset :=Fnd_Profile.VALUE(NAME => 'ICX_CLIENT_IANA_ENCODING');
763: FND_FILE.put_line(FND_FILE.output,'');

Line 763: FND_FILE.put_line(FND_FILE.output,'');

759: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
760: -- '');
761: -- Updated by shujuan for bug 7626489
762: l_characterset :=Fnd_Profile.VALUE(NAME => 'ICX_CLIENT_IANA_ENCODING');
763: FND_FILE.put_line(FND_FILE.output,'');
764: --for start period
765: SELECT XMLELEMENT("P_START_PERIOD",
766: P_GL_PERIOD_FROM)
767: INTO L_XML_ITEM

Line 912: FND_FILE.PUT_LINE(FND_FILE.LOG,

908: L_XML_ROW := NULL;
909: L_XML_ROWS_ALL := NULL;
910: -- Fix bug #6854438 initiate variable end
911:
912: FND_FILE.PUT_LINE(FND_FILE.LOG,
913: 'l_period_name' || L_PERIOD_NAME);
914: FND_FILE.PUT_LINE(FND_FILE.LOG,
915: 'p_row_name' || P_ROW_NAME || P_SOURCE);
916:

Line 914: FND_FILE.PUT_LINE(FND_FILE.LOG,

910: -- Fix bug #6854438 initiate variable end
911:
912: FND_FILE.PUT_LINE(FND_FILE.LOG,
913: 'l_period_name' || L_PERIOD_NAME);
914: FND_FILE.PUT_LINE(FND_FILE.LOG,
915: 'p_row_name' || P_ROW_NAME || P_SOURCE);
916:
917: --initiate row amount
918: L_ROW_AMOUNT:=0;

Line 929: FND_FILE.PUT_LINE(FND_FILE.LOG,

925: LOOP
926: FETCH C_ROWS
927: INTO L_ROW_NAME;
928: EXIT WHEN C_ROWS%NOTFOUND;
929: FND_FILE.PUT_LINE(FND_FILE.LOG,
930: 'l_row_name' || L_ROW_NAME);
931: L_XML_ROW := NULL;
932: L_XML_ITEM:=null; --fix bug#7497957 add
933: l_dis_flag:=0;--fix bug 7487395 add