[Home] [Help]
498: END LOOP;
499:
500: -- Validate shipment number is unique
501: FORALL i IN 1 .. p_id_tbl.COUNT
502: INSERT INTO po_validation_results_gt
503: (result_set_id,
504: result_type,
505: entity_type,
506: entity_id,
930:
931: -- If item_id is not null and ship_to_organization_id is not null, and
932: -- item_revision is not null and no record exists in mtl_item_revisions.
933: FORALL i IN 1 .. p_id_tbl.COUNT
934: INSERT INTO po_validation_results_gt
935: (result_set_id,
936: result_type,
937: entity_type,
938: entity_id,
971: -- item_revision is null, and no record exists in mtl_system_items.
972: -- Bug7513119 - Non revision controlled items were also getting validated
973: -- against mtl_item_revisions, changed this to mtl_system_items.
974: FORALL i IN 1 .. p_id_tbl.COUNT
975: INSERT INTO po_validation_results_gt
976: (result_set_id,
977: result_type,
978: entity_type,
979: entity_id,
1009:
1010: -- If item_id is null, and ship_to_organization_id is not null,
1011: -- validate ship_to_organization_id against org_organization_definitions
1012: FORALL i IN 1 .. p_id_tbl.COUNT
1013: INSERT INTO po_validation_results_gt
1014: (result_set_id,
1015: result_type,
1016: entity_type,
1017: entity_id,
1048: -- If ship_to_location_id is not null, check if record exists in
1049: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.
1050: -- If no record exists, or multiple records exist, then error.
1051: FORALL i IN 1 .. p_id_tbl.COUNT
1052: INSERT INTO po_validation_results_gt
1053: (result_set_id,
1054: result_type,
1055: entity_type,
1056: entity_id,
1360: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1361: END IF;
1362:
1363: FORALL i IN 1 .. p_id_tbl.COUNT
1364: INSERT INTO po_validation_results_gt
1365: (result_set_id,
1366: result_type,
1367: entity_type,
1368: entity_id,
1761: END IF;
1762:
1763: -- Validate that receiving routing id exists in rcv_routing_headers
1764: FORALL i IN 1 .. p_id_tbl.COUNT
1765: INSERT INTO po_validation_results_gt
1766: (result_set_id,
1767: result_type,
1768: entity_type,
1769: entity_id,
1938: -- bug5262146
1939: -- Added NVL() around pdsh.price_breaks_flag
1940:
1941: FORALL i IN 1 .. p_id_tbl.COUNT
1942: INSERT INTO po_validation_results_gt
1943: (result_set_id,
1944: result_type,
1945: entity_type,
1946: entity_id,
2016:
2017: -- Bug 4965755. Modified both queries to include -99 as valid orgs in zx
2018: -- tax_name must be valid if not null
2019: FORALL i IN 1 .. p_id_tbl.COUNT
2020: INSERT INTO po_validation_results_gt
2021: (result_set_id,
2022: result_type,
2023: entity_type,
2024: entity_id,
2059:
2060: -- tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
2061: -- if both are not null
2062: FORALL i IN 1 .. p_id_tbl.COUNT
2063: INSERT INTO po_validation_results_gt
2064: (result_set_id,
2065: result_type,
2066: entity_type,
2067: entity_id,
2140: x_result_type := po_validations.c_result_type_success;
2141:
2142: -- fob_lookup_code must be valid if not null
2143: FORALL i IN 1 .. p_id_tbl.COUNT
2144: INSERT INTO po_validation_results_gt
2145: (result_set_id,
2146: result_type,
2147: entity_type,
2148: entity_id,
2211: x_result_type := po_validations.c_result_type_success;
2212:
2213: -- freight_terms must be valid if not null
2214: FORALL i IN 1 .. p_id_tbl.COUNT
2215: INSERT INTO po_validation_results_gt
2216: (result_set_id,
2217: result_type,
2218: entity_type,
2219: entity_id,
2284: x_result_type := po_validations.c_result_type_success;
2285:
2286: -- freight_carrier must be valid if not null
2287: FORALL i IN 1 .. p_id_tbl.COUNT
2288: INSERT INTO po_validation_results_gt
2289: (result_set_id,
2290: result_type,
2291: entity_type,
2292: entity_id,