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.EAM_ASSET_LOG_PVT dependencies on EAM_ASSET_LOG_PVT

Line 1: PACKAGE BODY EAM_ASSET_LOG_PVT AS

1: PACKAGE BODY EAM_ASSET_LOG_PVT AS
2: /* $Header: EAMVALGB.pls 120.31 2012/01/27 10:52:00 vchidura ship $ */
3:
4: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_LOG_PVT';
5:

Line 4: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_LOG_PVT';

1: PACKAGE BODY EAM_ASSET_LOG_PVT AS
2: /* $Header: EAMVALGB.pls 120.31 2012/01/27 10:52:00 vchidura ship $ */
3:
4: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_LOG_PVT';
5:
6: PROCEDURE insert_row(
7: p_log_id IN number := NULL,
8: p_api_version IN number := 1.0,

Line 64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;

60: l_var2 number;
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT fnd_api.compatible_api_call(
68: l_api_version

Line 122: EAM_ASSET_LOG_PVT.validate_event(

118: END;
119:
120: END IF;
121:
122: EAM_ASSET_LOG_PVT.validate_event(
123: p_event_date => p_event_date,
124: p_event_type => p_event_type,
125: p_event_id => p_event_id,
126: p_instance_id => p_instance_id,

Line 247: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

243: p_count => x_msg_count
244: ,p_data => x_msg_data);
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get(
250: p_count => x_msg_count
251: ,p_data => x_msg_data);

Line 253: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

249: fnd_msg_pub.count_and_get(
250: p_count => x_msg_count
251: ,p_data => x_msg_data);
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);

Line 259: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

255: fnd_msg_pub.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN OTHERS THEN
259: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: IF fnd_msg_pub.check_msg_level(
263: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;

298: l_dummy number;
299:
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT fnd_api.compatible_api_call(
306: l_api_version

Line 518: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

514: END IF;
515:
516: EXCEPTION
517: WHEN fnd_api.g_exc_error THEN
518: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
519: x_return_status := fnd_api.g_ret_sts_error;
520: fnd_msg_pub.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);

Line 524: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

520: fnd_msg_pub.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN fnd_api.g_exc_unexpected_error THEN
524: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: fnd_msg_pub.count_and_get(
527: p_count => x_msg_count
528: ,p_data => x_msg_data);

Line 530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

526: fnd_msg_pub.count_and_get(
527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN OTHERS THEN
530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: IF fnd_msg_pub.check_msg_level(
533: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 566: SAVEPOINT EAM_ASSET_LOG_PVT_SV;

562: BEGIN
563: retcode:=0;
564:
565: -- Standard Start of API savepoint
566: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
567:
568: begin
569: select nvl(maint_organization_id, p_organization_id) into l_organization_id
570: from mtl_parameters

Line 623: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

619: COMMIT;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
624: fnd_message.set_name('EAM','EAM_PURGE_EVENT_LOG_FAILURE');
625: errbuf := fnd_message.get();
626: retcode := 2;
627: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 629: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

625: errbuf := fnd_message.get();
626: retcode := 2;
627: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
630: fnd_message.set_name('EAM','EAM_PURGE_EVENT_LOG_FAILURE');
631: errbuf := fnd_message.get();
632: retcode := 2;
633: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 635: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

631: errbuf := fnd_message.get();
632: retcode := 2;
633: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
634: WHEN OTHERS THEN
635: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
636: retcode := 2;
637: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
638:
639: END delete_row;

Line 679: SAVEPOINT EAM_ASSET_LOG_PVT;

675:
676: BEGIN
677:
678: /* Standard Start of API savepoint */
679: SAVEPOINT EAM_ASSET_LOG_PVT;
680:
681: /* Standard call to check for call compatibility. */
682: IF NOT FND_API.Compatible_API_Call
683: ( l_api_version ,

Line 1124: EAM_ASSET_LOG_PVT.insert_row(

1120: END IF;
1121:
1122: IF l_event_id IS NOT NULL THEN
1123:
1124: EAM_ASSET_LOG_PVT.insert_row(
1125: p_event_date => p_event_date,
1126: p_event_type => p_event_type,
1127: p_event_id => l_event_id,
1128: p_organization_id => l_organization_id,

Line 1152: ROLLBACK TO EAM_ASSET_LOG_PVT;

1148: p_data => x_msg_data
1149: );
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO EAM_ASSET_LOG_PVT;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: fnd_msg_pub.get
1155: ( p_msg_index_out => x_msg_count ,
1156: p_data => x_msg_data

Line 1159: ROLLBACK TO EAM_ASSET_LOG_PVT;

1155: ( p_msg_index_out => x_msg_count ,
1156: p_data => x_msg_data
1157: );
1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1159: ROLLBACK TO EAM_ASSET_LOG_PVT;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: fnd_msg_pub.get
1162: ( p_msg_index_out => x_msg_count ,
1163: p_data => x_msg_data

Line 1166: ROLLBACK TO EAM_ASSET_LOG_PVT;

1162: ( p_msg_index_out => x_msg_count ,
1163: p_data => x_msg_data
1164: );
1165: WHEN OTHERS THEN
1166: ROLLBACK TO EAM_ASSET_LOG_PVT;
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168:
1169: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1170: fnd_msg_pub.add_exc_msg

Line 1228: SAVEPOINT EAM_ASSET_LOG_PVT_SV;

1224: WHERE caa.counter_id = p_ref_id AND
1225: cii.instance_id = caa.source_object_id;
1226: BEGIN
1227: -- Standard Start of API savepoint
1228: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
1229:
1230: -- Standard call to check for call compatibility.
1231: IF NOT fnd_api.compatible_api_call(
1232: l_api_version

Line 1297: EAM_ASSET_LOG_PVT.validate_event(

1293: SELECT maint_organization_id INTO l_organization_id
1294: FROM mtl_parameters
1295: WHERE organization_id = l_cmetid.org_id;
1296:
1297: EAM_ASSET_LOG_PVT.validate_event(
1298: p_event_date => p_event_date,
1299: p_event_type => l_event_type,
1300: p_event_id => l_event_id,
1301: p_instance_id => l_instance_id,

Line 1312: EAM_ASSET_LOG_PVT.insert_row(

1308: IF x_return_status = fnd_api.g_ret_sts_success THEN
1309:
1310: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
1311:
1312: EAM_ASSET_LOG_PVT.insert_row(
1313: p_event_date => p_event_date,
1314: p_event_type => l_event_type,
1315: p_event_id => l_event_id,
1316: p_organization_id => l_organization_id,

Line 1340: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

1336: ,p_data => x_msg_data);
1337:
1338: EXCEPTION
1339: WHEN fnd_api.g_exc_error THEN
1340: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: fnd_msg_pub.count_and_get(
1343: p_count => x_msg_count
1344: ,p_data => x_msg_data);

Line 1346: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

1342: fnd_msg_pub.count_and_get(
1343: p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1347: x_return_status := fnd_api.g_ret_sts_unexp_error;
1348: fnd_msg_pub.count_and_get(
1349: p_count => x_msg_count
1350: ,p_data => x_msg_data);

Line 1352: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

1348: fnd_msg_pub.count_and_get(
1349: p_count => x_msg_count
1350: ,p_data => x_msg_data);
1351: WHEN OTHERS THEN
1352: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1353: x_return_status := fnd_api.g_ret_sts_unexp_error;
1354:
1355: IF fnd_msg_pub.check_msg_level(
1356: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1366: END EAM_ASSET_LOG_PVT;

1362: p_data => x_msg_data);
1363:
1364: END insert_meter_log;
1365:
1366: END EAM_ASSET_LOG_PVT;