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 FND_API

Line 111: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

107: , x_message_data OUT NOCOPY VARCHAR2) RETURN NUMBER
108: IS
109: l_tree_id INTEGER := NULL;
110: l_tree_mode NUMBER := NULL;
111: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
112: l_msg_data VARCHAR2(2000) := NULL;
113: l_msg_count NUMBER := NULL;
114: l_is_revision_control BOOLEAN := FALSE;
115: l_is_lot_control BOOLEAN := FALSE;

Line 158: x_return_status := fnd_api.g_ret_sts_success;

154: print_debug('DSName:'||p_demand_source_name||'DSLine:'||p_demand_source_line_id||
155: 'DSDel:'||p_demand_source_delivery||'RevAct:'||p_rev_active);
156: END IF;
157:
158: x_return_status := fnd_api.g_ret_sts_success;
159:
160: -- bug 4104123 : I don't know why the default of p_demand_header_type doesnt work.
161: l_demand_header_type := p_demand_header_type;
162: if p_demand_header_type IS NULL

Line 185: RAISE FND_API.G_EXC_ERROR;

181:
182: IF p_lot_control NOT IN (g_lot_control,g_no_lot_control) THEN
183: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_LOT_CTRL_OPTION');
184: FND_MSG_PUB.ADD;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: -- invConv removed this test : serial_control can have other values.
189: -- IF p_serial_control NOT IN (g_serial_control,g_no_serial_control) THEN

Line 192: -- RAISE FND_API.G_EXC_ERROR;

188: -- invConv removed this test : serial_control can have other values.
189: -- IF p_serial_control NOT IN (g_serial_control,g_no_serial_control) THEN
190: -- FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SER_CTRL_OPTION');
191: -- FND_MSG_PUB.ADD;
192: -- RAISE FND_API.G_EXC_ERROR;
193: -- END IF;
194:
195: IF p_rev_active = g_no_rev_ctrl_please THEN
196: l_is_revision_control := FALSE;

Line 244: p_init_msg_lst => fnd_api.g_true,

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,
246: x_msg_count => l_msg_count,
247: x_msg_data => l_msg_data,
248: p_organization_id => p_organization_id,

Line 267: IF l_return_status <> fnd_api.g_ret_sts_success THEN

263: p_onhand_source => l_onhand_source,
264: x_tree_id => l_tree_id
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;

Line 274: RAISE fnd_api.g_exc_error;

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;
274: RAISE fnd_api.g_exc_error;
275: END IF;
276:
277: IF (l_debug = 1) THEN
278: print_debug('Tree_id:'||l_tree_id);

Line 285: p_init_msg_lst => fnd_api.g_true,

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,
287: x_msg_count => l_msg_count,
288: x_msg_data => l_msg_data,
289: p_tree_id => l_tree_id,

Line 308: IF l_return_status <> fnd_api.g_ret_sts_success THEN

304: x_satt => l_satt, -- invConv change
305: x_satr => l_satr -- invConv change
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;

Line 315: RAISE fnd_api.g_exc_error;

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;
315: RAISE fnd_api.g_exc_error;
316: END IF;
317:
318: IF (l_debug = 1) THEN
319: print_debug('Primary Qties : l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 352: RAISE FND_API.G_EXC_ERROR;

348: print_debug('Primary UOM not found');
349: END IF;
350: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;
353: END;
354:
355: IF (l_debug = 1) THEN
356: print_debug('l_primary_uom_code'||l_primary_uom_code);

Line 375: RAISE FND_API.G_EXC_ERROR;

371: print_debug('Error converting l_available_quantity');
372: END IF;
373: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
374: FND_MSG_PUB.ADD;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: IF l_available_quantity < 0 THEN
379: l_available_quantity := 0 - l_available_conv_quantity;

Line 402: RAISE FND_API.G_EXC_ERROR;

398: print_debug('Error converting l_onhand_quantity');
399: END IF;
400: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
401: FND_MSG_PUB.ADD;
402: RAISE FND_API.G_EXC_ERROR;
403: END IF;
404:
405: IF l_onhand_quantity < 0 THEN
406: l_onhand_quantity := 0 - l_onhand_conv_quantity;

Line 432: WHEN fnd_api.g_exc_error THEN

428:
429: RETURN 1;
430:
431: EXCEPTION
432: WHEN fnd_api.g_exc_error THEN
433:
434: IF (l_debug = 1) THEN
435: print_debug('fnd_api.g_exc_error');
436: END IF;

Line 435: print_debug('fnd_api.g_exc_error');

431: EXCEPTION
432: WHEN fnd_api.g_exc_error THEN
433:
434: IF (l_debug = 1) THEN
435: print_debug('fnd_api.g_exc_error');
436: END IF;
437:
438: x_return_status := fnd_api.g_ret_sts_error;
439: x_available_quantity := 0;

Line 438: x_return_status := fnd_api.g_ret_sts_error;

434: IF (l_debug = 1) THEN
435: print_debug('fnd_api.g_exc_error');
436: END IF;
437:
438: x_return_status := fnd_api.g_ret_sts_error;
439: x_available_quantity := 0;
440: x_onhand_quantity := 0;
441:
442: fnd_msg_pub.count_and_get

Line 459: x_return_status := fnd_api.g_ret_sts_unexp_error ;

455: WHEN OTHERS THEN
456: IF (l_debug = 1) THEN
457: print_debug('OTHERS error');
458: END IF;
459: x_return_status := fnd_api.g_ret_sts_unexp_error ;
460:
461: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
462: THEN
463: fnd_msg_pub.add_exc_msg

Line 596: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

592: , X_message_data OUT NOCOPY VARCHAR2) RETURN NUMBER
593: IS
594: l_tree_id INTEGER := NULL;
595: l_tree_mode NUMBER := NULL;
596: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
597: l_msg_data VARCHAR2(2000) := NULL;
598: l_msg_count NUMBER := NULL;
599: l_is_revision_control BOOLEAN := FALSE;
600: l_is_lot_control BOOLEAN := FALSE;

Line 678: x_return_status := fnd_api.g_ret_sts_success;

674: print_debug('... p_demand_header_type IS NOT NULL... ');
675: END IF;
676: END IF;
677:
678: x_return_status := fnd_api.g_ret_sts_success;
679:
680: IF p_activate <> 1 THEN
681: x_available_quantity := 0;
682: x_available_onhand := 0;

Line 740: RAISE FND_API.G_EXC_ERROR;

736: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
737: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
738: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
739: FND_MSG_PUB.ADD;
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: CLOSE get_item_details;
743: END IF;
744: -- invConv changes end.

Line 791: IF l_return_status <> fnd_api.g_ret_sts_success THEN

787: p_lot_expiration_date => NULL,
788: p_onhand_source => l_onhand_source
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;

Line 798: RAISE fnd_api.g_exc_error;

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;
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);

Line 810: p_init_msg_lst => fnd_api.g_true,

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,
812: x_msg_count => l_msg_count,
813: x_msg_data => l_msg_data,
814: p_tree_id => l_tree_id,

Line 834: IF l_return_status <> fnd_api.g_ret_sts_success THEN

830: x_satr => l_satr, -- invConv change
831: p_transfer_subinventory_code => p_Transfer_Subinventory
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;

Line 841: RAISE fnd_api.g_exc_error;

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;
841: RAISE fnd_api.g_exc_error;
842: END IF;
843:
844: IF (l_debug = 1) THEN
845: print_debug('Primaries : l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 882: IF l_return_status <> fnd_api.g_ret_sts_success THEN

878: x_tqoh => l_tqoh,
879: x_stqoh => l_stqoh -- invConv change
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;

Line 889: RAISE fnd_api.g_exc_error;

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;
889: RAISE fnd_api.g_exc_error;
890: END IF;
891:
892: IF (l_debug = 1) THEN
893: print_debug('l_tqoh:'||l_tqoh||', l_stqoh='||l_stqoh);

Line 914: RAISE FND_API.G_EXC_ERROR;

910: print_debug('Cannot Find primary UOM');
911: END IF;
912: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_ERROR;
915: END;
916: END IF;
917:
918: IF (l_debug = 1) then

Line 941: RAISE FND_API.G_EXC_ERROR;

937: print_debug('Error converting l_transaction_quantity');
938: END IF;
939: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:
944: -- Bug 4094112 : Added the ELSE clause to the test to convert the QTY when >0
945: IF l_transaction_quantity < 0 THEN

Line 1002: RAISE FND_API.G_EXC_ERROR;

998: print_debug('Error converting l_available_quantity');
999: END IF;
1000: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1001: FND_MSG_PUB.ADD;
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: IF l_available_quantity < 0 THEN
1006: l_available_quantity := l_available_conv_quantity * (-1);

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: print_debug('Error converting l_avail_qoh');
1026: END IF;
1027: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: IF l_avail_qoh < 0 THEN
1033: l_avail_qoh := l_avail_qoh_conv_quantity * (-1);

Line 1056: RAISE FND_API.G_EXC_ERROR;

1052: print_debug('Error converting l_transaction_quantity');
1053: END IF;
1054: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1055: FND_MSG_PUB.ADD;
1056: RAISE FND_API.G_EXC_ERROR;
1057: END IF;
1058:
1059: IF l_transaction_quantity < 0 THEN
1060: l_transaction_quantity := l_transaction_conv_quantity * (-1);

Line 1094: WHEN fnd_api.g_exc_error THEN

1090: print_debug(' odab returning 1');
1091: END IF;
1092: RETURN 1;
1093: EXCEPTION
1094: WHEN fnd_api.g_exc_error THEN
1095: IF (l_debug = 1) THEN
1096: print_debug('fnd_api.g_exc_error');
1097: END IF;
1098: x_return_status := fnd_api.g_ret_sts_error;

Line 1096: print_debug('fnd_api.g_exc_error');

1092: RETURN 1;
1093: EXCEPTION
1094: WHEN fnd_api.g_exc_error THEN
1095: IF (l_debug = 1) THEN
1096: print_debug('fnd_api.g_exc_error');
1097: END IF;
1098: x_return_status := fnd_api.g_ret_sts_error;
1099: x_available_quantity := 0;
1100: x_available_onhand := 0;

Line 1098: x_return_status := fnd_api.g_ret_sts_error;

1094: WHEN fnd_api.g_exc_error THEN
1095: IF (l_debug = 1) THEN
1096: print_debug('fnd_api.g_exc_error');
1097: END IF;
1098: x_return_status := fnd_api.g_ret_sts_error;
1099: x_available_quantity := 0;
1100: x_available_onhand := 0;
1101: x_onhand_quantity := 0;
1102:

Line 1118: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1114: WHEN OTHERS THEN
1115: IF (l_debug = 1) THEN
1116: print_debug('Others error');
1117: END IF;
1118: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1119:
1120: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1121: THEN
1122: fnd_msg_pub.add_exc_msg

Line 1267: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1263: IS
1264:
1265: l_tree_id INTEGER := NULL;
1266: l_tree_mode NUMBER := NULL;
1267: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1268: l_msg_data VARCHAR2(2000) := NULL;
1269: l_msg_count NUMBER := NULL;
1270: l_is_revision_control BOOLEAN := FALSE;
1271: l_is_lot_control BOOLEAN := FALSE;

Line 1326: x_return_status := fnd_api.g_ret_sts_success;

1322: AND organization_id = org_id;
1323:
1324: l_demand_header_type NUMBER;
1325: BEGIN
1326: x_return_status := fnd_api.g_ret_sts_success;
1327:
1328: IF (l_debug = 1) then
1329: print_debug('Xact_qty Inputs Org='||p_organization_id||' itm='||p_inventory_item_id||
1330: ' RevCtrl='||p_revision_control||' LotCtrl='||p_lot_control||

Line 1416: RAISE FND_API.G_EXC_ERROR;

1412: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
1413: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
1414: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_ERROR;
1417: END IF;
1418: CLOSE get_item_details;
1419: END IF;
1420: -- invConv changes end.

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: print_debug('Cannot Find primary UOM');
1451: END IF;
1452: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');
1453: FND_MSG_PUB.ADD;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END;
1456: END IF;
1457:
1458:

Line 1479: RAISE FND_API.G_EXC_ERROR;

1475: print_debug('Error converting l_transaction_quantity');
1476: END IF;
1477: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_ERROR;
1480: END IF;
1481:
1482: -- Bug 4094112 : Added the ELSE clause in the test, in order to convert QTY when >0
1483: IF l_transaction_quantity < 0 THEN

Line 1538: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1534: p_lot_expiration_date => NULL,
1535: p_onhand_source => l_onhand_source
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;

Line 1545: RAISE fnd_api.g_exc_error;

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;
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);

Line 1562: p_init_msg_lst => fnd_api.g_true,

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,
1565: x_msg_data => l_msg_data,
1566: p_tree_id => l_tree_id,

Line 1586: p_call_for_form => fnd_api.g_true

1582: x_sqr => l_sqr, -- invConv change
1583: x_sqs => l_sqs, -- invConv change
1584: x_satt => l_satt, -- invConv change
1585: x_satr => l_satr, -- invConv change
1586: p_call_for_form => fnd_api.g_true
1587: );
1588:
1589: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1590: IF (l_debug = 1) then

Line 1589: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1585: x_satr => l_satr, -- invConv change
1586: p_call_for_form => fnd_api.g_true
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;

Line 1596: RAISE fnd_api.g_exc_error;

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;
1596: RAISE fnd_api.g_exc_error;
1597: END IF;
1598:
1599: IF (l_debug = 1) THEN
1600: print_debug('Primaries l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1612: p_init_msg_lst => fnd_api.g_true,

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,
1615: x_msg_data => l_msg_data,
1616: p_tree_id => l_tree_id,

Line 1636: p_call_for_form => fnd_api.g_true

1632: x_sqr => l_sqr, -- invConv change
1633: x_sqs => l_sqs, -- invConv change
1634: x_satt => l_satt, -- invConv change
1635: x_satr => l_satr, -- invConv change
1636: p_call_for_form => fnd_api.g_true
1637: );
1638:
1639: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1640: IF (l_debug = 1) then

Line 1639: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1635: x_satr => l_satr, -- invConv change
1636: p_call_for_form => fnd_api.g_true
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;

Line 1646: RAISE fnd_api.g_exc_error;

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;
1646: RAISE fnd_api.g_exc_error;
1647: END IF;
1648:
1649: IF (l_debug = 1) THEN
1650: print_debug('Primaries l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1662: p_init_msg_lst => fnd_api.g_true,

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,
1665: x_msg_data => l_msg_data,
1666: p_tree_id => l_tree_id,

Line 1686: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1682: x_satr => l_satr, -- invConv change
1683: p_transfer_subinventory_code => p_Transfer_Subinventory
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;

Line 1693: RAISE fnd_api.g_exc_error;

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;
1693: RAISE fnd_api.g_exc_error;
1694: END IF;
1695:
1696: IF (l_debug = 1) THEN
1697: print_debug('l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1716: p_init_msg_lst => fnd_api.g_true,

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,
1719: x_msg_data => l_msg_data,
1720: p_tree_id => l_tree_id,

Line 1740: p_call_for_form => fnd_api.g_true

1736: x_sqr => l_sqr, -- invConv change
1737: x_sqs => l_sqs, -- invConv change
1738: x_satt => l_satt, -- invConv change
1739: x_satr => l_satr, -- invConv change
1740: p_call_for_form => fnd_api.g_true
1741: );
1742:
1743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1744: IF (l_debug = 1) then

Line 1743: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1739: x_satr => l_satr, -- invConv change
1740: p_call_for_form => fnd_api.g_true
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;

Line 1750: RAISE fnd_api.g_exc_error;

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;
1750: RAISE fnd_api.g_exc_error;
1751: END IF;
1752:
1753: IF (l_debug = 1) THEN
1754: print_debug('Primaries l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1796: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1792: x_tqoh => l_tqoh,
1793: x_stqoh => l_stqoh -- invConv change
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;

Line 1803: RAISE fnd_api.g_exc_error;

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;
1803: RAISE fnd_api.g_exc_error;
1804: END IF;
1805:
1806: IF (l_debug = 1) THEN
1807: print_debug('l_tqoh:'||l_tqoh);

Line 1830: RAISE FND_API.G_EXC_ERROR;

1826: print_debug('Error converting l_available_quantity');
1827: END IF;
1828: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1829: FND_MSG_PUB.ADD;
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832:
1833: IF l_available_quantity < 0 THEN
1834: l_available_quantity := l_available_conv_quantity * (-1);

Line 1857: RAISE FND_API.G_EXC_ERROR;

1853: print_debug('Error converting l_avail_qoh');
1854: END IF;
1855: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1856: FND_MSG_PUB.ADD;
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;
1859:
1860: IF l_avail_qoh < 0 THEN
1861: l_avail_qoh := l_avail_qoh_conv_quantity * (-1);

Line 1884: RAISE FND_API.G_EXC_ERROR;

1880: print_debug('Error converting l_transaction_quantity');
1881: END IF;
1882: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1883: FND_MSG_PUB.ADD;
1884: RAISE FND_API.G_EXC_ERROR;
1885: END IF;
1886:
1887: IF l_transaction_quantity < 0 THEN
1888: l_transaction_quantity := l_transaction_conv_quantity * (-1);

Line 1916: WHEN fnd_api.g_exc_error THEN

1912:
1913: RETURN 1;
1914:
1915: EXCEPTION
1916: WHEN fnd_api.g_exc_error THEN
1917: IF (l_debug = 1) THEN
1918: print_debug('fnd_api.g_exc_error');
1919: END IF;
1920: x_return_status := fnd_api.g_ret_sts_error;

Line 1918: print_debug('fnd_api.g_exc_error');

1914:
1915: EXCEPTION
1916: WHEN fnd_api.g_exc_error THEN
1917: IF (l_debug = 1) THEN
1918: print_debug('fnd_api.g_exc_error');
1919: END IF;
1920: x_return_status := fnd_api.g_ret_sts_error;
1921: x_available_quantity := 0;
1922: x_available_onhand := 0;

Line 1920: x_return_status := fnd_api.g_ret_sts_error;

1916: WHEN fnd_api.g_exc_error THEN
1917: IF (l_debug = 1) THEN
1918: print_debug('fnd_api.g_exc_error');
1919: END IF;
1920: x_return_status := fnd_api.g_ret_sts_error;
1921: x_available_quantity := 0;
1922: x_available_onhand := 0;
1923: x_onhand_quantity := 0;
1924:

Line 1950: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1946: WHEN OTHERS THEN
1947: IF (l_debug = 1) THEN
1948: print_debug('Others error');
1949: END IF;
1950: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1951:
1952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1953: THEN
1954: fnd_msg_pub.add_exc_msg