eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CASH_ALLCTN_RLS_PUB dependencies on FND_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

2: /* $Header: OKLPCATB.pls 120.4 2006/07/13 12:20:47 adagur noship $ */
3:
4: PROCEDURE insert_cash_allctn_rls(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_catv_rec IN catv_rec_type

Line 53: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

49: ,l_msg_data
50: ,lp_catv_rec
51: ,lx_catv_rec);
52:
53: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_ERROR;
55: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
56: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
57: END IF;

Line 54: RAISE Fnd_Api.G_EXC_ERROR;

50: ,lp_catv_rec
51: ,lx_catv_rec);
52:
53: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_ERROR;
55: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
56: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:

Line 55: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 56: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

52:
53: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_ERROR;
55: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
56: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: --Copy value of OUT variable in the IN record type
60: lp_catv_rec := lx_catv_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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_CASH_ALLCTN_RLS_PUB','insert_cash_allctn_rls');
95: Fnd_Msg_Pub.count_and_get(

Line 102: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

98: END insert_cash_allctn_rls;
99:
100: PROCEDURE insert_cash_allctn_rls(
101: p_api_version IN NUMBER
102: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
106: ,p_catv_tbl IN catv_tbl_type

Line 146: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

142: ,l_msg_data
143: ,lp_catv_tbl
144: ,lx_catv_tbl);
145:
146: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_ERROR;
148: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
149: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
150: END IF;

Line 147: RAISE Fnd_Api.G_EXC_ERROR;

143: ,lp_catv_tbl
144: ,lx_catv_tbl);
145:
146: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_ERROR;
148: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
149: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:

Line 148: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

144: ,lx_catv_tbl);
145:
146: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_ERROR;
148: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
149: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: --Copy value of OUT variable in the IN record type

Line 149: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

145:
146: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_ERROR;
148: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
149: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: --Copy value of OUT variable in the IN record type
153: lp_catv_tbl := lx_catv_tbl;

Line 166: WHEN Fnd_Api.G_EXC_ERROR THEN

162:
163:
164: EXCEPTION
165:
166: WHEN Fnd_Api.G_EXC_ERROR THEN
167: ROLLBACK TO cash_allctn_rls_insert;
168: x_return_status := Fnd_Api.G_RET_STS_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;

Line 168: x_return_status := Fnd_Api.G_RET_STS_ERROR;

164: EXCEPTION
165:
166: WHEN Fnd_Api.G_EXC_ERROR THEN
167: ROLLBACK TO cash_allctn_rls_insert;
168: x_return_status := Fnd_Api.G_RET_STS_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;
171: Fnd_Msg_Pub.count_and_get(
172: p_count => x_msg_count

Line 174: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

170: x_msg_data := l_msg_data ;
171: Fnd_Msg_Pub.count_and_get(
172: p_count => x_msg_count
173: ,p_data => x_msg_data);
174: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
175: ROLLBACK TO cash_allctn_rls_insert;
176: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;

Line 176: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

172: p_count => x_msg_count
173: ,p_data => x_msg_data);
174: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
175: ROLLBACK TO cash_allctn_rls_insert;
176: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: Fnd_Msg_Pub.count_and_get(
180: p_count => x_msg_count

Line 184: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: WHEN OTHERS THEN
183: ROLLBACK TO cash_allctn_rls_insert;
184: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','insert_cash_allctn_rls');
188: Fnd_Msg_Pub.count_and_get(

Line 195: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

191: END insert_cash_allctn_rls;
192:
193: PROCEDURE lock_cash_allctn_rls(
194: p_api_version IN NUMBER
195: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
196: ,x_return_status OUT NOCOPY VARCHAR2
197: ,x_msg_count OUT NOCOPY NUMBER
198: ,x_msg_data OUT NOCOPY VARCHAR2
199: ,p_catv_rec IN catv_rec_type) IS

Line 210: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

206: x_msg_count,
207: x_msg_data,
208: p_catv_rec);
209:
210: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_ERROR;
212: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
213: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
214: END IF;

Line 211: RAISE Fnd_Api.G_EXC_ERROR;

207: x_msg_data,
208: p_catv_rec);
209:
210: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_ERROR;
212: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
213: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:

Line 212: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

208: p_catv_rec);
209:
210: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_ERROR;
212: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
213: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216:

Line 213: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

209:
210: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_ERROR;
212: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
213: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216:
217: EXCEPTION

Line 219: WHEN Fnd_Api.G_EXC_ERROR THEN

215:
216:
217: EXCEPTION
218:
219: WHEN Fnd_Api.G_EXC_ERROR THEN
220: Fnd_Msg_Pub.count_and_get(
221: p_count => x_msg_count
222: ,p_data => x_msg_data);
223: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 223: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

219: WHEN Fnd_Api.G_EXC_ERROR THEN
220: Fnd_Msg_Pub.count_and_get(
221: p_count => x_msg_count
222: ,p_data => x_msg_data);
223: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
224: Fnd_Msg_Pub.count_and_get(
225: p_count => x_msg_count
226: ,p_data => x_msg_data);
227: WHEN OTHERS THEN

Line 228: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

224: Fnd_Msg_Pub.count_and_get(
225: p_count => x_msg_count
226: ,p_data => x_msg_data);
227: WHEN OTHERS THEN
228: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
229: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','lock_cash_allctn_rls');
230: Fnd_Msg_Pub.count_and_get(
231: p_count => x_msg_count
232: ,p_data => x_msg_data);

Line 237: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

233: END lock_cash_allctn_rls;
234:
235: PROCEDURE lock_cash_allctn_rls(
236: p_api_version IN NUMBER
237: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
238: ,x_return_status OUT NOCOPY VARCHAR2
239: ,x_msg_count OUT NOCOPY NUMBER
240: ,x_msg_data OUT NOCOPY VARCHAR2
241: ,p_catv_tbl IN catv_tbl_type) IS

Line 252: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

248: x_msg_count,
249: x_msg_data,
250: p_catv_tbl);
251:
252: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;

Line 253: RAISE Fnd_Api.G_EXC_ERROR;

249: x_msg_data,
250: p_catv_tbl);
251:
252: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:

Line 254: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

250: p_catv_tbl);
251:
252: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258:

Line 255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

251:
252: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:
258:
259: EXCEPTION

Line 261: WHEN Fnd_Api.G_EXC_ERROR THEN

257:
258:
259: EXCEPTION
260:
261: WHEN Fnd_Api.G_EXC_ERROR THEN
262: Fnd_Msg_Pub.count_and_get(
263: p_count => x_msg_count
264: ,p_data => x_msg_data);
265: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 265: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

261: WHEN Fnd_Api.G_EXC_ERROR THEN
262: Fnd_Msg_Pub.count_and_get(
263: p_count => x_msg_count
264: ,p_data => x_msg_data);
265: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
266: Fnd_Msg_Pub.count_and_get(
267: p_count => x_msg_count
268: ,p_data => x_msg_data);
269: WHEN OTHERS THEN

Line 270: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

266: Fnd_Msg_Pub.count_and_get(
267: p_count => x_msg_count
268: ,p_data => x_msg_data);
269: WHEN OTHERS THEN
270: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
271: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','lock_cash_allctn_rls');
272: Fnd_Msg_Pub.count_and_get(
273: p_count => x_msg_count
274: ,p_data => x_msg_data);

Line 279: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

275: END lock_cash_allctn_rls;
276:
277: PROCEDURE update_cash_allctn_rls(
278: p_api_version IN NUMBER
279: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
280: ,x_return_status OUT NOCOPY VARCHAR2
281: ,x_msg_count OUT NOCOPY NUMBER
282: ,x_msg_data OUT NOCOPY VARCHAR2
283: ,p_catv_rec IN catv_rec_type

Line 324: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

320: ,l_msg_data
321: ,lp_catv_rec
322: ,lx_catv_rec);
323:
324: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;

Line 325: RAISE Fnd_Api.G_EXC_ERROR;

321: ,lp_catv_rec
322: ,lx_catv_rec);
323:
324: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:

Line 326: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

322: ,lx_catv_rec);
323:
324: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: --Copy value of OUT variable in the IN record type

Line 327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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

Line 345: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 347: x_return_status := Fnd_Api.G_RET_STS_ERROR;

343: EXCEPTION
344:
345: WHEN Fnd_Api.G_EXC_ERROR THEN
346: ROLLBACK TO cash_allctn_rls_update;
347: x_return_status := Fnd_Api.G_RET_STS_ERROR;
348: x_msg_count := l_msg_count ;
349: x_msg_data := l_msg_data ;
350: Fnd_Msg_Pub.count_and_get(
351: p_count => x_msg_count

Line 353: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

349: x_msg_data := l_msg_data ;
350: Fnd_Msg_Pub.count_and_get(
351: p_count => x_msg_count
352: ,p_data => x_msg_data);
353: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO cash_allctn_rls_update;
355: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
356: x_msg_count := l_msg_count ;
357: x_msg_data := l_msg_data ;

Line 355: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

351: p_count => x_msg_count
352: ,p_data => x_msg_data);
353: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO cash_allctn_rls_update;
355: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
356: x_msg_count := l_msg_count ;
357: x_msg_data := l_msg_data ;
358: Fnd_Msg_Pub.count_and_get(
359: p_count => x_msg_count

Line 363: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

359: p_count => x_msg_count
360: ,p_data => x_msg_data);
361: WHEN OTHERS THEN
362: ROLLBACK TO cash_allctn_rls_update;
363: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
364: x_msg_count := l_msg_count ;
365: x_msg_data := l_msg_data ;
366: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','update_cash_allctn_rls');
367: Fnd_Msg_Pub.count_and_get(

Line 374: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

370: END update_cash_allctn_rls;
371:
372: PROCEDURE update_cash_allctn_rls(
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2
378: ,p_catv_tbl IN catv_tbl_type

Line 418: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

414: ,l_msg_data
415: ,lp_catv_tbl
416: ,lx_catv_tbl);
417:
418: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
419: RAISE Fnd_Api.G_EXC_ERROR;
420: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
422: END IF;

Line 419: RAISE Fnd_Api.G_EXC_ERROR;

415: ,lp_catv_tbl
416: ,lx_catv_tbl);
417:
418: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
419: RAISE Fnd_Api.G_EXC_ERROR;
420: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:

Line 420: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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

Line 438: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 440: x_return_status := Fnd_Api.G_RET_STS_ERROR;

436: EXCEPTION
437:
438: WHEN Fnd_Api.G_EXC_ERROR THEN
439: ROLLBACK TO cash_allctn_rls_update;
440: x_return_status := Fnd_Api.G_RET_STS_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: Fnd_Msg_Pub.count_and_get(
444: p_count => x_msg_count

Line 446: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

442: x_msg_data := l_msg_data ;
443: Fnd_Msg_Pub.count_and_get(
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO cash_allctn_rls_update;
448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
449: x_msg_count := l_msg_count ;
450: x_msg_data := l_msg_data ;

Line 448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO cash_allctn_rls_update;
448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
449: x_msg_count := l_msg_count ;
450: x_msg_data := l_msg_data ;
451: Fnd_Msg_Pub.count_and_get(
452: p_count => x_msg_count

Line 456: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

452: p_count => x_msg_count
453: ,p_data => x_msg_data);
454: WHEN OTHERS THEN
455: ROLLBACK TO cash_allctn_rls_update;
456: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
457: x_msg_count := l_msg_count ;
458: x_msg_data := l_msg_data ;
459: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','update_cash_allctn_rls');
460: Fnd_Msg_Pub.count_and_get(

Line 468: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

464:
465: --Put custom code for cascade delete by developer
466: PROCEDURE delete_cash_allctn_rls(
467: p_api_version IN NUMBER
468: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
469: ,x_return_status OUT NOCOPY VARCHAR2
470: ,x_msg_count OUT NOCOPY NUMBER
471: ,x_msg_data OUT NOCOPY VARCHAR2
472: ,p_catv_rec IN catv_rec_type) IS

Line 507: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

503: ,l_msg_count
504: ,l_msg_data
505: ,lp_catv_rec);
506:
507: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
508: RAISE Fnd_Api.G_EXC_ERROR;
509: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
511: END IF;

Line 508: RAISE Fnd_Api.G_EXC_ERROR;

504: ,l_msg_data
505: ,lp_catv_rec);
506:
507: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
508: RAISE Fnd_Api.G_EXC_ERROR;
509: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:

Line 509: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

505: ,lp_catv_rec);
506:
507: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
508: RAISE Fnd_Api.G_EXC_ERROR;
509: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513:

Line 510: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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

Line 524: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 526: x_return_status := Fnd_Api.G_RET_STS_ERROR;

522: EXCEPTION
523:
524: WHEN Fnd_Api.G_EXC_ERROR THEN
525: ROLLBACK TO cash_allctn_rls_delete_rec;
526: x_return_status := Fnd_Api.G_RET_STS_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;
529: Fnd_Msg_Pub.count_and_get(
530: p_count => x_msg_count

Line 532: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

528: x_msg_data := l_msg_data ;
529: Fnd_Msg_Pub.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO cash_allctn_rls_delete_rec;
534: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
535: x_msg_count := l_msg_count ;
536: x_msg_data := l_msg_data ;

Line 534: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO cash_allctn_rls_delete_rec;
534: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
535: x_msg_count := l_msg_count ;
536: x_msg_data := l_msg_data ;
537: Fnd_Msg_Pub.count_and_get(
538: p_count => x_msg_count

Line 542: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

538: p_count => x_msg_count
539: ,p_data => x_msg_data);
540: WHEN OTHERS THEN
541: ROLLBACK TO cash_allctn_rls_delete_rec;
542: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := l_msg_count ;
544: x_msg_data := l_msg_data ;
545: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','delete_cash_allctn_rls');
546: Fnd_Msg_Pub.count_and_get(

Line 553: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

549: END delete_cash_allctn_rls;
550:
551: PROCEDURE delete_cash_allctn_rls(
552: p_api_version IN NUMBER
553: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
554: ,x_return_status OUT NOCOPY VARCHAR2
555: ,x_msg_count OUT NOCOPY NUMBER
556: ,x_msg_data OUT NOCOPY VARCHAR2
557: ,p_catv_tbl IN catv_tbl_type) IS

Line 601: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

597: EXIT WHEN (i = lp_catv_tbl.LAST);
598: i := p_catv_tbl.NEXT(i);
599: END LOOP;
600: END IF;
601: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
602: RAISE Fnd_Api.G_EXC_ERROR;
603: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
604: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
605: END IF;

Line 602: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 603: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 604: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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

Line 621: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 623: x_return_status := Fnd_Api.G_RET_STS_ERROR;

619: EXCEPTION
620:
621: WHEN Fnd_Api.G_EXC_ERROR THEN
622: ROLLBACK TO cash_allctn_rls_delete_tbl;
623: x_return_status := Fnd_Api.G_RET_STS_ERROR;
624: x_msg_count := l_msg_count ;
625: x_msg_data := l_msg_data ;
626: Fnd_Msg_Pub.count_and_get(
627: p_count => x_msg_count

Line 629: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

625: x_msg_data := l_msg_data ;
626: Fnd_Msg_Pub.count_and_get(
627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
630: ROLLBACK TO cash_allctn_rls_delete_tbl;
631: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
632: x_msg_count := l_msg_count ;
633: x_msg_data := l_msg_data ;

Line 631: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
630: ROLLBACK TO cash_allctn_rls_delete_tbl;
631: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
632: x_msg_count := l_msg_count ;
633: x_msg_data := l_msg_data ;
634: Fnd_Msg_Pub.count_and_get(
635: p_count => x_msg_count

Line 639: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

635: p_count => x_msg_count
636: ,p_data => x_msg_data);
637: WHEN OTHERS THEN
638: ROLLBACK TO cash_allctn_rls_delete_tbl;
639: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
640: x_msg_count := l_msg_count ;
641: x_msg_data := l_msg_data ;
642: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_ALLCTN_RLS_PUB','delete_cash_allctn_rls');
643: Fnd_Msg_Pub.count_and_get(

Line 650: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

646: END delete_cash_allctn_rls;
647:
648: PROCEDURE validate_cash_allctn_rls(
649: p_api_version IN NUMBER
650: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
651: ,x_return_status OUT NOCOPY VARCHAR2
652: ,x_msg_count OUT NOCOPY NUMBER
653: ,x_msg_data OUT NOCOPY VARCHAR2
654: ,p_catv_rec IN catv_rec_type) IS

Line 687: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

683: ,l_msg_count
684: ,l_msg_data
685: ,lp_catv_rec);
686:
687: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
688: RAISE Fnd_Api.G_EXC_ERROR;
689: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
691: END IF;

Line 688: RAISE Fnd_Api.G_EXC_ERROR;

684: ,l_msg_data
685: ,lp_catv_rec);
686:
687: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
688: RAISE Fnd_Api.G_EXC_ERROR;
689: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692:

Line 689: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

685: ,lp_catv_rec);
686:
687: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
688: RAISE Fnd_Api.G_EXC_ERROR;
689: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692:
693: --Copy value of OUT variable in the IN record type

Line 690: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

686:
687: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
688: RAISE Fnd_Api.G_EXC_ERROR;
689: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692:
693: --Copy value of OUT variable in the IN record type
694: lp_catv_rec := lx_catv_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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_CASH_ALLCTN_RLS_PUB','validate_cash_allctn_rls');
733: Fnd_Msg_Pub.count_and_get(

Line 740: p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,

736: END validate_cash_allctn_rls;
737:
738: PROCEDURE validate_cash_allctn_rls(
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
741: x_return_status OUT NOCOPY VARCHAR2,
742: x_msg_count OUT NOCOPY NUMBER,
743: x_msg_data OUT NOCOPY VARCHAR2,
744: p_catv_tbl IN catv_tbl_type) IS

Line 775: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

771: ,x_msg_count
772: ,x_msg_data
773: ,lp_catv_tbl);
774:
775: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
776: RAISE Fnd_Api.G_EXC_ERROR;
777: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
778: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
779: END IF;

Line 776: RAISE Fnd_Api.G_EXC_ERROR;

772: ,x_msg_data
773: ,lp_catv_tbl);
774:
775: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
776: RAISE Fnd_Api.G_EXC_ERROR;
777: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
778: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
779: END IF;
780:

Line 777: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

773: ,lp_catv_tbl);
774:
775: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
776: RAISE Fnd_Api.G_EXC_ERROR;
777: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
778: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
779: END IF;
780:
781: --Copy value of OUT variable in the IN record type

Line 778: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

774:
775: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
776: RAISE Fnd_Api.G_EXC_ERROR;
777: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
778: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
779: END IF;
780:
781: --Copy value of OUT variable in the IN record type
782: lp_catv_tbl := lx_catv_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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 cash_allctn_rls_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_CASH_ALLCTN_RLS_PUB','validate_cash_allctn_rls');
818: Fnd_Msg_Pub.count_and_get(