DBA Data[Home] [Help]

APPS.OKL_PROCESS_PROVISIONS_PUB dependencies on FND_API

Line 22: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 48: WHEN FND_API.G_EXC_ERROR THEN

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

Line 50: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 118: WHEN FND_API.G_EXC_ERROR THEN

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

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,

Line 182: WHEN FND_API.G_EXC_ERROR THEN

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

Line 184: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,

Line 245: WHEN FND_API.G_EXC_ERROR THEN

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

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,

Line 306: WHEN FND_API.G_EXC_ERROR THEN

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

Line 308: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(

Line 348: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,

Line 367: WHEN FND_API.G_EXC_ERROR THEN

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

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;