[Home] [Help]
1: PACKAGE BODY EAM_ASSET_OPERATION_TXN_PUB AS
2: /* $Header: EAMPACHB.pls 120.1 2005/07/04 09:53:43 ksiddhar noship $ */
3: /*
4: --Start of comments
5: -- API name : EAM_ASSET_OPERATION_TXN_PUB
1: PACKAGE BODY EAM_ASSET_OPERATION_TXN_PUB AS
2: /* $Header: EAMPACHB.pls 120.1 2005/07/04 09:53:43 ksiddhar noship $ */
3: /*
4: --Start of comments
5: -- API name : EAM_ASSET_OPERATION_TXN_PUB
6: -- Type : Public
7: -- Function : Insert and validation of the checkin/checkout transaction data
8: -- Pre-reqs : None.
9: */
52: p_comments IN varchar2 := NULL,
53: p_qa_collection_id IN number := NULL,
54: p_operable_flag IN number,
55: p_employee_id IN number,
56: p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
57: p_meter_reading_rec_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
58: p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
59: p_attribute_category IN varchar2 := NULL,
60: p_attribute1 IN varchar2 := NULL,
53: p_qa_collection_id IN number := NULL,
54: p_operable_flag IN number,
55: p_employee_id IN number,
56: p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
57: p_meter_reading_rec_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
58: p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
59: p_attribute_category IN varchar2 := NULL,
60: p_attribute1 IN varchar2 := NULL,
61: p_attribute2 IN varchar2 := NULL,
54: p_operable_flag IN number,
55: p_employee_id IN number,
56: p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
57: p_meter_reading_rec_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
58: p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
59: p_attribute_category IN varchar2 := NULL,
60: p_attribute1 IN varchar2 := NULL,
61: p_attribute2 IN varchar2 := NULL,
62: p_attribute3 IN varchar2 := NULL,
78: )
79: IS
80:
81:
82: l_api_name constant varchar2(30) :='EAM_ASSET_OPERATION_TXN_PUB';
83: l_api_version constant number := 1.0;
84: g_pkg_name constant varchar2(30) :='EAM_ASSET_OPERATION_TXN_PUB';
85:
86:
80:
81:
82: l_api_name constant varchar2(30) :='EAM_ASSET_OPERATION_TXN_PUB';
83: l_api_version constant number := 1.0;
84: g_pkg_name constant varchar2(30) :='EAM_ASSET_OPERATION_TXN_PUB';
85:
86:
87:
88: BEGIN
89:
90:
91: /* Standard Start of API savepoint */
92:
93: SAVEPOINT EAM_ASSET_OPERATION_TXN_PUB;
94:
95: /* Standard call to check for call compatibility. */
96: IF NOT
97: FND_API.Compatible_API_Call(
155: );
156:
157:
158: IF x_return_status <> fnd_api.g_ret_sts_success THEN
159: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PUB;
160: RETURN;
161: END IF;
162: /* Standard check of p_commit. */
163:
174:
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PUB;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180:
181: FND_MSG_PUB.Get
182: ( p_msg_index_out => x_msg_count ,
183: p_data => x_msg_data
184: );
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PUB;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: FND_MSG_PUB.get
190: ( p_msg_index_out => x_msg_count ,
191: p_data => x_msg_data
191: p_data => x_msg_data
192: );
193:
194: WHEN OTHERS THEN
195: ROLLBACK TO EAM_ASSET_OPERATION_TXN_PUB;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:
198: IF FND_MSG_PUB.Check_Msg_Level
199: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: FND_FILE.PUT_LINE(FND_FILE.LOG, info);
234:
235: END print_log;
236:
237: END EAM_ASSET_OPERATION_TXN_PUB;