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_OPI_RES_UTIL_F_C dependencies on EDW_LOG

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

164:
165:
166:
167:
168: edw_log.put_line( 'The collection range is from '||
169: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
170: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
171: edw_log.put_line(' ');
172:

Line 171: edw_log.put_line(' ');

167:
168: edw_log.put_line( 'The collection range is from '||
169: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
170: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
171: edw_log.put_line(' ');
172:
173: -- --------------------------------------------------------
174: -- Delete all opi_edw_res_util_push_log records
175: -- --------------------------------------------------------

Line 186: edw_log.put_line(' ');

182:
183: -- --------------------------------------------------------
184: -- . Pushing data to local push table
185: -- --------------------------------------------------------
186: edw_log.put_line(' ');
187: edw_log.put_line('Inserting into local push log table ');
188:
189: opimxru.extract_opi_res_util(g_push_from_date, g_push_to_date);
190:

Line 187: edw_log.put_line('Inserting into local push log table ');

183: -- --------------------------------------------------------
184: -- . Pushing data to local push table
185: -- --------------------------------------------------------
186: edw_log.put_line(' ');
187: edw_log.put_line('Inserting into local push log table ');
188:
189: opimxru.extract_opi_res_util(g_push_from_date, g_push_to_date);
190:
191: -- --------------------------------------------------------

Line 194: edw_log.put_line(' ');

190:
191: -- --------------------------------------------------------
192: -- . Pushing data to local staging table
193: -- --------------------------------------------------------
194: edw_log.put_line(' ');
195: edw_log.put_line('Inserting into local staging table for view type 1');
196:
197: l_row_count := push_to_local(p_from_date => g_push_from_date,
198: p_to_date => g_push_to_date );

Line 195: edw_log.put_line('Inserting into local staging table for view type 1');

191: -- --------------------------------------------------------
192: -- . Pushing data to local staging table
193: -- --------------------------------------------------------
194: edw_log.put_line(' ');
195: edw_log.put_line('Inserting into local staging table for view type 1');
196:
197: l_row_count := push_to_local(p_from_date => g_push_from_date,
198: p_to_date => g_push_to_date );
199:

Line 204: edw_log.put_line(' ');

200: -- --------------------------------------------
201: -- No exception raised so far. Call wrapup to transport
202: -- data to target database, and insert messages into logs
203: -- -----------------------------------------------
204: edw_log.put_line(' ');
205: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
206: ' rows into the local staging table');
207: edw_log.put_line( 'The system time after insert is ' ||
208: to_char(sysdate,'MM/DD/YYYY HH24:MI:SS') );

Line 205: edw_log.put_line('Inserted '||nvl(l_row_count,0)||

201: -- No exception raised so far. Call wrapup to transport
202: -- data to target database, and insert messages into logs
203: -- -----------------------------------------------
204: edw_log.put_line(' ');
205: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
206: ' rows into the local staging table');
207: edw_log.put_line( 'The system time after insert is ' ||
208: to_char(sysdate,'MM/DD/YYYY HH24:MI:SS') );
209: edw_log.put_line(' ');

Line 207: edw_log.put_line( 'The system time after insert is ' ||

203: -- -----------------------------------------------
204: edw_log.put_line(' ');
205: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
206: ' rows into the local staging table');
207: edw_log.put_line( 'The system time after insert is ' ||
208: to_char(sysdate,'MM/DD/YYYY HH24:MI:SS') );
209: edw_log.put_line(' ');
210:
211: EDW_COLLECTION_UTIL.wrapup(TRUE,

Line 209: edw_log.put_line(' ');

205: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
206: ' rows into the local staging table');
207: edw_log.put_line( 'The system time after insert is ' ||
208: to_char(sysdate,'MM/DD/YYYY HH24:MI:SS') );
209: edw_log.put_line(' ');
210:
211: EDW_COLLECTION_UTIL.wrapup(TRUE,
212: g_row_count,
213: l_exception_msg,

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

233: Errbuf:=g_errbuf;
234: Retcode:=g_retcode;
235: l_exception_msg := Retcode || ':' || Errbuf;
236: rollback; -- Rollback insert into local staging
237: edw_log.put_line('Inserting into local staging have failed');
238: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
239: g_push_from_date, g_push_to_date);
240: raise;
241:

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

243: Errbuf:= Sqlerrm;
244: Retcode:=sqlcode;
245: l_exception_msg := Retcode || ':' || Errbuf;
246: rollback;
247: edw_log.put_line('Other errors');
248: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
249: g_push_from_date, g_push_to_date);
250: raise;
251: