APPS.OKL_TRANS_PRICING_PARAMS_PVT dependencies on OKC_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2: /* $Header: OKLRSPMB.pls 120.5 2006/07/11 10:02:09 dkagrawa noship $*/
3:
4: PROCEDURE create_trans_pricing_params(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_tpp_rec IN tpp_rec_type

Line 22: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

18:
19:
20: PROCEDURE create_trans_pricing_params(
21: p_api_version IN NUMBER
22: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,p_tpp_tbl IN tpp_tbl_type

Line 72: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

68: PDT.ID = KHR.PDT_ID AND
69: KHR.ID =p_chr_id;
70:
71: BEGIN
72: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
73: l_tpp_tbl := p_tpp_tbl;
74:
75: delete_pricing_params(l_chr_id,x_return_status);
76:

Line 77: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

73: l_tpp_tbl := p_tpp_tbl;
74:
75: delete_pricing_params(l_chr_id,x_return_status);
76:
77: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
78: RAISE G_EXCEPTION_HALT_VALIDATION;
79: END IF;
80:
81: IF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND

Line 81: IF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND

77: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
78: RAISE G_EXCEPTION_HALT_VALIDATION;
79: END IF;
80:
81: IF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND
82: (l_chr_id IS NULL OR l_chr_id = OKC_API.G_MISS_NUM) )
83: THEN
84: x_return_status := Okc_Api.G_RET_STS_ERROR;
85: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 82: (l_chr_id IS NULL OR l_chr_id = OKC_API.G_MISS_NUM) )

78: RAISE G_EXCEPTION_HALT_VALIDATION;
79: END IF;
80:
81: IF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND
82: (l_chr_id IS NULL OR l_chr_id = OKC_API.G_MISS_NUM) )
83: THEN
84: x_return_status := Okc_Api.G_RET_STS_ERROR;
85: OKL_API.Set_Message(p_app_name => G_APP_NAME,
86: p_msg_name => G_REQUIRED_VALUE,

Line 84: x_return_status := Okc_Api.G_RET_STS_ERROR;

80:
81: IF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND
82: (l_chr_id IS NULL OR l_chr_id = OKC_API.G_MISS_NUM) )
83: THEN
84: x_return_status := Okc_Api.G_RET_STS_ERROR;
85: OKL_API.Set_Message(p_app_name => G_APP_NAME,
86: p_msg_name => G_REQUIRED_VALUE,
87: p_token1 => G_COL_NAME_TOKEN,
88: p_token1_value => 'Contract Number');

Line 90: ELSIF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND

86: p_msg_name => G_REQUIRED_VALUE,
87: p_token1 => G_COL_NAME_TOKEN,
88: p_token1_value => 'Contract Number');
89: RAISE G_EXCEPTION_HALT_VALIDATION;
90: ELSIF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND
91: (l_chr_id IS NOT NULL OR l_chr_id <> OKC_API.G_MISS_NUM) )
92: THEN
93: OPEN get_gts_id(l_chr_id);
94: FETCH get_gts_id INTO l_gts_id;

Line 91: (l_chr_id IS NOT NULL OR l_chr_id <> OKC_API.G_MISS_NUM) )

87: p_token1 => G_COL_NAME_TOKEN,
88: p_token1_value => 'Contract Number');
89: RAISE G_EXCEPTION_HALT_VALIDATION;
90: ELSIF ( (l_gts_id IS NULL OR l_gts_id = OKC_API.G_MISS_NUM) AND
91: (l_chr_id IS NOT NULL OR l_chr_id <> OKC_API.G_MISS_NUM) )
92: THEN
93: OPEN get_gts_id(l_chr_id);
94: FETCH get_gts_id INTO l_gts_id;
95: l_row_notfound := get_gts_id%NOTFOUND;

Line 99: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

95: l_row_notfound := get_gts_id%NOTFOUND;
96: CLOSE get_gts_id;
97:
98: IF l_row_notfound THEN
99: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
100: p_msg_name => 'OKL_INVALID_CONTRACT_ID',
101: p_token1 => 'CONT_ID',
102: p_token1_value => to_char(l_chr_id));
103: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 107: IF (l_gts_id IS NOT NULL OR l_gts_id <> OKC_API.G_MISS_NUM) THEN

103: RAISE G_EXCEPTION_HALT_VALIDATION;
104: END IF;
105: END IF;
106:
107: IF (l_gts_id IS NOT NULL OR l_gts_id <> OKC_API.G_MISS_NUM) THEN
108: OPEN st_gen_prc_params(l_gts_id);
109: LOOP
110: FETCH st_gen_prc_params INTO l_id, l_name,l_display_yn,l_update_yn,
111: l_default_value,l_prc_eng_ident,l_description;

Line 128: l_tpp_tbl(i).parameter_value <> OKC_API.G_MISS_CHAR

124: --Modified by kthiruva for on 06-Jan-2005.
125: -- A String was being compared against G_MISS_NUM instead of G_MISS_CHAR
126: --Bug 4062792 - Start of Changes
127: IF l_tpp_tbl(i).parameter_value IS NOT NULL AND
128: l_tpp_tbl(i).parameter_value <> OKC_API.G_MISS_CHAR
129: --Bug 4062792 - End of Changes
130: THEN
131: l_spmv_tbl(j).parameter_value := l_tpp_tbl(i).parameter_value;
132: END IF;

Line 165: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

161: END IF;
162:
163: EXCEPTION
164: WHEN OTHERS THEN
165: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
166: RAISE G_EXCEPTION_HALT_VALIDATION;
167: END create_trans_pricing_params;
168:
169: --User navigates to the same screen second time before Generate the Streams we need to remove the records

Line 181: x_return_status := OKC_API.G_RET_STS_SUCCESS;

177: DELETE FROM OKL_SIF_PRICING_PARAMS
178: WHERE khr_ID = p_chr_id
179: AND sif_id IS NULL;
180:
181: x_return_status := OKC_API.G_RET_STS_SUCCESS;
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185: WHEN OTHERS THEN

Line 184: x_return_status := OKC_API.G_RET_STS_SUCCESS;

180:
181: x_return_status := OKC_API.G_RET_STS_SUCCESS;
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185: WHEN OTHERS THEN
186: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
187: END delete_pricing_params;
188:

Line 186: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185: WHEN OTHERS THEN
186: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
187: END delete_pricing_params;
188:
189: END; --OKL_TRANS_PRICING_PARAMS_PVT