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 93: x_return_status := OKL_API.START_ACTIVITY(

89: l_inv_frmt_id number;
90:
91: BEGIN
92:
93: x_return_status := OKL_API.START_ACTIVITY(
94: p_api_name => l_api_name,
95: p_pkg_name => g_pkg_name,
96: p_init_msg_list => p_init_msg_list,
97: l_api_version => l_api_version,

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

99: p_api_type => g_api_type,
100: x_return_status => x_return_status);
101:
102: -- check if activity started successfully
103: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
105: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_ERROR;
107: END IF;

Line 104: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

100: x_return_status => x_return_status);
101:
102: -- check if activity started successfully
103: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
105: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_ERROR;
107: END IF;
108:

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

101:
102: -- check if activity started successfully
103: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
105: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_ERROR;
107: END IF;
108:
109: IF (p_rgpv_rec.rgp_id IS NULL) THEN

Line 106: RAISE OKL_API.G_EXCEPTION_ERROR;

102: -- check if activity started successfully
103: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
105: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_ERROR;
107: END IF;
108:
109: IF (p_rgpv_rec.rgp_id IS NULL) THEN
110:

Line 528: x_return_status := OKL_API.START_ACTIVITY(

524: l_msg_data VARCHAR2(4000);
525: l_msg_index_out number;
526:
527: BEGIN
528: x_return_status := OKL_API.START_ACTIVITY(
529: p_api_name => l_api_name,
530: p_pkg_name => g_pkg_name,
531: p_init_msg_list => p_init_msg_list,
532: l_api_version => l_api_version,

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

534: p_api_type => g_api_type,
535: x_return_status => x_return_status);
536:
537: -- check if activity started successfully
538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
541: RAISE OKL_API.G_EXCEPTION_ERROR;
542: END IF;

Line 539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

535: x_return_status => x_return_status);
536:
537: -- check if activity started successfully
538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
541: RAISE OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:

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

536:
537: -- check if activity started successfully
538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
541: RAISE OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:
544: IF (p_rgpv_rec.rgp_id IS NULL) THEN

Line 541: RAISE OKL_API.G_EXCEPTION_ERROR;

537: -- check if activity started successfully
538: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
541: RAISE OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:
544: IF (p_rgpv_rec.rgp_id IS NULL) THEN
545:

Line 765: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

761: END process_rvi;
762:
763: PROCEDURE load_billing_setup(
764: p_api_version IN NUMBER,
765: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
766: x_return_status OUT NOCOPY VARCHAR2,
767: x_msg_count OUT NOCOPY NUMBER,
768: x_msg_data OUT NOCOPY VARCHAR2,
769: p_chr_id IN NUMBER,

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

768: x_msg_data OUT NOCOPY VARCHAR2,
769: p_chr_id IN NUMBER,
770: x_billing_setup_rec OUT NOCOPY billing_setup_rec_type) IS
771:
772: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
773: l_api_name CONSTANT VARCHAR2(30) := 'load_billing_setup';
774: l_api_version CONSTANT NUMBER := 1.0;
775:
776: CURSOR c_bill_to(p_chr_id NUMBER) IS

Line 824: x_return_status := OKL_API.G_RET_STS_SUCCESS;

820: l_format_name VARCHAR2(150);
821: --sechawla 26-may-09 6826580 :end
822:
823: BEGIN
824: x_return_status := OKL_API.G_RET_STS_SUCCESS;
825: -- Call start_activity to create savepoint, check compatibility
826: -- and initialize message list
827: x_return_status := OKL_API.START_ACTIVITY (
828: l_api_name

Line 827: x_return_status := OKL_API.START_ACTIVITY (

823: BEGIN
824: x_return_status := OKL_API.G_RET_STS_SUCCESS;
825: -- Call start_activity to create savepoint, check compatibility
826: -- and initialize message list
827: x_return_status := OKL_API.START_ACTIVITY (
828: l_api_name
829: ,p_init_msg_list
830: ,'_PVT'
831: ,x_return_status);

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

829: ,p_init_msg_list
830: ,'_PVT'
831: ,x_return_status);
832: -- Check if activity started successfully
833: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_ERROR;
837: END IF;

Line 834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

830: ,'_PVT'
831: ,x_return_status);
832: -- Check if activity started successfully
833: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_ERROR;
837: END IF;
838:

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

831: ,x_return_status);
832: -- Check if activity started successfully
833: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_ERROR;
837: END IF;
838:
839: x_billing_setup_rec.chr_id := p_chr_id;

Line 836: RAISE OKL_API.G_EXCEPTION_ERROR;

832: -- Check if activity started successfully
833: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: RAISE OKL_API.G_EXCEPTION_ERROR;
837: END IF;
838:
839: x_billing_setup_rec.chr_id := p_chr_id;
840: OPEN c_bill_to(p_chr_id);

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

921: x_billing_setup_rec.lainpr_rule_information2 := l_rule.rule_information2;
922: END IF;
923: CLOSE c_rule;
924:
925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_ERROR;
929: END IF;

Line 926: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

922: END IF;
923: CLOSE c_rule;
924:
925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_ERROR;
929: END IF;
930:

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

923: CLOSE c_rule;
924:
925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_ERROR;
929: END IF;
930:
931: -- assign the rule group id

Line 928: RAISE OKL_API.G_EXCEPTION_ERROR;

924:
925: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
927: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
928: RAISE OKL_API.G_EXCEPTION_ERROR;
929: END IF;
930:
931: -- assign the rule group id
932: x_billing_setup_rec.rgp_id := l_rgp_id; -- Bug#9852347

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

930:
931: -- assign the rule group id
932: x_billing_setup_rec.rgp_id := l_rgp_id; -- Bug#9852347
933:
934: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
935:
936: EXCEPTION
937: WHEN OKL_API.G_EXCEPTION_ERROR THEN
938:

Line 937: WHEN OKL_API.G_EXCEPTION_ERROR THEN

933:
934: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
935:
936: EXCEPTION
937: WHEN OKL_API.G_EXCEPTION_ERROR THEN
938:
939: --sechawla 26-may-09 6826580
940: IF c_invoice_formats%ISOPEN THEN
941: CLOSE c_invoice_formats;

Line 944: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

940: IF c_invoice_formats%ISOPEN THEN
941: CLOSE c_invoice_formats;
942: END IF;
943:
944: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
945: l_api_name,
946: G_PKG_NAME,
947: 'OKL_API.G_RET_STS_ERROR',
948: x_msg_count,

Line 947: 'OKL_API.G_RET_STS_ERROR',

943:
944: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
945: l_api_name,
946: G_PKG_NAME,
947: 'OKL_API.G_RET_STS_ERROR',
948: x_msg_count,
949: x_msg_data,
950: '_PVT');
951: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 951: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

947: 'OKL_API.G_RET_STS_ERROR',
948: x_msg_count,
949: x_msg_data,
950: '_PVT');
951: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
952:
953: --sechawla 26-may-09 6826580
954: IF c_invoice_formats%ISOPEN THEN
955: CLOSE c_invoice_formats;

Line 957: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

953: --sechawla 26-may-09 6826580
954: IF c_invoice_formats%ISOPEN THEN
955: CLOSE c_invoice_formats;
956: END IF;
957: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
958: l_api_name,
959: G_PKG_NAME,
960: 'OKL_API.G_RET_STS_UNEXP_ERROR',
961: x_msg_count,

Line 960: 'OKL_API.G_RET_STS_UNEXP_ERROR',

956: END IF;
957: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
958: l_api_name,
959: G_PKG_NAME,
960: 'OKL_API.G_RET_STS_UNEXP_ERROR',
961: x_msg_count,
962: x_msg_data,
963: '_PVT');
964: WHEN OTHERS THEN

Line 970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

966: --sechawla 26-may-09 6826580
967: IF c_invoice_formats%ISOPEN THEN
968: CLOSE c_invoice_formats;
969: END IF;
970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
971: l_api_name,
972: G_PKG_NAME,
973: 'OTHERS',
974: x_msg_count,

Line 981: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

977: END load_billing_setup;
978:
979: PROCEDURE load_rvi(
980: p_api_version IN NUMBER,
981: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
982: x_return_status OUT NOCOPY VARCHAR2,
983: x_msg_count OUT NOCOPY NUMBER,
984: x_msg_data OUT NOCOPY VARCHAR2,
985: p_chr_id IN NUMBER,

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

984: x_msg_data OUT NOCOPY VARCHAR2,
985: p_chr_id IN NUMBER,
986: x_rvi_rec OUT NOCOPY rvi_rec_type) IS
987:
988: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
989: l_api_name CONSTANT VARCHAR2(30) := 'load_rvi';
990: l_api_version CONSTANT NUMBER := 1.0;
991:
992: CURSOR c_rule(p_chr_id NUMBER) IS

Line 1034: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1030: and olsb.LTY_CODE = 'FEE'
1031: and cle.dnz_chr_id = p_chr_id;
1032:
1033: BEGIN
1034: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1035: -- Call start_activity to create savepoint, check compatibility
1036: -- and initialize message list
1037: x_return_status := OKL_API.START_ACTIVITY (
1038: l_api_name

Line 1037: x_return_status := OKL_API.START_ACTIVITY (

1033: BEGIN
1034: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1035: -- Call start_activity to create savepoint, check compatibility
1036: -- and initialize message list
1037: x_return_status := OKL_API.START_ACTIVITY (
1038: l_api_name
1039: ,p_init_msg_list
1040: ,'_PVT'
1041: ,x_return_status);

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

1039: ,p_init_msg_list
1040: ,'_PVT'
1041: ,x_return_status);
1042: -- Check if activity started successfully
1043: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1045: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: END IF;

Line 1044: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1040: ,'_PVT'
1041: ,x_return_status);
1042: -- Check if activity started successfully
1043: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1045: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: END IF;
1048:

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

1041: ,x_return_status);
1042: -- Check if activity started successfully
1043: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1045: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: END IF;
1048:
1049: OPEN c_rule(p_chr_id);

Line 1046: RAISE OKL_API.G_EXCEPTION_ERROR;

1042: -- Check if activity started successfully
1043: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1045: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1046: RAISE OKL_API.G_EXCEPTION_ERROR;
1047: END IF;
1048:
1049: OPEN c_rule(p_chr_id);
1050: 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 1059: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

1055: OPEN c_stream_name(p_chr_id);
1056: 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;
1057: CLOSE c_stream_name;
1058:
1059: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1060:
1061: EXCEPTION
1062: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1063: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1062: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1063: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 1066: 'OKL_API.G_RET_STS_ERROR',

1062: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1063: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1064: l_api_name,
1065: G_PKG_NAME,
1066: 'OKL_API.G_RET_STS_ERROR',
1067: x_msg_count,
1068: x_msg_data,
1069: '_PVT');
1070: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1070: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1066: 'OKL_API.G_RET_STS_ERROR',
1067: x_msg_count,
1068: x_msg_data,
1069: '_PVT');
1070: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1071: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1072: l_api_name,
1073: G_PKG_NAME,
1074: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1071: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1067: x_msg_count,
1068: x_msg_data,
1069: '_PVT');
1070: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1071: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1072: l_api_name,
1073: G_PKG_NAME,
1074: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1075: x_msg_count,

Line 1074: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1070: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1071: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1072: l_api_name,
1073: G_PKG_NAME,
1074: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1075: x_msg_count,
1076: x_msg_data,
1077: '_PVT');
1078: WHEN OTHERS THEN

Line 1079: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1075: x_msg_count,
1076: x_msg_data,
1077: '_PVT');
1078: WHEN OTHERS THEN
1079: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1080: l_api_name,
1081: G_PKG_NAME,
1082: 'OTHERS',
1083: x_msg_count,

Line 1090: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1086: END load_rvi;
1087:
1088: PROCEDURE delete_tnc_group(
1089: p_api_version IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1091: x_return_status OUT NOCOPY VARCHAR2,
1092: x_msg_count OUT NOCOPY NUMBER,
1093: x_msg_data OUT NOCOPY VARCHAR2,
1094: p_tnc_id IN NUMBER

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

1094: p_tnc_id IN NUMBER
1095: ) is
1096:
1097:
1098: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1099: l_api_name CONSTANT VARCHAR2(30) := 'delete_tnc_group';
1100: l_api_version CONSTANT NUMBER := 1.0;
1101:
1102:

Line 1132: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1128:
1129:
1130:
1131: Begin
1132: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1133: -- Call start_activity to create savepoint, check compatibility
1134: -- and initialize message list
1135: x_return_status := OKL_API.START_ACTIVITY (
1136: l_api_name

Line 1135: x_return_status := OKL_API.START_ACTIVITY (

1131: Begin
1132: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1133: -- Call start_activity to create savepoint, check compatibility
1134: -- and initialize message list
1135: x_return_status := OKL_API.START_ACTIVITY (
1136: l_api_name
1137: ,p_init_msg_list
1138: ,'_PVT'
1139: ,x_return_status);

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

1137: ,p_init_msg_list
1138: ,'_PVT'
1139: ,x_return_status);
1140: -- Check if activity started successfully
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;

Line 1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1138: ,'_PVT'
1139: ,x_return_status);
1140: -- Check if activity started successfully
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:

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

1139: ,x_return_status);
1140: -- Check if activity started successfully
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1144: RAISE OKL_API.G_EXCEPTION_ERROR;

1140: -- Check if activity started successfully
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

1173: ,p_rgpv_rec => l_rgpv_rec);
1174: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1176: END IF;
1177: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_ERROR;
1181: END IF;

Line 1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1174: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1176: END IF;
1177: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_ERROR;
1181: END IF;
1182: ElsIf l_rgp_found = 'N' then

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

1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1176: END IF;
1177: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_ERROR;
1181: END IF;
1182: ElsIf l_rgp_found = 'N' then
1183: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for

Line 1180: RAISE OKL_API.G_EXCEPTION_ERROR;

1176: END IF;
1177: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_ERROR;
1181: END IF;
1182: ElsIf l_rgp_found = 'N' then
1183: --2. Check if record exists in OKL_PARTY_PAYMENT_HDR for
1184: -- evergreen passthrough

Line 1190: okl_api.set_message(

1186: Fetch l_ppyh_csr into l_ppyh_found;
1187: If l_ppyh_csr%NOTFOUND then
1188: --raise error as this means that the id
1189: --passed is invalid
1190: okl_api.set_message(
1191: p_app_name => G_APP_NAME,
1192: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1193: p_token1 => 'COL_NAME',
1194: p_token1_value => 'Terms and Condition group'

Line 1196: x_return_status := OKL_API.G_RET_STS_ERROR;

1192: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1193: p_token1 => 'COL_NAME',
1194: p_token1_value => 'Terms and Condition group'
1195: );
1196: x_return_status := OKL_API.G_RET_STS_ERROR;
1197: RAISE OKL_API.G_EXCEPTION_ERROR;
1198:
1199: End If;
1200: Close l_ppyh_csr;

Line 1197: RAISE OKL_API.G_EXCEPTION_ERROR;

1193: p_token1 => 'COL_NAME',
1194: p_token1_value => 'Terms and Condition group'
1195: );
1196: x_return_status := OKL_API.G_RET_STS_ERROR;
1197: RAISE OKL_API.G_EXCEPTION_ERROR;
1198:
1199: End If;
1200: Close l_ppyh_csr;
1201: If l_ppyh_found = 'Y' Then

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

1221: );
1222: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1224: END IF;
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;

Line 1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1222: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1224: END IF;
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: End If;

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

1223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1224: END IF;
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: End If;
1231: End Loop;

Line 1228: RAISE OKL_API.G_EXCEPTION_ERROR;

1224: END IF;
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: End If;
1231: End Loop;
1232: Close l_ppyl_csr;

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

1245: );
1246: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1248: END IF;
1249: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_ERROR;
1253: END IF;

Line 1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1246: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1248: END IF;
1249: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_ERROR;
1253: END IF;
1254: End If;

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

1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1248: END IF;
1249: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_ERROR;
1253: END IF;
1254: End If;
1255: End If;

Line 1252: RAISE OKL_API.G_EXCEPTION_ERROR;

1248: END IF;
1249: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_ERROR;
1253: END IF;
1254: End If;
1255: End If;
1256: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

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

1252: RAISE OKL_API.G_EXCEPTION_ERROR;
1253: END IF;
1254: End If;
1255: End If;
1256: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1257:
1258: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1260: END IF;

Line 1263: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1260: END IF;
1261:
1262: EXCEPTION
1263: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1264: IF l_rgp_csr%ISOPEN THEN
1265: CLOSE l_rgp_csr;
1266: END IF;
1267: IF l_ppyh_csr%ISOPEN THEN

Line 1273: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1269: END IF;
1270: IF l_ppyl_csr%ISOPEN THEN
1271: CLOSE l_ppyl_csr;
1272: END IF;
1273: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1274: l_api_name,
1275: G_PKG_NAME,
1276: 'OKL_API.G_RET_STS_ERROR',
1277: x_msg_count,

Line 1276: 'OKL_API.G_RET_STS_ERROR',

1272: END IF;
1273: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1274: l_api_name,
1275: G_PKG_NAME,
1276: 'OKL_API.G_RET_STS_ERROR',
1277: x_msg_count,
1278: x_msg_data,
1279: '_PVT');
1280: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1279: '_PVT');
1280: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');
1282: END IF;
1283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1284: IF l_rgp_csr%ISOPEN THEN
1285: CLOSE l_rgp_csr;
1286: END IF;
1287: IF l_ppyh_csr%ISOPEN THEN

Line 1293: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1289: END IF;
1290: IF l_ppyl_csr%ISOPEN THEN
1291: CLOSE l_ppyl_csr;
1292: END IF;
1293: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1297: x_msg_count,

Line 1296: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1292: END IF;
1293: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT');
1300: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1313: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1309: END IF;
1310: IF l_ppyl_csr%ISOPEN THEN
1311: CLOSE l_ppyl_csr;
1312: END IF;
1313: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1314: l_api_name,
1315: G_PKG_NAME,
1316: 'OTHERS',
1317: x_msg_count,