APPS.OPI_EDW_COGS_F_C dependencies on EDW_COLLECTION_UTIL

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

509: Errbuf :=NULL;
510: Retcode:=0;
511:
512:
513: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
514: l_staging_table,
515: l_staging_table,
516: l_exception_msg)) THEN
517: errbuf := fnd_message.get;

Line 535: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

531: -- date is NULL.
532: -- --------------------------------------------
533:
534: g_push_from_date := nvl(g_push_from_date,
535: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
536: EDW_COLLECTION_UTIL.g_offset);
537: g_push_to_date := nvl(g_push_to_date,
538: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
539:

Line 536: EDW_COLLECTION_UTIL.g_offset);

532: -- --------------------------------------------
533:
534: g_push_from_date := nvl(g_push_from_date,
535: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
536: EDW_COLLECTION_UTIL.g_offset);
537: g_push_to_date := nvl(g_push_to_date,
538: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
539:
540:

Line 538: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

534: g_push_from_date := nvl(g_push_from_date,
535: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
536: EDW_COLLECTION_UTIL.g_offset);
537: g_push_to_date := nvl(g_push_to_date,
538: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
539:
540:
541: -- End of code change for bug fix 2140267.
542:

Line 724: EDW_COLLECTION_UTIL.wrapup(TRUE,

720: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
721: ' rows into the staging table');
722: edw_log.put_line(' ');
723:
724: EDW_COLLECTION_UTIL.wrapup(TRUE,
725: g_row_count,
726: l_exception_msg,
727: g_push_from_date,
728: g_push_to_date);

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

745: Retcode:= 1; -- completed with warning
746: l_exception_msg := Retcode || ':' || Errbuf;
747: rollback;
748: edw_log.put_line( l_exception_msg);
749: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
750: g_push_from_date, g_push_to_date);
751:
752: WHEN L_PUSH_LOCAL_FAILURE THEN
753: Errbuf:=g_errbuf;

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

754: Retcode:=g_retcode;
755: l_exception_msg := Retcode || ':' || Errbuf;
756: rollback; -- Rollback insert into local staging
757: edw_log.put_line('Inserting into local staging have failed');
758: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
759: g_push_from_date, g_push_to_date);
760: raise;
761:
762: WHEN L_IDEN_CHANGE_FAILURE THEN

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

769: execute immediate 'truncate table ' || l_opi_schema
770: || '.opi_edw_cogs_inc ';
771: END IF;
772: edw_log.put_line('Identifying changed records have Failed');
773: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
774: g_push_from_date, g_push_to_date);
775: raise;
776:
777: WHEN OTHERS THEN

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

779: Retcode:=sqlcode;
780: l_exception_msg := Retcode || ':' || Errbuf;
781: rollback;
782: edw_log.put_line('Other errors');
783: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
784: g_push_from_date, g_push_to_date);
785: raise;
786:
787: END push;