APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_ALL

Line 187: if (CZ_IMP_ALL.get_time) then

183: OPEN C_REF_PART_NBR;
184: FETCH C_REF_PART_NBR INTO DFLT_REFPARTNBR;
185: CLOSE C_REF_PART_NBR;
186:
187: if (CZ_IMP_ALL.get_time) then
188: st_time := dbms_utility.get_time();
189: end if;
190:
191: SELECT DISTINCT INVENTORY_ITEM_ID, ORGANIZATION_ID, SEGMENT1, CONCATENATED_SEGMENTS, ITEM_DESC,

Line 204: if (CZ_IMP_ALL.get_time) then

200: FROM CZ_EXV_ITEMS
201: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID
202: AND EXPLOSION_TYPE=sExpl_type;
203:
204: if (CZ_IMP_ALL.get_time) then
205: end_time := dbms_utility.get_time();
206: d_str := inRun_Id || ' Bulk collect item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
207: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);
208: end if;

Line 258: if (CZ_IMP_ALL.get_time) then

254:
255: nIndex := nIndex + 1;
256: END LOOP;
257:
258: if (CZ_IMP_ALL.get_time) then
259: loop_end_time := dbms_utility.get_time();
260: --dbms_output.put_line ('loop over coll. (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00);
261: end if;
262:

Line 277: if (CZ_IMP_ALL.get_time) then

273: inRun_ID, iPrimaryUomCode(i), iDecimalQtyFlag(i),
274: iFskItemType(i), iFskItemType(i),
275: iSrcApplicationId(i), iSrcTypeCode(i));
276:
277: if (CZ_IMP_ALL.get_time) then
278: insert_end_time := dbms_utility.get_time();
279: --dbms_output.put_line ('Insert imp item master (' || nTop_Id || ') :' || (insert_end_time-end_time)/100.00);
280: end if;
281:

Line 823: if (CZ_IMP_ALL.get_time) then

819:
820:
821: nIndex := 1;
822:
823: if (CZ_IMP_ALL.get_time) then
824: st_time := dbms_utility.get_time();
825: end if;
826:
827: l_lang := userenv('LANG');

Line 849: if (CZ_IMP_ALL.get_time) then

845: EXIT;
846: END IF;
847: END IF;
848:
849: if (CZ_IMP_ALL.get_time) then
850: end_time := dbms_utility.get_time();
851: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
852: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
853: end if;

Line 855: if (CZ_IMP_ALL.get_time) then

851: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
852: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
853: end if;
854:
855: if (CZ_IMP_ALL.get_time) then
856: st_time := dbms_utility.get_time();
857: end if;
858:
859: --dbms_output.put_line('COUNT IS:'||ComponentItemId.COUNT);

Line 1318: if (CZ_IMP_ALL.get_time) then

1314: END IF;
1315: END IF;
1316: END LOOP;
1317:
1318: if (CZ_IMP_ALL.get_time) then
1319: end_time := dbms_utility.get_time();
1320: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1321: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1322: end if;

Line 1324: if (CZ_IMP_ALL.get_time) then

1320: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1321: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1322: end if;
1323:
1324: if (CZ_IMP_ALL.get_time) then
1325: st_time := dbms_utility.get_time();
1326: end if;
1327:
1328:

Line 1397: if (CZ_IMP_ALL.get_time) then

1393: iQuoteableFlag(i),iPrimaryUomCode(i),iBomSortOrder(i), iComponentSequencePath(i),iBTrackableFlag(i),
1394: iSrcApplicationId(i), ifskItemMaster22(i), iIBLinkItemFlag(i),
1395: iShippableItemFlag(i), iInventoryTransactableFlag(i), iAssembleToOrder(i), iSerializableItemFlag(i)); -- changes for TSO
1396:
1397: if (CZ_IMP_ALL.get_time) then
1398: end_time := dbms_utility.get_time();
1399: d_str := inRun_Id || ' Insert ps nodes (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1400: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1401: end if;

Line 1511: if (CZ_IMP_ALL.get_time) then

1507: p_out_err INTEGER;
1508:
1509: BEGIN
1510:
1511: if (CZ_IMP_ALL.get_time) then
1512: st_time := dbms_utility.get_time();
1513: end if;
1514:
1515: OPEN c_onl_ps_node;

Line 1560: if (CZ_IMP_ALL.get_time) then

1556: END IF;
1557:
1558: END LOOP;
1559:
1560: if (CZ_IMP_ALL.get_time) then
1561: end_time := dbms_utility.get_time();
1562: d_str := inRun_Id || ' Deleted ps node check (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1563: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1564: end if;

Line 1782: if (CZ_IMP_ALL.get_time) then

1778:
1779: END LOOP;
1780: END IF;
1781:
1782: if (CZ_IMP_ALL.get_time) then
1783: end_time := dbms_utility.get_time();
1784: d_str := inRun_Id || ' Extract text (' || nTop_Id || ' - Count - ' || iLocalizedStr.COUNT || ') :' || (end_time-st_time)/100.00;
1785: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1786: end if;

Line 1852: if (CZ_IMP_ALL.get_time) then

1848: l_lang VARCHAR2(4);
1849:
1850: BEGIN
1851: gModelItemId_tbl.delete;
1852: if (CZ_IMP_ALL.get_time) then
1853: st_time := dbms_utility.get_time();
1854: end if;
1855:
1856: l_lang := userenv('LANG');

Line 1868: if (CZ_IMP_ALL.get_time) then

1864: AND ORGANIZATION_ID=nOrg_ID
1865: AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type
1866: AND language = l_lang;
1867:
1868: if (CZ_IMP_ALL.get_time) then
1869: end_time := dbms_utility.get_time();
1870: d_str := inRun_Id || ' Extract projects (' || nTop_Id || ' - Count - ' || OrganizationId.COUNT || ') :' || (end_time-st_time)/100.00;
1871: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1872: end if;

Line 1897: if (CZ_IMP_ALL.get_time) then

1893:
1894: nIndex := nIndex + 1;
1895: END LOOP;
1896:
1897: if (CZ_IMP_ALL.get_time) then
1898: loop_end_time := dbms_utility.get_time();
1899: d_str := inRun_Id || ' Loop Projects (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
1900: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1901: end if;

Line 1913: if (CZ_IMP_ALL.get_time) then

1909: (nOrg_ID, iTopItemId(i), sExpl_type, iOrigSysRef(i), 1,
1910: inRun_ID, iName(i), iDescText(i), iDescText(i), iPlanLevel(i), nModelId, iModelType(i),
1911: iInventoryItemId(i), iProductKey(i), G_CAPTION_RULE_DESC, G_CAPTION_RULE_NAME, g_CONFIG_ENGINE_TYPE);
1912:
1913: if (CZ_IMP_ALL.get_time) then
1914: insert_end_time := dbms_utility.get_time();
1915: d_str := inRun_Id || ' Insert projects (' || nTop_Id || ') :' || (insert_end_time-loop_end_time)/100.00;
1916: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1917: end if;

Line 1948: if (CZ_IMP_ALL.get_time) then

1944: l_use_segments BOOLEAN:=FALSE;
1945: l_name_method VARCHAR2(255);
1946:
1947: BEGIN
1948: if (CZ_IMP_ALL.get_time) then
1949: st_time := dbms_utility.get_time();
1950: end if;
1951:
1952: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);

Line 1976: if (CZ_IMP_ALL.get_time) then

1972: FROM CZ_EXV_ITEM_TYPES
1973: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
1974: END IF;
1975:
1976: if (CZ_IMP_ALL.get_time) then
1977: end_time := dbms_utility.get_time();
1978: d_str := inRun_Id || ' Insert item type (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1979: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1980: end if;

Line 2633: if (CZ_IMP_ALL.get_time) then

2629: v_section_name VARCHAR2(30);
2630:
2631: BEGIN
2632:
2633: if (CZ_IMP_ALL.get_time) then
2634: st_time := dbms_utility.get_time();
2635: end if;
2636:
2637: FORALL i IN 1..itemCatalogGroupId.COUNT

Line 2644: if (CZ_IMP_ALL.get_time) then

2640: SELECT DESCRIPTION, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID, TEXT_TYPE, G_BOM_APPLICATION_ID
2641: FROM CZ_EXV_ITEM_PROPERTIES
2642: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2643:
2644: if (CZ_IMP_ALL.get_time) then
2645: end_time := dbms_utility.get_time();
2646: d_str := inRun_Id || ' Insert property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2647: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2648: end if;

Line 2737: if (CZ_IMP_ALL.get_time) then

2733: WHERE CURRENT OF C_DATATYPE;
2734: END IF;
2735: END LOOP;
2736: CLOSE C_DATATYPE;
2737: if (CZ_IMP_ALL.get_time) then
2738: loop_end_time := dbms_utility.get_time();
2739: d_str := inRun_Id || ' Resolve property datatype (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
2740: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2741: end if;

Line 2771: if (CZ_IMP_ALL.get_time) then

2767: d_str varchar2(255);
2768:
2769: BEGIN
2770:
2771: if (CZ_IMP_ALL.get_time) then
2772: st_time := dbms_utility.get_time();
2773: end if;
2774:
2775: FORALL i IN 1..itemCatalogGroupId.COUNT

Line 2784: if (CZ_IMP_ALL.get_time) then

2780: TO_CHAR(ITEM_CATALOG_GROUP_ID) || ':' || ELEMENT_NAME, G_BOM_APPLICATION_ID
2781: FROM CZ_EXV_ITEM_PROPERTIES
2782: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2783:
2784: if (CZ_IMP_ALL.get_time) then
2785: end_time := dbms_utility.get_time();
2786: d_str := inRun_Id || ' Insert item Type prop (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2787: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2788: end if;

Line 2819: if(CZ_IMP_ALL.get_time) then

2815: d_str varchar2(255);
2816:
2817: BEGIN
2818:
2819: if(CZ_IMP_ALL.get_time) then
2820: st_time := dbms_utility.get_time();
2821: end if;
2822:
2823: FORALL i IN 1..inventoryItemId.COUNT

Line 2841: if (CZ_IMP_ALL.get_time) then

2837: WHERE INVENTORY_ITEM_ID = inventoryItemId(i)
2838: AND ORGANIZATION_ID = nOrg_ID
2839: AND ELEMENT_VALUE IS NOT NULL;
2840:
2841: if (CZ_IMP_ALL.get_time) then
2842: loop_end_time := dbms_utility.get_time();
2843: d_str := inRun_Id || ' Bulk collect prop val (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2844: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2845: end if;

Line 2877: if (CZ_IMP_ALL.get_time) then

2873: BEGIN
2874: --DBMS_OUTPUT.ENABLE;
2875: --DBMS_OUTPUT.PUT_LINE('EXTRACTING TABLE: ' || lower_table_name);
2876: IF(lower_table_name='cz_item_masters') THEN
2877: if (CZ_IMP_ALL.get_time) then
2878: st_time := dbms_utility.get_time();
2879: end if;
2880: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2881: if (CZ_IMP_ALL.get_time) then

Line 2881: if (CZ_IMP_ALL.get_time) then

2877: if (CZ_IMP_ALL.get_time) then
2878: st_time := dbms_utility.get_time();
2879: end if;
2880: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2881: if (CZ_IMP_ALL.get_time) then
2882: end_time := dbms_utility.get_time();
2883: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2884: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2885: end if;

Line 2887: if (CZ_IMP_ALL.get_time) then

2883: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2884: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2885: end if;
2886: ELSIF(lower_table_name='cz_ps_nodes') THEN
2887: if (CZ_IMP_ALL.get_time) then
2888: st_time := dbms_utility.get_time();
2889: end if;
2890: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2891: if (CZ_IMP_ALL.get_time) then

Line 2891: if (CZ_IMP_ALL.get_time) then

2887: if (CZ_IMP_ALL.get_time) then
2888: st_time := dbms_utility.get_time();
2889: end if;
2890: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2891: if (CZ_IMP_ALL.get_time) then
2892: end_time := dbms_utility.get_time();
2893: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2894: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2895: end if;

Line 2897: if (CZ_IMP_ALL.get_time) then

2893: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2894: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2895: end if;
2896: ELSIF(lower_table_name='cz_localized_texts') THEN
2897: if (CZ_IMP_ALL.get_time) then
2898: st_time := dbms_utility.get_time();
2899: end if;
2900: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2901: if (CZ_IMP_ALL.get_time) then

Line 2901: if (CZ_IMP_ALL.get_time) then

2897: if (CZ_IMP_ALL.get_time) then
2898: st_time := dbms_utility.get_time();
2899: end if;
2900: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2901: if (CZ_IMP_ALL.get_time) then
2902: end_time := dbms_utility.get_time();
2903: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2904: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2905: end if;

Line 2907: if (CZ_IMP_ALL.get_time) then

2903: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2904: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2905: end if;
2906: ELSIF(lower_table_name='cz_devl_projects') THEN
2907: if (CZ_IMP_ALL.get_time) then
2908: st_time := dbms_utility.get_time();
2909: end if;
2910: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2911: if (CZ_IMP_ALL.get_time) then

Line 2911: if (CZ_IMP_ALL.get_time) then

2907: if (CZ_IMP_ALL.get_time) then
2908: st_time := dbms_utility.get_time();
2909: end if;
2910: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2911: if (CZ_IMP_ALL.get_time) then
2912: end_time := dbms_utility.get_time();
2913: d_str := inRun_Id || ' Extract devl project (' || 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 2917: if (CZ_IMP_ALL.get_time) then

2913: d_str := inRun_Id || ' Extract devl project (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2914: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2915: end if;
2916: ELSIF(lower_table_name='cz_item_types') THEN
2917: if (CZ_IMP_ALL.get_time) then
2918: st_time := dbms_utility.get_time();
2919: end if;
2920: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2921: if (CZ_IMP_ALL.get_time) then

Line 2921: if (CZ_IMP_ALL.get_time) then

2917: if (CZ_IMP_ALL.get_time) then
2918: st_time := dbms_utility.get_time();
2919: end if;
2920: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2921: if (CZ_IMP_ALL.get_time) then
2922: end_time := dbms_utility.get_time();
2923: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2924: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2925: end if;

Line 2927: if (CZ_IMP_ALL.get_time) then

2923: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2924: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2925: end if;
2926: ELSIF(lower_table_name='cz_properties') THEN
2927: if (CZ_IMP_ALL.get_time) then
2928: st_time := dbms_utility.get_time();
2929: end if;
2930: EXTR_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2931:

Line 2937: if (CZ_IMP_ALL.get_time) then

2933: p_org_id => nOrg_ID,
2934: p_top_item_id => nTop_ID,
2935: p_expl_type => sExpl_type);
2936:
2937: if (CZ_IMP_ALL.get_time) then
2938: end_time := dbms_utility.get_time();
2939: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2940: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2941: end if;

Line 2943: if (CZ_IMP_ALL.get_time) then

2939: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2940: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2941: end if;
2942: ELSIF(lower_table_name='cz_item_type_properties') THEN
2943: if (CZ_IMP_ALL.get_time) then
2944: st_time := dbms_utility.get_time();
2945: end if;
2946: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2947: if (CZ_IMP_ALL.get_time) then

Line 2947: if (CZ_IMP_ALL.get_time) then

2943: if (CZ_IMP_ALL.get_time) then
2944: st_time := dbms_utility.get_time();
2945: end if;
2946: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2947: if (CZ_IMP_ALL.get_time) then
2948: end_time := dbms_utility.get_time();
2949: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2950: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2951: end if;

Line 2953: if (CZ_IMP_ALL.get_time) then

2949: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2950: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2951: end if;
2952: ELSIF(lower_table_name='cz_item_property_values') THEN
2953: if (CZ_IMP_ALL.get_time) then
2954: st_time := dbms_utility.get_time();
2955: end if;
2956: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2957: if (CZ_IMP_ALL.get_time) then

Line 2957: if (CZ_IMP_ALL.get_time) then

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

Line 2989: if (CZ_IMP_ALL.get_time) then

2985: BEGIN
2986: --DBMS_OUTPUT.ENABLE;
2987: --DBMS_OUTPUT.PUT_LINE('IMPORTING TABLE: ' || lower_table_name);
2988: IF(lower_table_name='cz_item_masters') THEN
2989: if (CZ_IMP_ALL.get_time) then
2990: st_time := dbms_utility.get_time();
2991: end if;
2992: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
2993: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 2994: if (CZ_IMP_ALL.get_time) then

2990: st_time := dbms_utility.get_time();
2991: end if;
2992: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
2993: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
2994: if (CZ_IMP_ALL.get_time) then
2995: end_time := dbms_utility.get_time();
2996: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
2997: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
2998: end if;

Line 3000: if (CZ_IMP_ALL.get_time) then

2996: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
2997: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
2998: end if;
2999: ELSIF(lower_table_name='cz_ps_nodes') THEN
3000: if (CZ_IMP_ALL.get_time) then
3001: st_time := dbms_utility.get_time();
3002: end if;
3003: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3004: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 3005: if (CZ_IMP_ALL.get_time) then

3001: st_time := dbms_utility.get_time();
3002: end if;
3003: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3004: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3005: if (CZ_IMP_ALL.get_time) then
3006: end_time := dbms_utility.get_time();
3007: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3008: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3009: end if;

Line 3011: if (CZ_IMP_ALL.get_time) then

3007: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3008: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3009: end if;
3010: ELSIF(lower_table_name='cz_localized_texts') THEN
3011: if (CZ_IMP_ALL.get_time) then
3012: st_time := dbms_utility.get_time();
3013: end if;
3014: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3015: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 3016: if (CZ_IMP_ALL.get_time) then

3012: st_time := dbms_utility.get_time();
3013: end if;
3014: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3015: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3016: if (CZ_IMP_ALL.get_time) then
3017: end_time := dbms_utility.get_time();
3018: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3019: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3020: end if;

Line 3022: if (CZ_IMP_ALL.get_time) then

3018: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3019: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3020: end if;
3021: ELSIF(lower_table_name='cz_devl_projects') THEN
3022: if (CZ_IMP_ALL.get_time) then
3023: st_time := dbms_utility.get_time();
3024: end if;
3025: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3026: Inserts, Updates, x_failed, Dups,

Line 3028: if (CZ_IMP_ALL.get_time) then

3024: end if;
3025: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3026: Inserts, Updates, x_failed, Dups,
3027: inXFR_GROUP,p_rp_folder_id);
3028: if (CZ_IMP_ALL.get_time) then
3029: end_time := dbms_utility.get_time();
3030: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3031: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3032: end if;

Line 3034: if (CZ_IMP_ALL.get_time) then

3030: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3031: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3032: end if;
3033: ELSIF(lower_table_name='cz_item_property_values') THEN
3034: if (CZ_IMP_ALL.get_time) then
3035: st_time := dbms_utility.get_time();
3036: end if;
3037: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3038: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 3039: if (CZ_IMP_ALL.get_time) then

3035: st_time := dbms_utility.get_time();
3036: end if;
3037: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3038: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3039: if (CZ_IMP_ALL.get_time) then
3040: end_time := dbms_utility.get_time();
3041: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3042: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3043: end if;

Line 3045: if (CZ_IMP_ALL.get_time) then

3041: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3042: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3043: end if;
3044: ELSIF(lower_table_name='cz_item_types') THEN
3045: if (CZ_IMP_ALL.get_time) then
3046: st_time := dbms_utility.get_time();
3047: end if;
3048: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3049: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 3050: if (CZ_IMP_ALL.get_time) then

3046: st_time := dbms_utility.get_time();
3047: end if;
3048: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3049: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3050: if (CZ_IMP_ALL.get_time) then
3051: end_time := dbms_utility.get_time();
3052: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3053: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3054: end if;

Line 3056: if (CZ_IMP_ALL.get_time) then

3052: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3053: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3054: end if;
3055: ELSIF(lower_table_name='cz_item_type_properties') THEN
3056: if (CZ_IMP_ALL.get_time) then
3057: st_time := dbms_utility.get_time();
3058: end if;
3059: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3060: Inserts, Updates, x_failed, Dups, inXFR_GROUP);

Line 3061: if (CZ_IMP_ALL.get_time) then

3057: st_time := dbms_utility.get_time();
3058: end if;
3059: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3060: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3061: if (CZ_IMP_ALL.get_time) then
3062: end_time := dbms_utility.get_time();
3063: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3064: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3065: end if;

Line 3067: if (CZ_IMP_ALL.get_time) then

3063: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3064: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3065: end if;
3066: ELSIF(lower_table_name='cz_properties') THEN
3067: if (CZ_IMP_ALL.get_time) then
3068: st_time := dbms_utility.get_time();
3069: end if;
3070: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3071: Inserts, Updates, x_failed, Dups, inXFR_GROUP, p_rp_folder_id);

Line 3072: if (CZ_IMP_ALL.get_time) then

3068: st_time := dbms_utility.get_time();
3069: end if;
3070: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3071: Inserts, Updates, x_failed, Dups, inXFR_GROUP, p_rp_folder_id);
3072: if (CZ_IMP_ALL.get_time) then
3073: end_time := dbms_utility.get_time();
3074: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3075: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3076: end if;

Line 3281: if (CZ_IMP_ALL.get_time) then

3277:
3278: END IF;
3279: END IF;
3280:
3281: if (CZ_IMP_ALL.get_time) then
3282: bom_explode_st := dbms_utility.get_time();
3283: end if;
3284:
3285: IF((inRunExploder = 1) and (NOT(GET_REMOTE_IMPORT))) THEN

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

3322:
3323: --If found, explosion is not up-to-date.
3324:
3325: outErr_msg := CZ_UTILS.GET_TEXT('CZ_IMP_STALE_EXPLOSION');
3326: xERROR:=CZ_IMP_ALL.REPORT(outErr_msg, 1, 'BOM_EXPLODER', 11276);
3327: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3328: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3329: RETURN nModelId;
3330:

Line 3340: if (CZ_IMP_ALL.get_time) then

3336: NULL;
3337: END;
3338: END IF;
3339:
3340: if (CZ_IMP_ALL.get_time) then
3341: bom_explode_end := dbms_utility.get_time();
3342: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3343: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3344: end if;

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

3519: FROM cz_servers
3520: WHERE import_enabled = v_enabled;
3521: EXCEPTION
3522: WHEN TOO_MANY_ROWS THEN
3523: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3524: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3525: WHEN NO_DATA_FOUND THEN
3526: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3527: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;

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

3522: WHEN TOO_MANY_ROWS THEN
3523: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3524: RAISE CZ_ADMIN.IMP_TOO_MANY_SERVERS;
3525: WHEN NO_DATA_FOUND THEN
3526: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMP_SERVERS'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3527: RAISE CZ_ADMIN.IMP_NO_IMP_SERVER;
3528: END;
3529:
3530: IF(server_id > 0)THEN

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

3528: END;
3529:
3530: IF(server_id > 0)THEN
3531: IF(CZ_UTILS.check_installed_lang(server_id) <> 0)THEN
3532: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_LANGUAGES_DO_NOT_MATCH'),1,'CZ_IMP_ALL.ImportSingleBill',11276);
3533: RAISE CZ_ADMIN.CZ_LANGUAGES_DO_NOT_MATCH;
3534: END IF;
3535: END IF;
3536:

Line 3668: if (CZ_IMP_ALL.get_time) then

3664: OPEN C_BILL_OF_MATERIAL;
3665: FETCH C_BILL_OF_MATERIAL INTO cFound;
3666: IF(C_BILL_OF_MATERIAL%FOUND)THEN
3667:
3668: if (CZ_IMP_ALL.get_time) then
3669: extract_st := dbms_utility.get_time();
3670: end if;
3671:
3672: -- Clear processed_expl_tbl before and after ps node extraction.

Line 3700: if (CZ_IMP_ALL.get_time) then

3696: RAISE FAILED_TO_LOCK_MODEL;
3697: END IF;
3698: END LOOP;
3699:
3700: if (CZ_IMP_ALL.get_time) then
3701: extract_end := dbms_utility.get_time();
3702: d_str := genRun_Id || ' EXTRACT PS - TOTAL (' || nTop_Id || ') :' || (extract_end-extract_st)/100.00;
3703: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
3704: end if;

Line 3753: if (CZ_IMP_ALL.get_time) then

3749: inventoryItemId.DELETE;
3750: repItemId.DELETE;
3751: hashCatalog.DELETE;
3752:
3753: if (CZ_IMP_ALL.get_time) then
3754: st_time := dbms_utility.get_time();
3755: end if;
3756:
3757: l_lang := userenv('LANG');

Line 3798: if (CZ_IMP_ALL.get_time) then

3794: WHEN NO_DATA_FOUND THEN
3795: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);
3796: END;
3797:
3798: if (CZ_IMP_ALL.get_time) then
3799: end_time := dbms_utility.get_time();
3800: d_str := genRun_Id ||' Collect Catalog group id (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3801: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);
3802: end if;