[Home] [Help]
538: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
539: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
540: l_conversion_date := to_date(p_currency_conversion_date, 'YYYY/MM/DD HH24:MI:SS');
541:
542: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
543: errbuf := fnd_message.get;
544: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
545: END IF;
546:
544: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
545: END IF;
546:
547: FII_PA_BUDGET_F_C.g_push_date_range1 := nvl(l_from_date,
548: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
549:
550: FII_PA_BUDGET_F_C.g_push_date_range2 := nvl(l_to_date,
551: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
552:
547: FII_PA_BUDGET_F_C.g_push_date_range1 := nvl(l_from_date,
548: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
549:
550: FII_PA_BUDGET_F_C.g_push_date_range2 := nvl(l_to_date,
551: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
552:
553: l_date1 := g_push_date_range1;
554: l_date2 := g_push_date_range2;
555:
764:
765: END IF;
766: */
767: Retcode := g_retcode;
768: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
769: if (g_missing_rates >0) then
770:
771: if g_debug_flag = 'Y' then
772: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
782: l_exception_msg := Retcode || ':' || Errbuf;
783: if g_debug_flag = 'Y' then
784: edw_log.put_line('ERROR: Identifying changed records have Failed');
785: end if;
786: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
787: WHEN L_PUSH_LOCAL_FAILURE THEN
788: rollback;
789: Errbuf:=g_errbuf;
790: Retcode:=g_retcode;
791: l_exception_msg := Retcode || ':' || Errbuf;
792: if g_debug_flag = 'Y' then
793: edw_log.put_line('ERROR: Inserting into local staging have failed');
794: end if;
795: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
796: WHEN L_PUSH_REMOTE_FAILURE THEN
797: rollback;
798: Errbuf:=g_errbuf;
799: Retcode:=g_retcode;
800: l_exception_msg := Retcode || ':' || Errbuf;
801: if g_debug_flag = 'Y' then
802: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');
803: end if;
804: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
805: WHEN L_SET_STATUS_FAILURE THEN
806: rollback;
807: Errbuf:=g_errbuf;
808: Retcode:=g_retcode;
809: l_exception_msg := Retcode || ':' || Errbuf;
810: if g_debug_flag = 'Y' then
811: edw_log.put_line('ERROR: Setting status to READY have failed');
812: end if;
813: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
814: WHEN L_TRUNCATE_TMP_PK_FAILURE THEN
815: rollback;
816: Errbuf:=g_errbuf;
817: Retcode:=g_retcode;
819: if g_debug_flag = 'Y' then
820: edw_log.put_line('ERROR: Clean-up of primary key table failed');
821: edw_log.put_line(' ');
822: end if;
823: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
824: WHEN OTHERS THEN
825: rollback;
826: Errbuf:=sqlerrm;
827: Retcode:=sqlcode;
825: rollback;
826: Errbuf:=sqlerrm;
827: Retcode:=sqlcode;
828: l_exception_msg := Retcode || ':' || Errbuf;
829: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
830: raise;
831:
832: End;
833: End FII_PA_BUDGET_F_C;