eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MATERIAL_STATUS_GRP dependencies on FND_MESSAGE

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

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);
1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );

Line 1194: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);

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);
1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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

1191: end if;
1192:
1193: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1194: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

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

1192:
1193: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1194: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1200: FND_MSG_PUB.ADD;

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

1193: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1194: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1200: FND_MSG_PUB.ADD;
1201:

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

1194: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1200: FND_MSG_PUB.ADD;
1201:
1202: return 'N';

Line 1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

1195: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1200: FND_MSG_PUB.ADD;
1201:
1202: return 'N';
1203:

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

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
1302: if( l_return_status = 'N' OR l_new_return_status = 'N') then
1303: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1304: IF l_return_status = 'N' THEN
1305: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1306: ELSIF l_new_return_Status = 'N' THEN
1307: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

Line 1305: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);

1301: (l_return_status = 'N' OR l_new_return_status = 'N')) then
1302: if( l_return_status = 'N' OR l_new_return_status = 'N') then
1303: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1304: IF l_return_status = 'N' THEN
1305: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1306: ELSIF l_new_return_Status = 'N' THEN
1307: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1308: END IF;
1309: /* Changes done while fixing bug 6974630 */

Line 1307: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

1303: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1304: IF l_return_status = 'N' THEN
1305: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1306: ELSIF l_new_return_Status = 'N' THEN
1307: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1308: END IF;
1309: /* Changes done while fixing bug 6974630 */
1310: IF l_default_status_id is null THEN
1311: -- FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');

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

1307: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1308: END IF;
1309: /* Changes done while fixing bug 6974630 */
1310: IF l_default_status_id is null THEN
1311: -- FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');
1312: FND_MESSAGE.SET_TOKEN(
1313: TOKEN => 'TOKEN',
1314: VALUE => 'SUB',
1315: TRANSLATE => TRUE);

Line 1312: FND_MESSAGE.SET_TOKEN(

1308: END IF;
1309: /* Changes done while fixing bug 6974630 */
1310: IF l_default_status_id is null THEN
1311: -- FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');
1312: FND_MESSAGE.SET_TOKEN(
1313: TOKEN => 'TOKEN',
1314: VALUE => 'SUB',
1315: TRANSLATE => TRUE);
1316: FND_MESSAGE.SET_TOKEN('OBJECT',p_sub_code);

Line 1316: FND_MESSAGE.SET_TOKEN('OBJECT',p_sub_code);

1312: FND_MESSAGE.SET_TOKEN(
1313: TOKEN => 'TOKEN',
1314: VALUE => 'SUB',
1315: TRANSLATE => TRUE);
1316: FND_MESSAGE.SET_TOKEN('OBJECT',p_sub_code);
1317: ELSE
1318: FND_MESSAGE.SET_TOKEN(
1319: TOKEN => 'TOKEN',
1320: VALUE => 'OHN',

Line 1318: FND_MESSAGE.SET_TOKEN(

1314: VALUE => 'SUB',
1315: TRANSLATE => TRUE);
1316: FND_MESSAGE.SET_TOKEN('OBJECT',p_sub_code);
1317: ELSE
1318: FND_MESSAGE.SET_TOKEN(
1319: TOKEN => 'TOKEN',
1320: VALUE => 'OHN',
1321: TRANSLATE => TRUE);
1322: FND_MESSAGE.SET_TOKEN('OBJECT','');

Line 1322: FND_MESSAGE.SET_TOKEN('OBJECT','');

1318: FND_MESSAGE.SET_TOKEN(
1319: TOKEN => 'TOKEN',
1320: VALUE => 'OHN',
1321: TRANSLATE => TRUE);
1322: FND_MESSAGE.SET_TOKEN('OBJECT','');
1323: END IF;
1324: /* End Changes done while fixing bug 6974630 */
1325: FND_MSG_PUB.ADD;
1326: l_return_status := 'N';

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

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);
1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );

Line 1524: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);

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);
1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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

1521: end if;
1522:
1523: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1524: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

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

1522:
1523: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1524: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1530: FND_MSG_PUB.ADD;

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

1523: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1524: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1530: FND_MSG_PUB.ADD;
1531: return 'N';

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

1524: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1530: FND_MSG_PUB.ADD;
1531: return 'N';
1532: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then

Line 1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

1525: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1530: FND_MSG_PUB.ADD;
1531: return 'N';
1532: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then
1533: return 'Y';

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

1625:
1626: if (p_object_type = 'L') or (p_object_type = 'A' and
1627: (l_return_status = 'N' OR l_new_return_status = 'N')) then
1628: if( l_return_status = 'N' OR l_new_return_status = 'N' ) then
1629: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1630: IF l_return_status = 'N' THEN
1631: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1632: ELSIF l_new_return_Status = 'N' THEN
1633: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

Line 1631: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);

1627: (l_return_status = 'N' OR l_new_return_status = 'N')) then
1628: if( l_return_status = 'N' OR l_new_return_status = 'N' ) then
1629: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1630: IF l_return_status = 'N' THEN
1631: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1632: ELSIF l_new_return_Status = 'N' THEN
1633: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1634: END IF;
1635: /* Changes done while fixing bug 6974630 */

Line 1633: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

1629: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1630: IF l_return_status = 'N' THEN
1631: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1632: ELSIF l_new_return_Status = 'N' THEN
1633: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1634: END IF;
1635: /* Changes done while fixing bug 6974630 */
1636: IF l_default_status_id is null THEN
1637: FND_MESSAGE.SET_TOKEN(

Line 1637: FND_MESSAGE.SET_TOKEN(

1633: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1634: END IF;
1635: /* Changes done while fixing bug 6974630 */
1636: IF l_default_status_id is null THEN
1637: FND_MESSAGE.SET_TOKEN(
1638: TOKEN => 'TOKEN',
1639: VALUE => 'LOC',
1640: TRANSLATE => TRUE);
1641: ELSE

Line 1642: FND_MESSAGE.SET_TOKEN(

1638: TOKEN => 'TOKEN',
1639: VALUE => 'LOC',
1640: TRANSLATE => TRUE);
1641: ELSE
1642: FND_MESSAGE.SET_TOKEN(
1643: TOKEN => 'TOKEN',
1644: VALUE => 'OHN',
1645: TRANSLATE => TRUE);
1646: END IF;

Line 1648: FND_MESSAGE.SET_TOKEN('OBJECT','');

1644: VALUE => 'OHN',
1645: TRANSLATE => TRUE);
1646: END IF;
1647: /* End Changes done while fixing bug 6974630 */
1648: FND_MESSAGE.SET_TOKEN('OBJECT','');
1649: FND_MSG_PUB.ADD;
1650: l_return_status := 'N';
1651: end if;
1652: return(l_return_status);

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

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);
1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );

Line 1835: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);

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);
1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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

1832: end if;
1833:
1834: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1835: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

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

1833:
1834: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1835: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1841: FND_MSG_PUB.ADD;

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

1834: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
1835: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1841: FND_MSG_PUB.ADD;
1842: return 'N';

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

1835: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1841: FND_MSG_PUB.ADD;
1842: return 'N';
1843: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then

Line 1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

1836: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1841: FND_MSG_PUB.ADD;
1842: return 'N';
1843: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then
1844: return 'Y';

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

1893:
1894: if (p_object_type = 'O') or (p_object_type = 'A' and
1895: (l_return_status = 'N' OR l_new_return_status ='N')) then
1896: if( l_return_status = 'N' OR l_new_return_status = 'N') then
1897: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1898: IF l_return_status = 'N' THEN
1899: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1900: ELSIF l_new_return_Status = 'N' THEN
1901: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

Line 1899: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);

1895: (l_return_status = 'N' OR l_new_return_status ='N')) then
1896: if( l_return_status = 'N' OR l_new_return_status = 'N') then
1897: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1898: IF l_return_status = 'N' THEN
1899: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1900: ELSIF l_new_return_Status = 'N' THEN
1901: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1902: END IF;
1903:

Line 1901: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

1897: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1898: IF l_return_status = 'N' THEN
1899: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
1900: ELSIF l_new_return_Status = 'N' THEN
1901: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
1902: END IF;
1903:
1904: /* Changes done while fixing bug 6974630 */
1905: IF l_default_status_id is null THEN

Line 1906: FND_MESSAGE.SET_TOKEN(

1902: END IF;
1903:
1904: /* Changes done while fixing bug 6974630 */
1905: IF l_default_status_id is null THEN
1906: FND_MESSAGE.SET_TOKEN(
1907: TOKEN => 'TOKEN',
1908: VALUE => 'LOT',
1909: TRANSLATE => TRUE);
1910: FND_MESSAGE.SET_TOKEN('OBJECT',p_lot_number);

Line 1910: FND_MESSAGE.SET_TOKEN('OBJECT',p_lot_number);

1906: FND_MESSAGE.SET_TOKEN(
1907: TOKEN => 'TOKEN',
1908: VALUE => 'LOT',
1909: TRANSLATE => TRUE);
1910: FND_MESSAGE.SET_TOKEN('OBJECT',p_lot_number);
1911: ELSE
1912: FND_MESSAGE.SET_TOKEN(
1913: TOKEN => 'TOKEN',
1914: VALUE => 'OHN',

Line 1912: FND_MESSAGE.SET_TOKEN(

1908: VALUE => 'LOT',
1909: TRANSLATE => TRUE);
1910: FND_MESSAGE.SET_TOKEN('OBJECT',p_lot_number);
1911: ELSE
1912: FND_MESSAGE.SET_TOKEN(
1913: TOKEN => 'TOKEN',
1914: VALUE => 'OHN',
1915: TRANSLATE => TRUE);
1916: FND_MESSAGE.SET_TOKEN('OBJECT','');

Line 1916: FND_MESSAGE.SET_TOKEN('OBJECT','');

1912: FND_MESSAGE.SET_TOKEN(
1913: TOKEN => 'TOKEN',
1914: VALUE => 'OHN',
1915: TRANSLATE => TRUE);
1916: FND_MESSAGE.SET_TOKEN('OBJECT','');
1917: END IF;
1918: /* END Changes done while fixing bug 6974630 */
1919: FND_MSG_PUB.ADD;
1920: l_return_status := 'N';

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

1995: END IF;
1996: if (p_object_type = 'S') or (p_object_type = 'A' and
1997: l_return_status = 'N') then
1998: if( l_return_status = 'N' OR l_new_return_status = 'N') then
1999: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
2000: IF l_return_status = 'N' THEN
2001: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
2002: ELSIF l_new_return_Status = 'N' THEN
2003: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

Line 2001: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);

1997: l_return_status = 'N') then
1998: if( l_return_status = 'N' OR l_new_return_status = 'N') then
1999: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
2000: IF l_return_status = 'N' THEN
2001: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
2002: ELSIF l_new_return_Status = 'N' THEN
2003: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
2004: END IF;
2005: /* Changes done while fixing bug 6974630 */

Line 2003: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);

1999: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
2000: IF l_return_status = 'N' THEN
2001: FND_MESSAGE.SET_TOKEN('STATUS',l_status_code);
2002: ELSIF l_new_return_Status = 'N' THEN
2003: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
2004: END IF;
2005: /* Changes done while fixing bug 6974630 */
2006: FND_MESSAGE.SET_TOKEN(
2007: TOKEN => 'TOKEN',

Line 2006: FND_MESSAGE.SET_TOKEN(

2002: ELSIF l_new_return_Status = 'N' THEN
2003: FND_MESSAGE.SET_TOKEN('STATUS',l_new_status_code);
2004: END IF;
2005: /* Changes done while fixing bug 6974630 */
2006: FND_MESSAGE.SET_TOKEN(
2007: TOKEN => 'TOKEN',
2008: VALUE => 'SER',
2009: TRANSLATE => TRUE);
2010: /* End Changes done while fixing bug 6974630 */

Line 2011: FND_MESSAGE.SET_TOKEN('OBJECT',p_serial_number);

2007: TOKEN => 'TOKEN',
2008: VALUE => 'SER',
2009: TRANSLATE => TRUE);
2010: /* End Changes done while fixing bug 6974630 */
2011: FND_MESSAGE.SET_TOKEN('OBJECT',p_serial_number);
2012: FND_MSG_PUB.ADD;
2013: l_return_status := 'N';
2014: end if;
2015: return(l_return_status);

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

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);
2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );

Line 2269: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);

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);
2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);

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

2266: end if;
2267:
2268: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
2269: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

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

2267:
2268: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
2269: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
2275: FND_MSG_PUB.ADD;

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

2268: FND_MESSAGE.SET_NAME('INV', 'INV_NULL_MOQD_STATUS');
2269: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
2275: FND_MSG_PUB.ADD;
2276: else

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

2269: FND_MESSAGE.SET_TOKEN('ORG_ID', p_organization_id);
2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
2275: FND_MSG_PUB.ADD;
2276: else
2277: return null;

Line 2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);

2270: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_inventory_item_id);
2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
2275: FND_MSG_PUB.ADD;
2276: else
2277: return null;
2278: end if;

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

3170: , p_demand_source_name => -1
3171: );
3172:
3173: IF l_return_status <> 'S' THEN
3174: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3175: FND_MESSAGE.set_token('token1','XACT_QTY1');
3176: fnd_msg_pub.ADD;
3177: RAISE fnd_api.g_exc_error;
3178: END IF;

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

3171: );
3172:
3173: IF l_return_status <> 'S' THEN
3174: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3175: FND_MESSAGE.set_token('token1','XACT_QTY1');
3176: fnd_msg_pub.ADD;
3177: RAISE fnd_api.g_exc_error;
3178: END IF;
3179:

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

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;
3210: RAISE fnd_api.g_exc_error;
3211: END IF ;
3212: END IF ;--Second if

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

3498: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL
3499: l_return_status_code := NULL;
3500: END;
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;