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.

[Home] [Help]

APPS.INV_QUANTITY_TREE_UE dependencies on INV_QUANTITY_TREE_PVT

Line 184: -- l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????

180: END IF;
181: END IF;
182:
183: --start changes for bug7038890
184: -- l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
185: IF ((p_lpn_id IS NOT NULL) OR (p_wms_task_type IS NOT NULL)) THEN -- 12831673
186: l_tree_mode := 2;
187: ELSE
188: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;

Line 188: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;

184: -- l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
185: IF ((p_lpn_id IS NOT NULL) OR (p_wms_task_type IS NOT NULL)) THEN -- 12831673
186: l_tree_mode := 2;
187: ELSE
188: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;
189: END IF;
190: --end changes for bug7038890
191:
192: IF p_activate <> 1 THEN

Line 241: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;

237: ELSE
238: l_asset_sub_only := FALSE;
239: END IF;
240:
241: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;
242:
243: l_expiration_date := NULL;--???????
244:
245: IF p_serial_control = g_no_serial_control THEN

Line 254: print_debug('Calling inv_quantity_tree_pvt.create_tree');

250:
251: l_include_suggestion := TRUE;
252:
253: IF (l_debug = 1) then
254: print_debug('Calling inv_quantity_tree_pvt.create_tree');
255: END IF;
256:
257: inv_quantity_tree_pvt.create_tree
258: (

Line 257: inv_quantity_tree_pvt.create_tree

253: IF (l_debug = 1) then
254: print_debug('Calling inv_quantity_tree_pvt.create_tree');
255: END IF;
256:
257: inv_quantity_tree_pvt.create_tree
258: (
259: p_api_version_number => 1.0,
260: p_init_msg_lst => fnd_api.g_true,
261: x_return_status => l_return_status,

Line 285: print_debug('Error from inv_quantity_tree_pvt.create_tree');

281: );
282:
283: IF l_return_status <> fnd_api.g_ret_sts_success THEN
284: IF (l_debug = 1) then
285: print_debug('Error from inv_quantity_tree_pvt.create_tree');
286: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
287: END IF;
288: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_CREATE_TREE');
289: FND_MSG_PUB.ADD;

Line 295: print_debug('Calling inv_quantity_tree_pvt.query_tree');

291: END IF;
292:
293: IF (l_debug = 1) THEN
294: print_debug('Tree_id:'||l_tree_id);
295: print_debug('Calling inv_quantity_tree_pvt.query_tree');
296: END IF;
297:
298: inv_quantity_tree_pvt.query_tree
299: (

Line 298: inv_quantity_tree_pvt.query_tree

294: print_debug('Tree_id:'||l_tree_id);
295: print_debug('Calling inv_quantity_tree_pvt.query_tree');
296: END IF;
297:
298: inv_quantity_tree_pvt.query_tree
299: (
300: p_api_version_number => 1.0,
301: p_init_msg_lst => fnd_api.g_true,
302: x_return_status => l_return_status,

Line 326: print_debug('Error from inv_quantity_tree_pvt.query_tree');

322: );
323:
324: IF l_return_status <> fnd_api.g_ret_sts_success THEN
325: IF (l_debug = 1) then
326: print_debug('Error from inv_quantity_tree_pvt.query_tree');
327: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
328: END IF;
329: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');
330: FND_MSG_PUB.ADD;

Line 341: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,

337: print_debug('Secondary Qties : l_sqoh:'||l_sqoh||'l_srqoh:'||l_srqoh||'l_sqr:'||l_sqr||
338: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
339: END IF;
340:
341: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
342: inv_quantity_tree_pvt.g_loose_only_mode) THEN
343: l_available_quantity := l_att;
344: l_available_quantity2 := l_satt; -- invConv change
345: ELSE

Line 342: inv_quantity_tree_pvt.g_loose_only_mode) THEN

338: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
339: END IF;
340:
341: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
342: inv_quantity_tree_pvt.g_loose_only_mode) THEN
343: l_available_quantity := l_att;
344: l_available_quantity2 := l_satt; -- invConv change
345: ELSE
346: l_available_quantity := l_atr;

Line 716: -- l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????

712: RETURN 1;
713: END IF;
714:
715: --start changes for bug7038890
716: -- l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
717: IF ((p_lpn_id IS NOT NULL) OR (p_wms_task_type IS NOT NULL)) THEN -- 12831673
718: l_tree_mode := 2;
719: else
720: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;

Line 720: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;

716: -- l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
717: IF ((p_lpn_id IS NOT NULL) OR (p_wms_task_type IS NOT NULL)) THEN -- 12831673
718: l_tree_mode := 2;
719: else
720: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;
721: END IF ;
722: --end changes for bug7038890
723:
724: IF p_locator = -1 THEN

Line 764: print_debug('... g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);

760: END IF;
761: -- invConv changes begin :
762: -- Because of Material Status : Need to know whether the item is lot_control : MANDATORY.
763: IF (l_debug = 1) then
764: print_debug('... g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
765: END IF;
766: IF (l_is_lot_control = FALSE
767: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
768: THEN

Line 767: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)

763: IF (l_debug = 1) then
764: print_debug('... g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
765: END IF;
766: IF (l_is_lot_control = FALSE
767: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
768: THEN
769: -- Get Item Details:
770: OPEN get_item_details(p_organization_id, p_inventory_item_id);
771: FETCH get_item_details

Line 796: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;

792: -- ELSE
793: -- l_asset_sub_only := FALSE;
794: -- END IF;
795:
796: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;
797:
798: l_expiration_date := NULL;--???????
799:
800: IF p_serial_control = g_no_serial_control THEN

Line 809: print_debug('calling inv_quantity_tree_pvt.find_rootinfo.');

805:
806: l_include_suggestion := TRUE;
807:
808: IF (l_debug = 1) THEN
809: print_debug('calling inv_quantity_tree_pvt.find_rootinfo.');
810: END IF;
811:
812: l_tree_id :=
813: inv_quantity_tree_pvt.find_rootinfo

Line 813: inv_quantity_tree_pvt.find_rootinfo

809: print_debug('calling inv_quantity_tree_pvt.find_rootinfo.');
810: END IF;
811:
812: l_tree_id :=
813: inv_quantity_tree_pvt.find_rootinfo
814: (
815: x_return_status => l_return_status,
816: p_organization_id => p_Organization_id,
817: p_inventory_item_id => p_Inventory_item_id,

Line 835: print_debug('Error from inv_quantity_tree_pvt.find_rootinfo');

831: );
832:
833: IF l_return_status <> fnd_api.g_ret_sts_success THEN
834: IF (l_debug = 1) then
835: print_debug('Error from inv_quantity_tree_pvt.find_rootinfo');
836: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
837: END IF;
838: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_FIND_ROOTINFO');
839: FND_MSG_PUB.ADD;

Line 844: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);

840: RAISE fnd_api.g_exc_error;
841: END IF;
842:
843: IF (l_debug = 1) then
844: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);
845: print_debug('calling inv_quantity_tree_pvt.query_tree');
846: END IF;
847:
848:

Line 845: print_debug('calling inv_quantity_tree_pvt.query_tree');

841: END IF;
842:
843: IF (l_debug = 1) then
844: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);
845: print_debug('calling inv_quantity_tree_pvt.query_tree');
846: END IF;
847:
848:
849: inv_quantity_tree_pvt.query_tree

Line 849: inv_quantity_tree_pvt.query_tree

845: print_debug('calling inv_quantity_tree_pvt.query_tree');
846: END IF;
847:
848:
849: inv_quantity_tree_pvt.query_tree
850: (
851: p_api_version_number => 1.0,
852: p_init_msg_lst => fnd_api.g_true,
853: x_return_status => l_return_status,

Line 880: print_debug('Error from inv_quantity_tree_pvt.query_tree');

876: );
877:
878: IF l_return_status <> fnd_api.g_ret_sts_success THEN
879: IF (l_debug = 1) then
880: print_debug('Error from inv_quantity_tree_pvt.query_tree');
881: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
882: END IF;
883: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');
884: FND_MSG_PUB.ADD;

Line 893: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');

889: print_debug('Primaries : l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||
890: 'l_qs:'||l_qs||'l_att:'||l_att||'l_atr:'||l_atr);
891: print_debug('Secondaries : l_sqoh:'||l_sqoh||'l_srqoh:'||l_srqoh||'l_sqr:'||l_sqr||
892: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
893: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
894: END IF;
895:
896: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
897: inv_quantity_tree_pvt.g_loose_only_mode) THEN

Line 896: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,

892: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
893: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
894: END IF;
895:
896: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
897: inv_quantity_tree_pvt.g_loose_only_mode) THEN
898: l_available_quantity := l_att;
899: l_available_quantity2 := l_satt; -- invConv change
900: ELSE

Line 897: inv_quantity_tree_pvt.g_loose_only_mode) THEN

893: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
894: END IF;
895:
896: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
897: inv_quantity_tree_pvt.g_loose_only_mode) THEN
898: l_available_quantity := l_att;
899: l_available_quantity2 := l_satt; -- invConv change
900: ELSE
901: l_available_quantity := l_atr;

Line 913: inv_quantity_tree_pvt.get_total_qoh

909: IF (l_debug = 1) then
910: print_debug(' odab l_original_avail_qoh='||l_original_avail_qoh||', l_original_avail_qoh2='||l_original_avail_qoh2);
911: END IF;
912:
913: inv_quantity_tree_pvt.get_total_qoh
914: (x_return_status => l_return_status,
915: x_msg_count => l_msg_count,
916: x_msg_data => l_msg_data,
917: p_tree_id => l_tree_id,

Line 928: print_debug('Error from inv_quantity_tree_pvt.get_total_qoh');

924: );
925:
926: IF l_return_status <> fnd_api.g_ret_sts_success THEN
927: IF (l_debug = 1) then
928: print_debug('Error from inv_quantity_tree_pvt.get_total_qoh');
929: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
930: END IF;
931: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_TOTAL_QOH');
932: FND_MSG_PUB.ADD;

Line 1435: --l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????

1431: RETURN 1;
1432: END IF;
1433:
1434: --start changes for bug7038890
1435: --l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
1436: IF ((p_lpn_id IS NOT NULL) OR (p_wms_task_type IS NOT NULL)) THEN -- 12831673
1437: l_tree_mode :=2;
1438: ELSE
1439: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;

Line 1439: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;

1435: --l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
1436: IF ((p_lpn_id IS NOT NULL) OR (p_wms_task_type IS NOT NULL)) THEN -- 12831673
1437: l_tree_mode :=2;
1438: ELSE
1439: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;
1440: END IF;
1441: --end changes for bug7038890
1442:
1443: IF p_rev_active = g_no_rev_ctrl_please THEN

Line 1469: print_debug('+++ g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);

1465: END IF;
1466: -- invConv changes begin :
1467: -- Because of Material Status : Need to know whether the item is lot_control : MANDATORY.
1468: IF (l_debug = 1) then
1469: print_debug('+++ g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
1470: END IF;
1471: IF (l_is_lot_control = FALSE
1472: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
1473: THEN

Line 1472: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)

1468: IF (l_debug = 1) then
1469: print_debug('+++ g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
1470: END IF;
1471: IF (l_is_lot_control = FALSE
1472: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
1473: THEN
1474: -- Get Item Details:
1475: OPEN get_item_details(p_organization_id, p_inventory_item_id);
1476: FETCH get_item_details

Line 1575: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;

1571: -- ELSE
1572: -- l_asset_sub_only := FALSE;
1573: -- END IF;
1574:
1575: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;
1576:
1577: l_expiration_date := NULL;--???????
1578:
1579: IF p_serial_control = g_no_serial_control THEN

Line 1588: print_debug('calling inv_quantity_tree_pvt.find_rootinfo');

1584:
1585: l_include_suggestion := TRUE;
1586:
1587: IF (l_debug = 1) THEN
1588: print_debug('calling inv_quantity_tree_pvt.find_rootinfo');
1589: END IF;
1590:
1591: l_tree_id :=
1592: inv_quantity_tree_pvt.find_rootinfo

Line 1592: inv_quantity_tree_pvt.find_rootinfo

1588: print_debug('calling inv_quantity_tree_pvt.find_rootinfo');
1589: END IF;
1590:
1591: l_tree_id :=
1592: inv_quantity_tree_pvt.find_rootinfo
1593: ( x_return_status => l_return_status,
1594: p_organization_id => p_organization_id,
1595: p_inventory_item_id => p_inventory_item_id,
1596: p_tree_mode => l_tree_Mode,

Line 1613: print_debug('Error from inv_quantity_tree_pvt.find_rootinfo');

1609: );
1610:
1611: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1612: IF (l_debug = 1) then
1613: print_debug('Error from inv_quantity_tree_pvt.find_rootinfo');
1614: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1615: END IF;
1616: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_FIND_ROOTINFO');
1617: FND_MSG_PUB.ADD;

Line 1622: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);

1618: RAISE fnd_api.g_exc_error;
1619: END IF;
1620:
1621: IF (l_debug = 1) then
1622: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);
1623: print_debug('Will call update_qties for xact_mode='||l_xact_mode||', g_qs_txn='||g_qs_txn||', subinv='||p_transfer_subinventory);
1624: END IF;
1625:
1626: IF p_transfer_subinventory IS NOT NULL AND

Line 1633: inv_quantity_tree_pvt.update_quantities_for_form

1629: IF (l_debug = 1) THEN
1630: print_debug('Calling update_quantities_for_form for xact_mode='||l_xact_mode||', trx_qty='||l_transaction_quantity||', trx_qty2='||p_transaction_quantity2||'.');
1631: END IF;
1632:
1633: inv_quantity_tree_pvt.update_quantities_for_form
1634: ( p_api_version_number => 1.0,
1635: p_init_msg_lst => fnd_api.g_true,
1636: x_return_status => l_return_status,
1637: x_msg_count => l_msg_count,

Line 1646: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

1642: p_subinventory_code => p_transfer_Subinventory,
1643: p_locator_id => l_transfer_Locator_id,
1644: p_primary_quantity => l_transaction_quantity,
1645: p_secondary_quantity => p_transaction_quantity2, -- invConv change
1646: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
1647: x_qoh => l_qoh,
1648: x_rqoh => l_rqoh,
1649: x_qr => l_qr,
1650: x_qs => l_qs,

Line 1665: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 1');

1661: );
1662:
1663: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1664: IF (l_debug = 1) then
1665: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 1');
1666: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1667: END IF;
1668: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');
1669: FND_MSG_PUB.ADD;

Line 1684: inv_quantity_tree_pvt.update_quantities_for_form

1680: IF (l_debug = 1) THEN
1681: print_debug('Calling update_quantities_for_form for trx_qty='||(0 - l_transaction_quantity)||', trx_qty2='||(0 - p_transaction_quantity2)||'.');
1682: END IF;
1683:
1684: inv_quantity_tree_pvt.update_quantities_for_form
1685: ( p_api_version_number => 1.0,
1686: p_init_msg_lst => fnd_api.g_true,
1687: x_return_status => l_return_status,
1688: x_msg_count => l_msg_count,

Line 1697: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

1693: p_subinventory_code => p_Subinventory,
1694: p_locator_id => l_Locator_id,
1695: p_primary_quantity => (0 - l_transaction_quantity),
1696: p_secondary_quantity => (0 - p_transaction_quantity2),
1697: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
1698: x_qoh => l_qoh,
1699: x_rqoh => l_rqoh,
1700: x_qr => l_qr,
1701: x_qs => l_qs,

Line 1716: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 2');

1712: );
1713:
1714: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1715: IF (l_debug = 1) then
1716: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 2');
1717: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1718: END IF;
1719: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');
1720: FND_MSG_PUB.ADD;

Line 1732: print_debug('calling inv_quantity_tree_pvt.query_tree');

1728: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
1729: END IF;
1730:
1731: IF (l_debug = 1) THEN
1732: print_debug('calling inv_quantity_tree_pvt.query_tree');
1733: END IF;
1734:
1735: inv_quantity_tree_pvt.query_tree
1736: (p_api_version_number => 1.0,

Line 1735: inv_quantity_tree_pvt.query_tree

1731: IF (l_debug = 1) THEN
1732: print_debug('calling inv_quantity_tree_pvt.query_tree');
1733: END IF;
1734:
1735: inv_quantity_tree_pvt.query_tree
1736: (p_api_version_number => 1.0,
1737: p_init_msg_lst => fnd_api.g_true,
1738: x_return_status => l_return_status,
1739: x_msg_count => l_msg_count,

Line 1764: print_debug('Error from inv_quantity_tree_pvt.query_tree');

1760: );
1761:
1762: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1763: IF (l_debug = 1) then
1764: print_debug('Error from inv_quantity_tree_pvt.query_tree');
1765: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1766: END IF;
1767: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');
1768: FND_MSG_PUB.ADD;

Line 1790: inv_quantity_tree_pvt.update_quantities_for_form

1786: IF (l_debug = 1) THEN
1787: print_debug('Calling update_quantities_for_form for temp_trx_qty='||l_temp_trx_quantity||', temp_trx_qty2='||l_temp_trx_quantity2||'.');
1788: END IF;
1789:
1790: inv_quantity_tree_pvt.update_quantities_for_form
1791: ( p_api_version_number => 1.0,
1792: p_init_msg_lst => fnd_api.g_true,
1793: x_return_status => l_return_status,
1794: x_msg_count => l_msg_count,

Line 1822: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 3');

1818: );
1819:
1820: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1821: IF (l_debug = 1) then
1822: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 3');
1823: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1824: END IF;
1825: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');
1826: FND_MSG_PUB.ADD;

Line 1838: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,

1834: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
1835: END IF;
1836: END IF;
1837:
1838: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
1839: inv_quantity_tree_pvt.g_loose_only_mode) THEN
1840: l_available_quantity := l_att;
1841: l_available_quantity2 := l_satt; -- invConv change
1842: ELSE

Line 1839: inv_quantity_tree_pvt.g_loose_only_mode) THEN

1835: END IF;
1836: END IF;
1837:
1838: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
1839: inv_quantity_tree_pvt.g_loose_only_mode) THEN
1840: l_available_quantity := l_att;
1841: l_available_quantity2 := l_satt; -- invConv change
1842: ELSE
1843: l_available_quantity := l_atr;

Line 1857: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');

1853: print_debug(' odab before get_total_qoh l_original_avail_qoh='||l_onhand_quantity||', l_original_avail_qoh2='||l_onhand_quantity2);
1854: END IF;
1855:
1856: IF (l_debug = 1) THEN
1857: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
1858: END IF;
1859:
1860: inv_quantity_tree_pvt.get_total_qoh
1861: (x_return_status => l_return_status,

Line 1860: inv_quantity_tree_pvt.get_total_qoh

1856: IF (l_debug = 1) THEN
1857: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
1858: END IF;
1859:
1860: inv_quantity_tree_pvt.get_total_qoh
1861: (x_return_status => l_return_status,
1862: x_msg_count => l_msg_count,
1863: x_msg_data => l_msg_data,
1864: p_tree_id => l_tree_id,

Line 1876: print_debug('Error from inv_quantity_tree_pvt.get_total_qoh');

1872: );
1873:
1874: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1875: IF (l_debug = 1) then
1876: print_debug('Error from inv_quantity_tree_pvt.get_total_qoh');
1877: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1878: END IF;
1879: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_TOTAL_QOH');
1880: FND_MSG_PUB.ADD;