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_MSG_PUB

Line 200: FND_MSG_PUB.ADD;

196: END IF;
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.

Line 207: -- FND_MSG_PUB.ADD;

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

Line 289: FND_MSG_PUB.ADD;

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

Line 330: FND_MSG_PUB.ADD;

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;
331: RAISE fnd_api.g_exc_error;
332: END IF;
333:
334: IF (l_debug = 1) THEN

Line 367: FND_MSG_PUB.ADD;

363: IF (l_debug = 1) THEN
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

Line 390: FND_MSG_PUB.ADD;

386: IF (l_debug = 1) THEN
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

Line 417: FND_MSG_PUB.ADD;

413: IF (l_debug = 1) THEN
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

Line 458: fnd_msg_pub.count_and_get

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
459: ( p_count => x_message_count
460: , p_data => x_message_data
461: );
462:

Line 465: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));

461: );
462:
463: IF (l_debug = 1) THEN
464: FOR i IN 1 .. x_message_count LOOP
465: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
466: END LOOP;
467: END IF;
468:
469: RETURN 0;

Line 477: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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
480: ( 'INV_QUANTITY_TREE_UE'
481: ,'CREATE_TREE'

Line 479: fnd_msg_pub.add_exc_msg

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
480: ( 'INV_QUANTITY_TREE_UE'
481: ,'CREATE_TREE'
482: );
483: END IF;

Line 488: fnd_msg_pub.count_and_get

484:
485: x_available_quantity := 0;
486: x_onhand_quantity := 0;
487:
488: fnd_msg_pub.count_and_get
489: ( p_count => x_message_count
490: , p_data => x_message_data
491: );
492: IF (l_debug = 1) THEN

Line 494: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));

490: , p_data => x_message_data
491: );
492: IF (l_debug = 1) THEN
493: FOR i IN 1 .. x_message_count LOOP
494: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
495: END LOOP;
496: END IF;
497:
498: RETURN 0;

Line 781: FND_MSG_PUB.ADD;

777: -- The item doesn't exist under this organization.
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;

Line 839: FND_MSG_PUB.ADD;

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;
840: RAISE fnd_api.g_exc_error;
841: END IF;
842:
843: IF (l_debug = 1) then

Line 884: FND_MSG_PUB.ADD;

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;
885: RAISE fnd_api.g_exc_error;
886: END IF;
887:
888: IF (l_debug = 1) THEN

Line 932: FND_MSG_PUB.ADD;

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

Line 957: FND_MSG_PUB.ADD;

953: IF (l_debug = 1) then
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:

Line 986: FND_MSG_PUB.ADD;

982: IF (l_debug = 1) THEN
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

Line 1049: FND_MSG_PUB.ADD;

1045: IF (l_debug = 1) THEN
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

Line 1078: FND_MSG_PUB.ADD;

1074: IF (l_debug = 1) THEN
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

Line 1107: FND_MSG_PUB.ADD;

1103: IF (l_debug = 1) THEN
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

Line 1155: fnd_msg_pub.count_and_get

1151: x_available_quantity := 0;
1152: x_available_onhand := 0;
1153: x_onhand_quantity := 0;
1154:
1155: fnd_msg_pub.count_and_get
1156: ( p_count => x_message_count
1157: , p_data => x_message_data
1158: );
1159:

Line 1162: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));

1158: );
1159:
1160: IF (l_debug = 1) THEN
1161: FOR i IN 1 .. x_message_count LOOP
1162: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
1163: END LOOP;
1164: END IF;
1165: RETURN 0;
1166: WHEN OTHERS THEN

Line 1172: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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
1175: ( 'INV_QUANTITY_TREE_UE'
1176: ,'QUERY_TREE'

Line 1174: fnd_msg_pub.add_exc_msg

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
1175: ( 'INV_QUANTITY_TREE_UE'
1176: ,'QUERY_TREE'
1177: );
1178: END IF;

Line 1184: fnd_msg_pub.count_and_get

1180: x_available_quantity := 0;
1181: x_available_onhand := 0;
1182: x_onhand_quantity := 0;
1183:
1184: fnd_msg_pub.count_and_get
1185: ( p_count => x_message_count
1186: , p_data => x_message_data
1187: );
1188: IF (l_debug = 1) THEN

Line 1190: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));

1186: , p_data => x_message_data
1187: );
1188: IF (l_debug = 1) THEN
1189: FOR i IN 1 .. x_message_count LOOP
1190: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
1191: END LOOP;
1192: END IF;
1193: RETURN 0;
1194: END query_tree;

Line 1486: FND_MSG_PUB.ADD;

1482: -- The item doesn't exist under this organization.
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;

Line 1524: FND_MSG_PUB.ADD;

1520: IF (l_debug = 1) then
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:

Line 1551: FND_MSG_PUB.ADD;

1547: IF (l_debug = 1) THEN
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

Line 1617: FND_MSG_PUB.ADD;

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;
1618: RAISE fnd_api.g_exc_error;
1619: END IF;
1620:
1621: IF (l_debug = 1) then

Line 1669: FND_MSG_PUB.ADD;

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;
1670: RAISE fnd_api.g_exc_error;
1671: END IF;
1672:
1673: IF (l_debug = 1) THEN

Line 1720: FND_MSG_PUB.ADD;

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;
1721: RAISE fnd_api.g_exc_error;
1722: END IF;
1723:
1724: IF (l_debug = 1) THEN

Line 1768: FND_MSG_PUB.ADD;

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

Line 1826: FND_MSG_PUB.ADD;

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;
1827: RAISE fnd_api.g_exc_error;
1828: END IF;
1829:
1830: IF (l_debug = 1) THEN

Line 1880: FND_MSG_PUB.ADD;

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

Line 1909: FND_MSG_PUB.ADD;

1905: IF (l_debug = 1) THEN
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

Line 1938: FND_MSG_PUB.ADD;

1934: IF (l_debug = 1) THEN
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

Line 1967: FND_MSG_PUB.ADD;

1963: IF (l_debug = 1) THEN
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

Line 2018: fnd_msg_pub.count_and_get

2014: x_onhand_quantity2 := 0;
2015: END IF;
2016: -- invConv changes end.
2017:
2018: fnd_msg_pub.count_and_get
2019: ( p_count => x_message_count
2020: , p_data => x_message_data
2021: );
2022:

Line 2025: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));

2021: );
2022:
2023: IF (l_debug = 1) THEN
2024: FOR i IN 1 .. x_message_count LOOP
2025: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
2026: END LOOP;
2027: END IF;
2028:
2029: RETURN 0;

Line 2036: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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
2039: ( 'INV_QUANTITY_TREE_UE'
2040: ,'XACT_QTY'

Line 2038: fnd_msg_pub.add_exc_msg

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
2039: ( 'INV_QUANTITY_TREE_UE'
2040: ,'XACT_QTY'
2041: );
2042: END IF;

Line 2056: fnd_msg_pub.count_and_get

2052: x_onhand_quantity2 := 0;
2053: END IF;
2054: -- invConv changes end.
2055:
2056: fnd_msg_pub.count_and_get
2057: ( p_count => x_message_count
2058: , p_data => x_message_data
2059: );
2060:

Line 2063: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));

2059: );
2060:
2061: IF (l_debug = 1) THEN
2062: FOR i IN 1 .. x_message_count LOOP
2063: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
2064: END LOOP;
2065: END IF;
2066:
2067: RETURN 0;