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

Line 249: fnd_file.put_line(fnd_file.log, '*Parameters**');

245: p_module => g_block||'.Generate_XML()',
246: p_msg_text => 'BEGIN');
247:
248: dim := 'DIMENSION';
249: fnd_file.put_line(fnd_file.log, '***************************Parameters****************************');
250: fnd_file.put_line(fnd_file.log, '* DI Object Def Id : ' || to_char(p_diObjDefId));
251:
252: /*****************************************************************
253: Get the Table name

Line 250: fnd_file.put_line(fnd_file.log, '* DI Object Def Id : ' || to_char(p_diObjDefId));

246: p_msg_text => 'BEGIN');
247:
248: dim := 'DIMENSION';
249: fnd_file.put_line(fnd_file.log, '***************************Parameters****************************');
250: fnd_file.put_line(fnd_file.log, '* DI Object Def Id : ' || to_char(p_diObjDefId));
251:
252: /*****************************************************************
253: Get the Table name
254: *****************************************************************/

Line 268: fnd_file.put_line(fnd_file.log,'* Condition Id: ' || l_condition_obj_id);

264: OPEN get_condition_obj_id_cursor;
265: FETCH get_condition_obj_id_cursor INTO l_condition_obj_id,l_condition_name ;
266: CLOSE get_condition_obj_id_cursor;
267:
268: fnd_file.put_line(fnd_file.log,'* Condition Id: ' || l_condition_obj_id);
269:
270: /*****************************************************************
271: Get the DI Name.
272: *****************************************************************/

Line 278: fnd_file.put_line(fnd_file.log,'* DI Name: ' || l_di_name);

274: OPEN get_di_name_csr;
275: FETCH get_di_name_csr INTO l_di_name;
276: CLOSE get_di_name_csr;
277:
278: fnd_file.put_line(fnd_file.log,'* DI Name: ' || l_di_name);
279:
280: /*****************************************************************
281: Get the Condition predicate.
282: *****************************************************************/

Line 288: fnd_file.put_line(fnd_file.log,'* Condition Predicate: ' || whereClause);

284: IF l_condition_obj_id IS NOT NULL THEN
285: getConditionPredicate(l_condition_obj_id,l_tableName,whereClause);
286: END IF;
287:
288: fnd_file.put_line(fnd_file.log,'* Condition Predicate: ' || whereClause);
289:
290:
291: /*****************************************************************
292: Get the table display name.

Line 299: fnd_file.put_line(fnd_file.log,'* Table Display Name: ' || l_table_display_name);

295: OPEN get_table_display_name_cursor;
296: FETCH get_table_display_name_cursor INTO l_table_display_name;
297: CLOSE get_table_display_name_cursor;
298:
299: fnd_file.put_line(fnd_file.log,'* Table Display Name: ' || l_table_display_name);
300:
301:
302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);
303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);

Line 302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);

298:
299: fnd_file.put_line(fnd_file.log,'* Table Display Name: ' || l_table_display_name);
300:
301:
302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);
303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);
304: fnd_file.put_line(fnd_file.log,'* Execute: ' || p_mode);
305: fnd_file.put_line(fnd_file.log,'***************************Parameters****************************');
306: fnd_file.put_line(fnd_file.log,' ');

Line 303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);

299: fnd_file.put_line(fnd_file.log,'* Table Display Name: ' || l_table_display_name);
300:
301:
302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);
303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);
304: fnd_file.put_line(fnd_file.log,'* Execute: ' || p_mode);
305: fnd_file.put_line(fnd_file.log,'***************************Parameters****************************');
306: fnd_file.put_line(fnd_file.log,' ');
307:

Line 304: fnd_file.put_line(fnd_file.log,'* Execute: ' || p_mode);

300:
301:
302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);
303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);
304: fnd_file.put_line(fnd_file.log,'* Execute: ' || p_mode);
305: fnd_file.put_line(fnd_file.log,'***************************Parameters****************************');
306: fnd_file.put_line(fnd_file.log,' ');
307:
308: /*****************************************************************

Line 305: fnd_file.put_line(fnd_file.log,'*Parameters**');

301:
302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);
303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);
304: fnd_file.put_line(fnd_file.log,'* Execute: ' || p_mode);
305: fnd_file.put_line(fnd_file.log,'***************************Parameters****************************');
306: fnd_file.put_line(fnd_file.log,' ');
307:
308: /*****************************************************************
309: Add header details to CLOB

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

302: fnd_file.put_line(fnd_file.log,'* Show: ' || p_view);
303: fnd_file.put_line(fnd_file.log,'* Compute Column Totals: ' || p_comp_totals);
304: fnd_file.put_line(fnd_file.log,'* Execute: ' || p_mode);
305: fnd_file.put_line(fnd_file.log,'***************************Parameters****************************');
306: fnd_file.put_line(fnd_file.log,' ');
307:
308: /*****************************************************************
309: Add header details to CLOB
310: *****************************************************************/

Line 347: fnd_file.put_line(fnd_file.log,'Bal Sum Query: ' || l_bal_sum_query);

343: IF whereClause IS NOT NULL THEN
344: l_bal_sum_query := l_bal_sum_query || ' WHERE ' || whereClause;
345: END IF;
346:
347: fnd_file.put_line(fnd_file.log,'Bal Sum Query: ' || l_bal_sum_query);
348: fnd_file.put_line(fnd_file.log,' ');
349: EXECUTE IMMEDIATE l_bal_sum_query INTO l_bal_sum;
350: l_xmlString := l_xmlString || ' ' || l_bal_sum ||' ';
351:

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

344: l_bal_sum_query := l_bal_sum_query || ' WHERE ' || whereClause;
345: END IF;
346:
347: fnd_file.put_line(fnd_file.log,'Bal Sum Query: ' || l_bal_sum_query);
348: fnd_file.put_line(fnd_file.log,' ');
349: EXECUTE IMMEDIATE l_bal_sum_query INTO l_bal_sum;
350: l_xmlString := l_xmlString || ' ' || l_bal_sum ||' ';
351:
352: ELSE

Line 382: --fnd_file.put_line(fnd_file.log,l_queryString);

378: ' where ' || row_record.TABLE_NAME || '.' || 'ROWID' || ' = ' || 'a' || '.' || 'ROWID'
379: || ' ) as col , ' ;
380:
381: END IF;
382: --fnd_file.put_line(fnd_file.log,l_queryString);
383: dbms_lob.writeappend(selectClause,LENGTH(l_queryString),l_queryString);
384: dbms_lob.writeappend(l_metadata_xml,LENGTH(l_xmlString),l_xmlString);
385:
386: END LOOP;

Line 409: --fnd_file.put_line(fnd_file.log,'After appending to l_query');

405: --l_query := 'SELECT ' || selectclause || ' FROM ' || l_tablename || ' a';
406:
407: l_queryString := 'SELECT ';
408: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
409: --fnd_file.put_line(fnd_file.log,'After appending to l_query');
410: dbms_lob.append(l_query,selectClause);
411: l_queryString := ' FROM ' || l_tablename || ' a';
412: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
413:

Line 453: fnd_file.put_line(fnd_file.log, 'The final query : ');

449: l_queryString := SUBSTR(l_queryString, 1, LENGTH(l_queryString) - 1);
450: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
451: END IF;
452:
453: fnd_file.put_line(fnd_file.log, 'The final query : ');
454: --fnd_file.put_line(fnd_file.log,l_query);
455:
456:
457:

Line 454: --fnd_file.put_line(fnd_file.log,l_query);

450: dbms_lob.writeappend(l_query,LENGTH(l_queryString),l_queryString);
451: END IF;
452:
453: fnd_file.put_line(fnd_file.log, 'The final query : ');
454: --fnd_file.put_line(fnd_file.log,l_query);
455:
456:
457:
458: /**************************************************

Line 461: fnd_file.put_line(fnd_file.log,'XML******************');

457:
458: /**************************************************
459: Get the xml.
460: **************************************************/
461: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
462:
463: queryCtx := DBMS_XMLQuery.newContext(l_query);
464: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
465: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');

Line 501: --fnd_file.put_line(fnd_file.log,l_chunk);

497:
498: WHILE (l_clob_size > 0) LOOP
499:
500: l_chunk := dbms_lob.substr (l_metadata_xml, l_chunk_size, l_offset);
501: --fnd_file.put_line(fnd_file.log,l_chunk);
502: fnd_file.put(
503: which => fnd_file.output,
504: buff => l_chunk);
505: l_clob_size := l_clob_size - l_chunk_size;

Line 502: fnd_file.put(

498: WHILE (l_clob_size > 0) LOOP
499:
500: l_chunk := dbms_lob.substr (l_metadata_xml, l_chunk_size, l_offset);
501: --fnd_file.put_line(fnd_file.log,l_chunk);
502: fnd_file.put(
503: which => fnd_file.output,
504: buff => l_chunk);
505: l_clob_size := l_clob_size - l_chunk_size;
506: l_offset := l_offset + l_chunk_size;

Line 503: which => fnd_file.output,

499:
500: l_chunk := dbms_lob.substr (l_metadata_xml, l_chunk_size, l_offset);
501: --fnd_file.put_line(fnd_file.log,l_chunk);
502: fnd_file.put(
503: which => fnd_file.output,
504: buff => l_chunk);
505: l_clob_size := l_clob_size - l_chunk_size;
506: l_offset := l_offset + l_chunk_size;
507:

Line 525: fnd_file.put_line(fnd_file.log,sqlerrm);

521: dbms_lob.freetemporary(l_metadata_xml);
522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: fnd_file.put_line(fnd_file.log,sqlerrm);
526: fem_engines_pkg.tech_message (p_severity => g_log_level_1,
527: p_module => g_block||'.Generate_XML()',
528: p_msg_text => 'EXCEPTION BLOCK:'||sqlerrm);
529:

Line 675: fnd_file.put_line(fnd_file.log, 'DI Object Def Id:' || to_char(p_diObjDefId));

671: p_msg_text => 'BEGIN');
672:
673:
674: dim := 'DIMENSION';
675: fnd_file.put_line(fnd_file.log, 'DI Object Def Id:' || to_char(p_diObjDefId));
676: fnd_file.put_line(fnd_file.log, 'View:'||p_view);
677:
678: /*****************************************************************
679: Get the Table name

Line 676: fnd_file.put_line(fnd_file.log, 'View:'||p_view);

672:
673:
674: dim := 'DIMENSION';
675: fnd_file.put_line(fnd_file.log, 'DI Object Def Id:' || to_char(p_diObjDefId));
676: fnd_file.put_line(fnd_file.log, 'View:'||p_view);
677:
678: /*****************************************************************
679: Get the Table name
680: *****************************************************************/

Line 704: fnd_file.put_line(fnd_file.log,'Condition predicate is:' || whereClause);

700: IF l_condition_obj_id IS NOT NULL THEN
701: getConditionPredicate(l_condition_obj_id,l_tableName,whereClause);
702: END IF;
703:
704: fnd_file.put_line(fnd_file.log,'Condition predicate is:' || whereClause);
705:
706: dbms_lob.createtemporary(selectClause,TRUE);
707: dbms_lob.createtemporary(l_query,TRUE);
708: l_queryString := 'SELECT ';

Line 787: fnd_file.put_line(fnd_file.log, 'Final query:');

783: l_query := p_diQuery;
784:
785: END IF;
786:
787: fnd_file.put_line(fnd_file.log, 'Final query:');
788: --fnd_file.put_line(fnd_file.log,l_query);
789:
790: /**************************************************
791: Get the xml.

Line 788: --fnd_file.put_line(fnd_file.log,l_query);

784:
785: END IF;
786:
787: fnd_file.put_line(fnd_file.log, 'Final query:');
788: --fnd_file.put_line(fnd_file.log,l_query);
789:
790: /**************************************************
791: Get the xml.
792: **************************************************/

Line 793: fnd_file.put_line(fnd_file.log,'XML******************');

789:
790: /**************************************************
791: Get the xml.
792: **************************************************/
793: fnd_file.put_line(fnd_file.log,'************************************XML******************************************************');
794:
795: queryCtx := DBMS_XMLQuery.newContext(l_query);
796: DBMS_XMLQuery.setRowsetTag(queryCtx, 'Extracted_Records');
797: DBMS_XMLQuery.setRowTag(queryCtx, 'Row');

Line 809: --fnd_file.put_line(fnd_file.log,l_chunk);

805:
806: WHILE (l_clob_size > 0) LOOP
807:
808: l_chunk := dbms_lob.substr (l_xmlResult, l_chunk_size, l_offset);
809: --fnd_file.put_line(fnd_file.log,l_chunk);
810: fnd_file.put(
811: which => fnd_file.output,
812: buff => l_chunk);
813: l_clob_size := l_clob_size - l_chunk_size;

Line 810: fnd_file.put(

806: WHILE (l_clob_size > 0) LOOP
807:
808: l_chunk := dbms_lob.substr (l_xmlResult, l_chunk_size, l_offset);
809: --fnd_file.put_line(fnd_file.log,l_chunk);
810: fnd_file.put(
811: which => fnd_file.output,
812: buff => l_chunk);
813: l_clob_size := l_clob_size - l_chunk_size;
814: l_offset := l_offset + l_chunk_size;

Line 811: which => fnd_file.output,

807:
808: l_chunk := dbms_lob.substr (l_xmlResult, l_chunk_size, l_offset);
809: --fnd_file.put_line(fnd_file.log,l_chunk);
810: fnd_file.put(
811: which => fnd_file.output,
812: buff => l_chunk);
813: l_clob_size := l_clob_size - l_chunk_size;
814: l_offset := l_offset + l_chunk_size;
815:

Line 832: fnd_file.put_line(fnd_file.log,sqlerrm);

828:
829:
830: EXCEPTION
831: WHEN OTHERS THEN
832: fnd_file.put_line(fnd_file.log,sqlerrm);
833: fem_engines_pkg.tech_message (p_severity => g_log_level_1,
834: p_module => g_block||'.Generate_Cust_XML()',
835: p_msg_text => 'EXCEPTION BLOCK:'||sqlerrm);
836: