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 162: -- Standard Start of API savepoint

158: l_current_status NUMBER;
159: x_object_id NUMBER;
160: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
161: BEGIN
162: -- Standard Start of API savepoint
163: SAVEPOINT apiinsertserial_apipub;
164:
165: -- Standard call to check for call compatibility.
166: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

161: BEGIN
162: -- Standard Start of API savepoint
163: SAVEPOINT apiinsertserial_apipub;
164:
165: -- Standard call to check for call compatibility.
166: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
167: RAISE fnd_api.g_exc_unexpected_error;
168: END IF;
169:

Line 298: -- Standard check of p_commit.

294:
295: x_return_status := fnd_api.g_ret_sts_success;
296:
297: -- End of API body.
298: -- Standard check of p_commit.
299: IF fnd_api.to_boolean(p_commit) THEN
300: COMMIT WORK;
301: END IF;
302:

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

299: IF fnd_api.to_boolean(p_commit) THEN
300: COMMIT WORK;
301: END IF;
302:
303: -- Standard call to get message count and if count is 1, get message info.
304: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
305: EXCEPTION
306: WHEN fnd_api.g_exc_error THEN
307: ROLLBACK TO apiinsertserial_apipub;

Line 446: -- Standard Start of API savepoint

442:
443: l_input_idx BINARY_INTEGER;
444: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
445: BEGIN
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);

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

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
455: RAISE fnd_api.g_exc_unexpected_error;
456: END IF;
457:

Line 1236: -- Standard check of p_commit.

1232: l_status_rec.initial_status_flag := 'Y';
1233: inv_material_status_pkg.insert_status_history(l_status_rec);
1234: END IF;
1235:
1236: -- Standard check of p_commit.
1237: IF fnd_api.to_boolean(p_commit) THEN
1238: COMMIT WORK;
1239: END IF;
1240:

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

1237: IF fnd_api.to_boolean(p_commit) THEN
1238: COMMIT WORK;
1239: END IF;
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: ROLLBACK TO apiinsertserial_apipub;

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

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
1326: RAISE fnd_api.g_exc_unexpected_error;
1327: END IF;
1328:

Line 1512: -- Standard check of p_commit.

1508:
1509: x_return_status := fnd_api.g_ret_sts_success;
1510:
1511: -- End of API body
1512: -- Standard check of p_commit.
1513: IF fnd_api.to_boolean(p_commit) THEN
1514: COMMIT WORK;
1515: END IF;
1516:

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

1513: IF fnd_api.to_boolean(p_commit) THEN
1514: COMMIT WORK;
1515: END IF;
1516:
1517: -- Standard call to get message count and if count is 1,
1518: -- get message info.
1519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1520: EXCEPTION
1521: WHEN fnd_api.g_exc_error THEN

Line 1682: -- Standard Start of API savepoint

1678: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
1679:
1680: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1681: BEGIN
1682: -- Standard Start of API savepoint
1683: SAVEPOINT apiupdateserial_apipub;
1684:
1685: IF (l_debug = 1) THEN
1686: invtrace('*** Inside UpdateSerial ****');

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

1685: IF (l_debug = 1) THEN
1686: invtrace('*** Inside UpdateSerial ****');
1687: END IF;
1688:
1689: -- Standard call to check for call compatibility.
1690: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1691: RAISE fnd_api.g_exc_unexpected_error;
1692: END IF;
1693:

Line 2039: -- Standard check of p_commit.

2035:
2036: x_return_status := fnd_api.g_ret_sts_success;
2037:
2038: -- End of API body.
2039: -- Standard check of p_commit.
2040: IF fnd_api.to_boolean(p_commit) THEN
2041: COMMIT WORK;
2042: END IF;
2043:

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

2040: IF fnd_api.to_boolean(p_commit) THEN
2041: COMMIT WORK;
2042: END IF;
2043:
2044: -- Standard call to get message count and if count is 1, get message info.
2045: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: ROLLBACK TO apiupdateserial_apipub;

Line 2173: -- Standard Start of API savepoint

2169:
2170: l_input_idx BINARY_INTEGER;
2171: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2172: BEGIN
2173: -- Standard Start of API savepoint
2174: SAVEPOINT apiinsertserial_apipub;
2175:
2176: -- Standard call to check for call compatibility.
2177: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

2172: BEGIN
2173: -- Standard Start of API savepoint
2174: SAVEPOINT apiinsertserial_apipub;
2175:
2176: -- Standard call to check for call compatibility.
2177: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2178: RAISE fnd_api.g_exc_unexpected_error;
2179: END IF;
2180:

Line 2985: -- Standard check of p_commit.

2981:
2982: x_return_status := fnd_api.g_ret_sts_success;
2983:
2984: -- End of API body.
2985: -- Standard check of p_commit.
2986: IF fnd_api.to_boolean(p_commit) THEN
2987: COMMIT WORK;
2988: END IF;
2989:

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

2986: IF fnd_api.to_boolean(p_commit) THEN
2987: COMMIT WORK;
2988: END IF;
2989:
2990: -- Standard call to get message count and if count is 1, get message info.
2991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
2992: x_msg_data := SUBSTR(l_msg_data, 0, 198);
2993: EXCEPTION
2994: WHEN OTHERS THEN

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

4603: --FND_MSG_PUB.ADD;
4604: l_retval := -909;
4605: end if;
4606: elsif( l_groupId = 5 ) THEN
4607: --dbms_output.put_line('standard group');
4608: if( l_isIssue ) THEN
4609: if( p_ser_num_ctrl_code in (2, 3, 5)) THEN
4610: if( p_db_current_status = 3 ) then
4611: l_newStatus := 4;

Line 4937: -- Standard Start of API savepoint

4933: RETURN;
4934: END IF;
4935: END IF;
4936: */
4937: -- Standard Start of API savepoint
4938: SAVEPOINT apiinsertserial_apipub;
4939:
4940: -- Standard call to check for call compatibility.
4941: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

4936: */
4937: -- Standard Start of API savepoint
4938: SAVEPOINT apiinsertserial_apipub;
4939:
4940: -- Standard call to check for call compatibility.
4941: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4942: RAISE fnd_api.g_exc_unexpected_error;
4943: END IF;
4944: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 6006: -- Standard check of p_commit.

6002: END IF;
6003:
6004: x_return_status := fnd_api.g_ret_sts_success;
6005: -- End of API body.
6006: -- Standard check of p_commit.
6007: IF fnd_api.to_boolean(p_commit) THEN
6008: COMMIT WORK;
6009: END IF;
6010:

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

6007: IF fnd_api.to_boolean(p_commit) THEN
6008: COMMIT WORK;
6009: END IF;
6010:
6011: -- Standard call to get message count and if count is 1, get message info.
6012: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_msg_data);
6013: x_msg_data := SUBSTR(l_msg_data, 0, 198);
6014: EXCEPTION
6015: WHEN OTHERS THEN