DBA Data[Home] [Help]

APPS.OKL_TRX_MSGS_PUB dependencies on FND_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2: /* $Header: OKLPTMGB.pls 115.6 2004/04/13 11:25:08 rnaik noship $ */
3:
4: PROCEDURE insert_trx_msgs(
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_tmgv_rec IN tmgv_rec_type

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

45: ,l_msg_data
46: ,lp_tmgv_rec
47: ,lx_tmgv_rec);
48:
49: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;

Line 50: RAISE FND_API.G_EXC_ERROR;

46: ,lp_tmgv_rec
47: ,lx_tmgv_rec);
48:
49: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:

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

47: ,lx_tmgv_rec);
48:
49: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55: --Copy value of OUT variable in the IN record type

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48:
49: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55: --Copy value of OUT variable in the IN record type
56: lp_tmgv_rec := lx_tmgv_rec;

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: x_msg_data := l_msg_data ;
67:
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO trx_msgs_insert;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO trx_msgs_insert;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO trx_msgs_insert;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84: p_count => x_msg_count
85: ,p_data => x_msg_data);
86: WHEN OTHERS THEN
87: ROLLBACK TO trx_msgs_insert;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','insert_trx_msgs');
92: FND_MSG_PUB.count_and_get(

Line 99: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

95: END insert_trx_msgs;
96:
97: PROCEDURE insert_trx_msgs(
98: p_api_version IN NUMBER
99: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY NUMBER
102: ,x_msg_data OUT NOCOPY VARCHAR2
103: ,p_tmgv_tbl IN tmgv_tbl_type

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

134: ,l_msg_data
135: ,lp_tmgv_tbl
136: ,lx_tmgv_tbl);
137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;

Line 139: RAISE FND_API.G_EXC_ERROR;

135: ,lp_tmgv_tbl
136: ,lx_tmgv_tbl);
137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:

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

136: ,lx_tmgv_tbl);
137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: --Copy value of OUT variable in the IN record type

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137:
138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: --Copy value of OUT variable in the IN record type
145: lp_tmgv_tbl := lx_tmgv_tbl;

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154:
155:
156: EXCEPTION
157:
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO trx_msgs_insert;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: EXCEPTION
157:
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO trx_msgs_insert;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO trx_msgs_insert;
168: x_return_status := FND_API.G_RET_STS_UNEXP_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_UNEXP_ERROR;

164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO trx_msgs_insert;
168: x_return_status := FND_API.G_RET_STS_UNEXP_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 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 OTHERS THEN
175: ROLLBACK TO trx_msgs_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.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','insert_trx_msgs');
180: FND_MSG_PUB.count_and_get(

Line 187: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

183: END insert_trx_msgs;
184:
185: PROCEDURE lock_trx_msgs(
186: p_api_version IN NUMBER
187: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_count OUT NOCOPY NUMBER
190: ,x_msg_data OUT NOCOPY VARCHAR2
191: ,p_tmgv_rec IN tmgv_rec_type) IS

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

198: x_msg_count,
199: x_msg_data,
200: p_tmgv_rec);
201:
202: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 203: RAISE FND_API.G_EXC_ERROR;

199: x_msg_data,
200: p_tmgv_rec);
201:
202: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

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

200: p_tmgv_rec);
201:
202: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201:
202: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:
209: EXCEPTION

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207:
208:
209: EXCEPTION
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','lock_trx_msgs');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);

Line 229: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

225: END lock_trx_msgs;
226:
227: PROCEDURE lock_trx_msgs(
228: p_api_version IN NUMBER
229: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: ,p_tmgv_tbl IN tmgv_tbl_type) IS

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

240: x_msg_count,
241: x_msg_data,
242: p_tmgv_tbl);
243:
244: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;

Line 245: RAISE FND_API.G_EXC_ERROR;

241: x_msg_data,
242: p_tmgv_tbl);
243:
244: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:

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

242: p_tmgv_tbl);
243:
244: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:
250:

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243:
244: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:
250:
251: EXCEPTION

Line 253: WHEN FND_API.G_EXC_ERROR THEN

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

Line 257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

253: WHEN FND_API.G_EXC_ERROR THEN
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','lock_trx_msgs');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);

Line 271: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

267: END lock_trx_msgs;
268:
269: PROCEDURE update_trx_msgs(
270: p_api_version IN NUMBER
271: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
272: ,x_return_status OUT NOCOPY VARCHAR2
273: ,x_msg_count OUT NOCOPY NUMBER
274: ,x_msg_data OUT NOCOPY VARCHAR2
275: ,p_tmgv_rec IN tmgv_rec_type

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

308: ,l_msg_data
309: ,lp_tmgv_rec
310: ,lx_tmgv_rec);
311:
312: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;

Line 313: RAISE FND_API.G_EXC_ERROR;

309: ,lp_tmgv_rec
310: ,lx_tmgv_rec);
311:
312: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:

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

310: ,lx_tmgv_rec);
311:
312: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: --Copy value of OUT variable in the IN record type

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311:
312: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: --Copy value of OUT variable in the IN record type
319: lp_tmgv_rec := lx_tmgv_rec;

Line 333: WHEN FND_API.G_EXC_ERROR THEN

329:
330:
331: EXCEPTION
332:
333: WHEN FND_API.G_EXC_ERROR THEN
334: ROLLBACK TO trx_msgs_update;
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: x_msg_count := l_msg_count ;
337: x_msg_data := l_msg_data ;

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: EXCEPTION
332:
333: WHEN FND_API.G_EXC_ERROR THEN
334: ROLLBACK TO trx_msgs_update;
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: x_msg_count := l_msg_count ;
337: x_msg_data := l_msg_data ;
338: FND_MSG_PUB.count_and_get(
339: p_count => x_msg_count

Line 341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

337: x_msg_data := l_msg_data ;
338: FND_MSG_PUB.count_and_get(
339: p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: ROLLBACK TO trx_msgs_update;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := l_msg_count ;
345: x_msg_data := l_msg_data ;

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: ROLLBACK TO trx_msgs_update;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := l_msg_count ;
345: x_msg_data := l_msg_data ;
346: FND_MSG_PUB.count_and_get(
347: p_count => x_msg_count

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: p_count => x_msg_count
348: ,p_data => x_msg_data);
349: WHEN OTHERS THEN
350: ROLLBACK TO trx_msgs_update;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');
355: FND_MSG_PUB.count_and_get(

Line 362: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

358: END update_trx_msgs;
359:
360: PROCEDURE update_trx_msgs(
361: p_api_version IN NUMBER
362: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2
366: ,p_tmgv_tbl IN tmgv_tbl_type

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

398: ,l_msg_data
399: ,lp_tmgv_tbl
400: ,lx_tmgv_tbl);
401:
402: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
403: RAISE FND_API.G_EXC_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;

Line 403: RAISE FND_API.G_EXC_ERROR;

399: ,lp_tmgv_tbl
400: ,lx_tmgv_tbl);
401:
402: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
403: RAISE FND_API.G_EXC_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:

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

400: ,lx_tmgv_tbl);
401:
402: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
403: RAISE FND_API.G_EXC_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:
408: --Copy value of OUT variable in the IN record type

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

401:
402: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
403: RAISE FND_API.G_EXC_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:
408: --Copy value of OUT variable in the IN record type
409: lp_tmgv_tbl := lx_tmgv_tbl;

Line 422: WHEN FND_API.G_EXC_ERROR THEN

418:
419:
420: EXCEPTION
421:
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO trx_msgs_update;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: x_msg_count := l_msg_count ;
426: x_msg_data := l_msg_data ;

Line 424: x_return_status := FND_API.G_RET_STS_ERROR;

420: EXCEPTION
421:
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO trx_msgs_update;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: x_msg_count := l_msg_count ;
426: x_msg_data := l_msg_data ;
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: x_msg_data := l_msg_data ;
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ROLLBACK TO trx_msgs_update;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;

Line 432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ROLLBACK TO trx_msgs_update;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;
435: FND_MSG_PUB.count_and_get(
436: p_count => x_msg_count

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

436: p_count => x_msg_count
437: ,p_data => x_msg_data);
438: WHEN OTHERS THEN
439: ROLLBACK TO trx_msgs_update;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');
444: FND_MSG_PUB.count_and_get(

Line 452: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

448:
449: --Put custom code for cascade delete by developer
450: PROCEDURE delete_trx_msgs(
451: p_api_version IN NUMBER
452: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
453: ,x_return_status OUT NOCOPY VARCHAR2
454: ,x_msg_count OUT NOCOPY NUMBER
455: ,x_msg_data OUT NOCOPY VARCHAR2
456: ,p_tmgv_rec IN tmgv_rec_type) IS

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

487: ,l_msg_count
488: ,l_msg_data
489: ,lp_tmgv_rec);
490:
491: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;

Line 492: RAISE FND_API.G_EXC_ERROR;

488: ,l_msg_data
489: ,lp_tmgv_rec);
490:
491: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:

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

489: ,lp_tmgv_rec);
490:
491: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497:

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490:
491: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497:
498:

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504: x_return_status := l_return_status ;
505:
506: EXCEPTION
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO trx_msgs_delete_rec;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: x_msg_count := l_msg_count ;
512: x_msg_data := l_msg_data ;

Line 510: x_return_status := FND_API.G_RET_STS_ERROR;

506: EXCEPTION
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO trx_msgs_delete_rec;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: x_msg_count := l_msg_count ;
512: x_msg_data := l_msg_data ;
513: FND_MSG_PUB.count_and_get(
514: p_count => x_msg_count

Line 516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

512: x_msg_data := l_msg_data ;
513: FND_MSG_PUB.count_and_get(
514: p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO trx_msgs_delete_rec;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: x_msg_count := l_msg_count ;
520: x_msg_data := l_msg_data ;

Line 518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

514: p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO trx_msgs_delete_rec;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: x_msg_count := l_msg_count ;
520: x_msg_data := l_msg_data ;
521: FND_MSG_PUB.count_and_get(
522: p_count => x_msg_count

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: p_count => x_msg_count
523: ,p_data => x_msg_data);
524: WHEN OTHERS THEN
525: ROLLBACK TO trx_msgs_delete_rec;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;
529: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');
530: FND_MSG_PUB.count_and_get(

Line 537: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

533: END delete_trx_msgs;
534:
535: PROCEDURE delete_trx_msgs(
536: p_api_version IN NUMBER
537: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
538: ,x_return_status OUT NOCOPY VARCHAR2
539: ,x_msg_count OUT NOCOPY NUMBER
540: ,x_msg_data OUT NOCOPY VARCHAR2
541: ,p_tmgv_tbl IN tmgv_tbl_type) IS

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

581: EXIT WHEN (i = lp_tmgv_tbl.LAST);
582: i := p_tmgv_tbl.NEXT(i);
583: END LOOP;
584: END IF;
585: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;

Line 586: RAISE FND_API.G_EXC_ERROR;

582: i := p_tmgv_tbl.NEXT(i);
583: END LOOP;
584: END IF;
585: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:

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

583: END LOOP;
584: END IF;
585: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: END;

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: END IF;
585: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: END;
592:

Line 605: WHEN FND_API.G_EXC_ERROR THEN

601: x_return_status := l_return_status ;
602:
603: EXCEPTION
604:
605: WHEN FND_API.G_EXC_ERROR THEN
606: ROLLBACK TO trx_msgs_delete_tbl;
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;

Line 607: x_return_status := FND_API.G_RET_STS_ERROR;

603: EXCEPTION
604:
605: WHEN FND_API.G_EXC_ERROR THEN
606: ROLLBACK TO trx_msgs_delete_tbl;
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.count_and_get(
611: p_count => x_msg_count

Line 613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.count_and_get(
611: p_count => x_msg_count
612: ,p_data => x_msg_data);
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO trx_msgs_delete_tbl;
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: x_msg_count := l_msg_count ;
617: x_msg_data := l_msg_data ;

Line 615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

611: p_count => x_msg_count
612: ,p_data => x_msg_data);
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO trx_msgs_delete_tbl;
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: x_msg_count := l_msg_count ;
617: x_msg_data := l_msg_data ;
618: FND_MSG_PUB.count_and_get(
619: p_count => x_msg_count

Line 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619: p_count => x_msg_count
620: ,p_data => x_msg_data);
621: WHEN OTHERS THEN
622: ROLLBACK TO trx_msgs_delete_tbl;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: x_msg_count := l_msg_count ;
625: x_msg_data := l_msg_data ;
626: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');
627: FND_MSG_PUB.count_and_get(

Line 634: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

630: END delete_trx_msgs;
631:
632: PROCEDURE validate_trx_msgs(
633: p_api_version IN NUMBER
634: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
635: ,x_return_status OUT NOCOPY VARCHAR2
636: ,x_msg_count OUT NOCOPY NUMBER
637: ,x_msg_data OUT NOCOPY VARCHAR2
638: ,p_tmgv_rec IN tmgv_rec_type) IS

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

667: ,l_msg_count
668: ,l_msg_data
669: ,lp_tmgv_rec);
670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: ,l_msg_data
669: ,lp_tmgv_rec);
670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:

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

669: ,lp_tmgv_rec);
670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: --Copy value of OUT variable in the IN record type

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670:
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: --Copy value of OUT variable in the IN record type
678: lp_tmgv_rec := lx_tmgv_rec;

Line 695: WHEN FND_API.G_EXC_ERROR THEN

691: x_return_status := l_return_status ;
692:
693: EXCEPTION
694:
695: WHEN FND_API.G_EXC_ERROR THEN
696: ROLLBACK TO trx_msgs_validate;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: x_msg_count := l_msg_count ;
699: x_msg_data := l_msg_data ;

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: EXCEPTION
694:
695: WHEN FND_API.G_EXC_ERROR THEN
696: ROLLBACK TO trx_msgs_validate;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: x_msg_count := l_msg_count ;
699: x_msg_data := l_msg_data ;
700: FND_MSG_PUB.count_and_get(
701: p_count => x_msg_count

Line 703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

699: x_msg_data := l_msg_data ;
700: FND_MSG_PUB.count_and_get(
701: p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO trx_msgs_validate;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;

Line 705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

701: p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO trx_msgs_validate;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.count_and_get(
709: p_count => x_msg_count

Line 713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

709: p_count => x_msg_count
710: ,p_data => x_msg_data);
711: WHEN OTHERS THEN
712: ROLLBACK TO trx_msgs_validate;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
717: FND_MSG_PUB.count_and_get(

Line 724: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

720: END validate_trx_msgs;
721:
722: PROCEDURE validate_trx_msgs(
723: p_api_version IN NUMBER
724: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
725: ,x_return_status OUT NOCOPY VARCHAR2
726: ,x_msg_count OUT NOCOPY NUMBER
727: ,x_msg_data OUT NOCOPY VARCHAR2
728: ,p_tmgv_tbl IN tmgv_tbl_type) IS

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

755: ,x_msg_count
756: ,x_msg_data
757: ,lp_tmgv_tbl);
758:
759: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;

Line 760: RAISE FND_API.G_EXC_ERROR;

756: ,x_msg_data
757: ,lp_tmgv_tbl);
758:
759: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;
764:

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

757: ,lp_tmgv_tbl);
758:
759: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;
764:
765: --Copy value of OUT variable in the IN record type

Line 762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

758:
759: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;
764:
765: --Copy value of OUT variable in the IN record type
766: lp_tmgv_tbl := lx_tmgv_tbl;

Line 780: WHEN FND_API.G_EXC_ERROR THEN

776: x_return_status := l_return_status ;
777:
778: EXCEPTION
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: ROLLBACK TO trx_msgs_validate;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: x_msg_count := l_msg_count ;
784: x_msg_data := l_msg_data ;

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: EXCEPTION
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: ROLLBACK TO trx_msgs_validate;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: x_msg_count := l_msg_count ;
784: x_msg_data := l_msg_data ;
785: FND_MSG_PUB.count_and_get(
786: p_count => x_msg_count

Line 788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

784: x_msg_data := l_msg_data ;
785: FND_MSG_PUB.count_and_get(
786: p_count => x_msg_count
787: ,p_data => x_msg_data);
788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
789: ROLLBACK TO trx_msgs_validate;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;

Line 790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

786: p_count => x_msg_count
787: ,p_data => x_msg_data);
788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
789: ROLLBACK TO trx_msgs_validate;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;
793: FND_MSG_PUB.count_and_get(
794: p_count => x_msg_count

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: p_count => x_msg_count
795: ,p_data => x_msg_data);
796: WHEN OTHERS THEN
797: ROLLBACK TO trx_msgs_validate;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
802: FND_MSG_PUB.count_and_get(