eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LEASE_QUOTE_SERVICE_PVT dependencies on OKL_API

Line 19: WHEN OKL_API.G_EXCEPTION_ERROR THEN

15: BEGIN
16: x_return_status := G_RET_STS_SUCCESS;
17: EXCEPTION
18:
19: WHEN OKL_API.G_EXCEPTION_ERROR THEN
20: x_return_status := G_RET_STS_ERROR;
21:
22: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
23: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 22: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

18:
19: WHEN OKL_API.G_EXCEPTION_ERROR THEN
20: x_return_status := G_RET_STS_ERROR;
21:
22: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
23: x_return_status := G_RET_STS_UNEXP_ERROR;
24:
25: WHEN OTHERS THEN
26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

22: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
23: x_return_status := G_RET_STS_UNEXP_ERROR;
24:
25: WHEN OTHERS THEN
26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
27: p_msg_name => G_DB_ERROR,
28: p_token1 => G_PROG_NAME_TOKEN,
29: p_token1_value => l_program_name,
30: p_token2 => G_SQLCODE_TOKEN,

Line 83: WHEN OKL_API.G_EXCEPTION_ERROR THEN

79: x_return_status := G_RET_STS_SUCCESS;
80:
81: EXCEPTION
82:
83: WHEN OKL_API.G_EXCEPTION_ERROR THEN
84: x_return_status := G_RET_STS_ERROR;
85:
86: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
87: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 86: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

82:
83: WHEN OKL_API.G_EXCEPTION_ERROR THEN
84: x_return_status := G_RET_STS_ERROR;
85:
86: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
87: x_return_status := G_RET_STS_UNEXP_ERROR;
88:
89: WHEN OTHERS THEN
90: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 90: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

86: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
87: x_return_status := G_RET_STS_UNEXP_ERROR;
88:
89: WHEN OTHERS THEN
90: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
91: p_msg_name => G_DB_ERROR,
92: p_token1 => G_PROG_NAME_TOKEN,
93: p_token1_value => l_program_name,
94: p_token2 => G_SQLCODE_TOKEN,

Line 175: WHEN OKL_API.G_EXCEPTION_ERROR THEN

171: x_return_status := G_RET_STS_SUCCESS;
172:
173: EXCEPTION
174:
175: WHEN OKL_API.G_EXCEPTION_ERROR THEN
176: x_return_status := G_RET_STS_ERROR;
177:
178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
179: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

174:
175: WHEN OKL_API.G_EXCEPTION_ERROR THEN
176: x_return_status := G_RET_STS_ERROR;
177:
178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
179: x_return_status := G_RET_STS_UNEXP_ERROR;
180:
181: WHEN OTHERS THEN
182: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 182: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
179: x_return_status := G_RET_STS_UNEXP_ERROR;
180:
181: WHEN OTHERS THEN
182: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
183: p_msg_name => G_DB_ERROR,
184: p_token1 => G_PROG_NAME_TOKEN,
185: p_token1_value => l_program_name,
186: p_token2 => G_SQLCODE_TOKEN,

Line 223: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LINKASSET_NULL_FOUND');

219: l_amt_flag := 'Y';
220: l_assoc_total := l_assoc_total + p_assoc_assets_tbl(i).amount;
221: END IF;
222: IF (p_assoc_assets_tbl(i).amount IS NULL) AND l_amt_flag = 'Y' THEN
223: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226: END IF;
227: END LOOP;

Line 224: RAISE OKL_API.G_EXCEPTION_ERROR;

220: l_assoc_total := l_assoc_total + p_assoc_assets_tbl(i).amount;
221: END IF;
222: IF (p_assoc_assets_tbl(i).amount IS NULL) AND l_amt_flag = 'Y' THEN
223: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226: END IF;
227: END LOOP;
228:

Line 230: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

226: END IF;
227: END LOOP;
228:
229: IF l_amt_flag = 'Y' AND l_assoc_total <> p_service_amount THEN
230: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
231: p_msg_name => 'OKL_LINKASSET_AMT_MISMATCH',
232: p_token1 => 'LINE_COST',
233: p_token1_value => p_service_amount,
234: p_token2 => 'ASSOC_TOTAL',

Line 236: RAISE OKL_API.G_EXCEPTION_ERROR;

232: p_token1 => 'LINE_COST',
233: p_token1_value => p_service_amount,
234: p_token2 => 'ASSOC_TOTAL',
235: p_token2_value => l_assoc_total);
236: RAISE OKL_API.G_EXCEPTION_ERROR;
237: END IF;
238:
239: IF l_amt_flag = 'Y' THEN
240: x_derive_assoc_amt := 'N';

Line 249: WHEN OKL_API.G_EXCEPTION_ERROR THEN

245: x_return_status := G_RET_STS_SUCCESS;
246:
247: EXCEPTION
248:
249: WHEN OKL_API.G_EXCEPTION_ERROR THEN
250: x_return_status := G_RET_STS_ERROR;
251:
252: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
253: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 252: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

248:
249: WHEN OKL_API.G_EXCEPTION_ERROR THEN
250: x_return_status := G_RET_STS_ERROR;
251:
252: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
253: x_return_status := G_RET_STS_UNEXP_ERROR;
254:
255: WHEN OTHERS THEN
256: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 256: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

252: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
253: x_return_status := G_RET_STS_UNEXP_ERROR;
254:
255: WHEN OTHERS THEN
256: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
257: p_msg_name => G_DB_ERROR,
258: p_token1 => G_PROG_NAME_TOKEN,
259: p_token1_value => l_program_name,
260: p_token2 => G_SQLCODE_TOKEN,

Line 436: WHEN OKL_API.G_EXCEPTION_ERROR THEN

432: x_return_status := G_RET_STS_SUCCESS;
433:
434: EXCEPTION
435:
436: WHEN OKL_API.G_EXCEPTION_ERROR THEN
437: x_return_status := G_RET_STS_ERROR;
438:
439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
440: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

435:
436: WHEN OKL_API.G_EXCEPTION_ERROR THEN
437: x_return_status := G_RET_STS_ERROR;
438:
439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
440: x_return_status := G_RET_STS_UNEXP_ERROR;
441:
442: WHEN OTHERS THEN
443: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 443: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
440: x_return_status := G_RET_STS_UNEXP_ERROR;
441:
442: WHEN OTHERS THEN
443: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
444: p_msg_name => G_DB_ERROR,
445: p_token1 => G_PROG_NAME_TOKEN,
446: p_token1_value => l_program_name,
447: p_token2 => G_SQLCODE_TOKEN,

Line 507: WHEN OKL_API.G_EXCEPTION_ERROR THEN

503: x_return_status := G_RET_STS_SUCCESS;
504:
505: EXCEPTION
506:
507: WHEN OKL_API.G_EXCEPTION_ERROR THEN
508: x_return_status := G_RET_STS_ERROR;
509:
510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
511: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

506:
507: WHEN OKL_API.G_EXCEPTION_ERROR THEN
508: x_return_status := G_RET_STS_ERROR;
509:
510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
511: x_return_status := G_RET_STS_UNEXP_ERROR;
512:
513: WHEN OTHERS THEN
514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
511: x_return_status := G_RET_STS_UNEXP_ERROR;
512:
513: WHEN OTHERS THEN
514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
515: p_msg_name => G_DB_ERROR,
516: p_token1 => G_PROG_NAME_TOKEN,
517: p_token1_value => l_program_name,
518: p_token2 => G_SQLCODE_TOKEN,

Line 574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

570: ,x_lrev_tbl => lx_assoc_assets_tbl
571: );
572:
573: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF x_return_status = G_RET_STS_ERROR THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:

Line 576: RAISE OKL_API.G_EXCEPTION_ERROR;

572:
573: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF x_return_status = G_RET_STS_ERROR THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:
579: EXCEPTION
580:

Line 581: WHEN OKL_API.G_EXCEPTION_ERROR THEN

577: END IF;
578:
579: EXCEPTION
580:
581: WHEN OKL_API.G_EXCEPTION_ERROR THEN
582: x_return_status := G_RET_STS_ERROR;
583:
584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
585: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

580:
581: WHEN OKL_API.G_EXCEPTION_ERROR THEN
582: x_return_status := G_RET_STS_ERROR;
583:
584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
585: x_return_status := G_RET_STS_UNEXP_ERROR;
586:
587: WHEN OTHERS THEN
588: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 588: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
585: x_return_status := G_RET_STS_UNEXP_ERROR;
586:
587: WHEN OTHERS THEN
588: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
589: p_msg_name => G_DB_ERROR,
590: p_token1 => G_PROG_NAME_TOKEN,
591: p_token1_value => l_program_name,
592: p_token2 => G_SQLCODE_TOKEN,

Line 634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

630: ,x_return_status => x_return_status
631: );
632:
633: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
635: ELSIF x_return_status = G_RET_STS_ERROR THEN
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638:

Line 636: RAISE OKL_API.G_EXCEPTION_ERROR;

632:
633: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
635: ELSIF x_return_status = G_RET_STS_ERROR THEN
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638:
639: IF l_deleted_assoc_assets_tbl.COUNT > 0 THEN
640: okl_lre_pvt.delete_row (

Line 648: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

644: ,x_msg_count => x_msg_count
645: ,x_msg_data => x_msg_data
646: ,p_lrev_tbl => l_deleted_assoc_assets_tbl );
647: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
648: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF x_return_status = G_RET_STS_ERROR THEN
650: RAISE OKL_API.G_EXCEPTION_ERROR;
651: END IF;
652: END IF;

Line 650: RAISE OKL_API.G_EXCEPTION_ERROR;

646: ,p_lrev_tbl => l_deleted_assoc_assets_tbl );
647: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
648: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF x_return_status = G_RET_STS_ERROR THEN
650: RAISE OKL_API.G_EXCEPTION_ERROR;
651: END IF;
652: END IF;
653:
654: IF l_line_relation_tbl.COUNT > 0 THEN

Line 699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

695: ,x_lrev_tbl => lx_assoc_assets_tbl
696: );
697:
698: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
700: ELSIF x_return_status = G_RET_STS_ERROR THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
703:

Line 701: RAISE OKL_API.G_EXCEPTION_ERROR;

697:
698: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
700: ELSIF x_return_status = G_RET_STS_ERROR THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
703:
704: END IF;
705:

Line 719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

715: ,x_lrev_tbl => lx_assoc_assets_tbl
716: );
717:
718: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
720: ELSIF x_return_status = G_RET_STS_ERROR THEN
721: RAISE OKL_API.G_EXCEPTION_ERROR;
722: END IF;
723:

Line 721: RAISE OKL_API.G_EXCEPTION_ERROR;

717:
718: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
720: ELSIF x_return_status = G_RET_STS_ERROR THEN
721: RAISE OKL_API.G_EXCEPTION_ERROR;
722: END IF;
723:
724: END IF;
725:

Line 730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

726: x_return_status := G_RET_STS_SUCCESS;
727:
728: EXCEPTION
729:
730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
731: x_return_status := G_RET_STS_ERROR;
732:
733: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
734: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 733: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

729:
730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
731: x_return_status := G_RET_STS_ERROR;
732:
733: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
734: x_return_status := G_RET_STS_UNEXP_ERROR;
735:
736: WHEN OTHERS THEN
737: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 737: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

733: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
734: x_return_status := G_RET_STS_UNEXP_ERROR;
735:
736: WHEN OTHERS THEN
737: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
738: p_msg_name => G_DB_ERROR,
739: p_token1 => G_PROG_NAME_TOKEN,
740: p_token1_value => l_program_name,
741: p_token2 => G_SQLCODE_TOKEN,

Line 825: WHEN OKL_API.G_EXCEPTION_ERROR THEN

821:
822: x_return_status := G_RET_STS_SUCCESS;
823: EXCEPTION
824:
825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: x_return_status := G_RET_STS_ERROR;
827:
828: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
829: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 828: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

824:
825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: x_return_status := G_RET_STS_ERROR;
827:
828: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
829: x_return_status := G_RET_STS_UNEXP_ERROR;
830:
831: WHEN OTHERS THEN
832: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 832: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

828: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
829: x_return_status := G_RET_STS_UNEXP_ERROR;
830:
831: WHEN OTHERS THEN
832: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
833: p_msg_name => G_DB_ERROR,
834: p_token1 => G_PROG_NAME_TOKEN,
835: p_token1_value => l_program_name,
836: p_token2 => G_SQLCODE_TOKEN,

Line 886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

882: p_target_service_id => p_target_service_id,
883: x_lrship_tbl => l_lrship_tbl,
884: x_return_status => x_return_status);
885: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF x_return_status = G_RET_STS_ERROR THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890:

Line 888: RAISE OKL_API.G_EXCEPTION_ERROR;

884: x_return_status => x_return_status);
885: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF x_return_status = G_RET_STS_ERROR THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: -- Set the original asset id for the records
892: IF (l_lrship_tbl.COUNT > 0) THEN

Line 911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

907: ,p_lrev_tbl => l_lrship_tbl
908: ,x_lrev_tbl => lx_lrship_tbl );
909:
910: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
912: ELSIF x_return_status = G_RET_STS_ERROR THEN
913: RAISE OKL_API.G_EXCEPTION_ERROR;
914: END IF;
915: END IF;

Line 913: RAISE OKL_API.G_EXCEPTION_ERROR;

909:
910: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
911: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
912: ELSIF x_return_status = G_RET_STS_ERROR THEN
913: RAISE OKL_API.G_EXCEPTION_ERROR;
914: END IF;
915: END IF;
916:
917: x_return_status := G_RET_STS_SUCCESS;

Line 921: WHEN OKL_API.G_EXCEPTION_ERROR THEN

917: x_return_status := G_RET_STS_SUCCESS;
918:
919: EXCEPTION
920:
921: WHEN OKL_API.G_EXCEPTION_ERROR THEN
922:
923: x_return_status := G_RET_STS_ERROR;
924:
925: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 925: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

921: WHEN OKL_API.G_EXCEPTION_ERROR THEN
922:
923: x_return_status := G_RET_STS_ERROR;
924:
925: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
926:
927: x_return_status := G_RET_STS_UNEXP_ERROR;
928:
929: WHEN OTHERS THEN

Line 931: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

927: x_return_status := G_RET_STS_UNEXP_ERROR;
928:
929: WHEN OTHERS THEN
930:
931: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
932: p_msg_name => G_DB_ERROR,
933: p_token1 => G_PROG_NAME_TOKEN,
934: p_token1_value => l_api_name,
935: p_token2 => G_SQLCODE_TOKEN,

Line 973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

969: ,x_svcv_rec => lx_service_rec
970: );
971:
972: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
974: ELSIF x_return_status = G_RET_STS_ERROR THEN
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;
977:

Line 975: RAISE OKL_API.G_EXCEPTION_ERROR;

971:
972: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
974: ELSIF x_return_status = G_RET_STS_ERROR THEN
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;
977:
978: x_service_id := lx_service_rec.id;
979:

Line 982: WHEN OKL_API.G_EXCEPTION_ERROR THEN

978: x_service_id := lx_service_rec.id;
979:
980: EXCEPTION
981:
982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
983: x_return_status := G_RET_STS_ERROR;
984:
985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
986: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

981:
982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
983: x_return_status := G_RET_STS_ERROR;
984:
985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
986: x_return_status := G_RET_STS_UNEXP_ERROR;
987:
988: WHEN OTHERS THEN
989: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 989: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
986: x_return_status := G_RET_STS_UNEXP_ERROR;
987:
988: WHEN OTHERS THEN
989: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
990: p_msg_name => G_DB_ERROR,
991: p_token1 => G_PROG_NAME_TOKEN,
992: p_token1_value => l_program_name,
993: p_token2 => G_SQLCODE_TOKEN,

Line 1031: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1027: ,x_svcv_rec => lx_service_rec
1028: );
1029:
1030: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1031: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1032: ELSIF x_return_status = G_RET_STS_ERROR THEN
1033: RAISE OKL_API.G_EXCEPTION_ERROR;
1034: END IF;
1035:

Line 1033: RAISE OKL_API.G_EXCEPTION_ERROR;

1029:
1030: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1031: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1032: ELSIF x_return_status = G_RET_STS_ERROR THEN
1033: RAISE OKL_API.G_EXCEPTION_ERROR;
1034: END IF;
1035:
1036: EXCEPTION
1037:

Line 1038: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1034: END IF;
1035:
1036: EXCEPTION
1037:
1038: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1039: x_return_status := G_RET_STS_ERROR;
1040:
1041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1042: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1037:
1038: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1039: x_return_status := G_RET_STS_ERROR;
1040:
1041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1042: x_return_status := G_RET_STS_UNEXP_ERROR;
1043:
1044: WHEN OTHERS THEN
1045: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1045: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1042: x_return_status := G_RET_STS_UNEXP_ERROR;
1043:
1044: WHEN OTHERS THEN
1045: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1046: p_msg_name => G_DB_ERROR,
1047: p_token1 => G_PROG_NAME_TOKEN,
1048: p_token1_value => l_program_name,
1049: p_token2 => G_SQLCODE_TOKEN,

Line 1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1092: ,x_msg_data => x_msg_data
1093: );
1094:
1095: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1097: ELSIF x_return_status = G_RET_STS_ERROR THEN
1098: RAISE OKL_API.G_EXCEPTION_ERROR;
1099: END IF;
1100:

Line 1098: RAISE OKL_API.G_EXCEPTION_ERROR;

1094:
1095: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1097: ELSIF x_return_status = G_RET_STS_ERROR THEN
1098: RAISE OKL_API.G_EXCEPTION_ERROR;
1099: END IF;
1100:
1101: EXCEPTION
1102:

Line 1103: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1099: END IF;
1100:
1101: EXCEPTION
1102:
1103: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1104: x_return_status := G_RET_STS_ERROR;
1105:
1106: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1107: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1106: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1102:
1103: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1104: x_return_status := G_RET_STS_ERROR;
1105:
1106: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1107: x_return_status := G_RET_STS_UNEXP_ERROR;
1108:
1109: WHEN OTHERS THEN
1110: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1110: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1106: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1107: x_return_status := G_RET_STS_UNEXP_ERROR;
1108:
1109: WHEN OTHERS THEN
1110: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1111: p_msg_name => G_DB_ERROR,
1112: p_token1 => G_PROG_NAME_TOKEN,
1113: p_token1_value => l_program_name,
1114: p_token2 => G_SQLCODE_TOKEN,

Line 1159: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1155: ,x_msg_data => x_msg_data
1156: );
1157:
1158: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1159: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: ELSIF x_return_status = G_RET_STS_ERROR THEN
1161: RAISE OKL_API.G_EXCEPTION_ERROR;
1162: END IF;
1163:

Line 1161: RAISE OKL_API.G_EXCEPTION_ERROR;

1157:
1158: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1159: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: ELSIF x_return_status = G_RET_STS_ERROR THEN
1161: RAISE OKL_API.G_EXCEPTION_ERROR;
1162: END IF;
1163:
1164: EXCEPTION
1165:

Line 1166: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1162: END IF;
1163:
1164: EXCEPTION
1165:
1166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1167: x_return_status := G_RET_STS_ERROR;
1168:
1169: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1170: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1169: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1165:
1166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1167: x_return_status := G_RET_STS_ERROR;
1168:
1169: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1170: x_return_status := G_RET_STS_UNEXP_ERROR;
1171:
1172: WHEN OTHERS THEN
1173: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1173: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1169: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1170: x_return_status := G_RET_STS_UNEXP_ERROR;
1171:
1172: WHEN OTHERS THEN
1173: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1174: p_msg_name => G_DB_ERROR,
1175: p_token1 => G_PROG_NAME_TOKEN,
1176: p_token1_value => l_program_name,
1177: p_token2 => G_SQLCODE_TOKEN,

Line 1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1219: ,x_msg_data => x_msg_data
1220: );
1221:
1222: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: ELSIF x_return_status = G_RET_STS_ERROR THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;
1227:

Line 1225: RAISE OKL_API.G_EXCEPTION_ERROR;

1221:
1222: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: ELSIF x_return_status = G_RET_STS_ERROR THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;
1227:
1228: EXCEPTION
1229:

Line 1230: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1226: END IF;
1227:
1228: EXCEPTION
1229:
1230: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1231: x_return_status := G_RET_STS_ERROR;
1232:
1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1234: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1229:
1230: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1231: x_return_status := G_RET_STS_ERROR;
1232:
1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1234: x_return_status := G_RET_STS_UNEXP_ERROR;
1235:
1236: WHEN OTHERS THEN
1237: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1237: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1234: x_return_status := G_RET_STS_UNEXP_ERROR;
1235:
1236: WHEN OTHERS THEN
1237: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1238: p_msg_name => G_DB_ERROR,
1239: p_token1 => G_PROG_NAME_TOKEN,
1240: p_token1_value => l_program_name,
1241: p_token2 => G_SQLCODE_TOKEN,

Line 1286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1282: ,x_msg_data => x_msg_data
1283: );
1284:
1285: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF x_return_status = G_RET_STS_ERROR THEN
1288: RAISE OKL_API.G_EXCEPTION_ERROR;
1289: END IF;
1290:

Line 1288: RAISE OKL_API.G_EXCEPTION_ERROR;

1284:
1285: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF x_return_status = G_RET_STS_ERROR THEN
1288: RAISE OKL_API.G_EXCEPTION_ERROR;
1289: END IF;
1290:
1291: EXCEPTION
1292:

Line 1293: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1289: END IF;
1290:
1291: EXCEPTION
1292:
1293: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1294: x_return_status := G_RET_STS_ERROR;
1295:
1296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1297: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1292:
1293: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1294: x_return_status := G_RET_STS_ERROR;
1295:
1296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1297: x_return_status := G_RET_STS_UNEXP_ERROR;
1298:
1299: WHEN OTHERS THEN
1300: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1300: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1296: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1297: x_return_status := G_RET_STS_UNEXP_ERROR;
1298:
1299: WHEN OTHERS THEN
1300: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1301: p_msg_name => G_DB_ERROR,
1302: p_token1 => G_PROG_NAME_TOKEN,
1303: p_token1_value => l_program_name,
1304: p_token2 => G_SQLCODE_TOKEN,

Line 1364: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_RECEXP_PERIODS_INVALID');

1360:
1361: IF p_expense_level_tbl(p_expense_level_tbl.FIRST).periods <>
1362: TRUNC (p_expense_level_tbl(p_expense_level_tbl.FIRST).periods) THEN
1363:
1364: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_RECEXP_PERIODS_INVALID');
1365: RAISE OKL_API.G_EXCEPTION_ERROR;
1366:
1367: END IF;
1368:

Line 1365: RAISE OKL_API.G_EXCEPTION_ERROR;

1361: IF p_expense_level_tbl(p_expense_level_tbl.FIRST).periods <>
1362: TRUNC (p_expense_level_tbl(p_expense_level_tbl.FIRST).periods) THEN
1363:
1364: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_RECEXP_PERIODS_INVALID');
1365: RAISE OKL_API.G_EXCEPTION_ERROR;
1366:
1367: END IF;
1368:
1369: l_periodic_amount :=

Line 1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1377: ,x_return_status => l_return_status
1378: );
1379:
1380: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF l_return_status = G_RET_STS_ERROR THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385:

Line 1383: RAISE OKL_API.G_EXCEPTION_ERROR;

1379:
1380: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF l_return_status = G_RET_STS_ERROR THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385:
1386: IF p_assoc_asset_tbl.COUNT > 0 THEN
1387:

Line 1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1394: ,x_return_status => l_return_status
1395: );
1396:
1397: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1399: ELSIF l_return_status = G_RET_STS_ERROR THEN
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;
1402:

Line 1400: RAISE OKL_API.G_EXCEPTION_ERROR;

1396:
1397: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1399: ELSIF l_return_status = G_RET_STS_ERROR THEN
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;
1402:
1403: IF (l_derive_assoc_amt = 'Y') THEN
1404:

Line 1417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1413: ,x_msg_data => x_msg_data
1414: );
1415:
1416: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1418: ELSIF l_return_status = G_RET_STS_ERROR THEN
1419: RAISE OKL_API.G_EXCEPTION_ERROR;
1420: END IF;
1421:

Line 1419: RAISE OKL_API.G_EXCEPTION_ERROR;

1415:
1416: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1418: ELSIF l_return_status = G_RET_STS_ERROR THEN
1419: RAISE OKL_API.G_EXCEPTION_ERROR;
1420: END IF;
1421:
1422: END IF;
1423:

Line 1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1431: ,x_msg_data => x_msg_data
1432: );
1433:
1434: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1436: ELSIF l_return_status = G_RET_STS_ERROR THEN
1437: RAISE OKL_API.G_EXCEPTION_ERROR;
1438: END IF;
1439:

Line 1437: RAISE OKL_API.G_EXCEPTION_ERROR;

1433:
1434: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1436: ELSIF l_return_status = G_RET_STS_ERROR THEN
1437: RAISE OKL_API.G_EXCEPTION_ERROR;
1438: END IF;
1439:
1440: IF l_line_relation_tbl.COUNT > 0 THEN
1441:

Line 1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1447: ,x_msg_data => x_msg_data
1448: );
1449:
1450: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1452: ELSIF l_return_status = G_RET_STS_ERROR THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455:

Line 1453: RAISE OKL_API.G_EXCEPTION_ERROR;

1449:
1450: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1452: ELSIF l_return_status = G_RET_STS_ERROR THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455:
1456: END IF;
1457:

Line 1459: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1455:
1456: END IF;
1457:
1458: IF (p_payment_level_tbl.COUNT > 0 AND p_payment_header_rec.stream_type_id IS NULL) THEN
1459: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1460: p_msg_name => 'OKL_SALES_NO_PAYMENTHEAD');
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1463: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1461: RAISE OKL_API.G_EXCEPTION_ERROR;

1457:
1458: IF (p_payment_level_tbl.COUNT > 0 AND p_payment_header_rec.stream_type_id IS NULL) THEN
1459: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1460: p_msg_name => 'OKL_SALES_NO_PAYMENTHEAD');
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1463: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1464: p_msg_name => 'OKL_SALES_NO_PAYMENTLINES');
1465: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1463: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1459: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1460: p_msg_name => 'OKL_SALES_NO_PAYMENTHEAD');
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1463: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1464: p_msg_name => 'OKL_SALES_NO_PAYMENTLINES');
1465: RAISE OKL_API.G_EXCEPTION_ERROR;
1466: END IF;
1467:

Line 1465: RAISE OKL_API.G_EXCEPTION_ERROR;

1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1463: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1464: p_msg_name => 'OKL_SALES_NO_PAYMENTLINES');
1465: RAISE OKL_API.G_EXCEPTION_ERROR;
1466: END IF;
1467:
1468: IF p_payment_level_tbl.COUNT > 0 THEN
1469:

Line 1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1476: ,x_msg_data => x_msg_data
1477: );
1478:
1479: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF l_return_status = G_RET_STS_ERROR THEN
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;
1484:

Line 1482: RAISE OKL_API.G_EXCEPTION_ERROR;

1478:
1479: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF l_return_status = G_RET_STS_ERROR THEN
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;
1484:
1485: END IF;
1486:

Line 1497: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1493: ,x_msg_data => x_msg_data
1494: );
1495:
1496: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1497: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1498: ELSIF l_return_status = G_RET_STS_ERROR THEN
1499: RAISE OKL_API.G_EXCEPTION_ERROR;
1500: END IF;
1501:

Line 1499: RAISE OKL_API.G_EXCEPTION_ERROR;

1495:
1496: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1497: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1498: ELSIF l_return_status = G_RET_STS_ERROR THEN
1499: RAISE OKL_API.G_EXCEPTION_ERROR;
1500: END IF;
1501:
1502: x_return_status := G_RET_STS_SUCCESS;
1503:

Line 1506: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1502: x_return_status := G_RET_STS_SUCCESS;
1503:
1504: EXCEPTION
1505:
1506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1507:
1508: IF p_transaction_control = G_TRUE THEN
1509: ROLLBACK TO l_program_name;
1510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1515: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1511: END IF;
1512:
1513: x_return_status := G_RET_STS_ERROR;
1514:
1515: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1516:
1517: IF p_transaction_control = G_TRUE THEN
1518: ROLLBACK TO l_program_name;
1519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1526: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1522: x_return_status := G_RET_STS_UNEXP_ERROR;
1523:
1524: WHEN OTHERS THEN
1525:
1526: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1527: p_msg_name => G_DB_ERROR,
1528: p_token1 => G_PROG_NAME_TOKEN,
1529: p_token1_value => l_api_name,
1530: p_token2 => G_SQLCODE_TOKEN,

Line 1588: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1584:
1585: x_return_status := G_RET_STS_SUCCESS;
1586: EXCEPTION
1587:
1588: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1589: x_return_status := G_RET_STS_ERROR;
1590:
1591: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1591: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1587:
1588: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1589: x_return_status := G_RET_STS_ERROR;
1590:
1591: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := G_RET_STS_UNEXP_ERROR;
1593:
1594: WHEN OTHERS THEN
1595: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1595: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1591: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := G_RET_STS_UNEXP_ERROR;
1593:
1594: WHEN OTHERS THEN
1595: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1596: p_msg_name => G_DB_ERROR,
1597: p_token1 => G_PROG_NAME_TOKEN,
1598: p_token1_value => l_program_name,
1599: p_token2 => G_SQLCODE_TOKEN,

Line 1647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1643: get_line_relations_tbl (p_service_id => p_service_id
1644: ,x_line_relation_tbl => l_copy_relation_tbl
1645: ,x_return_status => x_return_status);
1646: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1648: ELSIF x_return_status = G_RET_STS_ERROR THEN
1649: RAISE OKL_API.G_EXCEPTION_ERROR;
1650: END IF;
1651:

Line 1649: RAISE OKL_API.G_EXCEPTION_ERROR;

1645: ,x_return_status => x_return_status);
1646: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1648: ELSIF x_return_status = G_RET_STS_ERROR THEN
1649: RAISE OKL_API.G_EXCEPTION_ERROR;
1650: END IF;
1651:
1652: SELECT LVL.AMOUNT * LVL.NUMBER_OF_PERIODS
1653: INTO ln_service_amount

Line 1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1677: ,x_msg_count => x_msg_count
1678: ,x_msg_data => x_msg_data );
1679:
1680: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1682: ELSIF x_return_status = G_RET_STS_ERROR THEN
1683: RAISE OKL_API.G_EXCEPTION_ERROR;
1684: END IF;
1685:

Line 1683: RAISE OKL_API.G_EXCEPTION_ERROR;

1679:
1680: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1682: ELSIF x_return_status = G_RET_STS_ERROR THEN
1683: RAISE OKL_API.G_EXCEPTION_ERROR;
1684: END IF;
1685:
1686: FOR i IN l_copy_relation_tbl.FIRST .. l_copy_relation_tbl.LAST LOOP
1687: IF l_copy_relation_tbl.EXISTS(i) THEN

Line 1709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1705: ,p_lrev_tbl => l_line_relation_tbl
1706: ,x_lrev_tbl => lx_line_relation_tbl);
1707:
1708: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1710: ELSIF x_return_status = G_RET_STS_ERROR THEN
1711: RAISE OKL_API.G_EXCEPTION_ERROR;
1712: END IF;
1713: END IF;

Line 1711: RAISE OKL_API.G_EXCEPTION_ERROR;

1707:
1708: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1710: ELSIF x_return_status = G_RET_STS_ERROR THEN
1711: RAISE OKL_API.G_EXCEPTION_ERROR;
1712: END IF;
1713: END IF;
1714: END IF;
1715:

Line 1720: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1716: x_return_status := G_RET_STS_SUCCESS;
1717:
1718: EXCEPTION
1719:
1720: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1721:
1722: IF p_transaction_control = G_TRUE THEN
1723: ROLLBACK TO l_program_name;
1724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1729: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1725: END IF;
1726:
1727: x_return_status := G_RET_STS_ERROR;
1728:
1729: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1730:
1731: IF p_transaction_control = G_TRUE THEN
1732: ROLLBACK TO l_program_name;
1733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1740: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1736: x_return_status := G_RET_STS_UNEXP_ERROR;
1737:
1738: WHEN OTHERS THEN
1739:
1740: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1741: p_msg_name => G_DB_ERROR,
1742: p_token1 => G_PROG_NAME_TOKEN,
1743: p_token1_value => l_api_name,
1744: p_token2 => G_SQLCODE_TOKEN,

Line 1807: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_RECEXP_PERIODS_INVALID');

1803:
1804: IF p_expense_level_tbl(p_expense_level_tbl.FIRST).periods <>
1805: TRUNC (p_expense_level_tbl(p_expense_level_tbl.FIRST).periods) THEN
1806:
1807: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_RECEXP_PERIODS_INVALID');
1808: RAISE OKL_API.G_EXCEPTION_ERROR;
1809:
1810: END IF;
1811:

Line 1808: RAISE OKL_API.G_EXCEPTION_ERROR;

1804: IF p_expense_level_tbl(p_expense_level_tbl.FIRST).periods <>
1805: TRUNC (p_expense_level_tbl(p_expense_level_tbl.FIRST).periods) THEN
1806:
1807: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_RECEXP_PERIODS_INVALID');
1808: RAISE OKL_API.G_EXCEPTION_ERROR;
1809:
1810: END IF;
1811:
1812: l_periodic_amount :=

Line 1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1820: ,x_return_status => l_return_status
1821: );
1822:
1823: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF l_return_status = G_RET_STS_ERROR THEN
1826: RAISE OKL_API.G_EXCEPTION_ERROR;
1827: END IF;
1828:

Line 1826: RAISE OKL_API.G_EXCEPTION_ERROR;

1822:
1823: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF l_return_status = G_RET_STS_ERROR THEN
1826: RAISE OKL_API.G_EXCEPTION_ERROR;
1827: END IF;
1828:
1829: IF p_assoc_asset_tbl.COUNT > 0 THEN
1830:

Line 1841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1837: ,x_return_status => l_return_status
1838: );
1839:
1840: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF l_return_status = G_RET_STS_ERROR THEN
1843: RAISE OKL_API.G_EXCEPTION_ERROR;
1844: END IF;
1845:

Line 1843: RAISE OKL_API.G_EXCEPTION_ERROR;

1839:
1840: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF l_return_status = G_RET_STS_ERROR THEN
1843: RAISE OKL_API.G_EXCEPTION_ERROR;
1844: END IF;
1845:
1846: IF (l_derive_assoc_amt = 'Y') THEN
1847:

Line 1860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1856: ,x_msg_data => x_msg_data
1857: );
1858:
1859: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1861: ELSIF l_return_status = G_RET_STS_ERROR THEN
1862: RAISE OKL_API.G_EXCEPTION_ERROR;
1863: END IF;
1864:

Line 1862: RAISE OKL_API.G_EXCEPTION_ERROR;

1858:
1859: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1861: ELSIF l_return_status = G_RET_STS_ERROR THEN
1862: RAISE OKL_API.G_EXCEPTION_ERROR;
1863: END IF;
1864:
1865: END IF;
1866:

Line 1877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1873: ,x_msg_data => x_msg_data
1874: );
1875:
1876: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF l_return_status = G_RET_STS_ERROR THEN
1879: RAISE OKL_API.G_EXCEPTION_ERROR;
1880: END IF;
1881:

Line 1879: RAISE OKL_API.G_EXCEPTION_ERROR;

1875:
1876: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1877: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF l_return_status = G_RET_STS_ERROR THEN
1879: RAISE OKL_API.G_EXCEPTION_ERROR;
1880: END IF;
1881:
1882: IF l_line_relation_tbl.COUNT > 0 THEN
1883:

Line 1893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1889: ,x_msg_data => x_msg_data
1890: );
1891:
1892: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1894: ELSIF l_return_status = G_RET_STS_ERROR THEN
1895: RAISE OKL_API.G_EXCEPTION_ERROR;
1896: END IF;
1897:

Line 1895: RAISE OKL_API.G_EXCEPTION_ERROR;

1891:
1892: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1894: ELSIF l_return_status = G_RET_STS_ERROR THEN
1895: RAISE OKL_API.G_EXCEPTION_ERROR;
1896: END IF;
1897:
1898: END IF;
1899:

Line 1901: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1897:
1898: END IF;
1899:
1900: IF (p_payment_level_tbl.COUNT > 0 AND p_payment_header_rec.stream_type_id IS NULL) THEN
1901: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1902: p_msg_name => 'OKL_SALES_NO_PAYMENTHEAD');
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1903: RAISE OKL_API.G_EXCEPTION_ERROR;

1899:
1900: IF (p_payment_level_tbl.COUNT > 0 AND p_payment_header_rec.stream_type_id IS NULL) THEN
1901: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1902: p_msg_name => 'OKL_SALES_NO_PAYMENTHEAD');
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1906: p_msg_name => 'OKL_SALES_NO_PAYMENTLINES');
1907: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1901: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1902: p_msg_name => 'OKL_SALES_NO_PAYMENTHEAD');
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1906: p_msg_name => 'OKL_SALES_NO_PAYMENTLINES');
1907: RAISE OKL_API.G_EXCEPTION_ERROR;
1908: END IF;
1909:

Line 1907: RAISE OKL_API.G_EXCEPTION_ERROR;

1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: ELSIF (p_payment_header_rec.stream_type_id IS NOT NULL AND p_payment_level_tbl.COUNT = 0 ) THEN
1905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1906: p_msg_name => 'OKL_SALES_NO_PAYMENTLINES');
1907: RAISE OKL_API.G_EXCEPTION_ERROR;
1908: END IF;
1909:
1910: IF p_payment_level_tbl.COUNT > 0 THEN
1911:

Line 1922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1918: ,x_msg_data => x_msg_data
1919: );
1920:
1921: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF l_return_status = G_RET_STS_ERROR THEN
1924: RAISE OKL_API.G_EXCEPTION_ERROR;
1925: END IF;
1926:

Line 1924: RAISE OKL_API.G_EXCEPTION_ERROR;

1920:
1921: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF l_return_status = G_RET_STS_ERROR THEN
1924: RAISE OKL_API.G_EXCEPTION_ERROR;
1925: END IF;
1926:
1927: END IF;
1928:

Line 1939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1935: ,x_msg_data => x_msg_data
1936: );
1937:
1938: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1940: ELSIF l_return_status = G_RET_STS_ERROR THEN
1941: RAISE OKL_API.G_EXCEPTION_ERROR;
1942: END IF;
1943:

Line 1941: RAISE OKL_API.G_EXCEPTION_ERROR;

1937:
1938: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1940: ELSIF l_return_status = G_RET_STS_ERROR THEN
1941: RAISE OKL_API.G_EXCEPTION_ERROR;
1942: END IF;
1943:
1944: x_return_status := G_RET_STS_SUCCESS;
1945:

Line 1948: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1944: x_return_status := G_RET_STS_SUCCESS;
1945:
1946: EXCEPTION
1947:
1948: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1949:
1950: IF p_transaction_control = G_TRUE THEN
1951: ROLLBACK TO l_program_name;
1952: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1957: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1953: END IF;
1954:
1955: x_return_status := G_RET_STS_ERROR;
1956:
1957: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1958:
1959: IF p_transaction_control = G_TRUE THEN
1960: ROLLBACK TO l_program_name;
1961: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1968: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1964: x_return_status := G_RET_STS_UNEXP_ERROR;
1965:
1966: WHEN OTHERS THEN
1967:
1968: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1969: p_msg_name => G_DB_ERROR,
1970: p_token1 => G_PROG_NAME_TOKEN,
1971: p_token1_value => l_api_name,
1972: p_token2 => G_SQLCODE_TOKEN,

Line 2037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2033: ,x_msg_data => x_msg_data
2034: );
2035:
2036: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2038: ELSIF x_return_status = G_RET_STS_ERROR THEN
2039: RAISE OKL_API.G_EXCEPTION_ERROR;
2040: END IF;
2041:

Line 2039: RAISE OKL_API.G_EXCEPTION_ERROR;

2035:
2036: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2038: ELSIF x_return_status = G_RET_STS_ERROR THEN
2039: RAISE OKL_API.G_EXCEPTION_ERROR;
2040: END IF;
2041:
2042: x_return_status := G_RET_STS_SUCCESS;
2043:

Line 2046: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2042: x_return_status := G_RET_STS_SUCCESS;
2043:
2044: EXCEPTION
2045:
2046: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2047:
2048: IF p_transaction_control = G_TRUE THEN
2049: ROLLBACK TO l_program_name;
2050: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2051: END IF;
2052:
2053: x_return_status := G_RET_STS_ERROR;
2054:
2055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2056:
2057: IF p_transaction_control = G_TRUE THEN
2058: ROLLBACK TO l_program_name;
2059: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2066: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

2062: x_return_status := G_RET_STS_UNEXP_ERROR;
2063:
2064: WHEN OTHERS THEN
2065:
2066: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2067: p_msg_name => G_DB_ERROR,
2068: p_token1 => G_PROG_NAME_TOKEN,
2069: p_token1_value => l_api_name,
2070: p_token2 => G_SQLCODE_TOKEN,

Line 2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2127: ,x_service_rec => l_service_rec
2128: ,x_return_status => x_return_status);
2129:
2130: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF x_return_status = G_RET_STS_ERROR THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135:

Line 2133: RAISE OKL_API.G_EXCEPTION_ERROR;

2129:
2130: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF x_return_status = G_RET_STS_ERROR THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135:
2136: l_service_rec.parent_object_id := p_target_quote_id;
2137:

Line 2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2143: ,x_msg_data => x_msg_data
2144: );
2145:
2146: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF x_return_status = G_RET_STS_ERROR THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;
2150: END IF;
2151:

Line 2149: RAISE OKL_API.G_EXCEPTION_ERROR;

2145:
2146: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF x_return_status = G_RET_STS_ERROR THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;
2150: END IF;
2151:
2152: -- Validation to check if the product and expected start date for source
2153: -- and target contracts are equal, if not cash flows are not copied.

Line 2191: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2187: x_return_status => x_return_status,
2188: x_msg_count => x_msg_count,
2189: x_msg_data => x_msg_data );
2190: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2191: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2192: ELSIF x_return_status = G_RET_STS_ERROR THEN
2193: RAISE OKL_API.G_EXCEPTION_ERROR;
2194: END IF;
2195: END IF;

Line 2193: RAISE OKL_API.G_EXCEPTION_ERROR;

2189: x_msg_data => x_msg_data );
2190: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2191: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2192: ELSIF x_return_status = G_RET_STS_ERROR THEN
2193: RAISE OKL_API.G_EXCEPTION_ERROR;
2194: END IF;
2195: END IF;
2196:
2197: IF (lb_copy_cashflow) THEN

Line 2211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2207: ,x_msg_count => x_msg_count
2208: ,x_msg_data => x_msg_data );
2209:
2210: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF x_return_status = G_RET_STS_ERROR THEN
2213: RAISE OKL_API.G_EXCEPTION_ERROR;
2214: END IF;
2215: END IF;

Line 2213: RAISE OKL_API.G_EXCEPTION_ERROR;

2209:
2210: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF x_return_status = G_RET_STS_ERROR THEN
2213: RAISE OKL_API.G_EXCEPTION_ERROR;
2214: END IF;
2215: END IF;
2216:
2217: x_return_status := G_RET_STS_SUCCESS;

Line 2221: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2217: x_return_status := G_RET_STS_SUCCESS;
2218:
2219: EXCEPTION
2220:
2221: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2222:
2223: IF p_transaction_control = G_TRUE THEN
2224: ROLLBACK TO l_program_name;
2225: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2226: END IF;
2227:
2228: x_return_status := G_RET_STS_ERROR;
2229:
2230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2231:
2232: IF p_transaction_control = G_TRUE THEN
2233: ROLLBACK TO l_program_name;
2234: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2241: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

2237: x_return_status := G_RET_STS_UNEXP_ERROR;
2238:
2239: WHEN OTHERS THEN
2240:
2241: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2242: p_msg_name => G_DB_ERROR,
2243: p_token1 => G_PROG_NAME_TOKEN,
2244: p_token1_value => l_api_name,
2245: p_token2 => G_SQLCODE_TOKEN,

Line 2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2310: ,p_lrev_tbl => l_lrev_tbl
2311: );
2312:
2313: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2315: ELSIF x_return_status = G_RET_STS_ERROR THEN
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:

Line 2316: RAISE OKL_API.G_EXCEPTION_ERROR;

2312:
2313: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2315: ELSIF x_return_status = G_RET_STS_ERROR THEN
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: END IF;
2320:

Line 2333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2329: ,x_msg_data => x_msg_data
2330: );
2331:
2332: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2334: ELSIF x_return_status = G_RET_STS_ERROR THEN
2335: RAISE OKL_API.G_EXCEPTION_ERROR;
2336: END IF;
2337:

Line 2335: RAISE OKL_API.G_EXCEPTION_ERROR;

2331:
2332: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2334: ELSIF x_return_status = G_RET_STS_ERROR THEN
2335: RAISE OKL_API.G_EXCEPTION_ERROR;
2336: END IF;
2337:
2338: l_svcv_rec.id := p_service_id;
2339:

Line 2350: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2346: ,p_svcv_rec => l_svcv_rec
2347: );
2348:
2349: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2350: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF x_return_status = G_RET_STS_ERROR THEN
2352: RAISE OKL_API.G_EXCEPTION_ERROR;
2353: END IF;
2354:

Line 2352: RAISE OKL_API.G_EXCEPTION_ERROR;

2348:
2349: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2350: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF x_return_status = G_RET_STS_ERROR THEN
2352: RAISE OKL_API.G_EXCEPTION_ERROR;
2353: END IF;
2354:
2355: x_return_status := G_RET_STS_SUCCESS;
2356:

Line 2359: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2355: x_return_status := G_RET_STS_SUCCESS;
2356:
2357: EXCEPTION
2358:
2359: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2360:
2361: IF p_transaction_control = G_TRUE THEN
2362: ROLLBACK TO l_program_name;
2363: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2364: END IF;
2365:
2366: x_return_status := G_RET_STS_ERROR;
2367:
2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2369:
2370: IF p_transaction_control = G_TRUE THEN
2371: ROLLBACK TO l_program_name;
2372: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2379: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

2375: x_return_status := G_RET_STS_UNEXP_ERROR;
2376:
2377: WHEN OTHERS THEN
2378:
2379: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2380: p_msg_name => G_DB_ERROR,
2381: p_token1 => G_PROG_NAME_TOKEN,
2382: p_token1_value => l_api_name,
2383: p_token2 => G_SQLCODE_TOKEN,