[Home] [Help]
2145:
2146: l_progress:= '270';
2147: SELECT po_releases_s.nextval
2148: INTO g_po_release_id
2149: FROM sys.dual;
2150:
2151: /*
2152: ** assign the document id to get passed back to the
2153: ** calling module.
3020: /**
3021: --mchandak 02/11/2002
3022: --Bug# 2219743
3023: --Added logic to default secondary qnty,UOM and grade in po_lines
3024: --if common purchasing is installed for OPM dual item
3025: IF(g_document_subtype='STANDARD' or g_document_subtype='PLANNED') AND NOT GML_PO_FOR_PROCESS.check_po_for_proc
3026: THEN
3027: x_retvar := FND_INSTALLATION.get_app_info(x_product,x_opm_installed,x_dummy,x_dummy);
3028: BEGIN
3075: IF ic_item_mst_rec.item_no is not null
3076: THEN
3077: interface.preferred_grade := ic_item_mst_rec.qc_grade;
3078:
3079: IF ic_item_mst_rec.dualum_ind >= 1
3080: THEN
3081: interface.secondary_unit_of_measure:= po_gml_db_common.get_apps_uom_code(ic_item_mst_rec.item_um2);
3082: x_order_opm_um := po_gml_db_common.get_opm_uom_code(interface.unit_meas_lookup_code);
3083: po_gml_db_common.validate_quantity(
3081: interface.secondary_unit_of_measure:= po_gml_db_common.get_apps_uom_code(ic_item_mst_rec.item_um2);
3082: x_order_opm_um := po_gml_db_common.get_opm_uom_code(interface.unit_meas_lookup_code);
3083: po_gml_db_common.validate_quantity(
3084: ic_item_mst_rec.item_id,
3085: ic_item_mst_rec.dualum_ind,
3086: x_quantity,
3087: x_order_opm_um,
3088: ic_item_mst_rec.item_um2,
3089: x_secondary_qty);
3090: interface.secondary_quantity := x_secondary_qty;
3091: ELSE
3092: interface.secondary_quantity := null;
3093: interface.secondary_unit_of_measure := null;
3094: END IF; -- ic_item_mst_rec.dualum_ind >= 1
3095: ELSE
3096: interface.secondary_quantity := null;
3097: interface.preferred_grade := null;
3098: interface.secondary_unit_of_measure := null;
3685: l_progress:='330';
3686:
3687: SELECT po_lines_s.nextval
3688: INTO x_po_line_id
3689: FROM sys.dual;
3690:
3691: l_progress:='340';
3692:
3693: /* GA FPI start */
3885:
3886: l_progress := '420';
3887:
3888: --
3889: -- IF secondary quantity is null and item is dual uom control , default the secondary qty.
3890: IF (g_document_subtype='STANDARD' OR g_document_subtype='PLANNED' OR g_document_type = 'PA')
3891: THEN
3892: IF interface.item_id is not null THEN
3893: IF item.secondary_uom_code IS NOT NULL THEN
4638: -- because x_po_line_id is the blanket line_id for 'Release'
4639: -- Introducing the 'If' statement for checking that its not a release
4640: IF (g_document_subtype <> 'RELEASE') THEN
4641:
4642: /** If FSP org and item combination is dual uom control, update the po lines secondary quantity
4643: with the default conversion based on the PO lines quantity **/
4644:
4645: --
4646:
5675: /*Bug 5629398 End */
5676:
5677:
5678: --
5679: --If item is dual uom control and secondary quantity is NULL, derive it
5680: IF x_secondary_unit_of_measure IS NOT NULL THEN
5681: IF interface.secondary_quantity IS NULL THEN
5682: PO_UOM_S.uom_convert (x_quantity,
5683: nvl(x_shipment_uom, interface.unit_meas_lookup_code),
5914: END IF;
5915:
5916: SELECT po_line_locations_s.nextval
5917: INTO x_line_location_id
5918: FROM sys.dual;
5919:
5920: -- bug: 404191
5921: -- Get the taxable_flag based on the following priority
5922: -- 1. preferences (global.po_taxable_flag)
6029: p_message => 'interface.trxn_flow_header_id='||interface.transaction_flow_header_id);
6030: END IF;
6031:
6032: --
6033: -- If item is dual uom control and secondary quantity is NULL, derive it
6034: IF interface.item_id IS NOT NULL THEN
6035: IF interface.secondary_quantity IS NULL THEN
6036: PO_UOM_S.get_secondary_uom( interface.item_id,
6037: interface.destination_organization_id,
8690: -- secondary qty and secondary uom not getting populated for requisition lines
8691: -- when requisition is created using IP.
8692: -- default secondary qty and uom if
8693: -- opm is installed.
8694: -- destination org. is process and item is process and item is dual uom control.
8695:
8696: -- bug# 3386353
8697: -- Sourcing when doing overaward creates additional PO line with the extra qty.
8698: -- If the line is OPM item with dual uom control then the shipment corresponding
8694: -- destination org. is process and item is process and item is dual uom control.
8695:
8696: -- bug# 3386353
8697: -- Sourcing when doing overaward creates additional PO line with the extra qty.
8698: -- If the line is OPM item with dual uom control then the shipment corresponding
8699: -- to the extra PO line created by Sourcing does not have secondary uom and
8700: -- secondary quantity with ship to organization as process org.
8701: -- default secondary UOM and secondary quantity in such a case (non req backed lines)
8702: -- the requisition line id would be null in po_lines_interface .
8833: END IF;
8834:
8835: SELECT po_headers_s.nextval
8836: INTO x_po_header_id
8837: FROM sys.dual;
8838:
8839:
8840: /*
8841: ** Assign the document id to get passed back to the calling
13253:
13254: begin
13255: SELECT po_line_locations_s.nextval
13256: INTO x_line_location_id
13257: FROM sys.dual;
13258: exception
13259: when others then
13260: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13261: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,