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.ISC_EDW_BACKLOGS_F_C dependencies on FII_UTIL

Line 668: FII_UTIL.Start_Timer;

664: -- ---------------
665:
666: EDW_LOG.Put_Line('Identifying changed Backlog lines');
667:
668: FII_UTIL.Start_Timer;
669:
670: g_seq_id_line := IDENTIFY_CHANGE(-1,l_row_count);
671:
672: FII_UTIL.Stop_Timer;

Line 672: FII_UTIL.Stop_Timer;

668: FII_UTIL.Start_Timer;
669:
670: g_seq_id_line := IDENTIFY_CHANGE(-1,l_row_count);
671:
672: FII_UTIL.Stop_Timer;
673:
674: IF (g_seq_id_line = -1)
675: THEN RAISE l_failure;
676: END IF;

Line 678: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in');

674: IF (g_seq_id_line = -1)
675: THEN RAISE l_failure;
676: END IF;
677:
678: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in');
679:
680:
681: -- ----------------------------------------------------------
682: -- Identify Missing Rate into ISC_EDW_BACK_MISSING_RATE table

Line 688: FII_UTIL.Start_Timer;

684:
685: EDW_LOG.Put_Line(' ');
686: EDW_LOG.Put_Line('Identifying the missing conversion rates (currency and UoM)');
687:
688: FII_UTIL.Start_Timer;
689:
690: g_miss_conv := Identify_Missing_Rate(l_row_count);
691:
692: FII_UTIL.Stop_Timer;

Line 692: FII_UTIL.Stop_Timer;

688: FII_UTIL.Start_Timer;
689:
690: g_miss_conv := Identify_Missing_Rate(l_row_count);
691:
692: FII_UTIL.Stop_Timer;
693:
694: IF (g_miss_conv = -1)
695: THEN RAISE l_failure;
696: END IF;

Line 698: FII_UTIL.Print_Timer('Inserted '||g_miss_conv||' rows into the ISC_EDW_BACK_MISSING_RATE table in ');

694: IF (g_miss_conv = -1)
695: THEN RAISE l_failure;
696: END IF;
697:
698: FII_UTIL.Print_Timer('Inserted '||g_miss_conv||' rows into the ISC_EDW_BACK_MISSING_RATE table in ');
699: EDW_LOG.Put_Line(' ');
700:
701:
702: -- ----------------------------------------------------------------------

Line 709: FII_UTIL.Start_Timer;

705:
706: EDW_LOG.Put_Line(' ');
707: EDW_LOG.Put_Line('Inserting into ISC_TMP_BACK with < 0 seq_id the rows having missing conversion rates (currency and UoM)');
708:
709: FII_UTIL.Start_Timer;
710:
711: g_row_count := Insert_Isc_Tmp_Back;
712:
713: FII_UTIL.Stop_Timer;

Line 713: FII_UTIL.Stop_Timer;

709: FII_UTIL.Start_Timer;
710:
711: g_row_count := Insert_Isc_Tmp_Back;
712:
713: FII_UTIL.Stop_Timer;
714:
715: IF (g_row_count = -1)
716: THEN RAISE l_failure;
717: END IF;

Line 719: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows into the ISC_TMP_BACK table in ');

715: IF (g_row_count = -1)
716: THEN RAISE l_failure;
717: END IF;
718:
719: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows into the ISC_TMP_BACK table in ');
720: EDW_LOG.Put_Line(' ');
721:
722:
723: -- ----------------------------------------------

Line 730: FII_UTIL.Start_Timer;

726:
727: EDW_LOG.Put_Line(' ');
728: EDW_LOG.Put_Line('Deleting the ISC_TMP_BACK rows having a missing conversion rates before collecting (currency and UoM)');
729:
730: FII_UTIL.Start_Timer;
731:
732: g_row_count := Delete_Isc_Tmp_Back ;
733:
734: FII_UTIL.Stop_Timer;

Line 734: FII_UTIL.Stop_Timer;

730: FII_UTIL.Start_Timer;
731:
732: g_row_count := Delete_Isc_Tmp_Back ;
733:
734: FII_UTIL.Stop_Timer;
735:
736: IF (g_row_count = -1)
737: THEN RAISE l_failure;
738: END IF;

Line 740: FII_UTIL.Print_Timer('Deleted '||g_row_count||' rows from the ISC_TMP_BACK table in ');

736: IF (g_row_count = -1)
737: THEN RAISE l_failure;
738: END IF;
739:
740: FII_UTIL.Print_Timer('Deleted '||g_row_count||' rows from the ISC_TMP_BACK table in ');
741: EDW_LOG.Put_Line(' ');
742:
743:
744: IF NOT ((g_all_or_nothing_flag = 'Y') and (g_miss_conv > 0)) -- collect except when this condition applies

Line 759: FII_UTIL.Start_Timer;

755: EDW_LOG.Put_Line( 'The collection range is from '||
756: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
757: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
758:
759: FII_UTIL.Start_Timer;
760:
761: g_rows_collected := Push_To_Local(g_seq_id_line);
762:
763: FII_UTIL.Stop_Timer;

Line 763: FII_UTIL.Stop_Timer;

759: FII_UTIL.Start_Timer;
760:
761: g_rows_collected := Push_To_Local(g_seq_id_line);
762:
763: FII_UTIL.Stop_Timer;
764:
765: IF (g_rows_collected = -1)
766: THEN RAISE l_failure;
767: END IF;

Line 769: FII_UTIL.Print_Timer('Inserted '||g_rows_collected||' rows into the local staging table in ');

765: IF (g_rows_collected = -1)
766: THEN RAISE l_failure;
767: END IF;
768:
769: FII_UTIL.Print_Timer('Inserted '||g_rows_collected||' rows into the local staging table in ');
770: EDW_LOG.Put_Line(' ');
771:
772: END;
773: END IF; -- IF NOT ((g_all_or_nothing_flag = 'Y') and (g_miss_conv > 0))