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 EDW_LOG

Line 657: EDW_LOG.Put_Line( 'The collection range is from '||

653: ISC_EDW_BACKLOGS_F_C.G_Push_From_Date := nvl(l_from_date,
654: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
655: ISC_EDW_BACKLOGS_F_C.G_Push_To_Date := nvl(l_to_date,EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
656:
657: EDW_LOG.Put_Line( 'The collection range is from '||
658: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
659: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
660: EDW_LOG.Put_Line(' ');
661:

Line 660: EDW_LOG.Put_Line(' ');

656:
657: EDW_LOG.Put_Line( 'The collection range is from '||
658: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
659: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
660: EDW_LOG.Put_Line(' ');
661:
662: -- ---------------
663: -- Identify Change
664: -- ---------------

Line 666: EDW_LOG.Put_Line('Identifying changed Backlog lines');

662: -- ---------------
663: -- Identify Change
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);

Line 685: EDW_LOG.Put_Line(' ');

681: -- ----------------------------------------------------------
682: -- Identify Missing Rate into ISC_EDW_BACK_MISSING_RATE table
683: -- ----------------------------------------------------------
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:

Line 686: EDW_LOG.Put_Line('Identifying the missing conversion rates (currency and UoM)');

682: -- Identify Missing Rate into ISC_EDW_BACK_MISSING_RATE table
683: -- ----------------------------------------------------------
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);

Line 699: EDW_LOG.Put_Line(' ');

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: -- ----------------------------------------------------------------------
703: -- Inserting into ISC_TMP_BACK rows having missing rate (with seq_id < 0)

Line 706: EDW_LOG.Put_Line(' ');

702: -- ----------------------------------------------------------------------
703: -- Inserting into ISC_TMP_BACK rows having missing rate (with seq_id < 0)
704: -- ----------------------------------------------------------------------
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:

Line 707: EDW_LOG.Put_Line('Inserting into ISC_TMP_BACK with < 0 seq_id the rows having missing conversion rates (currency and UoM)');

703: -- Inserting into ISC_TMP_BACK rows having missing rate (with seq_id < 0)
704: -- ----------------------------------------------------------------------
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;

Line 720: EDW_LOG.Put_Line(' ');

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: -- ----------------------------------------------
724: -- Deleting ISC_TMP_BACK rows having missing rate

Line 727: EDW_LOG.Put_Line(' ');

723: -- ----------------------------------------------
724: -- Deleting ISC_TMP_BACK rows having missing rate
725: -- ----------------------------------------------
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:

Line 728: EDW_LOG.Put_Line('Deleting the ISC_TMP_BACK rows having a missing conversion rates before collecting (currency and UoM)');

724: -- Deleting ISC_TMP_BACK rows having missing rate
725: -- ----------------------------------------------
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 ;

Line 741: EDW_LOG.Put_Line(' ');

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
745: THEN

Line 752: EDW_LOG.Put_Line(' ');

748: -- ---------------------------
749: -- Push to Local staging table
750: -- ---------------------------
751:
752: EDW_LOG.Put_Line(' ');
753: EDW_LOG.Put_Line('Pushing data to local staging');
754:
755: EDW_LOG.Put_Line( 'The collection range is from '||
756: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 753: EDW_LOG.Put_Line('Pushing data to local staging');

749: -- Push to Local staging table
750: -- ---------------------------
751:
752: EDW_LOG.Put_Line(' ');
753: EDW_LOG.Put_Line('Pushing data to local staging');
754:
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'));

Line 755: EDW_LOG.Put_Line( 'The collection range is from '||

751:
752: EDW_LOG.Put_Line(' ');
753: EDW_LOG.Put_Line('Pushing data to local staging');
754:
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;

Line 770: EDW_LOG.Put_Line(' ');

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))
774:

Line 795: EDW_LOG.Put_Line(' ');

791:
792: IF g_all_or_nothing_flag = 'N' -- We collected and report missing conversions
793: THEN
794: retcode := 1;
795: EDW_LOG.Put_Line(' ');
796: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');
797: EDW_LOG.Put_Line(' ');
798: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
799: THEN

Line 796: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');

792: IF g_all_or_nothing_flag = 'N' -- We collected and report missing conversions
793: THEN
794: retcode := 1;
795: EDW_LOG.Put_Line(' ');
796: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');
797: EDW_LOG.Put_Line(' ');
798: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
799: THEN
800: retcode := -1;

Line 797: EDW_LOG.Put_Line(' ');

793: THEN
794: retcode := 1;
795: EDW_LOG.Put_Line(' ');
796: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');
797: EDW_LOG.Put_Line(' ');
798: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
799: THEN
800: retcode := -1;
801: EDW_LOG.Put_Line(' ');

Line 801: EDW_LOG.Put_Line(' ');

797: EDW_LOG.Put_Line(' ');
798: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
799: THEN
800: retcode := -1;
801: EDW_LOG.Put_Line(' ');
802: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
803: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
804: EDW_LOG.Put_Line(' ');
805: END IF; --g_all_or_nothing_flag = 'N'

Line 802: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');

798: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
799: THEN
800: retcode := -1;
801: EDW_LOG.Put_Line(' ');
802: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
803: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
804: EDW_LOG.Put_Line(' ');
805: END IF; --g_all_or_nothing_flag = 'N'
806:

Line 803: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');

799: THEN
800: retcode := -1;
801: EDW_LOG.Put_Line(' ');
802: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
803: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
804: EDW_LOG.Put_Line(' ');
805: END IF; --g_all_or_nothing_flag = 'N'
806:
807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');

Line 804: EDW_LOG.Put_Line(' ');

800: retcode := -1;
801: EDW_LOG.Put_Line(' ');
802: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
803: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
804: EDW_LOG.Put_Line(' ');
805: END IF; --g_all_or_nothing_flag = 'N'
806:
807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');

Line 807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');

803: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
804: EDW_LOG.Put_Line(' ');
805: END IF; --g_all_or_nothing_flag = 'N'
806:
807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
810: EDW_LOG.Put_Line(' ');
811:

Line 808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');

804: EDW_LOG.Put_Line(' ');
805: END IF; --g_all_or_nothing_flag = 'N'
806:
807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
810: EDW_LOG.Put_Line(' ');
811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');

805: END IF; --g_all_or_nothing_flag = 'N'
806:
807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
810: EDW_LOG.Put_Line(' ');
811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');

Line 810: EDW_LOG.Put_Line(' ');

806:
807: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
810: EDW_LOG.Put_Line(' ');
811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
814: EDW_LOG.Put_Line('');

Line 812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

808: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
810: EDW_LOG.Put_Line(' ');
811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
814: EDW_LOG.Put_Line('');
815: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
816: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');

Line 813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');

809: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
810: EDW_LOG.Put_Line(' ');
811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
814: EDW_LOG.Put_Line('');
815: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
816: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
817:

Line 814: EDW_LOG.Put_Line('');

810: EDW_LOG.Put_Line(' ');
811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
814: EDW_LOG.Put_Line('');
815: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
816: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
817:
818: l_row_count := 0;

Line 815: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');

811:
812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
814: EDW_LOG.Put_Line('');
815: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
816: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
817:
818: l_row_count := 0;
819:

Line 816: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');

812: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
813: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
814: EDW_LOG.Put_Line('');
815: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
816: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
817:
818: l_row_count := 0;
819:
820: FOR line IN Missing_Currency_Conversion

Line 823: EDW_LOG.Put_Line( RPAD(line.curr_conv_date,10,' ')

819:
820: FOR line IN Missing_Currency_Conversion
821: LOOP
822: l_row_count := l_row_count + 1;
823: EDW_LOG.Put_Line( RPAD(line.curr_conv_date,10,' ')
824: ||' - '||RPAD(line.from_currency,10,' ')
825: ||' - '||RPAD(line.to_currency,8,' ')
826: ||' - '||RPAD(line.rate_type,15)
827: ||' - '||RPAD(line.status,20));

Line 832: EDW_LOG.Put_Line('');

828: END LOOP;
829:
830: IF l_row_count = 0
831: THEN
832: EDW_LOG.Put_Line('');
833: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
834: EDW_LOG.Put_Line('');
835: END IF;
836:

Line 833: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');

829:
830: IF l_row_count = 0
831: THEN
832: EDW_LOG.Put_Line('');
833: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
834: EDW_LOG.Put_Line('');
835: END IF;
836:
837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 834: EDW_LOG.Put_Line('');

830: IF l_row_count = 0
831: THEN
832: EDW_LOG.Put_Line('');
833: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
834: EDW_LOG.Put_Line('');
835: END IF;
836:
837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
838: EDW_LOG.Put_Line('');

Line 837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

833: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
834: EDW_LOG.Put_Line('');
835: END IF;
836:
837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
838: EDW_LOG.Put_Line('');
839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 838: EDW_LOG.Put_Line('');

834: EDW_LOG.Put_Line('');
835: END IF;
836:
837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
838: EDW_LOG.Put_Line('');
839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');

Line 839: EDW_LOG.Put_Line('');

835: END IF;
836:
837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
838: EDW_LOG.Put_Line('');
839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');

Line 840: EDW_LOG.Put_Line('');

836:
837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
838: EDW_LOG.Put_Line('');
839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');
844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');

Line 841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

837: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
838: EDW_LOG.Put_Line('');
839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');
844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
845: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');

Line 842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');

838: EDW_LOG.Put_Line('');
839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');
844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
845: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
846:

Line 843: EDW_LOG.Put_Line('');

839: EDW_LOG.Put_Line('');
840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');
844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
845: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
846:
847: l_row_count := 0;

Line 844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');

840: EDW_LOG.Put_Line('');
841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');
844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
845: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
846:
847: l_row_count := 0;
848:

Line 845: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');

841: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
842: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
843: EDW_LOG.Put_Line('');
844: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
845: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
846:
847: l_row_count := 0;
848:
849: FOR line IN Missing_UOM_Conversion

Line 852: EDW_LOG.Put_Line( RPAD(line.from_uom_code,8,' ')

848:
849: FOR line IN Missing_UOM_Conversion
850: LOOP
851: l_row_count := l_row_count + 1;
852: EDW_LOG.Put_Line( RPAD(line.from_uom_code,8,' ')
853: ||' - '||RPAD(line.to_uom_code,8,' ')
854: ||' - '||RPAD(line.item_id,8,' ')
855: ||' - '||RPAD(line.item_name,42));
856: END LOOP;

Line 860: EDW_LOG.Put_Line('');

856: END LOOP;
857:
858: IF l_row_count = 0
859: THEN
860: EDW_LOG.Put_Line('');
861: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
862: EDW_LOG.Put_Line('');
863: END IF;
864:

Line 861: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');

857:
858: IF l_row_count = 0
859: THEN
860: EDW_LOG.Put_Line('');
861: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
862: EDW_LOG.Put_Line('');
863: END IF;
864:
865: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 862: EDW_LOG.Put_Line('');

858: IF l_row_count = 0
859: THEN
860: EDW_LOG.Put_Line('');
861: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
862: EDW_LOG.Put_Line('');
863: END IF;
864:
865: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
866:

Line 865: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

861: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
862: EDW_LOG.Put_Line('');
863: END IF;
864:
865: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
866:
867: END; -- begin IF g_miss_conv > 0
868: END IF; -- IF g_miss_conv > 0
869:

Line 885: EDW_LOG.Put_Line(' ');

881: -- No exception raised so far. Successful. Call
882: -- wrapup to commit and insert messages into logs
883: -- ----------------------------------------------
884:
885: EDW_LOG.Put_Line(' ');
886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');

Line 886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');

882: -- wrapup to commit and insert messages into logs
883: -- ----------------------------------------------
884:
885: EDW_LOG.Put_Line(' ');
886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');
890: EDW_LOG.Put_Line('Start of the Wrapup section ');

Line 887: EDW_LOG.Put_Line(' ');

883: -- ----------------------------------------------
884:
885: EDW_LOG.Put_Line(' ');
886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');
890: EDW_LOG.Put_Line('Start of the Wrapup section ');
891: EDW_LOG.Put_Line(' ');

Line 888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

884:
885: EDW_LOG.Put_Line(' ');
886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');
890: EDW_LOG.Put_Line('Start of the Wrapup section ');
891: EDW_LOG.Put_Line(' ');
892:

Line 889: EDW_LOG.Put_Line(' ');

885: EDW_LOG.Put_Line(' ');
886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');
890: EDW_LOG.Put_Line('Start of the Wrapup section ');
891: EDW_LOG.Put_Line(' ');
892:
893: IF retcode = -1

Line 890: EDW_LOG.Put_Line('Start of the Wrapup section ');

886: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');
890: EDW_LOG.Put_Line('Start of the Wrapup section ');
891: EDW_LOG.Put_Line(' ');
892:
893: IF retcode = -1
894: THEN

Line 891: EDW_LOG.Put_Line(' ');

887: EDW_LOG.Put_Line(' ');
888: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
889: EDW_LOG.Put_Line(' ');
890: EDW_LOG.Put_Line('Start of the Wrapup section ');
891: EDW_LOG.Put_Line(' ');
892:
893: IF retcode = -1
894: THEN
895: EDW_COLLECTION_UTIL.Wrapup(

Line 920: EDW_LOG.Put_Line(g_errbuf);

916: EXCEPTION
917:
918: WHEN L_FAILURE THEN
919: ROLLBACK;
920: EDW_LOG.Put_Line(g_errbuf);
921: retcode := -1;
922: EDW_COLLECTION_UTIL.Wrapup(
923: FALSE,
924: g_rows_collected,

Line 932: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);

928:
929: WHEN OTHERS THEN
930: ROLLBACK;
931: g_errbuf := sqlerrm ||' - '|| sqlcode;
932: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);
933: retcode := -1;
934: EDW_COLLECTION_UTIL.Wrapup(
935: FALSE,
936: g_rows_collected,