[Home] [Help]
52: END IF;
53:
54: x_result_type := po_validations.c_result_type_success;
55: FORALL i IN 1 .. p_id_tbl.COUNT
56: INSERT INTO po_validation_results_gt
57: (result_set_id,
58: result_type,
59: entity_type,
60: entity_id,
139:
140: x_result_type := po_validations.c_result_type_success;
141: -- Bulk validate document_num uniqueness
142: FORALL i IN 1 .. p_id_tbl.COUNT
143: INSERT INTO po_validation_results_gt
144: (result_set_id,
145: result_type,
146: entity_type,
147: entity_id,
339:
340: x_result_type := po_validations.c_result_type_success;
341: -- Bulk validate currency_code not null and against FND_CURRENCIES
342: FORALL i IN 1 .. p_id_tbl.COUNT
343: INSERT INTO po_validation_results_gt
344: (result_set_id,
345: result_type,
346: entity_type,
347: entity_id,
562: END LOOP;
563:
564: -- validate rate_type against GL_DAILY_CONVERSION_TYPES
565: FORALL i IN 1 .. p_id_tbl.COUNT
566: INSERT INTO po_validation_results_gt
567: (result_set_id,
568: result_type,
569: entity_type,
570: entity_id,
633:
634: x_result_type := po_validations.c_result_type_success;
635: -- validate agent_id against PO_AGENTS
636: FORALL i IN 1 .. p_id_tbl.COUNT
637: INSERT INTO po_validation_results_gt
638: (result_set_id,
639: result_type,
640: entity_type,
641: entity_id,
738: END IF;
739:
740: x_result_type := po_validations.c_result_type_success;
741: FORALL i IN 1 .. p_id_tbl.COUNT
742: INSERT INTO po_validation_results_gt
743: (result_set_id,
744: result_type,
745: entity_type,
746: entity_id,
775: x_result_type := po_validations.c_result_type_failure;
776: END IF;
777:
778: FORALL i IN 1 .. p_id_tbl.COUNT
779: INSERT INTO po_validation_results_gt
780: (result_set_id,
781: result_type,
782: entity_type,
783: entity_id,
814: x_result_type := po_validations.c_result_type_failure;
815: END IF;
816:
817: FORALL i IN 1 .. p_id_tbl.COUNT
818: INSERT INTO po_validation_results_gt
819: (result_set_id,
820: result_type,
821: entity_type,
822: entity_id,
926:
927: x_result_type := po_validations.c_result_type_success;
928: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
929: FORALL i IN 1 .. p_id_tbl.COUNT
930: INSERT INTO po_validation_results_gt
931: (result_set_id,
932: result_type,
933: entity_type,
934: entity_id,
1009:
1010: x_result_type := po_validations.c_result_type_success;
1011: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
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,
1090: END IF;
1091:
1092: x_result_type := po_validations.c_result_type_success;
1093: FORALL i IN 1 .. p_id_tbl.COUNT
1094: INSERT INTO po_validation_results_gt
1095: (result_set_id,
1096: result_type,
1097: entity_type,
1098: entity_id,
1161: END IF;
1162:
1163: x_result_type := po_validations.c_result_type_success;
1164: FORALL i IN 1 .. p_id_tbl.COUNT
1165: INSERT INTO po_validation_results_gt
1166: (result_set_id,
1167: result_type,
1168: entity_type,
1169: entity_id,
1232: END IF;
1233:
1234: x_result_type := po_validations.c_result_type_success;
1235: FORALL i IN 1 .. p_id_tbl.COUNT
1236: INSERT INTO po_validation_results_gt
1237: (result_set_id,
1238: result_type,
1239: entity_type,
1240: entity_id,
1303: END IF;
1304:
1305: x_result_type := po_validations.c_result_type_success;
1306: FORALL i IN 1 .. p_id_tbl.COUNT
1307: INSERT INTO po_validation_results_gt
1308: (result_set_id,
1309: result_type,
1310: entity_type,
1311: entity_id,
1695: x_result_type := po_validations.c_result_type_success;
1696:
1697: -- validate that the style_id exists in the system and the status is ACTIVE.
1698: FORALL i IN 1 .. p_id_tbl.COUNT
1699: INSERT INTO po_validation_results_gt
1700: (result_set_id,
1701: result_type,
1702: entity_type,
1703: entity_id,
1728: END IF;
1729:
1730: -- validate that complex work is not enabled
1731: FORALL i IN 1 .. p_id_tbl.COUNT
1732: INSERT INTO po_validation_results_gt
1733: (result_set_id,
1734: result_type,
1735: entity_type,
1736: entity_id,