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 STANDARD

Line 194: -- Standard Start of API savepoint

190: l_current_status NUMBER;
191: x_object_id NUMBER;
192: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
193: BEGIN
194: -- Standard Start of API savepoint
195: SAVEPOINT apiinsertserial_apipub;
196:
197: -- Standard call to check for call compatibility.
198: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 197: -- Standard call to check for call compatibility.

193: BEGIN
194: -- Standard Start of API savepoint
195: SAVEPOINT apiinsertserial_apipub;
196:
197: -- Standard call to check for call compatibility.
198: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
199: RAISE fnd_api.g_exc_unexpected_error;
200: END IF;
201:

Line 331: -- Standard check of p_commit.

327:
328: x_return_status := fnd_api.g_ret_sts_success;
329:
330: -- End of API body.
331: -- Standard check of p_commit.
332: IF fnd_api.to_boolean(p_commit) THEN
333: COMMIT WORK;
334: END IF;
335:

Line 336: -- Standard call to get message count and if count is 1, get message info.

332: IF fnd_api.to_boolean(p_commit) THEN
333: COMMIT WORK;
334: END IF;
335:
336: -- Standard call to get message count and if count is 1, get message info.
337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
338: EXCEPTION
339: WHEN fnd_api.g_exc_error THEN
340: ROLLBACK TO apiinsertserial_apipub;

Line 479: -- Standard Start of API savepoint

475:
476: l_input_idx BINARY_INTEGER;
477: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
478: BEGIN
479: -- Standard Start of API savepoint
480: SAVEPOINT apiinsertserial_apipub;
481:
482: IF (l_debug = 1) THEN
483: inv_trx_util_pub.TRACE('In insertserial() procedure. ', 'INV_SERIAL_NUMBER_PUB', 9);

Line 486: -- Standard call to check for call compatibility.

482: IF (l_debug = 1) THEN
483: inv_trx_util_pub.TRACE('In insertserial() procedure. ', 'INV_SERIAL_NUMBER_PUB', 9);
484: END IF;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
488: RAISE fnd_api.g_exc_unexpected_error;
489: END IF;
490:

Line 1270: -- Standard check of p_commit.

1266: l_status_rec.initial_status_flag := 'Y';
1267: inv_material_status_pkg.insert_status_history(l_status_rec);
1268: END IF;
1269:
1270: -- Standard check of p_commit.
1271: IF fnd_api.to_boolean(p_commit) THEN
1272: COMMIT WORK;
1273: END IF;
1274:

Line 1275: -- Standard call to get message count and if count is 1, get message info.

1271: IF fnd_api.to_boolean(p_commit) THEN
1272: COMMIT WORK;
1273: END IF;
1274:
1275: -- Standard call to get message count and if count is 1, get message info.
1276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1277: EXCEPTION
1278: WHEN fnd_api.g_exc_error THEN
1279: ROLLBACK TO apiinsertserial_apipub;

Line 1341: -- Standard Start of API savepoint

1337: l_current_status NUMBER;
1338: x_object_id NUMBER;
1339: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1340: BEGIN
1341: -- Standard Start of API savepoint
1342: SAVEPOINT apiinsertserial_apipub;
1343:
1344: -- Standard call to check for call compatibility.
1345: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1344: -- Standard call to check for call compatibility.

1340: BEGIN
1341: -- Standard Start of API savepoint
1342: SAVEPOINT apiinsertserial_apipub;
1343:
1344: -- Standard call to check for call compatibility.
1345: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1346: RAISE fnd_api.g_exc_unexpected_error;
1347: END IF;
1348:

Line 1560: -- Standard check of p_commit.

1556: END LOOP;
1557:
1558: x_return_status := fnd_api.g_ret_sts_success;
1559: -- End of API body.
1560: -- Standard check of p_commit.
1561: IF fnd_api.to_boolean(p_commit) THEN
1562: COMMIT WORK;
1563: END IF;
1564: -- Standard call to get message count and if count is 1, get message info.

Line 1564: -- Standard call to get message count and if count is 1, get message info.

1560: -- Standard check of p_commit.
1561: IF fnd_api.to_boolean(p_commit) THEN
1562: COMMIT WORK;
1563: END IF;
1564: -- Standard call to get message count and if count is 1, get message info.
1565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1566: EXCEPTION
1567: WHEN fnd_api.g_exc_error THEN
1568: ROLLBACK TO apiinsertserial_apipub;

Line 1649: -- Standard call to check for call compatibility.

1645: BEGIN
1646: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 10');
1647: SAVEPOINT sp_insert_range_serial;
1648:
1649: -- Standard call to check for call compatibility.
1650: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1651: RAISE fnd_api.g_exc_unexpected_error;
1652: END IF;
1653:

Line 1843: -- Standard check of p_commit.

1839:
1840: x_return_status := fnd_api.g_ret_sts_success;
1841:
1842: -- End of API body
1843: -- Standard check of p_commit.
1844: IF fnd_api.to_boolean(p_commit) THEN
1845: COMMIT WORK;
1846: END IF;
1847:

Line 1848: -- Standard call to get message count and if count is 1,

1844: IF fnd_api.to_boolean(p_commit) THEN
1845: COMMIT WORK;
1846: END IF;
1847:
1848: -- Standard call to get message count and if count is 1,
1849: -- get message info.
1850: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1851: EXCEPTION
1852: WHEN fnd_api.g_exc_error THEN

Line 2013: -- Standard Start of API savepoint

2009: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
2010:
2011: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2012: BEGIN
2013: -- Standard Start of API savepoint
2014: SAVEPOINT apiupdateserial_apipub;
2015:
2016: IF (l_debug = 1) THEN
2017: invtrace('*** Inside UpdateSerial ****');

Line 2020: -- Standard call to check for call compatibility.

2016: IF (l_debug = 1) THEN
2017: invtrace('*** Inside UpdateSerial ****');
2018: END IF;
2019:
2020: -- Standard call to check for call compatibility.
2021: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024:

Line 2370: -- Standard check of p_commit.

2366:
2367: x_return_status := fnd_api.g_ret_sts_success;
2368:
2369: -- End of API body.
2370: -- Standard check of p_commit.
2371: IF fnd_api.to_boolean(p_commit) THEN
2372: COMMIT WORK;
2373: END IF;
2374:

Line 2375: -- Standard call to get message count and if count is 1, get message info.

2371: IF fnd_api.to_boolean(p_commit) THEN
2372: COMMIT WORK;
2373: END IF;
2374:
2375: -- Standard call to get message count and if count is 1, get message info.
2376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2377: EXCEPTION
2378: WHEN OTHERS THEN
2379: ROLLBACK TO apiupdateserial_apipub;

Line 2504: -- Standard Start of API savepoint

2500:
2501: l_input_idx BINARY_INTEGER;
2502: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2503: BEGIN
2504: -- Standard Start of API savepoint
2505: SAVEPOINT apiinsertserial_apipub;
2506:
2507: -- Standard call to check for call compatibility.
2508: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2507: -- Standard call to check for call compatibility.

2503: BEGIN
2504: -- Standard Start of API savepoint
2505: SAVEPOINT apiinsertserial_apipub;
2506:
2507: -- Standard call to check for call compatibility.
2508: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2509: RAISE fnd_api.g_exc_unexpected_error;
2510: END IF;
2511:

Line 3316: -- Standard check of p_commit.

3312:
3313: x_return_status := fnd_api.g_ret_sts_success;
3314:
3315: -- End of API body.
3316: -- Standard check of p_commit.
3317: IF fnd_api.to_boolean(p_commit) THEN
3318: COMMIT WORK;
3319: END IF;
3320:

Line 3321: -- Standard call to get message count and if count is 1, get message info.

3317: IF fnd_api.to_boolean(p_commit) THEN
3318: COMMIT WORK;
3319: END IF;
3320:
3321: -- Standard call to get message count and if count is 1, get message info.
3322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
3323: x_msg_data := SUBSTR(l_msg_data, 0, 198);
3324: EXCEPTION
3325: WHEN OTHERS THEN

Line 4994: --dbms_output.put_line('standard group');

4990: --FND_MSG_PUB.ADD;
4991: l_retval := -909;
4992: end if;
4993: elsif( l_groupId = 5 ) THEN
4994: --dbms_output.put_line('standard group');
4995: if( l_isIssue ) THEN
4996: if( p_ser_num_ctrl_code in (2, 3, 5)) THEN
4997: if( p_db_current_status = 3 ) then
4998: l_newStatus := 4;

Line 5324: -- Standard Start of API savepoint

5320: RETURN;
5321: END IF;
5322: END IF;
5323: */
5324: -- Standard Start of API savepoint
5325: SAVEPOINT apiinsertserial_apipub;
5326:
5327: -- Standard call to check for call compatibility.
5328: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 5327: -- Standard call to check for call compatibility.

5323: */
5324: -- Standard Start of API savepoint
5325: SAVEPOINT apiinsertserial_apipub;
5326:
5327: -- Standard call to check for call compatibility.
5328: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
5329: RAISE fnd_api.g_exc_unexpected_error;
5330: END IF;
5331: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 6409: -- Standard check of p_commit.

6405: END IF;
6406:
6407: x_return_status := fnd_api.g_ret_sts_success;
6408: -- End of API body.
6409: -- Standard check of p_commit.
6410: IF fnd_api.to_boolean(p_commit) THEN
6411: COMMIT WORK;
6412: END IF;
6413:

Line 6414: -- Standard call to get message count and if count is 1, get message info.

6410: IF fnd_api.to_boolean(p_commit) THEN
6411: COMMIT WORK;
6412: END IF;
6413:
6414: -- Standard call to get message count and if count is 1, get message info.
6415: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
6416: x_msg_data := SUBSTR(l_msg_data, 0, 198);
6417: EXCEPTION
6418: WHEN OTHERS THEN