DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKC_API

Line 506: OKC_API.set_message(p_app_name => G_APP_NAME,

502: --trap the conversion exception
503: --if conv rate is not found GL API returns negative
504: If (p_amount > 0) and (x_amount < 0) Then
505: --currency conversion rate was not found in Oracle GL
506: OKC_API.set_message(p_app_name => G_APP_NAME,
507: p_msg_name => G_CONV_RATE_NOT_FOUND,
508: p_token1 => G_FROM_CURRENCY_TOKEN,
509: p_token1_value => x_contract_currency,
510: p_token2 => G_TO_CURRENCY_TOKEN,

Line 516: x_return_status := OKC_API.G_RET_STS_ERROR;

512: p_token3 => G_CONV_TYPE_TOKEN,
513: p_token3_value => x_currency_conversion_type,
514: p_token4 => G_CONV_DATE_TOKEN,
515: p_token4_value => to_char(x_currency_conversion_date,'DD-MON-YYYY'));
516: x_return_status := OKC_API.G_RET_STS_ERROR;
517: End If;
518:
519:
520: End If;

Line 2957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2953: px_asset_hdr_rec => l_asset_hdr_rec,
2954: px_asset_desc_rec_new => l_asset_desc_rec,
2955: px_asset_cat_rec_new => l_asset_cat_rec);
2956:
2957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2960: RAISE OKC_API.G_EXCEPTION_ERROR;
2961: END IF;

Line 2958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2954: px_asset_desc_rec_new => l_asset_desc_rec,
2955: px_asset_cat_rec_new => l_asset_cat_rec);
2956:
2957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2960: RAISE OKC_API.G_EXCEPTION_ERROR;
2961: END IF;
2962:

Line 2959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2955: px_asset_cat_rec_new => l_asset_cat_rec);
2956:
2957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2960: RAISE OKC_API.G_EXCEPTION_ERROR;
2961: END IF;
2962:
2963: x_fa_trx_date := l_trans_rec.transaction_date_entered;

Line 2960: RAISE OKC_API.G_EXCEPTION_ERROR;

2956:
2957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2960: RAISE OKC_API.G_EXCEPTION_ERROR;
2961: END IF;
2962:
2963: x_fa_trx_date := l_trans_rec.transaction_date_entered;
2964:

Line 4779: OKC_API.set_message(

4775: Open town_rul_csr(pchrid => p_chrv_id);
4776: Fetch town_rul_csr into l_town_rul,
4777: l_town_rul_id;
4778: If town_rul_csr%NOTFOUND Then
4779: OKC_API.set_message(
4780: p_app_name => G_APP_NAME,
4781: p_msg_name => G_REQUIRED_VALUE,
4782: p_token1 => G_COL_NAME_TOKEN,
4783: p_token1_value => 'Tax Owner');

Line 4784: x_return_status := OKC_API.G_RET_STS_ERROR;

4780: p_app_name => G_APP_NAME,
4781: p_msg_name => G_REQUIRED_VALUE,
4782: p_token1 => G_COL_NAME_TOKEN,
4783: p_token1_value => 'Tax Owner');
4784: x_return_status := OKC_API.G_RET_STS_ERROR;
4785: RAISE OKL_API.G_EXCEPTION_ERROR;
4786: Else
4787: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
4788: End If;

Line 5416: OKC_API.set_message(

5412: Open town_rul_csr(pchrid => l_chr_id);
5413: Fetch town_rul_csr into l_town_rul,
5414: l_town_rul_id;
5415: If town_rul_csr%NOTFOUND Then
5416: OKC_API.set_message(
5417: p_app_name => G_APP_NAME,
5418: p_msg_name => G_REQUIRED_VALUE,
5419: p_token1 => G_COL_NAME_TOKEN,
5420: p_token1_value => 'Tax Owner');

Line 5421: x_return_status := OKC_API.G_RET_STS_ERROR;

5417: p_app_name => G_APP_NAME,
5418: p_msg_name => G_REQUIRED_VALUE,
5419: p_token1 => G_COL_NAME_TOKEN,
5420: p_token1_value => 'Tax Owner');
5421: x_return_status := OKC_API.G_RET_STS_ERROR;
5422: RAISE OKL_API.G_EXCEPTION_ERROR;
5423: Else
5424: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
5425: End If;

Line 6610: OKC_API.set_message(

6606: Open town_rul_csr(pchrid => l_chr_id);
6607: Fetch town_rul_csr into l_town_rul,
6608: l_town_rul_id;
6609: If town_rul_csr%NOTFOUND Then
6610: OKC_API.set_message(
6611: p_app_name => G_APP_NAME,
6612: p_msg_name => G_REQUIRED_VALUE,
6613: p_token1 => G_COL_NAME_TOKEN,
6614: p_token1_value => 'Tax Owner');

Line 6615: x_return_status := OKC_API.G_RET_STS_ERROR;

6611: p_app_name => G_APP_NAME,
6612: p_msg_name => G_REQUIRED_VALUE,
6613: p_token1 => G_COL_NAME_TOKEN,
6614: p_token1_value => 'Tax Owner');
6615: x_return_status := OKC_API.G_RET_STS_ERROR;
6616: RAISE OKL_API.G_EXCEPTION_ERROR;
6617: Else
6618: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
6619: End If;

Line 7695: OKC_API.set_message(

7691: Open town_rul_csr(pchrid => p_rel_chr_id);
7692: Fetch town_rul_csr into l_town_rul,
7693: l_town_rul_id;
7694: If town_rul_csr%NOTFOUND Then
7695: OKC_API.set_message(
7696: p_app_name => G_APP_NAME,
7697: p_msg_name => G_REQUIRED_VALUE,
7698: p_token1 => G_COL_NAME_TOKEN,
7699: p_token1_value => 'Tax Owner');

Line 7700: x_return_status := OKC_API.G_RET_STS_ERROR;

7696: p_app_name => G_APP_NAME,
7697: p_msg_name => G_REQUIRED_VALUE,
7698: p_token1 => G_COL_NAME_TOKEN,
7699: p_token1_value => 'Tax Owner');
7700: x_return_status := OKC_API.G_RET_STS_ERROR;
7701: RAISE OKL_API.G_EXCEPTION_ERROR;
7702: Else
7703: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
7704: End If;