DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on FND_FILE

Line 1650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_trx_detail_rec);

1646: RPAD(SUBSTR(trx_details_rec.unt_iss,1,2),2,' '))|| DECODE(trx_details_rec.unt_prc,NULL,RPAD('0',14,'0'),
1647: REPLACE(TO_CHAR(trx_details_rec.unt_prc,'FM099999999999D00') ,'.',''))|| RPAD(' ',15) trx_line_rec
1648: INTO l_trx_detail_rec
1649: FROM dual ;
1650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_trx_detail_rec);
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: errcode :=SQLCODE;
1654: errmsg :=SQLERRM || 'Error in Creating the Detail Record ' || '- Procedure: create_trx_dtl_rec';

Line 1703: fnd_file.put_line (fnd_file.output, l_output_string);

1699: ELSE
1700: ussgl_rec.cr_dr_flag := 'D';
1701: END IF;
1702: l_output_string := 'E' || 'A' || LPAD (ussgl_rec.sgl_acct_num, 4,0) || 'S' || 'F' || LPAD(REPLACE(ussgl_rec.amount*100,'-',NULL),14,0) || ussgl_rec.cr_dr_flag;
1703: fnd_file.put_line (fnd_file.output, l_output_string);
1704: END LOOP ; --END of USSGL record
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: errcode :=SQLCODE;

Line 2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);

2741: IF l_fetch_count = 0 THEN
2742: RETURN;
2743: END IF;
2744: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);
2746: END LOOP;
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN