APPS.OKL_CSH_ALLCTN_RL_HDR_PUB dependencies on FND_API

Line 52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

48: ,lp_cauv_rec
49: ,lx_cauv_rec);
50: -- Private API Call start
51:
52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;

Line 53: RAISE FND_API.G_EXC_ERROR;

49: ,lx_cauv_rec);
50: -- Private API Call start
51:
52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:

Line 54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

50: -- Private API Call start
51:
52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: --Copy value of OUT variable in the IN record type

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51:
52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: --Copy value of OUT variable in the IN record type
59: lp_cauv_rec := lx_cauv_rec;

Line 73: WHEN FND_API.G_EXC_ERROR THEN

69: x_msg_data := l_msg_data ;
70:
71: EXCEPTION
72:
73: WHEN FND_API.G_EXC_ERROR THEN
74: ROLLBACK TO csh_allctn_rl_hdr_insert;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: EXCEPTION
72:
73: WHEN FND_API.G_EXC_ERROR THEN
74: ROLLBACK TO csh_allctn_rl_hdr_insert;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count

Line 81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

77: x_msg_data := l_msg_data ;
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: ROLLBACK TO csh_allctn_rl_hdr_insert;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: ROLLBACK TO csh_allctn_rl_hdr_insert;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: FND_MSG_PUB.count_and_get(
87: p_count => x_msg_count

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

87: p_count => x_msg_count
88: ,p_data => x_msg_data);
89: WHEN OTHERS THEN
90: ROLLBACK TO csh_allctn_rl_hdr_insert;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','insert_csh_allctn_rl_hdr');
95: FND_MSG_PUB.count_and_get(

Line 149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

145: ,lp_cauv_tbl
146: ,lx_cauv_tbl);
147: -- Private API Call end
148:
149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
150: RAISE FND_API.G_EXC_ERROR;
151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;

Line 150: RAISE FND_API.G_EXC_ERROR;

146: ,lx_cauv_tbl);
147: -- Private API Call end
148:
149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
150: RAISE FND_API.G_EXC_ERROR;
151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:

Line 151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

147: -- Private API Call end
148:
149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
150: RAISE FND_API.G_EXC_ERROR;
151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:
155: --Copy value of OUT variable in the IN record type

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

148:
149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
150: RAISE FND_API.G_EXC_ERROR;
151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:
155: --Copy value of OUT variable in the IN record type
156: lp_cauv_tbl := lx_cauv_tbl;

Line 169: WHEN FND_API.G_EXC_ERROR THEN

165:
166:
167: EXCEPTION
168:
169: WHEN FND_API.G_EXC_ERROR THEN
170: ROLLBACK TO csh_allctn_rl_hdr_insert;
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: EXCEPTION
168:
169: WHEN FND_API.G_EXC_ERROR THEN
170: ROLLBACK TO csh_allctn_rl_hdr_insert;
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.count_and_get(
175: p_count => x_msg_count

Line 177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.count_and_get(
175: p_count => x_msg_count
176: ,p_data => x_msg_data);
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO csh_allctn_rl_hdr_insert;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: x_msg_count := l_msg_count ;
181: x_msg_data := l_msg_data ;

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175: p_count => x_msg_count
176: ,p_data => x_msg_data);
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO csh_allctn_rl_hdr_insert;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: x_msg_count := l_msg_count ;
181: x_msg_data := l_msg_data ;
182: FND_MSG_PUB.count_and_get(
183: p_count => x_msg_count

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: p_count => x_msg_count
184: ,p_data => x_msg_data);
185: WHEN OTHERS THEN
186: ROLLBACK TO csh_allctn_rl_hdr_insert;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: x_msg_count := l_msg_count ;
189: x_msg_data := l_msg_data ;
190: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','insert_csh_allctn_rl_hdr');
191: FND_MSG_PUB.count_and_get(

Line 213: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

209: x_msg_count,
210: x_msg_data,
211: p_cauv_rec);
212:
213: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
214: RAISE FND_API.G_EXC_ERROR;
215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;

Line 214: RAISE FND_API.G_EXC_ERROR;

210: x_msg_data,
211: p_cauv_rec);
212:
213: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
214: RAISE FND_API.G_EXC_ERROR;
215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:

Line 215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

211: p_cauv_rec);
212:
213: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
214: RAISE FND_API.G_EXC_ERROR;
215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:
219:

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212:
213: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
214: RAISE FND_API.G_EXC_ERROR;
215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:
219:
220: EXCEPTION

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218:
219:
220: EXCEPTION
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: FND_MSG_PUB.count_and_get(
224: p_count => x_msg_count
225: ,p_data => x_msg_data);
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: WHEN FND_API.G_EXC_ERROR THEN
223: FND_MSG_PUB.count_and_get(
224: p_count => x_msg_count
225: ,p_data => x_msg_data);
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: FND_MSG_PUB.count_and_get(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230: WHEN OTHERS THEN

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

227: FND_MSG_PUB.count_and_get(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230: WHEN OTHERS THEN
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','lock_csh_allctn_rl_hdr');
233: FND_MSG_PUB.count_and_get(
234: p_count => x_msg_count
235: ,p_data => x_msg_data);

Line 255: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

251: x_msg_count,
252: x_msg_data,
253: p_cauv_tbl);
254:
255: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;

Line 256: RAISE FND_API.G_EXC_ERROR;

252: x_msg_data,
253: p_cauv_tbl);
254:
255: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260:

Line 257: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

253: p_cauv_tbl);
254:
255: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260:
261:

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

254:
255: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260:
261:
262: EXCEPTION

Line 264: WHEN FND_API.G_EXC_ERROR THEN

260:
261:
262: EXCEPTION
263:
264: WHEN FND_API.G_EXC_ERROR THEN
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

264: WHEN FND_API.G_EXC_ERROR THEN
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: FND_MSG_PUB.count_and_get(
270: p_count => x_msg_count
271: ,p_data => x_msg_data);
272: WHEN OTHERS THEN

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: FND_MSG_PUB.count_and_get(
270: p_count => x_msg_count
271: ,p_data => x_msg_data);
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','lock_csh_allctn_rl_hdr');
275: FND_MSG_PUB.count_and_get(
276: p_count => x_msg_count
277: ,p_data => x_msg_data);

Line 325: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

321: ,lp_cauv_rec
322: ,lx_cauv_rec);
323: -- Private API Call end
324:
325: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;

Line 326: RAISE FND_API.G_EXC_ERROR;

322: ,lx_cauv_rec);
323: -- Private API Call end
324:
325: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:

Line 327: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

323: -- Private API Call end
324:
325: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: --Copy value of OUT variable in the IN record type

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324:
325: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: --Copy value of OUT variable in the IN record type
332: lp_cauv_rec := lx_cauv_rec;

Line 346: WHEN FND_API.G_EXC_ERROR THEN

342:
343:
344: EXCEPTION
345:
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO csh_allctn_rl_hdr_update;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: x_msg_count := l_msg_count ;
350: x_msg_data := l_msg_data ;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344: EXCEPTION
345:
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO csh_allctn_rl_hdr_update;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: x_msg_count := l_msg_count ;
350: x_msg_data := l_msg_data ;
351: FND_MSG_PUB.count_and_get(
352: p_count => x_msg_count

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

350: x_msg_data := l_msg_data ;
351: FND_MSG_PUB.count_and_get(
352: p_count => x_msg_count
353: ,p_data => x_msg_data);
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO csh_allctn_rl_hdr_update;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_msg_count := l_msg_count ;
358: x_msg_data := l_msg_data ;

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: p_count => x_msg_count
353: ,p_data => x_msg_data);
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO csh_allctn_rl_hdr_update;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_msg_count := l_msg_count ;
358: x_msg_data := l_msg_data ;
359: FND_MSG_PUB.count_and_get(
360: p_count => x_msg_count

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: p_count => x_msg_count
361: ,p_data => x_msg_data);
362: WHEN OTHERS THEN
363: ROLLBACK TO csh_allctn_rl_hdr_update;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: x_msg_count := l_msg_count ;
366: x_msg_data := l_msg_data ;
367: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','update_csh_allctn_rl_hdr');
368: FND_MSG_PUB.count_and_get(

Line 417: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

413: ,lp_cauv_tbl
414: ,lx_cauv_tbl);
415: -- Private API Call end
416:
417: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: ,lx_cauv_tbl);
415: -- Private API Call end
416:
417: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:

Line 419: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

415: -- Private API Call end
416:
417: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:
423: --Copy value of OUT variable in the IN record type

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416:
417: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:
423: --Copy value of OUT variable in the IN record type
424: lp_cauv_tbl := lx_cauv_tbl;

Line 437: WHEN FND_API.G_EXC_ERROR THEN

433:
434:
435: EXCEPTION
436:
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO csh_allctn_rl_hdr_update;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_msg_count := l_msg_count ;
441: x_msg_data := l_msg_data ;

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: EXCEPTION
436:
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO csh_allctn_rl_hdr_update;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_msg_count := l_msg_count ;
441: x_msg_data := l_msg_data ;
442: FND_MSG_PUB.count_and_get(
443: p_count => x_msg_count

Line 445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

441: x_msg_data := l_msg_data ;
442: FND_MSG_PUB.count_and_get(
443: p_count => x_msg_count
444: ,p_data => x_msg_data);
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO csh_allctn_rl_hdr_update;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: x_msg_count := l_msg_count ;
449: x_msg_data := l_msg_data ;

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: p_count => x_msg_count
444: ,p_data => x_msg_data);
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO csh_allctn_rl_hdr_update;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: x_msg_count := l_msg_count ;
449: x_msg_data := l_msg_data ;
450: FND_MSG_PUB.count_and_get(
451: p_count => x_msg_count

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451: p_count => x_msg_count
452: ,p_data => x_msg_data);
453: WHEN OTHERS THEN
454: ROLLBACK TO csh_allctn_rl_hdr_update;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: x_msg_count := l_msg_count ;
457: x_msg_data := l_msg_data ;
458: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','update_csh_allctn_rl_hdr');
459: FND_MSG_PUB.count_and_get(

Line 508: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

504: ,l_msg_data
505: ,lp_cauv_rec);
506: -- Private API Call end
507:
508: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
509: RAISE FND_API.G_EXC_ERROR;
510: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;

Line 509: RAISE FND_API.G_EXC_ERROR;

505: ,lp_cauv_rec);
506: -- Private API Call end
507:
508: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
509: RAISE FND_API.G_EXC_ERROR;
510: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:

Line 510: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

506: -- Private API Call end
507:
508: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
509: RAISE FND_API.G_EXC_ERROR;
510: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:
514:

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507:
508: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
509: RAISE FND_API.G_EXC_ERROR;
510: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:
514:
515:

Line 525: WHEN FND_API.G_EXC_ERROR THEN

521: x_return_status := l_return_status ;
522:
523: EXCEPTION
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO csh_allctn_rl_hdr_delete_rec;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: x_msg_count := l_msg_count ;
529: x_msg_data := l_msg_data ;

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: EXCEPTION
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO csh_allctn_rl_hdr_delete_rec;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: x_msg_count := l_msg_count ;
529: x_msg_data := l_msg_data ;
530: FND_MSG_PUB.count_and_get(
531: p_count => x_msg_count

Line 533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

529: x_msg_data := l_msg_data ;
530: FND_MSG_PUB.count_and_get(
531: p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO csh_allctn_rl_hdr_delete_rec;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: x_msg_count := l_msg_count ;
537: x_msg_data := l_msg_data ;

Line 535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

531: p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO csh_allctn_rl_hdr_delete_rec;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: x_msg_count := l_msg_count ;
537: x_msg_data := l_msg_data ;
538: FND_MSG_PUB.count_and_get(
539: p_count => x_msg_count

Line 543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

539: p_count => x_msg_count
540: ,p_data => x_msg_data);
541: WHEN OTHERS THEN
542: ROLLBACK TO csh_allctn_rl_hdr_delete_rec;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: x_msg_count := l_msg_count ;
545: x_msg_data := l_msg_data ;
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','delete_csh_allctn_rl_hdr');
547: FND_MSG_PUB.count_and_get(

Line 602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

598: EXIT WHEN (i = lp_cauv_tbl.LAST);
599: i := p_cauv_tbl.NEXT(i);
600: END LOOP;
601: END IF;
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;

Line 603: RAISE FND_API.G_EXC_ERROR;

599: i := p_cauv_tbl.NEXT(i);
600: END LOOP;
601: END IF;
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:

Line 604: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

600: END LOOP;
601: END IF;
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: END;

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

601: END IF;
602: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: END;
609:

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618: x_return_status := l_return_status ;
619:
620: EXCEPTION
621:
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO csh_allctn_rl_hdr_delete_tbl;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: x_msg_count := l_msg_count ;
626: x_msg_data := l_msg_data ;

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: EXCEPTION
621:
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO csh_allctn_rl_hdr_delete_tbl;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: x_msg_count := l_msg_count ;
626: x_msg_data := l_msg_data ;
627: FND_MSG_PUB.count_and_get(
628: p_count => x_msg_count

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: x_msg_data := l_msg_data ;
627: FND_MSG_PUB.count_and_get(
628: p_count => x_msg_count
629: ,p_data => x_msg_data);
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO csh_allctn_rl_hdr_delete_tbl;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: x_msg_count := l_msg_count ;
634: x_msg_data := l_msg_data ;

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: p_count => x_msg_count
629: ,p_data => x_msg_data);
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO csh_allctn_rl_hdr_delete_tbl;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: x_msg_count := l_msg_count ;
634: x_msg_data := l_msg_data ;
635: FND_MSG_PUB.count_and_get(
636: p_count => x_msg_count

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN OTHERS THEN
639: ROLLBACK TO csh_allctn_rl_hdr_delete_tbl;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: x_msg_count := l_msg_count ;
642: x_msg_data := l_msg_data ;
643: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','delete_csh_allctn_rl_hdr');
644: FND_MSG_PUB.count_and_get(

Line 690: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

686: ,l_msg_data
687: ,lp_cauv_rec);
688: -- Private API Call end
689:
690: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
691: RAISE FND_API.G_EXC_ERROR;
692: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;

Line 691: RAISE FND_API.G_EXC_ERROR;

687: ,lp_cauv_rec);
688: -- Private API Call end
689:
690: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
691: RAISE FND_API.G_EXC_ERROR;
692: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695:

Line 692: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

688: -- Private API Call end
689:
690: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
691: RAISE FND_API.G_EXC_ERROR;
692: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695:
696: --Copy value of OUT variable in the IN record type

Line 693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

689:
690: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
691: RAISE FND_API.G_EXC_ERROR;
692: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695:
696: --Copy value of OUT variable in the IN record type
697: lp_cauv_rec := lx_cauv_rec;

Line 711: WHEN FND_API.G_EXC_ERROR THEN

707: x_return_status := l_return_status ;
708:
709: EXCEPTION
710:
711: WHEN FND_API.G_EXC_ERROR THEN
712: ROLLBACK TO csh_allctn_rl_hdr_validate;
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;

Line 713: x_return_status := FND_API.G_RET_STS_ERROR;

709: EXCEPTION
710:
711: WHEN FND_API.G_EXC_ERROR THEN
712: ROLLBACK TO csh_allctn_rl_hdr_validate;
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.count_and_get(
717: p_count => x_msg_count

Line 719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.count_and_get(
717: p_count => x_msg_count
718: ,p_data => x_msg_data);
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO csh_allctn_rl_hdr_validate;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: x_msg_count := l_msg_count ;
723: x_msg_data := l_msg_data ;

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

717: p_count => x_msg_count
718: ,p_data => x_msg_data);
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO csh_allctn_rl_hdr_validate;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: x_msg_count := l_msg_count ;
723: x_msg_data := l_msg_data ;
724: FND_MSG_PUB.count_and_get(
725: p_count => x_msg_count

Line 729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

725: p_count => x_msg_count
726: ,p_data => x_msg_data);
727: WHEN OTHERS THEN
728: ROLLBACK TO csh_allctn_rl_hdr_validate;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: x_msg_count := l_msg_count ;
731: x_msg_data := l_msg_data ;
732: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','validate_csh_allctn_rl_hdr');
733: FND_MSG_PUB.count_and_get(

Line 777: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

773: ,x_msg_data
774: ,lp_cauv_tbl);
775: -- Private API Call end
776:
777: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
778: RAISE FND_API.G_EXC_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;

Line 778: RAISE FND_API.G_EXC_ERROR;

774: ,lp_cauv_tbl);
775: -- Private API Call end
776:
777: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
778: RAISE FND_API.G_EXC_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:

Line 779: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

775: -- Private API Call end
776:
777: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
778: RAISE FND_API.G_EXC_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783: --Copy value of OUT variable in the IN record type

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776:
777: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
778: RAISE FND_API.G_EXC_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783: --Copy value of OUT variable in the IN record type
784: lp_cauv_tbl := lx_cauv_tbl;

Line 796: WHEN FND_API.G_EXC_ERROR THEN

792: x_return_status := l_return_status ;
793:
794: EXCEPTION
795:
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO csh_allctn_rl_hdr_validate;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;

Line 798: x_return_status := FND_API.G_RET_STS_ERROR;

794: EXCEPTION
795:
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO csh_allctn_rl_hdr_validate;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.count_and_get(
802: p_count => x_msg_count

Line 804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.count_and_get(
802: p_count => x_msg_count
803: ,p_data => x_msg_data);
804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
805: ROLLBACK TO csh_allctn_rl_hdr_validate;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: x_msg_count := l_msg_count ;
808: x_msg_data := l_msg_data ;

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

802: p_count => x_msg_count
803: ,p_data => x_msg_data);
804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
805: ROLLBACK TO csh_allctn_rl_hdr_validate;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: x_msg_count := l_msg_count ;
808: x_msg_data := l_msg_data ;
809: FND_MSG_PUB.count_and_get(
810: p_count => x_msg_count

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

810: p_count => x_msg_count
811: ,p_data => x_msg_data);
812: WHEN OTHERS THEN
813: ROLLBACK TO csh_allctn_rl_hdr_validate;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: x_msg_count := l_msg_count ;
816: x_msg_data := l_msg_data ;
817: FND_MSG_PUB.ADD_EXC_MSG('OKL_CSH_ALLCTN_RL_HDR_PUB','validate_csh_allctn_rl_hdr');
818: FND_MSG_PUB.count_and_get(