APPS.OKL_ACCT_EVENT_PUB dependencies on FND_API

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: BEGIN
47:
48: SAVEPOINT create_acct_event;
49:
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52:
53: -- customer pre-processing
54:

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120:
121:
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO create_acct_event;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO create_acct_event;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);

Line 132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO create_acct_event;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
136: ,p_count => x_msg_count

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

130: ,p_data => x_msg_data);
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO create_acct_event;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
136: ,p_count => x_msg_count
137: ,p_data => x_msg_data);
138:

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
143: ,p_count => x_msg_count
144: ,p_data => x_msg_data);
145: -- notify caller of an UNEXPECTED error
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147:
148:
149: END create_acct_event;
150:

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: BEGIN
178:
179: SAVEPOINT create_acct_event;
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183:
184:
185: -- customer pre-processing

Line 221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

217: );
218:
219:
220:
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;

Line 222: RAISE FND_API.G_EXC_ERROR;

218:
219:
220:
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:

Line 223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

219:
220:
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: l_aetv_rec := x_aetv_rec;

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220:
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: l_aetv_rec := x_aetv_rec;
228:

Line 244: WHEN FND_API.G_EXC_ERROR THEN

240:
241:
242:
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO create_acct_event;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247:
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 246: x_return_status := FND_API.G_RET_STS_ERROR;

242:
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO create_acct_event;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247:
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO create_acct_event;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
256: ,p_count => x_msg_count

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: ,p_data => x_msg_data);
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO create_acct_event;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
256: ,p_count => x_msg_count
257: ,p_data => x_msg_data);
258:

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

262: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
263: ,p_count => x_msg_count
264: ,p_data => x_msg_data);
265: -- notify caller of an UNEXPECTED error
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: END create_acct_event;
269:
270:

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: --Initialize the return status
303:
304: SAVEPOINT create_acct_event;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308:
309:
310: -- customer pre-processing

Line 364: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

360: END IF;
361:
362: x_return_status := l_overall_status;
363:
364: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;

Line 365: RAISE FND_API.G_EXC_ERROR;

361:
362: x_return_status := l_overall_status;
363:
364: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369:

Line 366: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

362: x_return_status := l_overall_status;
363:
364: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369:
370:

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363:
364: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
366: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369:
370:
371: l_aetv_tbl := x_aetv_tbl;

Line 388: WHEN FND_API.G_EXC_ERROR THEN

384:
385:
386: EXCEPTION
387:
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO create_acct_event;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

386: EXCEPTION
387:
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO create_acct_event;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
393: ,p_count => x_msg_count
394: ,p_data => x_msg_data);

Line 396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
393: ,p_count => x_msg_count
394: ,p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_acct_event;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
400: ,p_count => x_msg_count

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: ,p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_acct_event;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
400: ,p_count => x_msg_count
401: ,p_data => x_msg_data);
402:

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
407: ,p_count => x_msg_count
408: ,p_data => x_msg_data);
409: -- notify caller of an UNEXPECTED error
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411:
412: END create_acct_event;
413:
414:

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453:
454: BEGIN
455:
456: SAVEPOINT update_acct_event;
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459:
460: -- customer pre-processing
461:

Line 504: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

500: ,x_aelv_tbl => x_aelv_tbl
501:
502: );
503:
504: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;

Line 505: RAISE FND_API.G_EXC_ERROR;

501:
502: );
503:
504: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:

Line 506: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

502: );
503:
504: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510: l_aetv_rec := x_aetv_rec;

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

503:
504: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510: l_aetv_rec := x_aetv_rec;
511: l_aehv_tbl := x_aehv_tbl;

Line 530: WHEN FND_API.G_EXC_ERROR THEN

526:
527:
528: EXCEPTION
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO update_acct_event;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533:
534: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: EXCEPTION
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO update_acct_event;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533:
534: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
535: ,p_count => x_msg_count
536: ,p_data => x_msg_data);

Line 538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

534: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
535: ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO update_acct_event;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
542: ,p_count => x_msg_count

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

536: ,p_data => x_msg_data);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO update_acct_event;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544:

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);
551: -- notify caller of an UNEXPECTED error
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553:
554: END update_acct_event;
555:
556:

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589:
590: BEGIN
591:
592: SAVEPOINT validate_acct_event;
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595:
596:
597: -- customer pre-processing

Line 635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

631: );
632:
633:
634:
635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;

Line 636: RAISE FND_API.G_EXC_ERROR;

632:
633:
634:
635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;
640:

Line 637: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

633:
634:
635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;
640:
641:

Line 638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634:
635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;
640:
641:
642:

Line 659: WHEN FND_API.G_EXC_ERROR THEN

655:
656:
657: EXCEPTION
658:
659: WHEN FND_API.G_EXC_ERROR THEN
660: ROLLBACK TO validate_acct_event;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: EXCEPTION
658:
659: WHEN FND_API.G_EXC_ERROR THEN
660: ROLLBACK TO validate_acct_event;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
664: ,p_count => x_msg_count
665: ,p_data => x_msg_data);

Line 667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

663: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
664: ,p_count => x_msg_count
665: ,p_data => x_msg_data);
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO validate_acct_event;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
671: ,p_count => x_msg_count

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

665: ,p_data => x_msg_data);
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO validate_acct_event;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
671: ,p_count => x_msg_count
672: ,p_data => x_msg_data);
673:

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
678: ,p_count => x_msg_count
679: ,p_data => x_msg_data);
680: -- notify caller of an UNEXPECTED error
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682:
683: END validate_acct_event;
684:
685:

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704:
705:
706: BEGIN
707:
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: SAVEPOINT lock_acct_event;
710:
711: okl_acct_event_pvt.lock_acct_event(
712:

Line 727: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

723: ,p_aetv_rec => p_aetv_rec
724:
725: );
726:
727: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;

Line 728: RAISE FND_API.G_EXC_ERROR;

724:
725: );
726:
727: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:

Line 729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

725: );
726:
727: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: EXCEPTION

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726:
727: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
728: RAISE FND_API.G_EXC_ERROR;
729: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN

Line 734: WHEN FND_API.G_EXC_ERROR THEN

730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO lock_acct_event;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737:
738: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 736: x_return_status := FND_API.G_RET_STS_ERROR;

732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO lock_acct_event;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737:
738: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
739: ,p_count => x_msg_count
740: ,p_data => x_msg_data);

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

738: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
739: ,p_count => x_msg_count
740: ,p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO lock_acct_event;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
746: ,p_count => x_msg_count

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

740: ,p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO lock_acct_event;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
746: ,p_count => x_msg_count
747: ,p_data => x_msg_data);
748:

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755: -- notify caller of an UNEXPECTED error
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757:
758: END lock_acct_event;
759:
760:

Line 786: x_return_status := FND_API.G_RET_STS_SUCCESS;

782: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
783:
784: BEGIN
785:
786: x_return_status := FND_API.G_RET_STS_SUCCESS;
787: SAVEPOINT lock_acct_event;
788:
789: IF (p_aetv_tbl.COUNT > 0) THEN
790:

Line 811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

807: ,p_aetv_rec => p_aetv_tbl(i)
808:
809: );
810: -- store the highest degree of error
811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
812: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
813: l_overall_status := l_return_status;
814: END IF;
815: END IF;

Line 812: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

808:
809: );
810: -- store the highest degree of error
811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
812: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
813: l_overall_status := l_return_status;
814: END IF;
815: END IF;
816:

Line 827: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

823: l_return_status := l_overall_status;
824:
825: END IF;
826:
827: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
828: RAISE FND_API.G_EXC_ERROR;
829: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;

Line 828: RAISE FND_API.G_EXC_ERROR;

824:
825: END IF;
826:
827: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
828: RAISE FND_API.G_EXC_ERROR;
829: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:

Line 829: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

825: END IF;
826:
827: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
828: RAISE FND_API.G_EXC_ERROR;
829: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:
833: EXCEPTION

Line 830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

826:
827: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
828: RAISE FND_API.G_EXC_ERROR;
829: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:
833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN

Line 834: WHEN FND_API.G_EXC_ERROR THEN

830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:
833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO lock_acct_event;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

832:
833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO lock_acct_event;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
839: ,p_count => x_msg_count
840: ,p_data => x_msg_data);

Line 842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

838: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
839: ,p_count => x_msg_count
840: ,p_data => x_msg_data);
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO lock_acct_event;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
846: ,p_count => x_msg_count

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

840: ,p_data => x_msg_data);
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO lock_acct_event;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
846: ,p_count => x_msg_count
847: ,p_data => x_msg_data);
848:

Line 856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

852: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
853: ,p_count => x_msg_count
854: ,p_data => x_msg_data);
855: -- notify caller of an UNEXPECTED error
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857:
858: END lock_acct_event;
859:
860:

Line 889: x_return_status := FND_API.G_RET_STS_SUCCESS;

885:
886: BEGIN
887:
888: SAVEPOINT update_acct_event;
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891:
892:
893: -- customer pre-processing

Line 927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

923: ,x_aetv_rec => x_aetv_rec
924:
925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
928: RAISE FND_API.G_EXC_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;

Line 928: RAISE FND_API.G_EXC_ERROR;

924:
925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
928: RAISE FND_API.G_EXC_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:

Line 929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

925: );
926:
927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
928: RAISE FND_API.G_EXC_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: l_aetv_rec := x_aetv_rec;

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926:
927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
928: RAISE FND_API.G_EXC_ERROR;
929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: l_aetv_rec := x_aetv_rec;
934:

Line 951: WHEN FND_API.G_EXC_ERROR THEN

947:
948:
949: EXCEPTION
950:
951: WHEN FND_API.G_EXC_ERROR THEN
952: ROLLBACK TO update_acct_event;
953: x_return_status := FND_API.G_RET_STS_ERROR;
954:
955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 953: x_return_status := FND_API.G_RET_STS_ERROR;

949: EXCEPTION
950:
951: WHEN FND_API.G_EXC_ERROR THEN
952: ROLLBACK TO update_acct_event;
953: x_return_status := FND_API.G_RET_STS_ERROR;
954:
955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
956: ,p_count => x_msg_count
957: ,p_data => x_msg_data);

Line 959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
956: ,p_count => x_msg_count
957: ,p_data => x_msg_data);
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: ROLLBACK TO update_acct_event;
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
963: ,p_count => x_msg_count

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

957: ,p_data => x_msg_data);
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: ROLLBACK TO update_acct_event;
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
963: ,p_count => x_msg_count
964: ,p_data => x_msg_data);
965:

Line 973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

969: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
970: ,p_count => x_msg_count
971: ,p_data => x_msg_data);
972: -- notify caller of an UNEXPECTED error
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974:
975: END update_acct_event;
976:
977:

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005:
1006: --Initialize the return status
1007:
1008: SAVEPOINT update_acct_event;
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010:
1011:
1012:
1013: -- customer pre-processing

Line 1067: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1063: END IF;
1064:
1065: x_return_status := l_overall_Status;
1066:
1067: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;

Line 1068: RAISE FND_API.G_EXC_ERROR;

1064:
1065: x_return_status := l_overall_Status;
1066:
1067: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072:

Line 1069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1065: x_return_status := l_overall_Status;
1066:
1067: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072:
1073: l_aetv_tbl := x_aetv_tbl;

Line 1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1066:
1067: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072:
1073: l_aetv_tbl := x_aetv_tbl;
1074:

Line 1089: WHEN FND_API.G_EXC_ERROR THEN

1085:
1086:
1087: EXCEPTION
1088:
1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO update_acct_event;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092:
1093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1091: x_return_status := FND_API.G_RET_STS_ERROR;

1087: EXCEPTION
1088:
1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO update_acct_event;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092:
1093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1094: ,p_count => x_msg_count
1095: ,p_data => x_msg_data);

Line 1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1094: ,p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO update_acct_event;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1101: ,p_count => x_msg_count

Line 1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1095: ,p_data => x_msg_data);
1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO update_acct_event;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1101: ,p_count => x_msg_count
1102: ,p_data => x_msg_data);
1103:

Line 1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1107: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1108: ,p_count => x_msg_count
1109: ,p_data => x_msg_data);
1110: -- notify caller of an UNEXPECTED error
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112:
1113: END update_acct_event;
1114:
1115:

Line 1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

1144:
1145: BEGIN
1146:
1147: SAVEPOINT delete_acct_event;
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149:
1150:
1151: -- customer pre-processing
1152:

Line 1185: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1181: );
1182:
1183:
1184:
1185: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;

Line 1186: RAISE FND_API.G_EXC_ERROR;

1182:
1183:
1184:
1185: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:

Line 1187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1183:
1184:
1185: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191:

Line 1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1184:
1185: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191:
1192:

Line 1208: WHEN FND_API.G_EXC_ERROR THEN

1204:
1205:
1206: EXCEPTION
1207:
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK TO delete_acct_event;
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211:
1212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1210: x_return_status := FND_API.G_RET_STS_ERROR;

1206: EXCEPTION
1207:
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK TO delete_acct_event;
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211:
1212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1213: ,p_count => x_msg_count
1214: ,p_data => x_msg_data);

Line 1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1213: ,p_count => x_msg_count
1214: ,p_data => x_msg_data);
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO delete_acct_event;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1220: ,p_count => x_msg_count

Line 1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1214: ,p_data => x_msg_data);
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO delete_acct_event;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1220: ,p_count => x_msg_count
1221: ,p_data => x_msg_data);
1222:

Line 1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1227: ,p_count => x_msg_count
1228: ,p_data => x_msg_data);
1229: -- notify caller of an UNEXPECTED error
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231:
1232: END delete_acct_event;
1233:
1234:

Line 1264: x_return_status := FND_API.G_RET_STS_SUCCESS;

1260:
1261: --Initialize the return status
1262:
1263: SAVEPOINT delete_acct_event;
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265:
1266:
1267: -- customer pre-processing
1268:

Line 1319: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1315: END IF;
1316:
1317: x_return_status := l_overall_status;
1318:
1319: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;

Line 1320: RAISE FND_API.G_EXC_ERROR;

1316:
1317: x_return_status := l_overall_status;
1318:
1319: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:

Line 1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1317: x_return_status := l_overall_status;
1318:
1319: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:
1325:

Line 1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1318:
1319: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:
1325:
1326:

Line 1341: WHEN FND_API.G_EXC_ERROR THEN

1337:
1338:
1339: EXCEPTION
1340:
1341: WHEN FND_API.G_EXC_ERROR THEN
1342: ROLLBACK TO delete_acct_event;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344:
1345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1343: x_return_status := FND_API.G_RET_STS_ERROR;

1339: EXCEPTION
1340:
1341: WHEN FND_API.G_EXC_ERROR THEN
1342: ROLLBACK TO delete_acct_event;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344:
1345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1346: ,p_count => x_msg_count
1347: ,p_data => x_msg_data);

Line 1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1346: ,p_count => x_msg_count
1347: ,p_data => x_msg_data);
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO delete_acct_event;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1353: ,p_count => x_msg_count

Line 1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1347: ,p_data => x_msg_data);
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO delete_acct_event;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1353: ,p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355:

Line 1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1360: ,p_count => x_msg_count
1361: ,p_data => x_msg_data);
1362: -- notify caller of an UNEXPECTED error
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364:
1365:
1366: END delete_acct_event;
1367:

Line 1395: x_return_status := FND_API.G_RET_STS_SUCCESS;

1391:
1392: BEGIN
1393:
1394: SAVEPOINT validate_acct_event;
1395: x_return_status := FND_API.G_RET_STS_SUCCESS;
1396:
1397:
1398:
1399: -- customer pre-processing

Line 1433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1429: ,p_aetv_rec => l_aetv_rec
1430:
1431: );
1432:
1433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430:
1431: );
1432:
1433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438:

Line 1435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1431: );
1432:
1433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438:
1439:

Line 1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1432:
1433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438:
1439:
1440:

Line 1457: WHEN FND_API.G_EXC_ERROR THEN

1453:
1454:
1455: EXCEPTION
1456:
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: ROLLBACK TO validate_acct_event;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460:
1461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR;

1455: EXCEPTION
1456:
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: ROLLBACK TO validate_acct_event;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460:
1461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1462: ,p_count => x_msg_count
1463: ,p_data => x_msg_data);

Line 1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1462: ,p_count => x_msg_count
1463: ,p_data => x_msg_data);
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO validate_acct_event;
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1469: ,p_count => x_msg_count

Line 1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1463: ,p_data => x_msg_data);
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO validate_acct_event;
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1469: ,p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471:

Line 1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: -- notify caller of an UNEXPECTED error
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480:
1481: END validate_acct_event;
1482:
1483:

Line 1513: x_return_status := FND_API.G_RET_STS_SUCCESS;

1509:
1510: --Initialize the return status
1511:
1512: SAVEPOINT validate_acct_event;
1513: x_return_status := FND_API.G_RET_STS_SUCCESS;
1514:
1515:
1516:
1517: -- customer pre-processing

Line 1569: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1565: END IF;
1566:
1567: x_return_status := l_overall_status;
1568:
1569: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1570: RAISE FND_API.G_EXC_ERROR;
1571: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1573: END IF;

Line 1570: RAISE FND_API.G_EXC_ERROR;

1566:
1567: x_return_status := l_overall_status;
1568:
1569: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1570: RAISE FND_API.G_EXC_ERROR;
1571: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1573: END IF;
1574:

Line 1571: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1567: x_return_status := l_overall_status;
1568:
1569: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1570: RAISE FND_API.G_EXC_ERROR;
1571: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1573: END IF;
1574:
1575:

Line 1572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1568:
1569: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1570: RAISE FND_API.G_EXC_ERROR;
1571: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1573: END IF;
1574:
1575:
1576:

Line 1591: WHEN FND_API.G_EXC_ERROR THEN

1587:
1588:
1589: EXCEPTION
1590:
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO validate_acct_event;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594:
1595: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1593: x_return_status := FND_API.G_RET_STS_ERROR;

1589: EXCEPTION
1590:
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO validate_acct_event;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594:
1595: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);

Line 1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1595: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO validate_acct_event;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1603: ,p_count => x_msg_count

Line 1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1597: ,p_data => x_msg_data);
1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO validate_acct_event;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1603: ,p_count => x_msg_count
1604: ,p_data => x_msg_data);
1605:

Line 1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1609: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1610: ,p_count => x_msg_count
1611: ,p_data => x_msg_data);
1612: -- notify caller of an UNEXPECTED error
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614:
1615: END validate_acct_event;
1616:
1617:

Line 1648: x_return_status := FND_API.G_RET_STS_SUCCESS;

1644:
1645: BEGIN
1646:
1647: SAVEPOINT create_acct_header;
1648: x_return_status := FND_API.G_RET_STS_SUCCESS;
1649:
1650:
1651:
1652: -- customer pre-processing

Line 1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1686: ,x_aehv_rec => x_aehv_rec
1687:
1688: );
1689:
1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1691: RAISE FND_API.G_EXC_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;

Line 1691: RAISE FND_API.G_EXC_ERROR;

1687:
1688: );
1689:
1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1691: RAISE FND_API.G_EXC_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695:

Line 1692: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1688: );
1689:
1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1691: RAISE FND_API.G_EXC_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695:
1696: l_aehv_rec := x_aehv_rec;

Line 1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1689:
1690: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1691: RAISE FND_API.G_EXC_ERROR;
1692: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695:
1696: l_aehv_rec := x_aehv_rec;
1697:

Line 1714: WHEN FND_API.G_EXC_ERROR THEN

1710:
1711:
1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: ROLLBACK TO create_acct_header;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717:
1718: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1716: x_return_status := FND_API.G_RET_STS_ERROR;

1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: ROLLBACK TO create_acct_header;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717:
1718: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1719: ,p_count => x_msg_count
1720: ,p_data => x_msg_data);

Line 1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1718: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1719: ,p_count => x_msg_count
1720: ,p_data => x_msg_data);
1721:
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1723: ROLLBACK TO create_acct_header;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1726: ,p_count => x_msg_count

Line 1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1720: ,p_data => x_msg_data);
1721:
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1723: ROLLBACK TO create_acct_header;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1726: ,p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728:

Line 1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1732: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1733: ,p_count => x_msg_count
1734: ,p_data => x_msg_data);
1735: -- notify caller of an UNEXPECTED error
1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1737:
1738: END create_acct_header;
1739:
1740:

Line 1772: x_return_status := FND_API.G_RET_STS_SUCCESS;

1768:
1769: --Initialize the return status
1770:
1771: SAVEPOINT create_acct_header;
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773:
1774:
1775:
1776: -- customer pre-processing

Line 1830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1826: END IF;
1827:
1828: x_return_status := l_overall_status;
1829:
1830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1831: RAISE FND_API.G_EXC_ERROR;
1832: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834: END IF;

Line 1831: RAISE FND_API.G_EXC_ERROR;

1827:
1828: x_return_status := l_overall_status;
1829:
1830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1831: RAISE FND_API.G_EXC_ERROR;
1832: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834: END IF;
1835:

Line 1832: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1828: x_return_status := l_overall_status;
1829:
1830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1831: RAISE FND_API.G_EXC_ERROR;
1832: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834: END IF;
1835:
1836: l_aehv_tbl := x_aehv_tbl;

Line 1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1829:
1830: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1831: RAISE FND_API.G_EXC_ERROR;
1832: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834: END IF;
1835:
1836: l_aehv_tbl := x_aehv_tbl;
1837:

Line 1852: WHEN FND_API.G_EXC_ERROR THEN

1848:
1849:
1850: EXCEPTION
1851:
1852: WHEN FND_API.G_EXC_ERROR THEN
1853: ROLLBACK TO create_acct_header;
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1854: x_return_status := FND_API.G_RET_STS_ERROR;

1850: EXCEPTION
1851:
1852: WHEN FND_API.G_EXC_ERROR THEN
1853: ROLLBACK TO create_acct_header;
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1857: ,p_count => x_msg_count
1858: ,p_data => x_msg_data);

Line 1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1857: ,p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859:
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: ROLLBACK TO create_acct_header;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1864: ,p_count => x_msg_count

Line 1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1858: ,p_data => x_msg_data);
1859:
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: ROLLBACK TO create_acct_header;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1864: ,p_count => x_msg_count
1865: ,p_data => x_msg_data);
1866:

Line 1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data);
1873: -- notify caller of an UNEXPECTED error
1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1875:
1876: END create_acct_header;
1877:
1878:

Line 1900: x_return_status := FND_API.G_RET_STS_SUCCESS;

1896: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_header';
1897:
1898: BEGIN
1899:
1900: x_return_status := FND_API.G_RET_STS_SUCCESS;
1901: SAVEPOINT lock_acct_header;
1902:
1903:
1904: okl_acct_event_pvt.lock_acct_header(

Line 1920: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1916: ,p_aehv_rec => p_aehv_rec
1917:
1918: );
1919:
1920: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1921: RAISE FND_API.G_EXC_ERROR;
1922: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;

Line 1921: RAISE FND_API.G_EXC_ERROR;

1917:
1918: );
1919:
1920: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1921: RAISE FND_API.G_EXC_ERROR;
1922: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;
1925:

Line 1922: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1918: );
1919:
1920: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1921: RAISE FND_API.G_EXC_ERROR;
1922: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;
1925:
1926: EXCEPTION

Line 1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1919:
1920: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1921: RAISE FND_API.G_EXC_ERROR;
1922: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;
1925:
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN

Line 1927: WHEN FND_API.G_EXC_ERROR THEN

1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;
1925:
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ROLLBACK TO lock_acct_header;
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1929: x_return_status := FND_API.G_RET_STS_ERROR;

1925:
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ROLLBACK TO lock_acct_header;
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1932: ,p_count => x_msg_count
1933: ,p_data => x_msg_data);

Line 1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1932: ,p_count => x_msg_count
1933: ,p_data => x_msg_data);
1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK TO lock_acct_header;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1939: ,p_count => x_msg_count

Line 1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1933: ,p_data => x_msg_data);
1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK TO lock_acct_header;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data);
1941:

Line 1949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1946: ,p_count => x_msg_count
1947: ,p_data => x_msg_data);
1948: -- notify caller of an UNEXPECTED error
1949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1950:
1951: END lock_acct_header;
1952:
1953:

Line 1979: x_return_status := FND_API.G_RET_STS_SUCCESS;

1975: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1976:
1977: BEGIN
1978:
1979: x_return_status := FND_API.G_RET_STS_SUCCESS;
1980: SAVEPOINT lock_acct_header;
1981:
1982: IF (p_aehv_tbl.COUNT > 0) THEN
1983:

Line 2005: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2001:
2002: );
2003:
2004: -- store the highest degree of error
2005: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2006: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: l_overall_status := l_return_status;
2008: END IF;
2009: END IF;

Line 2006: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2002: );
2003:
2004: -- store the highest degree of error
2005: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2006: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: l_overall_status := l_return_status;
2008: END IF;
2009: END IF;
2010: EXIT WHEN (i = p_aehv_tbl.LAST);

Line 2020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2016: l_return_status := l_overall_status;
2017:
2018: END IF;
2019:
2020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;

Line 2021: RAISE FND_API.G_EXC_ERROR;

2017:
2018: END IF;
2019:
2020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:

Line 2022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2018: END IF;
2019:
2020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: EXCEPTION

Line 2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2019:
2020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: EXCEPTION
2027: WHEN FND_API.G_EXC_ERROR THEN

Line 2027: WHEN FND_API.G_EXC_ERROR THEN

2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: EXCEPTION
2027: WHEN FND_API.G_EXC_ERROR THEN
2028: ROLLBACK TO lock_acct_header;
2029: x_return_status := FND_API.G_RET_STS_ERROR;
2030:
2031: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2029: x_return_status := FND_API.G_RET_STS_ERROR;

2025:
2026: EXCEPTION
2027: WHEN FND_API.G_EXC_ERROR THEN
2028: ROLLBACK TO lock_acct_header;
2029: x_return_status := FND_API.G_RET_STS_ERROR;
2030:
2031: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data);

Line 2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2031: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data);
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: ROLLBACK TO lock_acct_header;
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2038: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2039: ,p_count => x_msg_count

Line 2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2033: ,p_data => x_msg_data);
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: ROLLBACK TO lock_acct_header;
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2038: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2039: ,p_count => x_msg_count
2040: ,p_data => x_msg_data);
2041:

Line 2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2045: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2046: ,p_count => x_msg_count
2047: ,p_data => x_msg_data);
2048: -- notify caller of an UNEXPECTED error
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2050:
2051: END lock_acct_header;
2052:
2053:

Line 2080: x_return_status := FND_API.G_RET_STS_SUCCESS;

2076:
2077: BEGIN
2078:
2079: SAVEPOINT update_acct_header;
2080: x_return_status := FND_API.G_RET_STS_SUCCESS;
2081:
2082:
2083:
2084: -- customer pre-processing

Line 2118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2114: ,x_aehv_rec => x_aehv_rec
2115:
2116: );
2117:
2118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: END IF;

Line 2119: RAISE FND_API.G_EXC_ERROR;

2115:
2116: );
2117:
2118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: END IF;
2123:

Line 2120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2116: );
2117:
2118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: END IF;
2123:
2124:

Line 2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2117:
2118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: END IF;
2123:
2124:
2125: l_aehv_rec := x_aehv_rec;

Line 2143: WHEN FND_API.G_EXC_ERROR THEN

2139:
2140:
2141: EXCEPTION
2142:
2143: WHEN FND_API.G_EXC_ERROR THEN
2144: ROLLBACK TO update_acct_header;
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146:
2147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2145: x_return_status := FND_API.G_RET_STS_ERROR;

2141: EXCEPTION
2142:
2143: WHEN FND_API.G_EXC_ERROR THEN
2144: ROLLBACK TO update_acct_header;
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146:
2147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2148: ,p_count => x_msg_count
2149: ,p_data => x_msg_data);

Line 2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2148: ,p_count => x_msg_count
2149: ,p_data => x_msg_data);
2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2152: ROLLBACK TO update_acct_header;
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2155: ,p_count => x_msg_count

Line 2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2149: ,p_data => x_msg_data);
2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2152: ROLLBACK TO update_acct_header;
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2155: ,p_count => x_msg_count
2156: ,p_data => x_msg_data);
2157:

Line 2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2162: ,p_count => x_msg_count
2163: ,p_data => x_msg_data);
2164: -- notify caller of an UNEXPECTED error
2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166:
2167: END update_acct_header;
2168:
2169:

Line 2203: x_return_status := FND_API.G_RET_STS_SUCCESS;

2199:
2200: --Initialize the return status
2201:
2202: SAVEPOINT update_acct_header;
2203: x_return_status := FND_API.G_RET_STS_SUCCESS;
2204:
2205:
2206:
2207: -- customer pre-processing

Line 2259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2255: END IF;
2256:
2257: x_return_status := l_overall_status;
2258:
2259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2263: END IF;

Line 2260: RAISE FND_API.G_EXC_ERROR;

2256:
2257: x_return_status := l_overall_status;
2258:
2259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2263: END IF;
2264:

Line 2261: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2257: x_return_status := l_overall_status;
2258:
2259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2263: END IF;
2264:
2265:

Line 2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2258:
2259: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2263: END IF;
2264:
2265:
2266: l_aehv_tbl := x_aehv_tbl;

Line 2283: WHEN FND_API.G_EXC_ERROR THEN

2279:
2280:
2281: EXCEPTION
2282:
2283: WHEN FND_API.G_EXC_ERROR THEN
2284: ROLLBACK TO update_acct_header;
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286:
2287: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2285: x_return_status := FND_API.G_RET_STS_ERROR;

2281: EXCEPTION
2282:
2283: WHEN FND_API.G_EXC_ERROR THEN
2284: ROLLBACK TO update_acct_header;
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286:
2287: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2288: ,p_count => x_msg_count
2289: ,p_data => x_msg_data);

Line 2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2287: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2288: ,p_count => x_msg_count
2289: ,p_data => x_msg_data);
2290:
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO update_acct_header;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2295: ,p_count => x_msg_count

Line 2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2289: ,p_data => x_msg_data);
2290:
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO update_acct_header;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2295: ,p_count => x_msg_count
2296: ,p_data => x_msg_data);
2297:

Line 2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2302: ,p_count => x_msg_count
2303: ,p_data => x_msg_data);
2304: -- notify caller of an UNEXPECTED error
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2306:
2307: END update_acct_header;
2308:
2309:

Line 2338: x_return_status := FND_API.G_RET_STS_SUCCESS;

2334:
2335: BEGIN
2336:
2337: SAVEPOINT delete_acct_header;
2338: x_return_status := FND_API.G_RET_STS_SUCCESS;
2339:
2340:
2341:
2342: -- customer pre-processing

Line 2374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2370: ,x_msg_data => x_msg_data
2371:
2372: ,p_aehv_rec => l_aehv_rec);
2373:
2374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;

Line 2375: RAISE FND_API.G_EXC_ERROR;

2371:
2372: ,p_aehv_rec => l_aehv_rec);
2373:
2374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:

Line 2376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2372: ,p_aehv_rec => l_aehv_rec);
2373:
2374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:
2380:

Line 2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2373:
2374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:
2380:
2381:

Line 2398: WHEN FND_API.G_EXC_ERROR THEN

2394:
2395:
2396: EXCEPTION
2397:
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO delete_acct_header;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2400: x_return_status := FND_API.G_RET_STS_ERROR;

2396: EXCEPTION
2397:
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO delete_acct_header;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2403: ,p_count => x_msg_count
2404: ,p_data => x_msg_data);

Line 2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2402: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2403: ,p_count => x_msg_count
2404: ,p_data => x_msg_data);
2405:
2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2407: ROLLBACK TO delete_acct_header;
2408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2409: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2410: ,p_count => x_msg_count

Line 2408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2404: ,p_data => x_msg_data);
2405:
2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2407: ROLLBACK TO delete_acct_header;
2408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2409: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2410: ,p_count => x_msg_count
2411: ,p_data => x_msg_data);
2412:

Line 2420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2416: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2417: ,p_count => x_msg_count
2418: ,p_data => x_msg_data);
2419: -- notify caller of an UNEXPECTED error
2420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2421:
2422: END delete_acct_header;
2423:
2424:

Line 2457: x_return_status := FND_API.G_RET_STS_SUCCESS;

2453:
2454: --Initialize the return status
2455:
2456: SAVEPOINT delete_acct_header;
2457: x_return_status := FND_API.G_RET_STS_SUCCESS;
2458:
2459:
2460:
2461: -- customer pre-processing

Line 2512: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2508: END IF;
2509:
2510: x_return_status := l_overall_status;
2511:
2512: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2513: RAISE FND_API.G_EXC_ERROR;
2514: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: END IF;

Line 2513: RAISE FND_API.G_EXC_ERROR;

2509:
2510: x_return_status := l_overall_status;
2511:
2512: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2513: RAISE FND_API.G_EXC_ERROR;
2514: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: END IF;
2517:

Line 2514: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2510: x_return_status := l_overall_status;
2511:
2512: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2513: RAISE FND_API.G_EXC_ERROR;
2514: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: END IF;
2517:
2518:

Line 2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2511:
2512: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2513: RAISE FND_API.G_EXC_ERROR;
2514: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: END IF;
2517:
2518:
2519:

Line 2535: WHEN FND_API.G_EXC_ERROR THEN

2531:
2532:
2533: EXCEPTION
2534:
2535: WHEN FND_API.G_EXC_ERROR THEN
2536: ROLLBACK TO delete_acct_header;
2537: x_return_status := FND_API.G_RET_STS_ERROR;
2538:
2539: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2537: x_return_status := FND_API.G_RET_STS_ERROR;

2533: EXCEPTION
2534:
2535: WHEN FND_API.G_EXC_ERROR THEN
2536: ROLLBACK TO delete_acct_header;
2537: x_return_status := FND_API.G_RET_STS_ERROR;
2538:
2539: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2540: ,p_count => x_msg_count
2541: ,p_data => x_msg_data);

Line 2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2539: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2540: ,p_count => x_msg_count
2541: ,p_data => x_msg_data);
2542:
2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2544: ROLLBACK TO delete_acct_header;
2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2546: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2547: ,p_count => x_msg_count

Line 2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2541: ,p_data => x_msg_data);
2542:
2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2544: ROLLBACK TO delete_acct_header;
2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2546: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2547: ,p_count => x_msg_count
2548: ,p_data => x_msg_data);
2549:

Line 2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2553: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2554: ,p_count => x_msg_count
2555: ,p_data => x_msg_data);
2556: -- notify caller of an UNEXPECTED error
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2558:
2559: END delete_acct_header;
2560:
2561:

Line 2586: x_return_status := FND_API.G_RET_STS_SUCCESS;

2582:
2583: BEGIN
2584:
2585: SAVEPOINT validate_acct_header;
2586: x_return_status := FND_API.G_RET_STS_SUCCESS;
2587:
2588:
2589:
2590: -- customer pre-processing

Line 2624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2620: ,p_aehv_rec => l_aehv_rec
2621:
2622: );
2623:
2624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2625: RAISE FND_API.G_EXC_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END IF;

Line 2625: RAISE FND_API.G_EXC_ERROR;

2621:
2622: );
2623:
2624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2625: RAISE FND_API.G_EXC_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END IF;
2629:

Line 2626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2622: );
2623:
2624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2625: RAISE FND_API.G_EXC_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END IF;
2629:
2630:

Line 2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2623:
2624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2625: RAISE FND_API.G_EXC_ERROR;
2626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2628: END IF;
2629:
2630:
2631:

Line 2648: WHEN FND_API.G_EXC_ERROR THEN

2644:
2645:
2646: EXCEPTION
2647:
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: ROLLBACK TO validate_acct_header;
2650: x_return_status := FND_API.G_RET_STS_ERROR;
2651:
2652: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2650: x_return_status := FND_API.G_RET_STS_ERROR;

2646: EXCEPTION
2647:
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: ROLLBACK TO validate_acct_header;
2650: x_return_status := FND_API.G_RET_STS_ERROR;
2651:
2652: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2653: ,p_count => x_msg_count
2654: ,p_data => x_msg_data);

Line 2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2652: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2653: ,p_count => x_msg_count
2654: ,p_data => x_msg_data);
2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2657: ROLLBACK TO validate_acct_header;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2660: ,p_count => x_msg_count

Line 2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2654: ,p_data => x_msg_data);
2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2657: ROLLBACK TO validate_acct_header;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2660: ,p_count => x_msg_count
2661: ,p_data => x_msg_data);
2662:

Line 2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2666: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2667: ,p_count => x_msg_count
2668: ,p_data => x_msg_data);
2669: -- notify caller of an UNEXPECTED error
2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2671:
2672: END validate_acct_header;
2673:
2674:

Line 2706: x_return_status := FND_API.G_RET_STS_SUCCESS;

2702: --Initialize the return status
2703:
2704:
2705: SAVEPOINT validate_acct_header;
2706: x_return_status := FND_API.G_RET_STS_SUCCESS;
2707:
2708:
2709:
2710: -- customer pre-processing

Line 2764: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2760: END IF;
2761:
2762: x_return_status := l_overall_status;
2763:
2764: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2765: RAISE FND_API.G_EXC_ERROR;
2766: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: END IF;

Line 2765: RAISE FND_API.G_EXC_ERROR;

2761:
2762: x_return_status := l_overall_status;
2763:
2764: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2765: RAISE FND_API.G_EXC_ERROR;
2766: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: END IF;
2769:

Line 2766: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2762: x_return_status := l_overall_status;
2763:
2764: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2765: RAISE FND_API.G_EXC_ERROR;
2766: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: END IF;
2769:
2770:

Line 2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2763:
2764: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2765: RAISE FND_API.G_EXC_ERROR;
2766: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: END IF;
2769:
2770:
2771:

Line 2788: WHEN FND_API.G_EXC_ERROR THEN

2784:
2785:
2786: EXCEPTION
2787:
2788: WHEN FND_API.G_EXC_ERROR THEN
2789: ROLLBACK TO validate_acct_header;
2790: x_return_status := FND_API.G_RET_STS_ERROR;
2791:
2792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2790: x_return_status := FND_API.G_RET_STS_ERROR;

2786: EXCEPTION
2787:
2788: WHEN FND_API.G_EXC_ERROR THEN
2789: ROLLBACK TO validate_acct_header;
2790: x_return_status := FND_API.G_RET_STS_ERROR;
2791:
2792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2793: ,p_count => x_msg_count
2794: ,p_data => x_msg_data);

Line 2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2793: ,p_count => x_msg_count
2794: ,p_data => x_msg_data);
2795:
2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2797: ROLLBACK TO validate_acct_header;
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2800: ,p_count => x_msg_count

Line 2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2794: ,p_data => x_msg_data);
2795:
2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2797: ROLLBACK TO validate_acct_header;
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2800: ,p_count => x_msg_count
2801: ,p_data => x_msg_data);
2802:

Line 2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2806: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2807: ,p_count => x_msg_count
2808: ,p_data => x_msg_data);
2809: -- notify caller of an UNEXPECTED error
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2811:
2812: END validate_acct_header;
2813:
2814:

Line 2844: x_return_status := FND_API.G_RET_STS_SUCCESS;

2840:
2841: BEGIN
2842:
2843: SAVEPOINT create_acct_lines;
2844: x_return_status := FND_API.G_RET_STS_SUCCESS;
2845:
2846:
2847:
2848:

Line 2887: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2883: ,x_aelv_rec => x_aelv_rec
2884:
2885: );
2886:
2887: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2891: END IF;

Line 2888: RAISE FND_API.G_EXC_ERROR;

2884:
2885: );
2886:
2887: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2891: END IF;
2892:

Line 2889: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2885: );
2886:
2887: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2891: END IF;
2892:
2893: l_aelv_rec := x_aelv_rec;

Line 2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2886:
2887: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2891: END IF;
2892:
2893: l_aelv_rec := x_aelv_rec;
2894:

Line 2911: WHEN FND_API.G_EXC_ERROR THEN

2907:
2908:
2909: EXCEPTION
2910:
2911: WHEN FND_API.G_EXC_ERROR THEN
2912: ROLLBACK TO create_acct_lines;
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914:
2915: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2913: x_return_status := FND_API.G_RET_STS_ERROR;

2909: EXCEPTION
2910:
2911: WHEN FND_API.G_EXC_ERROR THEN
2912: ROLLBACK TO create_acct_lines;
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914:
2915: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2916: ,p_count => x_msg_count
2917: ,p_data => x_msg_data);

Line 2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2915: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2916: ,p_count => x_msg_count
2917: ,p_data => x_msg_data);
2918:
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: ROLLBACK TO create_acct_lines;
2921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2922: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2923: ,p_count => x_msg_count

Line 2921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2917: ,p_data => x_msg_data);
2918:
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: ROLLBACK TO create_acct_lines;
2921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2922: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2923: ,p_count => x_msg_count
2924: ,p_data => x_msg_data);
2925:

Line 2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2929: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2930: ,p_count => x_msg_count
2931: ,p_data => x_msg_data);
2932: -- notify caller of an UNEXPECTED error
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2934:
2935: END create_acct_lines;
2936:
2937:

Line 2969: x_return_status := FND_API.G_RET_STS_SUCCESS;

2965:
2966: --Initialize the return status
2967:
2968: SAVEPOINT create_acct_lines;
2969: x_return_status := FND_API.G_RET_STS_SUCCESS;
2970:
2971:
2972:
2973:

Line 3028: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3024: END IF;
3025:
3026: x_return_status := l_overall_status;
3027:
3028: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: END IF;

Line 3029: RAISE FND_API.G_EXC_ERROR;

3025:
3026: x_return_status := l_overall_status;
3027:
3028: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: END IF;
3033:

Line 3030: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3026: x_return_status := l_overall_status;
3027:
3028: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: END IF;
3033:
3034: l_aelv_tbl := x_aelv_tbl;

Line 3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3027:
3028: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: END IF;
3033:
3034: l_aelv_tbl := x_aelv_tbl;
3035:

Line 3053: WHEN FND_API.G_EXC_ERROR THEN

3049:
3050:
3051: EXCEPTION
3052:
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: ROLLBACK TO create_acct_lines;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056:
3057: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3055: x_return_status := FND_API.G_RET_STS_ERROR;

3051: EXCEPTION
3052:
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: ROLLBACK TO create_acct_lines;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056:
3057: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3058: ,p_count => x_msg_count
3059: ,p_data => x_msg_data);

Line 3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3057: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3058: ,p_count => x_msg_count
3059: ,p_data => x_msg_data);
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: ROLLBACK TO create_acct_lines;
3063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3064: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3065: ,p_count => x_msg_count

Line 3063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3059: ,p_data => x_msg_data);
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: ROLLBACK TO create_acct_lines;
3063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3064: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3065: ,p_count => x_msg_count
3066: ,p_data => x_msg_data);
3067:

Line 3075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3072: ,p_count => x_msg_count
3073: ,p_data => x_msg_data);
3074: -- notify caller of an UNEXPECTED error
3075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3076:
3077: END create_acct_lines;
3078:
3079:

Line 3101: x_return_status := FND_API.G_RET_STS_SUCCESS;

3097: l_api_name CONSTANT VARCHAR2(30) := 'lock_acct_lines';
3098:
3099: BEGIN
3100:
3101: x_return_status := FND_API.G_RET_STS_SUCCESS;
3102: SAVEPOINT lock_acct_header;
3103:
3104: okl_acct_event_pvt.lock_acct_lines(
3105:

Line 3120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3116: ,p_aelv_rec => p_aelv_rec
3117:
3118: );
3119:
3120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;

Line 3121: RAISE FND_API.G_EXC_ERROR;

3117:
3118: );
3119:
3120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:

Line 3122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3118: );
3119:
3120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:
3126: EXCEPTION

Line 3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3119:
3120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:
3126: EXCEPTION
3127: WHEN FND_API.G_EXC_ERROR THEN

Line 3127: WHEN FND_API.G_EXC_ERROR THEN

3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3124: END IF;
3125:
3126: EXCEPTION
3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO lock_acct_lines;
3129: x_return_status := FND_API.G_RET_STS_ERROR;
3130:
3131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3129: x_return_status := FND_API.G_RET_STS_ERROR;

3125:
3126: EXCEPTION
3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO lock_acct_lines;
3129: x_return_status := FND_API.G_RET_STS_ERROR;
3130:
3131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3132: ,p_count => x_msg_count
3133: ,p_data => x_msg_data);

Line 3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3132: ,p_count => x_msg_count
3133: ,p_data => x_msg_data);
3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3136: ROLLBACK TO lock_acct_lines;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3139: ,p_count => x_msg_count

Line 3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3133: ,p_data => x_msg_data);
3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3136: ROLLBACK TO lock_acct_lines;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3139: ,p_count => x_msg_count
3140: ,p_data => x_msg_data);
3141:

Line 3149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3146: ,p_count => x_msg_count
3147: ,p_data => x_msg_data);
3148: -- notify caller of an UNEXPECTED error
3149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3150:
3151: END lock_acct_lines;
3152:
3153:

Line 3179: x_return_status := FND_API.G_RET_STS_SUCCESS;

3175: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3176:
3177: BEGIN
3178:
3179: x_return_status := FND_API.G_RET_STS_SUCCESS;
3180: SAVEPOINT lock_acct_lines;
3181:
3182: IF (p_aelv_tbl.COUNT > 0) THEN
3183:

Line 3205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3201:
3202: );
3203:
3204: -- store the highest degree of error
3205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3206: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: l_overall_status := l_return_status;
3208: END IF;
3209: END IF;

Line 3206: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

3202: );
3203:
3204: -- store the highest degree of error
3205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3206: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: l_overall_status := l_return_status;
3208: END IF;
3209: END IF;
3210: EXIT WHEN (i = p_aelv_tbl.LAST);

Line 3220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3216: l_return_status := l_overall_status;
3217:
3218: END IF;
3219:
3220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;

Line 3221: RAISE FND_API.G_EXC_ERROR;

3217:
3218: END IF;
3219:
3220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;
3225:

Line 3222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3218: END IF;
3219:
3220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;
3225:
3226: EXCEPTION

Line 3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3219:
3220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3221: RAISE FND_API.G_EXC_ERROR;
3222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;
3225:
3226: EXCEPTION
3227: WHEN FND_API.G_EXC_ERROR THEN

Line 3227: WHEN FND_API.G_EXC_ERROR THEN

3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: END IF;
3225:
3226: EXCEPTION
3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ROLLBACK TO lock_acct_lines;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230:
3231: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3229: x_return_status := FND_API.G_RET_STS_ERROR;

3225:
3226: EXCEPTION
3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ROLLBACK TO lock_acct_lines;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230:
3231: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3232: ,p_count => x_msg_count
3233: ,p_data => x_msg_data);

Line 3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3231: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3232: ,p_count => x_msg_count
3233: ,p_data => x_msg_data);
3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO lock_acct_lines;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3239: ,p_count => x_msg_count

Line 3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3233: ,p_data => x_msg_data);
3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO lock_acct_lines;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3239: ,p_count => x_msg_count
3240: ,p_data => x_msg_data);
3241:

Line 3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3246: ,p_count => x_msg_count
3247: ,p_data => x_msg_data);
3248: -- notify caller of an UNEXPECTED error
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3250:
3251: END lock_acct_lines;
3252:
3253:

Line 3280: x_return_status := FND_API.G_RET_STS_SUCCESS;

3276:
3277: BEGIN
3278:
3279: SAVEPOINT update_acct_lines;
3280: x_return_status := FND_API.G_RET_STS_SUCCESS;
3281:
3282:
3283:
3284: -- customer pre-processing

Line 3318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3314: ,x_aelv_rec => x_aelv_rec
3315:
3316: );
3317:
3318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3319: RAISE FND_API.G_EXC_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;

Line 3319: RAISE FND_API.G_EXC_ERROR;

3315:
3316: );
3317:
3318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3319: RAISE FND_API.G_EXC_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;
3323:

Line 3320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3316: );
3317:
3318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3319: RAISE FND_API.G_EXC_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;
3323:
3324:

Line 3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3317:
3318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3319: RAISE FND_API.G_EXC_ERROR;
3320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;
3323:
3324:
3325: l_aelv_rec := x_aelv_rec;

Line 3343: WHEN FND_API.G_EXC_ERROR THEN

3339:
3340:
3341: EXCEPTION
3342:
3343: WHEN FND_API.G_EXC_ERROR THEN
3344: ROLLBACK TO update_acct_lines;
3345: x_return_status := FND_API.G_RET_STS_ERROR;
3346:
3347: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3345: x_return_status := FND_API.G_RET_STS_ERROR;

3341: EXCEPTION
3342:
3343: WHEN FND_API.G_EXC_ERROR THEN
3344: ROLLBACK TO update_acct_lines;
3345: x_return_status := FND_API.G_RET_STS_ERROR;
3346:
3347: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3348: ,p_count => x_msg_count
3349: ,p_data => x_msg_data);

Line 3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3347: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3348: ,p_count => x_msg_count
3349: ,p_data => x_msg_data);
3350:
3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3352: ROLLBACK TO update_acct_lines;
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3355: ,p_count => x_msg_count

Line 3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3349: ,p_data => x_msg_data);
3350:
3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3352: ROLLBACK TO update_acct_lines;
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3355: ,p_count => x_msg_count
3356: ,p_data => x_msg_data);
3357:

Line 3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3361: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3362: ,p_count => x_msg_count
3363: ,p_data => x_msg_data);
3364: -- notify caller of an UNEXPECTED error
3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3366:
3367: END update_acct_lines;
3368:
3369:

Line 3400: x_return_status := FND_API.G_RET_STS_SUCCESS;

3396: BEGIN
3397:
3398: --Initialize the return status
3399: SAVEPOINT update_acct_lines;
3400: x_return_status := FND_API.G_RET_STS_SUCCESS;
3401:
3402:
3403:
3404: -- customer pre-processing

Line 3458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3454: END IF;
3455:
3456: x_return_status := l_overall_status;
3457:
3458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3459: RAISE FND_API.G_EXC_ERROR;
3460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3462: END IF;

Line 3459: RAISE FND_API.G_EXC_ERROR;

3455:
3456: x_return_status := l_overall_status;
3457:
3458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3459: RAISE FND_API.G_EXC_ERROR;
3460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3462: END IF;
3463:

Line 3460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3456: x_return_status := l_overall_status;
3457:
3458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3459: RAISE FND_API.G_EXC_ERROR;
3460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3462: END IF;
3463:
3464:

Line 3461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3457:
3458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3459: RAISE FND_API.G_EXC_ERROR;
3460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3462: END IF;
3463:
3464:
3465: l_aelv_tbl := x_aelv_tbl;

Line 3485: WHEN FND_API.G_EXC_ERROR THEN

3481:
3482:
3483: EXCEPTION
3484:
3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO update_acct_lines;
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488:
3489: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3487: x_return_status := FND_API.G_RET_STS_ERROR;

3483: EXCEPTION
3484:
3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO update_acct_lines;
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488:
3489: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3490: ,p_count => x_msg_count
3491: ,p_data => x_msg_data);

Line 3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3489: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3490: ,p_count => x_msg_count
3491: ,p_data => x_msg_data);
3492:
3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3494: ROLLBACK TO update_acct_lines;
3495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3496: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3497: ,p_count => x_msg_count

Line 3495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3491: ,p_data => x_msg_data);
3492:
3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3494: ROLLBACK TO update_acct_lines;
3495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3496: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3497: ,p_count => x_msg_count
3498: ,p_data => x_msg_data);
3499:

Line 3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3503: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3504: ,p_count => x_msg_count
3505: ,p_data => x_msg_data);
3506: -- notify caller of an UNEXPECTED error
3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3508:
3509: END update_acct_lines;
3510:
3511:

Line 3540: x_return_status := FND_API.G_RET_STS_SUCCESS;

3536:
3537: BEGIN
3538:
3539: SAVEPOINT delete_acct_lines;
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541:
3542:
3543:
3544: -- customer pre-processing

Line 3576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3572: ,x_msg_data => x_msg_data
3573:
3574: ,p_aelv_rec => l_aelv_rec);
3575:
3576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: RAISE FND_API.G_EXC_ERROR;
3578: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3580: END IF;

Line 3577: RAISE FND_API.G_EXC_ERROR;

3573:
3574: ,p_aelv_rec => l_aelv_rec);
3575:
3576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: RAISE FND_API.G_EXC_ERROR;
3578: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3580: END IF;
3581:

Line 3578: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3574: ,p_aelv_rec => l_aelv_rec);
3575:
3576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: RAISE FND_API.G_EXC_ERROR;
3578: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3580: END IF;
3581:
3582:

Line 3579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3575:
3576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3577: RAISE FND_API.G_EXC_ERROR;
3578: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3580: END IF;
3581:
3582:
3583:

Line 3600: WHEN FND_API.G_EXC_ERROR THEN

3596:
3597:
3598: EXCEPTION
3599:
3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ROLLBACK TO delete_acct_lines;
3602: x_return_status := FND_API.G_RET_STS_ERROR;
3603:
3604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3602: x_return_status := FND_API.G_RET_STS_ERROR;

3598: EXCEPTION
3599:
3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ROLLBACK TO delete_acct_lines;
3602: x_return_status := FND_API.G_RET_STS_ERROR;
3603:
3604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3605: ,p_count => x_msg_count
3606: ,p_data => x_msg_data);

Line 3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3605: ,p_count => x_msg_count
3606: ,p_data => x_msg_data);
3607:
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO delete_acct_lines;
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3612: ,p_count => x_msg_count

Line 3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3606: ,p_data => x_msg_data);
3607:
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO delete_acct_lines;
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3612: ,p_count => x_msg_count
3613: ,p_data => x_msg_data);
3614:

Line 3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3619: ,p_count => x_msg_count
3620: ,p_data => x_msg_data);
3621: -- notify caller of an UNEXPECTED error
3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3623:
3624: END delete_acct_lines;
3625:
3626:

Line 3658: x_return_status := FND_API.G_RET_STS_SUCCESS;

3654:
3655: --Initialize the return status
3656:
3657: SAVEPOINT delete_acct_lines;
3658: x_return_status := FND_API.G_RET_STS_SUCCESS;
3659:
3660:
3661:
3662: -- customer pre-processing

Line 3713: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3709: END IF;
3710:
3711: x_return_status := l_overall_status;
3712:
3713: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3714: RAISE FND_API.G_EXC_ERROR;
3715: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: END IF;

Line 3714: RAISE FND_API.G_EXC_ERROR;

3710:
3711: x_return_status := l_overall_status;
3712:
3713: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3714: RAISE FND_API.G_EXC_ERROR;
3715: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: END IF;
3718:

Line 3715: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3711: x_return_status := l_overall_status;
3712:
3713: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3714: RAISE FND_API.G_EXC_ERROR;
3715: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: END IF;
3718:
3719:

Line 3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3712:
3713: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3714: RAISE FND_API.G_EXC_ERROR;
3715: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: END IF;
3718:
3719:
3720:

Line 3739: WHEN FND_API.G_EXC_ERROR THEN

3735:
3736:
3737: EXCEPTION
3738:
3739: WHEN FND_API.G_EXC_ERROR THEN
3740: ROLLBACK TO delete_acct_lines;
3741: x_return_status := FND_API.G_RET_STS_ERROR;
3742:
3743: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3741: x_return_status := FND_API.G_RET_STS_ERROR;

3737: EXCEPTION
3738:
3739: WHEN FND_API.G_EXC_ERROR THEN
3740: ROLLBACK TO delete_acct_lines;
3741: x_return_status := FND_API.G_RET_STS_ERROR;
3742:
3743: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3744: ,p_count => x_msg_count
3745: ,p_data => x_msg_data);

Line 3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3743: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3744: ,p_count => x_msg_count
3745: ,p_data => x_msg_data);
3746:
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3748: ROLLBACK TO delete_acct_lines;
3749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3751: ,p_count => x_msg_count

Line 3749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3745: ,p_data => x_msg_data);
3746:
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3748: ROLLBACK TO delete_acct_lines;
3749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3751: ,p_count => x_msg_count
3752: ,p_data => x_msg_data);
3753:

Line 3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3758: ,p_count => x_msg_count
3759: ,p_data => x_msg_data);
3760: -- notify caller of an UNEXPECTED error
3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3762:
3763: END delete_acct_lines;
3764:
3765:

Line 3790: x_return_status := FND_API.G_RET_STS_SUCCESS;

3786:
3787: BEGIN
3788:
3789: SAVEPOINT validate_acct_lines;
3790: x_return_status := FND_API.G_RET_STS_SUCCESS;
3791:
3792:
3793:
3794: -- customer pre-processing

Line 3828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3824: ,p_aelv_rec => l_aelv_rec
3825:
3826: );
3827:
3828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3829: RAISE FND_API.G_EXC_ERROR;
3830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3832: END IF;

Line 3829: RAISE FND_API.G_EXC_ERROR;

3825:
3826: );
3827:
3828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3829: RAISE FND_API.G_EXC_ERROR;
3830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3832: END IF;
3833:

Line 3830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3826: );
3827:
3828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3829: RAISE FND_API.G_EXC_ERROR;
3830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3832: END IF;
3833:
3834:

Line 3831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3827:
3828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3829: RAISE FND_API.G_EXC_ERROR;
3830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3832: END IF;
3833:
3834:
3835:

Line 3852: WHEN FND_API.G_EXC_ERROR THEN

3848:
3849:
3850: EXCEPTION
3851:
3852: WHEN FND_API.G_EXC_ERROR THEN
3853: ROLLBACK TO validate_acct_lines;
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855:
3856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3854: x_return_status := FND_API.G_RET_STS_ERROR;

3850: EXCEPTION
3851:
3852: WHEN FND_API.G_EXC_ERROR THEN
3853: ROLLBACK TO validate_acct_lines;
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855:
3856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3857: ,p_count => x_msg_count
3858: ,p_data => x_msg_data);

Line 3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3857: ,p_count => x_msg_count
3858: ,p_data => x_msg_data);
3859:
3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3861: ROLLBACK TO validate_acct_lines;
3862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3864: ,p_count => x_msg_count

Line 3862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3858: ,p_data => x_msg_data);
3859:
3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3861: ROLLBACK TO validate_acct_lines;
3862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3864: ,p_count => x_msg_count
3865: ,p_data => x_msg_data);
3866:

Line 3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3871: ,p_count => x_msg_count
3872: ,p_data => x_msg_data);
3873: -- notify caller of an UNEXPECTED error
3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875:
3876: END validate_acct_lines;
3877:
3878:

Line 3909: x_return_status := FND_API.G_RET_STS_SUCCESS;

3905:
3906: --Initialize the return status
3907:
3908: SAVEPOINT validate_acct_lines;
3909: x_return_status := FND_API.G_RET_STS_SUCCESS;
3910:
3911:
3912:
3913: -- customer pre-processing

Line 3963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3959: END IF;
3960:
3961: x_return_status := l_overall_status;
3962:
3963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: END IF;

Line 3964: RAISE FND_API.G_EXC_ERROR;

3960:
3961: x_return_status := l_overall_status;
3962:
3963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: END IF;
3968:

Line 3965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3961: x_return_status := l_overall_status;
3962:
3963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: END IF;
3968:
3969:

Line 3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3962:
3963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: END IF;
3968:
3969:
3970: -- vertical industry-post-processing

Line 3984: WHEN FND_API.G_EXC_ERROR THEN

3980:
3981:
3982: EXCEPTION
3983:
3984: WHEN FND_API.G_EXC_ERROR THEN
3985: ROLLBACK TO validate_acct_lines;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987:
3988: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3986: x_return_status := FND_API.G_RET_STS_ERROR;

3982: EXCEPTION
3983:
3984: WHEN FND_API.G_EXC_ERROR THEN
3985: ROLLBACK TO validate_acct_lines;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987:
3988: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3989: ,p_count => x_msg_count
3990: ,p_data => x_msg_data);

Line 3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3988: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3989: ,p_count => x_msg_count
3990: ,p_data => x_msg_data);
3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: ROLLBACK TO validate_acct_lines;
3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3995: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3996: ,p_count => x_msg_count

Line 3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3990: ,p_data => x_msg_data);
3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: ROLLBACK TO validate_acct_lines;
3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3995: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3996: ,p_count => x_msg_count
3997: ,p_data => x_msg_data);
3998:

Line 4006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4002: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4003: ,p_count => x_msg_count
4004: ,p_data => x_msg_data);
4005: -- notify caller of an UNEXPECTED error
4006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4007:
4008: END validate_acct_lines;
4009:
4010: