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.QA_VALIDATION_API dependencies on QA_PLAN_ELEMENT_API

Line 511: flag := qa_plan_element_api.get_enabled_flag(plan_id, element_id);

507: flag NUMBER;
508:
509: BEGIN
510:
511: flag := qa_plan_element_api.get_enabled_flag(plan_id, element_id);
512:
513: IF (flag = 1) THEN
514: RETURN ok;
515: ELSE

Line 670: m_flag := qa_plan_element_api.get_mandatory_flag(row_record.plan_id,

666: value);
667: END IF;
668:
669:
670: m_flag := qa_plan_element_api.get_mandatory_flag(row_record.plan_id,
671: element_id);
672:
673: IF ( (m_flag = 2) or (value IS NOT NULL) ) THEN
674: RETURN ok;

Line 735: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,

731: -- if the vlaue for so line number is NULL then
732: -- x_where_clause := NULL;
733: --
734:
735: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
736: qa_ss_const.production_line) AND
737: row_elements.exists(qa_ss_const.production_line) AND
738: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
739:

Line 990: mandatory_flag := qa_plan_element_api.get_mandatory_flag(

986: RETURN not_locator_controlled_error;
987: END IF;
988: END IF;
989:
990: mandatory_flag := qa_plan_element_api.get_mandatory_flag(
991: row_record.plan_id, element_id);
992:
993: IF ( (mandatory_flag = 1) and (value IS NULL) ) THEN
994:

Line 1134: mandatory_flag := qa_plan_element_api.get_mandatory_flag(

1130: RETURN not_locator_controlled_error;
1131: END IF;
1132: END IF;
1133:
1134: mandatory_flag := qa_plan_element_api.get_mandatory_flag(
1135: row_record.plan_id, element_id);
1136:
1137: IF ( (mandatory_flag = 1) and (value IS NULL) ) THEN
1138: RETURN mandatory_error;

Line 1395: mandatory_flag := qa_plan_element_api.get_mandatory_flag(

1391: RETURN not_locator_controlled_error;
1392: END IF;
1393: END IF;
1394:
1395: mandatory_flag := qa_plan_element_api.get_mandatory_flag(
1396: row_record.plan_id, element_id);
1397:
1398: IF ( (mandatory_flag = 1) and (value IS NULL) ) THEN
1399:

Line 1583: id := qa_plan_element_api.get_department_id(x_org_id, value);

1579: BEGIN
1580:
1581: IF (element_id = qa_ss_const.department)
1582: OR (element_id = qa_ss_const.to_department) THEN
1583: id := qa_plan_element_api.get_department_id(x_org_id, value);
1584:
1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1586: id := qa_plan_element_api.get_job_id(x_org_id, value);
1587:

Line 1586: id := qa_plan_element_api.get_job_id(x_org_id, value);

1582: OR (element_id = qa_ss_const.to_department) THEN
1583: id := qa_plan_element_api.get_department_id(x_org_id, value);
1584:
1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1586: id := qa_plan_element_api.get_job_id(x_org_id, value);
1587:
1588: ELSIF (element_id = qa_ss_const.production_line) THEN
1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1590:

Line 1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);

1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1586: id := qa_plan_element_api.get_job_id(x_org_id, value);
1587:
1588: ELSIF (element_id = qa_ss_const.production_line) THEN
1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1590:
1591: ELSIF (element_id = qa_ss_const.resource_code) THEN
1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1593:

Line 1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);

1588: ELSIF (element_id = qa_ss_const.production_line) THEN
1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1590:
1591: ELSIF (element_id = qa_ss_const.resource_code) THEN
1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1593:
1594: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1595: id := qa_plan_element_api.get_supplier_id(value);
1596:

Line 1595: id := qa_plan_element_api.get_supplier_id(value);

1591: ELSIF (element_id = qa_ss_const.resource_code) THEN
1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1593:
1594: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1595: id := qa_plan_element_api.get_supplier_id(value);
1596:
1597: ELSIF (element_id = qa_ss_const.po_number) THEN
1598: id := qa_plan_element_api.get_po_number_id(value);
1599:

Line 1598: id := qa_plan_element_api.get_po_number_id(value);

1594: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1595: id := qa_plan_element_api.get_supplier_id(value);
1596:
1597: ELSIF (element_id = qa_ss_const.po_number) THEN
1598: id := qa_plan_element_api.get_po_number_id(value);
1599:
1600: ELSIF (element_id = qa_ss_const.customer_name) THEN
1601: id := qa_plan_element_api.get_customer_id(value);
1602:

Line 1601: id := qa_plan_element_api.get_customer_id(value);

1597: ELSIF (element_id = qa_ss_const.po_number) THEN
1598: id := qa_plan_element_api.get_po_number_id(value);
1599:
1600: ELSIF (element_id = qa_ss_const.customer_name) THEN
1601: id := qa_plan_element_api.get_customer_id(value);
1602:
1603: ELSIF (element_id = qa_ss_const.sales_order) THEN
1604: id := qa_plan_element_api.get_so_number_id(value);
1605:

Line 1604: id := qa_plan_element_api.get_so_number_id(value);

1600: ELSIF (element_id = qa_ss_const.customer_name) THEN
1601: id := qa_plan_element_api.get_customer_id(value);
1602:
1603: ELSIF (element_id = qa_ss_const.sales_order) THEN
1604: id := qa_plan_element_api.get_so_number_id(value);
1605:
1606: ELSIF (element_id = qa_ss_const.order_line) THEN
1607: id := qa_plan_element_api.get_so_line_number_id(value);
1608:

Line 1607: id := qa_plan_element_api.get_so_line_number_id(value);

1603: ELSIF (element_id = qa_ss_const.sales_order) THEN
1604: id := qa_plan_element_api.get_so_number_id(value);
1605:
1606: ELSIF (element_id = qa_ss_const.order_line) THEN
1607: id := qa_plan_element_api.get_so_line_number_id(value);
1608:
1609: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1610: id := qa_plan_element_api.get_po_release_number_id(value,
1611: g_po_header_id);

Line 1610: id := qa_plan_element_api.get_po_release_number_id(value,

1606: ELSIF (element_id = qa_ss_const.order_line) THEN
1607: id := qa_plan_element_api.get_so_line_number_id(value);
1608:
1609: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1610: id := qa_plan_element_api.get_po_release_number_id(value,
1611: g_po_header_id);
1612:
1613: ELSIF (element_id = qa_ss_const.project_number) THEN
1614: id := qa_plan_element_api.get_project_number_id(value);

Line 1614: id := qa_plan_element_api.get_project_number_id(value);

1610: id := qa_plan_element_api.get_po_release_number_id(value,
1611: g_po_header_id);
1612:
1613: ELSIF (element_id = qa_ss_const.project_number) THEN
1614: id := qa_plan_element_api.get_project_number_id(value);
1615: --
1616: -- Bug 2672396. Need to keep a cache of the returned project ID
1617: -- bso Mon Nov 25 17:29:56 PST 2002
1618: --

Line 1626: id := qa_plan_element_api.get_task_number_id(value, g_project_id);

1622: --
1623: -- Bug 2672396. Added g_project_id because task is a dependent element.
1624: -- bso Mon Nov 25 17:29:56 PST 2002
1625: --
1626: id := qa_plan_element_api.get_task_number_id(value, g_project_id);
1627:
1628: ELSIF (element_id = qa_ss_const.rma_number) THEN
1629: id := qa_plan_element_api.get_rma_number_id(value);
1630:

Line 1629: id := qa_plan_element_api.get_rma_number_id(value);

1625: --
1626: id := qa_plan_element_api.get_task_number_id(value, g_project_id);
1627:
1628: ELSIF (element_id = qa_ss_const.rma_number) THEN
1629: id := qa_plan_element_api.get_rma_number_id(value);
1630:
1631: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1632: id := qa_plan_element_api.get_lpn_id(value);
1633:

Line 1632: id := qa_plan_element_api.get_lpn_id(value);

1628: ELSIF (element_id = qa_ss_const.rma_number) THEN
1629: id := qa_plan_element_api.get_rma_number_id(value);
1630:
1631: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1632: id := qa_plan_element_api.get_lpn_id(value);
1633:
1634: -- added the following to include new hardcoded element Transfer license plate number
1635: -- saugupta
1636:

Line 1638: id := qa_plan_element_api.get_xfr_lpn_id(value);

1634: -- added the following to include new hardcoded element Transfer license plate number
1635: -- saugupta
1636:
1637: ELSIF (element_id = qa_ss_const.xfr_license_plate_number) THEN
1638: id := qa_plan_element_api.get_xfr_lpn_id(value);
1639:
1640:
1641: ELSIF (element_id = qa_ss_const.contract_number) THEN
1642: id := qa_plan_element_api.get_contract_id(value);

Line 1642: id := qa_plan_element_api.get_contract_id(value);

1638: id := qa_plan_element_api.get_xfr_lpn_id(value);
1639:
1640:
1641: ELSIF (element_id = qa_ss_const.contract_number) THEN
1642: id := qa_plan_element_api.get_contract_id(value);
1643:
1644: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1645: id := qa_plan_element_api.get_contract_line_id(value);
1646:

Line 1645: id := qa_plan_element_api.get_contract_line_id(value);

1641: ELSIF (element_id = qa_ss_const.contract_number) THEN
1642: id := qa_plan_element_api.get_contract_id(value);
1643:
1644: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1645: id := qa_plan_element_api.get_contract_line_id(value);
1646:
1647: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1648: id := qa_plan_element_api.get_deliverable_id(value);
1649:

Line 1648: id := qa_plan_element_api.get_deliverable_id(value);

1644: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1645: id := qa_plan_element_api.get_contract_line_id(value);
1646:
1647: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1648: id := qa_plan_element_api.get_deliverable_id(value);
1649:
1650: ELSIF (element_id = qa_ss_const.work_order) THEN
1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1652:

Line 1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);

1647: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1648: id := qa_plan_element_api.get_deliverable_id(value);
1649:
1650: ELSIF (element_id = qa_ss_const.work_order) THEN
1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1652:
1653: --dgupta: Start R12 EAM Integration. Bug 4345492
1654: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1655: id := qa_plan_element_api.get_asset_instance_id(value);

Line 1655: id := qa_plan_element_api.get_asset_instance_id(value);

1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1652:
1653: --dgupta: Start R12 EAM Integration. Bug 4345492
1654: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1655: id := qa_plan_element_api.get_asset_instance_id(value);
1656: --dgupta: End R12 EAM Integration. Bug 4345492
1657:
1658: ELSIF (element_id = qa_ss_const.party_name) THEN
1659: id := qa_plan_element_api.get_party_id(value);

Line 1659: id := qa_plan_element_api.get_party_id(value);

1655: id := qa_plan_element_api.get_asset_instance_id(value);
1656: --dgupta: End R12 EAM Integration. Bug 4345492
1657:
1658: ELSIF (element_id = qa_ss_const.party_name) THEN
1659: id := qa_plan_element_api.get_party_id(value);
1660:
1661: ELSIF (element_id = qa_ss_const.item_instance) THEN
1662: id := qa_plan_element_api.get_item_instance_id(value);
1663:

Line 1662: id := qa_plan_element_api.get_item_instance_id(value);

1658: ELSIF (element_id = qa_ss_const.party_name) THEN
1659: id := qa_plan_element_api.get_party_id(value);
1660:
1661: ELSIF (element_id = qa_ss_const.item_instance) THEN
1662: id := qa_plan_element_api.get_item_instance_id(value);
1663:
1664: ELSIF (element_id = qa_ss_const.service_request) THEN
1665: id := qa_plan_element_api.get_service_request_id(value);
1666:

Line 1665: id := qa_plan_element_api.get_service_request_id(value);

1661: ELSIF (element_id = qa_ss_const.item_instance) THEN
1662: id := qa_plan_element_api.get_item_instance_id(value);
1663:
1664: ELSIF (element_id = qa_ss_const.service_request) THEN
1665: id := qa_plan_element_api.get_service_request_id(value);
1666:
1667: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1668: id := qa_plan_element_api.get_maintenance_req_id(value);
1669:

Line 1668: id := qa_plan_element_api.get_maintenance_req_id(value);

1664: ELSIF (element_id = qa_ss_const.service_request) THEN
1665: id := qa_plan_element_api.get_service_request_id(value);
1666:
1667: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1668: id := qa_plan_element_api.get_maintenance_req_id(value);
1669:
1670: ELSIF (element_id = qa_ss_const.rework_job) THEN
1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1672:

Line 1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);

1667: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1668: id := qa_plan_element_api.get_maintenance_req_id(value);
1669:
1670: ELSIF (element_id = qa_ss_const.rework_job) THEN
1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1672:
1673: ELSIF (element_id = qa_ss_const.counter_name) THEN
1674: id := qa_plan_element_api.get_counter_name_id(value);
1675:

Line 1674: id := qa_plan_element_api.get_counter_name_id(value);

1670: ELSIF (element_id = qa_ss_const.rework_job) THEN
1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1672:
1673: ELSIF (element_id = qa_ss_const.counter_name) THEN
1674: id := qa_plan_element_api.get_counter_name_id(value);
1675:
1676: -- Added the following for NCM Hardcode Elements.
1677: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1678: -- Bug 2449067.

Line 1681: id := qa_plan_element_api.get_lot_status_id(value);

1677: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1678: -- Bug 2449067.
1679:
1680: ELSIF (element_id = qa_ss_const.lot_status) THEN
1681: id := qa_plan_element_api.get_lot_status_id(value);
1682:
1683: ELSIF (element_id = qa_ss_const.serial_status) THEN
1684: id := qa_plan_element_api.get_serial_status_id(value);
1685:

Line 1684: id := qa_plan_element_api.get_serial_status_id(value);

1680: ELSIF (element_id = qa_ss_const.lot_status) THEN
1681: id := qa_plan_element_api.get_lot_status_id(value);
1682:
1683: ELSIF (element_id = qa_ss_const.serial_status) THEN
1684: id := qa_plan_element_api.get_serial_status_id(value);
1685:
1686: -- End of inclusions for NCM Hardcode Elements.
1687:
1688: -- R12 OPM Deviations. Bug 4345503 Start

Line 1690: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);

1686: -- End of inclusions for NCM Hardcode Elements.
1687:
1688: -- R12 OPM Deviations. Bug 4345503 Start
1689: ELSIF (element_id = qa_ss_const.process_batch_num) THEN
1690: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1691: g_process_batch_id := id;
1692:
1693: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1694: id := qa_plan_element_api.get_process_batchstep_id

Line 1694: id := qa_plan_element_api.get_process_batchstep_id

1690: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1691: g_process_batch_id := id;
1692:
1693: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1694: id := qa_plan_element_api.get_process_batchstep_id
1695: (value,g_process_batch_id);
1696: g_process_batchstep_id := id;
1697:
1698: ELSIF (element_id = qa_ss_const.process_operation) THEN

Line 1699: id := qa_plan_element_api.get_process_operation_id

1695: (value,g_process_batch_id);
1696: g_process_batchstep_id := id;
1697:
1698: ELSIF (element_id = qa_ss_const.process_operation) THEN
1699: id := qa_plan_element_api.get_process_operation_id
1700: (value,g_process_batch_id,g_process_batchstep_id);
1701:
1702: ELSIF (element_id = qa_ss_const.process_activity) THEN
1703: id := qa_plan_element_api.get_process_activity_id

Line 1703: id := qa_plan_element_api.get_process_activity_id

1699: id := qa_plan_element_api.get_process_operation_id
1700: (value,g_process_batch_id,g_process_batchstep_id);
1701:
1702: ELSIF (element_id = qa_ss_const.process_activity) THEN
1703: id := qa_plan_element_api.get_process_activity_id
1704: (value,g_process_batch_id,g_process_batchstep_id);
1705: g_process_activity_id := id;
1706:
1707: ELSIF (element_id = qa_ss_const.process_resource) THEN

Line 1708: id := qa_plan_element_api.get_process_resource_id

1704: (value,g_process_batch_id,g_process_batchstep_id);
1705: g_process_activity_id := id;
1706:
1707: ELSIF (element_id = qa_ss_const.process_resource) THEN
1708: id := qa_plan_element_api.get_process_resource_id
1709: (value,g_process_batch_id,
1710: g_process_batchstep_id, g_process_activity_id);
1711: g_process_resource_id := id;
1712: ELSIF (element_id = qa_ss_const.process_parameter) THEN

Line 1713: id := qa_plan_element_api.get_process_parameter_id

1709: (value,g_process_batch_id,
1710: g_process_batchstep_id, g_process_activity_id);
1711: g_process_resource_id := id;
1712: ELSIF (element_id = qa_ss_const.process_parameter) THEN
1713: id := qa_plan_element_api.get_process_parameter_id
1714: (value,g_process_resource_id);
1715:
1716: -- R12 OPM Deviations. Bug 4345503 End
1717: --R12 DR Integration . Bug 4345489 start

Line 1719: id := qa_plan_element_api.get_repair_line_id

1715:
1716: -- R12 OPM Deviations. Bug 4345503 End
1717: --R12 DR Integration . Bug 4345489 start
1718: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1719: id := qa_plan_element_api.get_repair_line_id
1720: (value);
1721: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1722: id := qa_plan_element_api.get_jtf_task_id(value);
1723: --R12 Dr Integration. Bug 4345489 end

Line 1722: id := qa_plan_element_api.get_jtf_task_id(value);

1718: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1719: id := qa_plan_element_api.get_repair_line_id
1720: (value);
1721: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1722: id := qa_plan_element_api.get_jtf_task_id(value);
1723: --R12 Dr Integration. Bug 4345489 end
1724: END IF;
1725:
1726: RETURN id;

Line 1804: result := qa_plan_element_api.validate_transaction_date(

1800:
1801: -- Transaction Date is validated only in PO Inspection Transaction
1802:
1803: IF (element_id = qa_ss_const.transaction_date) THEN
1804: result := qa_plan_element_api.validate_transaction_date(
1805: g_transaction_number);
1806:
1807: ELSIF (element_id = qa_ss_const.uom)
1808: OR (element_id = qa_ss_const.comp_uom) THEN

Line 1809: result := qa_plan_element_api.validate_uom(

1805: g_transaction_number);
1806:
1807: ELSIF (element_id = qa_ss_const.uom)
1808: OR (element_id = qa_ss_const.comp_uom) THEN
1809: result := qa_plan_element_api.validate_uom(
1810: x_org_id, g_item_id, x_value);
1811:
1812: ELSIF (element_id = qa_ss_const.revision)
1813: OR (element_id = qa_ss_const.comp_revision) THEN

Line 1814: result := qa_plan_element_api.validate_revision(

1810: x_org_id, g_item_id, x_value);
1811:
1812: ELSIF (element_id = qa_ss_const.revision)
1813: OR (element_id = qa_ss_const.comp_revision) THEN
1814: result := qa_plan_element_api.validate_revision(
1815: x_org_id, g_item_id, x_value);
1816:
1817: ELSIF (element_id = qa_ss_const.subinventory)
1818: OR (element_id = qa_ss_const.comp_subinventory) THEN

Line 1819: result := qa_plan_element_api.validate_subinventory(

1815: x_org_id, g_item_id, x_value);
1816:
1817: ELSIF (element_id = qa_ss_const.subinventory)
1818: OR (element_id = qa_ss_const.comp_subinventory) THEN
1819: result := qa_plan_element_api.validate_subinventory(
1820: x_org_id, x_value);
1821:
1822: -- Bug 4558205. OA Framewok Integration UT bug fix.
1823: -- Lot and serial numbers are not validated in server

Line 1829: result := qa_plan_element_api.validate_lot_num(x_org_id,

1825: -- srhariha. Tue Sep 27 03:14:23 PDT 2005.
1826:
1827: ELSIF (element_id = qa_ss_const.lot_number) THEN
1828: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1829: result := qa_plan_element_api.validate_lot_num(x_org_id,
1830: g_item_id ,
1831: x_value);
1832: ELSE
1833: result := qa_plan_element_api.validate_lot_number(g_transaction_number,

Line 1833: result := qa_plan_element_api.validate_lot_number(g_transaction_number,

1829: result := qa_plan_element_api.validate_lot_num(x_org_id,
1830: g_item_id ,
1831: x_value);
1832: ELSE
1833: result := qa_plan_element_api.validate_lot_number(g_transaction_number,
1834: g_transaction_id,
1835: x_value);
1836: END IF;
1837:

Line 1842: result := qa_plan_element_api.validate_serial_num(x_org_id,

1838: ELSIF (element_id = qa_ss_const.serial_number) THEN
1839:
1840: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1841:
1842: result := qa_plan_element_api.validate_serial_num(x_org_id,
1843: g_item_id,
1844: g_lot_number,
1845: g_revision,
1846: x_value);

Line 1848: result := qa_plan_element_api.validate_serial_number(g_transaction_number,

1844: g_lot_number,
1845: g_revision,
1846: x_value);
1847: ELSE
1848: result := qa_plan_element_api.validate_serial_number(g_transaction_number,
1849: g_transaction_id,
1850: g_lot_number,
1851: x_value);
1852: END IF;

Line 1858: result := qa_plan_element_api.validate_op_seq_number(

1854: -- End. Bug 4558205.
1855:
1856: ELSIF (element_id = qa_ss_const.to_op_seq_num)
1857: OR (element_id = qa_ss_const.from_op_seq_num) THEN
1858: result := qa_plan_element_api.validate_op_seq_number(
1859: x_org_id, g_line_id,
1860: g_wip_entity_id, x_value);
1861:
1862: --

Line 1870: result := qa_plan_element_api.validate_maintenance_op_seq(

1866: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1867: --
1868:
1869: ELSIF (element_id = qa_ss_const.maintenance_op_seq) THEN
1870: result := qa_plan_element_api.validate_maintenance_op_seq(
1871: x_org_id, g_work_order_id, x_value);
1872: --
1873: -- End of inclusions for Bug 2588213
1874: --

Line 1880: result := qa_plan_element_api.validate_po_line_number(

1876:
1877: ELSIF (element_id = qa_ss_const.po_line_num) THEN
1878:
1879: g_po_line_number := x_value;
1880: result := qa_plan_element_api.validate_po_line_number(
1881: g_po_header_id, x_value);
1882:
1883: ELSIF (element_id = qa_ss_const.po_shipment_num) THEN
1884: result := qa_plan_element_api.validate_po_shipments(

Line 1884: result := qa_plan_element_api.validate_po_shipments(

1880: result := qa_plan_element_api.validate_po_line_number(
1881: g_po_header_id, x_value);
1882:
1883: ELSIF (element_id = qa_ss_const.po_shipment_num) THEN
1884: result := qa_plan_element_api.validate_po_shipments(
1885: g_po_line_number,
1886: g_po_header_id, x_value);
1887:
1888: ELSIF (element_id = qa_ss_const.receipt_num) THEN

Line 1889: result := qa_plan_element_api.validate_receipt_number(x_value);

1885: g_po_line_number,
1886: g_po_header_id, x_value);
1887:
1888: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1889: result := qa_plan_element_api.validate_receipt_number(x_value);
1890:
1891: /*
1892: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1893: result := TRUE;

Line 1909: result := qa_plan_element_api.validate_to_subinventory(

1905: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1906: -- Bug 2449067.
1907:
1908: ELSIF (element_id = qa_ss_const.to_subinventory) THEN
1909: result := qa_plan_element_api.validate_to_subinventory(
1910: x_org_id, x_value);
1911:
1912: /*
1913: ELSIF (element_id = qa_ss_const.lot_status) THEN

Line 1914: result := qa_plan_element_api.validate_lot_status(x_value);

1910: x_org_id, x_value);
1911:
1912: /*
1913: ELSIF (element_id = qa_ss_const.lot_status) THEN
1914: result := qa_plan_element_api.validate_lot_status(x_value);
1915:
1916: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1917: result := TRUE;
1918:

Line 2049: IF qa_plan_element_api.values_exist(plan_id, element_id) THEN

2045: -- The following code was put to reduce element_id check.The existing code
2046: -- for element_id check is commented out after the new code.
2047: -- suramasw Thu Oct 24 05:14:54 PDT 2002.
2048:
2049: IF qa_plan_element_api.values_exist(plan_id, element_id) THEN
2050: RETURN validate_values(plan_id, element_id, value);
2051: END IF;
2052:
2053: /*

Line 2108: sql_string := qa_plan_element_api.get_sql_validation_string(element_id);

2104: IF (value IS NULL) THEN
2105: RETURN ok;
2106: END IF;
2107:
2108: sql_string := qa_plan_element_api.get_sql_validation_string(element_id);
2109:
2110: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
2111: x_org_id, x_user_id);
2112:

Line 2113: IF qa_plan_element_api.value_in_sql (sql_string, value) THEN

2109:
2110: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
2111: x_org_id, x_user_id);
2112:
2113: IF qa_plan_element_api.value_in_sql (sql_string, value) THEN
2114: RETURN ok;
2115:
2116: ELSE
2117: RETURN sql_validation_error;

Line 2146: qa_plan_element_api.get_spec_limits(row_record.plan_id, row_record.spec_id,

2142: -- BUG 3303285
2143: -- ksoh Mon Dec 29 13:33:02 PST 2003
2144: -- call overloaded get_spec_limits that takes in plan_id
2145: -- it performs uom conversion
2146: qa_plan_element_api.get_spec_limits(row_record.plan_id, row_record.spec_id,
2147: element_id,
2148: lower_limit, upper_limit);
2149:
2150: IF (lower_limit IS NULL) OR (upper_limit IS NULL) THEN

Line 2154: datatype := qa_plan_element_api.get_element_datatype(element_id);

2150: IF (lower_limit IS NULL) OR (upper_limit IS NULL) THEN
2151: RETURN ok;
2152: END IF;
2153:
2154: datatype := qa_plan_element_api.get_element_datatype(element_id);
2155:
2156: IF qltcompb.compare(value, 6, lower_limit, null, datatype) THEN
2157: -- if (value < lower_limit) then
2158: RETURN lower_limit_error;

Line 2312: actual_datatype := qa_plan_element_api.get_actual_datatype(element_id);

2308: -- client timezone. It is saving date time in client timezone
2309: -- for child plans due to this, difference is again added when
2310: -- viewing child plans
2311: -- saugupta Wed, 14 Jan 2004 04:39:30 -0800 PDT
2312: actual_datatype := qa_plan_element_api.get_actual_datatype(element_id);
2313:
2314: --
2315: -- See Bug 2624112
2316: -- The decimal precision for a number type collection

Line 2325: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),

2321: --
2322: -- Before this change
2323: -- precision := qa_chars_api.decimal_precision(element_id);
2324: -- After this change
2325: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2326: -- qa_chars_api.decimal_precision(element_id));
2327: --
2328: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2329: --

Line 2331: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),

2327: --
2328: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2329: --
2330:
2331: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2332: qa_chars_api.decimal_precision(element_id));
2333:
2334: IF (data_type = qa_ss_const.date_datatype) THEN
2335: error_code := validate_date(value, result_holder);

Line 2431: -- qa_plan_element_api.get_spec_limits(spec_id, element_id,

2427: -- ksoh Mon Jan 5 12:55:13 PST 2004
2428: -- replaced get_spec_limits, which does not retrieve the
2429: -- correct low high value as it always retrieve reasonable limits
2430: --
2431: -- qa_plan_element_api.get_spec_limits(spec_id, element_id,
2432: -- low_value, high_value);
2433: qa_plan_element_api.get_low_high_values(plan_id, spec_id, element_id,
2434: condition_record.low_value_lookup, condition_record.high_value_lookup,
2435: low_value, high_value);

Line 2433: qa_plan_element_api.get_low_high_values(plan_id, spec_id, element_id,

2429: -- correct low high value as it always retrieve reasonable limits
2430: --
2431: -- qa_plan_element_api.get_spec_limits(spec_id, element_id,
2432: -- low_value, high_value);
2433: qa_plan_element_api.get_low_high_values(plan_id, spec_id, element_id,
2434: condition_record.low_value_lookup, condition_record.high_value_lookup,
2435: low_value, high_value);
2436:
2437: ELSE

Line 2443: datatype := qa_plan_element_api.get_element_datatype(element_id);

2439: high_value := condition_record.high_value_other;
2440:
2441: END IF;
2442:
2443: datatype := qa_plan_element_api.get_element_datatype(element_id);
2444:
2445: IF qltcompb.compare(value, condition_record.operator, low_value,
2446: high_value, datatype) THEN
2447: RETURN TRUE;

Line 2867: target_element := qa_plan_element_api.get_target_element(

2863: RETURN reject_an_entry_error;
2864:
2865: ELSIF (action_id = qa_ss_const.assign_value_action) THEN
2866:
2867: target_element := qa_plan_element_api.get_target_element(
2868: plan_char_action_id);
2869:
2870:
2871: -- Bug 3679762. Check whether target column of assign a value action

Line 2911: IF qa_plan_element_api.keyflex(target_element) THEN

2907:
2908: -- Bug 3397484. Check for the item type keyflex or normalized and then call appropriate
2909: -- validate functions to get the ids.
2910: -- saugupta Wed, 28 Jan 2004 08:02:59 -0800 PDT
2911: IF qa_plan_element_api.keyflex(target_element) THEN
2912: error_code := validate_keyflex(row_elements, row_record,
2913: target_element, assigned_value, back_result_holder);
2914:
2915: return_results_array(target_element).id := back_result_holder.id;

Line 2927: ELSIF qa_plan_element_api.normalized(target_element) THEN

2923: IF (p_ssqr_operation IS NOT NULL) THEN
2924: ordered_array(target_element).validation_flag := invalid_element;
2925: END IF;
2926:
2927: ELSIF qa_plan_element_api.normalized(target_element) THEN
2928: error_code := validate_normalized(row_elements, row_record,
2929: target_element, assigned_value, back_result_holder);
2930:
2931: return_results_array(target_element).id := back_result_holder.id;

Line 3168: IF qa_plan_element_api.validate_transaction_type(g_transaction_number,p_org_id,

3164: IF (value IS NULL) THEN
3165: RETURN ok;
3166: END IF;
3167:
3168: IF qa_plan_element_api.validate_transaction_type(g_transaction_number,p_org_id,
3169: p_user_id, value) THEN
3170: RETURN ok;
3171: ELSE
3172: RETURN value_not_in_sql_error;

Line 3270: qa_plan_element_api.get_actual_datatype (element_id);

3266: g_org_id := org_id;
3267: element_value := row_elements(element_id).value;
3268:
3269: result_holder.actual_datatype :=
3270: qa_plan_element_api.get_actual_datatype (element_id);
3271:
3272: error_list(1).error_code := validate_enabled (row_record.plan_id,
3273: element_id);
3274:

Line 3304: IF qa_plan_element_api.keyflex(element_id) THEN

3300:
3301: error_list(3).error_code := validate_datatype(row_record.plan_id,
3302: element_id, element_value, row_elements, result_holder);
3303:
3304: IF qa_plan_element_api.keyflex(element_id) THEN
3305: error_list(4).error_code := validate_keyflex(row_elements, row_record,
3306: element_id, element_value, result_holder);
3307:
3308: ELSIF qa_plan_element_api.normalized(element_id) THEN

Line 3308: ELSIF qa_plan_element_api.normalized(element_id) THEN

3304: IF qa_plan_element_api.keyflex(element_id) THEN
3305: error_list(4).error_code := validate_keyflex(row_elements, row_record,
3306: element_id, element_value, result_holder);
3307:
3308: ELSIF qa_plan_element_api.normalized(element_id) THEN
3309: error_list(4).error_code := validate_normalized(row_elements,
3310: row_record, element_id, element_value, result_holder);
3311:
3312: ELSIF qa_plan_element_api.primitive(element_id) THEN

Line 3312: ELSIF qa_plan_element_api.primitive(element_id) THEN

3308: ELSIF qa_plan_element_api.normalized(element_id) THEN
3309: error_list(4).error_code := validate_normalized(row_elements,
3310: row_record, element_id, element_value, result_holder);
3311:
3312: ELSIF qa_plan_element_api.primitive(element_id) THEN
3313: error_list(4).error_code := validate_primitive(row_record.plan_id,
3314: row_elements, row_record, element_id, element_value);
3315:
3316: -- Bug 4519558. OA Framework integration project. UT bug fix.

Line 3325: ELSIF qa_plan_element_api.values_exist(row_record.plan_id, element_id) THEN

3321: ELSIF element_id = qa_ss_const.transaction_type THEN
3322: error_list(4).error_code := validate_transaction_type(element_value,
3323: g_org_id,row_record.user_id);
3324:
3325: ELSIF qa_plan_element_api.values_exist(row_record.plan_id, element_id) THEN
3326: error_list(4).error_code := validate_values(row_record.plan_id,
3327: element_id, element_value);
3328:
3329: ELSIF qa_plan_element_api.sql_validation_exists(element_id) THEN

Line 3329: ELSIF qa_plan_element_api.sql_validation_exists(element_id) THEN

3325: ELSIF qa_plan_element_api.values_exist(row_record.plan_id, element_id) THEN
3326: error_list(4).error_code := validate_values(row_record.plan_id,
3327: element_id, element_value);
3328:
3329: ELSIF qa_plan_element_api.sql_validation_exists(element_id) THEN
3330: error_list(4).error_code := validate_sql(element_id, element_value,
3331: row_record.org_id, row_record.user_id);
3332:
3333: ELSE -- For

Line 3437: qa_plan_element_api.primitive(ordered_array(i).id) THEN

3433: -- Also removed primitive call from below OR list.
3434: -- srhariha. Thu May 26 02:38:04 PDT 2005.
3435:
3436: IF flag_is_set(ordered_array(i).validation_flag,valid_element) AND
3437: qa_plan_element_api.primitive(ordered_array(i).id) THEN
3438:
3439: copy_primitive_to_global(p_element_id => ordered_array(i).id,
3440: p_value => row_elements(ordered_array(i).id).value);
3441: END IF;

Line 3446: OR qa_plan_element_api.keyflex(ordered_array(i).id)

3442:
3443:
3444: IF NOT flag_is_set(ordered_array(i).validation_flag,
3445: valid_element)
3446: OR qa_plan_element_api.keyflex(ordered_array(i).id)
3447: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN
3448: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN
3449:
3450: -- 12.1 QWB Usabiltiy Improvements

Line 3447: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN

3443:
3444: IF NOT flag_is_set(ordered_array(i).validation_flag,
3445: valid_element)
3446: OR qa_plan_element_api.keyflex(ordered_array(i).id)
3447: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN
3448: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN
3449:
3450: -- 12.1 QWB Usabiltiy Improvements
3451: -- Passing the Org Id parameter

Line 3448: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN

3444: IF NOT flag_is_set(ordered_array(i).validation_flag,
3445: valid_element)
3446: OR qa_plan_element_api.keyflex(ordered_array(i).id)
3447: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN
3448: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN
3449:
3450: -- 12.1 QWB Usabiltiy Improvements
3451: -- Passing the Org Id parameter
3452: error_list := validate_element( row_elements, row_record,

Line 3495: result_holder.actual_datatype := qa_plan_element_api.get_actual_datatype(

3491: error_list(1).error_code := validate_datatype(row_record.plan_id,
3492: ordered_array(i).id , row_elements(ordered_array(i).id).value,
3493: row_elements, result_holder);
3494:
3495: result_holder.actual_datatype := qa_plan_element_api.get_actual_datatype(
3496: ordered_array(i).id);
3497:
3498: END IF;
3499:

Line 4145: ((qa_plan_element_api.keyflex(p_element_id) OR

4141: -- This is done in the ELSE part
4142: -- ntungare
4143: --
4144: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND
4145: ((qa_plan_element_api.keyflex(p_element_id) OR
4146: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN
4147:
4148: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);
4149: message := replace_message_tokens(message_str);

Line 4146: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN

4142: -- ntungare
4143: --
4144: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND
4145: ((qa_plan_element_api.keyflex(p_element_id) OR
4146: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN
4147:
4148: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);
4149: message := replace_message_tokens(message_str);
4150:

Line 4164: IF ((qa_plan_element_api.keyflex(p_element_id) OR

4160: message := replace_message_tokens(message_str);
4161: END IF;
4162:
4163: -- Set the normalized value for HC element
4164: IF ((qa_plan_element_api.keyflex(p_element_id) OR
4165: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN
4166: normalized_id_val := result_record.id;
4167: -- Set the normalized element VO attribute
4168: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);

Line 4165: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN

4161: END IF;
4162:
4163: -- Set the normalized value for HC element
4164: IF ((qa_plan_element_api.keyflex(p_element_id) OR
4165: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN
4166: normalized_id_val := result_record.id;
4167: -- Set the normalized element VO attribute
4168: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);
4169:

Line 4180: QA_PLAN_ELEMENT_API.process_dependent_elements(

4176: l_id_string := LTRIM(l_id_string, '@');
4177: END IF;
4178:
4179: -- Process dependent elements
4180: QA_PLAN_ELEMENT_API.process_dependent_elements(
4181: l_result_string,
4182: l_id_string,
4183: p_org_id,
4184: p_plan_id,

Line 4357: qa_plan_element_api.get_actual_datatype(ordered_array2(charctr).id);

4353: p_row_elements(ordered_array2(charctr).id).id;
4354:
4355: -- Assinging the Actual data Type
4356: p_return_results_array(ordered_array2(charctr).id).actual_datatype :=
4357: qa_plan_element_api.get_actual_datatype(ordered_array2(charctr).id);
4358:
4359: -- Assinging the Deferenced value
4360: p_return_results_array(ordered_array2(charctr).id).canonical_value :=
4361: p_row_elements(ordered_array2(charctr).id).value;

Line 4374: result_holder.actual_datatype := qa_plan_element_api.get_actual_datatype(charctr);

4370: -- Set the canonical value
4371: result_holder.canonical_value := p_return_results_array(ordered_array2(charctr).id).canonical_value;
4372: END If;
4373:
4374: result_holder.actual_datatype := qa_plan_element_api.get_actual_datatype(charctr);
4375:
4376: IF (NOT (flag_is_set(ordered_array2(charctr).validation_flag,action_fired))) THEN
4377: error_list(6).error_code := fire_immediate_actions (
4378: p_plan_id,