eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_PA_COST_F_C dependencies on EDW_COLLECTION_UTIL

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

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

Line 590: raise_application_error(-20000,'Error in EDW_COLLECTION_UTIL.SETUP: ' || errbuf);

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

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

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

Line 597: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

593: FII_PA_COST_F_C.g_push_date_range1 := nvl(l_from_date,
594: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
595:
596: FII_PA_COST_F_C.g_push_date_range2 := nvl(l_to_date,
597: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
598: l_date1 := g_push_date_range1;
599: l_date2 := g_push_date_range2;
600:
601: if g_debug_flag = 'Y' then

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

829: edw_log.put_line(' ');
830: end if;
831:
832: Retcode := g_retcode;
833: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
834: if (g_missing_rates >0) then
835:
836: if g_debug_flag = 'Y' then
837: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

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

849: edw_log.put_line(' ');
850: edw_log.put_line('ERROR: Identifying changed records have failed');
851: edw_log.put_line(' ');
852: end if;
853: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
854: WHEN L_PUSH_LOCAL_FAILURE THEN
855: rollback;
856: Errbuf:=g_errbuf;
857: Retcode:=g_retcode;

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

860: edw_log.put_line(' ');
861: edw_log.put_line('ERROR: Inserting into local staging have failed');
862: edw_log.put_line(' ');
863: end if;
864: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
865: WHEN L_PUSH_REMOTE_FAILURE THEN
866: rollback;
867: Errbuf:=g_errbuf;
868: Retcode:=g_retcode;

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

871: edw_log.put_line(' ');
872: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');
873: edw_log.put_line(' ');
874: end if;
875: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
876: WHEN L_SET_STATUS_FAILURE THEN
877: rollback;
878: Errbuf:=g_errbuf;
879: Retcode:=g_retcode;

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

882: edw_log.put_line(' ');
883: edw_log.put_line('ERROR: Setting status to READY have failed');
884: edw_log.put_line(' ');
885: end if;
886: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
887: WHEN L_TRUNCATE_TMP_PK_FAILURE THEN
888: rollback;
889: Errbuf:=g_errbuf;
890: Retcode:=g_retcode;

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

892: if g_debug_flag = 'Y' then
893: edw_log.put_line('ERROR: Clean-up of primary key table failed');
894: edw_log.put_line(' ');
895: end if;
896: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
897: WHEN OTHERS THEN
898: rollback;
899: Errbuf:=sqlerrm;
900: Retcode:=sqlcode;

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

898: rollback;
899: Errbuf:=sqlerrm;
900: Retcode:=sqlcode;
901: l_exception_msg := Retcode || ':' || Errbuf;
902: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
903: raise;
904:
905: End Push;
906: