eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_ALL

Line 209: if (CZ_IMP_ALL.get_time) then

205: OPEN C_REF_PART_NBR;
206: FETCH C_REF_PART_NBR INTO DFLT_REFPARTNBR;
207: CLOSE C_REF_PART_NBR;
208:
209: if (CZ_IMP_ALL.get_time) then
210: st_time := dbms_utility.get_time();
211: end if;
212:
213: SELECT DISTINCT INVENTORY_ITEM_ID, ORGANIZATION_ID, SEGMENT1, CONCATENATED_SEGMENTS, ITEM_DESC,

Line 226: if (CZ_IMP_ALL.get_time) then

222: FROM CZ_EXV_ITEMS
223: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID
224: AND EXPLOSION_TYPE=sExpl_type;
225:
226: if (CZ_IMP_ALL.get_time) then
227: end_time := dbms_utility.get_time();
228: d_str := inRun_Id || ' Bulk collect item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
229: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);
230: end if;

Line 282: if (CZ_IMP_ALL.get_time) then

278:
279: nIndex := nIndex + 1;
280: END LOOP;
281:
282: if (CZ_IMP_ALL.get_time) then
283: loop_end_time := dbms_utility.get_time();
284: --dbms_output.put_line ('loop over coll. (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00);
285: end if;
286:

Line 301: if (CZ_IMP_ALL.get_time) then

297: inRun_ID, iPrimaryUomCode(i), iDecimalQtyFlag(i),
298: iFskItemType(i), iFskItemType(i),
299: iSrcApplicationId(i), iSrcTypeCode(i));
300:
301: if (CZ_IMP_ALL.get_time) then
302: insert_end_time := dbms_utility.get_time();
303: --dbms_output.put_line ('Insert imp item master (' || nTop_Id || ') :' || (insert_end_time-end_time)/100.00);
304: end if;
305:

Line 850: if (CZ_IMP_ALL.get_time) then

846:
847:
848: nIndex := 1;
849:
850: if (CZ_IMP_ALL.get_time) then
851: st_time := dbms_utility.get_time();
852: end if;
853:
854: l_lang := userenv('LANG');

Line 876: if (CZ_IMP_ALL.get_time) then

872: EXIT;
873: END IF;
874: END IF;
875:
876: if (CZ_IMP_ALL.get_time) then
877: end_time := dbms_utility.get_time();
878: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
879: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
880: end if;

Line 882: if (CZ_IMP_ALL.get_time) then

878: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
879: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
880: end if;
881:
882: if (CZ_IMP_ALL.get_time) then
883: st_time := dbms_utility.get_time();
884: end if;
885:
886: --DBMS_OUTPUT.PUT_LINE('COUNT IS:'||ComponentItemId.COUNT);

Line 1345: if (CZ_IMP_ALL.get_time) then

1341: END IF;
1342: END IF;
1343: END LOOP;
1344:
1345: if (CZ_IMP_ALL.get_time) then
1346: end_time := dbms_utility.get_time();
1347: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1348: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1349: end if;

Line 1351: if (CZ_IMP_ALL.get_time) then

1347: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1348: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1349: end if;
1350:
1351: if (CZ_IMP_ALL.get_time) then
1352: st_time := dbms_utility.get_time();
1353: end if;
1354:
1355:

Line 1424: if (CZ_IMP_ALL.get_time) then

1420: iQuoteableFlag(i),iPrimaryUomCode(i),iBomSortOrder(i), iComponentSequencePath(i),iBTrackableFlag(i),
1421: iSrcApplicationId(i), ifskItemMaster22(i), iIBLinkItemFlag(i),
1422: iShippableItemFlag(i), iInventoryTransactableFlag(i), iAssembleToOrder(i), iSerializableItemFlag(i)); -- changes for TSO
1423:
1424: if (CZ_IMP_ALL.get_time) then
1425: end_time := dbms_utility.get_time();
1426: d_str := inRun_Id || ' Insert ps nodes (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1427: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1428: end if;

Line 1483: if (CZ_IMP_ALL.get_time) then

1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then
1484: end_time := dbms_utility.get_time();
1485: d_str := inRun_Id || ' Gather Stats :' || (end_time-st_time)/100.00;
1486: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1487: end if;

Line 1573: if (CZ_IMP_ALL.get_time) then

1569: p_out_err INTEGER;
1570:
1571: BEGIN
1572:
1573: if (CZ_IMP_ALL.get_time) then
1574: st_time := dbms_utility.get_time();
1575: end if;
1576:
1577: OPEN c_onl_ps_node;

Line 1622: if (CZ_IMP_ALL.get_time) then

1618: END IF;
1619:
1620: END LOOP;
1621:
1622: if (CZ_IMP_ALL.get_time) then
1623: end_time := dbms_utility.get_time();
1624: d_str := inRun_Id || ' Deleted ps node check (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1625: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1626: end if;

Line 1844: if (CZ_IMP_ALL.get_time) then

1840:
1841: END LOOP;
1842: END IF;
1843:
1844: if (CZ_IMP_ALL.get_time) then
1845: end_time := dbms_utility.get_time();
1846: d_str := inRun_Id || ' Extract text (' || nTop_Id || ' - Count - ' || iLocalizedStr.COUNT || ') :' || (end_time-st_time)/100.00;
1847: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1848: end if;

Line 1914: if (CZ_IMP_ALL.get_time) then

1910: l_lang VARCHAR2(4);
1911:
1912: BEGIN
1913: gModelItemId_tbl.delete;
1914: if (CZ_IMP_ALL.get_time) then
1915: st_time := dbms_utility.get_time();
1916: end if;
1917:
1918: l_lang := userenv('LANG');

Line 1930: if (CZ_IMP_ALL.get_time) then

1926: AND ORGANIZATION_ID=nOrg_ID
1927: AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type
1928: AND language = l_lang;
1929:
1930: if (CZ_IMP_ALL.get_time) then
1931: end_time := dbms_utility.get_time();
1932: d_str := inRun_Id || ' Extract projects (' || nTop_Id || ' - Count - ' || OrganizationId.COUNT || ') :' || (end_time-st_time)/100.00;
1933: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1934: end if;

Line 1959: if (CZ_IMP_ALL.get_time) then

1955:
1956: nIndex := nIndex + 1;
1957: END LOOP;
1958:
1959: if (CZ_IMP_ALL.get_time) then
1960: loop_end_time := dbms_utility.get_time();
1961: d_str := inRun_Id || ' Loop Projects (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
1962: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1963: end if;

Line 1975: if (CZ_IMP_ALL.get_time) then

1971: (nOrg_ID, iTopItemId(i), sExpl_type, iOrigSysRef(i), 1,
1972: inRun_ID, iName(i), iDescText(i), iDescText(i), iPlanLevel(i), nModelId, iModelType(i),
1973: iInventoryItemId(i), iProductKey(i), G_CAPTION_RULE_DESC, G_CAPTION_RULE_NAME, g_CONFIG_ENGINE_TYPE);
1974:
1975: if (CZ_IMP_ALL.get_time) then
1976: insert_end_time := dbms_utility.get_time();
1977: d_str := inRun_Id || ' Insert projects (' || nTop_Id || ') :' || (insert_end_time-loop_end_time)/100.00;
1978: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1979: end if;

Line 2010: if (CZ_IMP_ALL.get_time) then

2006: l_use_segments BOOLEAN:=FALSE;
2007: l_name_method VARCHAR2(255);
2008:
2009: BEGIN
2010: if (CZ_IMP_ALL.get_time) then
2011: st_time := dbms_utility.get_time();
2012: end if;
2013:
2014: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);

Line 2038: if (CZ_IMP_ALL.get_time) then

2034: FROM CZ_EXV_ITEM_TYPES
2035: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2036: END IF;
2037:
2038: if (CZ_IMP_ALL.get_time) then
2039: end_time := dbms_utility.get_time();
2040: d_str := inRun_Id || ' Insert item type (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2041: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2042: end if;

Line 2703: if (CZ_IMP_ALL.get_time) then

2699: v_section_name VARCHAR2(30);
2700:
2701: BEGIN
2702:
2703: if (CZ_IMP_ALL.get_time) then
2704: st_time := dbms_utility.get_time();
2705: end if;
2706:
2707: FORALL i IN 1..itemCatalogGroupId.COUNT

Line 2714: if (CZ_IMP_ALL.get_time) then

2710: SELECT DESCRIPTION, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID, TEXT_TYPE, G_BOM_APPLICATION_ID
2711: FROM CZ_EXV_ITEM_PROPERTIES
2712: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2713:
2714: if (CZ_IMP_ALL.get_time) then
2715: end_time := dbms_utility.get_time();
2716: d_str := inRun_Id || ' Insert property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2717: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2718: end if;

Line 2807: if (CZ_IMP_ALL.get_time) then

2803: WHERE CURRENT OF C_DATATYPE;
2804: END IF;
2805: END LOOP;
2806: CLOSE C_DATATYPE;
2807: if (CZ_IMP_ALL.get_time) then
2808: loop_end_time := dbms_utility.get_time();
2809: d_str := inRun_Id || ' Resolve property datatype (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
2810: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2811: end if;

Line 2841: if (CZ_IMP_ALL.get_time) then

2837: d_str varchar2(255);
2838:
2839: BEGIN
2840:
2841: if (CZ_IMP_ALL.get_time) then
2842: st_time := dbms_utility.get_time();
2843: end if;
2844:
2845: FORALL i IN 1..itemCatalogGroupId.COUNT

Line 2854: if (CZ_IMP_ALL.get_time) then

2850: TO_CHAR(ITEM_CATALOG_GROUP_ID) || ':' || ELEMENT_NAME, G_BOM_APPLICATION_ID
2851: FROM CZ_EXV_ITEM_PROPERTIES
2852: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2853:
2854: if (CZ_IMP_ALL.get_time) then
2855: end_time := dbms_utility.get_time();
2856: d_str := inRun_Id || ' Insert item Type prop (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2857: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2858: end if;

Line 2889: if(CZ_IMP_ALL.get_time) then

2885: d_str varchar2(255);
2886:
2887: BEGIN
2888:
2889: if(CZ_IMP_ALL.get_time) then
2890: st_time := dbms_utility.get_time();
2891: end if;
2892:
2893: FORALL i IN 1..inventoryItemId.COUNT

Line 2911: if (CZ_IMP_ALL.get_time) then

2907: WHERE INVENTORY_ITEM_ID = inventoryItemId(i)
2908: AND ORGANIZATION_ID = nOrg_ID
2909: AND ELEMENT_VALUE IS NOT NULL;
2910:
2911: if (CZ_IMP_ALL.get_time) then
2912: loop_end_time := dbms_utility.get_time();
2913: d_str := inRun_Id || ' Bulk collect prop val (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2914: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2915: end if;

Line 2947: if (CZ_IMP_ALL.get_time) then

2943: BEGIN
2944: --DBMS_OUTPUT.ENABLE;
2945: --DBMS_OUTPUT.PUT_LINE('EXTRACTING TABLE: ' || lower_table_name);
2946: IF(lower_table_name='cz_item_masters') THEN
2947: if (CZ_IMP_ALL.get_time) then
2948: st_time := dbms_utility.get_time();
2949: end if;
2950: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2951: if (CZ_IMP_ALL.get_time) then

Line 2951: if (CZ_IMP_ALL.get_time) then

2947: if (CZ_IMP_ALL.get_time) then
2948: st_time := dbms_utility.get_time();
2949: end if;
2950: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2951: if (CZ_IMP_ALL.get_time) then
2952: end_time := dbms_utility.get_time();
2953: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2955: end if;

Line 2957: if (CZ_IMP_ALL.get_time) then

2953: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2955: end if;
2956: ELSIF(lower_table_name='cz_ps_nodes') THEN
2957: if (CZ_IMP_ALL.get_time) then
2958: st_time := dbms_utility.get_time();
2959: end if;
2960: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2961: if (CZ_IMP_ALL.get_time) then

Line 2961: if (CZ_IMP_ALL.get_time) then

2957: if (CZ_IMP_ALL.get_time) then
2958: st_time := dbms_utility.get_time();
2959: end if;
2960: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2961: if (CZ_IMP_ALL.get_time) then
2962: end_time := dbms_utility.get_time();
2963: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2964: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2965: end if;

Line 2967: if (CZ_IMP_ALL.get_time) then

2963: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2964: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2965: end if;
2966: ELSIF(lower_table_name='cz_localized_texts') THEN
2967: if (CZ_IMP_ALL.get_time) then
2968: st_time := dbms_utility.get_time();
2969: end if;
2970: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2971: if (CZ_IMP_ALL.get_time) then

Line 2971: if (CZ_IMP_ALL.get_time) then

2967: if (CZ_IMP_ALL.get_time) then
2968: st_time := dbms_utility.get_time();
2969: end if;
2970: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2971: if (CZ_IMP_ALL.get_time) then
2972: end_time := dbms_utility.get_time();
2973: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2975: end if;

Line 2977: if (CZ_IMP_ALL.get_time) then

2973: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2975: end if;
2976: ELSIF(lower_table_name='cz_devl_projects') THEN
2977: if (CZ_IMP_ALL.get_time) then
2978: st_time := dbms_utility.get_time();
2979: end if;
2980: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2981: if (CZ_IMP_ALL.get_time) then

Line 2981: if (CZ_IMP_ALL.get_time) then

2977: if (CZ_IMP_ALL.get_time) then
2978: st_time := dbms_utility.get_time();
2979: end if;
2980: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2981: if (CZ_IMP_ALL.get_time) then
2982: end_time := dbms_utility.get_time();
2983: d_str := inRun_Id || ' Extract devl project (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2984: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2985: end if;

Line 2987: if (CZ_IMP_ALL.get_time) then

2983: d_str := inRun_Id || ' Extract devl project (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2984: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2985: end if;
2986: ELSIF(lower_table_name='cz_item_types') THEN
2987: if (CZ_IMP_ALL.get_time) then
2988: st_time := dbms_utility.get_time();
2989: end if;
2990: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2991: if (CZ_IMP_ALL.get_time) then

Line 2991: if (CZ_IMP_ALL.get_time) then

2987: if (CZ_IMP_ALL.get_time) then
2988: st_time := dbms_utility.get_time();
2989: end if;
2990: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2991: if (CZ_IMP_ALL.get_time) then
2992: end_time := dbms_utility.get_time();
2993: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2995: end if;

Line 2997: if (CZ_IMP_ALL.get_time) then

2993: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2995: end if;
2996: ELSIF(lower_table_name='cz_properties') THEN
2997: if (CZ_IMP_ALL.get_time) then
2998: st_time := dbms_utility.get_time();
2999: end if;
3000: EXTR_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3001:

Line 3007: if (CZ_IMP_ALL.get_time) then

3003: p_org_id => nOrg_ID,
3004: p_top_item_id => nTop_ID,
3005: p_expl_type => sExpl_type);
3006:
3007: if (CZ_IMP_ALL.get_time) then
3008: end_time := dbms_utility.get_time();
3009: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3010: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3011: end if;

Line 3013: if (CZ_IMP_ALL.get_time) then

3009: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3010: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3011: end if;
3012: ELSIF(lower_table_name='cz_item_type_properties') THEN
3013: if (CZ_IMP_ALL.get_time) then
3014: st_time := dbms_utility.get_time();
3015: end if;
3016: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3017: if (CZ_IMP_ALL.get_time) then

Line 3017: if (CZ_IMP_ALL.get_time) then

3013: if (CZ_IMP_ALL.get_time) then
3014: st_time := dbms_utility.get_time();
3015: end if;
3016: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3017: if (CZ_IMP_ALL.get_time) then
3018: end_time := dbms_utility.get_time();
3019: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3020: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3021: end if;

Line 3023: if (CZ_IMP_ALL.get_time) then

3019: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3020: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3021: end if;
3022: ELSIF(lower_table_name='cz_item_property_values') THEN
3023: if (CZ_IMP_ALL.get_time) then
3024: st_time := dbms_utility.get_time();
3025: end if;
3026: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3027: if (CZ_IMP_ALL.get_time) then

Line 3027: if (CZ_IMP_ALL.get_time) then

3023: if (CZ_IMP_ALL.get_time) then
3024: st_time := dbms_utility.get_time();
3025: end if;
3026: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3027: if (CZ_IMP_ALL.get_time) then
3028: end_time := dbms_utility.get_time();
3029: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3030: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3031: end if;

Line 3060: if (CZ_IMP_ALL.get_time) then

3056: BEGIN
3057: --DBMS_OUTPUT.ENABLE;
3058: --DBMS_OUTPUT.PUT_LINE('IMPORTING TABLE: ' || lower_table_name);
3059: IF(lower_table_name='cz_item_masters') THEN
3060: if (CZ_IMP_ALL.get_time) then
3061: st_time := dbms_utility.get_time();
3062: end if;
3063: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
3064: Inserts, Updates, x_failed, Dups,NoChange, inXFR_GROUP);

Line 3065: if (CZ_IMP_ALL.get_time) then

3061: st_time := dbms_utility.get_time();
3062: end if;
3063: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
3064: Inserts, Updates, x_failed, Dups,NoChange, inXFR_GROUP);
3065: if (CZ_IMP_ALL.get_time) then
3066: end_time := dbms_utility.get_time();
3067: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3069: end if;

Line 3071: if (CZ_IMP_ALL.get_time) then

3067: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3069: end if;
3070: ELSIF(lower_table_name='cz_ps_nodes') THEN
3071: if (CZ_IMP_ALL.get_time) then
3072: st_time := dbms_utility.get_time();
3073: end if;
3074: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3075: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);

Line 3076: if (CZ_IMP_ALL.get_time) then

3072: st_time := dbms_utility.get_time();
3073: end if;
3074: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3075: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3076: if (CZ_IMP_ALL.get_time) then
3077: end_time := dbms_utility.get_time();
3078: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3079: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3080: end if;

Line 3082: if (CZ_IMP_ALL.get_time) then

3078: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3079: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3080: end if;
3081: ELSIF(lower_table_name='cz_localized_texts') THEN
3082: if (CZ_IMP_ALL.get_time) then
3083: st_time := dbms_utility.get_time();
3084: end if;
3085: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3086: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);

Line 3087: if (CZ_IMP_ALL.get_time) then

3083: st_time := dbms_utility.get_time();
3084: end if;
3085: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3086: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3087: if (CZ_IMP_ALL.get_time) then
3088: end_time := dbms_utility.get_time();
3089: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3091: end if;

Line 3093: if (CZ_IMP_ALL.get_time) then

3089: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3091: end if;
3092: ELSIF(lower_table_name='cz_devl_projects') THEN
3093: if (CZ_IMP_ALL.get_time) then
3094: st_time := dbms_utility.get_time();
3095: end if;
3096: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3097: Inserts, Updates, x_failed, Dups,NoChange,

Line 3099: if (CZ_IMP_ALL.get_time) then

3095: end if;
3096: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3097: Inserts, Updates, x_failed, Dups,NoChange,
3098: inXFR_GROUP,p_rp_folder_id, g_CONFIG_ENGINE_TYPE);
3099: if (CZ_IMP_ALL.get_time) then
3100: end_time := dbms_utility.get_time();
3101: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3102: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3103: end if;

Line 3105: if (CZ_IMP_ALL.get_time) then

3101: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3102: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3103: end if;
3104: ELSIF(lower_table_name='cz_item_property_values') THEN
3105: if (CZ_IMP_ALL.get_time) then
3106: st_time := dbms_utility.get_time();
3107: end if;
3108: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3109: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);

Line 3110: if (CZ_IMP_ALL.get_time) then

3106: st_time := dbms_utility.get_time();
3107: end if;
3108: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3109: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3110: if (CZ_IMP_ALL.get_time) then
3111: end_time := dbms_utility.get_time();
3112: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3113: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3114: end if;

Line 3116: if (CZ_IMP_ALL.get_time) then

3112: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3113: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3114: end if;
3115: ELSIF(lower_table_name='cz_item_types') THEN
3116: if (CZ_IMP_ALL.get_time) then
3117: st_time := dbms_utility.get_time();
3118: end if;
3119: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3120: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);

Line 3121: if (CZ_IMP_ALL.get_time) then

3117: st_time := dbms_utility.get_time();
3118: end if;
3119: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3120: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3121: if (CZ_IMP_ALL.get_time) then
3122: end_time := dbms_utility.get_time();
3123: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3124: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3125: end if;

Line 3127: if (CZ_IMP_ALL.get_time) then

3123: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3124: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3125: end if;
3126: ELSIF(lower_table_name='cz_item_type_properties') THEN
3127: if (CZ_IMP_ALL.get_time) then
3128: st_time := dbms_utility.get_time();
3129: end if;
3130: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3131: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 3132: if (CZ_IMP_ALL.get_time) then

3128: st_time := dbms_utility.get_time();
3129: end if;
3130: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3131: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3132: if (CZ_IMP_ALL.get_time) then
3133: end_time := dbms_utility.get_time();
3134: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3136: end if;

Line 3138: if (CZ_IMP_ALL.get_time) then

3134: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3136: end if;
3137: ELSIF(lower_table_name='cz_properties') THEN
3138: if (CZ_IMP_ALL.get_time) then
3139: st_time := dbms_utility.get_time();
3140: end if;
3141: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3142: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP, p_rp_folder_id);

Line 3143: if (CZ_IMP_ALL.get_time) then

3139: st_time := dbms_utility.get_time();
3140: end if;
3141: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3142: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP, p_rp_folder_id);
3143: if (CZ_IMP_ALL.get_time) then
3144: end_time := dbms_utility.get_time();
3145: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3146: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3147: end if;

Line 3509: if (CZ_IMP_ALL.get_time) then

3505:
3506: END IF;
3507: END IF;
3508:
3509: if (CZ_IMP_ALL.get_time) then
3510: bom_explode_st := dbms_utility.get_time();
3511: end if;
3512:
3513: IF((inRunExploder = 1) and (NOT(GET_REMOTE_IMPORT))) THEN

Line 3554: xERROR:=CZ_IMP_ALL.REPORT(outErr_msg, 1, 'BOM_EXPLODER', 11276);

3550:
3551: --If found, explosion is not up-to-date.
3552:
3553: outErr_msg := CZ_UTILS.GET_TEXT('CZ_IMP_STALE_EXPLOSION');
3554: xERROR:=CZ_IMP_ALL.REPORT(outErr_msg, 1, 'BOM_EXPLODER', 11276);
3555: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3556: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3557: RETURN nModelId;
3558:

Line 3568: if (CZ_IMP_ALL.get_time) then

3564: NULL;
3565: END;
3566: END IF;
3567:
3568: if (CZ_IMP_ALL.get_time) then
3569: bom_explode_end := dbms_utility.get_time();
3570: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3571: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3572: end if;

Line 3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);

3832: FROM cz_servers
3833: WHERE import_enabled = v_enabled;
3834: EXCEPTION
3835: WHEN TOO_MANY_ROWS THEN
3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3837: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3838: WHEN NO_DATA_FOUND THEN
3839: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3840: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

Line 3839: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);

3835: WHEN TOO_MANY_ROWS THEN
3836: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3837: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3838: WHEN NO_DATA_FOUND THEN
3839: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3840: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3841: END;
3842:
3843: IF(server_id > 0)THEN

Line 3845: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_LANGUAGES_DO_NOT_MATCH'),1,'CZ_IMP_ALL.ImportSingleBill',11276);

3841: END;
3842:
3843: IF(server_id > 0)THEN
3844: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN
3845: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_LANGUAGES_DO_NOT_MATCH'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3846: RAISE CZ_ADMIN.CZ_LANGUAGES_DO_NOT_MATCH;
3847: END IF;
3848: END IF;
3849:

Line 3995: if (CZ_IMP_ALL.get_time) then

3991: OPEN C_BILL_OF_MATERIAL;
3992: FETCH C_BILL_OF_MATERIAL INTO cFound;
3993: IF(C_BILL_OF_MATERIAL%FOUND)THEN
3994:
3995: if (CZ_IMP_ALL.get_time) then
3996: extract_st := dbms_utility.get_time();
3997: end if;
3998:
3999: --LA 9595142 Clear import_enabled_tbl before and after extraction

Line 4033: if (CZ_IMP_ALL.get_time) then

4029: RAISE FAILED_TO_LOCK_MODEL;
4030: END IF;
4031: END LOOP;
4032:
4033: if (CZ_IMP_ALL.get_time) then
4034: extract_end := dbms_utility.get_time();
4035: d_str := genRun_Id || ' EXTRACT PS - TOTAL (' || nTop_Id || ') :' || (extract_end-extract_st)/100.00;
4036: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
4037: end if;

Line 4103: if (CZ_IMP_ALL.get_time) then

4099: inventoryItemId.DELETE;
4100: repItemId.DELETE;
4101: hashCatalog.DELETE;
4102:
4103: if (CZ_IMP_ALL.get_time) then
4104: st_time := dbms_utility.get_time();
4105: end if;
4106:
4107: l_lang := userenv('LANG');

Line 4148: if (CZ_IMP_ALL.get_time) then

4144: WHEN NO_DATA_FOUND THEN
4145: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);
4146: END;
4147:
4148: if (CZ_IMP_ALL.get_time) then
4149: end_time := dbms_utility.get_time();
4150: d_str := genRun_Id ||' Collect Catalog group id (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
4151: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);
4152: end if;

Line 4290: cz_imp_all.setReturnCode(cz_imp_all.CONCURRENT_WARNING,'Model contains option class that does not have effective children.');

4286: xERROR :=CZ_UTILS.LOG_REPORT('Model ''' || lNoChildOCModelName(i) ||
4287: ''' contains an option class that has no effective children, option class ''' || lNoChildOCName(i) || '''.',
4288: 1, 'CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC', 11276,genRun_ID);
4289: END LOOP;
4290: cz_imp_all.setReturnCode(cz_imp_all.CONCURRENT_WARNING,'Model contains option class that does not have effective children.');
4291: END IF;
4292: EXCEPTION
4293: WHEN OTHERS THEN
4294: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC',11276,genRun_ID);