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 2005/08/31 18:05:45 srashmi noship $ */
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 2005/08/31 18:05:45 srashmi noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Qualifiers';
7:
8:
9: FUNCTION Check_Duplicate_Start_date(p_qualifier_grouping_no IN number,
10: p_start_date IN date,

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

1251: p_old_QUALIFIERS_rec.comparison_operator_code IS NULL )
1252: THEN
1253:
1254: --dbms_output.put_line(' inside if not null comparison operator');
1255: IF NOT QP_Validate.Comparison_Operator(p_QUALIFIERS_rec.comparison_operator_code) THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;
1258: END IF;
1259:

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

1267: ( p_QUALIFIERS_rec.created_by <>
1268: p_old_QUALIFIERS_rec.created_by OR
1269: p_old_QUALIFIERS_rec.created_by IS NULL )
1270: THEN
1271: IF NOT QP_Validate.Created_By(p_QUALIFIERS_rec.created_by) THEN
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: END IF;
1274: END IF;
1275: --dbms_output.put_line('status is '||x_return_status);

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

1282: ( p_QUALIFIERS_rec.created_from_rule_id <>
1283: p_old_QUALIFIERS_rec.created_from_rule_id OR
1284: p_old_QUALIFIERS_rec.created_from_rule_id IS NULL )
1285: THEN
1286: IF NOT QP_Validate.Created_From_Rule(p_QUALIFIERS_rec.created_from_rule_id) THEN
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: END IF;
1289: END IF;
1290:

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

1298: ( p_QUALIFIERS_rec.creation_date <>
1299: p_old_QUALIFIERS_rec.creation_date OR
1300: p_old_QUALIFIERS_rec.creation_date IS NULL )
1301: THEN
1302: IF NOT QP_Validate.Creation_Date(p_QUALIFIERS_rec.creation_date) THEN
1303: x_return_status := FND_API.G_RET_STS_ERROR;
1304: END IF;
1305: END IF;
1306: --dbms_output.put_line('status is '||x_return_status);

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

1313: ( p_QUALIFIERS_rec.end_date_active <>
1314: p_old_QUALIFIERS_rec.end_date_active OR
1315: p_old_QUALIFIERS_rec.end_date_active IS NULL )
1316: THEN
1317: IF NOT QP_Validate.End_Date_Active(p_QUALIFIERS_rec.end_date_active) THEN
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: END IF;
1320: END IF;
1321: --dbms_output.put_line('end adate status is '||x_return_status);

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

1328: ( p_QUALIFIERS_rec.excluder_flag <>
1329: p_old_QUALIFIERS_rec.excluder_flag OR
1330: p_old_QUALIFIERS_rec.excluder_flag IS NULL )
1331: THEN
1332: IF NOT QP_Validate.Excluder(p_QUALIFIERS_rec.excluder_flag) THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: END IF;
1335: END IF;
1336: --dbms_output.put_line(' excluder flag status is '||x_return_status);

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

1343: ( p_QUALIFIERS_rec.last_updated_by <>
1344: p_old_QUALIFIERS_rec.last_updated_by OR
1345: p_old_QUALIFIERS_rec.last_updated_by IS NULL )
1346: THEN
1347: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIERS_rec.last_updated_by) THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: END IF;
1350: END IF;
1351: --dbms_output.put_line('status is '||x_return_status);

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

1358: ( p_QUALIFIERS_rec.last_update_date <>
1359: p_old_QUALIFIERS_rec.last_update_date OR
1360: p_old_QUALIFIERS_rec.last_update_date IS NULL )
1361: THEN
1362: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIERS_rec.last_update_date) THEN
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: END IF;
1365: END IF;
1366: --dbms_output.put_line('status is '||x_return_status);

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

1373: ( p_QUALIFIERS_rec.last_update_login <>
1374: p_old_QUALIFIERS_rec.last_update_login OR
1375: p_old_QUALIFIERS_rec.last_update_login IS NULL )
1376: THEN
1377: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIERS_rec.last_update_login) THEN
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: END IF;
1380: END IF;
1381: --dbms_output.put_line('status is '||x_return_status);

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

1388: ( p_QUALIFIERS_rec.list_header_id <>
1389: p_old_QUALIFIERS_rec.list_header_id OR
1390: p_old_QUALIFIERS_rec.list_header_id IS NULL )
1391: THEN
1392: IF NOT QP_Validate.List_Header(p_QUALIFIERS_rec.list_header_id) THEN
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: END IF;
1395: END IF;
1396: --dbms_output.put_line('status is '||x_return_status);

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

1403: ( p_QUALIFIERS_rec.list_line_id <>
1404: p_old_QUALIFIERS_rec.list_line_id OR
1405: p_old_QUALIFIERS_rec.list_line_id IS NULL )
1406: THEN
1407: IF NOT QP_Validate.List_Line(p_QUALIFIERS_rec.list_line_id) THEN
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END IF;
1410: END IF;
1411: --dbms_output.put_line('status is '||x_return_status);

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

1419: ( p_QUALIFIERS_rec.program_application_id <>
1420: p_old_QUALIFIERS_rec.program_application_id OR
1421: p_old_QUALIFIERS_rec.program_application_id IS NULL )
1422: THEN
1423: IF NOT QP_Validate.Program_Application(p_QUALIFIERS_rec.program_application_id) THEN
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426: END IF;
1427: --dbms_output.put_line('status is '||x_return_status);

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

1435: ( p_QUALIFIERS_rec.program_id <>
1436: p_old_QUALIFIERS_rec.program_id OR
1437: p_old_QUALIFIERS_rec.program_id IS NULL )
1438: THEN
1439: IF NOT QP_Validate.Program(p_QUALIFIERS_rec.program_id) THEN
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: END IF;
1442: END IF;
1443: --dbms_output.put_line('status is '||x_return_status);

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

1450: ( p_QUALIFIERS_rec.program_update_date <>
1451: p_old_QUALIFIERS_rec.program_update_date OR
1452: p_old_QUALIFIERS_rec.program_update_date IS NULL )
1453: THEN
1454: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIERS_rec.program_update_date) THEN
1455: x_return_status := FND_API.G_RET_STS_ERROR;
1456: END IF;
1457: END IF;
1458: --dbms_output.put_line('status is '||x_return_status);

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

1465: ( p_QUALIFIERS_rec.qualifier_attribute <>
1466: p_old_QUALIFIERS_rec.qualifier_attribute OR
1467: p_old_QUALIFIERS_rec.qualifier_attribute IS NULL )
1468: THEN
1469: IF NOT QP_Validate.Qualifier_Attribute(p_QUALIFIERS_rec.qualifier_attribute) THEN
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471: END IF;
1472: END IF;
1473: --dbms_output.put_line(' attribute status is '||x_return_status);

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

1480: ( p_QUALIFIERS_rec.qualifier_attr_value <>
1481: p_old_QUALIFIERS_rec.qualifier_attr_value OR
1482: p_old_QUALIFIERS_rec.qualifier_attr_value IS NULL )
1483: THEN
1484: IF NOT QP_Validate.Qualifier_Attr_Value(p_QUALIFIERS_rec.qualifier_attr_value) THEN
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487: END IF;
1488: --dbms_output.put_line(' attr value status is '||x_return_status);

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

1495: ( p_QUALIFIERS_rec.qualifier_attr_value_to <>
1496: p_old_QUALIFIERS_rec.qualifier_attr_value_to OR
1497: p_old_QUALIFIERS_rec.qualifier_attr_value_to IS NULL )
1498: THEN
1499: IF NOT QP_Validate.Qualifier_Attr_Value_to(p_QUALIFIERS_rec.qualifier_attr_value_to) THEN
1500: x_return_status := FND_API.G_RET_STS_ERROR;
1501: END IF;
1502: END IF;
1503: --dbms_output.put_line(' attr_value to status is '||x_return_status);

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

1511: ( p_QUALIFIERS_rec.qualifier_context <>
1512: p_old_QUALIFIERS_rec.qualifier_context OR
1513: p_old_QUALIFIERS_rec.qualifier_context IS NULL )
1514: THEN
1515: IF NOT QP_Validate.Qualifier_Context(p_QUALIFIERS_rec.qualifier_context) THEN
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: END IF;
1518: END IF;
1519: --dbms_output.put_line(' context status is '||x_return_status);

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

1526: ( p_QUALIFIERS_rec.qualifier_datatype <>
1527: p_old_QUALIFIERS_rec.qualifier_datatype OR
1528: p_old_QUALIFIERS_rec.qualifier_datatype IS NULL )
1529: THEN
1530: IF NOT QP_Validate.Qualifier_Datatype(p_QUALIFIERS_rec.qualifier_datatype) THEN
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: END IF;
1533: END IF;
1534: --dbms_output.put_line(' data type status is '||x_return_status);

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

1537: ( p_QUALIFIERS_rec.qualifier_date_format <>
1538: p_old_QUALIFIERS_rec.qualifier_date_format OR
1539: p_old_QUALIFIERS_rec.qualifier_date_format IS NULL )
1540: THEN
1541: IF NOT QP_Validate.Qualifier_Date_Format(p_QUALIFIERS_rec.qualifier_date_format) THEN
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: END IF;
1544: END IF;*/
1545:

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

1554: ( p_QUALIFIERS_rec.qualifier_grouping_no <>
1555: p_old_QUALIFIERS_rec.qualifier_grouping_no OR
1556: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1 )
1557: THEN
1558: IF NOT QP_Validate.Qualifier_Grouping_No(p_QUALIFIERS_rec.qualifier_grouping_no) THEN
1559: x_return_status := FND_API.G_RET_STS_ERROR;
1560: END IF;
1561: END IF;
1562: --dbms_output.put_line(' gropuing status is '||x_return_status);

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

1569: ( p_QUALIFIERS_rec.qualifier_id <>
1570: p_old_QUALIFIERS_rec.qualifier_id OR
1571: p_old_QUALIFIERS_rec.qualifier_id IS NULL )
1572: THEN
1573: IF NOT QP_Validate.Qualifier(p_QUALIFIERS_rec.qualifier_id) THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: END IF;
1576: END IF;
1577: --dbms_output.put_line(' qualiifer id status is '||x_return_status);

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

1583: ( p_QUALIFIERS_rec.qualifier_number_format <>
1584: p_old_QUALIFIERS_rec.qualifier_number_format OR
1585: p_old_QUALIFIERS_rec.qualifier_number_format IS NULL )
1586: THEN
1587: IF NOT QP_Validate.Qualifier_Number_Format(p_QUALIFIERS_rec.qualifier_number_format) THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END IF;
1590: END IF;*/
1591:

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

1597: ( p_QUALIFIERS_rec.qualifier_precedence <>
1598: p_old_QUALIFIERS_rec.qualifier_precedence OR
1599: p_old_QUALIFIERS_rec.qualifier_precedence IS NULL )
1600: THEN
1601: IF NOT QP_Validate.Qualifier_Precedence(p_QUALIFIERS_rec.qualifier_precedence) THEN
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: END IF;
1605: --dbms_output.put_line(' precedence status is '||x_return_status);

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

1615: ( p_QUALIFIERS_rec.qualifier_rule_id <>
1616: p_old_QUALIFIERS_rec.qualifier_rule_id OR
1617: p_old_QUALIFIERS_rec.qualifier_rule_id IS NULL )
1618: THEN
1619: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIERS_rec.qualifier_rule_id) THEN
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: END IF;
1622: END IF;
1623: --dbms_output.put_line(' qualifier rule id status is '||x_return_status);

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

1629: ( p_QUALIFIERS_rec.request_id <>
1630: p_old_QUALIFIERS_rec.request_id OR
1631: p_old_QUALIFIERS_rec.request_id IS NULL )
1632: THEN
1633: IF NOT QP_Validate.Request(p_QUALIFIERS_rec.request_id) THEN
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: END IF;
1636: END IF;
1637: --dbms_output.put_line('status is '||x_return_status);

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

1643: ( p_QUALIFIERS_rec.start_date_active <>
1644: p_old_QUALIFIERS_rec.start_date_active OR
1645: p_old_QUALIFIERS_rec.start_date_active IS NULL )
1646: THEN
1647: IF NOT QP_Validate.Start_Date_Active(p_QUALIFIERS_rec.start_date_active) THEN
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: END IF;
1650: END IF;
1651: --dbms_output.put_line('status is '||x_return_status);

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

1654: ( p_QUALIFIERS_rec.qualify_hier_descendent_flag <>
1655: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag OR
1656: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag IS NULL )
1657: THEN
1658: IF NOT QP_Validate.Qualify_Hier_Descendent_Flag(p_QUALIFIERS_rec.qualify_hier_descendent_flag) THEN
1659: x_return_status := FND_API.G_RET_STS_ERROR;
1660: END IF;
1661: END IF;
1662:

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

1798:
1799: -- Validate descriptive flexfield.
1800:
1801: --dbms_output.put_line('validating flex ');
1802: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN
1803: x_return_status := FND_API.G_RET_STS_ERROR;
1804: END IF;
1805: --dbms_output.put_line('status is '||x_return_status);
1806:

Line 1884: END QP_Validate_Qualifiers;

1880: END IF;
1881:
1882: END Entity_Delete;
1883:
1884: END QP_Validate_Qualifiers;