eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_STD_DELIVER_APIS dependencies on INV_RCV_COMMON_APIS

Line 27: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

23: , p_organization_id IN NUMBER)
24: RETURN NUMBER IS
25: l_receipt_source_code VARCHAR2(30) := l_rcv_transaction_rec.receipt_source_code;
26: l_interface_transaction_id NUMBER;
27: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
28: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
29: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
30: l_source_document_code VARCHAR2(30) := l_rcv_transaction_rec.source_document_code;
31: l_dest_type_code VARCHAR2(30) := l_rcv_transaction_rec.destination_type_code;

Line 28: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;

24: RETURN NUMBER IS
25: l_receipt_source_code VARCHAR2(30) := l_rcv_transaction_rec.receipt_source_code;
26: l_interface_transaction_id NUMBER;
27: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
28: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
29: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
30: l_source_document_code VARCHAR2(30) := l_rcv_transaction_rec.source_document_code;
31: l_dest_type_code VARCHAR2(30) := l_rcv_transaction_rec.destination_type_code;
32: l_quantity NUMBER := l_rcv_transaction_rec.transaction_quantity;

Line 29: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;

25: l_receipt_source_code VARCHAR2(30) := l_rcv_transaction_rec.receipt_source_code;
26: l_interface_transaction_id NUMBER;
27: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
28: l_user_id NUMBER := inv_rcv_common_apis.g_po_startup_value.user_id;
29: l_logon_id NUMBER := inv_rcv_common_apis.g_po_startup_value.logon_id;
30: l_source_document_code VARCHAR2(30) := l_rcv_transaction_rec.source_document_code;
31: l_dest_type_code VARCHAR2(30) := l_rcv_transaction_rec.destination_type_code;
32: l_quantity NUMBER := l_rcv_transaction_rec.transaction_quantity;
33: l_uom VARCHAR2(30) := l_rcv_transaction_rec.transaction_uom;

Line 37: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;

33: l_uom VARCHAR2(30) := l_rcv_transaction_rec.transaction_uom;
34: l_shipment_hdr_id NUMBER := l_rcv_transaction_rec.shipment_header_id;
35: l_shipment_line_id NUMBER := l_rcv_transaction_rec.shipment_line_id;
36: l_substitute_code VARCHAR2(30) := l_rcv_transaction_rec.substitute_unordered_code;
37: l_employee_id NUMBER := inv_rcv_common_apis.g_po_startup_value.employee_id;
38: l_parent_transaction_id NUMBER := l_rcv_transaction_rec.rcv_transaction_id;
39: l_inspection_code VARCHAR2(30) := l_rcv_transaction_rec.inspection_status_code;
40: l_quality_code VARCHAR2(30) := l_rcv_transaction_rec.inspection_quality_code;
41: l_po_hdr_id NUMBER := l_rcv_transaction_rec.po_header_id;

Line 77: l_processor_value VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;

73: l_attribute14 VARCHAR2(150) := l_rcv_transaction_rec.attribute14;
74: l_attribute15 VARCHAR2(150) := l_rcv_transaction_rec.attribute15;
75: l_transaction_type VARCHAR2(30) := l_rcv_transaction_rec.transaction_type;
76: l_location_id NUMBER := l_rcv_transaction_rec.location_id;
77: l_processor_value VARCHAR2(10) := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
78: l_category_id NUMBER := l_rcv_transaction_rec.category_id;
79: l_vendor_lot VARCHAR2(30) := l_rcv_transaction_rec.vendor_lot_num;
80: l_reason_id NUMBER := l_rcv_transaction_rec.reason_id;
81: l_primary_qty NUMBER := l_rcv_transaction_rec.primary_quantity;

Line 188: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR

184: --dbms_output.put_line('Inserted with intf. txn id:'||l_interface_transaction_id);
185:
186: --Since we call the Transfer API for a receiving subinventory with WMS
187: --patchset J, do not need this validation
188: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
189: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
190: IF (l_debug = 1) THEN
191: print_debug('WMS patch level is < J. Setting txntype to TRANSFER for RECEIVING dest', 4);
192: END IF;

Line 189: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

185:
186: --Since we call the Transfer API for a receiving subinventory with WMS
187: --patchset J, do not need this validation
188: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
189: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
190: IF (l_debug = 1) THEN
191: print_debug('WMS patch level is < J. Setting txntype to TRANSFER for RECEIVING dest', 4);
192: END IF;
193: IF l_rcv_transaction_rec.destination_type_code = 'RECEIVING' THEN

Line 230: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

226: * Populate the LPN_GROUP_ID and validation_flag columns if INV and PO
227: * patch levels are J or higher else set them to NULL
228: * Insert these two additional columns in RTI
229: */
230: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
231: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
232: l_validation_flag := 'Y';
233: l_lpn_group_id := l_group_id;
234: -- bug 3452845

Line 231: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

227: * patch levels are J or higher else set them to NULL
228: * Insert these two additional columns in RTI
229: */
230: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
231: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
232: l_validation_flag := 'Y';
233: l_lpn_group_id := l_group_id;
234: -- bug 3452845
235: l_transaction_date := Sysdate;

Line 243: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id( l_receipt_source_code,

239: l_transaction_date := Trunc(Sysdate);
240: END IF;
241:
242: --
243: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id( l_receipt_source_code,
244: l_po_hdr_id,
245: l_req_line_id,
246: l_oe_order_header_id );
247:

Line 269: IF( inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j AND l_wip_entity_id is NULL) then

265: END IF;
266: END;
267:
268: --bug 6412992
269: IF( inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j AND l_wip_entity_id is NULL) then
270: BEGIN
271: select backorder_delivery_detail_id into l_wip_entity_id
272: from mtl_txn_request_lines mtrl , mtl_material_transactions_temp mmtt
273: where mmtt.transaction_temp_id = l_mmtt_temp_id

Line 549: p_lot_serial_break_tbl IN inv_rcv_common_apis.trans_rec_tb_tp

545: END IF;
546: END insert_interface_code;
547:
548: PROCEDURE insert_lot_serial(
549: p_lot_serial_break_tbl IN inv_rcv_common_apis.trans_rec_tb_tp
550: , p_transaction_temp_id IN NUMBER
551: , p_lot_control_code IN NUMBER
552: , p_serial_control_code IN NUMBER
553: , p_interface_transaction_id IN NUMBER

Line 561: inv_rcv_common_apis.BREAK(

557: IF (l_debug = 1) THEN
558: print_debug('entering insert_lot_serial 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
559: END IF;
560:
561: inv_rcv_common_apis.BREAK(
562: p_transaction_temp_id
563: , p_lot_serial_break_tbl
564: , p_lot_control_code
565: , p_serial_control_code);

Line 765: l_lot_serial_break_tbl inv_rcv_common_apis.trans_rec_tb_tp;

761: l_ratedisplay NUMBER;
762: l_interface_transaction_id NUMBER;
763: -- This keeps track of the number with which the record was inserted.
764:
765: l_lot_serial_break_tbl inv_rcv_common_apis.trans_rec_tb_tp;
766: -- table that will store the record into which the lot/serial entered
767: -- have to be broken.
768:
769: l_po_distribution_id NUMBER;

Line 952: IF ((inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j) OR

948: * If WMS and PO patch levels are J or higher, set the value of lpn_id and
949: * transfer_lpn_id in RTI from the input parameters and we should not
950: * refer to the MMTT columns since they would not be updating them
951: */
952: IF ((inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j) OR
953: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
954: IF l_content_lpn_id IS NOT NULL THEN
955: p_rcv_transaction_rec.lpn_id := l_content_lpn_id;
956:

Line 953: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

949: * transfer_lpn_id in RTI from the input parameters and we should not
950: * refer to the MMTT columns since they would not be updating them
951: */
952: IF ((inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j) OR
953: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
954: IF l_content_lpn_id IS NOT NULL THEN
955: p_rcv_transaction_rec.lpn_id := l_content_lpn_id;
956:
957: BEGIN

Line 1240: NVL(inv_rcv_common_apis.g_rcv_global_var.express_mode, 'NO') = 'NO'

1236: END IF;
1237:
1238: -- Part of the code in RCV_LOCATOR_CONTROL.SET_LOCATOR_ATTRIBUTES('INIT');
1239: IF (
1240: NVL(inv_rcv_common_apis.g_rcv_global_var.express_mode, 'NO') = 'NO'
1241: AND p_rcv_transaction_rec.subinventory_dsp IS NOT NULL
1242: AND p_rcv_transaction_rec.destination_type_code = 'INVENTORY'
1243: AND p_rcv_transaction_rec.subinventory_locator_control IN(2, 3)
1244: ) THEN

Line 1293: inv_rcv_common_apis.get_po_routing_id(

1289:
1290: IF (l_asn_line_flag = 'ASN') THEN
1291:
1292: --Check if the destination is expense
1293: inv_rcv_common_apis.get_po_routing_id(
1294: x_po_routing_id => l_po_routing_id,
1295: x_is_expense => l_is_expense,
1296: p_po_header_id => p_rcv_rcvtxn_rec.po_header_id,
1297: p_po_release_id => p_rcv_rcvtxn_rec.po_release_id,

Line 1369: IF (inv_rcv_common_apis.g_po_startup_value.display_inverse_rate = 'Y') THEN

1365: END IF;
1366:
1367: l_rate := p_rcv_transaction_rec.currency_conversion_rate;
1368:
1369: IF (inv_rcv_common_apis.g_po_startup_value.display_inverse_rate = 'Y') THEN
1370: l_ratedisplay := 1 / l_rate;
1371: ELSE
1372: l_ratedisplay := l_rate;
1373: END IF;

Line 1387: IF (NVL(inv_rcv_common_apis.g_rcv_global_var.express_mode, 'NO') <> 'YES'

1383: IF (l_debug = 1) THEN
1384: print_debug('populate_default_values 130: ', 4);
1385: END IF;
1386:
1387: IF (NVL(inv_rcv_common_apis.g_rcv_global_var.express_mode, 'NO') <> 'YES'
1388: AND p_rcv_transaction_rec.inspection_detail <> 'Y') THEN
1389: --dbms_output.put_line('before insert');
1390:
1391: -- Before this must populate the passed in parameters in the

Line 1414: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

1410: --a TRANSFER transaction if the subinventory type is RECEIVING. If the Deliver API is
1411: --called, then the destination sub should be a storage subinventory. So we should set
1412: --the destination type code to Inventory
1413: IF p_rcv_transaction_rec.destination_type_code IS NULL THEN
1414: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
1415: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1416: p_rcv_transaction_rec.destination_type_code := 'INVENTORY';
1417: END IF;
1418: END IF;

Line 1415: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

1411: --called, then the destination sub should be a storage subinventory. So we should set
1412: --the destination type code to Inventory
1413: IF p_rcv_transaction_rec.destination_type_code IS NULL THEN
1414: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
1415: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1416: p_rcv_transaction_rec.destination_type_code := 'INVENTORY';
1417: END IF;
1418: END IF;
1419:

Line 1428: AND ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j)

1424: -- exception since one cannot do a transfer in a storage sub.
1425: -- If the destination_type_code is receiving then the
1426: -- transaction_type is defaulted to be transfer in insert_interface_code
1427: IF p_rcv_transaction_rec.destination_type_code = 'RECEIVING'
1428: AND ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j)
1429: AND (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1430: l_subinventory_type := wms_putaway_utils.get_subinventory_type
1431: (p_subinventory_code => p_subinventory_code
1432: , p_organization_id => p_organization_id);

Line 1429: AND (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

1425: -- If the destination_type_code is receiving then the
1426: -- transaction_type is defaulted to be transfer in insert_interface_code
1427: IF p_rcv_transaction_rec.destination_type_code = 'RECEIVING'
1428: AND ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j)
1429: AND (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1430: l_subinventory_type := wms_putaway_utils.get_subinventory_type
1431: (p_subinventory_code => p_subinventory_code
1432: , p_organization_id => p_organization_id);
1433: IF Nvl(l_subinventory_type,1) = 1 THEN

Line 1475: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR

1471: * on the interface tables (MTLI/MSNI).
1472: * If either of these are not installed, use the existing logic to break
1473: * lots and serials based on temp records MTLI/MSNT
1474: */
1475: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
1476: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
1477:
1478: l_lot_serial_break_tbl(1).transaction_id := l_interface_transaction_id;
1479: l_lot_serial_break_tbl(1).primary_quantity := p_rcv_transaction_rec.primary_quantity;

Line 1476: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

1472: * If either of these are not installed, use the existing logic to break
1473: * lots and serials based on temp records MTLI/MSNT
1474: */
1475: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
1476: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
1477:
1478: l_lot_serial_break_tbl(1).transaction_id := l_interface_transaction_id;
1479: l_lot_serial_break_tbl(1).primary_quantity := p_rcv_transaction_rec.primary_quantity;
1480:

Line 1510: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

1506: -- database rollback) you would see this quantity as pending to be transacted if
1507: -- we inserted the rows as transaction_status_code = 'PENDING'
1508:
1509: l_rcv_transaction_id := p_rcv_transaction_rec.rcv_transaction_id;
1510: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1511:
1512: UPDATE rcv_transactions_interface
1513: SET transaction_status_code = 'PENDING'
1514: , processing_status_code = 'PENDING'

Line 1551: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;

1547: l_rcv_transaction_rec rcvtxn_transaction_rec_tp;
1548: l_rcv_rcvtxn_rec rcvtxn_enter_rec_cursor_rec;
1549: -- local record in which the values returned from the cursor are fetched.
1550:
1551: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
1552: -- local variable to store the output of the matching algorithm
1553:
1554: l_msg_count NUMBER;
1555: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1683: inv_rcv_common_apis.init_startup_values(p_organization_id);

1679:
1680: l_progress := '10';
1681:
1682: BEGIN
1683: inv_rcv_common_apis.init_startup_values(p_organization_id);
1684: EXCEPTION
1685: WHEN NO_DATA_FOUND THEN
1686: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1687: fnd_msg_pub.ADD;

Line 1693: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN

1689: END;
1690:
1691: l_progress := '20';
1692:
1693: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1694: SELECT rcv_interface_groups_s.NEXTVAL
1695: INTO l_group_id
1696: FROM DUAL;
1697:

Line 1698: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

1694: SELECT rcv_interface_groups_s.NEXTVAL
1695: INTO l_group_id
1696: FROM DUAL;
1697:
1698: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1699: ELSE
1700: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1701: END IF;
1702:

Line 1700: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

1696: FROM DUAL;
1697:
1698: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1699: ELSE
1700: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1701: END IF;
1702:
1703: l_progress := '30';
1704: -- call matching algorithm

Line 1861: inv_rcv_common_apis.do_check(

1857: CLOSE l_curs_rcvtxn_detail;
1858: END IF;
1859:
1860: l_progress := '90';
1861: inv_rcv_common_apis.do_check(
1862: p_organization_id => p_organization_id
1863: , p_inventory_item_id => p_item_id
1864: , p_transaction_type_id => 18
1865: , p_primary_quantity => l_total_primary_qty

Line 1929: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;

1925: l_rcv_transaction_rec rcvtxn_transaction_rec_tp;
1926: l_rcv_rcvtxn_rec rcvtxn_enter_rec_cursor_rec;
1927: -- local record in which the values returned from the cursor are fetched.
1928:
1929: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
1930: -- local variable to store the output of the matching algorithm
1931:
1932: l_msg_count NUMBER;
1933: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 2179: inv_rcv_common_apis.init_startup_values(p_organization_id);

2175: l_progress := '10';
2176:
2177: --dbms_output.put_line('In create po');
2178: BEGIN
2179: inv_rcv_common_apis.init_startup_values(p_organization_id);
2180: EXCEPTION
2181: WHEN NO_DATA_FOUND THEN
2182: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2183: fnd_msg_pub.ADD;

Line 2190: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN

2186:
2187: l_progress := '20';
2188:
2189: -- default l_group_id ?? clear group id after done
2190: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2191: SELECT rcv_interface_groups_s.NEXTVAL
2192: INTO l_group_id
2193: FROM DUAL;
2194:

Line 2195: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

2191: SELECT rcv_interface_groups_s.NEXTVAL
2192: INTO l_group_id
2193: FROM DUAL;
2194:
2195: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2196: ELSE
2197: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2198: END IF;
2199:

Line 2197: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

2193: FROM DUAL;
2194:
2195: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2196: ELSE
2197: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2198: END IF;
2199:
2200: l_progress := '30';
2201: -- call matching algorithm

Line 2226: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

2222: * If INV and PO J are installed, then the lots for the parent transaction will
2223: * be stored in rcv_lots_supply. We must match the lot number passed with that
2224: * of the parent transaction and also the parent_txn_id
2225: */
2226: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2227: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2228: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := p_lot_number;
2229: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).parent_transaction_id := p_parent_txn_id;
2230: ELSE

Line 2227: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

2223: * be stored in rcv_lots_supply. We must match the lot number passed with that
2224: * of the parent transaction and also the parent_txn_id
2225: */
2226: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2227: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2228: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := p_lot_number;
2229: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).parent_transaction_id := p_parent_txn_id;
2230: ELSE
2231: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := NULL;

Line 2483: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

2479: END IF;
2480: l_progress := '70';
2481:
2482: -- Only call split MO for patchset J or higher
2483: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2484: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2485: -- Added addition check for p_original_txn_temp_id: if it is null,
2486: -- then simply insert RTI with the MMTT column as null
2487: IF p_original_txn_temp_id IS NULL OR l_rcvtxn_match_table_detail.COUNT = 1 THEN

Line 2484: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

2480: l_progress := '70';
2481:
2482: -- Only call split MO for patchset J or higher
2483: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2484: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2485: -- Added addition check for p_original_txn_temp_id: if it is null,
2486: -- then simply insert RTI with the MMTT column as null
2487: IF p_original_txn_temp_id IS NULL OR l_rcvtxn_match_table_detail.COUNT = 1 THEN
2488: l_new_txn_temp_id := p_original_txn_temp_id;

Line 2580: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

2576: /* FP-J Lot/Serial Support Enhancement
2577: * Populate the table to store the information of the RTIs created used for
2578: * splitting the lots and serials based on RTI quantity
2579: */
2580: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2581: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2582: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2583: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2584: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_quantity;

Line 2581: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

2577: * Populate the table to store the information of the RTIs created used for
2578: * splitting the lots and serials based on RTI quantity
2579: */
2580: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2581: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2582: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2583: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2584: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_quantity;
2585: l_new_rti_info(match_result_count).sec_qty := l_rcv_transaction_rec.sec_transaction_quantity;--OPM Convergence

Line 2603: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

2599: /* FP-J Lot/Serial Support Enhancement
2600: * Call the split_lot API to split the lots and serials inserted from the UI
2601: * based on the quantity of each RTI record
2602: */
2603: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2604: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2605:
2606: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
2607: --BUG 3326408

Line 2604: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

2600: * Call the split_lot API to split the lots and serials inserted from the UI
2601: * based on the quantity of each RTI record
2602: */
2603: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2604: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2605:
2606: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
2607: --BUG 3326408
2608: IF (p_lot_control_code > 1 AND p_serial_control_code = 6) THEN

Line 2646: inv_rcv_common_apis.do_check(

2642: END IF; --END IF check lot and serial controls
2643: END IF; --END IF check INV J and PO J installed
2644:
2645: l_progress := '90';
2646: inv_rcv_common_apis.do_check(
2647: p_organization_id => p_organization_id
2648: , p_inventory_item_id => p_item_id
2649: , p_transaction_type_id => 18
2650: , p_primary_quantity => l_total_primary_qty

Line 2711: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;

2707: l_rcv_transaction_rec rcvtxn_transaction_rec_tp;
2708: l_rcv_rcvtxn_rec rcvtxn_enter_rec_cursor_rec;
2709: -- local record in which the values returned from the cursor are fetched.
2710:
2711: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
2712: -- local variable to store the output of the matching algorithm
2713:
2714: l_msg_count NUMBER;
2715: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 2853: Setting value of INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num to a

2849: l_progress := '10';
2850:
2851: BEGIN
2852: /*Begin Bug Fix 4158984
2853: Setting value of INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num to a
2854: dummy value of -9999 as if this value is null, we are generating recepit
2855: numbers during delivery transaction which is not required.
2856: We are setting value back to null after call to inv_rcv_common_apis.init_startup_values.
2857: */

Line 2856: We are setting value back to null after call to inv_rcv_common_apis.init_startup_values.

2852: /*Begin Bug Fix 4158984
2853: Setting value of INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num to a
2854: dummy value of -9999 as if this value is null, we are generating recepit
2855: numbers during delivery transaction which is not required.
2856: We are setting value back to null after call to inv_rcv_common_apis.init_startup_values.
2857: */
2858: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := -9999;
2859: inv_rcv_common_apis.init_startup_values(p_organization_id);
2860: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := NULL;

Line 2858: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := -9999;

2854: dummy value of -9999 as if this value is null, we are generating recepit
2855: numbers during delivery transaction which is not required.
2856: We are setting value back to null after call to inv_rcv_common_apis.init_startup_values.
2857: */
2858: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := -9999;
2859: inv_rcv_common_apis.init_startup_values(p_organization_id);
2860: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := NULL;
2861: /*End bug 4158984*/
2862: EXCEPTION

Line 2859: inv_rcv_common_apis.init_startup_values(p_organization_id);

2855: numbers during delivery transaction which is not required.
2856: We are setting value back to null after call to inv_rcv_common_apis.init_startup_values.
2857: */
2858: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := -9999;
2859: inv_rcv_common_apis.init_startup_values(p_organization_id);
2860: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := NULL;
2861: /*End bug 4158984*/
2862: EXCEPTION
2863: WHEN NO_DATA_FOUND THEN

Line 2860: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := NULL;

2856: We are setting value back to null after call to inv_rcv_common_apis.init_startup_values.
2857: */
2858: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := -9999;
2859: inv_rcv_common_apis.init_startup_values(p_organization_id);
2860: INV_RCV_COMMON_APIS.g_rcv_global_var.receipt_num := NULL;
2861: /*End bug 4158984*/
2862: EXCEPTION
2863: WHEN NO_DATA_FOUND THEN
2864: fnd_message.set_name('INV', 'INV_RCV_PARAM');

Line 2872: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN

2868:
2869: l_progress := '20';
2870:
2871: -- default l_group_id ?? clear group id after done
2872: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2873: SELECT rcv_interface_groups_s.NEXTVAL
2874: INTO l_group_id
2875: FROM DUAL;
2876:

Line 2877: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

2873: SELECT rcv_interface_groups_s.NEXTVAL
2874: INTO l_group_id
2875: FROM DUAL;
2876:
2877: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2878: ELSE
2879: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2880: END IF;
2881:

Line 2879: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

2875: FROM DUAL;
2876:
2877: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2878: ELSE
2879: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2880: END IF;
2881:
2882: -- default some header level variables based on the header id passed
2883: SELECT asn_type

Line 2958: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

2954: * If INV and PO J are installed, then the lots for the parent transaction will
2955: * be stored in rcv_lots_supply. We must match the lot number passed with that
2956: * of the parent transaction and also the parent_txn_id
2957: */
2958: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2959: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2960: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := l_lot_number;
2961: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).parent_transaction_id := p_parent_txn_id;
2962: ELSE

Line 2959: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

2955: * be stored in rcv_lots_supply. We must match the lot number passed with that
2956: * of the parent transaction and also the parent_txn_id
2957: */
2958: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2959: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2960: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := l_lot_number;
2961: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).parent_transaction_id := p_parent_txn_id;
2962: ELSE
2963: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := NULL;

Line 3177: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3173: end if;
3174:
3175:
3176:
3177: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3178: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3179: -- Added addition check for p_original_txn_temp_id: if it is null,
3180: -- then simply insert RTI with the MMTT column as null
3181: IF p_original_txn_temp_id IS NULL OR l_rcvtxn_match_table_detail.COUNT = 1 THEN

Line 3178: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3174:
3175:
3176:
3177: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3178: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3179: -- Added addition check for p_original_txn_temp_id: if it is null,
3180: -- then simply insert RTI with the MMTT column as null
3181: IF p_original_txn_temp_id IS NULL OR l_rcvtxn_match_table_detail.COUNT = 1 THEN
3182: l_new_txn_temp_id := p_original_txn_temp_id;

Line 3277: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3273: /* FP-J Lot/Serial Support Enhancement
3274: * Populate the table to store the information of the RTIs created used for
3275: * splitting the lots and serials based on RTI quantity
3276: */
3277: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3278: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3279: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3280: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3281: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_quantity;

Line 3278: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3274: * Populate the table to store the information of the RTIs created used for
3275: * splitting the lots and serials based on RTI quantity
3276: */
3277: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3278: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3279: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3280: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3281: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_quantity;
3282: IF (l_debug = 1) THEN

Line 3290: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR

3286:
3287: /* FP-J Lot/Serial Support Enhancement
3288: * No updates to rcv_serials_supply if INV J and PO J are installed
3289: */
3290: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
3291: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
3292: IF l_rcv_rcvtxn_rec.req_line_id IS NOT NULL
3293: AND p_serial_control_code NOT IN(1, 6) THEN
3294: -- update rss for req

Line 3291: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

3287: /* FP-J Lot/Serial Support Enhancement
3288: * No updates to rcv_serials_supply if INV J and PO J are installed
3289: */
3290: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
3291: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
3292: IF l_rcv_rcvtxn_rec.req_line_id IS NOT NULL
3293: AND p_serial_control_code NOT IN(1, 6) THEN
3294: -- update rss for req
3295: update_rcv_serials_supply(

Line 3323: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3319: /* FP-J Lot/Serial Support Enhancement
3320: * Call the split_lot API to split the lots and serials inserted from the UI
3321: * based on the quantity of each RTI record
3322: */
3323: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3324: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3325: l_msni_count := 0;
3326: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3327: --BUG 3326408, 3405320

Line 3324: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3320: * Call the split_lot API to split the lots and serials inserted from the UI
3321: * based on the quantity of each RTI record
3322: */
3323: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3324: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3325: l_msni_count := 0;
3326: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3327: --BUG 3326408, 3405320
3328: --If there are any serials confirmed from the UI for an item that is

Line 3377: inv_rcv_common_apis.do_check(

3373: END IF;
3374: END IF; --END IF check lot and serial control controls
3375: END IF; --END IF check INV J and PO J installed
3376:
3377: inv_rcv_common_apis.do_check(
3378: p_organization_id => p_organization_id
3379: , p_inventory_item_id => p_item_id
3380: , p_transaction_type_id => 61
3381: , p_primary_quantity => l_total_primary_qty

Line 3442: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;

3438: l_rcv_transaction_rec rcvtxn_transaction_rec_tp;
3439: l_rcv_rcvtxn_rec rcvtxn_enter_rec_cursor_rec;
3440: -- local record in which the values returned from the cursor are fetched.
3441:
3442: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
3443: -- local variable to store the output of the matching algorithm
3444:
3445: l_msg_count NUMBER;
3446: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 3581: inv_rcv_common_apis.init_startup_values(p_organization_id);

3577:
3578: l_progress := '10';
3579:
3580: BEGIN
3581: inv_rcv_common_apis.init_startup_values(p_organization_id);
3582: EXCEPTION
3583: WHEN NO_DATA_FOUND THEN
3584: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3585: fnd_msg_pub.ADD;

Line 3592: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN

3588:
3589: l_progress := '20';
3590:
3591: -- default l_group_id ?? clear group id after done
3592: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3593: SELECT rcv_interface_groups_s.NEXTVAL
3594: INTO l_group_id
3595: FROM DUAL;
3596:

Line 3597: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;

3593: SELECT rcv_interface_groups_s.NEXTVAL
3594: INTO l_group_id
3595: FROM DUAL;
3596:
3597: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3598: ELSE
3599: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3600: END IF;
3601:

Line 3599: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

3595: FROM DUAL;
3596:
3597: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3598: ELSE
3599: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3600: END IF;
3601:
3602: l_progress := '30';
3603: -- call matching algorithm

Line 3625: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3621: * If INV and PO J are installed, then the lots for the parent transaction will
3622: * be stored in rcv_lots_supply. We must match the lot number passed with that
3623: * of the parent transaction and also the parent_txn_id
3624: */
3625: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3626: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3627: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := p_lot_number;
3628: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).parent_transaction_id := p_parent_txn_id;
3629: ELSE

Line 3626: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3622: * be stored in rcv_lots_supply. We must match the lot number passed with that
3623: * of the parent transaction and also the parent_txn_id
3624: */
3625: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3626: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3627: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := p_lot_number;
3628: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).parent_transaction_id := p_parent_txn_id;
3629: ELSE
3630: g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).lot_number := NULL;

Line 3818: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3814:
3815: l_progress := '70';
3816:
3817: -- Only call split mo if J or higher
3818: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3819: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3820: -- Added addition check for p_original_txn_temp_id: if it is null,
3821: -- then simply insert RTI with the MMTT column as null
3822: IF p_original_txn_temp_id IS NULL OR l_rcvtxn_match_table_detail.COUNT = 1 THEN

Line 3819: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3815: l_progress := '70';
3816:
3817: -- Only call split mo if J or higher
3818: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3819: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3820: -- Added addition check for p_original_txn_temp_id: if it is null,
3821: -- then simply insert RTI with the MMTT column as null
3822: IF p_original_txn_temp_id IS NULL OR l_rcvtxn_match_table_detail.COUNT = 1 THEN
3823: l_new_txn_temp_id := p_original_txn_temp_id;

Line 3915: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3911: /* FP-J Lot/Serial Support Enhancement
3912: * Populate the table to store the information of the RTIs created used for
3913: * splitting the lots and serials based on RTI quantity
3914: */
3915: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3916: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3917: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3918: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3919: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_quantity;

Line 3916: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3912: * Populate the table to store the information of the RTIs created used for
3913: * splitting the lots and serials based on RTI quantity
3914: */
3915: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3916: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3917: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3918: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3919: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_quantity;
3920: IF (l_debug = 1) THEN

Line 3935: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

3931: /* FP-J Lot/Serial Support Enhancement
3932: * Call the split_lot API to split the lots and serials inserted from the UI
3933: * based on the quantity of each RTI record
3934: */
3935: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3936: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3937: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3938:
3939: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

Line 3936: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN

3932: * Call the split_lot API to split the lots and serials inserted from the UI
3933: * based on the quantity of each RTI record
3934: */
3935: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3936: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3937: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3938:
3939: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3940: p_api_version => 1.0

Line 3960: inv_rcv_common_apis.do_check(

3956: END IF; --END IF check lot and serial controls
3957: END IF; --END IF check INV J and PO J installed
3958:
3959: l_progress := '90';
3960: inv_rcv_common_apis.do_check(
3961: p_organization_id => p_organization_id
3962: , p_inventory_item_id => p_item_id
3963: , p_transaction_type_id => 15
3964: , p_primary_quantity => l_total_primary_qty

Line 4271: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4267: /* Bug 2443163 */
4268: /* SELECT MIN(rti.interface_transaction_id) */
4269: SELECT MAX(rti.interface_transaction_id)
4270: FROM rcv_transactions_interface rti
4271: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4272: GROUP BY rti.lpn_id;
4273:
4274: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4275: BEGIN

Line 4283: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN

4279: IF (l_debug = 1) THEN
4280: print_debug('create_osp_std_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4281: END IF;
4282:
4283: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4284: --BUG 3444177: User HOR for performance reasons
4285: SELECT TO_NUMBER(hoi.org_information1)
4286: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4287: FROM hr_organization_information hoi

Line 4286: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

4282:
4283: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4284: --BUG 3444177: User HOR for performance reasons
4285: SELECT TO_NUMBER(hoi.org_information1)
4286: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4287: FROM hr_organization_information hoi
4288: WHERE hoi.organization_id = p_organization_id
4289: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4290: END IF;

Line 4294: inv_rcv_common_apis.validate_trx_date(

4290: END IF;
4291:
4292: l_progress := '20';
4293: -- first check if the transaction date satisfies the validation.
4294: inv_rcv_common_apis.validate_trx_date(
4295: p_trx_date => SYSDATE
4296: , p_organization_id => p_organization_id
4297: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4298: , x_return_status => x_status

Line 4297: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id

4293: -- first check if the transaction date satisfies the validation.
4294: inv_rcv_common_apis.validate_trx_date(
4295: p_trx_date => SYSDATE
4296: , p_organization_id => p_organization_id
4297: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4298: , x_return_status => x_status
4299: , x_error_code => x_message
4300: );
4301:

Line 4371: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR

4367:
4368: /* FP-J Lot/Serial Support Enhancement
4369: * If INV J and PO J are installed, do not call label printing API at this stage
4370: */
4371: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4372: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4373: l_counter := 1;
4374: OPEN c_rti_txn_id;
4375:

Line 4372: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

4368: /* FP-J Lot/Serial Support Enhancement
4369: * If INV J and PO J are installed, do not call label printing API at this stage
4370: */
4371: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4372: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4373: l_counter := 1;
4374: OPEN c_rti_txn_id;
4375:
4376: LOOP

Line 4466: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4462: /* Bug 2443163 */
4463: /* SELECT MIN(rti.interface_transaction_id) */
4464: SELECT MAX(rti.interface_transaction_id)
4465: FROM rcv_transactions_interface rti
4466: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4467: GROUP BY rti.lpn_id;
4468:
4469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4470: BEGIN

Line 4479: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN

4475: print_debug('create_std_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4476: print_debug(' p_rcv_act_rjt_qty_type => '||p_rcv_act_rjt_qty_type,1);
4477: END IF;
4478:
4479: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4480: --BUG 3444177: User HOR for performance reasons
4481: SELECT TO_NUMBER(hoi.org_information1)
4482: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4483: FROM hr_organization_information hoi

Line 4482: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

4478:
4479: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4480: --BUG 3444177: User HOR for performance reasons
4481: SELECT TO_NUMBER(hoi.org_information1)
4482: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4483: FROM hr_organization_information hoi
4484: WHERE hoi.organization_id = p_organization_id
4485: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4486: END IF;

Line 4490: inv_rcv_common_apis.validate_trx_date(

4486: END IF;
4487:
4488: l_progress := '20';
4489: -- first check if the transaction date satisfies the validation.
4490: inv_rcv_common_apis.validate_trx_date(
4491: p_trx_date => SYSDATE
4492: , p_organization_id => p_organization_id
4493: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4494: , x_return_status => x_status

Line 4493: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id

4489: -- first check if the transaction date satisfies the validation.
4490: inv_rcv_common_apis.validate_trx_date(
4491: p_trx_date => SYSDATE
4492: , p_organization_id => p_organization_id
4493: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4494: , x_return_status => x_status
4495: , x_error_code => x_message
4496: );
4497:

Line 4746: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR

4742:
4743: /* FP-J Lot/Serial Support Enhancement
4744: * If INV J and PO J are installed, do not call label printing API at this stage
4745: */
4746: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4747: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4748: l_counter := 1;
4749: OPEN c_rti_txn_id;
4750:

Line 4747: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

4743: /* FP-J Lot/Serial Support Enhancement
4744: * If INV J and PO J are installed, do not call label printing API at this stage
4745: */
4746: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4747: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4748: l_counter := 1;
4749: OPEN c_rti_txn_id;
4750:
4751: LOOP

Line 4849: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

4845:
4846: CURSOR c_rti_txn_id IS
4847: SELECT DISTINCT rti.interface_transaction_id
4848: FROM rcv_transactions_interface rti
4849: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4850:
4851: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4852: BEGIN
4853: x_return_status := fnd_api.g_ret_sts_success;

Line 4883: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN

4879: END IF;
4880:
4881: --First check if the transaction date satisfies the validation.
4882: --If the transaction date is invalid then error out the transaction
4883: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4884: --BUG 3444177: User HOR for performance reasons
4885: BEGIN
4886: SELECT TO_NUMBER(hoi.org_information1)
4887: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

Line 4887: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

4883: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4884: --BUG 3444177: User HOR for performance reasons
4885: BEGIN
4886: SELECT TO_NUMBER(hoi.org_information1)
4887: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4888: FROM hr_organization_information hoi
4889: WHERE hoi.organization_id = p_organization_id
4890: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4891: EXCEPTION

Line 4903: inv_rcv_common_apis.validate_trx_date(

4899: END IF;
4900:
4901: l_progress := '15';
4902:
4903: inv_rcv_common_apis.validate_trx_date(
4904: p_trx_date => SYSDATE
4905: , p_organization_id => p_organization_id
4906: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4907: , x_return_status => x_return_status

Line 4906: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id

4902:
4903: inv_rcv_common_apis.validate_trx_date(
4904: p_trx_date => SYSDATE
4905: , p_organization_id => p_organization_id
4906: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4907: , x_return_status => x_return_status
4908: , x_error_code => x_msg_data
4909: );
4910:

Line 5139: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR

5135:
5136: /* FP-J Lot/Serial Support Enhancement
5137: * If INV J and PO J are installed, do not call label printing API at this stage
5138: */
5139: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5140: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5141: OPEN c_rti_txn_id;
5142:
5143: LOOP

Line 5140: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN

5136: /* FP-J Lot/Serial Support Enhancement
5137: * If INV J and PO J are installed, do not call label printing API at this stage
5138: */
5139: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5140: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5141: OPEN c_rti_txn_id;
5142:
5143: LOOP
5144: l_counter := 1;

Line 5211: inv_rcv_common_apis.g_po_startup_value := NULL;

5207: PROCEDURE rcvtxn_clear_global IS
5208: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5209: BEGIN
5210: g_rcvtxn_detail_index := 1;
5211: inv_rcv_common_apis.g_po_startup_value := NULL;
5212: inv_rcv_common_apis.g_rcv_global_var := NULL;
5213: g_rcvtxn_match_table_gross.DELETE;
5214: END rcvtxn_clear_global;
5215:

Line 5212: inv_rcv_common_apis.g_rcv_global_var := NULL;

5208: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5209: BEGIN
5210: g_rcvtxn_detail_index := 1;
5211: inv_rcv_common_apis.g_po_startup_value := NULL;
5212: inv_rcv_common_apis.g_rcv_global_var := NULL;
5213: g_rcvtxn_match_table_gross.DELETE;
5214: END rcvtxn_clear_global;
5215:
5216: PROCEDURE update_rcv_serials_supply(