eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on FND_LOOKUPS

Line 576: * The Return Code and Description are stored in FND_LOOKUPS where the

572: * on the interface table corresponding to the status of the transfer.
573: * For successful transfers, the corresponding Reference Code is also
574: * recorded on the interface table.
575: *
576: * The Return Code and Description are stored in FND_LOOKUPS where the
577: * lookup_type = 'XTR_MDTSF_RTN_CODES'
578: */
579: PROCEDURE market_data_transfer (p_upd_date_missing IN VARCHAR2,
580: p_upd_history IN VARCHAR2) IS

Line 704: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE

700: IF v_e_count = 1 THEN
701: put_header;
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||', '

Line 720: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE

716: v_e_count := v_e_count + 1;
717: IF v_e_count = 1 THEN
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||', '

Line 738: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE

734: v_e_count := v_e_count + 1;
735: IF v_e_count = 1 THEN
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||', '

Line 771: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE

767: v_e_count := v_e_count + 1;
768: IF v_e_count = 1 THEN
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||', '

Line 790: SELECT description INTO v_trans_stat FROM fnd_lookups WHERE

786: v_e_count := v_e_count + 1;
787: IF v_e_count = 1 THEN
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||', '