DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on FND_MESSAGE

Line 726: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');

722:
723: --dbms_output.put_line('Beginning Processing... ');
724: -- Validate OSP Order Id
725: IF (p_osp_order_id IS NULL OR p_osp_order_id = FND_API.G_MISS_NUM) THEN
726: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');
727: FND_MSG_PUB.ADD;
728: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
730: END IF;

Line 737: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');

733: ELSE
734: OPEN l_validate_osp_csr(p_osp_order_id);
735: FETCH l_validate_osp_csr INTO l_po_header_id;
736: IF (l_validate_osp_csr%NOTFOUND) THEN
737: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
738: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
739: FND_MSG_PUB.ADD;
740: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 738: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);

734: OPEN l_validate_osp_csr(p_osp_order_id);
735: FETCH l_validate_osp_csr INTO l_po_header_id;
736: IF (l_validate_osp_csr%NOTFOUND) THEN
737: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
738: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
739: FND_MSG_PUB.ADD;
740: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
742: END IF;

Line 753: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_HDR_ASSCTD');

749: END IF;
750: --dbms_output.put_line('OSP Order Id ' || p_osp_order_id || ' is already associated with PO ' || l_po_header_id);
751: -- No need to throw an exception
752: /*
753: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_HDR_ASSCTD');
754: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
755: FND_MSG_PUB.ADD;
756: CLOSE l_validate_osp_csr;
757: RAISE FND_API.G_EXC_ERROR;

Line 754: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);

750: --dbms_output.put_line('OSP Order Id ' || p_osp_order_id || ' is already associated with PO ' || l_po_header_id);
751: -- No need to throw an exception
752: /*
753: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_HDR_ASSCTD');
754: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
755: FND_MSG_PUB.ADD;
756: CLOSE l_validate_osp_csr;
757: RAISE FND_API.G_EXC_ERROR;
758: */

Line 1283: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_NULL');

1279: l_cancel_flag VARCHAR2(1);
1280:
1281: BEGIN
1282: IF (p_po_header_id IS NULL OR p_po_header_id = FND_API.G_MISS_NUM) THEN
1283: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_NULL');
1284: FND_MSG_PUB.ADD;
1285: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1286: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1287: END IF;

Line 1294: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_INVALID');

1290: OPEN l_get_po_cstatus_csr(p_po_header_id);
1291: FETCH l_get_po_cstatus_csr INTO l_closed_status,l_cancel_flag;
1292: IF (l_get_po_cstatus_csr%NOTFOUND) THEN
1293: --Modified by mpothuku on 16-Nov-06 for fixing the Bug 5673483
1294: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_INVALID');
1295: FND_MESSAGE.Set_Token('PO_ID', p_po_header_id);
1296: FND_MSG_PUB.ADD;
1297: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1298: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1295: FND_MESSAGE.Set_Token('PO_ID', p_po_header_id);

1291: FETCH l_get_po_cstatus_csr INTO l_closed_status,l_cancel_flag;
1292: IF (l_get_po_cstatus_csr%NOTFOUND) THEN
1293: --Modified by mpothuku on 16-Nov-06 for fixing the Bug 5673483
1294: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_INVALID');
1295: FND_MESSAGE.Set_Token('PO_ID', p_po_header_id);
1296: FND_MSG_PUB.ADD;
1297: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1298: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1299: END IF;

Line 1405: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');

1401: END IF;
1402:
1403: -- OSP Order Id
1404: IF (p_po_header_rec.OSP_ORDER_ID IS NULL OR p_po_header_rec.OSP_ORDER_ID = FND_API.G_MISS_NUM) THEN
1405: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');
1406: FND_MSG_PUB.ADD;
1407: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1408: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1409: END IF;

Line 1414: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');

1410: ELSE
1411: OPEN l_validate_osp_csr(p_po_header_rec.OSP_ORDER_ID);
1412: FETCH l_validate_osp_csr INTO l_dummy;
1413: IF (l_validate_osp_csr%NOTFOUND) THEN
1414: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
1415: FND_MESSAGE.Set_Token('OSP_ID', p_po_header_rec.OSP_ORDER_ID);
1416: FND_MSG_PUB.ADD;
1417: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1418: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1415: FND_MESSAGE.Set_Token('OSP_ID', p_po_header_rec.OSP_ORDER_ID);

1411: OPEN l_validate_osp_csr(p_po_header_rec.OSP_ORDER_ID);
1412: FETCH l_validate_osp_csr INTO l_dummy;
1413: IF (l_validate_osp_csr%NOTFOUND) THEN
1414: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
1415: FND_MESSAGE.Set_Token('OSP_ID', p_po_header_rec.OSP_ORDER_ID);
1416: FND_MSG_PUB.ADD;
1417: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1418: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1419: END IF;

Line 1426: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPPLIER_ID_NULL');

1422: END IF;
1423:
1424: -- Supplier
1425: IF (p_po_header_rec.VENDOR_ID IS NULL OR p_po_header_rec.VENDOR_ID = FND_API.G_MISS_NUM) THEN
1426: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPPLIER_ID_NULL');
1427: FND_MSG_PUB.ADD;
1428: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1430: END IF;

Line 1435: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');

1431: ELSE
1432: OPEN l_validate_supplier_csr(p_po_header_rec.VENDOR_ID);
1433: FETCH l_validate_supplier_csr INTO l_dummy;
1434: IF (l_validate_supplier_csr%NOTFOUND) THEN
1435: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');
1436: FND_MESSAGE.Set_Token('SUPP_ID', p_po_header_rec.VENDOR_ID);
1437: FND_MSG_PUB.ADD;
1438: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1436: FND_MESSAGE.Set_Token('SUPP_ID', p_po_header_rec.VENDOR_ID);

1432: OPEN l_validate_supplier_csr(p_po_header_rec.VENDOR_ID);
1433: FETCH l_validate_supplier_csr INTO l_dummy;
1434: IF (l_validate_supplier_csr%NOTFOUND) THEN
1435: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');
1436: FND_MESSAGE.Set_Token('SUPP_ID', p_po_header_rec.VENDOR_ID);
1437: FND_MSG_PUB.ADD;
1438: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1440: END IF;

Line 1447: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_ID_NULL');

1443: END IF;
1444:
1445: -- Supplier Site
1446: IF (p_po_header_rec.VENDOR_SITE_ID IS NULL OR p_po_header_rec.VENDOR_SITE_ID = FND_API.G_MISS_NUM) THEN
1447: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_ID_NULL');
1448: FND_MSG_PUB.ADD;
1449: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1450: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1451: END IF;

Line 1456: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');

1452: ELSE
1453: OPEN l_validate_supp_site_csr(p_po_header_rec.VENDOR_SITE_ID, p_po_header_rec.VENDOR_ID);
1454: FETCH l_validate_supp_site_csr INTO l_dummy;
1455: IF (l_validate_supp_site_csr%NOTFOUND) THEN
1456: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');
1457: FND_MESSAGE.Set_Token('SS_ID', p_po_header_rec.VENDOR_SITE_ID);
1458: FND_MSG_PUB.ADD;
1459: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1457: FND_MESSAGE.Set_Token('SS_ID', p_po_header_rec.VENDOR_SITE_ID);

1453: OPEN l_validate_supp_site_csr(p_po_header_rec.VENDOR_SITE_ID, p_po_header_rec.VENDOR_ID);
1454: FETCH l_validate_supp_site_csr INTO l_dummy;
1455: IF (l_validate_supp_site_csr%NOTFOUND) THEN
1456: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');
1457: FND_MESSAGE.Set_Token('SS_ID', p_po_header_rec.VENDOR_SITE_ID);
1458: FND_MSG_PUB.ADD;
1459: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1461: END IF;

Line 1472: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');

1468: IF (p_po_header_rec.VENDOR_CONTACT_ID IS NOT NULL AND p_po_header_rec.VENDOR_CONTACT_ID <> FND_API.G_MISS_NUM) THEN
1469: OPEN l_validate_vendor_contact_csr(p_po_header_rec.VENDOR_CONTACT_ID, p_po_header_rec.VENDOR_SITE_ID);
1470: FETCH l_validate_vendor_contact_csr INTO l_dummy;
1471: IF (l_validate_vendor_contact_csr%NOTFOUND) THEN
1472: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');
1473: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_header_rec.VENDOR_CONTACT_ID);
1474: FND_MSG_PUB.ADD;
1475: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1476: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1473: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_header_rec.VENDOR_CONTACT_ID);

1469: OPEN l_validate_vendor_contact_csr(p_po_header_rec.VENDOR_CONTACT_ID, p_po_header_rec.VENDOR_SITE_ID);
1470: FETCH l_validate_vendor_contact_csr INTO l_dummy;
1471: IF (l_validate_vendor_contact_csr%NOTFOUND) THEN
1472: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');
1473: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_header_rec.VENDOR_CONTACT_ID);
1474: FND_MSG_PUB.ADD;
1475: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1476: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1477: END IF;

Line 1485: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_ID_NULL');

1481: -- End Change for Inventory Service Order
1482:
1483: -- Buyer
1484: IF (p_po_header_rec.BUYER_ID IS NULL OR p_po_header_rec.BUYER_ID = FND_API.G_MISS_NUM) THEN
1485: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_ID_NULL');
1486: FND_MSG_PUB.ADD;
1487: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1489: END IF;

Line 1494: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');

1490: ELSE
1491: OPEN l_validate_buyer_csr(p_po_header_rec.BUYER_ID);
1492: FETCH l_validate_buyer_csr INTO l_dummy;
1493: IF (l_validate_buyer_csr%NOTFOUND) THEN
1494: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');
1495: FND_MESSAGE.Set_Token('BUYER_ID', p_po_header_rec.BUYER_ID);
1496: FND_MSG_PUB.ADD;
1497: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1495: FND_MESSAGE.Set_Token('BUYER_ID', p_po_header_rec.BUYER_ID);

1491: OPEN l_validate_buyer_csr(p_po_header_rec.BUYER_ID);
1492: FETCH l_validate_buyer_csr INTO l_dummy;
1493: IF (l_validate_buyer_csr%NOTFOUND) THEN
1494: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');
1495: FND_MESSAGE.Set_Token('BUYER_ID', p_po_header_rec.BUYER_ID);
1496: FND_MSG_PUB.ADD;
1497: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1499: END IF;

Line 1548: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');

1544: -- Get the current Org
1545: l_org_id := MO_GLOBAL.get_current_org_id();
1546:
1547: IF (l_org_id IS NULL) THEN
1548: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
1549: FND_MSG_PUB.ADD;
1550: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1551: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
1552: END IF;

Line 1559: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NO_PO_LINES');

1555:
1556: --dbms_output.put_line('p_po_line_tbl.COUNT = ' || p_po_line_tbl.COUNT);
1557: -- Non zero count
1558: IF (p_po_line_tbl.COUNT = 0) THEN
1559: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NO_PO_LINES');
1560: FND_MSG_PUB.ADD;
1561: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1562: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1563: END IF;

Line 1576: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');

1572: -- OPEN l_validate_item_csr(p_po_line_tbl(i).ITEM_ID, l_org_id);
1573: OPEN l_validate_item_csr(p_po_line_tbl(i).ITEM_ID, p_po_line_tbl(i).SHIP_TO_ORG_ID);
1574: FETCH l_validate_item_csr INTO l_dummy;
1575: IF (l_validate_item_csr%NOTFOUND) THEN
1576: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');
1577: FND_MESSAGE.Set_Token('ITEM', p_po_line_tbl(i).ITEM_ID);
1578: FND_MSG_PUB.ADD;
1579: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1580: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1577: FND_MESSAGE.Set_Token('ITEM', p_po_line_tbl(i).ITEM_ID);

1573: OPEN l_validate_item_csr(p_po_line_tbl(i).ITEM_ID, p_po_line_tbl(i).SHIP_TO_ORG_ID);
1574: FETCH l_validate_item_csr INTO l_dummy;
1575: IF (l_validate_item_csr%NOTFOUND) THEN
1576: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');
1577: FND_MESSAGE.Set_Token('ITEM', p_po_line_tbl(i).ITEM_ID);
1578: FND_MSG_PUB.ADD;
1579: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1580: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1581: END IF;

Line 1587: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_IDESC_NULL');

1583: CLOSE l_validate_item_csr;
1584: ELSE
1585: -- One-time Item: Description is mandatory
1586: IF (TRIM(p_po_line_tbl(i).ITEM_DESCRIPTION) IS NULL OR p_po_line_tbl(i).ITEM_DESCRIPTION = FND_API.G_MISS_CHAR) THEN
1587: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_IDESC_NULL');
1588: FND_MSG_PUB.ADD;
1589: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1591: END IF;

Line 1595: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_UOM_CODE_NULL');

1591: END IF;
1592: END IF;
1593: -- One-time Item: UOM is mandatory
1594: IF (TRIM(p_po_line_tbl(i).UOM_CODE) IS NULL OR p_po_line_tbl(i).UOM_CODE = FND_API.G_MISS_CHAR) THEN
1595: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_UOM_CODE_NULL');
1596: FND_MSG_PUB.ADD;
1597: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1598: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1599: END IF;

Line 1605: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_NULL');

1601: END IF;
1602:
1603: -- Quantity
1604: IF (p_po_line_tbl(i).QUANTITY IS NULL OR p_po_line_tbl(i).QUANTITY = FND_API.G_MISS_NUM) THEN
1605: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_NULL');
1606: FND_MSG_PUB.ADD;
1607: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1609: END IF;

Line 1612: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');

1608: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1609: END IF;
1610: ELSE
1611: IF (p_po_line_tbl(i).QUANTITY <= 0) THEN
1612: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');
1613: FND_MESSAGE.Set_Token('QUANTITY', p_po_line_tbl(i).QUANTITY);
1614: FND_MSG_PUB.ADD;
1615: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1616: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1613: FND_MESSAGE.Set_Token('QUANTITY', p_po_line_tbl(i).QUANTITY);

1609: END IF;
1610: ELSE
1611: IF (p_po_line_tbl(i).QUANTITY <= 0) THEN
1612: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');
1613: FND_MESSAGE.Set_Token('QUANTITY', p_po_line_tbl(i).QUANTITY);
1614: FND_MSG_PUB.ADD;
1615: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1616: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1617: END IF;

Line 1623: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NEED_BY_DATE_NULL');

1619: END IF;
1620:
1621: -- Need By Date
1622: IF (p_po_line_tbl(i).NEED_BY_DATE IS NULL OR p_po_line_tbl(i).NEED_BY_DATE = FND_API.G_MISS_DATE) THEN
1623: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NEED_BY_DATE_NULL');
1624: FND_MSG_PUB.ADD;
1625: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1626: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1627: END IF;

Line 1630: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');

1626: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1627: END IF;
1628: ELSE
1629: IF (TRUNC(p_po_line_tbl(i).NEED_BY_DATE) < TRUNC(SYSDATE)) THEN
1630: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');
1631: FND_MESSAGE.Set_Token('NBDATE', p_po_line_tbl(i).NEED_BY_DATE);
1632: FND_MSG_PUB.ADD;
1633: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1634: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1631: FND_MESSAGE.Set_Token('NBDATE', p_po_line_tbl(i).NEED_BY_DATE);

1627: END IF;
1628: ELSE
1629: IF (TRUNC(p_po_line_tbl(i).NEED_BY_DATE) < TRUNC(SYSDATE)) THEN
1630: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');
1631: FND_MESSAGE.Set_Token('NBDATE', p_po_line_tbl(i).NEED_BY_DATE);
1632: FND_MSG_PUB.ADD;
1633: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1634: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1635: END IF;

Line 1641: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_ORG_NULL');

1637: END IF;
1638:
1639: -- Ship To Organization
1640: IF (p_po_line_tbl(i).SHIP_TO_ORG_ID IS NULL OR p_po_line_tbl(i).SHIP_TO_ORG_ID = FND_API.G_MISS_NUM) THEN
1641: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_ORG_NULL');
1642: FND_MSG_PUB.ADD;
1643: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1644: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1645: END IF;

Line 1655: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_LOC_NULL');

1651: -- Need to check if this field is mandatory for PO creation.
1652: -- Ship To Location
1653: /***
1654: IF (p_po_line_tbl(i).SHIP_TO_LOC_ID IS NULL OR p_po_line_tbl(i).SHIP_TO_LOC_ID = FND_API.G_MISS_NUM) THEN
1655: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_LOC_NULL');
1656: FND_MSG_PUB.ADD;
1657: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1658: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1659: END IF;

Line 1664: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_NULL');

1660: END IF;
1661: ***/
1662: -- Line Type
1663: IF (p_po_line_tbl(i).PO_LINE_TYPE_ID IS NULL OR p_po_line_tbl(i).PO_LINE_TYPE_ID = FND_API.G_MISS_NUM) THEN
1664: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_NULL');
1665: FND_MSG_PUB.ADD;
1666: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1668: END IF;

Line 1673: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');

1669: ELSE
1670: OPEN l_validate_line_type_csr(p_po_line_tbl(i).PO_LINE_TYPE_ID);
1671: FETCH l_validate_line_type_csr INTO l_dummy;
1672: IF (l_validate_line_type_csr%NOTFOUND) THEN
1673: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');
1674: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_line_tbl(i).PO_LINE_TYPE_ID);
1675: FND_MSG_PUB.ADD;
1676: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1674: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_line_tbl(i).PO_LINE_TYPE_ID);

1670: OPEN l_validate_line_type_csr(p_po_line_tbl(i).PO_LINE_TYPE_ID);
1671: FETCH l_validate_line_type_csr INTO l_dummy;
1672: IF (l_validate_line_type_csr%NOTFOUND) THEN
1673: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');
1674: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_line_tbl(i).PO_LINE_TYPE_ID);
1675: FND_MSG_PUB.ADD;
1676: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1678: END IF;

Line 1770: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_CURRENCY_NOT_SET');

1766: END IF;
1767: END IF;
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_CURRENCY_NOT_SET');
1771: FND_MSG_PUB.ADD;
1772: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1774: END IF;

Line 3033: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');

3029: -- Retrieve the current record
3030: OPEN l_osp_line_dtls_csr(p_osp_order_line_id);
3031: FETCH l_osp_line_dtls_csr INTO l_osp_line_dtls_rec;
3032: IF (l_osp_line_dtls_csr%NOTFOUND) THEN
3033: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');
3034: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);
3035: FND_MSG_PUB.ADD;
3036: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3037: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 3034: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);

3030: OPEN l_osp_line_dtls_csr(p_osp_order_line_id);
3031: FETCH l_osp_line_dtls_csr INTO l_osp_line_dtls_rec;
3032: IF (l_osp_line_dtls_csr%NOTFOUND) THEN
3033: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');
3034: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);
3035: FND_MSG_PUB.ADD;
3036: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3037: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3038: END IF;

Line 3169: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');

3165: -- Retrieve the current record
3166: OPEN l_osp_dtls_csr(p_osp_order_id);
3167: FETCH l_osp_dtls_csr INTO l_osp_dtls_rec;
3168: IF (l_osp_dtls_csr%NOTFOUND) THEN
3169: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
3170: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
3171: FND_MSG_PUB.ADD;
3172: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3173: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 3170: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);

3166: OPEN l_osp_dtls_csr(p_osp_order_id);
3167: FETCH l_osp_dtls_csr INTO l_osp_dtls_rec;
3168: IF (l_osp_dtls_csr%NOTFOUND) THEN
3169: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
3170: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
3171: FND_MSG_PUB.ADD;
3172: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3173: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3174: END IF;

Line 3418: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_FIGURE_LENGTH_INVALID'); -- Entered value for Figure exceeded the limit

3414: END IF;
3415:
3416: CLOSE chk_manual_PO_Numbering;
3417:
3418: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_FIGURE_LENGTH_INVALID'); -- Entered value for Figure exceeded the limit
3419: FND_MSG_PUB.ADD;
3420: RAISE;
3421: END;
3422: END IF;