29: BEGIN
30:
31: SAVEPOINT SUBMIT_PERIOD_REVERSAL;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: -- customer pre-processing
36:
37:
65: -- End of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PVT.SUBMIT_PERIOD_REVERSAL
66:
67:
68: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
67:
68: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74: l_request_id := x_request_id;
75:
78:
79:
80: EXCEPTION
81:
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
80: EXCEPTION
81:
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);
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
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
88: ,p_data => x_msg_data);
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:
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:
105: END SUBMIT_PERIOD_REVERSAL;
106:
107:
129: BEGIN
130:
131: SAVEPOINT REVERSE_ENTRIES;
132:
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135: -- customer pre-processing
136:
137:
165: -- End of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PVT.REVERSE_ENTRIES
166:
167:
168: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
167:
168: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174:
175:
176:
177:
178: EXCEPTION
179:
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
178: EXCEPTION
179:
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);
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
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
186: ,p_data => x_msg_data);
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:
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:
203:
204: END REVERSE_ENTRIES;
205:
231: BEGIN
232:
233: SAVEPOINT REVERSE_ENTRIES;
234:
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: -- customer pre-processing
238:
239:
266: -- End of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PVT.REVERSE_ENTRIES
267:
268:
269: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
268:
269: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275:
276:
277:
278:
279: EXCEPTION
280:
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
279: EXCEPTION
280:
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);
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
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
287: ,p_data => x_msg_data);
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:
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:
304:
305: END REVERSE_ENTRIES;
306: