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