[Home] [Help]
866: add_error (
867: p_api_errors => g_api_errors,
868: x_return_status => x_return_status,
869: p_message_name => 'PO_GENERIC_ERROR',
870: p_table_name => 'PO_DISTRIBUTIONS_ALL',
871: p_token_name1 => 'ERROR_TEXT',
872: p_token_value1 => 'You cannot specify both po_distribution_id and parent_distribution_id / split_shipment_num for a distribution change.',
873: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
874: p_entity_id => i
899: add_error (
900: p_api_errors => g_api_errors,
901: x_return_status => x_return_status,
902: p_message_name => 'PO_INVALID_DOC_IDS',
903: p_table_name => 'PO_DISTRIBUTIONS_ALL',
904: p_column_name => 'PO_DISTRIBUTION_ID',
905: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
906: p_entity_id => i
907: );
2125: AND (p_chg.distribution_changes.amount_ordered(i) IS NULL) THEN
2126: add_error ( p_api_errors => g_api_errors,
2127: x_return_status => x_return_status,
2128: p_message_name => 'PO_CHNG_SPLIT_DIST_QTY_AMT',
2129: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2130: p_column_name => NULL,
2131: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2132: p_entity_id => i );
2133: END IF;
2145:
2146: add_error ( p_api_errors => g_api_errors,
2147: x_return_status => x_return_status,
2148: p_message_name => 'PO_CHNG_SPLIT_DIST_SHIP_NUM',
2149: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2150: p_column_name => NULL,
2151: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2152: p_entity_id => i );
2153: END IF;
2159: IF (p_chg.distribution_changes.delete_record(i) = G_PARAMETER_YES) THEN
2160: add_error ( p_api_errors => g_api_errors,
2161: x_return_status => x_return_status,
2162: p_message_name => 'PO_CHNG_SPLIT_DIST_NO_DELETE',
2163: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2164: p_column_name => NULL,
2165: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2166: p_entity_id => i );
2167: END IF; -- delete_record
2293: IF (p_chg.distribution_changes.get_count > 0) THEN
2294: add_error ( p_api_errors => g_api_errors,
2295: x_return_status => x_return_status,
2296: p_message_name => 'PO_CHNG_BLKT_NO_DISTS',
2297: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2298: p_column_name => null,
2299: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS );
2300: END IF;
2301:
2570: IF (p_chg.distribution_changes.quantity_ordered(i) IS NOT NULL) THEN
2571: add_error ( p_api_errors => g_api_errors,
2572: x_return_status => x_return_status,
2573: p_message_name => 'PO_SVC_NO_QTY',
2574: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2575: p_column_name => 'QUANTITY',
2576: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2577: p_entity_id => i );
2578: END IF;
2588: IF (p_chg.distribution_changes.amount_ordered(i) IS NOT NULL) THEN
2589: add_error ( p_api_errors => g_api_errors,
2590: x_return_status => x_return_status,
2591: p_message_name => 'PO_SVC_NO_AMT',
2592: p_table_name => 'PO_DISTRIBUTIONS_ALL',
2593: p_column_name => 'AMOUNT',
2594: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
2595: p_entity_id => i );
2596: END IF;
2671: l_new_quantity := p_chg.distribution_changes.quantity_ordered(i);
2672: l_new_price := NULL;
2673: l_new_amount := p_chg.distribution_changes.amount_ordered(i);
2674:
2675: l_table_name := 'PO_DISTRIBUTIONS_ALL';
2676: l_qty_column_name := 'QUANTITY_ORDERED';
2677: l_amt_column_name := 'AMOUNT_ORDERED';
2678: END IF; -- p_entity_type
2679:
6345:
6346: add_error ( p_api_errors => g_api_errors,
6347: x_return_status => x_return_status,
6348: p_message_name => 'PO_CHNG_QTY_RESTRICTED',
6349: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6350: p_column_name => 'QUANTITY_ORDERED',
6351: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6352: p_entity_id => i );
6353: END IF; -- l_new_qty
6363:
6364: add_error ( p_api_errors => g_api_errors,
6365: x_return_status => x_return_status,
6366: p_message_name => 'PO_CHNG_AMT_RESTRICTED',
6367: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6368: p_column_name => 'AMOUNT_ORDERED',
6369: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6370: p_entity_id => i );
6371: END IF; -- l_new_amt
6383: IF (p_chg.distribution_changes.c_creation_date(i) <= g_approved_date) THEN
6384: add_error ( p_api_errors => g_api_errors,
6385: x_return_status => x_return_status,
6386: p_message_name => 'PO_CANT_DELETE_PB_ON_APRVD_PO',
6387: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6388: p_column_name => NULL,
6389: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6390: p_entity_id => i);
6391: END IF;
6396: IF (p_chg.distribution_changes.c_req_distribution_id(i) IS NOT NULL) THEN
6397: add_error ( p_api_errors => g_api_errors,
6398: x_return_status => x_return_status,
6399: p_message_name => 'PO_PO_DEL_DIST_ONLINE_REQ_NA',
6400: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6401: p_column_name => NULL,
6402: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6403: p_entity_id => i);
6404: END IF;
6409: IF (p_chg.distribution_changes.c_encumbered_flag(i) = 'Y') THEN
6410: add_error ( p_api_errors => g_api_errors,
6411: x_return_status => x_return_status,
6412: p_message_name => 'PO_PO_USE_CANCEL_ON_ENCUMB_PO',
6413: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6414: p_column_name => NULL,
6415: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6416: p_entity_id => i);
6417: END IF;
6422: IF (l_qty_delivered > 0) OR (l_amt_delivered > 0) THEN -- Bug 3524527
6423: add_error ( p_api_errors => g_api_errors,
6424: x_return_status => x_return_status,
6425: p_message_name => 'PO_PO_DELETE_DEL_DIST_NA',
6426: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6427: p_column_name => NULL,
6428: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6429: p_entity_id => i);
6430: END IF;
6435: IF (l_qty_billed > 0) OR (l_amt_billed > 0) THEN -- Bug 3524527
6436: add_error ( p_api_errors => g_api_errors,
6437: x_return_status => x_return_status,
6438: p_message_name => 'PO_PO_DELETE_DIST_BILLED_NA',
6439: p_table_name => 'PO_DISTRIBUTIONS_ALL',
6440: p_column_name => NULL,
6441: p_entity_type => G_ENTITY_TYPE_DISTRIBUTIONS,
6442: p_entity_id => i);
6443: END IF;
6722: --Pre-reqs:
6723: -- None.
6724: --Modifies:
6725: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,
6726: -- PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL with the changes.
6727: --Locks:
6728: -- None.
6729: --End of Comments
6730: -------------------------------------------------------------------------------
6854: -- <13503748: Edit without unreserve ER START>
6855: -- update the amount_changted_flag to 'Y' for changed distributions which are already not changed.
6856: IF l_clm_doc_flag = 'N' THEN
6857: FORALL i IN 1..p_chg.line_changes.get_count
6858: UPDATE po_distributions_all /* Changed po_distributions to po_distributions_all */
6859: SET amount_changed_flag = 'Y'
6860: WHERE po_line_id = p_chg.line_changes.po_line_id(i)
6861: AND Nvl(amount_changed_flag, 'N') <> 'Y'
6862: AND distribution_type = 'STANDARD';
6914: -- <13503748: Edit without unreserve ER START>
6915: -- update the amount_changted_flag to 'Y' for changed distributions which are already not changed.
6916: IF l_clm_doc_flag = 'N' THEN
6917: FORALL i IN 1..p_chg.shipment_changes.get_count
6918: UPDATE po_distributions_all
6919: SET amount_changed_flag = 'Y'
6920: WHERE line_location_id = p_chg.shipment_changes.po_line_location_id(i)
6921: AND Nvl(amount_changed_flag, 'N') <> 'Y'
6922: AND distribution_type = 'STANDARD';
6930: FORALL i IN 1..p_chg.distribution_changes.get_count
6931:
6932: -- SQL What: Update PO_DISTRIBUTIONS with the requested/derived
6933: -- distribution changes.
6934: UPDATE po_distributions_all
6935: SET last_update_date = sysdate,
6936: last_updated_by = g_user_id,
6937: request_id = decode(g_request_id,null,request_id,-1,request_id,g_request_id), /*bug 7278327, update the request_id with the concerned concurrent_request_id*/
6938: quantity_ordered =
6947: -- <13503748: Edit without unreserve ER START>
6948: -- update the amount_changted_flag to 'Y' for changed distributions which are already not changed.
6949: IF l_clm_doc_flag = 'N' THEN
6950: FORALL i IN 1..p_chg.distribution_changes.get_count
6951: UPDATE po_distributions_all
6952: SET amount_changed_flag = 'Y'
6953: WHERE po_distribution_id = p_chg.distribution_changes.po_distribution_id(i)
6954: AND Nvl(amount_changed_flag, 'N') <> 'Y'
6955: AND distribution_type = 'STANDARD';
7601: -- Creates split distributions.
7602: --Pre-reqs:
7603: -- None.
7604: --Modifies:
7605: -- Inserts the split distributions into PO_DISTRIBUTIONS_ALL.
7606: -- Updates p_chg with the new PO_DISTRIBUTION_ID for each split distribution.
7607: --Locks:
7608: -- None.
7609: --End of Comments
7671:
7672:
7673: END LOOP; -- split distribution changes
7674:
7675: -- Bulk insert all the split distributions into PO_DISTRIBUTIONS_ALL,
7676: -- by copying most of the field values from the parent distribution.
7677: l_progress := '010';
7678: FORALL i IN 1..p_chg.distribution_changes.po_distribution_id.COUNT
7679: INSERT INTO po_distributions_all (
7675: -- Bulk insert all the split distributions into PO_DISTRIBUTIONS_ALL,
7676: -- by copying most of the field values from the parent distribution.
7677: l_progress := '010';
7678: FORALL i IN 1..p_chg.distribution_changes.po_distribution_id.COUNT
7679: INSERT INTO po_distributions_all (
7680: PO_DISTRIBUTION_ID ,
7681: LAST_UPDATE_DATE ,
7682: LAST_UPDATED_BY ,
7683: PO_HEADER_ID ,
8115: --Pre-reqs:
8116: -- None.
8117: --Modifies:
8118: -- Updates the RECOVERABLE_TAX and NONRECOVERABLE_TAX columns in
8119: -- PO_DISTRIBUTIONS_ALL.
8120: --Locks:
8121: -- None.
8122: --End of Comments
8123: -------------------------------------------------------------------------------