[Home] [Help]
1519: l_pre_specified_zone_id, l_pre_specified_sub_code, l_loc_mtrl_grp_rule_id,
1520: l_operation_type, l_is_in_inventory, l_organization_id, l_lpn_id;
1521:
1522: if c_oper_plan_details%NOTFOUND then
1523: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');
1524: fnd_msg_pub.ADD;
1525: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
1526: else
1527: if (l_debug = 1) then
1553: -- ### l_loc_mtrl_grp_rule_id is null is being removed.
1554: -- if (l_loc_mtrl_grp_rule_id is null or l_loc_mtrl_grp_rule_id not in (1,2,3)) then
1555: if (l_loc_mtrl_grp_rule_id not in (1,2,3)) then
1556: trace('Incorrect Material Group ID stamped on the operation plan detail line ... Cannot Proceed');
1557: fnd_message.set_name('WMS', 'WMS_MTRL_GRP_RULE_ID_IS_NULL');
1558: fnd_msg_pub.ADD;
1559: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
1560: end if;
1561: -- ### Added after review with Amin on Oct 3rd 2003.
1570: -- ### nvl(wopd.is_in_inventory, 'N'),
1571: -- if (l_is_in_inventory is null or l_is_in_inventory not in ('Y','N')) then
1572: if (l_is_in_inventory not in ('Y','N')) then
1573: trace('Incorrect is_in_inventory flag stamped on the operation plan detail line ... Cannot Proceed');
1574: fnd_message.set_name('WMS', 'WMS_INVALID_ISININVFLAG');
1575: fnd_msg_pub.ADD;
1576: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
1577: end if;
1578: end if;