DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on INV_ATTRIBUTE_CONTROL_PVT

Line 4286: if (INV_ATTRIBUTE_CONTROL_PVT.reservable_check(msii_temp.organization_id,

4282: /* Bug 3058650 : Validation added as part of Item attribute checks ER */
4283:
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,

Line 4315: if (INV_ATTRIBUTE_CONTROL_PVT.transactable_uncheck(msii_temp.organization_id, msii_temp.inventory_item_id)) then

4311: -- cannot update if there are Open sales order lines
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,

Line 4358: if (INV_ATTRIBUTE_CONTROL_PVT.shippable_check(msii_temp.organization_id,

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(
4361: org_id,
4362: user_id,

Line 4491: if (INV_ATTRIBUTE_CONTROL_PVT.serial_check(msii_temp.organization_id,

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

Line 5275: if (INV_ATTRIBUTE_CONTROL_PVT.check_pending_adjustments(msii_temp.organization_id, msii_temp.inventory_item_id, 'STOCK_ENABLED_FLAG')) then

5271: /*Bug 6501149 code ends */
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,