43: -- Added by Santonyr on 25-Nov-2002
44: -- Get the currency from transaction if the passed one is null
45:
46: IF (l_tclv_tbl(i).currency_code IS NULL) OR
47: (l_tclv_tbl(i).currency_code = OKL_API.G_MISS_CHAR) THEN
48: l_tclv_tbl(i).currency_code := x_tcnv_rec.currency_code;
49: END IF;
50:
51: EXIT WHEN(i = l_tclv_tbl.LAST);
137: OR (l_tcnv_rec.representation_code IS NULL) OR (l_tcnv_rec.representation_code = Okc_Api.G_MISS_CHAR) THEN
138: OPEN representation_csr(l_tcnv_rec.set_of_books_id);
139: FETCH representation_csr into l_tcnv_rec.representation_name, l_tcnv_rec.representation_code;
140: IF representation_csr%NOTFOUND THEN
141: OKL_API.set_message(
142: p_app_name => G_APP_NAME,
143: p_msg_name => 'OKL_INVALID_VALUE',
144: p_token1 => 'COL_NAME',
145: p_token1_value => 'set_of_books_id'
158: l_data_not_found := 0;
159: END IF;
160: CLOSE cntr_pid_csr;
161: IF(l_data_not_found = 0) THEN
162: OKL_API.set_message(
163: p_app_name => G_APP_NAME,
164: p_msg_name => 'OKL_INVALID_VALUE',
165: p_token1 => 'COL_NAME',
166: p_token1_value => 'khr_id'
207: END IF;
208:
209:
210: IF(l_data_not_found = 0) THEN
211: OKL_API.set_message(
212: p_app_name => G_APP_NAME,
213: p_msg_name => 'OKL_INVALID_VALUE',
214: p_token1 => 'COL_NAME',
215: p_token1_value => 'pdt_id'
237: -- Custom code if any
238:
239: EXCEPTION
240: WHEN G_EXCEPTION_HALT_VALIDATION THEN
241: x_return_status := OKL_Api.G_RET_STS_UNEXP_ERROR;
242: WHEN OKL_API.G_EXCEPTION_ERROR THEN
243: x_return_status := OKL_API.G_RET_STS_ERROR;
244: WHEN OTHERS THEN
245: OKL_API.SET_MESSAGE(p_app_name => g_app_name
238:
239: EXCEPTION
240: WHEN G_EXCEPTION_HALT_VALIDATION THEN
241: x_return_status := OKL_Api.G_RET_STS_UNEXP_ERROR;
242: WHEN OKL_API.G_EXCEPTION_ERROR THEN
243: x_return_status := OKL_API.G_RET_STS_ERROR;
244: WHEN OTHERS THEN
245: OKL_API.SET_MESSAGE(p_app_name => g_app_name
246: ,p_msg_name => g_unexpected_error
239: EXCEPTION
240: WHEN G_EXCEPTION_HALT_VALIDATION THEN
241: x_return_status := OKL_Api.G_RET_STS_UNEXP_ERROR;
242: WHEN OKL_API.G_EXCEPTION_ERROR THEN
243: x_return_status := OKL_API.G_RET_STS_ERROR;
244: WHEN OTHERS THEN
245: OKL_API.SET_MESSAGE(p_app_name => g_app_name
246: ,p_msg_name => g_unexpected_error
247: ,p_token1 => g_sqlcode_token
241: x_return_status := OKL_Api.G_RET_STS_UNEXP_ERROR;
242: WHEN OKL_API.G_EXCEPTION_ERROR THEN
243: x_return_status := OKL_API.G_RET_STS_ERROR;
244: WHEN OTHERS THEN
245: OKL_API.SET_MESSAGE(p_app_name => g_app_name
246: ,p_msg_name => g_unexpected_error
247: ,p_token1 => g_sqlcode_token
248: ,p_token1_value => sqlcode
249: ,p_token2 => g_sqlerrm_token
247: ,p_token1 => g_sqlcode_token
248: ,p_token1_value => sqlcode
249: ,p_token2 => g_sqlerrm_token
250: ,p_token2_value => sqlerrm);
251: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
252: END create_trx_contracts;
253:
254: PROCEDURE create_trx_contracts(
255: p_api_version IN NUMBER
852: FETCH okl_strm_type_csr INTO
853: l_stream_type_code,
854: l_stream_type_purpose;
855: IF okl_strm_type_csr%NOTFOUND THEN
856: OKL_API.set_message(
857: p_app_name => G_APP_NAME,
858: p_msg_name => 'OKL_INVALID_VALUE',
859: p_token1 => 'COL_NAME',
860: p_token1_value => 'sty_id'