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

Line 1: PACKAGE BODY inv_rcv_common_apis AS

1: PACKAGE BODY inv_rcv_common_apis AS
2: /* $Header: INVRCVCB.pls 120.32.12020000.5 2013/01/30 07:55:35 alxue ship $*/
3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'inv_RCV_COMMON_APIS';

Line 5: g_pkg_name CONSTANT VARCHAR2(30) := 'inv_RCV_COMMON_APIS';

1: PACKAGE BODY inv_rcv_common_apis AS
2: /* $Header: INVRCVCB.pls 120.32.12020000.5 2013/01/30 07:55:35 alxue ship $*/
3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'inv_RCV_COMMON_APIS';
6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
8: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9: BEGIN

Line 11: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'inv_RCV_COMMON_APIS', p_level => p_level);

7: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
8: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9: BEGIN
10: IF (l_debug = 1) THEN
11: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'inv_RCV_COMMON_APIS', p_level => p_level);
12: END IF;
13: END print_debug;
14:
15: PROCEDURE init_startup_values(p_organization_id IN NUMBER) IS

Line 778: inv_rcv_common_apis.g_order_lots_by

774: , vendor_name
775: FROM mtl_transaction_lots_temp
776: WHERE transaction_temp_id = p_original_tid
777: ORDER BY DECODE(
778: inv_rcv_common_apis.g_order_lots_by
779: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
780: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
781: , lot_expiration_date
782: );

Line 779: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date

775: FROM mtl_transaction_lots_temp
776: WHERE transaction_temp_id = p_original_tid
777: ORDER BY DECODE(
778: inv_rcv_common_apis.g_order_lots_by
779: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
780: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
781: , lot_expiration_date
782: );
783:

Line 780: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date

776: WHERE transaction_temp_id = p_original_tid
777: ORDER BY DECODE(
778: inv_rcv_common_apis.g_order_lots_by
779: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
780: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
781: , lot_expiration_date
782: );
783:
784: --Changed the order by for bug 2422193

Line 1077: inv_rcv_common_apis.g_order_lots_by

1073: , vendor_name
1074: FROM mtl_transaction_lots_temp
1075: WHERE transaction_temp_id = p_original_tid
1076: ORDER BY DECODE(
1077: inv_rcv_common_apis.g_order_lots_by
1078: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
1079: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
1080: , lot_expiration_date
1081: );

Line 1078: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date

1074: FROM mtl_transaction_lots_temp
1075: WHERE transaction_temp_id = p_original_tid
1076: ORDER BY DECODE(
1077: inv_rcv_common_apis.g_order_lots_by
1078: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
1079: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
1080: , lot_expiration_date
1081: );
1082:

Line 1079: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date

1075: WHERE transaction_temp_id = p_original_tid
1076: ORDER BY DECODE(
1077: inv_rcv_common_apis.g_order_lots_by
1078: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
1079: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
1080: , lot_expiration_date
1081: );
1082:
1083: --Changed the order by for bug 2422193

Line 1427: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.gen_receipt_num', l_progress, SQLCODE);

1423: WHEN OTHERS THEN
1424: x_return_status := fnd_api.g_ret_sts_unexp_error;
1425:
1426: IF SQLCODE IS NOT NULL THEN
1427: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.gen_receipt_num', l_progress, SQLCODE);
1428: END IF;
1429:
1430: fnd_message.set_name('PO', 'PO_SP_GET_NEXT_AUTO_RECEIPT_NM');
1431: fnd_msg_pub.ADD;

Line 1455: inv_rcv_common_apis.gen_receipt_num(

1451: IF (l_debug = 1) THEN
1452: print_debug('Receipt number is null', 4);
1453: END IF;
1454:
1455: inv_rcv_common_apis.gen_receipt_num(
1456: x_receipt_num => g_rcv_global_var.receipt_num
1457: , p_organization_id => p_organization_id
1458: , x_return_status => x_return_status
1459: , x_msg_count => x_msg_count

Line 1749: inv_rcv_common_apis.rcv_gen_receipt_num(

1745: IF (l_debug = 1) THEN
1746: print_debug('init_form_values : 75 ', 4);
1747: END IF;
1748:
1749: inv_rcv_common_apis.rcv_gen_receipt_num(
1750: x_receipt_num => g_rcv_global_var.receipt_num
1751: , p_organization_id => p_org_id
1752: , x_return_status => l_return_status
1753: , x_msg_count => l_msg_count

Line 1769: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.init_form_values', l_progress, SQLCODE);

1765: END IF;
1766:
1767: --
1768: IF SQLCODE IS NOT NULL THEN
1769: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.init_form_values', l_progress, SQLCODE);
1770: END IF;
1771:
1772: -- Get message count and data
1773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => l_msg_data);

Line 1804: x_inv_patch_level := inv_rcv_common_apis.g_inv_patch_level;

1800: END IF;
1801:
1802: x_return_status := fnd_api.g_ret_sts_success;
1803: x_org_id := p_organization_id;
1804: x_inv_patch_level := inv_rcv_common_apis.g_inv_patch_level;
1805: x_po_patch_level := inv_rcv_common_apis.g_po_patch_level;
1806: x_wms_patch_level := inv_rcv_common_apis.g_wms_patch_level;
1807: l_progress := '10';
1808:

Line 1805: x_po_patch_level := inv_rcv_common_apis.g_po_patch_level;

1801:
1802: x_return_status := fnd_api.g_ret_sts_success;
1803: x_org_id := p_organization_id;
1804: x_inv_patch_level := inv_rcv_common_apis.g_inv_patch_level;
1805: x_po_patch_level := inv_rcv_common_apis.g_po_patch_level;
1806: x_wms_patch_level := inv_rcv_common_apis.g_wms_patch_level;
1807: l_progress := '10';
1808:
1809: /* Bug 3440456 */

Line 1806: x_wms_patch_level := inv_rcv_common_apis.g_wms_patch_level;

1802: x_return_status := fnd_api.g_ret_sts_success;
1803: x_org_id := p_organization_id;
1804: x_inv_patch_level := inv_rcv_common_apis.g_inv_patch_level;
1805: x_po_patch_level := inv_rcv_common_apis.g_po_patch_level;
1806: x_wms_patch_level := inv_rcv_common_apis.g_wms_patch_level;
1807: l_progress := '10';
1808:
1809: /* Bug 3440456 */
1810: -- For performance reason this is being as replaced as below.

Line 1934: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.init_rcv_ui_startup_values', l_progress, SQLCODE);

1930: END IF;
1931:
1932: --
1933: IF SQLCODE IS NOT NULL THEN
1934: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.init_rcv_ui_startup_values', l_progress, SQLCODE);
1935: END IF;
1936:
1937: -- Get message count and data
1938: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

Line 2418: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or

2414:
2415: x_return_status := fnd_api.g_ret_sts_success;
2416: l_progress := '10';
2417:
2418: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2419: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2420: IF (l_debug = 1) THEN
2421: print_debug('In GET ASN ROUTING ID for/after patchsetJ ', 4);
2422: END IF;

Line 2419: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN

2415: x_return_status := fnd_api.g_ret_sts_success;
2416: l_progress := '10';
2417:
2418: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2419: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2420: IF (l_debug = 1) THEN
2421: print_debug('In GET ASN ROUTING ID for/after patchsetJ ', 4);
2422: END IF;
2423: OPEN l_curs_asn_lpn_content_new;

Line 2434: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or

2430:
2431: l_progress := '20';
2432:
2433: LOOP
2434: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2435: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2436: FETCH l_curs_asn_lpn_content_new INTO l_po_header_id, l_po_line_id, l_po_release_id, l_item_id , l_rsl_routing_id; -- 14354069
2437: EXIT WHEN l_curs_asn_lpn_content_new%NOTFOUND;
2438: ElSE

Line 2435: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN

2431: l_progress := '20';
2432:
2433: LOOP
2434: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2435: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2436: FETCH l_curs_asn_lpn_content_new INTO l_po_header_id, l_po_line_id, l_po_release_id, l_item_id , l_rsl_routing_id; -- 14354069
2437: EXIT WHEN l_curs_asn_lpn_content_new%NOTFOUND;
2438: ElSE
2439: FETCH l_curs_asn_lpn_content INTO l_po_header_id, l_po_line_id, l_po_release_id, l_item_id , l_rsl_routing_id; -- 14354069

Line 2506: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or

2502: --End Bug 5500463
2503: END LOOP;
2504:
2505: l_progress := '50';
2506: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2507: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2508: CLOSE l_curs_asn_lpn_content_new;
2509: ELSE
2510: CLOSE l_curs_asn_lpn_content;

Line 2507: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN

2503: END LOOP;
2504:
2505: l_progress := '50';
2506: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2507: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2508: CLOSE l_curs_asn_lpn_content_new;
2509: ELSE
2510: CLOSE l_curs_asn_lpn_content;
2511: END IF;

Line 2532: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_asn_routing_id', l_progress, SQLCODE);

2528: CLOSE l_curs_asn_lpn_content_new;
2529: END IF;
2530:
2531: IF SQLCODE IS NOT NULL THEN
2532: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_asn_routing_id', l_progress, SQLCODE);
2533: END IF;
2534:
2535: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2536:

Line 2797: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

2793: print_debug('Enter get_routing_id 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2794: END IF;
2795:
2796: /** Project Task Commingle check **/
2797: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2798: (inv_rcv_common_apis.g_PO_patch_level >= inv_rcv_common_apis.g_patchset_j_po) AND
2799: p_lpn_id IS NOT NULL AND
2800: p_lpn_id <> 0 ) THEN
2801:

Line 2798: (inv_rcv_common_apis.g_PO_patch_level >= inv_rcv_common_apis.g_patchset_j_po) AND

2794: END IF;
2795:
2796: /** Project Task Commingle check **/
2797: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2798: (inv_rcv_common_apis.g_PO_patch_level >= inv_rcv_common_apis.g_patchset_j_po) AND
2799: p_lpn_id IS NOT NULL AND
2800: p_lpn_id <> 0 ) THEN
2801:
2802: SELECT NVL(project_reference_enabled, 2)

Line 3238: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

3234: END IF; -- l_sub <> '@@@'
3235: END IF; -- l_lpn_context = 1
3236:
3237: -- Nested LPN changes do not update LPN status after patchset J
3238: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3239: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3240: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3241: IF (l_lpn_context = 5) THEN
3242: -- Bug 2357196

Line 3239: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

3235: END IF; -- l_lpn_context = 1
3236:
3237: -- Nested LPN changes do not update LPN status after patchset J
3238: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3239: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3240: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3241: IF (l_lpn_context = 5) THEN
3242: -- Bug 2357196
3243: -- For an expense item do not set the lpn context to 1 or 3

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

3236:
3237: -- Nested LPN changes do not update LPN status after patchset J
3238: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3239: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3240: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3241: IF (l_lpn_context = 5) THEN
3242: -- Bug 2357196
3243: -- For an expense item do not set the lpn context to 1 or 3
3244: IF NVL(x_is_expense, 'N') <> 'Y' THEN

Line 3262: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_routing_id', l_progress, SQLCODE);

3258: print_debug('Exiting get_routing_id - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3259: END IF;
3260:
3261: IF SQLCODE IS NOT NULL THEN
3262: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_routing_id', l_progress, SQLCODE);
3263: END IF;
3264:
3265: -- Get message count and data
3266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 3361: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.create_lpn', l_progress, SQLCODE);

3357: ROLLBACK TO rcv_create_lpn_sp;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359:
3360: IF SQLCODE IS NOT NULL THEN
3361: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.create_lpn', l_progress, SQLCODE);
3362: END IF;
3363:
3364: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3365: END create_lpn;

Line 3479: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.insert_lot', l_progress, SQLCODE);

3475: WHEN OTHERS THEN
3476: x_return_status := fnd_api.g_ret_sts_unexp_error;
3477:
3478: IF SQLCODE IS NOT NULL THEN
3479: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.insert_lot', l_progress, SQLCODE);
3480: END IF;
3481:
3482: IF (l_debug = 1) THEN
3483: print_debug('Exitting insert_lot - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3652: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.insert_serial', l_progress, SQLCODE);

3648: WHEN OTHERS THEN
3649: x_return_status := fnd_api.g_ret_sts_unexp_error;
3650:
3651: IF SQLCODE IS NOT NULL THEN
3652: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.insert_serial', l_progress, SQLCODE);
3653: END IF;
3654:
3655: IF (l_debug = 1) THEN
3656: print_debug('Exitting insert_serial - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3750: inv_mobile_helper_functions.sql_error ('inv_rcv_common_apis.get_rma_uom_code', l_progress, SQLCODE);

3746: x_return_status := fnd_api.g_ret_sts_unexp_error;
3747:
3748: IF SQLCODE IS NOT NULL
3749: THEN
3750: inv_mobile_helper_functions.sql_error ('inv_rcv_common_apis.get_rma_uom_code', l_progress, SQLCODE);
3751: END IF;
3752:
3753: IF (l_debug = 1)
3754: THEN

Line 3837: inv_mobile_helper_functions.sql_error ('inv_rcv_common_apis.get_asn_uom_code', l_progress, SQLCODE);

3833: x_return_status := fnd_api.g_ret_sts_unexp_error;
3834:
3835: IF SQLCODE IS NOT NULL
3836: THEN
3837: inv_mobile_helper_functions.sql_error ('inv_rcv_common_apis.get_asn_uom_code', l_progress, SQLCODE);
3838: END IF;
3839:
3840: IF (l_debug = 1)
3841: THEN

Line 3954: inv_mobile_helper_functions.sql_error ('inv_rcv_common_apis.get_asn_uom_code', l_progress, SQLCODE);

3950: x_return_status := fnd_api.g_ret_sts_unexp_error;
3951:
3952: IF SQLCODE IS NOT NULL
3953: THEN
3954: inv_mobile_helper_functions.sql_error ('inv_rcv_common_apis.get_asn_uom_code', l_progress, SQLCODE);
3955: END IF;
3956:
3957: IF (l_debug = 1)
3958: THEN

Line 4139: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_uom_code', l_progress, SQLCODE);

4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: IF SQLCODE IS NOT NULL THEN
4139: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_uom_code', l_progress, SQLCODE);
4140: END IF;
4141:
4142: IF (l_debug = 1) THEN
4143: print_debug('Exitting get_uom_code - other exception:' || l_progress ||' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4285: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND

4281: END IF; --End if check for proj/task comm error
4282: END IF; --END IF current org is PJM enabled
4283: END IF; --END IF lpn_context = 1
4284:
4285: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
4286: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
4287:
4288: --If the LPN has a sub/loc associated, set the defaulting source
4289: IF x_sub_code <> '@@@' AND l_locator_id IS NOT NULL THEN

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

4282: END IF; --END IF current org is PJM enabled
4283: END IF; --END IF lpn_context = 1
4284:
4285: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
4286: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
4287:
4288: --If the LPN has a sub/loc associated, set the defaulting source
4289: IF x_sub_code <> '@@@' AND l_locator_id IS NOT NULL THEN
4290: x_default_source := 'LPN';

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

4549: l_progress := '120';
4550:
4551: --If the INV or PO patch levels are < J, then we can reset the OUT variable
4552: --x_default_source since it would not be used for UI validations
4553: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4554: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4555: x_default_source := 'NONE';
4556: x_lpn_context := 5;
4557: ELSE

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

4550:
4551: --If the INV or PO patch levels are < J, then we can reset the OUT variable
4552: --x_default_source since it would not be used for UI validations
4553: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4554: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4555: x_default_source := 'NONE';
4556: x_lpn_context := 5;
4557: ELSE
4558: --If there was no sub/locator defaulted then reset the out variable

Line 4575: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', l_progress, SQLCODE);

4571: WHEN OTHERS THEN
4572: x_return_status := fnd_api.g_ret_sts_unexp_error;
4573:
4574: IF SQLCODE IS NOT NULL THEN
4575: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', l_progress, SQLCODE);
4576: END IF;
4577:
4578: IF (l_debug = 1) THEN
4579: print_debug('Exitting get_sub_code - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4769: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_location_code', l_progress, SQLCODE);

4765: WHEN OTHERS THEN
4766: x_return_status := fnd_api.g_ret_sts_unexp_error;
4767:
4768: IF SQLCODE IS NOT NULL THEN
4769: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_location_code', l_progress, SQLCODE);
4770: END IF;
4771:
4772: IF (l_debug = 1) THEN
4773: print_debug('Exitting get_location_code - other exception: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

4919: /* This code will default the revision if RMA contains only one line or more than one line
4920: /* with the same revision.
4921: /* This code will be for 11.5.10 only. We are not handling this functionality in 11.5.9 for an RMA
4922: /* as unable to enter revision for an item on the order line. */
4923: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
4924: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
4925: l_progress := '40';
4926:
4927: print_debug('Patchset J code - Defaulting revision for RMA',4);

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

4920: /* with the same revision.
4921: /* This code will be for 11.5.10 only. We are not handling this functionality in 11.5.9 for an RMA
4922: /* as unable to enter revision for an item on the order line. */
4923: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
4924: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
4925: l_progress := '40';
4926:
4927: print_debug('Patchset J code - Defaulting revision for RMA',4);
4928: IF (l_debug = 1) THEN

Line 4975: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_revision_code', l_progress, SQLCODE);

4971: WHEN OTHERS THEN
4972: x_return_status := fnd_api.g_ret_sts_unexp_error;
4973:
4974: IF SQLCODE IS NOT NULL THEN
4975: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_revision_code', l_progress, SQLCODE);
4976: END IF;
4977:
4978: IF (l_debug = 1) THEN
4979: print_debug('Exitting get_revision_code - other exception: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 5188: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', '10', SQLCODE);

5184: EXCEPTION
5185: WHEN OTHERS THEN
5186: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5187: IF SQLCODE IS NOT NULL THEN
5188: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', '10', SQLCODE);
5189: END IF;
5190: IF (l_debug = 1) THEN
5191: print_debug('Exitting populatelotattributes - other exception:'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
5192: END IF;

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

5472: * to skip the updates to the serial
5473: * If either INV or PO J is not installed, then this flag would be set to
5474: * the value 'N' so that the updates continue as usual.
5475: */
5476: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5477: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5478: l_inv_po_j_higher := FALSE;
5479: l_rcv_serial_flag := 'N';
5480: ELSE

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

5473: * If either INV or PO J is not installed, then this flag would be set to
5474: * the value 'N' so that the updates continue as usual.
5475: */
5476: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5477: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5478: l_inv_po_j_higher := FALSE;
5479: l_rcv_serial_flag := 'N';
5480: ELSE
5481: l_inv_po_j_higher := TRUE;

Line 5649: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.insert_range_serial', l_progress, SQLCODE);

5645:
5646: x_return_status := fnd_api.g_ret_sts_unexp_error;
5647:
5648: IF SQLCODE IS NOT NULL THEN
5649: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.insert_range_serial', l_progress, SQLCODE);
5650: END IF;
5651:
5652: --
5653: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5791: /* FP-J Lot/Serial Support Enhancement
5792: * If INV and PO patchset levels are "J" or higher, then do not call update statis
5793: * from UI since it would be handled by the receiving TM.
5794: */
5795: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5796: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5797: UPDATE mtl_serial_numbers
5798: SET previous_status = current_status
5799: , current_status = p_current_status

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

5792: * If INV and PO patchset levels are "J" or higher, then do not call update statis
5793: * from UI since it would be handled by the receiving TM.
5794: */
5795: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5796: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5797: UPDATE mtl_serial_numbers
5798: SET previous_status = current_status
5799: , current_status = p_current_status
5800: , inspection_status = p_inspection_required

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

5851: * from UI since it would be handled by the receiving TM.
5852: * Similarly, need not mark the serials since it would be done in the insert_msni
5853: * API upon creating the MSNI interface records
5854: */
5855: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5856: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5857: serial_check.inv_mark_serial(
5858: from_serial_number => p_from_serial_number
5859: , to_serial_number => p_to_serial_number

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

5852: * Similarly, need not mark the serials since it would be done in the insert_msni
5853: * API upon creating the MSNI interface records
5854: */
5855: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5856: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5857: serial_check.inv_mark_serial(
5858: from_serial_number => p_from_serial_number
5859: , to_serial_number => p_to_serial_number
5860: , item_id => p_inventory_item_id

Line 5940: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.update_serial_status', l_progress, SQLCODE);

5936: print_debug('Exitting update_serial_status - other exceptions:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5937: END IF;
5938:
5939: IF SQLCODE IS NOT NULL THEN
5940: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.update_serial_status', l_progress, SQLCODE);
5941: END IF;
5942:
5943: --
5944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

6044: /* FP-J Lot/Serial Support Enhancement
6045: * If INV and PO patchset levels are "J" or higher, then do not call packunpact
6046: * from UI since it would be handled by the receiving TM.
6047: */
6048: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
6049: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
6050: IF p_call_pack_unpack = 'TRUE' THEN
6051: l_progress := '50';
6052: inv_rcv_std_rcpt_apis.packunpack_container(

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

6045: * If INV and PO patchset levels are "J" or higher, then do not call packunpact
6046: * from UI since it would be handled by the receiving TM.
6047: */
6048: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
6049: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
6050: IF p_call_pack_unpack = 'TRUE' THEN
6051: l_progress := '50';
6052: inv_rcv_std_rcpt_apis.packunpack_container(
6053: p_api_version => p_api_version

Line 6117: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.process_lot', l_progress, SQLCODE);

6113: print_debug('Exitting process_lot - other exceptions:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6114: END IF;
6115:
6116: IF SQLCODE IS NOT NULL THEN
6117: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.process_lot', l_progress, SQLCODE);
6118: END IF;
6119:
6120: --
6121: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 6179: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.validate_trx_date', '10', SQLCODE);

6175: WHEN OTHERS THEN
6176: x_return_status := fnd_api.g_ret_sts_error;
6177:
6178: IF SQLCODE IS NOT NULL THEN
6179: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.validate_trx_date', '10', SQLCODE);
6180: END IF;
6181:
6182: fnd_message.set_name('PO', 'PO_PO_ENTER_OPEN_GL_DATE');
6183: fnd_msg_pub.ADD;

Line 6199: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.validate_trx_date', '20', SQLCODE);

6195: WHEN OTHERS THEN
6196: x_return_status := fnd_api.g_ret_sts_error;
6197:
6198: IF SQLCODE IS NOT NULL THEN
6199: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.validate_trx_date', '20', SQLCODE);
6200: END IF;
6201:
6202: fnd_message.set_name('PO', 'PO_INV_NO_OPEN_PERIOD');
6203: fnd_msg_pub.ADD;

Line 6522: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_req_shipment_header_id', l_progress, SQLCODE);

6518: , 1);
6519: END IF;
6520:
6521: IF SQLCODE IS NOT NULL THEN
6522: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_req_shipment_header_id', l_progress, SQLCODE);
6523: END IF;
6524: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6525: END;
6526:

Line 6636: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_req_shipment_header_id', l_progress, SQLCODE);

6632: , 1);
6633: END IF;
6634:
6635: IF SQLCODE IS NOT NULL THEN
6636: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_req_shipment_header_id', l_progress, SQLCODE);
6637: END IF;
6638:
6639: -- Get message count and data
6640: fnd_msg_pub.count_and_get(

Line 6965: inv_rcv_common_apis.get_serial_ctrl(x_return_status => x_return_status, x_serial_control => x_serial_control

6961: AND rsl.requisition_line_id = prl.requisition_line_id
6962: AND prl.item_id = p_item_id);
6963:
6964: --Get the serial control of the item at the source org
6965: inv_rcv_common_apis.get_serial_ctrl(x_return_status => x_return_status, x_serial_control => x_serial_control
6966: , p_from_org_id => l_from_org_id, p_item_id => p_item_id);
6967: EXCEPTION
6968: WHEN OTHERS THEN
6969: x_return_status := 'F';

Line 7103: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.create_cross_reference', l_progress, SQLCODE);

7099: ROLLBACK TO rcv_create_cross_reference_sp;
7100: x_return_status := fnd_api.g_ret_sts_unexp_error;
7101:
7102: IF SQLCODE IS NOT NULL THEN
7103: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.create_cross_reference', l_progress, SQLCODE);
7104: END IF;
7105:
7106: fnd_msg_pub.count_and_get(
7107: p_encoded => fnd_api.g_false,

Line 7196: inv_rcv_common_apis.get_lot_ctrl(

7192: AND rsl.requisition_line_id = prl.requisition_line_id
7193: AND prl.item_id = p_item_id);
7194:
7195: --Get the lot control of the item at the source org
7196: inv_rcv_common_apis.get_lot_ctrl(
7197: x_return_status => x_return_status
7198: , x_msg_count => x_msg_count
7199: , x_msg_data => x_msg_data
7200: , x_lot_control => x_lot_control

Line 7602: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or

7598:
7599:
7600: IF (NVL(l_auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7601: x_return_status := fnd_api.g_ret_sts_error;
7602: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
7603: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
7604: x_msg_data := 'INV_CANNOT_COMMINGLE_ROUTING';
7605: fnd_message.set_name('INV', 'INV_CANNOT_COMMINGLE_ROUTING');
7606: ELSE

Line 7603: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN

7599:
7600: IF (NVL(l_auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7601: x_return_status := fnd_api.g_ret_sts_error;
7602: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
7603: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
7604: x_msg_data := 'INV_CANNOT_COMMINGLE_ROUTING';
7605: fnd_message.set_name('INV', 'INV_CANNOT_COMMINGLE_ROUTING');
7606: ELSE
7607: x_msg_data := 'INV_INVALID_LPN_CONTEXT';

Line 7718: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', l_progress, SQLCODE);

7714: EXCEPTION
7715: WHEN OTHERS THEN
7716: x_return_status := fnd_api.g_ret_sts_unexp_error;
7717: IF SQLCODE IS NOT NULL THEN
7718: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', l_progress, SQLCODE);
7719: END IF;
7720: IF (l_debug = 1) THEN
7721: print_debug('Exitting get_sub_code - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7722: END IF;

Line 7987: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.validate_from_lpn', l_progress, SQLCODE);

7983: WHEN OTHERS THEN
7984: x_return_status := fnd_api.g_ret_sts_unexp_error;
7985:
7986: IF SQLCODE IS NOT NULL THEN
7987: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.validate_from_lpn', l_progress, SQLCODE);
7988: END IF;
7989:
7990: IF (l_debug = 1) THEN
7991: print_debug('Exitting validate_from_lpn - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 8206: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_rec_uom_code', l_progress, SQLCODE);

8202:
8203: x_return_status := fnd_api.g_ret_sts_unexp_error;
8204:
8205: IF SQLCODE IS NOT NULL THEN
8206: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_rec_uom_code', l_progress, SQLCODE);
8207: END IF;
8208:
8209: IF (l_debug = 1) THEN
8210: print_debug('Exiting get_rec_uom_code - other exception:' || l_progress ||' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 8220: END inv_rcv_common_apis;

8216: END IF;
8217:
8218: END get_rec_uom_code; -- Bug 5068944 Ends
8219:
8220: END inv_rcv_common_apis;