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 299: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

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

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

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(

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

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(

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

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

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

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

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

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(

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

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.

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

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; -- }

Line 4074: ret_code_master := INVUPD2B.validate_item_update_master(

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,

Line 4085: ret_code_child := INVUPD2B.validate_item_update_child(

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,