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 426: AND category_set_id = inv_rcv_common_apis.g_po_startup_value.category_set_id;

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

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

480: ELSE
481: l_rcv_transaction_rec.routing_id := p_qa_routing_id;
482: END IF;
483:
484: IF inv_rcv_common_apis.g_po_startup_value.blind_receiving_flag = 'Y' THEN
485: x_available_qty := 0;
486: l_rcv_transaction_rec.ordered_qty := 0;
487: END IF;
488:

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

522:
523: IF l_rcv_transaction_rec.match_option <> 'P' THEN
524: l_rcv_transaction_rec.currency_conversion_date := l_sysdate;
525:
526: IF (l_rcv_transaction_rec.currency_code <> inv_rcv_common_apis.g_po_startup_value.currency_code) THEN
527: l_rate := l_rcv_transaction_rec.currency_conversion_rate;
528:
529: IF (l_rcv_transaction_rec.currency_conversion_type <> 'User') THEN
530: BEGIN

Line 533: inv_rcv_common_apis.g_po_startup_value.sob_id

529: IF (l_rcv_transaction_rec.currency_conversion_type <> 'User') THEN
530: BEGIN
531: l_rate :=
532: gl_currency_api.get_rate(
533: inv_rcv_common_apis.g_po_startup_value.sob_id
534: , l_rcv_transaction_rec.currency_code
535: , l_rcv_transaction_rec.currency_conversion_date
536: , l_rcv_transaction_rec.currency_conversion_type
537: );

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

797: * -> Populate values for three new columns lpn_group_id, validation_flag
798: * and header_interface_id_id
799: * -> Populate project_id and task_id in RTI from inputs
800: */
801: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
802: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
803: IF ((l_rcv_transaction_rec.source_type_code = 'INTERNAL') OR
804: -- For Bug 7440217
805: (l_rcv_transaction_rec.source_type_code IN ('ASN', 'LCM') AND p_source_type <> 'VENDOR')) THEN

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

798: * and header_interface_id_id
799: * -> Populate project_id and task_id in RTI from inputs
800: */
801: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
802: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
803: IF ((l_rcv_transaction_rec.source_type_code = 'INTERNAL') OR
804: -- For Bug 7440217
805: (l_rcv_transaction_rec.source_type_code IN ('ASN', 'LCM') AND p_source_type <> 'VENDOR')) THEN
806: -- End for Bug 7440217

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

838: l_task_id := NULL;
839: END IF;
840:
841: -- bug 3452845
842: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
843: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
844: l_txn_date := Sysdate;
845: ELSE
846: l_txn_date := Trunc(Sysdate);

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

839: END IF;
840:
841: -- bug 3452845
842: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
843: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
844: l_txn_date := Sysdate;
845: ELSE
846: l_txn_date := Trunc(Sysdate);
847: END IF;

Line 863: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id(

859: print_debug('b4 insertingl_secondary_uom_code ' || l_secondary_uom_code,4);
860: print_debug('b4 insertingl_secondary_unit_of_measure ' || l_secondary_unit_of_measure,4);
861:
862: --
863: l_operating_unit_id := inv_rcv_common_apis.get_operating_unit_id(
864: l_rcv_transaction_rec.receipt_source_code,
865: l_rcv_transaction_rec.po_header_id,
866: l_rcv_transaction_rec.req_line_id,
867: l_rcv_transaction_rec.oe_order_header_id );

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

1069: VALUES (
1070: l_interface_transaction_id
1071: , p_group_id
1072: , l_sysdate
1073: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */
1074: , l_sysdate /* Created Date */
1075: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */
1076: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1077: , p_transaction_type /* transaction type */

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

1071: , p_group_id
1072: , l_sysdate
1073: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */
1074: , l_sysdate /* Created Date */
1075: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */
1076: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1077: , p_transaction_type /* transaction type */
1078: , l_txn_date /* transaction date */
1079: , 'PENDING' /* Processing status code */

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

1072: , l_sysdate
1073: , inv_rcv_common_apis.g_po_startup_value.user_id /* Last Updated By */
1074: , l_sysdate /* Created Date */
1075: , inv_rcv_common_apis.g_po_startup_value.user_id /* Created By */
1076: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1077: , p_transaction_type /* transaction type */
1078: , l_txn_date /* transaction date */
1079: , 'PENDING' /* Processing status code */
1080: , inv_rcv_common_apis.g_po_startup_value.transaction_mode

Line 1080: , inv_rcv_common_apis.g_po_startup_value.transaction_mode

1076: , inv_rcv_common_apis.g_po_startup_value.user_id /* last Update Login */
1077: , p_transaction_type /* transaction type */
1078: , l_txn_date /* transaction date */
1079: , 'PENDING' /* Processing status code */
1080: , inv_rcv_common_apis.g_po_startup_value.transaction_mode
1081: , NULL
1082: , 'PENDING' /* Transaction status code */
1083: , l_rcv_transaction_rec.item_category_id
1084: , l_rcv_transaction_rec.transaction_qty

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

1089: , l_rcv_transaction_rec.item_id
1090: , l_rcv_transaction_rec.item_description
1091: , l_rcv_transaction_rec.item_revision
1092: , l_rcv_transaction_rec.uom_code
1093: , inv_rcv_common_apis.g_po_startup_value.employee_id -- Fix for bug 2073164
1094: , l_auto_transact_code /* Auto transact code */
1095: , l_shipment_header_id /* shipment header id */
1096: , l_shipment_line_id /* shipment line id */
1097: , l_rcv_transaction_rec.ship_to_location_id

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

1538: , p_attribute13 IN VARCHAR2 DEFAULT NULL
1539: , p_attribute14 IN VARCHAR2 DEFAULT NULL
1540: , p_attribute15 IN VARCHAR2 DEFAULT NULL
1541: ) IS
1542: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
1543: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
1544: l_interface_transaction_id NUMBER := NULL;
1545: -- this is used to keep track of the id used to insert the row in rti
1546:

Line 1761: inv_rcv_common_apis.init_startup_values(p_organization_id);

1757: -- query po_startup_value
1758: l_progress := '20';
1759:
1760: BEGIN
1761: inv_rcv_common_apis.init_startup_values(p_organization_id);
1762: EXCEPTION
1763: WHEN NO_DATA_FOUND THEN
1764: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1765: fnd_msg_pub.ADD;

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

1770:
1771: -- default header level non-DB items in rcv_transaction block
1772: -- and default other values need to be insert into RTI
1773: -- default l_group_id ? clear group id after done
1774: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1775: l_progress := '40';
1776:
1777: SELECT rcv_interface_groups_s.NEXTVAL
1778: INTO l_group_id

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

1789: , 4
1790: );
1791: END IF;
1792:
1793: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1794: ELSE
1795: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1796:
1797: IF (l_debug = 1) THEN

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

1791: END IF;
1792:
1793: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1794: ELSE
1795: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1796:
1797: IF (l_debug = 1) THEN
1798: print_debug(
1799: 'Enter create_po_rcpt_intf_rec: 30 - l_group_id exists - l_group_id = '

Line 2365: inv_rcv_common_apis.do_check(

2361: g_rcpt_lot_qty_rec_tb.DELETE;
2362: l_progress := '90';
2363:
2364: IF p_item_id IS NOT NULL THEN
2365: inv_rcv_common_apis.do_check(
2366: p_organization_id => p_organization_id
2367: , p_inventory_item_id => p_item_id
2368: , p_transaction_type_id => 18
2369: , p_primary_quantity => l_total_primary_qty

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

2481: , p_attribute13 IN VARCHAR2 DEFAULT NULL
2482: , p_attribute14 IN VARCHAR2 DEFAULT NULL
2483: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2484: ) IS
2485: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2486: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
2487: l_interface_transaction_id NUMBER := NULL;
2488: -- this is used to keep track of the id used to insert the row in rti
2489:

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

2708: WHERE shipment_header_id = p_shipment_header_id
2709: AND ship_to_org_id = p_organization_id;
2710:
2711: --Bug 4252372
2712: --We should set inv_rcv_common_apis.g_rcv_global_var.receipt_num to
2713: --l_receipt_num only if l_receipt_num is not null. It it is null and
2714: --we set the value then we will end up generating extra receipt numbers.
2715: IF (l_receipt_num IS NOT NULL) THEN
2716: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

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

2712: --We should set inv_rcv_common_apis.g_rcv_global_var.receipt_num to
2713: --l_receipt_num only if l_receipt_num is not null. It it is null and
2714: --we set the value then we will end up generating extra receipt numbers.
2715: IF (l_receipt_num IS NOT NULL) THEN
2716: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
2717: END IF;
2718:
2719: IF (l_debug = 1) THEN
2720: print_debug('create_intship_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

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

2716: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
2717: END IF;
2718:
2719: IF (l_debug = 1) THEN
2720: print_debug('create_intship_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
2721: END IF;
2722: EXCEPTION
2723: WHEN NO_DATA_FOUND THEN
2724: l_receipt_num := NULL;

Line 2727: inv_rcv_common_apis.init_startup_values(p_organization_id);

2723: WHEN NO_DATA_FOUND THEN
2724: l_receipt_num := NULL;
2725: END;
2726:
2727: inv_rcv_common_apis.init_startup_values(p_organization_id);
2728: EXCEPTION
2729: WHEN NO_DATA_FOUND THEN
2730: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2731: fnd_msg_pub.ADD;

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

2741:
2742: l_progress := '20';
2743:
2744: -- default l_group_id ? clear group id after done
2745: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2746: SELECT rcv_interface_groups_s.NEXTVAL
2747: INTO l_group_id
2748: FROM DUAL;
2749:

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

2746: SELECT rcv_interface_groups_s.NEXTVAL
2747: INTO l_group_id
2748: FROM DUAL;
2749:
2750: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2751: ELSE
2752: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2753: END IF;
2754:

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

2748: FROM DUAL;
2749:
2750: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2751: ELSE
2752: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2753: END IF;
2754:
2755: l_progress := '30';
2756: /* We'll get shipment_header_id for req at front end

Line 3059: inv_rcv_common_apis.do_check(

3055:
3056: -- clear the lot/qty data structure
3057: g_rcpt_lot_qty_rec_tb.DELETE;
3058: l_progress := '120';
3059: inv_rcv_common_apis.do_check(
3060: p_organization_id => p_organization_id
3061: , p_inventory_item_id => p_item_id
3062: , p_transaction_type_id => 61
3063: , p_primary_quantity => l_total_primary_qty

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

3173: , p_attribute13 IN VARCHAR2 DEFAULT NULL
3174: , p_attribute14 IN VARCHAR2 DEFAULT NULL
3175: , p_attribute15 IN VARCHAR2 DEFAULT NULL
3176: ) IS
3177: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
3178: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
3179: l_interface_transaction_id NUMBER := NULL;
3180: -- this is used to keep track of the id used to insert the row in rti
3181:

Line 3367: inv_rcv_common_apis.init_startup_values(p_organization_id);

3363: l_progress := '10';
3364:
3365: -- query po_startup_value
3366: BEGIN
3367: inv_rcv_common_apis.init_startup_values(p_organization_id);
3368: EXCEPTION
3369: WHEN NO_DATA_FOUND THEN
3370: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3371: fnd_msg_pub.ADD;

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

3381:
3382: l_progress := '20';
3383:
3384: -- default l_group_id ? clear group id after done
3385: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3386: SELECT rcv_interface_groups_s.NEXTVAL
3387: INTO l_group_id
3388: FROM DUAL;
3389:

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

3386: SELECT rcv_interface_groups_s.NEXTVAL
3387: INTO l_group_id
3388: FROM DUAL;
3389:
3390: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3391: ELSE
3392: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3393: END IF;
3394:

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

3388: FROM DUAL;
3389:
3390: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3391: ELSE
3392: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3393: END IF;
3394:
3395: l_progress := '30';
3396: -- call matching algorithm ?

Line 3637: inv_rcv_common_apis.do_check(

3633:
3634: -- clear the lot/qty data structure
3635: g_rcpt_lot_qty_rec_tb.DELETE;
3636: l_progress := '120';
3637: inv_rcv_common_apis.do_check(
3638: p_organization_id => p_organization_id
3639: , p_inventory_item_id => p_item_id
3640: , p_transaction_type_id => 15
3641: , p_primary_quantity => l_total_primary_qty

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

3753: , p_attribute14 IN VARCHAR2 DEFAULT NULL
3754: , p_attribute15 IN VARCHAR2 DEFAULT NULL
3755: , p_express_transaction IN VARCHAR2 DEFAULT NULL
3756: ) IS
3757: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
3758: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
3759: l_interface_transaction_id NUMBER := NULL;
3760: -- this is used to keep track of the id used to insert the row in rti
3761:

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

4154: FROM rcv_shipment_headers
4155: WHERE shipment_header_id = p_shipment_header_id
4156: AND ship_to_org_id = p_organization_id;
4157:
4158: /* Bug# 6339752 the global variable inv_rcv_common_apis.g_rcv_global_var.receipt_num is to be set only if
4159: * there is non-null value from RSH.
4160: */
4161:
4162: IF (l_receipt_num IS NOT NULL) THEN

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

4159: * there is non-null value from RSH.
4160: */
4161:
4162: IF (l_receipt_num IS NOT NULL) THEN
4163: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
4164: END IF;
4165:
4166: IF (l_debug = 1) THEN
4167: print_debug('create_asn_con_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);

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

4163: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;
4164: END IF;
4165:
4166: IF (l_debug = 1) THEN
4167: print_debug('create_asn_con_rcpt_intf_rec: 10.1 ' || inv_rcv_common_apis.g_rcv_global_var.receipt_num, 1);
4168: END IF;
4169: EXCEPTION
4170: WHEN NO_DATA_FOUND THEN
4171: l_receipt_num := NULL;

Line 4174: inv_rcv_common_apis.init_startup_values(p_organization_id);

4170: WHEN NO_DATA_FOUND THEN
4171: l_receipt_num := NULL;
4172: END;
4173:
4174: inv_rcv_common_apis.init_startup_values(p_organization_id);
4175: EXCEPTION
4176: WHEN NO_DATA_FOUND THEN
4177: fnd_message.set_name('INV', 'INV_RCV_PARAM');
4178: fnd_msg_pub.ADD;

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

4188:
4189: l_progress := '20';
4190:
4191: -- default l_group_id ? clear group id after done
4192: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
4193: SELECT rcv_interface_groups_s.NEXTVAL
4194: INTO l_group_id
4195: FROM DUAL;
4196:

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

4193: SELECT rcv_interface_groups_s.NEXTVAL
4194: INTO l_group_id
4195: FROM DUAL;
4196:
4197: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
4198: ELSE
4199: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4200: END IF;
4201:

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

4195: FROM DUAL;
4196:
4197: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
4198: ELSE
4199: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4200: END IF;
4201:
4202: l_progress := '30';
4203: -- call matching algorithm ?

Line 4702: inv_rcv_common_apis.do_check(

4698:
4699: l_progress := '120';
4700:
4701: IF p_item_id IS NOT NULL THEN
4702: inv_rcv_common_apis.do_check(
4703: p_organization_id => p_organization_id
4704: , p_inventory_item_id => p_item_id
4705: , p_transaction_type_id => 18
4706: , p_primary_quantity => l_total_primary_qty

Line 4978: inv_rcv_common_apis.insert_dynamic_lot(

4974: WHEN OTHERS THEN
4975: l_expiration_date := NULL;
4976: END;
4977:
4978: inv_rcv_common_apis.insert_dynamic_lot(
4979: p_api_version => 1.0
4980: , --p_init_msg_list => p_init_msg_list,
4981: --p_commit => p_commit,
4982: --p_validation_level => p_validation_level,

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

5344: ,x_msg_data => l_msg_data
5345: ,p_organization_id => l_from_org_id --BUG 4096028: Should use from org_id
5346: ,p_lpn_id => p_lpn_id
5347: ,p_license_plate_number => NULL
5348: ,p_lpn_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5349: ,p_parent_lpn_id => NULL
5350: );
5351:
5352: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

5516: /* Also duplicate print of LPN labels is avoided */
5517: CURSOR c_rti_txn_id IS
5518: SELECT MAX(rti.interface_transaction_id)
5519: FROM rcv_transactions_interface rti
5520: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5521: GROUP BY DECODE(p_source_type,
5522: 'ASNEXP', rti.interface_transaction_id
5523: , 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5524:

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

5535: print_debug(p_secondary_uom_code,1);
5536: print_debug(p_secondary_quantity,1);
5537: END IF;
5538:
5539: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
5540: --BUG 3444210: For performance reason, use the follow query
5541: --instead of gl_sets_of_books
5542: SELECT TO_NUMBER(hoi.org_information1)
5543: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

Line 5543: INTO inv_rcv_common_apis.g_po_startup_value.sob_id

5539: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
5540: --BUG 3444210: For performance reason, use the follow query
5541: --instead of gl_sets_of_books
5542: SELECT TO_NUMBER(hoi.org_information1)
5543: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
5544: FROM hr_organization_information hoi
5545: WHERE hoi.organization_id = p_organization_id
5546: AND (hoi.org_information_context || '') = 'Accounting Information';
5547: END IF;

Line 5551: inv_rcv_common_apis.validate_trx_date(

5547: END IF;
5548:
5549: l_progress := '15';
5550: -- first check if the transaction date satisfies the validation.
5551: inv_rcv_common_apis.validate_trx_date(
5552: p_trx_date => SYSDATE
5553: , p_organization_id => p_organization_id
5554: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5555: , x_return_status => x_status

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

5550: -- first check if the transaction date satisfies the validation.
5551: inv_rcv_common_apis.validate_trx_date(
5552: p_trx_date => SYSDATE
5553: , p_organization_id => p_organization_id
5554: , p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id
5555: , x_return_status => x_status
5556: , x_error_code => x_message
5557: );
5558:

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

6058:
6059: /* FP-J Lot/Serial Support Enhancement
6060: * If INV J and PO J are installed, do not call label printing API at this stage
6061: */
6062: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
6063: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
6064: IF (p_source_type <> 'VENDOR') THEN --bug 3630412 for normal PO receipt moved the code to rcv_insert_update_header
6065: l_counter := 1;
6066: OPEN c_rti_txn_id;

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

6059: /* FP-J Lot/Serial Support Enhancement
6060: * If INV J and PO J are installed, do not call label printing API at this stage
6061: */
6062: IF ((inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po) OR
6063: (inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j)) THEN
6064: IF (p_source_type <> 'VENDOR') THEN --bug 3630412 for normal PO receipt moved the code to rcv_insert_update_header
6065: l_counter := 1;
6066: OPEN c_rti_txn_id;
6067:

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

6563:
6564: l_progress := '30';
6565: --If INV and PO J are installed,
6566: -- execute the old split logic else just update the local table
6567: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6568: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6569: IF (l_debug = 1) THEN
6570: print_debug('Calling to insert RHI for J code', 4);
6571: END IF;

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

6564: l_progress := '30';
6565: --If INV and PO J are installed,
6566: -- execute the old split logic else just update the local table
6567: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6568: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6569: IF (l_debug = 1) THEN
6570: print_debug('Calling to insert RHI for J code', 4);
6571: END IF;
6572: l_lot_qty_rec_tb(1).lot_number := p_lot_number;

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

6908:
6909: BEGIN
6910: --If INV and PO J are installed,
6911: -- then query using the group_id as RTI is not stamped with shipment_header_id
6912: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6913: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6914: IF (l_debug = 1) THEN
6915: print_debug('Calling to insert RHI for J code', 4);
6916: END IF;

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

6909: BEGIN
6910: --If INV and PO J are installed,
6911: -- then query using the group_id as RTI is not stamped with shipment_header_id
6912: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6913: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6914: IF (l_debug = 1) THEN
6915: print_debug('Calling to insert RHI for J code', 4);
6916: END IF;
6917:

Line 6921: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id

6917:
6918: SELECT transaction_status_code
6919: INTO l_process_status
6920: FROM rcv_transactions_interface
6921: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
6922: AND ROWNUM = 1;
6923: ELSE
6924: SELECT transaction_status_code
6925: INTO l_process_status

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

6947: END IF;
6948:
6949: --If INV and PO J are installed,
6950: -- then query using the group_id as RTI is not stamped with shipment_header_id
6951: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6952: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6953: IF (l_debug = 1) THEN
6954: print_debug('Calling to insert RHI for J code', 4);
6955: END IF;

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

6948:
6949: --If INV and PO J are installed,
6950: -- then query using the group_id as RTI is not stamped with shipment_header_id
6951: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
6952: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
6953: IF (l_debug = 1) THEN
6954: print_debug('Calling to insert RHI for J code', 4);
6955: END IF;
6956: UPDATE rcv_transactions_interface

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

6959: , bill_of_lading = p_bill_of_lading
6960: , packing_slip = p_packing_slip
6961: , num_of_containers = p_num_of_containers
6962: , waybill_airbill_num = p_waybill_airbill_num
6963: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
6964: ELSE
6965: UPDATE rcv_transactions_interface
6966: SET shipment_num = p_shipment_num
6967: , freight_carrier_code = p_freight_carrier_code

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

7056: x_return_status := fnd_api.g_ret_sts_success;
7057: SAVEPOINT rcv_insert_ship_header_sp;
7058: l_header.last_update_date := l_sysdate;
7059: l_header.creation_date := l_sysdate;
7060: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;
7061: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7062: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7063: -- Bug 3443989 for Internal Requition we have to enter receipt_source_code as INTERNAL ORDER
7064: -- According to PO

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

7057: SAVEPOINT rcv_insert_ship_header_sp;
7058: l_header.last_update_date := l_sysdate;
7059: l_header.creation_date := l_sysdate;
7060: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;
7061: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7062: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7063: -- Bug 3443989 for Internal Requition we have to enter receipt_source_code as INTERNAL ORDER
7064: -- According to PO
7065:

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

7058: l_header.last_update_date := l_sysdate;
7059: l_header.creation_date := l_sysdate;
7060: l_header.last_update_login := inv_rcv_common_apis.g_po_startup_value.user_id;
7061: l_header.created_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7062: l_header.last_updated_by := inv_rcv_common_apis.g_po_startup_value.user_id;
7063: -- Bug 3443989 for Internal Requition we have to enter receipt_source_code as INTERNAL ORDER
7064: -- According to PO
7065:
7066: IF p_source_type = 'CUSTOMER' THEN

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

7071: l_header.receipt_source_code := 'INTERNAL ORDER';
7072: END IF;
7073:
7074: l_progress := '13';
7075: l_header.receipt_num := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
7076: IF l_header.receipt_num IS NULL THEN
7077: RAISE fnd_api.g_exc_error;
7078: END IF;
7079:

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

7086: l_header.packing_slip := p_packing_slip;
7087: l_header.shipped_date := p_shipped_date;
7088: l_header.freight_carrier_code := p_freight_carrier_code;
7089: l_header.expected_receipt_date := Nvl(p_expected_receipt_date,l_sysdate);
7090: l_header.employee_id := inv_rcv_common_apis.g_po_startup_value.employee_id;
7091: l_header.num_of_containers := p_num_of_containers;
7092: l_header.waybill_airbill_num := p_waybill_airbill_num;
7093: l_header.comments := p_comments;
7094: l_header.usggl_transaction_code := p_ussgl_transaction_code;

Line 7185: , inv_rcv_common_apis.g_rcv_global_var.interface_group_id

7181: , customer_site_id
7182: )
7183: VALUES (
7184: g_header_intf_id
7185: , inv_rcv_common_apis.g_rcv_global_var.interface_group_id
7186: , 'PENDING' -- processing_status_code
7187: , 'NEW' -- transaction_type
7188: , 'Y' -- validation_flag
7189: , 'RECEIVE' -- auto_transact_code

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

7340: l_progress := '40';
7341: UPDATE rcv_headers_interface
7342: SET customer_id = Nvl(p_customer_id, customer_id)
7343: , last_update_date = l_sysdate
7344: , last_update_login = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_update_login)
7345: , last_updated_by = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_updated_by)
7346: , vendor_id = NVL(p_vendor_id, vendor_id)
7347: , vendor_site_id = NVL(p_vendor_site_id, vendor_site_id)
7348: , ship_to_organization_id = NVL(p_organization_id, ship_to_organization_id)

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

7341: UPDATE rcv_headers_interface
7342: SET customer_id = Nvl(p_customer_id, customer_id)
7343: , last_update_date = l_sysdate
7344: , last_update_login = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_update_login)
7345: , last_updated_by = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_updated_by)
7346: , vendor_id = NVL(p_vendor_id, vendor_id)
7347: , vendor_site_id = NVL(p_vendor_site_id, vendor_site_id)
7348: , ship_to_organization_id = NVL(p_organization_id, ship_to_organization_id)
7349: , receipt_num = NVL(p_receipt_num, receipt_num)

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

7352: , packing_slip = p_packing_slip
7353: , shipped_date = NVL(p_shipped_date, shipped_date)
7354: , freight_carrier_code = p_freight_carrier_code
7355: , expected_receipt_date = NVL(p_expected_receipt_date, expected_receipt_date)
7356: , employee_id = NVL(inv_rcv_common_apis.g_po_startup_value.employee_id, employee_id)
7357: , num_of_containers = NVL(p_num_of_containers, num_of_containers)
7358: , comments = p_comments
7359: , attribute_category = p_attribute_category
7360: , attribute1 = p_attribute1

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

7447: IF l_check_asn ='ASN' THEN
7448:
7449: IF (l_debug = 1) THEN
7450: print_debug('In type ASN before call to new procedure', 4);
7451: print_debug('group_id:'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,4);
7452: END IF;
7453:
7454: --Calling the procedure
7455: INV_CR_ASN_DETAILS.update_asn_item_details

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

7452: END IF;
7453:
7454: --Calling the procedure
7455: INV_CR_ASN_DETAILS.update_asn_item_details
7456: (p_group_id=>inv_rcv_common_apis.g_rcv_global_var.interface_group_id);
7457:
7458: IF (l_debug = 1) THEN
7459: print_debug('In type ASN after call to new procedure.', 4);
7460: print_debug('# of WAD updated:'||SQL%rowcount,4);

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

7918: , p_enforce_wv_constraints => p_enforce_wv_constraints
7919: , p_operation => p_operation
7920: , p_cost_group_id => p_cost_group_id
7921: , p_source_type_id => p_source_type_id
7922: , p_source_header_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
7923: , p_source_name => p_source_name
7924: , p_source_line_id => p_source_line_id
7925: , p_source_line_detail_id => p_source_line_detail_id
7926: , p_homogeneous_container => p_homogeneous_container

Line 8815: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

8811: EXIT WHEN c_delivery_details%NOTFOUND;
8812: l_progress := 35;
8813: IF l_lpn_id IS NOT NULL THEN
8814: -- Nested LPN changes. Check whether the given LPN has content.
8815: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
8816: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
8817: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
8818: SELECT organization_id
8819: , lpn_context

Line 8816: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

8812: l_progress := 35;
8813: IF l_lpn_id IS NOT NULL THEN
8814: -- Nested LPN changes. Check whether the given LPN has content.
8815: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
8816: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
8817: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
8818: SELECT organization_id
8819: , lpn_context
8820: INTO l_lpn_org

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

8813: IF l_lpn_id IS NOT NULL THEN
8814: -- Nested LPN changes. Check whether the given LPN has content.
8815: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
8816: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
8817: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
8818: SELECT organization_id
8819: , lpn_context
8820: INTO l_lpn_org
8821: , l_lpn_context