[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;
3104: AND language = gDBLDLanguageTbl(i)
3105: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3106:
3107: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3110: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3111: 'Num. of rows deleted from ctx_dtls for base and local row changes:' ||SQL%ROWCOUNT);
3112: END IF;
3105: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3106:
3107: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3110: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3111: 'Num. of rows deleted from ctx_dtls for base and local row changes:' ||SQL%ROWCOUNT);
3112: END IF;
3113: END IF;
3177: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3178: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3179:
3180: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3181: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3182: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3183: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3184: 'Num. of rows inserted into ctx_dtls for org row:' ||SQL%ROWCOUNT);
3185: END IF;
3178: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3179:
3180: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3181: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3182: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3183: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3184: 'Num. of rows inserted into ctx_dtls for org row:' ||SQL%ROWCOUNT);
3185: END IF;
3186: END IF;
3205: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3206: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3207:
3208: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3210: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3211: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3212: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3213: END IF;
3206: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3207:
3208: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3210: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3211: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3212: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3213: END IF;
3214: END IF;
3234: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3235: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3236:
3237: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3238: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3240: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3241: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3242: END IF;
3235: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3236:
3237: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3238: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3240: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3241: 'Num. of rows inserted into ctx_dtls for purch_org row:' ||SQL%ROWCOUNT);
3242: END IF;
3243: END IF;
3275: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3277: l_err_loc := 1800;
3278: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3280: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3281: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3282: 'special Ctx SQLS details..' ||
3283: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3276: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3277: l_err_loc := 1800;
3278: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3280: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3281: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3282: 'special Ctx SQLS details..' ||
3283: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3284: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3296: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDMDOrgIdTbl);
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3298: l_err_loc := 1900;
3299: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3300: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3302: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3303: 'special Ctx SQLS, Mandatory Row details..' ||
3304: '; Num. of rows in dtls plsql table:' || gDMDInventoryItemIdTbl.COUNT ||
3297: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDMDLanguageTbl);
3298: l_err_loc := 1900;
3299: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3300: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3302: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3303: 'special Ctx SQLS, Mandatory Row details..' ||
3304: '; Num. of rows in dtls plsql table:' || gDMDInventoryItemIdTbl.COUNT ||
3305: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3317: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSDOrgIdTbl);
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3319: l_err_loc := 2000;
3320: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3321: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3322: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3323: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3324: 'special Ctx SQLS, Supplier Row details..' ||
3325: '; Num. of rows in dtls plsql table:' || gDSDInventoryItemIdTbl.COUNT ||
3318: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSDLanguageTbl);
3319: l_err_loc := 2000;
3320: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3321: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3322: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3323: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3324: 'special Ctx SQLS, Supplier Row details..' ||
3325: '; Num. of rows in dtls plsql table:' || gDSDInventoryItemIdTbl.COUNT ||
3326: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3338: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDIRDOrgIdTbl);
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;
3341: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3342: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3343: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3344: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3345: 'special Ctx SQLS, ItemRev Row details..' ||
3346: '; Num. of rows in dtls plsql table:' || gDIRDInventoryItemIdTbl.COUNT ||
3339: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDIRDLanguageTbl);
3340: l_err_loc := 2100;
3341: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3342: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3343: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3344: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3345: 'special Ctx SQLS, ItemRev Row details..' ||
3346: '; Num. of rows in dtls plsql table:' || gDIRDInventoryItemIdTbl.COUNT ||
3347: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3359: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDSCDOrgIdTbl);
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;
3362: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3365: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3366: 'special Ctx SQLS, ShopCatg Row details..' ||
3367: '; Num. of rows in dtls plsql table:' || gDSCDInventoryItemIdTbl.COUNT ||
3360: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDSCDLanguageTbl);
3361: l_err_loc := 2200;
3362: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3365: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3366: 'special Ctx SQLS, ShopCatg Row details..' ||
3367: '; Num. of rows in dtls plsql table:' || gDSCDInventoryItemIdTbl.COUNT ||
3368: ', for seq:' || l_sequence || ', Num. of rows inserted into dtls:' || l_status);
3412: AND language = gIDLanguageTbl(i)
3413: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3414:
3415: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3416: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3417: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3418: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3419: 'Num. of rows inserted into ctx_dtls for GBPA with seq between 2 - 5000 row:' ||SQL%ROWCOUNT);
3420: END IF;
3413: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3414:
3415: IF (gIDInventoryItemIdTbl.COUNT > 0) THEN
3416: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3417: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3418: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3419: 'Num. of rows inserted into ctx_dtls for GBPA with seq between 2 - 5000 row:' ||SQL%ROWCOUNT);
3420: END IF;
3421: END IF;
3452: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
3453:
3454: l_err_loc := 2600;
3455: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3456: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3457: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3458: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3459: 'Num. of rows inserted into ctx_dtls for 101 - 5000 row:' ||SQL%ROWCOUNT);
3460: END IF;
3453:
3454: l_err_loc := 2600;
3455: IF (gDBLDInventoryItemIdTbl.COUNT > 0) THEN
3456: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3457: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3458: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3459: 'Num. of rows inserted into ctx_dtls for 101 - 5000 row:' ||SQL%ROWCOUNT);
3460: END IF;
3461: END IF;
3490: AND language = gDSDLanguageTbl(i)
3491: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3492:
3493: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3494: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3495: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3496: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3497: 'Num. of rows inserted into ctx_dtls for seq 2 row:' ||SQL%ROWCOUNT);
3498: END IF;
3491: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3492:
3493: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3494: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3495: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3496: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3497: 'Num. of rows inserted into ctx_dtls for seq 2 row:' ||SQL%ROWCOUNT);
3498: END IF;
3499: END IF;
3530: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
3531:
3532: l_err_loc := 2800;
3533: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3536: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3537: 'Num. of rows inserted into ctx_dtls for seq 5 row:' ||SQL%ROWCOUNT);
3538: END IF;
3531:
3532: l_err_loc := 2800;
3533: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3536: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3537: 'Num. of rows inserted into ctx_dtls for seq 5 row:' ||SQL%ROWCOUNT);
3538: END IF;
3539: END IF;
3569: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
3570:
3571: l_err_loc := 2900;
3572: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3573: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3575: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3576: 'Num. of rows inserted into ctx_dtls for seq 6 row:' ||SQL%ROWCOUNT);
3577: END IF;
3570:
3571: l_err_loc := 2900;
3572: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3573: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3575: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3576: 'Num. of rows inserted into ctx_dtls for seq 6 row:' ||SQL%ROWCOUNT);
3577: END IF;
3578: END IF;
3596: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gIDOrgIdTbl);
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;
3599: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3602: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3603: 'regular Ctx SQLS details..' ||
3604: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3597: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gIDLanguageTbl);
3598: l_err_loc := 3500;
3599: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3600: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3602: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3603: 'regular Ctx SQLS details..' ||
3604: '; Num. of rows in dtls plsql table:' || gIDInventoryItemIdTbl.COUNT ||
3605: ', for seq:' || l_ctx_sqlstring_rec.bind_sequence ||
3618: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_ORG_ID', gDBLDOrgIdTbl);
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;
3621: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3625: 'regular Ctx SQLS details..' ||
3626: '; Num. of rows in dtls plsql table:' || gDBLDInventoryItemIdTbl.COUNT ||
3619: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_LANGUAGE', gDBLDLanguageTbl);
3620: l_err_loc := 3800;
3621: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
3622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3625: 'regular Ctx SQLS details..' ||
3626: '; Num. of rows in dtls plsql table:' || gDBLDInventoryItemIdTbl.COUNT ||
3627: ', for seq:' || l_ctx_sqlstring_rec.bind_sequence ||
3639:
3640: l_err_loc := 4100;
3641: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3642: COMMIT;
3643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3644: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3645: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3646: 'Commit done.');
3647: END IF;
3640: l_err_loc := 4100;
3641: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3642: COMMIT;
3643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3644: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3645: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3646: 'Commit done.');
3647: END IF;
3648: ELSE
3645: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3646: 'Commit done.');
3647: END IF;
3648: ELSE
3649: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3650: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3651: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3652: 'Commit not done.');
3653: END IF;
3646: 'Commit done.');
3647: END IF;
3648: ELSE
3649: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3650: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3651: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3652: 'Commit not done.');
3653: END IF;
3654: END IF;
3657: END IF; -- (p_mode = 'OUTLOOP' OR gTotalRowCount >= ICX_CAT_UTIL_PVT.g_batch_size)
3658: l_err_loc := 4300;
3659: EXCEPTION
3660: WHEN OTHERS THEN
3661: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
3662: ICX_CAT_UTIL_PVT.logUnexpectedException(
3663: G_PKG_NAME, l_api_name,
3664: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
3665: RAISE;
3721: l_row_count := SQL%ROWCOUNT;
3722: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3723: l_err_loc := 900;
3724: l_continue := FALSE;
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3726: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3727: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3728: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3729: END IF;
3722: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3723: l_err_loc := 900;
3724: l_continue := FALSE;
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3726: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3727: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3728: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3729: END IF;
3730: END IF;
3750: AND hdrs.org_id = dtls.org_id
3751: AND hdrs.language = dtls.language
3752: AND hdrs.rowid = l_rowid_tbl(i) );
3753:
3754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3755: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3756: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3757: 'Num of rows updated in ctx_dtls for supplier name change:' ||SQL%ROWCOUNT);
3758: END IF;
3751: AND hdrs.language = dtls.language
3752: AND hdrs.rowid = l_rowid_tbl(i) );
3753:
3754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3755: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3756: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3757: 'Num of rows updated in ctx_dtls for supplier name change:' ||SQL%ROWCOUNT);
3758: END IF;
3759:
3760: l_err_loc := 1100;
3761: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3762: l_err_loc := 1200;
3763: COMMIT;
3764: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3766: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3767: 'Commit done.');
3768: END IF;
3761: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3762: l_err_loc := 1200;
3763: COMMIT;
3764: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3766: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3767: 'Commit done.');
3768: END IF;
3769: ELSE
3766: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3767: 'Commit done.');
3768: END IF;
3769: ELSE
3770: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3771: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3772: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3773: 'Commit not done.');
3774: END IF;
3767: 'Commit done.');
3768: END IF;
3769: ELSE
3770: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3771: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3772: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3773: 'Commit not done.');
3774: END IF;
3775: END IF;
3779: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3780: l_err_loc := 1400;
3781: -- Call the rebuild index
3782: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
3783: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3784: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3785: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3786: 'Rebuild indexes called.');
3787: END IF;
3780: l_err_loc := 1400;
3781: -- Call the rebuild index
3782: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
3783: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3784: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3785: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3786: 'Rebuild indexes called.');
3787: END IF;
3788: END IF;
3814: l_row_count := SQL%ROWCOUNT;
3815: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3816: l_err_loc := 1800;
3817: l_continue := FALSE;
3818: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3819: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3820: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3821: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3822: END IF;
3815: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3816: l_err_loc := 1800;
3817: l_continue := FALSE;
3818: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3819: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3820: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3821: 'Num of rows updated in ctx_hdrs for supplier name change:' || l_row_count);
3822: END IF;
3823: END IF;
3825: l_err_loc := 1900;
3826: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3827: l_err_loc := 2000;
3828: COMMIT;
3829: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3830: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3831: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3832: 'Commit done.');
3833: END IF;
3826: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
3827: l_err_loc := 2000;
3828: COMMIT;
3829: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3830: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3831: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3832: 'Commit done.');
3833: END IF;
3834: ELSE
3831: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3832: 'Commit done.');
3833: END IF;
3834: ELSE
3835: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3836: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3837: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3838: 'Commit not done.');
3839: END IF;
3832: 'Commit done.');
3833: END IF;
3834: ELSE
3835: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3836: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3837: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3838: 'Commit not done.');
3839: END IF;
3840: END IF;
3840: END IF;
3841: END LOOP;
3842:
3843: l_err_loc := 2100;
3844: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3845: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3846: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3847: 'Only update the supplier name on the header; Supplier is not searchable l_searchable:' || l_searchable );
3848: END IF;
3841: END LOOP;
3842:
3843: l_err_loc := 2100;
3844: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3845: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3846: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3847: 'Only update the supplier name on the header; Supplier is not searchable l_searchable:' || l_searchable );
3848: END IF;
3849: END IF; -- IF (l_searchable = 1) THEN
3906: FROM po_vendors
3907: WHERE vendor_id = p_to_vendor_id;
3908:
3909: l_err_loc := 500;
3910: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3911: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3912: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3913: 'l_to_vendor_name:' || l_to_vendor_name);
3914: END IF;
3907: WHERE vendor_id = p_to_vendor_id;
3908:
3909: l_err_loc := 500;
3910: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3911: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3912: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3913: 'l_to_vendor_name:' || l_to_vendor_name);
3914: END IF;
3915:
3947: l_row_count := SQL%ROWCOUNT;
3948: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3949: l_err_loc := 1100;
3950: l_continue := FALSE;
3951: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3952: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3953: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3954: 'Num of rows updated in ctx_hdrs for vendor merge:' || l_row_count);
3955: END IF;
3948: IF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
3949: l_err_loc := 1100;
3950: l_continue := FALSE;
3951: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3952: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3953: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3954: 'Num of rows updated in ctx_hdrs for vendor merge:' || l_row_count);
3955: END IF;
3956: END IF;
3971: AND hdrs.org_id = dtls.org_id
3972: AND hdrs.language = dtls.language
3973: AND hdrs.rowid = l_rowid_tbl(i) );
3974:
3975: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3976: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3977: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3978: 'Num. of rows deleted from dtls for seq=1:' || SQL%ROWCOUNT);
3979: END IF;
3972: AND hdrs.language = dtls.language
3973: AND hdrs.rowid = l_rowid_tbl(i) );
3974:
3975: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3976: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3977: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3978: 'Num. of rows deleted from dtls for seq=1:' || SQL%ROWCOUNT);
3979: END IF;
3980:
3981: l_err_loc := 1400;
3982:
3983: IF (NOT l_metadataTblFormed) THEN
3984: l_err_loc := 1500;
3985: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3986: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3987: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3988: 'populateVendorMerge: about to call buildMetaDataInfo and buildCtxSql');
3989: END IF;
3982:
3983: IF (NOT l_metadataTblFormed) THEN
3984: l_err_loc := 1500;
3985: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3986: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3987: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3988: 'populateVendorMerge: about to call buildMetaDataInfo and buildCtxSql');
3989: END IF;
3990:
4013: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
4014: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4015: l_err_loc := 2000;
4016: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4017: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4018: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4019: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4020: 'Num. of rows inserted into dtls for seq=1:' || l_status);
4021: END IF;
4014: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
4015: l_err_loc := 2000;
4016: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
4017: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4018: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4019: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4020: 'Num. of rows inserted into dtls for seq=1:' || l_status);
4021: END IF;
4022:
4023: l_err_loc := 2100;
4024:
4025: IF (l_searchable IS NULL) THEN
4026: l_err_loc := 2200;
4027: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4028: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4029: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4030: 'about to call the getAttributeDetails for supplier');
4031: END IF;
4024:
4025: IF (l_searchable IS NULL) THEN
4026: l_err_loc := 2200;
4027: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4028: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4029: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4030: 'about to call the getAttributeDetails for supplier');
4031: END IF;
4032:
4060: AND hdrs.language = dtls.language
4061: AND hdrs.rowid = l_rowid_tbl(i) );
4062: ELSE
4063: l_err_loc := 2500;
4064: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4065: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4066: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4067: 'Supplier is not searchable l_searchable:' || l_searchable );
4068: END IF;
4061: AND hdrs.rowid = l_rowid_tbl(i) );
4062: ELSE
4063: l_err_loc := 2500;
4064: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4065: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4066: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4067: 'Supplier is not searchable l_searchable:' || l_searchable );
4068: END IF;
4069: END IF;
4071: l_err_loc := 2600;
4072: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4073: l_err_loc := 2700;
4074: COMMIT;
4075: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4076: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4077: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4078: 'Commit done.');
4079: END IF;
4072: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4073: l_err_loc := 2700;
4074: COMMIT;
4075: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4076: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4077: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4078: 'Commit done.');
4079: END IF;
4080: ELSE
4077: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4078: 'Commit done.');
4079: END IF;
4080: ELSE
4081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4082: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4083: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4084: 'Commit not done.');
4085: END IF;
4078: 'Commit done.');
4079: END IF;
4080: ELSE
4081: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4082: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4083: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4084: 'Commit not done.');
4085: END IF;
4086: END IF;
4090: l_err_loc := 2800;
4091:
4092: -- close the cursor for the dynamic sql to insert the
4093: -- row with sequence 1 in icx_cat_items_ctx_dtls_tlp only once
4094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4096: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4097: 'the dynamic sql is closed');
4098: END IF;
4091:
4092: -- close the cursor for the dynamic sql to insert the
4093: -- row with sequence 1 in icx_cat_items_ctx_dtls_tlp only once
4094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4096: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4097: 'the dynamic sql is closed');
4098: END IF;
4099: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
4104: -- Call the rebuild index
4105: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4106:
4107: l_err_loc := 3100;
4108: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4109: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4110: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4111: 'Commit done.');
4112: END IF;
4105: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4106:
4107: l_err_loc := 3100;
4108: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4109: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4110: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4111: 'Commit done.');
4112: END IF;
4113: END IF;
4127: l_api_name CONSTANT VARCHAR2(30) := 'openInvalidCategoryCsr';
4128: l_err_loc PLS_INTEGER;
4129: BEGIN
4130: l_err_loc := 100;
4131: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4132: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4133: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4134: 'Processing cursor:' || l_api_name ||
4135: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
4128: l_err_loc PLS_INTEGER;
4129: BEGIN
4130: l_err_loc := 100;
4131: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4132: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4133: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4134: 'Processing cursor:' || l_api_name ||
4135: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
4136: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
4205: BEGIN
4206: l_err_loc := 100;
4207: l_start_date := sysdate;
4208:
4209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4210: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4211: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4212: END IF;
4213:
4256:
4257: l_err_loc := 900;
4258: l_row_count := SQL%ROWCOUNT;
4259: IF (l_row_count = 0) THEN
4260: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4261: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4262: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4263: 'No rows deleted from ctx_hdrs for invalid category, so exit out of the loop;');
4264: END IF;
4257: l_err_loc := 900;
4258: l_row_count := SQL%ROWCOUNT;
4259: IF (l_row_count = 0) THEN
4260: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4261: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4262: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4263: 'No rows deleted from ctx_hdrs for invalid category, so exit out of the loop;');
4264: END IF;
4265: EXIT;
4264: END IF;
4265: EXIT;
4266: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4267: l_continue := FALSE;
4268: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4269: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4270: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4271: 'Num. of rows deleted from ctx_hdrs for invalid category:' || l_row_count);
4272: END IF;
4265: EXIT;
4266: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4267: l_continue := FALSE;
4268: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4269: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4270: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4271: 'Num. of rows deleted from ctx_hdrs for invalid category:' || l_row_count);
4272: END IF;
4273: END IF;
4285: l_err_loc := 1100;
4286: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4287: l_err_loc := 1200;
4288: COMMIT;
4289: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4290: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4291: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4292: 'Commit done inside the while loop.');
4293: END IF;
4286: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4287: l_err_loc := 1200;
4288: COMMIT;
4289: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4290: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4291: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4292: 'Commit done inside the while loop.');
4293: END IF;
4294: ELSE
4292: 'Commit done inside the while loop.');
4293: END IF;
4294: ELSE
4295: l_err_loc := 1300;
4296: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4297: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4298: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4299: 'Commit not done inside the while loop.');
4300: END IF;
4293: END IF;
4294: ELSE
4295: l_err_loc := 1300;
4296: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4297: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4298: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4299: 'Commit not done inside the while loop.');
4300: END IF;
4301: END IF;
4311:
4312: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4313: l_err_loc := 1600;
4314: COMMIT;
4315: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4316: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4317: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4318: 'Commit done inside the fetch loop.');
4319: END IF;
4312: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4313: l_err_loc := 1600;
4314: COMMIT;
4315: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4316: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4317: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4318: 'Commit done inside the fetch loop.');
4319: END IF;
4320: ELSE
4318: 'Commit done inside the fetch loop.');
4319: END IF;
4320: ELSE
4321: l_err_loc := 1700;
4322: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4323: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4324: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4325: 'Commit not done inside the fetch loop.');
4326: END IF;
4319: END IF;
4320: ELSE
4321: l_err_loc := 1700;
4322: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4323: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4324: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4325: 'Commit not done inside the fetch loop.');
4326: END IF;
4327: END IF;
4338: END LOOP;
4339:
4340: l_err_loc := 1800;
4341: l_end_date := sysdate;
4342: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4343: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4344: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4345: END IF;
4346: EXCEPTION
4375: BEGIN
4376: l_err_loc := 100;
4377: l_start_date := sysdate;
4378:
4379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4380: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4381: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4382: END IF;
4383:
4438:
4439: l_err_loc := 400;
4440: l_row_count := SQL%ROWCOUNT;
4441: IF (l_row_count = 0) THEN
4442: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4443: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4444: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4445: 'no rows deleted from ctx_hdrs for invalid req tmplts, so exit from the loop');
4446: END IF;
4439: l_err_loc := 400;
4440: l_row_count := SQL%ROWCOUNT;
4441: IF (l_row_count = 0) THEN
4442: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4443: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4444: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4445: 'no rows deleted from ctx_hdrs for invalid req tmplts, so exit from the loop');
4446: END IF;
4447: EXIT;
4446: END IF;
4447: EXIT;
4448: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4449: l_continue := FALSE;
4450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4451: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4452: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4453: 'Num. of rows deleted from ctx_hdrs for invalid req templates:' || l_row_count);
4454: END IF;
4447: EXIT;
4448: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4449: l_continue := FALSE;
4450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4451: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4452: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4453: 'Num. of rows deleted from ctx_hdrs for invalid req templates:' || l_row_count);
4454: END IF;
4455: END IF;
4467: l_err_loc := 600;
4468: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4469: l_err_loc := 700;
4470: COMMIT;
4471: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4472: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4473: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4474: 'Commit done.');
4475: END IF;
4468: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4469: l_err_loc := 700;
4470: COMMIT;
4471: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4472: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4473: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4474: 'Commit done.');
4475: END IF;
4476: ELSE
4474: 'Commit done.');
4475: END IF;
4476: ELSE
4477: l_err_loc := 800;
4478: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4479: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4480: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4481: 'Commit not done.');
4482: END IF;
4475: END IF;
4476: ELSE
4477: l_err_loc := 800;
4478: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4479: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4480: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4481: 'Commit not done.');
4482: END IF;
4483: END IF;
4484: END LOOP;
4485:
4486: l_err_loc := 900;
4487: l_end_date := sysdate;
4488: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4489: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4490: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4491: END IF;
4492:
4523: BEGIN
4524: l_err_loc := 100;
4525: l_start_date := sysdate;
4526:
4527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4528: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4529: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4530: END IF;
4531:
4559:
4560: l_err_loc := 400;
4561: l_row_count := SQL%ROWCOUNT;
4562: IF (l_row_count = 0) THEN
4563: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4564: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4565: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4566: 'no rows deleted from ctx_hdrs for invalid Quote lines, so exit from the loop');
4567: END IF;
4560: l_err_loc := 400;
4561: l_row_count := SQL%ROWCOUNT;
4562: IF (l_row_count = 0) THEN
4563: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4564: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4565: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4566: 'no rows deleted from ctx_hdrs for invalid Quote lines, so exit from the loop');
4567: END IF;
4568: EXIT;
4567: END IF;
4568: EXIT;
4569: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4570: l_continue := FALSE;
4571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4572: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4573: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4574: 'Num. of rows deleted from ctx_hdrs for invalid Quote lines:' || l_row_count);
4575: END IF;
4568: EXIT;
4569: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4570: l_continue := FALSE;
4571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4572: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4573: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4574: 'Num. of rows deleted from ctx_hdrs for invalid Quote lines:' || l_row_count);
4575: END IF;
4576: END IF;
4588: l_err_loc := 600;
4589: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4590: l_err_loc := 700;
4591: COMMIT;
4592: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4593: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4594: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4595: 'Commit done.');
4596: END IF;
4589: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4590: l_err_loc := 700;
4591: COMMIT;
4592: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4593: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4594: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4595: 'Commit done.');
4596: END IF;
4597: ELSE
4595: 'Commit done.');
4596: END IF;
4597: ELSE
4598: l_err_loc := 800;
4599: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4600: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4601: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4602: 'Commit not done.');
4603: END IF;
4596: END IF;
4597: ELSE
4598: l_err_loc := 800;
4599: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4600: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4601: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4602: 'Commit not done.');
4603: END IF;
4604: END IF;
4605: END LOOP;
4606:
4607: l_err_loc := 900;
4608: l_end_date := sysdate;
4609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4610: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4611: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4612: END IF;
4613:
4653: l_row_count PLS_INTEGER;
4654: BEGIN
4655: l_err_loc := 100;
4656: l_start_date := sysdate;
4657: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4659: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4660: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
4661: END IF;
4654: BEGIN
4655: l_err_loc := 100;
4656: l_start_date := sysdate;
4657: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4659: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4660: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
4661: END IF;
4662:
4694:
4695: l_err_loc := 400;
4696: l_row_count := SQL%ROWCOUNT;
4697: IF (l_row_count = 0) THEN
4698: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4699: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4700: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4701: 'no rows deleted from ctx_hdrs for invalid blanket lines, so exit from the loop');
4702: END IF;
4695: l_err_loc := 400;
4696: l_row_count := SQL%ROWCOUNT;
4697: IF (l_row_count = 0) THEN
4698: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4699: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4700: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4701: 'no rows deleted from ctx_hdrs for invalid blanket lines, so exit from the loop');
4702: END IF;
4703: EXIT;
4702: END IF;
4703: EXIT;
4704: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4705: l_continue := FALSE;
4706: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4707: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4708: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4709: 'Num. of rows deleted from ctx_hdrs for invalid blanket lines:' || l_row_count);
4710: END IF;
4703: EXIT;
4704: ELSIF (l_row_count < ICX_CAT_UTIL_PVT.g_batch_size) THEN
4705: l_continue := FALSE;
4706: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4707: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4708: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4709: 'Num. of rows deleted from ctx_hdrs for invalid blanket lines:' || l_row_count);
4710: END IF;
4711: END IF;
4723: l_err_loc := 600;
4724: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4725: l_err_loc := 700;
4726: COMMIT;
4727: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4728: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4729: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4730: 'Commit done.');
4731: END IF;
4724: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4725: l_err_loc := 700;
4726: COMMIT;
4727: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4728: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4729: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4730: 'Commit done.');
4731: END IF;
4732: ELSE
4730: 'Commit done.');
4731: END IF;
4732: ELSE
4733: l_err_loc := 800;
4734: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4735: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4736: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4737: 'Commit not done.');
4738: END IF;
4731: END IF;
4732: ELSE
4733: l_err_loc := 800;
4734: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4735: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4736: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4737: 'Commit not done.');
4738: END IF;
4739: END IF;
4740: END LOOP;
4741:
4742: l_err_loc := 900;
4743: l_end_date := sysdate;
4744: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4745: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4746: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4747: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4748: END IF;
4741:
4742: l_err_loc := 900;
4743: l_end_date := sysdate;
4744: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4745: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4746: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4747: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4748: END IF;
4749:
4773:
4774: l_err_loc := 150;
4775: l_start_date := sysdate;
4776:
4777: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4778: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4779: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4780: END IF;
4781:
4802: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
4803: l_err_loc := 900;
4804: -- Call the rebuild index
4805: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4806: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4807: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4808: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4809: 'Rebuild indexes called.');
4810: END IF;
4803: l_err_loc := 900;
4804: -- Call the rebuild index
4805: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4806: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4807: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4808: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4809: 'Rebuild indexes called.');
4810: END IF;
4811: END IF;
4811: END IF;
4812:
4813: l_err_loc := 1000;
4814: l_end_date := sysdate;
4815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4816: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4817: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4818: END IF;
4819: EXCEPTION
4845:
4846: l_err_loc := 200;
4847: l_start_date := sysdate;
4848:
4849: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4850: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4851: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4852: END IF;
4853:
4856: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
4857:
4858: l_err_loc := 400;
4859: l_end_date := sysdate;
4860: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4861: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4862: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4863: END IF;
4864: EXCEPTION