74:
75: WHEN OKL_API.G_EXCEPTION_ERROR THEN
76: ROLLBACK TO insert_request;
77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);
80:
81: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: ROLLBACK TO insert_request;
80:
81: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
82: ROLLBACK TO insert_request;
83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
84: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
85: p_data => x_msg_data);
86:
87: WHEN OTHERS THEN
88: ROLLBACK TO insert_request;
86:
87: WHEN OTHERS THEN
88: ROLLBACK TO insert_request;
89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
90: FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
91: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
92: p_data => x_msg_data);
93:
94: END insert_request;
87: WHEN OTHERS THEN
88: ROLLBACK TO insert_request;
89: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
90: FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
91: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
92: p_data => x_msg_data);
93:
94: END insert_request;
95:
226: WHEN OKL_API.G_EXCEPTION_ERROR THEN
227:
228: ROLLBACK TO insert_request;
229: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
230: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
231: p_data => x_msg_data);
232:
233:
234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
235:
236: ROLLBACK TO insert_request;
237: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
238: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
239: p_data => x_msg_data);
240:
241:
242: WHEN OTHERS THEN
241:
242: WHEN OTHERS THEN
243: ROLLBACK TO insert_request;
244: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
246: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
247: p_data => x_msg_data);
248:
249: END insert_request;
242: WHEN OTHERS THEN
243: ROLLBACK TO insert_request;
244: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
246: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
247: p_data => x_msg_data);
248:
249: END insert_request;
250:
309:
310: WHEN OKL_API.G_EXCEPTION_ERROR THEN
311: ROLLBACK TO insert_request;
312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
313: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
314: p_data => x_msg_data);
315:
316: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
317: ROLLBACK TO insert_request;
315:
316: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
317: ROLLBACK TO insert_request;
318: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
320: p_data => x_msg_data);
321:
322: WHEN OTHERS THEN
323: ROLLBACK TO insert_request;
321:
322: WHEN OTHERS THEN
323: ROLLBACK TO insert_request;
324: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
325: FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
326: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: END insert_on_acc_cm_request;
322: WHEN OTHERS THEN
323: ROLLBACK TO insert_request;
324: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
325: FND_MSG_PUB.ADD_EXC_MSG('OKL_CREDIT_MEMO_PUB','insert_request');
326: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: END insert_on_acc_cm_request;
330: