[Home] [Help]
2961: x_secondary_available_qty NUMBER := 0;
2962: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
2963: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
2964: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
2965: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
2966: l_does_asn_exist VARCHAR2(1) := 'N';
2967: l_asn_count NUMBER := 0;
2968: l_dist_count number; /* Bug#3746516 */
2969: l_rate_date po_headers.rate_date%type; /* Bug#3746516 */
3542: -- Bug 6796920 Start
3543: BEGIN
3544: select blind_receiving_flag
3545: into l_blind_receiving_flag
3546: from rcv_parameters
3547: where organization_id = temp_cascaded_table(current_n).to_organization_id;
3548: EXCEPTION
3549: when others THEN
3550: NULL;
4159: );
4160:
4161: /* Bug 3296214.
4162: * We need to use the control actions set in the Receiving
4163: * Options window. Get the control code from rcv_parameters.
4164: * If the transaction type is RECEIVE and if there is an
4165: * ASN existing for that PO, then depending on this value
4166: * we should either allow or error out.
4167: */
4167: */
4168: BEGIN
4169: SELECT NVL(MAX(receipt_asn_exists_code), 'NONE')
4170: INTO l_asn_exists_code
4171: FROM rcv_parameters
4172: WHERE organization_id = x_cascaded_table(n).to_organization_id;
4173: EXCEPTION
4174: WHEN OTHERS THEN
4175: l_asn_exists_code := 'NONE';
4175: l_asn_exists_code := 'NONE';
4176: END;
4177:
4178: IF (g_asn_debug = 'Y') THEN
4179: asn_debug.put_line('ASN CODE IN rcv_parameters ' || l_asn_exists_code);
4180: END IF;
4181:
4182: /* This check is not done for receiving against ASNs. So check
4183: * whether x_cascaded_table(n).shipment_header_id is null which