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

Line 1: PACKAGE BODY EAM_ASSET_LOG_PVT AS

1: PACKAGE BODY EAM_ASSET_LOG_PVT AS
2: /* $Header: EAMVALGB.pls 120.24 2006/09/12 06:37:40 sshahid noship $ */
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.24 2006/09/12 06:37:40 sshahid noship $ */
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 141: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;

137:
138: IF x_return_status = fnd_api.g_ret_sts_success THEN
139:
140: IF (p_log_id IS NULL) THEN
141: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
142: ELSE
143: l_log_id:=p_log_id;
144: END IF;
145:

Line 147: INTO eam_asset_log

143: l_log_id:=p_log_id;
144: END IF;
145:
146: INSERT
147: INTO eam_asset_log
148: (
149: log_id,
150: event_date,
151: event_type,

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 578: l_statement := 'DELETE FROM eam_asset_log eal WHERE eal.organization_id = :1';

574:
575: RETURN;
576: end;
577:
578: l_statement := 'DELETE FROM eam_asset_log eal WHERE eal.organization_id = :1';
579:
580: IF p_start_date is not null then
581: l_statement := l_statement || ' AND eal.event_date >= '||''''||l_start_date||'''' ;
582: END IF;

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 674: SAVEPOINT EAM_ASSET_LOG_PVT;

670:
671: BEGIN
672:
673: /* Standard Start of API savepoint */
674: SAVEPOINT EAM_ASSET_LOG_PVT;
675:
676: /* Standard call to check for call compatibility. */
677: IF NOT FND_API.Compatible_API_Call
678: ( l_api_version ,

Line 780: EAM_ASSET_LOG_PVT.insert_row(

776: END IF;
777:
778: IF l_event_id IS NOT NULL THEN
779:
780: EAM_ASSET_LOG_PVT.insert_row(
781: p_event_date => p_event_date,
782: p_event_type => p_event_type,
783: p_event_id => l_event_id,
784: p_organization_id => l_organization_id,

Line 808: ROLLBACK TO EAM_ASSET_LOG_PVT;

804: p_data => x_msg_data
805: );
806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO EAM_ASSET_LOG_PVT;
809: x_return_status := FND_API.G_RET_STS_ERROR ;
810: fnd_msg_pub.get
811: ( p_msg_index_out => x_msg_count ,
812: p_data => x_msg_data

Line 815: ROLLBACK TO EAM_ASSET_LOG_PVT;

811: ( p_msg_index_out => x_msg_count ,
812: p_data => x_msg_data
813: );
814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
815: ROLLBACK TO EAM_ASSET_LOG_PVT;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: fnd_msg_pub.get
818: ( p_msg_index_out => x_msg_count ,
819: p_data => x_msg_data

Line 822: ROLLBACK TO EAM_ASSET_LOG_PVT;

818: ( p_msg_index_out => x_msg_count ,
819: p_data => x_msg_data
820: );
821: WHEN OTHERS THEN
822: ROLLBACK TO EAM_ASSET_LOG_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824:
825: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
826: fnd_msg_pub.add_exc_msg

Line 884: SAVEPOINT EAM_ASSET_LOG_PVT_SV;

880: WHERE caa.counter_id = p_ref_id AND
881: cii.instance_id = caa.source_object_id;
882: BEGIN
883: -- Standard Start of API savepoint
884: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
885:
886: -- Standard call to check for call compatibility.
887: IF NOT fnd_api.compatible_api_call(
888: l_api_version

Line 953: EAM_ASSET_LOG_PVT.validate_event(

949: SELECT maint_organization_id INTO l_organization_id
950: FROM mtl_parameters
951: WHERE organization_id = l_cmetid.org_id;
952:
953: EAM_ASSET_LOG_PVT.validate_event(
954: p_event_date => p_event_date,
955: p_event_type => l_event_type,
956: p_event_id => l_event_id,
957: p_instance_id => l_instance_id,

Line 966: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;

962:
963:
964: IF x_return_status = fnd_api.g_ret_sts_success THEN
965:
966: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
967:
968: EAM_ASSET_LOG_PVT.insert_row(
969: p_event_date => p_event_date,
970: p_event_type => l_event_type,

Line 968: EAM_ASSET_LOG_PVT.insert_row(

964: IF x_return_status = fnd_api.g_ret_sts_success THEN
965:
966: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
967:
968: EAM_ASSET_LOG_PVT.insert_row(
969: p_event_date => p_event_date,
970: p_event_type => l_event_type,
971: p_event_id => l_event_id,
972: p_organization_id => l_organization_id,

Line 996: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

992: ,p_data => x_msg_data);
993:
994: EXCEPTION
995: WHEN fnd_api.g_exc_error THEN
996: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_msg_pub.count_and_get(
999: p_count => x_msg_count
1000: ,p_data => x_msg_data);

Line 1002: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

998: fnd_msg_pub.count_and_get(
999: p_count => x_msg_count
1000: ,p_data => x_msg_data);
1001: WHEN fnd_api.g_exc_unexpected_error THEN
1002: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_msg_pub.count_and_get(
1005: p_count => x_msg_count
1006: ,p_data => x_msg_data);

Line 1008: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;

1004: fnd_msg_pub.count_and_get(
1005: p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007: WHEN OTHERS THEN
1008: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010:
1011: IF fnd_msg_pub.check_msg_level(
1012: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1022: END EAM_ASSET_LOG_PVT;

1018: p_data => x_msg_data);
1019:
1020: END insert_meter_log;
1021:
1022: END EAM_ASSET_LOG_PVT;