82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO SUBMIT_PERIOD_REVERSAL;
84: x_return_status := FND_API.G_RET_STS_ERROR;
85:
86: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
87: ,p_count => x_msg_count
88: ,p_data => x_msg_data);
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: ROLLBACK TO SUBMIT_PERIOD_REVERSAL;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
94: ,p_count => x_msg_count
95: ,p_data => x_msg_data);
96:
97: WHEN OTHERS THEN
95: ,p_data => x_msg_data);
96:
97: WHEN OTHERS THEN
98:
99: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','SUBMIT_PERIOD_REVERSAL');
100: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
101: ,p_count => x_msg_count
102: ,p_data => x_msg_data);
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96:
97: WHEN OTHERS THEN
98:
99: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','SUBMIT_PERIOD_REVERSAL');
100: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
101: ,p_count => x_msg_count
102: ,p_data => x_msg_data);
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104:
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO REVERSE_ENTRIES;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183:
184: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
185: ,p_count => x_msg_count
186: ,p_data => x_msg_data);
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO REVERSE_ENTRIES;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
192: ,p_count => x_msg_count
193: ,p_data => x_msg_data);
194:
195: WHEN OTHERS THEN
193: ,p_data => x_msg_data);
194:
195: WHEN OTHERS THEN
196:
197: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','REVERSE_ENTRIES');
198: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
199: ,p_count => x_msg_count
200: ,p_data => x_msg_data);
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: WHEN OTHERS THEN
196:
197: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','REVERSE_ENTRIES');
198: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
199: ,p_count => x_msg_count
200: ,p_data => x_msg_data);
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202:
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO REVERSE_ENTRIES;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO REVERSE_ENTRIES;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
297:
298: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','REVERSE_ENTRIES');
299: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295:
296: WHEN OTHERS THEN
297:
298: FND_MSG_PUB.ADD_EXC_MSG('OKL_REVERSAL_PUB','REVERSE_ENTRIES');
299: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: