[Home] [Help]
1: PACKAGE BODY INVUPD2B AS
2: /* $Header: INVUPD2B.pls 120.48.12020000.14 2013/04/08 04:10:46 qixia ship $ */
3: -- GlobalVar to hold control level for each attribute Bug Fix 3005880
4:
5: A_ALLOWED_UNITS_LOOKUP_CODE NUMBER := 2;
1: PACKAGE BODY INVUPD2B AS
2: /* $Header: INVUPD2B.pls 120.48.12020000.14 2013/04/08 04:10:46 qixia ship $ */
3: -- GlobalVar to hold control level for each attribute Bug Fix 3005880
4:
5: A_ALLOWED_UNITS_LOOKUP_CODE NUMBER := 2;
6: A_INVENTORY_ITEM_STATUS_CODE NUMBER := 2;
391:
392: BEGIN
393:
394: IF l_inv_debug_level IN(101, 102) THEN
395: INVPUTLI.info('INVUPD2B: Inside validate_item_update_master'|| '***orgid: ' || TO_CHAR(org_id));
396: END IF;
397:
398: -- Set the attribute level for those attributes under master control.
399: -- Bug fix 3005880
710:
711: tmp_xset_id := tmp_xset_id +1 ; --5351611
712:
713: -- call additional update validations on master record
714: ret_code_update := INVUPD2B.update_validations(
715: rec.ROWID,
716: rec.ORGANIZATION_ID,
717: t_trans_id,
718: user_id,
726: WHERE rowid = rec.rowid;
727:
728:
729: if (ret_code_update = 0 AND m_process_flag=4) THEN
730: ret_code := INVUPD2B.check_child_records(
731: rec.ROWID,
732: rec.INVENTORY_ITEM_ID,
733: rec.ORGANIZATION_ID,
734: t_trans_id,
769: null,
770: 'MTL_SYSTEM_ITEMS_INTERFACE',
771: 'INV_CHILD_VIOLATION_ERROR',
772: err_text);
773: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
774: end if;
775:
776: end if;
777:
1436: CLOSE c_master_attributes;
1437: END IF;
1438: */
1439: check_create_child := TRUE;
1440: INVPUTLI.info('INVUPD2B.check_create_child_records : Exception ' || SQLERRM );
1441:
1442: END Check_create_child_records;
1443:
1444: FUNCTION check_child_records
1488:
1489: BEGIN
1490:
1491: IF l_inv_debug_level IN(101, 102) THEN
1492: INVPUTLI.info('INVUPD2B: Inside check_child_records'|| '***orgid: ' || TO_CHAR(org_id));
1493: END IF;
1494:
1495: -- Bug 10404086 : Start
1496: Check_create_child_records(mast_rowid => master_row_id,
1513: check_create_child => l_check_create_child);
1514: IF l_check_create_child = TRUE THEN
1515: */ -- Bug 10404086.
1516:
1517: ret_code := INVUPD2B.create_child_update_mast_attr(master_row_id, crec.INVENTORY_ITEM_ID, crec.ORGANIZATION_ID, xset_id);
1518: l_created_child := TRUE;
1519: -- END IF;
1520: end loop; -- } -- msi_child loop
1521:
1547: err_text,
1548: xset_id + 1000000000000);
1549:
1550: for rec in C_msii_forupdate_records loop
1551: ret_code_update := INVUPD2B.update_validations(
1552: rec.ROWID,
1553: rec.ORGANIZATION_ID,
1554: trans_id,
1555: user_id,
1602: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1603: BEGIN
1604:
1605: IF l_inv_debug_level IN(101, 102) THEN
1606: INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));
1607: END IF;
1608: -- Insert msi data onto MSII for child record.
1609: -- Need to verify these attributes.
1610: --
2416:
2417: --commit;
2418:
2419: -- copy master item data to child record created in msii
2420: ret_code := INVUPD2B.copy_master_to_child(master_row_id, inv_item_id, org_id, xset_id);
2421:
2422: --commit;
2423:
2424: RETURN (ret_code);
2460:
2461: BEGIN
2462:
2463: IF l_inv_debug_level IN(101, 102) THEN
2464: INVPUTLI.info('INVUPD2B: Inside copy_master_to_child'|| '***orgid: ' || TO_CHAR(org_id));
2465: END IF;
2466:
2467: -- Get master record info into msii_master_temp
2468: --
3501:
3502: BEGIN -- {
3503:
3504: IF l_inv_debug_level IN(101, 102) THEN
3505: INVPUTLI.info('INVUPD2B: Inside validate_item_update_child'|| '***orgid: ' || TO_CHAR(org_id));
3506: END IF;
3507:
3508: for crec in C_msii_child_records loop -- {
3509: -- child record validation here
3506: END IF;
3507:
3508: for crec in C_msii_child_records loop -- {
3509: -- child record validation here
3510: ret_code_update := INVUPD2B.update_validations(
3511: crec.ROWID,
3512: crec.ORGANIZATION_ID,
3513: crec.TRANSACTION_ID,
3514: user_id,
3635: invetory_asset_flag_level NUMBER;
3636: BEGIN
3637:
3638: IF l_inv_debug_level IN(101, 102) THEN
3639: INVPUTLI.info('INVUPD2B: Inside update_validations'|| '***orgid: ' || TO_CHAR(org_id));
3640: END IF;
3641: -- initialize status = 0
3642: status := 0;
3643:
3959: X_open_shipment_serial => open_shipment_serial -- Bug 9043779
3960: );
3961:
3962: IF l_inv_debug_level IN(101, 102) THEN
3963: INVPUTLI.info('INVUPD2B: Inside update_validations: After Table Quries');
3964: END IF;
3965: -- validate LOT_CONTROL_CODE
3966: -- cannot update if there is onhand or transactions pending or lots exist
3967: if (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (onhand_lot = 1) then
3978: 'MTL_SYSTEM_ITEMS_INTERFACE',
3979: 'INV_LOT_QOH_CANNOT_UPDATE',
3980: err_text);
3981:
3982: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
3983:
3984: /* Bug 3058650 : Validation added as part of Item attribute checks ER */
3985: elsif (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (pendadj_lot = 1) then
3986: dumm_status := INVPUOPI.mtl_log_interface_err(
3996: 'MTL_SYSTEM_ITEMS_INTERFACE',
3997: 'INV_PENDING_ADJUSTMENT',
3998: err_text);
3999:
4000: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4001:
4002: /* End Bug 3058650 */
4003: elsif (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (intr_ship_lot = 1) then -- Bug 4387538
4004: dumm_status := INVPUOPI.mtl_log_interface_err(
4014: 'MTL_SYSTEM_ITEMS_INTERFACE',
4015: 'INV_INTRANSIT_CANNOT_UPDATE',
4016: err_text);
4017:
4018: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4019: /*Bug 6501149 Added code */
4020: elsif (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (lot_control = 1) then
4021: dumm_status := INVPUOPI.mtl_log_interface_err(
4022: org_id,
4031: 'MTL_SYSTEM_ITEMS_INTERFACE',
4032: 'INV_DELIVER_CANNOT_UPDATE',
4033: err_text);
4034:
4035: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4036: /* Bug 6501149 Code ended */
4037: end if;
4038: -- Bug 9043779
4039: if (msi_temp.lot_control_code <> msii_temp.lot_control_code) and (open_shipment_lot = 1) then
4050: 'MTL_SYSTEM_ITEMS_INTERFACE',
4051: 'INV_RECORG_SHIPSUPP_RO_LOT',
4052: err_text);
4053:
4054: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4055: end if;
4056: if (msi_temp.serial_number_control_code <> msii_temp.serial_number_control_code) and (open_shipment_serial = 1) then
4057: dumm_status := INVPUOPI.mtl_log_interface_err(
4058: org_id,
4067: 'MTL_SYSTEM_ITEMS_INTERFACE',
4068: 'INV_RECORG_SHIPSUPP_RO_SERL',
4069: err_text);
4070:
4071: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4072: end if;
4073: -- end, bug 9043779
4074:
4075: /* Start Bug 3713912 */
4089: 'MTL_SYSTEM_ITEMS_INTERFACE',
4090: 'INV_LOT_QOH_CANNOT_UPDATE',
4091: err_text);
4092:
4093: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4094:
4095: elsif (msi_temp.child_lot_flag <> msii_temp.child_lot_flag) AND (pendadj_child_lot = 1) then
4096: dumm_status := INVPUOPI.mtl_log_interface_err(
4097: org_id,
4106: 'MTL_SYSTEM_ITEMS_INTERFACE',
4107: 'INV_PENDING_ADJUSTMENT',
4108: err_text);
4109:
4110: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4111:
4112: end if;
4113:
4114: -- validate GRADE_CONTROL_FLAG
4127: 'MTL_SYSTEM_ITEMS_INTERFACE',
4128: 'INV_LOT_QOH_CANNOT_UPDATE',
4129: err_text);
4130:
4131: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4132:
4133: elsif (msi_temp.grade_control_flag <> msii_temp.grade_control_flag) AND (pendadj_grade = 1) then
4134: dumm_status := INVPUOPI.mtl_log_interface_err(
4135: org_id,
4144: 'MTL_SYSTEM_ITEMS_INTERFACE',
4145: 'INV_PENDING_ADJUSTMENT',
4146: err_text);
4147:
4148: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4149:
4150: end if;
4151:
4152: -- validate LOT_DIVISIBLE_FLAG
4165: 'MTL_SYSTEM_ITEMS_INTERFACE',
4166: 'INV_LOT_QOH_CANNOT_UPDATE',
4167: err_text);
4168:
4169: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4170:
4171: elsif (msi_temp.lot_divisible_flag <> msii_temp.lot_divisible_flag) AND (pendadj_lot_divisible = 1) then
4172: dumm_status := INVPUOPI.mtl_log_interface_err(
4173: org_id,
4182: 'MTL_SYSTEM_ITEMS_INTERFACE',
4183: 'INV_PENDING_ADJUSTMENT',
4184: err_text);
4185:
4186: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4187:
4188: end if;
4189:
4190: -- validate SHELF_LIFE_CODE
4210: 'MTL_SYSTEM_ITEMS_INTERFACE',
4211: 'INV_LOT_QOH_CANNOT_UPDATE',
4212: err_text);
4213:
4214: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4215: end if;
4216:
4217: /* End Bug 3713912 */
4218:
4234: 'MTL_SYSTEM_ITEMS_INTERFACE',
4235: 'INV_LOC_CONTROL_CODE_ERR',
4236: err_text);
4237:
4238: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4239:
4240: elsif (msi_temp.LOCATION_CONTROL_CODE <> msii_temp.LOCATION_CONTROL_CODE) AND (pendadj_loc = 1) then
4241: dumm_status := INVPUOPI.mtl_log_interface_err(
4242: org_id,
4251: 'MTL_SYSTEM_ITEMS_INTERFACE',
4252: 'INV_PENDING_ADJUSTMENT',
4253: err_text);
4254:
4255: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4256:
4257: /* End Bug 3058650 */
4258:
4259: end if;
4275: 'MTL_SYSTEM_ITEMS_INTERFACE',
4276: 'INV_RESERVABLE_TYPE_ERR',
4277: err_text);
4278:
4279: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4280: end if;
4281:
4282: /* Bug 3058650 : Validation added as part of Item attribute checks ER */
4283:
4297: 'RESERVABLE_TYPE',
4298: 'MTL_SYSTEM_ITEMS_INTERFACE',
4299: 'INV_RESERVABLE_NO_YES',
4300: err_text);
4301: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4302: end if;
4303: end if;
4304:
4305:
4325: 'TRANSACTIONS_ENABLED_FLAG',
4326: 'MTL_SYSTEM_ITEMS_INTERFACE',
4327: 'INV_TRANSACTABLE_YES_NO',
4328: err_text);
4329: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4330: end if;
4331:
4332: end if;
4333: /* End Bug 3058650 */
4352: 'SHIPPABLE_ITEM_FLAG',
4353: 'MTL_SYSTEM_ITEMS_INTERFACE',
4354: 'INV_OPEN_SO',
4355: err_text);
4356: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4357: elsif (msi_temp.SHIPPABLE_ITEM_FLAG = 'N' ) and (msii_temp.SHIPPABLE_ITEM_FLAG = 'Y') then
4358: if (INV_ATTRIBUTE_CONTROL_PVT.shippable_check(msii_temp.organization_id,
4359: msii_temp.inventory_item_id)) then
4360: dumm_status := INVPUOPI.mtl_log_interface_err(
4369: 'SHIPPABLE_ITEM_FLAG',
4370: 'MTL_SYSTEM_ITEMS_INTERFACE',
4371: 'INV_TRANSACTABLE_NO_YES',
4372: err_text);
4373: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4374: end if;
4375: end if;
4376:
4377: /* End Bug 3058650 */
4395: 'REPLENISH_TO_ORDER_FLAG',
4396: 'MTL_SYSTEM_ITEMS_INTERFACE',
4397: 'INV_ATO_YES_NO',
4398: err_text);
4399: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4400: end if;
4401:
4402: /* End Bug 3058650 */
4403:
4418: 'MTL_SYSTEM_ITEMS_INTERFACE',
4419: 'INV_REV_QTY_CNTRL_CODE_ERR',
4420: err_text);
4421:
4422: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4423: /*Bug 6501149 Code starts */
4424: elsif (msi_temp.REVISION_QTY_CONTROL_CODE <> msii_temp.REVISION_QTY_CONTROL_CODE) AND (revision_control = 1) then
4425: dumm_status := INVPUOPI.mtl_log_interface_err(
4426: org_id,
4434: 'REVISION_QTY_CONTROL_CODE',
4435: 'MTL_SYSTEM_ITEMS_INTERFACE',
4436: 'INV_DELIVER_CANNOT_UPDATE',
4437: err_text);
4438: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4439: /*Bug 6501149 Code ends */
4440:
4441: /* Bug 3058650 : Validation added as part of Item attribute checks ER */
4442: elsif (msi_temp.REVISION_QTY_CONTROL_CODE <> msii_temp.REVISION_QTY_CONTROL_CODE) AND (pendadj_rev = 1) then
4453: 'MTL_SYSTEM_ITEMS_INTERFACE',
4454: 'INV_PENDING_ADJUSTMENT',
4455: err_text);
4456:
4457: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4458: /* End Bug 3058650 */
4459: end if;
4460:
4461:
4483: 'SERIAL_NUMBER_CONTROL_CODE',
4484: 'MTL_SYSTEM_ITEMS_INTERFACE',
4485: 'INV_QTY_ON_HAND',
4486: err_text);
4487: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4488: elsif (msi_temp.SERIAL_NUMBER_CONTROL_CODE = 1 and
4489: msii_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5,6))then
4490:
4491: if (INV_ATTRIBUTE_CONTROL_PVT.serial_check(msii_temp.organization_id,
4502: 'SERIAL_NUMBER_CONTROL_CODE',
4503: 'MTL_SYSTEM_ITEMS_INTERFACE',
4504: 'INV_SERIAL_NO_YES',
4505: err_text);
4506: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4507: end if;
4508: /* End Bug 3058650 */
4509:
4510: /* Start Bug 4387538 */
4526: 'MTL_SYSTEM_ITEMS_INTERFACE',
4527: 'INV_INTRANSIT_CANNOT_UPDATE',
4528: err_text);
4529:
4530: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4531:
4532: /* Bug 6501149 Code start */
4533: elsif ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5)) and
4534: (serial_control = 1)) or
4547: 'SERIAL_NUMBER_CONTROL_CODE',
4548: 'MTL_SYSTEM_ITEMS_INTERFACE',
4549: 'INV_DELIVER_CANNOT_UPDATE',
4550: err_text);
4551: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4552: /* Bug 6501149 Code ended */
4553: end if;
4554: /* End Bug 4387538 */
4555:
4571: 'MTL_SYSTEM_ITEMS_INTERFACE',
4572: 'INV_BOM_ENABLED_FLAG_ERR',
4573: err_text);
4574:
4575: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4576: end if;
4577:
4578: -- validate BOM_ITEM_TYPE (1)
4579: -- Not updateable when row exists in bom_substitute_components or
4596: 'MTL_SYSTEM_ITEMS_INTERFACE',
4597: 'INV_BOM_ITEM_TYPE_ERR1',
4598: err_text);
4599:
4600: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4601: end if;
4602:
4603: -- Start : 3436435 Item in BOM,BOM Enabled cannot be N
4604: /* commented for bug 5479302
4616: 'MTL_SYSTEM_ITEMS_INTERFACE',
4617: 'INV_IOI_ITEM_BOM_EXISTS',
4618: err_text);
4619:
4620: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4621: end if; */
4622: -- End : 3436435 Item in BOM,BOM Enabled cannot be N
4623:
4624: -- validate BOM_ITEM_TYPE (2)
4652: 'MTL_SYSTEM_ITEMS_INTERFACE',
4653: 'INV_BOM_ITEM_TYPE_ERR2',
4654: err_text);
4655:
4656: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4657:
4658: end if;
4659: */
4660:
4677: 'MTL_SYSTEM_ITEMS_INTERFACE',
4678: 'INV_BOM_ITEM_TYPE_ERR3',
4679: err_text);
4680:
4681: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4682: end if;
4683:
4684: -- Added for Bug 5143614
4685: -- Validate update of pick_components flag
4712: 'PICK_COMPONENTS_FLAG',
4713: 'MTL_SYSTEM_ITEMS_INTERFACE',
4714: 'INV_ITEM_LOT_COMP',
4715: err_text);
4716: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4717: END IF;
4718: end if;
4719:
4720: -- validate COSTING_ENABLED_FLAG
4738: 'MTL_SYSTEM_ITEMS_INTERFACE',
4739: 'INV_COSTING_ENABLED_FLAG_ERR',
4740: err_text);
4741:
4742: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4743: end if;
4744: -- throw error only if the costing enabled flag is modified and
4745: -- pending transactions or onhand exists in any of the child orgs and the control level of COSTING_ENABLED_FLAG is org level
4746: -- Bug 9378082 If the return value is 2, check if the flag is master controlled then throw the error.
4766: 'MTL_SYSTEM_ITEMS_INTERFACE',
4767: 'INV_COSTING_ENABLED_FLAG_ERR',
4768: err_text);
4769:
4770: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4771: END IF;
4772: end if;
4773:
4774: -- validate INVENTORY_ASSET_FLAG
4792: 'MTL_SYSTEM_ITEMS_INTERFACE',
4793: 'INV_INVENTORY_ASSET_FLAG_ERR',
4794: err_text);
4795:
4796: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4797: end if;
4798: -- throw error only if the INVENTORY_ASSET_FLAG is modified and
4799: -- pending transactions or onhand exists in any of the child orgs and the control level of INVENTORY_ASSET_FLAG is org level
4800: -- Bug 9378082 If the return value is 2, check if the flag is master controlled then throw the error.
4820: 'MTL_SYSTEM_ITEMS_INTERFACE',
4821: 'INV_INVENTORY_ASSET_FLAG_ERR',
4822: err_text);
4823:
4824: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4825:
4826: END IF;
4827: end if;
4828:
4844: 'MTL_SYSTEM_ITEMS_INTERFACE',
4845: 'INV_FIXED_ORDER_QUANTITY_ERR',
4846: err_text);
4847:
4848: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4849: end if;
4850:
4851:
4852: -- validate PLANNING_MAKE_BUY_CODE
4867: 'MTL_SYSTEM_ITEMS_INTERFACE',
4868: 'INV_PLANNING_MAKE_BUY_CODE',
4869: err_text);
4870:
4871: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4872: end if;
4873:
4874:
4875: -- validate ACCEPTABLE_EARLY_DAYS
4889: 'MTL_SYSTEM_ITEMS_INTERFACE',
4890: 'INV_ACCEPTABLE_EARLY_DAYS_ERR',
4891: err_text);
4892:
4893: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4894: end if;
4895:
4896:
4897: -- validate ACCEPTABLE_RATE_INCREASE
4911: 'MTL_SYSTEM_ITEMS_INTERFACE',
4912: 'INV_ACCEPT_RATE_INCREASE_ERR',
4913: err_text);
4914:
4915: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4916: end if;
4917:
4918:
4919: -- validate ACCEPTABLE_RATE_DECREASE
4933: 'MTL_SYSTEM_ITEMS_INTERFACE',
4934: 'INV_ACCEPT_RATE_DECREASE_ERR',
4935: err_text);
4936:
4937: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4938: end if;
4939:
4940:
4941: -- validate DEMAND_TIME_FENCE_DAYS
4956: 'MTL_SYSTEM_ITEMS_INTERFACE',
4957: 'INV_DEMAND_TIME_FENCE_DAYS_ERR',
4958: err_text);
4959:
4960: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4961: end if;
4962:
4963:
4964: -- validate PLANNING_TIME_FENCE_DAYS
4979: 'MTL_SYSTEM_ITEMS_INTERFACE',
4980: 'INV_PLAN_TIME_FENCE_DAYS_ERR',
4981: err_text);
4982:
4983: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4984: end if;
4985:
4986:
4987: -- validate REPETITIVE_PLANNING_FLAG
5002: 'MTL_SYSTEM_ITEMS_INTERFACE',
5003: 'INV_REPET_PLANNING_FLAG_ERR',
5004: err_text);
5005:
5006: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5007: end if;
5008:
5009:
5010: -- validate SHRINKAGE_RATE
5026: 'MTL_SYSTEM_ITEMS_INTERFACE',
5027: 'INV_SHRINKAGE_RATE_ERR',
5028: err_text);
5029:
5030: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5031:
5032: end if;
5033:
5034:
5050: 'MTL_SYSTEM_ITEMS_INTERFACE',
5051: 'INV_FULL_LEAD_TIME_ERR',
5052: err_text);
5053:
5054: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5055: end if;
5056:
5057:
5058: -- validate LEAD_TIME_LOT_SIZE
5088: 'MTL_SYSTEM_ITEMS_INTERFACE',
5089: 'INV_POSTPROC_LEAD_TIME_ERR',
5090: err_text);
5091:
5092: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5093: end if;
5094:
5095:
5096: -- validate VARIABLE_LEAD_TIME
5110: 'MTL_SYSTEM_ITEMS_INTERFACE',
5111: 'INV_VARIABLE_LEAD_TIME_ERR',
5112: err_text);
5113:
5114: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5115: end if;
5116:
5117: /* Validation added for Bug 4139304 - Anmurali */
5118: if ((msi_temp.effectivity_control <> msii_temp.effectivity_control) AND (bom_item = 1 OR onhand_all = 1)) then
5129: 'MTL_SYSTEM_ITEMS_INTERFACE',
5130: 'ITM-EFFC-ITEM IS BILL OR COMP',
5131: err_text);
5132:
5133: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5134: end if;
5135: /* End of validation for Bug 4139304 */
5136:
5137: --ToDo (SERVICE_ITEM_FLAG) :
5154: 'MTL_SYSTEM_ITEMS_INTERFACE',
5155: 'INV_BUILD_IN_WIP_FLAG_ERR',
5156: err_text);
5157:
5158: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5159: end if;
5160: */
5161:
5162: -- validate SERVICE_ITEM_FLAG
5177: 'MTL_SYSTEM_ITEMS_INTERFACE',
5178: 'INV_SERVICE_ITEM_FLAG_ERR',
5179: err_text);
5180:
5181: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5182: end if;
5183: */
5184:
5185: -- validate SERVICE_STARTING_DELAY
5199: 'MTL_SYSTEM_ITEMS_INTERFACE',
5200: 'INV_SERVICE_STARTING_DELAY_ERR',
5201: err_text);
5202:
5203: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5204: end if;
5205:
5206: -- validate VEHICLE_ITEM_FLAG
5207: -- Not updateable when row exists in FTE_VEHICLE_TYPES
5220: 'MTL_SYSTEM_ITEMS_INTERFACE',
5221: 'INV_VEHICLE_CANNOT_UPDATE',
5222: err_text);
5223:
5224: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5225: end if;
5226: -- Bug: 2710463
5227: -- validate COMMS_NL_TRACKABLE_FLAG
5228: -- Not updateable when Onhand Trackable exists
5241: 'MTL_SYSTEM_ITEMS_INTERFACE',
5242: 'INV_ONHAND_TRACKABLE_EXIST',
5243: err_text);
5244:
5245: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5246: end if;
5247:
5248: IF l_inv_debug_level IN(101, 102) THEN
5249: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations started');
5245: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5246: end if;
5247:
5248: IF l_inv_debug_level IN(101, 102) THEN
5249: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations started');
5250: END IF;
5251: -- Added for 11.5.10
5252: -- validate OUTSIDE_OPERATION_FLAG, EAM_ITEM_TYPE, MTL_TRANSACTIONS_ENABLED_FLAG, STOCK_ENABLED_FLAG and INVENTORY_ASSET_FLAG
5253: -- validate Not updateable fields
5265: 'STOCK_ENABLED_FLAG',
5266: 'MTL_SYSTEM_ITEMS_INTERFACE',
5267: 'INV_DELIVER_CANNOT_UPDATE',
5268: err_text);
5269: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5270: end if;
5271: /*Bug 6501149 code ends */
5272:
5273: /* BUG 9135696 code starts */
5285: 'STOCK_ENABLED_FLAG',
5286: 'MTL_SYSTEM_ITEMS_INTERFACE',
5287: 'INV_PENDING_ADJUSTMENT',
5288: err_text);
5289: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5290: end if;
5291: end if;
5292: /* BUG 9135696 code ends */
5293:
5307: l_column_name := 'INVENTORY_ASSET_FLAG';
5308: end if;
5309: if (l_column_name IS NOT NULL) then
5310: IF l_inv_debug_level IN(101, 102) THEN
5311: INVPUTLI.info('INVUPD2B: Inside update_validations: VMI validations failed');
5312: END IF;
5313:
5314: dumm_status := INVPUOPI.mtl_log_interface_err(
5315: org_id,
5323: l_column_name,
5324: 'MTL_SYSTEM_ITEMS_INTERFACE',
5325: 'INV_VMI_ENABLED_ITEM',
5326: err_text);
5327: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5328: end if;
5329: IF l_inv_debug_level IN(101, 102) THEN
5330: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations Ended');
5331: END IF;
5326: err_text);
5327: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5328: end if;
5329: IF l_inv_debug_level IN(101, 102) THEN
5330: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations Ended');
5331: END IF;
5332:
5333: /* Start Bug 3713912 */
5334: -- validate TRACKING_QUANTITY_IND
5334: -- validate TRACKING_QUANTITY_IND
5335: -- cannot update if there is onhand or transactions pending
5336: if (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (onhand_tracking_qty_ind = 1) then
5337: IF l_inv_debug_level IN(101, 102) THEN
5338: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND onhand validations failed');
5339: END IF;
5340: dumm_status := INVPUOPI.mtl_log_interface_err(
5341: org_id,
5342: user_id,
5350: 'MTL_SYSTEM_ITEMS_INTERFACE',
5351: 'INV_QOH_CANNOT_UPDATE',
5352: err_text);
5353:
5354: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5355:
5356: elsif (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (pendadj_tracking_qty_ind = 1) then
5357: IF l_inv_debug_level IN(101, 102) THEN
5358: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');
5354: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5355:
5356: elsif (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (pendadj_tracking_qty_ind = 1) then
5357: IF l_inv_debug_level IN(101, 102) THEN
5358: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');
5359: END IF;
5360: dumm_status := INVPUOPI.mtl_log_interface_err(
5361: org_id,
5362: user_id,
5370: 'MTL_SYSTEM_ITEMS_INTERFACE',
5371: 'INV_PENDING_ADJUSTMENT',
5372: err_text);
5373:
5374: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5375:
5376: end if;
5377:
5378: -- validate SECONDARY_UOM_CODE
5378: -- validate SECONDARY_UOM_CODE
5379: -- cannot update if there is onhand or transactions pending
5380: if (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (onhand_secondary_uom = 1) then
5381: IF l_inv_debug_level IN(101, 102) THEN
5382: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE onhand validations failed');
5383: END IF;
5384: dumm_status := INVPUOPI.mtl_log_interface_err(
5385: org_id,
5386: user_id,
5394: 'MTL_SYSTEM_ITEMS_INTERFACE',
5395: 'INV_QOH_CANNOT_UPDATE',
5396: err_text);
5397:
5398: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5399:
5400: elsif (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (pendadj_secondary_uom = 1) then
5401: IF l_inv_debug_level IN(101, 102) THEN
5402: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');
5398: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5399:
5400: elsif (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (pendadj_secondary_uom = 1) then
5401: IF l_inv_debug_level IN(101, 102) THEN
5402: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');
5403: END IF;
5404: dumm_status := INVPUOPI.mtl_log_interface_err(
5405: org_id,
5406: user_id,
5414: 'MTL_SYSTEM_ITEMS_INTERFACE',
5415: 'INV_PENDING_ADJUSTMENT',
5416: err_text);
5417:
5418: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5419:
5420: end if;
5421:
5422: -- validate SECONDARY_DEFAULT_IND
5422: -- validate SECONDARY_DEFAULT_IND
5423: -- cannot update if there is onhand or transactions pending
5424: if (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (onhand_sec_default_ind = 1) then
5425: IF l_inv_debug_level IN(101, 102) THEN
5426: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND onhand validations failed');
5427: END IF;
5428: dumm_status := INVPUOPI.mtl_log_interface_err(
5429: org_id,
5430: user_id,
5438: 'MTL_SYSTEM_ITEMS_INTERFACE',
5439: 'INV_QOH_CANNOT_UPDATE',
5440: err_text);
5441:
5442: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5443:
5444: elsif (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (pendadj_sec_default_ind = 1) then
5445: IF l_inv_debug_level IN(101, 102) THEN
5446: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');
5442: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5443:
5444: elsif (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (pendadj_sec_default_ind = 1) then
5445: IF l_inv_debug_level IN(101, 102) THEN
5446: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');
5447: END IF;
5448: dumm_status := INVPUOPI.mtl_log_interface_err(
5449: org_id,
5450: user_id,
5458: 'MTL_SYSTEM_ITEMS_INTERFACE',
5459: 'INV_PENDING_ADJUSTMENT',
5460: err_text);
5461:
5462: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5463:
5464: end if;
5465:
5466: -- validate PRIMARY_UOM_CODE
5466: -- validate PRIMARY_UOM_CODE
5467: -- cannot update if there is onhand or transactions pending
5468: if (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (onhand_primary_uom = 1) then
5469: IF l_inv_debug_level IN(101, 102) THEN
5470: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE onhand validations failed');
5471: END IF;
5472: dumm_status := INVPUOPI.mtl_log_interface_err(
5473: org_id,
5474: user_id,
5482: 'MTL_SYSTEM_ITEMS_INTERFACE',
5483: 'INV_QOH_CANNOT_UPDATE',
5484: err_text);
5485:
5486: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5487:
5488: elsif (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (pendadj_primary_uom = 1) then
5489: IF l_inv_debug_level IN(101, 102) THEN
5490: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');
5486: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5487:
5488: elsif (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (pendadj_primary_uom = 1) then
5489: IF l_inv_debug_level IN(101, 102) THEN
5490: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');
5491: END IF;
5492: dumm_status := INVPUOPI.mtl_log_interface_err(
5493: org_id,
5494: user_id,
5502: 'MTL_SYSTEM_ITEMS_INTERFACE',
5503: 'INV_PENDING_ADJUSTMENT',
5504: err_text);
5505:
5506: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5507:
5508: end if;
5509:
5510: -- validate DUAL_UOM_DEVIATION_HIGH
5510: -- validate DUAL_UOM_DEVIATION_HIGH
5511: -- cannot update if there is onhand or transactions pending
5512: if (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (onhand_deviation_high = 1) then
5513: IF l_inv_debug_level IN(101, 102) THEN
5514: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH onhand validations failed');
5515: END IF;
5516: dumm_status := INVPUOPI.mtl_log_interface_err(
5517: org_id,
5518: user_id,
5526: 'MTL_SYSTEM_ITEMS_INTERFACE',
5527: 'INV_QOH_CANNOT_UPDATE',
5528: err_text);
5529:
5530: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5531:
5532: elsif (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (pendadj_deviation_high = 1) then
5533: IF l_inv_debug_level IN(101, 102) THEN
5534: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');
5530: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5531:
5532: elsif (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (pendadj_deviation_high = 1) then
5533: IF l_inv_debug_level IN(101, 102) THEN
5534: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');
5535: END IF;
5536: dumm_status := INVPUOPI.mtl_log_interface_err(
5537: org_id,
5538: user_id,
5546: 'MTL_SYSTEM_ITEMS_INTERFACE',
5547: 'INV_PENDING_ADJUSTMENT',
5548: err_text);
5549:
5550: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5551:
5552: end if;
5553:
5554: -- validate DUAL_UOM_DEVIATION_LOW
5554: -- validate DUAL_UOM_DEVIATION_LOW
5555: -- cannot update if there is onhand or transactions pending
5556: if (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (onhand_deviation_low = 1) then
5557: IF l_inv_debug_level IN(101, 102) THEN
5558: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW onhand validations failed');
5559: END IF;
5560: dumm_status := INVPUOPI.mtl_log_interface_err(
5561: org_id,
5562: user_id,
5570: 'MTL_SYSTEM_ITEMS_INTERFACE',
5571: 'INV_QOH_CANNOT_UPDATE',
5572: err_text);
5573:
5574: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5575:
5576: elsif (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (pendadj_deviation_low = 1) then
5577: IF l_inv_debug_level IN(101, 102) THEN
5578: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');
5574: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5575:
5576: elsif (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (pendadj_deviation_low = 1) then
5577: IF l_inv_debug_level IN(101, 102) THEN
5578: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');
5579: END IF;
5580: dumm_status := INVPUOPI.mtl_log_interface_err(
5581: org_id,
5582: user_id,
5590: 'MTL_SYSTEM_ITEMS_INTERFACE',
5591: 'INV_PENDING_ADJUSTMENT',
5592: err_text);
5593:
5594: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5595:
5596: end if;
5597:
5598: /* End Bug 3713912 */
5612: 'RECIPE_ENABLED_FLAG',
5613: 'MTL_SYSTEM_ITEMS_INTERFACE',
5614: 'INV_RECIPE_ENABLED_FLAG_ERR',
5615: err_text);
5616: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5617: END IF;
5618: END IF;
5619: /** ****** END - LANHUANG - Bug fix 13946893 ****** */
5620:
5857: ,P_Set_id => xset_id);
5858: -- End 3637854 : Pending ECO check and sync lifecycles
5859:
5860: IF l_inv_debug_level IN(101, 102) THEN
5861: INVPUTLI.info('INVUPD2B.inproit_process_item_update : begin');
5862: END IF;
5863:
5864: -- Identify the current session language as Base ('B') or Installed ('I')
5865: --
6068: (NVL(INV_EGO_REVISION_VALIDATE.Get_Process_Control(),'X')<> 'PLM_UI:Y') ) or
6069: (rec.contract_type <> rec.CONTRACT_ITEM_TYPE_CODE) then
6070:
6071: IF l_inv_debug_level IN(101, 102) THEN
6072: INVPUTLI.info('INVUPD2B: inserting the item category assignments for default category sets ');
6073: END IF;
6074:
6075: -- Creating item category assignments for the default category sets
6076: -- for the functional areas having the defining attribute enabled.
6972: --6417028 propagate item number update to all org hierarchies
6973: FOR item_csr IN c_item_number_updated
6974: LOOP
6975: IF l_inv_debug_level IN(101, 102) THEN
6976: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6977: 'segment1' || item_csr.segment1);
6978: END IF;
6979:
6980: UPDATE mtl_system_items_b
7277: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
7278: BEGIN
7279:
7280: IF l_inv_debug_level IN(101, 102) THEN
7281: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');
7282: END IF;
7283: update MTL_SYSTEM_ITEMS_INTERFACE
7284: set PROCESS_FLAG = l_process_flag_3,
7285: request_id = reqst_id,
7317: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
7318: BEGIN
7319:
7320: IF l_inv_debug_level IN(101, 102) THEN
7321: INVPUTLI.info('INVUPD2B: inside get_message');
7322: END IF;
7323: FND_MESSAGE.SET_NAME('INV', SUBSTRB(msg_name, 1,30));
7324: error_text := FND_MESSAGE.GET;
7325: return (0);
7445:
7446: END get_control_level;
7447:
7448:
7449: end INVUPD2B;