[Home] [Help]
1484:
1485: -- Initialize message stack since p_init_msg_list is set to TRUE
1486: -- The p_init_msg_list is set to 'TRUE' in this code and so the message stack will always be initialised.
1487: --if fnd_api.to_boolean(p_init_msg_list) then
1488: -- fnd_msg_pub.initialize;
1489: --end if;
1490:
1491: if (l_debug = 1) then
1492: trace(' Entering procedure '|| l_proc || ':'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
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
1528: trace(l_proc || ' Operation Plan ID => ' || nvl(l_operation_plan_id, -99));
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.
1562: -- ### Check to make sure for valid data.
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;
1579: