[Home] [Help]
852: add_error (
853: p_api_errors => g_api_errors,
854: x_return_status => x_return_status,
855: p_message_name => 'PO_GENERIC_ERROR',
856: p_table_name => 'PO_DISTRIBUTIONS_ALL',
857: p_token_name1 => 'ERROR_TEXT',
858: p_token_value1 => 'You cannot specify both po_distribution_id and parent_distribution_id / split_shipment_num for a distribution change.',
859: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
860: p_entity_id => i
885: add_error (
886: p_api_errors => g_api_errors,
887: x_return_status => x_return_status,
888: p_message_name => 'PO_INVALID_DOC_IDS',
889: p_table_name => 'PO_DISTRIBUTIONS_ALL',
890: p_column_name => 'PO_DISTRIBUTION_ID',
891: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
892: p_entity_id => i
893: );
2102: AND (p_chg.distribution_changes.amount_ordered(i) IS NULL) THEN
2103: add_error ( p_api_errors => g_api_errors,
2104: x_return_status => x_return_status,
2105: p_message_name => 'PO_CHNG_SPLIT_DIST_QTY_AMT',
2106: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2107: p_column_name => NULL,
2108: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2109: p_entity_id => i );
2110: END IF;
2122:
2123: add_error ( p_api_errors => g_api_errors,
2124: x_return_status => x_return_status,
2125: p_message_name => 'PO_CHNG_SPLIT_DIST_SHIP_NUM',
2126: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2127: p_column_name => NULL,
2128: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2129: p_entity_id => i );
2130: END IF;
2136: IF (p_chg.distribution_changes.delete_record(i) = G_PARAMETER_YES) THEN
2137: add_error ( p_api_errors => g_api_errors,
2138: x_return_status => x_return_status,
2139: p_message_name => 'PO_CHNG_SPLIT_DIST_NO_DELETE',
2140: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2141: p_column_name => NULL,
2142: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2143: p_entity_id => i );
2144: END IF; -- delete_record
2270: IF (p_chg.distribution_changes.get_count > 0) THEN
2271: add_error ( p_api_errors => g_api_errors,
2272: x_return_status => x_return_status,
2273: p_message_name => 'PO_CHNG_BLKT_NO_DISTS',
2274: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2275: p_column_name => null,
2276: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS );
2277: END IF;
2278:
2547: IF (p_chg.distribution_changes.quantity_ordered(i) IS NOT NULL) THEN
2548: add_error ( p_api_errors => g_api_errors,
2549: x_return_status => x_return_status,
2550: p_message_name => 'PO_SVC_NO_QTY',
2551: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2552: p_column_name => 'QUANTITY',
2553: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2554: p_entity_id => i );
2555: END IF;
2565: IF (p_chg.distribution_changes.amount_ordered(i) IS NOT NULL) THEN
2566: add_error ( p_api_errors => g_api_errors,
2567: x_return_status => x_return_status,
2568: p_message_name => 'PO_SVC_NO_AMT',
2569: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2570: p_column_name => 'AMOUNT',
2571: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2572: p_entity_id => i );
2573: END IF;
2648: l_new_quantity := p_chg.distribution_changes.quantity_ordered(i);
2649: l_new_price := NULL;
2650: l_new_amount := p_chg.distribution_changes.amount_ordered(i);
2651:
2652: l_table_name := 'PO_DISTRIBUTIONS_ALL';
2653: l_qty_column_name := 'QUANTITY_ORDERED';
2654: l_amt_column_name := 'AMOUNT_ORDERED';
2655: END IF; -- p_entity_type
2656:
6289:
6290: add_error ( p_api_errors => g_api_errors,
6291: x_return_status => x_return_status,
6292: p_message_name => 'PO_CHNG_QTY_RESTRICTED',
6293: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6294: p_column_name => 'QUANTITY_ORDERED',
6295: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6296: p_entity_id => i );
6297: END IF; -- l_new_qty
6307:
6308: add_error ( p_api_errors => g_api_errors,
6309: x_return_status => x_return_status,
6310: p_message_name => 'PO_CHNG_AMT_RESTRICTED',
6311: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6312: p_column_name => 'AMOUNT_ORDERED',
6313: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6314: p_entity_id => i );
6315: END IF; -- l_new_amt
6327: IF (p_chg.distribution_changes.c_creation_date(i) <= g_approved_date) THEN
6328: add_error ( p_api_errors => g_api_errors,
6329: x_return_status => x_return_status,
6330: p_message_name => 'PO_CANT_DELETE_PB_ON_APRVD_PO',
6331: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6332: p_column_name => NULL,
6333: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6334: p_entity_id => i);
6335: END IF;
6340: IF (p_chg.distribution_changes.c_req_distribution_id(i) IS NOT NULL) THEN
6341: add_error ( p_api_errors => g_api_errors,
6342: x_return_status => x_return_status,
6343: p_message_name => 'PO_PO_DEL_DIST_ONLINE_REQ_NA',
6344: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6345: p_column_name => NULL,
6346: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6347: p_entity_id => i);
6348: END IF;
6353: IF (p_chg.distribution_changes.c_encumbered_flag(i) = 'Y') THEN
6354: add_error ( p_api_errors => g_api_errors,
6355: x_return_status => x_return_status,
6356: p_message_name => 'PO_PO_USE_CANCEL_ON_ENCUMB_PO',
6357: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6358: p_column_name => NULL,
6359: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6360: p_entity_id => i);
6361: END IF;
6366: IF (l_qty_delivered > 0) OR (l_amt_delivered > 0) THEN -- Bug 3524527
6367: add_error ( p_api_errors => g_api_errors,
6368: x_return_status => x_return_status,
6369: p_message_name => 'PO_PO_DELETE_DEL_DIST_NA',
6370: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6371: p_column_name => NULL,
6372: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6373: p_entity_id => i);
6374: END IF;
6379: IF (l_qty_billed > 0) OR (l_amt_billed > 0) THEN -- Bug 3524527
6380: add_error ( p_api_errors => g_api_errors,
6381: x_return_status => x_return_status,
6382: p_message_name => 'PO_PO_DELETE_DIST_BILLED_NA',
6383: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6384: p_column_name => NULL,
6385: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6386: p_entity_id => i);
6387: END IF;
6666: --Pre-reqs:
6667: -- None.
6668: --Modifies:
6669: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,
6670: -- PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL with the changes.
6671: --Locks:
6672: -- None.
6673: --End of Comments
6674: -------------------------------------------------------------------------------
7489: -- Creates split distributions.
7490: --Pre-reqs:
7491: -- None.
7492: --Modifies:
7493: -- Inserts the split distributions into PO_DISTRIBUTIONS_ALL.
7494: -- Updates p_chg with the new PO_DISTRIBUTION_ID for each split distribution.
7495: --Locks:
7496: -- None.
7497: --End of Comments
7559:
7560:
7561: END LOOP; -- split distribution changes
7562:
7563: -- Bulk insert all the split distributions into PO_DISTRIBUTIONS_ALL,
7564: -- by copying most of the field values from the parent distribution.
7565: l_progress := '010';
7566: FORALL i IN 1..p_chg.distribution_changes.po_distribution_id.COUNT
7567: INSERT INTO po_distributions_all (
7563: -- Bulk insert all the split distributions into PO_DISTRIBUTIONS_ALL,
7564: -- by copying most of the field values from the parent distribution.
7565: l_progress := '010';
7566: FORALL i IN 1..p_chg.distribution_changes.po_distribution_id.COUNT
7567: INSERT INTO po_distributions_all (
7568: PO_DISTRIBUTION_ID ,
7569: LAST_UPDATE_DATE ,
7570: LAST_UPDATED_BY ,
7571: PO_HEADER_ID ,
7980: --Pre-reqs:
7981: -- None.
7982: --Modifies:
7983: -- Updates the RECOVERABLE_TAX and NONRECOVERABLE_TAX columns in
7984: -- PO_DISTRIBUTIONS_ALL.
7985: --Locks:
7986: -- None.
7987: --End of Comments
7988: -------------------------------------------------------------------------------