APPS.POA_EDW_RCV_TXNS_F_C dependencies on EDW_COLLECTION_UTIL

Line 459: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,

455:
456: Errbuf :=NULL;
457: Retcode:=0;
458:
459: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,
460: l_staging_table, l_exception_msg)) THEN
461: errbuf := fnd_message.get;
462: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
463: END IF;

Line 469: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

465: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
466: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
467:
468: g_push_from_date := NVL(l_from_date,
469: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
470: EDW_COLLECTION_UTIL.g_offset);
471: g_push_to_date := NVL(l_to_date,
472: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
473:

Line 470: EDW_COLLECTION_UTIL.g_offset);

466: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
467:
468: g_push_from_date := NVL(l_from_date,
469: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
470: EDW_COLLECTION_UTIL.g_offset);
471: g_push_to_date := NVL(l_to_date,
472: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
473:
474: edw_log.put_line( 'The collection range is from '||

Line 472: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

468: g_push_from_date := NVL(l_from_date,
469: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
470: EDW_COLLECTION_UTIL.g_offset);
471: g_push_to_date := NVL(l_to_date,
472: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
473:
474: edw_log.put_line( 'The collection range is from '||
475: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
476: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 561: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,

557: edw_log.put_line(' ');
558: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
559: edw_log.put_line(' ');
560:
561: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
562: P_PERIOD_START => g_push_from_date,
563: P_PERIOD_END => g_push_to_date);
564:
565: EXCEPTION

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

574:
575: l_exception_msg := Retcode || ':' || Errbuf;
576: rollback; -- Rollback insert into local staging
577: edw_log.put_line('Inserting into local staging have failed');
578: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
579: g_push_from_date, g_push_to_date);
580: raise;
581:
582: WHEN L_IDEN_CHANGE_FAILURE THEN

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

589:
590: l_exception_msg := Retcode || ':' || Errbuf;
591: TRUNCATE_INC;
592: edw_log.put_line('Identifying changed records have Failed');
593: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
594: g_push_from_date, g_push_to_date);
595: raise;
596:
597: WHEN OTHERS THEN

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

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