DBA Data[Home] [Help]

APPS.INV_LOT_API_PUB dependencies on INV_QUANTITY_TREE_PUB

Line 8495: we will call INV_QUANTITY_TREE_PUB to query quantities */

8491: it is possible to generate a transation for this lot.
8492: ========================================*/
8493: /* Jalaj Srivastava Bug 4634410
8494: commenting code below.
8495: we will call INV_QUANTITY_TREE_PUB to query quantities */
8496: /*
8497: print_debug('Calling INV_QUANTITY_TREE_GRP.CREATE_TREE api');
8498: INV_QUANTITY_TREE_GRP.CREATE_TREE
8499: ( p_api_version_number => p_api_version

Line 8527: print_debug('Calling INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES api');

8523: print_debug('Returning error from INV_QUANTITY_TREE_GRP.CREATE_TREE');
8524: RAISE CREATE_TREE_ERROR;
8525: END IF;
8526: */
8527: print_debug('Calling INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES api');
8528: INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES
8529: ( p_api_version_number => p_api_version
8530: , p_init_msg_lst => p_init_msg_list
8531: , x_return_status => l_return_status

Line 8528: INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES

8524: RAISE CREATE_TREE_ERROR;
8525: END IF;
8526: */
8527: print_debug('Calling INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES api');
8528: INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES
8529: ( p_api_version_number => p_api_version
8530: , p_init_msg_lst => p_init_msg_list
8531: , x_return_status => l_return_status
8532: , x_msg_count => l_msg_count

Line 8559: print_debug('Return Status INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES api'||l_return_status);

8555: , x_satt => l_satt
8556: , x_satr => l_satr
8557: );
8558:
8559: print_debug('Return Status INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES api'||l_return_status);
8560: print_debug(' onhand='||l_qoh||' l_atr --> '||l_atr);
8561: --Returning quantity to calling procedure
8562: x_primary_quantity := l_qoh;
8563:

Line 8567: print_debug('Returning error from INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8563:
8564: -- NSRIVAST, using <> as per GSCC compliance
8565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
8566: THEN
8567: print_debug('Returning error from INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8568: RAISE QUERY_TREE_ERROR;
8569: END IF;
8570:
8571: ELSE

Line 8643: INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES

8639: -- No inventory for sub/loct/lot, then, need to search somewhere-else :
8640: -- Going to see whether, for that lot the qty is the same at node=lot
8641: print_debug('within case 2 prim_qty='||p_primary_quantity||', atr='||l_atr);
8642:
8643: INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES
8644: ( p_api_version_number => p_api_version
8645: , p_init_msg_lst => p_init_msg_list
8646: , x_return_status => l_return_status
8647: , x_msg_count => l_msg_count