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_CS_TRANSACTIONS_PUB dependencies on OKL_API

Line 48: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

44: x_return_status => l_return_status,
45: x_msg_count => l_msg_count,
46: x_msg_data => l_msg_data);
47:
48: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;

Line 49: RAISE OKL_API.G_EXCEPTION_ERROR;

45: x_msg_count => l_msg_count,
46: x_msg_data => l_msg_data);
47:
48: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
53:

Line 50: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

46: x_msg_data => l_msg_data);
47:
48: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
53:
54:

Line 51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

47:
48: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
53:
54:
55:

Line 63: WHEN OKL_API.G_EXCEPTION_ERROR THEN

59:
60:
61: EXCEPTION
62:
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: ROLLBACK TO get_totals;
65: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
67: p_data => x_msg_data);

Line 65: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

61: EXCEPTION
62:
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: ROLLBACK TO get_totals;
65: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
67: p_data => x_msg_data);
68:
69: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 69: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

65: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
67: p_data => x_msg_data);
68:
69: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
70: ROLLBACK TO get_totals;
71: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
73: p_data => x_msg_data);

Line 71: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

67: p_data => x_msg_data);
68:
69: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
70: ROLLBACK TO get_totals;
71: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
73: p_data => x_msg_data);
74:
75: WHEN OTHERS THEN

Line 77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

73: p_data => x_msg_data);
74:
75: WHEN OTHERS THEN
76: ROLLBACK TO get_totals;
77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,'get_totals');
79: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
80: p_data => x_msg_data);
81:

Line 117: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

113: x_return_status => l_return_status,
114: x_msg_count => l_msg_count,
115: x_msg_data => l_msg_data);
116:
117: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: END IF;

Line 118: RAISE OKL_API.G_EXCEPTION_ERROR;

114: x_msg_count => l_msg_count,
115: x_msg_data => l_msg_data);
116:
117: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: END IF;
122:

Line 119: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

115: x_msg_data => l_msg_data);
116:
117: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: END IF;
122:
123:

Line 120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

116:
117: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: END IF;
122:
123:
124:

Line 132: WHEN OKL_API.G_EXCEPTION_ERROR THEN

128:
129:
130: EXCEPTION
131:
132: WHEN OKL_API.G_EXCEPTION_ERROR THEN
133: ROLLBACK TO get_svf_info;
134: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);

Line 134: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

130: EXCEPTION
131:
132: WHEN OKL_API.G_EXCEPTION_ERROR THEN
133: ROLLBACK TO get_svf_info;
134: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);
137:
138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

134: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
136: p_data => x_msg_data);
137:
138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: ROLLBACK TO get_svf_info;
140: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
142: p_data => x_msg_data);

Line 140: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

136: p_data => x_msg_data);
137:
138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: ROLLBACK TO get_svf_info;
140: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
142: p_data => x_msg_data);
143:
144: WHEN OTHERS THEN

Line 146: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

142: p_data => x_msg_data);
143:
144: WHEN OTHERS THEN
145: ROLLBACK TO get_svf_info;
146: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
147: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'get_svf_info');
148: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
149: p_data => x_msg_data);
150:

Line 199: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

195: x_return_status => l_return_status,
196: x_msg_count => l_msg_count,
197: x_msg_data => l_msg_data);
198:
199: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
203: END IF;

Line 200: RAISE OKL_API.G_EXCEPTION_ERROR;

196: x_msg_count => l_msg_count,
197: x_msg_data => l_msg_data);
198:
199: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
203: END IF;
204:

Line 201: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

197: x_msg_data => l_msg_data);
198:
199: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
203: END IF;
204:
205:

Line 202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

198:
199: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
200: RAISE OKL_API.G_EXCEPTION_ERROR;
201: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
203: END IF;
204:
205:
206:

Line 214: WHEN OKL_API.G_EXCEPTION_ERROR THEN

210:
211:
212: EXCEPTION
213:
214: WHEN OKL_API.G_EXCEPTION_ERROR THEN
215: ROLLBACK TO get_credit_memo_info;
216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
218: p_data => x_msg_data);

Line 216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

212: EXCEPTION
213:
214: WHEN OKL_API.G_EXCEPTION_ERROR THEN
215: ROLLBACK TO get_credit_memo_info;
216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
218: p_data => x_msg_data);
219:
220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
218: p_data => x_msg_data);
219:
220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
221: ROLLBACK TO get_credit_memo_info;
222: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
223: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
224: p_data => x_msg_data);

Line 222: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

218: p_data => x_msg_data);
219:
220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
221: ROLLBACK TO get_credit_memo_info;
222: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
223: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
224: p_data => x_msg_data);
225:
226: WHEN OTHERS THEN

Line 228: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

224: p_data => x_msg_data);
225:
226: WHEN OTHERS THEN
227: ROLLBACK TO get_credit_memo_info;
228: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
229: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'get_credit_memo_info');
230: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
231: p_data => x_msg_data);
232:

Line 264: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

260: x_return_status => l_return_status,
261: x_msg_count => l_msg_count,
262: x_msg_data => l_msg_data);
263:
264: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: RAISE OKL_API.G_EXCEPTION_ERROR;
266: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;

Line 265: RAISE OKL_API.G_EXCEPTION_ERROR;

261: x_msg_count => l_msg_count,
262: x_msg_data => l_msg_data);
263:
264: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: RAISE OKL_API.G_EXCEPTION_ERROR;
266: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;
269:

Line 266: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

262: x_msg_data => l_msg_data);
263:
264: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: RAISE OKL_API.G_EXCEPTION_ERROR;
266: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;
269:
270:

Line 267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

263:
264: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
265: RAISE OKL_API.G_EXCEPTION_ERROR;
266: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;
269:
270:
271:

Line 279: WHEN OKL_API.G_EXCEPTION_ERROR THEN

275:
276:
277: EXCEPTION
278:
279: WHEN OKL_API.G_EXCEPTION_ERROR THEN
280: ROLLBACK TO check_process_template;
281: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
283: p_data => x_msg_data);

Line 281: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

277: EXCEPTION
278:
279: WHEN OKL_API.G_EXCEPTION_ERROR THEN
280: ROLLBACK TO check_process_template;
281: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
283: p_data => x_msg_data);
284:
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

281: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
283: p_data => x_msg_data);
284:
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
286: ROLLBACK TO check_process_template;
287: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
289: p_data => x_msg_data);

Line 287: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

283: p_data => x_msg_data);
284:
285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
286: ROLLBACK TO check_process_template;
287: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
289: p_data => x_msg_data);
290:
291: WHEN OTHERS THEN

Line 293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

289: p_data => x_msg_data);
290:
291: WHEN OTHERS THEN
292: ROLLBACK TO check_process_template;
293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
294: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'check_process_template');
295: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
296: p_data => x_msg_data);
297:

Line 331: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

327: x_return_status => l_return_status,
328: x_msg_count => l_msg_count,
329: x_msg_data => l_msg_data);
330:
331: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: END IF;

Line 332: RAISE OKL_API.G_EXCEPTION_ERROR;

328: x_msg_count => l_msg_count,
329: x_msg_data => l_msg_data);
330:
331: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: END IF;
336:

Line 333: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

329: x_msg_data => l_msg_data);
330:
331: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: END IF;
336:
337:

Line 334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

330:
331: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: END IF;
336:
337:
338:

Line 346: WHEN OKL_API.G_EXCEPTION_ERROR THEN

342:
343:
344: EXCEPTION
345:
346: WHEN OKL_API.G_EXCEPTION_ERROR THEN
347: ROLLBACK TO get_pvt_label_email;
348: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
350: p_data => x_msg_data);

Line 348: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

344: EXCEPTION
345:
346: WHEN OKL_API.G_EXCEPTION_ERROR THEN
347: ROLLBACK TO get_pvt_label_email;
348: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
350: p_data => x_msg_data);
351:
352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

348: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
350: p_data => x_msg_data);
351:
352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
353: ROLLBACK TO get_pvt_label_email;
354: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
356: p_data => x_msg_data);

Line 354: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

350: p_data => x_msg_data);
351:
352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
353: ROLLBACK TO get_pvt_label_email;
354: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
356: p_data => x_msg_data);
357:
358: WHEN OTHERS THEN

Line 360: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

356: p_data => x_msg_data);
357:
358: WHEN OTHERS THEN
359: ROLLBACK TO get_pvt_label_email;
360: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'get_pvt_label_email');
362: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
363: p_data => x_msg_data);
364:

Line 418: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

414: x_return_status => l_return_status,
415: x_msg_count => x_msg_count,
416: x_msg_data => x_msg_data);
417:
418: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: END IF;

Line 419: RAISE OKL_API.G_EXCEPTION_ERROR;

415: x_msg_count => x_msg_count,
416: x_msg_data => x_msg_data);
417:
418: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: END IF;
423:

Line 420: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

416: x_msg_data => x_msg_data);
417:
418: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: END IF;
423:
424:

Line 421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

417:
418: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: END IF;
423:
424:
425:

Line 434: WHEN OKL_API.G_EXCEPTION_ERROR THEN

430: x_return_status := l_return_status;
431:
432: EXCEPTION
433:
434: WHEN OKL_API.G_EXCEPTION_ERROR THEN
435: ROLLBACK TO create_svf_invoice;
436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
437: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
438: p_data => x_msg_data);

Line 436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

432: EXCEPTION
433:
434: WHEN OKL_API.G_EXCEPTION_ERROR THEN
435: ROLLBACK TO create_svf_invoice;
436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
437: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
438: p_data => x_msg_data);
439:
440: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 440: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
437: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
438: p_data => x_msg_data);
439:
440: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
441: ROLLBACK TO create_svf_invoice;
442: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
444: p_data => x_msg_data);

Line 442: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

438: p_data => x_msg_data);
439:
440: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
441: ROLLBACK TO create_svf_invoice;
442: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
444: p_data => x_msg_data);
445:
446: WHEN OTHERS THEN

Line 448: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

444: p_data => x_msg_data);
445:
446: WHEN OTHERS THEN
447: ROLLBACK TO create_svf_invoice;
448: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_svf_invoice');
450: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
451: p_data => x_msg_data);
452: