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_SEEDED_FUNCTIONS_PVT dependencies on OKC_API

Line 52: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,

48:
49: OPEN c_monthly_premium (p_contract_id,p_contract_line_id );
50: FETCH c_monthly_premium INTO l_amount, ls_payment_freq, date_to, date_from;
51: IF(c_monthly_premium%NOTFOUND) THEN
52: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,
53: G_COL_NAME_TOKEN,p_contract_line_id);
54: -- x_return_status := OKC_API.G_RET_STS_ERROR ;
55: CLOSE c_monthly_premium ;
56: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 54: -- x_return_status := OKC_API.G_RET_STS_ERROR ;

50: FETCH c_monthly_premium INTO l_amount, ls_payment_freq, date_to, date_from;
51: IF(c_monthly_premium%NOTFOUND) THEN
52: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,
53: G_COL_NAME_TOKEN,p_contract_line_id);
54: -- x_return_status := OKC_API.G_RET_STS_ERROR ;
55: CLOSE c_monthly_premium ;
56: RAISE OKC_API.G_EXCEPTION_ERROR;
57: END IF ;
58: CLOSE c_monthly_premium;

Line 56: RAISE OKC_API.G_EXCEPTION_ERROR;

52: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,
53: G_COL_NAME_TOKEN,p_contract_line_id);
54: -- x_return_status := OKC_API.G_RET_STS_ERROR ;
55: CLOSE c_monthly_premium ;
56: RAISE OKC_API.G_EXCEPTION_ERROR;
57: END IF ;
58: CLOSE c_monthly_premium;
59:
60: IF(ls_payment_freq = 'MONTHLY') THEN

Line 177: IF(( l_profile_value = NULL) OR (l_profile_value = OKC_API.G_MISS_NUM )) THEN

173:
174: -- GET profile value
175: l_profile_value := fnd_profile.value('OKLINMAXTERMFORINS');
176:
177: IF(( l_profile_value = NULL) OR (l_profile_value = OKC_API.G_MISS_NUM )) THEN
178: l_unconsumed_months := 0 ;
179: END IF;
180:
181: /*OPEN C_OKL_STRM_TYPE_REC_V ;

Line 184: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',

180:
181: /*OPEN C_OKL_STRM_TYPE_REC_V ;
182: FETCH C_OKL_STRM_TYPE_REC_V INTO l_stm_type_id;
183: IF(C_OKL_STRM_TYPE_REC_V%NOTFOUND) THEN
184: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
185: G_COL_NAME_TOKEN,'Billing');
186: CLOSE C_OKL_STRM_TYPE_REC_V ;
187: RAISE OKC_API.G_EXCEPTION_ERROR;
188: END IF ;

Line 187: RAISE OKC_API.G_EXCEPTION_ERROR;

183: IF(C_OKL_STRM_TYPE_REC_V%NOTFOUND) THEN
184: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
185: G_COL_NAME_TOKEN,'Billing');
186: CLOSE C_OKL_STRM_TYPE_REC_V ;
187: RAISE OKC_API.G_EXCEPTION_ERROR;
188: END IF ;
189: CLOSE C_OKL_STRM_TYPE_REC_V;*/
190: -- cursor fetch replaced with the streams util call, change
191: -- done for user defined streams impacts, bug 3924300

Line 198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

194: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
195: 'INSURANCE_RECEIVABLE',
196: l_return_status,
197: l_stm_type_id);
198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
201: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_RECEIVABLE'); -- bug 4024785
202: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

195: 'INSURANCE_RECEIVABLE',
196: l_return_status,
197: l_stm_type_id);
198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
201: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_RECEIVABLE'); -- bug 4024785
202: RAISE OKC_API.G_EXCEPTION_ERROR;
203: END IF;

Line 200: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

196: l_return_status,
197: l_stm_type_id);
198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
201: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_RECEIVABLE'); -- bug 4024785
202: RAISE OKC_API.G_EXCEPTION_ERROR;
203: END IF;
204: -- end changes for bug 3924300

Line 201: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_RECEIVABLE'); -- bug 4024785

197: l_stm_type_id);
198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
201: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_RECEIVABLE'); -- bug 4024785
202: RAISE OKC_API.G_EXCEPTION_ERROR;
203: END IF;
204: -- end changes for bug 3924300
205:

Line 202: RAISE OKC_API.G_EXCEPTION_ERROR;

198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
199: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
201: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_STREAM_TYPE', G_PURPOSE_TOKEN,'INSURANCE_RECEIVABLE'); -- bug 4024785
202: RAISE OKC_API.G_EXCEPTION_ERROR;
203: END IF;
204: -- end changes for bug 3924300
205:
206:

Line 218: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,

214:
215: OPEN c_monthly_premium (p_contract_id,p_contract_line_id );
216: FETCH c_monthly_premium INTO ls_payment_freq, date_to, date_from;--, cancel_date;--++ Effective Dated TErmination ++--
217: IF(c_monthly_premium%NOTFOUND) THEN
218: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,
219: G_COL_NAME_TOKEN,p_contract_line_id);
220: -- x_return_status := OKC_API.G_RET_STS_ERROR ;
221: CLOSE c_monthly_premium ;
222: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 220: -- x_return_status := OKC_API.G_RET_STS_ERROR ;

216: FETCH c_monthly_premium INTO ls_payment_freq, date_to, date_from;--, cancel_date;--++ Effective Dated TErmination ++--
217: IF(c_monthly_premium%NOTFOUND) THEN
218: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,
219: G_COL_NAME_TOKEN,p_contract_line_id);
220: -- x_return_status := OKC_API.G_RET_STS_ERROR ;
221: CLOSE c_monthly_premium ;
222: RAISE OKC_API.G_EXCEPTION_ERROR;
223: END IF ;
224: CLOSE c_monthly_premium;

Line 222: RAISE OKC_API.G_EXCEPTION_ERROR;

218: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,
219: G_COL_NAME_TOKEN,p_contract_line_id);
220: -- x_return_status := OKC_API.G_RET_STS_ERROR ;
221: CLOSE c_monthly_premium ;
222: RAISE OKC_API.G_EXCEPTION_ERROR;
223: END IF ;
224: CLOSE c_monthly_premium;
225:
226: ---++ Ins Effective Dated Term Changes Start ++----

Line 227: IF(( l_cancellation_date IS NULL) OR (l_cancellation_date = OKC_API.G_MISS_DATE )) THEN

223: END IF ;
224: CLOSE c_monthly_premium;
225:
226: ---++ Ins Effective Dated Term Changes Start ++----
227: IF(( l_cancellation_date IS NULL) OR (l_cancellation_date = OKC_API.G_MISS_DATE )) THEN
228: cancel_date := SYSDATE ;
229: ELSE
230: cancel_date := l_cancellation_date;
231: END IF;

Line 250: IF(( l_total_num_months_paid IS NULL) OR (l_total_num_months_paid = OKC_API.G_MISS_NUM )) THEN

246: l_freq_factor := MONTHS_BETWEEN( date_to,date_from);
247: END IF;
248:
249: l_total_num_months_paid := l_freq_factor * l_no_of_rec;
250: IF(( l_total_num_months_paid IS NULL) OR (l_total_num_months_paid = OKC_API.G_MISS_NUM )) THEN
251: l_total_num_months_paid := 0 ;
252: END IF;
253: --- ++++ Eff Dated Term Qte Changes +++++ ----------
254: IF cancel_date < date_from THEN

Line 271: IF(( l_total_consumed_months IS NULL) OR (l_total_consumed_months = OKC_API.G_MISS_NUM )) THEN

267: l_total_consumed_months := MONTHS_BETWEEN( cancel_date,date_from);
268: END IF;
269: --- ++++ Eff Dated Term Qte Changes +++++ ----------
270:
271: IF(( l_total_consumed_months IS NULL) OR (l_total_consumed_months = OKC_API.G_MISS_NUM )) THEN
272: l_total_consumed_months := 0 ;
273: END IF;
274:
275: l_unconsumed_months := l_total_num_months_paid - l_total_consumed_months ;

Line 276: IF(( l_unconsumed_months IS NULL) OR (l_unconsumed_months = OKC_API.G_MISS_NUM )) THEN

272: l_total_consumed_months := 0 ;
273: END IF;
274:
275: l_unconsumed_months := l_total_num_months_paid - l_total_consumed_months ;
276: IF(( l_unconsumed_months IS NULL) OR (l_unconsumed_months = OKC_API.G_MISS_NUM )) THEN
277: l_unconsumed_months := 0 ;
278: END IF;
279:
280: IF (l_unconsumed_months > l_profile_value) AND

Line 4945: OKC_API.SET_MESSAGE (

4941: END IF;
4942:
4943: IF l_object_name IS NULL THEN
4944: l_overall_status := OKL_API.G_RET_STS_ERROR;
4945: OKC_API.SET_MESSAGE (
4946: p_app_name => OKC_API.G_APP_NAME,
4947: p_msg_name => OKC_API.G_INVALID_VALUE,
4948: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4949: p_token1_value => l_token);

Line 4946: p_app_name => OKC_API.G_APP_NAME,

4942:
4943: IF l_object_name IS NULL THEN
4944: l_overall_status := OKL_API.G_RET_STS_ERROR;
4945: OKC_API.SET_MESSAGE (
4946: p_app_name => OKC_API.G_APP_NAME,
4947: p_msg_name => OKC_API.G_INVALID_VALUE,
4948: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4949: p_token1_value => l_token);
4950: END IF;

Line 4947: p_msg_name => OKC_API.G_INVALID_VALUE,

4943: IF l_object_name IS NULL THEN
4944: l_overall_status := OKL_API.G_RET_STS_ERROR;
4945: OKC_API.SET_MESSAGE (
4946: p_app_name => OKC_API.G_APP_NAME,
4947: p_msg_name => OKC_API.G_INVALID_VALUE,
4948: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4949: p_token1_value => l_token);
4950: END IF;
4951:

Line 4948: p_token1 => OKC_API.G_COL_NAME_TOKEN,

4944: l_overall_status := OKL_API.G_RET_STS_ERROR;
4945: OKC_API.SET_MESSAGE (
4946: p_app_name => OKC_API.G_APP_NAME,
4947: p_msg_name => OKC_API.G_INVALID_VALUE,
4948: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4949: p_token1_value => l_token);
4950: END IF;
4951:
4952: -- ********************************************

Line 5707: p_init_msg_list => OKC_API.G_FALSE,

5703: lp_pdtv_rec.id := l_fin_product_id;
5704:
5705: -- check if the fin product has a reporting product
5706: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters( p_api_version => p_api_version,
5707: p_init_msg_list => OKC_API.G_FALSE,
5708: x_return_status => x_return_status,
5709: x_no_data_found => lx_no_data_found,
5710: x_msg_count => x_msg_count,
5711: x_msg_data => x_msg_data,

Line 5716: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

5712: p_pdtv_rec => lp_pdtv_rec,
5713: p_product_date => l_start_date,
5714: p_pdt_parameter_rec => lx_pdt_parameter_rec);
5715:
5716: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5717: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
5718: OKC_API.set_message( p_app_name => 'OKL',
5719: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
5720: p_token1 => 'CONTRACT_NUMBER',

Line 5718: OKC_API.set_message( p_app_name => 'OKL',

5714: p_pdt_parameter_rec => lx_pdt_parameter_rec);
5715:
5716: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5717: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
5718: OKC_API.set_message( p_app_name => 'OKL',
5719: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
5720: p_token1 => 'CONTRACT_NUMBER',
5721: p_token1_value => l_contract_number);
5722:

Line 5728: IF l_reporting_product IS NOT NULL AND l_reporting_product <> OKC_API.G_MISS_CHAR THEN

5724:
5725: l_reporting_product := lx_pdt_parameter_rec.reporting_product;
5726: l_reporting_product_id := lx_pdt_parameter_rec.reporting_pdt_id;
5727:
5728: IF l_reporting_product IS NOT NULL AND l_reporting_product <> OKC_API.G_MISS_CHAR THEN
5729: -- Contract has a reporting product
5730: x_rep_product_id := l_reporting_product_id;
5731: END IF;
5732: END IF;

Line 5850: p_init_msg_list => OKC_API.G_FALSE,

5846: IF l_rep_prod_streams_yn = 'Y' THEN
5847:
5848: get_reporting_product(
5849: p_api_version => l_api_version,
5850: p_init_msg_list => OKC_API.G_FALSE,
5851: x_return_status => l_return_status,
5852: x_msg_count => l_msg_count,
5853: x_msg_data => l_msg_data,
5854: p_contract_id => p_contract_id,

Line 7278: RAISE OKC_API.G_EXCEPTION_ERROR;

7274: p_msg_name => G_REQUIRED_VALUE,
7275: p_token1 => G_COL_NAME_TOKEN,
7276: p_token1_value => 'RATE');
7277:
7278: RAISE OKC_API.G_EXCEPTION_ERROR;
7279: END IF;
7280:
7281: IF p_contract_line_id IS NOT NULL THEN
7282:

Line 7475: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7471:
7472: RETURN l_net_investment;
7473: EXCEPTION
7474: WHEN OTHERS THEN
7475: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7476: ,p_msg_name => G_UNEXPECTED_ERROR
7477: ,p_token1 => G_SQLCODE_TOKEN
7478: ,p_token1_value => SQLCODE
7479: ,p_token2 => G_SQLERRM_TOKEN

Line 7520: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7516: RETURN l_cures_in_possession;
7517:
7518: EXCEPTION
7519: WHEN OTHERS THEN
7520: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7521: ,p_msg_name => G_UNEXPECTED_ERROR
7522: ,p_token1 => G_SQLCODE_TOKEN
7523: ,p_token1_value => SQLCODE
7524: ,p_token2 => G_SQLERRM_TOKEN

Line 7573: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7569: RETURN l_outstanding_amount;
7570:
7571: EXCEPTION
7572: WHEN OTHERS THEN
7573: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7574: ,p_msg_name => G_UNEXPECTED_ERROR
7575: ,p_token1 => G_SQLCODE_TOKEN
7576: ,p_token1_value => SQLCODE
7577: ,p_token2 => G_SQLERRM_TOKEN

Line 7630: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7626: RETURN l_full_cure;
7627:
7628: EXCEPTION
7629: WHEN OTHERS THEN
7630: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7631: ,p_msg_name => G_UNEXPECTED_ERROR
7632: ,p_token1 => G_SQLCODE_TOKEN
7633: ,p_token1_value => SQLCODE
7634: ,p_token2 => G_SQLERRM_TOKEN

Line 7720: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7716: RETURN l_interest_cure;
7717:
7718: EXCEPTION
7719: WHEN OTHERS THEN
7720: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7721: ,p_msg_name => G_UNEXPECTED_ERROR
7722: ,p_token1 => G_SQLCODE_TOKEN
7723: ,p_token1_value => SQLCODE
7724: ,p_token2 => G_SQLERRM_TOKEN

Line 7763: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7759:
7760: RETURN l_return_status;
7761: EXCEPTION
7762: WHEN OTHERS THEN
7763: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7764: ,p_msg_name => G_UNEXPECTED_ERROR
7765: ,p_token1 => G_SQLCODE_TOKEN
7766: ,p_token1_value => SQLCODE
7767: ,p_token2 => G_SQLERRM_TOKEN

Line 7769: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7765: ,p_token1 => G_SQLCODE_TOKEN
7766: ,p_token1_value => SQLCODE
7767: ,p_token2 => G_SQLERRM_TOKEN
7768: ,p_token2_value => SQLERRM);
7769: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7770: RETURN(l_return_status);
7771:
7772: END get_unrefunded_cures;
7773:

Line 9235: p_line_id <> OKC_API.G_MISS_NUM) THEN --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario

9231:
9232: --Bug# 15992711 , Start
9233: IF (l_line_type IN ('NEW','RELEASE') )
9234: AND (p_line_id IS NOT NULL AND
9235: p_line_id <> OKC_API.G_MISS_NUM) THEN --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9236: --Get the line status
9237: OPEN l_line_nr_sts_csr(p_cle_id => p_line_id, p_line_type => l_line_type);
9238: FETCH l_line_nr_sts_csr INTO l_line_sts_rec;
9239: CLOSE l_line_nr_sts_csr;

Line 9268: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario

9264: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
9265: END IF;
9266: END IF;
9267:
9268: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9269: --IF p_line_id IS NOT NULL THEN
9270: ELSIF (p_line_id IS NOT NULL AND
9271: p_line_id <> OKC_API.G_MISS_NUM ) THEN
9272: --Bug# 15992711 , End

Line 9271: p_line_id <> OKC_API.G_MISS_NUM ) THEN

9267:
9268: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9269: --IF p_line_id IS NOT NULL THEN
9270: ELSIF (p_line_id IS NOT NULL AND
9271: p_line_id <> OKC_API.G_MISS_NUM ) THEN
9272: --Bug# 15992711 , End
9273:
9274: --Get the line status
9275: OPEN l_line_sts_csr(p_cle_id => p_line_id);

Line 9307: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario

9303: END IF;
9304: END IF;
9305:
9306: --Bug# 15992711 , Start
9307: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9308: --ELSIF (p_line_id IS NULL) AND (p_chr_id IS NOT NULL) THEN
9309: ELSIF (p_line_id IS NULL OR p_line_id = OKC_API.G_MISS_NUM) AND (p_chr_id IS NOT NULL) THEN
9310: --Bug# 15992711 , End
9311: l_line_discount := 0;

Line 9309: ELSIF (p_line_id IS NULL OR p_line_id = OKC_API.G_MISS_NUM) AND (p_chr_id IS NOT NULL) THEN

9305:
9306: --Bug# 15992711 , Start
9307: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9308: --ELSIF (p_line_id IS NULL) AND (p_chr_id IS NOT NULL) THEN
9309: ELSIF (p_line_id IS NULL OR p_line_id = OKC_API.G_MISS_NUM) AND (p_chr_id IS NOT NULL) THEN
9310: --Bug# 15992711 , End
9311: l_line_discount := 0;
9312:
9313:

Line 9418: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario

9414: CLOSE l_cleb_csr;
9415:
9416: END IF;
9417: --Bug# 15992711 , Start
9418: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9419: --ELSIF (p_line_id IS NULL) AND (p_chr_id IS NULL) THEN
9420: ELSIF (p_line_id IS NULL OR p_line_id = OKC_API.G_MISS_NUM) AND (p_chr_id IS NULL) THEN
9421: --Bug# 15992711 , End
9422: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 9420: ELSIF (p_line_id IS NULL OR p_line_id = OKC_API.G_MISS_NUM) AND (p_chr_id IS NULL) THEN

9416: END IF;
9417: --Bug# 15992711 , Start
9418: --Added OKC_API.G_MISS_NUM condition because p_line_id was having OKC_API.G_MISS_NUM value in few scenario
9419: --ELSIF (p_line_id IS NULL) AND (p_chr_id IS NULL) THEN
9420: ELSIF (p_line_id IS NULL OR p_line_id = OKC_API.G_MISS_NUM) AND (p_chr_id IS NULL) THEN
9421: --Bug# 15992711 , End
9422: RAISE Okl_Api.G_EXCEPTION_ERROR;
9423: END IF;
9424:

Line 10497: OKC_API.set_message( p_app_name => 'OKC',

10493: --get the total quote amount excluding billed quote lines
10494: OPEN c_total_qt_amt(l_quote_id);
10495: FETCH c_total_qt_amt INTO l_total_qte_amt;
10496: IF c_total_qt_amt%NOTFOUND THEN
10497: OKC_API.set_message( p_app_name => 'OKC',
10498: p_msg_name => G_INVALID_VALUE,
10499: p_token1 => G_COL_NAME_TOKEN,
10500: p_token1_value => 'KLE_ID');
10501: l_total_qte_amt := 0;

Line 10979: RAISE OKC_API.G_EXCEPTION_ERROR;

10975: l_tot_amount := NULL; -- error
10976: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
10977: p_msg_name => 'OKL_DATE_TERMINATED_REQUIRED');
10978:
10979: RAISE OKC_API.G_EXCEPTION_ERROR;
10980: END IF;
10981:
10982: ELSE -- error
10983: l_tot_amount := NULL;

Line 10989: RAISE OKC_API.G_EXCEPTION_ERROR;

10985: p_msg_name => 'OKL_INVALID_ACCT_METHOD_CODE',
10986: p_token2 => 'COL_NAME',
10987: p_token2_value => r_subsidy_line.accounting_method_code);
10988:
10989: RAISE OKC_API.G_EXCEPTION_ERROR;
10990: -- END CASE;
10991: END IF;
10992:
10993: END LOOP;

Line 13370: p_init_msg_list => OKC_API.G_FALSE,

13366: IF l_rep_prod_streams_yn = 'Y' THEN
13367:
13368: get_reporting_product(
13369: p_api_version => l_api_version,
13370: p_init_msg_list => OKC_API.G_FALSE,
13371: x_return_status => l_return_status,
13372: x_msg_count => l_msg_count,
13373: x_msg_data => l_msg_data,
13374: p_contract_id => p_contract_id,