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 53: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,

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

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

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

Line 57: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

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

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

Line 188: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

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

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

Line 203: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 219: Okc_Api.set_message(G_APP_NAME, G_INVALID_CONTRACT_LINE,

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

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

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

Line 223: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

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

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

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

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

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

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

Line 4361: OKC_API.SET_MESSAGE (

4357: END IF;
4358:
4359: IF l_object_name IS NULL THEN
4360: l_overall_status := OKL_API.G_RET_STS_ERROR;
4361: OKC_API.SET_MESSAGE (
4362: p_app_name => OKC_API.G_APP_NAME,
4363: p_msg_name => OKC_API.G_INVALID_VALUE,
4364: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4365: p_token1_value => l_token);

Line 4362: p_app_name => OKC_API.G_APP_NAME,

4358:
4359: IF l_object_name IS NULL THEN
4360: l_overall_status := OKL_API.G_RET_STS_ERROR;
4361: OKC_API.SET_MESSAGE (
4362: p_app_name => OKC_API.G_APP_NAME,
4363: p_msg_name => OKC_API.G_INVALID_VALUE,
4364: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4365: p_token1_value => l_token);
4366: END IF;

Line 4363: p_msg_name => OKC_API.G_INVALID_VALUE,

4359: IF l_object_name IS NULL THEN
4360: l_overall_status := OKL_API.G_RET_STS_ERROR;
4361: OKC_API.SET_MESSAGE (
4362: p_app_name => OKC_API.G_APP_NAME,
4363: p_msg_name => OKC_API.G_INVALID_VALUE,
4364: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4365: p_token1_value => l_token);
4366: END IF;
4367:

Line 4364: p_token1 => OKC_API.G_COL_NAME_TOKEN,

4360: l_overall_status := OKL_API.G_RET_STS_ERROR;
4361: OKC_API.SET_MESSAGE (
4362: p_app_name => OKC_API.G_APP_NAME,
4363: p_msg_name => OKC_API.G_INVALID_VALUE,
4364: p_token1 => OKC_API.G_COL_NAME_TOKEN,
4365: p_token1_value => l_token);
4366: END IF;
4367:
4368: -- ********************************************

Line 5109: p_init_msg_list => OKC_API.G_FALSE,

5105: lp_pdtv_rec.id := l_fin_product_id;
5106:
5107: -- check if the fin product has a reporting product
5108: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters( p_api_version => p_api_version,
5109: p_init_msg_list => OKC_API.G_FALSE,
5110: x_return_status => x_return_status,
5111: x_no_data_found => lx_no_data_found,
5112: x_msg_count => x_msg_count,
5113: x_msg_data => x_msg_data,

Line 5118: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

5114: p_pdtv_rec => lp_pdtv_rec,
5115: p_product_date => l_start_date,
5116: p_pdt_parameter_rec => lx_pdt_parameter_rec);
5117:
5118: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5119: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
5120: OKC_API.set_message( p_app_name => 'OKL',
5121: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
5122: p_token1 => 'CONTRACT_NUMBER',

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

5116: p_pdt_parameter_rec => lx_pdt_parameter_rec);
5117:
5118: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5119: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
5120: OKC_API.set_message( p_app_name => 'OKL',
5121: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
5122: p_token1 => 'CONTRACT_NUMBER',
5123: p_token1_value => l_contract_number);
5124:

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

5126:
5127: l_reporting_product := lx_pdt_parameter_rec.reporting_product;
5128: l_reporting_product_id := lx_pdt_parameter_rec.reporting_pdt_id;
5129:
5130: IF l_reporting_product IS NOT NULL AND l_reporting_product <> OKC_API.G_MISS_CHAR THEN
5131: -- Contract has a reporting product
5132: x_rep_product_id := l_reporting_product_id;
5133: END IF;
5134: END IF;

Line 5252: p_init_msg_list => OKC_API.G_FALSE,

5248: IF l_rep_prod_streams_yn = 'Y' THEN
5249:
5250: get_reporting_product(
5251: p_api_version => l_api_version,
5252: p_init_msg_list => OKC_API.G_FALSE,
5253: x_return_status => l_return_status,
5254: x_msg_count => l_msg_count,
5255: x_msg_data => l_msg_data,
5256: p_contract_id => p_contract_id,

Line 6680: RAISE OKC_API.G_EXCEPTION_ERROR;

6676: p_msg_name => G_REQUIRED_VALUE,
6677: p_token1 => G_COL_NAME_TOKEN,
6678: p_token1_value => 'RATE');
6679:
6680: RAISE OKC_API.G_EXCEPTION_ERROR;
6681: END IF;
6682:
6683: IF p_contract_line_id IS NOT NULL THEN
6684:

Line 6877: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

6873:
6874: RETURN l_net_investment;
6875: EXCEPTION
6876: WHEN OTHERS THEN
6877: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
6878: ,p_msg_name => G_UNEXPECTED_ERROR
6879: ,p_token1 => G_SQLCODE_TOKEN
6880: ,p_token1_value => SQLCODE
6881: ,p_token2 => G_SQLERRM_TOKEN

Line 6922: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

6918: RETURN l_cures_in_possession;
6919:
6920: EXCEPTION
6921: WHEN OTHERS THEN
6922: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
6923: ,p_msg_name => G_UNEXPECTED_ERROR
6924: ,p_token1 => G_SQLCODE_TOKEN
6925: ,p_token1_value => SQLCODE
6926: ,p_token2 => G_SQLERRM_TOKEN

Line 6975: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

6971: RETURN l_outstanding_amount;
6972:
6973: EXCEPTION
6974: WHEN OTHERS THEN
6975: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
6976: ,p_msg_name => G_UNEXPECTED_ERROR
6977: ,p_token1 => G_SQLCODE_TOKEN
6978: ,p_token1_value => SQLCODE
6979: ,p_token2 => G_SQLERRM_TOKEN

Line 7032: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7028: RETURN l_full_cure;
7029:
7030: EXCEPTION
7031: WHEN OTHERS THEN
7032: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7033: ,p_msg_name => G_UNEXPECTED_ERROR
7034: ,p_token1 => G_SQLCODE_TOKEN
7035: ,p_token1_value => SQLCODE
7036: ,p_token2 => G_SQLERRM_TOKEN

Line 7122: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7118: RETURN l_interest_cure;
7119:
7120: EXCEPTION
7121: WHEN OTHERS THEN
7122: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7123: ,p_msg_name => G_UNEXPECTED_ERROR
7124: ,p_token1 => G_SQLCODE_TOKEN
7125: ,p_token1_value => SQLCODE
7126: ,p_token2 => G_SQLERRM_TOKEN

Line 7165: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

7161:
7162: RETURN l_return_status;
7163: EXCEPTION
7164: WHEN OTHERS THEN
7165: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
7166: ,p_msg_name => G_UNEXPECTED_ERROR
7167: ,p_token1 => G_SQLCODE_TOKEN
7168: ,p_token1_value => SQLCODE
7169: ,p_token2 => G_SQLERRM_TOKEN

Line 7171: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

7167: ,p_token1 => G_SQLCODE_TOKEN
7168: ,p_token1_value => SQLCODE
7169: ,p_token2 => G_SQLERRM_TOKEN
7170: ,p_token2_value => SQLERRM);
7171: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
7172: RETURN(l_return_status);
7173:
7174: END get_unrefunded_cures;
7175:

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

9636: --get the total quote amount excluding billed quote lines
9637: OPEN c_total_qt_amt(l_quote_id);
9638: FETCH c_total_qt_amt INTO l_total_qte_amt;
9639: IF c_total_qt_amt%NOTFOUND THEN
9640: OKC_API.set_message( p_app_name => 'OKC',
9641: p_msg_name => G_INVALID_VALUE,
9642: p_token1 => G_COL_NAME_TOKEN,
9643: p_token1_value => 'KLE_ID');
9644: l_total_qte_amt := 0;

Line 10122: RAISE OKC_API.G_EXCEPTION_ERROR;

10118: l_tot_amount := NULL; -- error
10119: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
10120: p_msg_name => 'OKL_DATE_TERMINATED_REQUIRED');
10121:
10122: RAISE OKC_API.G_EXCEPTION_ERROR;
10123: END IF;
10124:
10125: ELSE -- error
10126: l_tot_amount := NULL;

Line 10132: RAISE OKC_API.G_EXCEPTION_ERROR;

10128: p_msg_name => 'OKL_INVALID_ACCT_METHOD_CODE',
10129: p_token2 => 'COL_NAME',
10130: p_token2_value => r_subsidy_line.accounting_method_code);
10131:
10132: RAISE OKC_API.G_EXCEPTION_ERROR;
10133: -- END CASE;
10134: END IF;
10135:
10136: END LOOP;

Line 12164: p_init_msg_list => OKC_API.G_FALSE,

12160: IF l_rep_prod_streams_yn = 'Y' THEN
12161:
12162: get_reporting_product(
12163: p_api_version => l_api_version,
12164: p_init_msg_list => OKC_API.G_FALSE,
12165: x_return_status => l_return_status,
12166: x_msg_count => l_msg_count,
12167: x_msg_data => l_msg_data,
12168: p_contract_id => p_contract_id,