18:
19: BEGIN
20: SAVEPOINT insert_provisions;
21:
22: x_return_status := FND_API.G_RET_STS_SUCCESS;
23:
24: -- customer pre-processing
25:
26:
44:
45:
46: EXCEPTION
47:
48: WHEN FND_API.G_EXC_ERROR THEN
49: ROLLBACK TO insert_provisions;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51:
52: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
46: EXCEPTION
47:
48: WHEN FND_API.G_EXC_ERROR THEN
49: ROLLBACK TO insert_provisions;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51:
52: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
53: ,p_count => x_msg_count
54: ,p_data => x_msg_data);
52: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
53: ,p_count => x_msg_count
54: ,p_data => x_msg_data);
55:
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57: ROLLBACK TO insert_provisions;
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
60: ,p_count => x_msg_count
54: ,p_data => x_msg_data);
55:
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57: ROLLBACK TO insert_provisions;
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);
62:
65: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_PROVISIONS_PUB','CREATE_PROVISIONS');
66: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70:
71: END create_provisions;
72:
73:
88:
89: BEGIN
90: SAVEPOINT insert_provisions;
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- customer pre-processing
95:
96:
114:
115:
116: EXCEPTION
117:
118: WHEN FND_API.G_EXC_ERROR THEN
119: ROLLBACK TO insert_provisions;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121:
122: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
116: EXCEPTION
117:
118: WHEN FND_API.G_EXC_ERROR THEN
119: ROLLBACK TO insert_provisions;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121:
122: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
123: ,p_count => x_msg_count
124: ,p_data => x_msg_data);
122: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
123: ,p_count => x_msg_count
124: ,p_data => x_msg_data);
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: ROLLBACK TO insert_provisions;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
130: ,p_count => x_msg_count
124: ,p_data => x_msg_data);
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: ROLLBACK TO insert_provisions;
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
130: ,p_count => x_msg_count
131: ,p_data => x_msg_data);
132:
135: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_PROVISIONS_PUB','CREATE_PROVISIONS');
136: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
137: ,p_count => x_msg_count
138: ,p_data => x_msg_data);
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140:
141: END create_provisions;
142:
143:
157: l_pvnv_rec pvnv_rec_type := p_pvnv_rec;
158:
159: BEGIN
160: SAVEPOINT update_provisions;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162: -- customer pre-processing
163:
164: -- CALL THE MAIN PROCEDURE
165: OKL_PROCESS_PROVISIONS_PVT.UPDATE_PROVISIONS(p_api_version => l_api_version,
178: -- customer post-processing
179:
180: EXCEPTION
181:
182: WHEN FND_API.G_EXC_ERROR THEN
183: ROLLBACK TO update_provisions;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185:
186: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
180: EXCEPTION
181:
182: WHEN FND_API.G_EXC_ERROR THEN
183: ROLLBACK TO update_provisions;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185:
186: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
187: ,p_count => x_msg_count
188: ,p_data => x_msg_data);
186: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
187: ,p_count => x_msg_count
188: ,p_data => x_msg_data);
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO update_provisions;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
194: ,p_count => x_msg_count
188: ,p_data => x_msg_data);
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO update_provisions;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
194: ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196:
199: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_PROVISIONS_PUB','CREATE_PROVISIONS');
200: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
201: ,p_count => x_msg_count
202: ,p_data => x_msg_data);
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204:
205: END update_provisions;
206:
207:
221: l_pvnv_tbl pvnv_tbl_type := p_pvnv_tbl;
222:
223: BEGIN
224: SAVEPOINT update_provisions;
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226: -- customer pre-processing
227:
228: -- CALL THE MAIN PROCEDURE
229: OKL_PROCESS_PROVISIONS_PVT.UPDATE_PROVISIONS(p_api_version => l_api_version,
241:
242: -- customer post-processing
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO update_provisions;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO update_provisions;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
250: ,p_count => x_msg_count
251: ,p_data => x_msg_data);
249: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
250: ,p_count => x_msg_count
251: ,p_data => x_msg_data);
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: ROLLBACK TO update_provisions;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
257: ,p_count => x_msg_count
251: ,p_data => x_msg_data);
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: ROLLBACK TO update_provisions;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
257: ,p_count => x_msg_count
258: ,p_data => x_msg_data);
259:
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_PROVISIONS_PUB','CREATE_PROVISIONS');
263: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
264: ,p_count => x_msg_count
265: ,p_data => x_msg_data);
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: END update_provisions;
269:
270:
283: l_pvnv_rec pvnv_rec_type := p_pvnv_rec;
284:
285: BEGIN
286: SAVEPOINT delete_provisions;
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: -- customer pre-processing
289:
290: -- CALL THE MAIN PROCEDURE
291: OKL_PROCESS_PROVISIONS_PVT.DELETE_PROVISIONS(p_api_version => l_api_version,
302:
303: -- customer post-processing
304:
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: ROLLBACK TO delete_provisions;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309:
310: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
304:
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: ROLLBACK TO delete_provisions;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309:
310: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
311: ,p_count => x_msg_count
312: ,p_data => x_msg_data);
310: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
311: ,p_count => x_msg_count
312: ,p_data => x_msg_data);
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: ROLLBACK TO delete_provisions;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
318: ,p_count => x_msg_count
312: ,p_data => x_msg_data);
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: ROLLBACK TO delete_provisions;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
318: ,p_count => x_msg_count
319: ,p_data => x_msg_data);
320:
323: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_PROVISIONS_PUB','CREATE_PROVISIONS');
324: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
325: ,p_count => x_msg_count
326: ,p_data => x_msg_data);
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:
329: END delete_provisions;
330:
331: PROCEDURE delete_provisions(
344: l_pvnv_tbl pvnv_tbl_type := p_pvnv_tbl;
345:
346: BEGIN
347: SAVEPOINT delete_provisions;
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: -- customer pre-processing
350:
351: -- CALL THE MAIN PROCEDURE
352: OKL_PROCESS_PROVISIONS_PVT.DELETE_PROVISIONS(p_api_version => l_api_version,
363:
364: -- customer post-processing
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: ROLLBACK TO delete_provisions;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370:
371: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: ROLLBACK TO delete_provisions;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370:
371: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
372: ,p_count => x_msg_count
373: ,p_data => x_msg_data);
371: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
372: ,p_count => x_msg_count
373: ,p_data => x_msg_data);
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO delete_provisions;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
379: ,p_count => x_msg_count
373: ,p_data => x_msg_data);
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO delete_provisions;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
379: ,p_count => x_msg_count
380: ,p_data => x_msg_data);
381:
384: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_PROVISIONS_PUB','CREATE_PROVISIONS');
385: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
386: ,p_count => x_msg_count
387: ,p_data => x_msg_data);
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389:
390: END delete_provisions;
391:
392: END OKL_PROCESS_PROVISIONS_PUB;