DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_UE dependencies on FND_MESSAGE

Line 183: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_LOT_CTRL_OPTION');

179: RETURN 1;
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:

Line 190: -- FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SER_CTRL_OPTION');

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

Line 272: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_CREATE_TREE');

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;
274: RAISE fnd_api.g_exc_error;
275: END IF;
276:

Line 313: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');

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;
315: RAISE fnd_api.g_exc_error;
316: END IF;
317:

Line 350: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');

346: WHEN no_data_found THEN
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:

Line 373: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

369: IF l_available_conv_quantity < 0 THEN
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:

Line 400: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

396: IF l_onhand_conv_quantity < 0 THEN
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:

Line 736: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');

732: IF (get_item_details%NOTFOUND)
733: THEN
734: CLOSE get_item_details;
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;

Line 737: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);

733: THEN
734: CLOSE get_item_details;
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;

Line 738: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);

734: CLOSE get_item_details;
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;

Line 796: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_FIND_ROOTINFO');

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;
798: RAISE fnd_api.g_exc_error;
799: END IF;
800:

Line 839: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');

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;
841: RAISE fnd_api.g_exc_error;
842: END IF;
843:

Line 887: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_TOTAL_QOH');

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;
889: RAISE fnd_api.g_exc_error;
890: END IF;
891:

Line 912: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');

908: WHEN no_data_found THEN
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;

Line 939: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

935: IF l_transaction_conv_quantity < 0 THEN
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:

Line 1000: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

996: IF l_available_conv_quantity < 0 THEN
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:

Line 1027: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

1023: IF l_avail_qoh_conv_quantity < 0 THEN
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:

Line 1054: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

1050: IF l_transaction_conv_quantity < 0 THEN
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:

Line 1412: FND_MESSAGE.SET_NAME('INV', 'ITEM_NOTFOUND');

1408: IF (get_item_details%NOTFOUND)
1409: THEN
1410: CLOSE get_item_details;
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;

Line 1413: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);

1409: THEN
1410: CLOSE get_item_details;
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;

Line 1414: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_organization_id);

1410: CLOSE get_item_details;
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;

Line 1452: FND_MESSAGE.SET_NAME('INV', 'INV_NO_PRIMARY_UOM');

1448: WHEN no_data_found THEN
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;

Line 1477: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

1473: IF l_transaction_conv_quantity < 0 THEN
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:

Line 1543: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_FIND_ROOTINFO');

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;
1545: RAISE fnd_api.g_exc_error;
1546: END IF;
1547:

Line 1594: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');

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;
1596: RAISE fnd_api.g_exc_error;
1597: END IF;
1598:

Line 1644: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');

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;
1646: RAISE fnd_api.g_exc_error;
1647: END IF;
1648:

Line 1691: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_QUERY_TREE');

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;
1693: RAISE fnd_api.g_exc_error;
1694: END IF;
1695:

Line 1748: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_UPDATE_QUANTITIES');

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;
1750: RAISE fnd_api.g_exc_error;
1751: END IF;
1752:

Line 1801: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_GET_TOTAL_QOH');

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;
1803: RAISE fnd_api.g_exc_error;
1804: END IF;
1805:

Line 1828: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

1824: IF l_available_conv_quantity < 0 THEN
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:

Line 1855: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

1851: IF l_avail_qoh_conv_quantity < 0 THEN
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:

Line 1882: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_CANNOT_CONVERT');

1878: IF l_transaction_conv_quantity < 0 THEN
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: