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 916: inv_quantity_tree_pub.clear_quantity_cache;

912: RAISE FND_API.G_EXC_ERROR;
913: END;
914:
915: -- clear quantity cache before we create qty tree.
916: inv_quantity_tree_pub.clear_quantity_cache;
917:
918: -- Check if LPN has items other than the one requested
919:
920: IF (l_debug = 1) THEN

Line 990: inv_quantity_tree_pub.update_quantities

986:
987: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
988: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
989: -- in order to get correct att.
990: inv_quantity_tree_pub.update_quantities
991: ( p_api_version_number => 1.0
992: , p_init_msg_lst => fnd_api.g_false
993: , x_return_status => l_return_status
994: , x_msg_count => l_msg_cnt

Line 998: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

994: , x_msg_count => l_msg_cnt
995: , x_msg_data => l_msg_data
996: , p_organization_id => p_org_id
997: , p_inventory_item_id => p_item_id
998: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
999: , p_is_revision_control => b_is_revision_control
1000: , p_is_lot_control => TRUE
1001: , p_is_serial_control => b_is_serial_control
1002: , p_revision => nvl(p_rev, NULL)

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

1022: IF (l_debug = 1) THEN
1023: trace('lpn_match: calling update qty tree with lpn 1st time failed ');
1024: END IF;
1025: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1026: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1027: FND_MSG_PUB.ADD;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030: ELSE

Line 1031: inv_quantity_tree_pub.update_quantities

1027: FND_MSG_PUB.ADD;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030: ELSE
1031: inv_quantity_tree_pub.update_quantities
1032: ( p_api_version_number => 1.0
1033: , p_init_msg_lst => fnd_api.g_false
1034: , x_return_status => l_return_status
1035: , x_msg_count => l_msg_cnt

Line 1039: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1035: , x_msg_count => l_msg_cnt
1036: , x_msg_data => l_msg_data
1037: , p_organization_id => p_org_id
1038: , p_inventory_item_id => p_item_id
1039: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1040: , p_is_revision_control => b_is_revision_control
1041: , p_is_lot_control => TRUE
1042: , p_is_serial_control => b_is_serial_control
1043: , p_revision => nvl(p_rev, NULL)

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

1063: IF (l_debug = 1) THEN
1064: trace('lpn_match: calling update qty tree back without lpn 1st time failed ');
1065: END IF;
1066: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1067: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071:

Line 1074: inv_quantity_tree_pub.query_quantities

1070: END IF;
1071:
1072: END IF;
1073:
1074: inv_quantity_tree_pub.query_quantities
1075: ( p_api_version_number => 1.0
1076: , p_init_msg_lst => fnd_api.g_false
1077: , x_return_status => l_return_status
1078: , x_msg_count => l_msg_cnt

Line 1082: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1078: , x_msg_count => l_msg_cnt
1079: , x_msg_data => l_msg_data
1080: , p_organization_id => p_org_id
1081: , p_inventory_item_id => p_item_id
1082: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1083: , p_is_revision_control => b_is_revision_control
1084: , p_is_lot_control => TRUE
1085: , p_is_serial_control => b_is_serial_control
1086: , p_demand_source_type_id => -9999

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

1144: IF (l_debug = 1) THEN
1145: trace('lpn_match: calling qty tree 1st time failed ');
1146: END IF;
1147: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1148: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1149: FND_MSG_PUB.ADD;
1150: RAISE FND_API.G_EXC_ERROR;
1151:
1152: END IF;

Line 1157: inv_quantity_tree_pub.update_quantities

1153:
1154: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1155: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1156: -- in order to get correct att.
1157: inv_quantity_tree_pub.update_quantities
1158: ( p_api_version_number => 1.0
1159: , p_init_msg_lst => fnd_api.g_false
1160: , x_return_status => l_return_status
1161: , x_msg_count => l_msg_cnt

Line 1165: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1161: , x_msg_count => l_msg_cnt
1162: , x_msg_data => l_msg_data
1163: , p_organization_id => p_org_id
1164: , p_inventory_item_id => p_item_id
1165: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1166: , p_is_revision_control => b_is_revision_control
1167: , p_is_lot_control => TRUE
1168: , p_is_serial_control => b_is_serial_control
1169: , p_revision => nvl(p_rev, NULL)

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

1189: IF (l_debug = 1) THEN
1190: trace('lpn_match: calling update qty tree back with lpn 1st time failed ');
1191: END IF;
1192: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1193: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1194: FND_MSG_PUB.ADD;
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;
1197: ELSE

Line 1198: inv_quantity_tree_pub.update_quantities

1194: FND_MSG_PUB.ADD;
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;
1197: ELSE
1198: inv_quantity_tree_pub.update_quantities
1199: ( p_api_version_number => 1.0
1200: , p_init_msg_lst => fnd_api.g_false
1201: , x_return_status => l_return_status
1202: , x_msg_count => l_msg_cnt

Line 1206: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1202: , x_msg_count => l_msg_cnt
1203: , x_msg_data => l_msg_data
1204: , p_organization_id => p_org_id
1205: , p_inventory_item_id => p_item_id
1206: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1207: , p_is_revision_control => b_is_revision_control
1208: , p_is_lot_control => TRUE
1209: , p_is_serial_control => b_is_serial_control
1210: , p_revision => nvl(p_rev, NULL)

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

1230: IF (l_debug = 1) THEN
1231: trace('lpn_match: calling update qty tree back without lpn 1st time failed ');
1232: END IF;
1233: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1234: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1235: FND_MSG_PUB.ADD;
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238: END IF;

Line 1304: inv_quantity_tree_pub.update_quantities

1300:
1301: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1302: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1303: -- in order to get correct att.
1304: inv_quantity_tree_pub.update_quantities
1305: ( p_api_version_number => 1.0
1306: , p_init_msg_lst => fnd_api.g_false
1307: , x_return_status => l_return_status
1308: , x_msg_count => l_msg_cnt

Line 1312: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1308: , x_msg_count => l_msg_cnt
1309: , x_msg_data => l_msg_data
1310: , p_organization_id => p_org_id
1311: , p_inventory_item_id => p_item_id
1312: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1313: , p_is_revision_control => b_is_revision_control
1314: , p_is_lot_control => FALSE
1315: , p_is_serial_control => b_is_serial_control
1316: , p_revision => nvl(p_rev, NULL)

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

1336: IF (l_debug = 1) THEN
1337: trace('lpn_match: calling update qty tree with lpn 2nd time failed ');
1338: END IF;
1339: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1340: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: ELSE

Line 1345: inv_quantity_tree_pub.update_quantities

1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: ELSE
1345: inv_quantity_tree_pub.update_quantities
1346: ( p_api_version_number => 1.0
1347: , p_init_msg_lst => fnd_api.g_false
1348: , x_return_status => l_return_status
1349: , x_msg_count => l_msg_cnt

Line 1353: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1349: , x_msg_count => l_msg_cnt
1350: , x_msg_data => l_msg_data
1351: , p_organization_id => p_org_id
1352: , p_inventory_item_id => p_item_id
1353: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1354: , p_is_revision_control => b_is_revision_control
1355: , p_is_lot_control => FALSE
1356: , p_is_serial_control => b_is_serial_control
1357: , p_revision => nvl(p_rev, NULL)

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

1377: IF (l_debug = 1) THEN
1378: trace('lpn_match: calling update qty tree back without lpn 2nd time failed ');
1379: END IF;
1380: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1381: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: END IF;
1385:

Line 1388: inv_quantity_tree_pub.query_quantities

1384: END IF;
1385:
1386: END IF;
1387:
1388: inv_quantity_tree_pub.query_quantities
1389: ( p_api_version_number => 1.0
1390: , p_init_msg_lst => fnd_api.g_false
1391: , x_return_status => l_return_status
1392: , x_msg_count => l_msg_cnt

Line 1396: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1392: , x_msg_count => l_msg_cnt
1393: , x_msg_data => l_msg_data
1394: , p_organization_id => p_org_id
1395: , p_inventory_item_id => p_item_id
1396: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1397: , p_is_revision_control => b_is_revision_control
1398: , p_is_lot_control => FALSE
1399: , p_is_serial_control => b_is_serial_control
1400: , p_demand_source_type_id => -9999

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

1421: IF (l_debug = 1) THEN
1422: trace('lpn_match: calling qty tree 2nd time failed ');
1423: END IF;
1424: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1425: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1426: FND_MSG_PUB.add;
1427: RAISE FND_API.G_EXC_ERROR;
1428:
1429: END IF;

Line 1434: inv_quantity_tree_pub.update_quantities

1430:
1431: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1432: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1433: -- in order to get correct att.
1434: inv_quantity_tree_pub.update_quantities
1435: ( p_api_version_number => 1.0
1436: , p_init_msg_lst => fnd_api.g_false
1437: , x_return_status => l_return_status
1438: , x_msg_count => l_msg_cnt

Line 1442: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1438: , x_msg_count => l_msg_cnt
1439: , x_msg_data => l_msg_data
1440: , p_organization_id => p_org_id
1441: , p_inventory_item_id => p_item_id
1442: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1443: , p_is_revision_control => b_is_revision_control
1444: , p_is_lot_control => FALSE
1445: , p_is_serial_control => b_is_serial_control
1446: , p_revision => nvl(p_rev, NULL)

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

1466: IF (l_debug = 1) THEN
1467: trace('lpn_match: calling update qty tree with lpn 2nd time failed ');
1468: END IF;
1469: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1470: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1471: FND_MSG_PUB.ADD;
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;
1474: ELSE

Line 1475: inv_quantity_tree_pub.update_quantities

1471: FND_MSG_PUB.ADD;
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;
1474: ELSE
1475: inv_quantity_tree_pub.update_quantities
1476: ( p_api_version_number => 1.0
1477: , p_init_msg_lst => fnd_api.g_false
1478: , x_return_status => l_return_status
1479: , x_msg_count => l_msg_cnt

Line 1483: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1479: , x_msg_count => l_msg_cnt
1480: , x_msg_data => l_msg_data
1481: , p_organization_id => p_org_id
1482: , p_inventory_item_id => p_item_id
1483: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1484: , p_is_revision_control => b_is_revision_control
1485: , p_is_lot_control => FALSE
1486: , p_is_serial_control => b_is_serial_control
1487: , p_revision => nvl(p_rev, NULL)

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

1507: IF (l_debug = 1) THEN
1508: trace('lpn_match: calling update qty tree back without lpn 2nd time failed ');
1509: END IF;
1510: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1511: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:

Line 1626: inv_quantity_tree_pub.update_quantities

1622:
1623: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1624: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1625: -- in order to get correct att.
1626: inv_quantity_tree_pub.update_quantities
1627: ( p_api_version_number => 1.0
1628: , p_init_msg_lst => fnd_api.g_false
1629: , x_return_status => l_return_status
1630: , x_msg_count => l_msg_cnt

Line 1634: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1630: , x_msg_count => l_msg_cnt
1631: , x_msg_data => l_msg_data
1632: , p_organization_id => p_org_id
1633: , p_inventory_item_id => p_item_id
1634: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1635: , p_is_revision_control => b_is_revision_control
1636: , p_is_lot_control => TRUE
1637: , p_is_serial_control => b_is_serial_control
1638: , p_revision => nvl(p_rev, NULL)

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

1658: IF (l_debug = 1) THEN
1659: trace('lpn_match: calling update qty tree with lpn 3rd time failed ');
1660: END IF;
1661: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1662: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_ERROR;
1665: END IF;
1666: ELSE

Line 1667: inv_quantity_tree_pub.update_quantities

1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_ERROR;
1665: END IF;
1666: ELSE
1667: inv_quantity_tree_pub.update_quantities
1668: ( p_api_version_number => 1.0
1669: , p_init_msg_lst => fnd_api.g_false
1670: , x_return_status => l_return_status
1671: , x_msg_count => l_msg_cnt

Line 1675: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1671: , x_msg_count => l_msg_cnt
1672: , x_msg_data => l_msg_data
1673: , p_organization_id => p_org_id
1674: , p_inventory_item_id => p_item_id
1675: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1676: , p_is_revision_control => b_is_revision_control
1677: , p_is_lot_control => TRUE
1678: , p_is_serial_control => b_is_serial_control
1679: , p_revision => nvl(p_rev, NULL)

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

1699: IF (l_debug = 1) THEN
1700: trace('lpn_match: calling update qty tree back 3rd time without lpn 3rd time failed ');
1701: END IF;
1702: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1703: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1704: FND_MSG_PUB.ADD;
1705: RAISE FND_API.G_EXC_ERROR;
1706: END IF;
1707:

Line 1710: inv_quantity_tree_pub.query_quantities

1706: END IF;
1707:
1708: END IF;
1709:
1710: inv_quantity_tree_pub.query_quantities
1711: ( p_api_version_number => 1.0
1712: , p_init_msg_lst => fnd_api.g_false
1713: , x_return_status => l_return_status
1714: , x_msg_count => l_msg_cnt

Line 1718: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1714: , x_msg_count => l_msg_cnt
1715: , x_msg_data => l_msg_data
1716: , p_organization_id => p_org_id
1717: , p_inventory_item_id => p_item_id
1718: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1719: , p_is_revision_control => b_is_revision_control
1720: , p_is_lot_control => TRUE
1721: , p_is_serial_control => b_is_serial_control
1722: , p_demand_source_type_id => -9999

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

1795: IF (l_debug = 1) THEN
1796: trace('lpn_match: calling qty tree 3rd time failed ');
1797: END IF;
1798: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1799: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1800: FND_MSG_PUB.add;
1801: RAISE FND_API.G_EXC_ERROR;
1802:
1803: END IF;

Line 1854: inv_quantity_tree_pub.update_quantities

1850:
1851: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
1852: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
1853: -- in order to get correct att.
1854: inv_quantity_tree_pub.update_quantities
1855: ( p_api_version_number => 1.0
1856: , p_init_msg_lst => fnd_api.g_false
1857: , x_return_status => l_return_status
1858: , x_msg_count => l_msg_cnt

Line 1862: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1858: , x_msg_count => l_msg_cnt
1859: , x_msg_data => l_msg_data
1860: , p_organization_id => p_org_id
1861: , p_inventory_item_id => p_item_id
1862: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1863: , p_is_revision_control => b_is_revision_control
1864: , p_is_lot_control => TRUE
1865: , p_is_serial_control => b_is_serial_control
1866: , p_revision => nvl(p_rev, NULL)

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

1886: IF (l_debug = 1) THEN
1887: trace('lpn_match: calling update qty tree with lpn 3rd time failed ');
1888: END IF;
1889: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1890: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1891: FND_MSG_PUB.ADD;
1892: RAISE FND_API.G_EXC_ERROR;
1893: END IF;
1894: ELSE

Line 1895: inv_quantity_tree_pub.update_quantities

1891: FND_MSG_PUB.ADD;
1892: RAISE FND_API.G_EXC_ERROR;
1893: END IF;
1894: ELSE
1895: inv_quantity_tree_pub.update_quantities
1896: ( p_api_version_number => 1.0
1897: , p_init_msg_lst => fnd_api.g_false
1898: , x_return_status => l_return_status
1899: , x_msg_count => l_msg_cnt

Line 1903: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

1899: , x_msg_count => l_msg_cnt
1900: , x_msg_data => l_msg_data
1901: , p_organization_id => p_org_id
1902: , p_inventory_item_id => p_item_id
1903: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
1904: , p_is_revision_control => b_is_revision_control
1905: , p_is_lot_control => TRUE
1906: , p_is_serial_control => b_is_serial_control
1907: , p_revision => nvl(p_rev, NULL)

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

1927: IF (l_debug = 1) THEN
1928: trace('lpn_match: calling update qty tree back without lpn 3rd time failed ');
1929: END IF;
1930: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1931: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1932: FND_MSG_PUB.ADD;
1933: RAISE FND_API.G_EXC_ERROR;
1934: END IF;
1935:

Line 2041: inv_quantity_tree_pub.update_quantities

2037:
2038: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
2039: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
2040: -- in order to get correct att.
2041: inv_quantity_tree_pub.update_quantities
2042: ( p_api_version_number => 1.0
2043: , p_init_msg_lst => fnd_api.g_false
2044: , x_return_status => l_return_status
2045: , x_msg_count => l_msg_cnt

Line 2049: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2045: , x_msg_count => l_msg_cnt
2046: , x_msg_data => l_msg_data
2047: , p_organization_id => p_org_id
2048: , p_inventory_item_id => p_item_id
2049: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2050: , p_is_revision_control => b_is_revision_control
2051: , p_is_lot_control => FALSE
2052: , p_is_serial_control => b_is_serial_control
2053: , p_revision => nvl(p_rev, NULL)

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

2073: IF (l_debug = 1) THEN
2074: trace('lpn_match: calling update qty tree with lpn 4th time failed ');
2075: END IF;
2076: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2077: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: END IF;
2081: ELSE

Line 2082: inv_quantity_tree_pub.update_quantities

2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: END IF;
2081: ELSE
2082: inv_quantity_tree_pub.update_quantities
2083: ( p_api_version_number => 1.0
2084: , p_init_msg_lst => fnd_api.g_false
2085: , x_return_status => l_return_status
2086: , x_msg_count => l_msg_cnt

Line 2090: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2086: , x_msg_count => l_msg_cnt
2087: , x_msg_data => l_msg_data
2088: , p_organization_id => p_org_id
2089: , p_inventory_item_id => p_item_id
2090: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2091: , p_is_revision_control => b_is_revision_control
2092: , p_is_lot_control => FALSE
2093: , p_is_serial_control => b_is_serial_control
2094: , p_revision => nvl(p_rev, NULL)

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

2114: IF (l_debug = 1) THEN
2115: trace('lpn_match: calling update qty tree without lpn 4th time failed ');
2116: END IF;
2117: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2118: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2119: FND_MSG_PUB.ADD;
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122:

Line 2125: inv_quantity_tree_pub.query_quantities

2121: END IF;
2122:
2123: END IF;
2124:
2125: inv_quantity_tree_pub.query_quantities
2126: ( p_api_version_number => 1.0
2127: , p_init_msg_lst => fnd_api.g_false
2128: , x_return_status => l_return_status
2129: , x_msg_count => l_msg_cnt

Line 2133: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2129: , x_msg_count => l_msg_cnt
2130: , x_msg_data => l_msg_data
2131: , p_organization_id => p_org_id
2132: , p_inventory_item_id => p_item_id
2133: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2134: , p_is_revision_control => b_is_revision_control
2135: , p_is_lot_control => FALSE
2136: , p_is_serial_control => b_is_serial_control
2137: , p_demand_source_type_id => -9999

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

2194: IF (l_debug = 1) THEN
2195: trace('lpn_match: calling qty tree 4th time failed');
2196: END IF;
2197: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2198: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2199: FND_MSG_PUB.add;
2200: RAISE FND_API.G_EXC_ERROR;
2201:
2202: END IF;

Line 2207: inv_quantity_tree_pub.update_quantities

2203:
2204: IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
2205: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
2206: -- in order to get correct att.
2207: inv_quantity_tree_pub.update_quantities
2208: ( p_api_version_number => 1.0
2209: , p_init_msg_lst => fnd_api.g_false
2210: , x_return_status => l_return_status
2211: , x_msg_count => l_msg_cnt

Line 2215: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2211: , x_msg_count => l_msg_cnt
2212: , x_msg_data => l_msg_data
2213: , p_organization_id => p_org_id
2214: , p_inventory_item_id => p_item_id
2215: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2216: , p_is_revision_control => b_is_revision_control
2217: , p_is_lot_control => FALSE
2218: , p_is_serial_control => b_is_serial_control
2219: , p_revision => nvl(p_rev, NULL)

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

2239: IF (l_debug = 1) THEN
2240: trace('lpn_match: calling update qty tree back with lpn 4th time failed ');
2241: END IF;
2242: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2243: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2244: FND_MSG_PUB.ADD;
2245: RAISE FND_API.G_EXC_ERROR;
2246: END IF;
2247: ELSE

Line 2248: inv_quantity_tree_pub.update_quantities

2244: FND_MSG_PUB.ADD;
2245: RAISE FND_API.G_EXC_ERROR;
2246: END IF;
2247: ELSE
2248: inv_quantity_tree_pub.update_quantities
2249: ( p_api_version_number => 1.0
2250: , p_init_msg_lst => fnd_api.g_false
2251: , x_return_status => l_return_status
2252: , x_msg_count => l_msg_cnt

Line 2256: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2252: , x_msg_count => l_msg_cnt
2253: , x_msg_data => l_msg_data
2254: , p_organization_id => p_org_id
2255: , p_inventory_item_id => p_item_id
2256: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2257: , p_is_revision_control => b_is_revision_control
2258: , p_is_lot_control => FALSE
2259: , p_is_serial_control => b_is_serial_control
2260: , p_revision => nvl(p_rev, NULL)

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

2280: IF (l_debug = 1) THEN
2281: trace('lpn_match: calling update qty tree back without lpn 4th time failed ');
2282: END IF;
2283: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2284: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2285: FND_MSG_PUB.ADD;
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288: