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

Line 74: edw_log.put_line(' ');

70: l_global_conv_rate_flag := TRUE;
71: Errbuf :=NULL;
72: Retcode:=0;
73:
74: edw_log.put_line(' ');
75: edw_log.put_line('call EDW_COLLECTION_UTIL ');
76: --dbms_output.put_line(p_from_date);
77: --dbms_output.put_line(p_to_date);
78: -- -------------------------------------------

Line 75: edw_log.put_line('call EDW_COLLECTION_UTIL ');

71: Errbuf :=NULL;
72: Retcode:=0;
73:
74: edw_log.put_line(' ');
75: edw_log.put_line('call EDW_COLLECTION_UTIL ');
76: --dbms_output.put_line(p_from_date);
77: --dbms_output.put_line(p_to_date);
78: -- -------------------------------------------
79: -- call edw_collection_util.setup

Line 134: edw_log.put_line(' ');

130: --dbms_output.put_line(' ');
131: --dbms_output.put_line('call opi_extract_ids ');
132:
133:
134: edw_log.put_line(' ');
135: edw_log.put_line('call opi_extract_ids ');
136:
137: OPIMPXWI.opi_extract_ids(l_from_date,l_to_date,p_org_code);
138:

Line 135: edw_log.put_line('call opi_extract_ids ');

131: --dbms_output.put_line('call opi_extract_ids ');
132:
133:
134: edw_log.put_line(' ');
135: edw_log.put_line('call opi_extract_ids ');
136:
137: OPIMPXWI.opi_extract_ids(l_from_date,l_to_date,p_org_code);
138:
139:

Line 198: edw_log.put_line ('No conversion rate existed for conversion from '

194: EXCEPTION
195: WHEN OTHERS THEN
196: l_trx_date := l_org_date.trx_date;
197:
198: edw_log.put_line ('No conversion rate existed for conversion from '
199: || l_base_currency_code || ' to ' ||
200: l_global_currency_code || ' in organization_id ' ||
201: l_prev_org_id || ' on ' || To_char( l_trx_date, 'dd/mm/yyyy') );
202:

Line 245: edw_log.put_line(' ');

241: COMMIT;
242: -- --------------------------------------------------------
243: -- Insert into the local staging table
244: -- --------------------------------------------------------
245: edw_log.put_line(' ');
246: edw_log.put_line('Insert into the local staging table');
247:
248: INSERT INTO opi_edw_inv_daily_stat_fstg(
249: AVG_INT_QTY

Line 246: edw_log.put_line('Insert into the local staging table');

242: -- --------------------------------------------------------
243: -- Insert into the local staging table
244: -- --------------------------------------------------------
245: edw_log.put_line(' ');
246: edw_log.put_line('Insert into the local staging table');
247:
248: INSERT INTO opi_edw_inv_daily_stat_fstg(
249: AVG_INT_QTY
250: ,AVG_INT_VAL_B

Line 470: edw_log.put_line(' ');

466: -- --------------------------------------------
467: -- No exception raised so far. Call wrapup to transport
468: -- data to target database, and insert messages into logs
469: -- -----------------------------------------------
470: edw_log.put_line(' ');
471: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
472: ' rows into the staging table');
473: edw_log.put_line(' Calling EDW_COLLECTION_UTIL.wrapup');
474:

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

467: -- No exception raised so far. Call wrapup to transport
468: -- data to target database, and insert messages into logs
469: -- -----------------------------------------------
470: edw_log.put_line(' ');
471: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
472: ' rows into the staging table');
473: edw_log.put_line(' Calling EDW_COLLECTION_UTIL.wrapup');
474:
475: EDW_COLLECTION_UTIL.wrapup(TRUE,

Line 473: edw_log.put_line(' Calling EDW_COLLECTION_UTIL.wrapup');

469: -- -----------------------------------------------
470: edw_log.put_line(' ');
471: edw_log.put_line('Inserted '||nvl(l_row_count,0)||
472: ' rows into the staging table');
473: edw_log.put_line(' Calling EDW_COLLECTION_UTIL.wrapup');
474:
475: EDW_COLLECTION_UTIL.wrapup(TRUE,
476: l_row_count,
477: l_exception_msg,

Line 481: edw_log.put_line(' Calling UPDATE opi_ids_push_log');

477: l_exception_msg,
478: l_from_date,
479: l_to_date);
480:
481: edw_log.put_line(' Calling UPDATE opi_ids_push_log');
482: --dbms_output.put_line('after wrapup ' || to_char(Sysdate, 'hh24:mi:ss'));
483: UPDATE opi_ids_push_log
484: SET push_flag=0,
485: last_update_date=sysdate

Line 512: edw_log.put_line( l_exception_msg);

508:
509: Retcode:= 1; -- completed with warning
510: l_exception_msg := Retcode || ':' || Errbuf;
511: rollback;
512: edw_log.put_line( l_exception_msg);
513: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
514: l_from_date, l_to_date);
515: --dbms_output.put_line('currency_conv_rate_not_exist ' || l_exception_msg);
516: --raise;

Line 524: edw_log.put_line( l_exception_msg);

520:
521: Retcode:=sqlcode;
522: l_exception_msg := Retcode || ':' || Errbuf;
523: rollback;
524: edw_log.put_line( l_exception_msg);
525: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
526: l_from_date, l_to_date);
527: --dbms_output.put_line('no or too many ' || l_exception_msg);
528: raise;

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

530: Errbuf:= Sqlerrm;
531: Retcode:=sqlcode;
532: l_exception_msg := Retcode || ':' || Errbuf;
533: rollback;
534: edw_log.put_line('Other errors');
535: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
536: l_from_date, l_to_date);
537: raise;
538: