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

Line 1: PACKAGE BODY QP_Validate_Qualifiers AS

1: PACKAGE BODY QP_Validate_Qualifiers AS
2: /* $Header: QPXLQPQB.pls 120.2.12010000.2 2009/04/28 17:07:10 dnema ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXLQPQB.pls 120.2.12010000.2 2009/04/28 17:07:10 dnema ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Qualifiers';
7:
8: /*
9: Function added for bug8359572.
10: It will return true if a qualifier already exist at the same level, having same context,

Line 1355: IF NOT QP_Validate.Comparison_Operator(p_QUALIFIERS_rec.comparison_operator_code) THEN

1351: p_old_QUALIFIERS_rec.comparison_operator_code IS NULL )
1352: THEN
1353:
1354: --dbms_output.put_line(' inside if not null comparison operator');
1355: IF NOT QP_Validate.Comparison_Operator(p_QUALIFIERS_rec.comparison_operator_code) THEN
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: END IF;
1358: END IF;
1359:

Line 1371: IF NOT QP_Validate.Created_By(p_QUALIFIERS_rec.created_by) THEN

1367: ( p_QUALIFIERS_rec.created_by <>
1368: p_old_QUALIFIERS_rec.created_by OR
1369: p_old_QUALIFIERS_rec.created_by IS NULL )
1370: THEN
1371: IF NOT QP_Validate.Created_By(p_QUALIFIERS_rec.created_by) THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: END IF;
1374: END IF;
1375: --dbms_output.put_line('status is '||x_return_status);

Line 1386: IF NOT QP_Validate.Created_From_Rule(p_QUALIFIERS_rec.created_from_rule_id) THEN

1382: ( p_QUALIFIERS_rec.created_from_rule_id <>
1383: p_old_QUALIFIERS_rec.created_from_rule_id OR
1384: p_old_QUALIFIERS_rec.created_from_rule_id IS NULL )
1385: THEN
1386: IF NOT QP_Validate.Created_From_Rule(p_QUALIFIERS_rec.created_from_rule_id) THEN
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: END IF;
1389: END IF;
1390:

Line 1402: IF NOT QP_Validate.Creation_Date(p_QUALIFIERS_rec.creation_date) THEN

1398: ( p_QUALIFIERS_rec.creation_date <>
1399: p_old_QUALIFIERS_rec.creation_date OR
1400: p_old_QUALIFIERS_rec.creation_date IS NULL )
1401: THEN
1402: IF NOT QP_Validate.Creation_Date(p_QUALIFIERS_rec.creation_date) THEN
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: END IF;
1405: END IF;
1406: --dbms_output.put_line('status is '||x_return_status);

Line 1417: IF NOT QP_Validate.End_Date_Active(p_QUALIFIERS_rec.end_date_active) THEN

1413: ( p_QUALIFIERS_rec.end_date_active <>
1414: p_old_QUALIFIERS_rec.end_date_active OR
1415: p_old_QUALIFIERS_rec.end_date_active IS NULL )
1416: THEN
1417: IF NOT QP_Validate.End_Date_Active(p_QUALIFIERS_rec.end_date_active) THEN
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: END IF;
1420: END IF;
1421: --dbms_output.put_line('end adate status is '||x_return_status);

Line 1432: IF NOT QP_Validate.Excluder(p_QUALIFIERS_rec.excluder_flag) THEN

1428: ( p_QUALIFIERS_rec.excluder_flag <>
1429: p_old_QUALIFIERS_rec.excluder_flag OR
1430: p_old_QUALIFIERS_rec.excluder_flag IS NULL )
1431: THEN
1432: IF NOT QP_Validate.Excluder(p_QUALIFIERS_rec.excluder_flag) THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: END IF;
1435: END IF;
1436: --dbms_output.put_line(' excluder flag status is '||x_return_status);

Line 1447: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIERS_rec.last_updated_by) THEN

1443: ( p_QUALIFIERS_rec.last_updated_by <>
1444: p_old_QUALIFIERS_rec.last_updated_by OR
1445: p_old_QUALIFIERS_rec.last_updated_by IS NULL )
1446: THEN
1447: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIERS_rec.last_updated_by) THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: END IF;
1450: END IF;
1451: --dbms_output.put_line('status is '||x_return_status);

Line 1462: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIERS_rec.last_update_date) THEN

1458: ( p_QUALIFIERS_rec.last_update_date <>
1459: p_old_QUALIFIERS_rec.last_update_date OR
1460: p_old_QUALIFIERS_rec.last_update_date IS NULL )
1461: THEN
1462: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIERS_rec.last_update_date) THEN
1463: x_return_status := FND_API.G_RET_STS_ERROR;
1464: END IF;
1465: END IF;
1466: --dbms_output.put_line('status is '||x_return_status);

Line 1477: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIERS_rec.last_update_login) THEN

1473: ( p_QUALIFIERS_rec.last_update_login <>
1474: p_old_QUALIFIERS_rec.last_update_login OR
1475: p_old_QUALIFIERS_rec.last_update_login IS NULL )
1476: THEN
1477: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIERS_rec.last_update_login) THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: END IF;
1480: END IF;
1481: --dbms_output.put_line('status is '||x_return_status);

Line 1492: IF NOT QP_Validate.List_Header(p_QUALIFIERS_rec.list_header_id) THEN

1488: ( p_QUALIFIERS_rec.list_header_id <>
1489: p_old_QUALIFIERS_rec.list_header_id OR
1490: p_old_QUALIFIERS_rec.list_header_id IS NULL )
1491: THEN
1492: IF NOT QP_Validate.List_Header(p_QUALIFIERS_rec.list_header_id) THEN
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: END IF;
1495: END IF;
1496: --dbms_output.put_line('status is '||x_return_status);

Line 1507: IF NOT QP_Validate.List_Line(p_QUALIFIERS_rec.list_line_id) THEN

1503: ( p_QUALIFIERS_rec.list_line_id <>
1504: p_old_QUALIFIERS_rec.list_line_id OR
1505: p_old_QUALIFIERS_rec.list_line_id IS NULL )
1506: THEN
1507: IF NOT QP_Validate.List_Line(p_QUALIFIERS_rec.list_line_id) THEN
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509: END IF;
1510: END IF;
1511: --dbms_output.put_line('status is '||x_return_status);

Line 1523: IF NOT QP_Validate.Program_Application(p_QUALIFIERS_rec.program_application_id) THEN

1519: ( p_QUALIFIERS_rec.program_application_id <>
1520: p_old_QUALIFIERS_rec.program_application_id OR
1521: p_old_QUALIFIERS_rec.program_application_id IS NULL )
1522: THEN
1523: IF NOT QP_Validate.Program_Application(p_QUALIFIERS_rec.program_application_id) THEN
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: END IF;
1526: END IF;
1527: --dbms_output.put_line('status is '||x_return_status);

Line 1539: IF NOT QP_Validate.Program(p_QUALIFIERS_rec.program_id) THEN

1535: ( p_QUALIFIERS_rec.program_id <>
1536: p_old_QUALIFIERS_rec.program_id OR
1537: p_old_QUALIFIERS_rec.program_id IS NULL )
1538: THEN
1539: IF NOT QP_Validate.Program(p_QUALIFIERS_rec.program_id) THEN
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: END IF;
1542: END IF;
1543: --dbms_output.put_line('status is '||x_return_status);

Line 1554: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIERS_rec.program_update_date) THEN

1550: ( p_QUALIFIERS_rec.program_update_date <>
1551: p_old_QUALIFIERS_rec.program_update_date OR
1552: p_old_QUALIFIERS_rec.program_update_date IS NULL )
1553: THEN
1554: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIERS_rec.program_update_date) THEN
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: END IF;
1557: END IF;
1558: --dbms_output.put_line('status is '||x_return_status);

Line 1569: IF NOT QP_Validate.Qualifier_Attribute(p_QUALIFIERS_rec.qualifier_attribute) THEN

1565: ( p_QUALIFIERS_rec.qualifier_attribute <>
1566: p_old_QUALIFIERS_rec.qualifier_attribute OR
1567: p_old_QUALIFIERS_rec.qualifier_attribute IS NULL )
1568: THEN
1569: IF NOT QP_Validate.Qualifier_Attribute(p_QUALIFIERS_rec.qualifier_attribute) THEN
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: END IF;
1572: END IF;
1573: --dbms_output.put_line(' attribute status is '||x_return_status);

Line 1584: IF NOT QP_Validate.Qualifier_Attr_Value(p_QUALIFIERS_rec.qualifier_attr_value) THEN

1580: ( p_QUALIFIERS_rec.qualifier_attr_value <>
1581: p_old_QUALIFIERS_rec.qualifier_attr_value OR
1582: p_old_QUALIFIERS_rec.qualifier_attr_value IS NULL )
1583: THEN
1584: IF NOT QP_Validate.Qualifier_Attr_Value(p_QUALIFIERS_rec.qualifier_attr_value) THEN
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: END IF;
1587: END IF;
1588: --dbms_output.put_line(' attr value status is '||x_return_status);

Line 1599: IF NOT QP_Validate.Qualifier_Attr_Value_to(p_QUALIFIERS_rec.qualifier_attr_value_to) THEN

1595: ( p_QUALIFIERS_rec.qualifier_attr_value_to <>
1596: p_old_QUALIFIERS_rec.qualifier_attr_value_to OR
1597: p_old_QUALIFIERS_rec.qualifier_attr_value_to IS NULL )
1598: THEN
1599: IF NOT QP_Validate.Qualifier_Attr_Value_to(p_QUALIFIERS_rec.qualifier_attr_value_to) THEN
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: END IF;
1602: END IF;
1603: --dbms_output.put_line(' attr_value to status is '||x_return_status);

Line 1615: IF NOT QP_Validate.Qualifier_Context(p_QUALIFIERS_rec.qualifier_context) THEN

1611: ( p_QUALIFIERS_rec.qualifier_context <>
1612: p_old_QUALIFIERS_rec.qualifier_context OR
1613: p_old_QUALIFIERS_rec.qualifier_context IS NULL )
1614: THEN
1615: IF NOT QP_Validate.Qualifier_Context(p_QUALIFIERS_rec.qualifier_context) THEN
1616: x_return_status := FND_API.G_RET_STS_ERROR;
1617: END IF;
1618: END IF;
1619: --dbms_output.put_line(' context status is '||x_return_status);

Line 1630: IF NOT QP_Validate.Qualifier_Datatype(p_QUALIFIERS_rec.qualifier_datatype) THEN

1626: ( p_QUALIFIERS_rec.qualifier_datatype <>
1627: p_old_QUALIFIERS_rec.qualifier_datatype OR
1628: p_old_QUALIFIERS_rec.qualifier_datatype IS NULL )
1629: THEN
1630: IF NOT QP_Validate.Qualifier_Datatype(p_QUALIFIERS_rec.qualifier_datatype) THEN
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: END IF;
1633: END IF;
1634: --dbms_output.put_line(' data type status is '||x_return_status);

Line 1641: IF NOT QP_Validate.Qualifier_Date_Format(p_QUALIFIERS_rec.qualifier_date_format) THEN

1637: ( p_QUALIFIERS_rec.qualifier_date_format <>
1638: p_old_QUALIFIERS_rec.qualifier_date_format OR
1639: p_old_QUALIFIERS_rec.qualifier_date_format IS NULL )
1640: THEN
1641: IF NOT QP_Validate.Qualifier_Date_Format(p_QUALIFIERS_rec.qualifier_date_format) THEN
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: END IF;
1644: END IF;*/
1645:

Line 1658: IF NOT QP_Validate.Qualifier_Grouping_No(p_QUALIFIERS_rec.qualifier_grouping_no) THEN

1654: ( p_QUALIFIERS_rec.qualifier_grouping_no <>
1655: p_old_QUALIFIERS_rec.qualifier_grouping_no OR
1656: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1 )
1657: THEN
1658: IF NOT QP_Validate.Qualifier_Grouping_No(p_QUALIFIERS_rec.qualifier_grouping_no) THEN
1659: x_return_status := FND_API.G_RET_STS_ERROR;
1660: END IF;
1661: END IF;
1662: --dbms_output.put_line(' gropuing status is '||x_return_status);

Line 1673: IF NOT QP_Validate.Qualifier(p_QUALIFIERS_rec.qualifier_id) THEN

1669: ( p_QUALIFIERS_rec.qualifier_id <>
1670: p_old_QUALIFIERS_rec.qualifier_id OR
1671: p_old_QUALIFIERS_rec.qualifier_id IS NULL )
1672: THEN
1673: IF NOT QP_Validate.Qualifier(p_QUALIFIERS_rec.qualifier_id) THEN
1674: x_return_status := FND_API.G_RET_STS_ERROR;
1675: END IF;
1676: END IF;
1677: --dbms_output.put_line(' qualiifer id status is '||x_return_status);

Line 1687: IF NOT QP_Validate.Qualifier_Number_Format(p_QUALIFIERS_rec.qualifier_number_format) THEN

1683: ( p_QUALIFIERS_rec.qualifier_number_format <>
1684: p_old_QUALIFIERS_rec.qualifier_number_format OR
1685: p_old_QUALIFIERS_rec.qualifier_number_format IS NULL )
1686: THEN
1687: IF NOT QP_Validate.Qualifier_Number_Format(p_QUALIFIERS_rec.qualifier_number_format) THEN
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: END IF;
1690: END IF;*/
1691:

Line 1701: IF NOT QP_Validate.Qualifier_Precedence(p_QUALIFIERS_rec.qualifier_precedence) THEN

1697: ( p_QUALIFIERS_rec.qualifier_precedence <>
1698: p_old_QUALIFIERS_rec.qualifier_precedence OR
1699: p_old_QUALIFIERS_rec.qualifier_precedence IS NULL )
1700: THEN
1701: IF NOT QP_Validate.Qualifier_Precedence(p_QUALIFIERS_rec.qualifier_precedence) THEN
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: END IF;
1704: END IF;
1705: --dbms_output.put_line(' precedence status is '||x_return_status);

Line 1719: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIERS_rec.qualifier_rule_id) THEN

1715: ( p_QUALIFIERS_rec.qualifier_rule_id <>
1716: p_old_QUALIFIERS_rec.qualifier_rule_id OR
1717: p_old_QUALIFIERS_rec.qualifier_rule_id IS NULL )
1718: THEN
1719: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIERS_rec.qualifier_rule_id) THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: END IF;
1722: END IF;
1723: --dbms_output.put_line(' qualifier rule id status is '||x_return_status);

Line 1733: IF NOT QP_Validate.Request(p_QUALIFIERS_rec.request_id) THEN

1729: ( p_QUALIFIERS_rec.request_id <>
1730: p_old_QUALIFIERS_rec.request_id OR
1731: p_old_QUALIFIERS_rec.request_id IS NULL )
1732: THEN
1733: IF NOT QP_Validate.Request(p_QUALIFIERS_rec.request_id) THEN
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: END IF;
1736: END IF;
1737: --dbms_output.put_line('status is '||x_return_status);

Line 1747: IF NOT QP_Validate.Start_Date_Active(p_QUALIFIERS_rec.start_date_active) THEN

1743: ( p_QUALIFIERS_rec.start_date_active <>
1744: p_old_QUALIFIERS_rec.start_date_active OR
1745: p_old_QUALIFIERS_rec.start_date_active IS NULL )
1746: THEN
1747: IF NOT QP_Validate.Start_Date_Active(p_QUALIFIERS_rec.start_date_active) THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: END IF;
1750: END IF;
1751: --dbms_output.put_line('status is '||x_return_status);

Line 1758: IF NOT QP_Validate.Qualify_Hier_Descendent_Flag(p_QUALIFIERS_rec.qualify_hier_descendent_flag) THEN

1754: ( p_QUALIFIERS_rec.qualify_hier_descendent_flag <>
1755: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag OR
1756: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag IS NULL )
1757: THEN
1758: IF NOT QP_Validate.Qualify_Hier_Descendent_Flag(p_QUALIFIERS_rec.qualify_hier_descendent_flag) THEN
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: END IF;
1761: END IF;
1762:

Line 1902: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN

1898:
1899: -- Validate descriptive flexfield.
1900:
1901: --dbms_output.put_line('validating flex ');
1902: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904: END IF;
1905: --dbms_output.put_line('status is '||x_return_status);
1906:

Line 1984: END QP_Validate_Qualifiers;

1980: END IF;
1981:
1982: END Entity_Delete;
1983:
1984: END QP_Validate_Qualifiers;