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.WMS_DEVICE_CONFIRMATION_PUB dependencies on INV_QUANTITY_TREE_PUB

Line 1436: inv_quantity_tree_pub.clear_quantity_cache;

1432: RAISE FND_API.G_EXC_ERROR;
1433: END;
1434:
1435: -- clear quantity cache before we create qty tree.
1436: inv_quantity_tree_pub.clear_quantity_cache;
1437:
1438: -- Check if LPN has items other than the one requested
1439:
1440: IF (l_debug = 1) THEN

Line 1510: inv_quantity_tree_pub.update_quantities

1506:
1507: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1508: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1509: -- in order to get correct att.
1510: inv_quantity_tree_pub.update_quantities
1511: ( p_api_version_number => 1.0
1512: , p_init_msg_lst => fnd_api.g_false
1513: , x_return_status => l_return_status
1514: , x_msg_count => l_msg_cnt

Line 1518: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1514: , x_msg_count => l_msg_cnt
1515: , x_msg_data => l_msg_data
1516: , p_organization_id => p_org_id
1517: , p_inventory_item_id => p_item_id
1518: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1519: , p_is_revision_control => b_is_revision_control
1520: , p_is_lot_control => TRUE
1521: , p_is_serial_control => b_is_serial_control
1522: , p_revision => nvl(p_rev, NULL)

Line 1546: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1542: IF (l_debug = 1) THEN
1543: trace('lpn_match: calling update qty tree with lpn 1st time failed ');
1544: END IF;
1545: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1546: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: ELSE

Line 1551: inv_quantity_tree_pub.update_quantities

1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: ELSE
1551: inv_quantity_tree_pub.update_quantities
1552: ( p_api_version_number => 1.0
1553: , p_init_msg_lst => fnd_api.g_false
1554: , x_return_status => l_return_status
1555: , x_msg_count => l_msg_cnt

Line 1559: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1555: , x_msg_count => l_msg_cnt
1556: , x_msg_data => l_msg_data
1557: , p_organization_id => p_org_id
1558: , p_inventory_item_id => p_item_id
1559: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1560: , p_is_revision_control => b_is_revision_control
1561: , p_is_lot_control => TRUE
1562: , p_is_serial_control => b_is_serial_control
1563: , p_revision => nvl(p_rev, NULL)

Line 1587: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1583: IF (l_debug = 1) THEN
1584: trace('lpn_match: calling update qty tree back without lpn 1st time failed ');
1585: END IF;
1586: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1587: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1588: FND_MSG_PUB.ADD;
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591:

Line 1594: inv_quantity_tree_pub.query_quantities

1590: END IF;
1591:
1592: END IF;
1593:
1594: inv_quantity_tree_pub.query_quantities
1595: ( p_api_version_number => 1.0
1596: , p_init_msg_lst => fnd_api.g_false
1597: , x_return_status => l_return_status
1598: , x_msg_count => l_msg_cnt

Line 1602: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1598: , x_msg_count => l_msg_cnt
1599: , x_msg_data => l_msg_data
1600: , p_organization_id => p_org_id
1601: , p_inventory_item_id => p_item_id
1602: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1603: , p_is_revision_control => b_is_revision_control
1604: , p_is_lot_control => TRUE
1605: , p_is_serial_control => b_is_serial_control
1606: , p_demand_source_type_id => -9999

Line 1668: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1664: IF (l_debug = 1) THEN
1665: trace('lpn_match: calling qty tree 1st time failed ');
1666: END IF;
1667: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1668: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1669: FND_MSG_PUB.ADD;
1670: RAISE FND_API.G_EXC_ERROR;
1671:
1672: END IF;

Line 1677: inv_quantity_tree_pub.update_quantities

1673:
1674: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1675: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1676: -- in order to get correct att.
1677: inv_quantity_tree_pub.update_quantities
1678: ( p_api_version_number => 1.0
1679: , p_init_msg_lst => fnd_api.g_false
1680: , x_return_status => l_return_status
1681: , x_msg_count => l_msg_cnt

Line 1685: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1681: , x_msg_count => l_msg_cnt
1682: , x_msg_data => l_msg_data
1683: , p_organization_id => p_org_id
1684: , p_inventory_item_id => p_item_id
1685: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1686: , p_is_revision_control => b_is_revision_control
1687: , p_is_lot_control => TRUE
1688: , p_is_serial_control => b_is_serial_control
1689: , p_revision => nvl(p_rev, NULL)

Line 1713: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1709: IF (l_debug = 1) THEN
1710: trace('lpn_match: calling update qty tree back with lpn 1st time failed ');
1711: END IF;
1712: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1713: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1714: FND_MSG_PUB.ADD;
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: ELSE

Line 1718: inv_quantity_tree_pub.update_quantities

1714: FND_MSG_PUB.ADD;
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: ELSE
1718: inv_quantity_tree_pub.update_quantities
1719: ( p_api_version_number => 1.0
1720: , p_init_msg_lst => fnd_api.g_false
1721: , x_return_status => l_return_status
1722: , x_msg_count => l_msg_cnt

Line 1726: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1722: , x_msg_count => l_msg_cnt
1723: , x_msg_data => l_msg_data
1724: , p_organization_id => p_org_id
1725: , p_inventory_item_id => p_item_id
1726: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1727: , p_is_revision_control => b_is_revision_control
1728: , p_is_lot_control => TRUE
1729: , p_is_serial_control => b_is_serial_control
1730: , p_revision => nvl(p_rev, NULL)

Line 1754: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1750: IF (l_debug = 1) THEN
1751: trace('lpn_match: calling update qty tree back without lpn 1st time failed ');
1752: END IF;
1753: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1754: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1755: FND_MSG_PUB.ADD;
1756: RAISE FND_API.G_EXC_ERROR;
1757: END IF;
1758: END IF;

Line 1824: inv_quantity_tree_pub.update_quantities

1820:
1821: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1822: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1823: -- in order to get correct att.
1824: inv_quantity_tree_pub.update_quantities
1825: ( p_api_version_number => 1.0
1826: , p_init_msg_lst => fnd_api.g_false
1827: , x_return_status => l_return_status
1828: , x_msg_count => l_msg_cnt

Line 1832: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1828: , x_msg_count => l_msg_cnt
1829: , x_msg_data => l_msg_data
1830: , p_organization_id => p_org_id
1831: , p_inventory_item_id => p_item_id
1832: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1833: , p_is_revision_control => b_is_revision_control
1834: , p_is_lot_control => FALSE
1835: , p_is_serial_control => b_is_serial_control
1836: , p_revision => nvl(p_rev, NULL)

Line 1860: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1856: IF (l_debug = 1) THEN
1857: trace('lpn_match: calling update qty tree with lpn 2nd time failed ');
1858: END IF;
1859: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1860: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: ELSE

Line 1865: inv_quantity_tree_pub.update_quantities

1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: ELSE
1865: inv_quantity_tree_pub.update_quantities
1866: ( p_api_version_number => 1.0
1867: , p_init_msg_lst => fnd_api.g_false
1868: , x_return_status => l_return_status
1869: , x_msg_count => l_msg_cnt

Line 1873: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1869: , x_msg_count => l_msg_cnt
1870: , x_msg_data => l_msg_data
1871: , p_organization_id => p_org_id
1872: , p_inventory_item_id => p_item_id
1873: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1874: , p_is_revision_control => b_is_revision_control
1875: , p_is_lot_control => FALSE
1876: , p_is_serial_control => b_is_serial_control
1877: , p_revision => nvl(p_rev, NULL)

Line 1901: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1897: IF (l_debug = 1) THEN
1898: trace('lpn_match: calling update qty tree back without lpn 2nd time failed ');
1899: END IF;
1900: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1901: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1902: FND_MSG_PUB.ADD;
1903: RAISE FND_API.G_EXC_ERROR;
1904: END IF;
1905:

Line 1908: inv_quantity_tree_pub.query_quantities

1904: END IF;
1905:
1906: END IF;
1907:
1908: inv_quantity_tree_pub.query_quantities
1909: ( p_api_version_number => 1.0
1910: , p_init_msg_lst => fnd_api.g_false
1911: , x_return_status => l_return_status
1912: , x_msg_count => l_msg_cnt

Line 1916: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1912: , x_msg_count => l_msg_cnt
1913: , x_msg_data => l_msg_data
1914: , p_organization_id => p_org_id
1915: , p_inventory_item_id => p_item_id
1916: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1917: , p_is_revision_control => b_is_revision_control
1918: , p_is_lot_control => FALSE
1919: , p_is_serial_control => b_is_serial_control
1920: , p_demand_source_type_id => -9999

Line 1945: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1941: IF (l_debug = 1) THEN
1942: trace('lpn_match: calling qty tree 2nd time failed ');
1943: END IF;
1944: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1945: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1946: FND_MSG_PUB.add;
1947: RAISE FND_API.G_EXC_ERROR;
1948:
1949: END IF;

Line 1954: inv_quantity_tree_pub.update_quantities

1950:
1951: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1952: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1953: -- in order to get correct att.
1954: inv_quantity_tree_pub.update_quantities
1955: ( p_api_version_number => 1.0
1956: , p_init_msg_lst => fnd_api.g_false
1957: , x_return_status => l_return_status
1958: , x_msg_count => l_msg_cnt

Line 1962: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1958: , x_msg_count => l_msg_cnt
1959: , x_msg_data => l_msg_data
1960: , p_organization_id => p_org_id
1961: , p_inventory_item_id => p_item_id
1962: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1963: , p_is_revision_control => b_is_revision_control
1964: , p_is_lot_control => FALSE
1965: , p_is_serial_control => b_is_serial_control
1966: , p_revision => nvl(p_rev, NULL)

Line 1990: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

1986: IF (l_debug = 1) THEN
1987: trace('lpn_match: calling update qty tree with lpn 2nd time failed ');
1988: END IF;
1989: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1990: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1991: FND_MSG_PUB.ADD;
1992: RAISE FND_API.G_EXC_ERROR;
1993: END IF;
1994: ELSE

Line 1995: inv_quantity_tree_pub.update_quantities

1991: FND_MSG_PUB.ADD;
1992: RAISE FND_API.G_EXC_ERROR;
1993: END IF;
1994: ELSE
1995: inv_quantity_tree_pub.update_quantities
1996: ( p_api_version_number => 1.0
1997: , p_init_msg_lst => fnd_api.g_false
1998: , x_return_status => l_return_status
1999: , x_msg_count => l_msg_cnt

Line 2003: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1999: , x_msg_count => l_msg_cnt
2000: , x_msg_data => l_msg_data
2001: , p_organization_id => p_org_id
2002: , p_inventory_item_id => p_item_id
2003: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2004: , p_is_revision_control => b_is_revision_control
2005: , p_is_lot_control => FALSE
2006: , p_is_serial_control => b_is_serial_control
2007: , p_revision => nvl(p_rev, NULL)

Line 2031: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2027: IF (l_debug = 1) THEN
2028: trace('lpn_match: calling update qty tree back without lpn 2nd time failed ');
2029: END IF;
2030: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2031: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2032: FND_MSG_PUB.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035:

Line 2146: inv_quantity_tree_pub.update_quantities

2142:
2143: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
2144: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
2145: -- in order to get correct att.
2146: inv_quantity_tree_pub.update_quantities
2147: ( p_api_version_number => 1.0
2148: , p_init_msg_lst => fnd_api.g_false
2149: , x_return_status => l_return_status
2150: , x_msg_count => l_msg_cnt

Line 2154: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2150: , x_msg_count => l_msg_cnt
2151: , x_msg_data => l_msg_data
2152: , p_organization_id => p_org_id
2153: , p_inventory_item_id => p_item_id
2154: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2155: , p_is_revision_control => b_is_revision_control
2156: , p_is_lot_control => TRUE
2157: , p_is_serial_control => b_is_serial_control
2158: , p_revision => nvl(p_rev, NULL)

Line 2182: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2178: IF (l_debug = 1) THEN
2179: trace('lpn_match: calling update qty tree with lpn 3rd time failed ');
2180: END IF;
2181: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2182: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2183: FND_MSG_PUB.ADD;
2184: RAISE FND_API.G_EXC_ERROR;
2185: END IF;
2186: ELSE

Line 2187: inv_quantity_tree_pub.update_quantities

2183: FND_MSG_PUB.ADD;
2184: RAISE FND_API.G_EXC_ERROR;
2185: END IF;
2186: ELSE
2187: inv_quantity_tree_pub.update_quantities
2188: ( p_api_version_number => 1.0
2189: , p_init_msg_lst => fnd_api.g_false
2190: , x_return_status => l_return_status
2191: , x_msg_count => l_msg_cnt

Line 2195: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2191: , x_msg_count => l_msg_cnt
2192: , x_msg_data => l_msg_data
2193: , p_organization_id => p_org_id
2194: , p_inventory_item_id => p_item_id
2195: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2196: , p_is_revision_control => b_is_revision_control
2197: , p_is_lot_control => TRUE
2198: , p_is_serial_control => b_is_serial_control
2199: , p_revision => nvl(p_rev, NULL)

Line 2223: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2219: IF (l_debug = 1) THEN
2220: trace('lpn_match: calling update qty tree back 3rd time without lpn 3rd time failed ');
2221: END IF;
2222: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2223: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2224: FND_MSG_PUB.ADD;
2225: RAISE FND_API.G_EXC_ERROR;
2226: END IF;
2227:

Line 2230: inv_quantity_tree_pub.query_quantities

2226: END IF;
2227:
2228: END IF;
2229:
2230: inv_quantity_tree_pub.query_quantities
2231: ( p_api_version_number => 1.0
2232: , p_init_msg_lst => fnd_api.g_false
2233: , x_return_status => l_return_status
2234: , x_msg_count => l_msg_cnt

Line 2238: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2234: , x_msg_count => l_msg_cnt
2235: , x_msg_data => l_msg_data
2236: , p_organization_id => p_org_id
2237: , p_inventory_item_id => p_item_id
2238: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2239: , p_is_revision_control => b_is_revision_control
2240: , p_is_lot_control => TRUE
2241: , p_is_serial_control => b_is_serial_control
2242: , p_demand_source_type_id => -9999

Line 2319: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2315: IF (l_debug = 1) THEN
2316: trace('lpn_match: calling qty tree 3rd time failed ');
2317: END IF;
2318: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2319: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2320: FND_MSG_PUB.add;
2321: RAISE FND_API.G_EXC_ERROR;
2322:
2323: END IF;

Line 2374: inv_quantity_tree_pub.update_quantities

2370:
2371: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
2372: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
2373: -- in order to get correct att.
2374: inv_quantity_tree_pub.update_quantities
2375: ( p_api_version_number => 1.0
2376: , p_init_msg_lst => fnd_api.g_false
2377: , x_return_status => l_return_status
2378: , x_msg_count => l_msg_cnt

Line 2382: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2378: , x_msg_count => l_msg_cnt
2379: , x_msg_data => l_msg_data
2380: , p_organization_id => p_org_id
2381: , p_inventory_item_id => p_item_id
2382: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2383: , p_is_revision_control => b_is_revision_control
2384: , p_is_lot_control => TRUE
2385: , p_is_serial_control => b_is_serial_control
2386: , p_revision => nvl(p_rev, NULL)

Line 2410: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2406: IF (l_debug = 1) THEN
2407: trace('lpn_match: calling update qty tree with lpn 3rd time failed ');
2408: END IF;
2409: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2410: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2411: FND_MSG_PUB.ADD;
2412: RAISE FND_API.G_EXC_ERROR;
2413: END IF;
2414: ELSE

Line 2415: inv_quantity_tree_pub.update_quantities

2411: FND_MSG_PUB.ADD;
2412: RAISE FND_API.G_EXC_ERROR;
2413: END IF;
2414: ELSE
2415: inv_quantity_tree_pub.update_quantities
2416: ( p_api_version_number => 1.0
2417: , p_init_msg_lst => fnd_api.g_false
2418: , x_return_status => l_return_status
2419: , x_msg_count => l_msg_cnt

Line 2423: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2419: , x_msg_count => l_msg_cnt
2420: , x_msg_data => l_msg_data
2421: , p_organization_id => p_org_id
2422: , p_inventory_item_id => p_item_id
2423: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2424: , p_is_revision_control => b_is_revision_control
2425: , p_is_lot_control => TRUE
2426: , p_is_serial_control => b_is_serial_control
2427: , p_revision => nvl(p_rev, NULL)

Line 2451: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2447: IF (l_debug = 1) THEN
2448: trace('lpn_match: calling update qty tree back without lpn 3rd time failed ');
2449: END IF;
2450: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2451: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2452: FND_MSG_PUB.ADD;
2453: RAISE FND_API.G_EXC_ERROR;
2454: END IF;
2455:

Line 2561: inv_quantity_tree_pub.update_quantities

2557:
2558: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
2559: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
2560: -- in order to get correct att.
2561: inv_quantity_tree_pub.update_quantities
2562: ( p_api_version_number => 1.0
2563: , p_init_msg_lst => fnd_api.g_false
2564: , x_return_status => l_return_status
2565: , x_msg_count => l_msg_cnt

Line 2569: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2565: , x_msg_count => l_msg_cnt
2566: , x_msg_data => l_msg_data
2567: , p_organization_id => p_org_id
2568: , p_inventory_item_id => p_item_id
2569: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2570: , p_is_revision_control => b_is_revision_control
2571: , p_is_lot_control => FALSE
2572: , p_is_serial_control => b_is_serial_control
2573: , p_revision => nvl(p_rev, NULL)

Line 2597: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2593: IF (l_debug = 1) THEN
2594: trace('lpn_match: calling update qty tree with lpn 4th time failed ');
2595: END IF;
2596: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2597: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2598: FND_MSG_PUB.ADD;
2599: RAISE FND_API.G_EXC_ERROR;
2600: END IF;
2601: ELSE

Line 2602: inv_quantity_tree_pub.update_quantities

2598: FND_MSG_PUB.ADD;
2599: RAISE FND_API.G_EXC_ERROR;
2600: END IF;
2601: ELSE
2602: inv_quantity_tree_pub.update_quantities
2603: ( p_api_version_number => 1.0
2604: , p_init_msg_lst => fnd_api.g_false
2605: , x_return_status => l_return_status
2606: , x_msg_count => l_msg_cnt

Line 2610: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2606: , x_msg_count => l_msg_cnt
2607: , x_msg_data => l_msg_data
2608: , p_organization_id => p_org_id
2609: , p_inventory_item_id => p_item_id
2610: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2611: , p_is_revision_control => b_is_revision_control
2612: , p_is_lot_control => FALSE
2613: , p_is_serial_control => b_is_serial_control
2614: , p_revision => nvl(p_rev, NULL)

Line 2638: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2634: IF (l_debug = 1) THEN
2635: trace('lpn_match: calling update qty tree without lpn 4th time failed ');
2636: END IF;
2637: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2638: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2639: FND_MSG_PUB.ADD;
2640: RAISE FND_API.G_EXC_ERROR;
2641: END IF;
2642:

Line 2645: inv_quantity_tree_pub.query_quantities

2641: END IF;
2642:
2643: END IF;
2644:
2645: inv_quantity_tree_pub.query_quantities
2646: ( p_api_version_number => 1.0
2647: , p_init_msg_lst => fnd_api.g_false
2648: , x_return_status => l_return_status
2649: , x_msg_count => l_msg_cnt

Line 2653: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2649: , x_msg_count => l_msg_cnt
2650: , x_msg_data => l_msg_data
2651: , p_organization_id => p_org_id
2652: , p_inventory_item_id => p_item_id
2653: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2654: , p_is_revision_control => b_is_revision_control
2655: , p_is_lot_control => FALSE
2656: , p_is_serial_control => b_is_serial_control
2657: , p_demand_source_type_id => -9999

Line 2718: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2714: IF (l_debug = 1) THEN
2715: trace('lpn_match: calling qty tree 4th time failed');
2716: END IF;
2717: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2718: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2719: FND_MSG_PUB.add;
2720: RAISE FND_API.G_EXC_ERROR;
2721:
2722: END IF;

Line 2727: inv_quantity_tree_pub.update_quantities

2723:
2724: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
2725: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
2726: -- in order to get correct att.
2727: inv_quantity_tree_pub.update_quantities
2728: ( p_api_version_number => 1.0
2729: , p_init_msg_lst => fnd_api.g_false
2730: , x_return_status => l_return_status
2731: , x_msg_count => l_msg_cnt

Line 2735: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2731: , x_msg_count => l_msg_cnt
2732: , x_msg_data => l_msg_data
2733: , p_organization_id => p_org_id
2734: , p_inventory_item_id => p_item_id
2735: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2736: , p_is_revision_control => b_is_revision_control
2737: , p_is_lot_control => FALSE
2738: , p_is_serial_control => b_is_serial_control
2739: , p_revision => nvl(p_rev, NULL)

Line 2763: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2759: IF (l_debug = 1) THEN
2760: trace('lpn_match: calling update qty tree back with lpn 4th time failed ');
2761: END IF;
2762: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2763: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2764: FND_MSG_PUB.ADD;
2765: RAISE FND_API.G_EXC_ERROR;
2766: END IF;
2767: ELSE

Line 2768: inv_quantity_tree_pub.update_quantities

2764: FND_MSG_PUB.ADD;
2765: RAISE FND_API.G_EXC_ERROR;
2766: END IF;
2767: ELSE
2768: inv_quantity_tree_pub.update_quantities
2769: ( p_api_version_number => 1.0
2770: , p_init_msg_lst => fnd_api.g_false
2771: , x_return_status => l_return_status
2772: , x_msg_count => l_msg_cnt

Line 2776: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2772: , x_msg_count => l_msg_cnt
2773: , x_msg_data => l_msg_data
2774: , p_organization_id => p_org_id
2775: , p_inventory_item_id => p_item_id
2776: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2777: , p_is_revision_control => b_is_revision_control
2778: , p_is_lot_control => FALSE
2779: , p_is_serial_control => b_is_serial_control
2780: , p_revision => nvl(p_rev, NULL)

Line 2804: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2800: IF (l_debug = 1) THEN
2801: trace('lpn_match: calling update qty tree back without lpn 4th time failed ');
2802: END IF;
2803: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2804: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2805: FND_MSG_PUB.ADD;
2806: RAISE FND_API.G_EXC_ERROR;
2807: END IF;
2808: