APPS.OPI_EDW_INV_DAILY_STAT_F_C dependencies on EDW_COLLECTION_UTIL

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 79: -- call edw_collection_util.setup

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
80: -- -------------------------------------------
81: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
82: l_staging_table,
83: l_staging_table,

Line 81: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,

77: --dbms_output.put_line(p_to_date);
78: -- -------------------------------------------
79: -- call edw_collection_util.setup
80: -- -------------------------------------------
81: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
82: l_staging_table,
83: l_staging_table,
84: l_exception_msg)) THEN
85: errbuf := fnd_message.get;

Line 110: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

106: -- date is NULL.
107: -- --------------------------------------------
108:
109: l_from_date := nvl(l_from_date,
110: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
111: EDW_COLLECTION_UTIL.g_offset);
112: l_to_date := nvl(l_to_date,
113: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
114:

Line 111: EDW_COLLECTION_UTIL.g_offset);

107: -- --------------------------------------------
108:
109: l_from_date := nvl(l_from_date,
110: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
111: EDW_COLLECTION_UTIL.g_offset);
112: l_to_date := nvl(l_to_date,
113: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
114:
115:

Line 113: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

109: l_from_date := nvl(l_from_date,
110: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
111: EDW_COLLECTION_UTIL.g_offset);
112: l_to_date := nvl(l_to_date,
113: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
114:
115:
116: -- End of code change for bug fix 2140267.
117:

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 475: EDW_COLLECTION_UTIL.wrapup(TRUE,

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,
478: l_from_date,
479: l_to_date);

Line 513: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

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;
517:

Line 525: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

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;
529: WHEN OTHERS THEN

Line 535: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

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:
539: