APPS.FII_PA_REVENUE_F_C dependencies on EDW_COLLECTION_UTIL

Line 590: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN

586:
587: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
588: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
589:
590: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
591: errbuf := fnd_message.get;
592: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
593: END IF;
594:

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

592: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
593: END IF;
594:
595: FII_PA_REVENUE_F_C.g_push_date_range1 := nvl(l_from_date,
596: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
597:
598: FII_PA_REVENUE_F_C.g_push_date_range2 := nvl(l_to_date,
599: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
600:

Line 599: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

595: FII_PA_REVENUE_F_C.g_push_date_range1 := nvl(l_from_date,
596: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
597:
598: FII_PA_REVENUE_F_C.g_push_date_range2 := nvl(l_to_date,
599: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
600:
601: l_date1 := g_push_date_range1;
602: l_date2 := g_push_date_range2;
603:

Line 809: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);

805:
806: END IF;
807: */
808: Retcode := g_retcode;
809: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
810: if (g_missing_rates >0) then
811:
812: if g_debug_flag = 'Y' then
813: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

Line 826: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

822: l_exception_msg := Retcode || ':' || Errbuf;
823: if g_debug_flag = 'Y' then
824: edw_log.put_line('ERROR: Identifying changed records have Failed');
825: end if;
826: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
827: WHEN L_PUSH_LOCAL_FAILURE THEN
828: rollback;
829: Errbuf:=g_errbuf;
830: Retcode:=g_retcode;

Line 835: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

831: l_exception_msg := Retcode || ':' || Errbuf;
832: if g_debug_flag = 'Y' then
833: edw_log.put_line('ERROR: Inserting into local staging have failed');
834: end if;
835: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
836: WHEN L_PUSH_REMOTE_FAILURE THEN
837: rollback;
838: Errbuf:=g_errbuf;
839: Retcode:=g_retcode;

Line 844: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

840: l_exception_msg := Retcode || ':' || Errbuf;
841: if g_debug_flag = 'Y' then
842: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');
843: end if;
844: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
845: WHEN L_SET_STATUS_FAILURE THEN
846: rollback;
847: Errbuf:=g_errbuf;
848: Retcode:=g_retcode;

Line 853: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

849: l_exception_msg := Retcode || ':' || Errbuf;
850: if g_debug_flag = 'Y' then
851: edw_log.put_line('ERROR: Setting status to READY have failed');
852: end if;
853: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
854: WHEN L_TRUNCATE_TMP_PK_FAILURE THEN
855: rollback;
856: Errbuf:=g_errbuf;
857: Retcode:=g_retcode;

Line 863: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

859: if g_debug_flag = 'Y' then
860: edw_log.put_line('ERROR: Clean-up of primary key table failed');
861: edw_log.put_line(' ');
862: end if;
863: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
864: WHEN OTHERS THEN
865: rollback;
866: Errbuf:=sqlerrm;
867: Retcode:=sqlcode;

Line 869: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

865: rollback;
866: Errbuf:=sqlerrm;
867: Retcode:=sqlcode;
868: l_exception_msg := Retcode || ':' || Errbuf;
869: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
870: raise;
871:
872: End;
873: End FII_PA_REVENUE_F_C;