[Home] [Help]
177: --DBMS_output.put_line('more params passed than needed');
178: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
179: fnd_message.set_token('CONTEXT', 'NULL');
180: fnd_message.set_token('ROUTINE', 'inv_uom_api_pub');
181: fnd_msg_pub.ADD;
182: RAISE fnd_api.g_exc_error;
183: END IF;
184:
185:
199: THEN
200: --DBMS_output.put_line('y r we here');
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
202: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: END IF;
206: ELSE
207: --DBMS_output.put_line('This segment is not required');
280: NOT p_attributes_tbl.EXISTS(col))
281: THEN
282: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
283: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
284: fnd_msg_pub.ADD;
285: RAISE fnd_api.g_exc_error;
286: --DBMS_output.put_line('Req segment is not populated');
287: END IF;
288: END IF;
356: WHILE e < 5001
357: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
358: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
359: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
360: FND_MSG_PUB.ADD;
361:
362: s := s + 200;
363: e := e + 200;
364: END LOOP;
363: e := e + 200;
364: END LOOP;
365:
366: ROLLBACK TO get_lot_attr_information;
367: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
368: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
369:
370: IF (L_DEBUG = 1) THEN
371: INV_LOG_UTIL.TRACE('errors_received exception:'||X_MSG_DATA, 'inv_uom_api_pub', '9');
364: END LOOP;
365:
366: ROLLBACK TO get_lot_attr_information;
367: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
368: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
369:
370: IF (L_DEBUG = 1) THEN
371: INV_LOG_UTIL.TRACE('errors_received exception:'||X_MSG_DATA, 'inv_uom_api_pub', '9');
372: END IF;
373:
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: ROLLBACK TO get_lot_attr_information;
377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: ROLLBACK TO get_lot_attr_information;
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: ROLLBACK TO get_lot_attr_information;
382: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: ROLLBACK TO get_lot_attr_information;
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: ROLLBACK TO get_lot_attr_information;
387: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
388:
389: END validate_attr_info;
390:
391: -----------------------------------------------
536: END IF;
537:
538: FND_MESSAGE.SET_NAME('INV', 'INV_DUP');
539: FND_MESSAGE.SET_TOKEN('VALUE1', P_UOM_CLASS);
540: FND_MSG_PUB.ADD;
541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
542:
543: RAISE FND_API.G_EXC_ERROR;
544: END IF; -- UOM class already exists.
553:
554: IF P_DISABLE_DATE IS NOT NULL AND TRUNC(P_DISABLE_DATE) < TRUNC(SYSDATE) THEN
555:
556: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
557: FND_MSG_PUB.ADD;
558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
559: RAISE FND_API.G_EXC_ERROR;
560:
561: END IF;
565:
566: -- FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
567: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
568: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UNIT_OF_MEASURE OR P_BASE_UOM_CODE');
569: FND_MSG_PUB.ADD;
570:
571: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
572: RAISE FND_API.G_EXC_ERROR;
573: -- The unit of measure and base uom code for this uom class need to be passed.
583: END IF;
584:
585: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
586: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UOM_CODE');
587: FND_MSG_PUB.ADD;
588:
589: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
590: RAISE FND_API.G_EXC_ERROR;
591:
614:
615: IF ( L_UNIT_OF_MEASURE IS NOT NULL) THEN
616: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
617: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
618: FND_MSG_PUB.ADD;
619: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
620: RAISE FND_API.G_EXC_ERROR;
621: -- Already unit of measure and uom code exists with some other class exists.
622: END IF;
639: IF ( L_UOM_CODE IS NOT NULL) THEN
640:
641: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
642: FND_MESSAGE.SET_TOKEN('VALUE1', L_UOM_CODE);
643: FND_MSG_PUB.ADD;
644: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
645: RAISE FND_API.G_EXC_ERROR;
646: -- Already unit of measure and uom code exists with some other class exists.
647: END IF;
665: INV_LOG_UTIL.TRACE('UOM Class does not exists', 'inv_uom_api_pub', '9');
666: END IF;
667:
668: -- FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND'); -- added now
669: -- FND_MSG_PUB.ADD;
670: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
671: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
672: FND_MSG_PUB.ADD;
673:
668: -- FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND'); -- added now
669: -- FND_MSG_PUB.ADD;
670: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
671: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
672: FND_MSG_PUB.ADD;
673:
674: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
675: RAISE fnd_api.g_exc_error;
676:
692: END IF;
693:
694: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
695: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UOM_CODE');
696: FND_MSG_PUB.ADD;
697:
698: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
699: RAISE FND_API.G_EXC_ERROR;
700:
710: INV_LOG_UTIL.TRACE('Disable date is past date', 'inv_uom_api_pub', '9');
711: END IF;
712:
713: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
714: FND_MSG_PUB.ADD;
715: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
716: RAISE FND_API.G_EXC_ERROR;
717:
718: END IF;
722:
723: -- FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
724: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
725: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UNIT_OF_MEASURE OR P_BASE_UOM_CODE');
726: FND_MSG_PUB.ADD;
727:
728: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
729: RAISE FND_API.G_EXC_ERROR;
730: -- The unit of measure and base uom code for this uom class need to be passed.
744: EXCEPTION
745: WHEN NO_DATA_FOUND THEN
746: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_COMB_MSG');
747: -- FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
748: FND_MSG_PUB.ADD;
749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
750: RAISE FND_API.G_EXC_ERROR;
751: END ;
752:
758: IF ( L_UNIT_OF_MEASURE IS NULL OR L_UOM_CODE IS NULL) THEN
759: -- DBMS_OUTPUT.PUT_LINE('unit of measure already exists');
760: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
761: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: RAISE FND_API.G_EXC_ERROR;
765: -- Already unit of measure and uom code exists with some other class exists.
766: END IF;
770: IF p_action_type NOT IN('U', 'I') THEN
771:
772: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
773: fnd_message.set_token('VALUE1', 'p_action_type');
774: FND_MSG_PUB.ADD;
775:
776: RAISE L_INVALID_OBJECT_TYPE;
777:
778: END IF;
1218: EXCEPTION
1219: WHEN L_INVALID_OBJECT_TYPE THEN
1220:
1221: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1222: FND_MSG_PUB.COUNT_AND_GET
1223: ( P_COUNT => X_MSG_COUNT
1224: , P_DATA => X_MSG_DATA
1225: );
1226:
1223: ( P_COUNT => X_MSG_COUNT
1224: , P_DATA => X_MSG_DATA
1225: );
1226:
1227: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1228:
1229: WHEN FND_API.G_EXC_ERROR THEN
1230: ROLLBACK;
1231: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1230: ROLLBACK;
1231: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1232:
1233: -- Get message count and data
1234: fnd_msg_pub.count_and_get
1235: ( p_count => x_msg_count
1236: , p_data => x_msg_data
1237: );
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: ROLLBACK;
1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1241:
1242: -- Get message count and data
1243: fnd_msg_pub.count_and_get
1244: ( p_count => x_msg_count
1245: , p_data => x_msg_data
1246: );
1247: WHEN OTHERS THEN
1248: ROLLBACK;
1249: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1250:
1251: -- Get message count and data
1252: fnd_msg_pub.count_and_get
1253: ( p_count => x_msg_count
1254: , P_DATA => X_MSG_DATA
1255: );
1256:
1368: -- The unit of measure and uom code are not base uom.
1369: ELSE
1370:
1371: -- FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1372: -- FND_MSG_PUB.ADD;
1373: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1374: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
1375: FND_MSG_PUB.ADD;
1376: L_BASE_UOM_FLAG := 'Y';
1371: -- FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1372: -- FND_MSG_PUB.ADD;
1373: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1374: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
1375: FND_MSG_PUB.ADD;
1376: L_BASE_UOM_FLAG := 'Y';
1377: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1378: RAISE FND_API.G_EXC_ERROR;
1379:
1390: END IF;
1391:
1392: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1393: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CODE');
1394: FND_MSG_PUB.ADD;
1395:
1396: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1397: RAISE FND_API.G_EXC_ERROR;
1398:
1406: IF P_UNIT_OF_MEASURE IS NULL THEN
1407:
1408: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1409: FND_MESSAGE.SET_TOKEN('UOM', 'P_UNIT_OF_MEASURE'); -- added now
1410: FND_MSG_PUB.ADD;
1411: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1412: RAISE FND_API.G_EXC_ERROR;
1413: -- The unit of measure and base uom code for this uom class need to be passed.
1414:
1417: IF P_UOM_CODE IS NULL THEN
1418:
1419: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1420: FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1421: FND_MSG_PUB.ADD;
1422: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1423: RAISE FND_API.G_EXC_ERROR;
1424: -- The unit of measure and base uom code for this uom class need to be passed.
1425:
1428:
1429: IF P_DISABLE_DATE IS NOT NULL AND TRUNC(P_DISABLE_DATE) < TRUNC(SYSDATE) THEN
1430:
1431: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
1432: FND_MSG_PUB.ADD;
1433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1434: RAISE FND_API.G_EXC_ERROR;
1435:
1436: END IF;
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
1450: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1451: -- FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1452: FND_MSG_PUB.ADD;
1453: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END ;
1456:
1468: and NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
1469: EXCEPTION
1470: WHEN NO_DATA_FOUND THEN
1471: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1472: FND_MSG_PUB.ADD;
1473: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1474: RAISE fnd_api.g_exc_error;
1475:
1476: end;
1480: IF P_UNIT_OF_MEASURE IS NULL THEN
1481:
1482: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1483: FND_MESSAGE.SET_TOKEN('UOM', 'P_UNIT_OF_MEASURE'); -- added now
1484: FND_MSG_PUB.ADD;
1485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1486: RAISE FND_API.G_EXC_ERROR;
1487: -- The unit of measure and base uom code for this uom class need to be passed.
1488:
1491: IF P_UOM_CODE IS NULL THEN
1492:
1493: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1494: FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1495: FND_MSG_PUB.ADD;
1496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1497: RAISE FND_API.G_EXC_ERROR;
1498: -- The unit of measure and base uom code for this uom class need to be passed.
1499:
1502:
1503: IF P_DISABLE_DATE IS NOT NULL AND TRUNC(P_DISABLE_DATE) < TRUNC(SYSDATE) THEN
1504:
1505: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
1506: FND_MSG_PUB.ADD;
1507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1508: RAISE FND_API.G_EXC_ERROR;
1509:
1510: END IF;
1534: --DBMS_OUTPUT.PUT_LINE('Raising exception');
1535:
1536: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
1537: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
1538: FND_MSG_PUB.ADD;
1539: RAISE FND_API.G_EXC_ERROR;
1540:
1541: --fnd_message.raise_error;
1542: -- Already unit of measure and uom code exists with some other class exists.
1718: ELSE
1719:
1720: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1721: fnd_message.set_token('VALUE1', 'p_action_type');
1722: FND_MSG_PUB.ADD;
1723: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1724:
1725: RAISE L_INVALID_OBJECT_TYPE;
1726:
1734:
1735: EXCEPTION
1736: WHEN L_INVALID_OBJECT_TYPE THEN
1737: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1738: FND_MSG_PUB.COUNT_AND_GET
1739: ( P_COUNT => X_MSG_COUNT
1740: , P_DATA => X_MSG_DATA
1741: );
1742:
1739: ( P_COUNT => X_MSG_COUNT
1740: , P_DATA => X_MSG_DATA
1741: );
1742:
1743: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1744: WHEN FND_API.G_EXC_ERROR THEN
1745:
1746: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1747:
1745:
1746: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1747:
1748: -- Get message count and data
1749: FND_MSG_PUB.COUNT_AND_GET
1750: ( P_COUNT => X_MSG_COUNT
1751: , P_DATA => X_MSG_DATA
1752: );
1753: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1749: FND_MSG_PUB.COUNT_AND_GET
1750: ( P_COUNT => X_MSG_COUNT
1751: , P_DATA => X_MSG_DATA
1752: );
1753: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1754:
1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1756:
1757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1756:
1757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: -- Get message count and data
1760: FND_MSG_PUB.COUNT_AND_GET
1761: ( P_COUNT => X_MSG_COUNT
1762: , P_DATA => X_MSG_DATA
1763: );
1764: WHEN OTHERS THEN
1762: , P_DATA => X_MSG_DATA
1763: );
1764: WHEN OTHERS THEN
1765: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1766: FND_MSG_PUB.COUNT_AND_GET
1767: ( P_COUNT => X_MSG_COUNT
1768: , P_DATA => X_MSG_DATA
1769: );
1770: END Unit_Of_Measure;
2020:
2021: IF (P_UOM_RATE IS NULL) THEN
2022:
2023: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_CONVRATE_REQUIRED');
2024: FND_MSG_PUB.ADD;
2025: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2026: RAISE L_INVALID_UOM_RATE;
2027:
2028: END IF;
2029:
2030: IF (P_UOM_RATE <= 0) THEN
2031:
2032: FND_MESSAGE.SET_NAME('INV', 'INV_NEG_CONV');
2033: FND_MSG_PUB.ADD;
2034: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2035: RAISE L_INVALID_UOM_RATE;
2036:
2037: END IF;
2042: INV_LOG_UTIL.TRACE('Disable date is past date', 'inv_uom_api_pub', '9');
2043: END IF;
2044:
2045: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
2046: FND_MSG_PUB.ADD;
2047: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2048: RAISE FND_API.G_EXC_ERROR;
2049:
2050: END IF;
2072:
2073: if l_qr > 0 then
2074:
2075: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_RSV_EXIST');
2076: FND_MSG_PUB.ADD;
2077: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2078: RAISE FND_API.G_EXC_ERROR;
2079: end if;
2080:
2181:
2182: FND_MESSAGE.SET_NAME('INV', 'INV_CONV_EXISTS');
2183: FND_MESSAGE.SET_TOKEN('VALUE1', P_FROM_UOM_CODE);
2184: fnd_message.set_token('VALUE2', P_TO_UOM_CODE);
2185: FND_MSG_PUB.ADD;
2186:
2187: RAISE L_CONVERSION_EXISTS_EXC;
2188: ELSIF X_RETURN_STATUS <> 'S' THEN
2189: RAISE FND_API.G_EXC_ERROR;
2265: ELSE
2266:
2267: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
2268: FND_MESSAGE.SET_TOKEN('VALUE1', 'p_action_type');
2269: FND_MSG_PUB.ADD;
2270: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2271:
2272: RAISE L_INVALID_OBJECT;
2273:
2282: WHERE ORGANIZATION_ID = P_ORG_ID;
2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: FND_MESSAGE.SET_NAME('INV', 'INV_INT_ORGCODE');
2286: FND_MSG_PUB.ADD;
2287: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2288: RAISE FND_API.G_EXC_ERROR;
2289: END;
2290:
2300: AND organization_id = p_org_id;
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME('INV', 'INV_INT_ITMCODE');
2304: FND_MSG_PUB.ADD;
2305: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2306: RAISE FND_API.G_EXC_ERROR;
2307:
2308: END;
2361: EXCEPTION
2362: WHEN NO_DATA_FOUND THEN
2363: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_BASE_UOM');
2364: fnd_message.set_token('UOM', P_FROM_UOM_CODE);
2365: FND_MSG_PUB.ADD;
2366: RAISE L_INVALID_BASE_UOM;
2367: END ;
2368:
2369: IF (L_DEBUG = 1) THEN
2386: END IF;
2387:
2388: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM_BASE');
2389: FND_MESSAGE.SET_TOKEN('VALUE', P_FROM_UOM_CODE);
2390: FND_MSG_PUB.ADD;
2391: raise l_invalid_base_uom;
2392: END;
2393:
2394: BEGIN
2401: EXCEPTION
2402: WHEN NO_DATA_FOUND THEN
2403: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_BASE_UOM');
2404: FND_MESSAGE.SET_TOKEN('UOM', P_TO_UOM_CODE);
2405: FND_MSG_PUB.ADD;
2406: RAISE L_INVALID_BASE_UOM;
2407: -- passed p_base_uom_code is not assosiated with any other uom class.
2408: END ;
2409:
2423: END IF;
2424:
2425: IF( v_lot_control_code = 1 ) THEN
2426: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_CTL_ERROR');
2427: FND_MSG_PUB.ADD;
2428: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2429: FND_MESSAGE.RAISE_ERROR;
2430: END IF;
2431:
2444: AND organization_id = p_org_id;
2445: EXCEPTION
2446: WHEN NO_DATA_FOUND THEN
2447: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_INVALID');
2448: FND_MSG_PUB.ADD;
2449: RAISE FND_API.G_EXC_ERROR;
2450: END ;
2451:
2452: -- End of Validating the passed lot valid with the same item.
2467: IF (L_DEBUG = 1) THEN
2468: INV_LOG_UTIL.TRACE('Lot expired' , 'inv_uom_api_pub', '9');
2469: END IF;
2470: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_EXPIRED');
2471: FND_MSG_PUB.ADD;
2472: RAISE FND_API.G_EXC_ERROR;
2473: END;
2474:
2475: END IF;
2502: END IF;
2503:
2504: IF (l_count > 0) THEN
2505: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_INUSE');
2506: FND_MSG_PUB.ADD;
2507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2508: FND_MESSAGE.RAISE_ERROR;
2509: END IF;
2510: -- End of Check if the lot uom conversion already present.
2511: -- From and to UOM cannot be the same.
2512:
2513: IF (p_from_uom_code = p_to_uom_code) THEN
2514: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_FROMTO_ERROR');
2515: FND_MSG_PUB.ADD;
2516: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2517: fnd_message.raise_error;
2518: END IF;
2519: -- End of From and to UOM cannot be the same.
2547: END IF;
2548:
2549: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
2550: fnd_message.set_token('VALUE1', 'p_action_type');
2551: FND_MSG_PUB.ADD;
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553:
2554: RAISE L_INVALID_OBJECT;
2555:
2567:
2568: EXCEPTION
2569: when no_data_found then
2570: FND_MESSAGE.SET_NAME('INV', 'INV_INT_REACODE');
2571: FND_MSG_PUB.ADD;
2572:
2573: IF (L_DEBUG = 1) THEN
2574: INV_LOG_UTIL.TRACE('NO data found for the reason id:'||P_REASON_ID, 'inv_uom_api_pub', '9');
2575: END IF;
2589: INV_LOG_UTIL.TRACE('Invalid Update type ', 'inv_uom_api_pub', '9');
2590: END IF;
2591:
2592: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UPDATETYPE_INVALID');
2593: FND_MSG_PUB.ADD;
2594:
2595: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2596: -- fnd_message.raise_error;
2597: RAISE FND_API.G_EXC_ERROR;
2603:
2604: IF (L_TRACKING_QUANTITY_IND <> 'PS') THEN
2605:
2606: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_TYPE0_ERROR');
2607: FND_MSG_PUB.ADD;
2608:
2609: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2610: FND_MESSAGE.RAISE_ERROR;
2611: -- Error if the item is not Dual Fixed or dual default.
2611: -- Error if the item is not Dual Fixed or dual default.
2612: ELSIF (L_SECONDARY_DEF_IND NOT IN ('F', 'D')) THEN
2613:
2614: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_TYPE3_ERROR');
2615: FND_MSG_PUB.ADD;
2616:
2617: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2618: FND_MESSAGE.RAISE_ERROR;
2619:
2636: END IF;
2637:
2638: CLOSE GET_NON_BATCH_TXNS;
2639: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_NON_BATCH');
2640: FND_MSG_PUB.ADD;
2641:
2642: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2643: RAISE FND_API.G_EXC_ERROR;
2644:
2686: IF (X_LAST_BATCH_ID <> X_BATCH_ID AND X_PHANTOM_ID IS NULL) THEN
2687:
2688: CLOSE GET_BATCH_INFO;
2689: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_MULT_BATCHES');
2690: FND_MSG_PUB.ADD;
2691:
2692: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2693: FND_MESSAGE.RAISE_ERROR;
2694:
2699: NULL;
2700: ELSE
2701: CLOSE GET_BATCH_INFO;
2702: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_INGREDIENT');
2703: FND_MSG_PUB.ADD;
2704:
2705: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2706: FND_MESSAGE.RAISE_ERROR;
2707:
2713:
2714: IF (X_OPM_COSTED_FLAG IS NULL) THEN
2715:
2716: FND_MESSAGE.SET_NAME('INV','INV_LOTCONV_INDITEM_COSTED');
2717: FND_MSG_PUB.ADD;
2718: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2719: FND_MESSAGE.RAISE_ERROR;
2720:
2721: END IF ;
2730:
2731: IF (X_ROW_COUNT = 0) THEN
2732:
2733: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_NO_BATCHES');
2734: FND_MSG_PUB.ADD;
2735:
2736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2737: FND_MESSAGE.RAISE_ERROR;
2738:
2743: -- DBMS_OUTPUT.PUT_LINE('X_BATCH_STATUS:'||X_BATCH_STATUS||' ..Do nothing..');
2744: NULL;
2745: ELSE
2746: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_INVALID_BATCH_STS');
2747: FND_MSG_PUB.ADD;
2748:
2749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2750: FND_MESSAGE.RAISE_ERROR;
2751:
2782: IF l_from_uom_class <> x_uom_class THEN
2783: IF x_uom_class <> x_sec_uom_class THEN
2784: CLOSE GET_MATL_LINES;
2785: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_UPD_WRNG_DTLUM_CLS');
2786: FND_MSG_PUB.ADD;
2787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2788: RAISE FND_API.G_EXC_ERROR;
2789:
2790: END IF;
2799:
2800: IF (L_TRACKING_QUANTITY_IND = 'P') THEN
2801:
2802: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_TYPE_NOT_ALLOWED');
2803: FND_MSG_PUB.ADD;
2804:
2805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2806: FND_MESSAGE.RAISE_ERROR;
2807:
2850:
2851: IF (X_CALC_QTY = - 99999) THEN
2852:
2853: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_CONV_FUNC');
2854: FND_MSG_PUB.ADD;
2855:
2856: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2857: FND_MESSAGE.RAISE_ERROR;
2858:
2873:
2874: IF (X_CALC_QTY = - 99999) THEN
2875:
2876: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_CONV_FUNC');
2877: FND_MSG_PUB.ADD;
2878:
2879: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2880: FND_MESSAGE.RAISE_ERROR;
2881:
2995:
2996: IF (L_RETURN_STATUS <> 'S') THEN
2997:
2998: FOR I IN 1..L_MSG_COUNT LOOP
2999: L_MSG_DATA := FND_MSG_PUB.GET(I, 'F');
3000: FND_MSG_PUB.ADD;
3001: FND_MESSAGE.RAISE_ERROR;
3002: END LOOP;
3003:
2996: IF (L_RETURN_STATUS <> 'S') THEN
2997:
2998: FOR I IN 1..L_MSG_COUNT LOOP
2999: L_MSG_DATA := FND_MSG_PUB.GET(I, 'F');
3000: FND_MSG_PUB.ADD;
3001: FND_MESSAGE.RAISE_ERROR;
3002: END LOOP;
3003:
3004: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3007:
3008: IF (L_QR > 0) THEN
3009:
3010: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_RSV_EXIST');
3011: FND_MSG_PUB.ADD;
3012: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3013: RAISE FND_API.G_EXC_ERROR;
3014:
3015: END IF;
3057: ELSIF P_ONHAND_UPDATE NOT IN (1, 2) THEN
3058:
3059: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
3060: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_ONHAND_UPDATE');
3061: FND_MSG_PUB.ADD;
3062:
3063: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3064:
3065: RAISE FND_API.G_EXC_ERROR;
3139: IF (l_return_status <> 'S') THEN
3140:
3141: FOR I IN 1..l_msg_count
3142: LOOP
3143: L_MSG_DATA := FND_MSG_PUB.GET(I, 'F');
3144: FND_MSG_PUB.ADD;
3145: fnd_message.raise_error;
3146: END LOOP;
3147:
3140:
3141: FOR I IN 1..l_msg_count
3142: LOOP
3143: L_MSG_DATA := FND_MSG_PUB.GET(I, 'F');
3144: FND_MSG_PUB.ADD;
3145: fnd_message.raise_error;
3146: END LOOP;
3147:
3148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3157:
3158: EXCEPTION
3159: WHEN L_INVALID_BASE_UOM THEN
3160: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3161: FND_MSG_PUB.COUNT_AND_GET
3162: ( P_COUNT => X_MSG_COUNT
3163: , P_DATA => X_MSG_DATA
3164: );
3165: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3161: FND_MSG_PUB.COUNT_AND_GET
3162: ( P_COUNT => X_MSG_COUNT
3163: , P_DATA => X_MSG_DATA
3164: );
3165: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3166:
3167: WHEN L_INVALID_REASON THEN
3168: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3169: FND_MSG_PUB.COUNT_AND_GET
3165: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3166:
3167: WHEN L_INVALID_REASON THEN
3168: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3169: FND_MSG_PUB.COUNT_AND_GET
3170: ( P_COUNT => X_MSG_COUNT
3171: , P_DATA => X_MSG_DATA
3172: );
3173: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3169: FND_MSG_PUB.COUNT_AND_GET
3170: ( P_COUNT => X_MSG_COUNT
3171: , P_DATA => X_MSG_DATA
3172: );
3173: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3174: WHEN L_INVALID_OBJECT THEN
3175:
3176: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3177: FND_MSG_PUB.COUNT_AND_GET
3173: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3174: WHEN L_INVALID_OBJECT THEN
3175:
3176: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3177: FND_MSG_PUB.COUNT_AND_GET
3178: ( P_COUNT => X_MSG_COUNT
3179: , P_DATA => X_MSG_DATA
3180: );
3181:
3178: ( P_COUNT => X_MSG_COUNT
3179: , P_DATA => X_MSG_DATA
3180: );
3181:
3182: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3183:
3184: /* WHEN L_INVALID_LOT THEN
3185:
3186: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_INVALID');
3183:
3184: /* WHEN L_INVALID_LOT THEN
3185:
3186: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_INVALID');
3187: FND_MSG_PUB.ADD;
3188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3189: FND_MSG_PUB.COUNT_AND_GET
3190: ( P_COUNT => X_MSG_COUNT
3191: , P_DATA => X_MSG_DATA
3185:
3186: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_INVALID');
3187: FND_MSG_PUB.ADD;
3188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3189: FND_MSG_PUB.COUNT_AND_GET
3190: ( P_COUNT => X_MSG_COUNT
3191: , P_DATA => X_MSG_DATA
3192: );
3193:
3190: ( P_COUNT => X_MSG_COUNT
3191: , P_DATA => X_MSG_DATA
3192: );
3193:
3194: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3195: */
3196: WHEN L_LOT_CONV_NOT_EXISTS THEN
3197:
3198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3195: */
3196: WHEN L_LOT_CONV_NOT_EXISTS THEN
3197:
3198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3199: FND_MSG_PUB.ADD;
3200: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3201:
3202: FND_MSG_PUB.COUNT_AND_GET
3203: ( P_COUNT => X_MSG_COUNT
3198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3199: FND_MSG_PUB.ADD;
3200: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3201:
3202: FND_MSG_PUB.COUNT_AND_GET
3203: ( P_COUNT => X_MSG_COUNT
3204: , P_DATA => X_MSG_DATA
3205: );
3206:
3203: ( P_COUNT => X_MSG_COUNT
3204: , P_DATA => X_MSG_DATA
3205: );
3206:
3207: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3208: -- X_MSG_DATA := 'Lot Conversion does not exists';
3209:
3210: WHEN L_PENDING_TRAN_EXISTS THEN
3211:
3209:
3210: WHEN L_PENDING_TRAN_EXISTS THEN
3211:
3212: FND_MESSAGE.SET_NAME('GMI', 'GMI_LOTCONV_PENDING_EXIST');
3213: FND_MSG_PUB.ADD;
3214: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3215: FND_MSG_PUB.COUNT_AND_GET
3216: ( P_COUNT => X_MSG_COUNT
3217: , P_DATA => X_MSG_DATA
3211:
3212: FND_MESSAGE.SET_NAME('GMI', 'GMI_LOTCONV_PENDING_EXIST');
3213: FND_MSG_PUB.ADD;
3214: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3215: FND_MSG_PUB.COUNT_AND_GET
3216: ( P_COUNT => X_MSG_COUNT
3217: , P_DATA => X_MSG_DATA
3218: );
3219:
3216: ( P_COUNT => X_MSG_COUNT
3217: , P_DATA => X_MSG_DATA
3218: );
3219:
3220: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3221:
3222: WHEN L_INVALID_UOM_RATE THEN
3223:
3224: ROLLBACK;
3223:
3224: ROLLBACK;
3225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3226: FND_MESSAGE.SET_NAME('INV', 'INV_NEG_CONV');
3227: FND_MSG_PUB.ADD;
3228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3229: FND_MSG_PUB.COUNT_AND_GET
3230: ( P_COUNT => X_MSG_COUNT
3231: , P_DATA => X_MSG_DATA
3225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3226: FND_MESSAGE.SET_NAME('INV', 'INV_NEG_CONV');
3227: FND_MSG_PUB.ADD;
3228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3229: FND_MSG_PUB.COUNT_AND_GET
3230: ( P_COUNT => X_MSG_COUNT
3231: , P_DATA => X_MSG_DATA
3232: );
3233:
3230: ( P_COUNT => X_MSG_COUNT
3231: , P_DATA => X_MSG_DATA
3232: );
3233:
3234: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3235:
3236: WHEN FND_API.G_EXC_ERROR THEN
3237:
3238: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3237:
3238: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3239:
3240: -- Get message count and data
3241: FND_MSG_PUB.COUNT_AND_GET
3242: ( P_COUNT => X_MSG_COUNT
3243: , P_DATA => X_MSG_DATA
3244: );
3245:
3242: ( P_COUNT => X_MSG_COUNT
3243: , P_DATA => X_MSG_DATA
3244: );
3245:
3246: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3247:
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3249:
3250: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3249:
3250: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3251:
3252: -- Get message count and data
3253: FND_MSG_PUB.COUNT_AND_GET
3254: ( P_COUNT => X_MSG_COUNT
3255: , P_DATA => X_MSG_DATA
3256: );
3257:
3257:
3258: WHEN L_INVALID_UOM_EXC THEN
3259:
3260: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
3261: FND_MSG_PUB.ADD;
3262: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3263: FND_MSG_PUB.COUNT_AND_GET
3264: ( P_COUNT => X_MSG_COUNT
3265: , P_DATA => X_MSG_DATA
3259:
3260: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
3261: FND_MSG_PUB.ADD;
3262: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3263: FND_MSG_PUB.COUNT_AND_GET
3264: ( P_COUNT => X_MSG_COUNT
3265: , P_DATA => X_MSG_DATA
3266: );
3267: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3263: FND_MSG_PUB.COUNT_AND_GET
3264: ( P_COUNT => X_MSG_COUNT
3265: , P_DATA => X_MSG_DATA
3266: );
3267: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3268:
3269: WHEN L_CONVERSION_EXISTS_EXC THEN
3270: X_RETURN_STATUS := L_RET_CONV_EXISTS_WARNING;
3271:
3268:
3269: WHEN L_CONVERSION_EXISTS_EXC THEN
3270: X_RETURN_STATUS := L_RET_CONV_EXISTS_WARNING;
3271:
3272: FND_MSG_PUB.COUNT_AND_GET
3273: ( P_COUNT => X_MSG_COUNT
3274: , P_DATA => X_MSG_DATA
3275: );
3276:
3273: ( P_COUNT => X_MSG_COUNT
3274: , P_DATA => X_MSG_DATA
3275: );
3276:
3277: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3278:
3279: WHEN L_INVALID_ITEM_EXC THEN
3280:
3281: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');
3278:
3279: WHEN L_INVALID_ITEM_EXC THEN
3280:
3281: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');
3282: FND_MSG_PUB.ADD;
3283: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3284: FND_MSG_PUB.COUNT_AND_GET
3285: ( P_COUNT => X_MSG_COUNT
3286: , P_DATA => X_MSG_DATA
3280:
3281: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');
3282: FND_MSG_PUB.ADD;
3283: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3284: FND_MSG_PUB.COUNT_AND_GET
3285: ( P_COUNT => X_MSG_COUNT
3286: , P_DATA => X_MSG_DATA
3287: );
3288:
3288:
3289: WHEN L_UOM_FROMTO_EXC THEN
3290:
3291: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_FROMTO_ERROR');
3292: FND_MSG_PUB.ADD;
3293: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3294: FND_MSG_PUB.COUNT_AND_GET
3295: ( P_COUNT => X_MSG_COUNT
3296: , P_DATA => X_MSG_DATA
3290:
3291: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_FROMTO_ERROR');
3292: FND_MSG_PUB.ADD;
3293: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3294: FND_MSG_PUB.COUNT_AND_GET
3295: ( P_COUNT => X_MSG_COUNT
3296: , P_DATA => X_MSG_DATA
3297: );
3298: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3294: FND_MSG_PUB.COUNT_AND_GET
3295: ( P_COUNT => X_MSG_COUNT
3296: , P_DATA => X_MSG_DATA
3297: );
3298: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3299:
3300: WHEN L_CONV_NOT_EXISTS THEN
3301:
3302: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3299:
3300: WHEN L_CONV_NOT_EXISTS THEN
3301:
3302: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3303: FND_MSG_PUB.ADD;
3304: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3305:
3306: FND_MSG_PUB.COUNT_AND_GET
3307: ( P_COUNT => X_MSG_COUNT
3302: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3303: FND_MSG_PUB.ADD;
3304: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3305:
3306: FND_MSG_PUB.COUNT_AND_GET
3307: ( P_COUNT => X_MSG_COUNT
3308: , P_DATA => X_MSG_DATA
3309: );
3310:
3307: ( P_COUNT => X_MSG_COUNT
3308: , P_DATA => X_MSG_DATA
3309: );
3310:
3311: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3312:
3313: WHEN OTHERS THEN
3314:
3315: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3312:
3313: WHEN OTHERS THEN
3314:
3315: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3316: FND_MSG_PUB.COUNT_AND_GET
3317: ( P_COUNT => X_MSG_COUNT
3318: , P_DATA => X_MSG_DATA
3319: );
3320: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3316: FND_MSG_PUB.COUNT_AND_GET
3317: ( P_COUNT => X_MSG_COUNT
3318: , P_DATA => X_MSG_DATA
3319: );
3320: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3321: END UOM_CONVERSION;
3322:
3323: END INV_UOM_API_PUB;