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

Line 15: fnd_file.put_line( fnd_file.log, pBUFF);

11: is
12: begin
13:
14: if C_MSC_DEBUG = 'Y' then
15: fnd_file.put_line( fnd_file.log, pBUFF);
16: else
17: null;
18: --dbms_output.put_line( pBUFF);
19: end if;

Line 27: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);

23: PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2)
24: IS
25: BEGIN
26:
27: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
28:
29: END LOG_MESSAGE;
30:
31: Procedure ins( a in varchar2) is

Line 409: fnd_file.put_line(fnd_file.log,'View ' || p_source_table || ' does not exist on the source');

405: exception
406: WHEN others THEN
407: v_view_exist := 0;
408: retcode := 1;
409: fnd_file.put_line(fnd_file.log,'View ' || p_source_table || ' does not exist on the source');
410: end;
411:
412: /* Insert Level Values into staging table */
413: v_sql_stmt := 'insert /*+ ALL_ROWS */ into ' || p_dest_table || ' ( ' ||

Line 510: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

506: exception
507: when NO_DATA_FOUND then
508: null;
509: WHEN others THEN
510: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
511: errbuf := substr(SQLERRM,1,150);
512: end ;
513:
514:

Line 564: --fnd_file.put_line(fnd_file.log,'came here' || p_update_lvl_table ||' ' || MSD_COMMON_UTILITIES.COLLECT_ILP);

560: where level_id = p_level_id
561: and plan_type is null; --vinekuma
562:
563: IF ((p_update_lvl_table = 1 and MSD_COMMON_UTILITIES.COLLECT_ILP = 2) or MSD_COMMON_UTILITIES.COLLECT_ILP = 3) THEN /* IF 1 */
564: --fnd_file.put_line(fnd_file.log,'came here' || p_update_lvl_table ||' ' || MSD_COMMON_UTILITIES.COLLECT_ILP);
565:
566: IF (p_level_id = 1 OR p_level_id = 3) THEN /* IF 2 */
567:
568: CREATE_ITEM_LIST_PRICE(

Line 626: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

622: ins('ERROR ' || v_sql_stmt);
623: debug_line('ERROR ' || v_sql_stmt);
624: ins('ERROR ' || errbuf);
625: debug_line('ERROR ' || errbuf);
626: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
627: fnd_file.put_line(fnd_file.log, 'The offending sql is:');
628: fnd_file.put_line(fnd_file.log, v_sql_stmt);
629: rollback;
630: -- rollback to Savepoint Before_Delete ;

Line 627: fnd_file.put_line(fnd_file.log, 'The offending sql is:');

623: debug_line('ERROR ' || v_sql_stmt);
624: ins('ERROR ' || errbuf);
625: debug_line('ERROR ' || errbuf);
626: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
627: fnd_file.put_line(fnd_file.log, 'The offending sql is:');
628: fnd_file.put_line(fnd_file.log, v_sql_stmt);
629: rollback;
630: -- rollback to Savepoint Before_Delete ;
631:

Line 628: fnd_file.put_line(fnd_file.log, v_sql_stmt);

624: ins('ERROR ' || errbuf);
625: debug_line('ERROR ' || errbuf);
626: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
627: fnd_file.put_line(fnd_file.log, 'The offending sql is:');
628: fnd_file.put_line(fnd_file.log, v_sql_stmt);
629: rollback;
630: -- rollback to Savepoint Before_Delete ;
631:
632: End translate_level_parent_values ;

Line 789: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

785: EXCEPTION
786: when others then
787: errbuf := substr(SQLERRM,1,150);
788: retcode := -1;
789: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
790:
791:
792: END PROCESS_LEVEL_VALUE_PER_ROW;
793:

Line 865: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

861: EXCEPTION
862: when others then
863: errbuf := substr(SQLERRM,1,150);
864: retcode := -1;
865: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
866:
867:
868:
869: END CREATE_DELETED_LEVEL_VALUES;

Line 982: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

978: EXCEPTION
979: when others then
980: errbuf := substr(SQLERRM,1,150);
981: retcode := -1;
982: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
983:
984:
985: END PROCESS_LEVEL_ASSOCIATION;
986:

Line 1041: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1037: EXCEPTION
1038: when others then
1039: errbuf := substr(SQLERRM,1,150);
1040: retcode := -1;
1041: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1042:
1043:
1044:
1045: END CREATE_DELETED_LEVEL_ASSOCI;

Line 1141: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1137: EXCEPTION
1138: when others then
1139: errbuf := substr(SQLERRM,1,150);
1140: retcode := -1;
1141: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1142:
1143:
1144:
1145: END PROCESS_TOP_LEVEL_VALUES;

Line 1248: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1244: EXCEPTION
1245: when others then
1246: errbuf := substr(SQLERRM,1,150);
1247: retcode := -1;
1248: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1249:
1250:
1251:
1252: END CREATE_ITEM_LIST_PRICE;

Line 1306: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1302: EXCEPTION
1303: when others then
1304: errbuf := substr(SQLERRM,1,150);
1305: retcode := -1;
1306: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1307:
1308:
1309:
1310: END DELETED_ITEM_LIST_PRICE;

Line 1420: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1416: EXCEPTION
1417: when others then
1418: errbuf := substr(SQLERRM,1,150);
1419: retcode := -1;
1420: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1421:
1422:
1423: END UPDATE_ITEM_LIST_PRICE;
1424:

Line 1462: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1458:
1459:
1460: EXCEPTION
1461: when others then
1462: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1463: errbuf := substr(SQLERRM,1,150);
1464: retcode := -1;
1465:
1466: END CLEAN_DELETED_LEVEL_VALUES;

Line 1590: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));

1586: EXCEPTION
1587: when others then
1588: errbuf := substr(SQLERRM,1,150);
1589: retcode := -1;
1590: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1591: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1592: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1593:
1594: end;

Line 1591: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));

1587: when others then
1588: errbuf := substr(SQLERRM,1,150);
1589: retcode := -1;
1590: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1591: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1592: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1593:
1594: end;
1595:

Line 1592: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1588: errbuf := substr(SQLERRM,1,150);
1589: retcode := -1;
1590: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1591: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1592: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1593:
1594: end;
1595:
1596:

Line 1749: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));

1745: EXCEPTION
1746: when others then
1747: errbuf := substr(SQLERRM,1,150);
1748: retcode := -1;
1749: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1750: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1751: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1752:
1753: end;

Line 1750: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));

1746: when others then
1747: errbuf := substr(SQLERRM,1,150);
1748: retcode := -1;
1749: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1750: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1751: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1752:
1753: end;
1754:

Line 1751: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1747: errbuf := substr(SQLERRM,1,150);
1748: retcode := -1;
1749: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1750: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1751: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1752:
1753: end;
1754:
1755:

Line 1843: fnd_file.put_line(fnd_file.log,substr(p_sql, i, 255));

1839: Begin
1840: while i<= length(p_sql)
1841: loop
1842: -- dbms_output.put_line (substr(p_sql, i, 255));
1843: fnd_file.put_line(fnd_file.log,substr(p_sql, i, 255));
1844: null;
1845: i := i+255;
1846: end loop;
1847: End;