[Home] [Help]
240: AND pll.line_location_id = v_line_location_id
241: AND NVL(pll.approved_flag, 'N') = 'Y'
242: AND NVL(pll.cancel_flag, 'N') = 'N'
243: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
244: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT');
245:
246: default_po_info shipments%ROWTYPE;
247: BEGIN
248: IF (g_asn_debug = 'Y') THEN
2739: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
2740: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
2741: OR ( NVL(x_include_closed_po, 'N') = 'N'
2742: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
2743: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
2744: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
2745: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
2746: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'))
2747: ORDER BY NVL(pll.promised_date, pll.need_by_date);
2772: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
2773: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
2774: OR ( NVL(x_include_closed_po, 'N') = 'N'
2775: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
2776: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
2777: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
2778: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
2779: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
2780:
2853: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
2854: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
2855: OR ( NVL(x_include_closed_po, 'N') = 'N'
2856: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
2857: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
2858: AND pod.distribution_num = NVL(v_distribution_num, pod.distribution_num)
2859: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
2860: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
2861: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'))
2900: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
2901: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
2902: OR ( NVL(x_include_closed_po, 'N') = 'N'
2903: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
2904: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
2905: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
2906: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
2907: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
2908:
4002: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
4003: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
4004: END IF;
4005:
4006: IF x_shipment_type NOT IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT') THEN
4007: IF (g_asn_debug = 'Y') THEN
4008: asn_debug.put_line('This PO shipment type cannot be received');
4009: END IF;
4010:
5288: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
5289: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
5290: OR ( NVL(x_include_closed_po, 'N') = 'N'
5291: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
5292: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
5293: ORDER BY NVL(pll.promised_date, pll.need_by_date);
5294:
5295: CURSOR count_shipments(
5296: v_po_line_id NUMBER,
5311: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
5312: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
5313: OR ( NVL(x_include_closed_po, 'N') = 'N'
5314: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
5315: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT');
5316:
5317: CURSOR distributions(
5318: v_po_line_id NUMBER,
5319: v_po_line_location_id NUMBER,
5371: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
5372: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
5373: OR ( NVL(x_include_closed_po, 'N') = 'N'
5374: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
5375: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
5376: ORDER BY NVL(pll.promised_date, pll.need_by_date);
5377:
5378: CURSOR count_distributions(
5379: v_po_line_id NUMBER,
5398: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
5399: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
5400: OR ( NVL(x_include_closed_po, 'N') = 'N'
5401: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
5402: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT');
5403:
5404: /*
5405: ** Debug: had to change this to the distribution record
5406: ** Might be a compatibility issue between the two record definitions
6067: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
6068: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
6069: END IF;
6070:
6071: IF x_shipment_type NOT IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT') THEN
6072: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
6073: rcv_error_pkg.set_error_message('RCV_ASN_INVAL_SHIPMT_TYPE', x_cascaded_table(n).error_message);
6074: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
6075: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
7109: END IF;
7110:
7111: IF ( x_cascaded_table(n).transaction_type = 'RECEIVE'
7112: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7113: /* 1 is Standard Receipt, 2 is Inspection Required */
7114: IF ( (x_cascaded_table(n).routing_header_id) IN(1, 2)
7115: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN
7116: rcv_error_pkg.set_error_message('RCV_ASN_DELIVER_ROUTING_FAILED');
7117: RAISE e_validation_error;
10644: */
10645: IF ( (temp_cascaded_table(1).transaction_type = 'DELIVER')
10646: AND (l_num_of_distributions > 1)) THEN --{
10647: IF (g_asn_debug = 'Y') THEN
10648: asn_debug.put_line('before getting available qty for standard multi distributions deliver ');
10649: END IF;
10650:
10651: /* Bug 5354379:
10652: We should not compare the transaction quantity with the po_distributions_all.ordered_quantity,
11094: x_converted_parent_trx_qty := 0;
11095: END IF;
11096:
11097: IF (g_asn_debug = 'Y') THEN
11098: asn_debug.put_line('Available qty for standard multiple distributions deliver ' || x_converted_parent_trx_qty);
11099: asn_debug.put_line('l_converted_distribution_qty ' || l_converted_distribution_qty);
11100: asn_debug.put_line('l_converted_transaction_qty ' || l_converted_transaction_qty);
11101: END IF;
11102: END IF; --}