DBA Data[Home] [Help]

APPS.OKC_QA_PRICE_PVT dependencies on OKC_PRICE_PUB

Line 15: l_control_rec OKC_PRICE_PUB.PRICE_CONTROL_REC_TYPE;

11: x_return_status OUT NOCOPY VARCHAR2,
12: p_chr_id IN NUMBER) Is
13:
14: l_cle_price_tbl OKC_PRICE_PVT.CLE_PRICE_TBL_TYPE;
15: l_control_rec OKC_PRICE_PUB.PRICE_CONTROL_REC_TYPE;
16: l_msg_count NUMBER;
17: l_msg_data VARCHAR2(240);
18: l_return_status VARCHAR2(3);
19: l_application_id okc_k_headers_b.application_id%TYPE;

Line 144: okc_debug.log('1050: Before calling okc_price_pub');

140: ELSE
141: --execute price_qa_check as earlier .
142: --
143: IF (l_debug = 'Y') THEN
144: okc_debug.log('1050: Before calling okc_price_pub');
145: END IF;
146: OKC_Price_Pub.Update_Contract_Price(
147: p_api_version => 1.0,
148: p_init_msg_list => OKC_API.G_FALSE,

Line 146: OKC_Price_Pub.Update_Contract_Price(

142: --
143: IF (l_debug = 'Y') THEN
144: okc_debug.log('1050: Before calling okc_price_pub');
145: END IF;
146: OKC_Price_Pub.Update_Contract_Price(
147: p_api_version => 1.0,
148: p_init_msg_list => OKC_API.G_FALSE,
149: p_commit => OKC_API.G_FALSE,
150: p_chr_id => p_chr_id,

Line 160: okc_debug.log('1060: After calling okc_price_pub');

156: x_msg_data => l_msg_data);
157: END IF; ---IF l_price_qa_check_yn = 'N' THEN
158: --
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('1060: After calling okc_price_pub');
161: okc_debug.log('1070: Return status from okc_price_pub - ' || l_return_status);
162: END IF;
163: If (l_return_status <> 'S') Then
164: -- In case of Unexpected error, return error so that it can be shown

Line 161: okc_debug.log('1070: Return status from okc_price_pub - ' || l_return_status);

157: END IF; ---IF l_price_qa_check_yn = 'N' THEN
158: --
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('1060: After calling okc_price_pub');
161: okc_debug.log('1070: Return status from okc_price_pub - ' || l_return_status);
162: END IF;
163: If (l_return_status <> 'S') Then
164: -- In case of Unexpected error, return error so that it can be shown
165: -- as an Error in QA window. For normal error, return Success.

Line 187: okc_debug.log('1090: Price returned from okc_price_pub - ' || To_Char(l_chr_net_price));

183: IF (l_debug = 'Y') THEN
184: okc_debug.log('1080: Price stored at the header level - ' || To_Char(l_estimated_price));
185: END IF;
186: IF (l_debug = 'Y') THEN
187: okc_debug.log('1090: Price returned from okc_price_pub - ' || To_Char(l_chr_net_price));
188: END IF;
189: OKC_API.set_message(
190: p_app_name => G_APP_NAME,
191: p_msg_name => 'OKC_QA_INVALID_PRICE');