DBA Data[Home] [Help]

APPS.EAM_ASSET_OPERATION_TXN_PVT dependencies on EAM_ASSET_OPERATION_TXN_PVT

Line 1: PACKAGE BODY EAM_ASSET_OPERATION_TXN_PVT AS

1: PACKAGE BODY EAM_ASSET_OPERATION_TXN_PVT AS
2: /* $Header: EAMVACHB.pls 120.13.12020000.2 2012/07/05 10:55:32 vpasupur ship $ */
3: /*#
4: * This package is used for the ASSET CHECKIN/CHECKOUT transaction logging AND validation .
5: * It defines procedures which take quality collection plans and meter readings as input

Line 85: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_OPERATION_TXN_PVT';

81:
82: l_eam_ops_quality_tbl eam_asset_operation_txn_pub.eam_quality_tbl_type;
83: l_eam_meter_reading_tbl eam_asset_operation_txn_pub.meter_reading_rec_tbl_type;
84: l_eam_counter_properties_tbl eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl;
85: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_OPERATION_TXN_PVT';
86: l_api_name constant varchar2(30) := 'process_checkinout_txn';
87: l_api_version constant number := 1.0;
88:
89:

Line 94: SAVEPOINT EAM_ASSET_OPERATION_TXN_PVT;

90:
91: BEGIN
92:
93: -- Standard Start of API savepoint
94: SAVEPOINT EAM_ASSET_OPERATION_TXN_PVT;
95:
96: -- Standard call to check for call compatibility.
97: IF NOT fnd_api.compatible_api_call(
98: l_api_version

Line 111: EAM_ASSET_OPERATION_TXN_PVT.insert_txn(

107: END IF;
108:
109: x_return_status := fnd_api.g_ret_sts_success;
110:
111: EAM_ASSET_OPERATION_TXN_PVT.insert_txn(
112: p_txn_date => p_txn_date,
113: p_txn_type => p_txn_type,
114: p_instance_id => p_instance_id,
115: p_comments => p_comments,

Line 144: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;

140: x_msg_data => x_msg_data
141: );
142:
143: IF x_return_status <> fnd_api.g_ret_sts_success THEN
144: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;
145: RETURN;
146: END IF;
147:
148: -- Standard check of p_commit.

Line 157: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;

153: p_count => x_msg_count
154: ,p_data => x_msg_data);
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;
158: x_return_status := fnd_api.g_ret_sts_error;
159: fnd_msg_pub.count_and_get(
160: p_count => x_msg_count
161: ,p_data => x_msg_data);

Line 163: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;

159: fnd_msg_pub.count_and_get(
160: p_count => x_msg_count
161: ,p_data => x_msg_data);
162: WHEN fnd_api.g_exc_unexpected_error THEN
163: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: fnd_msg_pub.count_and_get(
166: p_count => x_msg_count
167: ,p_data => x_msg_data);

Line 169: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;

165: fnd_msg_pub.count_and_get(
166: p_count => x_msg_count
167: ,p_data => x_msg_data);
168: WHEN OTHERS THEN
169: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT;
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171:
172: IF fnd_msg_pub.check_msg_level(
173: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 620: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_OPERATION_TXN_PVT';

616: l_api_version constant number := 1.0;
617: l_last_txn_date date;
618: l_txn_type number;
619: l_count number;
620: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_OPERATION_TXN_PVT';
621:
622:
623: BEGIN
624:

Line 627: SAVEPOINT EAM_ASSET_OPERATION_TXN_PVT_SV;

623: BEGIN
624:
625:
626: -- Standard Start of API savepoint
627: SAVEPOINT EAM_ASSET_OPERATION_TXN_PVT_SV;
628: -- Standard call to check for call compatibility.
629:
630: IF NOT fnd_api.compatible_api_call(
631: l_api_version

Line 823: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT_SV;

819:
820: EXCEPTION
821:
822: WHEN fnd_api.g_exc_error THEN
823: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT_SV;
824: x_return_status := fnd_api.g_ret_sts_error;
825: fnd_msg_pub.count_and_get(
826: p_count => x_msg_count
827: ,p_data => x_msg_data);

Line 830: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT_SV;

826: p_count => x_msg_count
827: ,p_data => x_msg_data);
828:
829: WHEN fnd_api.g_exc_unexpected_error THEN
830: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT_SV;
831: x_return_status := fnd_api.g_ret_sts_unexp_error;
832: fnd_msg_pub.count_and_get(
833: p_count => x_msg_count
834: ,p_data => x_msg_data);

Line 838: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT_SV;

834: ,p_data => x_msg_data);
835:
836: WHEN OTHERS THEN
837:
838: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PVT_SV;
839: x_return_status := fnd_api.g_ret_sts_unexp_error;
840: IF fnd_msg_pub.check_msg_level(
841: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
842: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 923: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_OPERATION_TXN_PVT';

919: l_count number :=1;
920: l_list_of_plans varchar2(1000);
921: l_validate boolean;
922: l_mandatory_qua_plan varchar2(1);
923: g_pkg_name CONSTANT varchar2(30) := 'EAM_ASSET_OPERATION_TXN_PVT';
924: l_object_version_number number;
925: eaot_api_call_error EXCEPTION;
926: eaot_api_desc_error EXCEPTION;
927: TYPE num_table is TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1016: EAM_ASSET_OPERATION_TXN_PVT.validate_txn(

1012: END;
1013:
1014: --call validate_txn to validate txn_details
1015:
1016: EAM_ASSET_OPERATION_TXN_PVT.validate_txn(
1017: p_api_version => 1.0,
1018: p_init_msg_list => p_init_msg_list,
1019: p_validation_level => p_validation_level,
1020: p_txn_date => p_txn_date,

Line 1496: END EAM_ASSET_OPERATION_TXN_PVT;

1492: p_data => x_msg_data);
1493:
1494: END insert_txn;
1495:
1496: END EAM_ASSET_OPERATION_TXN_PVT;