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_PRICING_ATTR dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Pricing_Attr AS

1: PACKAGE BODY QP_Validate_Pricing_Attr AS
2: /* $Header: QPXLPRAB.pls 120.8 2006/09/07 10:08:10 rbagri noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXLPRAB.pls 120.8 2006/09/07 10:08:10 rbagri noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Pricing_Attr';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 813: IF NOT QP_VALIDATE.Product_Uom(p_PRICING_ATTR_rec.product_uom_code, -- sfiresto 4753707

809: select list_header_id into l_uom_list_header_id
810: from qp_list_lines
811: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
812:
813: IF NOT QP_VALIDATE.Product_Uom(p_PRICING_ATTR_rec.product_uom_code, -- sfiresto 4753707
814: to_number(p_PRICING_ATTR_rec.product_attr_value),
815: l_uom_list_header_id)
816: THEN
817: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

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

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

1517: ( p_PRICING_ATTR_rec.creation_date <>
1518: p_old_PRICING_ATTR_rec.creation_date OR
1519: p_old_PRICING_ATTR_rec.creation_date IS NULL )
1520: THEN
1521: IF NOT QP_Validate.Creation_Date(p_PRICING_ATTR_rec.creation_date) THEN
1522: x_return_status := FND_API.G_RET_STS_ERROR;
1523: END IF;
1524: END IF;
1525:

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

1527: ( p_PRICING_ATTR_rec.excluder_flag <>
1528: p_old_PRICING_ATTR_rec.excluder_flag OR
1529: p_old_PRICING_ATTR_rec.excluder_flag IS NULL )
1530: THEN
1531: IF NOT QP_Validate.Excluder(p_PRICING_ATTR_rec.excluder_flag) THEN
1532: x_return_status := FND_API.G_RET_STS_ERROR;
1533: END IF;
1534: END IF;
1535:

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

1537: ( p_PRICING_ATTR_rec.last_updated_by <>
1538: p_old_PRICING_ATTR_rec.last_updated_by OR
1539: p_old_PRICING_ATTR_rec.last_updated_by IS NULL )
1540: THEN
1541: IF NOT QP_Validate.Last_Updated_By(p_PRICING_ATTR_rec.last_updated_by) THEN
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: END IF;
1544: END IF;
1545:

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

1547: ( p_PRICING_ATTR_rec.last_update_date <>
1548: p_old_PRICING_ATTR_rec.last_update_date OR
1549: p_old_PRICING_ATTR_rec.last_update_date IS NULL )
1550: THEN
1551: IF NOT QP_Validate.Last_Update_Date(p_PRICING_ATTR_rec.last_update_date) THEN
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: END IF;
1554: END IF;
1555:

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

1557: ( p_PRICING_ATTR_rec.last_update_login <>
1558: p_old_PRICING_ATTR_rec.last_update_login OR
1559: p_old_PRICING_ATTR_rec.last_update_login IS NULL )
1560: THEN
1561: IF NOT QP_Validate.Last_Update_Login(p_PRICING_ATTR_rec.last_update_login) THEN
1562: x_return_status := FND_API.G_RET_STS_ERROR;
1563: END IF;
1564: END IF;
1565:

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

1567: ( p_PRICING_ATTR_rec.list_line_id <>
1568: p_old_PRICING_ATTR_rec.list_line_id OR
1569: p_old_PRICING_ATTR_rec.list_line_id IS NULL )
1570: THEN
1571: IF NOT QP_Validate.List_Line(p_PRICING_ATTR_rec.list_line_id) THEN
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: END IF;
1574: END IF;
1575:

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

1577: ( p_PRICING_ATTR_rec.pricing_attribute <>
1578: p_old_PRICING_ATTR_rec.pricing_attribute OR
1579: p_old_PRICING_ATTR_rec.pricing_attribute IS NULL )
1580: THEN
1581: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute) THEN
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: END IF;
1584: END IF;
1585:

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

1587: ( p_PRICING_ATTR_rec.pricing_attribute_context <>
1588: p_old_PRICING_ATTR_rec.pricing_attribute_context OR
1589: p_old_PRICING_ATTR_rec.pricing_attribute_context IS NULL )
1590: THEN
1591: IF NOT QP_Validate.Pricing_Attribute_Context(p_PRICING_ATTR_rec.pricing_attribute_context) THEN
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: END IF;
1594: END IF;
1595:

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

1597: ( p_PRICING_ATTR_rec.pricing_attribute_id <>
1598: p_old_PRICING_ATTR_rec.pricing_attribute_id OR
1599: p_old_PRICING_ATTR_rec.pricing_attribute_id IS NULL )
1600: THEN
1601: IF NOT QP_Validate.Pricing_Attribute(p_PRICING_ATTR_rec.pricing_attribute_id) THEN
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: END IF;
1605:

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

1607: ( p_PRICING_ATTR_rec.pricing_attr_value_from <>
1608: p_old_PRICING_ATTR_rec.pricing_attr_value_from OR
1609: p_old_PRICING_ATTR_rec.pricing_attr_value_from IS NULL )
1610: THEN
1611: IF NOT QP_Validate.Pricing_Attr_Value_From(p_PRICING_ATTR_rec.pricing_attr_value_from) THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: END IF;
1614: END IF;
1615:

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

1617: ( p_PRICING_ATTR_rec.pricing_attr_value_to <>
1618: p_old_PRICING_ATTR_rec.pricing_attr_value_to OR
1619: p_old_PRICING_ATTR_rec.pricing_attr_value_to IS NULL )
1620: THEN
1621: IF NOT QP_Validate.Pricing_Attr_Value_To(p_PRICING_ATTR_rec.pricing_attr_value_to) THEN
1622: x_return_status := FND_API.G_RET_STS_ERROR;
1623: END IF;
1624: END IF;
1625:

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

1627: ( p_PRICING_ATTR_rec.product_attribute <>
1628: p_old_PRICING_ATTR_rec.product_attribute OR
1629: p_old_PRICING_ATTR_rec.product_attribute IS NULL )
1630: THEN
1631: IF NOT QP_Validate.Product_Attribute(p_PRICING_ATTR_rec.product_attribute) THEN
1632: x_return_status := FND_API.G_RET_STS_ERROR;
1633: END IF;
1634: END IF;
1635:

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

1637: ( p_PRICING_ATTR_rec.product_attribute_context <>
1638: p_old_PRICING_ATTR_rec.product_attribute_context OR
1639: p_old_PRICING_ATTR_rec.product_attribute_context IS NULL )
1640: THEN
1641: IF NOT QP_Validate.Product_Attribute_Context(p_PRICING_ATTR_rec.product_attribute_context) THEN
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: END IF;
1644: END IF;
1645:

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

1647: ( p_PRICING_ATTR_rec.product_attr_value <>
1648: p_old_PRICING_ATTR_rec.product_attr_value OR
1649: p_old_PRICING_ATTR_rec.product_attr_value IS NULL )
1650: THEN
1651: IF NOT QP_Validate.Product_Attr_Value(p_PRICING_ATTR_rec.product_attr_value) THEN
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: END IF;
1654: END IF;
1655:

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

1657: ( p_PRICING_ATTR_rec.product_uom_code <>
1658: p_old_PRICING_ATTR_rec.product_uom_code OR
1659: p_old_PRICING_ATTR_rec.product_uom_code IS NULL )
1660: THEN
1661: IF NOT QP_Validate.Product_Uom(p_PRICING_ATTR_rec.product_uom_code) THEN
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: END IF;
1664: END IF;
1665:

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

1667: ( p_PRICING_ATTR_rec.program_application_id <>
1668: p_old_PRICING_ATTR_rec.program_application_id OR
1669: p_old_PRICING_ATTR_rec.program_application_id IS NULL )
1670: THEN
1671: IF NOT QP_Validate.Program_Application(p_PRICING_ATTR_rec.program_application_id) THEN
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: END IF;
1674: END IF;
1675:

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

1677: ( p_PRICING_ATTR_rec.program_id <>
1678: p_old_PRICING_ATTR_rec.program_id OR
1679: p_old_PRICING_ATTR_rec.program_id IS NULL )
1680: THEN
1681: IF NOT QP_Validate.Program(p_PRICING_ATTR_rec.program_id) THEN
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: END IF;
1684: END IF;
1685:

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

1687: ( p_PRICING_ATTR_rec.program_update_date <>
1688: p_old_PRICING_ATTR_rec.program_update_date OR
1689: p_old_PRICING_ATTR_rec.program_update_date IS NULL )
1690: THEN
1691: IF NOT QP_Validate.Program_Update_Date(p_PRICING_ATTR_rec.program_update_date) THEN
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: END IF;
1694: END IF;
1695:

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

1697: ( p_PRICING_ATTR_rec.request_id <>
1698: p_old_PRICING_ATTR_rec.request_id OR
1699: p_old_PRICING_ATTR_rec.request_id IS NULL )
1700: THEN
1701: IF NOT QP_Validate.Request(p_PRICING_ATTR_rec.request_id) THEN
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: END IF;
1704: END IF;
1705:

Line 1711: IF NOT QP_Validate.Product_Attribute_Datatype(p_PRICING_ATTR_rec.product_attribute_datatype) THEN

1707: ( p_PRICING_ATTR_rec.product_attribute_datatype <>
1708: p_old_PRICING_ATTR_rec.product_attribute_datatype OR
1709: p_old_PRICING_ATTR_rec.product_attribute_datatype IS NULL )
1710: THEN
1711: IF NOT QP_Validate.Product_Attribute_Datatype(p_PRICING_ATTR_rec.product_attribute_datatype) THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: END IF;
1714: END IF;
1715:

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

1717: ( p_PRICING_ATTR_rec.pricing_attribute_datatype <>
1718: p_old_PRICING_ATTR_rec.pricing_attribute_datatype OR
1719: p_old_PRICING_ATTR_rec.pricing_attribute_datatype IS NULL )
1720: THEN
1721: IF NOT QP_Validate.Pricing_Attribute_Datatype(p_PRICING_ATTR_rec.pricing_attribute_datatype) THEN
1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723: END IF;
1724: END IF;
1725:

Line 1731: IF NOT QP_Validate.Comparison_Operator(p_PRICING_ATTR_rec.comparison_operator_code) THEN

1727: ( p_PRICING_ATTR_rec.comparison_operator_code <>
1728: p_old_PRICING_ATTR_rec.comparison_operator_code OR
1729: p_old_PRICING_ATTR_rec.comparison_operator_code IS NULL )
1730: THEN
1731: IF NOT QP_Validate.Comparison_Operator(p_PRICING_ATTR_rec.comparison_operator_code) THEN
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734: END IF;
1735:

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

1869: */
1870:
1871: -- Validate descriptive flexfield.
1872:
1873: IF NOT QP_Validate.Desc_Flex( 'PRICING_ATTR' ) THEN
1874: x_return_status := FND_API.G_RET_STS_ERROR;
1875: END IF;
1876:
1877: END IF;

Line 2283: END QP_Validate_Pricing_Attr;

2279: END Mod_Dup;
2280:
2281: -- end bug2091362
2282:
2283: END QP_Validate_Pricing_Attr;