APPS.POA_EDW_ALINES_F_C dependencies on EDW_COLLECTION_UTIL

Line 485: IF (NOT EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,

481:
482: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
483: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
484:
485: IF (NOT EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,
486: l_staging_table, l_exception_msg)) THEN
487: errbuf := fnd_message.get;
488: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
489: END IF;

Line 496: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

492: -- Taking care of cases where the input from/to
493: -- date is NULL.
494: -- --------------------------------------------
495: g_push_date_range1 := nvl(l_from_date,
496: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
497: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
498:
499: edw_log.put_line( 'The collection range is from '||
500: to_char(g_push_date_range1, 'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 497: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

493: -- date is NULL.
494: -- --------------------------------------------
495: g_push_date_range1 := nvl(l_from_date,
496: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
497: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
498:
499: edw_log.put_line( 'The collection range is from '||
500: to_char(g_push_date_range1, 'MM/DD/YYYY HH24:MI:SS')||' to '||
501: to_char(g_push_date_range2, 'MM/DD/YYYY HH24:MI:SS'));

Line 594: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,

590: edw_log.put_line(' ');
591: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
592: edw_log.put_line(' ');
593:
594: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
595: P_PERIOD_START => g_push_date_range1,
596: P_PERIOD_END => g_push_date_range2);
597:
598: EXCEPTION

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

607:
608: l_exception_msg := Retcode || ':' || Errbuf;
609: rollback; -- Rollback insert into local staging
610: edw_log.put_line('Inserting into local staging have failed');
611: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
612: g_push_date_range1, g_push_date_range2);
613: raise;
614:
615: WHEN L_IDEN_CHANGE_FAILURE THEN

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

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

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

637:
638: l_exception_msg := Retcode || ':' || Errbuf;
639: rollback;
640: edw_log.put_line('Other errors');
641: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
642: g_push_date_range1, g_push_date_range2);
643: raise;
644:
645: End;