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

Line 43: fnd_file.put_line(fnd_file.log, 'Source view ' || p_view_name || ' is missing or invalid');

39: ----------
40:
41: EXCEPTION
42: WHEN l_missing_view THEN
43: fnd_file.put_line(fnd_file.log, 'Source view ' || p_view_name || ' is missing or invalid');
44: raise;
45:
46: WHEN OTHERS THEN
47: fnd_file.put_line(fnd_file.log, 'Error in calling generate_views for '

Line 47: fnd_file.put_line(fnd_file.log, 'Error in calling generate_views for '

43: fnd_file.put_line(fnd_file.log, 'Source view ' || p_view_name || ' is missing or invalid');
44: raise;
45:
46: WHEN OTHERS THEN
47: fnd_file.put_line(fnd_file.log, 'Error in calling generate_views for '
48: || p_view_name || ': ' || temp);
49: raise;
50:
51: END;

Line 102: fnd_file.put_names(l_obj_short_name||'gen_bg.log',l_obj_short_name||'gen_bg.out',l_dir);

98: IF l_dir is null THEN
99: l_dir:='/sqlcom/log';
100: END IF;
101:
102: fnd_file.put_names(l_obj_short_name||'gen_bg.log',l_obj_short_name||'gen_bg.out',l_dir);
103:
104:
105: fnd_file.put_line(fnd_file.log,'Object physical name is '||l_obj_short_name);
106: stmt := 'SELECT count(distinct FLEX_VIEW_NAME) FROM edw_source_views@' || l_target_link ||

Line 105: fnd_file.put_line(fnd_file.log,'Object physical name is '||l_obj_short_name);

101:
102: fnd_file.put_names(l_obj_short_name||'gen_bg.log',l_obj_short_name||'gen_bg.out',l_dir);
103:
104:
105: fnd_file.put_line(fnd_file.log,'Object physical name is '||l_obj_short_name);
106: stmt := 'SELECT count(distinct FLEX_VIEW_NAME) FROM edw_source_views@' || l_target_link ||
107: ' where version = :version and GENERATED_VIEW_NAME <>''NULL'' ';
108:
109: IF l_obj_short_name is not null THEN

Line 113: fnd_file.put_line(fnd_file.log,l_newline||'Going to Execute : '||stmt);

109: IF l_obj_short_name is not null THEN
110: stmt := stmt ||' and object_name = :b_object_name';
111: END IF;
112:
113: fnd_file.put_line(fnd_file.log,l_newline||'Going to Execute : '||stmt);
114: cid := DBMS_SQL.OPEN_CURSOR;
115: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
116: DBMS_SQL.BIND_VARIABLE(cid, ':version', l_version);
117:

Line 127: fnd_file.put_line(fnd_file.log,l_newline||'Number of source views found :'|| nViewCount);

123: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
124: DBMS_SQL.COLUMN_VALUE(cid, 1, nViewCount);
125: DBMS_SQL.close_cursor(cid);
126:
127: fnd_file.put_line(fnd_file.log,l_newline||'Number of source views found :'|| nViewCount);
128:
129: stmt := 'SELECT distinct FLEX_VIEW_NAME FROM edw_source_views@' || l_target_link ||
130: ' where version = :version and GENERATED_VIEW_NAME <>''NULL'' ';
131:

Line 150: fnd_file.put_line(fnd_file.log, nCount||'. Going to generate '||v_col(nCount));

146: DBMS_SQL.close_cursor(cid);
147:
148: WHILE (nCount < nViewCount )LOOP
149: nCount := nCount + 1;
150: fnd_file.put_line(fnd_file.log, nCount||'. Going to generate '||v_col(nCount));
151: generateOneView(v_col(nCount));
152:
153: BEGIN
154:

Line 161: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generated.'||l_newline);

157: WHERE flex_view_name = v_col(nCount);
158:
159: IF l_generate_status = 'GENERATED_ALL' THEN
160:
161: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generated.'||l_newline);
162: ELSE
163: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generation failed.');
164: fnd_file.put_line(fnd_file.log, ' Error Message is : '||l_error_message||l_newline);
165: END IF;

Line 163: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generation failed.');

159: IF l_generate_status = 'GENERATED_ALL' THEN
160:
161: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generated.'||l_newline);
162: ELSE
163: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generation failed.');
164: fnd_file.put_line(fnd_file.log, ' Error Message is : '||l_error_message||l_newline);
165: END IF;
166:
167: EXCEPTION WHEN no_data_found THEN

Line 164: fnd_file.put_line(fnd_file.log, ' Error Message is : '||l_error_message||l_newline);

160:
161: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generated.'||l_newline);
162: ELSE
163: fnd_file.put_line(fnd_file.log,v_col(nCount)|| ' Generation failed.');
164: fnd_file.put_line(fnd_file.log, ' Error Message is : '||l_error_message||l_newline);
165: END IF;
166:
167: EXCEPTION WHEN no_data_found THEN
168: null;

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

172:
173: END LOOP;
174:
175: exception when others then
176: fnd_file.put_line(fnd_file.log,sqlerrm);
177: raise;
178:
179: END;
180: END EDW_BIS_VIEW_GEN;