106: x_return_status,
107: x_msg_count,
108: x_msg_data);
109: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
110: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
111: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
114: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
107: x_msg_count,
108: x_msg_data);
109: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
110: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
111: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
114: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
115: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
110: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
111: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
114: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
115: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118: ELSE
111: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
114: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
115: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118: ELSE
119: l_coverage_id := p_coverage_id;
130: INTO x_flat_rate,
131: x_percent_rate;
132:
133: -- IF Bill_Rate_Null_UOM_Csr%NOTFOUND THEN
134: -- FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
135: -- FND_MESSAGE.Set_Token('VALUE','BILL RATES');
136: -- RAISE FND_API.G_EXC_ERROR;
137: -- END IF;
138:
131: x_percent_rate;
132:
133: -- IF Bill_Rate_Null_UOM_Csr%NOTFOUND THEN
134: -- FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
135: -- FND_MESSAGE.Set_Token('VALUE','BILL RATES');
136: -- RAISE FND_API.G_EXC_ERROR;
137: -- END IF;
138:
139: CLOSE Bill_Rate_Null_UOM_Csr;
251: x_return_status,
252: x_msg_count,
253: x_msg_data);
254: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
255: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
256: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
259: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
252: x_msg_count,
253: x_msg_data);
254: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
255: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
256: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
259: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
260: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
255: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
256: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
259: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
260: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263: ELSE
256: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
259: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
260: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263: ELSE
264: l_coverage_id := p_coverage_id;
269: INTO x_Preferred_Engineer1,
270: x_Preferred_Engineer2;
271:
272: IF Preferred_Engineer_csr%NOTFOUND THEN
273: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
274: FND_MESSAGE.Set_Token('VALUE','PREFERRED ENGINEER');
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: CLOSE Preferred_Engineer_csr;
270: x_Preferred_Engineer2;
271:
272: IF Preferred_Engineer_csr%NOTFOUND THEN
273: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
274: FND_MESSAGE.Set_Token('VALUE','PREFERRED ENGINEER');
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: CLOSE Preferred_Engineer_csr;
278:
363: OPEN Exception_Coverage_csr;
364: FETCH Exception_Coverage_csr INTO x_exception_coverage_id;
365:
366: IF Exception_coverage_csr%NOTFOUND THEN
367: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
368: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371: CLOSE Exception_Coverage_csr;
364: FETCH Exception_Coverage_csr INTO x_exception_coverage_id;
365:
366: IF Exception_coverage_csr%NOTFOUND THEN
367: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
368: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371: CLOSE Exception_Coverage_csr;
372: