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.INVUPD2B dependencies on INVPUOPI

Line 756: dumm_status := INVPUOPI.mtl_log_interface_err(

752: and TRANSACTION_TYPE = 'AUTO_CHILD';
753:
754: else
755: -- flag error in master msii record as child record validation is violated by master record update request
756: dumm_status := INVPUOPI.mtl_log_interface_err(
757: rec.ORGANIZATION_ID,
758: user_id,
759: login_id,
760: prog_appid,

Line 3859: dumm_status := INVPUOPI.mtl_log_interface_err(

3855: END IF;
3856: -- validate LOT_CONTROL_CODE
3857: -- cannot update if there is onhand or transactions pending or lots exist
3858: if (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (onhand_lot = 1) then
3859: dumm_status := INVPUOPI.mtl_log_interface_err(
3860: org_id,
3861: user_id,
3862: login_id,
3863: prog_appid,

Line 3877: dumm_status := INVPUOPI.mtl_log_interface_err(

3873: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
3874:
3875: /* Bug 3058650 : Validation added as part of Item attribute checks ER */
3876: elsif (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (pendadj_lot = 1) then
3877: dumm_status := INVPUOPI.mtl_log_interface_err(
3878: org_id,
3879: user_id,
3880: login_id,
3881: prog_appid,

Line 3895: dumm_status := INVPUOPI.mtl_log_interface_err(

3891: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
3892:
3893: /* End Bug 3058650 */
3894: elsif (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (intr_ship_lot = 1) then -- Bug 4387538
3895: dumm_status := INVPUOPI.mtl_log_interface_err(
3896: org_id,
3897: user_id,
3898: login_id,
3899: prog_appid,

Line 3912: dumm_status := INVPUOPI.mtl_log_interface_err(

3908:
3909: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
3910: /*Bug 6501149 Added code */
3911: elsif (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (lot_control = 1) then
3912: dumm_status := INVPUOPI.mtl_log_interface_err(
3913: org_id,
3914: user_id,
3915: login_id,
3916: prog_appid,

Line 3934: dumm_status := INVPUOPI.mtl_log_interface_err(

3930: /* Start Bug 3713912 */
3931: -- validate CHILD_LOT_FLAG
3932: -- cannot update if there is onhand or transactions pending or lots exist
3933: if (msi_temp.child_lot_flag <> msii_temp.child_lot_flag) AND (onhand_child_lot = 1) then
3934: dumm_status := INVPUOPI.mtl_log_interface_err(
3935: org_id,
3936: user_id,
3937: login_id,
3938: prog_appid,

Line 3951: dumm_status := INVPUOPI.mtl_log_interface_err(

3947:
3948: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
3949:
3950: elsif (msi_temp.child_lot_flag <> msii_temp.child_lot_flag) AND (pendadj_child_lot = 1) then
3951: dumm_status := INVPUOPI.mtl_log_interface_err(
3952: org_id,
3953: user_id,
3954: login_id,
3955: prog_appid,

Line 3972: dumm_status := INVPUOPI.mtl_log_interface_err(

3968:
3969: -- validate GRADE_CONTROL_FLAG
3970: -- cannot update if there is onhand or transactions pending or lots exist
3971: if (msi_temp.grade_control_flag <> msii_temp.grade_control_flag) AND (onhand_grade = 1) then
3972: dumm_status := INVPUOPI.mtl_log_interface_err(
3973: org_id,
3974: user_id,
3975: login_id,
3976: prog_appid,

Line 3989: dumm_status := INVPUOPI.mtl_log_interface_err(

3985:
3986: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
3987:
3988: elsif (msi_temp.grade_control_flag <> msii_temp.grade_control_flag) AND (pendadj_grade = 1) then
3989: dumm_status := INVPUOPI.mtl_log_interface_err(
3990: org_id,
3991: user_id,
3992: login_id,
3993: prog_appid,

Line 4010: dumm_status := INVPUOPI.mtl_log_interface_err(

4006:
4007: -- validate LOT_DIVISIBLE_FLAG
4008: -- cannot update if there is onhand or transactions pending or lots exist
4009: if (msi_temp.lot_divisible_flag <> msii_temp.lot_divisible_flag) AND (onhand_lot_divisible = 1) then
4010: dumm_status := INVPUOPI.mtl_log_interface_err(
4011: org_id,
4012: user_id,
4013: login_id,
4014: prog_appid,

Line 4027: dumm_status := INVPUOPI.mtl_log_interface_err(

4023:
4024: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4025:
4026: elsif (msi_temp.lot_divisible_flag <> msii_temp.lot_divisible_flag) AND (pendadj_lot_divisible = 1) then
4027: dumm_status := INVPUOPI.mtl_log_interface_err(
4028: org_id,
4029: user_id,
4030: login_id,
4031: prog_appid,

Line 4055: dumm_status := INVPUOPI.mtl_log_interface_err(

4051: AND ( (msi_temp.SHELF_LIFE_CODE = 1)
4052: OR (msii_temp.SHELF_LIFE_CODE = 1)
4053: )
4054: AND (onhand_shelf = 1) then
4055: dumm_status := INVPUOPI.mtl_log_interface_err(
4056: org_id,
4057: user_id,
4058: login_id,
4059: prog_appid,

Line 4079: dumm_status := INVPUOPI.mtl_log_interface_err(

4075:
4076: -- validate LOCATOR_CONTROL_CODE
4077: -- cannot update if there is onhand or transactions pending
4078: if (msi_temp.LOCATION_CONTROL_CODE <> msii_temp.LOCATION_CONTROL_CODE) AND (onhand_loc = 1) then
4079: dumm_status := INVPUOPI.mtl_log_interface_err(
4080: org_id,
4081: user_id,
4082: login_id,
4083: prog_appid,

Line 4096: dumm_status := INVPUOPI.mtl_log_interface_err(

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.LOCATION_CONTROL_CODE <> msii_temp.LOCATION_CONTROL_CODE) AND (pendadj_loc = 1) then
4096: dumm_status := INVPUOPI.mtl_log_interface_err(
4097: org_id,
4098: user_id,
4099: login_id,
4100: prog_appid,

Line 4120: dumm_status := INVPUOPI.mtl_log_interface_err(

4116: -- validate RESERVABLE_TYPE
4117: -- cannot update from 1 (reservable) if rows exist in mtl_demand
4118:
4119: if (msi_temp.reservable_type = 1) and (msii_temp.reservable_type <> 1) and (rsv_exists = 1) then
4120: dumm_status := INVPUOPI.mtl_log_interface_err(
4121: org_id,
4122: user_id,
4123: login_id,
4124: prog_appid,

Line 4143: dumm_status := INVPUOPI.mtl_log_interface_err(

4139: if (msi_temp.reservable_type = 2) and (msii_temp.reservable_type = 1) and (rsv_exists <> 1) then
4140:
4141: if (INV_ATTRIBUTE_CONTROL_PVT.reservable_check(msii_temp.organization_id,
4142: msii_temp.inventory_item_id)) then
4143: dumm_status := INVPUOPI.mtl_log_interface_err(
4144: org_id,
4145: user_id,
4146: login_id,
4147: prog_appid,

Line 4171: dumm_status := INVPUOPI.mtl_log_interface_err(

4167:
4168: if (msi_temp.mtl_transactions_enabled_flag = 'Y') and (msii_temp.mtl_transactions_enabled_flag = 'N') then
4169:
4170: if (INV_ATTRIBUTE_CONTROL_PVT.transactable_uncheck(msii_temp.organization_id, msii_temp.inventory_item_id)) then
4171: dumm_status := INVPUOPI.mtl_log_interface_err(
4172: org_id,
4173: user_id,
4174: login_id,
4175: prog_appid,

Line 4198: dumm_status := INVPUOPI.mtl_log_interface_err(

4194:
4195: if (msi_temp.SHIPPABLE_ITEM_FLAG <> msii_temp.SHIPPABLE_ITEM_FLAG) and
4196: (so_ship = 1) then
4197:
4198: dumm_status := INVPUOPI.mtl_log_interface_err(
4199: org_id,
4200: user_id,
4201: login_id,
4202: prog_appid,

Line 4215: dumm_status := INVPUOPI.mtl_log_interface_err(

4211: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4212: elsif (msi_temp.SHIPPABLE_ITEM_FLAG = 'N' ) and (msii_temp.SHIPPABLE_ITEM_FLAG = 'Y') then
4213: if (INV_ATTRIBUTE_CONTROL_PVT.shippable_check(msii_temp.organization_id,
4214: msii_temp.inventory_item_id)) then
4215: dumm_status := INVPUOPI.mtl_log_interface_err(
4216: org_id,
4217: user_id,
4218: login_id,
4219: prog_appid,

Line 4241: dumm_status := INVPUOPI.mtl_log_interface_err(

4237: -- cannot update if there are Open sales order lines
4238:
4239: if (msi_temp.REPLENISH_TO_ORDER_FLAG <> msii_temp.REPLENISH_TO_ORDER_FLAG) and (so_ato = 1) then
4240:
4241: dumm_status := INVPUOPI.mtl_log_interface_err(
4242: org_id,
4243: user_id,
4244: login_id,
4245: prog_appid,

Line 4263: dumm_status := INVPUOPI.mtl_log_interface_err(

4259: -- validate REVISION_QTY_CONTROL_CODE
4260: -- cannot update if there is onhand or transactions pending
4261:
4262: if (msi_temp.REVISION_QTY_CONTROL_CODE <> msii_temp.REVISION_QTY_CONTROL_CODE) AND (onhand_rev = 1) then
4263: dumm_status := INVPUOPI.mtl_log_interface_err(
4264: org_id,
4265: user_id,
4266: login_id,
4267: prog_appid,

Line 4280: dumm_status := INVPUOPI.mtl_log_interface_err(

4276:
4277: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4278: /*Bug 6501149 Code starts */
4279: elsif (msi_temp.REVISION_QTY_CONTROL_CODE <> msii_temp.REVISION_QTY_CONTROL_CODE) AND (revision_control = 1) then
4280: dumm_status := INVPUOPI.mtl_log_interface_err(
4281: org_id,
4282: user_id,
4283: login_id,
4284: prog_appid,

Line 4298: dumm_status := INVPUOPI.mtl_log_interface_err(

4294: /*Bug 6501149 Code ends */
4295:
4296: /* Bug 3058650 : Validation added as part of Item attribute checks ER */
4297: elsif (msi_temp.REVISION_QTY_CONTROL_CODE <> msii_temp.REVISION_QTY_CONTROL_CODE) AND (pendadj_rev = 1) then
4298: dumm_status := INVPUOPI.mtl_log_interface_err(
4299: org_id,
4300: user_id,
4301: login_id,
4302: prog_appid,

Line 4329: dumm_status := INVPUOPI.mtl_log_interface_err(

4325: (onhand_serial = 1))or
4326: ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6)) and
4327: (onhand_serial = 1)) then
4328:
4329: dumm_status := INVPUOPI.mtl_log_interface_err(
4330: org_id,
4331: user_id,
4332: login_id,
4333: prog_appid,

Line 4348: dumm_status := INVPUOPI.mtl_log_interface_err(

4344: msii_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5,6))then
4345:
4346: if (INV_ATTRIBUTE_CONTROL_PVT.serial_check(msii_temp.organization_id,
4347: msii_temp.inventory_item_id)) then
4348: dumm_status := INVPUOPI.mtl_log_interface_err(
4349: org_id,
4350: user_id,
4351: login_id,
4352: prog_appid,

Line 4371: dumm_status := INVPUOPI.mtl_log_interface_err(

4367: (intr_ship_serial = 1)) or
4368: ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6)) and
4369: (intr_ship_serial = 1)) then
4370:
4371: dumm_status := INVPUOPI.mtl_log_interface_err(
4372: org_id,
4373: user_id,
4374: login_id,
4375: prog_appid,

Line 4393: dumm_status := INVPUOPI.mtl_log_interface_err(

4389: (serial_control = 1)) or
4390: ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6)) and
4391: (serial_control = 1)) then
4392:
4393: dumm_status := INVPUOPI.mtl_log_interface_err(
4394: org_id,
4395: user_id,
4396: login_id,
4397: prog_appid,

Line 4416: dumm_status := INVPUOPI.mtl_log_interface_err(

4412: -- Must =Y when bom_item_type = 5
4413:
4414: if (msii_temp.bom_item_type = 5) and
4415: (msii_temp.bom_enabled_flag = 'N') then
4416: dumm_status := INVPUOPI.mtl_log_interface_err(
4417: org_id,
4418: user_id,
4419: login_id,
4420: prog_appid,

Line 4441: dumm_status := INVPUOPI.mtl_log_interface_err(

4437:
4438: if (msi_temp.bom_item_type <> msii_temp.bom_item_type) and
4439: ( (bom_item = 1) or
4440: (msii_temp.bom_item_type = 5 and bom_exists = 1) ) then
4441: dumm_status := INVPUOPI.mtl_log_interface_err(
4442: org_id,
4443: user_id,
4444: login_id,
4445: prog_appid,

Line 4461: dumm_status := INVPUOPI.mtl_log_interface_err(

4457:
4458: -- Start : 3436435 Item in BOM,BOM Enabled cannot be N
4459: /* commented for bug 5479302
4460: if (msii_temp.bom_enabled_flag = 'N' and bom_exists = 1) then
4461: dumm_status := INVPUOPI.mtl_log_interface_err(
4462: org_id,
4463: user_id,
4464: login_id,
4465: prog_appid,

Line 4497: dumm_status := INVPUOPI.mtl_log_interface_err(

4493: msii_temp.base_item_id IS NOT NULL OR
4494: msii_temp.internal_order_flag <> 'N' OR
4495: msii_temp.vendor_warranty_flag <> 'N') then
4496:
4497: dumm_status := INVPUOPI.mtl_log_interface_err(
4498: org_id,
4499: user_id,
4500: login_id,
4501: prog_appid,

Line 4522: dumm_status := INVPUOPI.mtl_log_interface_err(

4518:
4519: if (msii_temp.bom_item_type = 5 and
4520: so_open_exists = 1) then
4521:
4522: dumm_status := INVPUOPI.mtl_log_interface_err(
4523: org_id,
4524: user_id,
4525: login_id,
4526: prog_appid,

Line 4558: dumm_status := INVPUOPI.mtl_log_interface_err(

4554: EXCEPTION WHEN NO_DATA_FOUND THEN
4555: l_item_has_lot_comp := 0;
4556: end;
4557: IF l_item_has_lot_comp = 1 THEN
4558: dumm_status := INVPUOPI.mtl_log_interface_err(
4559: org_id,
4560: user_id,
4561: login_id,
4562: prog_appid,

Line 4583: dumm_status := INVPUOPI.mtl_log_interface_err(

4579: -- for orgs where costing_org = :org)
4580: --
4581: if (msi_temp.costing_enabled_flag <> msii_temp.costing_enabled_flag) and
4582: (cost_txn = 1) then
4583: dumm_status := INVPUOPI.mtl_log_interface_err(
4584: org_id,
4585: user_id,
4586: login_id,
4587: prog_appid,

Line 4609: dumm_status := INVPUOPI.mtl_log_interface_err(

4605: -- for orgs where costing_org = org)
4606:
4607: if (msi_temp.inventory_asset_flag <> msii_temp.inventory_asset_flag) and
4608: (cost_txn = 1) then
4609: dumm_status := INVPUOPI.mtl_log_interface_err(
4610: org_id,
4611: user_id,
4612: login_id,
4613: prog_appid,

Line 4631: dumm_status := INVPUOPI.mtl_log_interface_err(

4627: -- validate FIXED_ORDER_QUANTITY
4628: -- must be > 0
4629:
4630: if (msii_temp.fixed_order_quantity <=0 ) then
4631: dumm_status := INVPUOPI.mtl_log_interface_err(
4632: org_id,
4633: user_id,
4634: login_id,
4635: prog_appid,

Line 4654: dumm_status := INVPUOPI.mtl_log_interface_err(

4650: -- Must be 1 if bom_item_type = 5 (product family)
4651: --
4652: if (msii_temp.planning_make_buy_code <> 1) AND
4653: (msii_temp.bom_item_type = 5) then
4654: dumm_status := INVPUOPI.mtl_log_interface_err(
4655: org_id,
4656: user_id,
4657: login_id,
4658: prog_appid,

Line 4676: dumm_status := INVPUOPI.mtl_log_interface_err(

4672: -- validate ACCEPTABLE_EARLY_DAYS
4673: -- must be > 0
4674:
4675: if (msii_temp.acceptable_early_days <= 0) then
4676: dumm_status := INVPUOPI.mtl_log_interface_err(
4677: org_id,
4678: user_id,
4679: login_id,
4680: prog_appid,

Line 4698: dumm_status := INVPUOPI.mtl_log_interface_err(

4694: -- validate ACCEPTABLE_RATE_INCREASE
4695: -- must be >= 0
4696:
4697: if (msii_temp.acceptable_rate_increase < 0) then
4698: dumm_status := INVPUOPI.mtl_log_interface_err(
4699: org_id,
4700: user_id,
4701: login_id,
4702: prog_appid,

Line 4720: dumm_status := INVPUOPI.mtl_log_interface_err(

4716: -- validate ACCEPTABLE_RATE_DECREASE
4717: -- must be >= 0
4718:
4719: if (msii_temp.acceptable_rate_decrease < 0) then
4720: dumm_status := INVPUOPI.mtl_log_interface_err(
4721: org_id,
4722: user_id,
4723: login_id,
4724: prog_appid,

Line 4743: dumm_status := INVPUOPI.mtl_log_interface_err(

4739: -- updateable only if DEMAND_TIME_FENCE_CODE = 4
4740:
4741: if( msii_temp.demand_time_fence_days <> msi_temp.demand_time_fence_days) AND
4742: (msii_temp.demand_time_fence_code <> 4) then
4743: dumm_status := INVPUOPI.mtl_log_interface_err(
4744: org_id,
4745: user_id,
4746: login_id,
4747: prog_appid,

Line 4766: dumm_status := INVPUOPI.mtl_log_interface_err(

4762: -- updateable only if PLANNING_TIME_FENCE_CODE = 4
4763:
4764: if( msii_temp.planning_time_fence_days <> msi_temp.planning_time_fence_days) AND
4765: (msii_temp.planning_time_fence_code <> 4) then
4766: dumm_status := INVPUOPI.mtl_log_interface_err(
4767: org_id,
4768: user_id,
4769: login_id,
4770: prog_appid,

Line 4789: dumm_status := INVPUOPI.mtl_log_interface_err(

4785: -- not updateable if row exists in mrp_schedule_items for item and org
4786:
4787: if (msii_temp.repetitive_planning_flag <> msi_temp.repetitive_planning_flag) and
4788: (mrp_schedule = 1) then
4789: dumm_status := INVPUOPI.mtl_log_interface_err(
4790: org_id,
4791: user_id,
4792: login_id,
4793: prog_appid,

Line 4813: dumm_status := INVPUOPI.mtl_log_interface_err(

4809:
4810: if (msii_temp.shrinkage_rate >= 1) or
4811: (msii_temp.shrinkage_rate < 0) then
4812:
4813: dumm_status := INVPUOPI.mtl_log_interface_err(
4814: org_id,
4815: user_id,
4816: login_id,
4817: prog_appid,

Line 4837: dumm_status := INVPUOPI.mtl_log_interface_err(

4833: -- must be 0 when BOM_ITEM_TYPE = 5
4834:
4835: if (msii_temp.full_lead_time <> 0) and
4836: (msii_temp.bom_item_type = 5) then
4837: dumm_status := INVPUOPI.mtl_log_interface_err(
4838: org_id,
4839: user_id,
4840: login_id,
4841: prog_appid,

Line 4875: dumm_status := INVPUOPI.mtl_log_interface_err(

4871: -- not updateable and = 0 if PLANNING_MAKE_BUY_CODE = 1
4872:
4873: if (msii_temp.planning_make_buy_code = 1) and
4874: (msii_temp.postprocessing_lead_time <> 0) then
4875: dumm_status := INVPUOPI.mtl_log_interface_err(
4876: org_id,
4877: user_id,
4878: login_id,
4879: prog_appid,

Line 4897: dumm_status := INVPUOPI.mtl_log_interface_err(

4893: -- validate VARIABLE_LEAD_TIME
4894: -- must be > 0
4895:
4896: if (msii_temp.variable_lead_time < 0) then
4897: dumm_status := INVPUOPI.mtl_log_interface_err(
4898: org_id,
4899: user_id,
4900: login_id,
4901: prog_appid,

Line 4916: dumm_status := INVPUOPI.mtl_log_interface_err(

4912: end if;
4913:
4914: /* Validation added for Bug 4139304 - Anmurali */
4915: if ((msi_temp.effectivity_control <> msii_temp.effectivity_control) AND (bom_item = 1 OR onhand_all = 1)) then
4916: dumm_status := INVPUOPI.mtl_log_interface_err(
4917: org_id,
4918: user_id,
4919: login_id,
4920: prog_appid,

Line 4941: dumm_status := INVPUOPI.mtl_log_interface_err(

4937: -- must be 'N' when SERVICE_ITEM_FLAG = 'Y'
4938: /*
4939: if (msii_temp.build_in_wip_flag <> 'N') and
4940: (msii_temp.service_item_flag = 'Y') then
4941: dumm_status := INVPUOPI.mtl_log_interface_err(
4942: org_id,
4943: user_id,
4944: login_id,
4945: prog_appid,

Line 4964: dumm_status := INVPUOPI.mtl_log_interface_err(

4960: -- must be 'N' when MATERIAL_BILLABLE_FLAG <> null
4961: /*
4962: if (msii_temp.service_item_flag <> 'N') and
4963: (msii_temp.material_billable_flag IS NOT NULL) then
4964: dumm_status := INVPUOPI.mtl_log_interface_err(
4965: org_id,
4966: user_id,
4967: login_id,
4968: prog_appid,

Line 4986: dumm_status := INVPUOPI.mtl_log_interface_err(

4982: -- validate SERVICE_STARTING_DELAY
4983: -- must be >= 0
4984:
4985: if (msii_temp.service_starting_delay < 0) then
4986: dumm_status := INVPUOPI.mtl_log_interface_err(
4987: org_id,
4988: user_id,
4989: login_id,
4990: prog_appid,

Line 5007: dumm_status := INVPUOPI.mtl_log_interface_err(

5003: -- validate VEHICLE_ITEM_FLAG
5004: -- Not updateable when row exists in FTE_VEHICLE_TYPES
5005:
5006: if (msii_temp.vehicle_item_flag <> 'Y' and fte_vehicle_exists = 1) then
5007: dumm_status := INVPUOPI.mtl_log_interface_err(
5008: org_id,
5009: user_id,
5010: login_id,
5011: prog_appid,

Line 5028: dumm_status := INVPUOPI.mtl_log_interface_err(

5024: -- validate COMMS_NL_TRACKABLE_FLAG
5025: -- Not updateable when Onhand Trackable exists
5026:
5027: if ( NVL(msii_temp.COMMS_NL_TRACKABLE_FLAG,'N') <> NVL(msi_temp.COMMS_NL_TRACKABLE_FLAG,'N') and onhand_trackable = 1) then
5028: dumm_status := INVPUOPI.mtl_log_interface_err(
5029: org_id,
5030: user_id,
5031: login_id,
5032: prog_appid,

Line 5053: dumm_status := INVPUOPI.mtl_log_interface_err(

5049: -- validate OUTSIDE_OPERATION_FLAG, EAM_ITEM_TYPE, MTL_TRANSACTIONS_ENABLED_FLAG, STOCK_ENABLED_FLAG and INVENTORY_ASSET_FLAG
5050: -- validate Not updateable fields
5051: /*Bug 6501149 Code starts */
5052: if ((msi_temp.STOCK_ENABLED_FLAG <> msii_temp.STOCK_ENABLED_FLAG) AND (stockable = 1) AND msii_temp.STOCK_ENABLED_FLAG = 'N') then
5053: dumm_status := INVPUOPI.mtl_log_interface_err(
5054: org_id,
5055: user_id,
5056: login_id,
5057: prog_appid,

Line 5090: dumm_status := INVPUOPI.mtl_log_interface_err(

5086: IF l_inv_debug_level IN(101, 102) THEN
5087: INVPUTLI.info('INVUPD2B: Inside update_validations: VMI validations failed');
5088: END IF;
5089:
5090: dumm_status := INVPUOPI.mtl_log_interface_err(
5091: org_id,
5092: user_id,
5093: login_id,
5094: prog_appid,

Line 5116: dumm_status := INVPUOPI.mtl_log_interface_err(

5112: if (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (onhand_tracking_qty_ind = 1) then
5113: IF l_inv_debug_level IN(101, 102) THEN
5114: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND onhand validations failed');
5115: END IF;
5116: dumm_status := INVPUOPI.mtl_log_interface_err(
5117: org_id,
5118: user_id,
5119: login_id,
5120: prog_appid,

Line 5136: dumm_status := INVPUOPI.mtl_log_interface_err(

5132: elsif (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (pendadj_tracking_qty_ind = 1) then
5133: IF l_inv_debug_level IN(101, 102) THEN
5134: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');
5135: END IF;
5136: dumm_status := INVPUOPI.mtl_log_interface_err(
5137: org_id,
5138: user_id,
5139: login_id,
5140: prog_appid,

Line 5160: dumm_status := INVPUOPI.mtl_log_interface_err(

5156: if (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (onhand_secondary_uom = 1) then
5157: IF l_inv_debug_level IN(101, 102) THEN
5158: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE onhand validations failed');
5159: END IF;
5160: dumm_status := INVPUOPI.mtl_log_interface_err(
5161: org_id,
5162: user_id,
5163: login_id,
5164: prog_appid,

Line 5180: dumm_status := INVPUOPI.mtl_log_interface_err(

5176: elsif (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (pendadj_secondary_uom = 1) then
5177: IF l_inv_debug_level IN(101, 102) THEN
5178: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');
5179: END IF;
5180: dumm_status := INVPUOPI.mtl_log_interface_err(
5181: org_id,
5182: user_id,
5183: login_id,
5184: prog_appid,

Line 5204: dumm_status := INVPUOPI.mtl_log_interface_err(

5200: if (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (onhand_sec_default_ind = 1) then
5201: IF l_inv_debug_level IN(101, 102) THEN
5202: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND onhand validations failed');
5203: END IF;
5204: dumm_status := INVPUOPI.mtl_log_interface_err(
5205: org_id,
5206: user_id,
5207: login_id,
5208: prog_appid,

Line 5224: dumm_status := INVPUOPI.mtl_log_interface_err(

5220: elsif (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (pendadj_sec_default_ind = 1) then
5221: IF l_inv_debug_level IN(101, 102) THEN
5222: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');
5223: END IF;
5224: dumm_status := INVPUOPI.mtl_log_interface_err(
5225: org_id,
5226: user_id,
5227: login_id,
5228: prog_appid,

Line 5248: dumm_status := INVPUOPI.mtl_log_interface_err(

5244: if (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (onhand_primary_uom = 1) then
5245: IF l_inv_debug_level IN(101, 102) THEN
5246: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE onhand validations failed');
5247: END IF;
5248: dumm_status := INVPUOPI.mtl_log_interface_err(
5249: org_id,
5250: user_id,
5251: login_id,
5252: prog_appid,

Line 5268: dumm_status := INVPUOPI.mtl_log_interface_err(

5264: elsif (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (pendadj_primary_uom = 1) then
5265: IF l_inv_debug_level IN(101, 102) THEN
5266: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');
5267: END IF;
5268: dumm_status := INVPUOPI.mtl_log_interface_err(
5269: org_id,
5270: user_id,
5271: login_id,
5272: prog_appid,

Line 5292: dumm_status := INVPUOPI.mtl_log_interface_err(

5288: if (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (onhand_deviation_high = 1) then
5289: IF l_inv_debug_level IN(101, 102) THEN
5290: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH onhand validations failed');
5291: END IF;
5292: dumm_status := INVPUOPI.mtl_log_interface_err(
5293: org_id,
5294: user_id,
5295: login_id,
5296: prog_appid,

Line 5312: dumm_status := INVPUOPI.mtl_log_interface_err(

5308: elsif (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (pendadj_deviation_high = 1) then
5309: IF l_inv_debug_level IN(101, 102) THEN
5310: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');
5311: END IF;
5312: dumm_status := INVPUOPI.mtl_log_interface_err(
5313: org_id,
5314: user_id,
5315: login_id,
5316: prog_appid,

Line 5336: dumm_status := INVPUOPI.mtl_log_interface_err(

5332: if (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (onhand_deviation_low = 1) then
5333: IF l_inv_debug_level IN(101, 102) THEN
5334: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW onhand validations failed');
5335: END IF;
5336: dumm_status := INVPUOPI.mtl_log_interface_err(
5337: org_id,
5338: user_id,
5339: login_id,
5340: prog_appid,

Line 5356: dumm_status := INVPUOPI.mtl_log_interface_err(

5352: elsif (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (pendadj_deviation_low = 1) then
5353: IF l_inv_debug_level IN(101, 102) THEN
5354: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');
5355: END IF;
5356: dumm_status := INVPUOPI.mtl_log_interface_err(
5357: org_id,
5358: user_id,
5359: login_id,
5360: prog_appid,

Line 5642: dumm_status := INVPUOPI.mtl_log_interface_err(

5638: error_msg := FND_MESSAGE.GET;
5639:
5640: IF transaction_table.COUNT > 0 THEN
5641: FOR j IN transaction_table.FIRST .. transaction_table.LAST LOOP
5642: dumm_status := INVPUOPI.mtl_log_interface_err(
5643: item_rec.organization_id,
5644: user_id,
5645: login_id,
5646: prg_appid,

Line 6467: dumm_status := INVPUOPI.mtl_log_interface_err(

6463: WHERE inventory_item_id = item_rec.inventory_item_id
6464: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
6465: and process_flag = 3 AND ROWNUM=1;
6466:
6467: dumm_status := INVPUOPI.mtl_log_interface_err(
6468: l_org_id,
6469: user_id,
6470: login_id,
6471: prg_appid,

Line 6504: dumm_status := INVPUOPI.mtl_log_interface_err(

6500: WHERE inventory_item_id = item_rec.inventory_item_id
6501: and (set_process_id = xset_id or set_process_id = xset_id +1000000000000)
6502: and process_flag = 3 AND ROWNUM=1;
6503:
6504: dumm_status := INVPUOPI.mtl_log_interface_err(
6505: l_org_id,
6506: user_id,
6507: login_id,
6508: prg_appid,

Line 6709: dumm_status := INVPUOPI.mtl_log_interface_err(

6705: last_update_login = login_id
6706: WHERE rowid = rev_rec.rowid
6707: RETURNING organization_id,transaction_id INTO l_org_id,l_transaction_id;
6708:
6709: dumm_status := INVPUOPI.mtl_log_interface_err(
6710: l_org_id,
6711: user_id,
6712: login_id,
6713: prg_appid,