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 1833: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

1829: AND ship_to_org_id = p_organization_id;
1830:
1831: --Bug 4552825 - Assign the value only if it is not null
1832: IF l_receipt_num IS NOT NULL THEN
1833: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
1834: END IF;
1835:
1836: IF (l_debug = 1) THEN
1837: print_debug('create_int_shp_dr_del_rti_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

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

1833: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
1834: END IF;
1835:
1836: IF (l_debug = 1) THEN
1837: print_debug('create_int_shp_dr_del_rti_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
1838: END IF;
1839: EXCEPTION
1840: WHEN NO_DATA_FOUND THEN
1841: l_receipt_num := NULL;

Line 1844: inv_rcv_common_apis.init_startup_values(p_organization_id);

1840: WHEN NO_DATA_FOUND THEN
1841: l_receipt_num := NULL;
1842: END;
1843:
1844: inv_rcv_common_apis.init_startup_values(p_organization_id);
1845: EXCEPTION
1846: WHEN NO_DATA_FOUND THEN
1847: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1848: fnd_msg_pub.ADD;

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

1851:
1852: l_progress := '20';
1853:
1854: -- default l_group_id ? clear group id after done
1855: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1856: SELECT rcv_interface_groups_s.NEXTVAL
1857: INTO l_group_id
1858: FROM DUAL;
1859:

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

1856: SELECT rcv_interface_groups_s.NEXTVAL
1857: INTO l_group_id
1858: FROM DUAL;
1859:
1860: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1861:
1862: IF (l_debug = 1) THEN
1863: print_debug('create_int_shp_dr_del_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
1864: END IF;

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

1862: IF (l_debug = 1) THEN
1863: print_debug('create_int_shp_dr_del_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
1864: END IF;
1865: ELSE
1866: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1867:
1868: IF (l_debug = 1) THEN
1869: print_debug('create_int_shp_dr_del_rti_rec: 2.2 - group_id stored already: ' || l_group_id, 4);
1870: END IF;

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

2097:
2098: -- Nested LPN changes If FromLPN is not null and Patchset Level of INV,WMS,PO
2099: -- are at J then pass From_lpn_id as lpn_id otherwise use old code.
2100: --IF p_from_lpn_id IS NOT NULL
2101: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
2102: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
2103: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
2104: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
2105: ELSE

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

2098: -- Nested LPN changes If FromLPN is not null and Patchset Level of INV,WMS,PO
2099: -- are at J then pass From_lpn_id as lpn_id otherwise use old code.
2100: --IF p_from_lpn_id IS NOT NULL
2101: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
2102: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
2103: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
2104: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
2105: ELSE
2106: l_rcv_transaction_rec.lpn_id := p_lpn_id;

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

2099: -- are at J then pass From_lpn_id as lpn_id otherwise use old code.
2100: --IF p_from_lpn_id IS NOT NULL
2101: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
2102: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
2103: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
2104: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
2105: ELSE
2106: l_rcv_transaction_rec.lpn_id := p_lpn_id;
2107: END IF;

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

2160: /* FP-J Lot/Serial Support Enhancement
2161: * Populate the table to store the information of the RTIs created used for
2162: * splitting the lots and serials based on RTI quantity
2163: */
2164: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2165: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2166: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2167: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2168: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

2161: * Populate the table to store the information of the RTIs created used for
2162: * splitting the lots and serials based on RTI quantity
2163: */
2164: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2165: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2166: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2167: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2168: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
2169: IF (l_debug = 1) THEN

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

2186:
2187: /* FP-J Lot/Serial Support Enhancement
2188: * No updates to rcv_serials_supply if INV J and PO J are installed
2189: */
2190: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
2191: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
2192: IF l_rcv_rcpt_rec.req_line_id IS NOT NULL
2193: AND p_serial_control_code NOT IN(1, 6) THEN
2194: -- update rss for req

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

2187: /* FP-J Lot/Serial Support Enhancement
2188: * No updates to rcv_serials_supply if INV J and PO J are installed
2189: */
2190: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
2191: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
2192: IF l_rcv_rcpt_rec.req_line_id IS NOT NULL
2193: AND p_serial_control_code NOT IN(1, 6) THEN
2194: -- update rss for req
2195: inv_rcv_std_deliver_apis.update_rcv_serials_supply(

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

2211: /* FP-J Lot/Serial Support Enhancement
2212: * Call the split_lot API to split the lots and serials inserted from the UI
2213: * based on the quantity of each RTI record
2214: */
2215: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2216: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2217: --BUG 3326408,3346758,3405320
2218: --If there are any serials confirmed from the UI for an item that is
2219: --lot controlled and serial control dynamic at SO issue,

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

2212: * Call the split_lot API to split the lots and serials inserted from the UI
2213: * based on the quantity of each RTI record
2214: */
2215: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2216: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2217: --BUG 3326408,3346758,3405320
2218: --If there are any serials confirmed from the UI for an item that is
2219: --lot controlled and serial control dynamic at SO issue,
2220: --do not NULL out serial_transaction_temp_id. In other cases,

Line 2272: inv_rcv_common_apis.do_check(

2268:
2269: -- append index in input table where the line to be detailed needs to be inserted
2270: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
2271: l_progress := '90';
2272: inv_rcv_common_apis.do_check(
2273: p_organization_id => p_organization_id
2274: , p_inventory_item_id => p_item_id
2275: , p_transaction_type_id => 61
2276: , p_primary_quantity => l_total_primary_qty

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

2373: , p_attribute13 IN VARCHAR2 DEFAULT NULL
2374: , p_attribute14 IN VARCHAR2 DEFAULT NULL
2375: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2376: ) IS
2377: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2378: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2379: l_transaction_type VARCHAR2(20) := 'DELIVER';
2380: l_total_primary_qty NUMBER := 0;
2381: l_msg_count NUMBER;

Line 2558: inv_rcv_common_apis.init_startup_values(p_organization_id);

2554: SAVEPOINT crt_rma_rti_sp;
2555:
2556: -- query po_startup_value
2557: BEGIN
2558: inv_rcv_common_apis.init_startup_values(p_organization_id);
2559: EXCEPTION
2560: WHEN NO_DATA_FOUND THEN
2561: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2562: fnd_msg_pub.ADD;

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

2565:
2566: l_progress := '20';
2567:
2568: -- default l_group_id ? clear group id after done
2569: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2570: SELECT rcv_interface_groups_s.NEXTVAL
2571: INTO l_group_id
2572: FROM DUAL;
2573:

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

2570: SELECT rcv_interface_groups_s.NEXTVAL
2571: INTO l_group_id
2572: FROM DUAL;
2573:
2574: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2575:
2576: IF (l_debug = 1) THEN
2577: print_debug('create_rma_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
2578: END IF;

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

2576: IF (l_debug = 1) THEN
2577: print_debug('create_rma_drct_dlvr_rti_rec: 2.1 - group_id created: ' || l_group_id, 4);
2578: END IF;
2579: ELSE
2580: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2581:
2582: IF (l_debug = 1) THEN
2583: print_debug('create_rma_drct_dlvr_rti_rec: 2.2 - group_id stored already: ' || l_group_id, 4);
2584: END IF;

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

2771: l_total_primary_qty := l_total_primary_qty + l_rcv_transaction_rec.primary_quantity;
2772: l_progress := '70';
2773:
2774: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
2775: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
2776: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
2777: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
2778:
2779: l_rcv_transaction_rec.lpn_id := p_lpn_id;

Line 2776: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR

2772: l_progress := '70';
2773:
2774: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
2775: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
2776: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
2777: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
2778:
2779: l_rcv_transaction_rec.lpn_id := p_lpn_id;
2780: l_rcv_transaction_rec.transfer_lpn_id := p_lpn_id;

Line 2777: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN

2773:
2774: -- Nested LPN changes. Populate p_lpn_id as NULL for patchset J and above
2775: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po OR
2776: inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j OR
2777: inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
2778:
2779: l_rcv_transaction_rec.lpn_id := p_lpn_id;
2780: l_rcv_transaction_rec.transfer_lpn_id := p_lpn_id;
2781: ELSE

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

2834: /* FP-J Lot/Serial Support Enhancement
2835: * Populate the table to store the information of the RTIs created used for
2836: * splitting the lots and serials based on RTI quantity
2837: */
2838: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2839: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2840: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2841: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2842: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

2835: * Populate the table to store the information of the RTIs created used for
2836: * splitting the lots and serials based on RTI quantity
2837: */
2838: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2839: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2840: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
2841: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
2842: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
2843: IF (l_debug = 1) THEN

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

2856: /* FP-J Lot/Serial Support Enhancement
2857: * Call the split_lot API to split the lots and serials inserted from the UI
2858: * based on the quantity of each RTI record
2859: */
2860: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2861: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2862:
2863: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2864: p_api_version => 1.0

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

2857: * Call the split_lot API to split the lots and serials inserted from the UI
2858: * based on the quantity of each RTI record
2859: */
2860: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2861: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2862:
2863: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2864: p_api_version => 1.0
2865: , p_init_msg_lst => FND_API.G_FALSE

Line 2886: inv_rcv_common_apis.do_check(

2882: -- append index in input table where the line to be detailed needs to be inserted
2883: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
2884:
2885: l_progress := '90';
2886: inv_rcv_common_apis.do_check(
2887: p_organization_id => p_organization_id
2888: , p_inventory_item_id => p_item_id
2889: , p_transaction_type_id => 15
2890: , p_primary_quantity => l_total_primary_qty

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

2990: , p_attribute14 IN VARCHAR2 DEFAULT NULL
2991: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2992: , p_express_transaction IN VARCHAR2 DEFAULT NULL--Bug 5550783
2993: ) IS
2994: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2995: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2996: l_transaction_type VARCHAR2(20) := 'DELIVER';
2997: l_total_primary_qty NUMBER := 0;
2998: l_match_type VARCHAR2(20);

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

3396: AND ship_to_org_id = p_organization_id;
3397:
3398: --Bug 4552825 - Assign the value only if it is not null
3399: IF l_receipt_num IS NOT NULL THEN
3400: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
3401: END IF;
3402:
3403: IF (l_debug = 1) THEN
3404: print_debug('create_asn_con_dd_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

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

3400: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
3401: END IF;
3402:
3403: IF (l_debug = 1) THEN
3404: print_debug('create_asn_con_dd_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
3405: END IF;
3406: EXCEPTION
3407: WHEN NO_DATA_FOUND THEN
3408: l_receipt_num := NULL;

Line 3411: inv_rcv_common_apis.init_startup_values(p_organization_id);

3407: WHEN NO_DATA_FOUND THEN
3408: l_receipt_num := NULL;
3409: END;
3410:
3411: inv_rcv_common_apis.init_startup_values(p_organization_id);
3412: EXCEPTION
3413: WHEN NO_DATA_FOUND THEN
3414: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3415: fnd_msg_pub.ADD;

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

3425:
3426: l_progress := '20';
3427:
3428: -- default l_group_id ? clear group id after done
3429: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3430: SELECT rcv_interface_groups_s.NEXTVAL
3431: INTO l_group_id
3432: FROM DUAL;
3433:

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

3430: SELECT rcv_interface_groups_s.NEXTVAL
3431: INTO l_group_id
3432: FROM DUAL;
3433:
3434: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3435: ELSE
3436: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3437: END IF;
3438:

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

3432: FROM DUAL;
3433:
3434: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3435: ELSE
3436: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3437: END IF;
3438:
3439: l_progress := '30';
3440: -- call matching algorithm ?

Line 3497: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

3493:
3494: -- Nested LPN changes
3495: -- Costgroup updates will be done by TM from patchset J
3496:
3497: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3498: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3499: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3500: BEGIN
3501: SELECT cost_group_id

Line 3498: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

3494: -- Nested LPN changes
3495: -- Costgroup updates will be done by TM from patchset J
3496:
3497: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3498: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3499: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3500: BEGIN
3501: SELECT cost_group_id
3502: INTO l_rcv_transaction_rec.cost_group_id

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

3495: -- Costgroup updates will be done by TM from patchset J
3496:
3497: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3498: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3499: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3500: BEGIN
3501: SELECT cost_group_id
3502: INTO l_rcv_transaction_rec.cost_group_id
3503: FROM wms_lpn_contents wlpnc

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

3527: END IF;
3528: END IF;
3529:
3530: -- bug 3213241
3531: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3532: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3533: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3534: l_lpn_id := p_from_lpn_id;
3535: ELSE

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

3528: END IF;
3529:
3530: -- bug 3213241
3531: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3532: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3533: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3534: l_lpn_id := p_from_lpn_id;
3535: ELSE
3536: l_lpn_id := p_lpn_id;

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

3529:
3530: -- bug 3213241
3531: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3532: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3533: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3534: l_lpn_id := p_from_lpn_id;
3535: ELSE
3536: l_lpn_id := p_lpn_id;
3537: END IF;

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

3682:
3683: -- Nested lpn changes.
3684: -- Pass From_lpn_id instead of p_lpn_id for creating confirm receipts.
3685: --IF p_from_lpn_id IS NOT NULL
3686: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3687: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3688: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3689: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
3690: ELSE

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

3683: -- Nested lpn changes.
3684: -- Pass From_lpn_id instead of p_lpn_id for creating confirm receipts.
3685: --IF p_from_lpn_id IS NOT NULL
3686: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3687: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3688: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3689: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
3690: ELSE
3691: l_rcv_transaction_rec.lpn_id := p_lpn_id;

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

3684: -- Pass From_lpn_id instead of p_lpn_id for creating confirm receipts.
3685: --IF p_from_lpn_id IS NOT NULL
3686: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
3687: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
3688: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
3689: l_rcv_transaction_rec.lpn_id := p_from_lpn_id;
3690: ELSE
3691: l_rcv_transaction_rec.lpn_id := p_lpn_id;
3692: END IF;

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

3763: /* FP-J Lot/Serial Support Enhancement
3764: * Populate the table to store the information of the RTIs created used for
3765: * splitting the lots and serials based on RTI quantity
3766: */
3767: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3768: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3769: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3770: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3771: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;

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

3764: * Populate the table to store the information of the RTIs created used for
3765: * splitting the lots and serials based on RTI quantity
3766: */
3767: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3768: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3769: l_new_rti_info(match_result_count).orig_interface_trx_id := p_transaction_temp_id;
3770: l_new_rti_info(match_result_count).new_interface_trx_id := g_interface_transaction_id;
3771: l_new_rti_info(match_result_count).quantity := l_rcv_transaction_rec.transaction_qty;
3772: IF (l_debug = 1) THEN

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

3784: /* FP-J Lot/Serial Support Enhancement
3785: * Call the split_lot API to split the lots and serials inserted from the UI
3786: * based on the quantity of each RTI record
3787: */
3788: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3789: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3790: l_msni_count := 0;
3791: --BUG 3326408,3346758,3405320
3792: --If there are any serials confirmed from the UI for an item that is

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

3785: * Call the split_lot API to split the lots and serials inserted from the UI
3786: * based on the quantity of each RTI record
3787: */
3788: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3789: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3790: l_msni_count := 0;
3791: --BUG 3326408,3346758,3405320
3792: --If there are any serials confirmed from the UI for an item that is
3793: --lot controlled and serial control dynamic at SO issue,

Line 3855: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

3851: -- UPDATE lpn context
3852: l_progress := '100';
3853:
3854: -- Nested LPN changes
3855: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3856: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3857: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3858: UPDATE wms_license_plate_numbers
3859: SET lpn_context = 3

Line 3856: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

3852: l_progress := '100';
3853:
3854: -- Nested LPN changes
3855: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3856: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3857: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3858: UPDATE wms_license_plate_numbers
3859: SET lpn_context = 3
3860: WHERE lpn_id = p_lpn_id;

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

3853:
3854: -- Nested LPN changes
3855: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3856: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3857: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3858: UPDATE wms_license_plate_numbers
3859: SET lpn_context = 3
3860: WHERE lpn_id = p_lpn_id;
3861: END IF;

Line 3865: inv_rcv_common_apis.do_check(

3861: END IF;
3862:
3863: l_progress := '110';
3864: l_progress := '120';
3865: inv_rcv_common_apis.do_check(
3866: p_organization_id => p_organization_id
3867: , p_inventory_item_id => p_item_id
3868: , p_transaction_type_id => 18
3869: , p_primary_quantity => l_total_primary_qty

Line 4166: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

4162: , l_lpn_org;
4163: EXIT WHEN l_curs_asn_lpn_content%NOTFOUND;
4164: l_progress := '30';
4165:
4166: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4167: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4168: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4169: inv_rcv_std_rcpt_apis.update_lpn_org(
4170: p_organization_id => p_organization_id

Line 4167: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

4163: EXIT WHEN l_curs_asn_lpn_content%NOTFOUND;
4164: l_progress := '30';
4165:
4166: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4167: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4168: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4169: inv_rcv_std_rcpt_apis.update_lpn_org(
4170: p_organization_id => p_organization_id
4171: , p_lpn_id => l_lpn_id

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

4164: l_progress := '30';
4165:
4166: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4167: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4168: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4169: inv_rcv_std_rcpt_apis.update_lpn_org(
4170: p_organization_id => p_organization_id
4171: , p_lpn_id => l_lpn_id
4172: , x_return_status => l_return_status

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

4194: * If either INV J or PO J are not installed, then retain the existing logic
4195: * to create temp records for lots and serials
4196: * If both INV J and PO J are installed, create interface records for the lots/serials
4197: */
4198: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4199: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4200: -- insert into mtlt
4201: IF l_lot_number IS NOT NULL THEN
4202: IF (l_debug = 1) THEN

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

4195: * to create temp records for lots and serials
4196: * If both INV J and PO J are installed, create interface records for the lots/serials
4197: */
4198: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4199: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4200: -- insert into mtlt
4201: IF l_lot_number IS NOT NULL THEN
4202: IF (l_debug = 1) THEN
4203: print_debug('create_asn_exp_dd_intf_rec: 25 before inv_rcv_common_apis.insert_lot'

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

4199: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4200: -- insert into mtlt
4201: IF l_lot_number IS NOT NULL THEN
4202: IF (l_debug = 1) THEN
4203: print_debug('create_asn_exp_dd_intf_rec: 25 before inv_rcv_common_apis.insert_lot'
4204: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
4205: , 4);
4206: END IF;
4207:

Line 4245: inv_rcv_common_apis.insert_lot(

4241: print_debug('l_lot_expiration_date = '||l_lot_expiration_date, 4);
4242: END IF;
4243:
4244: l_primary_qty := l_quantity * l_uom_conv_ratio;
4245: inv_rcv_common_apis.insert_lot(
4246: p_transaction_temp_id => l_transaction_temp_id
4247: , p_created_by => fnd_global.user_id
4248: , p_transaction_qty => l_quantity
4249: , p_primary_qty => l_primary_qty

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

4260: fnd_msg_pub.ADD;
4261:
4262: IF (l_debug = 1) THEN
4263: print_debug(
4264: 'create_asn_exp_dd_intf_rec 25.1: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_ERROR;'
4265: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4266: END IF;
4267:
4268: RAISE fnd_api.g_exc_error;

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

4273: fnd_msg_pub.ADD;
4274:
4275: IF (l_debug = 1) THEN
4276: print_debug(
4277: 'create_asn_exp_dd_intf_rec 25.2: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
4278: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4279: END IF;
4280:
4281: RAISE fnd_api.g_exc_unexpected_error;

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

4650:
4651: -- Nested LPN changes, If INVJ,POJ,WMSJ Installed then
4652: -- insert WLPNI for FromLPN with parent as NULL.
4653:
4654: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
4655: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
4656: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
4657: IF (l_debug = 1) THEN
4658: print_debug(

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

4651: -- Nested LPN changes, If INVJ,POJ,WMSJ Installed then
4652: -- insert WLPNI for FromLPN with parent as NULL.
4653:
4654: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
4655: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
4656: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
4657: IF (l_debug = 1) THEN
4658: print_debug(
4659: 'create_asn_exp_dd_intf_rec: 50.1 - Before inserting into wlpni for p_lpn_id with parent NULL '

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

4652: -- insert WLPNI for FromLPN with parent as NULL.
4653:
4654: IF inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po
4655: AND inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j
4656: AND inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j THEN
4657: IF (l_debug = 1) THEN
4658: print_debug(
4659: 'create_asn_exp_dd_intf_rec: 50.1 - Before inserting into wlpni for p_lpn_id with parent NULL '
4660: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

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

4675: ,p_organization_id => l_from_org_id -- BUG 4096028: should
4676: -- from org_id
4677: ,p_lpn_id => p_lpn_id
4678: ,p_license_plate_number => NULL
4679: ,p_lpn_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4680: ,p_parent_lpn_id => NULL
4681: );
4682:
4683: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 4712: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

4708:
4709: -- UPDATE lpn context
4710:
4711:
4712: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4713: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4714: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4715:
4716: UPDATE wms_license_plate_numbers

Line 4713: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

4709: -- UPDATE lpn context
4710:
4711:
4712: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4713: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4714: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4715:
4716: UPDATE wms_license_plate_numbers
4717: SET lpn_context = 3

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

4710:
4711:
4712: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4713: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4714: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4715:
4716: UPDATE wms_license_plate_numbers
4717: SET lpn_context = 3
4718: WHERE source_header_id = p_shipment_header_id

Line 4731: || inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4727: IF (l_debug = 1) THEN
4728: print_debug(' create_asn_exp_dd_intf_rec: Before Update lpn history ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4729: print_debug(
4730: ' create_asn_exp_dd_intf_rec: Group_id = '
4731: || inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4732: || ' '
4733: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4734: END IF;
4735:

Line 4738: , source_header_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

4734: END IF;
4735:
4736: UPDATE wms_lpn_histories
4737: SET source_name = 'ASNEXP'
4738: , source_header_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4739: WHERE lpn_context = 7
4740: AND parent_lpn_id IN(SELECT lpn_id
4741: FROM wms_license_plate_numbers
4742: WHERE source_header_id = p_shipment_header_id

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

4836: /* Group BY LPN_ID is changed for Express Receipts */
4837: /* Also duplicate print of LPN labels is avoided */
4838: SELECT MAX(rti.interface_transaction_id)
4839: FROM rcv_transactions_interface rti
4840: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4841: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
4842: -- GROUP BY rti.lpn_id;
4843:
4844: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

4849: IF (l_debug = 1) THEN
4850: print_debug('create_osp_direct_rti_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4851: END IF;
4852:
4853: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4854: --BUG 3440184: For performance reason, use the follow query
4855: --instead of gl_sets_of_books
4856: SELECT TO_NUMBER(hoi.org_information1)
4857: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

Line 4857: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

4853: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4854: --BUG 3440184: For performance reason, use the follow query
4855: --instead of gl_sets_of_books
4856: SELECT TO_NUMBER(hoi.org_information1)
4857: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4858: FROM hr_organization_information hoi
4859: WHERE hoi.organization_id = p_organization_id
4860: AND (hoi.org_information_context || '') = 'Accounting Information';
4861:

Line 4863: --INTO inv_rcv_common_apis.g_po_startup_value.sob_id

4859: WHERE hoi.organization_id = p_organization_id
4860: AND (hoi.org_information_context || '') = 'Accounting Information';
4861:
4862: --SELECT ood.set_of_books_id
4863: --INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4864: --FROM org_organization_definitions ood, gl_sets_of_books sob
4865: --WHERE organization_id = p_organization_id
4866: --AND sob.set_of_books_id = ood.set_of_books_id;
4867: END IF;

Line 4871: inv_rcv_common_apis.validate_trx_date(

4867: END IF;
4868:
4869: l_progress := '10';
4870: -- first check if the transaction date satisfies the validation.
4871: inv_rcv_common_apis.validate_trx_date(
4872: p_trx_date => SYSDATE
4873: , p_organization_id => p_organization_id
4874: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4875: , x_return_status => x_status

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

4870: -- first check if the transaction date satisfies the validation.
4871: inv_rcv_common_apis.validate_trx_date(
4872: p_trx_date => SYSDATE
4873: , p_organization_id => p_organization_id
4874: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
4875: , x_return_status => x_status
4876: , x_error_code => x_message
4877: );
4878:

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

4965: l_progress := '40';
4966:
4967: IF (l_debug = 1) THEN
4968: print_debug(
4969: 'create_osp_direct_rti_rec: 8.1 before inv_label.print_label ' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id, 4);
4970: END IF;
4971:
4972: /* FP-J Lot/Serial Support Enhancement
4973: * If INV J and PO J are installed, do not call label printing API at this stage

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

4971:
4972: /* FP-J Lot/Serial Support Enhancement
4973: * If INV J and PO J are installed, do not call label printing API at this stage
4974: */
4975: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
4976: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
4977:
4978: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952 ..For PO receipt, code in rcv_insert_update_header(INVSTDRB.pls) will be called.
4979: l_counter := 1;

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

4972: /* FP-J Lot/Serial Support Enhancement
4973: * If INV J and PO J are installed, do not call label printing API at this stage
4974: */
4975: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
4976: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
4977:
4978: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952 ..For PO receipt, code in rcv_insert_update_header(INVSTDRB.pls) will be called.
4979: l_counter := 1;
4980: OPEN c_rti_txn_id;

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

5116: /* Group BY LPN_ID is changed for Express Receipts */
5117: /* Also duplicate print of LPN labels is avoided */
5118: SELECT MAX(rti.interface_transaction_id)
5119: FROM rcv_transactions_interface rti
5120: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5121: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5122:
5123: -- GROUP BY rti.lpn_id;
5124: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

5133: IF (l_debug = 1) THEN
5134: print_debug('txn temp id: ' || p_transaction_temp_id, 4);
5135: END IF;
5136:
5137: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
5138:
5139: --BUG 3440184: For performance reason, use the follow query
5140: --instead of gl_sets_of_books
5141:

Line 5143: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5139: --BUG 3440184: For performance reason, use the follow query
5140: --instead of gl_sets_of_books
5141:
5142: SELECT TO_NUMBER(hoi.org_information1)
5143: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5144: FROM hr_organization_information hoi
5145: WHERE hoi.organization_id = p_organization_id
5146: AND (hoi.org_information_context || '') = 'Accounting Information';
5147:

Line 5149: -- INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5145: WHERE hoi.organization_id = p_organization_id
5146: AND (hoi.org_information_context || '') = 'Accounting Information';
5147:
5148: -- SELECT ood.set_of_books_id
5149: -- INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5150: -- FROM org_organization_definitions ood, gl_sets_of_books sob
5151: -- WHERE organization_id = p_organization_id
5152: -- AND sob.set_of_books_id = ood.set_of_books_id;
5153:

Line 5158: inv_rcv_common_apis.validate_trx_date(

5154: END IF;
5155:
5156: l_progress := '10';
5157: -- first check if the transaction date satisfies the validation.
5158: inv_rcv_common_apis.validate_trx_date(
5159: p_trx_date => SYSDATE
5160: , p_organization_id => p_organization_id
5161: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5162: , x_return_status => x_status

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

5157: -- first check if the transaction date satisfies the validation.
5158: inv_rcv_common_apis.validate_trx_date(
5159: p_trx_date => SYSDATE
5160: , p_organization_id => p_organization_id
5161: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5162: , x_return_status => x_status
5163: , x_error_code => x_message
5164: );
5165:

Line 5709: 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);

5705: IF l_return_status <> fnd_api.g_ret_sts_error THEN
5706: l_progress := '80';
5707:
5708: IF (l_debug = 1) THEN
5709: 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);
5710: END IF;
5711:
5712: /* FP-J Lot/Serial Support Enhancement
5713: * If INV J and PO J are installed, do not call label printing API at this stage

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

5711:
5712: /* FP-J Lot/Serial Support Enhancement
5713: * If INV J and PO J are installed, do not call label printing API at this stage
5714: */
5715: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
5716: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
5717:
5718: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952.. For PO receipt code in rcv_insert_update_header(INVSTDRB.pls) will be called.
5719:

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

5712: /* FP-J Lot/Serial Support Enhancement
5713: * If INV J and PO J are installed, do not call label printing API at this stage
5714: */
5715: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
5716: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
5717:
5718: IF (p_source_type <> 'VENDOR') THEN --Bug #4079952.. For PO receipt code in rcv_insert_update_header(INVSTDRB.pls) will be called.
5719:
5720: l_counter := 1;

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

5796: print_debug('Enter pack_lpn_txn: 1'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') , 1);
5797: END IF;
5798:
5799: l_return_status := inv_lpn_trx_pub.process_lpn_trx
5800: (p_trx_hdr_id => inv_rcv_common_apis.g_rcv_global_var.transaction_header_id,
5801: p_mode => 2, -- putaway mode
5802: p_commit => 'F',
5803: x_proc_msg => l_proc_msg);
5804: