APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on FND_LOG

Line 594: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

590: l_err_loc PLS_INTEGER;
591: l_module_name VARCHAR2(80);
592: BEGIN
593: l_err_loc := 100;
594: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
595: l_err_loc := 200;
596: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, p_api_name);
597:
598: l_err_loc := 300;

Line 600: FND_LOG.string(p_log_level, l_module_name, l_log_string);

596: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, p_api_name);
597:
598: l_err_loc := 300;
599: l_log_string := 'logPLSQLTableRow('||p_action_mode||')['||p_index||']--';
600: FND_LOG.string(p_log_level, l_module_name, l_log_string);
601:
602: l_err_loc := 400;
603:
604: IF (p_action_mode = 'INSERT_INT_HDRS') THEN

Line 609: FND_LOG.string(p_log_level, l_module_name, l_log_string);

605: l_err_loc := 500;
606: -- INSERT po_headers_interface
607: l_log_string := ' gIHInterfaceHeaderIdTbl: ' ||
608: ICX_CAT_UTIL_PVT.getTableElement(gIHInterfaceHeaderIdTbl, p_index) || '; ';
609: FND_LOG.string(p_log_level, l_module_name, l_log_string);
610:
611: l_log_string := ' gIHActionTbl: ' ||
612: ICX_CAT_UTIL_PVT.getTableElement(gIHActionTbl, p_index) || '; ';
613: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 613: FND_LOG.string(p_log_level, l_module_name, l_log_string);

609: FND_LOG.string(p_log_level, l_module_name, l_log_string);
610:
611: l_log_string := ' gIHActionTbl: ' ||
612: ICX_CAT_UTIL_PVT.getTableElement(gIHActionTbl, p_index) || '; ';
613: FND_LOG.string(p_log_level, l_module_name, l_log_string);
614:
615: l_log_string := ' gIHOrgIdTbl: ' ||
616: ICX_CAT_UTIL_PVT.getTableElement(gIHOrgIdTbl, p_index) || '; ';
617: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 617: FND_LOG.string(p_log_level, l_module_name, l_log_string);

613: FND_LOG.string(p_log_level, l_module_name, l_log_string);
614:
615: l_log_string := ' gIHOrgIdTbl: ' ||
616: ICX_CAT_UTIL_PVT.getTableElement(gIHOrgIdTbl, p_index) || '; ';
617: FND_LOG.string(p_log_level, l_module_name, l_log_string);
618:
619: l_log_string := ' gIHDocumentTypeCodeTbl: ' ||
620: ICX_CAT_UTIL_PVT.getTableElement(gIHDocumentTypeCodeTbl, p_index) || '; ';
621: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 621: FND_LOG.string(p_log_level, l_module_name, l_log_string);

617: FND_LOG.string(p_log_level, l_module_name, l_log_string);
618:
619: l_log_string := ' gIHDocumentTypeCodeTbl: ' ||
620: ICX_CAT_UTIL_PVT.getTableElement(gIHDocumentTypeCodeTbl, p_index) || '; ';
621: FND_LOG.string(p_log_level, l_module_name, l_log_string);
622:
623: l_log_string := ' gIHBudgetAccountSegment1Tbl: ' ||
624: ICX_CAT_UTIL_PVT.getTableElement(gIHBudgetAccountSegment1Tbl, p_index) || '; ';
625: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 625: FND_LOG.string(p_log_level, l_module_name, l_log_string);

621: FND_LOG.string(p_log_level, l_module_name, l_log_string);
622:
623: l_log_string := ' gIHBudgetAccountSegment1Tbl: ' ||
624: ICX_CAT_UTIL_PVT.getTableElement(gIHBudgetAccountSegment1Tbl, p_index) || '; ';
625: FND_LOG.string(p_log_level, l_module_name, l_log_string);
626:
627: l_log_string := ' gIHPoHeaderIdTbl: ' ||
628: ICX_CAT_UTIL_PVT.getTableElement(gIHPoHeaderIdTbl, p_index) || '; ';
629: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 629: FND_LOG.string(p_log_level, l_module_name, l_log_string);

625: FND_LOG.string(p_log_level, l_module_name, l_log_string);
626:
627: l_log_string := ' gIHPoHeaderIdTbl: ' ||
628: ICX_CAT_UTIL_PVT.getTableElement(gIHPoHeaderIdTbl, p_index) || '; ';
629: FND_LOG.string(p_log_level, l_module_name, l_log_string);
630:
631: l_log_string := ' gIHApprovalStatusTbl: ' ||
632: ICX_CAT_UTIL_PVT.getTableElement(gIHApprovalStatusTbl, p_index) || '; ';
633: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 633: FND_LOG.string(p_log_level, l_module_name, l_log_string);

629: FND_LOG.string(p_log_level, l_module_name, l_log_string);
630:
631: l_log_string := ' gIHApprovalStatusTbl: ' ||
632: ICX_CAT_UTIL_PVT.getTableElement(gIHApprovalStatusTbl, p_index) || '; ';
633: FND_LOG.string(p_log_level, l_module_name, l_log_string);
634:
635: l_log_string := ' gIHVendorIdTbl: ' ||
636: ICX_CAT_UTIL_PVT.getTableElement(gIHVendorIdTbl, p_index) || '; ';
637: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 637: FND_LOG.string(p_log_level, l_module_name, l_log_string);

633: FND_LOG.string(p_log_level, l_module_name, l_log_string);
634:
635: l_log_string := ' gIHVendorIdTbl: ' ||
636: ICX_CAT_UTIL_PVT.getTableElement(gIHVendorIdTbl, p_index) || '; ';
637: FND_LOG.string(p_log_level, l_module_name, l_log_string);
638:
639: l_log_string := ' gIHVendorSiteIdTbl: ' ||
640: ICX_CAT_UTIL_PVT.getTableElement(gIHVendorSiteIdTbl, p_index) || '; ';
641: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 641: FND_LOG.string(p_log_level, l_module_name, l_log_string);

637: FND_LOG.string(p_log_level, l_module_name, l_log_string);
638:
639: l_log_string := ' gIHVendorSiteIdTbl: ' ||
640: ICX_CAT_UTIL_PVT.getTableElement(gIHVendorSiteIdTbl, p_index) || '; ';
641: FND_LOG.string(p_log_level, l_module_name, l_log_string);
642:
643: l_log_string := ' gIHCurrencyCodeTbl: ' ||
644: ICX_CAT_UTIL_PVT.getTableElement(gIHCurrencyCodeTbl, p_index) || '; ';
645: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 645: FND_LOG.string(p_log_level, l_module_name, l_log_string);

641: FND_LOG.string(p_log_level, l_module_name, l_log_string);
642:
643: l_log_string := ' gIHCurrencyCodeTbl: ' ||
644: ICX_CAT_UTIL_PVT.getTableElement(gIHCurrencyCodeTbl, p_index) || '; ';
645: FND_LOG.string(p_log_level, l_module_name, l_log_string);
646:
647: l_log_string := ' gIHCpaReferenceTbl: ' ||
648: ICX_CAT_UTIL_PVT.getTableElement(gIHCpaReferenceTbl, p_index) || '; ';
649: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 649: FND_LOG.string(p_log_level, l_module_name, l_log_string);

645: FND_LOG.string(p_log_level, l_module_name, l_log_string);
646:
647: l_log_string := ' gIHCpaReferenceTbl: ' ||
648: ICX_CAT_UTIL_PVT.getTableElement(gIHCpaReferenceTbl, p_index) || '; ';
649: FND_LOG.string(p_log_level, l_module_name, l_log_string);
650:
651: l_log_string := ' gIHCreatedLanguageTbl: ' ||
652: ICX_CAT_UTIL_PVT.getTableElement(gIHCreatedLanguageTbl, p_index) || '; ';
653: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 653: FND_LOG.string(p_log_level, l_module_name, l_log_string);

649: FND_LOG.string(p_log_level, l_module_name, l_log_string);
650:
651: l_log_string := ' gIHCreatedLanguageTbl: ' ||
652: ICX_CAT_UTIL_PVT.getTableElement(gIHCreatedLanguageTbl, p_index) || '; ';
653: FND_LOG.string(p_log_level, l_module_name, l_log_string);
654:
655: l_log_string := ' gIHCommentsTbl: ' ||
656: ICX_CAT_UTIL_PVT.getTableElement(gIHCommentsTbl, p_index) || '; ';
657: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 657: FND_LOG.string(p_log_level, l_module_name, l_log_string);

653: FND_LOG.string(p_log_level, l_module_name, l_log_string);
654:
655: l_log_string := ' gIHCommentsTbl: ' ||
656: ICX_CAT_UTIL_PVT.getTableElement(gIHCommentsTbl, p_index) || '; ';
657: FND_LOG.string(p_log_level, l_module_name, l_log_string);
658:
659: END IF;
660:
661: l_err_loc := 600;

Line 668: FND_LOG.string(p_log_level, l_module_name, l_log_string);

664: l_err_loc := 700;
665: -- INSERT po_lines_interface
666: l_log_string := ' gILInterfaceLineIdTbl: ' ||
667: ICX_CAT_UTIL_PVT.getTableElement(gILInterfaceLineIdTbl, p_index) || '; ';
668: FND_LOG.string(p_log_level, l_module_name, l_log_string);
669:
670: l_log_string := ' gILInterfaceHeaderIdTbl: ' ||
671: ICX_CAT_UTIL_PVT.getTableElement(gILInterfaceHeaderIdTbl, p_index) || '; ';
672: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 672: FND_LOG.string(p_log_level, l_module_name, l_log_string);

668: FND_LOG.string(p_log_level, l_module_name, l_log_string);
669:
670: l_log_string := ' gILInterfaceHeaderIdTbl: ' ||
671: ICX_CAT_UTIL_PVT.getTableElement(gILInterfaceHeaderIdTbl, p_index) || '; ';
672: FND_LOG.string(p_log_level, l_module_name, l_log_string);
673:
674: l_log_string := ' gILActionTbl: ' ||
675: ICX_CAT_UTIL_PVT.getTableElement(gILActionTbl, p_index) || '; ';
676: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 676: FND_LOG.string(p_log_level, l_module_name, l_log_string);

672: FND_LOG.string(p_log_level, l_module_name, l_log_string);
673:
674: l_log_string := ' gILActionTbl: ' ||
675: ICX_CAT_UTIL_PVT.getTableElement(gILActionTbl, p_index) || '; ';
676: FND_LOG.string(p_log_level, l_module_name, l_log_string);
677:
678: l_log_string := ' gILPoLineIdTbl: ' ||
679: ICX_CAT_UTIL_PVT.getTableElement(gILPoLineIdTbl, p_index) || '; ';
680: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 680: FND_LOG.string(p_log_level, l_module_name, l_log_string);

676: FND_LOG.string(p_log_level, l_module_name, l_log_string);
677:
678: l_log_string := ' gILPoLineIdTbl: ' ||
679: ICX_CAT_UTIL_PVT.getTableElement(gILPoLineIdTbl, p_index) || '; ';
680: FND_LOG.string(p_log_level, l_module_name, l_log_string);
681:
682: l_log_string := ' gILPoHeaderIdTbl: ' ||
683: ICX_CAT_UTIL_PVT.getTableElement(gILPoHeaderIdTbl, p_index) || '; ';
684: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 684: FND_LOG.string(p_log_level, l_module_name, l_log_string);

680: FND_LOG.string(p_log_level, l_module_name, l_log_string);
681:
682: l_log_string := ' gILPoHeaderIdTbl: ' ||
683: ICX_CAT_UTIL_PVT.getTableElement(gILPoHeaderIdTbl, p_index) || '; ';
684: FND_LOG.string(p_log_level, l_module_name, l_log_string);
685:
686: l_log_string := ' gILUnitPriceTbl: ' ||
687: ICX_CAT_UTIL_PVT.getTableElement(gILUnitPriceTbl, p_index) || '; ';
688: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 688: FND_LOG.string(p_log_level, l_module_name, l_log_string);

684: FND_LOG.string(p_log_level, l_module_name, l_log_string);
685:
686: l_log_string := ' gILUnitPriceTbl: ' ||
687: ICX_CAT_UTIL_PVT.getTableElement(gILUnitPriceTbl, p_index) || '; ';
688: FND_LOG.string(p_log_level, l_module_name, l_log_string);
689:
690: l_log_string := ' gILUomCodeTbl: ' ||
691: ICX_CAT_UTIL_PVT.getTableElement(gILUomCodeTbl, p_index) || '; ';
692: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 692: FND_LOG.string(p_log_level, l_module_name, l_log_string);

688: FND_LOG.string(p_log_level, l_module_name, l_log_string);
689:
690: l_log_string := ' gILUomCodeTbl: ' ||
691: ICX_CAT_UTIL_PVT.getTableElement(gILUomCodeTbl, p_index) || '; ';
692: FND_LOG.string(p_log_level, l_module_name, l_log_string);
693:
694: l_log_string := ' gILNegByPrepFlagTbl: ' ||
695: ICX_CAT_UTIL_PVT.getTableElement(gILNegByPrepFlagTbl, p_index) || '; ';
696: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 696: FND_LOG.string(p_log_level, l_module_name, l_log_string);

692: FND_LOG.string(p_log_level, l_module_name, l_log_string);
693:
694: l_log_string := ' gILNegByPrepFlagTbl: ' ||
695: ICX_CAT_UTIL_PVT.getTableElement(gILNegByPrepFlagTbl, p_index) || '; ';
696: FND_LOG.string(p_log_level, l_module_name, l_log_string);
697:
698: l_log_string := ' gILIpCategoryIdTbl: ' ||
699: ICX_CAT_UTIL_PVT.getTableElement(gILIpCategoryIdTbl, p_index) || '; ';
700: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 700: FND_LOG.string(p_log_level, l_module_name, l_log_string);

696: FND_LOG.string(p_log_level, l_module_name, l_log_string);
697:
698: l_log_string := ' gILIpCategoryIdTbl: ' ||
699: ICX_CAT_UTIL_PVT.getTableElement(gILIpCategoryIdTbl, p_index) || '; ';
700: FND_LOG.string(p_log_level, l_module_name, l_log_string);
701:
702: l_log_string := ' gILCategoryIdTbl: ' ||
703: ICX_CAT_UTIL_PVT.getTableElement(gILCategoryIdTbl, p_index) || '; ';
704: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 704: FND_LOG.string(p_log_level, l_module_name, l_log_string);

700: FND_LOG.string(p_log_level, l_module_name, l_log_string);
701:
702: l_log_string := ' gILCategoryIdTbl: ' ||
703: ICX_CAT_UTIL_PVT.getTableElement(gILCategoryIdTbl, p_index) || '; ';
704: FND_LOG.string(p_log_level, l_module_name, l_log_string);
705:
706: l_log_string := ' gILCategoryNameTbl: ' ||
707: ICX_CAT_UTIL_PVT.getTableElement(gILCategoryNameTbl, p_index) || '; ';
708: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 708: FND_LOG.string(p_log_level, l_module_name, l_log_string);

704: FND_LOG.string(p_log_level, l_module_name, l_log_string);
705:
706: l_log_string := ' gILCategoryNameTbl: ' ||
707: ICX_CAT_UTIL_PVT.getTableElement(gILCategoryNameTbl, p_index) || '; ';
708: FND_LOG.string(p_log_level, l_module_name, l_log_string);
709:
710: l_log_string := ' gILVendorProductNumTbl: ' ||
711: ICX_CAT_UTIL_PVT.getTableElement(gILVendorProductNumTbl, p_index) || '; ';
712: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 712: FND_LOG.string(p_log_level, l_module_name, l_log_string);

708: FND_LOG.string(p_log_level, l_module_name, l_log_string);
709:
710: l_log_string := ' gILVendorProductNumTbl: ' ||
711: ICX_CAT_UTIL_PVT.getTableElement(gILVendorProductNumTbl, p_index) || '; ';
712: FND_LOG.string(p_log_level, l_module_name, l_log_string);
713:
714: l_log_string := ' gILSupplierPartAuxidTbl: ' ||
715: ICX_CAT_UTIL_PVT.getTableElement(gILSupplierPartAuxidTbl, p_index) || '; ';
716: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 716: FND_LOG.string(p_log_level, l_module_name, l_log_string);

712: FND_LOG.string(p_log_level, l_module_name, l_log_string);
713:
714: l_log_string := ' gILSupplierPartAuxidTbl: ' ||
715: ICX_CAT_UTIL_PVT.getTableElement(gILSupplierPartAuxidTbl, p_index) || '; ';
716: FND_LOG.string(p_log_level, l_module_name, l_log_string);
717:
718: l_log_string := ' gILItemDescripionTbl: ' ||
719: ICX_CAT_UTIL_PVT.getTableElement(gILItemDescripionTbl, p_index) || '; ';
720: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 720: FND_LOG.string(p_log_level, l_module_name, l_log_string);

716: FND_LOG.string(p_log_level, l_module_name, l_log_string);
717:
718: l_log_string := ' gILItemDescripionTbl: ' ||
719: ICX_CAT_UTIL_PVT.getTableElement(gILItemDescripionTbl, p_index) || '; ';
720: FND_LOG.string(p_log_level, l_module_name, l_log_string);
721:
722: l_log_string := ' gILCatalogNameTbl: ' ||
723: ICX_CAT_UTIL_PVT.getTableElement(gILCatalogNameTbl, p_index) || '; ';
724: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 724: FND_LOG.string(p_log_level, l_module_name, l_log_string);

720: FND_LOG.string(p_log_level, l_module_name, l_log_string);
721:
722: l_log_string := ' gILCatalogNameTbl: ' ||
723: ICX_CAT_UTIL_PVT.getTableElement(gILCatalogNameTbl, p_index) || '; ';
724: FND_LOG.string(p_log_level, l_module_name, l_log_string);
725:
726: END IF;
727:
728: l_err_loc := 800;

Line 735: FND_LOG.string(p_log_level, l_module_name, l_log_string);

731: l_err_loc := 900;
732: -- INSERT po_attr_values_interface
733: l_log_string := ' gIAVInterfaceHeaderIdTbl: ' ||
734: ICX_CAT_UTIL_PVT.getTableElement(gIAVInterfaceHeaderIdTbl, p_index) || '; ';
735: FND_LOG.string(p_log_level, l_module_name, l_log_string);
736:
737: l_log_string := ' gIAVInterfaceLineIdTbl: ' ||
738: ICX_CAT_UTIL_PVT.getTableElement(gIAVInterfaceLineIdTbl, p_index) || '; ';
739: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 739: FND_LOG.string(p_log_level, l_module_name, l_log_string);

735: FND_LOG.string(p_log_level, l_module_name, l_log_string);
736:
737: l_log_string := ' gIAVInterfaceLineIdTbl: ' ||
738: ICX_CAT_UTIL_PVT.getTableElement(gIAVInterfaceLineIdTbl, p_index) || '; ';
739: FND_LOG.string(p_log_level, l_module_name, l_log_string);
740:
741: l_log_string := ' gIAVActionTbl: ' ||
742: ICX_CAT_UTIL_PVT.getTableElement(gIAVActionTbl, p_index) || '; ';
743: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 743: FND_LOG.string(p_log_level, l_module_name, l_log_string);

739: FND_LOG.string(p_log_level, l_module_name, l_log_string);
740:
741: l_log_string := ' gIAVActionTbl: ' ||
742: ICX_CAT_UTIL_PVT.getTableElement(gIAVActionTbl, p_index) || '; ';
743: FND_LOG.string(p_log_level, l_module_name, l_log_string);
744:
745: l_log_string := ' gIAVPoLineIdTbl: ' ||
746: ICX_CAT_UTIL_PVT.getTableElement(gIAVPoLineIdTbl, p_index) || '; ';
747: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 747: FND_LOG.string(p_log_level, l_module_name, l_log_string);

743: FND_LOG.string(p_log_level, l_module_name, l_log_string);
744:
745: l_log_string := ' gIAVPoLineIdTbl: ' ||
746: ICX_CAT_UTIL_PVT.getTableElement(gIAVPoLineIdTbl, p_index) || '; ';
747: FND_LOG.string(p_log_level, l_module_name, l_log_string);
748:
749: l_log_string := ' gIAVReqTemplateNameTbl: ' ||
750: ICX_CAT_UTIL_PVT.getTableElement(gIAVReqTemplateNameTbl, p_index) || '; ';
751: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 751: FND_LOG.string(p_log_level, l_module_name, l_log_string);

747: FND_LOG.string(p_log_level, l_module_name, l_log_string);
748:
749: l_log_string := ' gIAVReqTemplateNameTbl: ' ||
750: ICX_CAT_UTIL_PVT.getTableElement(gIAVReqTemplateNameTbl, p_index) || '; ';
751: FND_LOG.string(p_log_level, l_module_name, l_log_string);
752:
753: l_log_string := ' gIAVReqTemplateLineNumTbl: ' ||
754: ICX_CAT_UTIL_PVT.getTableElement(gIAVReqTemplateLineNumTbl, p_index) || '; ';
755: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 755: FND_LOG.string(p_log_level, l_module_name, l_log_string);

751: FND_LOG.string(p_log_level, l_module_name, l_log_string);
752:
753: l_log_string := ' gIAVReqTemplateLineNumTbl: ' ||
754: ICX_CAT_UTIL_PVT.getTableElement(gIAVReqTemplateLineNumTbl, p_index) || '; ';
755: FND_LOG.string(p_log_level, l_module_name, l_log_string);
756:
757: l_log_string := ' gIAVInventoryItemIdTbl: ' ||
758: ICX_CAT_UTIL_PVT.getTableElement(gIAVInventoryItemIdTbl, p_index) || '; ';
759: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 759: FND_LOG.string(p_log_level, l_module_name, l_log_string);

755: FND_LOG.string(p_log_level, l_module_name, l_log_string);
756:
757: l_log_string := ' gIAVInventoryItemIdTbl: ' ||
758: ICX_CAT_UTIL_PVT.getTableElement(gIAVInventoryItemIdTbl, p_index) || '; ';
759: FND_LOG.string(p_log_level, l_module_name, l_log_string);
760:
761: l_log_string := ' gIAVOrgIdTbl: ' ||
762: ICX_CAT_UTIL_PVT.getTableElement(gIAVOrgIdTbl, p_index) || '; ';
763: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 763: FND_LOG.string(p_log_level, l_module_name, l_log_string);

759: FND_LOG.string(p_log_level, l_module_name, l_log_string);
760:
761: l_log_string := ' gIAVOrgIdTbl: ' ||
762: ICX_CAT_UTIL_PVT.getTableElement(gIAVOrgIdTbl, p_index) || '; ';
763: FND_LOG.string(p_log_level, l_module_name, l_log_string);
764:
765: l_log_string := ' gIAVRtItemIdTbl: ' ||
766: ICX_CAT_UTIL_PVT.getTableElement(gIAVRtItemIdTbl, p_index) || '; ';
767: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 767: FND_LOG.string(p_log_level, l_module_name, l_log_string);

763: FND_LOG.string(p_log_level, l_module_name, l_log_string);
764:
765: l_log_string := ' gIAVRtItemIdTbl: ' ||
766: ICX_CAT_UTIL_PVT.getTableElement(gIAVRtItemIdTbl, p_index) || '; ';
767: FND_LOG.string(p_log_level, l_module_name, l_log_string);
768:
769: l_log_string := ' gIAVLanguageTbl: ' ||
770: ICX_CAT_UTIL_PVT.getTableElement(gIAVLanguageTbl, p_index) || '; ';
771: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 771: FND_LOG.string(p_log_level, l_module_name, l_log_string);

767: FND_LOG.string(p_log_level, l_module_name, l_log_string);
768:
769: l_log_string := ' gIAVLanguageTbl: ' ||
770: ICX_CAT_UTIL_PVT.getTableElement(gIAVLanguageTbl, p_index) || '; ';
771: FND_LOG.string(p_log_level, l_module_name, l_log_string);
772:
773: END IF;
774:
775: l_err_loc := 1000;

Line 782: FND_LOG.string(p_log_level, l_module_name, l_log_string);

778: l_err_loc := 1100;
779: -- INSERT po_attr_values_tlp_interface
780: l_log_string := ' gIAVTInterfaceHeaderIdTbl: ' ||
781: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInterfaceHeaderIdTbl, p_index) || '; ';
782: FND_LOG.string(p_log_level, l_module_name, l_log_string);
783:
784: l_log_string := ' gIAVTInterfaceLineIdTbl: ' ||
785: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInterfaceLineIdTbl, p_index) || '; ';
786: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 786: FND_LOG.string(p_log_level, l_module_name, l_log_string);

782: FND_LOG.string(p_log_level, l_module_name, l_log_string);
783:
784: l_log_string := ' gIAVTInterfaceLineIdTbl: ' ||
785: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInterfaceLineIdTbl, p_index) || '; ';
786: FND_LOG.string(p_log_level, l_module_name, l_log_string);
787:
788: l_log_string := ' gIAVTActionTbl: ' ||
789: ICX_CAT_UTIL_PVT.getTableElement(gIAVTActionTbl, p_index) || '; ';
790: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 790: FND_LOG.string(p_log_level, l_module_name, l_log_string);

786: FND_LOG.string(p_log_level, l_module_name, l_log_string);
787:
788: l_log_string := ' gIAVTActionTbl: ' ||
789: ICX_CAT_UTIL_PVT.getTableElement(gIAVTActionTbl, p_index) || '; ';
790: FND_LOG.string(p_log_level, l_module_name, l_log_string);
791:
792: l_log_string := ' gIAVTPoLineIdTbl: ' ||
793: ICX_CAT_UTIL_PVT.getTableElement(gIAVTPoLineIdTbl, p_index) || '; ';
794: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 794: FND_LOG.string(p_log_level, l_module_name, l_log_string);

790: FND_LOG.string(p_log_level, l_module_name, l_log_string);
791:
792: l_log_string := ' gIAVTPoLineIdTbl: ' ||
793: ICX_CAT_UTIL_PVT.getTableElement(gIAVTPoLineIdTbl, p_index) || '; ';
794: FND_LOG.string(p_log_level, l_module_name, l_log_string);
795:
796: l_log_string := ' gIAVTReqTemplateNameTbl: ' ||
797: ICX_CAT_UTIL_PVT.getTableElement(gIAVTReqTemplateNameTbl, p_index) || '; ';
798: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 798: FND_LOG.string(p_log_level, l_module_name, l_log_string);

794: FND_LOG.string(p_log_level, l_module_name, l_log_string);
795:
796: l_log_string := ' gIAVTReqTemplateNameTbl: ' ||
797: ICX_CAT_UTIL_PVT.getTableElement(gIAVTReqTemplateNameTbl, p_index) || '; ';
798: FND_LOG.string(p_log_level, l_module_name, l_log_string);
799:
800: l_log_string := ' gIAVTReqTemplateLineNumTbl: ' ||
801: ICX_CAT_UTIL_PVT.getTableElement(gIAVTReqTemplateLineNumTbl, p_index) || '; ';
802: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 802: FND_LOG.string(p_log_level, l_module_name, l_log_string);

798: FND_LOG.string(p_log_level, l_module_name, l_log_string);
799:
800: l_log_string := ' gIAVTReqTemplateLineNumTbl: ' ||
801: ICX_CAT_UTIL_PVT.getTableElement(gIAVTReqTemplateLineNumTbl, p_index) || '; ';
802: FND_LOG.string(p_log_level, l_module_name, l_log_string);
803:
804: l_log_string := ' gIAVTInventoryItemIdTbl: ' ||
805: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInventoryItemIdTbl, p_index) || '; ';
806: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 806: FND_LOG.string(p_log_level, l_module_name, l_log_string);

802: FND_LOG.string(p_log_level, l_module_name, l_log_string);
803:
804: l_log_string := ' gIAVTInventoryItemIdTbl: ' ||
805: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInventoryItemIdTbl, p_index) || '; ';
806: FND_LOG.string(p_log_level, l_module_name, l_log_string);
807:
808: l_log_string := ' gIAVTOrgIdTbl: ' ||
809: ICX_CAT_UTIL_PVT.getTableElement(gIAVTOrgIdTbl, p_index) || '; ';
810: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 810: FND_LOG.string(p_log_level, l_module_name, l_log_string);

806: FND_LOG.string(p_log_level, l_module_name, l_log_string);
807:
808: l_log_string := ' gIAVTOrgIdTbl: ' ||
809: ICX_CAT_UTIL_PVT.getTableElement(gIAVTOrgIdTbl, p_index) || '; ';
810: FND_LOG.string(p_log_level, l_module_name, l_log_string);
811:
812: l_log_string := ' gIAVTRtItemIdTbl: ' ||
813: ICX_CAT_UTIL_PVT.getTableElement(gIAVTRtItemIdTbl, p_index) || '; ';
814: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 814: FND_LOG.string(p_log_level, l_module_name, l_log_string);

810: FND_LOG.string(p_log_level, l_module_name, l_log_string);
811:
812: l_log_string := ' gIAVTRtItemIdTbl: ' ||
813: ICX_CAT_UTIL_PVT.getTableElement(gIAVTRtItemIdTbl, p_index) || '; ';
814: FND_LOG.string(p_log_level, l_module_name, l_log_string);
815:
816: l_log_string := ' gIAVTLanguageTbl: ' ||
817: ICX_CAT_UTIL_PVT.getTableElement(gIAVTLanguageTbl, p_index) || '; ';
818: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 818: FND_LOG.string(p_log_level, l_module_name, l_log_string);

814: FND_LOG.string(p_log_level, l_module_name, l_log_string);
815:
816: l_log_string := ' gIAVTLanguageTbl: ' ||
817: ICX_CAT_UTIL_PVT.getTableElement(gIAVTLanguageTbl, p_index) || '; ';
818: FND_LOG.string(p_log_level, l_module_name, l_log_string);
819:
820: l_log_string := ' gIAVTCheckDescUpdateTbl: ' ||
821: ICX_CAT_UTIL_PVT.getTableElement(gIAVTCheckDescUpdateTbl, p_index) || '; ';
822: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 822: FND_LOG.string(p_log_level, l_module_name, l_log_string);

818: FND_LOG.string(p_log_level, l_module_name, l_log_string);
819:
820: l_log_string := ' gIAVTCheckDescUpdateTbl: ' ||
821: ICX_CAT_UTIL_PVT.getTableElement(gIAVTCheckDescUpdateTbl, p_index) || '; ';
822: FND_LOG.string(p_log_level, l_module_name, l_log_string);
823:
824: END IF;
825:
826: l_err_loc := 1200;

Line 833: FND_LOG.string(p_log_level, l_module_name, l_log_string);

829: l_err_loc := 1300;
830: -- INSERT icx_cat_r12_upgrade
831: l_log_string := ' gIRURtItemIdTbl: ' ||
832: ICX_CAT_UTIL_PVT.getTableElement(gIRURtItemIdTbl, p_index) || '; ';
833: FND_LOG.string(p_log_level, l_module_name, l_log_string);
834:
835: l_log_string := ' gIRUSupplierSiteIdTbl: ' ||
836: ICX_CAT_UTIL_PVT.getTableElement(gIRUSupplierSiteIdTbl, p_index) || '; ';
837: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 837: FND_LOG.string(p_log_level, l_module_name, l_log_string);

833: FND_LOG.string(p_log_level, l_module_name, l_log_string);
834:
835: l_log_string := ' gIRUSupplierSiteIdTbl: ' ||
836: ICX_CAT_UTIL_PVT.getTableElement(gIRUSupplierSiteIdTbl, p_index) || '; ';
837: FND_LOG.string(p_log_level, l_module_name, l_log_string);
838:
839: l_log_string := ' gIRUCurrencyTbl: ' ||
840: ICX_CAT_UTIL_PVT.getTableElement(gIRUCurrencyTbl, p_index) || '; ';
841: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 841: FND_LOG.string(p_log_level, l_module_name, l_log_string);

837: FND_LOG.string(p_log_level, l_module_name, l_log_string);
838:
839: l_log_string := ' gIRUCurrencyTbl: ' ||
840: ICX_CAT_UTIL_PVT.getTableElement(gIRUCurrencyTbl, p_index) || '; ';
841: FND_LOG.string(p_log_level, l_module_name, l_log_string);
842:
843: l_log_string := ' gIRUCpaReferenceTbl: ' ||
844: ICX_CAT_UTIL_PVT.getTableElement(gIRUCpaReferenceTbl, p_index) || '; ';
845: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 845: FND_LOG.string(p_log_level, l_module_name, l_log_string);

841: FND_LOG.string(p_log_level, l_module_name, l_log_string);
842:
843: l_log_string := ' gIRUCpaReferenceTbl: ' ||
844: ICX_CAT_UTIL_PVT.getTableElement(gIRUCpaReferenceTbl, p_index) || '; ';
845: FND_LOG.string(p_log_level, l_module_name, l_log_string);
846:
847: l_log_string := ' gIRUPriceContractIdTbl: ' ||
848: ICX_CAT_UTIL_PVT.getTableElement(gIRUPriceContractIdTbl, p_index) || '; ';
849: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 849: FND_LOG.string(p_log_level, l_module_name, l_log_string);

845: FND_LOG.string(p_log_level, l_module_name, l_log_string);
846:
847: l_log_string := ' gIRUPriceContractIdTbl: ' ||
848: ICX_CAT_UTIL_PVT.getTableElement(gIRUPriceContractIdTbl, p_index) || '; ';
849: FND_LOG.string(p_log_level, l_module_name, l_log_string);
850:
851: l_log_string := ' gIRUSrcContractIdTbl: ' ||
852: ICX_CAT_UTIL_PVT.getTableElement(gIRUSrcContractIdTbl, p_index) || '; ';
853: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 853: FND_LOG.string(p_log_level, l_module_name, l_log_string);

849: FND_LOG.string(p_log_level, l_module_name, l_log_string);
850:
851: l_log_string := ' gIRUSrcContractIdTbl: ' ||
852: ICX_CAT_UTIL_PVT.getTableElement(gIRUSrcContractIdTbl, p_index) || '; ';
853: FND_LOG.string(p_log_level, l_module_name, l_log_string);
854:
855: l_log_string := ' gIRUPoCategoryIdTbl: ' ||
856: ICX_CAT_UTIL_PVT.getTableElement(gIRUPoCategoryIdTbl, p_index) || '; ';
857: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 857: FND_LOG.string(p_log_level, l_module_name, l_log_string);

853: FND_LOG.string(p_log_level, l_module_name, l_log_string);
854:
855: l_log_string := ' gIRUPoCategoryIdTbl: ' ||
856: ICX_CAT_UTIL_PVT.getTableElement(gIRUPoCategoryIdTbl, p_index) || '; ';
857: FND_LOG.string(p_log_level, l_module_name, l_log_string);
858:
859: l_log_string := ' gIRUPoInterfaceHeaderIdTbl: ' ||
860: ICX_CAT_UTIL_PVT.getTableElement(gIRUPoInterfaceHeaderIdTbl, p_index) || '; ';
861: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 861: FND_LOG.string(p_log_level, l_module_name, l_log_string);

857: FND_LOG.string(p_log_level, l_module_name, l_log_string);
858:
859: l_log_string := ' gIRUPoInterfaceHeaderIdTbl: ' ||
860: ICX_CAT_UTIL_PVT.getTableElement(gIRUPoInterfaceHeaderIdTbl, p_index) || '; ';
861: FND_LOG.string(p_log_level, l_module_name, l_log_string);
862:
863: l_log_string := ' gIRUPoInterfaceLineIdTbl: ' ||
864: ICX_CAT_UTIL_PVT.getTableElement(gIRUPoInterfaceLineIdTbl, p_index) || '; ';
865: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 865: FND_LOG.string(p_log_level, l_module_name, l_log_string);

861: FND_LOG.string(p_log_level, l_module_name, l_log_string);
862:
863: l_log_string := ' gIRUPoInterfaceLineIdTbl: ' ||
864: ICX_CAT_UTIL_PVT.getTableElement(gIRUPoInterfaceLineIdTbl, p_index) || '; ';
865: FND_LOG.string(p_log_level, l_module_name, l_log_string);
866:
867: l_log_string := ' gIRUCreatedLanguageTbl: ' ||
868: ICX_CAT_UTIL_PVT.getTableElement(gIRUCreatedLanguageTbl, p_index) || '; ';
869: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 869: FND_LOG.string(p_log_level, l_module_name, l_log_string);

865: FND_LOG.string(p_log_level, l_module_name, l_log_string);
866:
867: l_log_string := ' gIRUCreatedLanguageTbl: ' ||
868: ICX_CAT_UTIL_PVT.getTableElement(gIRUCreatedLanguageTbl, p_index) || '; ';
869: FND_LOG.string(p_log_level, l_module_name, l_log_string);
870:
871: END IF;
872:
873: l_err_loc := 1400;

Line 880: FND_LOG.string(p_log_level, l_module_name, l_log_string);

876: l_err_loc := 1500;
877: -- UPDATE icx_cat_r12_upgrade
878: l_log_string := ' gURURtItemIdTbl: ' ||
879: ICX_CAT_UTIL_PVT.getTableElement(gURURtItemIdTbl, p_index) || '; ';
880: FND_LOG.string(p_log_level, l_module_name, l_log_string);
881:
882: l_log_string := ' gURUPoCategoryIdTbl: ' ||
883: ICX_CAT_UTIL_PVT.getTableElement(gURUPoCategoryIdTbl, p_index) || '; ';
884: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUPoCategoryIdTbl: ' ||
883: ICX_CAT_UTIL_PVT.getTableElement(gURUPoCategoryIdTbl, p_index) || '; ';
884: FND_LOG.string(p_log_level, l_module_name, l_log_string);
885:
886: l_log_string := ' gURUCpaReferenceTbl: ' ||
887: ICX_CAT_UTIL_PVT.getTableElement(gURUCpaReferenceTbl, p_index) || '; ';
888: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUCpaReferenceTbl: ' ||
887: ICX_CAT_UTIL_PVT.getTableElement(gURUCpaReferenceTbl, p_index) || '; ';
888: FND_LOG.string(p_log_level, l_module_name, l_log_string);
889:
890: l_log_string := ' gURUPriceContractIdTbl: ' ||
891: ICX_CAT_UTIL_PVT.getTableElement(gURUPriceContractIdTbl, p_index) || '; ';
892: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUPriceContractIdTbl: ' ||
891: ICX_CAT_UTIL_PVT.getTableElement(gURUPriceContractIdTbl, p_index) || '; ';
892: FND_LOG.string(p_log_level, l_module_name, l_log_string);
893:
894: l_log_string := ' gURUSrcContractIdTbl: ' ||
895: ICX_CAT_UTIL_PVT.getTableElement(gURUSrcContractIdTbl, p_index) || '; ';
896: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUSrcContractIdTbl: ' ||
895: ICX_CAT_UTIL_PVT.getTableElement(gURUSrcContractIdTbl, p_index) || '; ';
896: FND_LOG.string(p_log_level, l_module_name, l_log_string);
897:
898: l_log_string := ' gURUOldPoInterfaceLineIdTbl: ' ||
899: ICX_CAT_UTIL_PVT.getTableElement(gURUOldPoInterfaceLineIdTbl, p_index) || '; ';
900: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUOldPoInterfaceLineIdTbl: ' ||
899: ICX_CAT_UTIL_PVT.getTableElement(gURUOldPoInterfaceLineIdTbl, p_index) || '; ';
900: FND_LOG.string(p_log_level, l_module_name, l_log_string);
901:
902: l_log_string := ' gURUPoInterfaceHeaderIdTbl: ' ||
903: ICX_CAT_UTIL_PVT.getTableElement(gURUPoInterfaceHeaderIdTbl, p_index) || '; ';
904: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUPoInterfaceHeaderIdTbl: ' ||
903: ICX_CAT_UTIL_PVT.getTableElement(gURUPoInterfaceHeaderIdTbl, p_index) || '; ';
904: FND_LOG.string(p_log_level, l_module_name, l_log_string);
905:
906: l_log_string := ' gURUPoInterfaceLineIdTbl: ' ||
907: ICX_CAT_UTIL_PVT.getTableElement(gURUPoInterfaceLineIdTbl, p_index) || '; ';
908: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUPoInterfaceLineIdTbl: ' ||
907: ICX_CAT_UTIL_PVT.getTableElement(gURUPoInterfaceLineIdTbl, p_index) || '; ';
908: FND_LOG.string(p_log_level, l_module_name, l_log_string);
909:
910: l_log_string := ' gURUPoHeaderIdTbl: ' ||
911: ICX_CAT_UTIL_PVT.getTableElement(gURUPoHeaderIdTbl, p_index) || '; ';
912: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUPoHeaderIdTbl: ' ||
911: ICX_CAT_UTIL_PVT.getTableElement(gURUPoHeaderIdTbl, p_index) || '; ';
912: FND_LOG.string(p_log_level, l_module_name, l_log_string);
913:
914: l_log_string := ' gURUPoLineIdTbl: ' ||
915: ICX_CAT_UTIL_PVT.getTableElement(gURUPoLineIdTbl, p_index) || '; ';
916: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUPoLineIdTbl: ' ||
915: ICX_CAT_UTIL_PVT.getTableElement(gURUPoLineIdTbl, p_index) || '; ';
916: FND_LOG.string(p_log_level, l_module_name, l_log_string);
917:
918: l_log_string := ' gURUCreatedLanguageTbl: ' ||
919: ICX_CAT_UTIL_PVT.getTableElement(gURUCreatedLanguageTbl, p_index) || '; ';
920: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 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 := ' gURUCreatedLanguageTbl: ' ||
919: ICX_CAT_UTIL_PVT.getTableElement(gURUCreatedLanguageTbl, p_index) || '; ';
920: FND_LOG.string(p_log_level, l_module_name, l_log_string);
921:
922: END IF;
923:
924: l_err_loc := 1600;

Line 931: FND_LOG.string(p_log_level, l_module_name, l_log_string);

927: l_err_loc := 1700;
928: -- DELETE icx_cat_r12_upgrade
929: l_log_string := ' gDRURtItemIdTbl: ' ||
930: ICX_CAT_UTIL_PVT.getTableElement(gDRURtItemIdTbl, p_index) || '; ';
931: FND_LOG.string(p_log_level, l_module_name, l_log_string);
932:
933: l_log_string := ' gDRUPoInterfaceHeaderIdTbl: ' ||
934: ICX_CAT_UTIL_PVT.getTableElement(gDRUPoInterfaceHeaderIdTbl, p_index) || '; ';
935: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 935: FND_LOG.string(p_log_level, l_module_name, l_log_string);

931: FND_LOG.string(p_log_level, l_module_name, l_log_string);
932:
933: l_log_string := ' gDRUPoInterfaceHeaderIdTbl: ' ||
934: ICX_CAT_UTIL_PVT.getTableElement(gDRUPoInterfaceHeaderIdTbl, p_index) || '; ';
935: FND_LOG.string(p_log_level, l_module_name, l_log_string);
936:
937: l_log_string := ' gDRUPoInterfaceLineIdTbl: ' ||
938: ICX_CAT_UTIL_PVT.getTableElement(gDRUPoInterfaceLineIdTbl, p_index) || '; ';
939: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 939: FND_LOG.string(p_log_level, l_module_name, l_log_string);

935: FND_LOG.string(p_log_level, l_module_name, l_log_string);
936:
937: l_log_string := ' gDRUPoInterfaceLineIdTbl: ' ||
938: ICX_CAT_UTIL_PVT.getTableElement(gDRUPoInterfaceLineIdTbl, p_index) || '; ';
939: FND_LOG.string(p_log_level, l_module_name, l_log_string);
940:
941: END IF;
942:
943: l_err_loc := 1800;

Line 950: FND_LOG.string(p_log_level, l_module_name, l_log_string);

946: l_err_loc := 1900;
947: --INSERT icx_cat_fav_list_lines_tlp for catalog items
948: l_log_string := ' gIFLCFavoriteListIdTbl: ' ||
949: ICX_CAT_UTIL_PVT.getTableElement(gIFLCFavoriteListIdTbl, p_index) || '; ';
950: FND_LOG.string(p_log_level, l_module_name, l_log_string);
951:
952: l_log_string := ' gIFLCNewFavoriteListLineIdTbl: ' ||
953: ICX_CAT_UTIL_PVT.getTableElement(gIFLCNewFavoriteListLineIdTbl, p_index) || '; ';
954: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 954: FND_LOG.string(p_log_level, l_module_name, l_log_string);

950: FND_LOG.string(p_log_level, l_module_name, l_log_string);
951:
952: l_log_string := ' gIFLCNewFavoriteListLineIdTbl: ' ||
953: ICX_CAT_UTIL_PVT.getTableElement(gIFLCNewFavoriteListLineIdTbl, p_index) || '; ';
954: FND_LOG.string(p_log_level, l_module_name, l_log_string);
955:
956: l_log_string := ' gIFLCOldFavoriteListLineIdTbl: ' ||
957: ICX_CAT_UTIL_PVT.getTableElement(gIFLCOldFavoriteListLineIdTbl, p_index) || '; ';
958: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 958: FND_LOG.string(p_log_level, l_module_name, l_log_string);

954: FND_LOG.string(p_log_level, l_module_name, l_log_string);
955:
956: l_log_string := ' gIFLCOldFavoriteListLineIdTbl: ' ||
957: ICX_CAT_UTIL_PVT.getTableElement(gIFLCOldFavoriteListLineIdTbl, p_index) || '; ';
958: FND_LOG.string(p_log_level, l_module_name, l_log_string);
959:
960: l_log_string := ' gIFLCRtItemIdTbl: ' ||
961: ICX_CAT_UTIL_PVT.getTableElement(gIFLCRtItemIdTbl, p_index) || '; ';
962: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 962: FND_LOG.string(p_log_level, l_module_name, l_log_string);

958: FND_LOG.string(p_log_level, l_module_name, l_log_string);
959:
960: l_log_string := ' gIFLCRtItemIdTbl: ' ||
961: ICX_CAT_UTIL_PVT.getTableElement(gIFLCRtItemIdTbl, p_index) || '; ';
962: FND_LOG.string(p_log_level, l_module_name, l_log_string);
963:
964: l_log_string := ' gIFLCSourceTypeTbl: ' ||
965: ICX_CAT_UTIL_PVT.getTableElement(gIFLCSourceTypeTbl, p_index) || '; ';
966: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 966: FND_LOG.string(p_log_level, l_module_name, l_log_string);

962: FND_LOG.string(p_log_level, l_module_name, l_log_string);
963:
964: l_log_string := ' gIFLCSourceTypeTbl: ' ||
965: ICX_CAT_UTIL_PVT.getTableElement(gIFLCSourceTypeTbl, p_index) || '; ';
966: FND_LOG.string(p_log_level, l_module_name, l_log_string);
967:
968: l_log_string := ' gIFLCOrgIdTbl: ' ||
969: ICX_CAT_UTIL_PVT.getTableElement(gIFLCOrgIdTbl, p_index) || '; ';
970: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 970: FND_LOG.string(p_log_level, l_module_name, l_log_string);

966: FND_LOG.string(p_log_level, l_module_name, l_log_string);
967:
968: l_log_string := ' gIFLCOrgIdTbl: ' ||
969: ICX_CAT_UTIL_PVT.getTableElement(gIFLCOrgIdTbl, p_index) || '; ';
970: FND_LOG.string(p_log_level, l_module_name, l_log_string);
971:
972: l_log_string := ' gIFLCLanguageTbl: ' ||
973: ICX_CAT_UTIL_PVT.getTableElement(gIFLCLanguageTbl, p_index) || '; ';
974: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 974: FND_LOG.string(p_log_level, l_module_name, l_log_string);

970: FND_LOG.string(p_log_level, l_module_name, l_log_string);
971:
972: l_log_string := ' gIFLCLanguageTbl: ' ||
973: ICX_CAT_UTIL_PVT.getTableElement(gIFLCLanguageTbl, p_index) || '; ';
974: FND_LOG.string(p_log_level, l_module_name, l_log_string);
975:
976: END IF;
977:
978: l_err_loc := 2000;

Line 985: FND_LOG.string(p_log_level, l_module_name, l_log_string);

981: l_err_loc := 2100;
982: --INSERT icx_cat_fav_list_lines_tlp for other items
983: l_log_string := ' gIFLOFavoriteListIdTbl: ' ||
984: ICX_CAT_UTIL_PVT.getTableElement(gIFLOFavoriteListIdTbl, p_index) || '; ';
985: FND_LOG.string(p_log_level, l_module_name, l_log_string);
986:
987: l_log_string := ' gIFLONewFavoriteListLineIdTbl: ' ||
988: ICX_CAT_UTIL_PVT.getTableElement(gIFLONewFavoriteListLineIdTbl, p_index) || '; ';
989: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 989: FND_LOG.string(p_log_level, l_module_name, l_log_string);

985: FND_LOG.string(p_log_level, l_module_name, l_log_string);
986:
987: l_log_string := ' gIFLONewFavoriteListLineIdTbl: ' ||
988: ICX_CAT_UTIL_PVT.getTableElement(gIFLONewFavoriteListLineIdTbl, p_index) || '; ';
989: FND_LOG.string(p_log_level, l_module_name, l_log_string);
990:
991: l_log_string := ' gIFLOOldFavoriteListLineIdTbl: ' ||
992: ICX_CAT_UTIL_PVT.getTableElement(gIFLOOldFavoriteListLineIdTbl, p_index) || '; ';
993: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 993: FND_LOG.string(p_log_level, l_module_name, l_log_string);

989: FND_LOG.string(p_log_level, l_module_name, l_log_string);
990:
991: l_log_string := ' gIFLOOldFavoriteListLineIdTbl: ' ||
992: ICX_CAT_UTIL_PVT.getTableElement(gIFLOOldFavoriteListLineIdTbl, p_index) || '; ';
993: FND_LOG.string(p_log_level, l_module_name, l_log_string);
994:
995: l_log_string := ' gIFLOOrgIdTbl: ' ||
996: ICX_CAT_UTIL_PVT.getTableElement(gIFLOOrgIdTbl, p_index) || '; ';
997: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 997: FND_LOG.string(p_log_level, l_module_name, l_log_string);

993: FND_LOG.string(p_log_level, l_module_name, l_log_string);
994:
995: l_log_string := ' gIFLOOrgIdTbl: ' ||
996: ICX_CAT_UTIL_PVT.getTableElement(gIFLOOrgIdTbl, p_index) || '; ';
997: FND_LOG.string(p_log_level, l_module_name, l_log_string);
998:
999: l_log_string := ' gIFLOLanguageTbl: ' ||
1000: ICX_CAT_UTIL_PVT.getTableElement(gIFLOLanguageTbl, p_index) || '; ';
1001: FND_LOG.string(p_log_level, l_module_name, l_log_string);

Line 1001: FND_LOG.string(p_log_level, l_module_name, l_log_string);

997: FND_LOG.string(p_log_level, l_module_name, l_log_string);
998:
999: l_log_string := ' gIFLOLanguageTbl: ' ||
1000: ICX_CAT_UTIL_PVT.getTableElement(gIFLOLanguageTbl, p_index) || '; ';
1001: FND_LOG.string(p_log_level, l_module_name, l_log_string);
1002:
1003: END IF;
1004:
1005: l_err_loc := 2200;

Line 1372: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1368:
1369: l_err_loc := 110;
1370: IF (p_mode = 'OUTLOOP' OR g_total_row_count >= ICX_CAT_UTIL_PVT.g_batch_size) THEN
1371: l_err_loc := 120;
1372: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1374: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1375: 'Enter populatePOInterfaceTables(' || p_mode || ')g_total_row_count : ' ||
1376: g_total_row_count);

Line 1373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1369: l_err_loc := 110;
1370: IF (p_mode = 'OUTLOOP' OR g_total_row_count >= ICX_CAT_UTIL_PVT.g_batch_size) THEN
1371: l_err_loc := 120;
1372: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1374: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1375: 'Enter populatePOInterfaceTables(' || p_mode || ')g_total_row_count : ' ||
1376: g_total_row_count);
1377: END IF;

Line 1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1402:
1403: l_err_loc := 140;
1404: IF (gIHInterfaceHeaderIdTbl.COUNT > 0) THEN
1405: l_err_loc := 150;
1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1408: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1409: 'No: of rows inserted into po_headers_interface:' ||SQL%ROWCOUNT);
1410: END IF;

Line 1407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1403: l_err_loc := 140;
1404: IF (gIHInterfaceHeaderIdTbl.COUNT > 0) THEN
1405: l_err_loc := 150;
1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1408: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1409: 'No: of rows inserted into po_headers_interface:' ||SQL%ROWCOUNT);
1410: END IF;
1411: END IF;

Line 1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1427: gILVendorProductNumTbl(i), gILSupplierPartAuxidTbl(i), gILItemDescripionTbl(i), gILCatalogNameTbl(i));
1428:
1429: l_err_loc := 180;
1430: IF (gILInterfaceHeaderIdTbl.COUNT > 0) THEN
1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1433: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1434: 'No: of rows inserted into po_lines_interface:' ||SQL%ROWCOUNT);
1435: END IF;

Line 1432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1428:
1429: l_err_loc := 180;
1430: IF (gILInterfaceHeaderIdTbl.COUNT > 0) THEN
1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1433: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1434: 'No: of rows inserted into po_lines_interface:' ||SQL%ROWCOUNT);
1435: END IF;
1436: END IF;

Line 1667: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1663: AND baseAtt.language = gIAVLanguageTbl(i);
1664:
1665: l_err_loc := 210;
1666: IF (gIAVInterfaceHeaderIdTbl.COUNT > 0) THEN
1667: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1668: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1669: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1670: 'No: of rows inserted into po_attr_values_interface:' ||SQL%ROWCOUNT);
1671: END IF;

Line 1668: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1664:
1665: l_err_loc := 210;
1666: IF (gIAVInterfaceHeaderIdTbl.COUNT > 0) THEN
1667: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1668: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1669: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1670: 'No: of rows inserted into po_attr_values_interface:' ||SQL%ROWCOUNT);
1671: END IF;
1672: END IF;

Line 1802: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1798: AND baseAtt.language = gIAVTLanguageTbl(i);
1799:
1800: l_err_loc := 240;
1801: IF (gIAVTInterfaceHeaderIdTbl.COUNT > 0) THEN
1802: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1804: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1805: 'No: of rows inserted into po_attr_values_tlp_interface:' ||SQL%ROWCOUNT);
1806: END IF;

Line 1803: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1799:
1800: l_err_loc := 240;
1801: IF (gIAVTInterfaceHeaderIdTbl.COUNT > 0) THEN
1802: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1804: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1805: 'No: of rows inserted into po_attr_values_tlp_interface:' ||SQL%ROWCOUNT);
1806: END IF;
1807: END IF;

Line 1839: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1835: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
1836:
1837: l_err_loc := 270;
1838: IF (gIRURtItemIdTbl.COUNT > 0) THEN
1839: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1841: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1842: 'No: of rows inserted into icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
1843: END IF;

Line 1840: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1836:
1837: l_err_loc := 270;
1838: IF (gIRURtItemIdTbl.COUNT > 0) THEN
1839: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1841: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1842: 'No: of rows inserted into icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
1843: END IF;
1844: END IF;

Line 1875: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1871: AND rt_item_id = gURURtItemIdTbl(i);
1872:
1873: l_err_loc := 300;
1874: IF (gURURtItemIdTbl.COUNT > 0) THEN
1875: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1877: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1878: 'No: of rows updated in icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
1879: END IF;

Line 1876: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1872:
1873: l_err_loc := 300;
1874: IF (gURURtItemIdTbl.COUNT > 0) THEN
1875: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1877: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1878: 'No: of rows updated in icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
1879: END IF;
1880: END IF;

Line 1895: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1891: AND po_interface_line_id = gDRUPoInterfaceLineIdTbl(i);
1892:
1893: l_err_loc := 330;
1894: IF (gDRURtItemIdTbl.COUNT > 0) THEN
1895: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1896: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1897: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1898: 'No: of rows deleted from icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
1899: END IF;

Line 1896: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1892:
1893: l_err_loc := 330;
1894: IF (gDRURtItemIdTbl.COUNT > 0) THEN
1895: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1896: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1897: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1898: 'No: of rows deleted from icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
1899: END IF;
1900: END IF;

Line 1936: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1932: AND favorite_list_id = gIFLCFavoriteListIdTbl(i);
1933:
1934: l_err_loc := 360;
1935: IF (gIFLCFavoriteListIdTbl.COUNT > 0) THEN
1936: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1938: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1939: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for catalog items:' ||SQL%ROWCOUNT);
1940: END IF;

Line 1937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1933:
1934: l_err_loc := 360;
1935: IF (gIFLCFavoriteListIdTbl.COUNT > 0) THEN
1936: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1938: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1939: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for catalog items:' ||SQL%ROWCOUNT);
1940: END IF;
1941: END IF;

Line 2020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2016: AND fsp.set_of_books_id = gsob.set_of_books_id;
2017:
2018: l_err_loc := 390;
2019: IF (gIFLOFavoriteListIdTbl.COUNT > 0) THEN
2020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2022: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2023: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for other items:' ||SQL%ROWCOUNT);
2024: END IF;

Line 2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2017:
2018: l_err_loc := 390;
2019: IF (gIFLOFavoriteListIdTbl.COUNT > 0) THEN
2020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2022: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2023: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for other items:' ||SQL%ROWCOUNT);
2024: END IF;
2025: END IF;

Line 2032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2028: clearTables(l_action_mode);
2029:
2030: l_err_loc := 440;
2031: COMMIT;
2032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2034: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2035: 'Commit done.');
2036: END IF;

Line 2033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2029:
2030: l_err_loc := 440;
2031: COMMIT;
2032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2034: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2035: 'Commit done.');
2036: END IF;
2037:

Line 2041: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);

2037:
2038: END IF; --(p_mode = 'OUTLOOP' OR g_total_row_count >= ICX_CAT_UTIL_PVT.g_batch_size)
2039: EXCEPTION
2040: WHEN OTHERS THEN
2041: logPLSQLTableRow(l_api_name, FND_LOG.LEVEL_UNEXPECTED, SQL%ROWCOUNT+1, l_action_mode);
2042: ICX_CAT_UTIL_PVT.logUnexpectedException(
2043: G_PKG_NAME, l_api_name,
2044: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2045: RAISE;

Line 2201: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2197: BEGIN
2198: l_err_loc := 100;
2199: l_start_date := sysdate;
2200:
2201: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2202: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2203: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2204: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
2205: END IF;

Line 2202: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2198: l_err_loc := 100;
2199: l_start_date := sysdate;
2200:
2201: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2202: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2203: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2204: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
2205: END IF;
2206:

Line 2226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2222: FETCH l_blanketAndQuoteHdr_csr BULK COLLECT INTO
2223: l_po_header_id_tbl, l_price_type_tbl, l_org_id_tbl
2224: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2225:
2226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2228: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2229: 'Total no: of blankets and quotes headers fetched from the cursor:' ||
2230: l_po_header_id_tbl.COUNT);

Line 2227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2223: l_po_header_id_tbl, l_price_type_tbl, l_org_id_tbl
2224: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2225:
2226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2228: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2229: 'Total no: of blankets and quotes headers fetched from the cursor:' ||
2230: l_po_header_id_tbl.COUNT);
2231: END IF;

Line 2303: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2299: CLOSE l_blanketAndQuoteHdr_csr;
2300: END IF;
2301:
2302: l_err_loc := 380;
2303: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2304: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2305: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2306: 'processBlanketsAndQuotes Headers done; '||
2307: 'Total no: of batches processed:' || l_batch_count ||

Line 2304: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2300: END IF;
2301:
2302: l_err_loc := 380;
2303: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2304: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2305: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2306: 'processBlanketsAndQuotes Headers done; '||
2307: 'Total no: of batches processed:' || l_batch_count ||
2308: ', Total no: of blankets and quotes headers processed:' || l_ext_row_count);

Line 2345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2341: l_catalog_name_tbl, l_primary_category_id_tbl,
2342: l_attr_val_tlp_action_tbl
2343: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2344:
2345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2348: 'Total no: of blankets and quotes lines fetched from the cursor:' ||
2349: l_po_line_id_tbl.COUNT);

Line 2346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2342: l_attr_val_tlp_action_tbl
2343: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2344:
2345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2348: 'Total no: of blankets and quotes lines fetched from the cursor:' ||
2349: l_po_line_id_tbl.COUNT);
2350: END IF;

Line 2458: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2454: CLOSE l_blanketAndQuoteLine_csr;
2455: END IF;
2456:
2457: l_err_loc := 380;
2458: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2460: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2461: 'done. '||
2462: 'Total no: of batches processed:' || l_batch_count ||

Line 2459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2455: END IF;
2456:
2457: l_err_loc := 380;
2458: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2460: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2461: 'done. '||
2462: 'Total no: of batches processed:' || l_batch_count ||
2463: ', Total no: of blankets and quotes lines processed:' || l_ext_row_count);

Line 2467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2463: ', Total no: of blankets and quotes lines processed:' || l_ext_row_count);
2464: END IF;
2465:
2466: l_end_date := sysdate;
2467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2468: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2469: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2470: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
2471: END IF;

Line 2468: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2464: END IF;
2465:
2466: l_end_date := sysdate;
2467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2468: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2469: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2470: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
2471: END IF;
2472: EXCEPTION

Line 2628: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2624: BEGIN
2625: l_err_loc := 100;
2626: l_start_date := sysdate;
2627:
2628: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2629: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2630: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2631: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
2632: END IF;

Line 2629: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2625: l_err_loc := 100;
2626: l_start_date := sysdate;
2627:
2628: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2629: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2630: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2631: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
2632: END IF;
2633:

Line 2653: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2649: l_req_template_name_tbl, l_org_id_tbl
2650: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2651:
2652: l_err_loc := 410;
2653: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2654: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2655: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2656: 'Total no: of Req Templates headers fetched from the cursor:' ||
2657: l_req_template_name_tbl.COUNT);

Line 2654: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2650: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2651:
2652: l_err_loc := 410;
2653: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2654: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2655: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2656: 'Total no: of Req Templates headers fetched from the cursor:' ||
2657: l_req_template_name_tbl.COUNT);
2658: END IF;

Line 2730: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2726: CLOSE l_reqTemplateHdr_csr;
2727: END IF;
2728:
2729: l_err_loc := 1800;
2730: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2731: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2732: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2733: 'processReqTemplates Headers done; ' ||
2734: 'Total no: of batches processed:' || l_batch_count ||

Line 2731: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2727: END IF;
2728:
2729: l_err_loc := 1800;
2730: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2731: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2732: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2733: 'processReqTemplates Headers done; ' ||
2734: 'Total no: of batches processed:' || l_batch_count ||
2735: ', Total no: of Req Templates headers processed:' || l_ext_row_count);

Line 2771: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2767: l_catalog_name_tbl, l_primary_category_id_tbl,
2768: l_attr_val_tlp_action_tbl
2769: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2770:
2771: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2772: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2773: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2774: 'Total no: of Req Templates lines fetched from the cursor:' ||
2775: l_rt_item_id_tbl.COUNT);

Line 2772: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2768: l_attr_val_tlp_action_tbl
2769: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
2770:
2771: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2772: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2773: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2774: 'Total no: of Req Templates lines fetched from the cursor:' ||
2775: l_rt_item_id_tbl.COUNT);
2776: END IF;

Line 2888: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2884: CLOSE l_reqTemplateLine_csr;
2885: END IF;
2886:
2887: l_err_loc := 3900;
2888: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2889: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2890: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2891: 'done. ' ||
2892: 'Total no: of batches processed:' || l_batch_count ||

Line 2889: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2885: END IF;
2886:
2887: l_err_loc := 3900;
2888: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2889: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2890: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2891: 'done. ' ||
2892: 'Total no: of batches processed:' || l_batch_count ||
2893: ', Total no: of Req Templates lines processed:' || l_ext_row_count);

Line 2897: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2893: ', Total no: of Req Templates lines processed:' || l_ext_row_count);
2894: END IF;
2895:
2896: l_end_date := sysdate;
2897: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2898: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2899: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2900: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
2901: END IF;

Line 2898: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2894: END IF;
2895:
2896: l_end_date := sysdate;
2897: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2898: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2899: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2900: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
2901: END IF;
2902: EXCEPTION

Line 3062: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3058: BEGIN
3059: l_err_loc := 100;
3060:
3061: l_err_loc := 110;
3062: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3063: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3064: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3065: 'Start =======');
3066: END IF;

Line 3063: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3059: l_err_loc := 100;
3060:
3061: l_err_loc := 110;
3062: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3063: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3064: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3065: 'Start =======');
3066: END IF;
3067:

Line 3082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3078: l_err_loc := 140;
3079: CLOSE l_contractAutoSourcing_csr;
3080:
3081: l_err_loc := 150;
3082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3084: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3085: 'Total no: of distinct contract auto source attributes found:' || l_org_id_tbl.COUNT);
3086: END IF;

Line 3083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3079: CLOSE l_contractAutoSourcing_csr;
3080:
3081: l_err_loc := 150;
3082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3084: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3085: 'Total no: of distinct contract auto source attributes found:' || l_org_id_tbl.COUNT);
3086: END IF;
3087:

Line 3107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3103: l_err_loc := 220;
3104: -- Try to find a suitable source document for the given attributes
3105: l_supplier_site_id := l_supplier_site_id_tbl(i);
3106:
3107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3108: l_start_date := sysdate;
3109: l_log_string := 'About to call po_autosource_sv.autosource at:' ||
3110: TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
3111: '; Parameter passed: l_currency_tbl:' || l_currency_tbl(i) ||

Line 3116: FND_LOG.string(FND_LOG.LEVEL_EVENT,

3112: ', l_supplier_id_tbl:' || l_supplier_id_tbl(i) ||
3113: ', l_supplier_site_id:' || l_supplier_site_id ||
3114: ', l_org_id_tbl:' || l_org_id_tbl(i) ||
3115: ', l_po_category_id_tbl:' || l_po_category_id_tbl(i) ;
3116: FND_LOG.string(FND_LOG.LEVEL_EVENT,
3117: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3118: l_log_string);
3119: END IF;
3120:

Line 3146: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3142: x_purchasing_uom => l_purchasing_uom);
3143:
3144: l_err_loc := 230;
3145:
3146: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: l_end_date := sysdate;
3148: l_log_string := ' done in:' ||
3149: ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
3150: '; Values returned: l_document_header_id:' || l_document_header_id ||

Line 3157: FND_LOG.string(FND_LOG.LEVEL_EVENT,

3153: ', l_document_line_id:' || l_document_line_id ||
3154: ', l_document_line_num:' || l_document_line_num ||
3155: ', l_vendor_product_num:' || l_vendor_product_num ||
3156: ', l_purchasing_uom:' || l_purchasing_uom ;
3157: FND_LOG.string(FND_LOG.LEVEL_EVENT,
3158: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3159: l_log_string);
3160: END IF;
3161:

Line 3192: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3188: EXECUTE IMMEDIATE
3189: 'TRUNCATE TABLE '|| l_icx_schema_name ||'.icx_cat_r12_upg_autosource';
3190:
3191: l_err_loc := 295;
3192: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3193: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3194: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3195: 'truncate table icx_cat_r12_upg_autosource done:');
3196: END IF;

Line 3193: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3189: 'TRUNCATE TABLE '|| l_icx_schema_name ||'.icx_cat_r12_upg_autosource';
3190:
3191: l_err_loc := 295;
3192: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3193: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3194: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3195: 'truncate table icx_cat_r12_upg_autosource done:');
3196: END IF;
3197:

Line 3219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3215: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
3216: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3217: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3218:
3219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3220: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3221: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3222: 'No: of rows inserted in autosource:' || SQL%ROWCOUNT);
3223: END IF;

Line 3220: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3216: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3217: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id);
3218:
3219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3220: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3221: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3222: 'No: of rows inserted in autosource:' || SQL%ROWCOUNT);
3223: END IF;
3224:

Line 3237: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3233: l_as_contract_id_tbl.DELETE;
3234: l_as_po_category_id_tbl.DELETE;
3235:
3236: l_err_loc := 320;
3237: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3239: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3240: 'done.');
3241: END IF;

Line 3238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3234: l_as_po_category_id_tbl.DELETE;
3235:
3236: l_err_loc := 320;
3237: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3239: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3240: 'done.');
3241: END IF;
3242:

Line 3372: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3368: BEGIN
3369: l_err_loc := 100;
3370: l_start_date := sysdate;
3371:
3372: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3373: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
3374: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
3375: END IF;
3376:

Line 3382: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3378: l_start_rt_item_id := 0;
3379: l_batch_count := 0;
3380: l_item_row_count := 0;
3381:
3382: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3383: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3384: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3385: 'Current Values in g_current_gbpa_hdr_rec:'||
3386: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||

Line 3383: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3379: l_batch_count := 0;
3380: l_item_row_count := 0;
3381:
3382: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3383: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3384: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3385: 'Current Values in g_current_gbpa_hdr_rec:'||
3386: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||
3387: ', supplier_id:' ||g_current_gbpa_hdr_rec.vendor_id ||

Line 3446: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3442:
3443: l_err_loc := 200;
3444: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
3445: l_log_index := i;
3446: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3447: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3448: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3449: 'Values fetched from the cursor; '||
3450: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||

Line 3447: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3443: l_err_loc := 200;
3444: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
3445: l_log_index := i;
3446: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3447: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3448: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3449: 'Values fetched from the cursor; '||
3450: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||
3451: ', l_supp_part_num_tbl:' || l_supp_part_num_tbl(i) ||

Line 3465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3461: IF (l_interface_header_id IS NULL) THEN
3462: --Create the header record only once for the
3463: --current combination of header attributes
3464: l_interface_header_id := getNextInterfaceHdrIdFromSeq;
3465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3466: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3467: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3468: 'about to create a new po_header_id with the following values' ||
3469: '--> l_interface_header_id set to :' || l_interface_header_id ||

Line 3466: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

3462: --Create the header record only once for the
3463: --current combination of header attributes
3464: l_interface_header_id := getNextInterfaceHdrIdFromSeq;
3465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3466: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3467: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3468: 'about to create a new po_header_id with the following values' ||
3469: '--> l_interface_header_id set to :' || l_interface_header_id ||
3470: ', org_id:' || g_current_gbpa_hdr_rec.org_id ||

Line 3572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3568: g_r12_upg_rec.created_language := g_current_gbpa_hdr_rec.language;
3569: -- TBD g_r12_upg_rec.extractor_updated_flag := 'N';
3570:
3571: l_err_loc := 289;
3572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3574: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3575: 'inserting into lines, attr_values and r12 upgrade');
3576: END IF;

Line 3573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3569: -- TBD g_r12_upg_rec.extractor_updated_flag := 'N';
3570:
3571: l_err_loc := 289;
3572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3574: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3575: 'inserting into lines, attr_values and r12 upgrade');
3576: END IF;
3577: l_err_loc := 290;

Line 3608: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3604: g_po_attrvalstlp_int_rec.check_desc_update := ICX_CAT_UTIL_PVT.g_update_description;
3605: g_po_attrvalstlp_int_rec.rt_item_id := l_rt_item_id_tbl(i);
3606:
3607: l_err_loc := 298;
3608: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3609: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3610: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3611: 'inserting only into attr_values_tlp');
3612: END IF;

Line 3609: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3605: g_po_attrvalstlp_int_rec.rt_item_id := l_rt_item_id_tbl(i);
3606:
3607: l_err_loc := 298;
3608: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3609: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3610: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3611: 'inserting only into attr_values_tlp');
3612: END IF;
3613: l_err_loc := 299;

Line 3652: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3648:
3649: l_err_loc := 360;
3650: g_total_bulkld_row_count := g_total_bulkld_row_count + l_item_row_count;
3651:
3652: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3653: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3654: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3655: 'done; '||
3656: 'Total no: of batches processed:' || l_batch_count ||

Line 3653: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

3649: l_err_loc := 360;
3650: g_total_bulkld_row_count := g_total_bulkld_row_count + l_item_row_count;
3651:
3652: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3653: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3654: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3655: 'done; '||
3656: 'Total no: of batches processed:' || l_batch_count ||
3657: ', Total no: of bulkloaded items processed:' || l_item_row_count);

Line 3661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3657: ', Total no: of bulkloaded items processed:' || l_item_row_count);
3658: END IF;
3659:
3660: l_end_date := sysdate;
3661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3662: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
3663: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
3664: END IF;
3665: EXCEPTION

Line 3671: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3667: ICX_CAT_UTIL_PVT.logUnexpectedException(
3668: G_PKG_NAME, l_api_name,
3669: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
3670:
3671: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3672: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3673: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3674: 'Current Values in g_current_gbpa_hdr_rec:'||
3675: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||

Line 3672: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

3668: G_PKG_NAME, l_api_name,
3669: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
3670:
3671: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3672: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3673: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3674: 'Current Values in g_current_gbpa_hdr_rec:'||
3675: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||
3676: ', supplier_id:' ||g_current_gbpa_hdr_rec.vendor_id ||

Line 3684: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3680: ', language:' ||g_current_gbpa_hdr_rec.language ||
3681: ', interface_header_id:' ||g_current_gbpa_hdr_rec.interface_header_id );
3682: END IF;
3683:
3684: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3685: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3686: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3687: 'Values fetched from the cursor; '||
3688: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(l_log_index) ||

Line 3685: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

3681: ', interface_header_id:' ||g_current_gbpa_hdr_rec.interface_header_id );
3682: END IF;
3683:
3684: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3685: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3686: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3687: 'Values fetched from the cursor; '||
3688: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(l_log_index) ||
3689: ', l_supp_part_num_tbl:' || l_supp_part_num_tbl(l_log_index) ||

Line 3702: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3698: ', l_upg_created_language_tbl:' || l_upg_created_language_tbl(l_log_index) ||
3699: ', l_po_interface_line_id_tbl:' || l_po_interface_line_id_tbl(l_log_index));
3700: END IF;
3701:
3702: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3703: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3704: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3705: 'Values fetched from the cursor; '||
3706: 'l_description_tbl:' || l_description_tbl(l_log_index) ||

Line 3703: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

3699: ', l_po_interface_line_id_tbl:' || l_po_interface_line_id_tbl(l_log_index));
3700: END IF;
3701:
3702: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3703: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
3704: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3705: 'Values fetched from the cursor; '||
3706: 'l_description_tbl:' || l_description_tbl(l_log_index) ||
3707: ', l_catalog_name_tbl:' || l_catalog_name_tbl(l_log_index) ||

Line 3814: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3810: BEGIN
3811: l_err_loc := 100;
3812: l_start_date := sysdate;
3813:
3814: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3815: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
3816: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
3817: END IF;
3818:

Line 3824: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3820: l_start_rt_item_id := 0;
3821: l_batch_count := 0;
3822: l_item_row_count := 0;
3823:
3824: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3825: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3826: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3827: 'Current Values in g_current_gbpa_hdr_rec:'||
3828: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||

Line 3825: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3821: l_batch_count := 0;
3822: l_item_row_count := 0;
3823:
3824: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3825: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3826: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3827: 'Current Values in g_current_gbpa_hdr_rec:'||
3828: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||
3829: ', supplier_id:' ||g_current_gbpa_hdr_rec.vendor_id ||

Line 3886: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3882:
3883: l_err_loc := 200;
3884: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
3885: l_log_index := i;
3886: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3887: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3888: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3889: 'Values fetched from the cursor; '||
3890: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||

Line 3887: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3883: l_err_loc := 200;
3884: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
3885: l_log_index := i;
3886: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3887: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3888: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3889: 'Values fetched from the cursor; '||
3890: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||
3891: ', l_supp_part_num_tbl:' || l_supp_part_num_tbl(i) ||

Line 3975: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3971: g_r12_upg_rec.created_language := g_current_gbpa_hdr_rec.language;
3972: -- TBD g_r12_upg_rec.extractor_updated_flag := 'N';
3973:
3974: l_err_loc := 254;
3975: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3977: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3978: 'inserting into lines, attr_values, attr_values_tlp and r12 upgrade');
3979: END IF;

Line 3976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3972: -- TBD g_r12_upg_rec.extractor_updated_flag := 'N';
3973:
3974: l_err_loc := 254;
3975: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3977: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
3978: 'inserting into lines, attr_values, attr_values_tlp and r12 upgrade');
3979: END IF;
3980: --Add the current value to the global pl/sql tables

Line 4025: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4021:
4022: l_err_loc := 360;
4023: g_total_bulkld_row_count := g_total_bulkld_row_count + l_item_row_count;
4024:
4025: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4026: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4027: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4028: 'done; '||
4029: 'Total no: of batches processed:' ||l_batch_count ||

Line 4026: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4022: l_err_loc := 360;
4023: g_total_bulkld_row_count := g_total_bulkld_row_count + l_item_row_count;
4024:
4025: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4026: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4027: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4028: 'done; '||
4029: 'Total no: of batches processed:' ||l_batch_count ||
4030: ', Total no: of bulkloaded items processed:' ||l_item_row_count);

Line 4034: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4030: ', Total no: of bulkloaded items processed:' ||l_item_row_count);
4031: END IF;
4032:
4033: l_end_date := sysdate;
4034: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4035: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
4036: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
4037: END IF;
4038:

Line 4045: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4041: ICX_CAT_UTIL_PVT.logUnexpectedException(
4042: G_PKG_NAME, l_api_name,
4043: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
4044:
4045: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4046: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4047: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4048: 'Current Values in g_current_gbpa_hdr_rec:'||
4049: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||

Line 4046: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4042: G_PKG_NAME, l_api_name,
4043: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
4044:
4045: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4046: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4047: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4048: 'Current Values in g_current_gbpa_hdr_rec:'||
4049: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||
4050: ', supplier_id:' ||g_current_gbpa_hdr_rec.vendor_id ||

Line 4058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4054: ', language:' ||g_current_gbpa_hdr_rec.language ||
4055: ', interface_header_id:' ||g_current_gbpa_hdr_rec.interface_header_id );
4056: END IF;
4057:
4058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4060: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4061: 'Values fetched from the cursor; '||
4062: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(l_log_index) ||

Line 4059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4055: ', interface_header_id:' ||g_current_gbpa_hdr_rec.interface_header_id );
4056: END IF;
4057:
4058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4060: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4061: 'Values fetched from the cursor; '||
4062: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(l_log_index) ||
4063: ', l_supp_part_num_tbl:' || l_supp_part_num_tbl(l_log_index) ||

Line 4073: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4069: ', l_po_category_id_tbl:' || l_po_category_id_tbl(l_log_index) ||
4070: ', l_price_type_tbl:' || l_price_type_tbl(l_log_index) );
4071: END IF;
4072:
4073: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4074: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4075: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4076: 'Values fetched from the cursor; '||
4077: 'l_description_tbl:' || l_description_tbl(l_log_index) ||

Line 4074: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4070: ', l_price_type_tbl:' || l_price_type_tbl(l_log_index) );
4071: END IF;
4072:
4073: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4074: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4075: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4076: 'Values fetched from the cursor; '||
4077: 'l_description_tbl:' || l_description_tbl(l_log_index) ||
4078: ', l_catalog_name_tbl:' || l_catalog_name_tbl(l_log_index) ||

Line 4169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4165: BEGIN
4166: l_err_loc := 100;
4167: l_start_date := sysdate;
4168:
4169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4171: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4172: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
4173: END IF;

Line 4170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4166: l_err_loc := 100;
4167: l_start_date := sysdate;
4168:
4169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4171: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4172: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
4173: END IF;
4174:

Line 4199: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4195: l_currency_tbl, l_gbpa_cpa_reference_tbl,
4196: l_language_tbl, l_count_tbl;
4197:
4198: l_err_loc := 130;
4199: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4200: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4201: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4202: 'Total no: of distinct GBPA headers attributes found:' || l_org_id_tbl.COUNT);
4203: END IF;

Line 4200: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4196: l_language_tbl, l_count_tbl;
4197:
4198: l_err_loc := 130;
4199: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4200: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4201: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4202: 'Total no: of distinct GBPA headers attributes found:' || l_org_id_tbl.COUNT);
4203: END IF;
4204:

Line 4222: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4218: g_current_gbpa_hdr_rec.upg_created_language := null;
4219: g_current_gbpa_hdr_rec.upg_cpa_reference := null;
4220:
4221: l_err_loc := 154;
4222: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4223: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4224: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4225: 'Previous Values:'||
4226: ', l_prev_org_id:' ||l_prev_org_id ||

Line 4223: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

4219: g_current_gbpa_hdr_rec.upg_cpa_reference := null;
4220:
4221: l_err_loc := 154;
4222: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4223: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4224: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4225: 'Previous Values:'||
4226: ', l_prev_org_id:' ||l_prev_org_id ||
4227: ', l_prev_supplier_id:' ||l_prev_supplier_id ||

Line 4295: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4291: CLOSE createGBPAHdrsForBlkldItemsCsr;
4292:
4293: l_err_loc := 250;
4294: l_end_date := sysdate;
4295: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4296: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4297: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4298: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
4299: '; Total no: of GBPA headers created:' || g_GBPA_hdr_count ||

Line 4296: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4292:
4293: l_err_loc := 250;
4294: l_end_date := sysdate;
4295: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4296: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4297: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4298: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
4299: '; Total no: of GBPA headers created:' || g_GBPA_hdr_count ||
4300: ', Total no: of bulkload items processed:' || g_total_bulkld_row_count);

Line 4516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4512: l_item_row_count := 0;
4513: l_start_date := sysdate;
4514:
4515: l_err_loc := 110;
4516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4517: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
4518: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
4519: END IF;
4520:

Line 4564: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4560: l_primary_category_name_tbl
4561: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
4562:
4563: l_err_loc := 150;
4564: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4565: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4566: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4567: 'Total no: of records fetced from the cursor:' || l_rt_item_id_tbl.COUNT);
4568: END IF;

Line 4565: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4561: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
4562:
4563: l_err_loc := 150;
4564: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4565: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4566: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4567: 'Total no: of records fetced from the cursor:' || l_rt_item_id_tbl.COUNT);
4568: END IF;
4569:

Line 4587: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4583:
4584: l_err_loc := 200;
4585: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
4586: l_log_index := i;
4587: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4588: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4589: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4590: 'Values fetched from the cursor; '||
4591: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||

Line 4588: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

4584: l_err_loc := 200;
4585: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
4586: l_log_index := i;
4587: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4588: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4589: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4590: 'Values fetched from the cursor; '||
4591: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||
4592: ', l_supp_part_num_tbl:' || l_supp_part_num_tbl(i) ||

Line 4681: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4677: g_current_gbpa_hdr_rec.cpa_reference,
4678: g_current_gbpa_hdr_rec.language);
4679:
4680: l_err_loc := 220;
4681: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4683: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4684: 'l_po_header_id returned from ' ||
4685: 'getGBPAHeaderId(orgId=>' || g_current_gbpa_hdr_rec.org_id ||

Line 4682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4678: g_current_gbpa_hdr_rec.language);
4679:
4680: l_err_loc := 220;
4681: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4683: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4684: 'l_po_header_id returned from ' ||
4685: 'getGBPAHeaderId(orgId=>' || g_current_gbpa_hdr_rec.org_id ||
4686: ', suppId=>' || g_current_gbpa_hdr_rec.vendor_id ||

Line 4721: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4717: l_err_loc := 227;
4718: g_GBPA_hdr_count := g_GBPA_hdr_count + 1;
4719:
4720: l_err_loc := 228;
4721: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4722: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4723: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4724: 'inserting into headers_interface; total_hdr_count:' ||g_GBPA_hdr_count ||
4725: ', g_po_hdrs_int_rec.action:' || g_po_hdrs_int_rec.action ||

Line 4722: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4718: g_GBPA_hdr_count := g_GBPA_hdr_count + 1;
4719:
4720: l_err_loc := 228;
4721: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4722: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4723: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4724: 'inserting into headers_interface; total_hdr_count:' ||g_GBPA_hdr_count ||
4725: ', g_po_hdrs_int_rec.action:' || g_po_hdrs_int_rec.action ||
4726: ', g_po_hdrs_int_rec.po_header_id:' || g_po_hdrs_int_rec.po_header_id ||

Line 4772: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4768: g_po_hdrs_int_rec.created_language := null;
4769: g_po_hdrs_int_rec.comments := null;
4770:
4771: l_err_loc := 234;
4772: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4773: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4774: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4775: 'inserting into headers interface for delete of lines'||
4776: ', l_del_interface_header_id:' || l_del_interface_header_id ||

Line 4773: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4769: g_po_hdrs_int_rec.comments := null;
4770:
4771: l_err_loc := 234;
4772: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4773: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4774: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4775: 'inserting into headers interface for delete of lines'||
4776: ', l_del_interface_header_id:' || l_del_interface_header_id ||
4777: ', g_po_hdrs_int_rec.action:' || g_po_hdrs_int_rec.action ||

Line 4812: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4808: g_po_line_attrval_int_rec.item_description := null;
4809: g_po_line_attrval_int_rec.catalog_name := null;
4810:
4811: l_err_loc := 240;
4812: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4813: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4814: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4815: 'inserting into lines interface with DELETE action' ||
4816: ', l_del_interface_line_id:' || l_del_interface_line_id ||

Line 4813: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4809: g_po_line_attrval_int_rec.catalog_name := null;
4810:
4811: l_err_loc := 240;
4812: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4813: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4814: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4815: 'inserting into lines interface with DELETE action' ||
4816: ', l_del_interface_line_id:' || l_del_interface_line_id ||
4817: ', po_line_id: ' || g_po_line_attrval_int_rec.po_line_id ||

Line 4898: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4894: g_r12_upg_rec.po_interface_line_id := l_interface_line_id;
4895: l_err_loc := 250;
4896: IF (l_createR12UpgradeRow) THEN
4897: g_r12_upg_rec.created_language := g_current_gbpa_hdr_rec.language;
4898: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4899: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4900: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4901: 'inserting into r12 upgrade');
4902: END IF;

Line 4899: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4895: l_err_loc := 250;
4896: IF (l_createR12UpgradeRow) THEN
4897: g_r12_upg_rec.created_language := g_current_gbpa_hdr_rec.language;
4898: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4899: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4900: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4901: 'inserting into r12 upgrade');
4902: END IF;
4903: insertR12Upgrade;

Line 4921: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4917: g_r12_upg_rec.created_language := l_created_language_tbl(i);
4918: END IF;
4919:
4920: l_err_loc := 256;
4921: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4922: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4923: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4924: 'updating r12 upgrade' ||
4925: ', old interface_header_id:' || g_current_gbpa_hdr_rec.interface_header_id ||

Line 4922: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4918: END IF;
4919:
4920: l_err_loc := 256;
4921: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4922: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4923: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4924: 'updating r12 upgrade' ||
4925: ', old interface_header_id:' || g_current_gbpa_hdr_rec.interface_header_id ||
4926: ', old interface_line_id: ' || l_po_interface_line_id_tbl(i) ||

Line 4985: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4981: g_po_line_attrval_int_rec.item_description := l_description_tbl(i);
4982: g_po_line_attrval_int_rec.catalog_name := l_catalog_name_tbl(i);
4983:
4984: l_err_loc := 270;
4985: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4986: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4987: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4988: 'inserting into lines and attr_values with action:' ||
4989: g_po_line_attrval_int_rec.action ||

Line 4986: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4982: g_po_line_attrval_int_rec.catalog_name := l_catalog_name_tbl(i);
4983:
4984: l_err_loc := 270;
4985: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4986: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4987: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4988: 'inserting into lines and attr_values with action:' ||
4989: g_po_line_attrval_int_rec.action ||
4990: ', l_rt_item_id_tbl(i): ' || l_rt_item_id_tbl(i) ||

Line 5026: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5022: g_po_attrvalstlp_int_rec.check_desc_update := ICX_CAT_UTIL_PVT.g_update_description;
5023: g_po_attrvalstlp_int_rec.rt_item_id := l_rt_item_id_tbl(i);
5024:
5025: l_err_loc := 290;
5026: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5027: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5028: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5029: 'inserting into attr_values_tlp with action:' || g_po_attrvalstlp_int_rec.action ||
5030: ', g_po_attrvalstlp_int_rec.po_line_id: ' || g_po_attrvalstlp_int_rec.po_line_id ||

Line 5027: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5023: g_po_attrvalstlp_int_rec.rt_item_id := l_rt_item_id_tbl(i);
5024:
5025: l_err_loc := 290;
5026: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5027: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5028: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5029: 'inserting into attr_values_tlp with action:' || g_po_attrvalstlp_int_rec.action ||
5030: ', g_po_attrvalstlp_int_rec.po_line_id: ' || g_po_attrvalstlp_int_rec.po_line_id ||
5031: ', g_current_gbpa_hdr_rec.language: ' || g_current_gbpa_hdr_rec.language ||

Line 5076: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5072:
5073: l_err_loc := 360;
5074: g_total_bulkld_row_count := g_total_bulkld_row_count + l_item_row_count;
5075:
5076: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5078: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5079: 'done; '||
5080: 'Total no: of batches processed:' ||l_batch_count ||

Line 5077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5073: l_err_loc := 360;
5074: g_total_bulkld_row_count := g_total_bulkld_row_count + l_item_row_count;
5075:
5076: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5078: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5079: 'done; '||
5080: 'Total no: of batches processed:' ||l_batch_count ||
5081: ', Total no: of bulkloaded items processed:' ||l_item_row_count);

Line 5085: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5081: ', Total no: of bulkloaded items processed:' ||l_item_row_count);
5082: END IF;
5083:
5084: l_end_date := sysdate;
5085: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5086: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
5087: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
5088: END IF;
5089: EXCEPTION

Line 5095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5091: ICX_CAT_UTIL_PVT.logUnexpectedException(
5092: G_PKG_NAME, l_api_name,
5093: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
5094:
5095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5098: 'Current Values in g_current_gbpa_hdr_rec:'||
5099: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||

Line 5096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5092: G_PKG_NAME, l_api_name,
5093: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
5094:
5095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5098: 'Current Values in g_current_gbpa_hdr_rec:'||
5099: ', org_id:' ||g_current_gbpa_hdr_rec.org_id ||
5100: ', supplier_id:' ||g_current_gbpa_hdr_rec.vendor_id ||

Line 5111: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5107: ', upg_created_language:' ||g_current_gbpa_hdr_rec.upg_created_language ||
5108: ', upg_cpa_reference:' ||g_current_gbpa_hdr_rec.upg_cpa_reference );
5109: END IF;
5110:
5111: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5112: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5113: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5114: 'Values fetched from the cursor; '||
5115: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(l_log_index) ||

Line 5112: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5108: ', upg_cpa_reference:' ||g_current_gbpa_hdr_rec.upg_cpa_reference );
5109: END IF;
5110:
5111: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5112: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5113: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5114: 'Values fetched from the cursor; '||
5115: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(l_log_index) ||
5116: ', l_supp_part_num_tbl:' || l_supp_part_num_tbl(l_log_index) ||

Line 5127: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5123: ', l_old_po_category_id_tbl:' || l_old_po_category_id_tbl(l_log_index) ||
5124: ', l_price_type_tbl:' || l_price_type_tbl(l_log_index) );
5125: END IF;
5126:
5127: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5128: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5129: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5130: 'Values fetched from the cursor; '||
5131: 'l_description_tbl:' || l_description_tbl(l_log_index) ||

Line 5128: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5124: ', l_price_type_tbl:' || l_price_type_tbl(l_log_index) );
5125: END IF;
5126:
5127: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5128: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5129: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5130: 'Values fetched from the cursor; '||
5131: 'l_description_tbl:' || l_description_tbl(l_log_index) ||
5132: ', l_catalog_name_tbl:' || l_catalog_name_tbl(l_log_index) ||

Line 5269: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5265: BEGIN
5266: l_err_loc := 100;
5267: l_start_date := sysdate;
5268:
5269: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5270: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5271: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5272: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
5273: END IF;

Line 5270: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5266: l_err_loc := 100;
5267: l_start_date := sysdate;
5268:
5269: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5270: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5271: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5272: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
5273: END IF;
5274: -- Perform the contract auto sourcing for delta

Line 5294: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5290: l_err_loc := 130;
5291: CLOSE checkUpdateInGBPAForDeltaCsr;
5292:
5293: l_err_loc := 140;
5294: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5295: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5296: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5297: 'Total no: of distinct GBPA headers attributes found:' || l_org_id_tbl.COUNT);
5298: END IF;

Line 5295: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5291: CLOSE checkUpdateInGBPAForDeltaCsr;
5292:
5293: l_err_loc := 140;
5294: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5295: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5296: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5297: 'Total no: of distinct GBPA headers attributes found:' || l_org_id_tbl.COUNT);
5298: END IF;
5299:

Line 5302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5298: END IF;
5299:
5300: l_err_loc := 150;
5301: FOR i in 1..l_org_id_tbl.COUNT LOOP
5302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5304: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5305: ' --> Values fetched from the cursor; '||
5306: 'l_org_id_tbl:' || l_org_id_tbl(i) ||

Line 5303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5299:
5300: l_err_loc := 150;
5301: FOR i in 1..l_org_id_tbl.COUNT LOOP
5302: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5304: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5305: ' --> Values fetched from the cursor; '||
5306: 'l_org_id_tbl:' || l_org_id_tbl(i) ||
5307: ', l_supplier_id_tbl:' || l_supplier_id_tbl(i) ||

Line 5338: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5334: END LOOP; --FOR LOOP of l_org_id_tbl
5335:
5336: l_err_loc := 180;
5337: l_end_date := sysdate;
5338: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5339: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5340: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5341: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
5342: '; Total no: of GBPA headers created:' || g_GBPA_hdr_count ||

Line 5339: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5335:
5336: l_err_loc := 180;
5337: l_end_date := sysdate;
5338: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5339: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5340: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5341: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
5342: '; Total no: of GBPA headers created:' || g_GBPA_hdr_count ||
5343: ', Total no: of bulkload items processed:' || g_total_bulkld_row_count);

Line 5406: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5402: BEGIN
5403: l_err_loc := 100;
5404: l_start_date := sysdate;
5405:
5406: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5408: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5409: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
5410: END IF;

Line 5407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5403: l_err_loc := 100;
5404: l_start_date := sysdate;
5405:
5406: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5408: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5409: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
5410: END IF;
5411: l_batch_count := 0;

Line 5436: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5432: l_po_interface_line_id_tbl, l_po_header_id_tbl,
5433: l_po_line_id_tbl, l_org_id_tbl
5434: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
5435:
5436: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5437: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5438: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5439: 'Total no: of records fetced from the cursor:' || l_rt_item_id_tbl.COUNT);
5440: END IF;

Line 5437: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5433: l_po_line_id_tbl, l_org_id_tbl
5434: LIMIT ICX_CAT_UTIL_PVT.g_batch_size ;
5435:
5436: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5437: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5438: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5439: 'Total no: of records fetced from the cursor:' || l_rt_item_id_tbl.COUNT);
5440: END IF;
5441:

Line 5453: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5449: l_item_row_count := l_item_row_count + l_rt_item_id_tbl.COUNT;
5450:
5451: l_err_loc := 200;
5452: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
5453: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5455: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5456: ' --> Values fetched from the cursor; '||
5457: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||

Line 5454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5450:
5451: l_err_loc := 200;
5452: FOR i in 1..l_rt_item_id_tbl.COUNT LOOP
5453: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5455: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5456: ' --> Values fetched from the cursor; '||
5457: 'l_rt_item_id_tbl:' || l_rt_item_id_tbl(i) ||
5458: ', l_po_interface_header_id_tbl:' || l_po_interface_header_id_tbl(i) ||

Line 5491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5487: g_po_hdrs_int_rec.cpa_reference := null;
5488: g_po_hdrs_int_rec.created_language := null;
5489: g_po_hdrs_int_rec.comments := null;
5490:
5491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5493: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5494: ' --> inserting into headers interface' ||
5495: ', g_po_hdrs_int_rec.po_header_id: ' || g_po_hdrs_int_rec.po_header_id ||

Line 5492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5488: g_po_hdrs_int_rec.created_language := null;
5489: g_po_hdrs_int_rec.comments := null;
5490:
5491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5493: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5494: ' --> inserting into headers interface' ||
5495: ', g_po_hdrs_int_rec.po_header_id: ' || g_po_hdrs_int_rec.po_header_id ||
5496: ', l_interface_header_id: ' || l_interface_header_id);

Line 5522: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5518: g_po_line_attrval_int_rec.supplier_part_auxid := null;
5519: g_po_line_attrval_int_rec.item_description := null;
5520: g_po_line_attrval_int_rec.catalog_name := null;
5521:
5522: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5524: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5525: ' --> inserting into lines interface' ||
5526: ', g_po_line_attrval_int_rec.po_header_id: ' || g_po_line_attrval_int_rec.po_header_id ||

Line 5523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5519: g_po_line_attrval_int_rec.item_description := null;
5520: g_po_line_attrval_int_rec.catalog_name := null;
5521:
5522: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5524: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5525: ' --> inserting into lines interface' ||
5526: ', g_po_line_attrval_int_rec.po_header_id: ' || g_po_line_attrval_int_rec.po_header_id ||
5527: ', g_po_line_attrval_int_rec.po_line_id: ' || g_po_line_attrval_int_rec.po_line_id ||

Line 5541: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5537: g_r12_upg_rec.po_interface_line_id := l_po_interface_line_id_tbl(i);
5538: g_r12_upg_rec.po_header_id := l_po_header_id_tbl(i);
5539: g_r12_upg_rec.po_line_id := l_po_line_id_tbl(i);
5540:
5541: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5543: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5544: ' --> deleting from r12 upgrade' ||
5545: ', l_rt_item_id_tbl: ' || l_rt_item_id_tbl(i) );

Line 5542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5538: g_r12_upg_rec.po_header_id := l_po_header_id_tbl(i);
5539: g_r12_upg_rec.po_line_id := l_po_line_id_tbl(i);
5540:
5541: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5543: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5544: ' --> deleting from r12 upgrade' ||
5545: ', l_rt_item_id_tbl: ' || l_rt_item_id_tbl(i) );
5546: END IF;

Line 5582: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5578: END IF;
5579:
5580: l_err_loc := 360;
5581: l_end_date := sysdate;
5582: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5584: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5585: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
5586: ', Total no: of batches processed:' ||l_batch_count ||

Line 5583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5579:
5580: l_err_loc := 360;
5581: l_end_date := sysdate;
5582: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5584: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5585: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
5586: ', Total no: of batches processed:' ||l_batch_count ||
5587: ', Total no: of bulkloaded items processed:' ||l_item_row_count);

Line 5638: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5634: BEGIN
5635: l_err_loc := 100;
5636: l_start_date := sysdate;
5637:
5638: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5639: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5640: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5641: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
5642: END IF;

Line 5639: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5635: l_err_loc := 100;
5636: l_start_date := sysdate;
5637:
5638: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5639: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5640: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5641: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
5642: END IF;
5643:

Line 5662: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5658: l_upo_int_hdr_id_tbl(l_upd_index) := getNextInterfaceHdrIdFromSeq;
5659: l_upo_hdr_id_tbl(l_upd_index) := l_po_header_id_tbl(i);
5660:
5661: l_err_loc := 700;
5662: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5664: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5665: ' --> Values fetched from the cursor; '||
5666: 'l_po_header_id_tbl:' || l_po_header_id_tbl(i) ||

Line 5663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5659: l_upo_hdr_id_tbl(l_upd_index) := l_po_header_id_tbl(i);
5660:
5661: l_err_loc := 700;
5662: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5664: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5665: ' --> Values fetched from the cursor; '||
5666: 'l_po_header_id_tbl:' || l_po_header_id_tbl(i) ||
5667: ', l_count_tbl:' || l_count_tbl(i) ||

Line 5679: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5675: SET po_interface_header_id = l_upo_int_hdr_id_tbl(i)
5676: WHERE po_header_id = l_upo_hdr_id_tbl(i);
5677:
5678: l_err_loc := 900;
5679: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5680: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5681: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5682: 'Number of rows updated in r12 upgrade with new interface_header_id ' || SQL%ROWCOUNT);
5683: END IF;

Line 5680: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5676: WHERE po_header_id = l_upo_hdr_id_tbl(i);
5677:
5678: l_err_loc := 900;
5679: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5680: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5681: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5682: 'Number of rows updated in r12 upgrade with new interface_header_id ' || SQL%ROWCOUNT);
5683: END IF;
5684:

Line 5704: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5700: FETCH syncRowsInR12UpgTblCsr BULK COLLECT INTO
5701: l_rowid_tbl
5702: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
5703:
5704: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5705: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5706: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5707: 'Total no: of rows fetched from the cursor:' || l_rowid_tbl.COUNT);
5708: END IF;

Line 5705: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5701: l_rowid_tbl
5702: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
5703:
5704: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5705: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5706: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5707: 'Total no: of rows fetched from the cursor:' || l_rowid_tbl.COUNT);
5708: END IF;
5709:

Line 5728: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5724: WHERE rowid = l_rowid_tbl(i);
5725:
5726: l_err_loc := 1700;
5727: IF (l_rowid_tbl.COUNT > 0) THEN
5728: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5729: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5731: 'No: of rows updated in icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
5732: END IF;

Line 5729: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5725:
5726: l_err_loc := 1700;
5727: IF (l_rowid_tbl.COUNT > 0) THEN
5728: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5729: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5731: 'No: of rows updated in icx_cat_r12_upgrade:' ||SQL%ROWCOUNT);
5732: END IF;
5733: END IF;

Line 5761: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5757: END IF;
5758:
5759: l_err_loc := 2100;
5760: l_end_date := sysdate;
5761: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5763: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5764: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
5765: ', Total no: of batches processed:' ||l_batch_count ||

Line 5762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5758:
5759: l_err_loc := 2100;
5760: l_end_date := sysdate;
5761: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5763: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5764: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date) ||
5765: ', Total no: of batches processed:' ||l_batch_count ||
5766: ', Total no: of bulkloaded items processed:' ||l_item_row_count);

Line 5784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5780: l_err_loc PLS_INTEGER;
5781: BEGIN
5782: l_err_loc := 100;
5783:
5784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5785: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, 'Start...');
5786: END IF;
5787: /*
5788: Possible changes after pre-upgrade and before another run of pre-upgrade/upgrade

Line 5816: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5812: -- call the delete
5813: checkDeleteInGBPAForDelta; --Checks for Steps 4, 5 and 6.
5814: checkUpdateInGBPAForDelta; --Checks for Steps 1, 2, 3 and 7.
5815:
5816: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5817: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, ' done ;' );
5818: END IF;
5819: EXCEPTION
5820: WHEN OTHERS THEN

Line 5846: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5842: l_err_string VARCHAR2(4000);
5843: l_icx_schema_name VARCHAR2(30) := NULL;
5844: BEGIN
5845: l_err_loc := 100;
5846: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5847: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, 'Start...');
5848: END IF;
5849:
5850: -- cleanup the contract_id for bulkload items

Line 5883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5879: WHERE rowid = l_rowid_tbl(i);
5880:
5881: l_err_loc := 185;
5882: IF (l_rowid_tbl.COUNT > 0) THEN
5883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5886: 'No: of rows updated in icx_cat_item_prices:' ||SQL%ROWCOUNT);
5887: END IF;

Line 5884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

5880:
5881: l_err_loc := 185;
5882: IF (l_rowid_tbl.COUNT > 0) THEN
5883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
5885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5886: 'No: of rows updated in icx_cat_item_prices:' ||SQL%ROWCOUNT);
5887: END IF;
5888: END IF;

Line 5923: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5919: l_err_loc := 230;
5920: -- Delete all the rows in icx_cat_r12_upgrade, because pre-upgrade was never run
5921: -- or never ran successfully. But icx_cat_r12_upgrade could have data from the
5922: -- previous run of data exception jobs.
5923: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5924: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5925: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5926: 'g_bulk_last_run_date:' || g_bulk_last_run_date ||
5927: '; about to truncate icx_cat_r12_upgrade...');

Line 5924: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5920: -- Delete all the rows in icx_cat_r12_upgrade, because pre-upgrade was never run
5921: -- or never ran successfully. But icx_cat_r12_upgrade could have data from the
5922: -- previous run of data exception jobs.
5923: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5924: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5925: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5926: 'g_bulk_last_run_date:' || g_bulk_last_run_date ||
5927: '; about to truncate icx_cat_r12_upgrade...');
5928: END IF;

Line 5969: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5965: l_err_loc := 100;
5966: ICX_CAT_UTIL_PVT.g_job_pdoi_update_date := NULL;
5967: l_start_date := sysdate;
5968:
5969: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5970: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
5971: ', g_current_program:' || ICX_CAT_UTIL_PVT.g_current_program ||
5972: ', g_data_exception_program:' || ICX_CAT_UTIL_PVT.g_data_exception_program;
5973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 5973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5969: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5970: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
5971: ', g_current_program:' || ICX_CAT_UTIL_PVT.g_current_program ||
5972: ', g_data_exception_program:' || ICX_CAT_UTIL_PVT.g_data_exception_program;
5973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5974: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5975: l_log_string);
5976: END IF;
5977:

Line 5981: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5977:
5978: -- Call the PDOI API.
5979: IF (ICX_CAT_UTIL_PVT.g_current_program = ICX_CAT_UTIL_PVT.g_data_exception_program) THEN
5980: l_err_loc := 200;
5981: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5982: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5983: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5984: 'Calling migrate catalog with FND_API.G_TRUE:' || FND_API.G_TRUE);
5985: END IF;

Line 5982: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5978: -- Call the PDOI API.
5979: IF (ICX_CAT_UTIL_PVT.g_current_program = ICX_CAT_UTIL_PVT.g_data_exception_program) THEN
5980: l_err_loc := 200;
5981: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5982: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5983: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
5984: 'Calling migrate catalog with FND_API.G_TRUE:' || FND_API.G_TRUE);
5985: END IF;
5986: -- Call it with 'FND_API.G_TRUE' for validate only and no commit done to transaction tables

Line 6004: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6000:
6001: -- Remove all the rows that are created in icx_cat_r12_upgrade table in the current job.
6002: ELSE
6003: l_err_loc := 300;
6004: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6005: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6006: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6007: 'Calling migrate catalog with FND_API.G_FALSE:' || FND_API.G_FALSE);
6008: END IF;

Line 6005: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6001: -- Remove all the rows that are created in icx_cat_r12_upgrade table in the current job.
6002: ELSE
6003: l_err_loc := 300;
6004: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6005: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6006: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6007: 'Calling migrate catalog with FND_API.G_FALSE:' || FND_API.G_FALSE);
6008: END IF;
6009: -- Call it with 'FND_API.G_FALSE' for commit into transaction tables

Line 6027: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6023: END IF;
6024:
6025: l_err_loc := 400;
6026: l_end_date := sysdate;
6027: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6028: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6029: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6030: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
6031: END IF;

Line 6028: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6024:
6025: l_err_loc := 400;
6026: l_end_date := sysdate;
6027: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6028: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6029: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6030: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
6031: END IF;
6032:

Line 6054: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6050: l_log_string VARCHAR2(2000);
6051: BEGIN
6052: l_err_loc := 100;
6053: l_start_date := sysdate;
6054: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6055: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6056: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6057: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6058: END IF;

Line 6055: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6051: BEGIN
6052: l_err_loc := 100;
6053: l_start_date := sysdate;
6054: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6055: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6056: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6057: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6058: END IF;
6059:

Line 6067: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6063: ICX_CAT_R12_DATA_EXCEP_RPT_PVT.process_data_exceptions_report(g_PDOI_batch_id);
6064:
6065: l_err_loc := 300;
6066: l_end_date := sysdate;
6067: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6068: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6069: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6070: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
6071: END IF;

Line 6068: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6064:
6065: l_err_loc := 300;
6066: l_end_date := sysdate;
6067: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6068: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6069: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6070: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
6071: END IF;
6072: EXCEPTION

Line 6090: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6086: l_err_loc PLS_INTEGER;
6087: l_row_count PLS_INTEGER;
6088: BEGIN
6089: l_err_loc := 100;
6090: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6091: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, 'Start...');
6092: END IF;
6093:
6094: FOR i IN 1..p_interface_header_id.COUNT LOOP

Line 6095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6091: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, 'Start...');
6092: END IF;
6093:
6094: FOR i IN 1..p_interface_header_id.COUNT LOOP
6095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6096: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6098: 'p_interface_header_id('||i||'):' || p_interface_header_id(i));
6099: END IF;

Line 6096: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6092: END IF;
6093:
6094: FOR i IN 1..p_interface_header_id.COUNT LOOP
6095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6096: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6098: 'p_interface_header_id('||i||'):' || p_interface_header_id(i));
6099: END IF;
6100: END LOOP;

Line 6102: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6098: 'p_interface_header_id('||i||'):' || p_interface_header_id(i));
6099: END IF;
6100: END LOOP;
6101:
6102: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6103: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6104: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6105: 'Count of p_interface_header_id:' || p_interface_header_id.COUNT);
6106: END IF;

Line 6103: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6099: END IF;
6100: END LOOP;
6101:
6102: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6103: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6104: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6105: 'Count of p_interface_header_id:' || p_interface_header_id.COUNT);
6106: END IF;
6107:

Line 6121: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6117: l_err_loc := 300;
6118: l_row_count := SQL%ROWCOUNT;
6119:
6120: l_err_loc := 350;
6121: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6122: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6123: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6124: 'No: of header rows updated in icx_cat_r12_upgrade table:' || l_row_count ||
6125: ', g_job_pdoi_update_date:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);

Line 6122: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6118: l_row_count := SQL%ROWCOUNT;
6119:
6120: l_err_loc := 350;
6121: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6122: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6123: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6124: 'No: of header rows updated in icx_cat_r12_upgrade table:' || l_row_count ||
6125: ', g_job_pdoi_update_date:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);
6126: END IF;

Line 6135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6131: THEN
6132: ICX_CAT_UTIL_PVT.g_job_pdoi_update_date := sysdate;
6133: -- Update the pdoi_update_date in the jobs table.
6134: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_paused_status);
6135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6137: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6138: ', g_job_pdoi_update_date set to:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);
6139: END IF;

Line 6136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6132: ICX_CAT_UTIL_PVT.g_job_pdoi_update_date := sysdate;
6133: -- Update the pdoi_update_date in the jobs table.
6134: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_paused_status);
6135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6137: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6138: ', g_job_pdoi_update_date set to:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);
6139: END IF;
6140: END IF;

Line 6143: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6139: END IF;
6140: END IF;
6141:
6142: l_err_loc := 500;
6143: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6144: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, ' done ;' );
6145: END IF;
6146: EXCEPTION
6147: WHEN OTHERS THEN

Line 6163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6159: l_err_loc PLS_INTEGER;
6160: l_row_count PLS_INTEGER;
6161: BEGIN
6162: l_err_loc := 100;
6163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6164: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, 'Start...');
6165: END IF;
6166:
6167: FOR i IN 1..p_interface_line_id.COUNT LOOP

Line 6168: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6164: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, 'Start...');
6165: END IF;
6166:
6167: FOR i IN 1..p_interface_line_id.COUNT LOOP
6168: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6169: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6170: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6171: 'p_interface_line_id('||i||'):' || p_interface_line_id(i));
6172: END IF;

Line 6169: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6165: END IF;
6166:
6167: FOR i IN 1..p_interface_line_id.COUNT LOOP
6168: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6169: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6170: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6171: 'p_interface_line_id('||i||'):' || p_interface_line_id(i));
6172: END IF;
6173: END LOOP;

Line 6175: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6171: 'p_interface_line_id('||i||'):' || p_interface_line_id(i));
6172: END IF;
6173: END LOOP;
6174:
6175: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6176: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6177: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6178: 'Count of p_interface_line_id:' || p_interface_line_id.COUNT);
6179: END IF;

Line 6176: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6172: END IF;
6173: END LOOP;
6174:
6175: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6176: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6177: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6178: 'Count of p_interface_line_id:' || p_interface_line_id.COUNT);
6179: END IF;
6180:

Line 6194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6190: l_err_loc := 300;
6191: l_row_count := SQL%ROWCOUNT;
6192:
6193: l_err_loc := 350;
6194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6195: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6196: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6197: 'No: of line rows updated in icx_cat_r12_upgrade table:' || l_row_count ||
6198: ', g_job_pdoi_update_date:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);

Line 6195: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6191: l_row_count := SQL%ROWCOUNT;
6192:
6193: l_err_loc := 350;
6194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6195: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6196: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6197: 'No: of line rows updated in icx_cat_r12_upgrade table:' || l_row_count ||
6198: ', g_job_pdoi_update_date:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);
6199: END IF;

Line 6211: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6207: THEN
6208: ICX_CAT_UTIL_PVT.g_job_pdoi_update_date := sysdate;
6209: -- Update the pdoi_update_date in the jobs table.
6210: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_paused_status);
6211: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6212: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6213: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6214: ', g_job_pdoi_update_date set to:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);
6215: END IF;

Line 6212: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6208: ICX_CAT_UTIL_PVT.g_job_pdoi_update_date := sysdate;
6209: -- Update the pdoi_update_date in the jobs table.
6210: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_paused_status);
6211: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6212: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6213: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6214: ', g_job_pdoi_update_date set to:' || ICX_CAT_UTIL_PVT.g_job_pdoi_update_date);
6215: END IF;
6216: END IF;

Line 6219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6215: END IF;
6216: END IF;
6217:
6218: l_err_loc := 500;
6219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6220: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, ' done ;' );
6221: END IF;
6222: EXCEPTION
6223: WHEN OTHERS THEN

Line 6259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6255: l_row_count PLS_INTEGER;
6256: BEGIN
6257: l_err_loc := 100;
6258: l_start_date := sysdate;
6259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6261: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6262: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6263: END IF;

Line 6260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6256: BEGIN
6257: l_err_loc := 100;
6258: l_start_date := sysdate;
6259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6261: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6262: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6263: END IF;
6264:

Line 6293: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6289: WHERE new_fav_hdrs.employee_id = old_fav_hdrs.employee_id
6290: AND new_fav_hdrs.favorite_list_id = old_fav_hdrs.favorite_list_id);
6291:
6292: l_err_loc := 200;
6293: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6294: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6295: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6296: 'No: of rows inserted into icx_cat_fav_list_headers during upgrade:' || SQL%ROWCOUNT);
6297: END IF;

Line 6294: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6290: AND new_fav_hdrs.favorite_list_id = old_fav_hdrs.favorite_list_id);
6291:
6292: l_err_loc := 200;
6293: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6294: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6295: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6296: 'No: of rows inserted into icx_cat_fav_list_headers during upgrade:' || SQL%ROWCOUNT);
6297: END IF;
6298:

Line 6325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6321: l_continue := FALSE;
6322: END IF;
6323:
6324: l_err_loc := 550;
6325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6327: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6328: 'No: of rows updated in icx_cat_fav_list_headers for primary_flag:' || l_row_count);
6329: END IF;

Line 6326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6322: END IF;
6323:
6324: l_err_loc := 550;
6325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6327: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6328: 'No: of rows updated in icx_cat_fav_list_headers for primary_flag:' || l_row_count);
6329: END IF;
6330:

Line 6337: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6333: END LOOP;
6334:
6335: l_err_loc := 700;
6336: l_end_date := sysdate;
6337: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6338: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6339: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6340: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
6341: END IF;

Line 6338: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6334:
6335: l_err_loc := 700;
6336: l_end_date := sysdate;
6337: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6338: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6339: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6340: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
6341: END IF;
6342: EXCEPTION

Line 6533: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6529:
6530: BEGIN
6531: l_err_loc := 100;
6532: l_start_date := sysdate;
6533: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6534: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6535: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6536: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6537: END IF;

Line 6534: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6530: BEGIN
6531: l_err_loc := 100;
6532: l_start_date := sysdate;
6533: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6534: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6535: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6536: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6537: END IF;
6538:

Line 6569: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6565: WHERE rowid = l_rowid_tbl(i);
6566:
6567: l_err_loc := 400;
6568: IF (l_rowid_tbl.COUNT > 0) THEN
6569: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6570: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6571: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6572: 'No: of rows updated in por_favorite_list_lines for bulk loaded items:' ||SQL%ROWCOUNT);
6573: END IF;

Line 6570: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6566:
6567: l_err_loc := 400;
6568: IF (l_rowid_tbl.COUNT > 0) THEN
6569: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6570: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6571: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6572: 'No: of rows updated in por_favorite_list_lines for bulk loaded items:' ||SQL%ROWCOUNT);
6573: END IF;
6574: END IF;

Line 6660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6656: WHERE favorite_list_line_id = l_favorite_list_line_id_tbl(i);
6657:
6658: l_err_loc := 1300;
6659: IF (l_favorite_list_line_id_tbl.COUNT > 0) THEN
6660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6662: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6663: 'No: of rows updated in por_favorite_list_lines for item_type:' ||SQL%ROWCOUNT);
6664: END IF;

Line 6661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6657:
6658: l_err_loc := 1300;
6659: IF (l_favorite_list_line_id_tbl.COUNT > 0) THEN
6660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6662: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6663: 'No: of rows updated in por_favorite_list_lines for item_type:' ||SQL%ROWCOUNT);
6664: END IF;
6665: END IF;

Line 6741: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6737: -- So mark this one as duplicate
6738: l_dupe_fav_list_index := l_dupe_fav_list_line_id_tbl.COUNT + 1;
6739: l_dupe_fav_list_line_id_tbl(l_dupe_fav_list_index) := l_favorite_list_line_id_tbl(i);
6740:
6741: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6742: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6743: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6744: 'fav list catalog lines marked as duplicate;' ||
6745: ', l_dupe_fav_list_line_id_tbl :' || l_dupe_fav_list_line_id_tbl(l_dupe_fav_list_index));

Line 6742: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6738: l_dupe_fav_list_index := l_dupe_fav_list_line_id_tbl.COUNT + 1;
6739: l_dupe_fav_list_line_id_tbl(l_dupe_fav_list_index) := l_favorite_list_line_id_tbl(i);
6740:
6741: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6742: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6743: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6744: 'fav list catalog lines marked as duplicate;' ||
6745: ', l_dupe_fav_list_line_id_tbl :' || l_dupe_fav_list_line_id_tbl(l_dupe_fav_list_index));
6746: END IF;

Line 6762: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6758: WHERE favorite_list_line_id = l_dupe_fav_list_line_id_tbl(i);
6759:
6760: l_err_loc := 2700;
6761: IF (l_favorite_list_line_id_tbl.COUNT > 0) THEN
6762: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6764: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6765: 'No: of rows updated in por_favorite_list_lines for duplicates:' ||SQL%ROWCOUNT);
6766: END IF;

Line 6763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6759:
6760: l_err_loc := 2700;
6761: IF (l_favorite_list_line_id_tbl.COUNT > 0) THEN
6762: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6764: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6765: 'No: of rows updated in por_favorite_list_lines for duplicates:' ||SQL%ROWCOUNT);
6766: END IF;
6767: END IF;

Line 6868: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6864: gIFLCNewFavoriteListLineIdTbl(l_fav_list_lines_index) := l_favorite_list_line_id_tbl(i);
6865: END IF;
6866:
6867: l_err_loc := 4200;
6868: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6870: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6871: 'fav list catalog lines upgrade values at fav_lines_index :' || l_fav_list_lines_index ||
6872: ', gIFLCFavoriteListIdTbl :' || gIFLCFavoriteListIdTbl(l_fav_list_lines_index) ||

Line 6869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

6865: END IF;
6866:
6867: l_err_loc := 4200;
6868: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6870: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6871: 'fav list catalog lines upgrade values at fav_lines_index :' || l_fav_list_lines_index ||
6872: ', gIFLCFavoriteListIdTbl :' || gIFLCFavoriteListIdTbl(l_fav_list_lines_index) ||
6873: ', gIFLCOldFavoriteListLineIdTbl :' || gIFLCOldFavoriteListLineIdTbl(l_fav_list_lines_index) ||

Line 6938: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6934: WHERE installed_flag IN ('B', 'I')
6935: ORDER BY installed_flag;
6936:
6937: l_err_loc := 5100;
6938: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6939: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6940: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6941: 'l_language_tbl.COUNT:' || l_language_tbl.COUNT);
6942: END IF;

Line 6939: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6935: ORDER BY installed_flag;
6936:
6937: l_err_loc := 5100;
6938: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6939: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6940: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6941: 'l_language_tbl.COUNT:' || l_language_tbl.COUNT);
6942: END IF;
6943:

Line 6981: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6977: l_batch_count := l_batch_count + 1;
6978:
6979: l_err_loc := 5800;
6980: FOR i IN 1..l_favorite_list_id_tbl.COUNT LOOP
6981: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6982: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6983: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6984: 'Processing the favorite_list_id:' || l_favorite_list_id_tbl(i));
6985: END IF;

Line 6982: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6978:
6979: l_err_loc := 5800;
6980: FOR i IN 1..l_favorite_list_id_tbl.COUNT LOOP
6981: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6982: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6983: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6984: 'Processing the favorite_list_id:' || l_favorite_list_id_tbl(i));
6985: END IF;
6986:

Line 6998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6994: l_prev_favorite_list_id <> l_favorite_list_id_tbl(i) AND
6995: l_org_id_tbl.COUNT > 0 )
6996: THEN
6997: l_err_loc := 6100;
6998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6999: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7000: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7001: 'Forming the gIFLO tables for favorite_list_id:' || l_prev_favorite_list_id ||
7002: '; l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT);

Line 6999: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

6995: l_org_id_tbl.COUNT > 0 )
6996: THEN
6997: l_err_loc := 6100;
6998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6999: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7000: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7001: 'Forming the gIFLO tables for favorite_list_id:' || l_prev_favorite_list_id ||
7002: '; l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT);
7003: END IF;

Line 7041: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7037: END LOOP;
7038: END LOOP;
7039:
7040: l_err_loc := 7200;
7041: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7043: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7044: 'Formed the gIFLO tables for favorite_list_id:' || l_prev_favorite_list_id ||
7045: '; count of favorite_lines in the hdr:' || l_count_tbl(i) ||

Line 7042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7038: END LOOP;
7039:
7040: l_err_loc := 7200;
7041: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7043: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7044: 'Formed the gIFLO tables for favorite_list_id:' || l_prev_favorite_list_id ||
7045: '; count of favorite_lines in the hdr:' || l_count_tbl(i) ||
7046: ', gIFLOFavoriteListIdTbl.COUNT:' || gIFLOFavoriteListIdTbl.COUNT);

Line 7058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7054: l_err_loc := 7400;
7055: IF (l_user_id_tbl(i) IS NOT NULL) THEN
7056: IF (l_profile_option_value_tbl(i) IS NOT NULL) THEN
7057: l_err_loc := 7500;
7058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7060: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7061: 'User level profile option:ORG_ID value:' || l_profile_option_value_tbl(i));
7062: END IF;

Line 7059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7055: IF (l_user_id_tbl(i) IS NOT NULL) THEN
7056: IF (l_profile_option_value_tbl(i) IS NOT NULL) THEN
7057: l_err_loc := 7500;
7058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7060: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7061: 'User level profile option:ORG_ID value:' || l_profile_option_value_tbl(i));
7062: END IF;
7063: l_err_loc := 7600;

Line 7070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7066: l_err_loc := 7700;
7067: l_org_id_index := l_org_id_tbl.COUNT + 1;
7068: l_org_id_tbl(l_org_id_index) := l_profile_option_value_tbl(i);
7069: l_err_loc := 7800;
7070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7072: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7073: 'Added to the l_org_id_tbl for, l_user_id_tbl:' || l_user_id_tbl(i) ||
7074: ', l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT ||

Line 7071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

7067: l_org_id_index := l_org_id_tbl.COUNT + 1;
7068: l_org_id_tbl(l_org_id_index) := l_profile_option_value_tbl(i);
7069: l_err_loc := 7800;
7070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7072: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7073: 'Added to the l_org_id_tbl for, l_user_id_tbl:' || l_user_id_tbl(i) ||
7074: ', l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT ||
7075: ', l_org_id_tbl:' || l_org_id_tbl(l_org_id_index));

Line 7080: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7076: END IF;
7077: END IF; -- IF ( l_org_already_exists = 'N' ) THEN
7078: ELSE
7079: l_err_loc := 7900;
7080: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7081: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7082: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7083: 'User level profile option:ORG_ID value:' || l_profile_option_value_tbl(i) ||
7084: ', About to get the Resp level profile option:ORG_ID values');

Line 7081: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7077: END IF; -- IF ( l_org_already_exists = 'N' ) THEN
7078: ELSE
7079: l_err_loc := 7900;
7080: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7081: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7082: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7083: 'User level profile option:ORG_ID value:' || l_profile_option_value_tbl(i) ||
7084: ', About to get the Resp level profile option:ORG_ID values');
7085: END IF;

Line 7094: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7090: -- Get the profile option value at the responsibility/application for the user
7091: FOR l_prf_option_val IN getOrgIdsAtRespAndAppLevelCsr(l_user_id_tbl(i), l_profile_option_id) LOOP
7092: l_err_loc := 8200;
7093: l_org_id_profile_value_exist := 'Y';
7094: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7095: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7096: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7097: 'Resp level profile option:ORG_ID value:' || l_prf_option_val.org_id);
7098: END IF;

Line 7095: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7091: FOR l_prf_option_val IN getOrgIdsAtRespAndAppLevelCsr(l_user_id_tbl(i), l_profile_option_id) LOOP
7092: l_err_loc := 8200;
7093: l_org_id_profile_value_exist := 'Y';
7094: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7095: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7096: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7097: 'Resp level profile option:ORG_ID value:' || l_prf_option_val.org_id);
7098: END IF;
7099: l_err_loc := 8300;

Line 7117: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7113: WHERE profile_option_id = l_profile_option_id
7114: AND level_id = 10001;
7115:
7116: l_err_loc := 8600;
7117: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7118: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7119: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7120: 'Site level profile option:ORG_ID value:' || l_site_level_prf_opt_val );
7121: END IF;

Line 7118: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7114: AND level_id = 10001;
7115:
7116: l_err_loc := 8600;
7117: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7118: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7119: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7120: 'Site level profile option:ORG_ID value:' || l_site_level_prf_opt_val );
7121: END IF;
7122: END IF;

Line 7146: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7142: l_org_id_tbl(l_org_id_index) := l_site_level_prf_opt_val;
7143: END IF;
7144:
7145: l_err_loc := 9300;
7146: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7147: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7148: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7149: 'Added to the l_org_id_tbl for, l_user_id_tbl:' || l_user_id_tbl(i) ||
7150: ', l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT ||

Line 7147: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

7143: END IF;
7144:
7145: l_err_loc := 9300;
7146: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7147: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7148: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7149: 'Added to the l_org_id_tbl for, l_user_id_tbl:' || l_user_id_tbl(i) ||
7150: ', l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT ||
7151: ', l_org_id_tbl:' || l_org_id_tbl(l_org_id_index));

Line 7161: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7157: IF (l_org_id_profile_value_exist = 'N') THEN
7158: -- Log the favorite list header info.
7159: -- This header will be probably removed if there are no lines in this one
7160: l_err_loc := 9500;
7161: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7162: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7164: 'ALERT: The user attached to the favorite list header does not have' ||
7165: ' profile option:ORG_ID value set at user level and responsibility level of' ||

Line 7162: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7158: -- Log the favorite list header info.
7159: -- This header will be probably removed if there are no lines in this one
7160: l_err_loc := 9500;
7161: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7162: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7164: 'ALERT: The user attached to the favorite list header does not have' ||
7165: ' profile option:ORG_ID value set at user level and responsibility level of' ||
7166: ' those resps belong to the following applications: 177, 178, 201, 396, 426;' ||

Line 7180: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7176: ELSE -- IF (l_user_id_tbl(i) IS NOT NULL) THEN
7177: l_err_loc := 9600;
7178: -- Log the favorite list header info.
7179: -- This header will be probably removed if there are no lines in this one
7180: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7181: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7182: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7183: 'ALERT: The employee attached to the favorite list header does not have a user;' ||
7184: ' Details: l_favorite_list_id_tbl:' || l_favorite_list_id_tbl(i) ||

Line 7181: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7177: l_err_loc := 9600;
7178: -- Log the favorite list header info.
7179: -- This header will be probably removed if there are no lines in this one
7180: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7181: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7182: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7183: 'ALERT: The employee attached to the favorite list header does not have a user;' ||
7184: ' Details: l_favorite_list_id_tbl:' || l_favorite_list_id_tbl(i) ||
7185: ', l_employee_id_tbl:' || l_employee_id_tbl(i) ||

Line 7197: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7193: IF (i = l_favorite_list_id_tbl.COUNT AND
7194: l_org_id_tbl.COUNT > 0)
7195: THEN
7196: l_err_loc := 9800;
7197: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7198: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7200: 'Forming the gIFLO tables for favorite_list_id:' || l_favorite_list_id_tbl(i) ||
7201: '; l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT);

Line 7198: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7194: l_org_id_tbl.COUNT > 0)
7195: THEN
7196: l_err_loc := 9800;
7197: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7198: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7200: 'Forming the gIFLO tables for favorite_list_id:' || l_favorite_list_id_tbl(i) ||
7201: '; l_org_id_tbl.COUNT:' || l_org_id_tbl.COUNT);
7202: END IF;

Line 7240: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7236: END LOOP;
7237: END LOOP;
7238:
7239: l_err_loc := 10900;
7240: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7242: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7243: 'Formed the gIFLO tables for favorite_list_id:' || l_favorite_list_id_tbl(i) ||
7244: '; count of favorite_lines in the hdr:' || l_count_tbl(i) ||

Line 7241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7237: END LOOP;
7238:
7239: l_err_loc := 10900;
7240: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7242: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7243: 'Formed the gIFLO tables for favorite_list_id:' || l_favorite_list_id_tbl(i) ||
7244: '; count of favorite_lines in the hdr:' || l_count_tbl(i) ||
7245: ', gIFLOFavoriteListIdTbl.COUNT:' || gIFLOFavoriteListIdTbl.COUNT);

Line 7276: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7272: END LOOP; -- CURSOR LOOP otherItemUpgradeCsr
7273:
7274: l_err_loc := 11500;
7275: FOR j IN 1..gIFLOFavoriteListIdTbl.COUNT LOOP
7276: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7277: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7278: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7279: 'fav list other lines upgrade values at j :' || j ||
7280: ', gIFLOFavoriteListIdTbl :' || gIFLOFavoriteListIdTbl(j) ||

Line 7277: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

7273:
7274: l_err_loc := 11500;
7275: FOR j IN 1..gIFLOFavoriteListIdTbl.COUNT LOOP
7276: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7277: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7278: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7279: 'fav list other lines upgrade values at j :' || j ||
7280: ', gIFLOFavoriteListIdTbl :' || gIFLOFavoriteListIdTbl(j) ||
7281: ', gIFLOOldFavoriteListLineIdTbl :' || gIFLOOldFavoriteListLineIdTbl(j) ||

Line 7331: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7327: END IF;
7328:
7329: l_err_loc := 390;
7330: IF (l_favorite_list_id_tbl.COUNT > 0) THEN
7331: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7333: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7334: 'No: of rows deleted from icx_cat_fav_list_headers for which there are no lines:' || l_row_count);
7335: FOR i IN 1..l_favorite_list_id_tbl.COUNT LOOP

Line 7332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

7328:
7329: l_err_loc := 390;
7330: IF (l_favorite_list_id_tbl.COUNT > 0) THEN
7331: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7333: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7334: 'No: of rows deleted from icx_cat_fav_list_headers for which there are no lines:' || l_row_count);
7335: FOR i IN 1..l_favorite_list_id_tbl.COUNT LOOP
7336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 7336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

7332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7333: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7334: 'No: of rows deleted from icx_cat_fav_list_headers for which there are no lines:' || l_row_count);
7335: FOR i IN 1..l_favorite_list_id_tbl.COUNT LOOP
7336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7337: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7338: 'l_favorite_list_id_tbl(i):' || l_favorite_list_id_tbl(i) ||
7339: ', l_employee_id_tbl(i):' || l_employee_id_tbl(i));
7340: END LOOP;

Line 7350: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7346: END LOOP;
7347:
7348: l_err_loc := 12500;
7349: l_end_date := sysdate;
7350: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7351: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7352: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7353: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
7354: END IF;

Line 7351: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7347:
7348: l_err_loc := 12500;
7349: l_end_date := sysdate;
7350: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7351: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7352: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7353: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
7354: END IF;
7355:

Line 7379: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7375: l_end_date DATE;
7376: BEGIN
7377: l_err_loc := 100;
7378: l_start_date := sysdate;
7379: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7380: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7381: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7382: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
7383: END IF;

Line 7380: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7376: BEGIN
7377: l_err_loc := 100;
7378: l_start_date := sysdate;
7379: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7380: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7381: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7382: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
7383: END IF;
7384:

Line 7414: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7410: l_err_loc := 600;
7411: ICX_CAT_INTERMEDIA_INDEX_PVT.create_index;
7412:
7413: l_err_loc := 700;
7414: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7415: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7416: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7417: 'Drop and Create indexes called ');
7418: END IF;

Line 7415: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7411: ICX_CAT_INTERMEDIA_INDEX_PVT.create_index;
7412:
7413: l_err_loc := 700;
7414: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7415: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7416: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7417: 'Drop and Create indexes called ');
7418: END IF;
7419: ELSIF (l_index_exists = -1) THEN

Line 7424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7420: l_err_loc := 800;
7421: ICX_CAT_INTERMEDIA_INDEX_PVT.create_index;
7422:
7423: l_err_loc := 900;
7424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7426: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7427: 'Create index called ');
7428: END IF;

Line 7425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7421: ICX_CAT_INTERMEDIA_INDEX_PVT.create_index;
7422:
7423: l_err_loc := 900;
7424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7426: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7427: 'Create index called ');
7428: END IF;
7429: END IF;

Line 7433: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7429: END IF;
7430:
7431: l_err_loc := 1000;
7432: l_end_date := sysdate;
7433: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7434: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7435: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7436: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
7437: END IF;

Line 7434: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7430:
7431: l_err_loc := 1000;
7432: l_end_date := sysdate;
7433: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7434: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7435: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7436: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
7437: END IF;
7438:

Line 7463: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7459: BEGIN
7460: l_err_loc := 100;
7461: l_start_date := sysdate;
7462:
7463: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7465: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7466: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
7467: END IF;

Line 7464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7460: l_err_loc := 100;
7461: l_start_date := sysdate;
7462:
7463: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7465: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7466: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
7467: END IF;
7468:

Line 7479: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7475: -- Set batch_size/commit_size into ICX_CAT_UTIL_PVT.g_batch_size
7476: ICX_CAT_UTIL_PVT.setBatchSize;
7477:
7478: l_err_loc := 400;
7479: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7480: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7481: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7482: ', AUDSID:' || g_audsid);
7483: END IF;

Line 7480: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7476: ICX_CAT_UTIL_PVT.setBatchSize;
7477:
7478: l_err_loc := 400;
7479: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7480: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7481: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7482: ', AUDSID:' || g_audsid);
7483: END IF;
7484:

Line 7533: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7529: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_current_status);
7530:
7531: l_err_loc := 1700;
7532: l_end_date := sysdate;
7533: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7534: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7535: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7536: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
7537: END IF;

Line 7534: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7530:
7531: l_err_loc := 1700;
7532: l_end_date := sysdate;
7533: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7534: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7535: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7536: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
7537: END IF;
7538: EXCEPTION

Line 7667: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7663: l_err_loc := 1500;
7664: l_upd_index := l_upd_rt_descriptor_id_tbl.COUNT + 1;
7665: l_upd_rt_descriptor_id_tbl(l_upd_index) := l_rt_descriptor_id_tbl(i);
7666: l_upd_key_tbl(l_upd_index) := l_new_key;
7667: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7669: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7670: 'changing descriptor key from:' || l_key_tbl(i) ||
7671: ', to :' || l_new_key || ' in icx_cat_descriptors_tl for rt_descriptor_id :' ||

Line 7668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7664: l_upd_index := l_upd_rt_descriptor_id_tbl.COUNT + 1;
7665: l_upd_rt_descriptor_id_tbl(l_upd_index) := l_rt_descriptor_id_tbl(i);
7666: l_upd_key_tbl(l_upd_index) := l_new_key;
7667: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7669: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7670: 'changing descriptor key from:' || l_key_tbl(i) ||
7671: ', to :' || l_new_key || ' in icx_cat_descriptors_tl for rt_descriptor_id :' ||
7672: l_rt_descriptor_id_tbl(i));

Line 7719: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7715: AND des1.language = des2.language)
7716: );
7717:
7718: l_err_loc := 300;
7719: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7720: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7721: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7722: 'No: of rows inserted into icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);
7723: END IF;

Line 7720: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7716: );
7717:
7718: l_err_loc := 300;
7719: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7720: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7721: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7722: 'No: of rows inserted into icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);
7723: END IF;
7724:

Line 7738: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7734: l_err_loc := 600;
7735: CLOSE checkSrchbleForSpecAttrsCsr;
7736:
7737: l_err_loc := 700;
7738: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7739: FOR i IN 1..l_attribute_id_tbl.COUNT LOOP
7740: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7742: ' Attribute key:' || l_key_tbl(i) || ', will be made non-searchable');

Line 7740: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7736:
7737: l_err_loc := 700;
7738: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7739: FOR i IN 1..l_attribute_id_tbl.COUNT LOOP
7740: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7742: ' Attribute key:' || l_key_tbl(i) || ', will be made non-searchable');
7743: END LOOP;
7744: END IF;

Line 7753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7749: SET searchable = 0
7750: WHERE attribute_id = l_attribute_id_tbl(i);
7751:
7752: l_err_loc := 850;
7753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7755: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7756: 'No: of rows updated with searchable=0 in icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);
7757: END IF;

Line 7754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7750: WHERE attribute_id = l_attribute_id_tbl(i);
7751:
7752: l_err_loc := 850;
7753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7755: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7756: 'No: of rows updated with searchable=0 in icx_cat_attributes_tl during upgrade:' || SQL%ROWCOUNT);
7757: END IF;
7758: END IF;

Line 7798: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7794: INTO g_PDOI_batch_id
7795: FROM po_headers_interface;
7796:
7797: l_err_loc := 400;
7798: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7799: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7800: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7801: 'PDOI Batch Id:' || g_PDOI_batch_id ||
7802: ', p_current_program:' || p_current_program ||

Line 7799: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7795: FROM po_headers_interface;
7796:
7797: l_err_loc := 400;
7798: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7799: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7800: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7801: 'PDOI Batch Id:' || g_PDOI_batch_id ||
7802: ', p_current_program:' || p_current_program ||
7803: ', AUDSID:' || g_audsid);

Line 7880: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7876: -- Update the current job to running status
7877: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_running_status);
7878:
7879: l_err_loc := 1800;
7880: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7881: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7882: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7883: 'Upgrade last successful completion dates:' ||
7884: ', g_extract_last_run_date: ' || g_extract_last_run_date ||

Line 7881: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7877: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_running_status);
7878:
7879: l_err_loc := 1800;
7880: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7881: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7882: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7883: 'Upgrade last successful completion dates:' ||
7884: ', g_extract_last_run_date: ' || g_extract_last_run_date ||
7885: ', g_bulk_last_run_date: ' || g_bulk_last_run_date ||

Line 7947: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7943: BEGIN
7944: l_err_loc := 100;
7945: l_start_date := sysdate;
7946:
7947: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7948: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7949: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7950: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
7951: END IF;

Line 7948: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7944: l_err_loc := 100;
7945: l_start_date := sysdate;
7946:
7947: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7948: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7949: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7950: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
7951: END IF;
7952:

Line 7973: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7969: g_PDOI_batch_id -- p_pdoi_batch_id
7970: );
7971: IF (p_data_exception_job > 0) THEN
7972: l_err_loc := 300;
7973: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7975: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7976: ', Child 1, Data Exceptions job submitted; request_id :' ||
7977: p_data_exception_job);

Line 7974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7970: );
7971: IF (p_data_exception_job > 0) THEN
7972: l_err_loc := 300;
7973: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7975: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7976: ', Child 1, Data Exceptions job submitted; request_id :' ||
7977: p_data_exception_job);
7978: END IF;

Line 7983: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7979: EXIT;
7980: ELSIF (l_counter > 3) THEN
7981: l_err_loc := 400;
7982: p_data_exception_job := 0;
7983: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7984: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7985: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7986: ', Child 1, Data Exceptions job not submitted; So submitting' ||
7987: ' it as a serial process. About to call callICXProcessDataExcptnRpt');

Line 7984: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7980: ELSIF (l_counter > 3) THEN
7981: l_err_loc := 400;
7982: p_data_exception_job := 0;
7983: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7984: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
7985: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7986: ', Child 1, Data Exceptions job not submitted; So submitting' ||
7987: ' it as a serial process. About to call callICXProcessDataExcptnRpt');
7988: END IF;

Line 7998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

7994:
7995: l_err_loc := 500;
7996: l_end_date := sysdate;
7997:
7998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7999: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8000: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8001: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
8002: END IF;

Line 7999: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

7995: l_err_loc := 500;
7996: l_end_date := sysdate;
7997:
7998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7999: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8000: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8001: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
8002: END IF;
8003:

Line 8119: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8115:
8116: l_err_loc := 200;
8117: l_start_date := sysdate;
8118:
8119: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8120: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8121: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8122: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
8123: END IF;

Line 8120: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

8116: l_err_loc := 200;
8117: l_start_date := sysdate;
8118:
8119: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8120: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8121: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8122: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
8123: END IF;
8124:

Line 8152: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8148: updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_current_status);
8149:
8150: l_err_loc := 1400;
8151: l_end_date := sysdate;
8152: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8153: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8155: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
8156: END IF;

Line 8153: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

8149:
8150: l_err_loc := 1400;
8151: l_end_date := sysdate;
8152: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8153: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8155: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
8156: END IF;
8157:

Line 8192: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8188: l_audsid NUMBER := USERENV('SESSIONID');
8189: BEGIN
8190: l_err_loc := 100;
8191: l_start_date := sysdate;
8192: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8193: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8194: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8195: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
8196: ', audsid:' || l_audsid ||

Line 8193: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

8189: BEGIN
8190: l_err_loc := 100;
8191: l_start_date := sysdate;
8192: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8193: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8194: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8195: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
8196: ', audsid:' || l_audsid ||
8197: 'Parameters: p_parent_int_req_id:' || p_parent_int_req_id ||

Line 8224: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8220: ICX_CAT_UTIL_PVT.g_job_type := ICX_CAT_UTIL_PVT.g_child_data_excptn_program;
8221: ICX_CAT_UTIL_PVT.g_job_number := ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id;
8222:
8223: l_err_loc := 600;
8224: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8225: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8226: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8227: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||
8228: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number);

Line 8225: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

8221: ICX_CAT_UTIL_PVT.g_job_number := ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id;
8222:
8223: l_err_loc := 600;
8224: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8225: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8226: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8227: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||
8228: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number);
8229: END IF;

Line 8249: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8245: x_errbuf := l_api_name ||' done';
8246:
8247: l_err_loc := 1100;
8248: l_end_date := sysdate;
8249: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8252: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
8253: END IF;

Line 8250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

8246:
8247: l_err_loc := 1100;
8248: l_end_date := sysdate;
8249: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8252: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
8253: END IF;
8254: EXCEPTION

Line 8366: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

8362: l_err_loc := 400;
8363: l_row_count := SQL%ROWCOUNT;
8364:
8365: l_err_loc := 500;
8366: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8367: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8368: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8369: '; No: of rows updated in icx_cat_r12_upgrade_jobs:' || l_row_count);
8370: END IF;

Line 8367: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

8363: l_row_count := SQL%ROWCOUNT;
8364:
8365: l_err_loc := 500;
8366: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8367: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
8368: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
8369: '; No: of rows updated in icx_cat_r12_upgrade_jobs:' || l_row_count);
8370: END IF;
8371: