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.INV_QUANTITY_TREE_UE dependencies on INV_QUANTITY_TREE_PVT

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

170: print_debug('... p_demand_header_type IS NOT NULL... ');
171: END IF;
172: END IF;
173:
174: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
175:
176: IF p_activate <> 1 THEN
177: x_available_quantity := 0;
178: x_onhand_quantity := 0;

Line 225: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;

221: ELSE
222: l_asset_sub_only := FALSE;
223: END IF;
224:
225: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;
226:
227: l_expiration_date := NULL;--???????
228:
229: IF p_serial_control = g_no_serial_control THEN

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

234:
235: l_include_suggestion := TRUE;
236:
237: IF (l_debug = 1) then
238: print_debug('Calling inv_quantity_tree_pvt.create_tree');
239: END IF;
240:
241: inv_quantity_tree_pvt.create_tree
242: (

Line 241: inv_quantity_tree_pvt.create_tree

237: IF (l_debug = 1) then
238: print_debug('Calling inv_quantity_tree_pvt.create_tree');
239: END IF;
240:
241: inv_quantity_tree_pvt.create_tree
242: (
243: p_api_version_number => 1.0,
244: p_init_msg_lst => fnd_api.g_true,
245: x_return_status => l_return_status,

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

265: );
266:
267: IF l_return_status <> fnd_api.g_ret_sts_success THEN
268: IF (l_debug = 1) then
269: print_debug('Error from inv_quantity_tree_pvt.create_tree');
270: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
271: END IF;
272: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_CREATE_TREE');
273: FND_MSG_PUB.ADD;

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

275: END IF;
276:
277: IF (l_debug = 1) THEN
278: print_debug('Tree_id:'||l_tree_id);
279: print_debug('Calling inv_quantity_tree_pvt.query_tree');
280: END IF;
281:
282: inv_quantity_tree_pvt.query_tree
283: (

Line 282: inv_quantity_tree_pvt.query_tree

278: print_debug('Tree_id:'||l_tree_id);
279: print_debug('Calling inv_quantity_tree_pvt.query_tree');
280: END IF;
281:
282: inv_quantity_tree_pvt.query_tree
283: (
284: p_api_version_number => 1.0,
285: p_init_msg_lst => fnd_api.g_true,
286: x_return_status => l_return_status,

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

306: );
307:
308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
309: IF (l_debug = 1) then
310: print_debug('Error from inv_quantity_tree_pvt.query_tree');
311: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
312: END IF;
313: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');
314: FND_MSG_PUB.ADD;

Line 325: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,

321: print_debug('Secondary Qties : l_sqoh:'||l_sqoh||'l_srqoh:'||l_srqoh||'l_sqr:'||l_sqr||
322: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
323: END IF;
324:
325: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
326: inv_quantity_tree_pvt.g_loose_only_mode) THEN
327: l_available_quantity := l_att;
328: l_available_quantity2 := l_satt; -- invConv change
329: ELSE

Line 326: inv_quantity_tree_pvt.g_loose_only_mode) THEN

322: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
323: END IF;
324:
325: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
326: inv_quantity_tree_pvt.g_loose_only_mode) THEN
327: l_available_quantity := l_att;
328: l_available_quantity2 := l_satt; -- invConv change
329: ELSE
330: l_available_quantity := l_atr;

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

683: x_onhand_quantity := 0;
684: RETURN 1;
685: END IF;
686:
687: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
688:
689: IF p_locator = -1 THEN
690: l_locator_id := NULL;
691: l_dyn_loc := TRUE;

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

718: END IF;
719: -- invConv changes begin :
720: -- Because of Material Status : Need to know whether the item is lot_control : MANDATORY.
721: IF (l_debug = 1) then
722: print_debug('... g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
723: END IF;
724: IF (l_is_lot_control = FALSE
725: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
726: THEN

Line 725: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)

721: IF (l_debug = 1) then
722: print_debug('... g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
723: END IF;
724: IF (l_is_lot_control = FALSE
725: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
726: THEN
727: -- Get Item Details:
728: OPEN get_item_details(p_organization_id, p_inventory_item_id);
729: FETCH get_item_details

Line 754: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;

750: -- ELSE
751: -- l_asset_sub_only := FALSE;
752: -- END IF;
753:
754: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;
755:
756: l_expiration_date := NULL;--???????
757:
758: IF p_serial_control = g_no_serial_control THEN

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

763:
764: l_include_suggestion := TRUE;
765:
766: IF (l_debug = 1) THEN
767: print_debug('calling inv_quantity_tree_pvt.find_rootinfo.');
768: END IF;
769:
770: l_tree_id :=
771: inv_quantity_tree_pvt.find_rootinfo

Line 771: inv_quantity_tree_pvt.find_rootinfo

767: print_debug('calling inv_quantity_tree_pvt.find_rootinfo.');
768: END IF;
769:
770: l_tree_id :=
771: inv_quantity_tree_pvt.find_rootinfo
772: (
773: x_return_status => l_return_status,
774: p_organization_id => p_Organization_id,
775: p_inventory_item_id => p_Inventory_item_id,

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

789: );
790:
791: IF l_return_status <> fnd_api.g_ret_sts_success THEN
792: IF (l_debug = 1) then
793: print_debug('Error from inv_quantity_tree_pvt.find_rootinfo');
794: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
795: END IF;
796: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_FIND_ROOTINFO');
797: FND_MSG_PUB.ADD;

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

798: RAISE fnd_api.g_exc_error;
799: END IF;
800:
801: IF (l_debug = 1) then
802: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);
803: print_debug('calling inv_quantity_tree_pvt.query_tree');
804: END IF;
805:
806:

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

799: END IF;
800:
801: IF (l_debug = 1) then
802: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);
803: print_debug('calling inv_quantity_tree_pvt.query_tree');
804: END IF;
805:
806:
807: inv_quantity_tree_pvt.query_tree

Line 807: inv_quantity_tree_pvt.query_tree

803: print_debug('calling inv_quantity_tree_pvt.query_tree');
804: END IF;
805:
806:
807: inv_quantity_tree_pvt.query_tree
808: (
809: p_api_version_number => 1.0,
810: p_init_msg_lst => fnd_api.g_true,
811: x_return_status => l_return_status,

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

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

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

845: print_debug('Primaries : l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||
846: 'l_qs:'||l_qs||'l_att:'||l_att||'l_atr:'||l_atr);
847: print_debug('Secondaries : l_sqoh:'||l_sqoh||'l_srqoh:'||l_srqoh||'l_sqr:'||l_sqr||
848: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
849: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
850: END IF;
851:
852: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
853: inv_quantity_tree_pvt.g_loose_only_mode) THEN

Line 852: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,

848: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
849: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
850: END IF;
851:
852: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
853: inv_quantity_tree_pvt.g_loose_only_mode) THEN
854: l_available_quantity := l_att;
855: l_available_quantity2 := l_satt; -- invConv change
856: ELSE

Line 853: inv_quantity_tree_pvt.g_loose_only_mode) THEN

849: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
850: END IF;
851:
852: IF p_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
853: inv_quantity_tree_pvt.g_loose_only_mode) THEN
854: l_available_quantity := l_att;
855: l_available_quantity2 := l_satt; -- invConv change
856: ELSE
857: l_available_quantity := l_atr;

Line 869: inv_quantity_tree_pvt.get_total_qoh

865: IF (l_debug = 1) then
866: print_debug(' odab l_original_avail_qoh='||l_original_avail_qoh||', l_original_avail_qoh2='||l_original_avail_qoh2);
867: END IF;
868:
869: inv_quantity_tree_pvt.get_total_qoh
870: (x_return_status => l_return_status,
871: x_msg_count => l_msg_count,
872: x_msg_data => l_msg_data,
873: p_tree_id => l_tree_id,

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

880: );
881:
882: IF l_return_status <> fnd_api.g_ret_sts_success THEN
883: IF (l_debug = 1) then
884: print_debug('Error from inv_quantity_tree_pvt.get_total_qoh');
885: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
886: END IF;
887: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_TOTAL_QOH');
888: FND_MSG_PUB.ADD;

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

1366: END IF;
1367: RETURN 1;
1368: END IF;
1369:
1370: l_tree_mode := inv_quantity_tree_pvt.g_loose_only_mode;--??????????????
1371:
1372: IF p_rev_active = g_no_rev_ctrl_please THEN
1373: l_is_revision_control := FALSE;
1374: ELSIF p_rev_active = g_want_rev_ctrl then

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

1394: END IF;
1395: -- invConv changes begin :
1396: -- Because of Material Status : Need to know whether the item is lot_control : MANDATORY.
1397: IF (l_debug = 1) then
1398: print_debug('+++ g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
1399: END IF;
1400: IF (l_is_lot_control = FALSE
1401: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
1402: THEN

Line 1401: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)

1397: IF (l_debug = 1) then
1398: print_debug('+++ g_is_mat_status_used='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
1399: END IF;
1400: IF (l_is_lot_control = FALSE
1401: AND INV_QUANTITY_TREE_PVT.g_is_mat_status_used = 1)
1402: THEN
1403: -- Get Item Details:
1404: OPEN get_item_details(p_organization_id, p_inventory_item_id);
1405: FETCH get_item_details

Line 1502: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;

1498: -- ELSE
1499: -- l_asset_sub_only := FALSE;
1500: -- END IF;
1501:
1502: l_onhand_source := inv_quantity_tree_pvt.g_all_subs;
1503:
1504: l_expiration_date := NULL;--???????
1505:
1506: IF p_serial_control = g_no_serial_control THEN

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

1511:
1512: l_include_suggestion := TRUE;
1513:
1514: IF (l_debug = 1) THEN
1515: print_debug('calling inv_quantity_tree_pvt.find_rootinfo');
1516: END IF;
1517:
1518: l_tree_id :=
1519: inv_quantity_tree_pvt.find_rootinfo

Line 1519: inv_quantity_tree_pvt.find_rootinfo

1515: print_debug('calling inv_quantity_tree_pvt.find_rootinfo');
1516: END IF;
1517:
1518: l_tree_id :=
1519: inv_quantity_tree_pvt.find_rootinfo
1520: ( x_return_status => l_return_status,
1521: p_organization_id => p_organization_id,
1522: p_inventory_item_id => p_inventory_item_id,
1523: p_tree_mode => l_tree_Mode,

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

1536: );
1537:
1538: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1539: IF (l_debug = 1) then
1540: print_debug('Error from inv_quantity_tree_pvt.find_rootinfo');
1541: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1542: END IF;
1543: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_FIND_ROOTINFO');
1544: FND_MSG_PUB.ADD;

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

1545: RAISE fnd_api.g_exc_error;
1546: END IF;
1547:
1548: IF (l_debug = 1) then
1549: print_debug('After inv_quantity_tree_pvt.find_rootinfo tree_id:'||l_tree_id);
1550: print_debug('Will call update_qties for xact_mode='||l_xact_mode||', g_qs_txn='||g_qs_txn||', subinv='||p_transfer_subinventory);
1551: END IF;
1552:
1553: IF p_transfer_subinventory IS NOT NULL AND

Line 1560: inv_quantity_tree_pvt.update_quantities_for_form

1556: IF (l_debug = 1) THEN
1557: print_debug('Calling update_quantities_for_form for xact_mode='||l_xact_mode||', trx_qty='||l_transaction_quantity||', trx_qty2='||p_transaction_quantity2||'.');
1558: END IF;
1559:
1560: inv_quantity_tree_pvt.update_quantities_for_form
1561: ( p_api_version_number => 1.0,
1562: p_init_msg_lst => fnd_api.g_true,
1563: x_return_status => l_return_status,
1564: x_msg_count => l_msg_count,

Line 1573: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

1569: p_subinventory_code => p_transfer_Subinventory,
1570: p_locator_id => l_transfer_Locator_id,
1571: p_primary_quantity => l_transaction_quantity,
1572: p_secondary_quantity => p_transaction_quantity2, -- invConv change
1573: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
1574: x_qoh => l_qoh,
1575: x_rqoh => l_rqoh,
1576: x_qr => l_qr,
1577: x_qs => l_qs,

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

1587: );
1588:
1589: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1590: IF (l_debug = 1) then
1591: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 1');
1592: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1593: END IF;
1594: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');
1595: FND_MSG_PUB.ADD;

Line 1610: inv_quantity_tree_pvt.update_quantities_for_form

1606: IF (l_debug = 1) THEN
1607: print_debug('Calling update_quantities_for_form for trx_qty='||(0 - l_transaction_quantity)||', trx_qty2='||(0 - p_transaction_quantity2)||'.');
1608: END IF;
1609:
1610: inv_quantity_tree_pvt.update_quantities_for_form
1611: ( p_api_version_number => 1.0,
1612: p_init_msg_lst => fnd_api.g_true,
1613: x_return_status => l_return_status,
1614: x_msg_count => l_msg_count,

Line 1623: p_quantity_type => inv_quantity_tree_pvt.g_qoh,

1619: p_subinventory_code => p_Subinventory,
1620: p_locator_id => l_Locator_id,
1621: p_primary_quantity => (0 - l_transaction_quantity),
1622: p_secondary_quantity => (0 - p_transaction_quantity2),
1623: p_quantity_type => inv_quantity_tree_pvt.g_qoh,
1624: x_qoh => l_qoh,
1625: x_rqoh => l_rqoh,
1626: x_qr => l_qr,
1627: x_qs => l_qs,

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

1637: );
1638:
1639: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1640: IF (l_debug = 1) then
1641: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 2');
1642: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1643: END IF;
1644: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');
1645: FND_MSG_PUB.ADD;

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

1653: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
1654: END IF;
1655:
1656: IF (l_debug = 1) THEN
1657: print_debug('calling inv_quantity_tree_pvt.query_tree');
1658: END IF;
1659:
1660: inv_quantity_tree_pvt.query_tree
1661: (p_api_version_number => 1.0,

Line 1660: inv_quantity_tree_pvt.query_tree

1656: IF (l_debug = 1) THEN
1657: print_debug('calling inv_quantity_tree_pvt.query_tree');
1658: END IF;
1659:
1660: inv_quantity_tree_pvt.query_tree
1661: (p_api_version_number => 1.0,
1662: p_init_msg_lst => fnd_api.g_true,
1663: x_return_status => l_return_status,
1664: x_msg_count => l_msg_count,

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

1684: );
1685:
1686: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1687: IF (l_debug = 1) then
1688: print_debug('Error from inv_quantity_tree_pvt.query_tree');
1689: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1690: END IF;
1691: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');
1692: FND_MSG_PUB.ADD;

Line 1714: inv_quantity_tree_pvt.update_quantities_for_form

1710: IF (l_debug = 1) THEN
1711: print_debug('Calling update_quantities_for_form for temp_trx_qty='||l_temp_trx_quantity||', temp_trx_qty2='||l_temp_trx_quantity2||'.');
1712: END IF;
1713:
1714: inv_quantity_tree_pvt.update_quantities_for_form
1715: ( p_api_version_number => 1.0,
1716: p_init_msg_lst => fnd_api.g_true,
1717: x_return_status => l_return_status,
1718: x_msg_count => l_msg_count,

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

1741: );
1742:
1743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1744: IF (l_debug = 1) then
1745: print_debug('Error from inv_quantity_tree_pvt.update_quantities_for_form 3');
1746: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1747: END IF;
1748: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');
1749: FND_MSG_PUB.ADD;

Line 1761: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,

1757: 'l_sqs:'||l_sqs||'l_satt:'||l_satt||'l_satr:'||l_satr);
1758: END IF;
1759: END IF;
1760:
1761: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
1762: inv_quantity_tree_pvt.g_loose_only_mode) THEN
1763: l_available_quantity := l_att;
1764: l_available_quantity2 := l_satt; -- invConv change
1765: ELSE

Line 1762: inv_quantity_tree_pvt.g_loose_only_mode) THEN

1758: END IF;
1759: END IF;
1760:
1761: IF l_tree_mode IN (inv_quantity_tree_pvt.g_transaction_mode,
1762: inv_quantity_tree_pvt.g_loose_only_mode) THEN
1763: l_available_quantity := l_att;
1764: l_available_quantity2 := l_satt; -- invConv change
1765: ELSE
1766: l_available_quantity := l_atr;

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

1776: print_debug(' odab before get_total_qoh l_original_avail_qoh='||l_onhand_quantity||', l_original_avail_qoh2='||l_onhand_quantity2);
1777: END IF;
1778:
1779: IF (l_debug = 1) THEN
1780: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
1781: END IF;
1782:
1783: inv_quantity_tree_pvt.get_total_qoh
1784: (x_return_status => l_return_status,

Line 1783: inv_quantity_tree_pvt.get_total_qoh

1779: IF (l_debug = 1) THEN
1780: print_debug('Calling inv_quantity_tree_pvt.get_total_qoh');
1781: END IF;
1782:
1783: inv_quantity_tree_pvt.get_total_qoh
1784: (x_return_status => l_return_status,
1785: x_msg_count => l_msg_count,
1786: x_msg_data => l_msg_data,
1787: p_tree_id => l_tree_id,

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

1794: );
1795:
1796: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1797: IF (l_debug = 1) then
1798: print_debug('Error from inv_quantity_tree_pvt.get_total_qoh');
1799: print_debug('l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data);
1800: END IF;
1801: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_TOTAL_QOH');
1802: FND_MSG_PUB.ADD;