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_COLLECT_LEVEL_VALUES dependencies on FND_FILE

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

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

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

21: PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2)
22: IS
23: BEGIN
24:
25: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
26:
27: END LOG_MESSAGE;
28:
29: Procedure Delete_duplicate(p_instance_id in number, p_dest_table in varchar2);

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

405:
406: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);
407: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);
408:
409: fnd_file.put_line(fnd_file.log, ' ');
410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||
411: 'Hierarchy : '|| p_hierarchy_name || '. (No Data Collected.)');
412: fnd_file.put_line(fnd_file.log, ' Level : ' || p_level_name );
413: fnd_file.put_line(fnd_file.log, ' Parent Level : ' || p_parent_level_name );

Line 410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||

406: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);
407: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);
408:
409: fnd_file.put_line(fnd_file.log, ' ');
410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||
411: 'Hierarchy : '|| p_hierarchy_name || '. (No Data Collected.)');
412: fnd_file.put_line(fnd_file.log, ' Level : ' || p_level_name );
413: fnd_file.put_line(fnd_file.log, ' Parent Level : ' || p_parent_level_name );
414:

Line 412: fnd_file.put_line(fnd_file.log, ' Level : ' || p_level_name );

408:
409: fnd_file.put_line(fnd_file.log, ' ');
410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||
411: 'Hierarchy : '|| p_hierarchy_name || '. (No Data Collected.)');
412: fnd_file.put_line(fnd_file.log, ' Level : ' || p_level_name );
413: fnd_file.put_line(fnd_file.log, ' Parent Level : ' || p_parent_level_name );
414:
415: End LOOP;
416:

Line 413: fnd_file.put_line(fnd_file.log, ' Parent Level : ' || p_parent_level_name );

409: fnd_file.put_line(fnd_file.log, ' ');
410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||
411: 'Hierarchy : '|| p_hierarchy_name || '. (No Data Collected.)');
412: fnd_file.put_line(fnd_file.log, ' Level : ' || p_level_name );
413: fnd_file.put_line(fnd_file.log, ' Parent Level : ' || p_parent_level_name );
414:
415: End LOOP;
416:
417: retcode := g_retcode;

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

1124: EXCEPTION
1125: when others then
1126: errbuf := substr(SQLERRM,1,150);
1127: retcode := -1;
1128: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1129:
1130:
1131: END Delete_duplicate_lvl_assoc;
1132:

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

1296: FOR Childless_rec IN c_childless_parent LOOP
1297: l_count := l_count + 1;
1298:
1299: IF ( l_print_title ) THEN
1300: fnd_file.put_line(fnd_file.log, ' ');
1301: fnd_file.put_line(fnd_file.log, 'Following Childless Level Values for Level ID : '||
1302: Childless_rec.level_id || ' were deleted.');
1303: fnd_file.put_line(fnd_file.log, 'SR Level PK ' );
1304: fnd_file.put_line(fnd_file.log, '---------------' );

Line 1301: fnd_file.put_line(fnd_file.log, 'Following Childless Level Values for Level ID : '||

1297: l_count := l_count + 1;
1298:
1299: IF ( l_print_title ) THEN
1300: fnd_file.put_line(fnd_file.log, ' ');
1301: fnd_file.put_line(fnd_file.log, 'Following Childless Level Values for Level ID : '||
1302: Childless_rec.level_id || ' were deleted.');
1303: fnd_file.put_line(fnd_file.log, 'SR Level PK ' );
1304: fnd_file.put_line(fnd_file.log, '---------------' );
1305: l_print_title := FALSE;

Line 1303: fnd_file.put_line(fnd_file.log, 'SR Level PK ' );

1299: IF ( l_print_title ) THEN
1300: fnd_file.put_line(fnd_file.log, ' ');
1301: fnd_file.put_line(fnd_file.log, 'Following Childless Level Values for Level ID : '||
1302: Childless_rec.level_id || ' were deleted.');
1303: fnd_file.put_line(fnd_file.log, 'SR Level PK ' );
1304: fnd_file.put_line(fnd_file.log, '---------------' );
1305: l_print_title := FALSE;
1306: END IF;
1307: fnd_file.put_line(fnd_file.log, ' ' || Childless_rec.sr_level_pk);

Line 1304: fnd_file.put_line(fnd_file.log, '---------------' );

1300: fnd_file.put_line(fnd_file.log, ' ');
1301: fnd_file.put_line(fnd_file.log, 'Following Childless Level Values for Level ID : '||
1302: Childless_rec.level_id || ' were deleted.');
1303: fnd_file.put_line(fnd_file.log, 'SR Level PK ' );
1304: fnd_file.put_line(fnd_file.log, '---------------' );
1305: l_print_title := FALSE;
1306: END IF;
1307: fnd_file.put_line(fnd_file.log, ' ' || Childless_rec.sr_level_pk);
1308:

Line 1307: fnd_file.put_line(fnd_file.log, ' ' || Childless_rec.sr_level_pk);

1303: fnd_file.put_line(fnd_file.log, 'SR Level PK ' );
1304: fnd_file.put_line(fnd_file.log, '---------------' );
1305: l_print_title := FALSE;
1306: END IF;
1307: fnd_file.put_line(fnd_file.log, ' ' || Childless_rec.sr_level_pk);
1308:
1309: END LOOP;
1310:
1311: IF (l_count > 0) THEN

Line 1312: fnd_file.put_line(fnd_file.log, l_count ||' childless level values deleted.' );

1308:
1309: END LOOP;
1310:
1311: IF (l_count > 0) THEN
1312: fnd_file.put_line(fnd_file.log, l_count ||' childless level values deleted.' );
1313: END IF;
1314:
1315: /*------------------------- Clean up msd_backup_level_values table ---------------*/
1316: delete from msd_backup_level_values

Line 1323: fnd_file.put_line(fnd_file.log, 'Error in Delete_Childless_Parent.');

1319: EXCEPTION
1320: when others then
1321: retcode := -1 ;
1322: errbuf := substr(SQLERRM,1,150);
1323: fnd_file.put_line(fnd_file.log, 'Error in Delete_Childless_Parent.');
1324: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,1000) );
1325:
1326: END Delete_Childless_Parent;
1327:

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

1320: when others then
1321: retcode := -1 ;
1322: errbuf := substr(SQLERRM,1,150);
1323: fnd_file.put_line(fnd_file.log, 'Error in Delete_Childless_Parent.');
1324: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,1000) );
1325:
1326: END Delete_Childless_Parent;
1327:
1328: