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.AHL_OSP_PO_PVT dependencies on FND_MESSAGE

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

714:
715: --dbms_output.put_line('Beginning Processing... ');
716: -- Validate OSP Order Id
717: IF (p_osp_order_id IS NULL OR p_osp_order_id = FND_API.G_MISS_NUM) THEN
718: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');
719: FND_MSG_PUB.ADD;
720: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
722: END IF;

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

725: ELSE
726: OPEN l_validate_osp_csr(p_osp_order_id);
727: FETCH l_validate_osp_csr INTO l_po_header_id;
728: IF (l_validate_osp_csr%NOTFOUND) THEN
729: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
730: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
731: FND_MSG_PUB.ADD;
732: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

726: OPEN l_validate_osp_csr(p_osp_order_id);
727: FETCH l_validate_osp_csr INTO l_po_header_id;
728: IF (l_validate_osp_csr%NOTFOUND) THEN
729: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
730: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
731: FND_MSG_PUB.ADD;
732: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
734: END IF;

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

741: END IF;
742: --dbms_output.put_line('OSP Order Id ' || p_osp_order_id || ' is already associated with PO ' || l_po_header_id);
743: -- No need to throw an exception
744: /*
745: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_HDR_ASSCTD');
746: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
747: FND_MSG_PUB.ADD;
748: CLOSE l_validate_osp_csr;
749: RAISE FND_API.G_EXC_ERROR;

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

742: --dbms_output.put_line('OSP Order Id ' || p_osp_order_id || ' is already associated with PO ' || l_po_header_id);
743: -- No need to throw an exception
744: /*
745: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_HDR_ASSCTD');
746: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
747: FND_MSG_PUB.ADD;
748: CLOSE l_validate_osp_csr;
749: RAISE FND_API.G_EXC_ERROR;
750: */

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

1271: l_cancel_flag VARCHAR2(1);
1272:
1273: BEGIN
1274: IF (p_po_header_id IS NULL OR p_po_header_id = FND_API.G_MISS_NUM) THEN
1275: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_NULL');
1276: FND_MSG_PUB.ADD;
1277: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1279: END IF;

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

1282: OPEN l_get_po_cstatus_csr(p_po_header_id);
1283: FETCH l_get_po_cstatus_csr INTO l_closed_status,l_cancel_flag;
1284: IF (l_get_po_cstatus_csr%NOTFOUND) THEN
1285: --Modified by mpothuku on 16-Nov-06 for fixing the Bug 5673483
1286: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_INVALID');
1287: FND_MESSAGE.Set_Token('PO_ID', p_po_header_id);
1288: FND_MSG_PUB.ADD;
1289: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1290: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1283: FETCH l_get_po_cstatus_csr INTO l_closed_status,l_cancel_flag;
1284: IF (l_get_po_cstatus_csr%NOTFOUND) THEN
1285: --Modified by mpothuku on 16-Nov-06 for fixing the Bug 5673483
1286: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_PO_ID_INVALID');
1287: FND_MESSAGE.Set_Token('PO_ID', p_po_header_id);
1288: FND_MSG_PUB.ADD;
1289: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1290: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1291: END IF;

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

1393: END IF;
1394:
1395: -- OSP Order Id
1396: IF (p_po_header_rec.OSP_ORDER_ID IS NULL OR p_po_header_rec.OSP_ORDER_ID = FND_API.G_MISS_NUM) THEN
1397: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');
1398: FND_MSG_PUB.ADD;
1399: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1401: END IF;

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

1402: ELSE
1403: OPEN l_validate_osp_csr(p_po_header_rec.OSP_ORDER_ID);
1404: FETCH l_validate_osp_csr INTO l_dummy;
1405: IF (l_validate_osp_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
1407: FND_MESSAGE.Set_Token('OSP_ID', p_po_header_rec.OSP_ORDER_ID);
1408: FND_MSG_PUB.ADD;
1409: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1410: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1403: OPEN l_validate_osp_csr(p_po_header_rec.OSP_ORDER_ID);
1404: FETCH l_validate_osp_csr INTO l_dummy;
1405: IF (l_validate_osp_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
1407: FND_MESSAGE.Set_Token('OSP_ID', p_po_header_rec.OSP_ORDER_ID);
1408: FND_MSG_PUB.ADD;
1409: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1410: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1411: END IF;

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

1414: END IF;
1415:
1416: -- Supplier
1417: IF (p_po_header_rec.VENDOR_ID IS NULL OR p_po_header_rec.VENDOR_ID = FND_API.G_MISS_NUM) THEN
1418: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPPLIER_ID_NULL');
1419: FND_MSG_PUB.ADD;
1420: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1421: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1422: END IF;

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

1423: ELSE
1424: OPEN l_validate_supplier_csr(p_po_header_rec.VENDOR_ID);
1425: FETCH l_validate_supplier_csr INTO l_dummy;
1426: IF (l_validate_supplier_csr%NOTFOUND) THEN
1427: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');
1428: FND_MESSAGE.Set_Token('SUPP_ID', p_po_header_rec.VENDOR_ID);
1429: FND_MSG_PUB.ADD;
1430: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1431: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1424: OPEN l_validate_supplier_csr(p_po_header_rec.VENDOR_ID);
1425: FETCH l_validate_supplier_csr INTO l_dummy;
1426: IF (l_validate_supplier_csr%NOTFOUND) THEN
1427: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');
1428: FND_MESSAGE.Set_Token('SUPP_ID', p_po_header_rec.VENDOR_ID);
1429: FND_MSG_PUB.ADD;
1430: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1431: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1432: END IF;

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

1435: END IF;
1436:
1437: -- Supplier Site
1438: IF (p_po_header_rec.VENDOR_SITE_ID IS NULL OR p_po_header_rec.VENDOR_SITE_ID = FND_API.G_MISS_NUM) THEN
1439: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_ID_NULL');
1440: FND_MSG_PUB.ADD;
1441: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1443: END IF;

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

1444: ELSE
1445: OPEN l_validate_supp_site_csr(p_po_header_rec.VENDOR_SITE_ID, p_po_header_rec.VENDOR_ID);
1446: FETCH l_validate_supp_site_csr INTO l_dummy;
1447: IF (l_validate_supp_site_csr%NOTFOUND) THEN
1448: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');
1449: FND_MESSAGE.Set_Token('SS_ID', p_po_header_rec.VENDOR_SITE_ID);
1450: FND_MSG_PUB.ADD;
1451: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1452: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1445: OPEN l_validate_supp_site_csr(p_po_header_rec.VENDOR_SITE_ID, p_po_header_rec.VENDOR_ID);
1446: FETCH l_validate_supp_site_csr INTO l_dummy;
1447: IF (l_validate_supp_site_csr%NOTFOUND) THEN
1448: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');
1449: FND_MESSAGE.Set_Token('SS_ID', p_po_header_rec.VENDOR_SITE_ID);
1450: FND_MSG_PUB.ADD;
1451: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1452: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1453: END IF;

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

1460: 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
1461: OPEN l_validate_vendor_contact_csr(p_po_header_rec.VENDOR_CONTACT_ID, p_po_header_rec.VENDOR_SITE_ID);
1462: FETCH l_validate_vendor_contact_csr INTO l_dummy;
1463: IF (l_validate_vendor_contact_csr%NOTFOUND) THEN
1464: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');
1465: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_header_rec.VENDOR_CONTACT_ID);
1466: FND_MSG_PUB.ADD;
1467: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1468: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1461: OPEN l_validate_vendor_contact_csr(p_po_header_rec.VENDOR_CONTACT_ID, p_po_header_rec.VENDOR_SITE_ID);
1462: FETCH l_validate_vendor_contact_csr INTO l_dummy;
1463: IF (l_validate_vendor_contact_csr%NOTFOUND) THEN
1464: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');
1465: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_header_rec.VENDOR_CONTACT_ID);
1466: FND_MSG_PUB.ADD;
1467: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1468: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1469: END IF;

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

1473: -- End Change for Inventory Service Order
1474:
1475: -- Buyer
1476: IF (p_po_header_rec.BUYER_ID IS NULL OR p_po_header_rec.BUYER_ID = FND_API.G_MISS_NUM) THEN
1477: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_ID_NULL');
1478: FND_MSG_PUB.ADD;
1479: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1480: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1481: END IF;

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

1482: ELSE
1483: OPEN l_validate_buyer_csr(p_po_header_rec.BUYER_ID);
1484: FETCH l_validate_buyer_csr INTO l_dummy;
1485: IF (l_validate_buyer_csr%NOTFOUND) THEN
1486: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');
1487: FND_MESSAGE.Set_Token('BUYER_ID', p_po_header_rec.BUYER_ID);
1488: FND_MSG_PUB.ADD;
1489: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1490: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1483: OPEN l_validate_buyer_csr(p_po_header_rec.BUYER_ID);
1484: FETCH l_validate_buyer_csr INTO l_dummy;
1485: IF (l_validate_buyer_csr%NOTFOUND) THEN
1486: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');
1487: FND_MESSAGE.Set_Token('BUYER_ID', p_po_header_rec.BUYER_ID);
1488: FND_MSG_PUB.ADD;
1489: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1490: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1491: END IF;

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

1536: -- Get the current Org
1537: l_org_id := MO_GLOBAL.get_current_org_id();
1538:
1539: IF (l_org_id IS NULL) THEN
1540: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
1541: FND_MSG_PUB.ADD;
1542: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
1544: END IF;

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

1547:
1548: --dbms_output.put_line('p_po_line_tbl.COUNT = ' || p_po_line_tbl.COUNT);
1549: -- Non zero count
1550: IF (p_po_line_tbl.COUNT = 0) THEN
1551: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NO_PO_LINES');
1552: FND_MSG_PUB.ADD;
1553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1554: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1555: END IF;

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

1564: -- OPEN l_validate_item_csr(p_po_line_tbl(i).ITEM_ID, l_org_id);
1565: OPEN l_validate_item_csr(p_po_line_tbl(i).ITEM_ID, p_po_line_tbl(i).SHIP_TO_ORG_ID);
1566: FETCH l_validate_item_csr INTO l_dummy;
1567: IF (l_validate_item_csr%NOTFOUND) THEN
1568: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');
1569: FND_MESSAGE.Set_Token('ITEM', p_po_line_tbl(i).ITEM_ID);
1570: FND_MSG_PUB.ADD;
1571: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1565: OPEN l_validate_item_csr(p_po_line_tbl(i).ITEM_ID, p_po_line_tbl(i).SHIP_TO_ORG_ID);
1566: FETCH l_validate_item_csr INTO l_dummy;
1567: IF (l_validate_item_csr%NOTFOUND) THEN
1568: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');
1569: FND_MESSAGE.Set_Token('ITEM', p_po_line_tbl(i).ITEM_ID);
1570: FND_MSG_PUB.ADD;
1571: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1573: END IF;

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

1575: CLOSE l_validate_item_csr;
1576: ELSE
1577: -- One-time Item: Description is mandatory
1578: 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
1579: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_IDESC_NULL');
1580: FND_MSG_PUB.ADD;
1581: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1583: END IF;

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

1583: END IF;
1584: END IF;
1585: -- One-time Item: UOM is mandatory
1586: 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
1587: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_UOM_CODE_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 1597: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_NULL');

1593: END IF;
1594:
1595: -- Quantity
1596: IF (p_po_line_tbl(i).QUANTITY IS NULL OR p_po_line_tbl(i).QUANTITY = FND_API.G_MISS_NUM) THEN
1597: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_NULL');
1598: FND_MSG_PUB.ADD;
1599: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1601: END IF;

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

1600: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1601: END IF;
1602: ELSE
1603: IF (p_po_line_tbl(i).QUANTITY <= 0) THEN
1604: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');
1605: FND_MESSAGE.Set_Token('QUANTITY', p_po_line_tbl(i).QUANTITY);
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);

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

1601: END IF;
1602: ELSE
1603: IF (p_po_line_tbl(i).QUANTITY <= 0) THEN
1604: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');
1605: FND_MESSAGE.Set_Token('QUANTITY', p_po_line_tbl(i).QUANTITY);
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 1615: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NEED_BY_DATE_NULL');

1611: END IF;
1612:
1613: -- Need By Date
1614: 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
1615: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NEED_BY_DATE_NULL');
1616: FND_MSG_PUB.ADD;
1617: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1619: END IF;

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

1618: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1619: END IF;
1620: ELSE
1621: IF (TRUNC(p_po_line_tbl(i).NEED_BY_DATE) < TRUNC(SYSDATE)) THEN
1622: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');
1623: FND_MESSAGE.Set_Token('NBDATE', p_po_line_tbl(i).NEED_BY_DATE);
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);

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

1619: END IF;
1620: ELSE
1621: IF (TRUNC(p_po_line_tbl(i).NEED_BY_DATE) < TRUNC(SYSDATE)) THEN
1622: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');
1623: FND_MESSAGE.Set_Token('NBDATE', p_po_line_tbl(i).NEED_BY_DATE);
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 1633: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_ORG_NULL');

1629: END IF;
1630:
1631: -- Ship To Organization
1632: 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
1633: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_ORG_NULL');
1634: FND_MSG_PUB.ADD;
1635: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1636: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1637: END IF;

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

1643: -- Need to check if this field is mandatory for PO creation.
1644: -- Ship To Location
1645: /***
1646: 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
1647: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_LOC_NULL');
1648: FND_MSG_PUB.ADD;
1649: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1650: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1651: END IF;

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

1652: END IF;
1653: ***/
1654: -- Line Type
1655: 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
1656: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_NULL');
1657: FND_MSG_PUB.ADD;
1658: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1660: END IF;

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

1661: ELSE
1662: OPEN l_validate_line_type_csr(p_po_line_tbl(i).PO_LINE_TYPE_ID);
1663: FETCH l_validate_line_type_csr INTO l_dummy;
1664: IF (l_validate_line_type_csr%NOTFOUND) THEN
1665: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');
1666: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_line_tbl(i).PO_LINE_TYPE_ID);
1667: FND_MSG_PUB.ADD;
1668: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1662: OPEN l_validate_line_type_csr(p_po_line_tbl(i).PO_LINE_TYPE_ID);
1663: FETCH l_validate_line_type_csr INTO l_dummy;
1664: IF (l_validate_line_type_csr%NOTFOUND) THEN
1665: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');
1666: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_line_tbl(i).PO_LINE_TYPE_ID);
1667: FND_MSG_PUB.ADD;
1668: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1670: END IF;

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

1757: END IF;
1758: END IF;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_CURRENCY_NOT_SET');
1762: FND_MSG_PUB.ADD;
1763: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1765: END IF;

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

2996: -- Retrieve the current record
2997: OPEN l_osp_line_dtls_csr(p_osp_order_line_id);
2998: FETCH l_osp_line_dtls_csr INTO l_osp_line_dtls_rec;
2999: IF (l_osp_line_dtls_csr%NOTFOUND) THEN
3000: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');
3001: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);
3002: FND_MSG_PUB.ADD;
3003: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3004: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

2997: OPEN l_osp_line_dtls_csr(p_osp_order_line_id);
2998: FETCH l_osp_line_dtls_csr INTO l_osp_line_dtls_rec;
2999: IF (l_osp_line_dtls_csr%NOTFOUND) THEN
3000: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');
3001: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);
3002: FND_MSG_PUB.ADD;
3003: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3004: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3005: END IF;

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

3132: -- Retrieve the current record
3133: OPEN l_osp_dtls_csr(p_osp_order_id);
3134: FETCH l_osp_dtls_csr INTO l_osp_dtls_rec;
3135: IF (l_osp_dtls_csr%NOTFOUND) THEN
3136: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
3137: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
3138: FND_MSG_PUB.ADD;
3139: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3140: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

3133: OPEN l_osp_dtls_csr(p_osp_order_id);
3134: FETCH l_osp_dtls_csr INTO l_osp_dtls_rec;
3135: IF (l_osp_dtls_csr%NOTFOUND) THEN
3136: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
3137: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
3138: FND_MSG_PUB.ADD;
3139: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3140: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3141: END IF;