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,
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;
2944: px_asset_hdr_rec => l_asset_hdr_rec,
2945: px_asset_desc_rec_new => l_asset_desc_rec,
2946: px_asset_cat_rec_new => l_asset_cat_rec);
2947:
2948: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2949: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2950: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2951: RAISE OKC_API.G_EXCEPTION_ERROR;
2952: END IF;
2945: px_asset_desc_rec_new => l_asset_desc_rec,
2946: px_asset_cat_rec_new => l_asset_cat_rec);
2947:
2948: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2949: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2950: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2951: RAISE OKC_API.G_EXCEPTION_ERROR;
2952: END IF;
2953:
2946: px_asset_cat_rec_new => l_asset_cat_rec);
2947:
2948: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2949: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2950: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2951: RAISE OKC_API.G_EXCEPTION_ERROR;
2952: END IF;
2953:
2954: x_fa_trx_date := l_trans_rec.transaction_date_entered;
2947:
2948: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2949: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2950: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2951: RAISE OKC_API.G_EXCEPTION_ERROR;
2952: END IF;
2953:
2954: x_fa_trx_date := l_trans_rec.transaction_date_entered;
2955:
4766: Open town_rul_csr(pchrid => p_chrv_id);
4767: Fetch town_rul_csr into l_town_rul,
4768: l_town_rul_id;
4769: If town_rul_csr%NOTFOUND Then
4770: OKC_API.set_message(
4771: p_app_name => G_APP_NAME,
4772: p_msg_name => G_REQUIRED_VALUE,
4773: p_token1 => G_COL_NAME_TOKEN,
4774: p_token1_value => 'Tax Owner');
4771: p_app_name => G_APP_NAME,
4772: p_msg_name => G_REQUIRED_VALUE,
4773: p_token1 => G_COL_NAME_TOKEN,
4774: p_token1_value => 'Tax Owner');
4775: x_return_status := OKC_API.G_RET_STS_ERROR;
4776: RAISE OKL_API.G_EXCEPTION_ERROR;
4777: Else
4778: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
4779: End If;
5431: Open town_rul_csr(pchrid => l_chr_id);
5432: Fetch town_rul_csr into l_town_rul,
5433: l_town_rul_id;
5434: If town_rul_csr%NOTFOUND Then
5435: OKC_API.set_message(
5436: p_app_name => G_APP_NAME,
5437: p_msg_name => G_REQUIRED_VALUE,
5438: p_token1 => G_COL_NAME_TOKEN,
5439: p_token1_value => 'Tax Owner');
5436: p_app_name => G_APP_NAME,
5437: p_msg_name => G_REQUIRED_VALUE,
5438: p_token1 => G_COL_NAME_TOKEN,
5439: p_token1_value => 'Tax Owner');
5440: x_return_status := OKC_API.G_RET_STS_ERROR;
5441: RAISE OKL_API.G_EXCEPTION_ERROR;
5442: Else
5443: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
5444: End If;
6662: Open town_rul_csr(pchrid => l_chr_id);
6663: Fetch town_rul_csr into l_town_rul,
6664: l_town_rul_id;
6665: If town_rul_csr%NOTFOUND Then
6666: OKC_API.set_message(
6667: p_app_name => G_APP_NAME,
6668: p_msg_name => G_REQUIRED_VALUE,
6669: p_token1 => G_COL_NAME_TOKEN,
6670: p_token1_value => 'Tax Owner');
6667: p_app_name => G_APP_NAME,
6668: p_msg_name => G_REQUIRED_VALUE,
6669: p_token1 => G_COL_NAME_TOKEN,
6670: p_token1_value => 'Tax Owner');
6671: x_return_status := OKC_API.G_RET_STS_ERROR;
6672: RAISE OKL_API.G_EXCEPTION_ERROR;
6673: Else
6674: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
6675: End If;
7966: Open town_rul_csr(pchrid => p_rel_chr_id);
7967: Fetch town_rul_csr into l_town_rul,
7968: l_town_rul_id;
7969: If town_rul_csr%NOTFOUND Then
7970: OKC_API.set_message(
7971: p_app_name => G_APP_NAME,
7972: p_msg_name => G_REQUIRED_VALUE,
7973: p_token1 => G_COL_NAME_TOKEN,
7974: p_token1_value => 'Tax Owner');
7971: p_app_name => G_APP_NAME,
7972: p_msg_name => G_REQUIRED_VALUE,
7973: p_token1 => G_COL_NAME_TOKEN,
7974: p_token1_value => 'Tax Owner');
7975: x_return_status := OKC_API.G_RET_STS_ERROR;
7976: RAISE OKL_API.G_EXCEPTION_ERROR;
7977: Else
7978: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
7979: End If;