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_INTEGRATION_APIS dependencies on INV_RCV_INTEGRATION_APIS

Line 1: PACKAGE BODY inv_rcv_integration_apis AS

1: PACKAGE BODY inv_rcv_integration_apis AS
2: /* $Header: INVRCVIB.pls 120.17.12020000.3 2012/08/23 11:54:05 raminoch ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_INTEGRATION_APIS';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_INTEGRATION_APIS';

1: PACKAGE BODY inv_rcv_integration_apis AS
2: /* $Header: INVRCVIB.pls 120.17.12020000.3 2012/08/23 11:54:05 raminoch ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_INTEGRATION_APIS';
5:
6: TYPE mol_rec IS RECORD
7: (line_id NUMBER DEFAULT NULL
8: ,line_number NUMBER DEFAULT NULL

Line 489: l_api_name, 'inv_rcv_integration_apis') THEN

485: BEGIN
486:
487: -- Standard call to check for call compatibility.
488: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
489: l_api_name, 'inv_rcv_integration_apis') THEN
490: print_debug('FND_API not compatible inv_rcv_integration_apis.insert_mtli', 4);
491: RAISE fnd_api.g_exc_unexpected_error;
492: END IF;
493:

Line 490: print_debug('FND_API not compatible inv_rcv_integration_apis.insert_mtli', 4);

486:
487: -- Standard call to check for call compatibility.
488: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
489: l_api_name, 'inv_rcv_integration_apis') THEN
490: print_debug('FND_API not compatible inv_rcv_integration_apis.insert_mtli', 4);
491: RAISE fnd_api.g_exc_unexpected_error;
492: END IF;
493:
494: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1080: 'INV_RCV_INTEGRATION_APIS.INSERT_MTLI',

1076: , p_count => x_msg_count
1077: , p_data => x_msg_data );
1078: IF SQLCODE IS NOT NULL THEN
1079: inv_mobile_helper_functions.sql_error (
1080: 'INV_RCV_INTEGRATION_APIS.INSERT_MTLI',
1081: l_progress,
1082: SQLCODE);
1083: END IF;
1084: END insert_mtli;

Line 1419: l_api_name, 'inv_rcv_integration_apis') THEN

1415: BEGIN
1416:
1417: -- Standard call to check for call compatibility.
1418: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1419: l_api_name, 'inv_rcv_integration_apis') THEN
1420: print_debug('FND_API not compatible','inv_rcv_integration_apis.insert_msni');
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423:

Line 1420: print_debug('FND_API not compatible','inv_rcv_integration_apis.insert_msni');

1416:
1417: -- Standard call to check for call compatibility.
1418: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1419: l_api_name, 'inv_rcv_integration_apis') THEN
1420: print_debug('FND_API not compatible','inv_rcv_integration_apis.insert_msni');
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423:
1424: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1900: inv_mobile_helper_functions.sql_error('INV_RCV_INTEGRATION_APIS.INSERT_MSNI', l_progress, SQLCODE);

1896: x_return_status := fnd_api.g_ret_sts_unexp_error;
1897: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1898:
1899: IF SQLCODE IS NOT NULL THEN
1900: inv_mobile_helper_functions.sql_error('INV_RCV_INTEGRATION_APIS.INSERT_MSNI', l_progress, SQLCODE);
1901: END IF;
1902: END insert_msni;
1903:
1904: -- being called from iSP to validate the lot number

Line 2008: IF p_txn_type = INV_RCV_INTEGRATION_APIS.G_SHIP THEN

2004: print_debug('validate_lot_number: vendor_name: ' || p_vendor_name, 9);
2005: END IF;
2006:
2007: --The validations should be called only if the transaction type is Ship
2008: IF p_txn_type = INV_RCV_INTEGRATION_APIS.G_SHIP THEN
2009: --First check if the lot exists in the given organization
2010: BEGIN
2011: SELECT 'Y'
2012: INTO l_lot_exists

Line 2033: IF (p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_ONLY AND

2029: x_is_new_lot := 'Y';
2030: END IF;
2031:
2032: --then raise an error indicating invalid lot number
2033: IF (p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_ONLY AND
2034: l_lot_exists = 'N') THEN
2035: fnd_message.set_name('INV', 'INV_INVALID_LOT');
2036: fnd_msg_pub.ADD;
2037: x_return_status := FND_API.g_ret_sts_error;

Line 2132: IF (p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_OR_CREATE AND

2128: END IF; /* l_shelf_life_code = item_shelf_life_days */
2129: END IF; --END IF validations for the lot if it exists
2130:
2131: --If the validation mode is exists_or_create and the the lot does not exist
2132: IF (p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_OR_CREATE AND
2133: l_lot_exists = 'N') THEN
2134: --Call the create_inv_lot API to create the lot number
2135: l_expiration_date := p_expiration_date;
2136: IF (l_debug = 1) THEN

Line 2212: 'INV_RCV_INTEGRATION_APIS.VALIDATE_LOT_NUMBER', SQLCODE, SQLERRM);

2208: , p_count => x_msg_count
2209: , p_data => x_msg_data);
2210: IF SQLCODE IS NOT NULL THEN
2211: inv_mobile_helper_functions.sql_error(
2212: 'INV_RCV_INTEGRATION_APIS.VALIDATE_LOT_NUMBER', SQLCODE, SQLERRM);
2213: END IF;
2214: RETURN FALSE;
2215: END validate_lot_number;
2216:

Line 2270: IF p_txn_type = INV_RCV_INTEGRATION_APIS.G_SHIP THEN

2266: print_debug('validate_serial_range: txn_type: ' || p_txn_type, 9);
2267: END IF;
2268:
2269: --The validations should be called only if the transaction type is Ship
2270: IF p_txn_type = INV_RCV_INTEGRATION_APIS.G_SHIP THEN
2271: --If from serial is not given then raise an error
2272: IF p_fm_serial_number IS NULL THEN
2273: IF (l_debug = 1) THEN
2274: print_debug('validate_serial_range: From Serial Number cannot be NULL', 9);

Line 2332: IF p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_ONLY THEN

2328: END IF; --END IF p_to_serial_number is NOT NULL
2329:
2330: --If the validation mode is exists_only then check for the existence of each
2331: --serial within the range
2332: IF p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_ONLY THEN
2333: --If to serial is not given then raise an error
2334: IF p_to_serial_number IS NULL THEN
2335: IF (l_debug = 1) THEN
2336: print_debug('validate_serial_range: To serial number must be specified', 9);

Line 2388: IF p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_OR_CREATE THEN

2384: END IF; --END IF g_exists_only
2385:
2386: --If the validation mode is exists_or_create then call the validate_range_serial
2387: --API that will validate the serial number as well as create one if it does not exist
2388: IF p_validation_mode = INV_RCV_INTEGRATION_APIS.G_EXISTS_OR_CREATE THEN
2389: IF (l_debug = 1) THEN
2390: print_debug('validate_lot_number: calling inv_serial_number_pub.validate_serials to validate/create the serials', 9);
2391: END IF;
2392: --Bug 8413853 To Validate the Marked Serials added Parameter p_check_for_grp_mark_id

Line 2452: 'INV_RCV_INTEGRATION_APIS.VALIDATE_SERIAL_RANGE', SQLCODE, SQLERRM);

2448: , p_count => x_msg_count
2449: , p_data => x_msg_data);
2450: IF SQLCODE IS NOT NULL THEN
2451: inv_mobile_helper_functions.sql_error(
2452: 'INV_RCV_INTEGRATION_APIS.VALIDATE_SERIAL_RANGE', SQLCODE, SQLERRM);
2453: END IF;
2454: RETURN FALSE;
2455: END validate_serial_range;
2456:

Line 2752: l_api_name, 'inv_rcv_integration_apis') THEN

2748: /*end , INVCONV */
2749:
2750: -- Standard call to check for call compatibility.
2751: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2752: l_api_name, 'inv_rcv_integration_apis') THEN
2753: print_debug('FND_API not compatible inv_rcv_integration_apis.validate_lpn_info', 4);
2754: RAISE fnd_api.g_exc_unexpected_error;
2755: END IF;
2756:

Line 2753: print_debug('FND_API not compatible inv_rcv_integration_apis.validate_lpn_info', 4);

2749:
2750: -- Standard call to check for call compatibility.
2751: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2752: l_api_name, 'inv_rcv_integration_apis') THEN
2753: print_debug('FND_API not compatible inv_rcv_integration_apis.validate_lpn_info', 4);
2754: RAISE fnd_api.g_exc_unexpected_error;
2755: END IF;
2756:
2757: l_progress := '50';

Line 2795: 'INV_RCV_INTEGRATION_APIS.VALIDATE_LPN_INFO',

2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2792:
2793: IF SQLCODE IS NOT NULL THEN
2794: inv_mobile_helper_functions.sql_error (
2795: 'INV_RCV_INTEGRATION_APIS.VALIDATE_LPN_INFO',
2796: l_progress,
2797: SQLCODE);
2798: END IF;
2799: RETURN FALSE;

Line 3181: , p_new_rti_info IN inv_rcv_integration_apis.child_rec_tb_tp

3177: , p_init_msg_lst IN VARCHAR2 DEFAULT g_false
3178: , x_return_status OUT NOCOPY VARCHAR2
3179: , x_msg_count OUT NOCOPY NUMBER
3180: , x_msg_data OUT NOCOPY VARCHAR2
3181: , p_new_rti_info IN inv_rcv_integration_apis.child_rec_tb_tp
3182: ) return BOOLEAN
3183: IS
3184: l_exist NUMBER;
3185: l_rti_id NUMBER;

Line 3195: l_api_name, 'inv_rcv_integration_apis') THEN

3191: x_return_status := g_ret_sts_success;
3192:
3193: -- Standard call to check for call compatibility.
3194: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
3195: l_api_name, 'inv_rcv_integration_apis') THEN
3196: IF (l_debug = 1) THEN
3197: print_debug('FND_API not compatible inv_rcv_integration_apis.split_lot_serial', 4);
3198: END IF;
3199: RAISE fnd_api.g_exc_unexpected_error;

Line 3197: print_debug('FND_API not compatible inv_rcv_integration_apis.split_lot_serial', 4);

3193: -- Standard call to check for call compatibility.
3194: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
3195: l_api_name, 'inv_rcv_integration_apis') THEN
3196: IF (l_debug = 1) THEN
3197: print_debug('FND_API not compatible inv_rcv_integration_apis.split_lot_serial', 4);
3198: END IF;
3199: RAISE fnd_api.g_exc_unexpected_error;
3200: END IF;
3201:

Line 5704: inv_rcv_integration_apis.split_mo

5700: l_operation_type VARCHAR2(15);
5701: l_updt_putaway_temp_tbl VARCHAR2(5);
5702: BEGIN
5703: x_return_status := g_ret_sts_success;
5704: inv_rcv_integration_apis.split_mo
5705: (p_orig_mol_id => p_orig_mol_id
5706: , p_mo_splt_tb => p_mo_splt_tb
5707: , p_updt_putaway_temp_tbl => l_updt_putaway_temp_tbl
5708: , p_txn_header_id => l_txn_header_id

Line 6529: END inv_rcv_integration_apis;

6525: fnd_msg_pub.count_and_get
6526: ( p_count => x_msg_count
6527: ,p_data => x_msg_data );
6528: END split_mmtt;
6529: END inv_rcv_integration_apis;