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.EDW_GEN_VIEW dependencies on UTL_FILE

Line 121: Doing so by parsing the 'utl_file_dir' init.ora parameter and scanning

117:
118: In case the log directory isnt passed and the EDW_LOGFILE_DIR profile
119: option has also not been set, where do I write the log file ?
120:
121: Doing so by parsing the 'utl_file_dir' init.ora parameter and scanning
122: for the word log and getting that string out.
123:
124: ---------------------------------------------------------------------*/
125:

Line 140: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';

136: l_dummy NUMBER;
137:
138: BEGIN
139: SELECT param.value into l_dir
140: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';
141:
142: l_log_begin := INSTR(l_dir, '/log');
143:
144: IF (l_log_begin = 0) THEN /* then get the first string */

Line 444: Write to the log file using utl_file. Write only if the logging

440: END;
441:
442: /*---------------------------------------------------------------------
443:
444: Write to the log file using utl_file. Write only if the logging
445: flag is true.
446:
447: ---------------------------------------------------------------------*/
448:

Line 455: utl_file.put_line(l_file, newline);

451: Procedure writeLog(p_message IN VARCHAR2) IS
452: BEGIN
453: IF (g_log) THEN
454: IF (p_message like 'Inside%') THEN
455: utl_file.put_line(l_file, newline);
456: utl_file.put_line(l_file, g_indenting||p_message);
457: ELSIF ( p_message like 'Completed%') THEN
458: utl_file.put_line(l_file, g_indenting||p_message);
459: utl_file.put_line(l_file, newline);

Line 456: utl_file.put_line(l_file, g_indenting||p_message);

452: BEGIN
453: IF (g_log) THEN
454: IF (p_message like 'Inside%') THEN
455: utl_file.put_line(l_file, newline);
456: utl_file.put_line(l_file, g_indenting||p_message);
457: ELSIF ( p_message like 'Completed%') THEN
458: utl_file.put_line(l_file, g_indenting||p_message);
459: utl_file.put_line(l_file, newline);
460: ELSE

Line 458: utl_file.put_line(l_file, g_indenting||p_message);

454: IF (p_message like 'Inside%') THEN
455: utl_file.put_line(l_file, newline);
456: utl_file.put_line(l_file, g_indenting||p_message);
457: ELSIF ( p_message like 'Completed%') THEN
458: utl_file.put_line(l_file, g_indenting||p_message);
459: utl_file.put_line(l_file, newline);
460: ELSE
461: utl_file.put_line(l_file, g_indenting||' '||p_message);
462: END IF;

Line 459: utl_file.put_line(l_file, newline);

455: utl_file.put_line(l_file, newline);
456: utl_file.put_line(l_file, g_indenting||p_message);
457: ELSIF ( p_message like 'Completed%') THEN
458: utl_file.put_line(l_file, g_indenting||p_message);
459: utl_file.put_line(l_file, newline);
460: ELSE
461: utl_file.put_line(l_file, g_indenting||' '||p_message);
462: END IF;
463: ELSE

Line 461: utl_file.put_line(l_file, g_indenting||' '||p_message);

457: ELSIF ( p_message like 'Completed%') THEN
458: utl_file.put_line(l_file, g_indenting||p_message);
459: utl_file.put_line(l_file, newline);
460: ELSE
461: utl_file.put_line(l_file, g_indenting||' '||p_message);
462: END IF;
463: ELSE
464: return;
465: END IF;

Line 471: utl_file.put(l_out_file, p_message);

467:
468: Procedure writeOut(p_message IN VARCHAR2) IS
469: BEGIN
470: IF (g_log) THEN
471: utl_file.put(l_out_file, p_message);
472: ELSE
473: return;
474: END IF;
475: END;

Line 480: utl_file.put_line(l_out_file, p_message);

476:
477: Procedure writeOutLine(p_message IN VARCHAR2) IS
478: BEGIN
479: IF (g_log) THEN
480: utl_file.put_line(l_out_file, p_message);
481: ELSE
482: return;
483: END IF;
484: END;

Line 1444: l_file := utl_file.fopen(p_log_dir, p_instance||'_'||p_obj_name||'.log' ,'w');

1440:
1441:
1442: IF (p_log_dir IS NOT NULL ) THEN
1443: l_dir := p_log_dir;
1444: l_file := utl_file.fopen(p_log_dir, p_instance||'_'||p_obj_name||'.log' ,'w');
1445: l_out_file:=utl_file.fopen(p_log_dir, p_instance||'_'|| p_obj_name||'.sql' ,'w');
1446: g_log := true;
1447: ELSE
1448: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

Line 1445: l_out_file:=utl_file.fopen(p_log_dir, p_instance||'_'|| p_obj_name||'.sql' ,'w');

1441:
1442: IF (p_log_dir IS NOT NULL ) THEN
1443: l_dir := p_log_dir;
1444: l_file := utl_file.fopen(p_log_dir, p_instance||'_'||p_obj_name||'.log' ,'w');
1445: l_out_file:=utl_file.fopen(p_log_dir, p_instance||'_'|| p_obj_name||'.sql' ,'w');
1446: g_log := true;
1447: ELSE
1448: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
1449: END IF;

Line 1456: l_file := utl_file.fopen(l_dir, p_instance||'_'||p_obj_name||'.log' ,'w');

1452: l_dir := getUtlFileDir;
1453: END IF;
1454:
1455: IF (l_dir IS NOT NULL ) THEN
1456: l_file := utl_file.fopen(l_dir, p_instance||'_'||p_obj_name||'.log' ,'w');
1457: l_out_file := utl_file.fopen(l_dir, p_instance||'_'|| p_obj_name ||'.sql' ,'w');
1458: g_log := true;
1459: ELSE
1460: g_log := false;

Line 1457: l_out_file := utl_file.fopen(l_dir, p_instance||'_'|| p_obj_name ||'.sql' ,'w');

1453: END IF;
1454:
1455: IF (l_dir IS NOT NULL ) THEN
1456: l_file := utl_file.fopen(l_dir, p_instance||'_'||p_obj_name||'.log' ,'w');
1457: l_out_file := utl_file.fopen(l_dir, p_instance||'_'|| p_obj_name ||'.sql' ,'w');
1458: g_log := true;
1459: ELSE
1460: g_log := false;
1461: END IF;

Line 1530: utl_file.fclose(l_file);

1526:
1527: IF (NOT g_success) THEN
1528: IF (g_log) THEN
1529: writelog(g_error);
1530: utl_file.fclose(l_file);
1531: utl_file.fclose(l_out_file);
1532:
1533: END IF;
1534: END IF;

Line 1531: utl_file.fclose(l_out_file);

1527: IF (NOT g_success) THEN
1528: IF (g_log) THEN
1529: writelog(g_error);
1530: utl_file.fclose(l_file);
1531: utl_file.fclose(l_out_file);
1532:
1533: END IF;
1534: END IF;
1535:

Line 1582: utl_file.fclose(l_file);

1578: IF (g_log) THEN
1579: writelog(newline);
1580: writelog('Updated entries in edw_object_deployments');
1581: writelog('Completed view generation successfully.');
1582: utl_file.fclose(l_file);
1583: utl_file.fclose(l_out_file);
1584:
1585: END IF;
1586:

Line 1583: utl_file.fclose(l_out_file);

1579: writelog(newline);
1580: writelog('Updated entries in edw_object_deployments');
1581: writelog('Completed view generation successfully.');
1582: utl_file.fclose(l_file);
1583: utl_file.fclose(l_out_file);
1584:
1585: END IF;
1586:
1587: EXCEPTION

Line 1592: utl_file.fflush(l_file);

1588: WHEN viewgen_exception THEN
1589:
1590: IF (g_log) THEN
1591: writelog('Exception!!! '||g_error);
1592: utl_file.fflush(l_file);
1593: utl_file.fclose(l_file);
1594: utl_file.fflush(l_out_file);
1595: utl_file.fclose(l_out_file);
1596: END IF;

Line 1593: utl_file.fclose(l_file);

1589:
1590: IF (g_log) THEN
1591: writelog('Exception!!! '||g_error);
1592: utl_file.fflush(l_file);
1593: utl_file.fclose(l_file);
1594: utl_file.fflush(l_out_file);
1595: utl_file.fclose(l_out_file);
1596: END IF;
1597:

Line 1594: utl_file.fflush(l_out_file);

1590: IF (g_log) THEN
1591: writelog('Exception!!! '||g_error);
1592: utl_file.fflush(l_file);
1593: utl_file.fclose(l_file);
1594: utl_file.fflush(l_out_file);
1595: utl_file.fclose(l_out_file);
1596: END IF;
1597:
1598: fnd_message.set_name('BIS', 'EDW_APPS_INT_GENERAL_ERROR');

Line 1595: utl_file.fclose(l_out_file);

1591: writelog('Exception!!! '||g_error);
1592: utl_file.fflush(l_file);
1593: utl_file.fclose(l_file);
1594: utl_file.fflush(l_out_file);
1595: utl_file.fclose(l_out_file);
1596: END IF;
1597:
1598: fnd_message.set_name('BIS', 'EDW_APPS_INT_GENERAL_ERROR');
1599: fnd_message.set_token('MESSAGE', g_error);

Line 1609: utl_file.fflush(l_file);

1605: WHEN OTHERS THEN
1606:
1607: IF (g_log) THEN
1608: writelog('Exception!!! '||sqlerrm);
1609: utl_file.fflush(l_file);
1610: utl_file.fclose(l_file);
1611: utl_file.fflush(l_out_file);
1612: utl_file.fclose(l_out_file);
1613:

Line 1610: utl_file.fclose(l_file);

1606:
1607: IF (g_log) THEN
1608: writelog('Exception!!! '||sqlerrm);
1609: utl_file.fflush(l_file);
1610: utl_file.fclose(l_file);
1611: utl_file.fflush(l_out_file);
1612: utl_file.fclose(l_out_file);
1613:
1614: END IF;

Line 1611: utl_file.fflush(l_out_file);

1607: IF (g_log) THEN
1608: writelog('Exception!!! '||sqlerrm);
1609: utl_file.fflush(l_file);
1610: utl_file.fclose(l_file);
1611: utl_file.fflush(l_out_file);
1612: utl_file.fclose(l_out_file);
1613:
1614: END IF;
1615: RAISE;

Line 1612: utl_file.fclose(l_out_file);

1608: writelog('Exception!!! '||sqlerrm);
1609: utl_file.fflush(l_file);
1610: utl_file.fclose(l_file);
1611: utl_file.fflush(l_out_file);
1612: utl_file.fclose(l_out_file);
1613:
1614: END IF;
1615: RAISE;
1616: END;