APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_API

Line 24: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

20: RETURN lease_qte_rec_type IS
21: -- Variables Declarations
22: l_api_version CONSTANT NUMBER DEFAULT 1.0;
23: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POPULATE_QUOTE_REC';
24: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
25: l_debug_enabled VARCHAR2(10);
26:
27: -- Record/Table Type Declarations
28: l_lsqv_rec lease_qte_rec_type;

Line 212: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

208: RETURN fee_rec_type IS
209: -- Variables Declarations
210: l_api_version CONSTANT NUMBER DEFAULT 1.0;
211: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POPULATE_FEE_REC';
212: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
213: l_debug_enabled VARCHAR2(10);
214:
215: -- Record/Table Type Declarations
216: l_feev_rec fee_rec_type;

Line 332: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

328: RETURN asset_rec_type IS
329: -- Variables Declarations
330: l_api_version CONSTANT NUMBER DEFAULT 1.0;
331: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POPULATE_ASSET_REC';
332: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
333: l_debug_enabled VARCHAR2(10);
334:
335: -- Record/Table Type Declarations
336: l_assv_rec asset_rec_type;

Line 437: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

433: RETURN VARCHAR2 IS
434: -- Variables Declarations
435: l_api_version CONSTANT NUMBER DEFAULT 1.0;
436: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'all_lns_ovr';
437: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
438: l_all_lines_overriden VARCHAR2(3) := 'N';
439: l_ovr_cnt NUMBER;
440: l_ast_cnt NUMBER;
441: CURSOR llo_flag_csr IS

Line 528: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

524: RETURN VARCHAR2 IS
525: -- Variables Declarations
526: l_api_version CONSTANT NUMBER DEFAULT 1.0;
527: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'qte_pr_entr';
528: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
529: l_falg VARCHAR2(3) := 'N';
530: BEGIN
531: IF p_lease_qte_rec.pricing_method = 'SY' THEN
532: IF p_payment_count <> 0 THEN

Line 599: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

595: ,x_msg_data OUT NOCOPY VARCHAR2) IS
596: -- Variables Declarations
597: l_api_version CONSTANT NUMBER DEFAULT 1.0;
598: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'VALIDATE';
599: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
600: l_debug_enabled VARCHAR2(10);
601:
602: l_object_type VARCHAR2(15):= 'LEASEQUOTE';
603:

Line 609: x_return_status := OKL_API.G_RET_STS_SUCCESS;

605: l_lease_qte_rec lease_qte_rec_type;
606: lx_lease_qte_rec lease_qte_rec_type;
607:
608: BEGIN
609: x_return_status := OKL_API.G_RET_STS_SUCCESS;
610: -- check for logging on PROCEDURE level
611: l_debug_enabled := okl_debug_pub.check_log_enabled;
612: -- call START_ACTIVITY to create savepoint, check compatibility
613: -- and initialize message list

Line 614: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

610: -- check for logging on PROCEDURE level
611: l_debug_enabled := okl_debug_pub.check_log_enabled;
612: -- call START_ACTIVITY to create savepoint, check compatibility
613: -- and initialize message list
614: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
615: ,p_pkg_name => G_PKG_NAME
616: ,p_init_msg_list => p_init_msg_list
617: ,l_api_version => l_api_version
618: ,p_api_version => p_api_version

Line 622: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

618: ,p_api_version => p_api_version
619: ,p_api_type => g_api_type
620: ,x_return_status => x_return_status);
621: -- check if activity started successfully
622: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
624: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_ERROR;
626: END IF;

Line 623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

619: ,p_api_type => g_api_type
620: ,x_return_status => x_return_status);
621: -- check if activity started successfully
622: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
624: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_ERROR;
626: END IF;
627: --Pupulate lease quote rec

Line 624: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

620: ,x_return_status => x_return_status);
621: -- check if activity started successfully
622: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
624: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_ERROR;
626: END IF;
627: --Pupulate lease quote rec
628: l_lease_qte_rec := populate_quote_rec(p_quote_id,x_return_status);

Line 625: RAISE OKL_API.G_EXCEPTION_ERROR;

621: -- check if activity started successfully
622: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
624: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
625: RAISE OKL_API.G_EXCEPTION_ERROR;
626: END IF;
627: --Pupulate lease quote rec
628: l_lease_qte_rec := populate_quote_rec(p_quote_id,x_return_status);
629:

Line 631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

627: --Pupulate lease quote rec
628: l_lease_qte_rec := populate_quote_rec(p_quote_id,x_return_status);
629:
630: IF(x_return_status = G_RET_STS_UNEXP_ERROR) THEN
631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
633: RAISE OKL_API.G_EXCEPTION_ERROR;
634: END IF;
635:

Line 633: RAISE OKL_API.G_EXCEPTION_ERROR;

629:
630: IF(x_return_status = G_RET_STS_UNEXP_ERROR) THEN
631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
633: RAISE OKL_API.G_EXCEPTION_ERROR;
634: END IF;
635:
636: IF(l_debug_enabled='Y') THEN
637: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'

Line 655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

651: ,'end debug call run_qa_checker');
652: END IF;
653:
654: IF(x_return_status = G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:

Line 657: RAISE OKL_API.G_EXCEPTION_ERROR;

653:
654: IF(x_return_status = G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
661: ,x_msg_data => x_msg_data);

Line 660: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

656: ELSIF(x_return_status = G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
661: ,x_msg_data => x_msg_data);
662: EXCEPTION
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 663: WHEN OKL_API.G_EXCEPTION_ERROR THEN

659:
660: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
661: ,x_msg_data => x_msg_data);
662: EXCEPTION
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
665: p_api_name => l_api_name,
666: p_pkg_name => G_PKG_NAME,
667: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 664: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

660: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
661: ,x_msg_data => x_msg_data);
662: EXCEPTION
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
665: p_api_name => l_api_name,
666: p_pkg_name => G_PKG_NAME,
667: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
668: x_msg_count => x_msg_count,

Line 667: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
665: p_api_name => l_api_name,
666: p_pkg_name => G_PKG_NAME,
667: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data,
670: p_api_type => g_api_type);
671: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 671: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

667: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data,
670: p_api_type => g_api_type);
671: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
673: p_api_name => l_api_name,
674: p_pkg_name => G_PKG_NAME,
675: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data,
670: p_api_type => g_api_type);
671: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
673: p_api_name => l_api_name,
674: p_pkg_name => G_PKG_NAME,
675: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
676: x_msg_count => x_msg_count,

Line 675: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

671: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
673: p_api_name => l_api_name,
674: p_pkg_name => G_PKG_NAME,
675: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
676: x_msg_count => x_msg_count,
677: x_msg_data => x_msg_data,
678: p_api_type => g_api_type);
679: WHEN OTHERS THEN

Line 680: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

676: x_msg_count => x_msg_count,
677: x_msg_data => x_msg_data,
678: p_api_type => g_api_type);
679: WHEN OTHERS THEN
680: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
681: p_api_name => l_api_name,
682: p_pkg_name => G_PKG_NAME,
683: p_exc_name => 'OTHERS',
684: x_msg_count => x_msg_count,

Line 715: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

711: ) IS
712: -- Variables Declarations
713: l_api_version CONSTANT NUMBER DEFAULT 1.0;
714: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'PRICE';
715: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
716: l_debug_enabled VARCHAR2(10);
717:
718: l_quote_id OKL_LEASE_QUOTES_B.ID%TYPE;
719:

Line 724: x_return_status := OKL_API.G_RET_STS_SUCCESS;

720: -- Record/Table Type Declarations
721:
722:
723: BEGIN
724: x_return_status := OKL_API.G_RET_STS_SUCCESS;
725: -- check for logging on PROCEDURE level
726: l_debug_enabled := okl_debug_pub.check_log_enabled;
727: -- call START_ACTIVITY to create savepoint, check compatibility
728: -- and initialize message list

Line 729: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

725: -- check for logging on PROCEDURE level
726: l_debug_enabled := okl_debug_pub.check_log_enabled;
727: -- call START_ACTIVITY to create savepoint, check compatibility
728: -- and initialize message list
729: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
730: ,p_pkg_name => G_PKG_NAME
731: ,p_init_msg_list => p_init_msg_list
732: ,l_api_version => l_api_version
733: ,p_api_version => p_api_version

Line 737: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

733: ,p_api_version => p_api_version
734: ,p_api_type => g_api_type
735: ,x_return_status => x_return_status);
736: -- check if activity started successfully
737: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
739: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_ERROR;
741: END IF;

Line 738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

734: ,p_api_type => g_api_type
735: ,x_return_status => x_return_status);
736: -- check if activity started successfully
737: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
739: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_ERROR;
741: END IF;
742: l_quote_id := p_quote_id;

Line 739: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

735: ,x_return_status => x_return_status);
736: -- check if activity started successfully
737: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
739: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_ERROR;
741: END IF;
742: l_quote_id := p_quote_id;
743:

Line 740: RAISE OKL_API.G_EXCEPTION_ERROR;

736: -- check if activity started successfully
737: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
739: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_ERROR;
741: END IF;
742: l_quote_id := p_quote_id;
743:
744: IF(l_debug_enabled='Y') THEN

Line 761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

757: ,'end debug call price_standard_quote');
758: END IF;
759:
760: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
762: ELSIF x_return_status = G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;
765:

Line 763: RAISE OKL_API.G_EXCEPTION_ERROR;

759:
760: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
762: ELSIF x_return_status = G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;
765:
766: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
767: ,x_msg_data => x_msg_data);

Line 766: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

762: ELSIF x_return_status = G_RET_STS_ERROR THEN
763: RAISE OKL_API.G_EXCEPTION_ERROR;
764: END IF;
765:
766: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
767: ,x_msg_data => x_msg_data);
768: EXCEPTION
769: WHEN OKL_API.G_EXCEPTION_ERROR THEN
770: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 769: WHEN OKL_API.G_EXCEPTION_ERROR THEN

765:
766: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
767: ,x_msg_data => x_msg_data);
768: EXCEPTION
769: WHEN OKL_API.G_EXCEPTION_ERROR THEN
770: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
771: p_api_name => l_api_name,
772: p_pkg_name => G_PKG_NAME,
773: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 770: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

766: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
767: ,x_msg_data => x_msg_data);
768: EXCEPTION
769: WHEN OKL_API.G_EXCEPTION_ERROR THEN
770: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
771: p_api_name => l_api_name,
772: p_pkg_name => G_PKG_NAME,
773: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
774: x_msg_count => x_msg_count,

Line 773: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

769: WHEN OKL_API.G_EXCEPTION_ERROR THEN
770: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
771: p_api_name => l_api_name,
772: p_pkg_name => G_PKG_NAME,
773: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data,
776: p_api_type => g_api_type);
777: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 777: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

773: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data,
776: p_api_type => g_api_type);
777: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
779: p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,
781: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data,
776: p_api_type => g_api_type);
777: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
779: p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,
781: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
782: x_msg_count => x_msg_count,

Line 781: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

777: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
779: p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,
781: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
782: x_msg_count => x_msg_count,
783: x_msg_data => x_msg_data,
784: p_api_type => g_api_type);
785: WHEN OTHERS THEN

Line 786: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

782: x_msg_count => x_msg_count,
783: x_msg_data => x_msg_data,
784: p_api_type => g_api_type);
785: WHEN OTHERS THEN
786: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
787: p_api_name => l_api_name,
788: p_pkg_name => G_PKG_NAME,
789: p_exc_name => 'OTHERS',
790: x_msg_count => x_msg_count,

Line 822: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

818: ) IS
819: -- Variables Declarations
820: l_api_version CONSTANT NUMBER DEFAULT 1.0;
821: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CALCULATE TAX';
822: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
823: l_debug_enabled VARCHAR2(10);
824:
825: l_source_table VARCHAR2(30):= 'OKL_LEASE_QUOTES_B';
826: l_source_trx_name VARCHAR2(15):='Quoting';

Line 833: x_return_status := OKL_API.G_RET_STS_SUCCESS;

829: -- Record/Table Type Declarations
830:
831:
832: BEGIN
833: x_return_status := OKL_API.G_RET_STS_SUCCESS;
834: -- check for logging on PROCEDURE level
835: l_debug_enabled := okl_debug_pub.check_log_enabled;
836: -- call START_ACTIVITY to create savepoint, check compatibility
837: -- and initialize message list

Line 838: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

834: -- check for logging on PROCEDURE level
835: l_debug_enabled := okl_debug_pub.check_log_enabled;
836: -- call START_ACTIVITY to create savepoint, check compatibility
837: -- and initialize message list
838: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
839: ,p_pkg_name => G_PKG_NAME
840: ,p_init_msg_list => p_init_msg_list
841: ,l_api_version => l_api_version
842: ,p_api_version => p_api_version

Line 846: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

842: ,p_api_version => p_api_version
843: ,p_api_type => g_api_type
844: ,x_return_status => x_return_status);
845: -- check if activity started successfully
846: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
848: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
849: RAISE OKL_API.G_EXCEPTION_ERROR;
850: END IF;

Line 847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

843: ,p_api_type => g_api_type
844: ,x_return_status => x_return_status);
845: -- check if activity started successfully
846: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
848: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
849: RAISE OKL_API.G_EXCEPTION_ERROR;
850: END IF;
851: l_quote_id := p_quote_id;

Line 848: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

844: ,x_return_status => x_return_status);
845: -- check if activity started successfully
846: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
848: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
849: RAISE OKL_API.G_EXCEPTION_ERROR;
850: END IF;
851: l_quote_id := p_quote_id;
852:

Line 849: RAISE OKL_API.G_EXCEPTION_ERROR;

845: -- check if activity started successfully
846: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
847: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
848: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
849: RAISE OKL_API.G_EXCEPTION_ERROR;
850: END IF;
851: l_quote_id := p_quote_id;
852:
853: IF(l_debug_enabled='Y') THEN

Line 873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

869: ,'end debug call price_standard_quote');
870: END IF;
871:
872: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF x_return_status = G_RET_STS_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_ERROR;
876: END IF;
877:

Line 875: RAISE OKL_API.G_EXCEPTION_ERROR;

871:
872: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF x_return_status = G_RET_STS_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_ERROR;
876: END IF;
877:
878: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
879: ,x_msg_data => x_msg_data);

Line 878: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

874: ELSIF x_return_status = G_RET_STS_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_ERROR;
876: END IF;
877:
878: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
879: ,x_msg_data => x_msg_data);
880: EXCEPTION
881: WHEN OKL_API.G_EXCEPTION_ERROR THEN
882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 881: WHEN OKL_API.G_EXCEPTION_ERROR THEN

877:
878: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
879: ,x_msg_data => x_msg_data);
880: EXCEPTION
881: WHEN OKL_API.G_EXCEPTION_ERROR THEN
882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
883: p_api_name => l_api_name,
884: p_pkg_name => G_PKG_NAME,
885: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

878: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
879: ,x_msg_data => x_msg_data);
880: EXCEPTION
881: WHEN OKL_API.G_EXCEPTION_ERROR THEN
882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
883: p_api_name => l_api_name,
884: p_pkg_name => G_PKG_NAME,
885: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
886: x_msg_count => x_msg_count,

Line 885: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

881: WHEN OKL_API.G_EXCEPTION_ERROR THEN
882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
883: p_api_name => l_api_name,
884: p_pkg_name => G_PKG_NAME,
885: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
886: x_msg_count => x_msg_count,
887: x_msg_data => x_msg_data,
888: p_api_type => g_api_type);
889: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 889: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

885: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
886: x_msg_count => x_msg_count,
887: x_msg_data => x_msg_data,
888: p_api_type => g_api_type);
889: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
890: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
891: p_api_name => l_api_name,
892: p_pkg_name => G_PKG_NAME,
893: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 890: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

886: x_msg_count => x_msg_count,
887: x_msg_data => x_msg_data,
888: p_api_type => g_api_type);
889: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
890: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
891: p_api_name => l_api_name,
892: p_pkg_name => G_PKG_NAME,
893: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
894: x_msg_count => x_msg_count,

Line 893: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

889: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
890: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
891: p_api_name => l_api_name,
892: p_pkg_name => G_PKG_NAME,
893: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
894: x_msg_count => x_msg_count,
895: x_msg_data => x_msg_data,
896: p_api_type => g_api_type);
897: WHEN OTHERS THEN

Line 898: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

894: x_msg_count => x_msg_count,
895: x_msg_data => x_msg_data,
896: p_api_type => g_api_type);
897: WHEN OTHERS THEN
898: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
899: p_api_name => l_api_name,
900: p_pkg_name => G_PKG_NAME,
901: p_exc_name => 'OTHERS',
902: x_msg_count => x_msg_count,

Line 936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

932:
933: -- Variables Declarations
934: l_api_version CONSTANT NUMBER DEFAULT 1.0;
935: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'HNDL_PRNT_STS';
936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
937: l_debug_enabled VARCHAR2(10);
938: lx_return_status VARCHAR2(1);
939:
940: x_lapv_rec OKL_LAP_PVT.LAPV_REC_TYPE;

Line 954: x_return_status := OKL_API.G_RET_STS_SUCCESS;

950: WHERE parent_object_id =p_parent_object_id
951: AND primary_quote = 'Y';
952:
953: BEGIN
954: x_return_status := OKL_API.G_RET_STS_SUCCESS;
955: -- check for logging on PROCEDURE level
956: l_debug_enabled := okl_debug_pub.check_log_enabled;
957: -- call START_ACTIVITY to create savepoint, check compatibility
958: -- and initialize message list

Line 959: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

955: -- check for logging on PROCEDURE level
956: l_debug_enabled := okl_debug_pub.check_log_enabled;
957: -- call START_ACTIVITY to create savepoint, check compatibility
958: -- and initialize message list
959: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
960: ,p_pkg_name => G_PKG_NAME
961: ,p_init_msg_list => p_init_msg_list
962: ,l_api_version => l_api_version
963: ,p_api_version => p_api_version

Line 967: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

963: ,p_api_version => p_api_version
964: ,p_api_type => g_api_type
965: ,x_return_status => x_return_status);
966: -- check if activity started successfully
967: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;

Line 968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

964: ,p_api_type => g_api_type
965: ,x_return_status => x_return_status);
966: -- check if activity started successfully
967: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972:

Line 969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

965: ,x_return_status => x_return_status);
966: -- check if activity started successfully
967: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972:
973: IF(l_debug_enabled='Y') THEN

Line 970: RAISE OKL_API.G_EXCEPTION_ERROR;

966: -- check if activity started successfully
967: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972:
973: IF(l_debug_enabled='Y') THEN
974: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_APP_PVT.populate_lease_app'

Line 987: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

983:
984: l_lsqv_rec := populate_quote_rec ( p_quote_id => l_quote_id,
985: x_return_status => x_return_status );
986:
987: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;

Line 988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

984: l_lsqv_rec := populate_quote_rec ( p_quote_id => l_quote_id,
985: x_return_status => x_return_status );
986:
987: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: l_lsqv_rec.STATUS := 'PR-INCOMPLETE';

Line 989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

985: x_return_status => x_return_status );
986:
987: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: l_lsqv_rec.STATUS := 'PR-INCOMPLETE';
993:

Line 990: RAISE OKL_API.G_EXCEPTION_ERROR;

986:
987: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: l_lsqv_rec.STATUS := 'PR-INCOMPLETE';
993:
994: OKL_LEASE_QUOTE_PVT.update_lease_qte(

Line 1005: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1001: ,x_msg_count => x_msg_count
1002: ,x_msg_data => x_msg_data);
1003:
1004: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1005: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1006: ELSIF x_return_status = G_RET_STS_ERROR THEN
1007: RAISE OKL_API.G_EXCEPTION_ERROR;
1008: END IF;
1009:

Line 1007: RAISE OKL_API.G_EXCEPTION_ERROR;

1003:
1004: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1005: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1006: ELSIF x_return_status = G_RET_STS_ERROR THEN
1007: RAISE OKL_API.G_EXCEPTION_ERROR;
1008: END IF;
1009:
1010:
1011: OKL_LEASE_APP_PVT.populate_lease_app(p_api_version => p_api_version,

Line 1023: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1019: IF(l_debug_enabled='Y') THEN
1020: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_APP_PVT.populate_lease_app'
1021: ,'end debug call populate_lease_app');
1022: END IF;
1023: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;

Line 1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1020: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_APP_PVT.populate_lease_app'
1021: ,'end debug call populate_lease_app');
1022: END IF;
1023: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;
1028:

Line 1025: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1021: ,'end debug call populate_lease_app');
1022: END IF;
1023: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;
1028:
1029: IF x_lapv_rec.APPLICATION_STATUS IN ('PR-COMPLETE', 'PR-APPROVED','PR-REJECTED') THEN

Line 1026: RAISE OKL_API.G_EXCEPTION_ERROR;

1022: END IF;
1023: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: END IF;
1028:
1029: IF x_lapv_rec.APPLICATION_STATUS IN ('PR-COMPLETE', 'PR-APPROVED','PR-REJECTED') THEN
1030: x_lapv_rec.APPLICATION_STATUS := 'INCOMPLETE';

Line 1048: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1044: IF(l_debug_enabled='Y') THEN
1045: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_APP_PVT.lease_app_upd'
1046: ,'end debug call lease_app_upd');
1047: END IF;
1048: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;

Line 1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1045: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_APP_PVT.lease_app_upd'
1046: ,'end debug call lease_app_upd');
1047: END IF;
1048: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: END IF;

Line 1050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1046: ,'end debug call lease_app_upd');
1047: END IF;
1048: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: END IF;
1054: END IF;

Line 1051: RAISE OKL_API.G_EXCEPTION_ERROR;

1047: END IF;
1048: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: END IF;
1054: END IF;
1055:

Line 1057: OKL_API.END_ACTIVITY(

1053: END IF;
1054: END IF;
1055:
1056: x_return_status := okc_api.G_RET_STS_SUCCESS;
1057: OKL_API.END_ACTIVITY(
1058: x_msg_count => x_msg_count
1059: ,x_msg_data => x_msg_data);
1060: EXCEPTION
1061: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1061: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1057: OKL_API.END_ACTIVITY(
1058: x_msg_count => x_msg_count
1059: ,x_msg_data => x_msg_data);
1060: EXCEPTION
1061: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1062: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1063: p_api_name => l_api_name,
1064: p_pkg_name => G_PKG_NAME,
1065: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1062: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1058: x_msg_count => x_msg_count
1059: ,x_msg_data => x_msg_data);
1060: EXCEPTION
1061: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1062: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1063: p_api_name => l_api_name,
1064: p_pkg_name => G_PKG_NAME,
1065: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1066: x_msg_count => x_msg_count,

Line 1065: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1061: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1062: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1063: p_api_name => l_api_name,
1064: p_pkg_name => G_PKG_NAME,
1065: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1066: x_msg_count => x_msg_count,
1067: x_msg_data => x_msg_data,
1068: p_api_type => G_API_TYPE);
1069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1065: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1066: x_msg_count => x_msg_count,
1067: x_msg_data => x_msg_data,
1068: p_api_type => G_API_TYPE);
1069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1071: p_api_name => l_api_name,
1072: p_pkg_name => G_PKG_NAME,
1073: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1066: x_msg_count => x_msg_count,
1067: x_msg_data => x_msg_data,
1068: p_api_type => G_API_TYPE);
1069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1071: p_api_name => l_api_name,
1072: p_pkg_name => G_PKG_NAME,
1073: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1074: x_msg_count => x_msg_count,

Line 1073: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1071: p_api_name => l_api_name,
1072: p_pkg_name => G_PKG_NAME,
1073: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1074: x_msg_count => x_msg_count,
1075: x_msg_data => x_msg_data,
1076: p_api_type => G_API_TYPE);
1077: WHEN OTHERS THEN

Line 1078: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1074: x_msg_count => x_msg_count,
1075: x_msg_data => x_msg_data,
1076: p_api_type => G_API_TYPE);
1077: WHEN OTHERS THEN
1078: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1079: p_api_name => l_api_name,
1080: p_pkg_name => G_PKG_NAME,
1081: p_exc_name => 'OTHERS',
1082: x_msg_count => x_msg_count,

Line 1117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1113:
1114: -- Variables Declarations
1115: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1116: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_UPDATE_PAYMENT';
1117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1118: l_debug_enabled VARCHAR2(10);
1119:
1120: -- Record/Table Type Declarations
1121: l_payment_header_rec cashflow_hdr_rec_type;

Line 1155: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1151: WHERE parent_object_id = lc_quote_id
1152: AND parent_object_code = 'LEASEQUOTE'
1153: AND fee_type <> 'CAPITALIZED';
1154: BEGIN
1155: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1156: -- check for logging on PROCEDURE level
1157: l_debug_enabled := okl_debug_pub.check_log_enabled;
1158: -- call START_ACTIVITY to create savepoint, check compatibility
1159: -- and initialize message list

Line 1160: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

1156: -- check for logging on PROCEDURE level
1157: l_debug_enabled := okl_debug_pub.check_log_enabled;
1158: -- call START_ACTIVITY to create savepoint, check compatibility
1159: -- and initialize message list
1160: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
1161: ,p_pkg_name => G_PKG_NAME
1162: ,p_init_msg_list => p_init_msg_list
1163: ,l_api_version => l_api_version
1164: ,p_api_version => p_api_version

Line 1168: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1164: ,p_api_version => p_api_version
1165: ,p_api_type => g_api_type
1166: ,x_return_status => x_return_status);
1167: -- check if activity started successfully
1168: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1170: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_ERROR;
1172: END IF;

Line 1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1165: ,p_api_type => g_api_type
1166: ,x_return_status => x_return_status);
1167: -- check if activity started successfully
1168: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1170: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_ERROR;
1172: END IF;
1173: --Pupulate quote record

Line 1170: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1166: ,x_return_status => x_return_status);
1167: -- check if activity started successfully
1168: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1170: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_ERROR;
1172: END IF;
1173: --Pupulate quote record
1174: l_lease_qte_rec := populate_quote_rec(p_lease_qte_rec.id,x_return_status);

Line 1171: RAISE OKL_API.G_EXCEPTION_ERROR;

1167: -- check if activity started successfully
1168: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1170: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_ERROR;
1172: END IF;
1173: --Pupulate quote record
1174: l_lease_qte_rec := populate_quote_rec(p_lease_qte_rec.id,x_return_status);
1175:

Line 1177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1173: --Pupulate quote record
1174: l_lease_qte_rec := populate_quote_rec(p_lease_qte_rec.id,x_return_status);
1175:
1176: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1178: ELSIF x_return_status = G_RET_STS_ERROR THEN
1179: RAISE OKL_API.G_EXCEPTION_ERROR;
1180: END IF;
1181:

Line 1179: RAISE OKL_API.G_EXCEPTION_ERROR;

1175:
1176: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1178: ELSIF x_return_status = G_RET_STS_ERROR THEN
1179: RAISE OKL_API.G_EXCEPTION_ERROR;
1180: END IF;
1181:
1182: l_lease_qte_rec.TARGET_RATE_TYPE := p_lease_qte_rec.TARGET_RATE_TYPE;
1183: l_lease_qte_rec.TARGET_RATE := p_lease_qte_rec.TARGET_RATE;

Line 1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1193:
1194: l_all_lines_overriden := okl_sales_quote_qa_pvt.are_all_lines_overriden(l_lease_qte_rec.id,l_lease_qte_rec.pricing_method,l_lease_qte_rec.LINE_LEVEL_PRICING ,x_return_status);
1195:
1196: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF x_return_status = G_RET_STS_ERROR THEN
1199: RAISE OKL_API.G_EXCEPTION_ERROR;
1200: END IF;
1201:

Line 1199: RAISE OKL_API.G_EXCEPTION_ERROR;

1195:
1196: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1197: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF x_return_status = G_RET_STS_ERROR THEN
1199: RAISE OKL_API.G_EXCEPTION_ERROR;
1200: END IF;
1201:
1202: IF l_all_lines_overriden = 'Y' THEN
1203: l_entered := are_qte_pricing_opts_entered(l_lease_qte_rec,p_payment_level_tbl.count,x_return_status);

Line 1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1202: IF l_all_lines_overriden = 'Y' THEN
1203: l_entered := are_qte_pricing_opts_entered(l_lease_qte_rec,p_payment_level_tbl.count,x_return_status);
1204:
1205: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1207: ELSIF x_return_status = G_RET_STS_ERROR THEN
1208: RAISE OKL_API.G_EXCEPTION_ERROR;
1209: END IF;
1210:

Line 1208: RAISE OKL_API.G_EXCEPTION_ERROR;

1204:
1205: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1207: ELSIF x_return_status = G_RET_STS_ERROR THEN
1208: RAISE OKL_API.G_EXCEPTION_ERROR;
1209: END IF;
1210:
1211: IF l_entered = 'Y' THEN
1212:

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

1209: END IF;
1210:
1211: IF l_entered = 'Y' THEN
1212:
1213: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1214: p_msg_name => 'OKL_QTE_PMT_ENTERED');
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: END IF;
1217: l_lease_qte_rec.TARGET_RATE_TYPE := NULL;

Line 1215: RAISE OKL_API.G_EXCEPTION_ERROR;

1211: IF l_entered = 'Y' THEN
1212:
1213: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1214: p_msg_name => 'OKL_QTE_PMT_ENTERED');
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: END IF;
1217: l_lease_qte_rec.TARGET_RATE_TYPE := NULL;
1218: l_lease_qte_rec.TARGET_RATE := NULL;
1219: l_lease_qte_rec.TARGET_AMOUNT := NULL;

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

1226: l_lease_qte_rec.rate_card_id := NULL;
1227: ELSE
1228: IF l_lease_qte_rec.pricing_method NOT IN ( 'TR','RC','SY') THEN
1229: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_template_id IS NULL THEN
1230: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1231: p_msg_name => 'OKL_SRT_MANDATORY');
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: ELSIF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.target_amount IS NULL
1234: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')

Line 1232: RAISE OKL_API.G_EXCEPTION_ERROR;

1228: IF l_lease_qte_rec.pricing_method NOT IN ( 'TR','RC','SY') THEN
1229: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_template_id IS NULL THEN
1230: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1231: p_msg_name => 'OKL_SRT_MANDATORY');
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: ELSIF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.target_amount IS NULL
1234: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')
1235: THEN
1236: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: ELSIF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.target_amount IS NULL
1234: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')
1235: THEN
1236: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1237: p_msg_name => 'OKL_PA_MANDATORY');
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: END IF;

Line 1238: RAISE OKL_API.G_EXCEPTION_ERROR;

1234: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')
1235: THEN
1236: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1237: p_msg_name => 'OKL_PA_MANDATORY');
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240: END IF;
1241: END IF;
1242: IF l_all_lines_overriden = 'N' OR l_entered = 'N' THEN

Line 1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1258: ,'end debug call update_lease_qte');
1259: END IF;
1260:
1261: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF x_return_status = G_RET_STS_ERROR THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266: IF l_all_lines_overriden = 'Y' THEN

Line 1264: RAISE OKL_API.G_EXCEPTION_ERROR;

1260:
1261: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF x_return_status = G_RET_STS_ERROR THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266: IF l_all_lines_overriden = 'Y' THEN
1267: IF(l_debug_enabled='Y') THEN
1268: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'

Line 1286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1282: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1283: END IF;
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: ELSE
1292: l_payment_header_rec := p_payment_header_rec;

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

1298:
1299: IF ((l_payment_level_tbl.COUNT > 0 AND l_payment_header_rec.stream_type_id IS NULL) OR
1300: (l_payment_header_rec.stream_type_id IS NOT NULL AND l_payment_level_tbl.COUNT = 0 ))
1301: THEN
1302: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1303: p_msg_name => 'OKL_EPT_PAYMENT_NA');
1304: RAISE OKL_API.G_EXCEPTION_ERROR;
1305: ELSE
1306: -- Check if the Cash flows already exists

Line 1304: RAISE OKL_API.G_EXCEPTION_ERROR;

1300: (l_payment_header_rec.stream_type_id IS NOT NULL AND l_payment_level_tbl.COUNT = 0 ))
1301: THEN
1302: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1303: p_msg_name => 'OKL_EPT_PAYMENT_NA');
1304: RAISE OKL_API.G_EXCEPTION_ERROR;
1305: ELSE
1306: -- Check if the Cash flows already exists
1307: OPEN c_check_cash_flow(p_quote_id => l_payment_header_rec.quote_id);
1308: FETCH c_check_cash_flow into lv_cash_flow_exists;

Line 1332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1328: ,'end debug call update_cashflow');
1329: END IF;
1330:
1331: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF x_return_status = G_RET_STS_ERROR THEN
1334: RAISE OKL_API.G_EXCEPTION_ERROR;
1335: END IF;
1336: ELSE

Line 1334: RAISE OKL_API.G_EXCEPTION_ERROR;

1330:
1331: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF x_return_status = G_RET_STS_ERROR THEN
1334: RAISE OKL_API.G_EXCEPTION_ERROR;
1335: END IF;
1336: ELSE
1337: IF(l_debug_enabled='Y') THEN
1338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'

Line 1356: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1352: ,'end debug call create_cashflow');
1353: END IF;
1354:
1355: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1356: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1357: ELSIF x_return_status = G_RET_STS_ERROR THEN
1358: RAISE OKL_API.G_EXCEPTION_ERROR;
1359: END IF;
1360: END IF;

Line 1358: RAISE OKL_API.G_EXCEPTION_ERROR;

1354:
1355: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1356: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1357: ELSIF x_return_status = G_RET_STS_ERROR THEN
1358: RAISE OKL_API.G_EXCEPTION_ERROR;
1359: END IF;
1360: END IF;
1361: END IF;
1362: END IF;

Line 1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1373: ,x_msg_count => x_msg_count
1374: ,x_msg_data => x_msg_data);
1375:
1376: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF x_return_status = G_RET_STS_ERROR THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:

Line 1379: RAISE OKL_API.G_EXCEPTION_ERROR;

1375:
1376: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF x_return_status = G_RET_STS_ERROR THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:
1382: END LOOP;
1383: /* FOR l_quote_fees_rec IN quote_fees_csr(l_lease_qte_rec.id) LOOP

Line 1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1391: ,x_msg_count => x_msg_count
1392: ,x_msg_data => x_msg_data);
1393:
1394: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF x_return_status = G_RET_STS_ERROR THEN
1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;
1399:

Line 1397: RAISE OKL_API.G_EXCEPTION_ERROR;

1393:
1394: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF x_return_status = G_RET_STS_ERROR THEN
1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;
1399:
1400: END LOOP; */
1401: END IF;

Line 1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1410: ,p_parent_object_id => l_lease_qte_rec.parent_object_id
1411: );
1412:
1413: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: ELSIF x_return_status = G_RET_STS_ERROR THEN
1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;*/
1418:

Line 1416: RAISE OKL_API.G_EXCEPTION_ERROR;

1412:
1413: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: ELSIF x_return_status = G_RET_STS_ERROR THEN
1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;*/
1418:
1419:
1420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 1420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;*/
1418:
1419:
1420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1421: ,x_msg_data => x_msg_data);
1422: EXCEPTION
1423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1423: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1419:
1420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1421: ,x_msg_data => x_msg_data);
1422: EXCEPTION
1423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1425: p_api_name => l_api_name,
1426: p_pkg_name => G_PKG_NAME,
1427: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1424: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1420: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1421: ,x_msg_data => x_msg_data);
1422: EXCEPTION
1423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1425: p_api_name => l_api_name,
1426: p_pkg_name => G_PKG_NAME,
1427: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1428: x_msg_count => x_msg_count,

Line 1427: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1425: p_api_name => l_api_name,
1426: p_pkg_name => G_PKG_NAME,
1427: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data,
1430: p_api_type => g_api_type);
1431: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1431: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1427: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data,
1430: p_api_type => g_api_type);
1431: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1433: p_api_name => l_api_name,
1434: p_pkg_name => G_PKG_NAME,
1435: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data,
1430: p_api_type => g_api_type);
1431: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1433: p_api_name => l_api_name,
1434: p_pkg_name => G_PKG_NAME,
1435: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1436: x_msg_count => x_msg_count,

Line 1435: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1431: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1433: p_api_name => l_api_name,
1434: p_pkg_name => G_PKG_NAME,
1435: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1436: x_msg_count => x_msg_count,
1437: x_msg_data => x_msg_data,
1438: p_api_type => g_api_type);
1439: WHEN OTHERS THEN

Line 1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1436: x_msg_count => x_msg_count,
1437: x_msg_data => x_msg_data,
1438: p_api_type => g_api_type);
1439: WHEN OTHERS THEN
1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1441: p_api_name => l_api_name,
1442: p_pkg_name => G_PKG_NAME,
1443: p_exc_name => 'OTHERS',
1444: x_msg_count => x_msg_count,

Line 1476: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1472:
1473: -- Variables Declarations
1474: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1475: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_UPDATE_PAYMENT';
1476: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1477: l_debug_enabled VARCHAR2(10);
1478:
1479: -- Record/Table Type Declarations
1480: l_payment_header_rec cashflow_hdr_rec_type;

Line 1505: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1501: AND parent_object_code = 'LEASEQUOTE'
1502: AND fee_type <> 'CAPITALIZED';
1503:
1504: BEGIN
1505: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1506: -- check for logging on PROCEDURE level
1507: l_debug_enabled := okl_debug_pub.check_log_enabled;
1508: -- call START_ACTIVITY to create savepoint, check compatibility
1509: -- and initialize message list

Line 1510: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

1506: -- check for logging on PROCEDURE level
1507: l_debug_enabled := okl_debug_pub.check_log_enabled;
1508: -- call START_ACTIVITY to create savepoint, check compatibility
1509: -- and initialize message list
1510: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
1511: ,p_pkg_name => G_PKG_NAME
1512: ,p_init_msg_list => p_init_msg_list
1513: ,l_api_version => l_api_version
1514: ,p_api_version => p_api_version

Line 1518: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1514: ,p_api_version => p_api_version
1515: ,p_api_type => g_api_type
1516: ,x_return_status => x_return_status);
1517: -- check if activity started successfully
1518: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_ERROR;
1522: END IF;

Line 1519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1515: ,p_api_type => g_api_type
1516: ,x_return_status => x_return_status);
1517: -- check if activity started successfully
1518: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_ERROR;
1522: END IF;
1523:

Line 1520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1516: ,x_return_status => x_return_status);
1517: -- check if activity started successfully
1518: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_ERROR;
1522: END IF;
1523:
1524: --Populate quote record

Line 1521: RAISE OKL_API.G_EXCEPTION_ERROR;

1517: -- check if activity started successfully
1518: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_ERROR;
1522: END IF;
1523:
1524: --Populate quote record
1525: l_lease_qte_rec := populate_quote_rec(p_lease_qte_rec.id,x_return_status);

Line 1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1524: --Populate quote record
1525: l_lease_qte_rec := populate_quote_rec(p_lease_qte_rec.id,x_return_status);
1526:
1527: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF x_return_status = G_RET_STS_ERROR THEN
1530: RAISE OKL_API.G_EXCEPTION_ERROR;
1531: END IF;
1532:

Line 1530: RAISE OKL_API.G_EXCEPTION_ERROR;

1526:
1527: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF x_return_status = G_RET_STS_ERROR THEN
1530: RAISE OKL_API.G_EXCEPTION_ERROR;
1531: END IF;
1532:
1533: l_lease_qte_rec.TARGET_RATE_TYPE := p_lease_qte_rec.TARGET_RATE_TYPE;
1534: l_lease_qte_rec.TARGET_RATE := p_lease_qte_rec.TARGET_RATE;

Line 1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1543: l_lease_qte_rec.rate_card_id := p_lease_qte_rec.rate_card_id;
1544: l_all_lines_overriden := okl_sales_quote_qa_pvt.are_all_lines_overriden(l_lease_qte_rec.id,l_lease_qte_rec.pricing_method,l_lease_qte_rec.LINE_LEVEL_PRICING ,x_return_status);
1545:
1546: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF x_return_status = G_RET_STS_ERROR THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: IF l_all_lines_overriden = 'Y' THEN

Line 1549: RAISE OKL_API.G_EXCEPTION_ERROR;

1545:
1546: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF x_return_status = G_RET_STS_ERROR THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: IF l_all_lines_overriden = 'Y' THEN
1552: l_entered := are_qte_pricing_opts_entered(l_lease_qte_rec,0,x_return_status);
1553:

Line 1555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1551: IF l_all_lines_overriden = 'Y' THEN
1552: l_entered := are_qte_pricing_opts_entered(l_lease_qte_rec,0,x_return_status);
1553:
1554: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1556: ELSIF x_return_status = G_RET_STS_ERROR THEN
1557: RAISE OKL_API.G_EXCEPTION_ERROR;
1558: END IF;
1559:

Line 1557: RAISE OKL_API.G_EXCEPTION_ERROR;

1553:
1554: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1556: ELSIF x_return_status = G_RET_STS_ERROR THEN
1557: RAISE OKL_API.G_EXCEPTION_ERROR;
1558: END IF;
1559:
1560: IF l_entered = 'Y' THEN
1561:

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

1558: END IF;
1559:
1560: IF l_entered = 'Y' THEN
1561:
1562: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1563: p_msg_name => 'OKL_QTE_PMT_ENTERED');
1564: RAISE OKL_API.G_EXCEPTION_ERROR;
1565: END IF;
1566: l_lease_qte_rec.TARGET_RATE_TYPE := NULL;

Line 1564: RAISE OKL_API.G_EXCEPTION_ERROR;

1560: IF l_entered = 'Y' THEN
1561:
1562: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1563: p_msg_name => 'OKL_QTE_PMT_ENTERED');
1564: RAISE OKL_API.G_EXCEPTION_ERROR;
1565: END IF;
1566: l_lease_qte_rec.TARGET_RATE_TYPE := NULL;
1567: l_lease_qte_rec.TARGET_RATE := NULL;
1568: l_lease_qte_rec.TARGET_AMOUNT := NULL;

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

1576: ELSE
1577:
1578: IF l_lease_qte_rec.pricing_method = 'RC' THEN
1579: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_card_id IS NULL THEN
1580: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1581: p_msg_name => 'OKL_RC_MANDATORY');
1582: RAISE OKL_API.G_EXCEPTION_ERROR;
1583: ELSIF l_lease_qte_rec.structured_pricing = 'Y' AND l_lease_qte_rec.lease_rate_factor IS NULL THEN
1584: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1582: RAISE OKL_API.G_EXCEPTION_ERROR;

1578: IF l_lease_qte_rec.pricing_method = 'RC' THEN
1579: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_card_id IS NULL THEN
1580: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1581: p_msg_name => 'OKL_RC_MANDATORY');
1582: RAISE OKL_API.G_EXCEPTION_ERROR;
1583: ELSIF l_lease_qte_rec.structured_pricing = 'Y' AND l_lease_qte_rec.lease_rate_factor IS NULL THEN
1584: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1585: p_msg_name => 'OKL_RF_MANDATORY');
1586: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1580: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1581: p_msg_name => 'OKL_RC_MANDATORY');
1582: RAISE OKL_API.G_EXCEPTION_ERROR;
1583: ELSIF l_lease_qte_rec.structured_pricing = 'Y' AND l_lease_qte_rec.lease_rate_factor IS NULL THEN
1584: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1585: p_msg_name => 'OKL_RF_MANDATORY');
1586: RAISE OKL_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: ELSIF l_lease_qte_rec.pricing_method NOT IN ('TR','SY') THEN

Line 1586: RAISE OKL_API.G_EXCEPTION_ERROR;

1582: RAISE OKL_API.G_EXCEPTION_ERROR;
1583: ELSIF l_lease_qte_rec.structured_pricing = 'Y' AND l_lease_qte_rec.lease_rate_factor IS NULL THEN
1584: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1585: p_msg_name => 'OKL_RF_MANDATORY');
1586: RAISE OKL_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: ELSIF l_lease_qte_rec.pricing_method NOT IN ('TR','SY') THEN
1589: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_template_id IS NULL THEN
1590: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1586: RAISE OKL_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: ELSIF l_lease_qte_rec.pricing_method NOT IN ('TR','SY') THEN
1589: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_template_id IS NULL THEN
1590: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1591: p_msg_name => 'OKL_SRT_MANDATORY');
1592: RAISE OKL_API.G_EXCEPTION_ERROR;
1593: ELSIF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.target_amount IS NULL
1594: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')

Line 1592: RAISE OKL_API.G_EXCEPTION_ERROR;

1588: ELSIF l_lease_qte_rec.pricing_method NOT IN ('TR','SY') THEN
1589: IF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.rate_template_id IS NULL THEN
1590: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1591: p_msg_name => 'OKL_SRT_MANDATORY');
1592: RAISE OKL_API.G_EXCEPTION_ERROR;
1593: ELSIF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.target_amount IS NULL
1594: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')
1595: THEN
1596: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1592: RAISE OKL_API.G_EXCEPTION_ERROR;
1593: ELSIF l_lease_qte_rec.structured_pricing = 'N' AND l_lease_qte_rec.target_amount IS NULL
1594: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')
1595: THEN
1596: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1597: p_msg_name => 'OKL_PA_MANDATORY');
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600: END IF;

Line 1598: RAISE OKL_API.G_EXCEPTION_ERROR;

1594: AND l_lease_qte_rec.pricing_method NOT IN ('SP','SM')
1595: THEN
1596: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1597: p_msg_name => 'OKL_PA_MANDATORY');
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600: END IF;
1601: END IF;
1602: IF l_all_lines_overriden = 'N' OR l_entered = 'N' THEN

Line 1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1618: ,'End debug call update_lease_qte');
1619: END IF;
1620:
1621: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = G_RET_STS_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626:

Line 1624: RAISE OKL_API.G_EXCEPTION_ERROR;

1620:
1621: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = G_RET_STS_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626:
1627: IF(l_debug_enabled='Y') THEN
1628: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'

Line 1646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1642: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1643: END IF;
1644:
1645: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1647: ELSIF x_return_status = G_RET_STS_ERROR THEN
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: END IF;
1650: END IF;

Line 1648: RAISE OKL_API.G_EXCEPTION_ERROR;

1644:
1645: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1647: ELSIF x_return_status = G_RET_STS_ERROR THEN
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: END IF;
1650: END IF;
1651: IF p_lease_qte_rec.line_level_pricing = 'N' THEN
1652: FOR l_quote_asset_rec IN quote_assets_csr(l_lease_qte_rec.id) LOOP

Line 1664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1660: ,x_msg_count => x_msg_count
1661: ,x_msg_data => x_msg_data);
1662:
1663: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF x_return_status = G_RET_STS_ERROR THEN
1666: RAISE OKL_API.G_EXCEPTION_ERROR;
1667: END IF;
1668:

Line 1666: RAISE OKL_API.G_EXCEPTION_ERROR;

1662:
1663: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF x_return_status = G_RET_STS_ERROR THEN
1666: RAISE OKL_API.G_EXCEPTION_ERROR;
1667: END IF;
1668:
1669: END LOOP;
1670: /* FOR l_quote_fees_rec IN quote_fees_csr(l_lease_qte_rec.id) LOOP

Line 1682: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1684: RAISE OKL_API.G_EXCEPTION_ERROR;

1680:
1681: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1682: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1683: ELSIF x_return_status = G_RET_STS_ERROR THEN
1684: RAISE OKL_API.G_EXCEPTION_ERROR;
1685: END IF;
1686:
1687: END LOOP; */
1688: END IF;

Line 1701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1697: ,p_parent_object_id => l_lease_qte_rec.parent_object_id
1698: );
1699:
1700: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1702: ELSIF x_return_status = G_RET_STS_ERROR THEN
1703: RAISE OKL_API.G_EXCEPTION_ERROR;
1704: END IF;*/
1705:

Line 1703: RAISE OKL_API.G_EXCEPTION_ERROR;

1699:
1700: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1702: ELSIF x_return_status = G_RET_STS_ERROR THEN
1703: RAISE OKL_API.G_EXCEPTION_ERROR;
1704: END IF;*/
1705:
1706: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1707: ,x_msg_data => x_msg_data);

Line 1706: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

1702: ELSIF x_return_status = G_RET_STS_ERROR THEN
1703: RAISE OKL_API.G_EXCEPTION_ERROR;
1704: END IF;*/
1705:
1706: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1707: ,x_msg_data => x_msg_data);
1708: EXCEPTION
1709: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1709: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1705:
1706: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1707: ,x_msg_data => x_msg_data);
1708: EXCEPTION
1709: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1711: p_api_name => l_api_name,
1712: p_pkg_name => G_PKG_NAME,
1713: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1706: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
1707: ,x_msg_data => x_msg_data);
1708: EXCEPTION
1709: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1711: p_api_name => l_api_name,
1712: p_pkg_name => G_PKG_NAME,
1713: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1714: x_msg_count => x_msg_count,

Line 1713: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1709: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1711: p_api_name => l_api_name,
1712: p_pkg_name => G_PKG_NAME,
1713: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1714: x_msg_count => x_msg_count,
1715: x_msg_data => x_msg_data,
1716: p_api_type => g_api_type);
1717: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1717: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1713: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1714: x_msg_count => x_msg_count,
1715: x_msg_data => x_msg_data,
1716: p_api_type => g_api_type);
1717: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1718: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1719: p_api_name => l_api_name,
1720: p_pkg_name => G_PKG_NAME,
1721: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1718: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1714: x_msg_count => x_msg_count,
1715: x_msg_data => x_msg_data,
1716: p_api_type => g_api_type);
1717: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1718: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1719: p_api_name => l_api_name,
1720: p_pkg_name => G_PKG_NAME,
1721: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1722: x_msg_count => x_msg_count,

Line 1721: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1717: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1718: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1719: p_api_name => l_api_name,
1720: p_pkg_name => G_PKG_NAME,
1721: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1722: x_msg_count => x_msg_count,
1723: x_msg_data => x_msg_data,
1724: p_api_type => g_api_type);
1725: WHEN OTHERS THEN

Line 1726: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1722: x_msg_count => x_msg_count,
1723: x_msg_data => x_msg_data,
1724: p_api_type => g_api_type);
1725: WHEN OTHERS THEN
1726: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1727: p_api_name => l_api_name,
1728: p_pkg_name => G_PKG_NAME,
1729: p_exc_name => 'OTHERS',
1730: x_msg_count => x_msg_count,

Line 1766: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1762:
1763: -- Variables Declarations
1764: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1765: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE3';
1766: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1767: l_debug_enabled VARCHAR2(10);
1768:
1769:
1770: -- Record/Table Type Declarations

Line 1804: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1800: AND SOURCE_TABLE = 'OKL_FEES_B'
1801: AND SOURCE_ID = p_fee_id;
1802:
1803: BEGIN
1804: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1805: -- check for logging on PROCEDURE level
1806: l_debug_enabled := okl_debug_pub.check_log_enabled;
1807: -- call START_ACTIVITY to create savepoint, check compatibility
1808: -- and initialize message list

Line 1809: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

1805: -- check for logging on PROCEDURE level
1806: l_debug_enabled := okl_debug_pub.check_log_enabled;
1807: -- call START_ACTIVITY to create savepoint, check compatibility
1808: -- and initialize message list
1809: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
1810: ,p_pkg_name => G_PKG_NAME
1811: ,p_init_msg_list => p_init_msg_list
1812: ,l_api_version => l_api_version
1813: ,p_api_version => p_api_version

Line 1817: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1813: ,p_api_version => p_api_version
1814: ,p_api_type => g_api_type
1815: ,x_return_status => x_return_status);
1816: -- check if activity started successfully
1817: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_ERROR;
1821: END IF;

Line 1818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1814: ,p_api_type => g_api_type
1815: ,x_return_status => x_return_status);
1816: -- check if activity started successfully
1817: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_ERROR;
1821: END IF;
1822: IF p_payment_header_rec.parent_object_code = 'QUOTED_FEE' THEN

Line 1819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1815: ,x_return_status => x_return_status);
1816: -- check if activity started successfully
1817: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_ERROR;
1821: END IF;
1822: IF p_payment_header_rec.parent_object_code = 'QUOTED_FEE' THEN
1823: --Populate fee record

Line 1820: RAISE OKL_API.G_EXCEPTION_ERROR;

1816: -- check if activity started successfully
1817: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1819: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_ERROR;
1821: END IF;
1822: IF p_payment_header_rec.parent_object_code = 'QUOTED_FEE' THEN
1823: --Populate fee record
1824: l_fee_rec := populate_fee_rec(p_fee_rec.id,x_return_status);

Line 1827: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1823: --Populate fee record
1824: l_fee_rec := populate_fee_rec(p_fee_rec.id,x_return_status);
1825:
1826: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1827: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1828: ELSIF x_return_status = G_RET_STS_ERROR THEN
1829: RAISE OKL_API.G_EXCEPTION_ERROR;
1830: END IF;
1831:

Line 1829: RAISE OKL_API.G_EXCEPTION_ERROR;

1825:
1826: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1827: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1828: ELSIF x_return_status = G_RET_STS_ERROR THEN
1829: RAISE OKL_API.G_EXCEPTION_ERROR;
1830: END IF;
1831:
1832: l_fee_rec.RATE_CARD_ID := p_fee_rec.RATE_CARD_ID;
1833: l_fee_rec.RATE_TEMPLATE_ID := p_fee_rec.RATE_TEMPLATE_ID;

Line 1867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1863: ,'end debug call update_row');
1864: END IF;
1865:
1866: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1868: ELSIF x_return_status = G_RET_STS_ERROR THEN
1869: RAISE OKL_API.G_EXCEPTION_ERROR;
1870: END IF;
1871:

Line 1869: RAISE OKL_API.G_EXCEPTION_ERROR;

1865:
1866: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1868: ELSIF x_return_status = G_RET_STS_ERROR THEN
1869: RAISE OKL_API.G_EXCEPTION_ERROR;
1870: END IF;
1871:
1872: -- Check if the Cash flows already exists
1873: OPEN c_check_fee_cash_flow(p_fee_id => lx_fee_rec.id);

Line 1915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1911: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
1912: ,'end debug call update_row');
1913: END IF;
1914: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1916: ELSIF x_return_status = G_RET_STS_ERROR THEN
1917: RAISE OKL_API.G_EXCEPTION_ERROR;
1918: END IF;
1919:

Line 1917: RAISE OKL_API.G_EXCEPTION_ERROR;

1913: END IF;
1914: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1916: ELSIF x_return_status = G_RET_STS_ERROR THEN
1917: RAISE OKL_API.G_EXCEPTION_ERROR;
1918: END IF;
1919:
1920: -- Check if the Cash flows already exists
1921: OPEN c_check_asset_cash_flow(p_asset_id => lx_asset_rec.id);

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

1940: END IF;
1941: END LOOP;
1942: IF l_missing = 'N' THEN
1943: IF l_sp = 'N' THEN
1944: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1945: p_msg_name => 'OKL_NO_MP_STR');
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: END IF;

Line 1946: RAISE OKL_API.G_EXCEPTION_ERROR;

1942: IF l_missing = 'N' THEN
1943: IF l_sp = 'N' THEN
1944: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1945: p_msg_name => 'OKL_NO_MP_STR');
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: END IF;
1949: IF l_missing = 'Y' THEN
1950: IF l_sp = 'N' AND l_srt IS NULL THEN

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

1947: END IF;
1948: END IF;
1949: IF l_missing = 'Y' THEN
1950: IF l_sp = 'N' AND l_srt IS NULL THEN
1951: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1952: p_msg_name => 'OKL_SRT_MANDATORY');
1953: RAISE OKL_API.G_EXCEPTION_ERROR;
1954: END IF;
1955: END IF;

Line 1953: RAISE OKL_API.G_EXCEPTION_ERROR;

1949: IF l_missing = 'Y' THEN
1950: IF l_sp = 'N' AND l_srt IS NULL THEN
1951: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1952: p_msg_name => 'OKL_SRT_MANDATORY');
1953: RAISE OKL_API.G_EXCEPTION_ERROR;
1954: END IF;
1955: END IF;
1956: END IF;
1957: IF ((l_payment_level_tbl.COUNT > 0 AND l_payment_header_rec.stream_type_id IS NULL) OR

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

1955: END IF;
1956: END IF;
1957: IF ((l_payment_level_tbl.COUNT > 0 AND l_payment_header_rec.stream_type_id IS NULL) OR
1958: (l_payment_header_rec.stream_type_id IS NOT NULL AND l_payment_level_tbl.COUNT = 0 )) THEN
1959: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1960: p_msg_name => 'OKL_EPT_PAYMENT_NA');
1961: RAISE OKL_API.G_EXCEPTION_ERROR;
1962: ELSE
1963: IF (lv_cash_flow_exists = 'YES') THEN

Line 1961: RAISE OKL_API.G_EXCEPTION_ERROR;

1957: IF ((l_payment_level_tbl.COUNT > 0 AND l_payment_header_rec.stream_type_id IS NULL) OR
1958: (l_payment_header_rec.stream_type_id IS NOT NULL AND l_payment_level_tbl.COUNT = 0 )) THEN
1959: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1960: p_msg_name => 'OKL_EPT_PAYMENT_NA');
1961: RAISE OKL_API.G_EXCEPTION_ERROR;
1962: ELSE
1963: IF (lv_cash_flow_exists = 'YES') THEN
1964:
1965: IF(l_debug_enabled='Y') THEN

Line 1984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1980: ,'end debug call update_cashflow');
1981: END IF;
1982:
1983: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: ELSIF x_return_status = G_RET_STS_ERROR THEN
1986: RAISE OKL_API.G_EXCEPTION_ERROR;
1987: END IF;
1988: ELSE

Line 1986: RAISE OKL_API.G_EXCEPTION_ERROR;

1982:
1983: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: ELSIF x_return_status = G_RET_STS_ERROR THEN
1986: RAISE OKL_API.G_EXCEPTION_ERROR;
1987: END IF;
1988: ELSE
1989:
1990: IF(l_debug_enabled='Y') THEN

Line 2009: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2005: ,'end debug call create_cashflow');
2006: END IF;
2007:
2008: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2009: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2010: ELSIF x_return_status = G_RET_STS_ERROR THEN
2011: RAISE OKL_API.G_EXCEPTION_ERROR;
2012: END IF;
2013: END IF;

Line 2011: RAISE OKL_API.G_EXCEPTION_ERROR;

2007:
2008: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2009: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2010: ELSIF x_return_status = G_RET_STS_ERROR THEN
2011: RAISE OKL_API.G_EXCEPTION_ERROR;
2012: END IF;
2013: END IF;
2014: END IF;
2015:

Line 2017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2013: END IF;
2014: END IF;
2015:
2016: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2018: ELSIF x_return_status = G_RET_STS_ERROR THEN
2019: RAISE OKL_API.G_EXCEPTION_ERROR;
2020: END IF;
2021:

Line 2019: RAISE OKL_API.G_EXCEPTION_ERROR;

2015:
2016: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2018: ELSIF x_return_status = G_RET_STS_ERROR THEN
2019: RAISE OKL_API.G_EXCEPTION_ERROR;
2020: END IF;
2021:
2022: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2023: FROM okl_lease_quotes_b where ID = nvl(l_fee_rec.parent_object_id,l_Asset_rec.parent_object_id);

Line 2036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2032: ,p_parent_object_id => l_p_id
2033: );
2034:
2035: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2037: ELSIF x_return_status = G_RET_STS_ERROR THEN
2038: RAISE OKL_API.G_EXCEPTION_ERROR;
2039: END IF;*/
2040:

Line 2038: RAISE OKL_API.G_EXCEPTION_ERROR;

2034:
2035: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2037: ELSIF x_return_status = G_RET_STS_ERROR THEN
2038: RAISE OKL_API.G_EXCEPTION_ERROR;
2039: END IF;*/
2040:
2041: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2042: ,x_msg_data => x_msg_data);

Line 2041: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

2037: ELSIF x_return_status = G_RET_STS_ERROR THEN
2038: RAISE OKL_API.G_EXCEPTION_ERROR;
2039: END IF;*/
2040:
2041: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2042: ,x_msg_data => x_msg_data);
2043: EXCEPTION
2044: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2044: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2040:
2041: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2042: ,x_msg_data => x_msg_data);
2043: EXCEPTION
2044: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2046: p_api_name => l_api_name,
2047: p_pkg_name => G_PKG_NAME,
2048: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2041: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2042: ,x_msg_data => x_msg_data);
2043: EXCEPTION
2044: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2046: p_api_name => l_api_name,
2047: p_pkg_name => G_PKG_NAME,
2048: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2049: x_msg_count => x_msg_count,

Line 2048: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2044: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2046: p_api_name => l_api_name,
2047: p_pkg_name => G_PKG_NAME,
2048: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2049: x_msg_count => x_msg_count,
2050: x_msg_data => x_msg_data,
2051: p_api_type => g_api_type);
2052: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2052: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2048: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2049: x_msg_count => x_msg_count,
2050: x_msg_data => x_msg_data,
2051: p_api_type => g_api_type);
2052: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2053: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2054: p_api_name => l_api_name,
2055: p_pkg_name => G_PKG_NAME,
2056: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2053: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2049: x_msg_count => x_msg_count,
2050: x_msg_data => x_msg_data,
2051: p_api_type => g_api_type);
2052: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2053: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2054: p_api_name => l_api_name,
2055: p_pkg_name => G_PKG_NAME,
2056: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2057: x_msg_count => x_msg_count,

Line 2056: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2052: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2053: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2054: p_api_name => l_api_name,
2055: p_pkg_name => G_PKG_NAME,
2056: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2057: x_msg_count => x_msg_count,
2058: x_msg_data => x_msg_data,
2059: p_api_type => g_api_type);
2060: WHEN OTHERS THEN

Line 2061: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2057: x_msg_count => x_msg_count,
2058: x_msg_data => x_msg_data,
2059: p_api_type => g_api_type);
2060: WHEN OTHERS THEN
2061: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2062: p_api_name => l_api_name,
2063: p_pkg_name => G_PKG_NAME,
2064: p_exc_name => 'OTHERS',
2065: x_msg_count => x_msg_count,

Line 2097: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2093:
2094: -- Variables Declarations
2095: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2096: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREAT2';
2097: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2098: l_debug_enabled VARCHAR2(10);
2099:
2100:
2101: -- Record/Table Type Declarations

Line 2116: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2112: l_p_code VARCHAR2(30);
2113:
2114:
2115: BEGIN
2116: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2117: -- check for logging on PROCEDURE level
2118: l_debug_enabled := okl_debug_pub.check_log_enabled;
2119: -- call START_ACTIVITY to create savepoint, check compatibility
2120: -- and initialize message list

Line 2121: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

2117: -- check for logging on PROCEDURE level
2118: l_debug_enabled := okl_debug_pub.check_log_enabled;
2119: -- call START_ACTIVITY to create savepoint, check compatibility
2120: -- and initialize message list
2121: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
2122: ,p_pkg_name => G_PKG_NAME
2123: ,p_init_msg_list => p_init_msg_list
2124: ,l_api_version => l_api_version
2125: ,p_api_version => p_api_version

Line 2129: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2125: ,p_api_version => p_api_version
2126: ,p_api_type => g_api_type
2127: ,x_return_status => x_return_status);
2128: -- check if activity started successfully
2129: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2131: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_ERROR;
2133: END IF;

Line 2130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2126: ,p_api_type => g_api_type
2127: ,x_return_status => x_return_status);
2128: -- check if activity started successfully
2129: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2131: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_ERROR;
2133: END IF;
2134: --populate fee record

Line 2131: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2127: ,x_return_status => x_return_status);
2128: -- check if activity started successfully
2129: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2131: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_ERROR;
2133: END IF;
2134: --populate fee record
2135: l_fee_rec := populate_fee_rec(p_fee_rec.id,x_return_status);

Line 2132: RAISE OKL_API.G_EXCEPTION_ERROR;

2128: -- check if activity started successfully
2129: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2131: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_ERROR;
2133: END IF;
2134: --populate fee record
2135: l_fee_rec := populate_fee_rec(p_fee_rec.id,x_return_status);
2136:

Line 2138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2134: --populate fee record
2135: l_fee_rec := populate_fee_rec(p_fee_rec.id,x_return_status);
2136:
2137: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2139: ELSIF x_return_status = G_RET_STS_ERROR THEN
2140: RAISE OKL_API.G_EXCEPTION_ERROR;
2141: END IF;
2142:

Line 2140: RAISE OKL_API.G_EXCEPTION_ERROR;

2136:
2137: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2139: ELSIF x_return_status = G_RET_STS_ERROR THEN
2140: RAISE OKL_API.G_EXCEPTION_ERROR;
2141: END IF;
2142:
2143: l_fee_rec.RATE_CARD_ID := p_fee_rec.RATE_CARD_ID;
2144: l_fee_rec.RATE_TEMPLATE_ID := p_fee_rec.RATE_TEMPLATE_ID;

Line 2171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2167: ,'end debug call update_row');
2168: END IF;
2169:
2170: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2172: ELSIF x_return_status = G_RET_STS_ERROR THEN
2173: RAISE OKL_API.G_EXCEPTION_ERROR;
2174: END IF;
2175:

Line 2173: RAISE OKL_API.G_EXCEPTION_ERROR;

2169:
2170: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2172: ELSIF x_return_status = G_RET_STS_ERROR THEN
2173: RAISE OKL_API.G_EXCEPTION_ERROR;
2174: END IF;
2175:
2176: IF(l_debug_enabled='Y') THEN
2177: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'

Line 2195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2191: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2192: END IF;
2193:
2194: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2196: ELSIF x_return_status = G_RET_STS_ERROR THEN
2197: RAISE OKL_API.G_EXCEPTION_ERROR;
2198: END IF;
2199:

Line 2197: RAISE OKL_API.G_EXCEPTION_ERROR;

2193:
2194: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2196: ELSIF x_return_status = G_RET_STS_ERROR THEN
2197: RAISE OKL_API.G_EXCEPTION_ERROR;
2198: END IF;
2199:
2200: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2201: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;

Line 2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2210: ,p_parent_object_id => l_p_id
2211: );
2212:
2213: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF x_return_status = G_RET_STS_ERROR THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;*/
2218:

Line 2216: RAISE OKL_API.G_EXCEPTION_ERROR;

2212:
2213: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF x_return_status = G_RET_STS_ERROR THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;*/
2218:
2219:
2220:

Line 2221: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

2217: END IF;*/
2218:
2219:
2220:
2221: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2222: ,x_msg_data => x_msg_data);
2223: EXCEPTION
2224: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2225: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2224: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2220:
2221: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2222: ,x_msg_data => x_msg_data);
2223: EXCEPTION
2224: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2225: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2226: p_api_name => l_api_name,
2227: p_pkg_name => G_PKG_NAME,
2228: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2225: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2221: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2222: ,x_msg_data => x_msg_data);
2223: EXCEPTION
2224: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2225: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2226: p_api_name => l_api_name,
2227: p_pkg_name => G_PKG_NAME,
2228: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2229: x_msg_count => x_msg_count,

Line 2228: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2224: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2225: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2226: p_api_name => l_api_name,
2227: p_pkg_name => G_PKG_NAME,
2228: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2229: x_msg_count => x_msg_count,
2230: x_msg_data => x_msg_data,
2231: p_api_type => g_api_type);
2232: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2232: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2228: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2229: x_msg_count => x_msg_count,
2230: x_msg_data => x_msg_data,
2231: p_api_type => g_api_type);
2232: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2233: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2234: p_api_name => l_api_name,
2235: p_pkg_name => G_PKG_NAME,
2236: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2233: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2229: x_msg_count => x_msg_count,
2230: x_msg_data => x_msg_data,
2231: p_api_type => g_api_type);
2232: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2233: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2234: p_api_name => l_api_name,
2235: p_pkg_name => G_PKG_NAME,
2236: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2237: x_msg_count => x_msg_count,

Line 2236: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2232: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2233: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2234: p_api_name => l_api_name,
2235: p_pkg_name => G_PKG_NAME,
2236: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2237: x_msg_count => x_msg_count,
2238: x_msg_data => x_msg_data,
2239: p_api_type => g_api_type);
2240: WHEN OTHERS THEN

Line 2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2237: x_msg_count => x_msg_count,
2238: x_msg_data => x_msg_data,
2239: p_api_type => g_api_type);
2240: WHEN OTHERS THEN
2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2242: p_api_name => l_api_name,
2243: p_pkg_name => G_PKG_NAME,
2244: p_exc_name => 'OTHERS',
2245: x_msg_count => x_msg_count,

Line 2277: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2273:
2274: -- Variables Declarations
2275: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2276: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE1';
2277: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2278: l_debug_enabled VARCHAR2(10);
2279:
2280:
2281: -- Record/Table Type Declarations

Line 2295: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2291: l_p_code VARCHAR2(30);
2292:
2293:
2294: BEGIN
2295: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2296: -- check for logging on PROCEDURE level
2297: l_debug_enabled := okl_debug_pub.check_log_enabled;
2298: -- call START_ACTIVITY to create savepoint, check compatibility
2299: -- and initialize message list

Line 2300: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

2296: -- check for logging on PROCEDURE level
2297: l_debug_enabled := okl_debug_pub.check_log_enabled;
2298: -- call START_ACTIVITY to create savepoint, check compatibility
2299: -- and initialize message list
2300: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
2301: ,p_pkg_name => G_PKG_NAME
2302: ,p_init_msg_list => p_init_msg_list
2303: ,l_api_version => l_api_version
2304: ,p_api_version => p_api_version

Line 2308: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2304: ,p_api_version => p_api_version
2305: ,p_api_type => g_api_type
2306: ,x_return_status => x_return_status);
2307: -- check if activity started successfully
2308: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2310: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2311: RAISE OKL_API.G_EXCEPTION_ERROR;
2312: END IF;

Line 2309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2305: ,p_api_type => g_api_type
2306: ,x_return_status => x_return_status);
2307: -- check if activity started successfully
2308: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2310: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2311: RAISE OKL_API.G_EXCEPTION_ERROR;
2312: END IF;
2313: l_asset_rec := populate_asset_rec(p_asset_rec.id,x_return_status);

Line 2310: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2306: ,x_return_status => x_return_status);
2307: -- check if activity started successfully
2308: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2310: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2311: RAISE OKL_API.G_EXCEPTION_ERROR;
2312: END IF;
2313: l_asset_rec := populate_asset_rec(p_asset_rec.id,x_return_status);
2314:

Line 2311: RAISE OKL_API.G_EXCEPTION_ERROR;

2307: -- check if activity started successfully
2308: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2310: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2311: RAISE OKL_API.G_EXCEPTION_ERROR;
2312: END IF;
2313: l_asset_rec := populate_asset_rec(p_asset_rec.id,x_return_status);
2314:
2315: l_asset_rec.RATE_CARD_ID := p_asset_rec.RATE_CARD_ID;

Line 2340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2336: ,'begin debug call update_row');
2337: END IF;
2338:
2339: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF x_return_status = G_RET_STS_ERROR THEN
2342: RAISE OKL_API.G_EXCEPTION_ERROR;
2343: END IF;
2344:

Line 2342: RAISE OKL_API.G_EXCEPTION_ERROR;

2338:
2339: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF x_return_status = G_RET_STS_ERROR THEN
2342: RAISE OKL_API.G_EXCEPTION_ERROR;
2343: END IF;
2344:
2345: IF(l_debug_enabled='Y') THEN
2346: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'

Line 2364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2360: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2361: END IF;
2362:
2363: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2365: ELSIF x_return_status = G_RET_STS_ERROR THEN
2366: RAISE OKL_API.G_EXCEPTION_ERROR;
2367: END IF;
2368:

Line 2366: RAISE OKL_API.G_EXCEPTION_ERROR;

2362:
2363: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2365: ELSIF x_return_status = G_RET_STS_ERROR THEN
2366: RAISE OKL_API.G_EXCEPTION_ERROR;
2367: END IF;
2368:
2369: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2370: FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;

Line 2383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2379: ,p_parent_object_id => l_p_id
2380: );
2381:
2382: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF x_return_status = G_RET_STS_ERROR THEN
2385: RAISE OKL_API.G_EXCEPTION_ERROR;
2386: END IF;*/
2387:

Line 2385: RAISE OKL_API.G_EXCEPTION_ERROR;

2381:
2382: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF x_return_status = G_RET_STS_ERROR THEN
2385: RAISE OKL_API.G_EXCEPTION_ERROR;
2386: END IF;*/
2387:
2388:
2389:

Line 2390: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

2386: END IF;*/
2387:
2388:
2389:
2390: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2391: ,x_msg_data => x_msg_data);
2392: EXCEPTION
2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2389:
2390: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2391: ,x_msg_data => x_msg_data);
2392: EXCEPTION
2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2395: p_api_name => l_api_name,
2396: p_pkg_name => G_PKG_NAME,
2397: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2390: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2391: ,x_msg_data => x_msg_data);
2392: EXCEPTION
2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2395: p_api_name => l_api_name,
2396: p_pkg_name => G_PKG_NAME,
2397: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2398: x_msg_count => x_msg_count,

Line 2397: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2395: p_api_name => l_api_name,
2396: p_pkg_name => G_PKG_NAME,
2397: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2398: x_msg_count => x_msg_count,
2399: x_msg_data => x_msg_data,
2400: p_api_type => g_api_type);
2401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2397: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2398: x_msg_count => x_msg_count,
2399: x_msg_data => x_msg_data,
2400: p_api_type => g_api_type);
2401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2402: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2403: p_api_name => l_api_name,
2404: p_pkg_name => G_PKG_NAME,
2405: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2402: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2398: x_msg_count => x_msg_count,
2399: x_msg_data => x_msg_data,
2400: p_api_type => g_api_type);
2401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2402: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2403: p_api_name => l_api_name,
2404: p_pkg_name => G_PKG_NAME,
2405: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2406: x_msg_count => x_msg_count,

Line 2405: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2402: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2403: p_api_name => l_api_name,
2404: p_pkg_name => G_PKG_NAME,
2405: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2406: x_msg_count => x_msg_count,
2407: x_msg_data => x_msg_data,
2408: p_api_type => g_api_type);
2409: WHEN OTHERS THEN

Line 2410: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2406: x_msg_count => x_msg_count,
2407: x_msg_data => x_msg_data,
2408: p_api_type => g_api_type);
2409: WHEN OTHERS THEN
2410: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2411: p_api_name => l_api_name,
2412: p_pkg_name => G_PKG_NAME,
2413: p_exc_name => 'OTHERS',
2414: x_msg_count => x_msg_count,

Line 2447: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2443:
2444: -- Variables Declarations
2445: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2446: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_LINE_PAYMENT';
2447: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2448: l_debug_enabled VARCHAR2(10);
2449:
2450:
2451: -- Record/Table Type Declarations

Line 2473: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2469:
2470:
2471: BEGIN
2472:
2473: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2474: -- check for logging on PROCEDURE level
2475: l_debug_enabled := okl_debug_pub.check_log_enabled;
2476: -- call START_ACTIVITY to create savepoint, check compatibility
2477: -- and initialize message list

Line 2478: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

2474: -- check for logging on PROCEDURE level
2475: l_debug_enabled := okl_debug_pub.check_log_enabled;
2476: -- call START_ACTIVITY to create savepoint, check compatibility
2477: -- and initialize message list
2478: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
2479: ,p_pkg_name => G_PKG_NAME
2480: ,p_init_msg_list => p_init_msg_list
2481: ,l_api_version => l_api_version
2482: ,p_api_version => p_api_version

Line 2486: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2482: ,p_api_version => p_api_version
2483: ,p_api_type => g_api_type
2484: ,x_return_status => x_return_status);
2485: -- check if activity started successfully
2486: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2489: RAISE OKL_API.G_EXCEPTION_ERROR;
2490: END IF;

Line 2487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2483: ,p_api_type => g_api_type
2484: ,x_return_status => x_return_status);
2485: -- check if activity started successfully
2486: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2489: RAISE OKL_API.G_EXCEPTION_ERROR;
2490: END IF;
2491:

Line 2488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2484: ,x_return_status => x_return_status);
2485: -- check if activity started successfully
2486: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2489: RAISE OKL_API.G_EXCEPTION_ERROR;
2490: END IF;
2491:
2492: l_source_object_id := p_source_object_id;

Line 2489: RAISE OKL_API.G_EXCEPTION_ERROR;

2485: -- check if activity started successfully
2486: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2488: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2489: RAISE OKL_API.G_EXCEPTION_ERROR;
2490: END IF;
2491:
2492: l_source_object_id := p_source_object_id;
2493: l_source_object_code := p_source_object_code;

Line 2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2496: --Populate fee record
2497: l_fee_rec := populate_fee_rec(l_source_object_id,x_return_status);
2498:
2499: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF x_return_status = G_RET_STS_ERROR THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;
2503: END IF;
2504:

Line 2502: RAISE OKL_API.G_EXCEPTION_ERROR;

2498:
2499: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF x_return_status = G_RET_STS_ERROR THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;
2503: END IF;
2504:
2505: l_fee_rec.RATE_CARD_ID := NULL;
2506: l_fee_rec.RATE_TEMPLATE_ID := NULL;

Line 2531: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2527: ,'end debug call update_row');
2528: END IF;
2529:
2530: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2531: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2532: ELSIF x_return_status = G_RET_STS_ERROR THEN
2533: RAISE OKL_API.G_EXCEPTION_ERROR;
2534: END IF;
2535:

Line 2533: RAISE OKL_API.G_EXCEPTION_ERROR;

2529:
2530: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2531: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2532: ELSIF x_return_status = G_RET_STS_ERROR THEN
2533: RAISE OKL_API.G_EXCEPTION_ERROR;
2534: END IF;
2535:
2536: ELSIF l_source_object_code = 'QUOTED_ASSET' THEN
2537: l_asset_rec := populate_asset_rec(l_source_object_id,x_return_status);

Line 2563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2559: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
2560: ,'end debug call update_row');
2561: END IF;
2562: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF x_return_status = G_RET_STS_ERROR THEN
2565: RAISE OKL_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: END IF;

Line 2565: RAISE OKL_API.G_EXCEPTION_ERROR;

2561: END IF;
2562: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF x_return_status = G_RET_STS_ERROR THEN
2565: RAISE OKL_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: END IF;
2568: -- Check if the Cash flows already exists
2569: OPEN c_check_cash_flow(p_source_id => l_source_object_id,p_source_code => l_source_object_code);

Line 2595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2591: ,'end debug call delete_cashflows');
2592: END IF;
2593:
2594: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2596: ELSIF x_return_status = G_RET_STS_ERROR THEN
2597: RAISE OKL_API.G_EXCEPTION_ERROR;
2598: END IF;
2599: END IF;

Line 2597: RAISE OKL_API.G_EXCEPTION_ERROR;

2593:
2594: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2596: ELSIF x_return_status = G_RET_STS_ERROR THEN
2597: RAISE OKL_API.G_EXCEPTION_ERROR;
2598: END IF;
2599: END IF;
2600:
2601: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 2602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2598: END IF;
2599: END IF;
2600:
2601: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2603: ELSIF x_return_status = G_RET_STS_ERROR THEN
2604: RAISE OKL_API.G_EXCEPTION_ERROR;
2605: END IF;
2606:

Line 2604: RAISE OKL_API.G_EXCEPTION_ERROR;

2600:
2601: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2603: ELSIF x_return_status = G_RET_STS_ERROR THEN
2604: RAISE OKL_API.G_EXCEPTION_ERROR;
2605: END IF;
2606:
2607: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2608: ,x_msg_data => x_msg_data);

Line 2607: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

2603: ELSIF x_return_status = G_RET_STS_ERROR THEN
2604: RAISE OKL_API.G_EXCEPTION_ERROR;
2605: END IF;
2606:
2607: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2608: ,x_msg_data => x_msg_data);
2609: EXCEPTION
2610: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2611: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2610: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2606:
2607: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2608: ,x_msg_data => x_msg_data);
2609: EXCEPTION
2610: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2611: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2612: p_api_name => l_api_name,
2613: p_pkg_name => G_PKG_NAME,
2614: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2611: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2607: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
2608: ,x_msg_data => x_msg_data);
2609: EXCEPTION
2610: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2611: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2612: p_api_name => l_api_name,
2613: p_pkg_name => G_PKG_NAME,
2614: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2615: x_msg_count => x_msg_count,

Line 2614: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2610: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2611: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2612: p_api_name => l_api_name,
2613: p_pkg_name => G_PKG_NAME,
2614: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2615: x_msg_count => x_msg_count,
2616: x_msg_data => x_msg_data,
2617: p_api_type => g_api_type);
2618: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2618: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2614: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2615: x_msg_count => x_msg_count,
2616: x_msg_data => x_msg_data,
2617: p_api_type => g_api_type);
2618: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2619: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2620: p_api_name => l_api_name,
2621: p_pkg_name => G_PKG_NAME,
2622: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2619: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2615: x_msg_count => x_msg_count,
2616: x_msg_data => x_msg_data,
2617: p_api_type => g_api_type);
2618: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2619: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2620: p_api_name => l_api_name,
2621: p_pkg_name => G_PKG_NAME,
2622: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2623: x_msg_count => x_msg_count,

Line 2622: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2618: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2619: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2620: p_api_name => l_api_name,
2621: p_pkg_name => G_PKG_NAME,
2622: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2623: x_msg_count => x_msg_count,
2624: x_msg_data => x_msg_data,
2625: p_api_type => g_api_type);
2626: WHEN OTHERS THEN

Line 2627: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2623: x_msg_count => x_msg_count,
2624: x_msg_data => x_msg_data,
2625: p_api_type => g_api_type);
2626: WHEN OTHERS THEN
2627: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2628: p_api_name => l_api_name,
2629: p_pkg_name => G_PKG_NAME,
2630: p_exc_name => 'OTHERS',
2631: x_msg_count => x_msg_count,