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_SERIAL_NUMBER_PUB dependencies on INV_SERIAL_NUMBER_PUB

Line 1: PACKAGE BODY inv_serial_number_pub AS

1: PACKAGE BODY inv_serial_number_pub AS
2: /* $Header: INVPSNB.pls 120.7.12010000.4 2008/12/02 10:07:52 ksivasa ship $*/
3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_SERIAL_NUMBER_PUB';

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

1: PACKAGE BODY inv_serial_number_pub AS
2: /* $Header: INVPSNB.pls 120.7.12010000.4 2008/12/02 10:07:52 ksivasa ship $*/
3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_SERIAL_NUMBER_PUB';
6: /* -- Added for DMV Project */
7: -- Bug# 6825191, Commenting the variables to be obsoleted
8: --G_first_row_of_trx boolean := true;
9: --G_first_row_trx_tmp_id number := 0;

Line 190: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

186: item_count := 0;
187: WHEN OTHERS THEN
188: --Bug 3153585:Raising exception to populate error message correctly.
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
190: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
191: END IF;
192:
193: RAISE fnd_api.g_exc_unexpected_error;
194: END;

Line 237: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

233: RAISE fnd_api.g_exc_error;
234: WHEN OTHERS THEN
235: --Bug 3152585:Raising Exception to populate error message correctly.
236: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
237: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
238: END IF;
239:
240: RAISE fnd_api.g_exc_unexpected_error;
241: END;

Line 320: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

316: WHEN OTHERS THEN
317: ROLLBACK TO apiinsertserial_apipub;
318:
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
321: END IF;
322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 450: inv_trx_util_pub.TRACE('In insertserial() procedure. ', 'INV_SERIAL_NUMBER_PUB', 9);

446: -- Standard Start of API savepoint
447: SAVEPOINT apiinsertserial_apipub;
448:
449: IF (l_debug = 1) THEN
450: inv_trx_util_pub.TRACE('In insertserial() procedure. ', 'INV_SERIAL_NUMBER_PUB', 9);
451: END IF;
452:
453: -- Standard call to check for call compatibility.
454: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1253: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');

1249: WHEN OTHERS THEN
1250: ROLLBACK TO apiinsertserial_apipub;
1251:
1252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1253: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertSerial');
1254: END IF;
1255:
1256: --Bug 3153585:Populating x_msg_data from message stack
1257: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1321: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 10');

1317: l_api_version CONSTANT NUMBER := 1.0;
1318: l_api_name CONSTANT VARCHAR2(30) := 'insert_range_serial';
1319: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1320: BEGIN
1321: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 10');
1322: SAVEPOINT sp_insert_range_serial;
1323:
1324: -- Standard call to check for call compatibility.
1325: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1372: --invtrace('INV_SERIAL_NUMBER_PUB', ' l_cur_serial_number, l_current_status AND l_group_mark_id ' || l_cur_serial_number || ' ' || l_current_status

1368: WHEN OTHERS THEN
1369: NULL;
1370: END;
1371:
1372: --invtrace('INV_SERIAL_NUMBER_PUB', ' l_cur_serial_number, l_current_status AND l_group_mark_id ' || l_cur_serial_number || ' ' || l_current_status
1373: -- || ' : ' || l_group_mark_id);
1374:
1375: /* Bug #1767236
1376: * When the status is 4 (out of stores) then update the status do not insert

Line 1422: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 60');

1418: fnd_message.set_name('INV', 'INV_SERIAL_USED');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_error;
1421: ELSE
1422: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 60');
1423: -- uniqueness check passed
1424: -- and it is not a pre-defined serial
1425: inv_serial_number_pub.insertserial(
1426: p_api_version => p_api_version

Line 1425: inv_serial_number_pub.insertserial(

1421: ELSE
1422: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 60');
1423: -- uniqueness check passed
1424: -- and it is not a pre-defined serial
1425: inv_serial_number_pub.insertserial(
1426: p_api_version => p_api_version
1427: , p_init_msg_list => p_init_msg_list
1428: , p_commit => p_commit
1429: , p_validation_level => p_validation_level

Line 2051: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');

2047: WHEN OTHERS THEN
2048: ROLLBACK TO apiupdateserial_apipub;
2049:
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'updateSerial');
2052: END IF;
2053:
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055: END updateserial;

Line 2998: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');

2994: WHEN OTHERS THEN
2995: ROLLBACK TO apiinsertserial_apipub;
2996:
2997: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2998: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertUnitTrx');
2999: END IF;
3000:
3001: x_return_status := fnd_api.g_ret_sts_unexp_error;
3002: END insertunittrx;

Line 4002: AND inv_serial_number_pub.valsn(

3998: AND msn.SERIAL_NUMBER BETWEEN p_f_ser_num AND p_t_ser_num
3999: AND decode( msn.CURRENT_STATUS, 6, 1, msn.CURRENT_STATUS ) = l_status_after_p1 -- l_last_status -- p_last_status
4000: AND Nvl(msn.owning_tp_type,2) <> 1
4001: AND Nvl(msn.owning_organization_id,msn.current_organization_id) = msn.current_organization_id
4002: AND inv_serial_number_pub.valsn(
4003: p_trxsrctypid, -- trx_src_typ_id IN NUMBER,
4004: p_trx_act_id, -- trx_action_id IN NUMBER,
4005: p_rev, -- revision IN VARCHAR2,
4006: p_subinv, -- curr_subinv_code IN VARCHAR2,

Line 4072: AND inv_serial_number_pub.valsn(

4068: AND msn.SERIAL_NUMBER BETWEEN p_f_ser_num AND p_t_ser_num
4069: AND decode( msn.CURRENT_STATUS, 6, 1, msn.CURRENT_STATUS ) = l_last_status
4070: AND Nvl(msn.owning_organization_id,msn.current_organization_id) = msn.current_organization_id
4071: AND Nvl(msn.owning_tp_type,2) <> 1
4072: AND inv_serial_number_pub.valsn(
4073: p_trxsrctypid, -- trx_src_typ_id IN NUMBER,
4074: p_trx_act_id, -- trx_action_id IN NUMBER,
4075: p_rev, -- revision IN VARCHAR2,
4076: p_subinv, -- curr_subinv_code IN VARCHAR2,

Line 6019: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');

6015: WHEN OTHERS THEN
6016: ROLLBACK TO apiinsertserial_apipub;
6017:
6018: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6019: fnd_msg_pub.add_exc_msg('INV_SERIAL_NUMBER_PUB', 'insertRangeUnitTrx');
6020: END IF;
6021:
6022: x_return_status := fnd_api.g_ret_sts_unexp_error;
6023: END insertRangeUnitTrx;

Line 6025: END inv_serial_number_pub;

6021:
6022: x_return_status := fnd_api.g_ret_sts_unexp_error;
6023: END insertRangeUnitTrx;
6024:
6025: END inv_serial_number_pub;