127: 'PRIMARY_UNIT_OF_MEASURE',
128: 'MTL_SYSTEM_ITEMS_INTERFACE',
129: 'INV_IOI_PRIMARY_UOM',
130: err_text);
131: dumm_status := INVUPD2B.set_process_flag3(puom.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
132: END;
133: END LOOP;
134: --End of Bug 4366615
135:
295: 'MTL_SYSTEM_ITEMS_INTERFACE',
296: attr_err_mesg_name,
297: err_text);
298:
299: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
300: ELSE
301: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id,t_inventory_item_id);
302: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
303: IF rtn_status = 0 THEN
332: null,
333: 'MTL_SYSTEM_ITEMS_INTERFACE',
334: 'INV_STATUS_CNTRL_ATTRIB_ERROR',
335: err_text);
336: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
337: END IF; -- } */
338: ELSE -- } {
339: -- flag error that non-updateable fields are being updated and move to next record
340: dumm_status := INVPUOPI.mtl_log_interface_err(
349: null,
350: 'MTL_SYSTEM_ITEMS_INTERFACE',
351: 'INV_NON_UPDATE_ATTRIBUTE_ERROR',
352: err_text);
353: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
354: END IF; -- }
355: ELSE -- } {
356: -- flag error that costing related fields are being updated and move to next record
357: dumm_status := INVPUOPI.mtl_log_interface_err(
366: null,
367: 'MTL_SYSTEM_ITEMS_INTERFACE',
368: 'INV_NON_UPDATE_ATTR_ERROR2',
369: err_text);
370: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
371: END IF; -- }
372: END LOOP; -- MSII LOOP -- }
373:
374: --2808277 Start supporting Item Revision Update
1114: null,
1115: 'MTL_SYSTEM_ITEMS_INTERFACE',
1116: 'INV_ORGITEM_ID_NOT_FOUND',
1117: err_text);
1118: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1119: end if;
1120: EXCEPTION
1121: -- if an oracle error occurred
1122: when ASS_ITEM_ERR then
1132: null,
1133: 'MTL_SYSTEM_ITEMS_INTERFACE',
1134: 'INV_TEMPLATE_ERROR',
1135: err_text);
1136: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1137: status_code := 1;
1138:
1139: when PARSE_ITEM_ERR then
1140: dumm_status := INVPUOPI.mtl_log_interface_err(
1149: 'ITEM_NUMBER',
1150: 'MTL_SYSTEM_ITEMS_INTERFACE',
1151: 'INV_PARSE_ITEM_ERROR',
1152: err_text);
1153: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1154: END;
1155: end loop; -- msii loop
1156:
1157: -- IOI Perf improvements..apply mass template.
1365: 'MTL_SYSTEM_ITEMS_INTERFACE',
1366: 'INV_DYN_SQL_ERROR',
1367: err_text);
1368:
1369: dumm_status := INVUPD2B.set_process_flag3 (row_id,user_id,login_id,prog_appid,prog_id,request_id);
1370:
1371: return (0);
1372:
1373: END exists_in_msi; -- }
4070: if (ret_code_create <> 0) then
4071: return (ret_code_create);
4072: end if;
4073:
4074: ret_code_master := INVUPD2B.validate_item_update_master(
4075: org_id,
4076: all_org,
4077: prog_appid,
4078: prog_id,
4081: login_id,
4082: err_text,
4083: xset_id);
4084:
4085: ret_code_child := INVUPD2B.validate_item_update_child(
4086: org_id,
4087: all_org,
4088: prog_appid,
4089: prog_id,