[Home] [Help]
758: l_err_loc PLS_INTEGER;
759: l_module_name VARCHAR2(80);
760: BEGIN
761: l_err_loc := 100;
762: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
763: l_err_loc := 200;
764: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, p_api_name);
765:
766: l_err_loc := 220;
764: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, p_api_name);
765:
766: l_err_loc := 220;
767: l_log_string := 'logPLSQLTableRow('||p_action_mode||')['||p_index||']--';
768: FND_LOG.string(p_log_level, l_module_name, l_log_string);
769:
770: l_err_loc := 240;
771: IF (p_action_mode = 'INSERT_CTX_HDRS') THEN
772: l_err_loc := 300;
772: l_err_loc := 300;
773: -- INSERT icx_cat_items_ctx_hdrs_tlp
774: l_log_string := ' gIHInventoryItemIdTbl['||p_index||']: ' ||
775: ICX_CAT_UTIL_PVT.getTableElement(gIHInventoryItemIdTbl, p_index) || '; ';
776: FND_LOG.string(p_log_level, l_module_name, l_log_string);
777:
778: l_log_string := ' gIHPoLineIdTbl['||p_index||']: ' ||
779: ICX_CAT_UTIL_PVT.getTableElement(gIHPoLineIdTbl, p_index) || '; ';
780: FND_LOG.string(p_log_level, l_module_name, l_log_string);
776: FND_LOG.string(p_log_level, l_module_name, l_log_string);
777:
778: l_log_string := ' gIHPoLineIdTbl['||p_index||']: ' ||
779: ICX_CAT_UTIL_PVT.getTableElement(gIHPoLineIdTbl, p_index) || '; ';
780: FND_LOG.string(p_log_level, l_module_name, l_log_string);
781:
782: l_log_string := ' gIHReqTemplateNameTbl['||p_index||']: ' ||
783: ICX_CAT_UTIL_PVT.getTableElement(gIHReqTemplateNameTbl, p_index) || '; ';
784: FND_LOG.string(p_log_level, l_module_name, l_log_string);
780: FND_LOG.string(p_log_level, l_module_name, l_log_string);
781:
782: l_log_string := ' gIHReqTemplateNameTbl['||p_index||']: ' ||
783: ICX_CAT_UTIL_PVT.getTableElement(gIHReqTemplateNameTbl, p_index) || '; ';
784: FND_LOG.string(p_log_level, l_module_name, l_log_string);
785:
786: l_log_string := ' gIHReqTemplateLineNumTbl['||p_index||']: ' ||
787: ICX_CAT_UTIL_PVT.getTableElement(gIHReqTemplateLineNumTbl, p_index) || '; ';
788: FND_LOG.string(p_log_level, l_module_name, l_log_string);
784: FND_LOG.string(p_log_level, l_module_name, l_log_string);
785:
786: l_log_string := ' gIHReqTemplateLineNumTbl['||p_index||']: ' ||
787: ICX_CAT_UTIL_PVT.getTableElement(gIHReqTemplateLineNumTbl, p_index) || '; ';
788: FND_LOG.string(p_log_level, l_module_name, l_log_string);
789:
790: l_log_string := ' gIHOrgIdTbl['||p_index||']: ' ||
791: ICX_CAT_UTIL_PVT.getTableElement(gIHOrgIdTbl, p_index) || '; ';
792: FND_LOG.string(p_log_level, l_module_name, l_log_string);
788: FND_LOG.string(p_log_level, l_module_name, l_log_string);
789:
790: l_log_string := ' gIHOrgIdTbl['||p_index||']: ' ||
791: ICX_CAT_UTIL_PVT.getTableElement(gIHOrgIdTbl, p_index) || '; ';
792: FND_LOG.string(p_log_level, l_module_name, l_log_string);
793:
794: l_log_string := ' gIHLanguageTbl['||p_index||']: ' ||
795: ICX_CAT_UTIL_PVT.getTableElement(gIHLanguageTbl, p_index) || '; ';
796: FND_LOG.string(p_log_level, l_module_name, l_log_string);
792: FND_LOG.string(p_log_level, l_module_name, l_log_string);
793:
794: l_log_string := ' gIHLanguageTbl['||p_index||']: ' ||
795: ICX_CAT_UTIL_PVT.getTableElement(gIHLanguageTbl, p_index) || '; ';
796: FND_LOG.string(p_log_level, l_module_name, l_log_string);
797:
798: l_log_string := ' gIHSourceTypeTbl['||p_index||']: ' ||
799: ICX_CAT_UTIL_PVT.getTableElement(gIHSourceTypeTbl, p_index) || '; ';
800: FND_LOG.string(p_log_level, l_module_name, l_log_string);
796: FND_LOG.string(p_log_level, l_module_name, l_log_string);
797:
798: l_log_string := ' gIHSourceTypeTbl['||p_index||']: ' ||
799: ICX_CAT_UTIL_PVT.getTableElement(gIHSourceTypeTbl, p_index) || '; ';
800: FND_LOG.string(p_log_level, l_module_name, l_log_string);
801:
802: l_log_string := ' gIHItemTypeTbl['||p_index||']: ' ||
803: ICX_CAT_UTIL_PVT.getTableElement(gIHItemTypeTbl, p_index) || '; ';
804: FND_LOG.string(p_log_level, l_module_name, l_log_string);
800: FND_LOG.string(p_log_level, l_module_name, l_log_string);
801:
802: l_log_string := ' gIHItemTypeTbl['||p_index||']: ' ||
803: ICX_CAT_UTIL_PVT.getTableElement(gIHItemTypeTbl, p_index) || '; ';
804: FND_LOG.string(p_log_level, l_module_name, l_log_string);
805:
806: l_log_string := ' gIHPurchasingOrgIdTbl['||p_index||']: ' ||
807: ICX_CAT_UTIL_PVT.getTableElement(gIHPurchasingOrgIdTbl, p_index) || '; ';
808: FND_LOG.string(p_log_level, l_module_name, l_log_string);
804: FND_LOG.string(p_log_level, l_module_name, l_log_string);
805:
806: l_log_string := ' gIHPurchasingOrgIdTbl['||p_index||']: ' ||
807: ICX_CAT_UTIL_PVT.getTableElement(gIHPurchasingOrgIdTbl, p_index) || '; ';
808: FND_LOG.string(p_log_level, l_module_name, l_log_string);
809:
810: l_log_string := ' gIHOwningOrgIdTbl['||p_index||']: ' ||
811: ICX_CAT_UTIL_PVT.getTableElement(gIHOwningOrgIdTbl, p_index) || '; ';
812: FND_LOG.string(p_log_level, l_module_name, l_log_string);
808: FND_LOG.string(p_log_level, l_module_name, l_log_string);
809:
810: l_log_string := ' gIHOwningOrgIdTbl['||p_index||']: ' ||
811: ICX_CAT_UTIL_PVT.getTableElement(gIHOwningOrgIdTbl, p_index) || '; ';
812: FND_LOG.string(p_log_level, l_module_name, l_log_string);
813:
814: l_log_string := ' gIHIpCategoryIdTbl['||p_index||']: ' ||
815: ICX_CAT_UTIL_PVT.getTableElement(gIHIpCategoryIdTbl, p_index) || '; ';
816: FND_LOG.string(p_log_level, l_module_name, l_log_string);
812: FND_LOG.string(p_log_level, l_module_name, l_log_string);
813:
814: l_log_string := ' gIHIpCategoryIdTbl['||p_index||']: ' ||
815: ICX_CAT_UTIL_PVT.getTableElement(gIHIpCategoryIdTbl, p_index) || '; ';
816: FND_LOG.string(p_log_level, l_module_name, l_log_string);
817:
818: l_log_string := ' gIHIpCategoryNameTbl['||p_index||']: ' ||
819: ICX_CAT_UTIL_PVT.getTableElement(gIHIpCategoryNameTbl, p_index) || '; ';
820: FND_LOG.string(p_log_level, l_module_name, l_log_string);
816: FND_LOG.string(p_log_level, l_module_name, l_log_string);
817:
818: l_log_string := ' gIHIpCategoryNameTbl['||p_index||']: ' ||
819: ICX_CAT_UTIL_PVT.getTableElement(gIHIpCategoryNameTbl, p_index) || '; ';
820: FND_LOG.string(p_log_level, l_module_name, l_log_string);
821:
822: l_log_string := ' gIHPoCategoryIdTbl['||p_index||']: ' ||
823: ICX_CAT_UTIL_PVT.getTableElement(gIHPoCategoryIdTbl, p_index) || '; ';
824: FND_LOG.string(p_log_level, l_module_name, l_log_string);
820: FND_LOG.string(p_log_level, l_module_name, l_log_string);
821:
822: l_log_string := ' gIHPoCategoryIdTbl['||p_index||']: ' ||
823: ICX_CAT_UTIL_PVT.getTableElement(gIHPoCategoryIdTbl, p_index) || '; ';
824: FND_LOG.string(p_log_level, l_module_name, l_log_string);
825:
826: l_log_string := ' gIHSupplierIdTbl['||p_index||']: ' ||
827: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierIdTbl, p_index) || '; ';
828: FND_LOG.string(p_log_level, l_module_name, l_log_string);
824: FND_LOG.string(p_log_level, l_module_name, l_log_string);
825:
826: l_log_string := ' gIHSupplierIdTbl['||p_index||']: ' ||
827: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierIdTbl, p_index) || '; ';
828: FND_LOG.string(p_log_level, l_module_name, l_log_string);
829:
830: l_log_string := ' gIHSupplierPartNumTbl['||p_index||']: ' ||
831: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierPartNumTbl, p_index) || '; ';
832: FND_LOG.string(p_log_level, l_module_name, l_log_string);
828: FND_LOG.string(p_log_level, l_module_name, l_log_string);
829:
830: l_log_string := ' gIHSupplierPartNumTbl['||p_index||']: ' ||
831: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierPartNumTbl, p_index) || '; ';
832: FND_LOG.string(p_log_level, l_module_name, l_log_string);
833:
834: l_log_string := ' gIHSupplierPartAuxidTbl['||p_index||']: ' ||
835: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierPartAuxidTbl, p_index) || '; ';
836: FND_LOG.string(p_log_level, l_module_name, l_log_string);
832: FND_LOG.string(p_log_level, l_module_name, l_log_string);
833:
834: l_log_string := ' gIHSupplierPartAuxidTbl['||p_index||']: ' ||
835: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierPartAuxidTbl, p_index) || '; ';
836: FND_LOG.string(p_log_level, l_module_name, l_log_string);
837:
838: l_log_string := ' gIHSupplierSiteIdTbl['||p_index||']: ' ||
839: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierSiteIdTbl, p_index) || '; ';
840: FND_LOG.string(p_log_level, l_module_name, l_log_string);
836: FND_LOG.string(p_log_level, l_module_name, l_log_string);
837:
838: l_log_string := ' gIHSupplierSiteIdTbl['||p_index||']: ' ||
839: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierSiteIdTbl, p_index) || '; ';
840: FND_LOG.string(p_log_level, l_module_name, l_log_string);
841:
842: l_log_string := ' gIHReqTemplatePoLineIdTbl['||p_index||']: ' ||
843: ICX_CAT_UTIL_PVT.getTableElement(gIHReqTemplatePoLineIdTbl, p_index) || '; ';
844: FND_LOG.string(p_log_level, l_module_name, l_log_string);
840: FND_LOG.string(p_log_level, l_module_name, l_log_string);
841:
842: l_log_string := ' gIHReqTemplatePoLineIdTbl['||p_index||']: ' ||
843: ICX_CAT_UTIL_PVT.getTableElement(gIHReqTemplatePoLineIdTbl, p_index) || '; ';
844: FND_LOG.string(p_log_level, l_module_name, l_log_string);
845:
846: l_log_string := ' gIHItemRevisionTbl['||p_index||']: ' ||
847: ICX_CAT_UTIL_PVT.getTableElement(gIHItemRevisionTbl, p_index) || '; ';
848: FND_LOG.string(p_log_level, l_module_name, l_log_string);
844: FND_LOG.string(p_log_level, l_module_name, l_log_string);
845:
846: l_log_string := ' gIHItemRevisionTbl['||p_index||']: ' ||
847: ICX_CAT_UTIL_PVT.getTableElement(gIHItemRevisionTbl, p_index) || '; ';
848: FND_LOG.string(p_log_level, l_module_name, l_log_string);
849:
850: l_log_string := ' gIHPoHeaderIdTbl['||p_index||']: ' ||
851: ICX_CAT_UTIL_PVT.getTableElement(gIHPoHeaderIdTbl, p_index) || '; ';
852: FND_LOG.string(p_log_level, l_module_name, l_log_string);
848: FND_LOG.string(p_log_level, l_module_name, l_log_string);
849:
850: l_log_string := ' gIHPoHeaderIdTbl['||p_index||']: ' ||
851: ICX_CAT_UTIL_PVT.getTableElement(gIHPoHeaderIdTbl, p_index) || '; ';
852: FND_LOG.string(p_log_level, l_module_name, l_log_string);
853:
854: l_log_string := ' gIHDocumentNumberTbl['||p_index||']: ' ||
855: ICX_CAT_UTIL_PVT.getTableElement(gIHDocumentNumberTbl, p_index) || '; ';
856: FND_LOG.string(p_log_level, l_module_name, l_log_string);
852: FND_LOG.string(p_log_level, l_module_name, l_log_string);
853:
854: l_log_string := ' gIHDocumentNumberTbl['||p_index||']: ' ||
855: ICX_CAT_UTIL_PVT.getTableElement(gIHDocumentNumberTbl, p_index) || '; ';
856: FND_LOG.string(p_log_level, l_module_name, l_log_string);
857:
858: l_log_string := ' gIHLineNumTbl['||p_index||']: ' ||
859: ICX_CAT_UTIL_PVT.getTableElement(gIHLineNumTbl, p_index) || '; ';
860: FND_LOG.string(p_log_level, l_module_name, l_log_string);
856: FND_LOG.string(p_log_level, l_module_name, l_log_string);
857:
858: l_log_string := ' gIHLineNumTbl['||p_index||']: ' ||
859: ICX_CAT_UTIL_PVT.getTableElement(gIHLineNumTbl, p_index) || '; ';
860: FND_LOG.string(p_log_level, l_module_name, l_log_string);
861:
862: l_log_string := ' gIHAllowPriceOverrideFlagTbl['||p_index||']: ' ||
863: ICX_CAT_UTIL_PVT.getTableElement(gIHAllowPriceOverrideFlagTbl, p_index) || '; ';
864: FND_LOG.string(p_log_level, l_module_name, l_log_string);
860: FND_LOG.string(p_log_level, l_module_name, l_log_string);
861:
862: l_log_string := ' gIHAllowPriceOverrideFlagTbl['||p_index||']: ' ||
863: ICX_CAT_UTIL_PVT.getTableElement(gIHAllowPriceOverrideFlagTbl, p_index) || '; ';
864: FND_LOG.string(p_log_level, l_module_name, l_log_string);
865:
866: l_log_string := ' gIHNotToExceedPriceTbl['||p_index||']: ' ||
867: ICX_CAT_UTIL_PVT.getTableElement(gIHNotToExceedPriceTbl, p_index) || '; ';
868: FND_LOG.string(p_log_level, l_module_name, l_log_string);
864: FND_LOG.string(p_log_level, l_module_name, l_log_string);
865:
866: l_log_string := ' gIHNotToExceedPriceTbl['||p_index||']: ' ||
867: ICX_CAT_UTIL_PVT.getTableElement(gIHNotToExceedPriceTbl, p_index) || '; ';
868: FND_LOG.string(p_log_level, l_module_name, l_log_string);
869:
870: l_log_string := ' gIHLineTypeIdTbl['||p_index||']: ' ||
871: ICX_CAT_UTIL_PVT.getTableElement(gIHLineTypeIdTbl, p_index) || '; ';
872: FND_LOG.string(p_log_level, l_module_name, l_log_string);
868: FND_LOG.string(p_log_level, l_module_name, l_log_string);
869:
870: l_log_string := ' gIHLineTypeIdTbl['||p_index||']: ' ||
871: ICX_CAT_UTIL_PVT.getTableElement(gIHLineTypeIdTbl, p_index) || '; ';
872: FND_LOG.string(p_log_level, l_module_name, l_log_string);
873:
874: l_log_string := ' gIHUnitMeasLookupCodeTbl['||p_index||']: ' ||
875: ICX_CAT_UTIL_PVT.getTableElement(gIHUnitMeasLookupCodeTbl, p_index) || '; ';
876: FND_LOG.string(p_log_level, l_module_name, l_log_string);
872: FND_LOG.string(p_log_level, l_module_name, l_log_string);
873:
874: l_log_string := ' gIHUnitMeasLookupCodeTbl['||p_index||']: ' ||
875: ICX_CAT_UTIL_PVT.getTableElement(gIHUnitMeasLookupCodeTbl, p_index) || '; ';
876: FND_LOG.string(p_log_level, l_module_name, l_log_string);
877:
878: l_log_string := ' gIHSuggestedQuantityTbl['||p_index||']: ' ||
879: ICX_CAT_UTIL_PVT.getTableElement(gIHSuggestedQuantityTbl, p_index) || '; ';
880: FND_LOG.string(p_log_level, l_module_name, l_log_string);
876: FND_LOG.string(p_log_level, l_module_name, l_log_string);
877:
878: l_log_string := ' gIHSuggestedQuantityTbl['||p_index||']: ' ||
879: ICX_CAT_UTIL_PVT.getTableElement(gIHSuggestedQuantityTbl, p_index) || '; ';
880: FND_LOG.string(p_log_level, l_module_name, l_log_string);
881:
882: l_log_string := ' gIHUnitPriceTbl['||p_index||']: ' ||
883: ICX_CAT_UTIL_PVT.getTableElement(gIHUnitPriceTbl, p_index) || '; ';
884: FND_LOG.string(p_log_level, l_module_name, l_log_string);
880: FND_LOG.string(p_log_level, l_module_name, l_log_string);
881:
882: l_log_string := ' gIHUnitPriceTbl['||p_index||']: ' ||
883: ICX_CAT_UTIL_PVT.getTableElement(gIHUnitPriceTbl, p_index) || '; ';
884: FND_LOG.string(p_log_level, l_module_name, l_log_string);
885:
886: l_log_string := ' gIHAmountTbl['||p_index||']: ' ||
887: ICX_CAT_UTIL_PVT.getTableElement(gIHAmountTbl, p_index) || '; ';
888: FND_LOG.string(p_log_level, l_module_name, l_log_string);
884: FND_LOG.string(p_log_level, l_module_name, l_log_string);
885:
886: l_log_string := ' gIHAmountTbl['||p_index||']: ' ||
887: ICX_CAT_UTIL_PVT.getTableElement(gIHAmountTbl, p_index) || '; ';
888: FND_LOG.string(p_log_level, l_module_name, l_log_string);
889:
890: l_log_string := ' gIHCurrencyCodeTbl['||p_index||']: ' ||
891: ICX_CAT_UTIL_PVT.getTableElement(gIHCurrencyCodeTbl, p_index) || '; ';
892: FND_LOG.string(p_log_level, l_module_name, l_log_string);
888: FND_LOG.string(p_log_level, l_module_name, l_log_string);
889:
890: l_log_string := ' gIHCurrencyCodeTbl['||p_index||']: ' ||
891: ICX_CAT_UTIL_PVT.getTableElement(gIHCurrencyCodeTbl, p_index) || '; ';
892: FND_LOG.string(p_log_level, l_module_name, l_log_string);
893:
894: l_log_string := ' gIHRateTypeTbl['||p_index||']: ' ||
895: ICX_CAT_UTIL_PVT.getTableElement(gIHRateTypeTbl, p_index) || '; ';
896: FND_LOG.string(p_log_level, l_module_name, l_log_string);
892: FND_LOG.string(p_log_level, l_module_name, l_log_string);
893:
894: l_log_string := ' gIHRateTypeTbl['||p_index||']: ' ||
895: ICX_CAT_UTIL_PVT.getTableElement(gIHRateTypeTbl, p_index) || '; ';
896: FND_LOG.string(p_log_level, l_module_name, l_log_string);
897:
898: l_log_string := ' gIHRateDateTbl['||p_index||']: ' ||
899: ICX_CAT_UTIL_PVT.getTableElement(gIHRateDateTbl, p_index) || '; ';
900: FND_LOG.string(p_log_level, l_module_name, l_log_string);
896: FND_LOG.string(p_log_level, l_module_name, l_log_string);
897:
898: l_log_string := ' gIHRateDateTbl['||p_index||']: ' ||
899: ICX_CAT_UTIL_PVT.getTableElement(gIHRateDateTbl, p_index) || '; ';
900: FND_LOG.string(p_log_level, l_module_name, l_log_string);
901:
902: l_log_string := ' gIHRateTbl['||p_index||']: ' ||
903: ICX_CAT_UTIL_PVT.getTableElement(gIHRateTbl, p_index) || '; ';
904: FND_LOG.string(p_log_level, l_module_name, l_log_string);
900: FND_LOG.string(p_log_level, l_module_name, l_log_string);
901:
902: l_log_string := ' gIHRateTbl['||p_index||']: ' ||
903: ICX_CAT_UTIL_PVT.getTableElement(gIHRateTbl, p_index) || '; ';
904: FND_LOG.string(p_log_level, l_module_name, l_log_string);
905:
906: l_log_string := ' gIHBuyerIdTbl['||p_index||']: ' ||
907: ICX_CAT_UTIL_PVT.getTableElement(gIHBuyerIdTbl, p_index) || '; ';
908: FND_LOG.string(p_log_level, l_module_name, l_log_string);
904: FND_LOG.string(p_log_level, l_module_name, l_log_string);
905:
906: l_log_string := ' gIHBuyerIdTbl['||p_index||']: ' ||
907: ICX_CAT_UTIL_PVT.getTableElement(gIHBuyerIdTbl, p_index) || '; ';
908: FND_LOG.string(p_log_level, l_module_name, l_log_string);
909:
910: l_log_string := ' gIHSupplierContactIdTbl['||p_index||']: ' ||
911: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierContactIdTbl, p_index) || '; ';
912: FND_LOG.string(p_log_level, l_module_name, l_log_string);
908: FND_LOG.string(p_log_level, l_module_name, l_log_string);
909:
910: l_log_string := ' gIHSupplierContactIdTbl['||p_index||']: ' ||
911: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierContactIdTbl, p_index) || '; ';
912: FND_LOG.string(p_log_level, l_module_name, l_log_string);
913:
914: l_log_string := ' gIHRfqRequiredFlagTbl['||p_index||']: ' ||
915: ICX_CAT_UTIL_PVT.getTableElement(gIHRfqRequiredFlagTbl, p_index) || '; ';
916: FND_LOG.string(p_log_level, l_module_name, l_log_string);
912: FND_LOG.string(p_log_level, l_module_name, l_log_string);
913:
914: l_log_string := ' gIHRfqRequiredFlagTbl['||p_index||']: ' ||
915: ICX_CAT_UTIL_PVT.getTableElement(gIHRfqRequiredFlagTbl, p_index) || '; ';
916: FND_LOG.string(p_log_level, l_module_name, l_log_string);
917:
918: l_log_string := ' gIHNegotiatedByPreparerFlagTbl['||p_index||']: ' ||
919: ICX_CAT_UTIL_PVT.getTableElement(gIHNegotiatedByPreparerFlagTbl, p_index) || '; ';
920: FND_LOG.string(p_log_level, l_module_name, l_log_string);
916: FND_LOG.string(p_log_level, l_module_name, l_log_string);
917:
918: l_log_string := ' gIHNegotiatedByPreparerFlagTbl['||p_index||']: ' ||
919: ICX_CAT_UTIL_PVT.getTableElement(gIHNegotiatedByPreparerFlagTbl, p_index) || '; ';
920: FND_LOG.string(p_log_level, l_module_name, l_log_string);
921:
922: l_log_string := ' gIHDescriptionTbl['||p_index||']: ' ||
923: ICX_CAT_UTIL_PVT.getTableElement(gIHDescriptionTbl, p_index) || '; ';
924: FND_LOG.string(p_log_level, l_module_name, l_log_string);
920: FND_LOG.string(p_log_level, l_module_name, l_log_string);
921:
922: l_log_string := ' gIHDescriptionTbl['||p_index||']: ' ||
923: ICX_CAT_UTIL_PVT.getTableElement(gIHDescriptionTbl, p_index) || '; ';
924: FND_LOG.string(p_log_level, l_module_name, l_log_string);
925:
926: l_log_string := ' gIHOrderTypeLookupCodeTbl['||p_index||']: ' ||
927: ICX_CAT_UTIL_PVT.getTableElement(gIHOrderTypeLookupCodeTbl, p_index) || '; ';
928: FND_LOG.string(p_log_level, l_module_name, l_log_string);
924: FND_LOG.string(p_log_level, l_module_name, l_log_string);
925:
926: l_log_string := ' gIHOrderTypeLookupCodeTbl['||p_index||']: ' ||
927: ICX_CAT_UTIL_PVT.getTableElement(gIHOrderTypeLookupCodeTbl, p_index) || '; ';
928: FND_LOG.string(p_log_level, l_module_name, l_log_string);
929:
930: l_log_string := ' gIHSupplierTbl['||p_index||']: ' ||
931: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierTbl, p_index) || '; ';
932: FND_LOG.string(p_log_level, l_module_name, l_log_string);
928: FND_LOG.string(p_log_level, l_module_name, l_log_string);
929:
930: l_log_string := ' gIHSupplierTbl['||p_index||']: ' ||
931: ICX_CAT_UTIL_PVT.getTableElement(gIHSupplierTbl, p_index) || '; ';
932: FND_LOG.string(p_log_level, l_module_name, l_log_string);
933:
934: l_log_string := ' gIHGlobalAgreementFlagTbl['||p_index||']: ' ||
935: ICX_CAT_UTIL_PVT.getTableElement(gIHGlobalAgreementFlagTbl, p_index) || '; ';
936: FND_LOG.string(p_log_level, l_module_name, l_log_string);
932: FND_LOG.string(p_log_level, l_module_name, l_log_string);
933:
934: l_log_string := ' gIHGlobalAgreementFlagTbl['||p_index||']: ' ||
935: ICX_CAT_UTIL_PVT.getTableElement(gIHGlobalAgreementFlagTbl, p_index) || '; ';
936: FND_LOG.string(p_log_level, l_module_name, l_log_string);
937:
938: l_log_string := ' gIHMergedSourceTypeTbl['||p_index||']: ' ||
939: ICX_CAT_UTIL_PVT.getTableElement(gIHMergedSourceTypeTbl, p_index) || '; ';
940: FND_LOG.string(p_log_level, l_module_name, l_log_string);
936: FND_LOG.string(p_log_level, l_module_name, l_log_string);
937:
938: l_log_string := ' gIHMergedSourceTypeTbl['||p_index||']: ' ||
939: ICX_CAT_UTIL_PVT.getTableElement(gIHMergedSourceTypeTbl, p_index) || '; ';
940: FND_LOG.string(p_log_level, l_module_name, l_log_string);
941:
942: END IF;
943:
944: l_err_loc := 400;
947: l_err_loc := 500;
948: -- INSERT icx_cat_items_ctx_dtl_tlp
949: l_log_string := ' gIDInventoryItemIdTbl['||p_index||']: ' ||
950: ICX_CAT_UTIL_PVT.getTableElement(gIDInventoryItemIdTbl, p_index) || '; ';
951: FND_LOG.string(p_log_level, l_module_name, l_log_string);
952:
953: l_log_string := ' gIDPoLineIdTbl['||p_index||']: ' ||
954: ICX_CAT_UTIL_PVT.getTableElement(gIDPoLineIdTbl, p_index) || '; ';
955: FND_LOG.string(p_log_level, l_module_name, l_log_string);
951: FND_LOG.string(p_log_level, l_module_name, l_log_string);
952:
953: l_log_string := ' gIDPoLineIdTbl['||p_index||']: ' ||
954: ICX_CAT_UTIL_PVT.getTableElement(gIDPoLineIdTbl, p_index) || '; ';
955: FND_LOG.string(p_log_level, l_module_name, l_log_string);
956:
957: l_log_string := ' gIDReqTemplateNameTbl['||p_index||']: ' ||
958: ICX_CAT_UTIL_PVT.getTableElement(gIDReqTemplateNameTbl, p_index) || '; ';
959: FND_LOG.string(p_log_level, l_module_name, l_log_string);
955: FND_LOG.string(p_log_level, l_module_name, l_log_string);
956:
957: l_log_string := ' gIDReqTemplateNameTbl['||p_index||']: ' ||
958: ICX_CAT_UTIL_PVT.getTableElement(gIDReqTemplateNameTbl, p_index) || '; ';
959: FND_LOG.string(p_log_level, l_module_name, l_log_string);
960:
961: l_log_string := ' gIDReqTemplateLineNumTbl['||p_index||']: ' ||
962: ICX_CAT_UTIL_PVT.getTableElement(gIDReqTemplateLineNumTbl, p_index) || '; ';
963: FND_LOG.string(p_log_level, l_module_name, l_log_string);
959: FND_LOG.string(p_log_level, l_module_name, l_log_string);
960:
961: l_log_string := ' gIDReqTemplateLineNumTbl['||p_index||']: ' ||
962: ICX_CAT_UTIL_PVT.getTableElement(gIDReqTemplateLineNumTbl, p_index) || '; ';
963: FND_LOG.string(p_log_level, l_module_name, l_log_string);
964:
965: l_log_string := ' gIDOrgIdTbl['||p_index||']: ' ||
966: ICX_CAT_UTIL_PVT.getTableElement(gIDOrgIdTbl, p_index) || '; ';
967: FND_LOG.string(p_log_level, l_module_name, l_log_string);
963: FND_LOG.string(p_log_level, l_module_name, l_log_string);
964:
965: l_log_string := ' gIDOrgIdTbl['||p_index||']: ' ||
966: ICX_CAT_UTIL_PVT.getTableElement(gIDOrgIdTbl, p_index) || '; ';
967: FND_LOG.string(p_log_level, l_module_name, l_log_string);
968:
969: l_log_string := ' gIDLanguageTbl['||p_index||']: ' ||
970: ICX_CAT_UTIL_PVT.getTableElement(gIDLanguageTbl, p_index) || '; ';
971: FND_LOG.string(p_log_level, l_module_name, l_log_string);
967: FND_LOG.string(p_log_level, l_module_name, l_log_string);
968:
969: l_log_string := ' gIDLanguageTbl['||p_index||']: ' ||
970: ICX_CAT_UTIL_PVT.getTableElement(gIDLanguageTbl, p_index) || '; ';
971: FND_LOG.string(p_log_level, l_module_name, l_log_string);
972:
973: l_log_string := ' gIDPurchasingOrgIdTbl['||p_index||']: ' ||
974: ICX_CAT_UTIL_PVT.getTableElement(gIDPurchasingOrgIdTbl, p_index) || '; ';
975: FND_LOG.string(p_log_level, l_module_name, l_log_string);
971: FND_LOG.string(p_log_level, l_module_name, l_log_string);
972:
973: l_log_string := ' gIDPurchasingOrgIdTbl['||p_index||']: ' ||
974: ICX_CAT_UTIL_PVT.getTableElement(gIDPurchasingOrgIdTbl, p_index) || '; ';
975: FND_LOG.string(p_log_level, l_module_name, l_log_string);
976:
977: l_log_string := ' gIDOwningOrgIdTbl['||p_index||']: ' ||
978: ICX_CAT_UTIL_PVT.getTableElement(gIDOwningOrgIdTbl, p_index) || '; ';
979: FND_LOG.string(p_log_level, l_module_name, l_log_string);
975: FND_LOG.string(p_log_level, l_module_name, l_log_string);
976:
977: l_log_string := ' gIDOwningOrgIdTbl['||p_index||']: ' ||
978: ICX_CAT_UTIL_PVT.getTableElement(gIDOwningOrgIdTbl, p_index) || '; ';
979: FND_LOG.string(p_log_level, l_module_name, l_log_string);
980:
981: END IF;
982:
983: l_err_loc := 600;
986: l_err_loc := 700;
987: -- UPDATE icx_cat_items_ctx_hdrs_tlp
988: l_log_string := ' gUHInventoryItemIdTbl['||p_index||']: ' ||
989: ICX_CAT_UTIL_PVT.getTableElement(gUHInventoryItemIdTbl, p_index) || '; ';
990: FND_LOG.string(p_log_level, l_module_name, l_log_string);
991:
992: l_log_string := ' gUHPoLineIdTbl['||p_index||']: ' ||
993: ICX_CAT_UTIL_PVT.getTableElement(gUHPoLineIdTbl, p_index) || '; ';
994: FND_LOG.string(p_log_level, l_module_name, l_log_string);
990: FND_LOG.string(p_log_level, l_module_name, l_log_string);
991:
992: l_log_string := ' gUHPoLineIdTbl['||p_index||']: ' ||
993: ICX_CAT_UTIL_PVT.getTableElement(gUHPoLineIdTbl, p_index) || '; ';
994: FND_LOG.string(p_log_level, l_module_name, l_log_string);
995:
996: l_log_string := ' gUHReqTemplateNameTbl['||p_index||']: ' ||
997: ICX_CAT_UTIL_PVT.getTableElement(gUHReqTemplateNameTbl, p_index) || '; ';
998: FND_LOG.string(p_log_level, l_module_name, l_log_string);
994: FND_LOG.string(p_log_level, l_module_name, l_log_string);
995:
996: l_log_string := ' gUHReqTemplateNameTbl['||p_index||']: ' ||
997: ICX_CAT_UTIL_PVT.getTableElement(gUHReqTemplateNameTbl, p_index) || '; ';
998: FND_LOG.string(p_log_level, l_module_name, l_log_string);
999:
1000: l_log_string := ' gUHReqTemplateLineNumTbl['||p_index||']: ' ||
1001: ICX_CAT_UTIL_PVT.getTableElement(gUHReqTemplateLineNumTbl, p_index) || '; ';
1002: FND_LOG.string(p_log_level, l_module_name, l_log_string);
998: FND_LOG.string(p_log_level, l_module_name, l_log_string);
999:
1000: l_log_string := ' gUHReqTemplateLineNumTbl['||p_index||']: ' ||
1001: ICX_CAT_UTIL_PVT.getTableElement(gUHReqTemplateLineNumTbl, p_index) || '; ';
1002: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1003:
1004: l_log_string := ' gUHOrgIdTbl['||p_index||']: ' ||
1005: ICX_CAT_UTIL_PVT.getTableElement(gUHOrgIdTbl, p_index) || '; ';
1006: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1002: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1003:
1004: l_log_string := ' gUHOrgIdTbl['||p_index||']: ' ||
1005: ICX_CAT_UTIL_PVT.getTableElement(gUHOrgIdTbl, p_index) || '; ';
1006: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1007:
1008: l_log_string := ' gUHLanguageTbl['||p_index||']: ' ||
1009: ICX_CAT_UTIL_PVT.getTableElement(gUHLanguageTbl, p_index) || '; ';
1010: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1006: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1007:
1008: l_log_string := ' gUHLanguageTbl['||p_index||']: ' ||
1009: ICX_CAT_UTIL_PVT.getTableElement(gUHLanguageTbl, p_index) || '; ';
1010: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1011:
1012: l_log_string := ' gUHSourceTypeTbl['||p_index||']: ' ||
1013: ICX_CAT_UTIL_PVT.getTableElement(gUHSourceTypeTbl, p_index) || '; ';
1014: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1010: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1011:
1012: l_log_string := ' gUHSourceTypeTbl['||p_index||']: ' ||
1013: ICX_CAT_UTIL_PVT.getTableElement(gUHSourceTypeTbl, p_index) || '; ';
1014: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1015:
1016: l_log_string := ' gUHItemTypeTbl['||p_index||']: ' ||
1017: ICX_CAT_UTIL_PVT.getTableElement(gUHItemTypeTbl, p_index) || '; ';
1018: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1014: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1015:
1016: l_log_string := ' gUHItemTypeTbl['||p_index||']: ' ||
1017: ICX_CAT_UTIL_PVT.getTableElement(gUHItemTypeTbl, p_index) || '; ';
1018: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1019:
1020: l_log_string := ' gUHPurchasingOrgIdTbl['||p_index||']: ' ||
1021: ICX_CAT_UTIL_PVT.getTableElement(gUHPurchasingOrgIdTbl, p_index) || '; ';
1022: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1018: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1019:
1020: l_log_string := ' gUHPurchasingOrgIdTbl['||p_index||']: ' ||
1021: ICX_CAT_UTIL_PVT.getTableElement(gUHPurchasingOrgIdTbl, p_index) || '; ';
1022: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1023:
1024: l_log_string := ' gUHIpCategoryIdTbl['||p_index||']: ' ||
1025: ICX_CAT_UTIL_PVT.getTableElement(gUHIpCategoryIdTbl, p_index) || '; ';
1026: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1022: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1023:
1024: l_log_string := ' gUHIpCategoryIdTbl['||p_index||']: ' ||
1025: ICX_CAT_UTIL_PVT.getTableElement(gUHIpCategoryIdTbl, p_index) || '; ';
1026: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1027:
1028: l_log_string := ' gUHIpCategoryNameTbl['||p_index||']: ' ||
1029: ICX_CAT_UTIL_PVT.getTableElement(gUHIpCategoryNameTbl, p_index) || '; ';
1030: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1026: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1027:
1028: l_log_string := ' gUHIpCategoryNameTbl['||p_index||']: ' ||
1029: ICX_CAT_UTIL_PVT.getTableElement(gUHIpCategoryNameTbl, p_index) || '; ';
1030: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1031:
1032: l_log_string := ' gUHPoCategoryIdTbl['||p_index||']: ' ||
1033: ICX_CAT_UTIL_PVT.getTableElement(gUHPoCategoryIdTbl, p_index) || '; ';
1034: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1030: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1031:
1032: l_log_string := ' gUHPoCategoryIdTbl['||p_index||']: ' ||
1033: ICX_CAT_UTIL_PVT.getTableElement(gUHPoCategoryIdTbl, p_index) || '; ';
1034: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1035:
1036: l_log_string := ' gUHSupplierIdTbl['||p_index||']: ' ||
1037: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierIdTbl, p_index) || '; ';
1038: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1034: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1035:
1036: l_log_string := ' gUHSupplierIdTbl['||p_index||']: ' ||
1037: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierIdTbl, p_index) || '; ';
1038: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1039:
1040: l_log_string := ' gUHSupplierPartNumTbl['||p_index||']: ' ||
1041: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierPartNumTbl, p_index) || '; ';
1042: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1038: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1039:
1040: l_log_string := ' gUHSupplierPartNumTbl['||p_index||']: ' ||
1041: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierPartNumTbl, p_index) || '; ';
1042: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1043:
1044: l_log_string := ' gUHSupplierPartAuxidTbl['||p_index||']: ' ||
1045: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierPartAuxidTbl, p_index) || '; ';
1046: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1042: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1043:
1044: l_log_string := ' gUHSupplierPartAuxidTbl['||p_index||']: ' ||
1045: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierPartAuxidTbl, p_index) || '; ';
1046: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1047:
1048: l_log_string := ' gUHSupplierSiteIdTbl['||p_index||']: ' ||
1049: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierSiteIdTbl, p_index) || '; ';
1050: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1046: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1047:
1048: l_log_string := ' gUHSupplierSiteIdTbl['||p_index||']: ' ||
1049: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierSiteIdTbl, p_index) || '; ';
1050: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1051:
1052: l_log_string := ' gUHReqTemplatePoLineIdTbl['||p_index||']: ' ||
1053: ICX_CAT_UTIL_PVT.getTableElement(gUHReqTemplatePoLineIdTbl, p_index) || '; ';
1054: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1050: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1051:
1052: l_log_string := ' gUHReqTemplatePoLineIdTbl['||p_index||']: ' ||
1053: ICX_CAT_UTIL_PVT.getTableElement(gUHReqTemplatePoLineIdTbl, p_index) || '; ';
1054: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1055:
1056: l_log_string := ' gUHItemRevisionTbl['||p_index||']: ' ||
1057: ICX_CAT_UTIL_PVT.getTableElement(gUHItemRevisionTbl, p_index) || '; ';
1058: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1054: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1055:
1056: l_log_string := ' gUHItemRevisionTbl['||p_index||']: ' ||
1057: ICX_CAT_UTIL_PVT.getTableElement(gUHItemRevisionTbl, p_index) || '; ';
1058: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1059:
1060: l_log_string := ' gUHPoHeaderIdTbl['||p_index||']: ' ||
1061: ICX_CAT_UTIL_PVT.getTableElement(gUHPoHeaderIdTbl, p_index) || '; ';
1062: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1058: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1059:
1060: l_log_string := ' gUHPoHeaderIdTbl['||p_index||']: ' ||
1061: ICX_CAT_UTIL_PVT.getTableElement(gUHPoHeaderIdTbl, p_index) || '; ';
1062: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1063:
1064: l_log_string := ' gUHDocumentNumberTbl['||p_index||']: ' ||
1065: ICX_CAT_UTIL_PVT.getTableElement(gUHDocumentNumberTbl, p_index) || '; ';
1066: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1062: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1063:
1064: l_log_string := ' gUHDocumentNumberTbl['||p_index||']: ' ||
1065: ICX_CAT_UTIL_PVT.getTableElement(gUHDocumentNumberTbl, p_index) || '; ';
1066: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1067:
1068: l_log_string := ' gUHLineNumTbl['||p_index||']: ' ||
1069: ICX_CAT_UTIL_PVT.getTableElement(gUHLineNumTbl, p_index) || '; ';
1070: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1066: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1067:
1068: l_log_string := ' gUHLineNumTbl['||p_index||']: ' ||
1069: ICX_CAT_UTIL_PVT.getTableElement(gUHLineNumTbl, p_index) || '; ';
1070: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1071:
1072: l_log_string := ' gUHAllowPriceOverrideFlagTbl['||p_index||']: ' ||
1073: ICX_CAT_UTIL_PVT.getTableElement(gUHAllowPriceOverrideFlagTbl, p_index) || '; ';
1074: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1070: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1071:
1072: l_log_string := ' gUHAllowPriceOverrideFlagTbl['||p_index||']: ' ||
1073: ICX_CAT_UTIL_PVT.getTableElement(gUHAllowPriceOverrideFlagTbl, p_index) || '; ';
1074: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1075:
1076: l_log_string := ' gUHNotToExceedPriceTbl['||p_index||']: ' ||
1077: ICX_CAT_UTIL_PVT.getTableElement(gUHNotToExceedPriceTbl, p_index) || '; ';
1078: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1074: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1075:
1076: l_log_string := ' gUHNotToExceedPriceTbl['||p_index||']: ' ||
1077: ICX_CAT_UTIL_PVT.getTableElement(gUHNotToExceedPriceTbl, p_index) || '; ';
1078: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1079:
1080: l_log_string := ' gUHLineTypeIdTbl['||p_index||']: ' ||
1081: ICX_CAT_UTIL_PVT.getTableElement(gUHLineTypeIdTbl, p_index) || '; ';
1082: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1078: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1079:
1080: l_log_string := ' gUHLineTypeIdTbl['||p_index||']: ' ||
1081: ICX_CAT_UTIL_PVT.getTableElement(gUHLineTypeIdTbl, p_index) || '; ';
1082: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1083:
1084: l_log_string := ' gUHUnitMeasLookupCodeTbl['||p_index||']: ' ||
1085: ICX_CAT_UTIL_PVT.getTableElement(gUHUnitMeasLookupCodeTbl, p_index) || '; ';
1086: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1082: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1083:
1084: l_log_string := ' gUHUnitMeasLookupCodeTbl['||p_index||']: ' ||
1085: ICX_CAT_UTIL_PVT.getTableElement(gUHUnitMeasLookupCodeTbl, p_index) || '; ';
1086: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1087:
1088: l_log_string := ' gUHSuggestedQuantityTbl['||p_index||']: ' ||
1089: ICX_CAT_UTIL_PVT.getTableElement(gUHSuggestedQuantityTbl, p_index) || '; ';
1090: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1086: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1087:
1088: l_log_string := ' gUHSuggestedQuantityTbl['||p_index||']: ' ||
1089: ICX_CAT_UTIL_PVT.getTableElement(gUHSuggestedQuantityTbl, p_index) || '; ';
1090: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1091:
1092: l_log_string := ' gUHUnitPriceTbl['||p_index||']: ' ||
1093: ICX_CAT_UTIL_PVT.getTableElement(gUHUnitPriceTbl, p_index) || '; ';
1094: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1090: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1091:
1092: l_log_string := ' gUHUnitPriceTbl['||p_index||']: ' ||
1093: ICX_CAT_UTIL_PVT.getTableElement(gUHUnitPriceTbl, p_index) || '; ';
1094: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1095:
1096: l_log_string := ' gUHAmountTbl['||p_index||']: ' ||
1097: ICX_CAT_UTIL_PVT.getTableElement(gUHAmountTbl, p_index) || '; ';
1098: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1094: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1095:
1096: l_log_string := ' gUHAmountTbl['||p_index||']: ' ||
1097: ICX_CAT_UTIL_PVT.getTableElement(gUHAmountTbl, p_index) || '; ';
1098: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1099:
1100: l_log_string := ' gUHCurrencyCodeTbl['||p_index||']: ' ||
1101: ICX_CAT_UTIL_PVT.getTableElement(gUHCurrencyCodeTbl, p_index) || '; ';
1102: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1098: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1099:
1100: l_log_string := ' gUHCurrencyCodeTbl['||p_index||']: ' ||
1101: ICX_CAT_UTIL_PVT.getTableElement(gUHCurrencyCodeTbl, p_index) || '; ';
1102: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1103:
1104: l_log_string := ' gUHRateTypeTbl['||p_index||']: ' ||
1105: ICX_CAT_UTIL_PVT.getTableElement(gUHRateTypeTbl, p_index) || '; ';
1106: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1102: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1103:
1104: l_log_string := ' gUHRateTypeTbl['||p_index||']: ' ||
1105: ICX_CAT_UTIL_PVT.getTableElement(gUHRateTypeTbl, p_index) || '; ';
1106: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1107:
1108: l_log_string := ' gUHRateDateTbl['||p_index||']: ' ||
1109: ICX_CAT_UTIL_PVT.getTableElement(gUHRateDateTbl, p_index) || '; ';
1110: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1106: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1107:
1108: l_log_string := ' gUHRateDateTbl['||p_index||']: ' ||
1109: ICX_CAT_UTIL_PVT.getTableElement(gUHRateDateTbl, p_index) || '; ';
1110: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1111:
1112: l_log_string := ' gUHRateTbl['||p_index||']: ' ||
1113: ICX_CAT_UTIL_PVT.getTableElement(gUHRateTbl, p_index) || '; ';
1114: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1110: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1111:
1112: l_log_string := ' gUHRateTbl['||p_index||']: ' ||
1113: ICX_CAT_UTIL_PVT.getTableElement(gUHRateTbl, p_index) || '; ';
1114: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1115:
1116: l_log_string := ' gUHBuyerIdTbl['||p_index||']: ' ||
1117: ICX_CAT_UTIL_PVT.getTableElement(gUHBuyerIdTbl, p_index) || '; ';
1118: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1114: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1115:
1116: l_log_string := ' gUHBuyerIdTbl['||p_index||']: ' ||
1117: ICX_CAT_UTIL_PVT.getTableElement(gUHBuyerIdTbl, p_index) || '; ';
1118: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1119:
1120: l_log_string := ' gUHSupplierContactIdTbl['||p_index||']: ' ||
1121: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierContactIdTbl, p_index) || '; ';
1122: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1118: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1119:
1120: l_log_string := ' gUHSupplierContactIdTbl['||p_index||']: ' ||
1121: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierContactIdTbl, p_index) || '; ';
1122: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1123:
1124: l_log_string := ' gUHRfqRequiredFlagTbl['||p_index||']: ' ||
1125: ICX_CAT_UTIL_PVT.getTableElement(gUHRfqRequiredFlagTbl, p_index) || '; ';
1126: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1122: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1123:
1124: l_log_string := ' gUHRfqRequiredFlagTbl['||p_index||']: ' ||
1125: ICX_CAT_UTIL_PVT.getTableElement(gUHRfqRequiredFlagTbl, p_index) || '; ';
1126: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1127:
1128: l_log_string := ' gUHNegotiatedByPreparerFlagTbl['||p_index||']: ' ||
1129: ICX_CAT_UTIL_PVT.getTableElement(gUHNegotiatedByPreparerFlagTbl, p_index) || '; ';
1130: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1126: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1127:
1128: l_log_string := ' gUHNegotiatedByPreparerFlagTbl['||p_index||']: ' ||
1129: ICX_CAT_UTIL_PVT.getTableElement(gUHNegotiatedByPreparerFlagTbl, p_index) || '; ';
1130: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1131:
1132: l_log_string := ' gUHDescriptionTbl['||p_index||']: ' ||
1133: ICX_CAT_UTIL_PVT.getTableElement(gUHDescriptionTbl, p_index) || '; ';
1134: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1130: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1131:
1132: l_log_string := ' gUHDescriptionTbl['||p_index||']: ' ||
1133: ICX_CAT_UTIL_PVT.getTableElement(gUHDescriptionTbl, p_index) || '; ';
1134: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1135:
1136: l_log_string := ' gUHOrderTypeLookupCodeTbl['||p_index||']: ' ||
1137: ICX_CAT_UTIL_PVT.getTableElement(gUHOrderTypeLookupCodeTbl, p_index) || '; ';
1138: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1134: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1135:
1136: l_log_string := ' gUHOrderTypeLookupCodeTbl['||p_index||']: ' ||
1137: ICX_CAT_UTIL_PVT.getTableElement(gUHOrderTypeLookupCodeTbl, p_index) || '; ';
1138: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1139:
1140: l_log_string := ' gUHSupplierTbl['||p_index||']: ' ||
1141: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierTbl, p_index) || '; ';
1142: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1138: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1139:
1140: l_log_string := ' gUHSupplierTbl['||p_index||']: ' ||
1141: ICX_CAT_UTIL_PVT.getTableElement(gUHSupplierTbl, p_index) || '; ';
1142: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1143:
1144: l_log_string := ' gUHGlobalAgreementFlagTbl['||p_index||']: ' ||
1145: ICX_CAT_UTIL_PVT.getTableElement(gUHGlobalAgreementFlagTbl, p_index) || '; ';
1146: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1142: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1143:
1144: l_log_string := ' gUHGlobalAgreementFlagTbl['||p_index||']: ' ||
1145: ICX_CAT_UTIL_PVT.getTableElement(gUHGlobalAgreementFlagTbl, p_index) || '; ';
1146: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1147:
1148: l_log_string := ' gUHMergedSourceTypeTbl['||p_index||']: ' ||
1149: ICX_CAT_UTIL_PVT.getTableElement(gUHMergedSourceTypeTbl, p_index) || '; ';
1150: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1146: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1147:
1148: l_log_string := ' gUHMergedSourceTypeTbl['||p_index||']: ' ||
1149: ICX_CAT_UTIL_PVT.getTableElement(gUHMergedSourceTypeTbl, p_index) || '; ';
1150: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1151:
1152: END IF;
1153:
1154: l_err_loc := 800;
1157: l_err_loc := 900;
1158: -- DELETE icx_cat_items_ctx_hdrs_tlp
1159: l_log_string := ' gDHInventoryItemIdTbl['||p_index||']: ' ||
1160: ICX_CAT_UTIL_PVT.getTableElement(gDHInventoryItemIdTbl, p_index) || '; ';
1161: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1162:
1163: l_log_string := ' gDHPoLineIdTbl['||p_index||']: ' ||
1164: ICX_CAT_UTIL_PVT.getTableElement(gDHPoLineIdTbl, p_index) || '; ';
1165: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1161: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1162:
1163: l_log_string := ' gDHPoLineIdTbl['||p_index||']: ' ||
1164: ICX_CAT_UTIL_PVT.getTableElement(gDHPoLineIdTbl, p_index) || '; ';
1165: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1166:
1167: l_log_string := ' gDHReqTemplateNameTbl['||p_index||']: ' ||
1168: ICX_CAT_UTIL_PVT.getTableElement(gDHReqTemplateNameTbl, p_index) || '; ';
1169: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1165: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1166:
1167: l_log_string := ' gDHReqTemplateNameTbl['||p_index||']: ' ||
1168: ICX_CAT_UTIL_PVT.getTableElement(gDHReqTemplateNameTbl, p_index) || '; ';
1169: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1170:
1171: l_log_string := ' gDHReqTemplateLineNumTbl['||p_index||']: ' ||
1172: ICX_CAT_UTIL_PVT.getTableElement(gDHReqTemplateLineNumTbl, p_index) || '; ';
1173: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1169: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1170:
1171: l_log_string := ' gDHReqTemplateLineNumTbl['||p_index||']: ' ||
1172: ICX_CAT_UTIL_PVT.getTableElement(gDHReqTemplateLineNumTbl, p_index) || '; ';
1173: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1174:
1175: l_log_string := ' gDHOrgIdTbl['||p_index||']: ' ||
1176: ICX_CAT_UTIL_PVT.getTableElement(gDHOrgIdTbl, p_index) || '; ';
1177: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1173: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1174:
1175: l_log_string := ' gDHOrgIdTbl['||p_index||']: ' ||
1176: ICX_CAT_UTIL_PVT.getTableElement(gDHOrgIdTbl, p_index) || '; ';
1177: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1178:
1179: l_log_string := ' gDHLanguageTbl['||p_index||']: ' ||
1180: ICX_CAT_UTIL_PVT.getTableElement(gDHLanguageTbl, p_index) || '; ';
1181: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1177: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1178:
1179: l_log_string := ' gDHLanguageTbl['||p_index||']: ' ||
1180: ICX_CAT_UTIL_PVT.getTableElement(gDHLanguageTbl, p_index) || '; ';
1181: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1182:
1183: END IF;
1184:
1185: l_err_loc := 1000;
1188: l_err_loc := 1100;
1189: -- DELETE icx_cat_items_ctx_dtl_tlp
1190: l_log_string := ' gDDInventoryItemIdTbl['||p_index||']: ' ||
1191: ICX_CAT_UTIL_PVT.getTableElement(gDDInventoryItemIdTbl, p_index) || '; ';
1192: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1193:
1194: l_log_string := ' gDDPoLineIdTbl['||p_index||']: ' ||
1195: ICX_CAT_UTIL_PVT.getTableElement(gDDPoLineIdTbl, p_index) || '; ';
1196: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1192: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1193:
1194: l_log_string := ' gDDPoLineIdTbl['||p_index||']: ' ||
1195: ICX_CAT_UTIL_PVT.getTableElement(gDDPoLineIdTbl, p_index) || '; ';
1196: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1197:
1198: l_log_string := ' gDDReqTemplateNameTbl['||p_index||']: ' ||
1199: ICX_CAT_UTIL_PVT.getTableElement(gDDReqTemplateNameTbl, p_index) || '; ';
1200: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1196: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1197:
1198: l_log_string := ' gDDReqTemplateNameTbl['||p_index||']: ' ||
1199: ICX_CAT_UTIL_PVT.getTableElement(gDDReqTemplateNameTbl, p_index) || '; ';
1200: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1201:
1202: l_log_string := ' gDDReqTemplateLineNumTbl['||p_index||']: ' ||
1203: ICX_CAT_UTIL_PVT.getTableElement(gDDReqTemplateLineNumTbl, p_index) || '; ';
1204: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1200: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1201:
1202: l_log_string := ' gDDReqTemplateLineNumTbl['||p_index||']: ' ||
1203: ICX_CAT_UTIL_PVT.getTableElement(gDDReqTemplateLineNumTbl, p_index) || '; ';
1204: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1205:
1206: l_log_string := ' gDDOrgIdTbl['||p_index||']: ' ||
1207: ICX_CAT_UTIL_PVT.getTableElement(gDDOrgIdTbl, p_index) || '; ';
1208: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1204: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1205:
1206: l_log_string := ' gDDOrgIdTbl['||p_index||']: ' ||
1207: ICX_CAT_UTIL_PVT.getTableElement(gDDOrgIdTbl, p_index) || '; ';
1208: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1209:
1210: l_log_string := ' gDDLanguageTbl['||p_index||']: ' ||
1211: ICX_CAT_UTIL_PVT.getTableElement(gDDLanguageTbl, p_index) || '; ';
1212: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1208: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1209:
1210: l_log_string := ' gDDLanguageTbl['||p_index||']: ' ||
1211: ICX_CAT_UTIL_PVT.getTableElement(gDDLanguageTbl, p_index) || '; ';
1212: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1213:
1214: END IF;
1215:
1216: l_err_loc := 1200;
1219: l_err_loc := 1300;
1220: -- DELETE rows with sequence = 1 in icx_cat_items_ctx_dtl_tlp
1221: l_log_string := ' gDMDInventoryItemIdTbl['||p_index||']: ' ||
1222: ICX_CAT_UTIL_PVT.getTableElement(gDMDInventoryItemIdTbl, p_index) || '; ';
1223: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1224:
1225: l_log_string := ' gDMDPoLineIdTbl['||p_index||']: ' ||
1226: ICX_CAT_UTIL_PVT.getTableElement(gDMDPoLineIdTbl, p_index) || '; ';
1227: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1223: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1224:
1225: l_log_string := ' gDMDPoLineIdTbl['||p_index||']: ' ||
1226: ICX_CAT_UTIL_PVT.getTableElement(gDMDPoLineIdTbl, p_index) || '; ';
1227: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1228:
1229: l_log_string := ' gDMDReqTemplateNameTbl['||p_index||']: ' ||
1230: ICX_CAT_UTIL_PVT.getTableElement(gDMDReqTemplateNameTbl, p_index) || '; ';
1231: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1227: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1228:
1229: l_log_string := ' gDMDReqTemplateNameTbl['||p_index||']: ' ||
1230: ICX_CAT_UTIL_PVT.getTableElement(gDMDReqTemplateNameTbl, p_index) || '; ';
1231: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1232:
1233: l_log_string := ' gDMDReqTemplateLineNumTbl['||p_index||']: ' ||
1234: ICX_CAT_UTIL_PVT.getTableElement(gDMDReqTemplateLineNumTbl, p_index) || '; ';
1235: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1231: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1232:
1233: l_log_string := ' gDMDReqTemplateLineNumTbl['||p_index||']: ' ||
1234: ICX_CAT_UTIL_PVT.getTableElement(gDMDReqTemplateLineNumTbl, p_index) || '; ';
1235: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1236:
1237: l_log_string := ' gDMDOrgIdTbl['||p_index||']: ' ||
1238: ICX_CAT_UTIL_PVT.getTableElement(gDMDOrgIdTbl, p_index) || '; ';
1239: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1235: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1236:
1237: l_log_string := ' gDMDOrgIdTbl['||p_index||']: ' ||
1238: ICX_CAT_UTIL_PVT.getTableElement(gDMDOrgIdTbl, p_index) || '; ';
1239: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1240:
1241: l_log_string := ' gDMDLanguageTbl['||p_index||']: ' ||
1242: ICX_CAT_UTIL_PVT.getTableElement(gDMDLanguageTbl, p_index) || '; ';
1243: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1239: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1240:
1241: l_log_string := ' gDMDLanguageTbl['||p_index||']: ' ||
1242: ICX_CAT_UTIL_PVT.getTableElement(gDMDLanguageTbl, p_index) || '; ';
1243: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1244:
1245: END IF;
1246:
1247: l_err_loc := 1400;
1250: l_err_loc := 1500;
1251: -- DELETE rows with sequence = 2 in icx_cat_items_ctx_dtl_tlp
1252: l_log_string := ' gDSDInventoryItemIdTbl['||p_index||']: ' ||
1253: ICX_CAT_UTIL_PVT.getTableElement(gDSDInventoryItemIdTbl, p_index) || '; ';
1254: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1255:
1256: l_log_string := ' gDSDPoLineIdTbl['||p_index||']: ' ||
1257: ICX_CAT_UTIL_PVT.getTableElement(gDSDPoLineIdTbl, p_index) || '; ';
1258: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1254: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1255:
1256: l_log_string := ' gDSDPoLineIdTbl['||p_index||']: ' ||
1257: ICX_CAT_UTIL_PVT.getTableElement(gDSDPoLineIdTbl, p_index) || '; ';
1258: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1259:
1260: l_log_string := ' gDSDReqTemplateNameTbl['||p_index||']: ' ||
1261: ICX_CAT_UTIL_PVT.getTableElement(gDSDReqTemplateNameTbl, p_index) || '; ';
1262: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1258: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1259:
1260: l_log_string := ' gDSDReqTemplateNameTbl['||p_index||']: ' ||
1261: ICX_CAT_UTIL_PVT.getTableElement(gDSDReqTemplateNameTbl, p_index) || '; ';
1262: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1263:
1264: l_log_string := ' gDSDReqTemplateLineNumTbl['||p_index||']: ' ||
1265: ICX_CAT_UTIL_PVT.getTableElement(gDSDReqTemplateLineNumTbl, p_index) || '; ';
1266: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1262: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1263:
1264: l_log_string := ' gDSDReqTemplateLineNumTbl['||p_index||']: ' ||
1265: ICX_CAT_UTIL_PVT.getTableElement(gDSDReqTemplateLineNumTbl, p_index) || '; ';
1266: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1267:
1268: l_log_string := ' gDSDOrgIdTbl['||p_index||']: ' ||
1269: ICX_CAT_UTIL_PVT.getTableElement(gDSDOrgIdTbl, p_index) || '; ';
1270: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1266: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1267:
1268: l_log_string := ' gDSDOrgIdTbl['||p_index||']: ' ||
1269: ICX_CAT_UTIL_PVT.getTableElement(gDSDOrgIdTbl, p_index) || '; ';
1270: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1271:
1272: l_log_string := ' gDSDLanguageTbl['||p_index||']: ' ||
1273: ICX_CAT_UTIL_PVT.getTableElement(gDSDLanguageTbl, p_index) || '; ';
1274: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1270: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1271:
1272: l_log_string := ' gDSDLanguageTbl['||p_index||']: ' ||
1273: ICX_CAT_UTIL_PVT.getTableElement(gDSDLanguageTbl, p_index) || '; ';
1274: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1275:
1276: END IF;
1277:
1278: l_err_loc := 1600;
1281: l_err_loc := 1700;
1282: -- DELETE rows with sequence = 5 in icx_cat_items_ctx_dtl_tlp
1283: l_log_string := ' gDIRDInventoryItemIdTbl['||p_index||']: ' ||
1284: ICX_CAT_UTIL_PVT.getTableElement(gDIRDInventoryItemIdTbl, p_index) || '; ';
1285: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1286:
1287: l_log_string := ' gDIRDPoLineIdTbl['||p_index||']: ' ||
1288: ICX_CAT_UTIL_PVT.getTableElement(gDIRDPoLineIdTbl, p_index) || '; ';
1289: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1285: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1286:
1287: l_log_string := ' gDIRDPoLineIdTbl['||p_index||']: ' ||
1288: ICX_CAT_UTIL_PVT.getTableElement(gDIRDPoLineIdTbl, p_index) || '; ';
1289: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1290:
1291: l_log_string := ' gDIRDReqTemplateNameTbl['||p_index||']: ' ||
1292: ICX_CAT_UTIL_PVT.getTableElement(gDIRDReqTemplateNameTbl, p_index) || '; ';
1293: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1289: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1290:
1291: l_log_string := ' gDIRDReqTemplateNameTbl['||p_index||']: ' ||
1292: ICX_CAT_UTIL_PVT.getTableElement(gDIRDReqTemplateNameTbl, p_index) || '; ';
1293: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1294:
1295: l_log_string := ' gDIRDReqTemplateLineNumTbl['||p_index||']: ' ||
1296: ICX_CAT_UTIL_PVT.getTableElement(gDIRDReqTemplateLineNumTbl, p_index) || '; ';
1297: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1293: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1294:
1295: l_log_string := ' gDIRDReqTemplateLineNumTbl['||p_index||']: ' ||
1296: ICX_CAT_UTIL_PVT.getTableElement(gDIRDReqTemplateLineNumTbl, p_index) || '; ';
1297: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1298:
1299: l_log_string := ' gDIRDOrgIdTbl['||p_index||']: ' ||
1300: ICX_CAT_UTIL_PVT.getTableElement(gDIRDOrgIdTbl, p_index) || '; ';
1301: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1297: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1298:
1299: l_log_string := ' gDIRDOrgIdTbl['||p_index||']: ' ||
1300: ICX_CAT_UTIL_PVT.getTableElement(gDIRDOrgIdTbl, p_index) || '; ';
1301: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1302:
1303: l_log_string := ' gDIRDLanguageTbl['||p_index||']: ' ||
1304: ICX_CAT_UTIL_PVT.getTableElement(gDIRDLanguageTbl, p_index) || '; ';
1305: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1301: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1302:
1303: l_log_string := ' gDIRDLanguageTbl['||p_index||']: ' ||
1304: ICX_CAT_UTIL_PVT.getTableElement(gDIRDLanguageTbl, p_index) || '; ';
1305: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1306:
1307: END IF;
1308:
1309: l_err_loc := 1800;
1312: l_err_loc := 1900;
1313: -- DELETE rows with sequence = 6 in icx_cat_items_ctx_dtl_tlp
1314: l_log_string := ' gDSCDInventoryItemIdTbl['||p_index||']: ' ||
1315: ICX_CAT_UTIL_PVT.getTableElement(gDSCDInventoryItemIdTbl, p_index) || '; ';
1316: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1317:
1318: l_log_string := ' gDSCDPoLineIdTbl['||p_index||']: ' ||
1319: ICX_CAT_UTIL_PVT.getTableElement(gDSCDPoLineIdTbl, p_index) || '; ';
1320: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1316: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1317:
1318: l_log_string := ' gDSCDPoLineIdTbl['||p_index||']: ' ||
1319: ICX_CAT_UTIL_PVT.getTableElement(gDSCDPoLineIdTbl, p_index) || '; ';
1320: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1321:
1322: l_log_string := ' gDSCDReqTemplateNameTbl['||p_index||']: ' ||
1323: ICX_CAT_UTIL_PVT.getTableElement(gDSCDReqTemplateNameTbl, p_index) || '; ';
1324: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1320: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1321:
1322: l_log_string := ' gDSCDReqTemplateNameTbl['||p_index||']: ' ||
1323: ICX_CAT_UTIL_PVT.getTableElement(gDSCDReqTemplateNameTbl, p_index) || '; ';
1324: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1325:
1326: l_log_string := ' gDSCDReqTemplateLineNumTbl['||p_index||']: ' ||
1327: ICX_CAT_UTIL_PVT.getTableElement(gDSCDReqTemplateLineNumTbl, p_index) || '; ';
1328: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1324: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1325:
1326: l_log_string := ' gDSCDReqTemplateLineNumTbl['||p_index||']: ' ||
1327: ICX_CAT_UTIL_PVT.getTableElement(gDSCDReqTemplateLineNumTbl, p_index) || '; ';
1328: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1329:
1330: l_log_string := ' gDSCDOrgIdTbl['||p_index||']: ' ||
1331: ICX_CAT_UTIL_PVT.getTableElement(gDSCDOrgIdTbl, p_index) || '; ';
1332: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1328: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1329:
1330: l_log_string := ' gDSCDOrgIdTbl['||p_index||']: ' ||
1331: ICX_CAT_UTIL_PVT.getTableElement(gDSCDOrgIdTbl, p_index) || '; ';
1332: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1333:
1334: l_log_string := ' gDSCDLanguageTbl['||p_index||']: ' ||
1335: ICX_CAT_UTIL_PVT.getTableElement(gDSCDLanguageTbl, p_index) || '; ';
1336: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1332: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1333:
1334: l_log_string := ' gDSCDLanguageTbl['||p_index||']: ' ||
1335: ICX_CAT_UTIL_PVT.getTableElement(gDSCDLanguageTbl, p_index) || '; ';
1336: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1337:
1338: END IF;
1339:
1340: l_err_loc := 2000;
1343: l_err_loc := 2100;
1344: -- DELETE rows with sequence =15001 in icx_cat_items_ctx_dtl_tlp
1345: l_log_string := ' gDPODInventoryItemIdTbl['||p_index||']: ' ||
1346: ICX_CAT_UTIL_PVT.getTableElement(gDPODInventoryItemIdTbl, p_index) || '; ';
1347: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1348:
1349: l_log_string := ' gDPODPoLineIdTbl['||p_index||']: ' ||
1350: ICX_CAT_UTIL_PVT.getTableElement(gDPODPoLineIdTbl, p_index) || '; ';
1351: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1347: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1348:
1349: l_log_string := ' gDPODPoLineIdTbl['||p_index||']: ' ||
1350: ICX_CAT_UTIL_PVT.getTableElement(gDPODPoLineIdTbl, p_index) || '; ';
1351: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1352:
1353: l_log_string := ' gDPODReqTemplateNameTbl['||p_index||']: ' ||
1354: ICX_CAT_UTIL_PVT.getTableElement(gDPODReqTemplateNameTbl, p_index) || '; ';
1355: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1351: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1352:
1353: l_log_string := ' gDPODReqTemplateNameTbl['||p_index||']: ' ||
1354: ICX_CAT_UTIL_PVT.getTableElement(gDPODReqTemplateNameTbl, p_index) || '; ';
1355: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1356:
1357: l_log_string := ' gDPODReqTemplateLineNumTbl['||p_index||']: ' ||
1358: ICX_CAT_UTIL_PVT.getTableElement(gDPODReqTemplateLineNumTbl, p_index) || '; ';
1359: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1355: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1356:
1357: l_log_string := ' gDPODReqTemplateLineNumTbl['||p_index||']: ' ||
1358: ICX_CAT_UTIL_PVT.getTableElement(gDPODReqTemplateLineNumTbl, p_index) || '; ';
1359: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1360:
1361: l_log_string := ' gDPODOrgIdTbl['||p_index||']: ' ||
1362: ICX_CAT_UTIL_PVT.getTableElement(gDPODOrgIdTbl, p_index) || '; ';
1363: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1359: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1360:
1361: l_log_string := ' gDPODOrgIdTbl['||p_index||']: ' ||
1362: ICX_CAT_UTIL_PVT.getTableElement(gDPODOrgIdTbl, p_index) || '; ';
1363: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1364:
1365: l_log_string := ' gDPODPurchasingOrgIdTbl['||p_index||']: ' ||
1366: ICX_CAT_UTIL_PVT.getTableElement(gDPODPurchasingOrgIdTbl, p_index) || '; ';
1367: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1363: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1364:
1365: l_log_string := ' gDPODPurchasingOrgIdTbl['||p_index||']: ' ||
1366: ICX_CAT_UTIL_PVT.getTableElement(gDPODPurchasingOrgIdTbl, p_index) || '; ';
1367: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1368:
1369: l_log_string := ' gDPODLanguageTbl['||p_index||']: ' ||
1370: ICX_CAT_UTIL_PVT.getTableElement(gDPODLanguageTbl, p_index) || '; ';
1371: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1367: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1368:
1369: l_log_string := ' gDPODLanguageTbl['||p_index||']: ' ||
1370: ICX_CAT_UTIL_PVT.getTableElement(gDPODLanguageTbl, p_index) || '; ';
1371: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1372:
1373: END IF;
1374: END IF;
1375:
1804: BEGIN
1805: l_err_loc := 100;
1806: IF (p_current_ctx_item_rec.ctx_rowid IS NULL) THEN
1807: -- Row does not exist in item ctx tables
1808: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1809: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1810: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1811: 'New row');
1812: END IF;
1805: l_err_loc := 100;
1806: IF (p_current_ctx_item_rec.ctx_rowid IS NULL) THEN
1807: -- Row does not exist in item ctx tables
1808: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1809: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1810: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1811: 'New row');
1812: END IF;
1813: l_err_loc := 200;
1822: -- 3. Need to delete the row based upon status
1823: l_err_loc := 400;
1824: IF (p_current_ctx_item_rec.status = 0) THEN
1825: l_err_loc := 500;
1826: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1827: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1828: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1829: 'Update row. p_current_cursor:' || p_current_cursor ||
1830: ', p_mode:' || p_mode);
1823: l_err_loc := 400;
1824: IF (p_current_ctx_item_rec.status = 0) THEN
1825: l_err_loc := 500;
1826: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1827: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1828: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1829: 'Update row. p_current_cursor:' || p_current_cursor ||
1830: ', p_mode:' || p_mode);
1831: END IF;
1835: THEN
1836: -- inventory item id has changed which means in a po line or req template line,
1837: -- the description based item has been changed to an inventory item.
1838: -- For this case, just delete and recreate the item.
1839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1841: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1842: 'Inventory item changed: for po_line_id:' || p_current_ctx_item_rec.po_line_id ||
1843: ', templt_name:' || p_current_ctx_item_rec.req_template_name ||
1836: -- inventory item id has changed which means in a po line or req template line,
1837: -- the description based item has been changed to an inventory item.
1838: -- For this case, just delete and recreate the item.
1839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1841: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1842: 'Inventory item changed: for po_line_id:' || p_current_ctx_item_rec.po_line_id ||
1843: ', templt_name:' || p_current_ctx_item_rec.req_template_name ||
1844: ', template_line_num:' || p_current_ctx_item_rec.req_template_line_num ||
1881: p_current_ctx_item_rec.ctx_supplier_part_auxid <> p_current_ctx_item_rec.supplier_part_auxid)
1882: THEN
1883: l_err_loc := 1200;
1884: -- Re-populate the row with sequence = 1 i.e. mandatory row
1885: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1887: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1888: 'Row 1 needs to be re-populated:');
1889: END IF;
1882: THEN
1883: l_err_loc := 1200;
1884: -- Re-populate the row with sequence = 1 i.e. mandatory row
1885: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1887: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1888: 'Row 1 needs to be re-populated:');
1889: END IF;
1890: l_repopulate_mandatory_row := TRUE;
1894: IF (p_current_ctx_item_rec.ctx_supplier_id <> p_current_ctx_item_rec.supplier_id)
1895: THEN
1896: l_err_loc := 1400;
1897: -- Re-populate the row with sequence = 1 and 2 i.e. mandatory row and supplier row
1898: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1900: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1901: 'Supplier Row needs to be re-populated:');
1902: END IF;
1895: THEN
1896: l_err_loc := 1400;
1897: -- Re-populate the row with sequence = 1 and 2 i.e. mandatory row and supplier row
1898: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1900: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1901: 'Supplier Row needs to be re-populated:');
1902: END IF;
1903: l_repopulate_mandatory_row := TRUE;
1917: -- express_name in po_reqexpress_headers_all cannot be changed once created.
1918: IF (p_current_ctx_item_rec.ctx_ip_category_id <> p_current_ctx_item_rec.ip_category_id) THEN
1919: l_err_loc := 1600;
1920: -- Re-populate the row with sequence = 1 and 6 i.e. mandatory row and shopping_category row
1921: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1922: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1923: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1924: 'Shop category Row needs to be re-populated:');
1925: END IF;
1918: IF (p_current_ctx_item_rec.ctx_ip_category_id <> p_current_ctx_item_rec.ip_category_id) THEN
1919: l_err_loc := 1600;
1920: -- Re-populate the row with sequence = 1 and 6 i.e. mandatory row and shopping_category row
1921: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1922: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1923: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1924: 'Shop category Row needs to be re-populated:');
1925: END IF;
1926: l_repopulate_mandatory_row := TRUE;
1930: l_err_loc := 1700;
1931:
1932: IF (p_current_ctx_item_rec.ctx_purchasing_org_id <> p_current_ctx_item_rec.purchasing_org_id) THEN
1933: l_err_loc := 1800;
1934: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1935: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1936: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1937: 'purchasing org_id Row needs to be re-populated:');
1938: END IF;
1931:
1932: IF (p_current_ctx_item_rec.ctx_purchasing_org_id <> p_current_ctx_item_rec.purchasing_org_id) THEN
1933: l_err_loc := 1800;
1934: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1935: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1936: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1937: 'purchasing org_id Row needs to be re-populated:');
1938: END IF;
1939: -- Re-populate the row with sequence = 15001 i.e. purchorgid
1965: )
1966: THEN
1967: l_err_loc := 2200;
1968: l_update_item_ctx_hdr_row := TRUE;
1969: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1970: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1971: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1972: 'item revision Row needs to be re-populated:' ||
1973: ', source_type:' || p_current_ctx_item_rec.source_type ||
1966: THEN
1967: l_err_loc := 2200;
1968: l_update_item_ctx_hdr_row := TRUE;
1969: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1970: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1971: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1972: 'item revision Row needs to be re-populated:' ||
1973: ', source_type:' || p_current_ctx_item_rec.source_type ||
1974: ', p_mode:' || p_mode ||
1997: p_current_cursor = 'ORG_ASSIGNMENT_CSR'))
1998: THEN
1999: l_err_loc := 2400;
2000: l_update_item_ctx_hdr_row := TRUE;
2001: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2002: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2003: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2004: 'base and local Row needs to be re-populated:' ||
2005: ', source_type:' || p_current_ctx_item_rec.source_type ||
1998: THEN
1999: l_err_loc := 2400;
2000: l_update_item_ctx_hdr_row := TRUE;
2001: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2002: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2003: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2004: 'base and local Row needs to be re-populated:' ||
2005: ', source_type:' || p_current_ctx_item_rec.source_type ||
2006: ', p_mode:' || p_mode ||
2017: -- The row needs to be updated in icx_cat_items_ctx_hdrs
2018: -- We have to update the ctx_desc to null in hdrs table, for rebuild indexes.
2019: updateItemCtxHdrsTLP(p_current_ctx_item_rec);
2020: ELSE
2021: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2022: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2023: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2024: ', l_update_item_ctx_hdr_row is false; so will not call updateItemCtxHdrsTLP');
2025: END IF;
2018: -- We have to update the ctx_desc to null in hdrs table, for rebuild indexes.
2019: updateItemCtxHdrsTLP(p_current_ctx_item_rec);
2020: ELSE
2021: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2022: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2023: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2024: ', l_update_item_ctx_hdr_row is false; so will not call updateItemCtxHdrsTLP');
2025: END IF;
2026: END IF;
2027:
2028: l_err_loc := 2700;
2029: END IF;
2030: ELSE -- status is not 0
2031: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2032: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2033: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2034: 'Delete row');
2035: END IF;
2028: l_err_loc := 2700;
2029: END IF;
2030: ELSE -- status is not 0
2031: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2032: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2033: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2034: 'Delete row');
2035: END IF;
2036: -- i.e. the row is invalid and needs to be deleted
2089: l_language icx_cat_items_ctx_hdrs_tlp.language%TYPE;
2090: --BUG 6599217: end 1
2091: BEGIN
2092: l_err_loc := 100;
2093: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2095: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2096: 'Enter populateItemCtxTables(' || p_mode || ', ' || p_current_cursor ||
2097: ')gTotalRowCount: ' || gTotalRowCount);
2090: --BUG 6599217: end 1
2091: BEGIN
2092: l_err_loc := 100;
2093: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2095: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2096: 'Enter populateItemCtxTables(' || p_mode || ', ' || p_current_cursor ||
2097: ')gTotalRowCount: ' || gTotalRowCount);
2098: END IF;
2101: IF (p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size) THEN
2102: l_err_loc := 200;
2103: gTotalRowCount := 0;
2104:
2105: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2107: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2108: '; Num. of rows to be inserted into hdrs:' || gIHInventoryItemIdTbl.COUNT ||
2109: '; Num. of rows to be inserted into dtls:' || gIDInventoryItemIdTbl.COUNT ||
2102: l_err_loc := 200;
2103: gTotalRowCount := 0;
2104:
2105: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2107: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2108: '; Num. of rows to be inserted into hdrs:' || gIHInventoryItemIdTbl.COUNT ||
2109: '; Num. of rows to be inserted into dtls:' || gIDInventoryItemIdTbl.COUNT ||
2110: ', Total num. of rows to be updated:' || gUHInventoryItemIdTbl.COUNT ||
2161: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
2162: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
2163:
2164: IF (gIHInventoryItemIdTbl.COUNT > 0) THEN
2165: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2166: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2167: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2168: 'Num. of rows inserted into ctx_hdrs:' ||SQL%ROWCOUNT);
2169: END IF;
2162: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
2163:
2164: IF (gIHInventoryItemIdTbl.COUNT > 0) THEN
2165: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2166: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2167: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2168: 'Num. of rows inserted into ctx_hdrs:' ||SQL%ROWCOUNT);
2169: END IF;
2170: END IF;
2175: if ( p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) then
2176:
2177: l_action_mode := 'INSERT_PO_ATTR_VALUES';
2178:
2179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2181: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2182: ' loop count : ' ||gIHInventoryItemIdTbl.Count);
2183: END IF;
2176:
2177: l_action_mode := 'INSERT_PO_ATTR_VALUES';
2178:
2179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2181: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2182: ' loop count : ' ||gIHInventoryItemIdTbl.Count);
2183: END IF;
2184:
2193: l_long_description := gIHLongDescriptionTbl(i);
2194: l_organization_id := gIHOrganizationIdTbl(i);
2195: l_master_organization_id := gIHMasterOrganizationIdTbl(i);
2196:
2197: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2200: 'Value of variable are l_ip_category_id= ' ||l_ip_category_id|| 'l_inventory_item_id=' ||l_inventory_item_id||
2201: 'l_org_id='||l_org_id||'l_description='||l_description);
2194: l_organization_id := gIHOrganizationIdTbl(i);
2195: l_master_organization_id := gIHMasterOrganizationIdTbl(i);
2196:
2197: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2200: 'Value of variable are l_ip_category_id= ' ||l_ip_category_id|| 'l_inventory_item_id=' ||l_inventory_item_id||
2201: 'l_org_id='||l_org_id||'l_description='||l_description);
2202: END IF;
2345: temp.creation_date, temp.request_id, temp.program_application_id, temp.program_id,
2346: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2347:
2348: IF (gIHInventoryItemIdTbl.COUNT > 0) THEN
2349: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2351: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2352: 'Num. of rows inserted into icx_cat_attribute_values:' ||SQL%ROWCOUNT);
2353: END IF;
2346: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2347:
2348: IF (gIHInventoryItemIdTbl.COUNT > 0) THEN
2349: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2351: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2352: 'Num. of rows inserted into icx_cat_attribute_values:' ||SQL%ROWCOUNT);
2353: END IF;
2354: END IF;
2358: -- BUG 6599217.start 3 new procedure to insert into PO_ATTRIBUTE_VALUES_TLP
2359: if ( p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) then
2360: l_action_mode := 'INSERT_PO_ATTR_VALUES_TLP';
2361:
2362: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2363: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2364: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2365: ' loop count : ' ||gIHInventoryItemIdTbl.Count);
2366: END IF;
2359: if ( p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) then
2360: l_action_mode := 'INSERT_PO_ATTR_VALUES_TLP';
2361:
2362: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2363: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2364: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2365: ' loop count : ' ||gIHInventoryItemIdTbl.Count);
2366: END IF;
2367:
2377: l_long_description := gIHLongDescriptionTbl(i);
2378: l_organization_id := gIHOrganizationIdTbl(i);
2379: l_master_organization_id := gIHMasterOrganizationIdTbl(i);
2380:
2381: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2383: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2384: 'Value of variable are l_inventory_item_id=' ||l_inventory_item_id||
2385: 'l_org_id='||l_org_id||'l_language='||l_language||' l_ip_category_id=' ||l_ip_category_id);
2378: l_organization_id := gIHOrganizationIdTbl(i);
2379: l_master_organization_id := gIHMasterOrganizationIdTbl(i);
2380:
2381: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2383: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2384: 'Value of variable are l_inventory_item_id=' ||l_inventory_item_id||
2385: 'l_org_id='||l_org_id||'l_language='||l_language||' l_ip_category_id=' ||l_ip_category_id);
2386: END IF;
2482: temp.creation_date, temp.request_id, temp.program_application_id, temp.program_id,
2483: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2484:
2485: IF (gIHInventoryItemIdTbl.COUNT > 0) THEN
2486: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2487: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2488: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2489: 'Num. of rows inserted into icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2490: END IF;
2483: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2484:
2485: IF (gIHInventoryItemIdTbl.COUNT > 0) THEN
2486: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2487: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2488: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2489: 'Num. of rows inserted into icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2490: END IF;
2491: END IF;
2548: AND language = gUHLanguageTbl(i)
2549: AND source_type = gUHSourceTypeTbl(i);
2550:
2551: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2552: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2554: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2555: 'Num. of rows updated in ctx_hdrs:' ||SQL%ROWCOUNT);
2556: END IF;
2549: AND source_type = gUHSourceTypeTbl(i);
2550:
2551: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2552: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2554: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2555: 'Num. of rows updated in ctx_hdrs:' ||SQL%ROWCOUNT);
2556: END IF;
2557: END IF;
2562: --BUG 6599217 Start3 : Here the po_attribute tables have stale data so update
2563: --the po_attribute tables with new values.
2564: if (p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) then
2565:
2566: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2568: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2569: 'updating po attribute tables count=:' ||gUHInventoryItemIdTbl.Count);
2570: END IF;
2563: --the po_attribute tables with new values.
2564: if (p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) then
2565:
2566: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2568: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2569: 'updating po attribute tables count=:' ||gUHInventoryItemIdTbl.Count);
2570: END IF;
2571:
2595: AND req_template_line_num = gUHReqTemplateLineNumTbl(i)
2596: AND org_id = gUHOrgIdTbl(i);
2597:
2598: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2599: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2600: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2601: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2602: 'Num. of rows deleted for update from icx_cat_attribute_values:' ||SQL%ROWCOUNT);
2603: END IF;
2596: AND org_id = gUHOrgIdTbl(i);
2597:
2598: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2599: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2600: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2601: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2602: 'Num. of rows deleted for update from icx_cat_attribute_values:' ||SQL%ROWCOUNT);
2603: END IF;
2604: END IF;
2731: temp.creation_date, temp.request_id, temp.program_application_id, temp.program_id,
2732: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2733:
2734: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2735: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2736: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2737: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2738: 'Num. of rows updated into icx_cat_attribute_values:' ||SQL%ROWCOUNT);
2739: END IF;
2732: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2733:
2734: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2735: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2736: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2737: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2738: 'Num. of rows updated into icx_cat_attribute_values:' ||SQL%ROWCOUNT);
2739: END IF;
2740: END IF;
2750: AND org_id = gUHOrgIdTbl(i)
2751: AND language = gUHLanguageTbl(i);
2752:
2753: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2754: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2755: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2756: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2757: 'Num. of rows deleted for update from icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2758: END IF;
2751: AND language = gUHLanguageTbl(i);
2752:
2753: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2754: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2755: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2756: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2757: 'Num. of rows deleted for update from icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2758: END IF;
2759: END IF;
2836: temp.creation_date, temp.request_id, temp.program_application_id, temp.program_id,
2837: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2838:
2839: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2840: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2841: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2842: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2843: 'Num. of rows updated into icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2844: END IF;
2837: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
2838:
2839: IF (gUHInventoryItemIdTbl.COUNT > 0) THEN
2840: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2841: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2842: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2843: 'Num. of rows updated into icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2844: END IF;
2845: END IF;
2858: AND org_id = gDDOrgIdTbl(i)
2859: AND language = gDDLanguageTbl(i);
2860:
2861: IF (gDDInventoryItemIdTbl.COUNT > 0) THEN
2862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2863: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2864: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2865: 'Num. of rows deleted from ctx_dtls:' ||SQL%ROWCOUNT);
2866: END IF;
2859: AND language = gDDLanguageTbl(i);
2860:
2861: IF (gDDInventoryItemIdTbl.COUNT > 0) THEN
2862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2863: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2864: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2865: 'Num. of rows deleted from ctx_dtls:' ||SQL%ROWCOUNT);
2866: END IF;
2867: END IF;
2880: AND org_id = gDHOrgIdTbl(i)
2881: AND language = gDHLanguageTbl(i);
2882:
2883: IF (gDHInventoryItemIdTbl.COUNT > 0) THEN
2884: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2885: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2886: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2887: 'Num. of rows deleted from ctx_hdrs:' ||SQL%ROWCOUNT);
2888: END IF;
2881: AND language = gDHLanguageTbl(i);
2882:
2883: IF (gDHInventoryItemIdTbl.COUNT > 0) THEN
2884: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2885: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2886: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2887: 'Num. of rows deleted from ctx_hdrs:' ||SQL%ROWCOUNT);
2888: END IF;
2889: END IF;
2898: AND req_template_line_num = gDHReqTemplateLineNumTbl(i)
2899: AND org_id = gDHOrgIdTbl(i);
2900:
2901: IF (gDHInventoryItemIdTbl.COUNT > 0) THEN
2902: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2904: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2905: 'Num. of rows deleted from icx_Cat_attribute_values:' ||SQL%ROWCOUNT);
2906: END IF;
2899: AND org_id = gDHOrgIdTbl(i);
2900:
2901: IF (gDHInventoryItemIdTbl.COUNT > 0) THEN
2902: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2903: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2904: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2905: 'Num. of rows deleted from icx_Cat_attribute_values:' ||SQL%ROWCOUNT);
2906: END IF;
2907: END IF;
2917: AND org_id = gDHOrgIdTbl(i)
2918: AND language = gDHLanguageTbl(i);
2919:
2920: IF (gDHInventoryItemIdTbl.COUNT > 0) THEN
2921: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2922: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2923: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2924: 'Num. of rows deleted from icx_Cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2925: END IF;
2918: AND language = gDHLanguageTbl(i);
2919:
2920: IF (gDHInventoryItemIdTbl.COUNT > 0) THEN
2921: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2922: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2923: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2924: 'Num. of rows deleted from icx_Cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
2925: END IF;
2926: END IF;
2993: AND language = gDMDLanguageTbl(i)
2994: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;
2995:
2996: IF (gDMDInventoryItemIdTbl.COUNT > 0) THEN
2997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2999: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3000: 'Num. of rows deleted from ctx_dtls for mandatory row changes:' ||SQL%ROWCOUNT);
3001: END IF;
2994: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;
2995:
2996: IF (gDMDInventoryItemIdTbl.COUNT > 0) THEN
2997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2999: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3000: 'Num. of rows deleted from ctx_dtls for mandatory row changes:' ||SQL%ROWCOUNT);
3001: END IF;
3002: END IF;
3015: AND language = gDSDLanguageTbl(i)
3016: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3017:
3018: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3019: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3020: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3021: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3022: 'Num. of rows deleted from ctx_dtls for supplier row changes:' ||SQL%ROWCOUNT);
3023: END IF;
3016: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3017:
3018: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3019: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3020: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3021: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3022: 'Num. of rows deleted from ctx_dtls for supplier row changes:' ||SQL%ROWCOUNT);
3023: END IF;
3024: END IF;
3037: AND language = gDIRDLanguageTbl(i)
3038: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
3039:
3040: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3042: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3043: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3044: 'Num. of rows deleted from ctx_dtls for item revision row changes:' ||SQL%ROWCOUNT);
3045: END IF;
3038: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
3039:
3040: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3042: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3043: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3044: 'Num. of rows deleted from ctx_dtls for item revision row changes:' ||SQL%ROWCOUNT);
3045: END IF;
3046: END IF;
3059: AND language = gDSCDLanguageTbl(i)
3060: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
3061:
3062: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3063: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3065: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3066: 'Num. of rows deleted from ctx_dtls for shop category row changes:' ||SQL%ROWCOUNT);
3067: END IF;
3060: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
3061:
3062: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3063: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3065: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3066: 'Num. of rows deleted from ctx_dtls for shop category row changes:' ||SQL%ROWCOUNT);
3067: END IF;
3068: END IF;
3081: AND language = gDPODLanguageTbl(i)
3082: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForPurchasingOrgIdRow;
3083:
3084: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3087: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3088: 'Num. of rows deleted from ctx_dtls for purch org row changes:' ||SQL%ROWCOUNT);
3089: END IF;
3082: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForPurchasingOrgIdRow;
3083:
3084: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3087: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3088: 'Num. of rows deleted from ctx_dtls for purch org row changes:' ||SQL%ROWCOUNT);
3089: END IF;
3090: END IF;
3105: AND language = gDBLDLanguageTbl(i)
3106: AND ((sequence BETWEEN l_start_sequence AND l_end_sequence) OR SEQUENCE = 3);
3107:
3108: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3111: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3112: 'Num. of rows deleted from ctx_dtls for base and local row changes:' ||SQL%ROWCOUNT);
3113: END IF;
3106: AND ((sequence BETWEEN l_start_sequence AND l_end_sequence) OR SEQUENCE = 3);
3107:
3108: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3111: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3112: 'Num. of rows deleted from ctx_dtls for base and local row changes:' ||SQL%ROWCOUNT);
3113: END IF;
3114: END IF;
3178: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3179: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3180:
3181: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3183: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3184: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3185: 'Num. of rows inserted into ctx_dtls for org row:' ||SQL%ROWCOUNT);
3186: END IF;
3179: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3180:
3181: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3183: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3184: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3185: 'Num. of rows inserted into ctx_dtls for org row:' ||SQL%ROWCOUNT);
3186: END IF;
3187: END IF;
3206: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3207: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3208:
3209: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3210: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3211: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3212: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3213: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3214: END IF;
3207: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3208:
3209: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3210: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3211: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3212: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3213: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3214: END IF;
3215: END IF;
3235: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3236: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3237:
3238: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3240: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3241: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3242: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3243: END IF;
3236: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3237:
3238: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3240: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3241: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3242: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3243: END IF;
3244: END IF;
3277: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;
3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3283: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3284: 'special Ctx SQLS details..' ||
3285: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3278: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3279: l_err_loc := 1800;
3280: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3283: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3284: 'special Ctx SQLS details..' ||
3285: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3286: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3298: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;
3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3304: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3305: 'special Ctx SQLS, Mandatory Row details..' ||
3306: '; Num. of rows in dtls plsql table:' || gDMDInventoryItemIdTbl.COUNT ||
3299: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3300: l_err_loc := 1900;
3301: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3304: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3305: 'special Ctx SQLS, Mandatory Row details..' ||
3306: '; Num. of rows in dtls plsql table:' || gDMDInventoryItemIdTbl.COUNT ||
3307: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3319: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;
3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3324: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3325: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3326: 'special Ctx SQLS, Supplier Row details..' ||
3327: '; Num. of rows in dtls plsql table:' || gDSDInventoryItemIdTbl.COUNT ||
3320: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3321: l_err_loc := 2000;
3322: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3323: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3324: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3325: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3326: 'special Ctx SQLS, Supplier Row details..' ||
3327: '; Num. of rows in dtls plsql table:' || gDSDInventoryItemIdTbl.COUNT ||
3328: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3341: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;
3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3348: 'special Ctx SQLS, Item Number details..' ||
3349: '; Num. of rows in dtls plsql table:' || gDBLDInventoryItemIdTbl.COUNT ||
3342: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3343: l_err_loc := 2020;
3344: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3348: 'special Ctx SQLS, Item Number details..' ||
3349: '; Num. of rows in dtls plsql table:' || gDBLDInventoryItemIdTbl.COUNT ||
3350: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3362: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;
3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3366: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3367: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3368: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3369: 'special Ctx SQLS, ItemRev Row details..' ||
3370: '; Num. of rows in dtls plsql table:' || gDIRDInventoryItemIdTbl.COUNT ||
3363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3364: l_err_loc := 2100;
3365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3366: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3367: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3368: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3369: 'special Ctx SQLS, ItemRev Row details..' ||
3370: '; Num. of rows in dtls plsql table:' || gDIRDInventoryItemIdTbl.COUNT ||
3371: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3383: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;
3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3387: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3389: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3390: 'special Ctx SQLS, ShopCatg Row details..' ||
3391: '; Num. of rows in dtls plsql table:' || gDSCDInventoryItemIdTbl.COUNT ||
3384: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3385: l_err_loc := 2200;
3386: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3387: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3389: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3390: 'special Ctx SQLS, ShopCatg Row details..' ||
3391: '; Num. of rows in dtls plsql table:' || gDSCDInventoryItemIdTbl.COUNT ||
3392: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3436: AND language = gIDLanguageTbl(i)
3437: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3438:
3439: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3440: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3443: 'Num. of rows inserted into ctx_dtls for GBPA with seq between 2 - 5000 row:' ||SQL%ROWCOUNT);
3444: END IF;
3437: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3438:
3439: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3440: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3443: 'Num. of rows inserted into ctx_dtls for GBPA with seq between 2 - 5000 row:' ||SQL%ROWCOUNT);
3444: END IF;
3445: END IF;
3477: sequence =3);
3478:
3479: l_err_loc := 2600;
3480: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3482: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3483: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3484: 'Num. of rows inserted into ctx_dtls for 101 - 5000 row:' ||SQL%ROWCOUNT);
3485: END IF;
3478:
3479: l_err_loc := 2600;
3480: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3482: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3483: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3484: 'Num. of rows inserted into ctx_dtls for 101 - 5000 row:' ||SQL%ROWCOUNT);
3485: END IF;
3486: END IF;
3515: AND language = gDSDLanguageTbl(i)
3516: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3517:
3518: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3519: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3521: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3522: 'Num. of rows inserted into ctx_dtls for seq 2 row:' ||SQL%ROWCOUNT);
3523: END IF;
3516: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3517:
3518: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3519: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3521: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3522: 'Num. of rows inserted into ctx_dtls for seq 2 row:' ||SQL%ROWCOUNT);
3523: END IF;
3524: END IF;
3555: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
3556:
3557: l_err_loc := 2800;
3558: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3559: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3560: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3561: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3562: 'Num. of rows inserted into ctx_dtls for seq 5 row:' ||SQL%ROWCOUNT);
3563: END IF;
3556:
3557: l_err_loc := 2800;
3558: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3559: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3560: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3561: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3562: 'Num. of rows inserted into ctx_dtls for seq 5 row:' ||SQL%ROWCOUNT);
3563: END IF;
3564: END IF;
3594: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
3595:
3596: l_err_loc := 2900;
3597: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3598: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3599: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3600: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3601: 'Num. of rows inserted into ctx_dtls for seq 6 row:' ||SQL%ROWCOUNT);
3602: END IF;
3595:
3596: l_err_loc := 2900;
3597: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3598: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3599: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3600: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3601: 'Num. of rows inserted into ctx_dtls for seq 6 row:' ||SQL%ROWCOUNT);
3602: END IF;
3603: END IF;
3621: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;
3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3627: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3628: 'regular Ctx SQLS details..' ||
3629: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3622: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3623: l_err_loc := 3500;
3624: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3627: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3628: 'regular Ctx SQLS details..' ||
3629: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3630: ', for seq:' || l_ctx_sqlstring_rec.bind_sequence ||
3643: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;
3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3647: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3649: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3650: 'regular Ctx SQLS details..' ||
3651: '; Num. of rows in dtls plsql table:' || gDBLDInventoryItemIdTbl.COUNT ||
3644: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3645: l_err_loc := 3800;
3646: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3647: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3649: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3650: 'regular Ctx SQLS details..' ||
3651: '; Num. of rows in dtls plsql table:' || gDBLDInventoryItemIdTbl.COUNT ||
3652: ', for seq:' || l_ctx_sqlstring_rec.bind_sequence ||
3664:
3665: l_err_loc := 4100;
3666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3667: COMMIT;
3668: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3669: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3671: 'Commit done.');
3672: END IF;
3665: l_err_loc := 4100;
3666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3667: COMMIT;
3668: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3669: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3671: 'Commit done.');
3672: END IF;
3673: ELSE
3670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3671: 'Commit done.');
3672: END IF;
3673: ELSE
3674: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3676: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3677: 'Commit not done.');
3678: END IF;
3671: 'Commit done.');
3672: END IF;
3673: ELSE
3674: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3676: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3677: 'Commit not done.');
3678: END IF;
3679: END IF;
3682: END IF; -- (p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size)
3683: l_err_loc := 4300;
3684: EXCEPTION
3685: WHEN OTHERS THEN
3686: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
3687: ICX_CAT_UTIL_PVT.logUnexpectedException(
3688: G_PKG_NAME, l_api_name,
3689: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
3690: RAISE;
3746: l_row_count := SQL%ROWCOUNT;
3747: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3748: l_err_loc := 900;
3749: l_continue := FALSE;
3750: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3751: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3752: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3753: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3754: END IF;
3747: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3748: l_err_loc := 900;
3749: l_continue := FALSE;
3750: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3751: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3752: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3753: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3754: END IF;
3755: END IF;
3775: AND hdrs.org_id = dtls.org_id
3776: AND hdrs.language = dtls.language
3777: AND hdrs.rowid = l_rowid_tbl(i) );
3778:
3779: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3780: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3781: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3782: 'Num of rows updated in ctx_dtls for supplier name change:' ||SQL%ROWCOUNT);
3783: END IF;
3776: AND hdrs.language = dtls.language
3777: AND hdrs.rowid = l_rowid_tbl(i) );
3778:
3779: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3780: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3781: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3782: 'Num of rows updated in ctx_dtls for supplier name change:' ||SQL%ROWCOUNT);
3783: END IF;
3784:
3785: l_err_loc := 1100;
3786: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3787: l_err_loc := 1200;
3788: COMMIT;
3789: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3791: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3792: 'Commit done.');
3793: END IF;
3786: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3787: l_err_loc := 1200;
3788: COMMIT;
3789: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3791: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3792: 'Commit done.');
3793: END IF;
3794: ELSE
3791: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3792: 'Commit done.');
3793: END IF;
3794: ELSE
3795: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3796: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3797: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3798: 'Commit not done.');
3799: END IF;
3792: 'Commit done.');
3793: END IF;
3794: ELSE
3795: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3796: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3797: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3798: 'Commit not done.');
3799: END IF;
3800: END IF;
3804: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3805: l_err_loc := 1400;
3806: -- Call the rebuild index
3807: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
3808: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3809: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3810: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3811: 'Rebuild indexes called.');
3812: END IF;
3805: l_err_loc := 1400;
3806: -- Call the rebuild index
3807: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
3808: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3809: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3810: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3811: 'Rebuild indexes called.');
3812: END IF;
3813: END IF;
3839: l_row_count := SQL%ROWCOUNT;
3840: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3841: l_err_loc := 1800;
3842: l_continue := FALSE;
3843: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3844: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3845: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3846: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3847: END IF;
3840: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3841: l_err_loc := 1800;
3842: l_continue := FALSE;
3843: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3844: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3845: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3846: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3847: END IF;
3848: END IF;
3850: l_err_loc := 1900;
3851: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3852: l_err_loc := 2000;
3853: COMMIT;
3854: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3855: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3856: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3857: 'Commit done.');
3858: END IF;
3851: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3852: l_err_loc := 2000;
3853: COMMIT;
3854: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3855: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3856: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3857: 'Commit done.');
3858: END IF;
3859: ELSE
3856: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3857: 'Commit done.');
3858: END IF;
3859: ELSE
3860: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3861: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3862: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3863: 'Commit not done.');
3864: END IF;
3857: 'Commit done.');
3858: END IF;
3859: ELSE
3860: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3861: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3862: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3863: 'Commit not done.');
3864: END IF;
3865: END IF;
3865: END IF;
3866: END LOOP;
3867:
3868: l_err_loc := 2100;
3869: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3870: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3871: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3872: 'Only update the supplier name on the header; Supplier is not searchable l_searchable:' || l_searchable );
3873: END IF;
3866: END LOOP;
3867:
3868: l_err_loc := 2100;
3869: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3870: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3871: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3872: 'Only update the supplier name on the header; Supplier is not searchable l_searchable:' || l_searchable );
3873: END IF;
3874: END IF; -- IF (l_searchable = 1) THEN
3931: FROM po_vendors
3932: WHERE vendor_id = p_to_vendor_id;
3933:
3934: l_err_loc := 500;
3935: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3936: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3937: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3938: 'l_to_vendor_name:' || l_to_vendor_name);
3939: END IF;
3932: WHERE vendor_id = p_to_vendor_id;
3933:
3934: l_err_loc := 500;
3935: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3936: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3937: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3938: 'l_to_vendor_name:' || l_to_vendor_name);
3939: END IF;
3940:
3972: l_row_count := SQL%ROWCOUNT;
3973: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3974: l_err_loc := 1100;
3975: l_continue := FALSE;
3976: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3977: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3978: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3979: 'Num of rows updated in ctx_hdrs for vendor merge:' || l_row_count);
3980: END IF;
3973: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3974: l_err_loc := 1100;
3975: l_continue := FALSE;
3976: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3977: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3978: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3979: 'Num of rows updated in ctx_hdrs for vendor merge:' || l_row_count);
3980: END IF;
3981: END IF;
3996: AND hdrs.org_id = dtls.org_id
3997: AND hdrs.language = dtls.language
3998: AND hdrs.rowid = l_rowid_tbl(i) );
3999:
4000: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4001: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4002: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4003: 'Num. of rows deleted from dtls for seq=1:' || SQL%ROWCOUNT);
4004: END IF;
3997: AND hdrs.language = dtls.language
3998: AND hdrs.rowid = l_rowid_tbl(i) );
3999:
4000: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4001: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4002: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4003: 'Num. of rows deleted from dtls for seq=1:' || SQL%ROWCOUNT);
4004: END IF;
4005:
4006: l_err_loc := 1400;
4007:
4008: IF (NOT l_metadataTblFormed) THEN
4009: l_err_loc := 1500;
4010: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4011: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4012: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4013: 'populateVendorMerge: about to call buildMetaDataInfo and buildCtxSql');
4014: END IF;
4007:
4008: IF (NOT l_metadataTblFormed) THEN
4009: l_err_loc := 1500;
4010: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4011: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4012: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4013: 'populateVendorMerge: about to call buildMetaDataInfo and buildCtxSql');
4014: END IF;
4015:
4038: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4039: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4040: l_err_loc := 2000;
4041: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4042: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4044: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4045: 'Num. of rows inserted into dtls for seq=1:' || l_status);
4046: END IF;
4039: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4040: l_err_loc := 2000;
4041: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4042: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4044: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4045: 'Num. of rows inserted into dtls for seq=1:' || l_status);
4046: END IF;
4047:
4048: l_err_loc := 2100;
4049:
4050: IF (l_searchable IS NULL) THEN
4051: l_err_loc := 2200;
4052: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4053: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4054: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4055: 'about to call the getAttributeDetails for supplier');
4056: END IF;
4049:
4050: IF (l_searchable IS NULL) THEN
4051: l_err_loc := 2200;
4052: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4053: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4054: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4055: 'about to call the getAttributeDetails for supplier');
4056: END IF;
4057:
4085: AND hdrs.language = dtls.language
4086: AND hdrs.rowid = l_rowid_tbl(i) );
4087: ELSE
4088: l_err_loc := 2500;
4089: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4091: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4092: 'Supplier is not searchable l_searchable:' || l_searchable );
4093: END IF;
4086: AND hdrs.rowid = l_rowid_tbl(i) );
4087: ELSE
4088: l_err_loc := 2500;
4089: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4091: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4092: 'Supplier is not searchable l_searchable:' || l_searchable );
4093: END IF;
4094: END IF;
4096: l_err_loc := 2600;
4097: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4098: l_err_loc := 2700;
4099: COMMIT;
4100: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4102: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4103: 'Commit done.');
4104: END IF;
4097: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4098: l_err_loc := 2700;
4099: COMMIT;
4100: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4102: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4103: 'Commit done.');
4104: END IF;
4105: ELSE
4102: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4103: 'Commit done.');
4104: END IF;
4105: ELSE
4106: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4107: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4108: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4109: 'Commit not done.');
4110: END IF;
4103: 'Commit done.');
4104: END IF;
4105: ELSE
4106: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4107: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4108: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4109: 'Commit not done.');
4110: END IF;
4111: END IF;
4115: l_err_loc := 2800;
4116:
4117: -- close the cursor for the dynamic sql to insert the
4118: -- row with sequence 1 in icx_cat_items_ctx_dtls_tlp only once
4119: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4121: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4122: 'the dynamic sql is closed');
4123: END IF;
4116:
4117: -- close the cursor for the dynamic sql to insert the
4118: -- row with sequence 1 in icx_cat_items_ctx_dtls_tlp only once
4119: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4121: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4122: 'the dynamic sql is closed');
4123: END IF;
4124: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
4129: -- Call the rebuild index
4130: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4131:
4132: l_err_loc := 3100;
4133: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4135: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4136: 'Commit done.');
4137: END IF;
4130: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4131:
4132: l_err_loc := 3100;
4133: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4135: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4136: 'Commit done.');
4137: END IF;
4138: END IF;
4152: l_api_name CONSTANT VARCHAR2(30) := 'openInvalidCategoryCsr';
4153: l_err_loc PLS_INTEGER;
4154: BEGIN
4155: l_err_loc := 100;
4156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4158: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4159: 'Processing cursor:' || l_api_name ||
4160: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
4153: l_err_loc PLS_INTEGER;
4154: BEGIN
4155: l_err_loc := 100;
4156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4158: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4159: 'Processing cursor:' || l_api_name ||
4160: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
4161: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
4230: BEGIN
4231: l_err_loc := 100;
4232: l_start_date := sysdate;
4233:
4234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4235: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4236: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4237: END IF;
4238:
4281:
4282: l_err_loc := 900;
4283: l_row_count := SQL%ROWCOUNT;
4284: IF (l_row_count = 0) THEN
4285: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4286: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4287: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4288: 'No rows deleted from ctx_hdrs for invalid category, so exit out of the loop;');
4289: END IF;
4282: l_err_loc := 900;
4283: l_row_count := SQL%ROWCOUNT;
4284: IF (l_row_count = 0) THEN
4285: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4286: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4287: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4288: 'No rows deleted from ctx_hdrs for invalid category, so exit out of the loop;');
4289: END IF;
4290: EXIT;
4289: END IF;
4290: EXIT;
4291: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4292: l_continue := FALSE;
4293: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4294: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4295: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4296: 'Num. of rows deleted from ctx_hdrs for invalid category:' || l_row_count);
4297: END IF;
4290: EXIT;
4291: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4292: l_continue := FALSE;
4293: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4294: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4295: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4296: 'Num. of rows deleted from ctx_hdrs for invalid category:' || l_row_count);
4297: END IF;
4298: END IF;
4310: l_err_loc := 1100;
4311: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4312: l_err_loc := 1200;
4313: COMMIT;
4314: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4315: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4316: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4317: 'Commit done inside the while loop.');
4318: END IF;
4311: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4312: l_err_loc := 1200;
4313: COMMIT;
4314: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4315: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4316: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4317: 'Commit done inside the while loop.');
4318: END IF;
4319: ELSE
4317: 'Commit done inside the while loop.');
4318: END IF;
4319: ELSE
4320: l_err_loc := 1300;
4321: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4323: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4324: 'Commit not done inside the while loop.');
4325: END IF;
4318: END IF;
4319: ELSE
4320: l_err_loc := 1300;
4321: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4323: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4324: 'Commit not done inside the while loop.');
4325: END IF;
4326: END IF;
4336:
4337: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4338: l_err_loc := 1600;
4339: COMMIT;
4340: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4341: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4342: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4343: 'Commit done inside the fetch loop.');
4344: END IF;
4337: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4338: l_err_loc := 1600;
4339: COMMIT;
4340: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4341: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4342: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4343: 'Commit done inside the fetch loop.');
4344: END IF;
4345: ELSE
4343: 'Commit done inside the fetch loop.');
4344: END IF;
4345: ELSE
4346: l_err_loc := 1700;
4347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4348: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4349: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4350: 'Commit not done inside the fetch loop.');
4351: END IF;
4344: END IF;
4345: ELSE
4346: l_err_loc := 1700;
4347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4348: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4349: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4350: 'Commit not done inside the fetch loop.');
4351: END IF;
4352: END IF;
4363: END LOOP;
4364:
4365: l_err_loc := 1800;
4366: l_end_date := sysdate;
4367: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4368: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4369: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4370: END IF;
4371: EXCEPTION
4400: BEGIN
4401: l_err_loc := 100;
4402: l_start_date := sysdate;
4403:
4404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4405: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4406: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4407: END IF;
4408:
4463:
4464: l_err_loc := 400;
4465: l_row_count := SQL%ROWCOUNT;
4466: IF (l_row_count = 0) THEN
4467: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4468: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4469: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4470: 'no rows deleted from ctx_hdrs for invalid req tmplts, so exit from the loop');
4471: END IF;
4464: l_err_loc := 400;
4465: l_row_count := SQL%ROWCOUNT;
4466: IF (l_row_count = 0) THEN
4467: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4468: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4469: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4470: 'no rows deleted from ctx_hdrs for invalid req tmplts, so exit from the loop');
4471: END IF;
4472: EXIT;
4471: END IF;
4472: EXIT;
4473: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4474: l_continue := FALSE;
4475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4477: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4478: 'Num. of rows deleted from ctx_hdrs for invalid req templates:' || l_row_count);
4479: END IF;
4472: EXIT;
4473: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4474: l_continue := FALSE;
4475: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4476: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4477: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4478: 'Num. of rows deleted from ctx_hdrs for invalid req templates:' || l_row_count);
4479: END IF;
4480: END IF;
4492: l_err_loc := 600;
4493: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4494: l_err_loc := 700;
4495: COMMIT;
4496: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4497: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4498: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4499: 'Commit done.');
4500: END IF;
4493: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4494: l_err_loc := 700;
4495: COMMIT;
4496: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4497: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4498: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4499: 'Commit done.');
4500: END IF;
4501: ELSE
4499: 'Commit done.');
4500: END IF;
4501: ELSE
4502: l_err_loc := 800;
4503: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4504: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4505: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4506: 'Commit not done.');
4507: END IF;
4500: END IF;
4501: ELSE
4502: l_err_loc := 800;
4503: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4504: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4505: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4506: 'Commit not done.');
4507: END IF;
4508: END IF;
4509: END LOOP;
4510:
4511: l_err_loc := 900;
4512: l_end_date := sysdate;
4513: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4514: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4515: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4516: END IF;
4517:
4548: BEGIN
4549: l_err_loc := 100;
4550: l_start_date := sysdate;
4551:
4552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4553: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4554: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4555: END IF;
4556:
4584:
4585: l_err_loc := 400;
4586: l_row_count := SQL%ROWCOUNT;
4587: IF (l_row_count = 0) THEN
4588: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4589: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4590: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4591: 'no rows deleted from ctx_hdrs for invalid Quote lines, so exit from the loop');
4592: END IF;
4585: l_err_loc := 400;
4586: l_row_count := SQL%ROWCOUNT;
4587: IF (l_row_count = 0) THEN
4588: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4589: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4590: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4591: 'no rows deleted from ctx_hdrs for invalid Quote lines, so exit from the loop');
4592: END IF;
4593: EXIT;
4592: END IF;
4593: EXIT;
4594: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4595: l_continue := FALSE;
4596: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4598: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4599: 'Num. of rows deleted from ctx_hdrs for invalid Quote lines:' || l_row_count);
4600: END IF;
4593: EXIT;
4594: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4595: l_continue := FALSE;
4596: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4598: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4599: 'Num. of rows deleted from ctx_hdrs for invalid Quote lines:' || l_row_count);
4600: END IF;
4601: END IF;
4613: l_err_loc := 600;
4614: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4615: l_err_loc := 700;
4616: COMMIT;
4617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4620: 'Commit done.');
4621: END IF;
4614: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4615: l_err_loc := 700;
4616: COMMIT;
4617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4620: 'Commit done.');
4621: END IF;
4622: ELSE
4620: 'Commit done.');
4621: END IF;
4622: ELSE
4623: l_err_loc := 800;
4624: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4625: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4626: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4627: 'Commit not done.');
4628: END IF;
4621: END IF;
4622: ELSE
4623: l_err_loc := 800;
4624: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4625: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4626: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4627: 'Commit not done.');
4628: END IF;
4629: END IF;
4630: END LOOP;
4631:
4632: l_err_loc := 900;
4633: l_end_date := sysdate;
4634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4635: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4636: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4637: END IF;
4638:
4678: l_row_count PLS_INTEGER;
4679: BEGIN
4680: l_err_loc := 100;
4681: l_start_date := sysdate;
4682: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4683: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4684: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4685: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
4686: END IF;
4679: BEGIN
4680: l_err_loc := 100;
4681: l_start_date := sysdate;
4682: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4683: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4684: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4685: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
4686: END IF;
4687:
4719:
4720: l_err_loc := 400;
4721: l_row_count := SQL%ROWCOUNT;
4722: IF (l_row_count = 0) THEN
4723: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4724: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4725: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4726: 'no rows deleted from ctx_hdrs for invalid blanket lines, so exit from the loop');
4727: END IF;
4720: l_err_loc := 400;
4721: l_row_count := SQL%ROWCOUNT;
4722: IF (l_row_count = 0) THEN
4723: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4724: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4725: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4726: 'no rows deleted from ctx_hdrs for invalid blanket lines, so exit from the loop');
4727: END IF;
4728: EXIT;
4727: END IF;
4728: EXIT;
4729: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4730: l_continue := FALSE;
4731: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4732: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4733: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4734: 'Num. of rows deleted from ctx_hdrs for invalid blanket lines:' || l_row_count);
4735: END IF;
4728: EXIT;
4729: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4730: l_continue := FALSE;
4731: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4732: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4733: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4734: 'Num. of rows deleted from ctx_hdrs for invalid blanket lines:' || l_row_count);
4735: END IF;
4736: END IF;
4748: l_err_loc := 600;
4749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4750: l_err_loc := 700;
4751: COMMIT;
4752: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4753: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4755: 'Commit done.');
4756: END IF;
4749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4750: l_err_loc := 700;
4751: COMMIT;
4752: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4753: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4755: 'Commit done.');
4756: END IF;
4757: ELSE
4755: 'Commit done.');
4756: END IF;
4757: ELSE
4758: l_err_loc := 800;
4759: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4760: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4761: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4762: 'Commit not done.');
4763: END IF;
4756: END IF;
4757: ELSE
4758: l_err_loc := 800;
4759: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4760: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4761: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4762: 'Commit not done.');
4763: END IF;
4764: END IF;
4765: END LOOP;
4766:
4767: l_err_loc := 900;
4768: l_end_date := sysdate;
4769: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4772: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4773: END IF;
4766:
4767: l_err_loc := 900;
4768: l_end_date := sysdate;
4769: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4772: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4773: END IF;
4774:
4798:
4799: l_err_loc := 150;
4800: l_start_date := sysdate;
4801:
4802: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4803: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4804: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4805: END IF;
4806:
4827: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4828: l_err_loc := 900;
4829: -- Call the rebuild index
4830: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4831: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4832: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4833: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4834: 'Rebuild indexes called.');
4835: END IF;
4828: l_err_loc := 900;
4829: -- Call the rebuild index
4830: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4831: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4832: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4833: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4834: 'Rebuild indexes called.');
4835: END IF;
4836: END IF;
4836: END IF;
4837:
4838: l_err_loc := 1000;
4839: l_end_date := sysdate;
4840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4841: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4842: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4843: END IF;
4844: EXCEPTION
4870:
4871: l_err_loc := 200;
4872: l_start_date := sysdate;
4873:
4874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4875: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4876: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4877: END IF;
4878:
4881: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4882:
4883: l_err_loc := 400;
4884: l_end_date := sysdate;
4885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4886: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4887: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4888: END IF;
4889: EXCEPTION