[Home] [Help]
521:
522: -------------------------------------------------------------------------------
523: --Start of Comments
524: --Pre-reqs: None.
525: --Modifies: PO_VALIDATION_RESULTS_GT
526: --Locks: None.
527: --Function:
528: -- Checks that the provided dates are in valid periods for Purchasing
529: -- (open or future-enterable, not adjusting) for the corresponding
607: * the for loop, so that all the validation errors are captured.
608: */
609: FOR i IN 1 .. p_date_tbl.COUNT LOOP
610: IF p_date_tbl(i) IS NOT NULL THEN
611: INSERT INTO PO_VALIDATION_RESULTS_GT
612: ( result_set_id
613: , entity_type
614: , entity_id
615: , column_name
1371:
1372: -------------------------------------------------------------------------------
1373: --Start of Comments
1374: --Pre-reqs: None.
1375: --Modifies: PO_VALIDATION_RESULTS_GT
1376: --Locks: None.
1377: --Function:
1378: -- Checks for notification controls based on amounts,
1379: -- and adds a warning to the results table if any exist.
1439: l_quantity_tbl := p_quantity_tbl;
1440: END IF;
1441:
1442: FORALL i IN 1 .. p_line_id_tbl.COUNT
1443: INSERT INTO PO_VALIDATION_RESULTS_GT
1444: ( result_set_id
1445: , result_type
1446: , entity_type
1447: , entity_id
1717:
1718: -- Check that the child number is unique across the parent.
1719: --
1720: --Added a decode around char1 so that the appropriate message gets inserted into
1721: --PO_VALIDATION_RESULTS_GT.message_name column
1722: --If it is null we would would go with the default message populated in l_message_name
1723: INSERT INTO PO_VALIDATION_RESULTS_GT
1724: ( result_set_id
1725: , entity_type
1719: --
1720: --Added a decode around char1 so that the appropriate message gets inserted into
1721: --PO_VALIDATION_RESULTS_GT.message_name column
1722: --If it is null we would would go with the default message populated in l_message_name
1723: INSERT INTO PO_VALIDATION_RESULTS_GT
1724: ( result_set_id
1725: , entity_type
1726: , entity_id
1727: , column_name
1900: );
1901:
1902:
1903: -- Check that the child number is unique across the parent.
1904: INSERT INTO PO_VALIDATION_RESULTS_GT
1905: ( result_set_id
1906: , entity_type
1907: , entity_id
1908: , column_name
2247:
2248: -------------------------------------------------------------------------------
2249: --Start of Comments
2250: --Pre-reqs: None.
2251: --Modifies: PO_VALIDATION_RESULTS_GT
2252: --Locks: None.
2253: --Function:
2254: -- Validates the terms_id agains ap_terms
2255: -- and adds an error to the results table if it's invalid.
2296: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2297: END IF;
2298:
2299: FORALL i IN 1 .. p_entity_id_tbl.COUNT
2300: INSERT INTO PO_VALIDATION_RESULTS_GT
2301: (result_set_id,
2302: result_type,
2303: entity_type,
2304: entity_id,
3008:
3009: x_result_type := po_validations.c_result_type_success;
3010:
3011: FORALL i IN 1 .. p_id_tbl.COUNT
3012: INSERT INTO po_validation_results_gt
3013: (result_set_id,
3014: result_type,
3015: entity_type,
3016: entity_id,
3130: END IF;
3131: END LOOP;
3132:
3133: FORALL i IN 1 .. p_id_tbl.COUNT
3134: INSERT INTO po_validation_results_gt
3135: (result_set_id,
3136: result_type,
3137: entity_type,
3138: entity_id,
3164: x_result_type := po_validations.c_result_type_failure;
3165: END IF;
3166:
3167: FORALL i IN 1 .. p_id_tbl.COUNT
3168: INSERT INTO po_validation_results_gt
3169: (result_set_id,
3170: result_type,
3171: entity_type,
3172: entity_id,
3238: x_result_type := po_validations.c_result_type_success;
3239:
3240: -- check if ship to org is process. Currently we don't support OSP items for process orgs.
3241: FORALL i IN 1 .. p_id_tbl.COUNT
3242: INSERT INTO po_validation_results_gt
3243: (result_set_id,
3244: result_type,
3245: entity_type,
3246: entity_id,