[Home] [Help]
1: PACKAGE BODY INV_MATERIAL_STATUS_GRP as
2: /* $Header: INVMSGRB.pls 120.58.12020000.3 2012/07/18 04:31:50 alxue ship $ */
3:
4:
5:
3:
4:
5:
6: -- Global constant holding package name
7: g_pkg_name constant varchar2(50) := 'INV_MATERIAL_STATUS_GRP';
8:
9: g_status_id NUMBER;
10: g_transaction_type_id NUMBER;
11: g_is_allowed VARCHAR2(1);
665: l_msg_data VARCHAR2(256);
666: BEGIN
667:
668:
669: allowed := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
670: p_status_id =>p_status_id
671: ,p_transaction_type_id=> p_transaction_type_id
672: ,x_return_status => l_return_status
673: ,x_msg_count => l_msg_count
762: l_return_status VARCHAR2(1);
763: BEGIN
764:
765: if (g_debug = 1) then
766: inv_trx_util_pub.TRACE('inside non-overloaded is_status_applicable ', 'INV_MATERIAL_STATUS_GRP', 14);
767: end if;
768:
769: l_return_status:= is_status_applicable(p_wms_installed ,
770: p_trx_status_enabled ,
982: l_serial_status_enabled := p_serial_status_enabled;
983: -- Onhand Material Status Support: We need lot and serial control even if the object type is not lot or serial.
984: if ( (p_lot_status_enabled is null) or
985: (p_serial_status_enabled is null) )then
986: INV_MATERIAL_STATUS_GRP.get_lot_serial_status_control(
987: p_organization_id =>p_organization_id
988: , p_inventory_item_id =>p_inventory_item_id
989: , x_return_status =>l_return_status
990: , x_msg_count =>l_msg_count
1018: end if;
1019: /* Bug 6918409 */
1020:
1021: if (g_debug = 1) then
1022: inv_trx_util_pub.TRACE('default org status id ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1023: end if;
1024:
1025: if (p_sub_code is not null ) and (p_object_type = 'Z' or p_object_type = 'A') then
1026: if(( p_organization_id <> nvl(g_isa_organization_id,-9999) ) or
1062: if (p_inventory_item_id is not null) then
1063: begin
1064:
1065: if (g_debug = 1) then
1066: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1067: end if;
1068: --ERES Deferred
1069: -- IF g_eres_enabled <> 'N' THEN
1070: BEGIN
1096: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999)
1097: and rownum = 1 ;
1098:
1099: if (g_debug = 1) then
1100: inv_trx_util_pub.TRACE('sub status id ' || g_isa_sub_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1101: end if;
1102:
1103: g_isa_organization_id := p_organization_id;
1104: g_isa_sub_code := p_sub_code;
1107: -- If no onhand record exists and the item is not locator/lot/serial controlled then
1108: -- we need to check whether the subinv status allows the transaction as that is going to be
1109: -- the status in MOQD except for the transfer transactions.
1110: if (g_debug = 1) then
1111: inv_trx_util_pub.TRACE('locator control '|| get_locator_control(p_organization_id, p_inventory_item_id, p_sub_code), 'INV_MATERIAL_STATUS_GRP', 14);
1112: end if;
1113:
1114: /* Bug 6918409 */
1115: if(l_lot_status_enabled = 'Y' or l_serial_controlled = 1
1121: else
1122: if (get_action_id(p_trx_type_id) in (2,3,21,28)) then -- Need to use action Id.
1123:
1124: if (g_debug = 1) then
1125: inv_trx_util_pub.TRACE('returning Y as its a transfer transaction', 'INV_MATERIAL_STATUS_GRP', 14);
1126: end if;
1127:
1128: return 'Y';
1129: else
1130: /* Bug 6918409 */
1131: l_count := 0;
1132: if (l_lot_status_enabled <> 'Y' ) then
1133: if (g_debug = 1) then
1134: inv_trx_util_pub.TRACE('lot status is not enabled', 'INV_MATERIAL_STATUS_GRP', 14);
1135: end if;
1136: /* Bug 6975416 : Modified the SQL for 10g
1137: * compliance
1138: */
1142: from mtl_onhand_quantities_detail moqd
1143: where moqd.inventory_item_id = p_inventory_item_id
1144: and moqd.organization_id = p_organization_id
1145: and moqd.subinventory_code = p_sub_code
1146: and INV_MATERIAL_STATUS_GRP.is_trx_allowed_wrap(
1147: moqd.status_id
1148: ,p_trx_type_id) = 'Y'
1149: and rownum = 1;
1150: exception
1152: l_count := 0;
1153: end;
1154:
1155: if (g_debug = 1) then
1156: inv_trx_util_pub.TRACE('sub, l_count: '||l_count, 'INV_MATERIAL_STATUS_GRP', 14);
1157: end if;
1158:
1159: if (l_count = 1 and p_object_type <> 'A') then
1160: return 'Y';
1172: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1173: g_isa_sub_status_id := inv_cache.tosub_rec.status_id;
1174: end if;
1175: if (g_debug = 1) then
1176: inv_trx_util_pub.TRACE('sub, l_count is 0, sub_status_id: '||g_isa_sub_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1177: end if;
1178: end if;
1179: end if;
1180: end if;
1186: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1187: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1188:
1189: if (g_debug = 1) then
1190: inv_trx_util_pub.TRACE('sub, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1191: end if;
1192:
1193: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1194: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1207: end if;
1208: end if;
1209: else
1210: if (g_debug = 1) then
1211: inv_trx_util_pub.TRACE('Item id is null for sub', 'INV_MATERIAL_STATUS_GRP', 14);
1212: end if;
1213:
1214: begin
1215: select count(distinct status_id)
1270: WHERE status_id = l_new_status_id ;
1271: end if;
1272: if (g_debug = 1) then
1273: inv_trx_util_pub.TRACE('sub,'||p_sub_code||' l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'
1274: ||l_new_status_id||'pending status is:'||l_new_status_code||',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1275: end if;
1276:
1277:
1278: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1274: ||l_new_status_id||'pending status is:'||l_new_status_code||',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1275: end if;
1276:
1277:
1278: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1279: p_status_id =>l_status_id
1280: ,p_transaction_type_id=> p_trx_type_id
1281: ,x_return_status => l_return_status
1282: ,x_msg_count => l_msg_count
1281: ,x_return_status => l_return_status
1282: ,x_msg_count => l_msg_count
1283: ,x_msg_data => l_msg_data);
1284: if (g_debug = 1) then
1285: inv_trx_util_pub.TRACE('sub, l return status ' || l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1286: end if;
1287:
1288: IF l_new_status_id is not null THEN
1289: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1285: inv_trx_util_pub.TRACE('sub, l return status ' || l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1286: end if;
1287:
1288: IF l_new_status_id is not null THEN
1289: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1290: p_status_id =>l_new_status_id
1291: ,p_transaction_type_id=> p_trx_type_id
1292: ,x_return_status => l_new_return_status
1293: ,x_msg_count => l_msg_count
1293: ,x_msg_count => l_msg_count
1294: ,x_msg_data => l_msg_data);
1295:
1296: if (g_debug = 1) then
1297: inv_trx_util_pub.TRACE('sub, l_new_return status ' || l_new_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1298: end if;
1299: END IF;
1300: if (p_object_type = 'Z') or (p_object_type = 'A' and
1301: (l_return_status = 'N' OR l_new_return_status = 'N')) then
1394: if (p_inventory_item_id is not null) then
1395: begin
1396:
1397: if (g_debug = 1) then
1398: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1399: end if;
1400: --ERES Deferred
1401: -- IF g_eres_enabled <> 'N' THEN
1402: BEGIN
1425: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999)
1426: and rownum = 1 ;
1427:
1428: if (g_debug = 1) then
1429: inv_trx_util_pub.TRACE('loc status id ' || g_isa_loc_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1430: end if;
1431:
1432: g_isa_organization_id := p_organization_id;
1433: g_isa_locator_id := p_locator_id;
1446: /* Bug 6918409 */
1447: l_count := 0;
1448: if (l_lot_status_enabled <> 'Y' ) then
1449: if (g_debug = 1) then
1450: inv_trx_util_pub.TRACE('loc, lot status is not enabled', 'INV_MATERIAL_STATUS_GRP', 14);
1451: end if;
1452: /* Bug 6975416 : Modified the SQL for 10g
1453: * compliance
1454: */
1458: from mtl_onhand_quantities_detail moqd
1459: where moqd.inventory_item_id = p_inventory_item_id
1460: and moqd.organization_id = p_organization_id
1461: and moqd.locator_id = p_locator_id
1462: and INV_MATERIAL_STATUS_GRP.is_trx_allowed_wrap(
1463: moqd.status_id
1464: ,p_trx_type_id) = 'Y'
1465: and rownum = 1;
1466: exception
1468: l_count := 0;
1469: end;
1470:
1471: if (g_debug = 1) then
1472: inv_trx_util_pub.TRACE('loc, l_count: '||l_count, 'INV_MATERIAL_STATUS_GRP', 14);
1473: end if;
1474:
1475: if (l_count = 1 and p_object_type <> 'A') then
1476: return 'Y';
1516: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1517: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1518:
1519: if (g_debug = 1) then
1520: inv_trx_util_pub.TRACE('Loc, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1521: end if;
1522:
1523: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1524: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1536: end if;
1537: else
1538:
1539: if (g_debug = 1) then
1540: inv_trx_util_pub.TRACE('Item id is null for loc', 'INV_MATERIAL_STATUS_GRP', 14);
1541: end if;
1542:
1543: begin
1544: select count(distinct status_id)
1596: WHERE status_id = l_new_status_id ;
1597: end if;
1598: if (g_debug = 1) then
1599: inv_trx_util_pub.TRACE('sub, l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'
1600: ||l_new_status_id||'pending status is:'||l_new_status_code||',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1601: end if;
1602:
1603: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1604: p_status_id =>l_status_id
1599: inv_trx_util_pub.TRACE('sub, l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'
1600: ||l_new_status_id||'pending status is:'||l_new_status_code||',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1601: end if;
1602:
1603: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1604: p_status_id =>l_status_id
1605: ,p_transaction_type_id=> p_trx_type_id
1606: ,x_return_status => l_return_status
1607: ,x_msg_count => l_msg_count
1607: ,x_msg_count => l_msg_count
1608: ,x_msg_data => l_msg_data);
1609:
1610: if (g_debug = 1) then
1611: inv_trx_util_pub.TRACE('loc, l return status ' || l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1612: end if;
1613: IF l_new_status_id is not null THEN
1614: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1615: p_status_id =>l_new_status_id
1610: if (g_debug = 1) then
1611: inv_trx_util_pub.TRACE('loc, l return status ' || l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1612: end if;
1613: IF l_new_status_id is not null THEN
1614: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1615: p_status_id =>l_new_status_id
1616: ,p_transaction_type_id=> p_trx_type_id
1617: ,x_return_status => l_new_return_status
1618: ,x_msg_count => l_msg_count
1618: ,x_msg_count => l_msg_count
1619: ,x_msg_data => l_msg_data);
1620:
1621: if (g_debug = 1) then
1622: inv_trx_util_pub.TRACE('sub, l_new_return status ' || l_new_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1623: end if;
1624: END IF;
1625:
1626: if (p_object_type = 'L') or (p_object_type = 'A' and
1709: else
1710: begin
1711:
1712: if (g_debug = 1 ) then
1713: inv_trx_util_pub.TRACE('Inside lot ', 'INV_MATERIAL_STATUS_GRP', 14);
1714: inv_trx_util_pub.TRACE('org ' || p_organization_id, 'INV_MATERIAL_STATUS_GRP', 14);
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1710: begin
1711:
1712: if (g_debug = 1 ) then
1713: inv_trx_util_pub.TRACE('Inside lot ', 'INV_MATERIAL_STATUS_GRP', 14);
1714: inv_trx_util_pub.TRACE('org ' || p_organization_id, 'INV_MATERIAL_STATUS_GRP', 14);
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1718: inv_trx_util_pub.TRACE('lot ' || p_lot_number, 'INV_MATERIAL_STATUS_GRP', 14);
1711:
1712: if (g_debug = 1 ) then
1713: inv_trx_util_pub.TRACE('Inside lot ', 'INV_MATERIAL_STATUS_GRP', 14);
1714: inv_trx_util_pub.TRACE('org ' || p_organization_id, 'INV_MATERIAL_STATUS_GRP', 14);
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1718: inv_trx_util_pub.TRACE('lot ' || p_lot_number, 'INV_MATERIAL_STATUS_GRP', 14);
1719: inv_trx_util_pub.TRACE('lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
1712: if (g_debug = 1 ) then
1713: inv_trx_util_pub.TRACE('Inside lot ', 'INV_MATERIAL_STATUS_GRP', 14);
1714: inv_trx_util_pub.TRACE('org ' || p_organization_id, 'INV_MATERIAL_STATUS_GRP', 14);
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1718: inv_trx_util_pub.TRACE('lot ' || p_lot_number, 'INV_MATERIAL_STATUS_GRP', 14);
1719: inv_trx_util_pub.TRACE('lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
1720: end if;
1713: inv_trx_util_pub.TRACE('Inside lot ', 'INV_MATERIAL_STATUS_GRP', 14);
1714: inv_trx_util_pub.TRACE('org ' || p_organization_id, 'INV_MATERIAL_STATUS_GRP', 14);
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1718: inv_trx_util_pub.TRACE('lot ' || p_lot_number, 'INV_MATERIAL_STATUS_GRP', 14);
1719: inv_trx_util_pub.TRACE('lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
1720: end if;
1721:
1714: inv_trx_util_pub.TRACE('org ' || p_organization_id, 'INV_MATERIAL_STATUS_GRP', 14);
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1718: inv_trx_util_pub.TRACE('lot ' || p_lot_number, 'INV_MATERIAL_STATUS_GRP', 14);
1719: inv_trx_util_pub.TRACE('lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
1720: end if;
1721:
1722: --Adding following locator id logic to support locator_id = -1
1715: inv_trx_util_pub.TRACE('item ' || p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 14);
1716: inv_trx_util_pub.TRACE('sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
1717: inv_trx_util_pub.TRACE('loc ' || p_locator_id, 'INV_MATERIAL_STATUS_GRP', 14);
1718: inv_trx_util_pub.TRACE('lot ' || p_lot_number, 'INV_MATERIAL_STATUS_GRP', 14);
1719: inv_trx_util_pub.TRACE('lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
1720: end if;
1721:
1722: --Adding following locator id logic to support locator_id = -1
1723: --which is being passed from some mobile pages for null value.
1755: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999)
1756: and rownum = 1 ;
1757:
1758: if (g_debug = 1 ) then
1759: inv_trx_util_pub.TRACE('lot status id ' || g_isa_lot_number_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1760: end if;
1761:
1762: g_isa_lot_number := p_lot_number;
1763: exception
1827: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1828: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1829:
1830: if (g_debug = 1) then
1831: inv_trx_util_pub.TRACE('lot, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1832: end if;
1833:
1834: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1835: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1862: WHERE status_id = l_new_status_id ;
1863: end if;
1864: if (g_debug = 1) then
1865: inv_trx_util_pub.TRACE('sub, l_status_id ' || l_status_id ||',status ' || l_status_code || 'pending status id is:'
1866: ||l_new_status_id||'pending status is:'||l_new_status_code||',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1867: end if;
1868:
1869:
1870: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1866: ||l_new_status_id||'pending status is:'||l_new_status_code||',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1867: end if;
1868:
1869:
1870: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1871: p_status_id =>l_status_id
1872: ,p_transaction_type_id=> p_trx_type_id
1873: ,x_return_status => l_return_status
1874: ,x_msg_count => l_msg_count
1874: ,x_msg_count => l_msg_count
1875: ,x_msg_data => l_msg_data);
1876:
1877: if (g_debug = 1) then
1878: inv_trx_util_pub.TRACE('lot, l return status ' || l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1879: end if;
1880: IF l_new_status_id is not null THEN
1881: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1882: p_status_id =>l_new_status_id
1877: if (g_debug = 1) then
1878: inv_trx_util_pub.TRACE('lot, l return status ' || l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1879: end if;
1880: IF l_new_status_id is not null THEN
1881: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1882: p_status_id =>l_new_status_id
1883: ,p_transaction_type_id=> p_trx_type_id
1884: ,x_return_status => l_new_return_status
1885: ,x_msg_count => l_msg_count
1885: ,x_msg_count => l_msg_count
1886: ,x_msg_data => l_msg_data);
1887:
1888: if (g_debug = 1) then
1889: inv_trx_util_pub.TRACE('sub, l_new_return status ' || l_new_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1890: end if;
1891: END IF;
1892:
1893:
1937:
1938: EXCEPTION
1939: WHEN NO_DATA_FOUND THEN
1940: inv_trx_util_pub.TRACE('In dynamic serial checking default serial status'
1941: || l_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1942: SELECT default_serial_status_id
1943: INTO l_status_id
1944: FROM mtl_system_items
1945: WHERE inventory_item_id = p_inventory_item_id
1969: FROM mtl_material_statuses_vl
1970: WHERE status_id = l_status_id ;
1971:
1972: if (g_debug = 1) then
1973: inv_trx_util_pub.TRACE('ser, l_status_id ' || l_status_id ||',status ' || l_status_code || ',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1974: end if;
1975:
1976: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1977: p_status_id =>l_status_id
1972: if (g_debug = 1) then
1973: inv_trx_util_pub.TRACE('ser, l_status_id ' || l_status_id ||',status ' || l_status_code || ',trx type id '||p_trx_type_id, 'INV_MATERIAL_STATUS_GRP', 14);
1974: end if;
1975:
1976: l_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1977: p_status_id =>l_status_id
1978: ,p_transaction_type_id=> p_trx_type_id
1979: ,x_return_status => l_return_status
1980: ,x_msg_count => l_msg_count
1981: ,x_msg_data => l_msg_data);
1982:
1983:
1984: IF l_new_status_id is not null THEN
1985: l_new_return_status := INV_MATERIAL_STATUS_GRP.is_trx_allowed(
1986: p_status_id =>l_new_status_id
1987: ,p_transaction_type_id=> p_trx_type_id
1988: ,x_return_status => l_new_return_status
1989: ,x_msg_count => l_msg_count
1989: ,x_msg_count => l_msg_count
1990: ,x_msg_data => l_msg_data);
1991:
1992: if (g_debug = 1) then
1993: inv_trx_util_pub.TRACE('ser, l_new_return status ' || l_new_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
1994: end if;
1995: END IF;
1996: if (p_object_type = 'S') or (p_object_type = 'A' and
1997: l_return_status = 'N') then
2208:
2209: BEGIN
2210:
2211: if (g_debug = 1) then
2212: inv_trx_util_pub.TRACE('Inside get default status ', 'INV_MATERIAL_STATUS_GRP', 14);
2213: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2214: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' action ' || p_transaction_action_id || ' src ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2215: inv_trx_util_pub.TRACE('lock id '|| p_lock_id || ' header id '||p_header_id, 'INV_MATERIAL_STATUS_GRP', 14);
2216: end if;
2209: BEGIN
2210:
2211: if (g_debug = 1) then
2212: inv_trx_util_pub.TRACE('Inside get default status ', 'INV_MATERIAL_STATUS_GRP', 14);
2213: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2214: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' action ' || p_transaction_action_id || ' src ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2215: inv_trx_util_pub.TRACE('lock id '|| p_lock_id || ' header id '||p_header_id, 'INV_MATERIAL_STATUS_GRP', 14);
2216: end if;
2217:
2210:
2211: if (g_debug = 1) then
2212: inv_trx_util_pub.TRACE('Inside get default status ', 'INV_MATERIAL_STATUS_GRP', 14);
2213: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2214: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' action ' || p_transaction_action_id || ' src ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2215: inv_trx_util_pub.TRACE('lock id '|| p_lock_id || ' header id '||p_header_id, 'INV_MATERIAL_STATUS_GRP', 14);
2216: end if;
2217:
2218: if inv_cache.set_org_rec(p_organization_id) then
2211: if (g_debug = 1) then
2212: inv_trx_util_pub.TRACE('Inside get default status ', 'INV_MATERIAL_STATUS_GRP', 14);
2213: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2214: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' action ' || p_transaction_action_id || ' src ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2215: inv_trx_util_pub.TRACE('lock id '|| p_lock_id || ' header id '||p_header_id, 'INV_MATERIAL_STATUS_GRP', 14);
2216: end if;
2217:
2218: if inv_cache.set_org_rec(p_organization_id) then
2219: l_default_org_status_id := inv_cache.org_rec.default_status_id;
2219: l_default_org_status_id := inv_cache.org_rec.default_status_id;
2220: end if;
2221:
2222: if (g_debug = 1) then
2223: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2224: end if;
2225:
2226: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2227: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
2254: AND rownum = 1;
2255: END IF ; /*LPN Status Project */
2256:
2257: if (g_debug = 1) then
2258: inv_trx_util_pub.TRACE('default status in MOQD ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2259: end if;
2260:
2261: if (l_default_status_id = -1) then
2262: if (l_serial_controlled = 0) then
2261: if (l_default_status_id = -1) then
2262: if (l_serial_controlled = 0) then
2263:
2264: if (g_debug = 1) then
2265: inv_trx_util_pub.TRACE('status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
2266: end if;
2267:
2268: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
2269: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
2278: end if;
2279: end if;
2280:
2281: if (g_debug = 1) then
2282: inv_trx_util_pub.TRACE(' 1 default status returned ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2283: end if;
2284:
2285: return l_default_status_id;
2286: end if;
2298: if (p_lock_id <> 0 and INV_TABLE_LOCK_PVT.lock_onhand_records(p_organization_id,p_inventory_item_id,null
2299: ,p_lot_number,p_sub_code,p_loc_id,1,p_header_id)
2300: ) then
2301: if (g_debug = 1) then
2302: inv_trx_util_pub.TRACE('Locked the MOQD record', 'INV_MATERIAL_STATUS_GRP', 14);
2303: end if;
2304: else
2305: if (g_debug = 1) then
2306: inv_trx_util_pub.TRACE('Unbale to lock MOQD ', 'INV_MATERIAL_STATUS_GRP', 14);
2302: inv_trx_util_pub.TRACE('Locked the MOQD record', 'INV_MATERIAL_STATUS_GRP', 14);
2303: end if;
2304: else
2305: if (g_debug = 1) then
2306: inv_trx_util_pub.TRACE('Unbale to lock MOQD ', 'INV_MATERIAL_STATUS_GRP', 14);
2307: end if;
2308: end if;
2309:
2310: -- Material Status Enhancement - Tracking bug: 13519864
2314: If (p_transaction_action_id is not null and p_transaction_action_id in (27,12,31) ) then
2315: If(m_status_id is not null) then
2316:
2317: if (g_debug = 1) then
2318: inv_trx_util_pub.TRACE('src status ex ' || m_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2319: end if;
2320: -- Calling the insert procedure to insert the status of the new onhand record into
2321: -- the table : mtl_material_status_history
2322: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2361: exception
2362: when others then
2363: if (g_debug = 1) then
2364: inv_trx_util_pub.TRACE('exception in the MTLN query',
2365: 'INV_MATERIAL_STATUS_GRP', 14);
2366: end if;
2367: end;
2368: end if;
2369: end if;
2376: l_wip_lot_return := NVL(FND_PROFILE.VALUE('INV_DEFAULT_LOT_STATUS_FOR_RETURN'),2);
2377: If(l_wip_lot_return=2) THEN
2378: If(p_txn_source_id is not null) then
2379: if (g_debug = 1) then
2380: inv_trx_util_pub.TRACE('src id ' || p_txn_source_id, 'INV_MATERIAL_STATUS_GRP', 14);
2381: end if;
2382:
2383: begin
2384:
2396: ORDER BY mmt.creation_date desc) X
2397: where rownum = 1;
2398:
2399: if (g_debug = 1) then
2400: inv_trx_util_pub.TRACE('MTLN l_default_status_id ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2401: end if;
2402:
2403:
2404: if (l_default_status_id is not null) then
2407:
2408: exception
2409: when others then
2410: if (g_debug = 1) then
2411: inv_trx_util_pub.TRACE('exception in the MTLN query', 'INV_MATERIAL_STATUS_GRP', 14);
2412: end if;
2413: end;
2414: end if;
2415: end if;
2424: If (p_transaction_action_id is not null and p_transaction_action_id in (2,3,28,50,51,52,40,42) ) then --ADDED 50,51,52 FOR LPN STATUS PROJECT
2425: If(p_src_status_id is not null) then
2426:
2427: if (g_debug = 1) then
2428: inv_trx_util_pub.TRACE('src status ex ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2429: end if;
2430: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2431: -- the table : mtl_material_status_history
2432: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2520:
2521: WHEN OTHERS THEN
2522:
2523: if (g_debug = 1) then
2524: inv_trx_util_pub.TRACE('Exception default status returned ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2525: end if;
2526:
2527: return l_default_status_id;
2528:
2549:
2550: BEGIN
2551:
2552: if (g_debug = 1) then
2553: inv_trx_util_pub.TRACE('Inside insert status history ', 'INV_MATERIAL_STATUS_GRP', 14);
2554: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2555: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' status id ' || p_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2556: inv_trx_util_pub.TRACE('lock id '|| p_lock_id, 'INV_MATERIAL_STATUS_GRP', 14);
2557: end if;
2550: BEGIN
2551:
2552: if (g_debug = 1) then
2553: inv_trx_util_pub.TRACE('Inside insert status history ', 'INV_MATERIAL_STATUS_GRP', 14);
2554: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2555: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' status id ' || p_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2556: inv_trx_util_pub.TRACE('lock id '|| p_lock_id, 'INV_MATERIAL_STATUS_GRP', 14);
2557: end if;
2558:
2551:
2552: if (g_debug = 1) then
2553: inv_trx_util_pub.TRACE('Inside insert status history ', 'INV_MATERIAL_STATUS_GRP', 14);
2554: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2555: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' status id ' || p_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2556: inv_trx_util_pub.TRACE('lock id '|| p_lock_id, 'INV_MATERIAL_STATUS_GRP', 14);
2557: end if;
2558:
2559:
2552: if (g_debug = 1) then
2553: inv_trx_util_pub.TRACE('Inside insert status history ', 'INV_MATERIAL_STATUS_GRP', 14);
2554: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2555: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' status id ' || p_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2556: inv_trx_util_pub.TRACE('lock id '|| p_lock_id, 'INV_MATERIAL_STATUS_GRP', 14);
2557: end if;
2558:
2559:
2560: if (p_lock_id <> 0) then
2574:
2575: WHEN OTHERS THEN
2576:
2577: if (g_debug = 1) then
2578: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_ret_status: '|| l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
2579: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_msg_count: '|| l_msg_count, 'INV_MATERIAL_STATUS_GRP', 14);
2580: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_msg_data: '||l_msg_data, 'INV_MATERIAL_STATUS_GRP', 14);
2581: end if;
2582:
2575: WHEN OTHERS THEN
2576:
2577: if (g_debug = 1) then
2578: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_ret_status: '|| l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
2579: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_msg_count: '|| l_msg_count, 'INV_MATERIAL_STATUS_GRP', 14);
2580: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_msg_data: '||l_msg_data, 'INV_MATERIAL_STATUS_GRP', 14);
2581: end if;
2582:
2583: END insert_status_history;
2576:
2577: if (g_debug = 1) then
2578: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_ret_status: '|| l_return_status, 'INV_MATERIAL_STATUS_GRP', 14);
2579: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_msg_count: '|| l_msg_count, 'INV_MATERIAL_STATUS_GRP', 14);
2580: inv_trx_util_pub.TRACE('Exception in insert_status_history, l_msg_data: '||l_msg_data, 'INV_MATERIAL_STATUS_GRP', 14);
2581: end if;
2582:
2583: END insert_status_history;
2584:
2598: l_serial_controlled NUMBER := 0;
2599: BEGIN
2600:
2601: if (g_debug = 1) then
2602: inv_trx_util_pub.TRACE('Inside get default status conc ', 'INV_MATERIAL_STATUS_GRP', 14);
2603: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2604: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
2605: end if;
2606:
2599: BEGIN
2600:
2601: if (g_debug = 1) then
2602: inv_trx_util_pub.TRACE('Inside get default status conc ', 'INV_MATERIAL_STATUS_GRP', 14);
2603: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2604: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
2605: end if;
2606:
2607: if inv_cache.set_org_rec(p_organization_id) then
2600:
2601: if (g_debug = 1) then
2602: inv_trx_util_pub.TRACE('Inside get default status conc ', 'INV_MATERIAL_STATUS_GRP', 14);
2603: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2604: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
2605: end if;
2606:
2607: if inv_cache.set_org_rec(p_organization_id) then
2608: l_default_org_status_id := inv_cache.org_rec.default_status_id;
2610:
2611: l_default_status_id := l_default_org_status_id;
2612:
2613: if (g_debug = 1) then
2614: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2615: end if;
2616:
2617: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2618: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
2666:
2667: end if;
2668:
2669: if (g_debug = 1) then
2670: inv_trx_util_pub.TRACE(' 1 default status returned ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2671: end if;
2672:
2673: return l_default_status_id;
2674:
2676:
2677: WHEN OTHERS THEN
2678:
2679: if (g_debug = 1) then
2680: inv_trx_util_pub.TRACE('Exception default status returned ' || l_default_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2681: end if;
2682:
2683: return l_default_status_id;
2684:
2764: l_onhand_status_id NUMBER ;
2765:
2766: BEGIN
2767: IF (g_debug = 1) then
2768: inv_trx_util_pub.TRACE('Inside get_onhand_status_id' , 'INV_MATERIAL_STATUS_GRP', 9);
2769: END IF;
2770: BEGIN
2771: SELECT NVL( status_id ,0 )
2772: INTO l_onhand_status_id
2860: --First get the value of move different status parameter.
2861: --Printing all input parameters to debug file
2862:
2863: if (g_debug = 1) then
2864: inv_trx_util_pub.TRACE('inside check_move_diff: p_org_id = ' || p_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2865: inv_trx_util_pub.TRACE('inside check_move_diff: p_inventory_item_id = '|| p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2861: --Printing all input parameters to debug file
2862:
2863: if (g_debug = 1) then
2864: inv_trx_util_pub.TRACE('inside check_move_diff: p_org_id = ' || p_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2865: inv_trx_util_pub.TRACE('inside check_move_diff: p_inventory_item_id = '|| p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2862:
2863: if (g_debug = 1) then
2864: inv_trx_util_pub.TRACE('inside check_move_diff: p_org_id = ' || p_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2865: inv_trx_util_pub.TRACE('inside check_move_diff: p_inventory_item_id = '|| p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2863: if (g_debug = 1) then
2864: inv_trx_util_pub.TRACE('inside check_move_diff: p_org_id = ' || p_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2865: inv_trx_util_pub.TRACE('inside check_move_diff: p_inventory_item_id = '|| p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2864: inv_trx_util_pub.TRACE('inside check_move_diff: p_org_id = ' || p_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2865: inv_trx_util_pub.TRACE('inside check_move_diff: p_inventory_item_id = '|| p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2865: inv_trx_util_pub.TRACE('inside check_move_diff: p_inventory_item_id = '|| p_inventory_item_id, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2866: inv_trx_util_pub.TRACE('inside check_move_diff: p_subinventory_code = ' || p_subinventory_code, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2867: inv_trx_util_pub.TRACE('inside check_move_diff: p_locator_id = '|| p_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2868: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_org_id = ' || p_transfer_org_id, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2876: inv_trx_util_pub.TRACE('inside check_move_diff: p_revision = ' || p_revision, 'INV_MATERIAL_STATUS_GRP', 9);
2869: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_subinventory = '|| p_transfer_subinventory, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2876: inv_trx_util_pub.TRACE('inside check_move_diff: p_revision = ' || p_revision, 'INV_MATERIAL_STATUS_GRP', 9);
2877: inv_trx_util_pub.TRACE('inside check_move_diff: p_primary_quantity = ' || p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
2870: inv_trx_util_pub.TRACE('inside check_move_diff: p_transfer_locator_id = ' || p_transfer_locator_id, 'INV_MATERIAL_STATUS_GRP', 9);
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2876: inv_trx_util_pub.TRACE('inside check_move_diff: p_revision = ' || p_revision, 'INV_MATERIAL_STATUS_GRP', 9);
2877: inv_trx_util_pub.TRACE('inside check_move_diff: p_primary_quantity = ' || p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
2878: end if;
2871: inv_trx_util_pub.TRACE('inside check_move_diff: p_lot_number = '|| p_lot_number, 'INV_MATERIAL_STATUS_GRP', 9);
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2876: inv_trx_util_pub.TRACE('inside check_move_diff: p_revision = ' || p_revision, 'INV_MATERIAL_STATUS_GRP', 9);
2877: inv_trx_util_pub.TRACE('inside check_move_diff: p_primary_quantity = ' || p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
2878: end if;
2879:
2872: inv_trx_util_pub.TRACE('inside check_move_diff: p_transaction_action_id = ' || p_transaction_action_id, 'INV_MATERIAL_STATUS_GRP', 9);
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2876: inv_trx_util_pub.TRACE('inside check_move_diff: p_revision = ' || p_revision, 'INV_MATERIAL_STATUS_GRP', 9);
2877: inv_trx_util_pub.TRACE('inside check_move_diff: p_primary_quantity = ' || p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
2878: end if;
2879:
2880:
2873: inv_trx_util_pub.TRACE('inside check_move_diff: p_object_type = '|| p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2874: inv_trx_util_pub.TRACE('inside check_move_diff: p_lpn_id = ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 9);
2875: inv_trx_util_pub.TRACE('inside check_move_diff: p_demand_src_header_id = '|| p_demand_src_header_id, 'INV_MATERIAL_STATUS_GRP', 9);
2876: inv_trx_util_pub.TRACE('inside check_move_diff: p_revision = ' || p_revision, 'INV_MATERIAL_STATUS_GRP', 9);
2877: inv_trx_util_pub.TRACE('inside check_move_diff: p_primary_quantity = ' || p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
2878: end if;
2879:
2880:
2881: l_org_id := p_org_id ;
2900: l_allow_different_status := NVL(inv_cache.org_rec.allow_different_status,1);
2901: END IF;
2902:
2903: if (g_debug = 1) then
2904: inv_trx_util_pub.TRACE('inside check_move_diff: l_allow_different_status = ' || l_allow_different_status, 'INV_MATERIAL_STATUS_GRP', 9);
2905: end if;
2906: --Correcting below if condition as OR clause is not needed.Transfer subinventory has to be not null irrespective of transaction action.
2907: --IF (p_transfer_subinventory IS NOT NULL OR p_transaction_action_id = 21 )
2908: IF p_transfer_subinventory IS NOT NULL
2930: END IF;
2931:
2932: if (g_debug = 1) then
2933:
2934: inv_trx_util_pub.TRACE('inside check_move_diff: object_type = ' || p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2935: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_source_status = '||l_lot_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2936: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_source = '||l_lot_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2937:
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2931:
2932: if (g_debug = 1) then
2933:
2934: inv_trx_util_pub.TRACE('inside check_move_diff: object_type = ' || p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2935: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_source_status = '||l_lot_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2936: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_source = '||l_lot_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2937:
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2932: if (g_debug = 1) then
2933:
2934: inv_trx_util_pub.TRACE('inside check_move_diff: object_type = ' || p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2935: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_source_status = '||l_lot_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2936: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_source = '||l_lot_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2937:
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2934: inv_trx_util_pub.TRACE('inside check_move_diff: object_type = ' || p_object_type, 'INV_MATERIAL_STATUS_GRP', 9);
2935: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_source_status = '||l_lot_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2936: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_source = '||l_lot_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2937:
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2941:
2942: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_destin = ' || l_lot_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2935: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_source_status = '||l_lot_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2936: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_source = '||l_lot_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2937:
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2941:
2942: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_destin = ' || l_lot_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2943: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_destin= '||l_serial_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2936: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_source = '||l_lot_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2937:
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2941:
2942: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_destin = ' || l_lot_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2943: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_destin= '||l_serial_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2944: inv_trx_util_pub.TRACE('inside check_move_diff: l_locator_control_code = '||l_locator_control_code, 'INV_MATERIAL_STATUS_GRP', 9);
2938: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_source = ' || l_serial_control_code_source, 'INV_MATERIAL_STATUS_GRP', 9);
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2941:
2942: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_destin = ' || l_lot_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2943: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_destin= '||l_serial_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2944: inv_trx_util_pub.TRACE('inside check_move_diff: l_locator_control_code = '||l_locator_control_code, 'INV_MATERIAL_STATUS_GRP', 9);
2945:
2946: end if;
2939: inv_trx_util_pub.TRACE('inside check_move_diff: l_revision_control_code_destin = '||l_revision_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2941:
2942: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_destin = ' || l_lot_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2943: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_destin= '||l_serial_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2944: inv_trx_util_pub.TRACE('inside check_move_diff: l_locator_control_code = '||l_locator_control_code, 'INV_MATERIAL_STATUS_GRP', 9);
2945:
2946: end if;
2947:
2940: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_destin_status = '||l_lot_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2941:
2942: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_control_code_destin = ' || l_lot_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2943: inv_trx_util_pub.TRACE('inside check_move_diff: l_serial_control_code_destin= '||l_serial_control_code_destin, 'INV_MATERIAL_STATUS_GRP', 9);
2944: inv_trx_util_pub.TRACE('inside check_move_diff: l_locator_control_code = '||l_locator_control_code, 'INV_MATERIAL_STATUS_GRP', 9);
2945:
2946: end if;
2947:
2948: IF (
2974: END IF;
2975: END IF;
2976:
2977: if (g_debug = 1) then
2978: inv_trx_util_pub.TRACE('inside check_move_diff: l_default_source_status = ' || l_default_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2979: inv_trx_util_pub.TRACE('inside check_move_diff: l_default_destin_status = ' ||l_default_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2980: end if;
2981:
2982: IF (l_default_source_status = 'Y' AND l_default_destin_status ='Y') THEN
2975: END IF;
2976:
2977: if (g_debug = 1) then
2978: inv_trx_util_pub.TRACE('inside check_move_diff: l_default_source_status = ' || l_default_source_status, 'INV_MATERIAL_STATUS_GRP', 9);
2979: inv_trx_util_pub.TRACE('inside check_move_diff: l_default_destin_status = ' ||l_default_destin_status, 'INV_MATERIAL_STATUS_GRP', 9);
2980: end if;
2981:
2982: IF (l_default_source_status = 'Y' AND l_default_destin_status ='Y') THEN
2983: -- AND NVL(l_allow_different_status,1) = 2) --(O,O) Third if
2986: -- If both the organizations are onhand status controlled
2987: -- then get the status from corresponding SKU's and compare.
2988:
2989: if (g_debug = 1) then
2990: inv_trx_util_pub.TRACE('Inside O=O', 'INV_MATERIAL_STATUS_GRP', 9);
2991: end if ;
2992: IF l_serial_control_code_source IN (1,6) AND l_serial_control_code_destin IN (1,6) THEN
2993: --Get onhand status id from source org.
2994:
2991: end if ;
2992: IF l_serial_control_code_source IN (1,6) AND l_serial_control_code_destin IN (1,6) THEN
2993: --Get onhand status id from source org.
2994:
2995: inv_material_status_grp.get_onhand_status_id
2996: ( p_organization_id => l_org_id
2997: , p_inventory_item_id => p_inventory_item_id
2998: , p_subinventory_code => p_subinventory_code
2999: , p_locator_id => p_locator_id
3002: , x_onhand_status_id => l_onhand_source_status_id );
3003:
3004:
3005: --Get onhand status id from destination org.
3006: inv_material_status_grp.get_onhand_status_id
3007: ( p_organization_id => l_transfer_org_id
3008: , p_inventory_item_id => p_inventory_item_id
3009: , p_subinventory_code => p_transfer_subinventory
3010: , p_locator_id => p_transfer_locator_id
3012: , p_lpn_id => p_lpn_id
3013: , x_onhand_status_id => l_onhand_destin_status_id );
3014:
3015: if (g_debug = 1) then
3016: inv_trx_util_pub.TRACE('inside check_move_diff: l_onhand_source_status_id = ' || l_onhand_source_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3017: inv_trx_util_pub.TRACE('inside check_move_diff: l_onhand_destin_status_id = '||l_onhand_destin_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3018: end if;
3019:
3020: -- Correcting nvl condition
3013: , x_onhand_status_id => l_onhand_destin_status_id );
3014:
3015: if (g_debug = 1) then
3016: inv_trx_util_pub.TRACE('inside check_move_diff: l_onhand_source_status_id = ' || l_onhand_source_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3017: inv_trx_util_pub.TRACE('inside check_move_diff: l_onhand_destin_status_id = '||l_onhand_destin_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3018: end if;
3019:
3020: -- Correcting nvl condition
3021: IF NVL(l_onhand_source_status_id , 0) = 0 --no onhand in source org
3034: --AND NVL(l_allow_different_status,1) = 2)
3035: /*Bug 7833168 :Commenting above AND clause */
3036: --(L ,0)
3037: if (g_debug = 1) then
3038: inv_trx_util_pub.TRACE('Inside L-O', 'INV_MATERIAL_STATUS_GRP', 9);
3039: end if ;
3040: -- In source org, item is lot status enabled and destination org is onhand so
3041: -- get the lot status from source org and MOQD status from destination org
3042: IF l_serial_control_code_destin IN (1,6) THEN
3051: WHEN NO_DATA_FOUND THEN
3052: l_lot_status_id := 0;
3053: END;
3054:
3055: inv_material_status_grp.get_onhand_status_id
3056: ( p_organization_id => l_transfer_org_id
3057: , p_inventory_item_id => p_inventory_item_id
3058: , p_subinventory_code => p_transfer_subinventory
3059: , p_locator_id => p_transfer_locator_id
3061: , p_lpn_id => p_lpn_id
3062: , x_onhand_status_id => l_onhand_destin_status_id );
3063:
3064: if (g_debug = 1) then
3065: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_status_id = ' || l_lot_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3066: inv_trx_util_pub.TRACE('inside check_move_diff: l_onhand_destin_status_id = '|| l_onhand_destin_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3067: end if;
3068:
3069: -- Correcting nvl condition
3062: , x_onhand_status_id => l_onhand_destin_status_id );
3063:
3064: if (g_debug = 1) then
3065: inv_trx_util_pub.TRACE('inside check_move_diff: l_lot_status_id = ' || l_lot_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3066: inv_trx_util_pub.TRACE('inside check_move_diff: l_onhand_destin_status_id = '|| l_onhand_destin_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3067: end if;
3068:
3069: -- Correcting nvl condition
3070: IF NVL(l_lot_status_id, 0) = 0 -- lot doesnt exists in source org
3081: ELSIF (l_default_source_status = 'Y' AND l_lot_destin_status = 'Y') THEN
3082: IF p_object_type = 'O' THEN
3083: --(O,L)
3084: if (g_debug = 1) then
3085: inv_trx_util_pub.TRACE('Inside O-L', 'INV_MATERIAL_STATUS_GRP', 9);
3086: end if ;
3087: -- source org is onhand status enabled and destination is lot status enabled
3088: -- Check onhand status id from source org and lot status id from destination org
3089:
3087: -- source org is onhand status enabled and destination is lot status enabled
3088: -- Check onhand status id from source org and lot status id from destination org
3089:
3090: IF l_serial_control_code_source IN (1,6) THEN
3091: inv_material_status_grp.get_onhand_status_id
3092: ( p_organization_id => l_org_id
3093: , p_inventory_item_id => p_inventory_item_id
3094: , p_subinventory_code => p_subinventory_code
3095: , p_locator_id => p_locator_id
3109: l_lot_status_id := 0;
3110: END;
3111:
3112: if (g_debug = 1) then
3113: inv_trx_util_pub.TRACE('l_onhand_source_status_id'||l_onhand_source_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3114: inv_trx_util_pub.TRACE('l_lot_status_id' || l_lot_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3115: end if ;
3116: -- Correcting nvl condition
3117: IF NVL(l_onhand_source_status_id,0)= 0
3110: END;
3111:
3112: if (g_debug = 1) then
3113: inv_trx_util_pub.TRACE('l_onhand_source_status_id'||l_onhand_source_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3114: inv_trx_util_pub.TRACE('l_lot_status_id' || l_lot_status_id, 'INV_MATERIAL_STATUS_GRP', 9);
3115: end if ;
3116: -- Correcting nvl condition
3117: IF NVL(l_onhand_source_status_id,0)= 0
3118: OR NVL(l_lot_status_id ,0) = 0
3177: RAISE fnd_api.g_exc_error;
3178: END IF;
3179:
3180: IF (g_debug = 1) then
3181: inv_trx_util_pub.TRACE('l_qoh: '||l_qoh, 'INV_MATERIAL_STATUS_GRP', 9);
3182: inv_trx_util_pub.TRACE('p_primary_quantity '|| p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
3183: END IF;
3184: /* Added for bug#7833080 Start */
3185: IF (p_transaction_action_id = 3) THEN
3178: END IF;
3179:
3180: IF (g_debug = 1) then
3181: inv_trx_util_pub.TRACE('l_qoh: '||l_qoh, 'INV_MATERIAL_STATUS_GRP', 9);
3182: inv_trx_util_pub.TRACE('p_primary_quantity '|| p_primary_quantity, 'INV_MATERIAL_STATUS_GRP', 9);
3183: END IF;
3184: /* Added for bug#7833080 Start */
3185: IF (p_transaction_action_id = 3) THEN
3186: l_qoh := l_qoh + p_primary_quantity;
3201: END IF; --IF p_object_type = 'O' THEN
3202: END IF ; --Third if
3203: IF NOT l_go THEN
3204: if (g_debug = 1) then
3205: inv_trx_util_pub.TRACE('Comingling Occurs', 'INV_MATERIAL_STATUS_GRP', 9);
3206: end if ;
3207:
3208: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');
3209: fnd_msg_pub.ADD;
3292:
3293:
3294: BEGIN
3295: if(g_debug = 1)THEN
3296: inv_trx_util_pub.TRACE('In get_lpn_status','INV_MATERIAL_STATUS_GRP',9);
3297: END if;
3298: l_lpn_org_id := p_organization_id;
3299: l_lpn_sub := p_sub_code;
3300: l_lpn_loc := p_loc_id;
3308: where lpn_id = p_lpn_id;
3309: EXCEPTION
3310: WHEN NO_DATA_FOUND THEN
3311: if(g_debug = 1)THEN
3312: inv_trx_util_pub.TRACE('Unable to find the LPN''INV_MATERIAL_STATUS_GRP',9);
3313: END IF;
3314: x_return_status_code := NULL;
3315: x_return_status_id :=NULL;
3316: RETURN;
3318: END IF;
3319: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3320: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN
3321: IF(g_debug = 1)THEN
3322: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
3323: END IF;
3324: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL
3325: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,
3326: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
3329: INTO l_def_org_status
3330: FROM mtl_parameters
3331: WHERE organization_id = l_lpn_org_id;
3332: IF(g_debug = 1)THEN
3333: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context|| ' Status should be default org level staus which is '||l_return_status_id,'INV_MATERIAL_STATUS_GRP',9);
3334: END IF;
3335: l_return_status_id := l_def_org_status; --If lpn_context is 4 or 6 lpn status should be derived from default org parameters
3336: ELSE
3337:
3336: ELSE
3337:
3338: IF (l_lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING )THEN--wlc don't exists for the lpn therefore checking mmtt
3339: IF(g_debug = 1)THEN
3340: inv_trx_util_pub.TRACE('WLC is not there and no child record is there for the lpn therefor querying mmtt for details','INV_MATERIAL_STATUS_GRP',9);
3341: END IF;
3342: FOR l_mmtt_cur IN mmtt_cur
3343: LOOP
3344: l_serial_status_enabled := 0;
3360: --item is lot controlled so need to loop through mtlt also
3361: FOR l_mtlt_cur IN mtlt_cur(l_mmtt_cur.transaction_temp_id)
3362: LOOP
3363: l_counter := l_counter + 1;
3364: l_return_status_id := INV_MATERIAL_STATUS_GRP.get_default_status --calling function to get the MOQD status
3365: (p_organization_id => p_organization_id,
3366: p_inventory_item_id => l_mmtt_cur.inventory_item_id,
3367: p_sub_code => l_mmtt_cur.subinventory_code,
3368: p_loc_id => l_mmtt_cur.locator_id,
3377: IF NVL(l_return_status_id,-99) <> NVL(l_status_id,-99) THEN --checking current status from the first status
3378: --There are mixed status so returning -1 and exiting the loop
3379: l_return_status_id := -1;
3380: IF(g_debug = 1)THEN
3381: inv_trx_util_pub.TRACE('lpn has item of mixed statuses so returning mixed at 1','INV_MATERIAL_STATUS_GRP',9);
3382: END IF;
3383: EXIT;
3384: END IF;
3385: END LOOP; --mtlt_cur loop finished
3395: IF l_return_status_id <> l_status_id THEN --checking current status from the first status
3396: --There are mixed status so returning -1 and exiting the loop
3397: l_return_status_id := -1;
3398: IF(g_debug = 1)THEN
3399: inv_trx_util_pub.TRACE('lpn has item of mixed statuses so returning mixed at 2','INV_MATERIAL_STATUS_GRP',9);
3400: END IF;
3401: EXIT;
3402: END IF;
3403: END LOOP; --l_msnt_cur loop finished
3405:
3406: ELSE
3407: l_counter := l_counter + 1;
3408: l_return_status_id :=
3409: INV_MATERIAL_STATUS_GRP.get_default_status --calling function to get the MOQD status
3410: (p_organization_id => p_organization_id,
3411: p_inventory_item_id => l_mmtt_cur.inventory_item_id,
3412: p_sub_code => l_mmtt_cur.subinventory_code,
3413: p_loc_id => l_mmtt_cur.locator_id,
3446: END IF;
3447: IF (l_serial_controlled <> 1) then
3448: l_counter := l_counter + 1;
3449: l_return_status_id :=
3450: INV_MATERIAL_STATUS_GRP.get_default_status --calling function to get the MOQD status
3451: (p_organization_id => p_organization_id,
3452: p_inventory_item_id => l_cur_wlc.inventory_item_id,
3453: p_sub_code => l_lpn_sub,
3454: p_loc_id => l_lpn_loc,
3460: l_status_id := l_return_status_id ; --assigning it for the first to check further if all the statuses are same or not
3461: END IF;
3462: IF (NVL(l_status_id,-99) <> NVL(l_return_status_id,-99)) THEN
3463: IF(g_debug = 1)THEN
3464: inv_trx_util_pub.TRACE('lpn has item of mixed statuses so returning mixed at 3','INV_MATERIAL_STATUS_GRP',9);
3465: END IF;
3466: l_return_status_id := -1;
3467: END IF;
3468: ELSE --item is serial controlled therefor checkin msn for status
3501: ELSIF (NVL(l_return_status_id,-99) = -1)THEN
3502: l_return_status_code := FND_MESSAGE.get_string('WMS','WMS_LPN_STATUS_MIXED');
3503: END IF;
3504: IF(g_debug = 1)THEN
3505: inv_trx_util_pub.TRACE('Return Status id is '||l_return_status_id||' Return staus code is '||l_return_status_code,'INV_MATERIAL_STATUS_GRP',9);
3506: END IF;
3507: x_return_status_id := l_return_status_id;
3508: x_return_status_code := l_return_status_code;
3509: END get_lpn_status;
3811: -- WHERE msnt.transaction_temp_id = l_transaction_temp_id
3812: -- AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3813: BEGIN
3814: IF(g_debug = 1)THEN
3815: inv_trx_util_pub.TRACE(c_api_name||':Entered is_status_applicable ', 'inv_material_status_grp', 9);
3816: inv_trx_util_pub.TRACE('p_wms_installed: '||p_wms_installed,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3812: -- AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3813: BEGIN
3814: IF(g_debug = 1)THEN
3815: inv_trx_util_pub.TRACE(c_api_name||':Entered is_status_applicable ', 'inv_material_status_grp', 9);
3816: inv_trx_util_pub.TRACE('p_wms_installed: '||p_wms_installed,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3813: BEGIN
3814: IF(g_debug = 1)THEN
3815: inv_trx_util_pub.TRACE(c_api_name||':Entered is_status_applicable ', 'inv_material_status_grp', 9);
3816: inv_trx_util_pub.TRACE('p_wms_installed: '||p_wms_installed,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3814: IF(g_debug = 1)THEN
3815: inv_trx_util_pub.TRACE(c_api_name||':Entered is_status_applicable ', 'inv_material_status_grp', 9);
3816: inv_trx_util_pub.TRACE('p_wms_installed: '||p_wms_installed,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3815: inv_trx_util_pub.TRACE(c_api_name||':Entered is_status_applicable ', 'inv_material_status_grp', 9);
3816: inv_trx_util_pub.TRACE('p_wms_installed: '||p_wms_installed,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3816: inv_trx_util_pub.TRACE('p_wms_installed: '||p_wms_installed,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3817: inv_trx_util_pub.TRACE('p_trx_status_enabled: '||p_trx_status_enabled,'inv_material_status_grps', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3818: inv_trx_util_pub.TRACE('p_trx_type_id: '||p_trx_type_id,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3819: inv_trx_util_pub.TRACE('p_lot_status_enabled: '||p_lot_status_enabled,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3820: inv_trx_util_pub.TRACE('p_serial_status_enabled: '||p_serial_status_enabled, 'inv_material_status_grp', 9);
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3821: inv_trx_util_pub.TRACE('p_organization_id: '||p_organization_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3822: inv_trx_util_pub.TRACE('p_inventory_item_id: '||p_inventory_item_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3823: inv_trx_util_pub.TRACE('p_sub_code: '||p_sub_code,'inv_material_status_grp', 9);
3824: inv_trx_util_pub.TRACE('p_locator_id: '||p_locator_id,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3831: inv_trx_util_pub.TRACE('p_xfer_sub_code: '||p_xfer_sub_code,'inv_material_status_grp', 9);
3825: inv_trx_util_pub.TRACE('p_lot_number: '||p_lot_number,'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3831: inv_trx_util_pub.TRACE('p_xfer_sub_code: '||p_xfer_sub_code,'inv_material_status_grp', 9);
3832: inv_trx_util_pub.TRACE('p_xfer_locator_id: '||p_xfer_locator_id,'inv_material_status_grp', 9);
3833: inv_trx_util_pub.TRACE('p_xfer_org_id: '||p_xfer_org_id, 'inv_material_status_grp', 9);
3826: inv_trx_util_pub.TRACE('p_serial_number: '||p_serial_number,'inv_material_status_grp', 9);
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3831: inv_trx_util_pub.TRACE('p_xfer_sub_code: '||p_xfer_sub_code,'inv_material_status_grp', 9);
3832: inv_trx_util_pub.TRACE('p_xfer_locator_id: '||p_xfer_locator_id,'inv_material_status_grp', 9);
3833: inv_trx_util_pub.TRACE('p_xfer_org_id: '||p_xfer_org_id, 'inv_material_status_grp', 9);
3834: END IF;
3827: inv_trx_util_pub.TRACE('p_object_type: '||p_object_type,'inv_material_status_grp', 9);
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3831: inv_trx_util_pub.TRACE('p_xfer_sub_code: '||p_xfer_sub_code,'inv_material_status_grp', 9);
3832: inv_trx_util_pub.TRACE('p_xfer_locator_id: '||p_xfer_locator_id,'inv_material_status_grp', 9);
3833: inv_trx_util_pub.TRACE('p_xfer_org_id: '||p_xfer_org_id, 'inv_material_status_grp', 9);
3834: END IF;
3835:
3828:
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3831: inv_trx_util_pub.TRACE('p_xfer_sub_code: '||p_xfer_sub_code,'inv_material_status_grp', 9);
3832: inv_trx_util_pub.TRACE('p_xfer_locator_id: '||p_xfer_locator_id,'inv_material_status_grp', 9);
3833: inv_trx_util_pub.TRACE('p_xfer_org_id: '||p_xfer_org_id, 'inv_material_status_grp', 9);
3834: END IF;
3835:
3836: BEGIN
3829: inv_trx_util_pub.TRACE('p_fromlpn_id: '||p_fromlpn_id,'inv_material_status_grp', 9);
3830: inv_trx_util_pub.TRACE('p_xfer_lpn_id: '||p_xfer_lpn_id,'inv_material_status_grp', 9);
3831: inv_trx_util_pub.TRACE('p_xfer_sub_code: '||p_xfer_sub_code,'inv_material_status_grp', 9);
3832: inv_trx_util_pub.TRACE('p_xfer_locator_id: '||p_xfer_locator_id,'inv_material_status_grp', 9);
3833: inv_trx_util_pub.TRACE('p_xfer_org_id: '||p_xfer_org_id, 'inv_material_status_grp', 9);
3834: END IF;
3835:
3836: BEGIN
3837:
3848:
3849: END;
3850:
3851: IF(g_debug = 1)THEN
3852: inv_trx_util_pub.TRACE('LPN Context: '|| l_lpn_context,'inv_material_status_grp', 9);
3853: inv_trx_util_pub.TRACE('LPN Org Id: '|| l_lpn_org_id,'inv_material_status_grp', 9);
3854: inv_trx_util_pub.TRACE('LPN Sub: '|| l_lpn_sub,'inv_material_status_grp', 9);
3855: inv_trx_util_pub.TRACE('LPN Locator: '|| l_lpn_loc,'inv_material_status_grp', 9);
3856: END IF;
3849: END;
3850:
3851: IF(g_debug = 1)THEN
3852: inv_trx_util_pub.TRACE('LPN Context: '|| l_lpn_context,'inv_material_status_grp', 9);
3853: inv_trx_util_pub.TRACE('LPN Org Id: '|| l_lpn_org_id,'inv_material_status_grp', 9);
3854: inv_trx_util_pub.TRACE('LPN Sub: '|| l_lpn_sub,'inv_material_status_grp', 9);
3855: inv_trx_util_pub.TRACE('LPN Locator: '|| l_lpn_loc,'inv_material_status_grp', 9);
3856: END IF;
3857:
3850:
3851: IF(g_debug = 1)THEN
3852: inv_trx_util_pub.TRACE('LPN Context: '|| l_lpn_context,'inv_material_status_grp', 9);
3853: inv_trx_util_pub.TRACE('LPN Org Id: '|| l_lpn_org_id,'inv_material_status_grp', 9);
3854: inv_trx_util_pub.TRACE('LPN Sub: '|| l_lpn_sub,'inv_material_status_grp', 9);
3855: inv_trx_util_pub.TRACE('LPN Locator: '|| l_lpn_loc,'inv_material_status_grp', 9);
3856: END IF;
3857:
3858: if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then
3851: IF(g_debug = 1)THEN
3852: inv_trx_util_pub.TRACE('LPN Context: '|| l_lpn_context,'inv_material_status_grp', 9);
3853: inv_trx_util_pub.TRACE('LPN Org Id: '|| l_lpn_org_id,'inv_material_status_grp', 9);
3854: inv_trx_util_pub.TRACE('LPN Sub: '|| l_lpn_sub,'inv_material_status_grp', 9);
3855: inv_trx_util_pub.TRACE('LPN Locator: '|| l_lpn_loc,'inv_material_status_grp', 9);
3856: END IF;
3857:
3858: if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then
3859:
3869: LOOP
3870: IF(g_debug = 1)THEN
3871: inv_trx_util_pub.TRACE('In loop, Checking the material status for the item: '||l_cur_wlc.inventory_item_id);
3872: END IF;
3873: l_trx_allow := inv_material_status_grp.is_status_applicable_lpns(p_wms_installed => p_wms_installed,
3874: p_trx_status_enabled =>p_trx_status_enabled,
3875: p_trx_type_id => l_trx_type_id,
3876: p_lot_status_enabled => p_lot_status_enabled,
3877: p_serial_status_enabled => p_serial_status_enabled,
3910: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or
3911: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then
3912: -- LPN is in receiving or WIP
3913: IF(g_debug = 1)THEN
3914: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);
3915: END IF;
3916:
3917: --IF p_trx_type_id IS NULL AND l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP THEN
3918: --p_trx_type_id:=43; -- WIP Component Return.
3939: IF(g_debug = 1)THEN
3940: inv_trx_util_pub.TRACE('Before calling get_default_status');
3941: END IF;
3942: l_return_status :=
3943: INV_MATERIAL_STATUS_GRP.get_default_status
3944: (p_organization_id => p_organization_id,
3945: p_inventory_item_id => l_cur_mtrl.inventory_item_id,
3946: p_sub_code => l_lpn_sub,
3947: p_loc_id => l_lpn_loc,
3951: IF(g_debug = 1)THEN
3952: inv_trx_util_pub.TRACE('Value of l_return_status: '||l_return_status);
3953: END IF;
3954:
3955: l_trx_allowed := inv_material_status_grp.is_trx_allowed(
3956: p_status_id => l_return_status
3957: ,p_transaction_type_id => l_cur_mtrl.transaction_type_id
3958: ,x_return_status => l_trx_allowed
3959: ,x_msg_count => l_msg_count
3981: FOR l_msn_cur in msn_cur(l_cur_mtrl.lpn_id , l_cur_mtrl.inventory_item_id) loop
3982: --l_counter := l_counter + 1;
3983: l_return_status := l_msn_cur.status_id;
3984:
3985: l_trx_allowed := inv_material_status_grp.is_trx_allowed(
3986: p_status_id => l_return_status
3987: ,p_transaction_type_id => l_cur_mtrl.transaction_type_id
3988: ,x_return_status => l_trx_allowed
3989: ,x_msg_count => l_msg_count
4050: IF (l_lot_controlled = 1 AND l_serial_controlled = 0) THEN
4051: -- Item is lot controlled item. We are not taking care of both lot and serial controlled items.
4052: FOR l_mtlt_cur IN mtlt_cur(l_mmtt_cur.transaction_temp_id)
4053: LOOP
4054: l_return_status := INV_MATERIAL_STATUS_GRP.get_default_status --calling function to get the MOQD status
4055: (p_organization_id => p_organization_id,
4056: p_inventory_item_id => l_mmtt_cur.inventory_item_id,
4057: p_sub_code => l_mmtt_cur.subinventory_code,
4058: p_loc_id => l_mmtt_cur.locator_id,
4068: inv_trx_util_pub.TRACE('Value of l_return_status: '||l_return_status);
4069:
4070: END IF;
4071:
4072: l_trx_allowed := inv_material_status_grp.is_trx_allowed(
4073: p_status_id => l_return_status
4074: ,p_transaction_type_id => l_mmtt_cur.transaction_type_id
4075: ,x_return_status => l_trx_allowed
4076: ,x_msg_count => l_msg_count
4121: inv_trx_util_pub.TRACE('It is serial controlled item ', 9);
4122: inv_trx_util_pub.TRACE('Querying MSN and MSNT to know the status ', 9);
4123: FOR l_msnt_cur IN msnt_cur(l_mmtt_cur.transaction_temp_id) LOOP
4124: l_return_status := l_msnt_cur.status_id;
4125: l_trx_allowed := inv_material_status_grp.is_trx_allowed(
4126: p_status_id => l_return_status
4127: ,p_transaction_type_id => l_mmtt_cur.transaction_type_id
4128: ,x_return_status => l_trx_allowed
4129: ,x_msg_count => l_msg_count
4148:
4149: ELSE
4150: -- Not lot controlled and not serial controlled item
4151: l_return_status :=
4152: INV_MATERIAL_STATUS_GRP.get_default_status --calling function to get the MOQD status
4153: (p_organization_id => p_organization_id,
4154: p_inventory_item_id => l_mmtt_cur.inventory_item_id,
4155: p_sub_code => l_mmtt_cur.subinventory_code,
4156: p_loc_id => l_mmtt_cur.locator_id,
4157: p_lot_number => NULL,
4158: p_lpn_id => l_mmtt_cur.lpn_id,
4159: p_transaction_action_id=> NULL,
4160: p_src_status_id => NULL);
4161: l_trx_allowed := inv_material_status_grp.is_trx_allowed(
4162: p_status_id => l_return_status
4163: ,p_transaction_type_id => l_mmtt_cur.transaction_type_id
4164: ,x_return_status => l_trx_allowed
4165: ,x_msg_count => l_msg_count
4298: WHEN OTHERS THEN
4299: RETURN 'Y';
4300: END sub_loc_valid_for_item;
4301:
4302: END INV_MATERIAL_STATUS_GRP;