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_DEAL_TERMS_PVT dependencies on OKL_API

Line 7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

3: -------------------------------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: -------------------------------------------------------------------------------------------------

Line 32: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

28: -------------------------------------------------------------------------------------------------
29: -- GLOBAL VARIABLES
30: -------------------------------------------------------------------------------------------------
31: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DEAL_TERMS_PVT';
32: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
33: -------------------------------------------------------------------------------------------------
34:
35: PROCEDURE delete_terms(
36: p_api_version IN NUMBER,

Line 37: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

33: -------------------------------------------------------------------------------------------------
34:
35: PROCEDURE delete_terms(
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_chr_id IN NUMBER,

Line 86: x_return_status := OKL_API.START_ACTIVITY(

82: l_msg_index_out number;
83:
84: BEGIN
85:
86: x_return_status := OKL_API.START_ACTIVITY(
87: p_api_name => l_api_name,
88: p_pkg_name => g_pkg_name,
89: p_init_msg_list => p_init_msg_list,
90: l_api_version => l_api_version,

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

92: p_api_type => g_api_type,
93: x_return_status => x_return_status);
94:
95: -- check if activity started successfully
96: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
97: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_ERROR;
100: END IF;

Line 97: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

93: x_return_status => x_return_status);
94:
95: -- check if activity started successfully
96: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
97: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_ERROR;
100: END IF;
101:

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

94:
95: -- check if activity started successfully
96: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
97: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_ERROR;
100: END IF;
101:
102: IF (p_rgpv_rec.rgp_id IS NULL) THEN

Line 99: RAISE OKL_API.G_EXCEPTION_ERROR;

95: -- check if activity started successfully
96: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
97: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_ERROR;
100: END IF;
101:
102: IF (p_rgpv_rec.rgp_id IS NULL) THEN
103:

Line 505: x_return_status := OKL_API.START_ACTIVITY(

501: l_msg_data VARCHAR2(4000);
502: l_msg_index_out number;
503:
504: BEGIN
505: x_return_status := OKL_API.START_ACTIVITY(
506: p_api_name => l_api_name,
507: p_pkg_name => g_pkg_name,
508: p_init_msg_list => p_init_msg_list,
509: l_api_version => l_api_version,

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

511: p_api_type => g_api_type,
512: x_return_status => x_return_status);
513:
514: -- check if activity started successfully
515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
518: RAISE OKL_API.G_EXCEPTION_ERROR;
519: END IF;

Line 516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

512: x_return_status => x_return_status);
513:
514: -- check if activity started successfully
515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
518: RAISE OKL_API.G_EXCEPTION_ERROR;
519: END IF;
520:

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

513:
514: -- check if activity started successfully
515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
518: RAISE OKL_API.G_EXCEPTION_ERROR;
519: END IF;
520:
521: IF (p_rgpv_rec.rgp_id IS NULL) THEN

Line 518: RAISE OKL_API.G_EXCEPTION_ERROR;

514: -- check if activity started successfully
515: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
517: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
518: RAISE OKL_API.G_EXCEPTION_ERROR;
519: END IF;
520:
521: IF (p_rgpv_rec.rgp_id IS NULL) THEN
522:

Line 742: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

738: END process_rvi;
739:
740: PROCEDURE load_billing_setup(
741: p_api_version IN NUMBER,
742: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
743: x_return_status OUT NOCOPY VARCHAR2,
744: x_msg_count OUT NOCOPY NUMBER,
745: x_msg_data OUT NOCOPY VARCHAR2,
746: p_chr_id IN NUMBER,

Line 749: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

745: x_msg_data OUT NOCOPY VARCHAR2,
746: p_chr_id IN NUMBER,
747: x_billing_setup_rec OUT NOCOPY billing_setup_rec_type) IS
748:
749: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
750: l_api_name CONSTANT VARCHAR2(30) := 'load_billing_setup';
751: l_api_version CONSTANT NUMBER := 1.0;
752:
753: CURSOR c_bill_to(p_chr_id NUMBER) IS

Line 791: x_return_status := OKL_API.G_RET_STS_SUCCESS;

787: FROM okl_bpd_active_csh_rls_v
788: WHERE id1 = p_object1_id1;
789:
790: BEGIN
791: x_return_status := OKL_API.G_RET_STS_SUCCESS;
792: -- Call start_activity to create savepoint, check compatibility
793: -- and initialize message list
794: x_return_status := OKL_API.START_ACTIVITY (
795: l_api_name

Line 794: x_return_status := OKL_API.START_ACTIVITY (

790: BEGIN
791: x_return_status := OKL_API.G_RET_STS_SUCCESS;
792: -- Call start_activity to create savepoint, check compatibility
793: -- and initialize message list
794: x_return_status := OKL_API.START_ACTIVITY (
795: l_api_name
796: ,p_init_msg_list
797: ,'_PVT'
798: ,x_return_status);

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

796: ,p_init_msg_list
797: ,'_PVT'
798: ,x_return_status);
799: -- Check if activity started successfully
800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;

Line 801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

797: ,'_PVT'
798: ,x_return_status);
799: -- Check if activity started successfully
800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:

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

798: ,x_return_status);
799: -- Check if activity started successfully
800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:
806: x_billing_setup_rec.chr_id := p_chr_id;

Line 803: RAISE OKL_API.G_EXCEPTION_ERROR;

799: -- Check if activity started successfully
800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:
806: x_billing_setup_rec.chr_id := p_chr_id;
807: OPEN c_bill_to(p_chr_id);

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

862: x_billing_setup_rec.lainpr_rule_information1 := l_rule.rule_information1;
863: x_billing_setup_rec.lainpr_rule_information2 := l_rule.rule_information2;
864: CLOSE c_rule;
865:
866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_ERROR;
870: END IF;

Line 867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

863: x_billing_setup_rec.lainpr_rule_information2 := l_rule.rule_information2;
864: CLOSE c_rule;
865:
866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_ERROR;
870: END IF;
871:

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

864: CLOSE c_rule;
865:
866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_ERROR;
870: END IF;
871:
872: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 869: RAISE OKL_API.G_EXCEPTION_ERROR;

865:
866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_ERROR;
870: END IF;
871:
872: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
873:

Line 872: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_ERROR;
870: END IF;
871:
872: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
873:
874: EXCEPTION
875: WHEN OKL_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 875: WHEN OKL_API.G_EXCEPTION_ERROR THEN

871:
872: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
873:
874: EXCEPTION
875: WHEN OKL_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
877: l_api_name,
878: G_PKG_NAME,
879: 'OKL_API.G_RET_STS_ERROR',

Line 876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

872: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
873:
874: EXCEPTION
875: WHEN OKL_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
877: l_api_name,
878: G_PKG_NAME,
879: 'OKL_API.G_RET_STS_ERROR',
880: x_msg_count,

Line 879: 'OKL_API.G_RET_STS_ERROR',

875: WHEN OKL_API.G_EXCEPTION_ERROR THEN
876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
877: l_api_name,
878: G_PKG_NAME,
879: 'OKL_API.G_RET_STS_ERROR',
880: x_msg_count,
881: x_msg_data,
882: '_PVT');
883: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 883: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

879: 'OKL_API.G_RET_STS_ERROR',
880: x_msg_count,
881: x_msg_data,
882: '_PVT');
883: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
884: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
885: l_api_name,
886: G_PKG_NAME,
887: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 884: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

880: x_msg_count,
881: x_msg_data,
882: '_PVT');
883: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
884: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
885: l_api_name,
886: G_PKG_NAME,
887: 'OKL_API.G_RET_STS_UNEXP_ERROR',
888: x_msg_count,

Line 887: 'OKL_API.G_RET_STS_UNEXP_ERROR',

883: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
884: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
885: l_api_name,
886: G_PKG_NAME,
887: 'OKL_API.G_RET_STS_UNEXP_ERROR',
888: x_msg_count,
889: x_msg_data,
890: '_PVT');
891: WHEN OTHERS THEN

Line 892: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

888: x_msg_count,
889: x_msg_data,
890: '_PVT');
891: WHEN OTHERS THEN
892: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
893: l_api_name,
894: G_PKG_NAME,
895: 'OTHERS',
896: x_msg_count,

Line 903: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

899: END load_billing_setup;
900:
901: PROCEDURE load_rvi(
902: p_api_version IN NUMBER,
903: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_chr_id IN NUMBER,

Line 910: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_chr_id IN NUMBER,
908: x_rvi_rec OUT NOCOPY rvi_rec_type) IS
909:
910: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
911: l_api_name CONSTANT VARCHAR2(30) := 'load_rvi';
912: l_api_version CONSTANT NUMBER := 1.0;
913:
914: CURSOR c_rule(p_chr_id NUMBER) IS

Line 956: x_return_status := OKL_API.G_RET_STS_SUCCESS;

952: and olsb.LTY_CODE = 'FEE'
953: and cle.dnz_chr_id = p_chr_id;
954:
955: BEGIN
956: x_return_status := OKL_API.G_RET_STS_SUCCESS;
957: -- Call start_activity to create savepoint, check compatibility
958: -- and initialize message list
959: x_return_status := OKL_API.START_ACTIVITY (
960: l_api_name

Line 959: x_return_status := OKL_API.START_ACTIVITY (

955: BEGIN
956: x_return_status := OKL_API.G_RET_STS_SUCCESS;
957: -- Call start_activity to create savepoint, check compatibility
958: -- and initialize message list
959: x_return_status := OKL_API.START_ACTIVITY (
960: l_api_name
961: ,p_init_msg_list
962: ,'_PVT'
963: ,x_return_status);

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

961: ,p_init_msg_list
962: ,'_PVT'
963: ,x_return_status);
964: -- Check if activity started successfully
965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_ERROR;
969: END IF;

Line 966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

962: ,'_PVT'
963: ,x_return_status);
964: -- Check if activity started successfully
965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_ERROR;
969: END IF;
970:

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

963: ,x_return_status);
964: -- Check if activity started successfully
965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_ERROR;
969: END IF;
970:
971: OPEN c_rule(p_chr_id);

Line 968: RAISE OKL_API.G_EXCEPTION_ERROR;

964: -- Check if activity started successfully
965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
968: RAISE OKL_API.G_EXCEPTION_ERROR;
969: END IF;
970:
971: OPEN c_rule(p_chr_id);
972: FETCH c_rule INTO x_rvi_rec.chr_id,x_rvi_rec.rgp_id,x_rvi_rec.rgd_code,x_rvi_rec.rgp_larvin_larvau_id,x_rvi_rec.rgp_larvin_larvam_id,

Line 981: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

977: OPEN c_stream_name(p_chr_id);
978: FETCH c_stream_name INTO x_rvi_rec.line_id,x_rvi_rec.item_id1,x_rvi_rec.item_name,x_rvi_rec.fee_type;
979: CLOSE c_stream_name;
980:
981: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
982:
983: EXCEPTION
984: WHEN OKL_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 984: WHEN OKL_API.G_EXCEPTION_ERROR THEN

980:
981: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
982:
983: EXCEPTION
984: WHEN OKL_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
986: l_api_name,
987: G_PKG_NAME,
988: 'OKL_API.G_RET_STS_ERROR',

Line 985: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

981: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
982:
983: EXCEPTION
984: WHEN OKL_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
986: l_api_name,
987: G_PKG_NAME,
988: 'OKL_API.G_RET_STS_ERROR',
989: x_msg_count,

Line 988: 'OKL_API.G_RET_STS_ERROR',

984: WHEN OKL_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
986: l_api_name,
987: G_PKG_NAME,
988: 'OKL_API.G_RET_STS_ERROR',
989: x_msg_count,
990: x_msg_data,
991: '_PVT');
992: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 992: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

988: 'OKL_API.G_RET_STS_ERROR',
989: x_msg_count,
990: x_msg_data,
991: '_PVT');
992: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
993: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
994: l_api_name,
995: G_PKG_NAME,
996: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 993: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

989: x_msg_count,
990: x_msg_data,
991: '_PVT');
992: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
993: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
994: l_api_name,
995: G_PKG_NAME,
996: 'OKL_API.G_RET_STS_UNEXP_ERROR',
997: x_msg_count,

Line 996: 'OKL_API.G_RET_STS_UNEXP_ERROR',

992: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
993: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
994: l_api_name,
995: G_PKG_NAME,
996: 'OKL_API.G_RET_STS_UNEXP_ERROR',
997: x_msg_count,
998: x_msg_data,
999: '_PVT');
1000: WHEN OTHERS THEN

Line 1001: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

997: x_msg_count,
998: x_msg_data,
999: '_PVT');
1000: WHEN OTHERS THEN
1001: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1002: l_api_name,
1003: G_PKG_NAME,
1004: 'OTHERS',
1005: x_msg_count,

Line 1012: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1008: END load_rvi;
1009:
1010: PROCEDURE delete_tnc_group(
1011: p_api_version IN NUMBER,
1012: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1013: x_return_status OUT NOCOPY VARCHAR2,
1014: x_msg_count OUT NOCOPY NUMBER,
1015: x_msg_data OUT NOCOPY VARCHAR2,
1016: p_tnc_id IN NUMBER

Line 1020: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

1016: p_tnc_id IN NUMBER
1017: ) is
1018:
1019:
1020: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1021: l_api_name CONSTANT VARCHAR2(30) := 'delete_tnc_group';
1022: l_api_version CONSTANT NUMBER := 1.0;
1023:
1024:

Line 1054: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1050:
1051:
1052:
1053: Begin
1054: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1055: -- Call start_activity to create savepoint, check compatibility
1056: -- and initialize message list
1057: x_return_status := OKL_API.START_ACTIVITY (
1058: l_api_name

Line 1057: x_return_status := OKL_API.START_ACTIVITY (

1053: Begin
1054: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1055: -- Call start_activity to create savepoint, check compatibility
1056: -- and initialize message list
1057: x_return_status := OKL_API.START_ACTIVITY (
1058: l_api_name
1059: ,p_init_msg_list
1060: ,'_PVT'
1061: ,x_return_status);

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

1059: ,p_init_msg_list
1060: ,'_PVT'
1061: ,x_return_status);
1062: -- Check if activity started successfully
1063: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1065: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;

Line 1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1060: ,'_PVT'
1061: ,x_return_status);
1062: -- Check if activity started successfully
1063: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1065: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:

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

1061: ,x_return_status);
1062: -- Check if activity started successfully
1063: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1065: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:
1069: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1066: RAISE OKL_API.G_EXCEPTION_ERROR;

1062: -- Check if activity started successfully
1063: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1065: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:
1069: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

1095: ,p_rgpv_rec => l_rgpv_rec);
1096: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1098: END IF;
1099: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;

Line 1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1096: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1098: END IF;
1099: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: ElsIf l_rgp_found = 'N' then

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

1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1098: END IF;
1099: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: ElsIf l_rgp_found = 'N' then
1105: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for

Line 1102: RAISE OKL_API.G_EXCEPTION_ERROR;

1098: END IF;
1099: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: ElsIf l_rgp_found = 'N' then
1105: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for
1106: -- evergreen passthrough

Line 1112: okl_api.set_message(

1108: Fetch l_ppyh_csr into l_ppyh_found;
1109: If l_ppyh_csr%NOTFOUND then
1110: --raise error as this means that the id
1111: --passed is invalid
1112: okl_api.set_message(
1113: p_app_name => G_APP_NAME,
1114: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1115: p_token1 => 'COL_NAME',
1116: p_token1_value => 'Terms and Condition group'

Line 1118: x_return_status := OKL_API.G_RET_STS_ERROR;

1114: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1115: p_token1 => 'COL_NAME',
1116: p_token1_value => 'Terms and Condition group'
1117: );
1118: x_return_status := OKL_API.G_RET_STS_ERROR;
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120:
1121: End If;
1122: Close l_ppyh_csr;

Line 1119: RAISE OKL_API.G_EXCEPTION_ERROR;

1115: p_token1 => 'COL_NAME',
1116: p_token1_value => 'Terms and Condition group'
1117: );
1118: x_return_status := OKL_API.G_RET_STS_ERROR;
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120:
1121: End If;
1122: Close l_ppyh_csr;
1123: If l_ppyh_found = 'Y' Then

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

1143: );
1144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1146: END IF;
1147: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;

Line 1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1146: END IF;
1147: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: End If;

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

1145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1146: END IF;
1147: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: End If;
1153: End Loop;

Line 1150: RAISE OKL_API.G_EXCEPTION_ERROR;

1146: END IF;
1147: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: End If;
1153: End Loop;
1154: Close l_ppyl_csr;

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

1167: );
1168: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1170: END IF;
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;

Line 1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1168: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1170: END IF;
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176: End If;

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

1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1170: END IF;
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176: End If;
1177: End If;

Line 1174: RAISE OKL_API.G_EXCEPTION_ERROR;

1170: END IF;
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176: End If;
1177: End If;
1178: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 1178: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176: End If;
1177: End If;
1178: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1179:
1180: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1182: END IF;

Line 1185: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1182: END IF;
1183:
1184: EXCEPTION
1185: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1186: IF l_rgp_csr%ISOPEN THEN
1187: CLOSE l_rgp_csr;
1188: END IF;
1189: IF l_ppyh_csr%ISOPEN THEN

Line 1195: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1191: END IF;
1192: IF l_ppyl_csr%ISOPEN THEN
1193: CLOSE l_ppyl_csr;
1194: END IF;
1195: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1196: l_api_name,
1197: G_PKG_NAME,
1198: 'OKL_API.G_RET_STS_ERROR',
1199: x_msg_count,

Line 1198: 'OKL_API.G_RET_STS_ERROR',

1194: END IF;
1195: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1196: l_api_name,
1197: G_PKG_NAME,
1198: 'OKL_API.G_RET_STS_ERROR',
1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT');
1202: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1201: '_PVT');
1202: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');
1204: END IF;
1205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1206: IF l_rgp_csr%ISOPEN THEN
1207: CLOSE l_rgp_csr;
1208: END IF;
1209: IF l_ppyh_csr%ISOPEN THEN

Line 1215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1211: END IF;
1212: IF l_ppyl_csr%ISOPEN THEN
1213: CLOSE l_ppyl_csr;
1214: END IF;
1215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1216: l_api_name,
1217: G_PKG_NAME,
1218: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1219: x_msg_count,

Line 1218: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1214: END IF;
1215: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1216: l_api_name,
1217: G_PKG_NAME,
1218: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1219: x_msg_count,
1220: x_msg_data,
1221: '_PVT');
1222: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1235: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1231: END IF;
1232: IF l_ppyl_csr%ISOPEN THEN
1233: CLOSE l_ppyl_csr;
1234: END IF;
1235: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OTHERS',
1239: x_msg_count,