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

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

2: /* $Header: OKLPCAHB.pls 120.3 2006/07/07 09:55:31 adagur noship $ */
3:
4: PROCEDURE insert_csh_allct_srchs(
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_cahv_rec IN cahv_rec_type

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

46: ,l_msg_data
47: ,lp_cahv_rec
48: ,lx_cahv_rec);
49:
50: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
51: RAISE Fnd_Api.G_EXC_ERROR;
52: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
53: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
54: END IF;

Line 51: RAISE Fnd_Api.G_EXC_ERROR;

47: ,lp_cahv_rec
48: ,lx_cahv_rec);
49:
50: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
51: RAISE Fnd_Api.G_EXC_ERROR;
52: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
53: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:

Line 52: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 53: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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

Line 71: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 73: x_return_status := Fnd_Api.G_RET_STS_ERROR;

69: EXCEPTION
70:
71: WHEN Fnd_Api.G_EXC_ERROR THEN
72: ROLLBACK TO csh_allct_srchs_insert;
73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.count_and_get(
77: p_count => x_msg_count

Line 79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO csh_allct_srchs_insert;
81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;

Line 81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 89: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN OTHERS THEN
88: ROLLBACK TO csh_allct_srchs_insert;
89: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;
92: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','insert_csh_allct_srchs');
93: Fnd_Msg_Pub.count_and_get(

Line 100: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

96: END insert_csh_allct_srchs;
97:
98: PROCEDURE insert_csh_allct_srchs(
99: p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_cahv_tbl IN cahv_tbl_type

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

140: ,l_msg_data
141: ,lp_cahv_tbl
142: ,lx_cahv_tbl);
143:
144: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
145: RAISE Fnd_Api.G_EXC_ERROR;
146: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
148: END IF;

Line 145: RAISE Fnd_Api.G_EXC_ERROR;

141: ,lp_cahv_tbl
142: ,lx_cahv_tbl);
143:
144: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
145: RAISE Fnd_Api.G_EXC_ERROR;
146: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:

Line 146: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

142: ,lx_cahv_tbl);
143:
144: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
145: RAISE Fnd_Api.G_EXC_ERROR;
146: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: --Copy value of OUT variable in the IN record type

Line 147: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

143:
144: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
145: RAISE Fnd_Api.G_EXC_ERROR;
146: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
147: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: --Copy value of OUT variable in the IN record type
151: lp_cahv_tbl := lx_cahv_tbl;

Line 164: WHEN Fnd_Api.G_EXC_ERROR THEN

160:
161:
162: EXCEPTION
163:
164: WHEN Fnd_Api.G_EXC_ERROR THEN
165: ROLLBACK TO csh_allct_srchs_insert;
166: x_return_status := Fnd_Api.G_RET_STS_ERROR;
167: x_msg_count := l_msg_count ;
168: x_msg_data := l_msg_data ;

Line 166: x_return_status := Fnd_Api.G_RET_STS_ERROR;

162: EXCEPTION
163:
164: WHEN Fnd_Api.G_EXC_ERROR THEN
165: ROLLBACK TO csh_allct_srchs_insert;
166: x_return_status := Fnd_Api.G_RET_STS_ERROR;
167: x_msg_count := l_msg_count ;
168: x_msg_data := l_msg_data ;
169: Fnd_Msg_Pub.count_and_get(
170: p_count => x_msg_count

Line 172: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

168: x_msg_data := l_msg_data ;
169: Fnd_Msg_Pub.count_and_get(
170: p_count => x_msg_count
171: ,p_data => x_msg_data);
172: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
173: ROLLBACK TO csh_allct_srchs_insert;
174: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
175: x_msg_count := l_msg_count ;
176: x_msg_data := l_msg_data ;

Line 174: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

170: p_count => x_msg_count
171: ,p_data => x_msg_data);
172: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
173: ROLLBACK TO csh_allct_srchs_insert;
174: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
175: x_msg_count := l_msg_count ;
176: x_msg_data := l_msg_data ;
177: Fnd_Msg_Pub.count_and_get(
178: p_count => x_msg_count

Line 182: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

178: p_count => x_msg_count
179: ,p_data => x_msg_data);
180: WHEN OTHERS THEN
181: ROLLBACK TO csh_allct_srchs_insert;
182: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
185: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','insert_csh_allct_srchs');
186: Fnd_Msg_Pub.count_and_get(

Line 193: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

189: END insert_csh_allct_srchs;
190:
191: PROCEDURE lock_csh_allct_srchs(
192: p_api_version IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
194: ,x_return_status OUT NOCOPY VARCHAR2
195: ,x_msg_count OUT NOCOPY NUMBER
196: ,x_msg_data OUT NOCOPY VARCHAR2
197: ,p_cahv_rec IN cahv_rec_type) IS

Line 208: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

204: x_msg_count,
205: x_msg_data,
206: p_cahv_rec);
207:
208: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
209: RAISE Fnd_Api.G_EXC_ERROR;
210: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
212: END IF;

Line 209: RAISE Fnd_Api.G_EXC_ERROR;

205: x_msg_data,
206: p_cahv_rec);
207:
208: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
209: RAISE Fnd_Api.G_EXC_ERROR;
210: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:

Line 210: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

206: p_cahv_rec);
207:
208: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
209: RAISE Fnd_Api.G_EXC_ERROR;
210: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214:

Line 211: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

207:
208: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
209: RAISE Fnd_Api.G_EXC_ERROR;
210: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214:
215: EXCEPTION

Line 217: WHEN Fnd_Api.G_EXC_ERROR THEN

213:
214:
215: EXCEPTION
216:
217: WHEN Fnd_Api.G_EXC_ERROR THEN
218: Fnd_Msg_Pub.count_and_get(
219: p_count => x_msg_count
220: ,p_data => x_msg_data);
221: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 221: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 226: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

222: Fnd_Msg_Pub.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: WHEN OTHERS THEN
226: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
227: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','lock_csh_allct_srchs');
228: Fnd_Msg_Pub.count_and_get(
229: p_count => x_msg_count
230: ,p_data => x_msg_data);

Line 235: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

231: END lock_csh_allct_srchs;
232:
233: PROCEDURE lock_csh_allct_srchs(
234: p_api_version IN NUMBER
235: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
236: ,x_return_status OUT NOCOPY VARCHAR2
237: ,x_msg_count OUT NOCOPY NUMBER
238: ,x_msg_data OUT NOCOPY VARCHAR2
239: ,p_cahv_tbl IN cahv_tbl_type) IS

Line 250: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

246: x_msg_count,
247: x_msg_data,
248: p_cahv_tbl);
249:
250: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
251: RAISE Fnd_Api.G_EXC_ERROR;
252: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
254: END IF;

Line 251: RAISE Fnd_Api.G_EXC_ERROR;

247: x_msg_data,
248: p_cahv_tbl);
249:
250: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
251: RAISE Fnd_Api.G_EXC_ERROR;
252: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:

Line 252: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

248: p_cahv_tbl);
249:
250: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
251: RAISE Fnd_Api.G_EXC_ERROR;
252: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256:

Line 253: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

249:
250: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
251: RAISE Fnd_Api.G_EXC_ERROR;
252: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256:
257: EXCEPTION

Line 259: WHEN Fnd_Api.G_EXC_ERROR THEN

255:
256:
257: EXCEPTION
258:
259: WHEN Fnd_Api.G_EXC_ERROR THEN
260: Fnd_Msg_Pub.count_and_get(
261: p_count => x_msg_count
262: ,p_data => x_msg_data);
263: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 263: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 268: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

264: Fnd_Msg_Pub.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: WHEN OTHERS THEN
268: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
269: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','lock_csh_allct_srchs');
270: Fnd_Msg_Pub.count_and_get(
271: p_count => x_msg_count
272: ,p_data => x_msg_data);

Line 277: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

273: END lock_csh_allct_srchs;
274:
275: PROCEDURE update_csh_allct_srchs(
276: p_api_version IN NUMBER
277: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
278: ,x_return_status OUT NOCOPY VARCHAR2
279: ,x_msg_count OUT NOCOPY NUMBER
280: ,x_msg_data OUT NOCOPY VARCHAR2
281: ,p_cahv_rec IN cahv_rec_type

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

317: ,l_msg_data
318: ,lp_cahv_rec
319: ,lx_cahv_rec);
320:
321: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
322: RAISE Fnd_Api.G_EXC_ERROR;
323: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
324: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
325: END IF;

Line 322: RAISE Fnd_Api.G_EXC_ERROR;

318: ,lp_cahv_rec
319: ,lx_cahv_rec);
320:
321: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
322: RAISE Fnd_Api.G_EXC_ERROR;
323: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
324: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:

Line 323: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 324: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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

Line 342: WHEN Fnd_Api.G_EXC_ERROR THEN

338:
339:
340: EXCEPTION
341:
342: WHEN Fnd_Api.G_EXC_ERROR THEN
343: ROLLBACK TO csh_allct_srchs_update;
344: x_return_status := Fnd_Api.G_RET_STS_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_ERROR;

340: EXCEPTION
341:
342: WHEN Fnd_Api.G_EXC_ERROR THEN
343: ROLLBACK TO csh_allct_srchs_update;
344: x_return_status := Fnd_Api.G_RET_STS_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 350: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

346: x_msg_data := l_msg_data ;
347: Fnd_Msg_Pub.count_and_get(
348: p_count => x_msg_count
349: ,p_data => x_msg_data);
350: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO csh_allct_srchs_update;
352: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
353: x_msg_count := l_msg_count ;
354: x_msg_data := l_msg_data ;

Line 352: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

348: p_count => x_msg_count
349: ,p_data => x_msg_data);
350: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO csh_allct_srchs_update;
352: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
353: x_msg_count := l_msg_count ;
354: x_msg_data := l_msg_data ;
355: Fnd_Msg_Pub.count_and_get(
356: p_count => x_msg_count

Line 360: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

356: p_count => x_msg_count
357: ,p_data => x_msg_data);
358: WHEN OTHERS THEN
359: ROLLBACK TO csh_allct_srchs_update;
360: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
361: x_msg_count := l_msg_count ;
362: x_msg_data := l_msg_data ;
363: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','update_csh_allct_srchs');
364: Fnd_Msg_Pub.count_and_get(

Line 371: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

367: END update_csh_allct_srchs;
368:
369: PROCEDURE update_csh_allct_srchs(
370: p_api_version IN NUMBER
371: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
372: ,x_return_status OUT NOCOPY VARCHAR2
373: ,x_msg_count OUT NOCOPY NUMBER
374: ,x_msg_data OUT NOCOPY VARCHAR2
375: ,p_cahv_tbl IN cahv_tbl_type

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

411: ,l_msg_data
412: ,lp_cahv_tbl
413: ,lx_cahv_tbl);
414:
415: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
416: RAISE Fnd_Api.G_EXC_ERROR;
417: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
418: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
419: END IF;

Line 416: RAISE Fnd_Api.G_EXC_ERROR;

412: ,lp_cahv_tbl
413: ,lx_cahv_tbl);
414:
415: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
416: RAISE Fnd_Api.G_EXC_ERROR;
417: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
418: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:

Line 417: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

413: ,lx_cahv_tbl);
414:
415: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
416: RAISE Fnd_Api.G_EXC_ERROR;
417: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
418: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:
421: --Copy value of OUT variable in the IN record type

Line 418: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

414:
415: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
416: RAISE Fnd_Api.G_EXC_ERROR;
417: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
418: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:
421: --Copy value of OUT variable in the IN record type
422: lp_cahv_tbl := lx_cahv_tbl;

Line 435: WHEN Fnd_Api.G_EXC_ERROR THEN

431:
432:
433: EXCEPTION
434:
435: WHEN Fnd_Api.G_EXC_ERROR THEN
436: ROLLBACK TO csh_allct_srchs_update;
437: x_return_status := Fnd_Api.G_RET_STS_ERROR;
438: x_msg_count := l_msg_count ;
439: x_msg_data := l_msg_data ;

Line 437: x_return_status := Fnd_Api.G_RET_STS_ERROR;

433: EXCEPTION
434:
435: WHEN Fnd_Api.G_EXC_ERROR THEN
436: ROLLBACK TO csh_allct_srchs_update;
437: x_return_status := Fnd_Api.G_RET_STS_ERROR;
438: x_msg_count := l_msg_count ;
439: x_msg_data := l_msg_data ;
440: Fnd_Msg_Pub.count_and_get(
441: p_count => x_msg_count

Line 443: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

439: x_msg_data := l_msg_data ;
440: Fnd_Msg_Pub.count_and_get(
441: p_count => x_msg_count
442: ,p_data => x_msg_data);
443: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
444: ROLLBACK TO csh_allct_srchs_update;
445: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
446: x_msg_count := l_msg_count ;
447: x_msg_data := l_msg_data ;

Line 445: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

441: p_count => x_msg_count
442: ,p_data => x_msg_data);
443: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
444: ROLLBACK TO csh_allct_srchs_update;
445: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
446: x_msg_count := l_msg_count ;
447: x_msg_data := l_msg_data ;
448: Fnd_Msg_Pub.count_and_get(
449: p_count => x_msg_count

Line 453: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

449: p_count => x_msg_count
450: ,p_data => x_msg_data);
451: WHEN OTHERS THEN
452: ROLLBACK TO csh_allct_srchs_update;
453: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
454: x_msg_count := l_msg_count ;
455: x_msg_data := l_msg_data ;
456: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','update_csh_allct_srchs');
457: Fnd_Msg_Pub.count_and_get(

Line 465: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

461:
462: --Put custom code for cascade delete by developer
463: PROCEDURE delete_csh_allct_srchs(
464: p_api_version IN NUMBER
465: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
466: ,x_return_status OUT NOCOPY VARCHAR2
467: ,x_msg_count OUT NOCOPY NUMBER
468: ,x_msg_data OUT NOCOPY VARCHAR2
469: ,p_cahv_rec IN cahv_rec_type) IS

Line 472: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

468: ,x_msg_data OUT NOCOPY VARCHAR2
469: ,p_cahv_rec IN cahv_rec_type) IS
470:
471: i NUMBER :=0;
472: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
473: l_api_version NUMBER ;
474: l_init_msg_list VARCHAR2(1) ;
475: l_msg_data VARCHAR2(2000);
476: l_msg_count NUMBER ;

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

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

Line 505: RAISE Fnd_Api.G_EXC_ERROR;

501: ,l_msg_data
502: ,lp_cahv_rec);
503:
504: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
505: RAISE Fnd_Api.G_EXC_ERROR;
506: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
507: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:

Line 506: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

502: ,lp_cahv_rec);
503:
504: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
505: RAISE Fnd_Api.G_EXC_ERROR;
506: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
507: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510:

Line 507: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

503:
504: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
505: RAISE Fnd_Api.G_EXC_ERROR;
506: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
507: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510:
511:

Line 521: WHEN Fnd_Api.G_EXC_ERROR THEN

517: x_return_status := l_return_status ;
518:
519: EXCEPTION
520:
521: WHEN Fnd_Api.G_EXC_ERROR THEN
522: ROLLBACK TO csh_allct_srchs_delete_rec;
523: x_return_status := Fnd_Api.G_RET_STS_ERROR;
524: x_msg_count := l_msg_count ;
525: x_msg_data := l_msg_data ;

Line 523: x_return_status := Fnd_Api.G_RET_STS_ERROR;

519: EXCEPTION
520:
521: WHEN Fnd_Api.G_EXC_ERROR THEN
522: ROLLBACK TO csh_allct_srchs_delete_rec;
523: x_return_status := Fnd_Api.G_RET_STS_ERROR;
524: x_msg_count := l_msg_count ;
525: x_msg_data := l_msg_data ;
526: Fnd_Msg_Pub.count_and_get(
527: p_count => x_msg_count

Line 529: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

525: x_msg_data := l_msg_data ;
526: Fnd_Msg_Pub.count_and_get(
527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO csh_allct_srchs_delete_rec;
531: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
532: x_msg_count := l_msg_count ;
533: x_msg_data := l_msg_data ;

Line 531: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO csh_allct_srchs_delete_rec;
531: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
532: x_msg_count := l_msg_count ;
533: x_msg_data := l_msg_data ;
534: Fnd_Msg_Pub.count_and_get(
535: p_count => x_msg_count

Line 539: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

535: p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN OTHERS THEN
538: ROLLBACK TO csh_allct_srchs_delete_rec;
539: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
540: x_msg_count := l_msg_count ;
541: x_msg_data := l_msg_data ;
542: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','delete_csh_allct_srchs');
543: Fnd_Msg_Pub.count_and_get(

Line 550: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

546: END delete_csh_allct_srchs;
547:
548: PROCEDURE delete_csh_allct_srchs(
549: p_api_version IN NUMBER
550: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
551: ,x_return_status OUT NOCOPY VARCHAR2
552: ,x_msg_count OUT NOCOPY NUMBER
553: ,x_msg_data OUT NOCOPY VARCHAR2
554: ,p_cahv_tbl IN cahv_tbl_type) IS

Line 557: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

553: ,x_msg_data OUT NOCOPY VARCHAR2
554: ,p_cahv_tbl IN cahv_tbl_type) IS
555:
556: i NUMBER := 0;
557: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
558: l_api_version NUMBER := p_api_version ;
559: l_init_msg_list VARCHAR2(1) := p_init_msg_list ;
560: l_msg_data VARCHAR2(2000);
561: l_msg_count NUMBER ;

Line 582: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;

578:
579:
580: BEGIN
581: --Initialize the return status
582: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
583:
584: IF (lp_cahv_tbl.COUNT > 0) THEN
585: i := p_cahv_tbl.FIRST;
586: LOOP

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

594: EXIT WHEN (i = lp_cahv_tbl.LAST);
595: i := p_cahv_tbl.NEXT(i);
596: END LOOP;
597: END IF;
598: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
599: RAISE Fnd_Api.G_EXC_ERROR;
600: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
601: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
602: END IF;

Line 599: RAISE Fnd_Api.G_EXC_ERROR;

595: i := p_cahv_tbl.NEXT(i);
596: END LOOP;
597: END IF;
598: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
599: RAISE Fnd_Api.G_EXC_ERROR;
600: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
601: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:

Line 600: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

596: END LOOP;
597: END IF;
598: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
599: RAISE Fnd_Api.G_EXC_ERROR;
600: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
601: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: END;

Line 601: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

597: END IF;
598: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
599: RAISE Fnd_Api.G_EXC_ERROR;
600: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
601: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: END;
605:

Line 618: WHEN Fnd_Api.G_EXC_ERROR THEN

614: x_return_status := l_return_status ;
615:
616: EXCEPTION
617:
618: WHEN Fnd_Api.G_EXC_ERROR THEN
619: ROLLBACK TO csh_allct_srchs_delete_tbl;
620: x_return_status := Fnd_Api.G_RET_STS_ERROR;
621: x_msg_count := l_msg_count ;
622: x_msg_data := l_msg_data ;

Line 620: x_return_status := Fnd_Api.G_RET_STS_ERROR;

616: EXCEPTION
617:
618: WHEN Fnd_Api.G_EXC_ERROR THEN
619: ROLLBACK TO csh_allct_srchs_delete_tbl;
620: x_return_status := Fnd_Api.G_RET_STS_ERROR;
621: x_msg_count := l_msg_count ;
622: x_msg_data := l_msg_data ;
623: Fnd_Msg_Pub.count_and_get(
624: p_count => x_msg_count

Line 626: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

622: x_msg_data := l_msg_data ;
623: Fnd_Msg_Pub.count_and_get(
624: p_count => x_msg_count
625: ,p_data => x_msg_data);
626: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO csh_allct_srchs_delete_tbl;
628: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
629: x_msg_count := l_msg_count ;
630: x_msg_data := l_msg_data ;

Line 628: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

624: p_count => x_msg_count
625: ,p_data => x_msg_data);
626: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO csh_allct_srchs_delete_tbl;
628: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
629: x_msg_count := l_msg_count ;
630: x_msg_data := l_msg_data ;
631: Fnd_Msg_Pub.count_and_get(
632: p_count => x_msg_count

Line 636: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

632: p_count => x_msg_count
633: ,p_data => x_msg_data);
634: WHEN OTHERS THEN
635: ROLLBACK TO csh_allct_srchs_delete_tbl;
636: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
637: x_msg_count := l_msg_count ;
638: x_msg_data := l_msg_data ;
639: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','delete_csh_allct_srchs');
640: Fnd_Msg_Pub.count_and_get(

Line 647: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE

643: END delete_csh_allct_srchs;
644:
645: PROCEDURE validate_csh_allct_srchs(
646: p_api_version IN NUMBER
647: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_cahv_rec IN cahv_rec_type) IS

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

680: ,l_msg_count
681: ,l_msg_data
682: ,lp_cahv_rec);
683:
684: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
685: RAISE Fnd_Api.G_EXC_ERROR;
686: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
687: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
688: END IF;

Line 685: RAISE Fnd_Api.G_EXC_ERROR;

681: ,l_msg_data
682: ,lp_cahv_rec);
683:
684: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
685: RAISE Fnd_Api.G_EXC_ERROR;
686: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
687: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
688: END IF;
689:

Line 686: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

682: ,lp_cahv_rec);
683:
684: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
685: RAISE Fnd_Api.G_EXC_ERROR;
686: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
687: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
688: END IF;
689:
690: --Copy value of OUT variable in the IN record type

Line 687: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

683:
684: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
685: RAISE Fnd_Api.G_EXC_ERROR;
686: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
687: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
688: END IF;
689:
690: --Copy value of OUT variable in the IN record type
691: lp_cahv_rec := lx_cahv_rec;

Line 708: WHEN Fnd_Api.G_EXC_ERROR THEN

704: x_return_status := l_return_status ;
705:
706: EXCEPTION
707:
708: WHEN Fnd_Api.G_EXC_ERROR THEN
709: ROLLBACK TO csh_allct_srchs_validate;
710: x_return_status := Fnd_Api.G_RET_STS_ERROR;
711: x_msg_count := l_msg_count ;
712: x_msg_data := l_msg_data ;

Line 710: x_return_status := Fnd_Api.G_RET_STS_ERROR;

706: EXCEPTION
707:
708: WHEN Fnd_Api.G_EXC_ERROR THEN
709: ROLLBACK TO csh_allct_srchs_validate;
710: x_return_status := Fnd_Api.G_RET_STS_ERROR;
711: x_msg_count := l_msg_count ;
712: x_msg_data := l_msg_data ;
713: Fnd_Msg_Pub.count_and_get(
714: p_count => x_msg_count

Line 716: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

712: x_msg_data := l_msg_data ;
713: Fnd_Msg_Pub.count_and_get(
714: p_count => x_msg_count
715: ,p_data => x_msg_data);
716: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
717: ROLLBACK TO csh_allct_srchs_validate;
718: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
719: x_msg_count := l_msg_count ;
720: x_msg_data := l_msg_data ;

Line 718: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

714: p_count => x_msg_count
715: ,p_data => x_msg_data);
716: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
717: ROLLBACK TO csh_allct_srchs_validate;
718: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
719: x_msg_count := l_msg_count ;
720: x_msg_data := l_msg_data ;
721: Fnd_Msg_Pub.count_and_get(
722: p_count => x_msg_count

Line 726: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

722: p_count => x_msg_count
723: ,p_data => x_msg_data);
724: WHEN OTHERS THEN
725: ROLLBACK TO csh_allct_srchs_validate;
726: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
727: x_msg_count := l_msg_count ;
728: x_msg_data := l_msg_data ;
729: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','validate_csh_allct_srchs');
730: Fnd_Msg_Pub.count_and_get(

Line 737: p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,

733: END validate_csh_allct_srchs;
734:
735: PROCEDURE validate_csh_allct_srchs(
736: p_api_version IN NUMBER,
737: p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
738: x_return_status OUT NOCOPY VARCHAR2,
739: x_msg_count OUT NOCOPY NUMBER,
740: x_msg_data OUT NOCOPY VARCHAR2,
741: p_cahv_tbl IN cahv_tbl_type) IS

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

768: ,x_msg_count
769: ,x_msg_data
770: ,lp_cahv_tbl);
771:
772: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
773: RAISE Fnd_Api.G_EXC_ERROR;
774: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
776: END IF;

Line 773: RAISE Fnd_Api.G_EXC_ERROR;

769: ,x_msg_data
770: ,lp_cahv_tbl);
771:
772: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
773: RAISE Fnd_Api.G_EXC_ERROR;
774: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:

Line 774: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

770: ,lp_cahv_tbl);
771:
772: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
773: RAISE Fnd_Api.G_EXC_ERROR;
774: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: --Copy value of OUT variable in the IN record type

Line 775: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

771:
772: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
773: RAISE Fnd_Api.G_EXC_ERROR;
774: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: --Copy value of OUT variable in the IN record type
779: lp_cahv_tbl := lx_cahv_tbl;

Line 793: WHEN Fnd_Api.G_EXC_ERROR THEN

789: x_return_status := l_return_status ;
790:
791: EXCEPTION
792:
793: WHEN Fnd_Api.G_EXC_ERROR THEN
794: ROLLBACK TO csh_allct_srchs_validate;
795: x_return_status := Fnd_Api.G_RET_STS_ERROR;
796: x_msg_count := l_msg_count ;
797: x_msg_data := l_msg_data ;

Line 795: x_return_status := Fnd_Api.G_RET_STS_ERROR;

791: EXCEPTION
792:
793: WHEN Fnd_Api.G_EXC_ERROR THEN
794: ROLLBACK TO csh_allct_srchs_validate;
795: x_return_status := Fnd_Api.G_RET_STS_ERROR;
796: x_msg_count := l_msg_count ;
797: x_msg_data := l_msg_data ;
798: Fnd_Msg_Pub.count_and_get(
799: p_count => x_msg_count

Line 801: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

797: x_msg_data := l_msg_data ;
798: Fnd_Msg_Pub.count_and_get(
799: p_count => x_msg_count
800: ,p_data => x_msg_data);
801: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO csh_allct_srchs_validate;
803: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
804: x_msg_count := l_msg_count ;
805: x_msg_data := l_msg_data ;

Line 803: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

799: p_count => x_msg_count
800: ,p_data => x_msg_data);
801: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO csh_allct_srchs_validate;
803: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
804: x_msg_count := l_msg_count ;
805: x_msg_data := l_msg_data ;
806: Fnd_Msg_Pub.count_and_get(
807: p_count => x_msg_count

Line 811: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

807: p_count => x_msg_count
808: ,p_data => x_msg_data);
809: WHEN OTHERS THEN
810: ROLLBACK TO csh_allct_srchs_validate;
811: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
812: x_msg_count := l_msg_count ;
813: x_msg_data := l_msg_data ;
814: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_SRCHS_PUB','validate_csh_allct_srchs');
815: Fnd_Msg_Pub.count_and_get(