APPS.OPI_EDW_OPMCOGS_F_C dependencies on EDW_COLLECTION_UTIL

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

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

Line 515: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

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

Line 516: EDW_COLLECTION_UTIL.g_offset);

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

Line 518: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

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

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

597: edw_log.put_line(' ');
598: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
599: ' rows into the staging table');
600: edw_log.put_line(' ');
601: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
602: g_push_from_date, g_push_to_date);
603: -- ---------------------------------------------------------------------------
604: -- END OF Collection , Developer Customizable Section
605: -- ---------------------------------------------------------------------------

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

609: Retcode:=g_retcode;
610: l_exception_msg := Retcode || ':' || Errbuf;
611: rollback; -- Rollback insert into local staging
612: edw_log.put_line('Inserting into local staging have failed');
613: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
614: g_push_from_date, g_push_to_date);
615: l_exception_msg := Retcode || ':' || Errbuf;
616: delete OPI_EDW_OPMCOGS_INC;
617: commit;

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

622: l_exception_msg := Retcode || ':' || Errbuf;
623: delete OPI_EDW_OPMCOGS_INC;
624: commit;
625: edw_log.put_line('Identifying changed records have Failed');
626: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
627: g_push_from_date, g_push_to_date);
628: raise;
629: WHEN OTHERS THEN
630: Errbuf:=g_errbuf;

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

631: Retcode:=g_retcode;
632: l_exception_msg := Retcode || ':' || Errbuf;
633: rollback;
634: edw_log.put_line('Other errors');
635: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
636: g_push_from_date, g_push_to_date);
637: l_exception_msg := Retcode || ':' || Errbuf;
638: delete OPI_EDW_OPMCOGS_INC;
639: commit;