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

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

45: ,l_msg_data
46: ,lp_rasv_rec
47: ,lx_rasv_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_rasv_rec
47: ,lx_rasv_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_rasv_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_rasv_rec := lx_rasv_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 shipping_instr_create;
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 shipping_instr_create;
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 shipping_instr_create;
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 shipping_instr_create;
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 shipping_instr_create;
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_AM_SHIPPING_INSTR_PUB','create_shipping_instr');
92: FND_MSG_PUB.count_and_get(

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

134: ,l_msg_data
135: ,lp_rasv_tbl
136: ,lx_rasv_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_rasv_tbl
136: ,lx_rasv_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_rasv_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_rasv_tbl := lx_rasv_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 shipping_instr_create;
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 shipping_instr_create;
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 shipping_instr_create;
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 shipping_instr_create;
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 shipping_instr_create;
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_AM_SHIPPING_INSTR_PUB','create_shipping_instr');
180: FND_MSG_PUB.count_and_get(

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

224: ,l_msg_data
225: ,lp_rasv_rec
226: ,lx_rasv_rec);
227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;

Line 229: RAISE FND_API.G_EXC_ERROR;

225: ,lp_rasv_rec
226: ,lx_rasv_rec);
227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:

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

226: ,lx_rasv_rec);
227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: --Copy value of OUT variable in the IN record type

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227:
228: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: --Copy value of OUT variable in the IN record type
235: lp_rasv_rec := lx_rasv_rec;

Line 249: WHEN FND_API.G_EXC_ERROR THEN

245:
246:
247: EXCEPTION
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO shipping_instr_update;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: x_msg_count := l_msg_count ;
253: x_msg_data := l_msg_data ;

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: EXCEPTION
248:
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO shipping_instr_update;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: x_msg_count := l_msg_count ;
253: x_msg_data := l_msg_data ;
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count

Line 257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

253: x_msg_data := l_msg_data ;
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: ROLLBACK TO shipping_instr_update;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: x_msg_count := l_msg_count ;
261: x_msg_data := l_msg_data ;

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO shipping_instr_update;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: x_msg_count := l_msg_count ;
261: x_msg_data := l_msg_data ;
262: FND_MSG_PUB.count_and_get(
263: p_count => x_msg_count

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: p_count => x_msg_count
264: ,p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO shipping_instr_update;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: x_msg_count := l_msg_count ;
269: x_msg_data := l_msg_data ;
270: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_SHIPPING_INSTR_PUB','update_shipping_instr');
271: FND_MSG_PUB.count_and_get(

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

314: ,l_msg_data
315: ,lp_rasv_tbl
316: ,lx_rasv_tbl);
317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;

Line 319: RAISE FND_API.G_EXC_ERROR;

315: ,lp_rasv_tbl
316: ,lx_rasv_tbl);
317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:

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

316: ,lx_rasv_tbl);
317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: --Copy value of OUT variable in the IN record type

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317:
318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: --Copy value of OUT variable in the IN record type
325: lp_rasv_tbl := lx_rasv_tbl;

Line 338: WHEN FND_API.G_EXC_ERROR THEN

334:
335:
336: EXCEPTION
337:
338: WHEN FND_API.G_EXC_ERROR THEN
339: ROLLBACK TO shipping_instr_update;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: x_msg_count := l_msg_count ;
342: x_msg_data := l_msg_data ;

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: EXCEPTION
337:
338: WHEN FND_API.G_EXC_ERROR THEN
339: ROLLBACK TO shipping_instr_update;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: x_msg_count := l_msg_count ;
342: x_msg_data := l_msg_data ;
343: FND_MSG_PUB.count_and_get(
344: p_count => x_msg_count

Line 346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

342: x_msg_data := l_msg_data ;
343: FND_MSG_PUB.count_and_get(
344: p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO shipping_instr_update;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_msg_count := l_msg_count ;
350: x_msg_data := l_msg_data ;

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344: p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO shipping_instr_update;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_msg_count := l_msg_count ;
350: x_msg_data := l_msg_data ;
351: FND_MSG_PUB.count_and_get(
352: p_count => x_msg_count

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: p_count => x_msg_count
353: ,p_data => x_msg_data);
354: WHEN OTHERS THEN
355: ROLLBACK TO shipping_instr_update;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_msg_count := l_msg_count ;
358: x_msg_data := l_msg_data ;
359: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_SHIPPING_INSTR_PUB','update_shipping_instr');
360: FND_MSG_PUB.count_and_get(

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

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

Line 409: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 428: WHEN FND_API.G_EXC_ERROR THEN

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

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 498: RAISE FND_API.G_EXC_ERROR;

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

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

495: ,lx_rasv_tbl);
496:
497: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503: --Copy value of OUT variable in the IN record type

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496:
497: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503: --Copy value of OUT variable in the IN record type
504: lp_rasv_tbl := lx_rasv_tbl;

Line 517: WHEN FND_API.G_EXC_ERROR THEN

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

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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