APPS.POA_EDW_PO_DIST_F_C dependencies on EDW_COLLECTION_UTIL

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

696:
697: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
698: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
699:
700: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,
701: l_staging_table, l_exception_msg)) THEN
702: errbuf := fnd_message.get;
703: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
704: END IF;

Line 711: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

707: -- Taking care of cases where the input from/to
708: -- date is NULL.
709: -- --------------------------------------------
710: g_push_from_date := nvl(l_from_date,
711: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
712: EDW_COLLECTION_UTIL.g_offset);
713:
714: g_push_to_date := nvl(l_to_date,
715: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

Line 712: EDW_COLLECTION_UTIL.g_offset);

708: -- date is NULL.
709: -- --------------------------------------------
710: g_push_from_date := nvl(l_from_date,
711: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
712: EDW_COLLECTION_UTIL.g_offset);
713:
714: g_push_to_date := nvl(l_to_date,
715: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
716:

Line 715: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

711: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
712: EDW_COLLECTION_UTIL.g_offset);
713:
714: g_push_to_date := nvl(l_to_date,
715: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
716:
717: edw_log.put_line( 'The collection range is from '||
718: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
719: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

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

829: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
830: ' rows into the staging table');
831: edw_log.put_line(' ');
832:
833: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
834: g_push_from_date, g_push_to_date);
835:
836:
837: -- ---------------------------------------------------------------------------

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

850:
851: l_exception_msg := Retcode || ':' || Errbuf;
852: rollback; -- Rollback insert into local staging
853: edw_log.put_line('Inserting into local staging have failed');
854: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
855: g_push_from_date, g_push_to_date);
856: raise;
857:
858: WHEN L_IDEN_CHANGE_FAILURE THEN

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

865:
866: l_exception_msg := Retcode || ':' || Errbuf;
867: rollback;
868: edw_log.put_line('Identifying changed records have Failed');
869: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
870: g_push_from_date, g_push_to_date);
871: raise;
872:
873: WHEN OTHERS THEN

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

880:
881: l_exception_msg := Retcode || ':' || Errbuf;
882: rollback;
883: edw_log.put_line('Other errors');
884: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
885: g_push_from_date, g_push_to_date);
886: raise;
887:
888: END;