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 FND_MSG_PUB

Line 1431: fnd_msg_pub.ADD;

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;
1432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1433: END gen_receipt_num;
1434:
1435: PROCEDURE rcv_gen_receipt_num(

Line 1432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1428: END IF;
1429:
1430: fnd_message.set_name('PO', 'PO_SP_GET_NEXT_AUTO_RECEIPT_NM');
1431: fnd_msg_pub.ADD;
1432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1433: END gen_receipt_num;
1434:
1435: PROCEDURE rcv_gen_receipt_num(
1436: x_receipt_num OUT NOCOPY VARCHAR2

Line 1491: fnd_msg_pub.delete_msg;

1487: --Calling the procedure to clear the Global variable which conatains Lot Numbers (Bug # 3156689)
1488: clear_lot_rec;
1489:
1490: -- clear the message stack.
1491: fnd_msg_pub.delete_msg;
1492: gen_txn_group_id;
1493:
1494: -- set wms_purchased flag
1495: IF wms_install.check_install(l_return_status, l_msg_count, l_msg_data, NULL) THEN

Line 1773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => l_msg_data);

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);
1774: RAISE;
1775: END init_form_values;
1776:
1777: -- Added the overloaded method to return the value of inv patch level

Line 1884: fnd_msg_pub.ADD;

1880: END IF;
1881:
1882: IF x_return_status = fnd_api.g_ret_sts_error THEN
1883: fnd_message.set_name('INV', 'WMS_INSTALL_CHK_ERROR'); -- error checking ems installation
1884: fnd_msg_pub.ADD;
1885: RAISE fnd_api.g_exc_error;
1886: END IF;
1887:
1888: l_progress := '110';

Line 1899: fnd_msg_pub.ADD;

1895: END IF;
1896:
1897: IF x_return_status = fnd_api.g_ret_sts_error THEN
1898: fnd_message.set_name('INV', 'WMS_INSTALL_CHK_ERROR'); -- error checking ems installation
1899: fnd_msg_pub.ADD;
1900: RAISE fnd_api.g_exc_error;
1901: END IF;
1902:
1903: l_progress := '120';

Line 1938: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

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);
1939: END init_rcv_ui_startup_values;
1940:
1941: PROCEDURE init_rcv_ui_startup_values(
1942: p_organization_id IN NUMBER

Line 2535: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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:
2537: IF (l_debug = 1) THEN
2538: print_debug('get_asn_routing_id: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2539: END IF;

Line 2853: fnd_msg_pub.ADD;

2849: (NVL(p_task_id,-9999) <> NVL(l_task_id,-9999)) THEN
2850: x_return_status := fnd_api.g_ret_sts_error;
2851: x_msg_data := 'INV_PRJ_ERR';
2852: fnd_message.set_name('INV', 'INV_PRJ_ERR');
2853: fnd_msg_pub.ADD;
2854: END IF; --End if check for proj/task comm error
2855: END IF; --End IF the current org is PJM org
2856: END IF; --END if WMS and PO patch levels are >= J and lpn_id is not null
2857:

Line 3046: fnd_msg_pub.ADD;

3042: x_return_status := fnd_api.g_ret_sts_error;
3043: -- print_debug('invalid lpn context ',9);
3044: x_msg_data := 'INV_INVALID_LPN_CONTEXT';
3045: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
3046: fnd_msg_pub.ADD;
3047: RETURN;
3048: END IF;
3049:
3050: IF (l_debug = 1) THEN

Line 3089: fnd_msg_pub.ADD;

3085: x_return_status := fnd_api.g_ret_sts_error;
3086: print_debug('get_routing_id: LPN is a loaded LPN',9);
3087: x_msg_data := 'WMS_CONT_INVALID_LPN';
3088: fnd_message.set_name('WMS', 'WMS_LOADED_ERROR');
3089: fnd_msg_pub.ADD;
3090: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
3091: fnd_msg_pub.ADD;
3092: RETURN;
3093: END IF;

Line 3091: fnd_msg_pub.ADD;

3087: x_msg_data := 'WMS_CONT_INVALID_LPN';
3088: fnd_message.set_name('WMS', 'WMS_LOADED_ERROR');
3089: fnd_msg_pub.ADD;
3090: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
3091: fnd_msg_pub.ADD;
3092: RETURN;
3093: END IF;
3094: END IF;
3095:

Line 3125: fnd_msg_pub.ADD;

3121: WHEN OTHERS THEN
3122: x_return_status := fnd_api.g_ret_sts_error;
3123: x_msg_data := 'INV_INT_RESSUBEXP';
3124: fnd_message.set_name('INV', 'INV_INT_RESSUBEXP');
3125: fnd_msg_pub.ADD;
3126: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3127: fnd_msg_pub.ADD;
3128: RETURN;
3129: END;

Line 3127: fnd_msg_pub.ADD;

3123: x_msg_data := 'INV_INT_RESSUBEXP';
3124: fnd_message.set_name('INV', 'INV_INT_RESSUBEXP');
3125: fnd_msg_pub.ADD;
3126: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3127: fnd_msg_pub.ADD;
3128: RETURN;
3129: END;
3130: ELSE -- item not under subinventory restrictions.
3131: BEGIN

Line 3148: fnd_msg_pub.ADD;

3144: WHEN OTHERS THEN
3145: x_return_status := fnd_api.g_ret_sts_error;
3146: x_msg_data := 'INV_SUB_RESTRICT';
3147: fnd_message.set_name('INV', 'INV_SUB_RESTRICT');
3148: fnd_msg_pub.ADD;
3149: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3150: fnd_msg_pub.ADD;
3151: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3152: fnd_msg_pub.ADD;

Line 3150: fnd_msg_pub.ADD;

3146: x_msg_data := 'INV_SUB_RESTRICT';
3147: fnd_message.set_name('INV', 'INV_SUB_RESTRICT');
3148: fnd_msg_pub.ADD;
3149: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3150: fnd_msg_pub.ADD;
3151: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3152: fnd_msg_pub.ADD;
3153: RETURN;
3154: END;

Line 3152: fnd_msg_pub.ADD;

3148: fnd_msg_pub.ADD;
3149: fnd_message.set_name('INV', 'INV_INVALID_SUBINV');
3150: fnd_msg_pub.ADD;
3151: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3152: fnd_msg_pub.ADD;
3153: RETURN;
3154: END;
3155: END IF; -- subinventory restrictions
3156:

Line 3190: fnd_msg_pub.ADD;

3186: WHEN OTHERS THEN
3187: x_return_status := fnd_api.g_ret_sts_error;
3188: x_msg_data := 'INV_CCEOI_LOC_NOT_IN_LIST';
3189: fnd_message.set_name('INV', 'INV_CCEOI_LOC_NOT_IN_LIST');
3190: fnd_msg_pub.ADD;
3191: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3192: fnd_msg_pub.ADD;
3193: RETURN;
3194: END;

Line 3192: fnd_msg_pub.ADD;

3188: x_msg_data := 'INV_CCEOI_LOC_NOT_IN_LIST';
3189: fnd_message.set_name('INV', 'INV_CCEOI_LOC_NOT_IN_LIST');
3190: fnd_msg_pub.ADD;
3191: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3192: fnd_msg_pub.ADD;
3193: RETURN;
3194: END;
3195: ELSE -- item not under restricted locator control
3196: BEGIN

Line 3227: fnd_msg_pub.ADD;

3223: x_return_status := fnd_api.g_ret_sts_error;
3224: x_msg_data := 'INV_TRX_LOCATOR_NA_DUE_MS';
3225: fnd_message.set_name('INV', 'INV_TRX_LOCATOR_NA_DUE_MS');
3226: fnd_message.set_token('TOKEN1', '');
3227: fnd_msg_pub.ADD;
3228: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3229: fnd_msg_pub.ADD;
3230: RETURN;
3231: END;

Line 3229: fnd_msg_pub.ADD;

3225: fnd_message.set_name('INV', 'INV_TRX_LOCATOR_NA_DUE_MS');
3226: fnd_message.set_token('TOKEN1', '');
3227: fnd_msg_pub.ADD;
3228: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
3229: fnd_msg_pub.ADD;
3230: RETURN;
3231: END;
3232: END IF; -- locator restrictions
3233: END IF; -- l_locator_id <> -1

Line 3266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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);
3267: END get_routing_id;
3268:
3269: PROCEDURE create_lpn(
3270: p_organization_id NUMBER

Line 3309: fnd_msg_pub.ADD;

3305: );
3306:
3307: IF l_return_status = fnd_api.g_ret_sts_error THEN
3308: fnd_message.set_name('WMS', 'WMS_LPN_GENERATION_FAIL');
3309: fnd_msg_pub.ADD;
3310:
3311: IF (l_debug = 1) THEN
3312: print_debug('create_lpn 20.1: wms_container_pub.create_lpn RAISE FND_API.G_EXC_ERROR' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
3313: , 4);

Line 3321: fnd_msg_pub.ADD;

3317: END IF;
3318:
3319: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3320: fnd_message.set_name('WMS', 'WMS_LPN_GENERATION_FAIL');
3321: fnd_msg_pub.ADD;
3322:
3323: IF (l_debug = 1) THEN
3324: print_debug('create_lpn 20.2: wms_container_pub.create_lpn RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3325: END IF;

Line 3351: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

3347: EXCEPTION
3348: WHEN fnd_api.g_exc_error THEN
3349: ROLLBACK TO rcv_create_lpn_sp;
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO rcv_create_lpn_sp;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

Line 3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

3351: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO rcv_create_lpn_sp;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3356: WHEN OTHERS THEN
3357: ROLLBACK TO rcv_create_lpn_sp;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359:

Line 3364: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

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;
3366:
3367: -- This api creates a record in the mtl_transaction_lots_temp
3368: -- It checks if the p_transaction_temp_id is null, if it is, then it

Line 3487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3483: print_debug('Exitting insert_lot - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3484: END IF;
3485:
3486: --
3487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3488: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_lot');
3489: END IF;
3490: END insert_lot;
3491:

Line 3488: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_lot');

3484: END IF;
3485:
3486: --
3487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3488: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_lot');
3489: END IF;
3490: END insert_lot;
3491:
3492: -- This api creates a record in the mtl_transaction_serial_temp

Line 3547: fnd_msg_pub.ADD;

3543: l_progress := '20';
3544:
3545: IF l_return = 1 THEN
3546: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
3547: fnd_msg_pub.ADD;
3548: RAISE fnd_api.g_exc_error;
3549: END IF;
3550:
3551: l_progress := '25';

Line 3581: fnd_msg_pub.ADD;

3577: END;
3578:
3579: IF l_count <> 0 THEN
3580: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
3581: fnd_msg_pub.ADD;
3582: RAISE fnd_api.g_exc_error;
3583: END IF;
3584:
3585: l_progress := '30';

Line 3647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);

3643: print_debug('Exitting insert_serial - execution error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3644: END IF;
3645:
3646: -- Get message count and data
3647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3648: WHEN OTHERS THEN
3649: x_return_status := fnd_api.g_ret_sts_unexp_error;
3650:
3651: IF SQLCODE IS NOT NULL THEN

Line 3660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3656: print_debug('Exitting insert_serial - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3657: END IF;
3658:
3659: --
3660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3661: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_serial');
3662: END IF;
3663: END insert_serial;
3664:

Line 3661: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_serial');

3657: END IF;
3658:
3659: --
3660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3661: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_serial');
3662: END IF;
3663: END insert_serial;
3664:
3665: -- Bug 9274276

Line 3758: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3754: THEN
3755: print_debug ('Exitting get_rma_uom_code - other exception:' || l_progress || ' ' || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3756: END IF;
3757:
3758: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3759: THEN
3760: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_rma_uom_code');
3761: END IF;
3762: END get_rma_uom_code;

Line 3760: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_rma_uom_code');

3756: END IF;
3757:
3758: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3759: THEN
3760: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_rma_uom_code');
3761: END IF;
3762: END get_rma_uom_code;
3763: -- Bug 9274276
3764:

Line 3846: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3842: print_debug (
3843: 'Exitting get_asn_uom_code - other exception:' || l_progress || ' ' || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),1);
3844: END IF;
3845:
3846: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3847: THEN
3848: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_asn_uom_code');
3849: END IF;
3850: END get_asn_uom_code;

Line 3848: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_asn_uom_code');

3844: END IF;
3845:
3846: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3847: THEN
3848: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_asn_uom_code');
3849: END IF;
3850: END get_asn_uom_code;
3851: -- Bug 9274276
3852:

Line 3962: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3958: THEN
3959: print_debug ('Exitting get_asn_uom_code - other exception:' || l_progress || ' ' || TO_CHAR (SYSDATE, 'YYYY-MM-DD HH:DD:SS'),1);
3960: END IF;
3961:
3962: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3963: THEN
3964: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_asn_uom_code');
3965: END IF;
3966: END get_asn_uom_code;

Line 3964: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_asn_uom_code');

3960: END IF;
3961:
3962: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3963: THEN
3964: fnd_msg_pub.add_exc_msg (g_pkg_name, 'get_asn_uom_code');
3965: END IF;
3966: END get_asn_uom_code;
3967: -- Bug 9274276
3968:

Line 4147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4143: print_debug('Exitting get_uom_code - other exception:' || l_progress ||' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4144: END IF;
4145:
4146: --
4147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4148: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_uom_code');
4149: END IF;
4150:
4151: END get_uom_code;--BUG#3062591

Line 4148: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_uom_code');

4144: END IF;
4145:
4146: --
4147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4148: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_uom_code');
4149: END IF;
4150:
4151: END get_uom_code;--BUG#3062591
4152:

Line 4280: fnd_msg_pub.ADD;

4276: (NVL(p_task_id,-9999) <> NVL(l_loc_task_id,-9999)) THEN
4277: x_return_status := fnd_api.g_ret_sts_error;
4278: x_msg_data := 'INV_PRJ_ERR';
4279: fnd_message.set_name('INV', 'INV_PRJ_ERR');
4280: fnd_msg_pub.ADD;
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:

Line 4320: fnd_msg_pub.ADD;

4316: IF (NVL(l_auto_transact_code, 'RECEIVE') <> 'DELIVER') THEN
4317: x_return_status := fnd_api.g_ret_sts_error;
4318: x_msg_data := 'INV_CANNOT_COMMINGLE_ROUTING';
4319: fnd_message.set_name('INV', 'INV_CANNOT_COMMINGLE_ROUTING');
4320: fnd_msg_pub.ADD;
4321: RETURN;
4322: END IF;
4323: EXCEPTION
4324: WHEN OTHERS THEN

Line 4583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4579: print_debug('Exitting get_sub_code - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4580: END IF;
4581:
4582: --
4583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4584: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_sub_code');
4585: END IF;
4586: END get_sub_code;
4587:

Line 4584: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_sub_code');

4580: END IF;
4581:
4582: --
4583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4584: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_sub_code');
4585: END IF;
4586: END get_sub_code;
4587:
4588: -- This api is used to return the possible value that can be used for

Line 4776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);
4774: END IF;
4775:
4776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4777: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_location_code');
4778: END IF;
4779:
4780: END get_location_code;

Line 4777: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_location_code');

4773: print_debug('Exitting get_location_code - other exception: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4774: END IF;
4775:
4776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4777: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_location_code');
4778: END IF;
4779:
4780: END get_location_code;
4781:

Line 4982: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);
4980: END IF;
4981:
4982: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4983: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_revision_code');
4984: END IF;
4985:
4986: END GET_REVISION_CODE;

Line 4983: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_revision_code');

4979: print_debug('Exitting get_revision_code - other exception: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4980: END IF;
4981:
4982: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4983: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_revision_code');
4984: END IF;
4985:
4986: END GET_REVISION_CODE;
4987:

Line 5194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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;
5193: --
5194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
5195: THEN
5196: fnd_msg_pub.add_exc_msg
5197: ( g_pkg_name
5198: , 'populatelotattributes'

Line 5196: fnd_msg_pub.add_exc_msg

5192: END IF;
5193: --
5194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
5195: THEN
5196: fnd_msg_pub.add_exc_msg
5197: ( g_pkg_name
5198: , 'populatelotattributes'
5199: );
5200: END IF;

Line 5353: fnd_msg_pub.ADD;

5349: END IF;
5350:
5351: x_return_status := fnd_api.g_ret_sts_unexp_error;
5352: fnd_message.set_name('INV', 'LOT_UNIQUENESS_VIOLATED');
5353: fnd_msg_pub.ADD;
5354: RAISE fnd_api.g_exc_error;
5355: RETURN;
5356: END IF;
5357:

Line 5459: fnd_msg_pub.ADD;

5455: , 1);
5456: END IF;
5457:
5458: fnd_message.set_name('INV', 'INV_DUPLICATE_SERIAL');
5459: fnd_msg_pub.ADD;
5460: fnd_message.set_name('INV', 'INV_FAIL_VALIDATE_SERIAL');
5461: fnd_msg_pub.ADD;
5462: RAISE fnd_api.g_exc_error;
5463: END IF;

Line 5461: fnd_msg_pub.ADD;

5457:
5458: fnd_message.set_name('INV', 'INV_DUPLICATE_SERIAL');
5459: fnd_msg_pub.ADD;
5460: fnd_message.set_name('INV', 'INV_FAIL_VALIDATE_SERIAL');
5461: fnd_msg_pub.ADD;
5462: RAISE fnd_api.g_exc_error;
5463: END IF;
5464:
5465: l_progress := '20';

Line 5527: fnd_msg_pub.ADD;

5523: );
5524:
5525: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5526: fnd_message.set_name('INV', 'INV_LOT_COMMIT_FAILURE');
5527: fnd_msg_pub.ADD;
5528: RAISE fnd_api.g_exc_error;
5529: END IF;
5530:
5531: l_progress := '30';

Line 5606: fnd_msg_pub.ADD;

5602: END IF;
5603:
5604: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5605: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');
5606: fnd_msg_pub.ADD;
5607: RAISE fnd_api.g_exc_error;
5608: END IF;
5609: ELSE
5610: print_debug('insert_range_serial: INV and PO patchset levels are J or higher. No packunpack from UI. No marking from here', 4);

Line 5628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5624: print_debug('Exitting insert_range_serial - execution error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5625: END IF;
5626:
5627: -- Get message count and data
5628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5629: WHEN fnd_api.g_exc_unexpected_error THEN
5630: ROLLBACK TO rcv_insert_range_serial_sp;
5631:
5632: IF (l_debug = 1) THEN

Line 5638: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5634: END IF;
5635:
5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: -- Get message count and data
5638: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5639: WHEN OTHERS THEN
5640: ROLLBACK TO rcv_insert_range_serial_sp;
5641:
5642: IF (l_debug = 1) THEN

Line 5653: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
5654: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_range_serial');
5655: END IF;
5656:
5657: -- Get message count and data

Line 5654: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_range_serial');

5650: END IF;
5651:
5652: --
5653: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5654: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_range_serial');
5655: END IF;
5656:
5657: -- Get message count and data
5658: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 5658: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5654: fnd_msg_pub.add_exc_msg(g_pkg_name, 'insert_range_serial');
5655: END IF;
5656:
5657: -- Get message count and data
5658: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5659: END;
5660:
5661: PROCEDURE update_serial_status(
5662: p_api_version IN NUMBER

Line 5734: fnd_msg_pub.ADD;

5730: print_debug('Update Serial Status : Failed in getting serial control code ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5731: END IF;
5732:
5733: fnd_message.set_name('INV', 'INV_FAIL_VALIDATE_SERIAL');
5734: fnd_msg_pub.ADD;
5735: RAISE fnd_api.g_exc_error;
5736: END IF;
5737:
5738: IF l_serial_control_code = '6' THEN

Line 5764: fnd_msg_pub.ADD;

5760: print_debug('Update_serial_status: After Duplicate Serial Check , RMA and Serial Ctrl as SALES ISSUE Failed Here', 1);
5761: END IF;
5762:
5763: fnd_message.set_name('INV', 'INV_FAIL_VALIDATE_SERIAL');
5764: fnd_msg_pub.ADD;
5765: RAISE fnd_api.g_exc_error;
5766: END IF;
5767: EXCEPTION
5768: WHEN NO_DATA_FOUND THEN

Line 5898: fnd_msg_pub.ADD;

5894: l_progress := '120';
5895:
5896: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5897: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');
5898: fnd_msg_pub.ADD;
5899: RAISE fnd_api.g_exc_error;
5900: END IF;
5901: ELSE
5902: print_debug('update_serial_status: INV and PO patchset levels are J or higher. No packunpack from UI. No marking from here', 4);

Line 5920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5916: print_debug('Exitting update_serial_status - execution error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5917: END IF;
5918:
5919: -- Get message count and data
5920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5921: WHEN fnd_api.g_exc_unexpected_error THEN
5922: ROLLBACK TO rcv_update_serial_sp;
5923: x_return_status := fnd_api.g_ret_sts_unexp_error;
5924:

Line 5930: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5926: print_debug('Exitting update_serial_status - unexpected error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5927: END IF;
5928:
5929: -- Get message count and data
5930: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5931: WHEN OTHERS THEN
5932: ROLLBACK TO rcv_update_serial_sp;
5933: x_return_status := fnd_api.g_ret_sts_unexp_error;
5934:

Line 5944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
5945: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_serial_status');
5946: END IF;
5947:
5948: -- Get message count and data

Line 5945: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_serial_status');

5941: END IF;
5942:
5943: --
5944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5945: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_serial_status');
5946: END IF;
5947:
5948: -- Get message count and data
5949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 5949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5945: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_serial_status');
5946: END IF;
5947:
5948: -- Get message count and data
5949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5950: END update_serial_status;
5951:
5952: PROCEDURE process_lot(
5953: p_api_version IN NUMBER

Line 6038: fnd_msg_pub.ADD;

6034: END IF;
6035:
6036: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6037: fnd_message.set_name('INV', 'INV_LOT_COMMIT_FAILURE');
6038: fnd_msg_pub.ADD;
6039: RAISE fnd_api.g_exc_error;
6040: END IF;
6041:
6042: l_progress := '40';

Line 6080: fnd_msg_pub.ADD;

6076: l_progress := '60';
6077:
6078: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6079: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');
6080: fnd_msg_pub.ADD;
6081: RAISE fnd_api.g_exc_error;
6082: END IF;
6083:
6084: IF (l_debug = 1) THEN

Line 6097: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6093: print_debug('Exitting process_lot - execution error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6094: END IF;
6095:
6096: -- Get message count and data
6097: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6098: WHEN fnd_api.g_exc_unexpected_error THEN
6099: ROLLBACK TO rcv_process_lot_sp;
6100: x_return_status := fnd_api.g_ret_sts_unexp_error;
6101:

Line 6107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6103: print_debug('Exitting process_lot - unexpected error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6104: END IF;
6105:
6106: -- Get message count and data
6107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6108: WHEN OTHERS THEN
6109: ROLLBACK TO rcv_process_lot_sp;
6110: x_return_status := fnd_api.g_ret_sts_unexp_error;
6111:

Line 6121: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
6122: fnd_msg_pub.add_exc_msg(g_pkg_name, 'process_lot');
6123: END IF;
6124:
6125: -- Get message count and data

Line 6122: fnd_msg_pub.add_exc_msg(g_pkg_name, 'process_lot');

6118: END IF;
6119:
6120: --
6121: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6122: fnd_msg_pub.add_exc_msg(g_pkg_name, 'process_lot');
6123: END IF;
6124:
6125: -- Get message count and data
6126: fnd_msg_pub.count_and_get(

Line 6126: fnd_msg_pub.count_and_get(

6122: fnd_msg_pub.add_exc_msg(g_pkg_name, 'process_lot');
6123: END IF;
6124:
6125: -- Get message count and data
6126: fnd_msg_pub.count_and_get(
6127: p_encoded => fnd_api.g_false,
6128: p_count => x_msg_count,
6129: p_data => x_msg_data);
6130: END process_lot;

Line 6156: fnd_msg_pub.ADD;

6152:
6153: IF (p_trx_date > SYSDATE) THEN
6154: x_return_status := fnd_api.g_ret_sts_error;
6155: fnd_message.set_name('PO', 'RCV_TRX_FUTURE_DATE_NA');
6156: fnd_msg_pub.ADD;
6157: RETURN;
6158: END IF;
6159:
6160: BEGIN

Line 6164: fnd_msg_pub.ADD;

6160: BEGIN
6161: IF NOT(po_dates_s.val_open_period(p_trx_date, p_sob_id, 'SQLGL', p_organization_id)) THEN
6162: x_return_status := fnd_api.g_ret_sts_error;
6163: fnd_message.set_name('PO', 'PO_PO_ENTER_OPEN_GL_DATE');
6164: fnd_msg_pub.ADD;
6165: RETURN;
6166: END IF;
6167:
6168: IF NOT(po_dates_s.val_open_period(p_trx_date, p_sob_id, 'PO', p_organization_id)) THEN

Line 6171: fnd_msg_pub.ADD;

6167:
6168: IF NOT(po_dates_s.val_open_period(p_trx_date, p_sob_id, 'PO', p_organization_id)) THEN
6169: x_return_status := fnd_api.g_ret_sts_error;
6170: fnd_message.set_name('PO', 'PO_PO_ENTER_OPEN_GL_DATE');
6171: fnd_msg_pub.ADD;
6172: RETURN;
6173: END IF;
6174: EXCEPTION
6175: WHEN OTHERS THEN

Line 6183: fnd_msg_pub.ADD;

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;
6184: RETURN;
6185: END;
6186:
6187: BEGIN

Line 6191: fnd_msg_pub.ADD;

6187: BEGIN
6188: IF NOT(po_dates_s.val_open_period(p_trx_date, p_sob_id, 'INV', p_organization_id)) THEN
6189: x_return_status := fnd_api.g_ret_sts_error;
6190: fnd_message.set_name('PO', 'PO_INV_NO_OPEN_PERIOD');
6191: fnd_msg_pub.ADD;
6192: RETURN;
6193: END IF;
6194: EXCEPTION
6195: WHEN OTHERS THEN

Line 6203: fnd_msg_pub.ADD;

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;
6204: RETURN;
6205: END;
6206: END validate_trx_date;
6207:

Line 6301: fnd_msg_pub.ADD;

6297: ));
6298: EXCEPTION
6299: WHEN TOO_MANY_ROWS THEN
6300: fnd_message.set_name('INV', 'INV_RCV_REQ_SHIP_MISMATCH');
6301: fnd_msg_pub.ADD;
6302:
6303: IF (l_debug = 1) THEN
6304: print_debug(
6305: 'get_req_shipment_header_id 20 - returns more than one shipment header ID for RCVTXN '

Line 6380: fnd_msg_pub.ADD;

6376: AND prl.item_id = ms.item_id);
6377: EXCEPTION
6378: WHEN TOO_MANY_ROWS THEN
6379: fnd_message.set_name('INV', 'INV_RCV_REQ_SHIP_MISMATCH');
6380: fnd_msg_pub.ADD;
6381:
6382: IF (l_debug = 1) THEN
6383: print_debug('get_req_shipment_header_id for reqexp 35 - returns more than one shipment header ID for RECEIPT ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
6384: , 1

Line 6391: fnd_msg_pub.ADD;

6387:
6388: RAISE fnd_api.g_exc_error;
6389: WHEN NO_DATA_FOUND THEN
6390: fnd_message.set_name('INV', 'INV_LPN_ZERO_AVAIL_QTY');
6391: fnd_msg_pub.ADD;
6392: IF (l_debug = 1) THEN
6393: print_debug('get_req_shipment_header_id for reqexp 40 retruned no rows ', 4);
6394: END IF;
6395:

Line 6416: fnd_msg_pub.ADD;

6412: AND prl.item_id = p_item_id);
6413: EXCEPTION
6414: WHEN TOO_MANY_ROWS THEN
6415: fnd_message.set_name('INV', 'INV_RCV_REQ_SHIP_MISMATCH');
6416: fnd_msg_pub.ADD;
6417:
6418: IF (l_debug = 1) THEN
6419: print_debug('get_req_shipment_header_id 30 - returns more than one shipment header ID for RECEIPT ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6420: END IF;

Line 6461: fnd_msg_pub.ADD;

6457: ));
6458: EXCEPTION
6459: WHEN TOO_MANY_ROWS THEN
6460: fnd_message.set_name('INV', 'INV_RCV_REQ_SHIP_MISMATCH');
6461: fnd_msg_pub.ADD;
6462:
6463: IF (l_debug = 1) THEN
6464: print_debug(
6465: 'get_req_shipment_header_id 20 - returns more than one shipment header ID for RCVTXN '

Line 6478: fnd_msg_pub.ADD;

6474: l_progress := '30';
6475: ELSE
6476: l_progress := '60';
6477: fnd_message.set_name('INV', 'INV_RCV_TXN_NOT_DEFINED');
6478: fnd_msg_pub.ADD;
6479:
6480: IF (l_debug = 1) THEN
6481: print_debug('get_req_shipment_header_id 30 - receiving Txn type ' || p_rcv_txn_type || ' not defined. ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6482: END IF;

Line 6500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6496: print_debug('Exiting get_req_shipment_header_id - execution error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6497: END IF;
6498:
6499: -- Get message count and data
6500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6501: WHEN fnd_api.g_exc_unexpected_error THEN
6502: x_return_status := fnd_api.g_ret_sts_unexp_error;
6503:
6504: IF (l_debug = 1) THEN

Line 6511: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6507: , 1);
6508: END IF;
6509:
6510: -- Get message count and data
6511: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6512: WHEN OTHERS THEN
6513: x_return_status := fnd_api.g_ret_sts_unexp_error;
6514:
6515: IF (l_debug = 1) THEN

Line 6524: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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:
6527: PROCEDURE do_check(
6528: p_organization_id IN NUMBER

Line 6560: fnd_msg_pub.ADD;

6556:
6557: --
6558: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6559: fnd_message.set_name('INV', 'INV_RCV_SHORTAGE_FAILED');
6560: fnd_msg_pub.ADD;
6561: RAISE fnd_api.g_exc_error;
6562: END IF;
6563:
6564: l_progress := '20';

Line 6591: fnd_msg_pub.ADD;

6587:
6588: --
6589: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6590: fnd_message.set_name('INV', 'INV_RCV_SHORTAGE_FAILED');
6591: fnd_msg_pub.ADD;
6592: RAISE fnd_api.g_exc_error;
6593: END IF;
6594:
6595: l_progress := '30';

Line 6603: fnd_msg_pub.ADD;

6599: inv_quantity_tree_pub.clear_quantity_cache;
6600:
6601: IF l_check_result = 'T' THEN
6602: fnd_message.set_name('INV', 'INV_RCV_SHORTAGE_EXISTS');
6603: fnd_msg_pub.ADD;
6604: x_return_status := 'W';
6605: END IF;
6606: END IF;
6607: EXCEPTION

Line 6616: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6612: print_debug('Exiting do_check - execution error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6613: END IF;
6614:
6615: -- Get message count and data
6616: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6617: WHEN fnd_api.g_exc_unexpected_error THEN
6618: x_return_status := fnd_api.g_ret_sts_unexp_error;
6619:
6620: IF (l_debug = 1) THEN

Line 6625: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6621: print_debug('Exitting do_check - unexpected error:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6622: END IF;
6623:
6624: -- Get message count and data
6625: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6626: WHEN OTHERS THEN
6627: x_return_status := fnd_api.g_ret_sts_unexp_error;
6628:
6629: IF (l_debug = 1) THEN

Line 6640: fnd_msg_pub.count_and_get(

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(
6641: p_encoded => fnd_api.g_false,
6642: p_count => x_msg_count,
6643: p_data => x_msg_data);
6644: END do_check;

Line 7016: fnd_msg_pub.ADD;

7012: print_debug('Cross Reference matches a master item - Progress = ' || l_progress, 9);
7013: END IF;
7014:
7015: fnd_message.set_name('INV', 'INV_CROSS_REF_MATCHES_ITEM');
7016: fnd_msg_pub.ADD;
7017: RAISE fnd_api.g_exc_error;
7018: EXCEPTION
7019: WHEN NO_DATA_FOUND THEN
7020: l_progress := '15';

Line 7039: fnd_msg_pub.ADD;

7035: print_debug('Cross Reference already exists - Progress = ' || l_progress, 9);
7036: END IF;
7037:
7038: fnd_message.set_name('INV', 'INV_CROSS_REF_EXISTS');
7039: fnd_msg_pub.ADD;
7040: RAISE fnd_api.g_exc_error;
7041: EXCEPTION
7042: WHEN NO_DATA_FOUND THEN
7043: l_progress := '25';

Line 7087: fnd_msg_pub.count_and_get(

7083: EXCEPTION
7084: WHEN fnd_api.g_exc_error THEN
7085: ROLLBACK TO rcv_create_cross_reference_sp;
7086: x_return_status := fnd_api.g_ret_sts_error;
7087: fnd_msg_pub.count_and_get(
7088: p_encoded => fnd_api.g_false,
7089: p_count => x_msg_count,
7090: p_data => x_msg_data);
7091: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7094: fnd_msg_pub.count_and_get(

7090: p_data => x_msg_data);
7091: WHEN fnd_api.g_exc_unexpected_error THEN
7092: ROLLBACK TO rcv_create_cross_reference_sp;
7093: x_return_status := fnd_api.g_ret_sts_unexp_error;
7094: fnd_msg_pub.count_and_get(
7095: p_encoded => fnd_api.g_false,
7096: p_count => x_msg_count,
7097: p_data => x_msg_data);
7098: WHEN OTHERS THEN

Line 7106: fnd_msg_pub.count_and_get(

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,
7108: p_count => x_msg_count,
7109: p_data => x_msg_data);
7110: END create_cross_reference;

Line 7141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7137: AND organization_id = p_from_org_id;
7138: EXCEPTION
7139: WHEN fnd_api.g_exc_error THEN
7140: x_return_status := fnd_api.g_ret_sts_error;
7141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7142: WHEN fnd_api.g_exc_unexpected_error THEN
7143: x_return_status := fnd_api.g_ret_sts_unexp_error;
7144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7145: WHEN OTHERS THEN

Line 7144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7140: x_return_status := fnd_api.g_ret_sts_error;
7141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7142: WHEN fnd_api.g_exc_unexpected_error THEN
7143: x_return_status := fnd_api.g_ret_sts_unexp_error;
7144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7145: WHEN OTHERS THEN
7146: x_return_status := fnd_api.g_ret_sts_unexp_error;
7147:
7148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7145: WHEN OTHERS THEN
7146: x_return_status := fnd_api.g_ret_sts_unexp_error;
7147:
7148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7149: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');
7150: END IF;
7151:
7152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 7149: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');

7145: WHEN OTHERS THEN
7146: x_return_status := fnd_api.g_ret_sts_unexp_error;
7147:
7148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7149: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');
7150: END IF;
7151:
7152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7153: END get_lot_ctrl;

Line 7152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7149: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');
7150: END IF;
7151:
7152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7153: END get_lot_ctrl;
7154:
7155: /*
7156: * Procedure to to get lot control of the item at

Line 7207: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7203: );
7204: EXCEPTION
7205: WHEN fnd_api.g_exc_error THEN
7206: x_return_status := fnd_api.g_ret_sts_error;
7207: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7208: WHEN fnd_api.g_exc_unexpected_error THEN
7209: x_return_status := fnd_api.g_ret_sts_unexp_error;
7210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7211: WHEN OTHERS THEN

Line 7210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7206: x_return_status := fnd_api.g_ret_sts_error;
7207: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7208: WHEN fnd_api.g_exc_unexpected_error THEN
7209: x_return_status := fnd_api.g_ret_sts_unexp_error;
7210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7211: WHEN OTHERS THEN
7212: x_return_status := fnd_api.g_ret_sts_unexp_error;
7213:
7214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7211: WHEN OTHERS THEN
7212: x_return_status := fnd_api.g_ret_sts_unexp_error;
7213:
7214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');
7216: END IF;
7217:
7218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 7215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');

7211: WHEN OTHERS THEN
7212: x_return_status := fnd_api.g_ret_sts_unexp_error;
7213:
7214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');
7216: END IF;
7217:
7218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7219: END get_lot_ctrl;

Line 7218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

7214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOT_CTRL');
7216: END IF;
7217:
7218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7219: END get_lot_ctrl;
7220:
7221: PROCEDURE get_default_task(
7222: x_return_status OUT NOCOPY VARCHAR2

Line 7610: fnd_msg_pub.ADD;

7606: ELSE
7607: x_msg_data := 'INV_INVALID_LPN_CONTEXT';
7608: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
7609: END IF;
7610: fnd_msg_pub.ADD;
7611: RETURN;
7612: END IF;
7613: EXCEPTION
7614: WHEN NO_DATA_FOUND THEN

Line 7724: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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;
7723: --
7724: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7725: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_sub_code');
7726: END IF;
7727: END get_rcv_sub_loc;
7728:

Line 7725: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_sub_code');

7721: print_debug('Exitting get_sub_code - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7722: END IF;
7723: --
7724: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7725: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_sub_code');
7726: END IF;
7727: END get_rcv_sub_loc;
7728:
7729: PROCEDURE validate_from_lpn(

Line 7995: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7991: print_debug('Exitting validate_from_lpn - other exception:' || l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7992: END IF;
7993:
7994: --
7995: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7996: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validate_from_lpn');
7997: END IF;
7998:
7999: END validate_from_lpn;

Line 7996: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validate_from_lpn');

7992: END IF;
7993:
7994: --
7995: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7996: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validate_from_lpn');
7997: END IF;
7998:
7999: END validate_from_lpn;
8000:

Line 8137: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

8133:
8134: EXCEPTION
8135: WHEN OTHERS THEN
8136: x_return_status := fnd_api.g_ret_sts_unexp_error;
8137: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8138: IF (l_debug = 1) THEN
8139: print_debug('check_req_open_shipments 30 - Unexpected error',1);
8140: END IF;
8141: END count_req_open_shipments;

Line 8214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

8210: print_debug('Exiting get_rec_uom_code - other exception:' || l_progress ||' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8211: END IF;
8212:
8213: --
8214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_rec_uom_code');
8216: END IF;
8217:
8218: END get_rec_uom_code; -- Bug 5068944 Ends

Line 8215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_rec_uom_code');

8211: END IF;
8212:
8213: --
8214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8215: fnd_msg_pub.add_exc_msg(g_pkg_name, 'get_rec_uom_code');
8216: END IF;
8217:
8218: END get_rec_uom_code; -- Bug 5068944 Ends
8219: