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
70: ROLLBACK TO get_totals;
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
76: ROLLBACK TO get_totals;
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:
82: END get_totals;
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:
82: END get_totals;
83:
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
139: ROLLBACK TO get_svf_info;
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
145: ROLLBACK TO get_svf_info;
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:
151: END get_svf_info;
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:
151: END get_svf_info;
152:
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
221: ROLLBACK TO get_credit_memo_info;
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
227: ROLLBACK TO get_credit_memo_info;
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:
233: END get_credit_memo_info;
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:
233: END get_credit_memo_info;
234:
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
286: ROLLBACK TO check_process_template;
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
292: ROLLBACK TO check_process_template;
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:
298: END check_process_template;
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:
298: END check_process_template;
299:
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
353: ROLLBACK TO get_pvt_label_email;
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
359: ROLLBACK TO get_pvt_label_email;
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:
365: END get_pvt_label_email;
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:
365: END get_pvt_label_email;
366:
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
441: ROLLBACK TO create_svf_invoice;
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
447: ROLLBACK TO create_svf_invoice;
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:
453: END create_svf_invoice;
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:
453: END create_svf_invoice;
454: