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

Line 4316: FND_FILE.put_line(FND_FILE.LOG, l_indicator||':'||kpilist);

4312: l_indicator := fnd_message.get;
4313: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
4314: writeTmp( 'Compl. CheckAllIndicsHaveSystem, error BSC_MISSING_KPI_TAB_ASSIG');
4315: END IF;
4316: FND_FILE.put_line(FND_FILE.LOG, l_indicator||':'||kpilist);
4317: terminateWithError('BSC_MISSING_KPI_TAB_ASSIG', 'CheckAllIndicsHaveSystem');
4318: terminateWithMsg(kpiList);
4319: raise bsc_metadata_optimizer_pkg.optimizer_exception;
4320: return; -- Mark as error in CP status

Line 6443: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_to_stack:'||sqlerrm);

6439: IF (g_stack.count > 150) THEN
6440: g_stack.delete(g_stack.first);
6441: END IF;
6442: EXCEPTION WHEN OTHERS THEN
6443: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_to_stack:'||sqlerrm);
6444: fnd_file.put_line(FND_FILE.LOG, 'Stack length='||length(g_stack(g_stack_index)));
6445: fnd_file.put_line(FND_FILE.LOG, 'g_stack_length='||g_stack_length);
6446: fnd_file.put_line(FND_FILE.LOG, 'length(msg) = '||length(msg));
6447: fnd_file.put_line(FND_FILE.LOG, 'msg = '||msg);

Line 6444: fnd_file.put_line(FND_FILE.LOG, 'Stack length='||length(g_stack(g_stack_index)));

6440: g_stack.delete(g_stack.first);
6441: END IF;
6442: EXCEPTION WHEN OTHERS THEN
6443: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_to_stack:'||sqlerrm);
6444: fnd_file.put_line(FND_FILE.LOG, 'Stack length='||length(g_stack(g_stack_index)));
6445: fnd_file.put_line(FND_FILE.LOG, 'g_stack_length='||g_stack_length);
6446: fnd_file.put_line(FND_FILE.LOG, 'length(msg) = '||length(msg));
6447: fnd_file.put_line(FND_FILE.LOG, 'msg = '||msg);
6448: raise;

Line 6445: fnd_file.put_line(FND_FILE.LOG, 'g_stack_length='||g_stack_length);

6441: END IF;
6442: EXCEPTION WHEN OTHERS THEN
6443: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_to_stack:'||sqlerrm);
6444: fnd_file.put_line(FND_FILE.LOG, 'Stack length='||length(g_stack(g_stack_index)));
6445: fnd_file.put_line(FND_FILE.LOG, 'g_stack_length='||g_stack_length);
6446: fnd_file.put_line(FND_FILE.LOG, 'length(msg) = '||length(msg));
6447: fnd_file.put_line(FND_FILE.LOG, 'msg = '||msg);
6448: raise;
6449: END;

Line 6446: fnd_file.put_line(FND_FILE.LOG, 'length(msg) = '||length(msg));

6442: EXCEPTION WHEN OTHERS THEN
6443: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_to_stack:'||sqlerrm);
6444: fnd_file.put_line(FND_FILE.LOG, 'Stack length='||length(g_stack(g_stack_index)));
6445: fnd_file.put_line(FND_FILE.LOG, 'g_stack_length='||g_stack_length);
6446: fnd_file.put_line(FND_FILE.LOG, 'length(msg) = '||length(msg));
6447: fnd_file.put_line(FND_FILE.LOG, 'msg = '||msg);
6448: raise;
6449: END;
6450:

Line 6447: fnd_file.put_line(FND_FILE.LOG, 'msg = '||msg);

6443: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_to_stack:'||sqlerrm);
6444: fnd_file.put_line(FND_FILE.LOG, 'Stack length='||length(g_stack(g_stack_index)));
6445: fnd_file.put_line(FND_FILE.LOG, 'g_stack_length='||g_stack_length);
6446: fnd_file.put_line(FND_FILE.LOG, 'length(msg) = '||length(msg));
6447: fnd_file.put_line(FND_FILE.LOG, 'msg = '||msg);
6448: raise;
6449: END;
6450:
6451: PROCEDURE dump_stack IS

Line 6456: fnd_file.put_line(FND_FILE.LOG, ' ');

6452: l_msg VARCHAR2(2000);
6453: l_chunk VARCHAR2(256);
6454: l_varchar2_table DBMS_SQL.VARCHAR2_TABLE;
6455: BEGIN
6456: fnd_file.put_line(FND_FILE.LOG, ' ');
6457: BSC_MO_HELPER_PKG.TerminateWithMsg( 'Dumping stack contents ');
6458: fnd_file.put_line(FND_FILE.LOG, '-------------START OF STACK CONTENTS------------ ');
6459: IF g_stack.count = 0 THEN
6460: return;

Line 6458: fnd_file.put_line(FND_FILE.LOG, '-------------START OF STACK CONTENTS------------ ');

6454: l_varchar2_table DBMS_SQL.VARCHAR2_TABLE;
6455: BEGIN
6456: fnd_file.put_line(FND_FILE.LOG, ' ');
6457: BSC_MO_HELPER_PKG.TerminateWithMsg( 'Dumping stack contents ');
6458: fnd_file.put_line(FND_FILE.LOG, '-------------START OF STACK CONTENTS------------ ');
6459: IF g_stack.count = 0 THEN
6460: return;
6461: END IF;
6462: FOR i IN g_stack.first..g_stack.last LOOP

Line 6464: --fnd_file.put_line(FND_FILE.LOG, g_stack(i));

6460: return;
6461: END IF;
6462: FOR i IN g_stack.first..g_stack.last LOOP
6463: l_msg := g_stack(i);
6464: --fnd_file.put_line(FND_FILE.LOG, g_stack(i));
6465: IF length(l_msg) <=256 THEN
6466: fnd_file.put_line(FND_FILE.LOG, l_msg);
6467: ELSE
6468: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);

Line 6466: fnd_file.put_line(FND_FILE.LOG, l_msg);

6462: FOR i IN g_stack.first..g_stack.last LOOP
6463: l_msg := g_stack(i);
6464: --fnd_file.put_line(FND_FILE.LOG, g_stack(i));
6465: IF length(l_msg) <=256 THEN
6466: fnd_file.put_line(FND_FILE.LOG, l_msg);
6467: ELSE
6468: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);
6469: FOR j in l_varchar2_table.first..l_varchar2_table.last LOOP
6470: fnd_file.put_line(FND_FILE.LOG, l_varchar2_table(j));

Line 6470: fnd_file.put_line(FND_FILE.LOG, l_varchar2_table(j));

6466: fnd_file.put_line(FND_FILE.LOG, l_msg);
6467: ELSE
6468: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);
6469: FOR j in l_varchar2_table.first..l_varchar2_table.last LOOP
6470: fnd_file.put_line(FND_FILE.LOG, l_varchar2_table(j));
6471: END LOOP;
6472: END IF;
6473: END LOOP;
6474: fnd_file.put_line(FND_FILE.LOG, '-------------END OF STACK CONTENTS--------------- ');

Line 6474: fnd_file.put_line(FND_FILE.LOG, '-------------END OF STACK CONTENTS--------------- ');

6470: fnd_file.put_line(FND_FILE.LOG, l_varchar2_table(j));
6471: END LOOP;
6472: END IF;
6473: END LOOP;
6474: fnd_file.put_line(FND_FILE.LOG, '-------------END OF STACK CONTENTS--------------- ');
6475: END;
6476:
6477:
6478: PROCEDURE write_debug (

Line 6493: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_debug:'||sqlerrm);

6489: if( l_severity >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6490: FND_LOG.STRING(l_severity, 'bsc.pma.opt.optimize', msg);
6491: end if;
6492: EXCEPTION WHEN OTHERS THEN
6493: fnd_file.put_line(FND_FILE.LOG, 'Exception in write_debug:'||sqlerrm);
6494: raise;
6495: END;
6496:
6497:

Line 6551: fnd_file.put_names(BSC_METADATA_OPTIMIZER_PKG.g_filename||'.log', BSC_METADATA_OPTIMIZER_PKG.g_filename||'.out', BSC_METADATA_OPTIMIZER_PKG.g_dir);

6547: BSC_METADATA_OPTIMIZER_PKG.g_dir := null;
6548: IF BSC_METADATA_OPTIMIZER_PKG.g_dir is null THEN
6549: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;
6550: END IF;
6551: fnd_file.put_names(BSC_METADATA_OPTIMIZER_PKG.g_filename||'.log', BSC_METADATA_OPTIMIZER_PKG.g_filename||'.out', BSC_METADATA_OPTIMIZER_PKG.g_dir);
6552: BSC_METADATA_OPTIMIZER_PKG.g_file := utl_file.fopen(BSC_METADATA_OPTIMIZER_PKG.g_dir, 'METADATA.log' ,'w');
6553: BSC_METADATA_OPTIMIZER_PKG.g_fileOpened := true;
6554: END IF;
6555: IF (length(l_msg) <=256) THEN

Line 6556: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_msg);

6552: BSC_METADATA_OPTIMIZER_PKG.g_file := utl_file.fopen(BSC_METADATA_OPTIMIZER_PKG.g_dir, 'METADATA.log' ,'w');
6553: BSC_METADATA_OPTIMIZER_PKG.g_fileOpened := true;
6554: END IF;
6555: IF (length(l_msg) <=256) THEN
6556: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_msg);
6557: ELSE
6558: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);
6559: FOR i IN l_varchar2_table.first..l_varchar2_table.last LOOP
6560: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_varchar2_table(i));

Line 6560: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_varchar2_table(i));

6556: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_msg);
6557: ELSE
6558: l_varchar2_table := bsc_dbgen_utils.get_char_chunks(l_msg, 256);
6559: FOR i IN l_varchar2_table.first..l_varchar2_table.last LOOP
6560: fnd_file.put_line(FND_FILE.LOG, bsc_metadata_optimizer_pkg.gIndent||l_varchar2_table(i));
6561: END LOOP;
6562: END IF;
6563: IF (l_msg like 'Inside%') THEN
6564: bsc_metadata_optimizer_pkg.gIndent := bsc_metadata_optimizer_pkg.gIndent || bsc_metadata_optimizer_pkg.gSpacing;

Line 6570: fnd_file.put_line(FND_FILE.LOG, 'Exception in writeTmp:'||sqlerrm);

6566: IF length(bsc_metadata_optimizer_pkg.gIndent) > 256 THEN
6567: bsc_metadata_optimizer_pkg.gIndent := substr(bsc_metadata_optimizer_pkg.gIndent, 1, 64);
6568: END IF;
6569: EXCEPTION WHEN OTHERS THEN
6570: fnd_file.put_line(FND_FILE.LOG, 'Exception in writeTmp:'||sqlerrm);
6571: raise;
6572: END;
6573:
6574:

Line 7084: FND_FILE.put_line(FND_FILE.log, 'Exception '||pAPI||' : '||l_error);

7080:
7081: fnd_message.set_name('BSC', pErrorShortName);
7082: l_error := fnd_message.get;
7083: BSC_METADATA_OPTIMIZER_PKG.logProgress('ERROR', pAPI||' '||l_error);
7084: FND_FILE.put_line(FND_FILE.log, 'Exception '||pAPI||' : '||l_error);
7085: --fnd_file.release_names(bsc_metadata_optimizer_pkg.g_filename||'.log', bsc_metadata_optimizer_pkg.g_filename||'.out');
7086: fnd_message.set_name('BSC', pErrorShortName);
7087: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;
7088: BSC_METADATA_OPTIMIZER_PKG.g_errbuf := l_error;

Line 7085: --fnd_file.release_names(bsc_metadata_optimizer_pkg.g_filename||'.log', bsc_metadata_optimizer_pkg.g_filename||'.out');

7081: fnd_message.set_name('BSC', pErrorShortName);
7082: l_error := fnd_message.get;
7083: BSC_METADATA_OPTIMIZER_PKG.logProgress('ERROR', pAPI||' '||l_error);
7084: FND_FILE.put_line(FND_FILE.log, 'Exception '||pAPI||' : '||l_error);
7085: --fnd_file.release_names(bsc_metadata_optimizer_pkg.g_filename||'.log', bsc_metadata_optimizer_pkg.g_filename||'.out');
7086: fnd_message.set_name('BSC', pErrorShortName);
7087: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;
7088: BSC_METADATA_OPTIMIZER_PKG.g_errbuf := l_error;
7089:

Line 7097: FND_FILE.put_line(FND_FILE.log, ' -------------------');

7093: IS
7094: BEGIN
7095:
7096: BSC_METADATA_OPTIMIZER_PKG.logProgress('ERROR', pAPI||' '||pMessage);
7097: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7098: FND_FILE.put_line(FND_FILE.log, ' ERROR ');
7099: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7100: FND_FILE.put_line(FND_FILE.log, pMessage);
7101: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;

Line 7098: FND_FILE.put_line(FND_FILE.log, ' ERROR ');

7094: BEGIN
7095:
7096: BSC_METADATA_OPTIMIZER_PKG.logProgress('ERROR', pAPI||' '||pMessage);
7097: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7098: FND_FILE.put_line(FND_FILE.log, ' ERROR ');
7099: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7100: FND_FILE.put_line(FND_FILE.log, pMessage);
7101: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;
7102: BSC_METADATA_OPTIMIZER_PKG.g_errbuf := pMessage;

Line 7099: FND_FILE.put_line(FND_FILE.log, ' -------------------');

7095:
7096: BSC_METADATA_OPTIMIZER_PKG.logProgress('ERROR', pAPI||' '||pMessage);
7097: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7098: FND_FILE.put_line(FND_FILE.log, ' ERROR ');
7099: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7100: FND_FILE.put_line(FND_FILE.log, pMessage);
7101: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;
7102: BSC_METADATA_OPTIMIZER_PKG.g_errbuf := pMessage;
7103: END;

Line 7100: FND_FILE.put_line(FND_FILE.log, pMessage);

7096: BSC_METADATA_OPTIMIZER_PKG.logProgress('ERROR', pAPI||' '||pMessage);
7097: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7098: FND_FILE.put_line(FND_FILE.log, ' ERROR ');
7099: FND_FILE.put_line(FND_FILE.log, ' -------------------');
7100: FND_FILE.put_line(FND_FILE.log, pMessage);
7101: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;
7102: BSC_METADATA_OPTIMIZER_PKG.g_errbuf := pMessage;
7103: END;
7104: