DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_API

Line 115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

111: IF contract_csr%NOTFOUND THEN
112: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
113: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
114: p_msg_name => G_LLA_CHR_ID);
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: END IF;
117:
118: CLOSE contract_csr;
119:

Line 126: OKC_API.set_message(

122: CLOSE bankrupt_csr;
123:
124: IF (nvl(l_bankruptcy_status,'N') = 'Y') THEN
125: l_sts_code := 'BANKRUPTCY_HOLD';
126: OKC_API.set_message(
127: p_app_name => G_APP_NAME,
128: p_msg_name => G_CANC_CNTR_INV_STATUS,
129: p_token1 => G_CONTRACT_NUMBER_TOKEN,
130: p_token1_value => l_contract_number,

Line 146: OKC_API.set_message(

142:
143: CLOSE contract_status_csr;
144:
145: IF (l_sts_code IS NOT NULL) THEN
146: OKC_API.set_message(
147: p_app_name => G_APP_NAME,
148: p_msg_name => G_CANC_CNTR_INV_STATUS,
149: p_token1 => G_CONTRACT_NUMBER_TOKEN,
150: p_token1_value => l_contract_number,

Line 169: OKC_API.set_message(

165: OPEN funding_disb_txn_type_csr(l_funding_type_code);
166: FETCH funding_disb_txn_type_csr INTO l_txn_type;
167: CLOSE funding_disb_txn_type_csr;
168:
169: OKC_API.set_message(
170: p_app_name => G_APP_NAME,
171: p_msg_name => G_CANC_CNTR_PYMT_EXIST,
172: p_token1 => G_TXN_TYPE,
173: p_token1_value => l_txn_type,

Line 177: x_return_status := OKC_API.G_RET_STS_ERROR;

173: p_token1_value => l_txn_type,
174: p_token2 => G_CONTRACT_NUMBER_TOKEN,
175: p_token2_value => l_contract_number);
176:
177: x_return_status := OKC_API.G_RET_STS_ERROR;
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OPEN Billing_invoice_status_csr(p_contract_id);

Line 189: OKC_API.set_message(

185: END IF;
186: CLOSE Billing_invoice_status_csr;
187:
188: IF (l_Billing_invoice_status = '!') THEN
189: OKC_API.set_message(
190: p_app_name => G_APP_NAME,
191: p_msg_name => G_CANC_CNTR_RCPT_EXIST,
192: p_token1 => G_CONTRACT_NUMBER_TOKEN,
193: p_token1_value => l_contract_number);

Line 195: x_return_status := OKC_API.G_RET_STS_ERROR;

191: p_msg_name => G_CANC_CNTR_RCPT_EXIST,
192: p_token1 => G_CONTRACT_NUMBER_TOKEN,
193: p_token1_value => l_contract_number);
194:
195: x_return_status := OKC_API.G_RET_STS_ERROR;
196: RAISE OKL_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: OPEN Advance_receipt_csr(p_contract_id);

Line 207: OKC_API.set_message(

203: END IF;
204: CLOSE Advance_receipt_csr;
205:
206: IF (l_advance_receipt_status = '!') THEN
207: OKC_API.set_message(
208: p_app_name => G_APP_NAME,
209: p_msg_name => G_CANC_CNTR_RCPT_EXIST,
210: p_token1 => G_CONTRACT_NUMBER_TOKEN,
211: p_token1_value => l_contract_number);

Line 213: x_return_status := OKC_API.G_RET_STS_ERROR;

209: p_msg_name => G_CANC_CNTR_RCPT_EXIST,
210: p_token1 => G_CONTRACT_NUMBER_TOKEN,
211: p_token1_value => l_contract_number);
212:
213: x_return_status := OKC_API.G_RET_STS_ERROR;
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
217: EXCEPTION

Line 423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

419: okl_api.set_message(
420: G_APP_NAME,
421: G_LLA_CHR_ID
422: );
423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
424:
425: END IF;
426:
427: CLOSE orig_csr;