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 234: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(InventoryItemId(i)),to_char(OrganizationId(i)));

230: end if;
231:
232: FOR i IN 1..InventoryItemId.COUNT LOOP
233:
234: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(InventoryItemId(i)),to_char(OrganizationId(i)));
235: IF(DFLT_REFPARTNBR = 'SEGMENT1')THEN
236: iRefPartNbr(nIndex) := Segment1(i);
237: ELSIF(DFLT_REFPARTNBR = 'CONCATENATED_SEGMENTS')THEN
238: iRefPartNbr(nIndex) := ConcatenatedSegments(i);

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

946:
947: iPsNodeType(nIndex) := cnReference;
948: iComponentCode(nIndex) := ShiftComponentCode(ComponentCode(i), StackPlanLevel(nStack));
949: iComponentSequencePath(nIndex) := ComponentSequencePath;
950: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(iComponentCode(nIndex),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
951: iPlanLevel(nIndex) := PlanLevel(i) - StackPlanLevel(nStack);
952:
953: --DBMS_OUTPUT.PUT_LINE('PlanLevel('||i||')='||PlanLevel(i));
954: --DBMS_OUTPUT.PUT_LINE('StackPlanLevel('||nStack||')='||StackPlanLevel(nStack));

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

955: --DBMS_OUTPUT.PUT_LINE('iPlanLevel('||nIndex||')='||iPlanLevel(nIndex));
956:
957: IF(x_usesurr_psnode = 0)THEN
958: ifskParentNode(nIndex) :=
959: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
960: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
961: ifskParentNodeExt(nIndex) := NULL;
962: ELSE
963: ifskParentNode(nIndex) := NULL;

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

961: ifskParentNodeExt(nIndex) := NULL;
962: ELSE
963: ifskParentNode(nIndex) := NULL;
964: ifskParentNodeExt(nIndex) :=
965: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
966: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
967: END IF;
968:
969: IF(x_usesurr_devlproject = 0)THEN

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

966: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
967: END IF;
968:
969: IF(x_usesurr_devlproject = 0)THEN
970: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
971: ifskDevlProjectExt(nIndex) := NULL;
972: ELSE
973: ifskDevlProject(nIndex) := NULL;
974: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

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

970: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
971: ifskDevlProjectExt(nIndex) := NULL;
972: ELSE
973: ifskDevlProject(nIndex) := NULL;
974: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
975: END IF;
976:
977: ifskReference(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));
978: iOrganizationId(nIndex) := OrganizationId(i);

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

973: ifskDevlProject(nIndex) := NULL;
974: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
975: END IF;
976:
977: ifskReference(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));
978: iOrganizationId(nIndex) := OrganizationId(i);
979: iTopItemId(nIndex) := StackTopItemId(nStack);
980: iExplosionType(nIndex) := ExplosionType(i);
981:

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

1012: ifskIntlTextExt(nIndex) := ComponentItemId(i) || ':' || ExplosionType(i) || ':' || OrganizationId(i) || ':'|| ComponentSequenceId(i);
1013: END IF;
1014:
1015: IF(x_usesurr_itemmaster = 0)THEN
1016: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1017: ifskItemMasterExt(nIndex) := NULL;
1018: ELSE
1019: ifskItemMaster(nIndex) := NULL;
1020: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

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

1016: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1017: ifskItemMasterExt(nIndex) := NULL;
1018: ELSE
1019: ifskItemMaster(nIndex) := NULL;
1020: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1021: END IF;
1022:
1023: iMutuallyExclusive(nIndex) := MutuallyExclusiveOptions(i);
1024: iOptional(nIndex) := v_Optional(i);

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

1106: --DBMS_OUTPUT.PUT_LINE('IF i> comp ... ModelType: '||ModelType(i));
1107: StackModelType(nStack) := ModelType(i);
1108:
1109: END IF;
1110: thisOrigSysRef := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(ComponentItemId(i)));
1111:
1112: --Check if the model has already been processed in this session
1113:
1114: --DBMS_OUTPUT.PUT_LINE('Verifying model...');

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

1147: iPsNodeType(nIndex) := bomStandard;
1148: END IF;
1149: iComponentCode(nIndex) := ShiftComponentCode(ComponentCode(i), StackPlanLevel(nStack));
1150: iComponentSequencePath(nIndex) := ComponentSequencePath;
1151: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(iComponentCode(nIndex),ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1152: iPlanLevel(nIndex) := PlanLevel(i) - StackPlanLevel(nStack);
1153:
1154: --DBMS_OUTPUT.PUT_LINE('PlanLevel('||i||')='||PlanLevel(i));
1155: --DBMS_OUTPUT.PUT_LINE('StackPlanLevel('||nStack||')='||StackPlanLevel(nStack));

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

1159: IF(BomItemType(i) = cnModel)THEN
1160: ifskParentNode(nIndex) := NULL;
1161: ELSE
1162: ifskParentNode(nIndex) :=
1163: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
1164: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1165: END IF;
1166: ifskParentNodeExt(nIndex) := NULL;
1167: ELSE

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

1169: IF(BomItemType(i) = cnModel)THEN
1170: ifskParentNodeExt(nIndex) := NULL;
1171: ELSE
1172: ifskParentNodeExt(nIndex) :=
1173: CZ_ORAAPPS_INTEGRATE.COMPONENT_SURROGATE_KEY(SUBSTR(iComponentCode(nIndex),1,INSTR(iComponentCode(nIndex),'-',-1,1)-1),
1174: ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1175: END IF;
1176: END IF;
1177:

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

1175: END IF;
1176: END IF;
1177:
1178: IF(x_usesurr_devlproject = 0)THEN
1179: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1180: ifskDevlProjectExt(nIndex) := NULL;
1181: ELSE
1182: ifskDevlProject(nIndex) := NULL;
1183: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));

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

1179: ifskDevlProject(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1180: ifskDevlProjectExt(nIndex) := NULL;
1181: ELSE
1182: ifskDevlProject(nIndex) := NULL;
1183: ifskDevlProjectExt(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),TO_CHAR(OrganizationId(i)),TO_CHAR(StackTopItemId(nStack)));
1184: END IF;
1185:
1186: ifskReference(nIndex) := NULL;
1187: iOrganizationId(nIndex) := OrganizationId(i);

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

1254: -- ifskIntlTextExt(nIndex) := Description(i);
1255: END IF;
1256:
1257: IF(x_usesurr_itemmaster = 0)THEN
1258: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1259: ifskItemMasterExt(nIndex) := NULL;
1260: ELSE
1261: ifskItemMaster(nIndex) := NULL;
1262: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));

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

1258: ifskItemMaster(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1259: ifskItemMasterExt(nIndex) := NULL;
1260: ELSE
1261: ifskItemMaster(nIndex) := NULL;
1262: ifskItemMasterExt(nIndex) := CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(TO_CHAR(ComponentItemId(i)),TO_CHAR(OrganizationId(i)));
1263: END IF;
1264:
1265: iMutuallyExclusive(nIndex) := MutuallyExclusiveOptions(i);
1266: iOptional(nIndex) := v_Optional(i);

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

1804: ElSE
1805: l_parent_model_id := nTop_ID; -- the item belongs to the top model
1806: END IF;
1807:
1808: iFSKDevlProject := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(l_parent_model_id));
1809:
1810: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
1811: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, FSK_DEVLPROJECT_1_1)
1812: VALUES (iLocalizedStr(i), iLanguage(i), iSrcLang(i), inRun_ID,

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

1829: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, FSK_DEVLPROJECT_1_1)
1830: SELECT description, language, source_lang, inRun_ID,
1831: gModelItemId_tbl(j)||':'||sExpl_type||':'||nOrg_ID||':'||
1832: NVL(common_component_sequence_id, component_sequence_id),
1833: CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(gModelItemId_tbl(j)))
1834: FROM cz_exv_intl_text
1835: WHERE organization_id = nOrg_ID
1836: AND top_item_id = gModelItemId_tbl(j)
1837: AND explosion_type = sExpl_type

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

1934: end if;
1935:
1936: FOR i IN 1..OrganizationId.COUNT LOOP
1937:
1938: iOrigSysRef(nIndex) := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(ExplosionType(i),to_char(OrganizationId(i)),to_char(ComponentItemId(i)));
1939: iName(nIndex) := Description(i) || '(' || to_char(OrganizationId(i)) || ' ' || to_char(ComponentItemId(i)) || ')';
1940: iDescText(nIndex) := SUBSTR(Description(i), 1, 255);
1941: iPlanLevel(nIndex) := PlanLevel(i);
1942: iTopItemId(nIndex) := ComponentItemId(i);

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

2897: FSK_ITEMMASTER_2_EXT,
2898: RUN_ID,
2899: ORIG_SYS_REF, SRC_APPLICATION_ID)
2900: SELECT ELEMENT_VALUE, ELEMENT_NAME, ELEMENT_NAME,
2901: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2902: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2903: inRun_ID,
2904: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,
2905: G_BOM_APPLICATION_ID

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

2898: RUN_ID,
2899: ORIG_SYS_REF, SRC_APPLICATION_ID)
2900: SELECT ELEMENT_VALUE, ELEMENT_NAME, ELEMENT_NAME,
2901: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2902: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2903: inRun_ID,
2904: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,
2905: G_BOM_APPLICATION_ID
2906: FROM CZ_EXV_ITEM_PROPERTY_VALUES

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

2900: SELECT ELEMENT_VALUE, ELEMENT_NAME, ELEMENT_NAME,
2901: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2902: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID)),
2903: inRun_ID,
2904: CZ_ORAAPPS_INTEGRATE.ITEM_SURROGATE_KEY(to_char(INVENTORY_ITEM_ID), to_char(ORGANIZATION_ID))|| ':' || ELEMENT_NAME,
2905: G_BOM_APPLICATION_ID
2906: FROM CZ_EXV_ITEM_PROPERTY_VALUES
2907: WHERE INVENTORY_ITEM_ID = inventoryItemId(i)
2908: AND ORGANIZATION_ID = nOrg_ID

Line 3532: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;

3528: END IF;
3529:
3530: IF(outError_code <> 0)THEN
3531: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);
3532: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3533: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3534: RETURN nModelId;
3535: END IF;
3536: ELSE

Line 3533: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;

3529:
3530: IF(outError_code <> 0)THEN
3531: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);
3532: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;
3533: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;
3534: RETURN nModelId;
3535: END IF;
3536: ELSE
3537:

Line 3555: CZ_ORAAPPS_INTEGRATE.mRETCODE := 2;

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

Line 3556: CZ_ORAAPPS_INTEGRATE.mERRBUF := outErr_msg;

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:
3559: EXCEPTION
3560: WHEN NO_DATA_FOUND THEN

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

3676: inRunExploder, inRevDate, inDateFormat, -1, 0, 0, 0);
3677: END IF;
3678:
3679: tabCompCode(tabCompCode.COUNT + 1) := compCode;
3680: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN nModelId; END IF;
3681: END IF;
3682:
3683: --LA 9595142
3684: -- Explosion has been processed, add to array

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

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;
4038:
4039: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;
4040:
4041: UPDATE CZ_XFR_PROJECT_BILLS SET
4042: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'0',SOURCE_BILL_DELETED)
4043: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;