433:
434: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
435: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
436:
437: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,
438: l_staging_table, l_exception_msg)) THEN
439: errbuf := fnd_message.get;
440: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
441: END IF;
440: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
441: END IF;
442:
443: g_push_date_range1 := nvl(l_from_date,
444: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
445: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
446:
447: edw_log.put_line( 'The collection range is from '||
448: to_char(g_push_date_range1, 'MM/DD/YYYY HH24:MI:SS')||' to '||
441: END IF;
442:
443: g_push_date_range1 := nvl(l_from_date,
444: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
445: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
446:
447: edw_log.put_line( 'The collection range is from '||
448: to_char(g_push_date_range1, 'MM/DD/YYYY HH24:MI:SS')||' to '||
449: to_char(g_push_date_range2, 'MM/DD/YYYY HH24:MI:SS'));
538: edw_log.put_line(' ');
539: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
540: edw_log.put_line(' ');
541:
542: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
543: P_PERIOD_START => g_push_date_range1,
544: P_PERIOD_END => g_push_date_range2);
545:
546: EXCEPTION
555:
556: l_exception_msg := Retcode || ':' || Errbuf;
557: rollback; -- Rollback insert into local staging
558: edw_log.put_line('Inserting into local staging have failed');
559: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
560: g_push_date_range1, g_push_date_range2);
561: raise;
562:
563: WHEN L_IDEN_CHANGE_FAILURE THEN
570:
571: l_exception_msg := Retcode || ':' || Errbuf;
572: TRUNCATE_INC;
573: edw_log.put_line('Identifying changed records have Failed');
574: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
575: g_push_date_range1, g_push_date_range2);
576: raise;
577:
578: WHEN OTHERS THEN
585:
586: l_exception_msg := Retcode || ':' || Errbuf;
587: rollback;
588: edw_log.put_line('Other errors');
589: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
590: g_push_date_range1, g_push_date_range2);
591: raise;
592:
593: End;