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.FUN_RECON_RPT_PKG dependencies on FND_FILE

Line 1039: fnd_file.put_line(fnd_file.output, '');

1035: ,p_rate_date => l_rate_date
1036: ,p_array_sql => l_array_sql);
1037:
1038: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1039: fnd_file.put_line(fnd_file.output, '');
1040: fnd_file.put_line(fnd_file.output, '');
1041:
1042: FOR i IN 1..l_array_sql.COUNT LOOP
1043: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1040: fnd_file.put_line(fnd_file.output, '');

1036: ,p_array_sql => l_array_sql);
1037:
1038: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1039: fnd_file.put_line(fnd_file.output, '');
1040: fnd_file.put_line(fnd_file.output, '');
1041:
1042: FOR i IN 1..l_array_sql.COUNT LOOP
1043: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1044: trace

Line 1080: fnd_file.put_line(fnd_file.log, l_array_sql(i));

1076: ,p_level =>C_LEVEL_EVENT
1077: ,p_module=>l_log_module);
1078: END IF;
1079:
1080: fnd_file.put_line(fnd_file.log, l_array_sql(i));
1081: fnd_file.put_line(fnd_file.log, ' ');
1082: fnd_file.put_line(fnd_file.log, '+===========================================================================+');
1083: fnd_file.put_line(fnd_file.log, ' ');
1084:

Line 1081: fnd_file.put_line(fnd_file.log, ' ');

1077: ,p_module=>l_log_module);
1078: END IF;
1079:
1080: fnd_file.put_line(fnd_file.log, l_array_sql(i));
1081: fnd_file.put_line(fnd_file.log, ' ');
1082: fnd_file.put_line(fnd_file.log, '+===========================================================================+');
1083: fnd_file.put_line(fnd_file.log, ' ');
1084:
1085: IF i = 2 -- forward relation query

Line 1082: fnd_file.put_line(fnd_file.log, '+===========================================================================+');

1078: END IF;
1079:
1080: fnd_file.put_line(fnd_file.log, l_array_sql(i));
1081: fnd_file.put_line(fnd_file.log, ' ');
1082: fnd_file.put_line(fnd_file.log, '+===========================================================================+');
1083: fnd_file.put_line(fnd_file.log, ' ');
1084:
1085: IF i = 2 -- forward relation query
1086: OR i = 6 -- reverse relation query

Line 1083: fnd_file.put_line(fnd_file.log, ' ');

1079:
1080: fnd_file.put_line(fnd_file.log, l_array_sql(i));
1081: fnd_file.put_line(fnd_file.log, ' ');
1082: fnd_file.put_line(fnd_file.log, '+===========================================================================+');
1083: fnd_file.put_line(fnd_file.log, ' ');
1084:
1085: IF i = 2 -- forward relation query
1086: OR i = 6 -- reverse relation query
1087: THEN

Line 1088: fnd_file.put_line(fnd_file.output, '');

1084:
1085: IF i = 2 -- forward relation query
1086: OR i = 6 -- reverse relation query
1087: THEN
1088: fnd_file.put_line(fnd_file.output, '');
1089:
1090: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1091: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SUMMARY_ROWSET');
1092: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SUMMARY_ROW');

Line 1104: fnd_file.put_line(fnd_file.output, '');

1100:
1101: ELSIF i = 3 -- forward relation query
1102: OR i = 7 -- reverse relation query
1103: THEN
1104: fnd_file.put_line(fnd_file.output, '');
1105:
1106: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1107: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_ROWSET');
1108: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_ROW');

Line 1113: fnd_file.put_line(fnd_file.output, '');

1109:
1110: ELSIF i = 4 -- forward relation query
1111: OR i = 8 -- reverse relation query
1112: THEN
1113: fnd_file.put_line(fnd_file.output, '');
1114:
1115: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1116: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_ROWSET');
1117: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_ROW');

Line 1122: fnd_file.put_line(fnd_file.output, '');

1118:
1119: ELSIF i = 5 -- forward relation query
1120: OR i = 9 -- reverse relation query
1121: THEN
1122: fnd_file.put_line(fnd_file.output, '');
1123:
1124: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1125: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_ROWSET');
1126: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_ROW');

Line 1132: fnd_file.put_line(fnd_file.output, '');

1128:
1129: ELSIF i = 10 -- forward relation query
1130: OR i = 13 -- reverse relation query
1131: THEN
1132: fnd_file.put_line(fnd_file.output, '');
1133:
1134: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1135: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLSOURCE_UNMATCHED_ROWSET');
1136: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JRNLSOURCE_UNMATCHED_ROW');

Line 1141: fnd_file.put_line(fnd_file.output, '');

1137:
1138: ELSIF i = 11 -- forward relation query
1139: OR i = 14 -- reverse relation query
1140: THEN
1141: fnd_file.put_line(fnd_file.output, '');
1142:
1143: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1144: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_JRNLDETAILS_UNMATCHED_ROWSET');
1145: DBMS_XMLGEN.setRowTag(l_ctx, 'G_JOURNAL_UNMATCHED_ROW');

Line 1150: fnd_file.put_line(fnd_file.output, '');

1146:
1147: ELSIF i = 12 -- forward relation query
1148: OR i = 15 -- reverse relation query
1149: THEN
1150: fnd_file.put_line(fnd_file.output, '');
1151:
1152: l_ctx := DBMS_XMLGEN.newContext(l_array_sql(i));
1153: DBMS_XMLGEN.setRowSetTag(l_ctx,'G_SLADETAILS_UNMATCHED_ROWSET');
1154: DBMS_XMLGEN.setRowTag(l_ctx, 'G_SLA_UNMATCHED_ROW');

Line 1172: fnd_file.put_line(fnd_file.output, '');

1168: END IF;
1169:
1170: IF l_xml_clob IS NULL THEN
1171: IF i = 2 OR i = 6 THEN
1172: fnd_file.put_line(fnd_file.output, '');
1173: ELSIF i = 3 OR i = 7 THEN
1174: fnd_file.put_line(fnd_file.output, '');
1175: ELSIF i = 4 OR i = 8 THEN
1176: fnd_file.put_line(fnd_file.output, '');

Line 1174: fnd_file.put_line(fnd_file.output, '');

1170: IF l_xml_clob IS NULL THEN
1171: IF i = 2 OR i = 6 THEN
1172: fnd_file.put_line(fnd_file.output, '');
1173: ELSIF i = 3 OR i = 7 THEN
1174: fnd_file.put_line(fnd_file.output, '');
1175: ELSIF i = 4 OR i = 8 THEN
1176: fnd_file.put_line(fnd_file.output, '');
1177: ELSIF i = 5 OR i = 9 THEN
1178: fnd_file.put_line(fnd_file.output, '');

Line 1176: fnd_file.put_line(fnd_file.output, '');

1172: fnd_file.put_line(fnd_file.output, '');
1173: ELSIF i = 3 OR i = 7 THEN
1174: fnd_file.put_line(fnd_file.output, '');
1175: ELSIF i = 4 OR i = 8 THEN
1176: fnd_file.put_line(fnd_file.output, '');
1177: ELSIF i = 5 OR i = 9 THEN
1178: fnd_file.put_line(fnd_file.output, '');
1179: ELSIF i = 10 OR i = 13 THEN
1180: fnd_file.put_line(fnd_file.output, '');

Line 1178: fnd_file.put_line(fnd_file.output, '');

1174: fnd_file.put_line(fnd_file.output, '');
1175: ELSIF i = 4 OR i = 8 THEN
1176: fnd_file.put_line(fnd_file.output, '');
1177: ELSIF i = 5 OR i = 9 THEN
1178: fnd_file.put_line(fnd_file.output, '');
1179: ELSIF i = 10 OR i = 13 THEN
1180: fnd_file.put_line(fnd_file.output, '');
1181: ELSIF i = 11 OR i = 14 THEN
1182: fnd_file.put_line(fnd_file.output, '');

Line 1180: fnd_file.put_line(fnd_file.output, '');

1176: fnd_file.put_line(fnd_file.output, '');
1177: ELSIF i = 5 OR i = 9 THEN
1178: fnd_file.put_line(fnd_file.output, '');
1179: ELSIF i = 10 OR i = 13 THEN
1180: fnd_file.put_line(fnd_file.output, '');
1181: ELSIF i = 11 OR i = 14 THEN
1182: fnd_file.put_line(fnd_file.output, '');
1183: ELSIF i = 12 OR i = 15 THEN
1184: fnd_file.put_line(fnd_file.output, '');

Line 1182: fnd_file.put_line(fnd_file.output, '');

1178: fnd_file.put_line(fnd_file.output, '');
1179: ELSIF i = 10 OR i = 13 THEN
1180: fnd_file.put_line(fnd_file.output, '');
1181: ELSIF i = 11 OR i = 14 THEN
1182: fnd_file.put_line(fnd_file.output, '');
1183: ELSIF i = 12 OR i = 15 THEN
1184: fnd_file.put_line(fnd_file.output, '');
1185: END IF;
1186: END IF;

Line 1184: fnd_file.put_line(fnd_file.output, '');

1180: fnd_file.put_line(fnd_file.output, '');
1181: ELSIF i = 11 OR i = 14 THEN
1182: fnd_file.put_line(fnd_file.output, '');
1183: ELSIF i = 12 OR i = 15 THEN
1184: fnd_file.put_line(fnd_file.output, '');
1185: END IF;
1186: END IF;
1187:
1188: fun_recon_rpt_pkg.clob_to_file

Line 1192: fnd_file.put_line(fnd_file.output, '');

1188: fun_recon_rpt_pkg.clob_to_file
1189: (p_xml_clob => l_xml_clob);
1190: END LOOP;
1191:
1192: fnd_file.put_line(fnd_file.output, '');
1193:
1194: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1195: trace
1196: (p_msg =>'run_fun_report.End'

Line 1883: fnd_file.put

1879: l_chunk_size := 3000;
1880:
1881: WHILE (l_clob_size > 0) LOOP
1882: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);
1883: fnd_file.put
1884: (which => fnd_file.output
1885: ,buff => l_chunk);
1886:
1887: l_clob_size := l_clob_size - l_chunk_size;

Line 1884: (which => fnd_file.output

1880:
1881: WHILE (l_clob_size > 0) LOOP
1882: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);
1883: fnd_file.put
1884: (which => fnd_file.output
1885: ,buff => l_chunk);
1886:
1887: l_clob_size := l_clob_size - l_chunk_size;
1888: l_offset := l_offset + l_chunk_size;

Line 1891: fnd_file.new_line(fnd_file.output,1);

1887: l_clob_size := l_clob_size - l_chunk_size;
1888: l_offset := l_offset + l_chunk_size;
1889: END LOOP;
1890:
1891: fnd_file.new_line(fnd_file.output,1);
1892:
1893: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1894: trace
1895: (p_msg => 'END of procedure CLOB_TO_FILE'