19: BEGIN
20:
21: SAVEPOINT INT_HDR_INS_UPDT1;
22:
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: -- customer pre-processing
26:
27:
39:
40:
41: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
42:
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44:
45: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44:
45: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;
50:
51:
53:
54:
55: EXCEPTION
56:
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
55: EXCEPTION
56:
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);
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
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
63: ,p_data => x_msg_data);
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:
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:
81:
82: END INT_HDR_INS_UPDT;
83:
101:
102:
103: SAVEPOINT INT_HDR_INS_UPDT1;
104:
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- customer pre-processing
108:
109:
120:
121:
122: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
123:
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125:
126: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
127:
128: RAISE FND_API.G_EXC_ERROR;
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125:
126: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
127:
128: RAISE FND_API.G_EXC_ERROR;
129:
130: END IF;
131:
132:
134:
135:
136: EXCEPTION
137:
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
136: EXCEPTION
137:
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);
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
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
144: ,p_data => x_msg_data);
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:
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:
162:
163: END INT_HDR_INS_UPDT;
164:
180: BEGIN
181:
182: SAVEPOINT INT_DTL_INS_UPDT1;
183:
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: -- customer pre-processing
187:
188:
198: p_ivev_rec => p_ivev_rec);
199:
200:
201: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
200:
201: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207:
208:
209:
210:
211: EXCEPTION
212:
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
211: EXCEPTION
212:
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);
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
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
219: ,p_data => x_msg_data);
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:
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:
237:
238:
239:
258: BEGIN
259:
260: SAVEPOINT INT_DTL_INS_UPDT1;
261:
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: -- customer pre-processing
265:
266:
277: p_ivev_tbl => p_ivev_tbl);
278:
279:
280: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
279:
280: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286:
287:
288:
289:
290: EXCEPTION
291:
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
290: EXCEPTION
291:
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);
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
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
298: ,p_data => x_msg_data);
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:
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:
316:
317:
318: END INT_DTL_INS_UPDT;