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.OPI_EDW_OPM_RES_UTIL_F_C dependencies on EDW_LOG

Line 171: edw_log.put_line( 'The collection range is from '||

167: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
168: EDW_COLLECTION_UTIL.g_offset);
169: g_push_to_date := nvl(l_to_date,
170: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
171: edw_log.put_line( 'The collection range is from '||
172: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
173: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
174: edw_log.put_line(' ');
175: -- --------------------------------------------

Line 174: edw_log.put_line(' ');

170: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
171: edw_log.put_line( 'The collection range is from '||
172: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
173: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
174: edw_log.put_line(' ');
175: -- --------------------------------------------
176: -- Push to local staging table
177: -- --------------------------------------------
178: edw_log.put_line(' ');

Line 178: edw_log.put_line(' ');

174: edw_log.put_line(' ');
175: -- --------------------------------------------
176: -- Push to local staging table
177: -- --------------------------------------------
178: edw_log.put_line(' ');
179: edw_log.put_line('Inserting into local staging table ');
180: l_row_count1 := PUSH_TO_LOCAL(g_push_from_date,g_push_to_date);
181: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
182: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||

Line 179: edw_log.put_line('Inserting into local staging table ');

175: -- --------------------------------------------
176: -- Push to local staging table
177: -- --------------------------------------------
178: edw_log.put_line(' ');
179: edw_log.put_line('Inserting into local staging table ');
180: l_row_count1 := PUSH_TO_LOCAL(g_push_from_date,g_push_to_date);
181: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
182: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||
183: ' rows into the local staging table ');

Line 182: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||

178: edw_log.put_line(' ');
179: edw_log.put_line('Inserting into local staging table ');
180: l_row_count1 := PUSH_TO_LOCAL(g_push_from_date,g_push_to_date);
181: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
182: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||
183: ' rows into the local staging table ');
184: edw_log.put_line(' ');
185: g_row_count:= l_row_count1;
186: edw_log.put_line(' ');

Line 184: edw_log.put_line(' ');

180: l_row_count1 := PUSH_TO_LOCAL(g_push_from_date,g_push_to_date);
181: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
182: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||
183: ' rows into the local staging table ');
184: edw_log.put_line(' ');
185: g_row_count:= l_row_count1;
186: edw_log.put_line(' ');
187: edw_log.put_line('For all views types, inserted '||nvl(g_row_count,0)||
188: ' rows into local staging table ');

Line 186: edw_log.put_line(' ');

182: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||
183: ' rows into the local staging table ');
184: edw_log.put_line(' ');
185: g_row_count:= l_row_count1;
186: edw_log.put_line(' ');
187: edw_log.put_line('For all views types, inserted '||nvl(g_row_count,0)||
188: ' rows into local staging table ');
189: -- --------------------------------------------
190: -- No exception raised so far. Call wrapup to transport

Line 187: edw_log.put_line('For all views types, inserted '||nvl(g_row_count,0)||

183: ' rows into the local staging table ');
184: edw_log.put_line(' ');
185: g_row_count:= l_row_count1;
186: edw_log.put_line(' ');
187: edw_log.put_line('For all views types, inserted '||nvl(g_row_count,0)||
188: ' rows into local staging table ');
189: -- --------------------------------------------
190: -- No exception raised so far. Call wrapup to transport
191: -- data to target database, and insert messages into logs

Line 193: edw_log.put_line(' ');

189: -- --------------------------------------------
190: -- No exception raised so far. Call wrapup to transport
191: -- data to target database, and insert messages into logs
192: -- -----------------------------------------------
193: edw_log.put_line(' ');
194: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
195: ' rows into the staging table');
196: edw_log.put_line(' ');
197: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,

Line 194: edw_log.put_line('Inserted '||nvl(g_row_count,0)||

190: -- No exception raised so far. Call wrapup to transport
191: -- data to target database, and insert messages into logs
192: -- -----------------------------------------------
193: edw_log.put_line(' ');
194: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
195: ' rows into the staging table');
196: edw_log.put_line(' ');
197: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
198: g_push_from_date, g_push_to_date);

Line 196: edw_log.put_line(' ');

192: -- -----------------------------------------------
193: edw_log.put_line(' ');
194: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
195: ' rows into the staging table');
196: edw_log.put_line(' ');
197: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
198: g_push_from_date, g_push_to_date);
199: -- ---------------------------------------------------------------------------
200: -- END OF Collection , Developer Customizable Section

Line 208: edw_log.put_line('Inserting into local staging have failed');

204: Errbuf:=g_errbuf;
205: Retcode:=g_retcode;
206: l_exception_msg := Retcode || ':' || Errbuf;
207: rollback; -- Rollback insert into local staging
208: edw_log.put_line('Inserting into local staging have failed');
209: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
210: raise;
211: WHEN L_IDEN_CHANGE_FAILURE THEN
212: Errbuf:=g_errbuf;

Line 215: edw_log.put_line('Identifying changed records have Failed');

211: WHEN L_IDEN_CHANGE_FAILURE THEN
212: Errbuf:=g_errbuf;
213: Retcode:=g_retcode;
214: l_exception_msg := Retcode || ':' || Errbuf;
215: edw_log.put_line('Identifying changed records have Failed');
216: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
217: raise;
218: WHEN OTHERS THEN
219: Errbuf:=g_errbuf;

Line 223: edw_log.put_line('Other errors');

219: Errbuf:=g_errbuf;
220: Retcode:=g_retcode;
221: l_exception_msg := Retcode || ':' || Errbuf;
222: rollback;
223: edw_log.put_line('Other errors');
224: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
225: g_push_from_date, g_push_to_date);
226: raise;
227: END;