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_ORAAPPS_INTEGRATE

Line 212: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(InventoryItemId(i)),to_char(OrganizationId(i)));

208: end if;
209:
210: FOR i IN 1..InventoryItemId.COUNT LOOP
211:
212: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(InventoryItemId(i)),to_char(OrganizationId(i)));
213: IF(DFLT_REFPARTNBR = 'SEGMENT1')THEN
214: iRefPartNbr(nIndex) := Segment1(i);
215: ELSIF(DFLT_REFPARTNBR = 'CONCATENATED_SEGMENTS')THEN
216: iRefPartNbr(nIndex) := ConcatenatedSegments(i);

Line 923: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(iComponentCode(nIndex),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

919:
920: iPsNodeType(nIndex) := cnReference;
921: iComponentCode(nIndex) := ShiftComponentCode(ComponentCode(i), StackPlanLevel(nStack));
922: iComponentSequencePath(nIndex) := ComponentSequencePath;
923: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(iComponentCode(nIndex),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
924: iPlanLevel(nIndex) := PlanLevel(i) - StackPlanLevel(nStack);
925:
926: --DBMS_OUTPUT.PUT_LINE('PlanLevel('||i||')='||PlanLevel(i));
927: --DBMS_OUTPUT.PUT_LINE('StackPlanLevel('||nStack||')='||StackPlanLevel(nStack));

Line 932: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),

928: --DBMS_OUTPUT.PUT_LINE('iPlanLevel('||nIndex||')='||iPlanLevel(nIndex));
929:
930: IF(x_usesurr_psnode = 0)THEN
931: ifskParentNode(nIndex) :=
932: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
933: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
934: ifskParentNodeExt(nIndex) := NULL;
935: ELSE
936: ifskParentNode(nIndex) := NULL;

Line 938: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),

934: ifskParentNodeExt(nIndex) := NULL;
935: ELSE
936: ifskParentNode(nIndex) := NULL;
937: ifskParentNodeExt(nIndex) :=
938: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
939: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
940: END IF;
941:
942: IF(x_usesurr_devlproject = 0)THEN

Line 943: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

939: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
940: END IF;
941:
942: IF(x_usesurr_devlproject = 0)THEN
943: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
944: ifskDevlProjectExt(nIndex) := NULL;
945: ELSE
946: ifskDevlProject(nIndex) := NULL;
947: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

Line 947: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

943: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
944: ifskDevlProjectExt(nIndex) := NULL;
945: ELSE
946: ifskDevlProject(nIndex) := NULL;
947: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
948: END IF;
949:
950: ifskReference(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));
951: iOrganizationId(nIndex) := OrganizationId(i);

Line 950: ifskReference(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));

946: ifskDevlProject(nIndex) := NULL;
947: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
948: END IF;
949:
950: ifskReference(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));
951: iOrganizationId(nIndex) := OrganizationId(i);
952: iTopItemId(nIndex) := StackTopItemId(nStack);
953: iExplosionType(nIndex) := ExplosionType(i);
954:

Line 989: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

985: ifskIntlTextExt(nIndex) := ComponentItemId(i) || ':' || ExplosionType(i) || ':' || OrganizationId(i) || ':'|| ComponentSequenceId(i);
986: END IF;
987:
988: IF(x_usesurr_itemmaster = 0)THEN
989: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
990: ifskItemMasterExt(nIndex) := NULL;
991: ELSE
992: ifskItemMaster(nIndex) := NULL;
993: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

Line 993: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

989: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
990: ifskItemMasterExt(nIndex) := NULL;
991: ELSE
992: ifskItemMaster(nIndex) := NULL;
993: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
994: END IF;
995:
996: iMutuallyExclusive(nIndex) := MutuallyExclusiveOptions(i);
997: iOptional(nIndex) := v_Optional(i);

Line 1083: thisOrigSysRef := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));

1079: --DBMS_OUTPUT.PUT_LINE('IF i> comp ... ModelType: '||ModelType(i));
1080: StackModelType(nStack) := ModelType(i);
1081:
1082: END IF;
1083: thisOrigSysRef := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));
1084:
1085: --Check if the model has already been processed in this session
1086:
1087: --DBMS_OUTPUT.PUT_LINE('Verifying model...');

Line 1124: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(iComponentCode(nIndex),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

1120: iPsNodeType(nIndex) := bomStandard;
1121: END IF;
1122: iComponentCode(nIndex) := ShiftComponentCode(ComponentCode(i), StackPlanLevel(nStack));
1123: iComponentSequencePath(nIndex) := ComponentSequencePath;
1124: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(iComponentCode(nIndex),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1125: iPlanLevel(nIndex) := PlanLevel(i) - StackPlanLevel(nStack);
1126:
1127: --DBMS_OUTPUT.PUT_LINE('PlanLevel('||i||')='||PlanLevel(i));
1128: --DBMS_OUTPUT.PUT_LINE('StackPlanLevel('||nStack||')='||StackPlanLevel(nStack));

Line 1136: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),

1132: IF(BomItemType(i) = cnModel)THEN
1133: ifskParentNode(nIndex) := NULL;
1134: ELSE
1135: ifskParentNode(nIndex) :=
1136: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
1137: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1138: END IF;
1139: ifskParentNodeExt(nIndex) := NULL;
1140: ELSE

Line 1146: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),

1142: IF(BomItemType(i) = cnModel)THEN
1143: ifskParentNodeExt(nIndex) := NULL;
1144: ELSE
1145: ifskParentNodeExt(nIndex) :=
1146: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
1147: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1148: END IF;
1149: END IF;
1150:

Line 1152: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

1148: END IF;
1149: END IF;
1150:
1151: IF(x_usesurr_devlproject = 0)THEN
1152: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1153: ifskDevlProjectExt(nIndex) := NULL;
1154: ELSE
1155: ifskDevlProject(nIndex) := NULL;
1156: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

Line 1156: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

1152: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1153: ifskDevlProjectExt(nIndex) := NULL;
1154: ELSE
1155: ifskDevlProject(nIndex) := NULL;
1156: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1157: END IF;
1158:
1159: ifskReference(nIndex) := NULL;
1160: iOrganizationId(nIndex) := OrganizationId(i);

Line 1231: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

1227: -- ifskIntlTextExt(nIndex) := Description(i);
1228: END IF;
1229:
1230: IF(x_usesurr_itemmaster = 0)THEN
1231: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1232: ifskItemMasterExt(nIndex) := NULL;
1233: ELSE
1234: ifskItemMaster(nIndex) := NULL;
1235: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

Line 1235: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

1231: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1232: ifskItemMasterExt(nIndex) := NULL;
1233: ELSE
1234: ifskItemMaster(nIndex) := NULL;
1235: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1236: END IF;
1237:
1238: iMutuallyExclusive(nIndex) := MutuallyExclusiveOptions(i);
1239: iOptional(nIndex) := v_Optional(i);

Line 1746: iFSKDevlProject := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(l_parent_model_id));

1742: ElSE
1743: l_parent_model_id := nTop_ID; -- the item belongs to the top model
1744: END IF;
1745:
1746: iFSKDevlProject := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(l_parent_model_id));
1747:
1748: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
1749: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, FSK_DEVLPROJECT_1_1)
1750: VALUES (iLocalizedStr(i), iLanguage(i), iSrcLang(i), inRun_ID,

Line 1771: CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(gModelItemId_tbl(j)))

1767: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, FSK_DEVLPROJECT_1_1)
1768: SELECT description, language, source_lang, inRun_ID,
1769: gModelItemId_tbl(j)||':'||sExpl_type||':'||nOrg_ID||':'||
1770: NVL(common_component_sequence_id, component_sequence_id),
1771: CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(gModelItemId_tbl(j)))
1772: FROM cz_exv_intl_text
1773: WHERE organization_id = nOrg_ID
1774: AND top_item_id = gModelItemId_tbl(j)
1775: AND explosion_type = sExpl_type

Line 1876: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),to_char(OrganizationId(i)),to_char(ComponentItemId(i)));

1872: end if;
1873:
1874: FOR i IN 1..OrganizationId.COUNT LOOP
1875:
1876: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),to_char(OrganizationId(i)),to_char(ComponentItemId(i)));
1877: iName(nIndex) := Description(i) || '(' || to_char(OrganizationId(i)) || ' ' || to_char(ComponentItemId(i)) || ')';
1878: iDescText(nIndex) := SUBSTR(Description(i), 1, 255);
1879: iPlanLevel(nIndex) := PlanLevel(i);
1880: iTopItemId(nIndex) := ComponentItemId(i);

Line 2831: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),

2827: FSK_ITEMMASTER_2_EXT,
2828: RUN_ID,
2829: ORIG_SYS_REF, SRC_APPLICATION_ID)
2830: SELECT ELEMENT_VALUE, ELEMENT_NAME, ELEMENT_NAME,
2831: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2832: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2833: inRun_ID,
2834: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,
2835: G_BOM_APPLICATION_ID

Line 2832: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),

2828: RUN_ID,
2829: ORIG_SYS_REF, SRC_APPLICATION_ID)
2830: SELECT ELEMENT_VALUE, ELEMENT_NAME, ELEMENT_NAME,
2831: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2832: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2833: inRun_ID,
2834: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,
2835: G_BOM_APPLICATION_ID
2836: FROM CZ_EXV_ITEM_PROPERTY_VALUES

Line 2834: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,

2830: SELECT ELEMENT_VALUE, ELEMENT_NAME, ELEMENT_NAME,
2831: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2832: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2833: inRun_ID,
2834: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,
2835: G_BOM_APPLICATION_ID
2836: FROM CZ_EXV_ITEM_PROPERTY_VALUES
2837: WHERE INVENTORY_ITEM_ID = inventoryItemId(i)
2838: AND ORGANIZATION_ID = nOrg_ID

Line 3304: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;

3300: END IF;
3301:
3302: IF(outError_code <> 0)THEN
3303: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);
3304: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3305: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3306: RETURN nModelId;
3307: END IF;
3308: ELSE

Line 3305: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;

3301:
3302: IF(outError_code <> 0)THEN
3303: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);
3304: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3305: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3306: RETURN nModelId;
3307: END IF;
3308: ELSE
3309:

Line 3327: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;

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:
3331: EXCEPTION

Line 3328: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;

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:
3331: EXCEPTION
3332: WHEN NO_DATA_FOUND THEN

Line 3389: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN nModelId; END IF;

3385: inRunExploder, inRevDate, inDateFormat, -1, 0, 0, 0);
3386: END IF;
3387:
3388: tabCompCode(tabCompCode.COUNT + 1) := compCode;
3389: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN nModelId; END IF;
3390: END IF;
3391:
3392: -- Explosion has been processed, add to array
3393: processed_expls_tbl(nTopItemId) := 1;

Line 3706: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;

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;
3705:
3706: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;
3707:
3708: UPDATE CZ_XFR_PROJECT_BILLS SET
3709: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'0',SOURCE_BILL_DELETED)
3710: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;