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.6 2009/12/15 09:14:20 kdurgasi 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.6 2009/12/15 09:14:20 kdurgasi 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 412: if NOT( Qp_Validate_pll_pricing_attr.Check_Dup_Pra (l_start_date_active,

408: OE_Debug_Pub.add ( 'smbalara :: Value Set 1' || l_start_date_active || l_end_date_active );
409:
410: OE_Debug_Pub.add ( 'smbalara :: Value Set 2' || l_revision );
411:
412: if NOT( Qp_Validate_pll_pricing_attr.Check_Dup_Pra (l_start_date_active,
413: l_end_date_active,
414: l_revision,
415: p_PRICING_ATTR_rec.list_line_id ,
416: l_list_header_id ,

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

527: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
528: ( p_PRICING_ATTR_rec.product_uom_code <> p_old_PRICING_ATTR_rec.product_uom_code
529: OR
530: p_old_PRICING_ATTR_rec.product_uom_code IS NULL ) THEN
531: IF NOT QP_VALIDATE.Product_Uom(p_pricing_attr_rec.product_uom_code,
532: to_number(p_PRICING_ATTR_rec.product_attr_value),
533: p_PRICING_ATTR_rec.list_header_id) THEN
534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
535: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

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

1396: ( p_PRICING_ATTR_rec.accumulate_flag <>
1397: p_old_PRICING_ATTR_rec.accumulate_flag OR
1398: p_old_PRICING_ATTR_rec.accumulate_flag IS NULL )
1399: THEN
1400: IF NOT QP_Validate.Accumulate(p_PRICING_ATTR_rec.accumulate_flag) THEN
1401: x_return_status := FND_API.G_RET_STS_ERROR;
1402: END IF;
1403: END IF;
1404:

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

1406: ( p_PRICING_ATTR_rec.attribute_grouping_no <>
1407: p_old_PRICING_ATTR_rec.attribute_grouping_no OR
1408: p_old_PRICING_ATTR_rec.attribute_grouping_no IS NULL )
1409: THEN
1410: IF NOT QP_Validate.Attribute_Grouping_No(p_PRICING_ATTR_rec.attribute_grouping_no) THEN
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: END IF;
1413: END IF;
1414:

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

1416: ( p_PRICING_ATTR_rec.created_by <>
1417: p_old_PRICING_ATTR_rec.created_by OR
1418: p_old_PRICING_ATTR_rec.created_by IS NULL )
1419: THEN
1420: IF NOT QP_Validate.Created_By(p_PRICING_ATTR_rec.created_by) THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: END IF;
1423: END IF;
1424:

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

1426: ( p_PRICING_ATTR_rec.creation_date <>
1427: p_old_PRICING_ATTR_rec.creation_date OR
1428: p_old_PRICING_ATTR_rec.creation_date IS NULL )
1429: THEN
1430: IF NOT QP_Validate.Creation_Date(p_PRICING_ATTR_rec.creation_date) THEN
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432: END IF;
1433: END IF;
1434:

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

1436: ( p_PRICING_ATTR_rec.excluder_flag <>
1437: p_old_PRICING_ATTR_rec.excluder_flag OR
1438: p_old_PRICING_ATTR_rec.excluder_flag IS NULL )
1439: THEN
1440: IF NOT QP_Validate.Excluder(p_PRICING_ATTR_rec.excluder_flag) THEN
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: END IF;
1443: END IF;
1444:

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

1446: ( p_PRICING_ATTR_rec.last_updated_by <>
1447: p_old_PRICING_ATTR_rec.last_updated_by OR
1448: p_old_PRICING_ATTR_rec.last_updated_by IS NULL )
1449: THEN
1450: IF NOT QP_Validate.Last_Updated_By(p_PRICING_ATTR_rec.last_updated_by) THEN
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452: END IF;
1453: END IF;
1454:

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

1456: ( p_PRICING_ATTR_rec.last_update_date <>
1457: p_old_PRICING_ATTR_rec.last_update_date OR
1458: p_old_PRICING_ATTR_rec.last_update_date IS NULL )
1459: THEN
1460: IF NOT QP_Validate.Last_Update_Date(p_PRICING_ATTR_rec.last_update_date) THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: END IF;
1463: END IF;
1464:

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

1466: ( p_PRICING_ATTR_rec.last_update_login <>
1467: p_old_PRICING_ATTR_rec.last_update_login OR
1468: p_old_PRICING_ATTR_rec.last_update_login IS NULL )
1469: THEN
1470: IF NOT QP_Validate.Last_Update_Login(p_PRICING_ATTR_rec.last_update_login) THEN
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: END IF;
1473: END IF;
1474:

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

1476: ( p_PRICING_ATTR_rec.list_line_id <>
1477: p_old_PRICING_ATTR_rec.list_line_id OR
1478: p_old_PRICING_ATTR_rec.list_line_id IS NULL )
1479: THEN
1480: IF NOT QP_Validate.List_Line(p_PRICING_ATTR_rec.list_line_id) THEN
1481: x_return_status := FND_API.G_RET_STS_ERROR;
1482: END IF;
1483: END IF;
1484:

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

1486: ( p_PRICING_ATTR_rec.pricing_attribute <>
1487: p_old_PRICING_ATTR_rec.pricing_attribute OR
1488: p_old_PRICING_ATTR_rec.pricing_attribute IS NULL )
1489: THEN
1490: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute) THEN
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: END IF;
1493: END IF;
1494:

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

1496: ( p_PRICING_ATTR_rec.pricing_attribute_context <>
1497: p_old_PRICING_ATTR_rec.pricing_attribute_context OR
1498: p_old_PRICING_ATTR_rec.pricing_attribute_context IS NULL )
1499: THEN
1500: IF NOT QP_Validate.Pricing_Attribute_Context(p_PRICING_ATTR_rec.pricing_attribute_context) THEN
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: END IF;
1503: END IF;
1504:

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

1506: ( p_PRICING_ATTR_rec.pricing_attribute_id <>
1507: p_old_PRICING_ATTR_rec.pricing_attribute_id OR
1508: p_old_PRICING_ATTR_rec.pricing_attribute_id IS NULL )
1509: THEN
1510: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute_id) THEN
1511: x_return_status := FND_API.G_RET_STS_ERROR;
1512: END IF;
1513: END IF;
1514:

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

1517: p_old_PRICING_ATTR_rec.from_rltd_modifier_id OR
1518: p_old_PRICING_ATTR_rec.from_rltd_modifier_id IS NULL )
1519: THEN
1520: /*
1521: IF NOT QP_Validate.From_Rltd_Modifier_Id(p_PRICING_ATTR_rec.from_rltd_modifier_id) THEN
1522: x_return_status := FND_API.G_RET_STS_ERROR;
1523: END IF;
1524: */
1525: NULL;

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

1530: ( p_PRICING_ATTR_rec.pricing_attr_value_from <>
1531: p_old_PRICING_ATTR_rec.pricing_attr_value_from OR
1532: p_old_PRICING_ATTR_rec.pricing_attr_value_from IS NULL )
1533: THEN
1534: IF NOT QP_Validate.Pricing_Attr_Value_From(p_PRICING_ATTR_rec.pricing_attr_value_from) THEN
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: END IF;
1537: END IF;
1538:

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

1540: ( p_PRICING_ATTR_rec.pricing_attr_value_to <>
1541: p_old_PRICING_ATTR_rec.pricing_attr_value_to OR
1542: p_old_PRICING_ATTR_rec.pricing_attr_value_to IS NULL )
1543: THEN
1544: IF NOT QP_Validate.Pricing_Attr_Value_To(p_PRICING_ATTR_rec.pricing_attr_value_to) THEN
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: END IF;
1547: END IF;
1548:

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

1550: ( p_PRICING_ATTR_rec.product_attribute <>
1551: p_old_PRICING_ATTR_rec.product_attribute OR
1552: p_old_PRICING_ATTR_rec.product_attribute IS NULL )
1553: THEN
1554: IF NOT QP_Validate.Product_Attribute(p_PRICING_ATTR_rec.product_attribute) THEN
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: END IF;
1557: END IF;
1558:

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

1560: ( p_PRICING_ATTR_rec.product_attribute_context <>
1561: p_old_PRICING_ATTR_rec.product_attribute_context OR
1562: p_old_PRICING_ATTR_rec.product_attribute_context IS NULL )
1563: THEN
1564: IF NOT QP_Validate.Product_Attribute_Context(p_PRICING_ATTR_rec.product_attribute_context) THEN
1565: x_return_status := FND_API.G_RET_STS_ERROR;
1566: END IF;
1567: END IF;
1568:

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

1570: ( p_PRICING_ATTR_rec.product_attr_value <>
1571: p_old_PRICING_ATTR_rec.product_attr_value OR
1572: p_old_PRICING_ATTR_rec.product_attr_value IS NULL )
1573: THEN
1574: IF NOT QP_Validate.Product_Attr_Value(p_PRICING_ATTR_rec.product_attr_value) THEN
1575: x_return_status := FND_API.G_RET_STS_ERROR;
1576: END IF;
1577: END IF;
1578:

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

1580: ( p_PRICING_ATTR_rec.product_uom_code <>
1581: p_old_PRICING_ATTR_rec.product_uom_code OR
1582: p_old_PRICING_ATTR_rec.product_uom_code IS NULL )
1583: THEN
1584: IF NOT QP_Validate.Product_Uom(p_PRICING_ATTR_rec.product_uom_code) THEN
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: END IF;
1587: END IF;
1588:

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

1590: ( p_PRICING_ATTR_rec.program_application_id <>
1591: p_old_PRICING_ATTR_rec.program_application_id OR
1592: p_old_PRICING_ATTR_rec.program_application_id IS NULL )
1593: THEN
1594: IF NOT QP_Validate.Program_Application(p_PRICING_ATTR_rec.program_application_id) THEN
1595: x_return_status := FND_API.G_RET_STS_ERROR;
1596: END IF;
1597: END IF;
1598:

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

1600: ( p_PRICING_ATTR_rec.program_id <>
1601: p_old_PRICING_ATTR_rec.program_id OR
1602: p_old_PRICING_ATTR_rec.program_id IS NULL )
1603: THEN
1604: IF NOT QP_Validate.Program(p_PRICING_ATTR_rec.program_id) THEN
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: END IF;
1607: END IF;
1608:

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

1610: ( p_PRICING_ATTR_rec.program_update_date <>
1611: p_old_PRICING_ATTR_rec.program_update_date OR
1612: p_old_PRICING_ATTR_rec.program_update_date IS NULL )
1613: THEN
1614: IF NOT QP_Validate.Program_Update_Date(p_PRICING_ATTR_rec.program_update_date) THEN
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: END IF;
1617: END IF;
1618:

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

1620: ( p_PRICING_ATTR_rec.request_id <>
1621: p_old_PRICING_ATTR_rec.request_id OR
1622: p_old_PRICING_ATTR_rec.request_id IS NULL )
1623: THEN
1624: IF NOT QP_Validate.Request(p_PRICING_ATTR_rec.request_id) THEN
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: END IF;
1627: END IF;
1628:

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

1630: ( p_PRICING_ATTR_rec.comparison_operator_code <>
1631: p_old_PRICING_ATTR_rec.comparison_operator_code OR
1632: p_old_PRICING_ATTR_rec.comparison_operator_code IS NULL )
1633: THEN
1634: IF NOT QP_Validate.comparison_operator(p_PRICING_ATTR_rec.comparison_operator_code) THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: END IF;
1637: END IF;
1638:

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

1640: ( p_PRICING_ATTR_rec.pricing_attribute_datatype <>
1641: p_old_PRICING_ATTR_rec.pricing_attribute_datatype OR
1642: p_old_PRICING_ATTR_rec.pricing_attribute_datatype IS NULL )
1643: THEN
1644: IF NOT QP_Validate.Pricing_Attribute_Datatype(p_PRICING_ATTR_rec.pricing_attribute_datatype) THEN
1645: x_return_status := FND_API.G_RET_STS_ERROR;
1646: END IF;
1647: END IF;
1648:

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

1650: ( p_PRICING_ATTR_rec.product_attribute_datatype <>
1651: p_old_PRICING_ATTR_rec.product_attribute_datatype OR
1652: p_old_PRICING_ATTR_rec.product_attribute_datatype IS NULL )
1653: THEN
1654: IF NOT QP_Validate.product_attribute_datatype(p_PRICING_ATTR_rec.product_attribute_datatype) THEN
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656: END IF;
1657: END IF;
1658:

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

1793: */
1794:
1795: -- Validate descriptive flexfield.
1796:
1797: IF NOT QP_Validate.Desc_Flex( 'PRICING_ATTR' ) THEN
1798: x_return_status := FND_API.G_RET_STS_ERROR;
1799: END IF;
1800:
1801: END IF;

Line 2158: END QP_Validate_pll_pricing_attr;

2154:
2155: END Check_Line_EffDates;
2156:
2157:
2158: END QP_Validate_pll_pricing_attr;