APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C dependencies on EDW_COLLECTION_UTIL

Line 503: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN

499: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
500:
501:
502:
503: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN
504: errbuf := fnd_message.get;
505: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
506: Return;
507: END IF;

Line 514: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

510: -- Taking care of cases where the input from/to
511: -- date is NULL.
512: -- --------------------------------------------
513: g_push_from_date := nvl(l_from_date,
514: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
515: EDW_COLLECTION_UTIL.g_offset);
516: g_push_to_date := nvl(l_to_date,
517: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
518: edw_log.put_line( 'The collection range is from '||

Line 515: EDW_COLLECTION_UTIL.g_offset);

511: -- date is NULL.
512: -- --------------------------------------------
513: g_push_from_date := nvl(l_from_date,
514: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
515: EDW_COLLECTION_UTIL.g_offset);
516: g_push_to_date := nvl(l_to_date,
517: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
518: edw_log.put_line( 'The collection range is from '||
519: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 517: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

513: g_push_from_date := nvl(l_from_date,
514: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
515: EDW_COLLECTION_UTIL.g_offset);
516: g_push_to_date := nvl(l_to_date,
517: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
518: edw_log.put_line( 'The collection range is from '||
519: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
520: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
521: edw_log.put_line(' ');

Line 573: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,

569: ||PRIMARY_KEY5||PRIMARY_KEY6
570: from OPI_EDW_OPMINV_DAILY_STAT_INC
571: WHERE SEQ_ID is NULL);
572:
573: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
574: g_push_from_date, g_push_to_date);
575:
576:
577:

Line 590: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);

586: Retcode:=g_retcode;
587: l_exception_msg := Retcode || ':' || Errbuf;
588: rollback; -- Rollback insert into local staging
589: edw_log.put_line('Inserting into local staging have failed');
590: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
591: raise;
592:
593: WHEN L_IDEN_CHANGE_FAILURE THEN
594: Errbuf:=g_errbuf;

Line 598: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);

594: Errbuf:=g_errbuf;
595: Retcode:=g_retcode;
596: l_exception_msg := Retcode || ':' || Errbuf;
597: edw_log.put_line('Identifying changed records have Failed');
598: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
599: raise;
600:
601: WHEN OTHERS THEN
602: Errbuf:=g_errbuf;

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

603: Retcode:=g_retcode;
604: l_exception_msg := Retcode || ':' || Errbuf;
605: rollback;
606: edw_log.put_line('Other errors');
607: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
608: g_push_from_date, g_push_to_date);
609: raise;
610:
611: END;