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

APPS.INV_RCV_STD_RCPT_APIS dependencies on INV_RCV_COMMON_APIS

Line 428: AND category_set_id = inv_rcv_common_apis.g_po_startup_value.category_set_id;

424: INTO l_rcv_transaction_rec.item_category_id
425: FROM mtl_item_categories
426: WHERE inventory_item_id = l_rcv_transaction_rec.item_id
427: AND organization_id = p_organization_id
428: AND category_set_id = inv_rcv_common_apis.g_po_startup_value.category_set_id;
429: EXCEPTION
430: WHEN OTHERS THEN
431: IF (l_debug = 1) THEN
432: print_debug('insert_txn_interface: Exception in getting the item categories', 4);

Line 518: IF inv_rcv_common_apis.g_po_startup_value.blind_receiving_flag = 'Y' THEN

514: ELSE
515: l_rcv_transaction_rec.routing_id := p_qa_routing_id;
516: END IF;
517:
518: IF inv_rcv_common_apis.g_po_startup_value.blind_receiving_flag = 'Y' THEN
519: x_available_qty := 0;
520: l_rcv_transaction_rec.ordered_qty := 0;
521: END IF;
522:

Line 560: IF (l_rcv_transaction_rec.currency_code <> inv_rcv_common_apis.g_po_startup_value.currency_code) THEN

556:
557: IF l_rcv_transaction_rec.match_option <> 'P' THEN
558: l_rcv_transaction_rec.currency_conversion_date := l_sysdate;
559:
560: IF (l_rcv_transaction_rec.currency_code <> inv_rcv_common_apis.g_po_startup_value.currency_code) THEN
561: l_rate := l_rcv_transaction_rec.currency_conversion_rate;
562:
563: IF (l_rcv_transaction_rec.currency_conversion_type <> 'User') THEN
564: BEGIN

Line 567: inv_rcv_common_apis.g_po_startup_value.sob_id

563: IF (l_rcv_transaction_rec.currency_conversion_type <> 'User') THEN
564: BEGIN
565: l_rate :=
566: gl_currency_api.get_rate(
567: inv_rcv_common_apis.g_po_startup_value.sob_id
568: , l_rcv_transaction_rec.currency_code
569: , l_rcv_transaction_rec.currency_conversion_date
570: , l_rcv_transaction_rec.currency_conversion_type
571: );

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

831: * -> Populate values for three new columns lpn_group_id, validation_flag
832: * and header_interface_id_id
833: * -> Populate project_id and task_id in RTI from inputs
834: */
835: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
836: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
837: IF ((l_rcv_transaction_rec.source_type_code = 'INTERNAL') OR
838: -- For Bug 7440217
839: (l_rcv_transaction_rec.source_type_code IN ('ASN', 'LCM') AND p_source_type <> 'VENDOR')) THEN

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

832: * and header_interface_id_id
833: * -> Populate project_id and task_id in RTI from inputs
834: */
835: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
836: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
837: IF ((l_rcv_transaction_rec.source_type_code = 'INTERNAL') OR
838: -- For Bug 7440217
839: (l_rcv_transaction_rec.source_type_code IN ('ASN', 'LCM') AND p_source_type <> 'VENDOR')) THEN
840: -- End for Bug 7440217

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

872: l_task_id := NULL;
873: END IF;
874:
875: -- bug 3452845
876: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
877: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
878: l_txn_date := Sysdate;
879: ELSE
880: l_txn_date := Trunc(Sysdate);

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

873: END IF;
874:
875: -- bug 3452845
876: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
877: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
878: l_txn_date := Sysdate;
879: ELSE
880: l_txn_date := Trunc(Sysdate);
881: END IF;

Line 897: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id(

893: print_debug('b4 insertingl_secondary_uom_code ' || l_secondary_uom_code,4);
894: print_debug('b4 insertingl_secondary_unit_of_measure ' || l_secondary_unit_of_measure,4);
895:
896: --
897: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id(
898: l_rcv_transaction_rec.receipt_source_code,
899: l_rcv_transaction_rec.po_header_id,
900: l_rcv_transaction_rec.req_line_id,
901: l_rcv_transaction_rec.oe_order_header_id );

Line 1107: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */

1103: VALUES (
1104: l_interface_transaction_id
1105: , p_group_id
1106: , l_sysdate
1107: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */
1108: , l_sysdate /* Created Date */
1109: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */
1110: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1111: , p_transaction_type /* transaction type */

Line 1109: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */

1105: , p_group_id
1106: , l_sysdate
1107: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */
1108: , l_sysdate /* Created Date */
1109: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */
1110: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1111: , p_transaction_type /* transaction type */
1112: , l_txn_date /* transaction date */
1113: , 'PENDING' /* Processing status code */

Line 1110: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */

1106: , l_sysdate
1107: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */
1108: , l_sysdate /* Created Date */
1109: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */
1110: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1111: , p_transaction_type /* transaction type */
1112: , l_txn_date /* transaction date */
1113: , 'PENDING' /* Processing status code */
1114: , inv_rcv_common_apis.g_po_startup_value.transaction_mode

Line 1114: , inv_rcv_common_apis.g_po_startup_value.transaction_mode

1110: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1111: , p_transaction_type /* transaction type */
1112: , l_txn_date /* transaction date */
1113: , 'PENDING' /* Processing status code */
1114: , inv_rcv_common_apis.g_po_startup_value.transaction_mode
1115: , NULL
1116: , 'PENDING' /* Transaction status code */
1117: , l_rcv_transaction_rec.item_category_id
1118: , l_rcv_transaction_rec.transaction_qty

Line 1127: , inv_rcv_common_apis.g_po_startup_value.employee_id -- Fix for bug 2073164

1123: , l_rcv_transaction_rec.item_id
1124: , l_rcv_transaction_rec.item_description
1125: , l_rcv_transaction_rec.item_revision
1126: , l_rcv_transaction_rec.uom_code
1127: , inv_rcv_common_apis.g_po_startup_value.employee_id -- Fix for bug 2073164
1128: , l_auto_transact_code /* Auto transact code */
1129: , l_shipment_header_id /* shipment header id */
1130: , l_shipment_line_id /* shipment line id */
1131: , l_rcv_transaction_rec.ship_to_location_id

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

1587: , p_attribute13 IN VARCHAR2 DEFAULT NULL
1588: , p_attribute14 IN VARCHAR2 DEFAULT NULL
1589: , p_attribute15 IN VARCHAR2 DEFAULT NULL
1590: ) IS
1591: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
1592: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
1593: l_interface_transaction_id NUMBER := NULL;
1594: -- this is used to keep track of the id used to insert the row in rti
1595:

Line 1810: inv_rcv_common_apis.init_startup_values(p_organization_id);

1806: -- query po_startup_value
1807: l_progress := '20';
1808:
1809: BEGIN
1810: inv_rcv_common_apis.init_startup_values(p_organization_id);
1811: EXCEPTION
1812: WHEN NO_DATA_FOUND THEN
1813: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1814: fnd_msg_pub.ADD;

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

1819:
1820: -- default header level non-DB items in rcv_transaction block
1821: -- and default other values need to be insert into RTI
1822: -- default l_group_id ? clear group id after done
1823: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1824: l_progress := '40';
1825:
1826: SELECT rcv_interface_groups_s.NEXTVAL
1827: INTO l_group_id

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

1838: , 4
1839: );
1840: END IF;
1841:
1842: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1843: ELSE
1844: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1845:
1846: IF (l_debug = 1) THEN

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

1840: END IF;
1841:
1842: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1843: ELSE
1844: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1845:
1846: IF (l_debug = 1) THEN
1847: print_debug(
1848: 'Enter create_po_rcpt_intf_rec: 30 - l_group_id exists - l_group_id = '

Line 2418: inv_rcv_common_apis.do_check(

2414: g_rcpt_lot_qty_rec_tb.DELETE;
2415: l_progress := '90';
2416:
2417: IF p_item_id IS NOT NULL THEN
2418: inv_rcv_common_apis.do_check(
2419: p_organization_id => p_organization_id
2420: , p_inventory_item_id => p_item_id
2421: , p_transaction_type_id => 18
2422: , p_primary_quantity => l_total_primary_qty

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

2534: , p_attribute13 IN VARCHAR2 DEFAULT NULL
2535: , p_attribute14 IN VARCHAR2 DEFAULT NULL
2536: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2537: ) IS
2538: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2539: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
2540: l_interface_transaction_id NUMBER := NULL;
2541: -- this is used to keep track of the id used to insert the row in rti
2542:

Line 2770: --We should set inv_rcv_common_apis.g_rcv_global_var.receipt_num to

2766: WHERE shipment_header_id = p_shipment_header_id
2767: AND ship_to_org_id = p_organization_id;
2768:
2769: --Bug 4252372
2770: --We should set inv_rcv_common_apis.g_rcv_global_var.receipt_num to
2771: --l_receipt_num only if l_receipt_num is not null. It it is null and
2772: --we set the value then we will end up generating extra receipt numbers.
2773: IF (l_receipt_num IS NOT NULL) THEN
2774: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

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

2770: --We should set inv_rcv_common_apis.g_rcv_global_var.receipt_num to
2771: --l_receipt_num only if l_receipt_num is not null. It it is null and
2772: --we set the value then we will end up generating extra receipt numbers.
2773: IF (l_receipt_num IS NOT NULL) THEN
2774: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
2775: END IF;
2776:
2777: IF (l_debug = 1) THEN
2778: print_debug('create_intship_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

Line 2778: print_debug('create_intship_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

2774: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
2775: END IF;
2776:
2777: IF (l_debug = 1) THEN
2778: print_debug('create_intship_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
2779: END IF;
2780: EXCEPTION
2781: WHEN NO_DATA_FOUND THEN
2782: l_receipt_num := NULL;

Line 2785: inv_rcv_common_apis.init_startup_values(p_organization_id);

2781: WHEN NO_DATA_FOUND THEN
2782: l_receipt_num := NULL;
2783: END;
2784:
2785: inv_rcv_common_apis.init_startup_values(p_organization_id);
2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2789: fnd_msg_pub.ADD;

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

2799:
2800: l_progress := '20';
2801:
2802: -- default l_group_id ? clear group id after done
2803: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2804: SELECT rcv_interface_groups_s.NEXTVAL
2805: INTO l_group_id
2806: FROM DUAL;
2807:

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

2804: SELECT rcv_interface_groups_s.NEXTVAL
2805: INTO l_group_id
2806: FROM DUAL;
2807:
2808: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2809: ELSE
2810: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2811: END IF;
2812:

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

2806: FROM DUAL;
2807:
2808: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2809: ELSE
2810: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2811: END IF;
2812:
2813: l_progress := '30';
2814: /* We'll get shipment_header_id for req at front end

Line 3222: inv_rcv_common_apis.do_check(

3218:
3219: -- clear the lot/qty data structure
3220: g_rcpt_lot_qty_rec_tb.DELETE;
3221: l_progress := '120';
3222: inv_rcv_common_apis.do_check(
3223: p_organization_id => p_organization_id
3224: , p_inventory_item_id => p_item_id
3225: , p_transaction_type_id => 61
3226: , p_primary_quantity => l_total_primary_qty

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

3336: , p_attribute13 IN VARCHAR2 DEFAULT NULL
3337: , p_attribute14 IN VARCHAR2 DEFAULT NULL
3338: , p_attribute15 IN VARCHAR2 DEFAULT NULL
3339: ) IS
3340: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
3341: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
3342: l_interface_transaction_id NUMBER := NULL;
3343: -- this is used to keep track of the id used to insert the row in rti
3344:

Line 3530: inv_rcv_common_apis.init_startup_values(p_organization_id);

3526: l_progress := '10';
3527:
3528: -- query po_startup_value
3529: BEGIN
3530: inv_rcv_common_apis.init_startup_values(p_organization_id);
3531: EXCEPTION
3532: WHEN NO_DATA_FOUND THEN
3533: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3534: fnd_msg_pub.ADD;

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

3544:
3545: l_progress := '20';
3546:
3547: -- default l_group_id ? clear group id after done
3548: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3549: SELECT rcv_interface_groups_s.NEXTVAL
3550: INTO l_group_id
3551: FROM DUAL;
3552:

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

3549: SELECT rcv_interface_groups_s.NEXTVAL
3550: INTO l_group_id
3551: FROM DUAL;
3552:
3553: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3554: ELSE
3555: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3556: END IF;
3557:

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

3551: FROM DUAL;
3552:
3553: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3554: ELSE
3555: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3556: END IF;
3557:
3558: l_progress := '30';
3559: -- call matching algorithm ?

Line 3817: inv_rcv_common_apis.do_check(

3813:
3814: -- clear the lot/qty data structure
3815: g_rcpt_lot_qty_rec_tb.DELETE;
3816: l_progress := '120';
3817: inv_rcv_common_apis.do_check(
3818: p_organization_id => p_organization_id
3819: , p_inventory_item_id => p_item_id
3820: , p_transaction_type_id => 15
3821: , p_primary_quantity => l_total_primary_qty

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

3933: , p_attribute14 IN VARCHAR2 DEFAULT NULL
3934: , p_attribute15 IN VARCHAR2 DEFAULT NULL
3935: , p_express_transaction IN VARCHAR2 DEFAULT NULL
3936: ) IS
3937: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
3938: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
3939: l_interface_transaction_id NUMBER := NULL;
3940: -- this is used to keep track of the id used to insert the row in rti
3941:

Line 4342: /* Bug# 6339752 the global variable inv_rcv_common_apis.g_rcv_global_var.receipt_num is to be set only if

4338: FROM rcv_shipment_headers
4339: WHERE shipment_header_id = p_shipment_header_id
4340: AND ship_to_org_id = p_organization_id;
4341:
4342: /* Bug# 6339752 the global variable inv_rcv_common_apis.g_rcv_global_var.receipt_num is to be set only if
4343: * there is non-null value from RSH.
4344: */
4345:
4346: IF (l_receipt_num IS NOT NULL) THEN

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

4343: * there is non-null value from RSH.
4344: */
4345:
4346: IF (l_receipt_num IS NOT NULL) THEN
4347: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
4348: END IF;
4349:
4350: IF (l_debug = 1) THEN
4351: print_debug('create_asn_con_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

Line 4351: print_debug('create_asn_con_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

4347: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
4348: END IF;
4349:
4350: IF (l_debug = 1) THEN
4351: print_debug('create_asn_con_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
4352: END IF;
4353: EXCEPTION
4354: WHEN NO_DATA_FOUND THEN
4355: l_receipt_num := NULL;

Line 4358: inv_rcv_common_apis.init_startup_values(p_organization_id);

4354: WHEN NO_DATA_FOUND THEN
4355: l_receipt_num := NULL;
4356: END;
4357:
4358: inv_rcv_common_apis.init_startup_values(p_organization_id);
4359: EXCEPTION
4360: WHEN NO_DATA_FOUND THEN
4361: fnd_message.set_name('INV', 'INV_RCV_PARAM');
4362: fnd_msg_pub.ADD;

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

4372:
4373: l_progress := '20';
4374:
4375: -- default l_group_id ? clear group id after done
4376: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
4377: SELECT rcv_interface_groups_s.NEXTVAL
4378: INTO l_group_id
4379: FROM DUAL;
4380:

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

4377: SELECT rcv_interface_groups_s.NEXTVAL
4378: INTO l_group_id
4379: FROM DUAL;
4380:
4381: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
4382: ELSE
4383: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4384: END IF;
4385:

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

4379: FROM DUAL;
4380:
4381: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
4382: ELSE
4383: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4384: END IF;
4385:
4386: l_progress := '30';
4387: -- call matching algorithm ?

Line 4969: inv_rcv_common_apis.do_check(

4965:
4966: l_progress := '120';
4967:
4968: IF p_item_id IS NOT NULL THEN
4969: inv_rcv_common_apis.do_check(
4970: p_organization_id => p_organization_id
4971: , p_inventory_item_id => p_item_id
4972: , p_transaction_type_id => 18
4973: , p_primary_quantity => l_total_primary_qty

Line 5253: inv_rcv_common_apis.insert_dynamic_lot(

5249: WHEN OTHERS THEN
5250: l_expiration_date := NULL;
5251: END;
5252:
5253: inv_rcv_common_apis.insert_dynamic_lot(
5254: p_api_version => 1.0
5255: , --p_init_msg_list => p_init_msg_list,
5256: --p_commit => p_commit,
5257: --p_validation_level => p_validation_level,

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

5695: ,x_msg_data => l_msg_data
5696: ,p_organization_id => l_from_org_id --BUG 4096028: Should use from org_id
5697: ,p_lpn_id => p_lpn_id
5698: ,p_license_plate_number => NULL
5699: ,p_lpn_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5700: ,p_parent_lpn_id => NULL
5701: );
5702:
5703: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

5867: /* Also duplicate print of LPN labels is avoided */
5868: CURSOR c_rti_txn_id IS
5869: SELECT MAX(rti.interface_transaction_id)
5870: FROM rcv_transactions_interface rti
5871: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5872: GROUP BY DECODE(p_source_type,
5873: 'ASNEXP', rti.interface_transaction_id
5874: , 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5875:

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

5886: print_debug(p_secondary_uom_code,1);
5887: print_debug(p_secondary_quantity,1);
5888: END IF;
5889:
5890: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
5891: --BUG 3444210: For performance reason, use the follow query
5892: --instead of gl_sets_of_books
5893: SELECT TO_NUMBER(hoi.org_information1)
5894: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

Line 5894: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5890: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
5891: --BUG 3444210: For performance reason, use the follow query
5892: --instead of gl_sets_of_books
5893: SELECT TO_NUMBER(hoi.org_information1)
5894: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5895: FROM hr_organization_information hoi
5896: WHERE hoi.organization_id = p_organization_id
5897: AND (hoi.org_information_context || '') = 'Accounting Information';
5898: END IF;

Line 5902: inv_rcv_common_apis.validate_trx_date(

5898: END IF;
5899:
5900: l_progress := '15';
5901: -- first check if the transaction date satisfies the validation.
5902: inv_rcv_common_apis.validate_trx_date(
5903: p_trx_date => SYSDATE
5904: , p_organization_id => p_organization_id
5905: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5906: , x_return_status => x_status

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

5901: -- first check if the transaction date satisfies the validation.
5902: inv_rcv_common_apis.validate_trx_date(
5903: p_trx_date => SYSDATE
5904: , p_organization_id => p_organization_id
5905: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5906: , x_return_status => x_status
5907: , x_error_code => x_message
5908: );
5909:

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

6409:
6410: /* FP-J Lot/Serial Support Enhancement
6411: * If INV J and PO J are installed, do not call label printing API at this stage
6412: */
6413: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
6414: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
6415: IF (p_source_type <> 'VENDOR') THEN --bug 3630412 for normal PO receipt moved the code to rcv_insert_update_header
6416: l_counter := 1;
6417: OPEN c_rti_txn_id;

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

6410: /* FP-J Lot/Serial Support Enhancement
6411: * If INV J and PO J are installed, do not call label printing API at this stage
6412: */
6413: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
6414: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
6415: IF (p_source_type <> 'VENDOR') THEN --bug 3630412 for normal PO receipt moved the code to rcv_insert_update_header
6416: l_counter := 1;
6417: OPEN c_rti_txn_id;
6418:

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

6918:
6919: l_progress := '30';
6920: --If INV and PO J are installed,
6921: -- execute the old split logic else just update the local table
6922: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6923: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6924: IF (l_debug = 1) THEN
6925: print_debug('Calling to insert RHI for J code', 4);
6926: END IF;

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

6919: l_progress := '30';
6920: --If INV and PO J are installed,
6921: -- execute the old split logic else just update the local table
6922: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6923: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6924: IF (l_debug = 1) THEN
6925: print_debug('Calling to insert RHI for J code', 4);
6926: END IF;
6927: l_lot_qty_rec_tb(1).lot_number := p_lot_number;

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

7264:
7265: BEGIN
7266: --If INV and PO J are installed,
7267: -- then query using the group_id as RTI is not stamped with shipment_header_id
7268: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
7269: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
7270: IF (l_debug = 1) THEN
7271: print_debug('Calling to insert RHI for J code', 4);
7272: END IF;

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

7265: BEGIN
7266: --If INV and PO J are installed,
7267: -- then query using the group_id as RTI is not stamped with shipment_header_id
7268: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
7269: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
7270: IF (l_debug = 1) THEN
7271: print_debug('Calling to insert RHI for J code', 4);
7272: END IF;
7273:

Line 7277: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

7273:
7274: SELECT transaction_status_code
7275: INTO l_process_status
7276: FROM rcv_transactions_interface
7277: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
7278: AND ROWNUM = 1;
7279: ELSE
7280: SELECT transaction_status_code
7281: INTO l_process_status

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

7303: END IF;
7304:
7305: --If INV and PO J are installed,
7306: -- then query using the group_id as RTI is not stamped with shipment_header_id
7307: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
7308: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
7309: IF (l_debug = 1) THEN
7310: print_debug('Calling to insert RHI for J code', 4);
7311: END IF;

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

7304:
7305: --If INV and PO J are installed,
7306: -- then query using the group_id as RTI is not stamped with shipment_header_id
7307: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
7308: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
7309: IF (l_debug = 1) THEN
7310: print_debug('Calling to insert RHI for J code', 4);
7311: END IF;
7312: UPDATE rcv_transactions_interface

Line 7319: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

7315: , bill_of_lading = p_bill_of_lading
7316: , packing_slip = p_packing_slip
7317: , num_of_containers = p_num_of_containers
7318: , waybill_airbill_num = p_waybill_airbill_num
7319: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
7320: ELSE
7321: UPDATE rcv_transactions_interface
7322: SET shipment_num = p_shipment_num
7323: , freight_carrier_code = p_freight_carrier_code

Line 7416: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;

7412: x_return_status := fnd_api.g_ret_sts_success;
7413: SAVEPOINT rcv_insert_ship_header_sp;
7414: l_header.last_update_date := l_sysdate;
7415: l_header.creation_date := l_sysdate;
7416: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;
7417: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7418: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7419: -- Bug 3443989 for Internal Requition we have to enter receipt_source_code as INTERNAL ORDER
7420: -- According to PO

Line 7417: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;

7413: SAVEPOINT rcv_insert_ship_header_sp;
7414: l_header.last_update_date := l_sysdate;
7415: l_header.creation_date := l_sysdate;
7416: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;
7417: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7418: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7419: -- Bug 3443989 for Internal Requition we have to enter receipt_source_code as INTERNAL ORDER
7420: -- According to PO
7421:

Line 7418: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;

7414: l_header.last_update_date := l_sysdate;
7415: l_header.creation_date := l_sysdate;
7416: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;
7417: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7418: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7419: -- Bug 3443989 for Internal Requition we have to enter receipt_source_code as INTERNAL ORDER
7420: -- According to PO
7421:
7422: IF p_source_type = 'CUSTOMER' THEN

Line 7431: l_header.receipt_num := inv_rcv_common_apis.g_rcv_global_var.receipt_num;

7427: l_header.receipt_source_code := 'INTERNAL ORDER';
7428: END IF;
7429:
7430: l_progress := '13';
7431: l_header.receipt_num := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
7432: IF l_header.receipt_num IS NULL THEN
7433: RAISE fnd_api.g_exc_error;
7434: END IF;
7435:

Line 7475: l_header.employee_id := inv_rcv_common_apis.g_po_startup_value.employee_id;

7471: l_header.expected_receipt_date := Nvl(p_expected_receipt_date,l_sysdate);
7472: END;
7473: -- End Bug 16495716
7474:
7475: l_header.employee_id := inv_rcv_common_apis.g_po_startup_value.employee_id;
7476: l_header.num_of_containers := p_num_of_containers;
7477: l_header.waybill_airbill_num := p_waybill_airbill_num;
7478: l_header.comments := p_comments;
7479: l_header.usggl_transaction_code := p_ussgl_transaction_code;

Line 7570: , inv_rcv_common_apis.g_rcv_global_var.interface_group_id

7566: , customer_site_id
7567: )
7568: VALUES (
7569: g_header_intf_id
7570: , inv_rcv_common_apis.g_rcv_global_var.interface_group_id
7571: , 'PENDING' -- processing_status_code
7572: , 'NEW' -- transaction_type
7573: , 'Y' -- validation_flag
7574: , 'RECEIVE' -- auto_transact_code

Line 7740: , last_update_login = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_update_login)

7736: l_progress := '40';
7737: UPDATE rcv_headers_interface
7738: SET customer_id = Nvl(p_customer_id, customer_id)
7739: , last_update_date = l_sysdate
7740: , last_update_login = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_update_login)
7741: , last_updated_by = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_updated_by)
7742: , vendor_id = NVL(p_vendor_id, vendor_id)
7743: , vendor_site_id = NVL(l_vendor_site_id, vendor_site_id)--bug9409867
7744: , ship_to_organization_id = NVL(p_organization_id, ship_to_organization_id)

Line 7741: , last_updated_by = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_updated_by)

7737: UPDATE rcv_headers_interface
7738: SET customer_id = Nvl(p_customer_id, customer_id)
7739: , last_update_date = l_sysdate
7740: , last_update_login = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_update_login)
7741: , last_updated_by = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_updated_by)
7742: , vendor_id = NVL(p_vendor_id, vendor_id)
7743: , vendor_site_id = NVL(l_vendor_site_id, vendor_site_id)--bug9409867
7744: , ship_to_organization_id = NVL(p_organization_id, ship_to_organization_id)
7745: , receipt_num = NVL(p_receipt_num, receipt_num)

Line 7752: , employee_id = NVL(inv_rcv_common_apis.g_po_startup_value.employee_id, employee_id)

7748: , packing_slip = p_packing_slip
7749: , shipped_date = NVL(p_shipped_date, shipped_date)
7750: , freight_carrier_code = p_freight_carrier_code
7751: , expected_receipt_date = NVL(p_expected_receipt_date, expected_receipt_date)
7752: , employee_id = NVL(inv_rcv_common_apis.g_po_startup_value.employee_id, employee_id)
7753: , num_of_containers = NVL(p_num_of_containers, num_of_containers)
7754: , comments = p_comments
7755: , attribute_category = p_attribute_category
7756: , attribute1 = p_attribute1

Line 7847: print_debug('group_id:'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,4);

7843: IF l_check_asn ='ASN' THEN
7844:
7845: IF (l_debug = 1) THEN
7846: print_debug('In type ASN before call to new procedure', 4);
7847: print_debug('group_id:'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,4);
7848: END IF;
7849:
7850: --Calling the procedure
7851: INV_CR_ASN_DETAILS.update_asn_item_details

Line 7852: (p_group_id=>inv_rcv_common_apis.g_rcv_global_var.interface_group_id);

7848: END IF;
7849:
7850: --Calling the procedure
7851: INV_CR_ASN_DETAILS.update_asn_item_details
7852: (p_group_id=>inv_rcv_common_apis.g_rcv_global_var.interface_group_id);
7853:
7854: IF (l_debug = 1) THEN
7855: print_debug('In type ASN after call to new procedure.', 4);
7856: print_debug('# of WAD updated:'||SQL%rowcount,4);

Line 8318: , p_source_header_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id

8314: , p_enforce_wv_constraints => p_enforce_wv_constraints
8315: , p_operation => p_operation
8316: , p_cost_group_id => p_cost_group_id
8317: , p_source_type_id => p_source_type_id
8318: , p_source_header_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
8319: , p_source_name => p_source_name
8320: , p_source_line_id => p_source_line_id
8321: , p_source_line_detail_id => p_source_line_detail_id
8322: , p_homogeneous_container => p_homogeneous_container

Line 9211: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

9207: EXIT WHEN c_delivery_details%NOTFOUND;
9208: l_progress := 35;
9209: IF l_lpn_id IS NOT NULL THEN
9210: -- Nested LPN changes. Check whether the given LPN has content.
9211: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
9212: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
9213: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
9214: SELECT organization_id
9215: , lpn_context

Line 9212: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

9208: l_progress := 35;
9209: IF l_lpn_id IS NOT NULL THEN
9210: -- Nested LPN changes. Check whether the given LPN has content.
9211: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
9212: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
9213: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
9214: SELECT organization_id
9215: , lpn_context
9216: INTO l_lpn_org

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

9209: IF l_lpn_id IS NOT NULL THEN
9210: -- Nested LPN changes. Check whether the given LPN has content.
9211: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
9212: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
9213: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
9214: SELECT organization_id
9215: , lpn_context
9216: INTO l_lpn_org
9217: , l_lpn_context