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_DIRECT_SHIP_PVT dependencies on INV_QUANTITY_TREE_PUB

Line 6750: inv_quantity_tree_pub.clear_quantity_cache;

6746: DEBUG('The value of p_line_id is ' || p_line_id, 'GET_LPN_AVAILABLE_QUANTITY');
6747: DEBUG('The value of p_header_id is ' || p_header_id, 'GET_LPN_AVAILABLE_QUANTITY');
6748: END IF;
6749:
6750: inv_quantity_tree_pub.clear_quantity_cache;
6751:
6752: SELECT revision_qty_control_code
6753: , lot_control_code
6754: , serial_number_control_code

Line 6794: inv_quantity_tree_pub.clear_quantity_cache;

6790: LOOP
6791: FETCH inner_lpn INTO l_inner_lpn;
6792: EXIT WHEN inner_lpn%NOTFOUND;
6793: /* Bug 2440408: All the Trees in the cache have to be cleared so that trees are rebuild */
6794: inv_quantity_tree_pub.clear_quantity_cache;
6795: inv_quantity_tree_pub.query_quantities(
6796: p_api_version_number => 1.0
6797: , p_init_msg_lst => fnd_api.g_false
6798: , x_return_status => x_return_status

Line 6795: inv_quantity_tree_pub.query_quantities(

6791: FETCH inner_lpn INTO l_inner_lpn;
6792: EXIT WHEN inner_lpn%NOTFOUND;
6793: /* Bug 2440408: All the Trees in the cache have to be cleared so that trees are rebuild */
6794: inv_quantity_tree_pub.clear_quantity_cache;
6795: inv_quantity_tree_pub.query_quantities(
6796: p_api_version_number => 1.0
6797: , p_init_msg_lst => fnd_api.g_false
6798: , x_return_status => x_return_status
6799: , x_msg_count => x_msg_count

Line 6803: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

6799: , x_msg_count => x_msg_count
6800: , x_msg_data => x_msg_data
6801: , p_organization_id => p_organization_id
6802: , p_inventory_item_id => p_inventory_item_id
6803: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
6804: , p_is_revision_control => l_is_revision_control
6805: , p_is_lot_control => l_is_lot_control
6806: , p_is_serial_control => l_is_serial_control
6807: , p_demand_source_type_id => l_demand_source_type_id

Line 9566: inv_quantity_tree_pub.clear_quantity_cache;

9562: OR l_resv_rec.lot_number IS NULL)
9563: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, p_end_item_unit_number)
9564: ) THEN
9565: -- clear quantity tree cache
9566: inv_quantity_tree_pub.clear_quantity_cache;
9567:
9568: -- query quantity tree
9569: IF (l_debug = 1) THEN
9570: DEBUG('Before query quantity tree ', 'Process_Line');

Line 9580: inv_quantity_tree_pub.query_quantities(

9576: DEBUG('l_lpn_cont_rec.locator_id =' || l_lpn_cont_rec.locator_id, 'Process_Line');
9577: DEBUG('l_lpn_cont_rec.lpn_id=' || l_lpn_cont_rec.lpn_id, 'Process_Line');
9578: END IF;
9579:
9580: inv_quantity_tree_pub.query_quantities(
9581: x_return_status => l_return_status
9582: , x_msg_count => l_msg_count
9583: , x_msg_data => l_msg_data
9584: , x_qoh => l_qoh

Line 9594: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode --inv_quantity_tree_pub.g_reservation_mode Changed bug 4128854

9590: , p_api_version_number => 1.0
9591: , p_init_msg_lst => fnd_api.g_false
9592: , p_organization_id => p_org_id
9593: , p_inventory_item_id => p_inventory_item_id
9594: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode --inv_quantity_tree_pub.g_reservation_mode Changed bug 4128854
9595: , p_is_revision_control => l_lpn_cont_rec.revision_control
9596: , p_is_lot_control => l_lpn_cont_rec.lot_control
9597: , p_is_serial_control => l_lpn_cont_rec.serial_control
9598: , p_demand_source_type_id => l_demand_source_type_id

Line 9611: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of '

9607:
9608: IF l_return_status = fnd_api.g_ret_sts_error THEN
9609: IF (l_debug = 1) THEN
9610: DEBUG(
9611: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of '
9612: || p_order_header_id
9613: || ' '
9614: || p_order_line_id
9615: , 'Process_Line'

Line 9623: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of '

9619: RAISE fnd_api.g_exc_error;
9620: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9621: IF (l_debug = 1) THEN
9622: DEBUG(
9623: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of '
9624: || p_order_header_id
9625: || ' '
9626: || p_order_line_id
9627: , 'Process_Line'

Line 9796: inv_quantity_tree_pub.clear_quantity_cache;

9792: OR p_revision IS NULL)
9793: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, p_end_item_unit_number)
9794: ) THEN
9795: -- clear quantity tree cache
9796: inv_quantity_tree_pub.clear_quantity_cache;
9797:
9798: -- query quantity tree
9799: IF (l_debug = 1) THEN
9800: DEBUG('Before query quantity tree ', 'Process_Line');

Line 9810: inv_quantity_tree_pub.query_quantities(

9806: DEBUG('l_lpn_cont_rec.locator_id =' || l_lpn_cont_rec.locator_id, 'Process_Line');
9807: DEBUG('l_lpn_cont_rec.lpn_id=' || l_lpn_cont_rec.lpn_id, 'Process_Line');
9808: END IF;
9809:
9810: inv_quantity_tree_pub.query_quantities(
9811: x_return_status => l_return_status
9812: , x_msg_count => l_msg_count
9813: , x_msg_data => l_msg_data
9814: , x_qoh => l_qoh

Line 9824: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode

9820: , p_api_version_number => 1.0
9821: , p_init_msg_lst => fnd_api.g_false
9822: , p_organization_id => p_org_id
9823: , p_inventory_item_id => p_inventory_item_id
9824: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
9825: , p_is_revision_control => l_lpn_cont_rec.revision_control
9826: , p_is_lot_control => l_lpn_cont_rec.lot_control
9827: , p_is_serial_control => l_lpn_cont_rec.serial_control
9828: , p_demand_source_type_id => l_demand_source_type_id

Line 9841: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of ' || p_order_header_id || ' '

9837:
9838: IF l_return_status = fnd_api.g_ret_sts_error THEN
9839: IF (l_debug = 1) THEN
9840: DEBUG(
9841: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of ' || p_order_header_id || ' '
9842: || p_order_line_id
9843: , 'Process_Line'
9844: );
9845: END IF;

Line 9851: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of ' || p_order_header_id || ' '

9847: RAISE fnd_api.g_exc_error;
9848: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9849: IF (l_debug = 1) THEN
9850: DEBUG(
9851: 'Validation failed for inv_quantity_tree_pub.query_quantities for combination of ' || p_order_header_id || ' '
9852: || p_order_line_id
9853: , 'Process_Line'
9854: );
9855: END IF;

Line 10994: inv_quantity_tree_pub.clear_quantity_cache;

10990: RAISE fnd_api.g_exc_unexpected_error;
10991: END;
10992:
10993: -- clear quantity tree cache
10994: inv_quantity_tree_pub.clear_quantity_cache;
10995:
10996: -- query quantity tree
10997: IF (l_debug = 1) THEN
10998: DEBUG('Before query quantity tree ', 'Perform_Overship_Distribution');

Line 11008: inv_quantity_tree_pub.query_quantities(

11004: DEBUG('l_lpn_cont_rec.locator_id =' || l_lpn_cont_rec.locator_id, 'Perform_Overship_Distribution');
11005: DEBUG('l_lpn_cont_rec.lpn_id=' || l_lpn_cont_rec.lpn_id, 'Perform_Overship_Distribution');
11006: END IF;
11007:
11008: inv_quantity_tree_pub.query_quantities(
11009: x_return_status => l_return_status
11010: , x_msg_count => l_msg_count
11011: , x_msg_data => l_msg_data
11012: , x_qoh => l_qoh

Line 11022: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

11018: , p_api_version_number => 1.0
11019: , p_init_msg_lst => fnd_api.g_false
11020: , p_organization_id => p_org_id
11021: , p_inventory_item_id => l_lpn_cont_rec.inventory_item_id
11022: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
11023: , p_is_revision_control => l_lpn_cont_rec.revision_control
11024: , p_is_lot_control => l_lpn_cont_rec.lot_control
11025: , p_is_serial_control => l_lpn_cont_rec.serial_control
11026: , p_demand_source_type_id => l_demand_source_type_id

Line 11038: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');

11034: );
11035:
11036: IF l_return_status = fnd_api.g_ret_sts_error THEN
11037: IF (l_debug = 1) THEN
11038: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');
11039: END IF;
11040:
11041: RAISE fnd_api.g_exc_error;
11042: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 11044: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');

11040:
11041: RAISE fnd_api.g_exc_error;
11042: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11043: IF (l_debug = 1) THEN
11044: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');
11045: END IF;
11046:
11047: RAISE fnd_api.g_exc_unexpected_error;
11048: END IF;

Line 11288: inv_quantity_tree_pub.clear_quantity_cache;

11284: RAISE fnd_api.g_exc_unexpected_error;
11285: END;
11286:
11287: -- clear quantity tree cache
11288: inv_quantity_tree_pub.clear_quantity_cache;
11289:
11290: -- query quantity tree
11291: IF (l_debug = 1) THEN
11292: DEBUG('Before query quantity tree ', 'Perform_Overship_Distribution');

Line 11302: inv_quantity_tree_pub.query_quantities(

11298: DEBUG('l_lpn_cont_rec.locator_id =' || l_lpn_cont_rec.locator_id, 'Perform_Overship_Distribution');
11299: DEBUG('l_lpn_cont_rec.lpn_id=' || l_lpn_cont_rec.lpn_id, 'Perform_Overship_Distribution');
11300: END IF;
11301:
11302: inv_quantity_tree_pub.query_quantities(
11303: x_return_status => l_return_status
11304: , x_msg_count => l_msg_count
11305: , x_msg_data => l_msg_data
11306: , x_qoh => l_qoh

Line 11316: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

11312: , p_api_version_number => 1.0
11313: , p_init_msg_lst => fnd_api.g_false
11314: , p_organization_id => p_org_id
11315: , p_inventory_item_id => l_lpn_cont_rec.inventory_item_id
11316: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
11317: , p_is_revision_control => l_lpn_cont_rec.revision_control
11318: , p_is_lot_control => l_lpn_cont_rec.lot_control
11319: , p_is_serial_control => l_lpn_cont_rec.serial_control
11320: , p_demand_source_type_id => l_demand_source_type_id

Line 11332: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');

11328: );
11329:
11330: IF l_return_status = fnd_api.g_ret_sts_error THEN
11331: IF (l_debug = 1) THEN
11332: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');
11333: END IF;
11334:
11335: RAISE fnd_api.g_exc_error;
11336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 11338: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');

11334:
11335: RAISE fnd_api.g_exc_error;
11336: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11337: IF (l_debug = 1) THEN
11338: DEBUG('Validation failed for inv_quantity_tree_pub.query_quantities', 'Perform_Overship_Distribution');
11339: END IF;
11340:
11341: RAISE fnd_api.g_exc_unexpected_error;
11342: END IF;