DBA Data[Home] [Help]

APPS.INV_MGD_MVT_EXPORT_DATA dependencies on FND_FILE

Line 198: --FND_FILE.Put_Names('yawang.log','yawang.out','/sqlcom/mgdev115');

194: );
195: END IF;
196:
197: --Temporary file for unit test,will remove after using concurrent pgm
198: --FND_FILE.Put_Names('yawang.log','yawang.out','/sqlcom/mgdev115');
199:
200: --Get base currency
201: l_base_currency := INV_MGD_MVT_UTILS_PKG.Get_LE_Currency(p_legal_entity_id);
202:

Line 477: FND_FILE.Put_Line(FND_FILE.Output, NVL(RPAD(mvt_rec.commodity_code,8), ' ')

473:
474: --l_invoice_val_fore_conv := TO_CHAR(l_invoice_value_foreign,'FM9999999999999990D00');
475: END IF;
476:
477: FND_FILE.Put_Line(FND_FILE.Output, NVL(RPAD(mvt_rec.commodity_code,8), ' ')
478: ||NVL(RPAD(l_cons_country, 2), ' ')
479: ||NVL(RPAD(l_cons_eu_country, 3), ' ')
480: ||NVL(RPAD(mvt_rec.transaction_nature,2), ' ')
481: ||NVL(RPAD(mvt_rec.transport_mode,1), ' ')

Line 499: --FND_FILE.Close;

495: ||NVL(mvt_rec.comments, ''));
496:
497:
498: END LOOP;
499: --FND_FILE.Close;
500:
501: --Check if process_rec_count is greate than 0, if yes then update
502: --movement status to Exported,else print "No Data Found" in output file
503: IF l_process_rec_count > 0

Line 514: --FND_FILE.Put_Names('yawang.log','yawang.out','/sqlcom/mgdev115');

510: AND report_reference = to_char(p_legal_entity_id)||p_zone_code
511: ||p_period_name||p_usage_type
512: ||p_stat_type||p_movement_type;
513: ELSE
514: --FND_FILE.Put_Names('yawang.log','yawang.out','/sqlcom/mgdev115');
515: FND_FILE.Put_Line(FND_FILE.Output, 'No Data Found');
516: --FND_FILE.Close;
517: END IF;
518:

Line 515: FND_FILE.Put_Line(FND_FILE.Output, 'No Data Found');

511: ||p_period_name||p_usage_type
512: ||p_stat_type||p_movement_type;
513: ELSE
514: --FND_FILE.Put_Names('yawang.log','yawang.out','/sqlcom/mgdev115');
515: FND_FILE.Put_Line(FND_FILE.Output, 'No Data Found');
516: --FND_FILE.Close;
517: END IF;
518:
519: --Commit the Operation

Line 516: --FND_FILE.Close;

512: ||p_stat_type||p_movement_type;
513: ELSE
514: --FND_FILE.Put_Names('yawang.log','yawang.out','/sqlcom/mgdev115');
515: FND_FILE.Put_Line(FND_FILE.Output, 'No Data Found');
516: --FND_FILE.Close;
517: END IF;
518:
519: --Commit the Operation
520: COMMIT;