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_INVOICE_MSSGS_PUB dependencies on FND_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2: /* $Header: OKLPIMSB.pls 120.4 2008/02/04 13:16:48 nikshah noship $ */
3:
4: PROCEDURE insert_invoice_mssgs(
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_imsv_rec IN imsv_rec_type

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

62: ,l_msg_data
63: ,lp_imsv_rec
64: ,lx_imsv_rec);
65:
66: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
67: RAISE FND_API.G_EXC_ERROR;
68: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;

Line 67: RAISE FND_API.G_EXC_ERROR;

63: ,lp_imsv_rec
64: ,lx_imsv_rec);
65:
66: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
67: RAISE FND_API.G_EXC_ERROR;
68: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:

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

64: ,lx_imsv_rec);
65:
66: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
67: RAISE FND_API.G_EXC_ERROR;
68: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: --Copy value of OUT variable in the IN record type

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65:
66: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
67: RAISE FND_API.G_EXC_ERROR;
68: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: --Copy value of OUT variable in the IN record type
73: lp_imsv_rec := lx_imsv_rec;

Line 87: WHEN FND_API.G_EXC_ERROR THEN

83: x_msg_data := l_msg_data ;
84:
85: EXCEPTION
86:
87: WHEN FND_API.G_EXC_ERROR THEN
88: ROLLBACK TO invoice_mssgs_insert;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85: EXCEPTION
86:
87: WHEN FND_API.G_EXC_ERROR THEN
88: ROLLBACK TO invoice_mssgs_insert;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: x_msg_data := l_msg_data ;
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO invoice_mssgs_insert;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: x_msg_count := l_msg_count ;
99: x_msg_data := l_msg_data ;

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO invoice_mssgs_insert;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: x_msg_count := l_msg_count ;
99: x_msg_data := l_msg_data ;
100: FND_MSG_PUB.count_and_get(
101: p_count => x_msg_count

Line 105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

101: p_count => x_msg_count
102: ,p_data => x_msg_data);
103: WHEN OTHERS THEN
104: ROLLBACK TO invoice_mssgs_insert;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: x_msg_count := l_msg_count ;
107: x_msg_data := l_msg_data ;
108: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','insert_invoice_mssgs');
109: FND_MSG_PUB.count_and_get(

Line 116: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

112: END insert_invoice_mssgs;
113:
114: PROCEDURE insert_invoice_mssgs(
115: p_api_version IN NUMBER
116: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
119: ,x_msg_data OUT NOCOPY VARCHAR2
120: ,p_imsv_tbl IN imsv_tbl_type

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

172: ,l_msg_data
173: ,lp_imsv_tbl
174: ,lx_imsv_tbl);
175:
176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;

Line 177: RAISE FND_API.G_EXC_ERROR;

173: ,lp_imsv_tbl
174: ,lx_imsv_tbl);
175:
176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:

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

174: ,lx_imsv_tbl);
175:
176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: --Copy value of OUT variable in the IN record type

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175:
176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: --Copy value of OUT variable in the IN record type
183: lp_imsv_tbl := lx_imsv_tbl;

Line 196: WHEN FND_API.G_EXC_ERROR THEN

192:
193:
194: EXCEPTION
195:
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO invoice_mssgs_insert;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: EXCEPTION
195:
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO invoice_mssgs_insert;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count

Line 204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

200: x_msg_data := l_msg_data ;
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO invoice_mssgs_insert;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_count := l_msg_count ;
208: x_msg_data := l_msg_data ;

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO invoice_mssgs_insert;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_count := l_msg_count ;
208: x_msg_data := l_msg_data ;
209: FND_MSG_PUB.count_and_get(
210: p_count => x_msg_count

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

210: p_count => x_msg_count
211: ,p_data => x_msg_data);
212: WHEN OTHERS THEN
213: ROLLBACK TO invoice_mssgs_insert;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: x_msg_count := l_msg_count ;
216: x_msg_data := l_msg_data ;
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','insert_invoice_mssgs');
218: FND_MSG_PUB.count_and_get(

Line 225: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

221: END insert_invoice_mssgs;
222:
223: PROCEDURE lock_invoice_mssgs(
224: p_api_version IN NUMBER
225: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
226: ,x_return_status OUT NOCOPY VARCHAR2
227: ,x_msg_count OUT NOCOPY NUMBER
228: ,x_msg_data OUT NOCOPY VARCHAR2
229: ,p_imsv_rec IN imsv_rec_type) IS

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

236: x_msg_count,
237: x_msg_data,
238: p_imsv_rec);
239:
240: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;

Line 241: RAISE FND_API.G_EXC_ERROR;

237: x_msg_data,
238: p_imsv_rec);
239:
240: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:

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

238: p_imsv_rec);
239:
240: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246:

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239:
240: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
241: RAISE FND_API.G_EXC_ERROR;
242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246:
247: EXCEPTION

Line 249: WHEN FND_API.G_EXC_ERROR THEN

245:
246:
247: EXCEPTION
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: FND_MSG_PUB.count_and_get(
251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

249: WHEN FND_API.G_EXC_ERROR THEN
250: FND_MSG_PUB.count_and_get(
251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN OTHERS THEN

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','lock_invoice_mssgs');
260: FND_MSG_PUB.count_and_get(
261: p_count => x_msg_count
262: ,p_data => x_msg_data);

Line 267: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

263: END lock_invoice_mssgs;
264:
265: PROCEDURE lock_invoice_mssgs(
266: p_api_version IN NUMBER
267: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
268: ,x_return_status OUT NOCOPY VARCHAR2
269: ,x_msg_count OUT NOCOPY NUMBER
270: ,x_msg_data OUT NOCOPY VARCHAR2
271: ,p_imsv_tbl IN imsv_tbl_type) IS

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

278: x_msg_count,
279: x_msg_data,
280: p_imsv_tbl);
281:
282: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
283: RAISE FND_API.G_EXC_ERROR;
284: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;

Line 283: RAISE FND_API.G_EXC_ERROR;

279: x_msg_data,
280: p_imsv_tbl);
281:
282: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
283: RAISE FND_API.G_EXC_ERROR;
284: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:

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

280: p_imsv_tbl);
281:
282: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
283: RAISE FND_API.G_EXC_ERROR;
284: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288:

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

281:
282: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
283: RAISE FND_API.G_EXC_ERROR;
284: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288:
289: EXCEPTION

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287:
288:
289: EXCEPTION
290:
291: WHEN FND_API.G_EXC_ERROR THEN
292: FND_MSG_PUB.count_and_get(
293: p_count => x_msg_count
294: ,p_data => x_msg_data);
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

291: WHEN FND_API.G_EXC_ERROR THEN
292: FND_MSG_PUB.count_and_get(
293: p_count => x_msg_count
294: ,p_data => x_msg_data);
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: FND_MSG_PUB.count_and_get(
297: p_count => x_msg_count
298: ,p_data => x_msg_data);
299: WHEN OTHERS THEN

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

296: FND_MSG_PUB.count_and_get(
297: p_count => x_msg_count
298: ,p_data => x_msg_data);
299: WHEN OTHERS THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','lock_invoice_mssgs');
302: FND_MSG_PUB.count_and_get(
303: p_count => x_msg_count
304: ,p_data => x_msg_data);

Line 309: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

305: END lock_invoice_mssgs;
306:
307: PROCEDURE update_invoice_mssgs(
308: p_api_version IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
310: ,x_return_status OUT NOCOPY VARCHAR2
311: ,x_msg_count OUT NOCOPY NUMBER
312: ,x_msg_data OUT NOCOPY VARCHAR2
313: ,p_imsv_rec IN imsv_rec_type

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

346: ,l_msg_data
347: ,lp_imsv_rec
348: ,lx_imsv_rec);
349:
350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
351: RAISE FND_API.G_EXC_ERROR;
352: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;

Line 351: RAISE FND_API.G_EXC_ERROR;

347: ,lp_imsv_rec
348: ,lx_imsv_rec);
349:
350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
351: RAISE FND_API.G_EXC_ERROR;
352: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355:

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

348: ,lx_imsv_rec);
349:
350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
351: RAISE FND_API.G_EXC_ERROR;
352: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355:
356: --Copy value of OUT variable in the IN record type

Line 353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

349:
350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
351: RAISE FND_API.G_EXC_ERROR;
352: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355:
356: --Copy value of OUT variable in the IN record type
357: lp_imsv_rec := lx_imsv_rec;

Line 371: WHEN FND_API.G_EXC_ERROR THEN

367:
368:
369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372: ROLLBACK TO invoice_mssgs_update;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_msg_count := l_msg_count ;
375: x_msg_data := l_msg_data ;

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372: ROLLBACK TO invoice_mssgs_update;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_msg_count := l_msg_count ;
375: x_msg_data := l_msg_data ;
376: FND_MSG_PUB.count_and_get(
377: p_count => x_msg_count

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: x_msg_data := l_msg_data ;
376: FND_MSG_PUB.count_and_get(
377: p_count => x_msg_count
378: ,p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO invoice_mssgs_update;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: x_msg_count := l_msg_count ;
383: x_msg_data := l_msg_data ;

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: p_count => x_msg_count
378: ,p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO invoice_mssgs_update;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: x_msg_count := l_msg_count ;
383: x_msg_data := l_msg_data ;
384: FND_MSG_PUB.count_and_get(
385: p_count => x_msg_count

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385: p_count => x_msg_count
386: ,p_data => x_msg_data);
387: WHEN OTHERS THEN
388: ROLLBACK TO invoice_mssgs_update;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: x_msg_count := l_msg_count ;
391: x_msg_data := l_msg_data ;
392: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','update_invoice_mssgs');
393: FND_MSG_PUB.count_and_get(

Line 400: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

396: END update_invoice_mssgs;
397:
398: PROCEDURE update_invoice_mssgs(
399: p_api_version IN NUMBER
400: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
401: ,x_return_status OUT NOCOPY VARCHAR2
402: ,x_msg_count OUT NOCOPY NUMBER
403: ,x_msg_data OUT NOCOPY VARCHAR2
404: ,p_imsv_tbl IN imsv_tbl_type

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

436: ,l_msg_data
437: ,lp_imsv_tbl
438: ,lx_imsv_tbl);
439:
440: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;

Line 441: RAISE FND_API.G_EXC_ERROR;

437: ,lp_imsv_tbl
438: ,lx_imsv_tbl);
439:
440: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:

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

438: ,lx_imsv_tbl);
439:
440: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446: --Copy value of OUT variable in the IN record type

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439:
440: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446: --Copy value of OUT variable in the IN record type
447: lp_imsv_tbl := lx_imsv_tbl;

Line 460: WHEN FND_API.G_EXC_ERROR THEN

456:
457:
458: EXCEPTION
459:
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO invoice_mssgs_update;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: x_msg_count := l_msg_count ;
464: x_msg_data := l_msg_data ;

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458: EXCEPTION
459:
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO invoice_mssgs_update;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: x_msg_count := l_msg_count ;
464: x_msg_data := l_msg_data ;
465: FND_MSG_PUB.count_and_get(
466: p_count => x_msg_count

Line 468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

464: x_msg_data := l_msg_data ;
465: FND_MSG_PUB.count_and_get(
466: p_count => x_msg_count
467: ,p_data => x_msg_data);
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO invoice_mssgs_update;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: x_msg_count := l_msg_count ;
472: x_msg_data := l_msg_data ;

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

466: p_count => x_msg_count
467: ,p_data => x_msg_data);
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO invoice_mssgs_update;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: x_msg_count := l_msg_count ;
472: x_msg_data := l_msg_data ;
473: FND_MSG_PUB.count_and_get(
474: p_count => x_msg_count

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: p_count => x_msg_count
475: ,p_data => x_msg_data);
476: WHEN OTHERS THEN
477: ROLLBACK TO invoice_mssgs_update;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: x_msg_count := l_msg_count ;
480: x_msg_data := l_msg_data ;
481: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','update_invoice_mssgs');
482: FND_MSG_PUB.count_and_get(

Line 490: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

486:
487: --Put custom code for cascade delete by developer
488: PROCEDURE delete_invoice_mssgs(
489: p_api_version IN NUMBER
490: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
491: ,x_return_status OUT NOCOPY VARCHAR2
492: ,x_msg_count OUT NOCOPY NUMBER
493: ,x_msg_data OUT NOCOPY VARCHAR2
494: ,p_imsv_rec IN imsv_rec_type) IS

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

525: ,l_msg_count
526: ,l_msg_data
527: ,lp_imsv_rec);
528:
529: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
530: RAISE FND_API.G_EXC_ERROR;
531: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;

Line 530: RAISE FND_API.G_EXC_ERROR;

526: ,l_msg_data
527: ,lp_imsv_rec);
528:
529: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
530: RAISE FND_API.G_EXC_ERROR;
531: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:

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

527: ,lp_imsv_rec);
528:
529: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
530: RAISE FND_API.G_EXC_ERROR;
531: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535:

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528:
529: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
530: RAISE FND_API.G_EXC_ERROR;
531: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535:
536:

Line 546: WHEN FND_API.G_EXC_ERROR THEN

542: x_return_status := l_return_status ;
543:
544: EXCEPTION
545:
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO invoice_mssgs_delete_rec;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: x_msg_count := l_msg_count ;
550: x_msg_data := l_msg_data ;

Line 548: x_return_status := FND_API.G_RET_STS_ERROR;

544: EXCEPTION
545:
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO invoice_mssgs_delete_rec;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: x_msg_count := l_msg_count ;
550: x_msg_data := l_msg_data ;
551: FND_MSG_PUB.count_and_get(
552: p_count => x_msg_count

Line 554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

550: x_msg_data := l_msg_data ;
551: FND_MSG_PUB.count_and_get(
552: p_count => x_msg_count
553: ,p_data => x_msg_data);
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: ROLLBACK TO invoice_mssgs_delete_rec;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: x_msg_count := l_msg_count ;
558: x_msg_data := l_msg_data ;

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552: p_count => x_msg_count
553: ,p_data => x_msg_data);
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: ROLLBACK TO invoice_mssgs_delete_rec;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: x_msg_count := l_msg_count ;
558: x_msg_data := l_msg_data ;
559: FND_MSG_PUB.count_and_get(
560: p_count => x_msg_count

Line 564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

560: p_count => x_msg_count
561: ,p_data => x_msg_data);
562: WHEN OTHERS THEN
563: ROLLBACK TO invoice_mssgs_delete_rec;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: x_msg_count := l_msg_count ;
566: x_msg_data := l_msg_data ;
567: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','delete_invoice_mssgs');
568: FND_MSG_PUB.count_and_get(

Line 575: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

571: END delete_invoice_mssgs;
572:
573: PROCEDURE delete_invoice_mssgs(
574: p_api_version IN NUMBER
575: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
576: ,x_return_status OUT NOCOPY VARCHAR2
577: ,x_msg_count OUT NOCOPY NUMBER
578: ,x_msg_data OUT NOCOPY VARCHAR2
579: ,p_imsv_tbl IN imsv_tbl_type) IS

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

619: EXIT WHEN (i = lp_imsv_tbl.LAST);
620: i := p_imsv_tbl.NEXT(i);
621: END LOOP;
622: END IF;
623: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
624: RAISE FND_API.G_EXC_ERROR;
625: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;

Line 624: RAISE FND_API.G_EXC_ERROR;

620: i := p_imsv_tbl.NEXT(i);
621: END LOOP;
622: END IF;
623: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
624: RAISE FND_API.G_EXC_ERROR;
625: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:

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

621: END LOOP;
622: END IF;
623: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
624: RAISE FND_API.G_EXC_ERROR;
625: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:
629: END;

Line 626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

622: END IF;
623: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
624: RAISE FND_API.G_EXC_ERROR;
625: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:
629: END;
630:

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639: x_return_status := l_return_status ;
640:
641: EXCEPTION
642:
643: WHEN FND_API.G_EXC_ERROR THEN
644: ROLLBACK TO invoice_mssgs_delete_tbl;
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: x_msg_count := l_msg_count ;
647: x_msg_data := l_msg_data ;

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641: EXCEPTION
642:
643: WHEN FND_API.G_EXC_ERROR THEN
644: ROLLBACK TO invoice_mssgs_delete_tbl;
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: x_msg_count := l_msg_count ;
647: x_msg_data := l_msg_data ;
648: FND_MSG_PUB.count_and_get(
649: p_count => x_msg_count

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: x_msg_data := l_msg_data ;
648: FND_MSG_PUB.count_and_get(
649: p_count => x_msg_count
650: ,p_data => x_msg_data);
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: ROLLBACK TO invoice_mssgs_delete_tbl;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: x_msg_count := l_msg_count ;
655: x_msg_data := l_msg_data ;

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: p_count => x_msg_count
650: ,p_data => x_msg_data);
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: ROLLBACK TO invoice_mssgs_delete_tbl;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: x_msg_count := l_msg_count ;
655: x_msg_data := l_msg_data ;
656: FND_MSG_PUB.count_and_get(
657: p_count => x_msg_count

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657: p_count => x_msg_count
658: ,p_data => x_msg_data);
659: WHEN OTHERS THEN
660: ROLLBACK TO invoice_mssgs_delete_tbl;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: x_msg_count := l_msg_count ;
663: x_msg_data := l_msg_data ;
664: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','delete_invoice_mssgs');
665: FND_MSG_PUB.count_and_get(

Line 672: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

668: END delete_invoice_mssgs;
669:
670: PROCEDURE validate_invoice_mssgs(
671: p_api_version IN NUMBER
672: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
673: ,x_return_status OUT NOCOPY VARCHAR2
674: ,x_msg_count OUT NOCOPY NUMBER
675: ,x_msg_data OUT NOCOPY VARCHAR2
676: ,p_imsv_rec IN imsv_rec_type) IS

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

705: ,l_msg_count
706: ,l_msg_data
707: ,lp_imsv_rec);
708:
709: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;

Line 710: RAISE FND_API.G_EXC_ERROR;

706: ,l_msg_data
707: ,lp_imsv_rec);
708:
709: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:

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

707: ,lp_imsv_rec);
708:
709: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:
715: --Copy value of OUT variable in the IN record type

Line 712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

708:
709: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:
715: --Copy value of OUT variable in the IN record type
716: lp_imsv_rec := lx_imsv_rec;

Line 733: WHEN FND_API.G_EXC_ERROR THEN

729: x_return_status := l_return_status ;
730:
731: EXCEPTION
732:
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO invoice_mssgs_validate;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: x_msg_count := l_msg_count ;
737: x_msg_data := l_msg_data ;

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731: EXCEPTION
732:
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO invoice_mssgs_validate;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: x_msg_count := l_msg_count ;
737: x_msg_data := l_msg_data ;
738: FND_MSG_PUB.count_and_get(
739: p_count => x_msg_count

Line 741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

737: x_msg_data := l_msg_data ;
738: FND_MSG_PUB.count_and_get(
739: p_count => x_msg_count
740: ,p_data => x_msg_data);
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO invoice_mssgs_validate;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: x_msg_count := l_msg_count ;
745: x_msg_data := l_msg_data ;

Line 743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

739: p_count => x_msg_count
740: ,p_data => x_msg_data);
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO invoice_mssgs_validate;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: x_msg_count := l_msg_count ;
745: x_msg_data := l_msg_data ;
746: FND_MSG_PUB.count_and_get(
747: p_count => x_msg_count

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

747: p_count => x_msg_count
748: ,p_data => x_msg_data);
749: WHEN OTHERS THEN
750: ROLLBACK TO invoice_mssgs_validate;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: x_msg_count := l_msg_count ;
753: x_msg_data := l_msg_data ;
754: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','validate_invoice_mssgs');
755: FND_MSG_PUB.count_and_get(

Line 762: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

758: END validate_invoice_mssgs;
759:
760: PROCEDURE validate_invoice_mssgs(
761: p_api_version IN NUMBER,
762: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763: x_return_status OUT NOCOPY VARCHAR2,
764: x_msg_count OUT NOCOPY NUMBER,
765: x_msg_data OUT NOCOPY VARCHAR2,
766: p_imsv_tbl IN imsv_tbl_type) IS

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

793: ,x_msg_count
794: ,x_msg_data
795: ,lp_imsv_tbl);
796:
797: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;

Line 798: RAISE FND_API.G_EXC_ERROR;

794: ,x_msg_data
795: ,lp_imsv_tbl);
796:
797: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:

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

795: ,lp_imsv_tbl);
796:
797: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: --Copy value of OUT variable in the IN record type

Line 800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

796:
797: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
798: RAISE FND_API.G_EXC_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: --Copy value of OUT variable in the IN record type
804: lp_imsv_tbl := lx_imsv_tbl;

Line 818: WHEN FND_API.G_EXC_ERROR THEN

814: x_return_status := l_return_status ;
815:
816: EXCEPTION
817:
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO invoice_mssgs_validate;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: x_msg_count := l_msg_count ;
822: x_msg_data := l_msg_data ;

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816: EXCEPTION
817:
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO invoice_mssgs_validate;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: x_msg_count := l_msg_count ;
822: x_msg_data := l_msg_data ;
823: FND_MSG_PUB.count_and_get(
824: p_count => x_msg_count

Line 826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

822: x_msg_data := l_msg_data ;
823: FND_MSG_PUB.count_and_get(
824: p_count => x_msg_count
825: ,p_data => x_msg_data);
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO invoice_mssgs_validate;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: x_msg_count := l_msg_count ;
830: x_msg_data := l_msg_data ;

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

824: p_count => x_msg_count
825: ,p_data => x_msg_data);
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO invoice_mssgs_validate;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: x_msg_count := l_msg_count ;
830: x_msg_data := l_msg_data ;
831: FND_MSG_PUB.count_and_get(
832: p_count => x_msg_count

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

832: p_count => x_msg_count
833: ,p_data => x_msg_data);
834: WHEN OTHERS THEN
835: ROLLBACK TO invoice_mssgs_validate;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: x_msg_count := l_msg_count ;
838: x_msg_data := l_msg_data ;
839: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','validate_invoice_mssgs');
840: FND_MSG_PUB.count_and_get(