[Home] [Help]
518: flag NUMBER;
519:
520: BEGIN
521:
522: flag := qa_plan_element_api.get_enabled_flag(plan_id, element_id);
523:
524: IF (flag = 1) THEN
525: RETURN ok;
526: ELSE
677: value);
678: END IF;
679:
680:
681: m_flag := qa_plan_element_api.get_mandatory_flag(row_record.plan_id,
682: element_id);
683:
684: IF ( (m_flag = 2) or (value IS NOT NULL) ) THEN
685: RETURN ok;
742: -- if the vlaue for so line number is NULL then
743: -- x_where_clause := NULL;
744: --
745:
746: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
747: qa_ss_const.production_line) AND
748: row_elements.exists(qa_ss_const.production_line) AND
749: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
750:
997: RETURN not_locator_controlled_error;
998: END IF;
999: END IF;
1000:
1001: mandatory_flag := qa_plan_element_api.get_mandatory_flag(
1002: row_record.plan_id, element_id);
1003:
1004: IF ( (mandatory_flag = 1) and (value IS NULL) ) THEN
1005:
1141: RETURN not_locator_controlled_error;
1142: END IF;
1143: END IF;
1144:
1145: mandatory_flag := qa_plan_element_api.get_mandatory_flag(
1146: row_record.plan_id, element_id);
1147:
1148: IF ( (mandatory_flag = 1) and (value IS NULL) ) THEN
1149: RETURN mandatory_error;
1402: RETURN not_locator_controlled_error;
1403: END IF;
1404: END IF;
1405:
1406: mandatory_flag := qa_plan_element_api.get_mandatory_flag(
1407: row_record.plan_id, element_id);
1408:
1409: IF ( (mandatory_flag = 1) and (value IS NULL) ) THEN
1410:
1590: BEGIN
1591:
1592: IF (element_id = qa_ss_const.department)
1593: OR (element_id = qa_ss_const.to_department) THEN
1594: id := qa_plan_element_api.get_department_id(x_org_id, value);
1595:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1597: id := qa_plan_element_api.get_job_id(x_org_id, value);
1598:
1593: OR (element_id = qa_ss_const.to_department) THEN
1594: id := qa_plan_element_api.get_department_id(x_org_id, value);
1595:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1597: id := qa_plan_element_api.get_job_id(x_org_id, value);
1598:
1599: ELSIF (element_id = qa_ss_const.production_line) THEN
1600: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1601:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1597: id := qa_plan_element_api.get_job_id(x_org_id, value);
1598:
1599: ELSIF (element_id = qa_ss_const.production_line) THEN
1600: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1601:
1602: ELSIF (element_id = qa_ss_const.resource_code) THEN
1603: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1604:
1599: ELSIF (element_id = qa_ss_const.production_line) THEN
1600: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1601:
1602: ELSIF (element_id = qa_ss_const.resource_code) THEN
1603: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1604:
1605: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1606: id := qa_plan_element_api.get_supplier_id(value);
1607:
1602: ELSIF (element_id = qa_ss_const.resource_code) THEN
1603: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1604:
1605: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1606: id := qa_plan_element_api.get_supplier_id(value);
1607:
1608: ELSIF (element_id = qa_ss_const.po_number) THEN
1609: id := qa_plan_element_api.get_po_number_id(value);
1610:
1605: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1606: id := qa_plan_element_api.get_supplier_id(value);
1607:
1608: ELSIF (element_id = qa_ss_const.po_number) THEN
1609: id := qa_plan_element_api.get_po_number_id(value);
1610:
1611: ELSIF (element_id = qa_ss_const.customer_name) THEN
1612: id := qa_plan_element_api.get_customer_id(value);
1613:
1608: ELSIF (element_id = qa_ss_const.po_number) THEN
1609: id := qa_plan_element_api.get_po_number_id(value);
1610:
1611: ELSIF (element_id = qa_ss_const.customer_name) THEN
1612: id := qa_plan_element_api.get_customer_id(value);
1613:
1614: ELSIF (element_id = qa_ss_const.sales_order) THEN
1615: id := qa_plan_element_api.get_so_number_id(value);
1616:
1611: ELSIF (element_id = qa_ss_const.customer_name) THEN
1612: id := qa_plan_element_api.get_customer_id(value);
1613:
1614: ELSIF (element_id = qa_ss_const.sales_order) THEN
1615: id := qa_plan_element_api.get_so_number_id(value);
1616:
1617: -- bug 16214422
1618: g_sales_order_id := id;
1619:
1620: ELSIF (element_id = qa_ss_const.order_line) THEN
1621: -- bug 16214422
1622: -- Get the SO line id based on the SO header Id as well
1623: --
1624: --id := qa_plan_element_api.get_so_line_number_id(value);
1625: id := qa_plan_element_api.get_so_line_number_id(value, g_sales_order_id);
1626:
1627: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1628: id := qa_plan_element_api.get_po_release_number_id(value,
1621: -- bug 16214422
1622: -- Get the SO line id based on the SO header Id as well
1623: --
1624: --id := qa_plan_element_api.get_so_line_number_id(value);
1625: id := qa_plan_element_api.get_so_line_number_id(value, g_sales_order_id);
1626:
1627: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1628: id := qa_plan_element_api.get_po_release_number_id(value,
1629: g_po_header_id);
1624: --id := qa_plan_element_api.get_so_line_number_id(value);
1625: id := qa_plan_element_api.get_so_line_number_id(value, g_sales_order_id);
1626:
1627: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1628: id := qa_plan_element_api.get_po_release_number_id(value,
1629: g_po_header_id);
1630:
1631: ELSIF (element_id = qa_ss_const.project_number) THEN
1632: id := qa_plan_element_api.get_project_number_id(value);
1628: id := qa_plan_element_api.get_po_release_number_id(value,
1629: g_po_header_id);
1630:
1631: ELSIF (element_id = qa_ss_const.project_number) THEN
1632: id := qa_plan_element_api.get_project_number_id(value);
1633: --
1634: -- Bug 2672396. Need to keep a cache of the returned project ID
1635: -- bso Mon Nov 25 17:29:56 PST 2002
1636: --
1640: --
1641: -- Bug 2672396. Added g_project_id because task is a dependent element.
1642: -- bso Mon Nov 25 17:29:56 PST 2002
1643: --
1644: id := qa_plan_element_api.get_task_number_id(value, g_project_id);
1645:
1646: ELSIF (element_id = qa_ss_const.rma_number) THEN
1647: id := qa_plan_element_api.get_rma_number_id(value);
1648:
1643: --
1644: id := qa_plan_element_api.get_task_number_id(value, g_project_id);
1645:
1646: ELSIF (element_id = qa_ss_const.rma_number) THEN
1647: id := qa_plan_element_api.get_rma_number_id(value);
1648:
1649: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1650: id := qa_plan_element_api.get_lpn_id(value);
1651:
1646: ELSIF (element_id = qa_ss_const.rma_number) THEN
1647: id := qa_plan_element_api.get_rma_number_id(value);
1648:
1649: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1650: id := qa_plan_element_api.get_lpn_id(value);
1651:
1652: -- added the following to include new hardcoded element Transfer license plate number
1653: -- saugupta
1654:
1652: -- added the following to include new hardcoded element Transfer license plate number
1653: -- saugupta
1654:
1655: ELSIF (element_id = qa_ss_const.xfr_license_plate_number) THEN
1656: id := qa_plan_element_api.get_xfr_lpn_id(value);
1657:
1658:
1659: ELSIF (element_id = qa_ss_const.contract_number) THEN
1660: id := qa_plan_element_api.get_contract_id(value);
1656: id := qa_plan_element_api.get_xfr_lpn_id(value);
1657:
1658:
1659: ELSIF (element_id = qa_ss_const.contract_number) THEN
1660: id := qa_plan_element_api.get_contract_id(value);
1661:
1662: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1663: id := qa_plan_element_api.get_contract_line_id(value);
1664:
1659: ELSIF (element_id = qa_ss_const.contract_number) THEN
1660: id := qa_plan_element_api.get_contract_id(value);
1661:
1662: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1663: id := qa_plan_element_api.get_contract_line_id(value);
1664:
1665: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1666: id := qa_plan_element_api.get_deliverable_id(value);
1667:
1662: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1663: id := qa_plan_element_api.get_contract_line_id(value);
1664:
1665: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1666: id := qa_plan_element_api.get_deliverable_id(value);
1667:
1668: ELSIF (element_id = qa_ss_const.work_order) THEN
1669: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1670:
1665: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1666: id := qa_plan_element_api.get_deliverable_id(value);
1667:
1668: ELSIF (element_id = qa_ss_const.work_order) THEN
1669: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1670:
1671: --dgupta: Start R12 EAM Integration. Bug 4345492
1672: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1673: id := qa_plan_element_api.get_asset_instance_id(value);
1669: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1670:
1671: --dgupta: Start R12 EAM Integration. Bug 4345492
1672: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1673: id := qa_plan_element_api.get_asset_instance_id(value);
1674: --dgupta: End R12 EAM Integration. Bug 4345492
1675:
1676: ELSIF (element_id = qa_ss_const.party_name) THEN
1677: id := qa_plan_element_api.get_party_id(value);
1673: id := qa_plan_element_api.get_asset_instance_id(value);
1674: --dgupta: End R12 EAM Integration. Bug 4345492
1675:
1676: ELSIF (element_id = qa_ss_const.party_name) THEN
1677: id := qa_plan_element_api.get_party_id(value);
1678:
1679: ELSIF (element_id = qa_ss_const.item_instance) THEN
1680: id := qa_plan_element_api.get_item_instance_id(value);
1681:
1676: ELSIF (element_id = qa_ss_const.party_name) THEN
1677: id := qa_plan_element_api.get_party_id(value);
1678:
1679: ELSIF (element_id = qa_ss_const.item_instance) THEN
1680: id := qa_plan_element_api.get_item_instance_id(value);
1681:
1682: ELSIF (element_id = qa_ss_const.service_request) THEN
1683: id := qa_plan_element_api.get_service_request_id(value);
1684:
1679: ELSIF (element_id = qa_ss_const.item_instance) THEN
1680: id := qa_plan_element_api.get_item_instance_id(value);
1681:
1682: ELSIF (element_id = qa_ss_const.service_request) THEN
1683: id := qa_plan_element_api.get_service_request_id(value);
1684:
1685: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1686: id := qa_plan_element_api.get_maintenance_req_id(value);
1687:
1682: ELSIF (element_id = qa_ss_const.service_request) THEN
1683: id := qa_plan_element_api.get_service_request_id(value);
1684:
1685: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1686: id := qa_plan_element_api.get_maintenance_req_id(value);
1687:
1688: ELSIF (element_id = qa_ss_const.rework_job) THEN
1689: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1690:
1685: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1686: id := qa_plan_element_api.get_maintenance_req_id(value);
1687:
1688: ELSIF (element_id = qa_ss_const.rework_job) THEN
1689: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1690:
1691: ELSIF (element_id = qa_ss_const.counter_name) THEN
1692: id := qa_plan_element_api.get_counter_name_id(value);
1693:
1688: ELSIF (element_id = qa_ss_const.rework_job) THEN
1689: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1690:
1691: ELSIF (element_id = qa_ss_const.counter_name) THEN
1692: id := qa_plan_element_api.get_counter_name_id(value);
1693:
1694: -- Added the following for NCM Hardcode Elements.
1695: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1696: -- Bug 2449067.
1695: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1696: -- Bug 2449067.
1697:
1698: ELSIF (element_id = qa_ss_const.lot_status) THEN
1699: id := qa_plan_element_api.get_lot_status_id(value);
1700:
1701: ELSIF (element_id = qa_ss_const.serial_status) THEN
1702: id := qa_plan_element_api.get_serial_status_id(value);
1703:
1698: ELSIF (element_id = qa_ss_const.lot_status) THEN
1699: id := qa_plan_element_api.get_lot_status_id(value);
1700:
1701: ELSIF (element_id = qa_ss_const.serial_status) THEN
1702: id := qa_plan_element_api.get_serial_status_id(value);
1703:
1704: -- End of inclusions for NCM Hardcode Elements.
1705:
1706: -- R12 OPM Deviations. Bug 4345503 Start
1704: -- End of inclusions for NCM Hardcode Elements.
1705:
1706: -- R12 OPM Deviations. Bug 4345503 Start
1707: ELSIF (element_id = qa_ss_const.process_batch_num) THEN
1708: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1709: g_process_batch_id := id;
1710:
1711: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1712: id := qa_plan_element_api.get_process_batchstep_id
1708: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1709: g_process_batch_id := id;
1710:
1711: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1712: id := qa_plan_element_api.get_process_batchstep_id
1713: (value,g_process_batch_id);
1714: g_process_batchstep_id := id;
1715:
1716: ELSIF (element_id = qa_ss_const.process_operation) THEN
1713: (value,g_process_batch_id);
1714: g_process_batchstep_id := id;
1715:
1716: ELSIF (element_id = qa_ss_const.process_operation) THEN
1717: id := qa_plan_element_api.get_process_operation_id
1718: (value,g_process_batch_id,g_process_batchstep_id);
1719:
1720: ELSIF (element_id = qa_ss_const.process_activity) THEN
1721: id := qa_plan_element_api.get_process_activity_id
1717: id := qa_plan_element_api.get_process_operation_id
1718: (value,g_process_batch_id,g_process_batchstep_id);
1719:
1720: ELSIF (element_id = qa_ss_const.process_activity) THEN
1721: id := qa_plan_element_api.get_process_activity_id
1722: (value,g_process_batch_id,g_process_batchstep_id);
1723: g_process_activity_id := id;
1724:
1725: ELSIF (element_id = qa_ss_const.process_resource) THEN
1722: (value,g_process_batch_id,g_process_batchstep_id);
1723: g_process_activity_id := id;
1724:
1725: ELSIF (element_id = qa_ss_const.process_resource) THEN
1726: id := qa_plan_element_api.get_process_resource_id
1727: (value,g_process_batch_id,
1728: g_process_batchstep_id, g_process_activity_id);
1729: g_process_resource_id := id;
1730: ELSIF (element_id = qa_ss_const.process_parameter) THEN
1727: (value,g_process_batch_id,
1728: g_process_batchstep_id, g_process_activity_id);
1729: g_process_resource_id := id;
1730: ELSIF (element_id = qa_ss_const.process_parameter) THEN
1731: id := qa_plan_element_api.get_process_parameter_id
1732: (value,g_process_resource_id);
1733:
1734: -- R12 OPM Deviations. Bug 4345503 End
1735: --R12 DR Integration . Bug 4345489 start
1733:
1734: -- R12 OPM Deviations. Bug 4345503 End
1735: --R12 DR Integration . Bug 4345489 start
1736: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1737: id := qa_plan_element_api.get_repair_line_id
1738: (value);
1739: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1740: id := qa_plan_element_api.get_jtf_task_id(value);
1741: --R12 Dr Integration. Bug 4345489 end
1736: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1737: id := qa_plan_element_api.get_repair_line_id
1738: (value);
1739: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1740: id := qa_plan_element_api.get_jtf_task_id(value);
1741: --R12 Dr Integration. Bug 4345489 end
1742: END IF;
1743:
1744: RETURN id;
1829:
1830: -- Transaction Date is validated only in PO Inspection Transaction
1831:
1832: IF (element_id = qa_ss_const.transaction_date) THEN
1833: result := qa_plan_element_api.validate_transaction_date(
1834: g_transaction_number);
1835: --
1836: -- Bug 8690822
1837: -- Separating the condition for UOM and Comp UOM,
1839: -- skolluku
1840: --
1841: ELSIF (element_id = qa_ss_const.uom) THEN
1842: --OR (element_id = qa_ss_const.comp_uom) THEN
1843: result := qa_plan_element_api.validate_uom(
1844: x_org_id, g_item_id, x_value);
1845: --
1846: -- Bug 8690822
1847: -- Pass g_comp_item_id to validate_uom, as the validation has
1848: -- to be done for Comp UOM and not UOM.
1849: -- skolluku
1850: --
1851: ELSIF (element_id = qa_ss_const.comp_uom) THEN
1852: result := qa_plan_element_api.validate_uom(
1853: x_org_id, g_comp_item_id, x_value);
1854:
1855: ELSIF (element_id = qa_ss_const.revision)
1856: OR (element_id = qa_ss_const.comp_revision) THEN
1853: x_org_id, g_comp_item_id, x_value);
1854:
1855: ELSIF (element_id = qa_ss_const.revision)
1856: OR (element_id = qa_ss_const.comp_revision) THEN
1857: result := qa_plan_element_api.validate_revision(
1858: x_org_id, g_item_id, x_value);
1859:
1860: ELSIF (element_id = qa_ss_const.subinventory)
1861: OR (element_id = qa_ss_const.comp_subinventory) THEN
1858: x_org_id, g_item_id, x_value);
1859:
1860: ELSIF (element_id = qa_ss_const.subinventory)
1861: OR (element_id = qa_ss_const.comp_subinventory) THEN
1862: result := qa_plan_element_api.validate_subinventory(
1863: x_org_id, x_value);
1864:
1865: -- Bug 4558205. OA Framewok Integration UT bug fix.
1866: -- Lot and serial numbers are not validated in server
1868: -- srhariha. Tue Sep 27 03:14:23 PDT 2005.
1869:
1870: ELSIF (element_id = qa_ss_const.lot_number) THEN
1871: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1872: result := qa_plan_element_api.validate_lot_num(x_org_id,
1873: g_item_id ,
1874: x_value);
1875: ELSE
1876: result := qa_plan_element_api.validate_lot_number(g_transaction_number,
1872: result := qa_plan_element_api.validate_lot_num(x_org_id,
1873: g_item_id ,
1874: x_value);
1875: ELSE
1876: result := qa_plan_element_api.validate_lot_number(g_transaction_number,
1877: g_transaction_id,
1878: x_value);
1879: END IF;
1880:
1881: ELSIF (element_id = qa_ss_const.serial_number) THEN
1882:
1883: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1884:
1885: result := qa_plan_element_api.validate_serial_num(x_org_id,
1886: g_item_id,
1887: g_lot_number,
1888: g_revision,
1889: x_value);
1887: g_lot_number,
1888: g_revision,
1889: x_value);
1890: ELSE
1891: result := qa_plan_element_api.validate_serial_number(g_transaction_number,
1892: g_transaction_id,
1893: g_lot_number,
1894: x_value);
1895: END IF;
1897: -- End. Bug 4558205.
1898:
1899: ELSIF (element_id = qa_ss_const.to_op_seq_num)
1900: OR (element_id = qa_ss_const.from_op_seq_num) THEN
1901: result := qa_plan_element_api.validate_op_seq_number(
1902: x_org_id, g_line_id,
1903: g_wip_entity_id, x_value);
1904:
1905: --
1909: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1910: --
1911:
1912: ELSIF (element_id = qa_ss_const.maintenance_op_seq) THEN
1913: result := qa_plan_element_api.validate_maintenance_op_seq(
1914: x_org_id, g_work_order_id, x_value);
1915: --
1916: -- End of inclusions for Bug 2588213
1917: --
1919:
1920: ELSIF (element_id = qa_ss_const.po_line_num) THEN
1921:
1922: g_po_line_number := x_value;
1923: result := qa_plan_element_api.validate_po_line_number(
1924: g_po_header_id, x_value);
1925:
1926: ELSIF (element_id = qa_ss_const.po_shipment_num) THEN
1927: result := qa_plan_element_api.validate_po_shipments(
1923: result := qa_plan_element_api.validate_po_line_number(
1924: g_po_header_id, x_value);
1925:
1926: ELSIF (element_id = qa_ss_const.po_shipment_num) THEN
1927: result := qa_plan_element_api.validate_po_shipments(
1928: g_po_line_number,
1929: g_po_header_id, x_value);
1930:
1931: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1928: g_po_line_number,
1929: g_po_header_id, x_value);
1930:
1931: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1932: result := qa_plan_element_api.validate_receipt_number(x_value);
1933:
1934: /*
1935: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1936: result := TRUE;
1948: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1949: -- Bug 2449067.
1950:
1951: ELSIF (element_id = qa_ss_const.to_subinventory) THEN
1952: result := qa_plan_element_api.validate_to_subinventory(
1953: x_org_id, x_value);
1954:
1955: /*
1956: ELSIF (element_id = qa_ss_const.lot_status) THEN
1953: x_org_id, x_value);
1954:
1955: /*
1956: ELSIF (element_id = qa_ss_const.lot_status) THEN
1957: result := qa_plan_element_api.validate_lot_status(x_value);
1958:
1959: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1960: result := TRUE;
1961:
2088: -- The following code was put to reduce element_id check.The existing code
2089: -- for element_id check is commented out after the new code.
2090: -- suramasw Thu Oct 24 05:14:54 PDT 2002.
2091:
2092: IF qa_plan_element_api.values_exist(plan_id, element_id) THEN
2093: RETURN validate_values(plan_id, element_id, value);
2094: END IF;
2095:
2096: /*
2147: IF (value IS NULL) THEN
2148: RETURN ok;
2149: END IF;
2150:
2151: sql_string := qa_plan_element_api.get_sql_validation_string(element_id);
2152:
2153: --
2154: -- Bug 9773062
2155: -- For all elements which need bind variables, add them to following block
2176:
2177: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
2178: x_org_id, x_user_id);
2179:
2180: IF qa_plan_element_api.value_in_sql (sql_string, value) THEN
2181: RETURN ok;
2182:
2183: ELSE
2184: RETURN sql_validation_error;
2209: -- BUG 3303285
2210: -- ksoh Mon Dec 29 13:33:02 PST 2003
2211: -- call overloaded get_spec_limits that takes in plan_id
2212: -- it performs uom conversion
2213: qa_plan_element_api.get_spec_limits(row_record.plan_id, row_record.spec_id,
2214: element_id,
2215: lower_limit, upper_limit);
2216:
2217: IF (lower_limit IS NULL) OR (upper_limit IS NULL) THEN
2217: IF (lower_limit IS NULL) OR (upper_limit IS NULL) THEN
2218: RETURN ok;
2219: END IF;
2220:
2221: datatype := qa_plan_element_api.get_element_datatype(element_id);
2222:
2223: IF qltcompb.compare(value, 6, lower_limit, null, datatype) THEN
2224: -- if (value < lower_limit) then
2225: RETURN lower_limit_error;
2375: -- client timezone. It is saving date time in client timezone
2376: -- for child plans due to this, difference is again added when
2377: -- viewing child plans
2378: -- saugupta Wed, 14 Jan 2004 04:39:30 -0800 PDT
2379: actual_datatype := qa_plan_element_api.get_actual_datatype(element_id);
2380:
2381: --
2382: -- See Bug 2624112
2383: -- The decimal precision for a number type collection
2388: --
2389: -- Before this change
2390: -- precision := qa_chars_api.decimal_precision(element_id);
2391: -- After this change
2392: -- precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2393: -- qa_chars_api.decimal_precision(element_id));
2394: --
2395: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2396: --
2394: --
2395: -- rkunchal Wed Oct 16 05:32:33 PDT 2002
2396: --
2397:
2398: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2399: qa_chars_api.decimal_precision(element_id));
2400:
2401: IF (data_type = qa_ss_const.date_datatype) THEN
2402: error_code := validate_date(value, result_holder);
2494: -- ksoh Mon Jan 5 12:55:13 PST 2004
2495: -- replaced get_spec_limits, which does not retrieve the
2496: -- correct low high value as it always retrieve reasonable limits
2497: --
2498: -- qa_plan_element_api.get_spec_limits(spec_id, element_id,
2499: -- low_value, high_value);
2500: qa_plan_element_api.get_low_high_values(plan_id, spec_id, element_id,
2501: condition_record.low_value_lookup, condition_record.high_value_lookup,
2502: low_value, high_value);
2496: -- correct low high value as it always retrieve reasonable limits
2497: --
2498: -- qa_plan_element_api.get_spec_limits(spec_id, element_id,
2499: -- low_value, high_value);
2500: qa_plan_element_api.get_low_high_values(plan_id, spec_id, element_id,
2501: condition_record.low_value_lookup, condition_record.high_value_lookup,
2502: low_value, high_value);
2503:
2504: ELSE
2506: high_value := condition_record.high_value_other;
2507:
2508: END IF;
2509:
2510: datatype := qa_plan_element_api.get_element_datatype(element_id);
2511:
2512: IF qltcompb.compare(value, condition_record.operator, low_value,
2513: high_value, datatype) THEN
2514: RETURN TRUE;
2930: RETURN reject_an_entry_error;
2931:
2932: ELSIF (action_id = qa_ss_const.assign_value_action) THEN
2933:
2934: target_element := qa_plan_element_api.get_target_element(
2935: plan_char_action_id);
2936:
2937:
2938: -- Bug 3679762. Check whether target column of assign a value action
2974:
2975: -- Bug 3397484. Check for the item type keyflex or normalized and then call appropriate
2976: -- validate functions to get the ids.
2977: -- saugupta Wed, 28 Jan 2004 08:02:59 -0800 PDT
2978: IF qa_plan_element_api.keyflex(target_element) THEN
2979: error_code := validate_keyflex(row_elements, row_record,
2980: target_element, assigned_value, back_result_holder);
2981:
2982: return_results_array(target_element).id := back_result_holder.id;
2990: IF (p_ssqr_operation IS NOT NULL) THEN
2991: ordered_array(target_element).validation_flag := invalid_element;
2992: END IF;
2993:
2994: ELSIF qa_plan_element_api.normalized(target_element) THEN
2995: error_code := validate_normalized(row_elements, row_record,
2996: target_element, assigned_value, back_result_holder);
2997:
2998: return_results_array(target_element).id := back_result_holder.id;
3231: IF (value IS NULL) THEN
3232: RETURN ok;
3233: END IF;
3234:
3235: IF qa_plan_element_api.validate_transaction_type(g_transaction_number,p_org_id,
3236: p_user_id, value) THEN
3237: RETURN ok;
3238: ELSE
3239: RETURN value_not_in_sql_error;
3333: g_org_id := org_id;
3334: element_value := row_elements(element_id).value;
3335:
3336: result_holder.actual_datatype :=
3337: qa_plan_element_api.get_actual_datatype (element_id);
3338:
3339: error_list(1).error_code := validate_enabled (row_record.plan_id,
3340: element_id);
3341:
3367:
3368: error_list(3).error_code := validate_datatype(row_record.plan_id,
3369: element_id, element_value, row_elements, result_holder);
3370:
3371: IF qa_plan_element_api.keyflex(element_id) THEN
3372: error_list(4).error_code := validate_keyflex(row_elements, row_record,
3373: element_id, element_value, result_holder);
3374:
3375: ELSIF qa_plan_element_api.normalized(element_id) THEN
3371: IF qa_plan_element_api.keyflex(element_id) THEN
3372: error_list(4).error_code := validate_keyflex(row_elements, row_record,
3373: element_id, element_value, result_holder);
3374:
3375: ELSIF qa_plan_element_api.normalized(element_id) THEN
3376: error_list(4).error_code := validate_normalized(row_elements,
3377: row_record, element_id, element_value, result_holder);
3378:
3379: ELSIF qa_plan_element_api.primitive(element_id) THEN
3375: ELSIF qa_plan_element_api.normalized(element_id) THEN
3376: error_list(4).error_code := validate_normalized(row_elements,
3377: row_record, element_id, element_value, result_holder);
3378:
3379: ELSIF qa_plan_element_api.primitive(element_id) THEN
3380: error_list(4).error_code := validate_primitive(row_record.plan_id,
3381: row_elements, row_record, element_id, element_value);
3382:
3383: -- Bug 4519558. OA Framework integration project. UT bug fix.
3388: ELSIF element_id = qa_ss_const.transaction_type THEN
3389: error_list(4).error_code := validate_transaction_type(element_value,
3390: g_org_id,row_record.user_id);
3391:
3392: ELSIF qa_plan_element_api.values_exist(row_record.plan_id, element_id) THEN
3393: error_list(4).error_code := validate_values(row_record.plan_id,
3394: element_id, element_value);
3395:
3396: -- Bug 7716875.pdube Mon Apr 13 03:25:19 PDT 2009
3395:
3396: -- Bug 7716875.pdube Mon Apr 13 03:25:19 PDT 2009
3397: -- Added condition based on validation_flag which will
3398: -- be true for elements with sql validation for forms and qwb
3399: -- ELSIF qa_plan_element_api.sql_validation_exists(element_id) THEN
3400: -- Bug 10431717
3401: -- Added the NVL condition to ensure that if the flag is NULL then
3402: -- the data is considered as invalid and the validation is performed
3403: --
3400: -- Bug 10431717
3401: -- Added the NVL condition to ensure that if the flag is NULL then
3402: -- the data is considered as invalid and the validation is performed
3403: --
3404: ELSIF qa_plan_element_api.sql_validation_exists(element_id)
3405: AND NOT NVL(row_elements(element_id).validation_flag,'invalid') = 'valid' THEN
3406: error_list(4).error_code := validate_sql(element_id, element_value,
3407: row_record.org_id, row_record.user_id);
3408:
3509: -- Also removed primitive call from below OR list.
3510: -- srhariha. Thu May 26 02:38:04 PDT 2005.
3511:
3512: IF flag_is_set(ordered_array(i).validation_flag,valid_element) AND
3513: qa_plan_element_api.primitive(ordered_array(i).id) THEN
3514:
3515: copy_primitive_to_global(p_element_id => ordered_array(i).id,
3516: p_value => row_elements(ordered_array(i).id).value);
3517: END IF;
3518:
3519:
3520: IF NOT flag_is_set(ordered_array(i).validation_flag,
3521: valid_element)
3522: OR qa_plan_element_api.keyflex(ordered_array(i).id)
3523: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN
3524: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN
3525:
3526: -- 12.1 QWB Usabiltiy Improvements
3519:
3520: IF NOT flag_is_set(ordered_array(i).validation_flag,
3521: valid_element)
3522: OR qa_plan_element_api.keyflex(ordered_array(i).id)
3523: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN
3524: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN
3525:
3526: -- 12.1 QWB Usabiltiy Improvements
3527: -- Passing the Org Id parameter
3520: IF NOT flag_is_set(ordered_array(i).validation_flag,
3521: valid_element)
3522: OR qa_plan_element_api.keyflex(ordered_array(i).id)
3523: OR qa_plan_element_api.normalized(ordered_array(i).id) THEN
3524: -- OR qa_plan_element_api.primitive(ordered_array(i).id) THEN
3525:
3526: -- 12.1 QWB Usabiltiy Improvements
3527: -- Passing the Org Id parameter
3528: error_list := validate_element( row_elements, row_record,
3567: error_list(1).error_code := validate_datatype(row_record.plan_id,
3568: ordered_array(i).id , row_elements(ordered_array(i).id).value,
3569: row_elements, result_holder);
3570:
3571: result_holder.actual_datatype := qa_plan_element_api.get_actual_datatype(
3572: ordered_array(i).id);
3573:
3574: END IF;
3575:
4287: -- This is done in the ELSE part
4288: -- ntungare
4289: --
4290: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND
4291: ((qa_plan_element_api.keyflex(p_element_id) OR
4292: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN
4293:
4294: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);
4295: message := replace_message_tokens(message_str);
4288: -- ntungare
4289: --
4290: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND
4291: ((qa_plan_element_api.keyflex(p_element_id) OR
4292: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN
4293:
4294: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);
4295: message := replace_message_tokens(message_str);
4296:
4306: message := replace_message_tokens(message_str);
4307: END IF;
4308:
4309: -- Set the normalized value for HC element
4310: IF ((qa_plan_element_api.keyflex(p_element_id) OR
4311: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN
4312: normalized_id_val := result_record.id;
4313: -- Set the normalized element VO attribute
4314: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);
4307: END IF;
4308:
4309: -- Set the normalized value for HC element
4310: IF ((qa_plan_element_api.keyflex(p_element_id) OR
4311: qa_plan_element_api.normalized(p_element_id)) = TRUE) THEN
4312: normalized_id_val := result_record.id;
4313: -- Set the normalized element VO attribute
4314: normalized_attr := qa_chars_api.hardcoded_column(p_element_id);
4315:
4322: l_id_string := LTRIM(l_id_string, '@');
4323: END IF;
4324:
4325: -- Process dependent elements
4326: QA_PLAN_ELEMENT_API.process_dependent_elements(
4327: l_result_string,
4328: l_id_string,
4329: p_org_id,
4330: p_plan_id,
4536: p_row_elements(ordered_array2(charctr).id).id;
4537:
4538: -- Assinging the Actual data Type
4539: p_return_results_array(ordered_array2(charctr).id).actual_datatype :=
4540: qa_plan_element_api.get_actual_datatype(ordered_array2(charctr).id);
4541:
4542: -- Assinging the Deferenced value
4543: p_return_results_array(ordered_array2(charctr).id).canonical_value :=
4544: p_row_elements(ordered_array2(charctr).id).value;
4553: -- Set the canonical value
4554: result_holder.canonical_value := p_return_results_array(ordered_array2(charctr).id).canonical_value;
4555: END If;
4556:
4557: result_holder.actual_datatype := qa_plan_element_api.get_actual_datatype(charctr);
4558:
4559: IF (NOT (flag_is_set(ordered_array2(charctr).validation_flag,action_fired))) THEN
4560: error_list(6).error_code := fire_immediate_actions (
4561: p_plan_id,