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 184: FND_MSG_PUB.ADD;

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

Line 191: -- FND_MSG_PUB.ADD;

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

Line 273: FND_MSG_PUB.ADD;

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

Line 314: FND_MSG_PUB.ADD;

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;
315: RAISE fnd_api.g_exc_error;
316: END IF;
317:
318: IF (l_debug = 1) THEN

Line 351: FND_MSG_PUB.ADD;

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

Line 374: FND_MSG_PUB.ADD;

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

Line 401: FND_MSG_PUB.ADD;

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

Line 442: fnd_msg_pub.count_and_get

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
443: ( p_count => x_message_count
444: , p_data => x_message_data
445: );
446:

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

445: );
446:
447: IF (l_debug = 1) THEN
448: FOR i IN 1 .. x_message_count LOOP
449: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
450: END LOOP;
451: END IF;
452:
453: RETURN 0;

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

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
464: ( 'INV_QUANTITY_TREE_UE'
465: ,'CREATE_TREE'

Line 463: fnd_msg_pub.add_exc_msg

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
464: ( 'INV_QUANTITY_TREE_UE'
465: ,'CREATE_TREE'
466: );
467: END IF;

Line 472: fnd_msg_pub.count_and_get

468:
469: x_available_quantity := 0;
470: x_onhand_quantity := 0;
471:
472: fnd_msg_pub.count_and_get
473: ( p_count => x_message_count
474: , p_data => x_message_data
475: );
476: IF (l_debug = 1) THEN

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

474: , p_data => x_message_data
475: );
476: IF (l_debug = 1) THEN
477: FOR i IN 1 .. x_message_count LOOP
478: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
479: END LOOP;
480: END IF;
481:
482: RETURN 0;

Line 739: FND_MSG_PUB.ADD;

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

Line 797: FND_MSG_PUB.ADD;

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;
798: RAISE fnd_api.g_exc_error;
799: END IF;
800:
801: IF (l_debug = 1) then

Line 840: FND_MSG_PUB.ADD;

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

Line 888: FND_MSG_PUB.ADD;

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

Line 913: FND_MSG_PUB.ADD;

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

Line 940: FND_MSG_PUB.ADD;

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

Line 1001: FND_MSG_PUB.ADD;

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

Line 1028: FND_MSG_PUB.ADD;

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

Line 1055: FND_MSG_PUB.ADD;

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

Line 1103: fnd_msg_pub.count_and_get

1099: x_available_quantity := 0;
1100: x_available_onhand := 0;
1101: x_onhand_quantity := 0;
1102:
1103: fnd_msg_pub.count_and_get
1104: ( p_count => x_message_count
1105: , p_data => x_message_data
1106: );
1107:

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

1106: );
1107:
1108: IF (l_debug = 1) THEN
1109: FOR i IN 1 .. x_message_count LOOP
1110: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
1111: END LOOP;
1112: END IF;
1113: RETURN 0;
1114: WHEN OTHERS THEN

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

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
1123: ( 'INV_QUANTITY_TREE_UE'
1124: ,'QUERY_TREE'

Line 1122: fnd_msg_pub.add_exc_msg

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
1123: ( 'INV_QUANTITY_TREE_UE'
1124: ,'QUERY_TREE'
1125: );
1126: END IF;

Line 1132: fnd_msg_pub.count_and_get

1128: x_available_quantity := 0;
1129: x_available_onhand := 0;
1130: x_onhand_quantity := 0;
1131:
1132: fnd_msg_pub.count_and_get
1133: ( p_count => x_message_count
1134: , p_data => x_message_data
1135: );
1136: IF (l_debug = 1) THEN

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

1134: , p_data => x_message_data
1135: );
1136: IF (l_debug = 1) THEN
1137: FOR i IN 1 .. x_message_count LOOP
1138: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
1139: END LOOP;
1140: END IF;
1141: RETURN 0;
1142: END query_tree;

Line 1415: FND_MSG_PUB.ADD;

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

Line 1453: FND_MSG_PUB.ADD;

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

Line 1478: FND_MSG_PUB.ADD;

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

Line 1544: FND_MSG_PUB.ADD;

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;
1545: RAISE fnd_api.g_exc_error;
1546: END IF;
1547:
1548: IF (l_debug = 1) then

Line 1595: FND_MSG_PUB.ADD;

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;
1596: RAISE fnd_api.g_exc_error;
1597: END IF;
1598:
1599: IF (l_debug = 1) THEN

Line 1645: FND_MSG_PUB.ADD;

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;
1646: RAISE fnd_api.g_exc_error;
1647: END IF;
1648:
1649: IF (l_debug = 1) THEN

Line 1692: FND_MSG_PUB.ADD;

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

Line 1749: FND_MSG_PUB.ADD;

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;
1750: RAISE fnd_api.g_exc_error;
1751: END IF;
1752:
1753: IF (l_debug = 1) THEN

Line 1802: FND_MSG_PUB.ADD;

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

Line 1829: FND_MSG_PUB.ADD;

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

Line 1856: FND_MSG_PUB.ADD;

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

Line 1883: FND_MSG_PUB.ADD;

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

Line 1934: fnd_msg_pub.count_and_get

1930: x_onhand_quantity2 := 0;
1931: END IF;
1932: -- invConv changes end.
1933:
1934: fnd_msg_pub.count_and_get
1935: ( p_count => x_message_count
1936: , p_data => x_message_data
1937: );
1938:

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

1937: );
1938:
1939: IF (l_debug = 1) THEN
1940: FOR i IN 1 .. x_message_count LOOP
1941: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
1942: END LOOP;
1943: END IF;
1944:
1945: RETURN 0;

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

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
1955: ( 'INV_QUANTITY_TREE_UE'
1956: ,'XACT_QTY'

Line 1954: fnd_msg_pub.add_exc_msg

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
1955: ( 'INV_QUANTITY_TREE_UE'
1956: ,'XACT_QTY'
1957: );
1958: END IF;

Line 1972: fnd_msg_pub.count_and_get

1968: x_onhand_quantity2 := 0;
1969: END IF;
1970: -- invConv changes end.
1971:
1972: fnd_msg_pub.count_and_get
1973: ( p_count => x_message_count
1974: , p_data => x_message_data
1975: );
1976:

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

1975: );
1976:
1977: IF (l_debug = 1) THEN
1978: FOR i IN 1 .. x_message_count LOOP
1979: print_debug(fnd_msg_pub.get(x_message_count - i + 1, 'F'));
1980: END LOOP;
1981: END IF;
1982:
1983: RETURN 0;