DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on FND_MESSAGE

Line 1126: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');

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 );

Line 1127: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_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);

Line 1128: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);

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);

Line 1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);

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;

Line 1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );

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:

Line 1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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';

Line 1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_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';
1136:

Line 1209: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');

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);

Line 1210: FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');

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;

Line 1347: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');

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 );

Line 1348: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_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);

Line 1349: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);

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);

Line 1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);

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;

Line 1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );

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';

Line 1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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

Line 1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_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
1357: return 'Y';

Line 1427: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');

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);

Line 1428: FND_MESSAGE.SET_TOKEN('TOKEN', 'Locator');

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;

Line 1561: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');

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 );

Line 1562: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_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);

Line 1563: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);

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);

Line 1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);

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;

Line 1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );

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';

Line 1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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

Line 1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_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
1571: return 'Y';

Line 1598: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');

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);

Line 1599: FND_MESSAGE.SET_TOKEN('TOKEN', 'Lot Number');

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;

Line 1624: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');

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);

Line 1625: FND_MESSAGE.SET_TOKEN('TOKEN', 'Serial Number');

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;

Line 1872: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');

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 );

Line 1873: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_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);

Line 1874: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);

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);

Line 1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);

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;

Line 1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );

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

Line 1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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;

Line 1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_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;
1882: end if;

Line 2653: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

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;

Line 2654: FND_MESSAGE.set_token('token1','XACT_QTY1');

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:

Line 2677: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');

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

Line 2971: l_return_status_code := FND_MESSAGE.get_string('WMS','WMS_LPN_STATUS_MIXED');

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;