42:
43:
44: SAVEPOINT CREATE_ACCOUNTING_DIST1;
45:
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: -- customer pre-processing
49:
50:
83: END IF;
84: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST
85:
86:
87: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
84: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST
85:
86:
87: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92:
85:
86:
87: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92:
93: l_template_tbl := x_template_tbl;
86:
87: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92:
93: l_template_tbl := x_template_tbl;
94: l_amount_tbl := x_amount_tbl;
98:
99:
100: EXCEPTION
101:
102: WHEN FND_API.G_EXC_ERROR THEN
103: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
106: ,p_count => x_msg_count
100: EXCEPTION
101:
102: WHEN FND_API.G_EXC_ERROR THEN
103: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
106: ,p_count => x_msg_count
107: ,p_data => x_msg_data);
108:
105: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
106: ,p_count => x_msg_count
107: ,p_data => x_msg_data);
108:
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
113: ,p_count => x_msg_count
107: ,p_data => x_msg_data);
108:
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
113: ,p_count => x_msg_count
114: ,p_data => x_msg_data);
115:
119: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCOUNT_DIST_PUB','CREATE_ACCOUNTING_DIST');
120: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
121: ,p_count => x_msg_count
122: ,p_data => x_msg_data);
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124:
125:
126:
127: END CREATE_ACCOUNTING_DIST;
145:
146:
147: SAVEPOINT CREATE_ACCOUNTING_DIST1;
148:
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151:
152: -- Start of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST
153: IF(L_DEBUG_ENABLED='Y') THEN
178: END IF;
179: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST
180:
181:
182: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
179: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST
180:
181:
182: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
180:
181:
182: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188:
181:
182: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188:
189:
190:
191:
192: EXCEPTION
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
198: ,p_count => x_msg_count
192: EXCEPTION
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
198: ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200:
197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
198: ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
205: ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: ROLLBACK TO CREATE_ACCOUNTING_DIST1;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
205: ,p_count => x_msg_count
206: ,p_data => x_msg_data);
207:
211: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCOUNT_DIST_PUB','CREATE_ACCOUNTING_DIST');
212: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216:
217:
218:
219:
247:
248:
249: SAVEPOINT GET_TEMPLATE_INFO1;
250:
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252:
253: -- customer pre-processing
254:
255:
283: END;
284: END IF;
285: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO
286:
287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
288: RAISE FND_API.G_EXC_ERROR;
289: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
284: END IF;
285: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO
286:
287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
288: RAISE FND_API.G_EXC_ERROR;
289: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
285: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO
286:
287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
288: RAISE FND_API.G_EXC_ERROR;
289: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293:
286:
287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
288: RAISE FND_API.G_EXC_ERROR;
289: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293:
294: l_template_tbl := x_template_tbl;
297:
298:
299: EXCEPTION
300:
301: WHEN FND_API.G_EXC_ERROR THEN
302: ROLLBACK TO GET_TEMPLATE_INFO1;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304:
305: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
299: EXCEPTION
300:
301: WHEN FND_API.G_EXC_ERROR THEN
302: ROLLBACK TO GET_TEMPLATE_INFO1;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304:
305: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
306: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
305: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
306: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO GET_TEMPLATE_INFO1;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
313: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO GET_TEMPLATE_INFO1;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
313: ,p_count => x_msg_count
314: ,p_data => x_msg_data);
315:
319: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCOUNT_DIST_PUB','GET_TEMPLATE_INFO');
320: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
321: ,p_count => x_msg_count
322: ,p_data => x_msg_data);
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324:
325:
326:
327: END GET_TEMPLATE_INFO;
346:
347: BEGIN
348:
349: SAVEPOINT UPDATE_POST_TO_GL1;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: -- customer pre-processing
353:
354:
377: END;
378: END IF;
379: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.UPDATE_POST_TO_GL
380:
381: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385: END IF;
378: END IF;
379: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.UPDATE_POST_TO_GL
380:
381: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385: END IF;
386:
379: -- End of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.UPDATE_POST_TO_GL
380:
381: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385: END IF;
386:
387:
380:
381: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
385: END IF;
386:
387:
388:
388:
389:
390: EXCEPTION
391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO UPDATE_POST_TO_GL1;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395:
396: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
390: EXCEPTION
391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO UPDATE_POST_TO_GL1;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395:
396: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
397: ,p_count => x_msg_count
398: ,p_data => x_msg_data);
396: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
397: ,p_count => x_msg_count
398: ,p_data => x_msg_data);
399:
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: ROLLBACK TO UPDATE_POST_TO_GL1;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
404: ,p_count => x_msg_count
398: ,p_data => x_msg_data);
399:
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: ROLLBACK TO UPDATE_POST_TO_GL1;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
404: ,p_count => x_msg_count
405: ,p_data => x_msg_data);
406:
410: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCOUNT_DIST_PUB','UPDATE_POST_TO_GL');
411: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
412: ,p_count => x_msg_count
413: ,p_data => x_msg_data);
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415:
416:
417:
418: END UPDATE_POST_TO_GL;