183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK TO Get_contract_lines;
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => fnd_api.g_false );
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO Get_contract_lines;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
195: p_data => x_msg_data ,
196: p_encoded => fnd_api.g_false );
197:
198: WHEN OTHERS THEN
197:
198: WHEN OTHERS THEN
199: ROLLBACK TO Get_contract_lines;
200: x_return_status := FND_API.G_RET_STS_unexp_error ;
201: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
202: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
203: END IF;
204: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,p_data => x_msg_data ,p_encoded => fnd_api.g_false );
205:
198: WHEN OTHERS THEN
199: ROLLBACK TO Get_contract_lines;
200: x_return_status := FND_API.G_RET_STS_unexp_error ;
201: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
202: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
203: END IF;
204: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,p_data => x_msg_data ,p_encoded => fnd_api.g_false );
205:
206: END Get_Contract_Lines;
200: x_return_status := FND_API.G_RET_STS_unexp_error ;
201: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
202: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
203: END IF;
204: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,p_data => x_msg_data ,p_encoded => fnd_api.g_false );
205:
206: END Get_Contract_Lines;
207:
208: END CS_Est_Apply_Contract_PKG;