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

APPS.OKL_LA_TRADEIN_PVT dependencies on OKC_API

Line 424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

420:
421:
422:
423: PROCEDURE allocate_amount1(p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
425: p_transaction_control IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
426: p_cle_id IN NUMBER,
427: p_chr_id IN NUMBER,
428: p_capitalize_yn IN VARCHAR2,

Line 425: p_transaction_control IN VARCHAR2 DEFAULT OKC_API.G_TRUE,

421:
422:
423: PROCEDURE allocate_amount1(p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
425: p_transaction_control IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
426: p_cle_id IN NUMBER,
427: p_chr_id IN NUMBER,
428: p_capitalize_yn IN VARCHAR2,
429: x_cle_id OUT NOCOPY NUMBER,

Line 577: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

573:
574:
575: PROCEDURE update_contract(
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_chr_id IN okl_k_headers.id%TYPE,

Line 606: x_return_status := OKC_API.START_ACTIVITY(

602: BEGIN
603:
604: -- call START_ACTIVITY to create savepoint, check compatibility
605: -- and initialize message list
606: x_return_status := OKC_API.START_ACTIVITY(
607: p_api_name => l_api_name,
608: p_pkg_name => g_pkg_name,
609: p_init_msg_list => p_init_msg_list,
610: l_api_version => l_api_version,

Line 616: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

612: p_api_type => g_api_type,
613: x_return_status => x_return_status);
614:
615: -- check if activity started successfully
616: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
617: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
619: raise OKC_API.G_EXCEPTION_ERROR;
620: End If;

Line 617: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

613: x_return_status => x_return_status);
614:
615: -- check if activity started successfully
616: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
617: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
619: raise OKC_API.G_EXCEPTION_ERROR;
620: End If;
621:

Line 618: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

614:
615: -- check if activity started successfully
616: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
617: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
619: raise OKC_API.G_EXCEPTION_ERROR;
620: End If;
621:
622: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then

Line 619: raise OKC_API.G_EXCEPTION_ERROR;

615: -- check if activity started successfully
616: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
617: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
619: raise OKC_API.G_EXCEPTION_ERROR;
620: End If;
621:
622: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then
623: x_return_status := OKC_API.g_ret_sts_error;

Line 623: x_return_status := OKC_API.g_ret_sts_error;

619: raise OKC_API.G_EXCEPTION_ERROR;
620: End If;
621:
622: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then
623: x_return_status := OKC_API.g_ret_sts_error;
624: OKC_API.SET_MESSAGE( p_app_name => g_app_name
625: , p_msg_name => 'OKL_REQUIRED_VALUE'
626: , p_token1 => 'COL_NAME'
627: , p_token1_value => 'DNZ_CHR_ID'

Line 624: OKC_API.SET_MESSAGE( p_app_name => g_app_name

620: End If;
621:
622: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then
623: x_return_status := OKC_API.g_ret_sts_error;
624: OKC_API.SET_MESSAGE( p_app_name => g_app_name
625: , p_msg_name => 'OKL_REQUIRED_VALUE'
626: , p_token1 => 'COL_NAME'
627: , p_token1_value => 'DNZ_CHR_ID'
628: );

Line 629: raise OKC_API.G_EXCEPTION_ERROR;

625: , p_msg_name => 'OKL_REQUIRED_VALUE'
626: , p_token1 => 'COL_NAME'
627: , p_token1_value => 'DNZ_CHR_ID'
628: );
629: raise OKC_API.G_EXCEPTION_ERROR;
630: End If;
631:
632: If(l_tradein_date is null or l_tradein_date = OKL_API.G_MISS_DATE) Then
633: x_return_status := OKC_API.g_ret_sts_error;

Line 633: x_return_status := OKC_API.g_ret_sts_error;

629: raise OKC_API.G_EXCEPTION_ERROR;
630: End If;
631:
632: If(l_tradein_date is null or l_tradein_date = OKL_API.G_MISS_DATE) Then
633: x_return_status := OKC_API.g_ret_sts_error;
634: l_ak_prompt := GET_AK_PROMPT('OKL_LA_AST_DTLS', 'OKL_TRADEIN_DATE');
635: OKC_API.SET_MESSAGE( p_app_name => g_app_name
636: , p_msg_name => 'OKL_REQUIRED_VALUE'
637: , p_token1 => 'COL_NAME'

Line 635: OKC_API.SET_MESSAGE( p_app_name => g_app_name

631:
632: If(l_tradein_date is null or l_tradein_date = OKL_API.G_MISS_DATE) Then
633: x_return_status := OKC_API.g_ret_sts_error;
634: l_ak_prompt := GET_AK_PROMPT('OKL_LA_AST_DTLS', 'OKL_TRADEIN_DATE');
635: OKC_API.SET_MESSAGE( p_app_name => g_app_name
636: , p_msg_name => 'OKL_REQUIRED_VALUE'
637: , p_token1 => 'COL_NAME'
638: , p_token1_value => l_ak_prompt
639: );

Line 640: raise OKC_API.G_EXCEPTION_ERROR;

636: , p_msg_name => 'OKL_REQUIRED_VALUE'
637: , p_token1 => 'COL_NAME'
638: , p_token1_value => l_ak_prompt
639: );
640: raise OKC_API.G_EXCEPTION_ERROR;
641: End If;
642:
643: If(l_tradein_amount is null or l_tradein_amount = OKL_API.G_MISS_NUM) Then
644: x_return_status := OKC_API.g_ret_sts_error;

Line 644: x_return_status := OKC_API.g_ret_sts_error;

640: raise OKC_API.G_EXCEPTION_ERROR;
641: End If;
642:
643: If(l_tradein_amount is null or l_tradein_amount = OKL_API.G_MISS_NUM) Then
644: x_return_status := OKC_API.g_ret_sts_error;
645: l_ak_prompt := GET_AK_PROMPT('OKL_LA_AST_DTLS', 'OKL_TRADEIN_AMOUNT');
646: OKC_API.SET_MESSAGE( p_app_name => g_app_name
647: , p_msg_name => 'OKL_REQUIRED_VALUE'
648: , p_token1 => 'COL_NAME'

Line 646: OKC_API.SET_MESSAGE( p_app_name => g_app_name

642:
643: If(l_tradein_amount is null or l_tradein_amount = OKL_API.G_MISS_NUM) Then
644: x_return_status := OKC_API.g_ret_sts_error;
645: l_ak_prompt := GET_AK_PROMPT('OKL_LA_AST_DTLS', 'OKL_TRADEIN_AMOUNT');
646: OKC_API.SET_MESSAGE( p_app_name => g_app_name
647: , p_msg_name => 'OKL_REQUIRED_VALUE'
648: , p_token1 => 'COL_NAME'
649: , p_token1_value => l_ak_prompt
650: );

Line 651: raise OKC_API.G_EXCEPTION_ERROR;

647: , p_msg_name => 'OKL_REQUIRED_VALUE'
648: , p_token1 => 'COL_NAME'
649: , p_token1_value => l_ak_prompt
650: );
651: raise OKC_API.G_EXCEPTION_ERROR;
652: End If;
653:
654:
655: If okl_context.get_okc_org_id is null then

Line 677: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

673: p_khrv_rec => lp_khrv_rec,
674: x_chrv_rec => lx_chrv_rec,
675: x_khrv_rec => lx_khrv_rec);
676:
677: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
680: RAISE OKC_API.G_EXCEPTION_ERROR;
681: END IF;

Line 678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

674: x_chrv_rec => lx_chrv_rec,
675: x_khrv_rec => lx_khrv_rec);
676:
677: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
680: RAISE OKC_API.G_EXCEPTION_ERROR;
681: END IF;
682:

Line 679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

675: x_khrv_rec => lx_khrv_rec);
676:
677: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
680: RAISE OKC_API.G_EXCEPTION_ERROR;
681: END IF;
682:
683: x_return_status := OKC_API.g_ret_sts_success;

Line 680: RAISE OKC_API.G_EXCEPTION_ERROR;

676:
677: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
680: RAISE OKC_API.G_EXCEPTION_ERROR;
681: END IF;
682:
683: x_return_status := OKC_API.g_ret_sts_success;
684:

Line 683: x_return_status := OKC_API.g_ret_sts_success;

679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
680: RAISE OKC_API.G_EXCEPTION_ERROR;
681: END IF;
682:
683: x_return_status := OKC_API.g_ret_sts_success;
684:
685: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
686:
687: EXCEPTION

Line 685: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

681: END IF;
682:
683: x_return_status := OKC_API.g_ret_sts_success;
684:
685: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
686:
687: EXCEPTION
688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 688: when OKC_API.G_EXCEPTION_ERROR then

684:
685: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
686:
687: EXCEPTION
688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
690: p_api_name => l_api_name,
691: p_pkg_name => g_pkg_name,
692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

685: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
686:
687: EXCEPTION
688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
690: p_api_name => l_api_name,
691: p_pkg_name => g_pkg_name,
692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
693: x_msg_count => x_msg_count,

Line 692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
690: p_api_name => l_api_name,
691: p_pkg_name => g_pkg_name,
692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data,
695: p_api_type => g_api_type);
696:

Line 697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data,
695: p_api_type => g_api_type);
696:
697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
699: p_api_name => l_api_name,
700: p_pkg_name => g_pkg_name,
701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

694: x_msg_data => x_msg_data,
695: p_api_type => g_api_type);
696:
697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
699: p_api_name => l_api_name,
700: p_pkg_name => g_pkg_name,
701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
702: x_msg_count => x_msg_count,

Line 701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
699: p_api_name => l_api_name,
700: p_pkg_name => g_pkg_name,
701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data,
704: p_api_type => g_api_type);
705:

Line 707: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

703: x_msg_data => x_msg_data,
704: p_api_type => g_api_type);
705:
706: when OTHERS then
707: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
708: p_api_name => l_api_name,
709: p_pkg_name => g_pkg_name,
710: p_exc_name => 'OTHERS',
711: x_msg_count => x_msg_count,

Line 859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

855: --Bug# 5102606
856:
857: PROCEDURE create_tradein(
858: p_api_version IN NUMBER,
859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
860: x_return_status OUT NOCOPY VARCHAR2,
861: x_msg_count OUT NOCOPY NUMBER,
862: x_msg_data OUT NOCOPY VARCHAR2,
863: p_chr_id IN okl_k_headers.id%TYPE,

Line 887: x_return_status := OKC_API.START_ACTIVITY(

883: BEGIN
884:
885: -- call START_ACTIVITY to create savepoint, check compatibility
886: -- and initialize message list
887: x_return_status := OKC_API.START_ACTIVITY(
888: p_api_name => l_api_name,
889: p_pkg_name => g_pkg_name,
890: p_init_msg_list => p_init_msg_list,
891: l_api_version => l_api_version,

Line 897: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

893: p_api_type => g_api_type,
894: x_return_status => x_return_status);
895:
896: -- check if activity started successfully
897: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
898: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
900: raise OKC_API.G_EXCEPTION_ERROR;
901: End If;

Line 898: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

894: x_return_status => x_return_status);
895:
896: -- check if activity started successfully
897: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
898: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
900: raise OKC_API.G_EXCEPTION_ERROR;
901: End If;
902:

Line 899: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

895:
896: -- check if activity started successfully
897: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
898: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
900: raise OKC_API.G_EXCEPTION_ERROR;
901: End If;
902:
903: If( lp_tradein_rec.asset_id is null) Then

Line 900: raise OKC_API.G_EXCEPTION_ERROR;

896: -- check if activity started successfully
897: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
898: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
900: raise OKC_API.G_EXCEPTION_ERROR;
901: End If;
902:
903: If( lp_tradein_rec.asset_id is null) Then
904: -- program error

Line 905: x_return_status := OKC_API.g_ret_sts_error;

901: End If;
902:
903: If( lp_tradein_rec.asset_id is null) Then
904: -- program error
905: x_return_status := OKC_API.g_ret_sts_error;
906: OKC_API.SET_MESSAGE( p_app_name => g_app_name
907: , p_msg_name => 'PROGRAM_ERROR_ASSET_ID'
908: );
909: raise OKC_API.G_EXCEPTION_ERROR;

Line 906: OKC_API.SET_MESSAGE( p_app_name => g_app_name

902:
903: If( lp_tradein_rec.asset_id is null) Then
904: -- program error
905: x_return_status := OKC_API.g_ret_sts_error;
906: OKC_API.SET_MESSAGE( p_app_name => g_app_name
907: , p_msg_name => 'PROGRAM_ERROR_ASSET_ID'
908: );
909: raise OKC_API.G_EXCEPTION_ERROR;
910: End If;

Line 909: raise OKC_API.G_EXCEPTION_ERROR;

905: x_return_status := OKC_API.g_ret_sts_error;
906: OKC_API.SET_MESSAGE( p_app_name => g_app_name
907: , p_msg_name => 'PROGRAM_ERROR_ASSET_ID'
908: );
909: raise OKC_API.G_EXCEPTION_ERROR;
910: End If;
911:
912: -- on update of a asset line, reset the tradein_amount value to null
913: If ( (lp_tradein_rec.id is not null and lp_tradein_rec.id <> OKL_API.G_MISS_NUM)

Line 932: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

928: x_clev_rec => lx_clev_rec,
929: x_klev_rec => lx_klev_rec);
930:
931:
932: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
933: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
935: raise OKC_API.G_EXCEPTION_ERROR;
936: End If;

Line 933: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

929: x_klev_rec => lx_klev_rec);
930:
931:
932: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
933: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
935: raise OKC_API.G_EXCEPTION_ERROR;
936: End If;
937:

Line 934: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

930:
931:
932: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
933: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
935: raise OKC_API.G_EXCEPTION_ERROR;
936: End If;
937:
938: --Bug# 5102606

Line 935: raise OKC_API.G_EXCEPTION_ERROR;

931:
932: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
933: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
935: raise OKC_API.G_EXCEPTION_ERROR;
936: End If;
937:
938: --Bug# 5102606
939: recalculate_costs(

Line 948: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

944: x_msg_data => x_msg_data,
945: p_chr_id => p_chr_id,
946: p_cle_id => lp_clev_rec.id);
947:
948: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
949: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
950: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
951: raise OKC_API.G_EXCEPTION_ERROR;
952: End If;

Line 949: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

945: p_chr_id => p_chr_id,
946: p_cle_id => lp_clev_rec.id);
947:
948: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
949: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
950: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
951: raise OKC_API.G_EXCEPTION_ERROR;
952: End If;
953: --Bug# 5102606

Line 950: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

946: p_cle_id => lp_clev_rec.id);
947:
948: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
949: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
950: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
951: raise OKC_API.G_EXCEPTION_ERROR;
952: End If;
953: --Bug# 5102606
954:

Line 951: raise OKC_API.G_EXCEPTION_ERROR;

947:
948: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
949: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
950: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
951: raise OKC_API.G_EXCEPTION_ERROR;
952: End If;
953: --Bug# 5102606
954:
955: End If;

Line 973: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

969: x_clev_rec => lx_clev_rec,
970: x_klev_rec => lx_klev_rec);
971:
972:
973: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
974: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
975: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
976: raise OKC_API.G_EXCEPTION_ERROR;
977: End If;

Line 974: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

970: x_klev_rec => lx_klev_rec);
971:
972:
973: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
974: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
975: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
976: raise OKC_API.G_EXCEPTION_ERROR;
977: End If;
978:

Line 975: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

971:
972:
973: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
974: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
975: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
976: raise OKC_API.G_EXCEPTION_ERROR;
977: End If;
978:
979: --Bug# 5102606

Line 976: raise OKC_API.G_EXCEPTION_ERROR;

972:
973: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
974: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
975: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
976: raise OKC_API.G_EXCEPTION_ERROR;
977: End If;
978:
979: --Bug# 5102606
980: recalculate_costs(

Line 989: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

985: x_msg_data => x_msg_data,
986: p_chr_id => p_chr_id,
987: p_cle_id => lp_clev_rec.id);
988:
989: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
990: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
992: raise OKC_API.G_EXCEPTION_ERROR;
993: End If;

Line 990: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

986: p_chr_id => p_chr_id,
987: p_cle_id => lp_clev_rec.id);
988:
989: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
990: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
992: raise OKC_API.G_EXCEPTION_ERROR;
993: End If;
994: --Bug# 5102606

Line 991: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

987: p_cle_id => lp_clev_rec.id);
988:
989: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
990: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
992: raise OKC_API.G_EXCEPTION_ERROR;
993: End If;
994: --Bug# 5102606
995:

Line 992: raise OKC_API.G_EXCEPTION_ERROR;

988:
989: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
990: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
991: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
992: raise OKC_API.G_EXCEPTION_ERROR;
993: End If;
994: --Bug# 5102606
995:
996: x_tradein_rec.id := lx_clev_rec.id;

Line 998: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

994: --Bug# 5102606
995:
996: x_tradein_rec.id := lx_clev_rec.id;
997:
998: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
999:
1000: EXCEPTION
1001: when OKC_API.G_EXCEPTION_ERROR then
1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1001: when OKC_API.G_EXCEPTION_ERROR then

997:
998: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
999:
1000: EXCEPTION
1001: when OKC_API.G_EXCEPTION_ERROR then
1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1003: p_api_name => l_api_name,
1004: p_pkg_name => g_pkg_name,
1005: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

998: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
999:
1000: EXCEPTION
1001: when OKC_API.G_EXCEPTION_ERROR then
1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1003: p_api_name => l_api_name,
1004: p_pkg_name => g_pkg_name,
1005: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1006: x_msg_count => x_msg_count,

Line 1005: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1001: when OKC_API.G_EXCEPTION_ERROR then
1002: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1003: p_api_name => l_api_name,
1004: p_pkg_name => g_pkg_name,
1005: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1006: x_msg_count => x_msg_count,
1007: x_msg_data => x_msg_data,
1008: p_api_type => g_api_type);
1009:

Line 1010: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1006: x_msg_count => x_msg_count,
1007: x_msg_data => x_msg_data,
1008: p_api_type => g_api_type);
1009:
1010: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1011: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1012: p_api_name => l_api_name,
1013: p_pkg_name => g_pkg_name,
1014: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1011: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1007: x_msg_data => x_msg_data,
1008: p_api_type => g_api_type);
1009:
1010: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1011: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1012: p_api_name => l_api_name,
1013: p_pkg_name => g_pkg_name,
1014: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1015: x_msg_count => x_msg_count,

Line 1014: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1010: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1011: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1012: p_api_name => l_api_name,
1013: p_pkg_name => g_pkg_name,
1014: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1015: x_msg_count => x_msg_count,
1016: x_msg_data => x_msg_data,
1017: p_api_type => g_api_type);
1018:

Line 1020: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1016: x_msg_data => x_msg_data,
1017: p_api_type => g_api_type);
1018:
1019: when OTHERS then
1020: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1021: p_api_name => l_api_name,
1022: p_pkg_name => g_pkg_name,
1023: p_exc_name => 'OTHERS',
1024: x_msg_count => x_msg_count,

Line 1032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1028: END;
1029:
1030: PROCEDURE create_tradein(
1031: p_api_version IN NUMBER,
1032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1033: x_return_status OUT NOCOPY VARCHAR2,
1034: x_msg_count OUT NOCOPY NUMBER,
1035: x_msg_data OUT NOCOPY VARCHAR2,
1036: p_chr_id IN okl_k_headers.id%TYPE,

Line 1068: x_return_status := OKC_API.START_ACTIVITY(

1064: BEGIN
1065:
1066: -- call START_ACTIVITY to create savepoint, check compatibility
1067: -- and initialize message list
1068: x_return_status := OKC_API.START_ACTIVITY(
1069: p_api_name => l_api_name,
1070: p_pkg_name => g_pkg_name,
1071: p_init_msg_list => p_init_msg_list,
1072: l_api_version => l_api_version,

Line 1078: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1074: p_api_type => g_api_type,
1075: x_return_status => x_return_status);
1076:
1077: -- check if activity started successfully
1078: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1079: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1081: raise OKC_API.G_EXCEPTION_ERROR;
1082: End If;

Line 1079: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1075: x_return_status => x_return_status);
1076:
1077: -- check if activity started successfully
1078: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1079: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1081: raise OKC_API.G_EXCEPTION_ERROR;
1082: End If;
1083:

Line 1080: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1076:
1077: -- check if activity started successfully
1078: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1079: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1081: raise OKC_API.G_EXCEPTION_ERROR;
1082: End If;
1083:
1084: If okl_context.get_okc_org_id is null then

Line 1081: raise OKC_API.G_EXCEPTION_ERROR;

1077: -- check if activity started successfully
1078: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1079: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1081: raise OKC_API.G_EXCEPTION_ERROR;
1082: End If;
1083:
1084: If okl_context.get_okc_org_id is null then
1085: okl_context.set_okc_org_context(p_chr_id => l_chr_id );

Line 1106: x_return_status := OKC_API.g_ret_sts_error;

1102: End If;
1103:
1104: If( (lp_tradein_rec.asset_number is null or lp_tradein_rec.asset_number = OKL_API.G_MISS_CHAR)
1105: and (lp_tradein_rec.tradein_amount is not null and lp_tradein_rec.tradein_amount != OKL_API.G_MISS_NUM) ) Then
1106: x_return_status := OKC_API.g_ret_sts_error;
1107: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1108: , p_msg_name => 'OKL_LLA_ASSET_REQUIRED'
1109: );
1110: raise OKC_API.G_EXCEPTION_ERROR;

Line 1107: OKC_API.SET_MESSAGE( p_app_name => g_app_name

1103:
1104: If( (lp_tradein_rec.asset_number is null or lp_tradein_rec.asset_number = OKL_API.G_MISS_CHAR)
1105: and (lp_tradein_rec.tradein_amount is not null and lp_tradein_rec.tradein_amount != OKL_API.G_MISS_NUM) ) Then
1106: x_return_status := OKC_API.g_ret_sts_error;
1107: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1108: , p_msg_name => 'OKL_LLA_ASSET_REQUIRED'
1109: );
1110: raise OKC_API.G_EXCEPTION_ERROR;
1111: End If;

Line 1110: raise OKC_API.G_EXCEPTION_ERROR;

1106: x_return_status := OKC_API.g_ret_sts_error;
1107: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1108: , p_msg_name => 'OKL_LLA_ASSET_REQUIRED'
1109: );
1110: raise OKC_API.G_EXCEPTION_ERROR;
1111: End If;
1112:
1113: If( (lp_tradein_rec.asset_number is not null and lp_tradein_rec.asset_number != OKL_API.G_MISS_CHAR)
1114: and (lp_tradein_rec.tradein_amount is null or lp_tradein_rec.tradein_amount = OKL_API.G_MISS_NUM) ) Then

Line 1115: x_return_status := OKC_API.g_ret_sts_error;

1111: End If;
1112:
1113: If( (lp_tradein_rec.asset_number is not null and lp_tradein_rec.asset_number != OKL_API.G_MISS_CHAR)
1114: and (lp_tradein_rec.tradein_amount is null or lp_tradein_rec.tradein_amount = OKL_API.G_MISS_NUM) ) Then
1115: x_return_status := OKC_API.g_ret_sts_error;
1116: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1117: , p_msg_name => 'OKL_AMOUNT_FORMAT'
1118: );
1119: raise OKC_API.G_EXCEPTION_ERROR;

Line 1116: OKC_API.SET_MESSAGE( p_app_name => g_app_name

1112:
1113: If( (lp_tradein_rec.asset_number is not null and lp_tradein_rec.asset_number != OKL_API.G_MISS_CHAR)
1114: and (lp_tradein_rec.tradein_amount is null or lp_tradein_rec.tradein_amount = OKL_API.G_MISS_NUM) ) Then
1115: x_return_status := OKC_API.g_ret_sts_error;
1116: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1117: , p_msg_name => 'OKL_AMOUNT_FORMAT'
1118: );
1119: raise OKC_API.G_EXCEPTION_ERROR;
1120: End If;

Line 1119: raise OKC_API.G_EXCEPTION_ERROR;

1115: x_return_status := OKC_API.g_ret_sts_error;
1116: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1117: , p_msg_name => 'OKL_AMOUNT_FORMAT'
1118: );
1119: raise OKC_API.G_EXCEPTION_ERROR;
1120: End If;
1121: */
1122: create_tradein(
1123: p_api_version => p_api_version,

Line 1132: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

1128: p_chr_id => l_chr_id,
1129: p_tradein_rec => lp_tradein_rec,
1130: x_tradein_rec => lx_tradein_rec);
1131:
1132: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1133: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1135: raise OKC_API.G_EXCEPTION_ERROR;
1136: End If;

Line 1133: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1129: p_tradein_rec => lp_tradein_rec,
1130: x_tradein_rec => lx_tradein_rec);
1131:
1132: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1133: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1135: raise OKC_API.G_EXCEPTION_ERROR;
1136: End If;
1137:

Line 1134: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

1130: x_tradein_rec => lx_tradein_rec);
1131:
1132: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1133: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1135: raise OKC_API.G_EXCEPTION_ERROR;
1136: End If;
1137:
1138: EXIT WHEN (i = p_tradein_tbl.LAST);

Line 1135: raise OKC_API.G_EXCEPTION_ERROR;

1131:
1132: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1133: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1135: raise OKC_API.G_EXCEPTION_ERROR;
1136: End If;
1137:
1138: EXIT WHEN (i = p_tradein_tbl.LAST);
1139: i := p_tradein_tbl.NEXT(i);

Line 1144: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1140: END LOOP;
1141:
1142: End If;
1143:
1144: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1145:
1146: EXCEPTION
1147: when OKC_API.G_EXCEPTION_ERROR then
1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1147: when OKC_API.G_EXCEPTION_ERROR then

1143:
1144: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1145:
1146: EXCEPTION
1147: when OKC_API.G_EXCEPTION_ERROR then
1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1149: p_api_name => l_api_name,
1150: p_pkg_name => g_pkg_name,
1151: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1144: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1145:
1146: EXCEPTION
1147: when OKC_API.G_EXCEPTION_ERROR then
1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1149: p_api_name => l_api_name,
1150: p_pkg_name => g_pkg_name,
1151: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1152: x_msg_count => x_msg_count,

Line 1151: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1147: when OKC_API.G_EXCEPTION_ERROR then
1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1149: p_api_name => l_api_name,
1150: p_pkg_name => g_pkg_name,
1151: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1152: x_msg_count => x_msg_count,
1153: x_msg_data => x_msg_data,
1154: p_api_type => g_api_type);
1155:

Line 1156: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1152: x_msg_count => x_msg_count,
1153: x_msg_data => x_msg_data,
1154: p_api_type => g_api_type);
1155:
1156: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1157: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1158: p_api_name => l_api_name,
1159: p_pkg_name => g_pkg_name,
1160: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1157: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1153: x_msg_data => x_msg_data,
1154: p_api_type => g_api_type);
1155:
1156: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1157: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1158: p_api_name => l_api_name,
1159: p_pkg_name => g_pkg_name,
1160: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1161: x_msg_count => x_msg_count,

Line 1160: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1156: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1157: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1158: p_api_name => l_api_name,
1159: p_pkg_name => g_pkg_name,
1160: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1161: x_msg_count => x_msg_count,
1162: x_msg_data => x_msg_data,
1163: p_api_type => g_api_type);
1164:

Line 1166: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1162: x_msg_data => x_msg_data,
1163: p_api_type => g_api_type);
1164:
1165: when OTHERS then
1166: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1167: p_api_name => l_api_name,
1168: p_pkg_name => g_pkg_name,
1169: p_exc_name => 'OTHERS',
1170: x_msg_count => x_msg_count,

Line 1179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1175:
1176:
1177: PROCEDURE delete_tradein(
1178: p_api_version IN NUMBER,
1179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1180: x_return_status OUT NOCOPY VARCHAR2,
1181: x_msg_count OUT NOCOPY NUMBER,
1182: x_msg_data OUT NOCOPY VARCHAR2,
1183: p_chr_id IN okl_k_headers.id%TYPE,

Line 1207: x_return_status := OKC_API.START_ACTIVITY(

1203: BEGIN
1204:
1205: -- call START_ACTIVITY to create savepoint, check compatibility
1206: -- and initialize message list
1207: x_return_status := OKC_API.START_ACTIVITY(
1208: p_api_name => l_api_name,
1209: p_pkg_name => g_pkg_name,
1210: p_init_msg_list => p_init_msg_list,
1211: l_api_version => l_api_version,

Line 1217: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1213: p_api_type => g_api_type,
1214: x_return_status => x_return_status);
1215:
1216: -- check if activity started successfully
1217: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1220: raise OKC_API.G_EXCEPTION_ERROR;
1221: End If;

Line 1218: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1214: x_return_status => x_return_status);
1215:
1216: -- check if activity started successfully
1217: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1220: raise OKC_API.G_EXCEPTION_ERROR;
1221: End If;
1222:

Line 1219: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1215:
1216: -- check if activity started successfully
1217: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1220: raise OKC_API.G_EXCEPTION_ERROR;
1221: End If;
1222:
1223: lp_clev_rec.id := lp_tradein_rec.id;

Line 1220: raise OKC_API.G_EXCEPTION_ERROR;

1216: -- check if activity started successfully
1217: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1220: raise OKC_API.G_EXCEPTION_ERROR;
1221: End If;
1222:
1223: lp_clev_rec.id := lp_tradein_rec.id;
1224: lp_klev_rec.id := lp_tradein_rec.id;

Line 1239: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1235: x_clev_rec => lx_clev_rec,
1236: x_klev_rec => lx_klev_rec);
1237:
1238:
1239: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1242: raise OKC_API.G_EXCEPTION_ERROR;
1243: End If;

Line 1240: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1236: x_klev_rec => lx_klev_rec);
1237:
1238:
1239: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1242: raise OKC_API.G_EXCEPTION_ERROR;
1243: End If;
1244:

Line 1241: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1237:
1238:
1239: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1242: raise OKC_API.G_EXCEPTION_ERROR;
1243: End If;
1244:
1245: --Bug# 5102606

Line 1242: raise OKC_API.G_EXCEPTION_ERROR;

1238:
1239: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1242: raise OKC_API.G_EXCEPTION_ERROR;
1243: End If;
1244:
1245: --Bug# 5102606
1246: recalculate_costs(

Line 1255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1251: x_msg_data => x_msg_data,
1252: p_chr_id => p_chr_id,
1253: p_cle_id => lp_clev_rec.id);
1254:
1255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1258: raise OKC_API.G_EXCEPTION_ERROR;
1259: End If;

Line 1256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1252: p_chr_id => p_chr_id,
1253: p_cle_id => lp_clev_rec.id);
1254:
1255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1258: raise OKC_API.G_EXCEPTION_ERROR;
1259: End If;
1260: --Bug# 5102606

Line 1257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1253: p_cle_id => lp_clev_rec.id);
1254:
1255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1258: raise OKC_API.G_EXCEPTION_ERROR;
1259: End If;
1260: --Bug# 5102606
1261:

Line 1258: raise OKC_API.G_EXCEPTION_ERROR;

1254:
1255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1258: raise OKC_API.G_EXCEPTION_ERROR;
1259: End If;
1260: --Bug# 5102606
1261:
1262: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 1262: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1258: raise OKC_API.G_EXCEPTION_ERROR;
1259: End If;
1260: --Bug# 5102606
1261:
1262: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1263:
1264: EXCEPTION
1265: when OKC_API.G_EXCEPTION_ERROR then
1266: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1265: when OKC_API.G_EXCEPTION_ERROR then

1261:
1262: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1263:
1264: EXCEPTION
1265: when OKC_API.G_EXCEPTION_ERROR then
1266: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1267: p_api_name => l_api_name,
1268: p_pkg_name => g_pkg_name,
1269: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1266: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1262: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1263:
1264: EXCEPTION
1265: when OKC_API.G_EXCEPTION_ERROR then
1266: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1267: p_api_name => l_api_name,
1268: p_pkg_name => g_pkg_name,
1269: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1270: x_msg_count => x_msg_count,

Line 1269: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1265: when OKC_API.G_EXCEPTION_ERROR then
1266: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1267: p_api_name => l_api_name,
1268: p_pkg_name => g_pkg_name,
1269: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1270: x_msg_count => x_msg_count,
1271: x_msg_data => x_msg_data,
1272: p_api_type => g_api_type);
1273:

Line 1274: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1270: x_msg_count => x_msg_count,
1271: x_msg_data => x_msg_data,
1272: p_api_type => g_api_type);
1273:
1274: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1275: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1276: p_api_name => l_api_name,
1277: p_pkg_name => g_pkg_name,
1278: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1275: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1271: x_msg_data => x_msg_data,
1272: p_api_type => g_api_type);
1273:
1274: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1275: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1276: p_api_name => l_api_name,
1277: p_pkg_name => g_pkg_name,
1278: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1279: x_msg_count => x_msg_count,

Line 1278: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1274: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1275: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1276: p_api_name => l_api_name,
1277: p_pkg_name => g_pkg_name,
1278: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1279: x_msg_count => x_msg_count,
1280: x_msg_data => x_msg_data,
1281: p_api_type => g_api_type);
1282:

Line 1284: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1280: x_msg_data => x_msg_data,
1281: p_api_type => g_api_type);
1282:
1283: when OTHERS then
1284: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1285: p_api_name => l_api_name,
1286: p_pkg_name => g_pkg_name,
1287: p_exc_name => 'OTHERS',
1288: x_msg_count => x_msg_count,

Line 1296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1292: END;
1293:
1294: PROCEDURE delete_tradein(
1295: p_api_version IN NUMBER,
1296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1297: x_return_status OUT NOCOPY VARCHAR2,
1298: x_msg_count OUT NOCOPY NUMBER,
1299: x_msg_data OUT NOCOPY VARCHAR2,
1300: p_chr_id IN okl_k_headers.id%TYPE,

Line 1332: x_return_status := OKC_API.START_ACTIVITY(

1328: BEGIN
1329:
1330: -- call START_ACTIVITY to create savepoint, check compatibility
1331: -- and initialize message list
1332: x_return_status := OKC_API.START_ACTIVITY(
1333: p_api_name => l_api_name,
1334: p_pkg_name => g_pkg_name,
1335: p_init_msg_list => p_init_msg_list,
1336: l_api_version => l_api_version,

Line 1342: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1338: p_api_type => g_api_type,
1339: x_return_status => x_return_status);
1340:
1341: -- check if activity started successfully
1342: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1343: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1345: raise OKC_API.G_EXCEPTION_ERROR;
1346: End If;

Line 1343: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1339: x_return_status => x_return_status);
1340:
1341: -- check if activity started successfully
1342: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1343: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1345: raise OKC_API.G_EXCEPTION_ERROR;
1346: End If;
1347:

Line 1344: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1340:
1341: -- check if activity started successfully
1342: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1343: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1345: raise OKC_API.G_EXCEPTION_ERROR;
1346: End If;
1347:
1348: If (p_tradein_tbl.COUNT > 0) Then

Line 1345: raise OKC_API.G_EXCEPTION_ERROR;

1341: -- check if activity started successfully
1342: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1343: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1345: raise OKC_API.G_EXCEPTION_ERROR;
1346: End If;
1347:
1348: If (p_tradein_tbl.COUNT > 0) Then
1349:

Line 1366: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

1362: p_chr_id => l_chr_id,
1363: p_tradein_rec => lp_tradein_rec,
1364: x_tradein_rec => lx_tradein_rec);
1365:
1366: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1368: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1369: raise OKC_API.G_EXCEPTION_ERROR;
1370: End If;

Line 1367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1363: p_tradein_rec => lp_tradein_rec,
1364: x_tradein_rec => lx_tradein_rec);
1365:
1366: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1368: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1369: raise OKC_API.G_EXCEPTION_ERROR;
1370: End If;
1371:

Line 1368: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

1364: x_tradein_rec => lx_tradein_rec);
1365:
1366: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1368: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1369: raise OKC_API.G_EXCEPTION_ERROR;
1370: End If;
1371:
1372: EXIT WHEN (i = p_tradein_tbl.LAST);

Line 1369: raise OKC_API.G_EXCEPTION_ERROR;

1365:
1366: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
1367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1368: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
1369: raise OKC_API.G_EXCEPTION_ERROR;
1370: End If;
1371:
1372: EXIT WHEN (i = p_tradein_tbl.LAST);
1373: i := p_tradein_tbl.NEXT(i);

Line 1378: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1374: END LOOP;
1375:
1376: End If;
1377:
1378: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1379:
1380: EXCEPTION
1381: when OKC_API.G_EXCEPTION_ERROR then
1382: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1381: when OKC_API.G_EXCEPTION_ERROR then

1377:
1378: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1379:
1380: EXCEPTION
1381: when OKC_API.G_EXCEPTION_ERROR then
1382: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1383: p_api_name => l_api_name,
1384: p_pkg_name => g_pkg_name,
1385: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1382: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1378: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1379:
1380: EXCEPTION
1381: when OKC_API.G_EXCEPTION_ERROR then
1382: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1383: p_api_name => l_api_name,
1384: p_pkg_name => g_pkg_name,
1385: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1386: x_msg_count => x_msg_count,

Line 1385: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1381: when OKC_API.G_EXCEPTION_ERROR then
1382: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1383: p_api_name => l_api_name,
1384: p_pkg_name => g_pkg_name,
1385: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data,
1388: p_api_type => g_api_type);
1389:

Line 1390: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data,
1388: p_api_type => g_api_type);
1389:
1390: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1391: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1392: p_api_name => l_api_name,
1393: p_pkg_name => g_pkg_name,
1394: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1391: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1387: x_msg_data => x_msg_data,
1388: p_api_type => g_api_type);
1389:
1390: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1391: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1392: p_api_name => l_api_name,
1393: p_pkg_name => g_pkg_name,
1394: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1395: x_msg_count => x_msg_count,

Line 1394: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1390: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1391: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1392: p_api_name => l_api_name,
1393: p_pkg_name => g_pkg_name,
1394: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1395: x_msg_count => x_msg_count,
1396: x_msg_data => x_msg_data,
1397: p_api_type => g_api_type);
1398:

Line 1400: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1396: x_msg_data => x_msg_data,
1397: p_api_type => g_api_type);
1398:
1399: when OTHERS then
1400: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1401: p_api_name => l_api_name,
1402: p_pkg_name => g_pkg_name,
1403: p_exc_name => 'OTHERS',
1404: x_msg_count => x_msg_count,

Line 1439: x_return_status := OKC_API.START_ACTIVITY(

1435: End If;
1436:
1437: -- call START_ACTIVITY to create savepoint, check compatibility
1438: -- and initialize message list
1439: x_return_status := OKC_API.START_ACTIVITY(
1440: p_api_name => l_api_name,
1441: p_pkg_name => g_pkg_name,
1442: p_init_msg_list => p_init_msg_list,
1443: l_api_version => l_api_version,

Line 1449: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1445: p_api_type => g_api_type,
1446: x_return_status => x_return_status);
1447:
1448: -- check if activity started successfully
1449: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1450: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1452: raise OKC_API.G_EXCEPTION_ERROR;
1453: End If;

Line 1450: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1446: x_return_status => x_return_status);
1447:
1448: -- check if activity started successfully
1449: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1450: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1452: raise OKC_API.G_EXCEPTION_ERROR;
1453: End If;
1454:

Line 1451: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1447:
1448: -- check if activity started successfully
1449: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1450: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1452: raise OKC_API.G_EXCEPTION_ERROR;
1453: End If;
1454:
1455: allocate_amount(

Line 1452: raise OKC_API.G_EXCEPTION_ERROR;

1448: -- check if activity started successfully
1449: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1450: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1452: raise OKC_API.G_EXCEPTION_ERROR;
1453: End If;
1454:
1455: allocate_amount(
1456: p_api_version => p_api_version,

Line 1469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data
1467: );
1468:
1469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;

Line 1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1466: x_msg_data => x_msg_data
1467: );
1468:
1469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474:

Line 1471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1467: );
1468:
1469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474:
1475: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 1472: RAISE OKC_API.G_EXCEPTION_ERROR;

1468:
1469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474:
1475: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1476:

Line 1475: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474:
1475: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1476:
1477: EXCEPTION
1478: when OKC_API.G_EXCEPTION_ERROR then
1479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1478: when OKC_API.G_EXCEPTION_ERROR then

1474:
1475: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1476:
1477: EXCEPTION
1478: when OKC_API.G_EXCEPTION_ERROR then
1479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1480: p_api_name => l_api_name,
1481: p_pkg_name => g_pkg_name,
1482: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1475: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1476:
1477: EXCEPTION
1478: when OKC_API.G_EXCEPTION_ERROR then
1479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1480: p_api_name => l_api_name,
1481: p_pkg_name => g_pkg_name,
1482: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1483: x_msg_count => x_msg_count,

Line 1482: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1478: when OKC_API.G_EXCEPTION_ERROR then
1479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1480: p_api_name => l_api_name,
1481: p_pkg_name => g_pkg_name,
1482: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data,
1485: p_api_type => g_api_type);
1486:

Line 1487: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data,
1485: p_api_type => g_api_type);
1486:
1487: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1488: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1489: p_api_name => l_api_name,
1490: p_pkg_name => g_pkg_name,
1491: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1488: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1484: x_msg_data => x_msg_data,
1485: p_api_type => g_api_type);
1486:
1487: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1488: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1489: p_api_name => l_api_name,
1490: p_pkg_name => g_pkg_name,
1491: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1492: x_msg_count => x_msg_count,

Line 1491: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1487: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1488: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1489: p_api_name => l_api_name,
1490: p_pkg_name => g_pkg_name,
1491: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1492: x_msg_count => x_msg_count,
1493: x_msg_data => x_msg_data,
1494: p_api_type => g_api_type);
1495:

Line 1497: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1493: x_msg_data => x_msg_data,
1494: p_api_type => g_api_type);
1495:
1496: when OTHERS then
1497: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1498: p_api_name => l_api_name,
1499: p_pkg_name => g_pkg_name,
1500: p_exc_name => 'OTHERS',
1501: x_msg_count => x_msg_count,

Line 1509: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1505: END allocate_amount;
1506:
1507: PROCEDURE allocate_amount_tradein (
1508: p_api_version IN NUMBER,
1509: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1510: x_return_status OUT NOCOPY VARCHAR2,
1511: x_msg_count OUT NOCOPY NUMBER,
1512: x_msg_data OUT NOCOPY VARCHAR2,
1513: p_chr_id IN NUMBER,

Line 1558: x_return_status := OKC_API.START_ACTIVITY(

1554: BEGIN
1555:
1556: -- call START_ACTIVITY to create savepoint, check compatibility
1557: -- and initialize message list
1558: x_return_status := OKC_API.START_ACTIVITY(
1559: p_api_name => l_api_name,
1560: p_pkg_name => g_pkg_name,
1561: p_init_msg_list => p_init_msg_list,
1562: l_api_version => l_api_version,

Line 1568: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1564: p_api_type => g_api_type,
1565: x_return_status => x_return_status);
1566:
1567: -- check if activity started successfully
1568: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1569: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1571: raise OKC_API.G_EXCEPTION_ERROR;
1572: End If;

Line 1569: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1565: x_return_status => x_return_status);
1566:
1567: -- check if activity started successfully
1568: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1569: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1571: raise OKC_API.G_EXCEPTION_ERROR;
1572: End If;
1573:

Line 1570: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1566:
1567: -- check if activity started successfully
1568: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1569: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1571: raise OKC_API.G_EXCEPTION_ERROR;
1572: End If;
1573:
1574: l_chr_id := p_chr_id;

Line 1571: raise OKC_API.G_EXCEPTION_ERROR;

1567: -- check if activity started successfully
1568: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1569: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1571: raise OKC_API.G_EXCEPTION_ERROR;
1572: End If;
1573:
1574: l_chr_id := p_chr_id;
1575: If okl_context.get_okc_org_id is null then

Line 1743: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1739: x_clev_tbl => lx_clev_tbl,
1740: x_klev_tbl => lx_klev_tbl);
1741:
1742:
1743: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1744: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1745: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1746: raise OKC_API.G_EXCEPTION_ERROR;
1747: End If;

Line 1744: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1740: x_klev_tbl => lx_klev_tbl);
1741:
1742:
1743: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1744: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1745: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1746: raise OKC_API.G_EXCEPTION_ERROR;
1747: End If;
1748:

Line 1745: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1741:
1742:
1743: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1744: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1745: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1746: raise OKC_API.G_EXCEPTION_ERROR;
1747: End If;
1748:
1749: --Bug# 5102606

Line 1746: raise OKC_API.G_EXCEPTION_ERROR;

1742:
1743: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1744: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1745: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1746: raise OKC_API.G_EXCEPTION_ERROR;
1747: End If;
1748:
1749: --Bug# 5102606
1750: FOR i IN lp_klev_tbl.FIRST .. lp_klev_tbl.LAST

Line 1762: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1758: x_msg_data => x_msg_data,
1759: p_chr_id => p_chr_id,
1760: p_cle_id => lp_klev_tbl(i).id);
1761:
1762: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1763: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1764: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1765: raise OKC_API.G_EXCEPTION_ERROR;
1766: End If;

Line 1763: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1759: p_chr_id => p_chr_id,
1760: p_cle_id => lp_klev_tbl(i).id);
1761:
1762: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1763: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1764: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1765: raise OKC_API.G_EXCEPTION_ERROR;
1766: End If;
1767: END LOOP;

Line 1764: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1760: p_cle_id => lp_klev_tbl(i).id);
1761:
1762: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1763: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1764: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1765: raise OKC_API.G_EXCEPTION_ERROR;
1766: End If;
1767: END LOOP;
1768: --Bug# 5102606

Line 1765: raise OKC_API.G_EXCEPTION_ERROR;

1761:
1762: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1763: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1764: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1765: raise OKC_API.G_EXCEPTION_ERROR;
1766: End If;
1767: END LOOP;
1768: --Bug# 5102606
1769:

Line 1774: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1770: END IF;
1771:
1772: END IF;
1773:
1774: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1775:
1776: EXCEPTION
1777:
1778: when OKC_API.G_EXCEPTION_ERROR then

Line 1778: when OKC_API.G_EXCEPTION_ERROR then

1774: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1775:
1776: EXCEPTION
1777:
1778: when OKC_API.G_EXCEPTION_ERROR then
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1780: p_api_name => l_api_name,
1781: p_pkg_name => g_pkg_name,
1782: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1775:
1776: EXCEPTION
1777:
1778: when OKC_API.G_EXCEPTION_ERROR then
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1780: p_api_name => l_api_name,
1781: p_pkg_name => g_pkg_name,
1782: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1783: x_msg_count => x_msg_count,

Line 1782: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1778: when OKC_API.G_EXCEPTION_ERROR then
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1780: p_api_name => l_api_name,
1781: p_pkg_name => g_pkg_name,
1782: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1783: x_msg_count => x_msg_count,
1784: x_msg_data => x_msg_data,
1785: p_api_type => g_api_type);
1786:

Line 1787: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1783: x_msg_count => x_msg_count,
1784: x_msg_data => x_msg_data,
1785: p_api_type => g_api_type);
1786:
1787: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1789: p_api_name => l_api_name,
1790: p_pkg_name => g_pkg_name,
1791: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1784: x_msg_data => x_msg_data,
1785: p_api_type => g_api_type);
1786:
1787: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1789: p_api_name => l_api_name,
1790: p_pkg_name => g_pkg_name,
1791: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1792: x_msg_count => x_msg_count,

Line 1791: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1787: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1788: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1789: p_api_name => l_api_name,
1790: p_pkg_name => g_pkg_name,
1791: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1792: x_msg_count => x_msg_count,
1793: x_msg_data => x_msg_data,
1794: p_api_type => g_api_type);
1795:

Line 1797: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1793: x_msg_data => x_msg_data,
1794: p_api_type => g_api_type);
1795:
1796: when OTHERS then
1797: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1798: p_api_name => l_api_name,
1799: p_pkg_name => g_pkg_name,
1800: p_exc_name => 'OTHERS',
1801: x_msg_count => x_msg_count,

Line 1810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1806: --Bug# 5237504 Added the following procedure to remove trade-in info at
1807: -- contract level
1808: PROCEDURE delete_contract(
1809: p_api_version IN NUMBER,
1810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1811: x_return_status OUT NOCOPY VARCHAR2,
1812: x_msg_count OUT NOCOPY NUMBER,
1813: x_msg_data OUT NOCOPY VARCHAR2,
1814: p_chr_id IN okl_k_headers.id%TYPE

Line 1834: x_return_status := OKC_API.START_ACTIVITY(

1830: BEGIN
1831:
1832: -- call START_ACTIVITY to create savepoint, check compatibility
1833: -- and initialize message list
1834: x_return_status := OKC_API.START_ACTIVITY(
1835: p_api_name => l_api_name,
1836: p_pkg_name => g_pkg_name,
1837: p_init_msg_list => p_init_msg_list,
1838: l_api_version => l_api_version,

Line 1844: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1840: p_api_type => g_api_type,
1841: x_return_status => x_return_status);
1842:
1843: -- check if activity started successfully
1844: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1845: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1847: raise OKC_API.G_EXCEPTION_ERROR;
1848: End If;

Line 1845: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1841: x_return_status => x_return_status);
1842:
1843: -- check if activity started successfully
1844: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1845: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1847: raise OKC_API.G_EXCEPTION_ERROR;
1848: End If;
1849:

Line 1846: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1842:
1843: -- check if activity started successfully
1844: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1845: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1847: raise OKC_API.G_EXCEPTION_ERROR;
1848: End If;
1849:
1850: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then

Line 1847: raise OKC_API.G_EXCEPTION_ERROR;

1843: -- check if activity started successfully
1844: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1845: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1847: raise OKC_API.G_EXCEPTION_ERROR;
1848: End If;
1849:
1850: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then
1851: x_return_status := OKC_API.g_ret_sts_error;

Line 1851: x_return_status := OKC_API.g_ret_sts_error;

1847: raise OKC_API.G_EXCEPTION_ERROR;
1848: End If;
1849:
1850: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then
1851: x_return_status := OKC_API.g_ret_sts_error;
1852: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1853: , p_msg_name => 'OKL_REQUIRED_VALUE'
1854: , p_token1 => 'COL_NAME'
1855: , p_token1_value => 'DNZ_CHR_ID'

Line 1852: OKC_API.SET_MESSAGE( p_app_name => g_app_name

1848: End If;
1849:
1850: If(l_chr_id is null or l_chr_id = OKL_API.G_MISS_NUM) Then
1851: x_return_status := OKC_API.g_ret_sts_error;
1852: OKC_API.SET_MESSAGE( p_app_name => g_app_name
1853: , p_msg_name => 'OKL_REQUIRED_VALUE'
1854: , p_token1 => 'COL_NAME'
1855: , p_token1_value => 'DNZ_CHR_ID'
1856: );

Line 1857: raise OKC_API.G_EXCEPTION_ERROR;

1853: , p_msg_name => 'OKL_REQUIRED_VALUE'
1854: , p_token1 => 'COL_NAME'
1855: , p_token1_value => 'DNZ_CHR_ID'
1856: );
1857: raise OKC_API.G_EXCEPTION_ERROR;
1858: End If;
1859:
1860: If okl_context.get_okc_org_id is null then
1861: okl_context.set_okc_org_context(p_chr_id => l_chr_id );

Line 1882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1878: p_khrv_rec => lp_khrv_rec,
1879: x_chrv_rec => lx_chrv_rec,
1880: x_khrv_rec => lx_khrv_rec);
1881:
1882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;

Line 1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1879: x_chrv_rec => lx_chrv_rec,
1880: x_khrv_rec => lx_khrv_rec);
1881:
1882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:

Line 1884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1880: x_khrv_rec => lx_khrv_rec);
1881:
1882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:
1888: x_return_status := OKC_API.g_ret_sts_success;

Line 1885: RAISE OKC_API.G_EXCEPTION_ERROR;

1881:
1882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:
1888: x_return_status := OKC_API.g_ret_sts_success;
1889:

Line 1888: x_return_status := OKC_API.g_ret_sts_success;

1884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:
1888: x_return_status := OKC_API.g_ret_sts_success;
1889:
1890: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1891:
1892: EXCEPTION

Line 1890: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1886: END IF;
1887:
1888: x_return_status := OKC_API.g_ret_sts_success;
1889:
1890: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1891:
1892: EXCEPTION
1893: when OKC_API.G_EXCEPTION_ERROR then
1894: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1893: when OKC_API.G_EXCEPTION_ERROR then

1889:
1890: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1891:
1892: EXCEPTION
1893: when OKC_API.G_EXCEPTION_ERROR then
1894: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1895: p_api_name => l_api_name,
1896: p_pkg_name => g_pkg_name,
1897: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1894: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1890: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1891:
1892: EXCEPTION
1893: when OKC_API.G_EXCEPTION_ERROR then
1894: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1895: p_api_name => l_api_name,
1896: p_pkg_name => g_pkg_name,
1897: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1898: x_msg_count => x_msg_count,

Line 1897: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1893: when OKC_API.G_EXCEPTION_ERROR then
1894: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1895: p_api_name => l_api_name,
1896: p_pkg_name => g_pkg_name,
1897: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1898: x_msg_count => x_msg_count,
1899: x_msg_data => x_msg_data,
1900: p_api_type => g_api_type);
1901:

Line 1902: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1898: x_msg_count => x_msg_count,
1899: x_msg_data => x_msg_data,
1900: p_api_type => g_api_type);
1901:
1902: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1903: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1904: p_api_name => l_api_name,
1905: p_pkg_name => g_pkg_name,
1906: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1903: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1899: x_msg_data => x_msg_data,
1900: p_api_type => g_api_type);
1901:
1902: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1903: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1904: p_api_name => l_api_name,
1905: p_pkg_name => g_pkg_name,
1906: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1907: x_msg_count => x_msg_count,

Line 1906: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1902: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1903: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1904: p_api_name => l_api_name,
1905: p_pkg_name => g_pkg_name,
1906: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1907: x_msg_count => x_msg_count,
1908: x_msg_data => x_msg_data,
1909: p_api_type => g_api_type);
1910:

Line 1912: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1908: x_msg_data => x_msg_data,
1909: p_api_type => g_api_type);
1910:
1911: when OTHERS then
1912: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1913: p_api_name => l_api_name,
1914: p_pkg_name => g_pkg_name,
1915: p_exc_name => 'OTHERS',
1916: x_msg_count => x_msg_count,