DBA Data[Home] [Help]

APPS.INVUPD1B dependencies on INVUPD2B

Line 131: dumm_status := INVUPD2B.set_process_flag3(puom.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

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:

Line 315: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

311: 'MTL_SYSTEM_ITEMS_INTERFACE',
312: attr_err_mesg_name,
313: err_text);
314:
315: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
316: ELSE
317: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id,t_inventory_item_id);
318: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
319: IF rtn_status = 0 THEN

Line 352: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

348: null,
349: 'MTL_SYSTEM_ITEMS_INTERFACE',
350: 'INV_STATUS_CNTRL_ATTRIB_ERROR',
351: err_text);
352: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
353: END IF; -- } */
354: ELSE -- } {
355: -- flag error that non-updateable fields are being updated and move to next record
356: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 369: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

365: null,
366: 'MTL_SYSTEM_ITEMS_INTERFACE',
367: 'INV_NON_UPDATE_ATTRIBUTE_ERROR',
368: err_text);
369: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
370: END IF; -- }
371: ELSE -- } {
372: -- flag error that costing related fields are being updated and move to next record
373: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 386: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

382: null,
383: 'MTL_SYSTEM_ITEMS_INTERFACE',
384: 'INV_NON_UPDATE_ATTR_ERROR2',
385: err_text);
386: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
387: END IF; -- }
388: END LOOP; -- MSII LOOP -- }
389:
390: --2808277 Start supporting Item Revision Update

Line 1134: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

1130: null,
1131: 'MTL_SYSTEM_ITEMS_INTERFACE',
1132: 'INV_ORGITEM_ID_NOT_FOUND',
1133: err_text);
1134: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1135: end if;
1136: EXCEPTION
1137: -- if an oracle error occurred
1138: when ASS_ITEM_ERR then

Line 1152: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

1148: null,
1149: 'MTL_SYSTEM_ITEMS_INTERFACE',
1150: 'INV_TEMPLATE_ERROR',
1151: err_text);
1152: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1153: status_code := 1;
1154:
1155: when PARSE_ITEM_ERR then
1156: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1169: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

1165: 'ITEM_NUMBER',
1166: 'MTL_SYSTEM_ITEMS_INTERFACE',
1167: 'INV_PARSE_ITEM_ERROR',
1168: err_text);
1169: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1170: END;
1171: end loop; -- msii loop
1172:
1173: -- IOI Perf improvements..apply mass template.

Line 1385: dumm_status := INVUPD2B.set_process_flag3 (row_id,user_id,login_id,prog_appid,prog_id,request_id);

1381: 'MTL_SYSTEM_ITEMS_INTERFACE',
1382: 'INV_DYN_SQL_ERROR',
1383: err_text);
1384:
1385: dumm_status := INVUPD2B.set_process_flag3 (row_id,user_id,login_id,prog_appid,prog_id,request_id);
1386:
1387: return (0);
1388:
1389: END exists_in_msi; -- }

Line 4101: ret_code_master := INVUPD2B.validate_item_update_master(

4097: if (ret_code_create <> 0) then
4098: return (ret_code_create);
4099: end if;
4100:
4101: ret_code_master := INVUPD2B.validate_item_update_master(
4102: org_id,
4103: all_org,
4104: prog_appid,
4105: prog_id,

Line 4112: ret_code_child := INVUPD2B.validate_item_update_child(

4108: login_id,
4109: err_text,
4110: xset_id);
4111:
4112: ret_code_child := INVUPD2B.validate_item_update_child(
4113: org_id,
4114: all_org,
4115: prog_appid,
4116: prog_id,