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.17.12010000.2 2008/09/30 11:13:46 kkesavar 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.17.12010000.2 2008/09/30 11:13:46 kkesavar 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 2300: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or

2296:
2297: x_return_status := fnd_api.g_ret_sts_success;
2298: l_progress := '10';
2299:
2300: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2301: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2302: IF (l_debug = 1) THEN
2303: print_debug('In GET ASN ROUTING ID for/after patchsetJ ', 4);
2304: END IF;

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

2297: x_return_status := fnd_api.g_ret_sts_success;
2298: l_progress := '10';
2299:
2300: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2301: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2302: IF (l_debug = 1) THEN
2303: print_debug('In GET ASN ROUTING ID for/after patchsetJ ', 4);
2304: END IF;
2305: OPEN l_curs_asn_lpn_content_new;

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

2312:
2313: l_progress := '20';
2314:
2315: LOOP
2316: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2317: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2318: FETCH l_curs_asn_lpn_content_new INTO l_po_header_id, l_po_line_id, l_po_release_id, l_item_id;
2319: EXIT WHEN l_curs_asn_lpn_content_new%NOTFOUND;
2320: ElSE

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

2313: l_progress := '20';
2314:
2315: LOOP
2316: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2317: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2318: FETCH l_curs_asn_lpn_content_new INTO l_po_header_id, l_po_line_id, l_po_release_id, l_item_id;
2319: EXIT WHEN l_curs_asn_lpn_content_new%NOTFOUND;
2320: ElSE
2321: FETCH l_curs_asn_lpn_content INTO l_po_header_id, l_po_line_id, l_po_release_id, l_item_id;

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

2367: --End Bug 5500463
2368: END LOOP;
2369:
2370: l_progress := '50';
2371: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2372: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2373: CLOSE l_curs_asn_lpn_content_new;
2374: ELSE
2375: CLOSE l_curs_asn_lpn_content;

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

2368: END LOOP;
2369:
2370: l_progress := '50';
2371: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
2372: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
2373: CLOSE l_curs_asn_lpn_content_new;
2374: ELSE
2375: CLOSE l_curs_asn_lpn_content;
2376: END IF;

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

2393: CLOSE l_curs_asn_lpn_content_new;
2394: END IF;
2395:
2396: IF SQLCODE IS NOT NULL THEN
2397: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_asn_routing_id', l_progress, SQLCODE);
2398: END IF;
2399:
2400: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2401:

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

2650: print_debug('Enter get_routing_id 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2651: END IF;
2652:
2653: /** Project Task Commingle check **/
2654: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2655: (inv_rcv_common_apis.g_PO_patch_level >= inv_rcv_common_apis.g_patchset_j_po) AND
2656: p_lpn_id IS NOT NULL AND
2657: p_lpn_id <> 0 ) THEN
2658:

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

2651: END IF;
2652:
2653: /** Project Task Commingle check **/
2654: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2655: (inv_rcv_common_apis.g_PO_patch_level >= inv_rcv_common_apis.g_patchset_j_po) AND
2656: p_lpn_id IS NOT NULL AND
2657: p_lpn_id <> 0 ) THEN
2658:
2659: SELECT NVL(project_reference_enabled, 2)

Line 3060: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po

3056: END IF; -- l_sub <> '@@@'
3057: END IF; -- l_lpn_context = 1
3058:
3059: -- Nested LPN changes do not update LPN status after patchset J
3060: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3061: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3062: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3063: IF (l_lpn_context = 5) THEN
3064: -- Bug 2357196

Line 3061: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j

3057: END IF; -- l_lpn_context = 1
3058:
3059: -- Nested LPN changes do not update LPN status after patchset J
3060: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3061: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3062: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3063: IF (l_lpn_context = 5) THEN
3064: -- Bug 2357196
3065: -- For an expense item do not set the lpn context to 1 or 3

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

3058:
3059: -- Nested LPN changes do not update LPN status after patchset J
3060: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
3061: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
3062: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3063: IF (l_lpn_context = 5) THEN
3064: -- Bug 2357196
3065: -- For an expense item do not set the lpn context to 1 or 3
3066: IF NVL(x_is_expense, 'N') <> 'Y' THEN

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

3080: print_debug('Exiting get_routing_id - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3081: END IF;
3082:
3083: IF SQLCODE IS NOT NULL THEN
3084: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_routing_id', l_progress, SQLCODE);
3085: END IF;
3086:
3087: -- Get message count and data
3088: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

3179: ROLLBACK TO rcv_create_lpn_sp;
3180: x_return_status := fnd_api.g_ret_sts_unexp_error;
3181:
3182: IF SQLCODE IS NOT NULL THEN
3183: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.create_lpn', l_progress, SQLCODE);
3184: END IF;
3185:
3186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3187: END create_lpn;

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

3297: WHEN OTHERS THEN
3298: x_return_status := fnd_api.g_ret_sts_unexp_error;
3299:
3300: IF SQLCODE IS NOT NULL THEN
3301: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.insert_lot', l_progress, SQLCODE);
3302: END IF;
3303:
3304: IF (l_debug = 1) THEN
3305: print_debug('Exitting insert_lot - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

3470: WHEN OTHERS THEN
3471: x_return_status := fnd_api.g_ret_sts_unexp_error;
3472:
3473: IF SQLCODE IS NOT NULL THEN
3474: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.insert_serial', l_progress, SQLCODE);
3475: END IF;
3476:
3477: IF (l_debug = 1) THEN
3478: print_debug('Exitting insert_serial - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

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

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

3798: END IF; --End if check for proj/task comm error
3799: END IF; --END IF current org is PJM enabled
3800: END IF; --END IF lpn_context = 1
3801:
3802: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3803: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3804:
3805: --If the LPN has a sub/loc associated, set the defaulting source
3806: IF x_sub_code <> '@@@' AND l_locator_id IS NOT NULL THEN

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

3799: END IF; --END IF current org is PJM enabled
3800: END IF; --END IF lpn_context = 1
3801:
3802: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3803: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3804:
3805: --If the LPN has a sub/loc associated, set the defaulting source
3806: IF x_sub_code <> '@@@' AND l_locator_id IS NOT NULL THEN
3807: x_default_source := 'LPN';

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

4066: l_progress := '120';
4067:
4068: --If the INV or PO patch levels are < J, then we can reset the OUT variable
4069: --x_default_source since it would not be used for UI validations
4070: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4071: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4072: x_default_source := 'NONE';
4073: x_lpn_context := 5;
4074: ELSE

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

4067:
4068: --If the INV or PO patch levels are < J, then we can reset the OUT variable
4069: --x_default_source since it would not be used for UI validations
4070: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4071: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4072: x_default_source := 'NONE';
4073: x_lpn_context := 5;
4074: ELSE
4075: --If there was no sub/locator defaulted then reset the out variable

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

4088: WHEN OTHERS THEN
4089: x_return_status := fnd_api.g_ret_sts_unexp_error;
4090:
4091: IF SQLCODE IS NOT NULL THEN
4092: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', l_progress, SQLCODE);
4093: END IF;
4094:
4095: IF (l_debug = 1) THEN
4096: print_debug('Exitting get_sub_code - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

4242: WHEN OTHERS THEN
4243: x_return_status := fnd_api.g_ret_sts_unexp_error;
4244:
4245: IF SQLCODE IS NOT NULL THEN
4246: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_location_code', l_progress, SQLCODE);
4247: END IF;
4248:
4249: IF (l_debug = 1) THEN
4250: print_debug('Exitting get_location_code - other exception: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

4396: /* This code will default the revision if RMA contains only one line or more than one line
4397: /* with the same revision.
4398: /* This code will be for 11.5.10 only. We are not handling this functionality in 11.5.9 for an RMA
4399: /* as unable to enter revision for an item on the order line. */
4400: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
4401: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
4402: l_progress := '40';
4403:
4404: print_debug('Patchset J code - Defaulting revision for RMA',4);

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

4397: /* with the same revision.
4398: /* This code will be for 11.5.10 only. We are not handling this functionality in 11.5.9 for an RMA
4399: /* as unable to enter revision for an item on the order line. */
4400: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
4401: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
4402: l_progress := '40';
4403:
4404: print_debug('Patchset J code - Defaulting revision for RMA',4);
4405: IF (l_debug = 1) THEN

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

4448: WHEN OTHERS THEN
4449: x_return_status := fnd_api.g_ret_sts_unexp_error;
4450:
4451: IF SQLCODE IS NOT NULL THEN
4452: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_revision_code', l_progress, SQLCODE);
4453: END IF;
4454:
4455: IF (l_debug = 1) THEN
4456: print_debug('Exitting get_revision_code - other exception: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

4661: EXCEPTION
4662: WHEN OTHERS THEN
4663: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4664: IF SQLCODE IS NOT NULL THEN
4665: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', '10', SQLCODE);
4666: END IF;
4667: IF (l_debug = 1) THEN
4668: print_debug('Exitting populatelotattributes - other exception:'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
4669: END IF;

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

4945: * to skip the updates to the serial
4946: * If either INV or PO J is not installed, then this flag would be set to
4947: * the value 'N' so that the updates continue as usual.
4948: */
4949: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4950: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4951: l_inv_po_j_higher := FALSE;
4952: l_rcv_serial_flag := 'N';
4953: ELSE

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

4946: * If either INV or PO J is not installed, then this flag would be set to
4947: * the value 'N' so that the updates continue as usual.
4948: */
4949: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
4950: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
4951: l_inv_po_j_higher := FALSE;
4952: l_rcv_serial_flag := 'N';
4953: ELSE
4954: l_inv_po_j_higher := TRUE;

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

5118:
5119: x_return_status := fnd_api.g_ret_sts_unexp_error;
5120:
5121: IF SQLCODE IS NOT NULL THEN
5122: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.insert_range_serial', l_progress, SQLCODE);
5123: END IF;
5124:
5125: --
5126: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5264: /* FP-J Lot/Serial Support Enhancement
5265: * If INV and PO patchset levels are "J" or higher, then do not call update statis
5266: * from UI since it would be handled by the receiving TM.
5267: */
5268: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5269: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5270: UPDATE mtl_serial_numbers
5271: SET previous_status = current_status
5272: , current_status = p_current_status

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

5265: * If INV and PO patchset levels are "J" or higher, then do not call update statis
5266: * from UI since it would be handled by the receiving TM.
5267: */
5268: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5269: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5270: UPDATE mtl_serial_numbers
5271: SET previous_status = current_status
5272: , current_status = p_current_status
5273: , inspection_status = p_inspection_required

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

5324: * from UI since it would be handled by the receiving TM.
5325: * Similarly, need not mark the serials since it would be done in the insert_msni
5326: * API upon creating the MSNI interface records
5327: */
5328: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5329: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5330: serial_check.inv_mark_serial(
5331: from_serial_number => p_from_serial_number
5332: , to_serial_number => p_to_serial_number

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

5325: * Similarly, need not mark the serials since it would be done in the insert_msni
5326: * API upon creating the MSNI interface records
5327: */
5328: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5329: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5330: serial_check.inv_mark_serial(
5331: from_serial_number => p_from_serial_number
5332: , to_serial_number => p_to_serial_number
5333: , item_id => p_inventory_item_id

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

5409: print_debug('Exitting update_serial_status - other exceptions:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5410: END IF;
5411:
5412: IF SQLCODE IS NOT NULL THEN
5413: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.update_serial_status', l_progress, SQLCODE);
5414: END IF;
5415:
5416: --
5417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5512: /* FP-J Lot/Serial Support Enhancement
5513: * If INV and PO patchset levels are "J" or higher, then do not call packunpact
5514: * from UI since it would be handled by the receiving TM.
5515: */
5516: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5517: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5518: IF p_call_pack_unpack = 'TRUE' THEN
5519: l_progress := '50';
5520: inv_rcv_std_rcpt_apis.packunpack_container(

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

5513: * If INV and PO patchset levels are "J" or higher, then do not call packunpact
5514: * from UI since it would be handled by the receiving TM.
5515: */
5516: IF ((inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j) OR
5517: (inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po)) THEN
5518: IF p_call_pack_unpack = 'TRUE' THEN
5519: l_progress := '50';
5520: inv_rcv_std_rcpt_apis.packunpack_container(
5521: p_api_version => p_api_version

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

5581: print_debug('Exitting process_lot - other exceptions:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5582: END IF;
5583:
5584: IF SQLCODE IS NOT NULL THEN
5585: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.process_lot', l_progress, SQLCODE);
5586: END IF;
5587:
5588: --
5589: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5643: WHEN OTHERS THEN
5644: x_return_status := fnd_api.g_ret_sts_error;
5645:
5646: IF SQLCODE IS NOT NULL THEN
5647: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.validate_trx_date', '10', SQLCODE);
5648: END IF;
5649:
5650: fnd_message.set_name('PO', 'PO_PO_ENTER_OPEN_GL_DATE');
5651: fnd_msg_pub.ADD;

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

5663: WHEN OTHERS THEN
5664: x_return_status := fnd_api.g_ret_sts_error;
5665:
5666: IF SQLCODE IS NOT NULL THEN
5667: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.validate_trx_date', '20', SQLCODE);
5668: END IF;
5669:
5670: fnd_message.set_name('PO', 'PO_INV_NO_OPEN_PERIOD');
5671: fnd_msg_pub.ADD;

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

5986: , 1);
5987: END IF;
5988:
5989: IF SQLCODE IS NOT NULL THEN
5990: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_req_shipment_header_id', l_progress, SQLCODE);
5991: END IF;
5992: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5993: END;
5994:

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

6100: , 1);
6101: END IF;
6102:
6103: IF SQLCODE IS NOT NULL THEN
6104: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.get_req_shipment_header_id', l_progress, SQLCODE);
6105: END IF;
6106:
6107: -- Get message count and data
6108: fnd_msg_pub.count_and_get(

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

6429: AND rsl.requisition_line_id = prl.requisition_line_id
6430: AND prl.item_id = p_item_id);
6431:
6432: --Get the serial control of the item at the source org
6433: inv_rcv_common_apis.get_serial_ctrl(x_return_status => x_return_status, x_serial_control => x_serial_control
6434: , p_from_org_id => l_from_org_id, p_item_id => p_item_id);
6435: EXCEPTION
6436: WHEN OTHERS THEN
6437: x_return_status := 'F';

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

6567: ROLLBACK TO rcv_create_cross_reference_sp;
6568: x_return_status := fnd_api.g_ret_sts_unexp_error;
6569:
6570: IF SQLCODE IS NOT NULL THEN
6571: inv_mobile_helper_functions.sql_error('INV_RCV_COMMON_APIS.create_cross_reference', l_progress, SQLCODE);
6572: END IF;
6573:
6574: fnd_msg_pub.count_and_get(
6575: p_encoded => fnd_api.g_false,

Line 6664: inv_rcv_common_apis.get_lot_ctrl(

6660: AND rsl.requisition_line_id = prl.requisition_line_id
6661: AND prl.item_id = p_item_id);
6662:
6663: --Get the lot control of the item at the source org
6664: inv_rcv_common_apis.get_lot_ctrl(
6665: x_return_status => x_return_status
6666: , x_msg_count => x_msg_count
6667: , x_msg_data => x_msg_data
6668: , x_lot_control => x_lot_control

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

7066:
7067:
7068: IF (NVL(l_auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7069: x_return_status := fnd_api.g_ret_sts_error;
7070: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
7071: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
7072: x_msg_data := 'INV_CANNOT_COMMINGLE_ROUTING';
7073: fnd_message.set_name('INV', 'INV_CANNOT_COMMINGLE_ROUTING');
7074: ELSE

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

7067:
7068: IF (NVL(l_auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7069: x_return_status := fnd_api.g_ret_sts_error;
7070: IF ((inv_rcv_common_apis.g_wms_patch_level >= inv_rcv_common_apis.g_patchset_j) or
7071: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)) THEN
7072: x_msg_data := 'INV_CANNOT_COMMINGLE_ROUTING';
7073: fnd_message.set_name('INV', 'INV_CANNOT_COMMINGLE_ROUTING');
7074: ELSE
7075: x_msg_data := 'INV_INVALID_LPN_CONTEXT';

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

7182: EXCEPTION
7183: WHEN OTHERS THEN
7184: x_return_status := fnd_api.g_ret_sts_unexp_error;
7185: IF SQLCODE IS NOT NULL THEN
7186: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_sub_code', l_progress, SQLCODE);
7187: END IF;
7188: IF (l_debug = 1) THEN
7189: print_debug('Exitting get_sub_code - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7190: END IF;

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

7451: WHEN OTHERS THEN
7452: x_return_status := fnd_api.g_ret_sts_unexp_error;
7453:
7454: IF SQLCODE IS NOT NULL THEN
7455: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.validate_from_lpn', l_progress, SQLCODE);
7456: END IF;
7457:
7458: IF (l_debug = 1) THEN
7459: print_debug('Exitting validate_from_lpn - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

7670:
7671: x_return_status := fnd_api.g_ret_sts_unexp_error;
7672:
7673: IF SQLCODE IS NOT NULL THEN
7674: inv_mobile_helper_functions.sql_error('inv_rcv_common_apis.get_rec_uom_code', l_progress, SQLCODE);
7675: END IF;
7676:
7677: IF (l_debug = 1) THEN
7678: print_debug('Exiting get_rec_uom_code - other exception:' || l_progress ||' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 7688: END inv_rcv_common_apis;

7684: END IF;
7685:
7686: END get_rec_uom_code; -- Bug 5068944 Ends
7687:
7688: END inv_rcv_common_apis;