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.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_pll_pricing_attr AS

1: PACKAGE BODY QP_Validate_pll_pricing_attr AS
2: /* $Header: QPXLPLAB.pls 120.9.12010000.2 2008/10/15 14:08:29 jputta ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Qp_Validate_pll_pricing_attr';

2: /* $Header: QPXLPLAB.pls 120.9.12010000.2 2008/10/15 14:08:29 jputta ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Qp_Validate_pll_pricing_attr';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 474: IF NOT QP_VALIDATE.Product_Uom(p_pricing_attr_rec.product_uom_code,

470: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
471: ( p_PRICING_ATTR_rec.product_uom_code <> p_old_PRICING_ATTR_rec.product_uom_code
472: OR
473: p_old_PRICING_ATTR_rec.product_uom_code IS NULL ) THEN
474: IF NOT QP_VALIDATE.Product_Uom(p_pricing_attr_rec.product_uom_code,
475: to_number(p_PRICING_ATTR_rec.product_attr_value),
476: p_PRICING_ATTR_rec.list_header_id) THEN
477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
478: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

Line 1343: IF NOT QP_Validate.Accumulate(p_PRICING_ATTR_rec.accumulate_flag) THEN

1339: ( p_PRICING_ATTR_rec.accumulate_flag <>
1340: p_old_PRICING_ATTR_rec.accumulate_flag OR
1341: p_old_PRICING_ATTR_rec.accumulate_flag IS NULL )
1342: THEN
1343: IF NOT QP_Validate.Accumulate(p_PRICING_ATTR_rec.accumulate_flag) THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: END IF;
1346: END IF;
1347:

Line 1353: IF NOT QP_Validate.Attribute_Grouping_No(p_PRICING_ATTR_rec.attribute_grouping_no) THEN

1349: ( p_PRICING_ATTR_rec.attribute_grouping_no <>
1350: p_old_PRICING_ATTR_rec.attribute_grouping_no OR
1351: p_old_PRICING_ATTR_rec.attribute_grouping_no IS NULL )
1352: THEN
1353: IF NOT QP_Validate.Attribute_Grouping_No(p_PRICING_ATTR_rec.attribute_grouping_no) THEN
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: END IF;
1356: END IF;
1357:

Line 1363: IF NOT QP_Validate.Created_By(p_PRICING_ATTR_rec.created_by) THEN

1359: ( p_PRICING_ATTR_rec.created_by <>
1360: p_old_PRICING_ATTR_rec.created_by OR
1361: p_old_PRICING_ATTR_rec.created_by IS NULL )
1362: THEN
1363: IF NOT QP_Validate.Created_By(p_PRICING_ATTR_rec.created_by) THEN
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365: END IF;
1366: END IF;
1367:

Line 1373: IF NOT QP_Validate.Creation_Date(p_PRICING_ATTR_rec.creation_date) THEN

1369: ( p_PRICING_ATTR_rec.creation_date <>
1370: p_old_PRICING_ATTR_rec.creation_date OR
1371: p_old_PRICING_ATTR_rec.creation_date IS NULL )
1372: THEN
1373: IF NOT QP_Validate.Creation_Date(p_PRICING_ATTR_rec.creation_date) THEN
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: END IF;
1376: END IF;
1377:

Line 1383: IF NOT QP_Validate.Excluder(p_PRICING_ATTR_rec.excluder_flag) THEN

1379: ( p_PRICING_ATTR_rec.excluder_flag <>
1380: p_old_PRICING_ATTR_rec.excluder_flag OR
1381: p_old_PRICING_ATTR_rec.excluder_flag IS NULL )
1382: THEN
1383: IF NOT QP_Validate.Excluder(p_PRICING_ATTR_rec.excluder_flag) THEN
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: END IF;
1386: END IF;
1387:

Line 1393: IF NOT QP_Validate.Last_Updated_By(p_PRICING_ATTR_rec.last_updated_by) THEN

1389: ( p_PRICING_ATTR_rec.last_updated_by <>
1390: p_old_PRICING_ATTR_rec.last_updated_by OR
1391: p_old_PRICING_ATTR_rec.last_updated_by IS NULL )
1392: THEN
1393: IF NOT QP_Validate.Last_Updated_By(p_PRICING_ATTR_rec.last_updated_by) THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: END IF;
1396: END IF;
1397:

Line 1403: IF NOT QP_Validate.Last_Update_Date(p_PRICING_ATTR_rec.last_update_date) THEN

1399: ( p_PRICING_ATTR_rec.last_update_date <>
1400: p_old_PRICING_ATTR_rec.last_update_date OR
1401: p_old_PRICING_ATTR_rec.last_update_date IS NULL )
1402: THEN
1403: IF NOT QP_Validate.Last_Update_Date(p_PRICING_ATTR_rec.last_update_date) THEN
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: END IF;
1406: END IF;
1407:

Line 1413: IF NOT QP_Validate.Last_Update_Login(p_PRICING_ATTR_rec.last_update_login) THEN

1409: ( p_PRICING_ATTR_rec.last_update_login <>
1410: p_old_PRICING_ATTR_rec.last_update_login OR
1411: p_old_PRICING_ATTR_rec.last_update_login IS NULL )
1412: THEN
1413: IF NOT QP_Validate.Last_Update_Login(p_PRICING_ATTR_rec.last_update_login) THEN
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: END IF;
1416: END IF;
1417:

Line 1423: IF NOT QP_Validate.List_Line(p_PRICING_ATTR_rec.list_line_id) THEN

1419: ( p_PRICING_ATTR_rec.list_line_id <>
1420: p_old_PRICING_ATTR_rec.list_line_id OR
1421: p_old_PRICING_ATTR_rec.list_line_id IS NULL )
1422: THEN
1423: IF NOT QP_Validate.List_Line(p_PRICING_ATTR_rec.list_line_id) THEN
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426: END IF;
1427:

Line 1433: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute) THEN

1429: ( p_PRICING_ATTR_rec.pricing_attribute <>
1430: p_old_PRICING_ATTR_rec.pricing_attribute OR
1431: p_old_PRICING_ATTR_rec.pricing_attribute IS NULL )
1432: THEN
1433: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute) THEN
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: END IF;
1436: END IF;
1437:

Line 1443: IF NOT QP_Validate.Pricing_Attribute_Context(p_PRICING_ATTR_rec.pricing_attribute_context) THEN

1439: ( p_PRICING_ATTR_rec.pricing_attribute_context <>
1440: p_old_PRICING_ATTR_rec.pricing_attribute_context OR
1441: p_old_PRICING_ATTR_rec.pricing_attribute_context IS NULL )
1442: THEN
1443: IF NOT QP_Validate.Pricing_Attribute_Context(p_PRICING_ATTR_rec.pricing_attribute_context) THEN
1444: x_return_status := FND_API.G_RET_STS_ERROR;
1445: END IF;
1446: END IF;
1447:

Line 1453: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute_id) THEN

1449: ( p_PRICING_ATTR_rec.pricing_attribute_id <>
1450: p_old_PRICING_ATTR_rec.pricing_attribute_id OR
1451: p_old_PRICING_ATTR_rec.pricing_attribute_id IS NULL )
1452: THEN
1453: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute_id) THEN
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: END IF;
1456: END IF;
1457:

Line 1464: IF NOT QP_Validate.From_Rltd_Modifier_Id(p_PRICING_ATTR_rec.from_rltd_modifier_id) THEN

1460: p_old_PRICING_ATTR_rec.from_rltd_modifier_id OR
1461: p_old_PRICING_ATTR_rec.from_rltd_modifier_id IS NULL )
1462: THEN
1463: /*
1464: IF NOT QP_Validate.From_Rltd_Modifier_Id(p_PRICING_ATTR_rec.from_rltd_modifier_id) THEN
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: END IF;
1467: */
1468: NULL;

Line 1477: IF NOT QP_Validate.Pricing_Attr_Value_From(p_PRICING_ATTR_rec.pricing_attr_value_from) THEN

1473: ( p_PRICING_ATTR_rec.pricing_attr_value_from <>
1474: p_old_PRICING_ATTR_rec.pricing_attr_value_from OR
1475: p_old_PRICING_ATTR_rec.pricing_attr_value_from IS NULL )
1476: THEN
1477: IF NOT QP_Validate.Pricing_Attr_Value_From(p_PRICING_ATTR_rec.pricing_attr_value_from) THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: END IF;
1480: END IF;
1481:

Line 1487: IF NOT QP_Validate.Pricing_Attr_Value_To(p_PRICING_ATTR_rec.pricing_attr_value_to) THEN

1483: ( p_PRICING_ATTR_rec.pricing_attr_value_to <>
1484: p_old_PRICING_ATTR_rec.pricing_attr_value_to OR
1485: p_old_PRICING_ATTR_rec.pricing_attr_value_to IS NULL )
1486: THEN
1487: IF NOT QP_Validate.Pricing_Attr_Value_To(p_PRICING_ATTR_rec.pricing_attr_value_to) THEN
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: END IF;
1490: END IF;
1491:

Line 1497: IF NOT QP_Validate.Product_Attribute(p_PRICING_ATTR_rec.product_attribute) THEN

1493: ( p_PRICING_ATTR_rec.product_attribute <>
1494: p_old_PRICING_ATTR_rec.product_attribute OR
1495: p_old_PRICING_ATTR_rec.product_attribute IS NULL )
1496: THEN
1497: IF NOT QP_Validate.Product_Attribute(p_PRICING_ATTR_rec.product_attribute) THEN
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: END IF;
1500: END IF;
1501:

Line 1507: IF NOT QP_Validate.Product_Attribute_Context(p_PRICING_ATTR_rec.product_attribute_context) THEN

1503: ( p_PRICING_ATTR_rec.product_attribute_context <>
1504: p_old_PRICING_ATTR_rec.product_attribute_context OR
1505: p_old_PRICING_ATTR_rec.product_attribute_context IS NULL )
1506: THEN
1507: IF NOT QP_Validate.Product_Attribute_Context(p_PRICING_ATTR_rec.product_attribute_context) THEN
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509: END IF;
1510: END IF;
1511:

Line 1517: IF NOT QP_Validate.Product_Attr_Value(p_PRICING_ATTR_rec.product_attr_value) THEN

1513: ( p_PRICING_ATTR_rec.product_attr_value <>
1514: p_old_PRICING_ATTR_rec.product_attr_value OR
1515: p_old_PRICING_ATTR_rec.product_attr_value IS NULL )
1516: THEN
1517: IF NOT QP_Validate.Product_Attr_Value(p_PRICING_ATTR_rec.product_attr_value) THEN
1518: x_return_status := FND_API.G_RET_STS_ERROR;
1519: END IF;
1520: END IF;
1521:

Line 1527: IF NOT QP_Validate.Product_Uom(p_PRICING_ATTR_rec.product_uom_code) THEN

1523: ( p_PRICING_ATTR_rec.product_uom_code <>
1524: p_old_PRICING_ATTR_rec.product_uom_code OR
1525: p_old_PRICING_ATTR_rec.product_uom_code IS NULL )
1526: THEN
1527: IF NOT QP_Validate.Product_Uom(p_PRICING_ATTR_rec.product_uom_code) THEN
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530: END IF;
1531:

Line 1537: IF NOT QP_Validate.Program_Application(p_PRICING_ATTR_rec.program_application_id) THEN

1533: ( p_PRICING_ATTR_rec.program_application_id <>
1534: p_old_PRICING_ATTR_rec.program_application_id OR
1535: p_old_PRICING_ATTR_rec.program_application_id IS NULL )
1536: THEN
1537: IF NOT QP_Validate.Program_Application(p_PRICING_ATTR_rec.program_application_id) THEN
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: END IF;
1540: END IF;
1541:

Line 1547: IF NOT QP_Validate.Program(p_PRICING_ATTR_rec.program_id) THEN

1543: ( p_PRICING_ATTR_rec.program_id <>
1544: p_old_PRICING_ATTR_rec.program_id OR
1545: p_old_PRICING_ATTR_rec.program_id IS NULL )
1546: THEN
1547: IF NOT QP_Validate.Program(p_PRICING_ATTR_rec.program_id) THEN
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: END IF;
1550: END IF;
1551:

Line 1557: IF NOT QP_Validate.Program_Update_Date(p_PRICING_ATTR_rec.program_update_date) THEN

1553: ( p_PRICING_ATTR_rec.program_update_date <>
1554: p_old_PRICING_ATTR_rec.program_update_date OR
1555: p_old_PRICING_ATTR_rec.program_update_date IS NULL )
1556: THEN
1557: IF NOT QP_Validate.Program_Update_Date(p_PRICING_ATTR_rec.program_update_date) THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: END IF;
1560: END IF;
1561:

Line 1567: IF NOT QP_Validate.Request(p_PRICING_ATTR_rec.request_id) THEN

1563: ( p_PRICING_ATTR_rec.request_id <>
1564: p_old_PRICING_ATTR_rec.request_id OR
1565: p_old_PRICING_ATTR_rec.request_id IS NULL )
1566: THEN
1567: IF NOT QP_Validate.Request(p_PRICING_ATTR_rec.request_id) THEN
1568: x_return_status := FND_API.G_RET_STS_ERROR;
1569: END IF;
1570: END IF;
1571:

Line 1577: IF NOT QP_Validate.comparison_operator(p_PRICING_ATTR_rec.comparison_operator_code) THEN

1573: ( p_PRICING_ATTR_rec.comparison_operator_code <>
1574: p_old_PRICING_ATTR_rec.comparison_operator_code OR
1575: p_old_PRICING_ATTR_rec.comparison_operator_code IS NULL )
1576: THEN
1577: IF NOT QP_Validate.comparison_operator(p_PRICING_ATTR_rec.comparison_operator_code) THEN
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579: END IF;
1580: END IF;
1581:

Line 1587: IF NOT QP_Validate.Pricing_Attribute_Datatype(p_PRICING_ATTR_rec.pricing_attribute_datatype) THEN

1583: ( p_PRICING_ATTR_rec.pricing_attribute_datatype <>
1584: p_old_PRICING_ATTR_rec.pricing_attribute_datatype OR
1585: p_old_PRICING_ATTR_rec.pricing_attribute_datatype IS NULL )
1586: THEN
1587: IF NOT QP_Validate.Pricing_Attribute_Datatype(p_PRICING_ATTR_rec.pricing_attribute_datatype) THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END IF;
1590: END IF;
1591:

Line 1597: IF NOT QP_Validate.product_attribute_datatype(p_PRICING_ATTR_rec.product_attribute_datatype) THEN

1593: ( p_PRICING_ATTR_rec.product_attribute_datatype <>
1594: p_old_PRICING_ATTR_rec.product_attribute_datatype OR
1595: p_old_PRICING_ATTR_rec.product_attribute_datatype IS NULL )
1596: THEN
1597: IF NOT QP_Validate.product_attribute_datatype(p_PRICING_ATTR_rec.product_attribute_datatype) THEN
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: END IF;
1600: END IF;
1601:

Line 1740: IF NOT QP_Validate.Desc_Flex( 'PRICING_ATTR' ) THEN

1736: */
1737:
1738: -- Validate descriptive flexfield.
1739:
1740: IF NOT QP_Validate.Desc_Flex( 'PRICING_ATTR' ) THEN
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: END IF;
1743:
1744: END IF;

Line 2093: END QP_Validate_pll_pricing_attr;

2089:
2090: END Check_Line_EffDates;
2091:
2092:
2093: END QP_Validate_pll_pricing_attr;