57: WHEN FND_API.G_EXC_ERROR THEN
58: ROLLBACK TO INT_HDR_INS_UPDT1;
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
62: ,p_count => x_msg_count
63: ,p_data => x_msg_data);
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66: ROLLBACK TO INT_HDR_INS_UPDT1;
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
69: ,p_count => x_msg_count
70: ,p_data => x_msg_data);
71:
72: WHEN OTHERS THEN
71:
72: WHEN OTHERS THEN
73:
74: ROLLBACK TO INT_HDR_INS_UPDT1;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_HDR_INS_UPDT');
76: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
77: ,p_count => x_msg_count
78: ,p_data => x_msg_data);
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: WHEN OTHERS THEN
73:
74: ROLLBACK TO INT_HDR_INS_UPDT1;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_HDR_INS_UPDT');
76: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
77: ,p_count => x_msg_count
78: ,p_data => x_msg_data);
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80:
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO INT_HDR_INS_UPDT1;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141:
142: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
143: ,p_count => x_msg_count
144: ,p_data => x_msg_data);
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: ROLLBACK TO INT_HDR_INS_UPDT1;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
150: ,p_count => x_msg_count
151: ,p_data => x_msg_data);
152:
153: WHEN OTHERS THEN
152:
153: WHEN OTHERS THEN
154:
155: ROLLBACK TO INT_HDR_INS_UPDT1;
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_HDR_INS_UPDT');
157: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
158: ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: WHEN OTHERS THEN
154:
155: ROLLBACK TO INT_HDR_INS_UPDT1;
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_HDR_INS_UPDT');
157: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
158: ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO INT_DTL_INS_UPDT1;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216:
217: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
218: ,p_count => x_msg_count
219: ,p_data => x_msg_data);
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO INT_DTL_INS_UPDT1;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
225: ,p_count => x_msg_count
226: ,p_data => x_msg_data);
227:
228: WHEN OTHERS THEN
227:
228: WHEN OTHERS THEN
229:
230: ROLLBACK TO INT_DTL_INS_UPDT1;
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_DTL_INS_UPDT');
232: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data);
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: WHEN OTHERS THEN
229:
230: ROLLBACK TO INT_DTL_INS_UPDT1;
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_DTL_INS_UPDT');
232: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data);
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
292: WHEN FND_API.G_EXC_ERROR THEN
293: ROLLBACK TO INT_DTL_INS_UPDT1;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295:
296: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
297: ,p_count => x_msg_count
298: ,p_data => x_msg_data);
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO INT_DTL_INS_UPDT1;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
304: ,p_count => x_msg_count
305: ,p_data => x_msg_data);
306:
307: WHEN OTHERS THEN
306:
307: WHEN OTHERS THEN
308:
309: ROLLBACK TO INT_DTL_INS_UPDT1;
310: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_DTL_INS_UPDT');
311: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
312: ,p_count => x_msg_count
313: ,p_data => x_msg_data);
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: WHEN OTHERS THEN
308:
309: ROLLBACK TO INT_DTL_INS_UPDT1;
310: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_MAINT_PUB','INT_DTL_INS_UPDT');
311: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
312: ,p_count => x_msg_count
313: ,p_data => x_msg_data);
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: