87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90:
91: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
92: ,p_count => x_msg_count
93: ,p_data => x_msg_data);
94: RETURN l_request_id;
95:
94: RETURN l_request_id;
95:
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
99: ,p_count => x_msg_count
100: ,p_data => x_msg_data);
101: RETURN l_request_id;
102:
100: ,p_data => x_msg_data);
101: RETURN l_request_id;
102:
103: WHEN OTHERS THEN
104: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SUBMIT_GENERAL_LOSS');
105: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
106: ,p_count => x_msg_count
107: ,p_data => x_msg_data);
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: RETURN l_request_id;
102:
103: WHEN OTHERS THEN
104: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SUBMIT_GENERAL_LOSS');
105: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
106: ,p_count => x_msg_count
107: ,p_data => x_msg_data);
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: RETURN l_request_id;
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: x_return_status := FND_API.G_RET_STS_ERROR;
157:
158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
160: ,p_data => x_msg_data);
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
165: ,p_count => x_msg_count
166: ,p_data => x_msg_data);
167:
168: WHEN OTHERS THEN
165: ,p_count => x_msg_count
166: ,p_data => x_msg_data);
167:
168: WHEN OTHERS THEN
169: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SPECIFIC_LOSS_PROVISION');
170: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
171: ,p_count => x_msg_count
172: ,p_data => x_msg_data);
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: ,p_data => x_msg_data);
167:
168: WHEN OTHERS THEN
169: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SPECIFIC_LOSS_PROVISION');
170: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
171: ,p_count => x_msg_count
172: ,p_data => x_msg_data);
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ,p_data => x_msg_data);
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
240: ,p_count => x_msg_count
241: ,p_data => x_msg_data);
242:
243: WHEN OTHERS THEN
240: ,p_count => x_msg_count
241: ,p_data => x_msg_data);
242:
243: WHEN OTHERS THEN
244: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SPECIFIC_LOSS_PROVISION');
245: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
246: ,p_count => x_msg_count
247: ,p_data => x_msg_data);
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: ,p_data => x_msg_data);
242:
243: WHEN OTHERS THEN
244: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SPECIFIC_LOSS_PROVISION');
245: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
246: ,p_count => x_msg_count
247: ,p_data => x_msg_data);
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: