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 FND_API

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

116: RETURN NUMBER
117: IS
118: l_tree_id INTEGER := NULL;
119: l_tree_mode NUMBER := NULL;
120: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
121: l_msg_data VARCHAR2(2000) := NULL;
122: l_msg_count NUMBER := NULL;
123: l_is_revision_control BOOLEAN := FALSE;
124: l_is_lot_control BOOLEAN := FALSE;

Line 167: x_return_status := fnd_api.g_ret_sts_success;

163: print_debug('DSName:'||p_demand_source_name||'DSLine:'||p_demand_source_line_id||
164: 'DSDel:'||p_demand_source_delivery||'RevAct:'||p_rev_active);
165: END IF;
166:
167: x_return_status := fnd_api.g_ret_sts_success;
168:
169: -- bug 4104123 : I don't know why the default of p_demand_header_type doesnt work.
170: l_demand_header_type := p_demand_header_type;
171: if p_demand_header_type IS NULL

Line 201: RAISE FND_API.G_EXC_ERROR;

197:
198: IF p_lot_control NOT IN (g_lot_control,g_no_lot_control) THEN
199: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_LOT_CTRL_OPTION');
200: FND_MSG_PUB.ADD;
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: -- invConv removed this test : serial_control can have other values.
205: -- IF p_serial_control NOT IN (g_serial_control,g_no_serial_control) THEN

Line 208: -- RAISE FND_API.G_EXC_ERROR;

204: -- invConv removed this test : serial_control can have other values.
205: -- IF p_serial_control NOT IN (g_serial_control,g_no_serial_control) THEN
206: -- FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SER_CTRL_OPTION');
207: -- FND_MSG_PUB.ADD;
208: -- RAISE FND_API.G_EXC_ERROR;
209: -- END IF;
210:
211: IF p_rev_active = g_no_rev_ctrl_please THEN
212: l_is_revision_control := FALSE;

Line 260: p_init_msg_lst => fnd_api.g_true,

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,
262: x_msg_count => l_msg_count,
263: x_msg_data => l_msg_data,
264: p_organization_id => p_organization_id,

Line 283: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 290: RAISE fnd_api.g_exc_error;

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;
290: RAISE fnd_api.g_exc_error;
291: END IF;
292:
293: IF (l_debug = 1) THEN
294: print_debug('Tree_id:'||l_tree_id);

Line 301: p_init_msg_lst => fnd_api.g_true,

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,
303: x_msg_count => l_msg_count,
304: x_msg_data => l_msg_data,
305: p_tree_id => l_tree_id,

Line 324: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 331: RAISE fnd_api.g_exc_error;

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;
331: RAISE fnd_api.g_exc_error;
332: END IF;
333:
334: IF (l_debug = 1) THEN
335: print_debug('Primary Qties : l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 368: RAISE FND_API.G_EXC_ERROR;

364: print_debug('Primary UOM not found');
365: END IF;
366: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');
367: FND_MSG_PUB.ADD;
368: RAISE FND_API.G_EXC_ERROR;
369: END;
370:
371: IF (l_debug = 1) THEN
372: print_debug('l_primary_uom_code'||l_primary_uom_code);

Line 391: RAISE FND_API.G_EXC_ERROR;

387: print_debug('Error converting l_available_quantity');
388: END IF;
389: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
390: FND_MSG_PUB.ADD;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: IF l_available_quantity < 0 THEN
395: l_available_quantity := 0 - l_available_conv_quantity;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: print_debug('Error converting l_onhand_quantity');
415: END IF;
416: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
417: FND_MSG_PUB.ADD;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: IF l_onhand_quantity < 0 THEN
422: l_onhand_quantity := 0 - l_onhand_conv_quantity;

Line 448: WHEN fnd_api.g_exc_error THEN

444:
445: RETURN 1;
446:
447: EXCEPTION
448: WHEN fnd_api.g_exc_error THEN
449:
450: IF (l_debug = 1) THEN
451: print_debug('fnd_api.g_exc_error');
452: END IF;

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

447: EXCEPTION
448: WHEN fnd_api.g_exc_error THEN
449:
450: IF (l_debug = 1) THEN
451: print_debug('fnd_api.g_exc_error');
452: END IF;
453:
454: x_return_status := fnd_api.g_ret_sts_error;
455: x_available_quantity := 0;

Line 454: x_return_status := fnd_api.g_ret_sts_error;

450: IF (l_debug = 1) THEN
451: print_debug('fnd_api.g_exc_error');
452: END IF;
453:
454: x_return_status := fnd_api.g_ret_sts_error;
455: x_available_quantity := 0;
456: x_onhand_quantity := 0;
457:
458: fnd_msg_pub.count_and_get

Line 475: x_return_status := fnd_api.g_ret_sts_unexp_error ;

471: WHEN OTHERS THEN
472: IF (l_debug = 1) THEN
473: print_debug('OTHERS error');
474: END IF;
475: x_return_status := fnd_api.g_ret_sts_unexp_error ;
476:
477: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
478: THEN
479: fnd_msg_pub.add_exc_msg

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

619: ) RETURN NUMBER
620: IS
621: l_tree_id INTEGER := NULL;
622: l_tree_mode NUMBER := NULL;
623: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
624: l_msg_data VARCHAR2(2000) := NULL;
625: l_msg_count NUMBER := NULL;
626: l_is_revision_control BOOLEAN := FALSE;
627: l_is_lot_control BOOLEAN := FALSE;

Line 706: x_return_status := fnd_api.g_ret_sts_success;

702: print_debug('... p_demand_header_type IS NOT NULL... ');
703: END IF;
704: END IF;
705:
706: x_return_status := fnd_api.g_ret_sts_success;
707:
708: IF p_activate <> 1 THEN
709: x_available_quantity := 0;
710: x_available_onhand := 0;

Line 782: RAISE FND_API.G_EXC_ERROR;

778: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
779: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
780: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784: CLOSE get_item_details;
785: END IF;
786: -- invConv changes end.

Line 833: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 840: RAISE fnd_api.g_exc_error;

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

Line 852: p_init_msg_lst => fnd_api.g_true,

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,
854: x_msg_count => l_msg_count,
855: x_msg_data => l_msg_data,
856: p_tree_id => l_tree_id,

Line 878: IF l_return_status <> fnd_api.g_ret_sts_success THEN

874: p_lpn_id => p_lpn_id, --added for bug7038890
875: p_transfer_locator_id => l_transfer_locator_id --Bug 14516283
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;

Line 885: RAISE fnd_api.g_exc_error;

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;
885: RAISE fnd_api.g_exc_error;
886: END IF;
887:
888: IF (l_debug = 1) THEN
889: print_debug('Primaries : l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 926: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 933: RAISE fnd_api.g_exc_error;

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;
933: RAISE fnd_api.g_exc_error;
934: END IF;
935:
936: IF (l_debug = 1) THEN
937: print_debug('l_tqoh:'||l_tqoh||', l_stqoh='||l_stqoh);

Line 958: RAISE FND_API.G_EXC_ERROR;

954: print_debug('Cannot Find primary UOM');
955: END IF;
956: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');
957: FND_MSG_PUB.ADD;
958: RAISE FND_API.G_EXC_ERROR;
959: END;
960: END IF;
961:
962: IF (l_debug = 1) then

Line 987: RAISE FND_API.G_EXC_ERROR;

983: print_debug('Error converting l_transaction_quantity');
984: END IF;
985: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
986: FND_MSG_PUB.ADD;
987: RAISE FND_API.G_EXC_ERROR;
988: END IF;
989:
990: -- Bug 4094112 : Added the ELSE clause to the test to convert the QTY when >0
991: IF l_transaction_quantity < 0 THEN

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: print_debug('Error converting l_available_quantity');
1047: END IF;
1048: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1049: FND_MSG_PUB.ADD;
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052:
1053: IF l_available_quantity < 0 THEN
1054: l_available_quantity := l_available_conv_quantity * (-1);

Line 1079: RAISE FND_API.G_EXC_ERROR;

1075: print_debug('Error converting l_avail_qoh');
1076: END IF;
1077: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1078: FND_MSG_PUB.ADD;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:
1082: IF l_avail_qoh < 0 THEN
1083: l_avail_qoh := l_avail_qoh_conv_quantity * (-1);

Line 1108: RAISE FND_API.G_EXC_ERROR;

1104: print_debug('Error converting l_transaction_quantity');
1105: END IF;
1106: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1107: FND_MSG_PUB.ADD;
1108: RAISE FND_API.G_EXC_ERROR;
1109: END IF;
1110:
1111: IF l_transaction_quantity < 0 THEN
1112: l_transaction_quantity := l_transaction_conv_quantity * (-1);

Line 1146: WHEN fnd_api.g_exc_error THEN

1142: print_debug(' odab returning 1');
1143: END IF;
1144: RETURN 1;
1145: EXCEPTION
1146: WHEN fnd_api.g_exc_error THEN
1147: IF (l_debug = 1) THEN
1148: print_debug('fnd_api.g_exc_error');
1149: END IF;
1150: x_return_status := fnd_api.g_ret_sts_error;

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

1144: RETURN 1;
1145: EXCEPTION
1146: WHEN fnd_api.g_exc_error THEN
1147: IF (l_debug = 1) THEN
1148: print_debug('fnd_api.g_exc_error');
1149: END IF;
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: x_available_quantity := 0;
1152: x_available_onhand := 0;

Line 1150: x_return_status := fnd_api.g_ret_sts_error;

1146: WHEN fnd_api.g_exc_error THEN
1147: IF (l_debug = 1) THEN
1148: print_debug('fnd_api.g_exc_error');
1149: END IF;
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: x_available_quantity := 0;
1152: x_available_onhand := 0;
1153: x_onhand_quantity := 0;
1154:

Line 1170: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1166: WHEN OTHERS THEN
1167: IF (l_debug = 1) THEN
1168: print_debug('Others error');
1169: END IF;
1170: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1171:
1172: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1173: THEN
1174: fnd_msg_pub.add_exc_msg

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

1327: IS
1328:
1329: l_tree_id INTEGER := NULL;
1330: l_tree_mode NUMBER := NULL;
1331: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1332: l_msg_data VARCHAR2(2000) := NULL;
1333: l_msg_count NUMBER := NULL;
1334: l_is_revision_control BOOLEAN := FALSE;
1335: l_is_lot_control BOOLEAN := FALSE;

Line 1390: x_return_status := fnd_api.g_ret_sts_success;

1386: AND organization_id = org_id;
1387:
1388: l_demand_header_type NUMBER;
1389: BEGIN
1390: x_return_status := fnd_api.g_ret_sts_success;
1391:
1392: IF (l_debug = 1) then
1393: print_debug('Xact_qty Inputs Org='||p_organization_id||' itm='||p_inventory_item_id||
1394: ' RevCtrl='||p_revision_control||' LotCtrl='||p_lot_control||

Line 1487: RAISE FND_API.G_EXC_ERROR;

1483: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');
1484: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
1485: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);
1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;
1489: CLOSE get_item_details;
1490: END IF;
1491: -- invConv changes end.

Line 1525: RAISE FND_API.G_EXC_ERROR;

1521: print_debug('Cannot Find primary UOM');
1522: END IF;
1523: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');
1524: FND_MSG_PUB.ADD;
1525: RAISE FND_API.G_EXC_ERROR;
1526: END;
1527: END IF;
1528:
1529:

Line 1552: RAISE FND_API.G_EXC_ERROR;

1548: print_debug('Error converting l_transaction_quantity');
1549: END IF;
1550: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: END IF;
1554:
1555: -- Bug 4094112 : Added the ELSE clause in the test, in order to convert QTY when >0
1556: IF l_transaction_quantity < 0 THEN

Line 1611: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1618: RAISE fnd_api.g_exc_error;

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

Line 1635: p_init_msg_lst => fnd_api.g_true,

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,
1638: x_msg_data => l_msg_data,
1639: p_tree_id => l_tree_id,

Line 1659: p_call_for_form => fnd_api.g_true,

1655: x_sqr => l_sqr, -- invConv change
1656: x_sqs => l_sqs, -- invConv change
1657: x_satt => l_satt, -- invConv change
1658: x_satr => l_satr, -- invConv change
1659: p_call_for_form => fnd_api.g_true,
1660: p_lpn_id =>p_lpn_id --added for bug7038890
1661: );
1662:
1663: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1663: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1659: p_call_for_form => fnd_api.g_true,
1660: p_lpn_id =>p_lpn_id --added for bug7038890
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;

Line 1670: RAISE fnd_api.g_exc_error;

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;
1670: RAISE fnd_api.g_exc_error;
1671: END IF;
1672:
1673: IF (l_debug = 1) THEN
1674: print_debug('Primaries l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1686: p_init_msg_lst => fnd_api.g_true,

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,
1689: x_msg_data => l_msg_data,
1690: p_tree_id => l_tree_id,

Line 1710: p_call_for_form => fnd_api.g_true,

1706: x_sqr => l_sqr, -- invConv change
1707: x_sqs => l_sqs, -- invConv change
1708: x_satt => l_satt, -- invConv change
1709: x_satr => l_satr, -- invConv change
1710: p_call_for_form => fnd_api.g_true,
1711: p_lpn_id =>p_lpn_id --added for bug7038890
1712: );
1713:
1714: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1714: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1710: p_call_for_form => fnd_api.g_true,
1711: p_lpn_id =>p_lpn_id --added for bug7038890
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;

Line 1721: RAISE fnd_api.g_exc_error;

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;
1721: RAISE fnd_api.g_exc_error;
1722: END IF;
1723:
1724: IF (l_debug = 1) THEN
1725: print_debug('Primaries l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1737: p_init_msg_lst => fnd_api.g_true,

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,
1740: x_msg_data => l_msg_data,
1741: p_tree_id => l_tree_id,

Line 1762: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1758: p_transfer_subinventory_code => p_Transfer_Subinventory,
1759: p_lpn_id => p_lpn_id --added for bug7038890
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;

Line 1769: RAISE fnd_api.g_exc_error;

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;
1769: RAISE fnd_api.g_exc_error;
1770: END IF;
1771:
1772: IF (l_debug = 1) THEN
1773: print_debug('l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1792: p_init_msg_lst => fnd_api.g_true,

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,
1795: x_msg_data => l_msg_data,
1796: p_tree_id => l_tree_id,

Line 1816: p_call_for_form => fnd_api.g_true,

1812: x_sqr => l_sqr, -- invConv change
1813: x_sqs => l_sqs, -- invConv change
1814: x_satt => l_satt, -- invConv change
1815: x_satr => l_satr, -- invConv change
1816: p_call_for_form => fnd_api.g_true,
1817: p_lpn_id => p_lpn_id --added for bug7038890
1818: );
1819:
1820: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1820: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1816: p_call_for_form => fnd_api.g_true,
1817: p_lpn_id => p_lpn_id --added for bug7038890
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;

Line 1827: RAISE fnd_api.g_exc_error;

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;
1827: RAISE fnd_api.g_exc_error;
1828: END IF;
1829:
1830: IF (l_debug = 1) THEN
1831: print_debug('Primaries l_qoh:'||l_qoh||'l_rqoh:'||l_rqoh||'l_qr:'||l_qr||

Line 1874: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1870: x_stqoh => l_stqoh, -- invConv change
1871: p_lpn_id => p_lpn_id --added for bug7038890
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;

Line 1881: RAISE fnd_api.g_exc_error;

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;
1881: RAISE fnd_api.g_exc_error;
1882: END IF;
1883:
1884: IF (l_debug = 1) THEN
1885: print_debug('l_tqoh:'||l_tqoh);

Line 1910: RAISE FND_API.G_EXC_ERROR;

1906: print_debug('Error converting l_available_quantity');
1907: END IF;
1908: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1909: FND_MSG_PUB.ADD;
1910: RAISE FND_API.G_EXC_ERROR;
1911: END IF;
1912:
1913: IF l_available_quantity < 0 THEN
1914: l_available_quantity := l_available_conv_quantity * (-1);

Line 1939: RAISE FND_API.G_EXC_ERROR;

1935: print_debug('Error converting l_avail_qoh');
1936: END IF;
1937: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1941:
1942: IF l_avail_qoh < 0 THEN
1943: l_avail_qoh := l_avail_qoh_conv_quantity * (-1);

Line 1968: RAISE FND_API.G_EXC_ERROR;

1964: print_debug('Error converting l_transaction_quantity');
1965: END IF;
1966: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');
1967: FND_MSG_PUB.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970:
1971: IF l_transaction_quantity < 0 THEN
1972: l_transaction_quantity := l_transaction_conv_quantity * (-1);

Line 2000: WHEN fnd_api.g_exc_error THEN

1996:
1997: RETURN 1;
1998:
1999: EXCEPTION
2000: WHEN fnd_api.g_exc_error THEN
2001: IF (l_debug = 1) THEN
2002: print_debug('fnd_api.g_exc_error');
2003: END IF;
2004: x_return_status := fnd_api.g_ret_sts_error;

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

1998:
1999: EXCEPTION
2000: WHEN fnd_api.g_exc_error THEN
2001: IF (l_debug = 1) THEN
2002: print_debug('fnd_api.g_exc_error');
2003: END IF;
2004: x_return_status := fnd_api.g_ret_sts_error;
2005: x_available_quantity := 0;
2006: x_available_onhand := 0;

Line 2004: x_return_status := fnd_api.g_ret_sts_error;

2000: WHEN fnd_api.g_exc_error THEN
2001: IF (l_debug = 1) THEN
2002: print_debug('fnd_api.g_exc_error');
2003: END IF;
2004: x_return_status := fnd_api.g_ret_sts_error;
2005: x_available_quantity := 0;
2006: x_available_onhand := 0;
2007: x_onhand_quantity := 0;
2008:

Line 2034: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2030: WHEN OTHERS THEN
2031: IF (l_debug = 1) THEN
2032: print_debug('Others error');
2033: END IF;
2034: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2035:
2036: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2037: THEN
2038: fnd_msg_pub.add_exc_msg