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

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

2: /* $Header: OKLPSLXB.pls 115.5 2004/04/13 11:17:41 rnaik noship $ */
3:
4: PROCEDURE insert_strm_type_exempt(
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_slxv_rec IN slxv_rec_type

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

45: ,l_msg_data
46: ,lp_slxv_rec
47: ,lx_slxv_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_slxv_rec
47: ,lx_slxv_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_slxv_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_slxv_rec := lx_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','insert_strm_type_exempt');
92: Fnd_Msg_Pub.count_and_get(

Line 99: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

95: END insert_strm_type_exempt;
96:
97: PROCEDURE insert_strm_type_exempt(
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_slxv_tbl IN slxv_tbl_type

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

134: ,l_msg_data
135: ,lp_slxv_tbl
136: ,lx_slxv_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_slxv_tbl
136: ,lx_slxv_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_slxv_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_slxv_tbl := lx_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','insert_strm_type_exempt');
180: Fnd_Msg_Pub.count_and_get(

Line 187: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

183: END insert_strm_type_exempt;
184:
185: PROCEDURE lock_strm_type_exempt(
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_slxv_rec IN slxv_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_slxv_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_slxv_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_slxv_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_STRM_TYPE_EXEMPT_PUB','lock_strm_type_exempt');
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_strm_type_exempt;
226:
227: PROCEDURE lock_strm_type_exempt(
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_slxv_tbl IN slxv_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_slxv_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_slxv_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_slxv_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_STRM_TYPE_EXEMPT_PUB','lock_strm_type_exempt');
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_strm_type_exempt;
268:
269: PROCEDURE update_strm_type_exempt(
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_slxv_rec IN slxv_rec_type

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

308: ,l_msg_data
309: ,lp_slxv_rec
310: ,lx_slxv_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_slxv_rec
310: ,lx_slxv_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_slxv_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_slxv_rec := lx_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','update_strm_type_exempt');
355: Fnd_Msg_Pub.count_and_get(

Line 362: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

358: END update_strm_type_exempt;
359:
360: PROCEDURE update_strm_type_exempt(
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_slxv_tbl IN slxv_tbl_type

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

398: ,l_msg_data
399: ,lp_slxv_tbl
400: ,lx_slxv_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_slxv_tbl
400: ,lx_slxv_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_slxv_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_slxv_tbl := lx_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','update_strm_type_exempt');
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_strm_type_exempt(
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_slxv_rec IN slxv_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_slxv_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_slxv_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_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','delete_strm_type_exempt');
530: Fnd_Msg_Pub.count_and_get(

Line 537: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

533: END delete_strm_type_exempt;
534:
535: PROCEDURE delete_strm_type_exempt(
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_slxv_tbl IN slxv_tbl_type) IS

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

581: EXIT WHEN (i = lp_slxv_tbl.LAST);
582: i := p_slxv_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_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','delete_strm_type_exempt');
627: Fnd_Msg_Pub.count_and_get(

Line 634: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

630: END delete_strm_type_exempt;
631:
632: PROCEDURE validate_strm_type_exempt(
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_slxv_rec IN slxv_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_slxv_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_slxv_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_slxv_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_slxv_rec := lx_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','validate_strm_type_exempt');
717: Fnd_Msg_Pub.count_and_get(

Line 724: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

720: END validate_strm_type_exempt;
721:
722: PROCEDURE validate_strm_type_exempt(
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_slxv_tbl IN slxv_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_slxv_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_slxv_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_slxv_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_slxv_tbl := lx_slxv_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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 strm_type_exempt_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_STRM_TYPE_EXEMPT_PUB','validate_strm_type_exempt');
802: Fnd_Msg_Pub.count_and_get(