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

Line 82: p_init_msg_list => OKC_API.G_FALSE,

78: lp_pdtv_rec.id := l_fin_product_id;
79:
80: -- check if the fin product has a reporting product
81: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters( p_api_version => p_api_version,
82: p_init_msg_list => OKC_API.G_FALSE,
83: x_return_status => x_return_status,
84: x_no_data_found => lx_no_data_found,
85: x_msg_count => x_msg_count,
86: x_msg_data => x_msg_data,

Line 91: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

87: p_pdtv_rec => lp_pdtv_rec,
88: p_product_date => l_start_date,
89: p_pdt_parameter_rec => lx_pdt_parameter_rec);
90:
91: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
92: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
93: OKC_API.set_message( p_app_name => 'OKL',
94: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
95: p_token1 => 'CONTRACT_NUMBER',

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

89: p_pdt_parameter_rec => lx_pdt_parameter_rec);
90:
91: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
92: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
93: OKC_API.set_message( p_app_name => 'OKL',
94: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
95: p_token1 => 'CONTRACT_NUMBER',
96: p_token1_value => l_contract_number);
97:

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

101:
102: l_reporting_product := lx_pdt_parameter_rec.reporting_product;
103: l_reporting_product_id := lx_pdt_parameter_rec.reporting_pdt_id;
104:
105: IF l_reporting_product IS NOT NULL AND l_reporting_product <> OKC_API.G_MISS_CHAR THEN
106: -- Contract has a reporting product
107: x_rep_product := l_reporting_product;
108:
109: lp_pdtv_rec := lp_empty_pdtv_rec;

Line 114: p_init_msg_list => OKC_API.G_FALSE,

110: lp_pdtv_rec.id := l_reporting_product_id;
111:
112: -- get the deal type of the reporting product
113: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters( p_api_version => p_api_version,
114: p_init_msg_list => OKC_API.G_FALSE,
115: x_return_status => x_return_status,
116: x_no_data_found => lx_no_data_found,
117: x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data,

Line 123: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

119: p_pdtv_rec => lp_pdtv_rec,
120: p_product_date => l_start_date,
121: p_pdt_parameter_rec => lx_pdt_parameter_rec);
122:
123: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
124: -- Error getting reporting product parameters for contract CONTRACT_NUMBER.
125: OKC_API.set_message( p_app_name => 'OKL',
126: p_msg_name => 'OKL_AM_REP_PROD_PARAM_ERR',
127: p_token1 => 'CONTRACT_NUMBER',

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

121: p_pdt_parameter_rec => lx_pdt_parameter_rec);
122:
123: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
124: -- Error getting reporting product parameters for contract CONTRACT_NUMBER.
125: OKC_API.set_message( p_app_name => 'OKL',
126: p_msg_name => 'OKL_AM_REP_PROD_PARAM_ERR',
127: p_token1 => 'CONTRACT_NUMBER',
128: p_token1_value => l_contract_number);
129:

Line 134: IF l_rep_deal_type IS NULL OR l_rep_deal_type = OKC_API.G_MISS_CHAR THEN

130:
131: ELSE
132:
133: l_rep_deal_type := lx_pdt_parameter_rec.Deal_Type;
134: IF l_rep_deal_type IS NULL OR l_rep_deal_type = OKC_API.G_MISS_CHAR THEN
135: --Deal Type not defined for Reporting product REP_PROD.
136: OKC_API.set_message( p_app_name => 'OKL',
137: p_msg_name => 'OKL_AM_NO_MG_DEAL_TYPE',
138: p_token1 => 'REP_PROD',

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

132:
133: l_rep_deal_type := lx_pdt_parameter_rec.Deal_Type;
134: IF l_rep_deal_type IS NULL OR l_rep_deal_type = OKC_API.G_MISS_CHAR THEN
135: --Deal Type not defined for Reporting product REP_PROD.
136: OKC_API.set_message( p_app_name => 'OKL',
137: p_msg_name => 'OKL_AM_NO_MG_DEAL_TYPE',
138: p_token1 => 'REP_PROD',
139: p_token1_value => l_reporting_product);
140:

Line 148: IF l_rep_tax_owner IS NULL OR l_rep_tax_owner = OKC_API.G_MISS_CHAR THEN

144: END IF;
145:
146: /*
147: l_rep_tax_owner := lx_pdt_parameter_rec.Tax_Owner;
148: IF l_rep_tax_owner IS NULL OR l_rep_tax_owner = OKC_API.G_MISS_CHAR THEN
149: -- Tax Owner not defined for Reporting product REP_PROD.
150: OKC_API.set_message( p_app_name => 'OKL',
151: p_msg_name => 'OKL_AM_NO_MG_TAX_OWNER',
152: p_token1 => 'REP_PROD',

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

146: /*
147: l_rep_tax_owner := lx_pdt_parameter_rec.Tax_Owner;
148: IF l_rep_tax_owner IS NULL OR l_rep_tax_owner = OKC_API.G_MISS_CHAR THEN
149: -- Tax Owner not defined for Reporting product REP_PROD.
150: OKC_API.set_message( p_app_name => 'OKL',
151: p_msg_name => 'OKL_AM_NO_MG_TAX_OWNER',
152: p_token1 => 'REP_PROD',
153: p_token1_value => l_reporting_product);
154:

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

165: -- get the MG reporting book
166: l_mg_rep_book := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
167: IF l_mg_rep_book IS NULL THEN
168: --Multi GAAP Reporting Book is not defined.
169: OKC_API.set_message( p_app_name => 'OKL',
170: p_msg_name => 'OKL_AM_NO_MG_REP_BOOK');
171:
172: RAISE mg_error;
173: ELSE

Line 1278: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1274: x_currency_conversion_rate => l_currency_conversion_rate,
1275: x_currency_conversion_date => l_currency_conversion_date,
1276: x_converted_amount => l_converted_amount);
1277:
1278: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1279: RAISE process_unexp_error;
1280: END IF;
1281:
1282: l_orig_cost_in_func := l_converted_amount;

Line 1297: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1293: x_currency_conversion_rate => l_currency_conversion_rate,
1294: x_currency_conversion_date => l_currency_conversion_date,
1295: x_converted_amount => l_converted_amount);
1296:
1297: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1298: RAISE process_unexp_error;
1299: END IF;
1300:
1301: l_nest_invest_val_in_func := l_converted_amount;

Line 2442: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2438: x_currency_conversion_rate => l_currency_conversion_rate,
2439: x_currency_conversion_date => l_currency_conversion_date,
2440: x_converted_amount => l_converted_amount);
2441:
2442: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2443: RAISE process_unexp_error;
2444: END IF;
2445:
2446: l_orig_cost_in_func := l_converted_amount;

Line 2461: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2457: x_currency_conversion_rate => l_currency_conversion_rate,
2458: x_currency_conversion_date => l_currency_conversion_date,
2459: x_converted_amount => l_converted_amount);
2460:
2461: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2462: RAISE process_unexp_error;
2463: END IF;
2464:
2465: l_nest_invest_val_in_func := l_converted_amount;

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

3777:
3778: IF p_kle_id IS NULL OR p_kle_id = OKL_API.G_MISS_NUM THEN
3779: x_return_status := OKL_API.G_RET_STS_ERROR;
3780: -- kle id parameter is null
3781: OKC_API.set_message( p_app_name => 'OKC',
3782: p_msg_name => G_REQUIRED_VALUE,
3783: p_token1 => G_COL_NAME_TOKEN,
3784: p_token1_value => 'KLE_ID');
3785: RAISE OKL_API.G_EXCEPTION_ERROR;

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

3790: FETCH l_okllines_csr INTO l_name;
3791: IF l_okllines_csr%NOTFOUND THEN
3792: x_return_status := OKL_API.G_RET_STS_ERROR;
3793: -- kle id is invalid
3794: OKC_API.set_message( p_app_name => 'OKC',
3795: p_msg_name => G_INVALID_VALUE,
3796: p_token1 => G_COL_NAME_TOKEN,
3797: p_token1_value => 'KLE_ID');
3798: RAISE OKL_API.G_EXCEPTION_ERROR;

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

3806: /*
3807: IF p_early_termination_yn IS NULL OR p_early_termination_yn = OKL_API.G_MISS_CHAR THEN
3808: x_return_status := OKL_API.G_RET_STS_ERROR;
3809: -- early_termination_yn parameter is null
3810: OKC_API.set_message( p_app_name => 'OKC',
3811: p_msg_name => G_REQUIRED_VALUE,
3812: p_token1 => G_COL_NAME_TOKEN,
3813: p_token1_value => 'EARLY_TERMINATION_YN');
3814:

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

3818:
3819: IF p_early_termination_yn <> 'Y' AND p_early_termination_yn <> 'N' THEN
3820: x_return_status := OKL_API.G_RET_STS_ERROR;
3821: -- early_termination_yn parameter is invalid
3822: OKC_API.set_message( p_app_name => 'OKC',
3823: p_msg_name => G_INVALID_VALUE,
3824: p_token1 => G_COL_NAME_TOKEN,
3825: p_token1_value => 'EARLY_TERMINATION_YN');
3826:

Line 3869: RAISE OKC_API.G_EXCEPTION_ERROR;

3865: OKL_API.set_message(p_app_name => 'OKL',
3866: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
3867: p_token1 => 'TRY_NAME',
3868: p_token1_value => 'Off Lease Amortization');
3869: RAISE OKC_API.G_EXCEPTION_ERROR;
3870: END IF;
3871:
3872: --SECHAWLA 03-JAN-03 2683876 get the functional currency code
3873: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

Line 3984: p_init_msg_list => OKC_API.G_FALSE,

3980: -- SECHAWLA 06-MAY-04 3578894 :Check if the contract has a reporting product attached
3981: -- PAGARG 10-Feb-2005 3730369: Pass correct variable as out parameter for return status
3982: get_reporting_product(
3983: p_api_version => p_api_version,
3984: p_init_msg_list => OKC_API.G_FALSE,
3985: x_return_status => x_return_status,
3986: x_msg_count => x_msg_count,
3987: x_msg_data => x_msg_data,
3988: p_contract_id => l_contract_id,

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

4631: -- SECHAWLA 19-NOV-2004 4022466 : added validations
4632: IF p_contract_id IS NULL OR p_contract_id = OKL_API.G_MISS_NUM THEN
4633: x_return_status := OKL_API.G_RET_STS_ERROR;
4634: -- chr id is required
4635: OKC_API.set_message( p_app_name => 'OKC',
4636: p_msg_name => G_REQUIRED_VALUE,
4637: p_token1 => G_COL_NAME_TOKEN,
4638: p_token1_value => 'CONTRACT_ID');
4639: RAISE OKL_API.G_EXCEPTION_ERROR;

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

4643: FETCH l_okckhdr_csr INTO l_sts_code;
4644: IF l_okckhdr_csr%NOTFOUND THEN
4645: x_return_status := OKL_API.G_RET_STS_ERROR;
4646: -- chr id is invalid
4647: OKC_API.set_message( p_app_name => 'OKC',
4648: p_msg_name => G_INVALID_VALUE,
4649: p_token1 => G_COL_NAME_TOKEN,
4650: p_token1_value => 'CONTRACT_ID');
4651: RAISE OKL_API.G_EXCEPTION_ERROR;

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

4870: IF p_header_rec.id IS NULL OR p_header_rec.id = OKL_API.G_MISS_NUM OR
4871: p_lines_rec.id IS NULL OR p_lines_rec.id = OKL_API.G_MISS_NUM THEN
4872: x_return_status := OKL_API.G_RET_STS_ERROR;
4873: -- transaction id is requierd
4874: OKC_API.set_message( p_app_name => 'OKC',
4875: p_msg_name => G_REQUIRED_VALUE,
4876: p_token1 => G_COL_NAME_TOKEN,
4877: p_token1_value => 'TRANSACTION_ID');
4878: RAISE OKL_API.G_EXCEPTION_ERROR;

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

4886: FETCH l_lines_csr INTO l_asset_number, l_old_hold_days, l_depreciate_yn, l_kle_id, l_tal_type, l_booktype_code ;
4887: IF l_lines_csr%NOTFOUND THEN
4888: x_return_status := OKL_API.G_RET_STS_ERROR;
4889: -- Line ID in the input line record is invalid
4890: OKC_API.set_message( p_app_name => 'OKC',
4891: p_msg_name => G_INVALID_VALUE,
4892: p_token1 => G_COL_NAME_TOKEN,
4893: p_token1_value => 'LINE_ID');
4894: RAISE OKL_API.G_EXCEPTION_ERROR;

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

4938: FETCH l_hdrtransdate_csr INTO l_old_trans_date;
4939: IF l_hdrtransdate_csr%NOTFOUND THEN
4940: x_return_status := OKL_API.G_RET_STS_ERROR;
4941: -- Header ID in the input header record is invalid
4942: OKC_API.set_message( p_app_name => 'OKC',
4943: p_msg_name => G_INVALID_VALUE,
4944: p_token1 => G_COL_NAME_TOKEN,
4945: p_token1_value => 'HEADER_ID');
4946: RAISE OKL_API.G_EXCEPTION_ERROR;

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

5331: IF p_header_tbl(i).id IS NULL OR p_header_tbl(i).id = OKL_API.G_MISS_NUM OR
5332: p_lines_tbl(i).id IS NULL OR p_lines_tbl(i).id = OKL_API.G_MISS_NUM THEN
5333: x_record_status := OKL_API.G_RET_STS_ERROR;
5334: -- transaction Id is required
5335: OKC_API.set_message( p_app_name => 'OKC',
5336: p_msg_name => G_REQUIRED_VALUE,
5337: p_token1 => G_COL_NAME_TOKEN,
5338: p_token1_value => 'TRANSACTION_ID');
5339:

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

5345: -- << LABEL 4 >>
5346: IF l_hdrtransdate_csr%NOTFOUND THEN
5347: x_record_status := OKL_API.G_RET_STS_ERROR;
5348: -- Header Id for the current record in the input table is invalid
5349: OKC_API.set_message( p_app_name => 'OKC',
5350: p_msg_name => G_INVALID_VALUE,
5351: p_token1 => G_COL_NAME_TOKEN,
5352: p_token1_value => 'HEADER_ID');
5353:

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

5360: -- << LABEL 2 >>
5361: IF l_lines_csr%NOTFOUND THEN
5362: x_record_status := OKL_API.G_RET_STS_ERROR;
5363: -- Line Id for the current record in the input table is invalid
5364: OKC_API.set_message( p_app_name => 'OKC',
5365: p_msg_name => G_INVALID_VALUE,
5366: p_token1 => G_COL_NAME_TOKEN,
5367: p_token1_value => 'LINE_ID');
5368:

Line 5536: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

5532: -- SECHAWLA 28-MAY-04 3645574 Added deprn rate processing logic for diminishing dep methods
5533: -- End of comments
5534: PROCEDURE update_depreciation(
5535: p_api_version IN NUMBER,
5536: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5537: x_return_status OUT NOCOPY VARCHAR2,
5538: x_msg_count OUT NOCOPY NUMBER,
5539: x_msg_data OUT NOCOPY VARCHAR2,
5540: p_deprn_rec IN deprn_rec_type) IS