DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on FND_FILE

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

1605: RPAD(SUBSTR(trx_details_rec.unt_iss,1,2),2,' '))|| DECODE(trx_details_rec.unt_prc,NULL,RPAD('0',14,'0'),
1606: REPLACE(TO_CHAR(trx_details_rec.unt_prc,'FM099999999999D00') ,'.',''))|| RPAD(' ',15) trx_line_rec
1607: INTO l_trx_detail_rec
1608: FROM dual ;
1609: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_trx_detail_rec);
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: errcode :=SQLCODE;
1613: errmsg :=SQLERRM || 'Error in Creating the Detail Record ' || '- Procedure: create_trx_dtl_rec';

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

1658: ELSE
1659: ussgl_rec.cr_dr_flag := 'D';
1660: END IF;
1661: 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;
1662: fnd_file.put_line (fnd_file.output, l_output_string);
1663: END LOOP ; --END of USSGL record
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: errcode :=SQLCODE;

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

2670: IF l_fetch_count = 0 THEN
2671: RETURN;
2672: END IF;
2673: DBMS_SQL.COLUMN_VALUE(v_cursor_id, 1, col1);
2674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);
2675: END LOOP;
2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN