APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on FND_FILE

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG,v_source_h ||', '||v_ext_ref_h||', '

538: module_name='XTRMDTRP' AND canvas_type='TEXT' AND ITEM_NAME = 'P_DATE';
539: SELECT text INTO v_trans_stat_h FROM xtr_sys_languages_vl WHERE
540: module_name='XTRMDTRP' AND canvas_type='TEXT' AND ITEM_NAME =
541: 'P_TRANSFER_STATUS';
542: FND_FILE.PUT_LINE(FND_FILE.LOG,v_source_h ||', '||v_ext_ref_h||', '
543: ||v_bid_h||', '||v_ask_h||', '||v_mid_h||', '||v_spread_h||', '
544: ||v_date_h||', '||v_trans_stat_h);
545: END put_header;
546:

Line 706: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||

702: END IF;
703:
704: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE
705: lookup_type= 'XTR_MDTSF_RTN_CODES'AND lookup_code= '90';
706: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||
707: v_mdi_rec.external_ref_code||', '||v_mdi_rec.bid||', '||v_mdi_rec.ask
708: ||', '||v_mdi_rec.mid||', '||v_mdi_rec.spread||', '
709: ||v_mdi_rec.datetime||', '||v_trans_stat||' [90]');
710:

Line 722: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||

718: put_header;
719: END IF;
720: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE
721: lookup_type= 'XTR_MDTSF_RTN_CODES'AND lookup_code= '50';
722: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||
723: v_mdi_rec.external_ref_code||', '||v_mdi_rec.bid||', '||v_mdi_rec.ask
724: ||', '||v_mdi_rec.mid||', '||v_mdi_rec.spread||', '
725: ||v_mdi_rec.datetime||', '||v_trans_stat||' [50]');
726:

Line 740: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||

736: put_header;
737: END IF;
738: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE
739: lookup_type= 'XTR_MDTSF_RTN_CODES'AND lookup_code= '60';
740: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||
741: v_mdi_rec.external_ref_code||', '||v_mdi_rec.bid||', '||v_mdi_rec.ask
742: ||', '||v_mdi_rec.mid||', '||v_mdi_rec.spread||', '
743: ||v_mdi_rec.datetime||', '||v_trans_stat||' [60]');
744:

Line 773: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||

769: put_header;
770: END IF;
771: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE
772: lookup_type= 'XTR_MDTSF_RTN_CODES'AND lookup_code= '70';
773: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||
774: v_mdi_rec.external_ref_code||', '||v_mdi_rec.bid||', '||v_mdi_rec.ask
775: ||', '||v_mdi_rec.mid||', '||v_mdi_rec.spread||', '
776: ||v_mdi_rec.datetime||', '||v_trans_stat||' [70]');
777: END IF;

Line 792: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||

788: put_header;
789: END IF;
790: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE
791: lookup_type= 'XTR_MDTSF_RTN_CODES'AND lookup_code= '80';
792: FND_FILE.PUT_LINE(FND_FILE.LOG,v_mdi_rec.source||', '||
793: v_mdi_rec.external_ref_code||', '||v_mdi_rec.bid||', '||v_mdi_rec.ask
794: ||', '||v_mdi_rec.mid||', '||v_mdi_rec.spread||', '
795: ||v_mdi_rec.datetime||', '||v_trans_stat||' [80]');
796: ELSE

Line 869: FND_FILE.put_line(FND_FILE.LOG,'invalid parameter error. You must enter A,N, or C for the first parameter and Y or N for the second');

865: END LOOP;
866:
867: EXCEPTION
868: WHEN e_inv THEN
869: FND_FILE.put_line(FND_FILE.LOG,'invalid parameter error. You must enter A,N, or C for the first parameter and Y or N for the second');
870:
871: END market_data_transfer;
872:
873:

Line 954: Fnd_File.Put_Line(Fnd_file.LOG,Avr_Buff);

950:
951:
952: Procedure Put_Log(Avr_Buff In Varchar2) is
953: Begin
954: Fnd_File.Put_Line(Fnd_file.LOG,Avr_Buff);
955: End;
956: PROCEDURE populate_rate(p_currency VARCHAR2,
957: p_date DATE,
958: p_bid_rate NUMBER,