[Home] [Help]
265: END LOOP;
266:
267: -- Validate shipment number is unique
268: FORALL i IN 1 .. p_id_tbl.COUNT
269: INSERT INTO po_validation_results_gt
270: (result_set_id,
271: result_type,
272: entity_type,
273: entity_id,
566:
567: -- If item_id is not null and ship_to_organization_id is not null, and
568: -- item_revision is not null and no record exists in mtl_item_revisions.
569: FORALL i IN 1 .. p_id_tbl.COUNT
570: INSERT INTO po_validation_results_gt
571: (result_set_id,
572: result_type,
573: entity_type,
574: entity_id,
607: -- item_revision is null, and no record exists in mtl_system_items.
608: -- Bug7513119 - Non revision controlled items were also getting validated
609: -- against mtl_item_revisions, changed this to mtl_system_items.
610: FORALL i IN 1 .. p_id_tbl.COUNT
611: INSERT INTO po_validation_results_gt
612: (result_set_id,
613: result_type,
614: entity_type,
615: entity_id,
645:
646: -- If item_id is null, and ship_to_organization_id is not null,
647: -- validate ship_to_organization_id against org_organization_definitions
648: FORALL i IN 1 .. p_id_tbl.COUNT
649: INSERT INTO po_validation_results_gt
650: (result_set_id,
651: result_type,
652: entity_type,
653: entity_id,
684: -- If ship_to_location_id is not null, check if record exists in
685: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.
686: -- If no record exists, or multiple records exist, then error.
687: FORALL i IN 1 .. p_id_tbl.COUNT
688: INSERT INTO po_validation_results_gt
689: (result_set_id,
690: result_type,
691: entity_type,
692: entity_id,
996: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
997: END IF;
998:
999: FORALL i IN 1 .. p_id_tbl.COUNT
1000: INSERT INTO po_validation_results_gt
1001: (result_set_id,
1002: result_type,
1003: entity_type,
1004: entity_id,
1397: END IF;
1398:
1399: -- Validate that receiving routing id exists in rcv_routing_headers
1400: FORALL i IN 1 .. p_id_tbl.COUNT
1401: INSERT INTO po_validation_results_gt
1402: (result_set_id,
1403: result_type,
1404: entity_type,
1405: entity_id,
1515: -- bug5262146
1516: -- Added NVL() around pdsh.price_breaks_flag
1517:
1518: FORALL i IN 1 .. p_id_tbl.COUNT
1519: INSERT INTO po_validation_results_gt
1520: (result_set_id,
1521: result_type,
1522: entity_type,
1523: entity_id,
1593:
1594: -- Bug 4965755. Modified both queries to include -99 as valid orgs in zx
1595: -- tax_name must be valid if not null
1596: FORALL i IN 1 .. p_id_tbl.COUNT
1597: INSERT INTO po_validation_results_gt
1598: (result_set_id,
1599: result_type,
1600: entity_type,
1601: entity_id,
1636:
1637: -- tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
1638: -- if both are not null
1639: FORALL i IN 1 .. p_id_tbl.COUNT
1640: INSERT INTO po_validation_results_gt
1641: (result_set_id,
1642: result_type,
1643: entity_type,
1644: entity_id,
1717: x_result_type := po_validations.c_result_type_success;
1718:
1719: -- fob_lookup_code must be valid if not null
1720: FORALL i IN 1 .. p_id_tbl.COUNT
1721: INSERT INTO po_validation_results_gt
1722: (result_set_id,
1723: result_type,
1724: entity_type,
1725: entity_id,
1788: x_result_type := po_validations.c_result_type_success;
1789:
1790: -- freight_terms must be valid if not null
1791: FORALL i IN 1 .. p_id_tbl.COUNT
1792: INSERT INTO po_validation_results_gt
1793: (result_set_id,
1794: result_type,
1795: entity_type,
1796: entity_id,
1861: x_result_type := po_validations.c_result_type_success;
1862:
1863: -- freight_carrier must be valid if not null
1864: FORALL i IN 1 .. p_id_tbl.COUNT
1865: INSERT INTO po_validation_results_gt
1866: (result_set_id,
1867: result_type,
1868: entity_type,
1869: entity_id,