1122: if (g_debug = 1) then
1123: inv_trx_util_pub.TRACE('sub, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1124: end if;
1125:
1126: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1123: inv_trx_util_pub.TRACE('sub, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1124: end if;
1125:
1126: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1124: end if;
1125:
1126: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1125:
1126: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1133: FND_MSG_PUB.ADD;
1126: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1133: FND_MSG_PUB.ADD;
1134:
1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1133: FND_MSG_PUB.ADD;
1134:
1135: return 'N';
1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1133: FND_MSG_PUB.ADD;
1134:
1135: return 'N';
1136:
1205:
1206: if (p_object_type = 'Z') or (p_object_type = 'A' and
1207: l_return_status = 'N') then
1208: if( l_return_status = 'N' ) then
1209: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1210: FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');
1211: FND_MSG_PUB.ADD;
1212: end if;
1213: return(l_return_status);
1206: if (p_object_type = 'Z') or (p_object_type = 'A' and
1207: l_return_status = 'N') then
1208: if( l_return_status = 'N' ) then
1209: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1210: FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');
1211: FND_MSG_PUB.ADD;
1212: end if;
1213: return(l_return_status);
1214: end if;
1343: if (g_debug = 1) then
1344: inv_trx_util_pub.TRACE('Loc, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1345: end if;
1346:
1347: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1344: inv_trx_util_pub.TRACE('Loc, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1345: end if;
1346:
1347: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1345: end if;
1346:
1347: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1346:
1347: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1354: FND_MSG_PUB.ADD;
1347: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1354: FND_MSG_PUB.ADD;
1355: return 'N';
1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1354: FND_MSG_PUB.ADD;
1355: return 'N';
1356: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then
1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1354: FND_MSG_PUB.ADD;
1355: return 'N';
1356: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then
1357: return 'Y';
1423:
1424: if (p_object_type = 'L') or (p_object_type = 'A' and
1425: l_return_status = 'N') then
1426: if( l_return_status = 'N' ) then
1427: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1428: FND_MESSAGE.SET_TOKEN('TOKEN', 'Locator');
1429: FND_MSG_PUB.ADD;
1430: end if;
1431: return(l_return_status);
1424: if (p_object_type = 'L') or (p_object_type = 'A' and
1425: l_return_status = 'N') then
1426: if( l_return_status = 'N' ) then
1427: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1428: FND_MESSAGE.SET_TOKEN('TOKEN', 'Locator');
1429: FND_MSG_PUB.ADD;
1430: end if;
1431: return(l_return_status);
1432: end if;
1557: if (g_debug = 1) then
1558: inv_trx_util_pub.TRACE('lot, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1559: end if;
1560:
1561: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1558: inv_trx_util_pub.TRACE('lot, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1559: end if;
1560:
1561: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1559: end if;
1560:
1561: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1560:
1561: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1568: FND_MSG_PUB.ADD;
1561: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1568: FND_MSG_PUB.ADD;
1569: return 'N';
1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1568: FND_MSG_PUB.ADD;
1569: return 'N';
1570: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then
1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1568: FND_MSG_PUB.ADD;
1569: return 'N';
1570: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then
1571: return 'Y';
1594:
1595: if (p_object_type = 'O') or (p_object_type = 'A' and
1596: l_return_status = 'N') then
1597: if( l_return_status = 'N') then
1598: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1599: FND_MESSAGE.SET_TOKEN('TOKEN', 'Lot Number');
1600: FND_MSG_PUB.ADD;
1601: end if;
1602: return(l_return_status);
1595: if (p_object_type = 'O') or (p_object_type = 'A' and
1596: l_return_status = 'N') then
1597: if( l_return_status = 'N') then
1598: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1599: FND_MESSAGE.SET_TOKEN('TOKEN', 'Lot Number');
1600: FND_MSG_PUB.ADD;
1601: end if;
1602: return(l_return_status);
1603: end if;
1620: ,x_msg_data => l_msg_data);
1621: if (p_object_type = 'S') or (p_object_type = 'A' and
1622: l_return_status = 'N') then
1623: if( l_return_status = 'N' ) then
1624: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1625: FND_MESSAGE.SET_TOKEN('TOKEN', 'Serial Number');
1626: FND_MSG_PUB.ADD;
1627: end if;
1628: return(l_return_status);
1621: if (p_object_type = 'S') or (p_object_type = 'A' and
1622: l_return_status = 'N') then
1623: if( l_return_status = 'N' ) then
1624: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1625: FND_MESSAGE.SET_TOKEN('TOKEN', 'Serial Number');
1626: FND_MSG_PUB.ADD;
1627: end if;
1628: return(l_return_status);
1629: end if;
1868: if (g_debug = 1) then
1869: inv_trx_util_pub.TRACE('status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1870: end if;
1871:
1872: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1869: inv_trx_util_pub.TRACE('status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1870: end if;
1871:
1872: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1870: end if;
1871:
1872: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1871:
1872: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1879: FND_MSG_PUB.ADD;
1872: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1879: FND_MSG_PUB.ADD;
1880: else
1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1879: FND_MSG_PUB.ADD;
1880: else
1881: return null;
1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1879: FND_MSG_PUB.ADD;
1880: else
1881: return null;
1882: end if;
2649: , p_demand_source_name => -1
2650: );
2651:
2652: IF l_return_status <> 'S' THEN
2653: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
2654: FND_MESSAGE.set_token('token1','XACT_QTY1');
2655: fnd_msg_pub.ADD;
2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2650: );
2651:
2652: IF l_return_status <> 'S' THEN
2653: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
2654: FND_MESSAGE.set_token('token1','XACT_QTY1');
2655: fnd_msg_pub.ADD;
2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2658:
2673: if (g_debug = 1) then
2674: inv_trx_util_pub.TRACE('Comingling Occurs', 'INV_MATERIAL_STATUS_GRP', 9);
2675: end if ;
2676:
2677: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');
2678: fnd_msg_pub.ADD;
2679: RAISE fnd_api.g_exc_error;
2680: END IF ;
2681: END IF ;--Second if
2967: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL
2968: l_return_status_code := NULL;
2969: END;
2970: ELSIF (NVL(l_return_status_id,-99) = -1)THEN
2971: l_return_status_code := FND_MESSAGE.get_string('WMS','WMS_LPN_STATUS_MIXED');
2972: END IF;
2973: IF(g_debug = 1)THEN
2974: 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);
2975: END IF;