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_DIR_RCPT_APIS dependencies on INV_RCV_COMMON_APIS

Line 35: l_lot_serial_break_tbl inv_rcv_common_apis.trans_rec_tb_tp;

31: ) IS
32: l_interface_transaction_id NUMBER;
33: -- this is used to keep track of the id used to insert the row in rti
34:
35: l_lot_serial_break_tbl inv_rcv_common_apis.trans_rec_tb_tp;
36: -- table that will store the record into which the lot/serial entered
37: -- have to be broken.
38:
39: -- l_transaction_type VARCHAR2(20) := 'DELIVER';

Line 139: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) AND

135: * on the interface tables (MTLI/MSNI).
136: * If either of these are not installed, use the existing logic to break
137: * lots and serials based on temp records MTLI/MSNT
138: */
139: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) AND
140: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
141:
142: l_lot_serial_break_tbl(1).transaction_id := l_interface_transaction_id;
143: l_lot_serial_break_tbl(1).primary_quantity := p_rcv_transaction_rec.primary_quantity;

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

136: * If either of these are not installed, use the existing logic to break
137: * lots and serials based on temp records MTLI/MSNT
138: */
139: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) AND
140: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
141:
142: l_lot_serial_break_tbl(1).transaction_id := l_interface_transaction_id;
143: l_lot_serial_break_tbl(1).primary_quantity := p_rcv_transaction_rec.primary_quantity;
144:

Line 248: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm

244: , p_attribute13 IN VARCHAR2 DEFAULT NULL
245: , p_attribute14 IN VARCHAR2 DEFAULT NULL
246: , p_attribute15 IN VARCHAR2 DEFAULT NULL
247: ) IS
248: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
249: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
250: l_transaction_type VARCHAR2(20) := 'DELIVER';
251: l_total_primary_qty NUMBER := 0;
252: l_msg_count NUMBER;

Line 431: inv_rcv_common_apis.init_startup_values(p_organization_id);

427: l_progress := '10';
428:
429: -- query po_startup_value
430: BEGIN
431: inv_rcv_common_apis.init_startup_values(p_organization_id);
432: EXCEPTION
433: WHEN NO_DATA_FOUND THEN
434: fnd_message.set_name('INV', 'INV_RCV_PARAM');
435: fnd_msg_pub.ADD;

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

438:
439: l_progress := '20';
440:
441: -- default l_group_id ? clear group id after done
442: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
443: SELECT rcv_interface_groups_s.NEXTVAL
444: INTO l_group_id
445: FROM DUAL;
446:

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

443: SELECT rcv_interface_groups_s.NEXTVAL
444: INTO l_group_id
445: FROM DUAL;
446:
447: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
448:
449: IF (l_debug = 1) THEN
450: print_debug('create_osp_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
451: END IF;

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

449: IF (l_debug = 1) THEN
450: print_debug('create_osp_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
451: END IF;
452: ELSE
453: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
454:
455: IF (l_debug = 1) THEN
456: print_debug('create_osp_drct_dlvr_rti_rec: 2.2 - group_id stored already: ' || l_group_id, 4);
457: END IF;

Line 688: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) OR

684: /* FP-J Lot/Serial Support Enhancement
685: * Populate the table to store the information of the RTIs created and
686: * split the lots and serials based on RTI quantity
687: */
688: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) OR
689: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po )) THEN
690:
691: --BUG 3326408,3346758,3405320
692: --If there are any serials confirmed from the UI for an item that is

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

685: * Populate the table to store the information of the RTIs created and
686: * split the lots and serials based on RTI quantity
687: */
688: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) OR
689: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po )) THEN
690:
691: --BUG 3326408,3346758,3405320
692: --If there are any serials confirmed from the UI for an item that is
693: --lot controlled and serial control dynamic at SO issue,

Line 744: inv_rcv_common_apis.do_check(

740: print_debug('create_osp_drct_dlvr_rti_rec: 9 - after populate_default_values' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
741: END IF;
742:
743: l_progress := '65';
744: inv_rcv_common_apis.do_check(
745: p_organization_id => p_organization_id
746: , p_inventory_item_id => p_item_id
747: , p_transaction_type_id => 18
748: , p_primary_quantity => l_total_primary_qty

Line 862: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm

858: , p_attribute13 IN VARCHAR2 DEFAULT NULL
859: , p_attribute14 IN VARCHAR2 DEFAULT NULL
860: , p_attribute15 IN VARCHAR2 DEFAULT NULL
861: ) IS
862: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
863: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
864: l_transaction_type VARCHAR2(20) := 'DELIVER';
865: l_total_primary_qty NUMBER := 0;
866: l_msg_count NUMBER;

Line 1056: inv_rcv_common_apis.init_startup_values(p_organization_id);

1052: l_progress := '10';
1053:
1054: -- query po_startup_value
1055: BEGIN
1056: inv_rcv_common_apis.init_startup_values(p_organization_id);
1057: EXCEPTION
1058: WHEN NO_DATA_FOUND THEN
1059: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1060: fnd_msg_pub.ADD;

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

1063:
1064: l_progress := '20';
1065:
1066: -- default l_group_id ? clear group id after done
1067: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1068: SELECT rcv_interface_groups_s.NEXTVAL
1069: INTO l_group_id
1070: FROM DUAL;
1071:

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

1068: SELECT rcv_interface_groups_s.NEXTVAL
1069: INTO l_group_id
1070: FROM DUAL;
1071:
1072: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1073:
1074: IF (l_debug = 1) THEN
1075: print_debug('create_po_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
1076: END IF;

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

1074: IF (l_debug = 1) THEN
1075: print_debug('create_po_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
1076: END IF;
1077: ELSE
1078: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1079:
1080: IF (l_debug = 1) THEN
1081: print_debug('create_po_drct_dlvr_rti_rec: 2.2 - group_id stored already: ' || l_group_id, 4);
1082: END IF;

Line 1315: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR

1311: l_rcv_transaction_rec.secondary_quantity := (l_rcpt_match_table_detail(match_result_count).quantity/p_rcv_qty) * p_secondary_rcv_qty;
1312: print_debug('secondary quantity after matching logic qty is obtained is ' ||l_rcv_transaction_rec.secondary_quantity);
1313:
1314: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
1315: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
1316: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
1317: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
1318:
1319: l_rcv_transaction_rec.lpn_id := p_lpn_id;

Line 1316: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR

1312: print_debug('secondary quantity after matching logic qty is obtained is ' ||l_rcv_transaction_rec.secondary_quantity);
1313:
1314: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
1315: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
1316: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
1317: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
1318:
1319: l_rcv_transaction_rec.lpn_id := p_lpn_id;
1320: l_rcv_transaction_rec.transfer_lpn_id := p_lpn_id;

Line 1317: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

1313:
1314: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
1315: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
1316: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
1317: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
1318:
1319: l_rcv_transaction_rec.lpn_id := p_lpn_id;
1320: l_rcv_transaction_rec.transfer_lpn_id := p_lpn_id;
1321: ELSE

Line 1358: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR

1354: -- Deliver_to_location_id is mandatory for Expense Items case
1355: -- So if no deliver_to_location_id is present in the distributions of po for Expense Items
1356: -- we will default it to the value passed from the mobile UI.
1357:
1358: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
1359: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
1360: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
1361: NULL;
1362: ELSE

Line 1359: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR

1355: -- So if no deliver_to_location_id is present in the distributions of po for Expense Items
1356: -- we will default it to the value passed from the mobile UI.
1357:
1358: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
1359: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
1360: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
1361: NULL;
1362: ELSE
1363: if l_rcv_rcpt_rec.destination_type_code = 'EXPENSE' then

Line 1360: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

1356: -- we will default it to the value passed from the mobile UI.
1357:
1358: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
1359: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
1360: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
1361: NULL;
1362: ELSE
1363: if l_rcv_rcpt_rec.destination_type_code = 'EXPENSE' then
1364: IF (l_debug = 1) THEN

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

1415: /* FP-J Lot/Serial Support Enhancement
1416: * Populate the table to store the information of the RTIs created used for
1417: * splitting the lots and serials based on RTI quantity
1418: */
1419: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
1420: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1421: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
1422: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
1423: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

1416: * Populate the table to store the information of the RTIs created used for
1417: * splitting the lots and serials based on RTI quantity
1418: */
1419: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
1420: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1421: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
1422: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
1423: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
1424: /*OPM Convergence. Populate the calculated secondary quantity */

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

1439: /* FP-J Lot/Serial Support Enhancement
1440: * Call the split_lot API to split the lots and serials inserted from the UI
1441: * based on the quantity of each RTI record
1442: */
1443: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
1444: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1445: --BUG 3326408,3346758,3405320
1446: --If there are any serials confirmed from the UI for an item that is
1447: --lot controlled and serial control dynamic at SO issue,

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

1440: * Call the split_lot API to split the lots and serials inserted from the UI
1441: * based on the quantity of each RTI record
1442: */
1443: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
1444: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
1445: --BUG 3326408,3346758,3405320
1446: --If there are any serials confirmed from the UI for an item that is
1447: --lot controlled and serial control dynamic at SO issue,
1448: --do not NULL out serial_transaction_temp_id. In other cases,

Line 1491: inv_rcv_common_apis.do_check(

1487: -- append index in input table where the line to be detailed needs to be inserted
1488: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1489:
1490: l_progress := '90';
1491: inv_rcv_common_apis.do_check(
1492: p_organization_id => p_organization_id
1493: , p_inventory_item_id => p_item_id
1494: , p_transaction_type_id => 18
1495: , p_primary_quantity => l_total_primary_qty

Line 1602: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm

1598: , p_attribute13 IN VARCHAR2 DEFAULT NULL
1599: , p_attribute14 IN VARCHAR2 DEFAULT NULL
1600: , p_attribute15 IN VARCHAR2 DEFAULT NULL
1601: ) IS
1602: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
1603: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1604: l_transaction_type VARCHAR2(20) := 'DELIVER';
1605: l_total_primary_qty NUMBER := 0;
1606: l_msg_count NUMBER;

Line 1844: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

1840: AND ship_to_org_id = p_organization_id;
1841:
1842: --Bug 4552825 - Assign the value only if it is not null
1843: IF l_receipt_num IS NOT NULL THEN
1844: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
1845: END IF;
1846:
1847: IF (l_debug = 1) THEN
1848: print_debug('create_int_shp_dr_del_rti_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

Line 1848: print_debug('create_int_shp_dr_del_rti_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

1844: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
1845: END IF;
1846:
1847: IF (l_debug = 1) THEN
1848: print_debug('create_int_shp_dr_del_rti_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
1849: END IF;
1850: EXCEPTION
1851: WHEN NO_DATA_FOUND THEN
1852: l_receipt_num := NULL;

Line 1855: inv_rcv_common_apis.init_startup_values(p_organization_id);

1851: WHEN NO_DATA_FOUND THEN
1852: l_receipt_num := NULL;
1853: END;
1854:
1855: inv_rcv_common_apis.init_startup_values(p_organization_id);
1856: EXCEPTION
1857: WHEN NO_DATA_FOUND THEN
1858: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1859: fnd_msg_pub.ADD;

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

1862:
1863: l_progress := '20';
1864:
1865: -- default l_group_id ? clear group id after done
1866: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1867: SELECT rcv_interface_groups_s.NEXTVAL
1868: INTO l_group_id
1869: FROM DUAL;
1870:

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

1867: SELECT rcv_interface_groups_s.NEXTVAL
1868: INTO l_group_id
1869: FROM DUAL;
1870:
1871: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1872:
1873: IF (l_debug = 1) THEN
1874: print_debug('create_int_shp_dr_del_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
1875: END IF;

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

1873: IF (l_debug = 1) THEN
1874: print_debug('create_int_shp_dr_del_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
1875: END IF;
1876: ELSE
1877: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1878:
1879: IF (l_debug = 1) THEN
1880: print_debug('create_int_shp_dr_del_rti_rec: 2.2 - group_id stored already: ' || l_group_id, 4);
1881: END IF;

Line 2178: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po

2174:
2175: -- Nested LPN changes If FromLPN is not null and Patchset Level of INV,WMS,PO
2176: -- are at J then pass From_lpn_id as lpn_id otherwise use old code.
2177: --IF p_from_lpn_id IS NOT NULL
2178: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
2179: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
2180: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
2181: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
2182: ELSE

Line 2179: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j

2175: -- Nested LPN changes If FromLPN is not null and Patchset Level of INV,WMS,PO
2176: -- are at J then pass From_lpn_id as lpn_id otherwise use old code.
2177: --IF p_from_lpn_id IS NOT NULL
2178: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
2179: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
2180: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
2181: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
2182: ELSE
2183: l_rcv_transaction_rec.lpn_id := p_lpn_id;

Line 2180: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN

2176: -- are at J then pass From_lpn_id as lpn_id otherwise use old code.
2177: --IF p_from_lpn_id IS NOT NULL
2178: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
2179: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
2180: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
2181: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
2182: ELSE
2183: l_rcv_transaction_rec.lpn_id := p_lpn_id;
2184: END IF;

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

2237: /* FP-J Lot/Serial Support Enhancement
2238: * Populate the table to store the information of the RTIs created used for
2239: * splitting the lots and serials based on RTI quantity
2240: */
2241: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2242: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2243: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2244: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2245: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

2238: * Populate the table to store the information of the RTIs created used for
2239: * splitting the lots and serials based on RTI quantity
2240: */
2241: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2242: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2243: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2244: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2245: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
2246: IF (l_debug = 1) THEN

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

2263:
2264: /* FP-J Lot/Serial Support Enhancement
2265: * No updates to rcv_serials_supply if INV J and PO J are installed
2266: */
2267: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
2268: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
2269: IF l_rcv_rcpt_rec.req_line_id IS NOT NULL
2270: AND p_serial_control_code NOT IN(1, 6) THEN
2271: -- update rss for req

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

2264: /* FP-J Lot/Serial Support Enhancement
2265: * No updates to rcv_serials_supply if INV J and PO J are installed
2266: */
2267: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
2268: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
2269: IF l_rcv_rcpt_rec.req_line_id IS NOT NULL
2270: AND p_serial_control_code NOT IN(1, 6) THEN
2271: -- update rss for req
2272: inv_rcv_std_deliver_apis.update_rcv_serials_supply(

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

2295: /* FP-J Lot/Serial Support Enhancement
2296: * Call the split_lot API to split the lots and serials inserted from the UI
2297: * based on the quantity of each RTI record
2298: */
2299: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2300: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2301: --BUG 3326408,3346758,3405320
2302: --If there are any serials confirmed from the UI for an item that is
2303: --lot controlled and serial control dynamic at SO issue,

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

2296: * Call the split_lot API to split the lots and serials inserted from the UI
2297: * based on the quantity of each RTI record
2298: */
2299: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2300: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2301: --BUG 3326408,3346758,3405320
2302: --If there are any serials confirmed from the UI for an item that is
2303: --lot controlled and serial control dynamic at SO issue,
2304: --do not NULL out serial_transaction_temp_id. In other cases,

Line 2357: inv_rcv_common_apis.do_check(

2353:
2354: -- append index in input table where the line to be detailed needs to be inserted
2355: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
2356: l_progress := '90';
2357: inv_rcv_common_apis.do_check(
2358: p_organization_id => p_organization_id
2359: , p_inventory_item_id => p_item_id
2360: , p_transaction_type_id => 61
2361: , p_primary_quantity => l_total_primary_qty

Line 2462: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm

2458: , p_attribute13 IN VARCHAR2 DEFAULT NULL
2459: , p_attribute14 IN VARCHAR2 DEFAULT NULL
2460: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2461: ) IS
2462: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2463: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2464: l_transaction_type VARCHAR2(20) := 'DELIVER';
2465: l_total_primary_qty NUMBER := 0;
2466: l_msg_count NUMBER;

Line 2643: inv_rcv_common_apis.init_startup_values(p_organization_id);

2639: SAVEPOINT crt_rma_rti_sp;
2640:
2641: -- query po_startup_value
2642: BEGIN
2643: inv_rcv_common_apis.init_startup_values(p_organization_id);
2644: EXCEPTION
2645: WHEN NO_DATA_FOUND THEN
2646: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2647: fnd_msg_pub.ADD;

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

2650:
2651: l_progress := '20';
2652:
2653: -- default l_group_id ? clear group id after done
2654: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2655: SELECT rcv_interface_groups_s.NEXTVAL
2656: INTO l_group_id
2657: FROM DUAL;
2658:

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

2655: SELECT rcv_interface_groups_s.NEXTVAL
2656: INTO l_group_id
2657: FROM DUAL;
2658:
2659: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2660:
2661: IF (l_debug = 1) THEN
2662: print_debug('create_rma_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
2663: END IF;

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

2661: IF (l_debug = 1) THEN
2662: print_debug('create_rma_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
2663: END IF;
2664: ELSE
2665: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2666:
2667: IF (l_debug = 1) THEN
2668: print_debug('create_rma_drct_dlvr_rti_rec: 2.2 - group_id stored already: ' || l_group_id, 4);
2669: END IF;

Line 2878: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR

2874: print_debug('In create_rma_drct_dlvr_rti_rec 7.6: l_rcv_transaction_rec.secondary_quantity'|| l_rcv_transaction_rec.secondary_quantity, 1);
2875: END IF;
2876:
2877: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
2878: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
2879: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
2880: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
2881:
2882: l_rcv_transaction_rec.lpn_id := p_lpn_id;

Line 2879: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR

2875: END IF;
2876:
2877: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
2878: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
2879: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
2880: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
2881:
2882: l_rcv_transaction_rec.lpn_id := p_lpn_id;
2883: l_rcv_transaction_rec.transfer_lpn_id := p_lpn_id;

Line 2880: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

2876:
2877: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
2878: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
2879: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
2880: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
2881:
2882: l_rcv_transaction_rec.lpn_id := p_lpn_id;
2883: l_rcv_transaction_rec.transfer_lpn_id := p_lpn_id;
2884: ELSE

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

2937: /* FP-J Lot/Serial Support Enhancement
2938: * Populate the table to store the information of the RTIs created used for
2939: * splitting the lots and serials based on RTI quantity
2940: */
2941: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2942: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2943: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2944: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2945: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

2938: * Populate the table to store the information of the RTIs created used for
2939: * splitting the lots and serials based on RTI quantity
2940: */
2941: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2942: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2943: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2944: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2945: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
2946: IF (l_debug = 1) THEN

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

2959: /* FP-J Lot/Serial Support Enhancement
2960: * Call the split_lot API to split the lots and serials inserted from the UI
2961: * based on the quantity of each RTI record
2962: */
2963: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2964: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2965:
2966: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2967: p_api_version => 1.0

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

2960: * Call the split_lot API to split the lots and serials inserted from the UI
2961: * based on the quantity of each RTI record
2962: */
2963: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2964: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2965:
2966: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2967: p_api_version => 1.0
2968: , p_init_msg_lst => FND_API.G_FALSE

Line 2989: inv_rcv_common_apis.do_check(

2985: -- append index in input table where the line to be detailed needs to be inserted
2986: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
2987:
2988: l_progress := '90';
2989: inv_rcv_common_apis.do_check(
2990: p_organization_id => p_organization_id
2991: , p_inventory_item_id => p_item_id
2992: , p_transaction_type_id => 15
2993: , p_primary_quantity => l_total_primary_qty

Line 3098: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm

3094: , p_attribute15 IN VARCHAR2 DEFAULT NULL
3095: , p_express_transaction IN VARCHAR2 DEFAULT NULL--Bug 5550783
3096: , p_location_id IN NUMBER DEFAULT NULL --Bug 13490287
3097: ) IS
3098: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
3099: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
3100: l_transaction_type VARCHAR2(20) := 'DELIVER';
3101: l_total_primary_qty NUMBER := 0;
3102: l_match_type VARCHAR2(20);

Line 3504: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

3500: AND ship_to_org_id = p_organization_id;
3501:
3502: --Bug 4552825 - Assign the value only if it is not null
3503: IF l_receipt_num IS NOT NULL THEN
3504: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
3505: END IF;
3506:
3507: IF (l_debug = 1) THEN
3508: print_debug('create_asn_con_dd_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

Line 3508: print_debug('create_asn_con_dd_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

3504: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
3505: END IF;
3506:
3507: IF (l_debug = 1) THEN
3508: print_debug('create_asn_con_dd_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
3509: END IF;
3510: EXCEPTION
3511: WHEN NO_DATA_FOUND THEN
3512: l_receipt_num := NULL;

Line 3515: inv_rcv_common_apis.init_startup_values(p_organization_id);

3511: WHEN NO_DATA_FOUND THEN
3512: l_receipt_num := NULL;
3513: END;
3514:
3515: inv_rcv_common_apis.init_startup_values(p_organization_id);
3516: EXCEPTION
3517: WHEN NO_DATA_FOUND THEN
3518: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3519: fnd_msg_pub.ADD;

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

3529:
3530: l_progress := '20';
3531:
3532: -- default l_group_id ? clear group id after done
3533: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3534: SELECT rcv_interface_groups_s.NEXTVAL
3535: INTO l_group_id
3536: FROM DUAL;
3537:

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

3534: SELECT rcv_interface_groups_s.NEXTVAL
3535: INTO l_group_id
3536: FROM DUAL;
3537:
3538: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3539: ELSE
3540: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3541: END IF;
3542:

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

3536: FROM DUAL;
3537:
3538: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3539: ELSE
3540: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3541: END IF;
3542:
3543: l_progress := '30';
3544: -- call matching algorithm ?

Line 3601: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

3597:
3598: -- Nested LPN changes
3599: -- Costgroup updates will be done by TM from patchset J
3600:
3601: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3602: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3603: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3604: BEGIN
3605: SELECT cost_group_id

Line 3602: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

3598: -- Nested LPN changes
3599: -- Costgroup updates will be done by TM from patchset J
3600:
3601: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3602: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3603: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3604: BEGIN
3605: SELECT cost_group_id
3606: INTO l_rcv_transaction_rec.cost_group_id

Line 3603: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

3599: -- Costgroup updates will be done by TM from patchset J
3600:
3601: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3602: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3603: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3604: BEGIN
3605: SELECT cost_group_id
3606: INTO l_rcv_transaction_rec.cost_group_id
3607: FROM wms_lpn_contents wlpnc

Line 3635: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po

3631: END IF;
3632: END IF;
3633:
3634: -- bug 3213241
3635: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3636: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3637: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3638: l_lpn_id := p_from_lpn_id;
3639: ELSE

Line 3636: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j

3632: END IF;
3633:
3634: -- bug 3213241
3635: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3636: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3637: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3638: l_lpn_id := p_from_lpn_id;
3639: ELSE
3640: l_lpn_id := p_lpn_id;

Line 3637: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN

3633:
3634: -- bug 3213241
3635: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3636: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3637: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3638: l_lpn_id := p_from_lpn_id;
3639: ELSE
3640: l_lpn_id := p_lpn_id;
3641: END IF;

Line 3801: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po

3797:
3798: -- Nested lpn changes.
3799: -- Pass From_lpn_id instead of p_lpn_id for creating confirm receipts.
3800: --IF p_from_lpn_id IS NOT NULL
3801: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3802: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3803: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3804: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
3805: ELSE

Line 3802: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j

3798: -- Nested lpn changes.
3799: -- Pass From_lpn_id instead of p_lpn_id for creating confirm receipts.
3800: --IF p_from_lpn_id IS NOT NULL
3801: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3802: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3803: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3804: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
3805: ELSE
3806: l_rcv_transaction_rec.lpn_id := p_lpn_id;

Line 3803: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN

3799: -- Pass From_lpn_id instead of p_lpn_id for creating confirm receipts.
3800: --IF p_from_lpn_id IS NOT NULL
3801: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3802: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3803: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3804: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
3805: ELSE
3806: l_rcv_transaction_rec.lpn_id := p_lpn_id;
3807: END IF;

Line 3840: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR

3836: -- Deliver_to_location_id is mandatory for Expense Items case
3837: -- So if no deliver_to_location_id is present in the distributions of po for Expense Items
3838: -- we will default it to the value passed from the mobile UI.
3839:
3840: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
3841: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
3842: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3843: NULL;
3844: ELSE

Line 3841: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR

3837: -- So if no deliver_to_location_id is present in the distributions of po for Expense Items
3838: -- we will default it to the value passed from the mobile UI.
3839:
3840: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
3841: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
3842: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3843: NULL;
3844: ELSE
3845: if l_rcv_rcpt_rec.destination_type_code = 'EXPENSE' then

Line 3842: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

3838: -- we will default it to the value passed from the mobile UI.
3839:
3840: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
3841: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
3842: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3843: NULL;
3844: ELSE
3845: if l_rcv_rcpt_rec.destination_type_code = 'EXPENSE' then
3846: IF (l_debug = 1) THEN

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

3903: /* FP-J Lot/Serial Support Enhancement
3904: * Populate the table to store the information of the RTIs created used for
3905: * splitting the lots and serials based on RTI quantity
3906: */
3907: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3908: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3909: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3910: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3911: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

3904: * Populate the table to store the information of the RTIs created used for
3905: * splitting the lots and serials based on RTI quantity
3906: */
3907: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3908: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3909: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3910: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3911: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
3912: IF (l_debug = 1) THEN

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

3924: /* FP-J Lot/Serial Support Enhancement
3925: * Call the split_lot API to split the lots and serials inserted from the UI
3926: * based on the quantity of each RTI record
3927: */
3928: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3929: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3930: l_msni_count := 0;
3931: --BUG 3326408,3346758,3405320
3932: --If there are any serials confirmed from the UI for an item that is

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

3925: * Call the split_lot API to split the lots and serials inserted from the UI
3926: * based on the quantity of each RTI record
3927: */
3928: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3929: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3930: l_msni_count := 0;
3931: --BUG 3326408,3346758,3405320
3932: --If there are any serials confirmed from the UI for an item that is
3933: --lot controlled and serial control dynamic at SO issue,

Line 3995: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

3991: -- UPDATE lpn context
3992: l_progress := '100';
3993:
3994: -- Nested LPN changes
3995: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3996: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3997: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3998: UPDATE wms_license_plate_numbers
3999: SET lpn_context = 3

Line 3996: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

3992: l_progress := '100';
3993:
3994: -- Nested LPN changes
3995: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3996: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3997: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3998: UPDATE wms_license_plate_numbers
3999: SET lpn_context = 3
4000: WHERE lpn_id = p_lpn_id;

Line 3997: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

3993:
3994: -- Nested LPN changes
3995: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3996: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3997: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3998: UPDATE wms_license_plate_numbers
3999: SET lpn_context = 3
4000: WHERE lpn_id = p_lpn_id;
4001: END IF;

Line 4005: inv_rcv_common_apis.do_check(

4001: END IF;
4002:
4003: l_progress := '110';
4004: l_progress := '120';
4005: inv_rcv_common_apis.do_check(
4006: p_organization_id => p_organization_id
4007: , p_inventory_item_id => p_item_id
4008: , p_transaction_type_id => 18
4009: , p_primary_quantity => l_total_primary_qty

Line 4310: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

4306: , l_secondary_quantity; --Bug 7656734
4307: EXIT WHEN l_curs_asn_lpn_content%NOTFOUND;
4308: l_progress := '30';
4309:
4310: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4311: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4312: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4313: inv_rcv_std_rcpt_apis.update_lpn_org(
4314: p_organization_id => p_organization_id

Line 4311: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

4307: EXIT WHEN l_curs_asn_lpn_content%NOTFOUND;
4308: l_progress := '30';
4309:
4310: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4311: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4312: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4313: inv_rcv_std_rcpt_apis.update_lpn_org(
4314: p_organization_id => p_organization_id
4315: , p_lpn_id => l_lpn_id

Line 4312: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

4308: l_progress := '30';
4309:
4310: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4311: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4312: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4313: inv_rcv_std_rcpt_apis.update_lpn_org(
4314: p_organization_id => p_organization_id
4315: , p_lpn_id => l_lpn_id
4316: , x_return_status => l_return_status

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

4338: * If either INV J or PO J are not installed, then retain the existing logic
4339: * to create temp records for lots and serials
4340: * If both INV J and PO J are installed, create interface records for the lots/serials
4341: */
4342: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4343: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4344: -- insert into mtlt
4345: IF l_lot_number IS NOT NULL THEN
4346: IF (l_debug = 1) THEN

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

4339: * to create temp records for lots and serials
4340: * If both INV J and PO J are installed, create interface records for the lots/serials
4341: */
4342: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4343: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4344: -- insert into mtlt
4345: IF l_lot_number IS NOT NULL THEN
4346: IF (l_debug = 1) THEN
4347: print_debug('create_asn_exp_dd_intf_rec: 25 before inv_rcv_common_apis.insert_lot'

Line 4347: print_debug('create_asn_exp_dd_intf_rec: 25 before inv_rcv_common_apis.insert_lot'

4343: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4344: -- insert into mtlt
4345: IF l_lot_number IS NOT NULL THEN
4346: IF (l_debug = 1) THEN
4347: print_debug('create_asn_exp_dd_intf_rec: 25 before inv_rcv_common_apis.insert_lot'
4348: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
4349: , 4);
4350: END IF;
4351:

Line 4389: inv_rcv_common_apis.insert_lot(

4385: print_debug('l_lot_expiration_date = '||l_lot_expiration_date, 4);
4386: END IF;
4387:
4388: l_primary_qty := l_quantity * l_uom_conv_ratio;
4389: inv_rcv_common_apis.insert_lot(
4390: p_transaction_temp_id => l_transaction_temp_id
4391: , p_created_by => fnd_global.user_id
4392: , p_transaction_qty => l_quantity
4393: , p_primary_qty => l_primary_qty

Line 4408: 'create_asn_exp_dd_intf_rec 25.1: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_ERROR;'

4404: fnd_msg_pub.ADD;
4405:
4406: IF (l_debug = 1) THEN
4407: print_debug(
4408: 'create_asn_exp_dd_intf_rec 25.1: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_ERROR;'
4409: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4410: END IF;
4411:
4412: RAISE fnd_api.g_exc_error;

Line 4421: 'create_asn_exp_dd_intf_rec 25.2: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

4417: fnd_msg_pub.ADD;
4418:
4419: IF (l_debug = 1) THEN
4420: print_debug(
4421: 'create_asn_exp_dd_intf_rec 25.2: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
4422: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4423: END IF;
4424:
4425: RAISE fnd_api.g_exc_unexpected_error;

Line 4799: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po

4795:
4796: -- Nested LPN changes, If INVJ,POJ,WMSJ Installed then
4797: -- insert WLPNI for FromLPN with parent as NULL.
4798:
4799: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
4800: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
4801: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
4802: IF (l_debug = 1) THEN
4803: print_debug(

Line 4800: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j

4796: -- Nested LPN changes, If INVJ,POJ,WMSJ Installed then
4797: -- insert WLPNI for FromLPN with parent as NULL.
4798:
4799: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
4800: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
4801: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
4802: IF (l_debug = 1) THEN
4803: print_debug(
4804: 'create_asn_exp_dd_intf_rec: 50.1 - Before inserting into wlpni for p_lpn_id with parent NULL '

Line 4801: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN

4797: -- insert WLPNI for FromLPN with parent as NULL.
4798:
4799: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
4800: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
4801: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
4802: IF (l_debug = 1) THEN
4803: print_debug(
4804: 'create_asn_exp_dd_intf_rec: 50.1 - Before inserting into wlpni for p_lpn_id with parent NULL '
4805: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 4824: ,p_lpn_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4820: ,p_organization_id => l_from_org_id -- BUG 4096028: should
4821: -- from org_id
4822: ,p_lpn_id => p_lpn_id
4823: ,p_license_plate_number => NULL
4824: ,p_lpn_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4825: ,p_parent_lpn_id => NULL
4826: );
4827:
4828: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 4857: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

4853:
4854: -- UPDATE lpn context
4855:
4856:
4857: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4858: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4859: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4860:
4861: UPDATE wms_license_plate_numbers

Line 4858: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

4854: -- UPDATE lpn context
4855:
4856:
4857: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4858: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4859: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4860:
4861: UPDATE wms_license_plate_numbers
4862: SET lpn_context = 3

Line 4859: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

4855:
4856:
4857: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4858: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4859: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4860:
4861: UPDATE wms_license_plate_numbers
4862: SET lpn_context = 3
4863: WHERE source_header_id = p_shipment_header_id

Line 4876: || inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4872: IF (l_debug = 1) THEN
4873: print_debug(' create_asn_exp_dd_intf_rec: Before Update lpn history ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4874: print_debug(
4875: ' create_asn_exp_dd_intf_rec: Group_id = '
4876: || inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4877: || ' '
4878: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4879: END IF;
4880:

Line 4883: , source_header_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4879: END IF;
4880:
4881: UPDATE wms_lpn_histories
4882: SET source_name = 'ASNEXP'
4883: , source_header_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4884: WHERE lpn_context = 7
4885: AND parent_lpn_id IN(SELECT lpn_id
4886: FROM wms_license_plate_numbers
4887: WHERE source_header_id = p_shipment_header_id

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

4981: /* Group BY LPN_ID is changed for Express Receipts */
4982: /* Also duplicate print of LPN labels is avoided */
4983: SELECT MAX(rti.interface_transaction_id)
4984: FROM rcv_transactions_interface rti
4985: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4986: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
4987: -- GROUP BY rti.lpn_id;
4988:
4989: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

4994: IF (l_debug = 1) THEN
4995: print_debug('create_osp_direct_rti_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4996: END IF;
4997:
4998: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4999: --BUG 3440184: For performance reason, use the follow query
5000: --instead of gl_sets_of_books
5001: SELECT TO_NUMBER(hoi.org_information1)
5002: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

Line 5002: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

4998: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4999: --BUG 3440184: For performance reason, use the follow query
5000: --instead of gl_sets_of_books
5001: SELECT TO_NUMBER(hoi.org_information1)
5002: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5003: FROM hr_organization_information hoi
5004: WHERE hoi.organization_id = p_organization_id
5005: AND (hoi.org_information_context || '') = 'Accounting Information';
5006:

Line 5008: --INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5004: WHERE hoi.organization_id = p_organization_id
5005: AND (hoi.org_information_context || '') = 'Accounting Information';
5006:
5007: --SELECT ood.set_of_books_id
5008: --INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5009: --FROM org_organization_definitions ood, gl_sets_of_books sob
5010: --WHERE organization_id = p_organization_id
5011: --AND sob.set_of_books_id = ood.set_of_books_id;
5012: END IF;

Line 5016: inv_rcv_common_apis.validate_trx_date(

5012: END IF;
5013:
5014: l_progress := '10';
5015: -- first check if the transaction date satisfies the validation.
5016: inv_rcv_common_apis.validate_trx_date(
5017: p_trx_date => SYSDATE
5018: , p_organization_id => p_organization_id
5019: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5020: , x_return_status => x_status

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

5015: -- first check if the transaction date satisfies the validation.
5016: inv_rcv_common_apis.validate_trx_date(
5017: p_trx_date => SYSDATE
5018: , p_organization_id => p_organization_id
5019: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5020: , x_return_status => x_status
5021: , x_error_code => x_message
5022: );
5023:

Line 5114: 'create_osp_direct_rti_rec: 8.1 before inv_label.print_label ' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id, 4);

5110: l_progress := '40';
5111:
5112: IF (l_debug = 1) THEN
5113: print_debug(
5114: 'create_osp_direct_rti_rec: 8.1 before inv_label.print_label ' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id, 4);
5115: END IF;
5116:
5117: /* FP-J Lot/Serial Support Enhancement
5118: * If INV J and PO J are installed, do not call label printing API at this stage

Line 5120: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR

5116:
5117: /* FP-J Lot/Serial Support Enhancement
5118: * If INV J and PO J are installed, do not call label printing API at this stage
5119: */
5120: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
5121: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
5122:
5123: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952 ..For PO receipt, code in rcv_insert_update_header(INVSTDRB.pls) will be called.
5124: l_counter := 1;

Line 5121: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN

5117: /* FP-J Lot/Serial Support Enhancement
5118: * If INV J and PO J are installed, do not call label printing API at this stage
5119: */
5120: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
5121: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
5122:
5123: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952 ..For PO receipt, code in rcv_insert_update_header(INVSTDRB.pls) will be called.
5124: l_counter := 1;
5125: OPEN c_rti_txn_id;

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

5261: /* Group BY LPN_ID is changed for Express Receipts */
5262: /* Also duplicate print of LPN labels is avoided */
5263: SELECT MAX(rti.interface_transaction_id)
5264: FROM rcv_transactions_interface rti
5265: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5266: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5267:
5268: -- GROUP BY rti.lpn_id;
5269: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

5278: IF (l_debug = 1) THEN
5279: print_debug('txn temp id: ' || p_transaction_temp_id, 4);
5280: END IF;
5281:
5282: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
5283:
5284: --BUG 3440184: For performance reason, use the follow query
5285: --instead of gl_sets_of_books
5286:

Line 5288: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5284: --BUG 3440184: For performance reason, use the follow query
5285: --instead of gl_sets_of_books
5286:
5287: SELECT TO_NUMBER(hoi.org_information1)
5288: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5289: FROM hr_organization_information hoi
5290: WHERE hoi.organization_id = p_organization_id
5291: AND (hoi.org_information_context || '') = 'Accounting Information';
5292:

Line 5294: -- INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5290: WHERE hoi.organization_id = p_organization_id
5291: AND (hoi.org_information_context || '') = 'Accounting Information';
5292:
5293: -- SELECT ood.set_of_books_id
5294: -- INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5295: -- FROM org_organization_definitions ood, gl_sets_of_books sob
5296: -- WHERE organization_id = p_organization_id
5297: -- AND sob.set_of_books_id = ood.set_of_books_id;
5298:

Line 5303: inv_rcv_common_apis.validate_trx_date(

5299: END IF;
5300:
5301: l_progress := '10';
5302: -- first check if the transaction date satisfies the validation.
5303: inv_rcv_common_apis.validate_trx_date(
5304: p_trx_date => SYSDATE
5305: , p_organization_id => p_organization_id
5306: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5307: , x_return_status => x_status

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

5302: -- first check if the transaction date satisfies the validation.
5303: inv_rcv_common_apis.validate_trx_date(
5304: p_trx_date => SYSDATE
5305: , p_organization_id => p_organization_id
5306: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5307: , x_return_status => x_status
5308: , x_error_code => x_message
5309: );
5310:

Line 5855: print_debug('create_direct_rti_rec: 8.1 before inv_label.print_label ' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id, 4);

5851: IF l_return_status <> fnd_api.g_ret_sts_error THEN
5852: l_progress := '80';
5853:
5854: IF (l_debug = 1) THEN
5855: print_debug('create_direct_rti_rec: 8.1 before inv_label.print_label ' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id, 4);
5856: END IF;
5857:
5858: /* FP-J Lot/Serial Support Enhancement
5859: * If INV J and PO J are installed, do not call label printing API at this stage

Line 5861: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR

5857:
5858: /* FP-J Lot/Serial Support Enhancement
5859: * If INV J and PO J are installed, do not call label printing API at this stage
5860: */
5861: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
5862: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
5863:
5864: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952.. For PO receipt code in rcv_insert_update_header(INVSTDRB.pls) will be called.
5865:

Line 5862: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN

5858: /* FP-J Lot/Serial Support Enhancement
5859: * If INV J and PO J are installed, do not call label printing API at this stage
5860: */
5861: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
5862: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
5863:
5864: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952.. For PO receipt code in rcv_insert_update_header(INVSTDRB.pls) will be called.
5865:
5866: l_counter := 1;

Line 5946: (p_trx_hdr_id => inv_rcv_common_apis.g_rcv_global_var.transaction_header_id,

5942: print_debug('Enter pack_lpn_txn: 1'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') , 1);
5943: END IF;
5944:
5945: l_return_status := inv_lpn_trx_pub.process_lpn_trx
5946: (p_trx_hdr_id => inv_rcv_common_apis.g_rcv_global_var.transaction_header_id,
5947: p_mode => 2, -- putaway mode
5948: p_commit => 'F',
5949: x_proc_msg => l_proc_msg);
5950: