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

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2: /* $Header: OKLPCLGB.pls 120.4 2006/07/13 12:21:39 adagur noship $ */
3:
4: PROCEDURE insert_cntr_lvlng_grps(
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_clgv_rec IN clgv_rec_type

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

48: ,l_msg_data
49: ,lp_clgv_rec
50: ,lx_clgv_rec);
51:
52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;

Line 53: RAISE FND_API.G_EXC_ERROR;

49: ,lp_clgv_rec
50: ,lx_clgv_rec);
51:
52: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:

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

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

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 73: WHEN FND_API.G_EXC_ERROR THEN

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

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 102: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

98: END insert_cntr_lvlng_grps;
99:
100: PROCEDURE insert_cntr_lvlng_grps(
101: p_api_version IN NUMBER
102: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
106: ,p_clgv_tbl IN clgv_tbl_type

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

144: ,l_msg_data
145: ,lp_clgv_tbl
146: ,lx_clgv_tbl);
147:
148: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
149: RAISE FND_API.G_EXC_ERROR;
150: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;

Line 149: RAISE FND_API.G_EXC_ERROR;

145: ,lp_clgv_tbl
146: ,lx_clgv_tbl);
147:
148: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
149: RAISE FND_API.G_EXC_ERROR;
150: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:

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

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

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 168: WHEN FND_API.G_EXC_ERROR THEN

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

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 197: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

193: END insert_cntr_lvlng_grps;
194:
195: PROCEDURE lock_cntr_lvlng_grps(
196: p_api_version IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
198: ,x_return_status OUT NOCOPY VARCHAR2
199: ,x_msg_count OUT NOCOPY NUMBER
200: ,x_msg_data OUT NOCOPY VARCHAR2
201: ,p_clgv_rec IN clgv_rec_type) IS

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

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

Line 213: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 221: WHEN FND_API.G_EXC_ERROR THEN

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

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 239: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

235: END lock_cntr_lvlng_grps;
236:
237: PROCEDURE lock_cntr_lvlng_grps(
238: p_api_version IN NUMBER
239: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
240: ,x_return_status OUT NOCOPY VARCHAR2
241: ,x_msg_count OUT NOCOPY NUMBER
242: ,x_msg_data OUT NOCOPY VARCHAR2
243: ,p_clgv_tbl IN clgv_tbl_type) IS

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

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

Line 255: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 263: WHEN FND_API.G_EXC_ERROR THEN

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

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 281: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

277: END lock_cntr_lvlng_grps;
278:
279: PROCEDURE update_cntr_lvlng_grps(
280: p_api_version IN NUMBER
281: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
282: ,x_return_status OUT NOCOPY VARCHAR2
283: ,x_msg_count OUT NOCOPY NUMBER
284: ,x_msg_data OUT NOCOPY VARCHAR2
285: ,p_clgv_rec IN clgv_rec_type

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

318: ,l_msg_data
319: ,lp_clgv_rec
320: ,lx_clgv_rec);
321:
322: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
323: RAISE FND_API.G_EXC_ERROR;
324: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
326: END IF;

Line 323: RAISE FND_API.G_EXC_ERROR;

319: ,lp_clgv_rec
320: ,lx_clgv_rec);
321:
322: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
323: RAISE FND_API.G_EXC_ERROR;
324: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
326: END IF;
327:

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

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

Line 325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339:
340:
341: EXCEPTION
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO cntr_lvlng_grps_update;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: x_msg_count := l_msg_count ;
347: x_msg_data := l_msg_data ;

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: EXCEPTION
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO cntr_lvlng_grps_update;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: x_msg_count := l_msg_count ;
347: x_msg_data := l_msg_data ;
348: FND_MSG_PUB.count_and_get(
349: p_count => x_msg_count

Line 351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: WHEN OTHERS THEN
360: ROLLBACK TO cntr_lvlng_grps_update;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_msg_count := l_msg_count ;
363: x_msg_data := l_msg_data ;
364: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');
365: FND_MSG_PUB.count_and_get(

Line 372: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

368: END update_cntr_lvlng_grps;
369:
370: PROCEDURE update_cntr_lvlng_grps(
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
375: ,x_msg_data OUT NOCOPY VARCHAR2
376: ,p_clgv_tbl IN clgv_tbl_type

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

408: ,l_msg_data
409: ,lp_clgv_tbl
410: ,lx_clgv_tbl);
411:
412: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
413: RAISE FND_API.G_EXC_ERROR;
414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;

Line 413: RAISE FND_API.G_EXC_ERROR;

409: ,lp_clgv_tbl
410: ,lx_clgv_tbl);
411:
412: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
413: RAISE FND_API.G_EXC_ERROR;
414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:

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

410: ,lx_clgv_tbl);
411:
412: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
413: RAISE FND_API.G_EXC_ERROR;
414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: --Copy value of OUT variable in the IN record type

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411:
412: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
413: RAISE FND_API.G_EXC_ERROR;
414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: --Copy value of OUT variable in the IN record type
419: lp_clgv_tbl := lx_clgv_tbl;

Line 432: WHEN FND_API.G_EXC_ERROR THEN

428:
429:
430: EXCEPTION
431:
432: WHEN FND_API.G_EXC_ERROR THEN
433: ROLLBACK TO cntr_lvlng_grps_update;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: x_msg_count := l_msg_count ;
436: x_msg_data := l_msg_data ;

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430: EXCEPTION
431:
432: WHEN FND_API.G_EXC_ERROR THEN
433: ROLLBACK TO cntr_lvlng_grps_update;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: x_msg_count := l_msg_count ;
436: x_msg_data := l_msg_data ;
437: FND_MSG_PUB.count_and_get(
438: p_count => x_msg_count

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO cntr_lvlng_grps_update;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: x_msg_count := l_msg_count ;
444: x_msg_data := l_msg_data ;
445: FND_MSG_PUB.count_and_get(
446: p_count => x_msg_count

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

446: p_count => x_msg_count
447: ,p_data => x_msg_data);
448: WHEN OTHERS THEN
449: ROLLBACK TO cntr_lvlng_grps_update;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: x_msg_count := l_msg_count ;
452: x_msg_data := l_msg_data ;
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','update_cntr_lvlng_grps');
454: FND_MSG_PUB.count_and_get(

Line 462: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

458:
459: --Put custom code for cascade delete by developer
460: PROCEDURE delete_cntr_lvlng_grps(
461: p_api_version IN NUMBER
462: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
463: ,x_return_status OUT NOCOPY VARCHAR2
464: ,x_msg_count OUT NOCOPY NUMBER
465: ,x_msg_data OUT NOCOPY VARCHAR2
466: ,p_clgv_rec IN clgv_rec_type) IS

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

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

Line 502: RAISE FND_API.G_EXC_ERROR;

498: ,l_msg_data
499: ,lp_clgv_rec);
500:
501: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:

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

499: ,lp_clgv_rec);
500:
501: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507:

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500:
501: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507:
508:

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514: x_return_status := l_return_status ;
515:
516: EXCEPTION
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: ROLLBACK TO cntr_lvlng_grps_delete_rec;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: x_msg_count := l_msg_count ;
522: x_msg_data := l_msg_data ;

Line 520: x_return_status := FND_API.G_RET_STS_ERROR;

516: EXCEPTION
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: ROLLBACK TO cntr_lvlng_grps_delete_rec;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: x_msg_count := l_msg_count ;
522: x_msg_data := l_msg_data ;
523: FND_MSG_PUB.count_and_get(
524: p_count => x_msg_count

Line 526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: p_count => x_msg_count
525: ,p_data => x_msg_data);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: ROLLBACK TO cntr_lvlng_grps_delete_rec;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: x_msg_count := l_msg_count ;
530: x_msg_data := l_msg_data ;
531: FND_MSG_PUB.count_and_get(
532: p_count => x_msg_count

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

532: p_count => x_msg_count
533: ,p_data => x_msg_data);
534: WHEN OTHERS THEN
535: ROLLBACK TO cntr_lvlng_grps_delete_rec;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: x_msg_count := l_msg_count ;
538: x_msg_data := l_msg_data ;
539: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');
540: FND_MSG_PUB.count_and_get(

Line 547: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

543: END delete_cntr_lvlng_grps;
544:
545: PROCEDURE delete_cntr_lvlng_grps(
546: p_api_version IN NUMBER
547: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
548: ,x_return_status OUT NOCOPY VARCHAR2
549: ,x_msg_count OUT NOCOPY NUMBER
550: ,x_msg_data OUT NOCOPY VARCHAR2
551: ,p_clgv_tbl IN clgv_tbl_type) IS

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

591: EXIT WHEN (i = lp_clgv_tbl.LAST);
592: i := p_clgv_tbl.NEXT(i);
593: END LOOP;
594: END IF;
595: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;

Line 596: RAISE FND_API.G_EXC_ERROR;

592: i := p_clgv_tbl.NEXT(i);
593: END LOOP;
594: END IF;
595: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:

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

593: END LOOP;
594: END IF;
595: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:
601: END;

Line 598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

594: END IF;
595: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:
601: END;
602:

Line 615: WHEN FND_API.G_EXC_ERROR THEN

611: x_return_status := l_return_status ;
612:
613: EXCEPTION
614:
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: x_msg_count := l_msg_count ;
619: x_msg_data := l_msg_data ;

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: EXCEPTION
614:
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: x_msg_count := l_msg_count ;
619: x_msg_data := l_msg_data ;
620: FND_MSG_PUB.count_and_get(
621: p_count => x_msg_count

Line 623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: p_count => x_msg_count
622: ,p_data => x_msg_data);
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: x_msg_count := l_msg_count ;
627: x_msg_data := l_msg_data ;
628: FND_MSG_PUB.count_and_get(
629: p_count => x_msg_count

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: p_count => x_msg_count
630: ,p_data => x_msg_data);
631: WHEN OTHERS THEN
632: ROLLBACK TO cntr_lvlng_grps_delete_tbl;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: x_msg_count := l_msg_count ;
635: x_msg_data := l_msg_data ;
636: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','delete_cntr_lvlng_grps');
637: FND_MSG_PUB.count_and_get(

Line 644: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

640: END delete_cntr_lvlng_grps;
641:
642: PROCEDURE validate_cntr_lvlng_grps(
643: p_api_version IN NUMBER
644: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
645: ,x_return_status OUT NOCOPY VARCHAR2
646: ,x_msg_count OUT NOCOPY NUMBER
647: ,x_msg_data OUT NOCOPY VARCHAR2
648: ,p_clgv_rec IN clgv_rec_type) IS

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

677: ,l_msg_count
678: ,l_msg_data
679: ,lp_clgv_rec);
680:
681: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;

Line 682: RAISE FND_API.G_EXC_ERROR;

678: ,l_msg_data
679: ,lp_clgv_rec);
680:
681: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:

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

679: ,lp_clgv_rec);
680:
681: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: --Copy value of OUT variable in the IN record type

Line 684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

680:
681: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: --Copy value of OUT variable in the IN record type
688: lp_clgv_rec := lx_clgv_rec;

Line 705: WHEN FND_API.G_EXC_ERROR THEN

701: x_return_status := l_return_status ;
702:
703: EXCEPTION
704:
705: WHEN FND_API.G_EXC_ERROR THEN
706: ROLLBACK TO cntr_lvlng_grps_validate;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: x_msg_count := l_msg_count ;
709: x_msg_data := l_msg_data ;

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: EXCEPTION
704:
705: WHEN FND_API.G_EXC_ERROR THEN
706: ROLLBACK TO cntr_lvlng_grps_validate;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: x_msg_count := l_msg_count ;
709: x_msg_data := l_msg_data ;
710: FND_MSG_PUB.count_and_get(
711: p_count => x_msg_count

Line 713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: p_count => x_msg_count
712: ,p_data => x_msg_data);
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: ROLLBACK TO cntr_lvlng_grps_validate;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_msg_count := l_msg_count ;
717: x_msg_data := l_msg_data ;
718: FND_MSG_PUB.count_and_get(
719: p_count => x_msg_count

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: p_count => x_msg_count
720: ,p_data => x_msg_data);
721: WHEN OTHERS THEN
722: ROLLBACK TO cntr_lvlng_grps_validate;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: x_msg_count := l_msg_count ;
725: x_msg_data := l_msg_data ;
726: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');
727: FND_MSG_PUB.count_and_get(

Line 734: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

730: END validate_cntr_lvlng_grps;
731:
732: PROCEDURE validate_cntr_lvlng_grps(
733: p_api_version IN NUMBER,
734: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
735: x_return_status OUT NOCOPY VARCHAR2,
736: x_msg_count OUT NOCOPY NUMBER,
737: x_msg_data OUT NOCOPY VARCHAR2,
738: p_clgv_tbl IN clgv_tbl_type) IS

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

765: ,x_msg_count
766: ,x_msg_data
767: ,lp_clgv_tbl);
768:
769: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;

Line 770: RAISE FND_API.G_EXC_ERROR;

766: ,x_msg_data
767: ,lp_clgv_tbl);
768:
769: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774:

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

767: ,lp_clgv_tbl);
768:
769: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774:
775: --Copy value of OUT variable in the IN record type

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

768:
769: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
770: RAISE FND_API.G_EXC_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774:
775: --Copy value of OUT variable in the IN record type
776: lp_clgv_tbl := lx_clgv_tbl;

Line 790: WHEN FND_API.G_EXC_ERROR THEN

786: x_return_status := l_return_status ;
787:
788: EXCEPTION
789:
790: WHEN FND_API.G_EXC_ERROR THEN
791: ROLLBACK TO cntr_lvlng_grps_validate;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: x_msg_count := l_msg_count ;
794: x_msg_data := l_msg_data ;

Line 792: x_return_status := FND_API.G_RET_STS_ERROR;

788: EXCEPTION
789:
790: WHEN FND_API.G_EXC_ERROR THEN
791: ROLLBACK TO cntr_lvlng_grps_validate;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: x_msg_count := l_msg_count ;
794: x_msg_data := l_msg_data ;
795: FND_MSG_PUB.count_and_get(
796: p_count => x_msg_count

Line 798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO cntr_lvlng_grps_validate;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: x_msg_count := l_msg_count ;
802: x_msg_data := l_msg_data ;
803: FND_MSG_PUB.count_and_get(
804: p_count => x_msg_count

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: p_count => x_msg_count
805: ,p_data => x_msg_data);
806: WHEN OTHERS THEN
807: ROLLBACK TO cntr_lvlng_grps_validate;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_msg_count := l_msg_count ;
810: x_msg_data := l_msg_data ;
811: FND_MSG_PUB.ADD_EXC_MSG('OKL_CNTR_LVLNG_GRPS_PUB','validate_cntr_lvlng_grps');
812: FND_MSG_PUB.count_and_get(