536: SAVEPOINT l_program_name;
537: END IF;
538:
539: IF p_init_msg_list = G_TRUE THEN
540: FND_MSG_PUB.initialize;
541: END IF;
542:
543: l_insurance_estimate_rec := p_insurance_estimate_rec;
544:
601: WHEN OKL_API.G_EXCEPTION_ERROR THEN
602:
603: IF p_transaction_control = G_TRUE THEN
604: ROLLBACK TO l_program_name;
605: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
606: END IF;
607:
608: x_return_status := G_RET_STS_ERROR;
609:
610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
611:
612: IF p_transaction_control = G_TRUE THEN
613: ROLLBACK TO l_program_name;
614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
615: END IF;
616:
617: x_return_status := G_RET_STS_UNEXP_ERROR;
618:
628: p_token3_value => sqlerrm);
629:
630: IF p_transaction_control = G_TRUE THEN
631: ROLLBACK TO l_program_name;
632: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
633: END IF;
634:
635: x_return_status := G_RET_STS_UNEXP_ERROR;
636:
669: SAVEPOINT l_program_name;
670: END IF;
671:
672: IF p_init_msg_list = G_TRUE THEN
673: FND_MSG_PUB.initialize;
674: END IF;
675:
676: l_insurance_estimate_rec := p_insurance_estimate_rec;
677: --Bug#6935907 -Added by kkorrapo
731: WHEN OKL_API.G_EXCEPTION_ERROR THEN
732:
733: IF p_transaction_control = G_TRUE THEN
734: ROLLBACK TO l_program_name;
735: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
736: END IF;
737:
738: x_return_status := G_RET_STS_ERROR;
739:
740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
741:
742: IF p_transaction_control = G_TRUE THEN
743: ROLLBACK TO l_program_name;
744: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
745: END IF;
746:
747: x_return_status := G_RET_STS_UNEXP_ERROR;
748:
758: p_token3_value => sqlerrm);
759:
760: IF p_transaction_control = G_TRUE THEN
761: ROLLBACK TO l_program_name;
762: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
763: END IF;
764:
765: x_return_status := G_RET_STS_UNEXP_ERROR;
766:
789: SAVEPOINT l_program_name;
790: END IF;
791:
792: IF p_init_msg_list = G_TRUE THEN
793: FND_MSG_PUB.initialize;
794: END IF;
795:
796: okl_lease_quote_cashflow_pvt.delete_cashflows (
797: p_api_version => G_API_VERSION
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821:
822: IF p_transaction_control = G_TRUE THEN
823: ROLLBACK TO l_program_name;
824: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
825: END IF;
826:
827: x_return_status := G_RET_STS_ERROR;
828:
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830:
831: IF p_transaction_control = G_TRUE THEN
832: ROLLBACK TO l_program_name;
833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
834: END IF;
835:
836: x_return_status := G_RET_STS_UNEXP_ERROR;
837:
847: p_token3_value => sqlerrm);
848:
849: IF p_transaction_control = G_TRUE THEN
850: ROLLBACK TO l_program_name;
851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
852: END IF;
853:
854: x_return_status := G_RET_STS_UNEXP_ERROR;
855:
883: SAVEPOINT l_program_name;
884: END IF;
885:
886: IF p_init_msg_list = G_TRUE THEN
887: FND_MSG_PUB.initialize;
888: END IF;
889:
890:
891: get_insurance_estimate_rec(
949: WHEN OKL_API.G_EXCEPTION_ERROR THEN
950:
951: IF p_transaction_control = G_TRUE THEN
952: ROLLBACK TO l_program_name;
953: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
954: END IF;
955:
956: x_return_status := G_RET_STS_ERROR;
957:
958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
959:
960: IF p_transaction_control = G_TRUE THEN
961: ROLLBACK TO l_program_name;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: END IF;
964:
965: x_return_status := G_RET_STS_UNEXP_ERROR;
966:
976: p_token3_value => sqlerrm);
977:
978: IF p_transaction_control = G_TRUE THEN
979: ROLLBACK TO l_program_name;
980: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
981: END IF;
982:
983: x_return_status := G_RET_STS_UNEXP_ERROR;
984: