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

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2: /* $Header: OKLPICGB.pls 115.8 2004/04/13 10:47:16 rnaik noship $ */
3:
4: PROCEDURE insert_ins_class_cats(
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_icgv_rec IN icgv_rec_type

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

45: ,l_msg_data
46: ,lp_icgv_rec
47: ,lx_icgv_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_icgv_rec
47: ,lx_icgv_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_icgv_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_icgv_rec := lx_icgv_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 ins_class_cats_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 ins_class_cats_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 ins_class_cats_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 ins_class_cats_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 ins_class_cats_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_INS_CLASS_CATS_PUB','insert_ins_class_cats');
92: FND_MSG_PUB.count_and_get(

Line 99: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

95: END insert_ins_class_cats;
96:
97: PROCEDURE insert_ins_class_cats(
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_icgv_tbl IN icgv_tbl_type

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

134: ,l_msg_data
135: ,lp_icgv_tbl
136: ,lx_icgv_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_icgv_tbl
136: ,lx_icgv_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_icgv_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_icgv_tbl := lx_icgv_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 ins_class_cats_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 ins_class_cats_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 ins_class_cats_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 ins_class_cats_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 ins_class_cats_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_INS_CLASS_CATS_PUB','insert_ins_class_cats');
180: FND_MSG_PUB.count_and_get(

Line 187: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

183: END insert_ins_class_cats;
184:
185: PROCEDURE lock_ins_class_cats(
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_icgv_rec IN icgv_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_icgv_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_icgv_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_icgv_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_INS_CLASS_CATS_PUB','lock_ins_class_cats');
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_ins_class_cats;
226:
227: PROCEDURE lock_ins_class_cats(
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_icgv_tbl IN icgv_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_icgv_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_icgv_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_icgv_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_INS_CLASS_CATS_PUB','lock_ins_class_cats');
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_ins_class_cats;
268:
269: PROCEDURE update_ins_class_cats(
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_icgv_rec IN icgv_rec_type

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

306: ,l_msg_data
307: ,lp_icgv_rec
308: ,lx_icgv_rec);
309:
310: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
311: RAISE FND_API.G_EXC_ERROR;
312:
313: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 311: RAISE FND_API.G_EXC_ERROR;

307: ,lp_icgv_rec
308: ,lx_icgv_rec);
309:
310: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
311: RAISE FND_API.G_EXC_ERROR;
312:
313: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;

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

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

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 332: WHEN FND_API.G_EXC_ERROR THEN

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

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

350:
351:
352: WHEN OTHERS THEN
353: ROLLBACK TO ins_class_cats_update;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: x_msg_count := l_msg_count ;
356: x_msg_data := l_msg_data ;
357: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
358: FND_MSG_PUB.count_and_get(

Line 368: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

364: END update_ins_class_cats;
365:
366: PROCEDURE update_ins_class_cats(
367: p_api_version IN NUMBER
368: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
369: ,x_return_status OUT NOCOPY VARCHAR2
370: ,x_msg_count OUT NOCOPY NUMBER
371: ,x_msg_data OUT NOCOPY VARCHAR2
372: ,p_icgv_tbl IN icgv_tbl_type

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

404: ,l_msg_data
405: ,lp_icgv_tbl
406: ,lx_icgv_tbl);
407:
408: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;

Line 409: RAISE FND_API.G_EXC_ERROR;

405: ,lp_icgv_tbl
406: ,lx_icgv_tbl);
407:
408: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:

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

406: ,lx_icgv_tbl);
407:
408: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: --Copy value of OUT variable in the IN record type

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407:
408: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: --Copy value of OUT variable in the IN record type
415: lp_icgv_tbl := lx_icgv_tbl;

Line 428: WHEN FND_API.G_EXC_ERROR THEN

424:
425:
426: EXCEPTION
427:
428: WHEN FND_API.G_EXC_ERROR THEN
429: ROLLBACK TO ins_class_cats_update;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: x_msg_count := l_msg_count ;
432: x_msg_data := l_msg_data ;

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: EXCEPTION
427:
428: WHEN FND_API.G_EXC_ERROR THEN
429: ROLLBACK TO ins_class_cats_update;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: x_msg_count := l_msg_count ;
432: x_msg_data := l_msg_data ;
433: FND_MSG_PUB.count_and_get(
434: p_count => x_msg_count

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

432: x_msg_data := l_msg_data ;
433: FND_MSG_PUB.count_and_get(
434: p_count => x_msg_count
435: ,p_data => x_msg_data);
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO ins_class_cats_update;
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_msg_count := l_msg_count ;
440: x_msg_data := l_msg_data ;

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: p_count => x_msg_count
435: ,p_data => x_msg_data);
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO ins_class_cats_update;
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_msg_count := l_msg_count ;
440: x_msg_data := l_msg_data ;
441: FND_MSG_PUB.count_and_get(
442: p_count => x_msg_count

Line 446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

442: p_count => x_msg_count
443: ,p_data => x_msg_data);
444: WHEN OTHERS THEN
445: ROLLBACK TO ins_class_cats_update;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: x_msg_count := l_msg_count ;
448: x_msg_data := l_msg_data ;
449: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
450: FND_MSG_PUB.count_and_get(

Line 458: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

454:
455: --Put custom code for cascade delete by developer
456: PROCEDURE delete_ins_class_cats(
457: p_api_version IN NUMBER
458: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
459: ,x_return_status OUT NOCOPY VARCHAR2
460: ,x_msg_count OUT NOCOPY NUMBER
461: ,x_msg_data OUT NOCOPY VARCHAR2
462: ,p_icgv_rec IN icgv_rec_type) IS

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

493: ,l_msg_count
494: ,l_msg_data
495: ,lp_icgv_rec);
496:
497: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;

Line 498: RAISE FND_API.G_EXC_ERROR;

494: ,l_msg_data
495: ,lp_icgv_rec);
496:
497: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:

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

495: ,lp_icgv_rec);
496:
497: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503:

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496:
497: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503:
504:

Line 514: WHEN FND_API.G_EXC_ERROR THEN

510: x_return_status := l_return_status ;
511:
512: EXCEPTION
513:
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO ins_class_cats_delete_rec;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: x_msg_count := l_msg_count ;
518: x_msg_data := l_msg_data ;

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512: EXCEPTION
513:
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO ins_class_cats_delete_rec;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: x_msg_count := l_msg_count ;
518: x_msg_data := l_msg_data ;
519: FND_MSG_PUB.count_and_get(
520: p_count => x_msg_count

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: x_msg_data := l_msg_data ;
519: FND_MSG_PUB.count_and_get(
520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO ins_class_cats_delete_rec;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_msg_count := l_msg_count ;
526: x_msg_data := l_msg_data ;

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO ins_class_cats_delete_rec;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_msg_count := l_msg_count ;
526: x_msg_data := l_msg_data ;
527: FND_MSG_PUB.count_and_get(
528: p_count => x_msg_count

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

528: p_count => x_msg_count
529: ,p_data => x_msg_data);
530: WHEN OTHERS THEN
531: ROLLBACK TO ins_class_cats_delete_rec;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: x_msg_count := l_msg_count ;
534: x_msg_data := l_msg_data ;
535: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
536: FND_MSG_PUB.count_and_get(

Line 543: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

539: END delete_ins_class_cats;
540:
541: PROCEDURE delete_ins_class_cats(
542: p_api_version IN NUMBER
543: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER
546: ,x_msg_data OUT NOCOPY VARCHAR2
547: ,p_icgv_tbl IN icgv_tbl_type) IS

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

587: EXIT WHEN (i = lp_icgv_tbl.LAST);
588: i := p_icgv_tbl.NEXT(i);
589: END LOOP;
590: END IF;
591: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;

Line 592: RAISE FND_API.G_EXC_ERROR;

588: i := p_icgv_tbl.NEXT(i);
589: END LOOP;
590: END IF;
591: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596:

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

589: END LOOP;
590: END IF;
591: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596:
597: END;

Line 594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

590: END IF;
591: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596:
597: END;
598:

Line 611: WHEN FND_API.G_EXC_ERROR THEN

607: x_return_status := l_return_status ;
608:
609: EXCEPTION
610:
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO ins_class_cats_delete_tbl;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;

Line 613: x_return_status := FND_API.G_RET_STS_ERROR;

609: EXCEPTION
610:
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO ins_class_cats_delete_tbl;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.count_and_get(
617: p_count => x_msg_count

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.count_and_get(
617: p_count => x_msg_count
618: ,p_data => x_msg_data);
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO ins_class_cats_delete_tbl;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: x_msg_count := l_msg_count ;
623: x_msg_data := l_msg_data ;

Line 621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

617: p_count => x_msg_count
618: ,p_data => x_msg_data);
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO ins_class_cats_delete_tbl;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: x_msg_count := l_msg_count ;
623: x_msg_data := l_msg_data ;
624: FND_MSG_PUB.count_and_get(
625: p_count => x_msg_count

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625: p_count => x_msg_count
626: ,p_data => x_msg_data);
627: WHEN OTHERS THEN
628: ROLLBACK TO ins_class_cats_delete_tbl;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: x_msg_count := l_msg_count ;
631: x_msg_data := l_msg_data ;
632: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
633: FND_MSG_PUB.count_and_get(

Line 640: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

636: END delete_ins_class_cats;
637:
638: PROCEDURE validate_ins_class_cats(
639: p_api_version IN NUMBER
640: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
641: ,x_return_status OUT NOCOPY VARCHAR2
642: ,x_msg_count OUT NOCOPY NUMBER
643: ,x_msg_data OUT NOCOPY VARCHAR2
644: ,p_icgv_rec IN icgv_rec_type) IS

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

673: ,l_msg_count
674: ,l_msg_data
675: ,lp_icgv_rec);
676:
677: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
678: RAISE FND_API.G_EXC_ERROR;
679: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;

Line 678: RAISE FND_API.G_EXC_ERROR;

674: ,l_msg_data
675: ,lp_icgv_rec);
676:
677: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
678: RAISE FND_API.G_EXC_ERROR;
679: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:

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

675: ,lp_icgv_rec);
676:
677: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
678: RAISE FND_API.G_EXC_ERROR;
679: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: --Copy value of OUT variable in the IN record type

Line 680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

676:
677: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
678: RAISE FND_API.G_EXC_ERROR;
679: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: --Copy value of OUT variable in the IN record type
684: lp_icgv_rec := lx_icgv_rec;

Line 701: WHEN FND_API.G_EXC_ERROR THEN

697: x_return_status := l_return_status ;
698:
699: EXCEPTION
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO ins_class_cats_validate;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: x_msg_count := l_msg_count ;
705: x_msg_data := l_msg_data ;

Line 703: x_return_status := FND_API.G_RET_STS_ERROR;

699: EXCEPTION
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO ins_class_cats_validate;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: x_msg_count := l_msg_count ;
705: x_msg_data := l_msg_data ;
706: FND_MSG_PUB.count_and_get(
707: p_count => x_msg_count

Line 709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

705: x_msg_data := l_msg_data ;
706: FND_MSG_PUB.count_and_get(
707: p_count => x_msg_count
708: ,p_data => x_msg_data);
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO ins_class_cats_validate;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: x_msg_count := l_msg_count ;
713: x_msg_data := l_msg_data ;

Line 711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

707: p_count => x_msg_count
708: ,p_data => x_msg_data);
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO ins_class_cats_validate;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: x_msg_count := l_msg_count ;
713: x_msg_data := l_msg_data ;
714: FND_MSG_PUB.count_and_get(
715: p_count => x_msg_count

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 730: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

726: END validate_ins_class_cats;
727:
728: PROCEDURE validate_ins_class_cats(
729: p_api_version IN NUMBER,
730: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
731: x_return_status OUT NOCOPY VARCHAR2,
732: x_msg_count OUT NOCOPY NUMBER,
733: x_msg_data OUT NOCOPY VARCHAR2,
734: p_icgv_tbl IN icgv_tbl_type) IS

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

761: ,x_msg_count
762: ,x_msg_data
763: ,lp_icgv_tbl);
764:
765: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
766: RAISE FND_API.G_EXC_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;

Line 766: RAISE FND_API.G_EXC_ERROR;

762: ,x_msg_data
763: ,lp_icgv_tbl);
764:
765: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
766: RAISE FND_API.G_EXC_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:

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

763: ,lp_icgv_tbl);
764:
765: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
766: RAISE FND_API.G_EXC_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: --Copy value of OUT variable in the IN record type

Line 768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764:
765: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
766: RAISE FND_API.G_EXC_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: --Copy value of OUT variable in the IN record type
772: lp_icgv_tbl := lx_icgv_tbl;

Line 786: WHEN FND_API.G_EXC_ERROR THEN

782: x_return_status := l_return_status ;
783:
784: EXCEPTION
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO ins_class_cats_validate;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: x_msg_count := l_msg_count ;
790: x_msg_data := l_msg_data ;

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: EXCEPTION
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO ins_class_cats_validate;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: x_msg_count := l_msg_count ;
790: x_msg_data := l_msg_data ;
791: FND_MSG_PUB.count_and_get(
792: p_count => x_msg_count

Line 794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

790: x_msg_data := l_msg_data ;
791: FND_MSG_PUB.count_and_get(
792: p_count => x_msg_count
793: ,p_data => x_msg_data);
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795: ROLLBACK TO ins_class_cats_validate;
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: x_msg_count := l_msg_count ;
798: x_msg_data := l_msg_data ;

Line 796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

792: p_count => x_msg_count
793: ,p_data => x_msg_data);
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795: ROLLBACK TO ins_class_cats_validate;
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: x_msg_count := l_msg_count ;
798: x_msg_data := l_msg_data ;
799: FND_MSG_PUB.count_and_get(
800: p_count => x_msg_count

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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