55: X_MSG_COUNT => l_msg_count,
56: X_MSG_DATA => l_msg_data,
57: X_est_DISCounted_amt_TBL => l_contracts_out_tbl);
58:
59: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
60:
61: FOR k in 1..l_contracts_out_tbl.count LOOP
62:
63: IF l_contracts_out_tbl(1).discounted_amount IS NULL THEN
69: END IF;
70: END LOOP;
71:
72:
73: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
74: x_msg_data := l_msg_data;
75: x_msg_count := l_msg_count;
76: x_return_status := l_return_status;
77:
174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data,
176: x_ent_contracts => x_ent_contracts);
177:
178: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
179: RAISE FND_API.G_EXC_ERROR ;
180: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
182: END IF ;
175: x_msg_data => x_msg_data,
176: x_ent_contracts => x_ent_contracts);
177:
178: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
179: RAISE FND_API.G_EXC_ERROR ;
180: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
182: END IF ;
183: x_return_status := l_return_status;
176: x_ent_contracts => x_ent_contracts);
177:
178: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
179: RAISE FND_API.G_EXC_ERROR ;
180: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
182: END IF ;
183: x_return_status := l_return_status;
184:
177:
178: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
179: RAISE FND_API.G_EXC_ERROR ;
180: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
182: END IF ;
183: x_return_status := l_return_status;
184:
185: EXCEPTION
182: END IF ;
183: x_return_status := l_return_status;
184:
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 ,
184:
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:
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
194: ROLLBACK TO Get_contract_lines;
195: x_return_status := FND_API.G_RET_STS_UNEXP_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
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 ,
191: p_encoded => fnd_api.g_false );
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:
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
201: ROLLBACK TO Get_contract_lines;
202: x_return_status := FND_API.G_RET_STS_unexp_error ;
198: p_encoded => fnd_api.g_false );
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 );
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;