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 760: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 3968: dumm_status := INVPUOPI.mtl_log_interface_err(

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
3968: dumm_status := INVPUOPI.mtl_log_interface_err(
3969: org_id,
3970: user_id,
3971: login_id,
3972: prog_appid,

Line 3986: dumm_status := INVPUOPI.mtl_log_interface_err(

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(
3987: org_id,
3988: user_id,
3989: login_id,
3990: prog_appid,

Line 4004: dumm_status := INVPUOPI.mtl_log_interface_err(

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(
4005: org_id,
4006: user_id,
4007: login_id,
4008: prog_appid,

Line 4021: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4023: user_id,
4024: login_id,
4025: prog_appid,

Line 4040: dumm_status := INVPUOPI.mtl_log_interface_err(

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
4040: dumm_status := INVPUOPI.mtl_log_interface_err(
4041: org_id,
4042: user_id,
4043: login_id,
4044: prog_appid,

Line 4057: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4059: user_id,
4060: login_id,
4061: prog_appid,

Line 4079: dumm_status := INVPUOPI.mtl_log_interface_err(

4075: /* Start Bug 3713912 */
4076: -- validate CHILD_LOT_FLAG
4077: -- cannot update if there is onhand or transactions pending or lots exist
4078: if (msi_temp.child_lot_flag <> msii_temp.child_lot_flag) AND (onhand_child_lot = 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.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,
4098: user_id,
4099: login_id,
4100: prog_appid,

Line 4117: dumm_status := INVPUOPI.mtl_log_interface_err(

4113:
4114: -- validate GRADE_CONTROL_FLAG
4115: -- cannot update if there is onhand or transactions pending or lots exist
4116: if (msi_temp.grade_control_flag <> msii_temp.grade_control_flag) AND (onhand_grade = 1) then
4117: dumm_status := INVPUOPI.mtl_log_interface_err(
4118: org_id,
4119: user_id,
4120: login_id,
4121: prog_appid,

Line 4134: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4136: user_id,
4137: login_id,
4138: prog_appid,

Line 4155: dumm_status := INVPUOPI.mtl_log_interface_err(

4151:
4152: -- validate LOT_DIVISIBLE_FLAG
4153: -- cannot update if there is onhand or transactions pending or lots exist
4154: if (msi_temp.lot_divisible_flag <> msii_temp.lot_divisible_flag) AND (onhand_lot_divisible = 1) then
4155: dumm_status := INVPUOPI.mtl_log_interface_err(
4156: org_id,
4157: user_id,
4158: login_id,
4159: prog_appid,

Line 4172: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4174: user_id,
4175: login_id,
4176: prog_appid,

Line 4200: dumm_status := INVPUOPI.mtl_log_interface_err(

4196: AND ( (msi_temp.SHELF_LIFE_CODE = 1)
4197: OR (msii_temp.SHELF_LIFE_CODE = 1)
4198: )
4199: AND (onhand_shelf = 1) then
4200: dumm_status := INVPUOPI.mtl_log_interface_err(
4201: org_id,
4202: user_id,
4203: login_id,
4204: prog_appid,

Line 4224: dumm_status := INVPUOPI.mtl_log_interface_err(

4220:
4221: -- validate LOCATOR_CONTROL_CODE
4222: -- cannot update if there is onhand or transactions pending
4223: if (msi_temp.LOCATION_CONTROL_CODE <> msii_temp.LOCATION_CONTROL_CODE) AND (onhand_loc = 1) then
4224: dumm_status := INVPUOPI.mtl_log_interface_err(
4225: org_id,
4226: user_id,
4227: login_id,
4228: prog_appid,

Line 4241: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4243: user_id,
4244: login_id,
4245: prog_appid,

Line 4265: dumm_status := INVPUOPI.mtl_log_interface_err(

4261: -- validate RESERVABLE_TYPE
4262: -- cannot update from 1 (reservable) if rows exist in mtl_demand
4263:
4264: if (msi_temp.reservable_type = 1) and (msii_temp.reservable_type <> 1) and (rsv_exists = 1) then
4265: dumm_status := INVPUOPI.mtl_log_interface_err(
4266: org_id,
4267: user_id,
4268: login_id,
4269: prog_appid,

Line 4288: dumm_status := INVPUOPI.mtl_log_interface_err(

4284: if (msi_temp.reservable_type = 2) and (msii_temp.reservable_type = 1) and (rsv_exists <> 1) then
4285:
4286: if (INV_ATTRIBUTE_CONTROL_PVT.reservable_check(msii_temp.organization_id,
4287: msii_temp.inventory_item_id)) then
4288: dumm_status := INVPUOPI.mtl_log_interface_err(
4289: org_id,
4290: user_id,
4291: login_id,
4292: prog_appid,

Line 4316: dumm_status := INVPUOPI.mtl_log_interface_err(

4312:
4313: if (msi_temp.mtl_transactions_enabled_flag = 'Y') and (msii_temp.mtl_transactions_enabled_flag = 'N') then
4314:
4315: if (INV_ATTRIBUTE_CONTROL_PVT.transactable_uncheck(msii_temp.organization_id, msii_temp.inventory_item_id)) then
4316: dumm_status := INVPUOPI.mtl_log_interface_err(
4317: org_id,
4318: user_id,
4319: login_id,
4320: prog_appid,

Line 4343: dumm_status := INVPUOPI.mtl_log_interface_err(

4339:
4340: if (msi_temp.SHIPPABLE_ITEM_FLAG <> msii_temp.SHIPPABLE_ITEM_FLAG) and
4341: (so_ship = 1) then
4342:
4343: dumm_status := INVPUOPI.mtl_log_interface_err(
4344: org_id,
4345: user_id,
4346: login_id,
4347: prog_appid,

Line 4360: dumm_status := INVPUOPI.mtl_log_interface_err(

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(
4361: org_id,
4362: user_id,
4363: login_id,
4364: prog_appid,

Line 4386: dumm_status := INVPUOPI.mtl_log_interface_err(

4382: -- cannot update if there are Open sales order lines
4383:
4384: if (msi_temp.REPLENISH_TO_ORDER_FLAG <> msii_temp.REPLENISH_TO_ORDER_FLAG) and (so_ato = 1) then
4385:
4386: dumm_status := INVPUOPI.mtl_log_interface_err(
4387: org_id,
4388: user_id,
4389: login_id,
4390: prog_appid,

Line 4408: dumm_status := INVPUOPI.mtl_log_interface_err(

4404: -- validate REVISION_QTY_CONTROL_CODE
4405: -- cannot update if there is onhand or transactions pending
4406:
4407: if (msi_temp.REVISION_QTY_CONTROL_CODE <> msii_temp.REVISION_QTY_CONTROL_CODE) AND (onhand_rev = 1) then
4408: dumm_status := INVPUOPI.mtl_log_interface_err(
4409: org_id,
4410: user_id,
4411: login_id,
4412: prog_appid,

Line 4425: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4427: user_id,
4428: login_id,
4429: prog_appid,

Line 4443: dumm_status := INVPUOPI.mtl_log_interface_err(

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
4443: dumm_status := INVPUOPI.mtl_log_interface_err(
4444: org_id,
4445: user_id,
4446: login_id,
4447: prog_appid,

Line 4474: dumm_status := INVPUOPI.mtl_log_interface_err(

4470: (onhand_serial = 1))or
4471: ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6)) and
4472: (onhand_serial = 1)) then
4473:
4474: dumm_status := INVPUOPI.mtl_log_interface_err(
4475: org_id,
4476: user_id,
4477: login_id,
4478: prog_appid,

Line 4493: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
4492: msii_temp.inventory_item_id)) then
4493: dumm_status := INVPUOPI.mtl_log_interface_err(
4494: org_id,
4495: user_id,
4496: login_id,
4497: prog_appid,

Line 4516: dumm_status := INVPUOPI.mtl_log_interface_err(

4512: (intr_ship_serial = 1)) or
4513: ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6)) and
4514: (intr_ship_serial = 1)) then
4515:
4516: dumm_status := INVPUOPI.mtl_log_interface_err(
4517: org_id,
4518: user_id,
4519: login_id,
4520: prog_appid,

Line 4538: dumm_status := INVPUOPI.mtl_log_interface_err(

4534: (serial_control = 1)) or
4535: ((msi_temp.SERIAL_NUMBER_CONTROL_CODE in (2,5) and msii_temp.SERIAL_NUMBER_CONTROL_CODE in (1,6)) and
4536: (serial_control = 1)) then
4537:
4538: dumm_status := INVPUOPI.mtl_log_interface_err(
4539: org_id,
4540: user_id,
4541: login_id,
4542: prog_appid,

Line 4561: dumm_status := INVPUOPI.mtl_log_interface_err(

4557: -- Must =Y when bom_item_type = 5
4558:
4559: if (msii_temp.bom_item_type = 5) and
4560: (msii_temp.bom_enabled_flag = 'N') then
4561: dumm_status := INVPUOPI.mtl_log_interface_err(
4562: org_id,
4563: user_id,
4564: login_id,
4565: prog_appid,

Line 4586: dumm_status := INVPUOPI.mtl_log_interface_err(

4582:
4583: if (msi_temp.bom_item_type <> msii_temp.bom_item_type) and
4584: ( (bom_item = 1) or
4585: (msii_temp.bom_item_type = 5 and bom_exists = 1) ) then
4586: dumm_status := INVPUOPI.mtl_log_interface_err(
4587: org_id,
4588: user_id,
4589: login_id,
4590: prog_appid,

Line 4606: dumm_status := INVPUOPI.mtl_log_interface_err(

4602:
4603: -- Start : 3436435 Item in BOM,BOM Enabled cannot be N
4604: /* commented for bug 5479302
4605: if (msii_temp.bom_enabled_flag = 'N' and bom_exists = 1) then
4606: dumm_status := INVPUOPI.mtl_log_interface_err(
4607: org_id,
4608: user_id,
4609: login_id,
4610: prog_appid,

Line 4642: dumm_status := INVPUOPI.mtl_log_interface_err(

4638: msii_temp.base_item_id IS NOT NULL OR
4639: msii_temp.internal_order_flag <> 'N' OR
4640: msii_temp.vendor_warranty_flag <> 'N') then
4641:
4642: dumm_status := INVPUOPI.mtl_log_interface_err(
4643: org_id,
4644: user_id,
4645: login_id,
4646: prog_appid,

Line 4667: dumm_status := INVPUOPI.mtl_log_interface_err(

4663:
4664: if (msii_temp.bom_item_type = 5 and
4665: so_open_exists = 1) then
4666:
4667: dumm_status := INVPUOPI.mtl_log_interface_err(
4668: org_id,
4669: user_id,
4670: login_id,
4671: prog_appid,

Line 4703: dumm_status := INVPUOPI.mtl_log_interface_err(

4699: EXCEPTION WHEN NO_DATA_FOUND THEN
4700: l_item_has_lot_comp := 0;
4701: end;
4702: IF l_item_has_lot_comp = 1 THEN
4703: dumm_status := INVPUOPI.mtl_log_interface_err(
4704: org_id,
4705: user_id,
4706: login_id,
4707: prog_appid,

Line 4728: dumm_status := INVPUOPI.mtl_log_interface_err(

4724: -- for orgs where costing_org = :org)
4725: --
4726: if (msi_temp.costing_enabled_flag <> msii_temp.costing_enabled_flag) and
4727: (cost_txn = 1) then
4728: dumm_status := INVPUOPI.mtl_log_interface_err(
4729: org_id,
4730: user_id,
4731: login_id,
4732: prog_appid,

Line 4756: dumm_status := INVPUOPI.mtl_log_interface_err(

4752: into costing_level
4753: from mtl_item_attributes where attribute_name = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG';
4754:
4755: IF (costing_level = 1) then
4756: dumm_status := INVPUOPI.mtl_log_interface_err(
4757: org_id,
4758: user_id,
4759: login_id,
4760: prog_appid,

Line 4782: dumm_status := INVPUOPI.mtl_log_interface_err(

4778: -- for orgs where costing_org = org)
4779:
4780: if (msi_temp.inventory_asset_flag <> msii_temp.inventory_asset_flag) and
4781: (cost_txn = 1) then
4782: dumm_status := INVPUOPI.mtl_log_interface_err(
4783: org_id,
4784: user_id,
4785: login_id,
4786: prog_appid,

Line 4810: dumm_status := INVPUOPI.mtl_log_interface_err(

4806: into invetory_asset_flag_level
4807: from mtl_item_attributes where attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG';
4808:
4809: IF (invetory_asset_flag_level = 1) then
4810: dumm_status := INVPUOPI.mtl_log_interface_err(
4811: org_id,
4812: user_id,
4813: login_id,
4814: prog_appid,

Line 4834: dumm_status := INVPUOPI.mtl_log_interface_err(

4830: -- validate FIXED_ORDER_QUANTITY
4831: -- must be > 0
4832:
4833: if (msii_temp.fixed_order_quantity <=0 ) then
4834: dumm_status := INVPUOPI.mtl_log_interface_err(
4835: org_id,
4836: user_id,
4837: login_id,
4838: prog_appid,

Line 4857: dumm_status := INVPUOPI.mtl_log_interface_err(

4853: -- Must be 1 if bom_item_type = 5 (product family)
4854: --
4855: if (msii_temp.planning_make_buy_code <> 1) AND
4856: (msii_temp.bom_item_type = 5) then
4857: dumm_status := INVPUOPI.mtl_log_interface_err(
4858: org_id,
4859: user_id,
4860: login_id,
4861: prog_appid,

Line 4879: dumm_status := INVPUOPI.mtl_log_interface_err(

4875: -- validate ACCEPTABLE_EARLY_DAYS
4876: -- must be > 0
4877:
4878: if (msii_temp.acceptable_early_days <= 0) then
4879: dumm_status := INVPUOPI.mtl_log_interface_err(
4880: org_id,
4881: user_id,
4882: login_id,
4883: prog_appid,

Line 4901: dumm_status := INVPUOPI.mtl_log_interface_err(

4897: -- validate ACCEPTABLE_RATE_INCREASE
4898: -- must be >= 0
4899:
4900: if (msii_temp.acceptable_rate_increase < 0) then
4901: dumm_status := INVPUOPI.mtl_log_interface_err(
4902: org_id,
4903: user_id,
4904: login_id,
4905: prog_appid,

Line 4923: dumm_status := INVPUOPI.mtl_log_interface_err(

4919: -- validate ACCEPTABLE_RATE_DECREASE
4920: -- must be >= 0
4921:
4922: if (msii_temp.acceptable_rate_decrease < 0) then
4923: dumm_status := INVPUOPI.mtl_log_interface_err(
4924: org_id,
4925: user_id,
4926: login_id,
4927: prog_appid,

Line 4946: dumm_status := INVPUOPI.mtl_log_interface_err(

4942: -- updateable only if DEMAND_TIME_FENCE_CODE = 4
4943:
4944: if( msii_temp.demand_time_fence_days <> msi_temp.demand_time_fence_days) AND
4945: (msii_temp.demand_time_fence_code <> 4) then
4946: dumm_status := INVPUOPI.mtl_log_interface_err(
4947: org_id,
4948: user_id,
4949: login_id,
4950: prog_appid,

Line 4969: dumm_status := INVPUOPI.mtl_log_interface_err(

4965: -- updateable only if PLANNING_TIME_FENCE_CODE = 4
4966:
4967: if( msii_temp.planning_time_fence_days <> msi_temp.planning_time_fence_days) AND
4968: (msii_temp.planning_time_fence_code <> 4) then
4969: dumm_status := INVPUOPI.mtl_log_interface_err(
4970: org_id,
4971: user_id,
4972: login_id,
4973: prog_appid,

Line 4992: dumm_status := INVPUOPI.mtl_log_interface_err(

4988: -- not updateable if row exists in mrp_schedule_items for item and org
4989:
4990: if (msii_temp.repetitive_planning_flag <> msi_temp.repetitive_planning_flag) and
4991: (mrp_schedule = 1) then
4992: dumm_status := INVPUOPI.mtl_log_interface_err(
4993: org_id,
4994: user_id,
4995: login_id,
4996: prog_appid,

Line 5016: dumm_status := INVPUOPI.mtl_log_interface_err(

5012:
5013: if (msii_temp.shrinkage_rate >= 1) or
5014: (msii_temp.shrinkage_rate < 0) then
5015:
5016: dumm_status := INVPUOPI.mtl_log_interface_err(
5017: org_id,
5018: user_id,
5019: login_id,
5020: prog_appid,

Line 5040: dumm_status := INVPUOPI.mtl_log_interface_err(

5036: -- must be 0 when BOM_ITEM_TYPE = 5
5037:
5038: if (msii_temp.full_lead_time <> 0) and
5039: (msii_temp.bom_item_type = 5) then
5040: dumm_status := INVPUOPI.mtl_log_interface_err(
5041: org_id,
5042: user_id,
5043: login_id,
5044: prog_appid,

Line 5078: dumm_status := INVPUOPI.mtl_log_interface_err(

5074: -- not updateable and = 0 if PLANNING_MAKE_BUY_CODE = 1
5075:
5076: if (msii_temp.planning_make_buy_code = 1) and
5077: (msii_temp.postprocessing_lead_time <> 0) then
5078: dumm_status := INVPUOPI.mtl_log_interface_err(
5079: org_id,
5080: user_id,
5081: login_id,
5082: prog_appid,

Line 5100: dumm_status := INVPUOPI.mtl_log_interface_err(

5096: -- validate VARIABLE_LEAD_TIME
5097: -- must be > 0
5098:
5099: if (msii_temp.variable_lead_time < 0) then
5100: dumm_status := INVPUOPI.mtl_log_interface_err(
5101: org_id,
5102: user_id,
5103: login_id,
5104: prog_appid,

Line 5119: dumm_status := INVPUOPI.mtl_log_interface_err(

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
5119: dumm_status := INVPUOPI.mtl_log_interface_err(
5120: org_id,
5121: user_id,
5122: login_id,
5123: prog_appid,

Line 5144: dumm_status := INVPUOPI.mtl_log_interface_err(

5140: -- must be 'N' when SERVICE_ITEM_FLAG = 'Y'
5141: /*
5142: if (msii_temp.build_in_wip_flag <> 'N') and
5143: (msii_temp.service_item_flag = 'Y') then
5144: dumm_status := INVPUOPI.mtl_log_interface_err(
5145: org_id,
5146: user_id,
5147: login_id,
5148: prog_appid,

Line 5167: dumm_status := INVPUOPI.mtl_log_interface_err(

5163: -- must be 'N' when MATERIAL_BILLABLE_FLAG <> null
5164: /*
5165: if (msii_temp.service_item_flag <> 'N') and
5166: (msii_temp.material_billable_flag IS NOT NULL) then
5167: dumm_status := INVPUOPI.mtl_log_interface_err(
5168: org_id,
5169: user_id,
5170: login_id,
5171: prog_appid,

Line 5189: dumm_status := INVPUOPI.mtl_log_interface_err(

5185: -- validate SERVICE_STARTING_DELAY
5186: -- must be >= 0
5187:
5188: if (msii_temp.service_starting_delay < 0) then
5189: dumm_status := INVPUOPI.mtl_log_interface_err(
5190: org_id,
5191: user_id,
5192: login_id,
5193: prog_appid,

Line 5210: dumm_status := INVPUOPI.mtl_log_interface_err(

5206: -- validate VEHICLE_ITEM_FLAG
5207: -- Not updateable when row exists in FTE_VEHICLE_TYPES
5208:
5209: if (msii_temp.vehicle_item_flag <> 'Y' and fte_vehicle_exists = 1) then
5210: dumm_status := INVPUOPI.mtl_log_interface_err(
5211: org_id,
5212: user_id,
5213: login_id,
5214: prog_appid,

Line 5231: dumm_status := INVPUOPI.mtl_log_interface_err(

5227: -- validate COMMS_NL_TRACKABLE_FLAG
5228: -- Not updateable when Onhand Trackable exists
5229:
5230: if ( NVL(msii_temp.COMMS_NL_TRACKABLE_FLAG,'N') <> NVL(msi_temp.COMMS_NL_TRACKABLE_FLAG,'N') and onhand_trackable = 1) then
5231: dumm_status := INVPUOPI.mtl_log_interface_err(
5232: org_id,
5233: user_id,
5234: login_id,
5235: prog_appid,

Line 5256: dumm_status := INVPUOPI.mtl_log_interface_err(

5252: -- validate OUTSIDE_OPERATION_FLAG, EAM_ITEM_TYPE, MTL_TRANSACTIONS_ENABLED_FLAG, STOCK_ENABLED_FLAG and INVENTORY_ASSET_FLAG
5253: -- validate Not updateable fields
5254: /*Bug 6501149 Code starts */
5255: if ((msi_temp.STOCK_ENABLED_FLAG <> msii_temp.STOCK_ENABLED_FLAG) AND (stockable = 1) AND msii_temp.STOCK_ENABLED_FLAG = 'N') then
5256: dumm_status := INVPUOPI.mtl_log_interface_err(
5257: org_id,
5258: user_id,
5259: login_id,
5260: prog_appid,

Line 5276: dumm_status := INVPUOPI.mtl_log_interface_err(

5272:
5273: /* BUG 9135696 code starts */
5274: if (msi_temp.STOCK_ENABLED_FLAG = 'Y') AND (msii_temp.STOCK_ENABLED_FLAG = 'N') then
5275: if (INV_ATTRIBUTE_CONTROL_PVT.check_pending_adjustments(msii_temp.organization_id, msii_temp.inventory_item_id, 'STOCK_ENABLED_FLAG')) then
5276: dumm_status := INVPUOPI.mtl_log_interface_err(
5277: org_id,
5278: user_id,
5279: login_id,
5280: prog_appid,

Line 5314: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5316: user_id,
5317: login_id,
5318: prog_appid,

Line 5340: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5343: login_id,
5344: prog_appid,

Line 5360: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5363: login_id,
5364: prog_appid,

Line 5384: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5387: login_id,
5388: prog_appid,

Line 5404: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5407: login_id,
5408: prog_appid,

Line 5428: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5431: login_id,
5432: prog_appid,

Line 5448: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5451: login_id,
5452: prog_appid,

Line 5472: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5475: login_id,
5476: prog_appid,

Line 5492: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5495: login_id,
5496: prog_appid,

Line 5516: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5519: login_id,
5520: prog_appid,

Line 5536: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5539: login_id,
5540: prog_appid,

Line 5560: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5563: login_id,
5564: prog_appid,

Line 5580: dumm_status := INVPUOPI.mtl_log_interface_err(

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,
5583: login_id,
5584: prog_appid,

Line 5603: dumm_status := INVPUOPI.mtl_log_interface_err(

5599:
5600: /** ****** BEGINNING - LANHUANG - Bug fix 13946893 (23AUG2012) ****** */
5601: IF(msi_temp.RECIPE_ENABLED_FLAG = 'Y' AND msii_temp.RECIPE_ENABLED_FLAG = 'N') THEN
5602: IF(NOT validate_recipe_enabled_flag(msii_temp.INVENTORY_ITEM_ID, msii_temp.ORGANIZATION_ID)) THEN
5603: dumm_status := INVPUOPI.mtl_log_interface_err(
5604: org_id,
5605: user_id,
5606: login_id,
5607: prog_appid,

Line 5920: dumm_status := INVPUOPI.mtl_log_interface_err(

5916: error_msg := FND_MESSAGE.GET;
5917:
5918: IF transaction_table.COUNT > 0 THEN
5919: FOR j IN transaction_table.FIRST .. transaction_table.LAST LOOP
5920: dumm_status := INVPUOPI.mtl_log_interface_err(
5921: item_rec.organization_id,
5922: user_id,
5923: login_id,
5924: prg_appid,

Line 6901: dumm_status := INVPUOPI.mtl_log_interface_err(

6897: WHERE inventory_item_id = item_rec.inventory_item_id
6898: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
6899: and process_flag = 3 AND ROWNUM=1;
6900:
6901: dumm_status := INVPUOPI.mtl_log_interface_err(
6902: l_org_id,
6903: user_id,
6904: login_id,
6905: prg_appid,

Line 6938: dumm_status := INVPUOPI.mtl_log_interface_err(

6934: WHERE inventory_item_id = item_rec.inventory_item_id
6935: and (set_process_id = xset_id or set_process_id = xset_id +1000000000000)
6936: and process_flag = 3 AND ROWNUM=1;
6937:
6938: dumm_status := INVPUOPI.mtl_log_interface_err(
6939: l_org_id,
6940: user_id,
6941: login_id,
6942: prg_appid,

Line 7184: dumm_status := INVPUOPI.mtl_log_interface_err(

7180: last_update_login = login_id
7181: WHERE rowid = rev_rec.rowid
7182: RETURNING organization_id,transaction_id INTO l_org_id,l_transaction_id;
7183:
7184: dumm_status := INVPUOPI.mtl_log_interface_err(
7185: l_org_id,
7186: user_id,
7187: login_id,
7188: prg_appid,