[Home] [Help]
531:
532: -------------------------------------------------------------------------------
533: --Start of Comments
534: --Pre-reqs: None.
535: --Modifies: PO_VALIDATION_RESULTS_GT
536: --Locks: None.
537: --Function:
538: -- Checks that the provided dates are in valid periods for Purchasing
539: -- (open or future-enterable, not adjusting) for the corresponding
617: * the for loop, so that all the validation errors are captured.
618: */
619: FOR i IN 1 .. p_date_tbl.COUNT LOOP
620: IF p_date_tbl(i) IS NOT NULL THEN
621: INSERT INTO PO_VALIDATION_RESULTS_GT
622: ( result_set_id
623: , entity_type
624: , entity_id
625: , column_name
1525:
1526: -------------------------------------------------------------------------------
1527: --Start of Comments
1528: --Pre-reqs: None.
1529: --Modifies: PO_VALIDATION_RESULTS_GT
1530: --Locks: None.
1531: --Function:
1532: -- Checks for notification controls based on amounts,
1533: -- and adds a warning to the results table if any exist.
1593: l_quantity_tbl := p_quantity_tbl;
1594: END IF;
1595:
1596: FORALL i IN 1 .. p_line_id_tbl.COUNT
1597: INSERT INTO PO_VALIDATION_RESULTS_GT
1598: ( result_set_id
1599: , result_type
1600: , entity_type
1601: , entity_id
1902:
1903: -- Check that the child number is unique across the parent.
1904: --
1905: --Added a decode around char1 so that the appropriate message gets inserted into
1906: --PO_VALIDATION_RESULTS_GT.message_name column
1907: --If it is null we would would go with the default message populated in l_message_name
1908: INSERT INTO PO_VALIDATION_RESULTS_GT
1909: ( result_set_id
1910: , entity_type
1904: --
1905: --Added a decode around char1 so that the appropriate message gets inserted into
1906: --PO_VALIDATION_RESULTS_GT.message_name column
1907: --If it is null we would would go with the default message populated in l_message_name
1908: INSERT INTO PO_VALIDATION_RESULTS_GT
1909: ( result_set_id
1910: , entity_type
1911: , entity_id
1912: , column_name
2085: );
2086:
2087:
2088: -- Check that the child number is unique across the parent.
2089: INSERT INTO PO_VALIDATION_RESULTS_GT
2090: ( result_set_id
2091: , entity_type
2092: , entity_id
2093: , column_name
2432:
2433: -------------------------------------------------------------------------------
2434: --Start of Comments
2435: --Pre-reqs: None.
2436: --Modifies: PO_VALIDATION_RESULTS_GT
2437: --Locks: None.
2438: --Function:
2439: -- Validates the terms_id agains ap_terms
2440: -- and adds an error to the results table if it's invalid.
2481: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2482: END IF;
2483:
2484: FORALL i IN 1 .. p_entity_id_tbl.COUNT
2485: INSERT INTO PO_VALIDATION_RESULTS_GT
2486: (result_set_id,
2487: result_type,
2488: entity_type,
2489: entity_id,
3195:
3196: x_result_type := po_validations.c_result_type_success;
3197:
3198: FORALL i IN 1 .. p_id_tbl.COUNT
3199: INSERT INTO po_validation_results_gt
3200: (result_set_id,
3201: result_type,
3202: entity_type,
3203: entity_id,
3317: END IF;
3318: END LOOP;
3319:
3320: FORALL i IN 1 .. p_id_tbl.COUNT
3321: INSERT INTO po_validation_results_gt
3322: (result_set_id,
3323: result_type,
3324: entity_type,
3325: entity_id,
3351: x_result_type := po_validations.c_result_type_failure;
3352: END IF;
3353:
3354: FORALL i IN 1 .. p_id_tbl.COUNT
3355: INSERT INTO po_validation_results_gt
3356: (result_set_id,
3357: result_type,
3358: entity_type,
3359: entity_id,
3425: x_result_type := po_validations.c_result_type_success;
3426:
3427: -- check if ship to org is process. Currently we don't support OSP items for process orgs.
3428: FORALL i IN 1 .. p_id_tbl.COUNT
3429: INSERT INTO po_validation_results_gt
3430: (result_set_id,
3431: result_type,
3432: entity_type,
3433: entity_id,