APPS.ARP_RECON_REP dependencies on FND_FILE

Line 10: FND_FILE.put_line(fnd_file.log,msg_txt);

6:
7: PROCEDURE log(msg_txt IN VARCHAR2) IS
8: BEGIN
9: IF (PG_DEBUG='Y' AND LOG_LEVEL='1') THEN
10: FND_FILE.put_line(fnd_file.log,msg_txt);
11: END IF;
12: END log;
13:
14: /*========================================================================+

Line 1470: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);

1466: '||l_source_type_ard_where||'
1467: '||l_posting_status_nul_where||')';
1468:
1469: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
1470: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
1471: l_xml_query := to_clob(l_xml_build_sql);
1472:
1473: l_xml_build_sql := 'UNION
1474: (select /*+ leading(crh) index(crh AR_CASH_RECEIPT_HISTORY_N2) index(ps AR_PAYMENT_SCHEDULES_U2)*/

Line 1633: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);

1629: '||l_account_seg_where ||'
1630: '||l_posting_status_crh_where||')';
1631:
1632: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
1633: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
1634: l_xml_query := l_xml_query||to_clob(l_xml_build_sql);
1635:
1636: l_xml_build_sql := 'UNION
1637: (select /*+ leading(ra) index(ra AR_RECEIVABLE_APPLICATIONS_N6) index(ps AR_PAYMENT_SCHEDULES_U2)*/

Line 1881: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);

1877: '||l_account_seg_where ||'
1878: '||l_posting_status_nul_where||')';
1879:
1880: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
1881: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
1882: l_xml_query := l_xml_query||to_clob(l_xml_build_sql);
1883:
1884: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
1885: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));

Line 2727: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);

2723: '||l_source_type_ard_where||'
2724: '||l_posting_status_nul_where;
2725:
2726: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
2727: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
2728: l_xml_query := to_clob(l_xml_build_sql);
2729:
2730: l_xml_build_sql :='UNION ALL
2731: select cr.receipt_number payment_number,

Line 2991: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);

2987: '||l_posting_status_nul_where;
2988:
2989: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
2990: l_xml_query := l_xml_query||to_clob(l_xml_build_sql);
2991: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
2992:
2993: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
2994: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2995: