APPS.OKL_TRX_CONTRACTS_PVT dependencies on OKL_API

Line 47: (l_tclv_tbl(i).currency_code = OKL_API.G_MISS_CHAR) THEN

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);

Line 141: OKL_API.set_message(

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'

Line 162: OKL_API.set_message(

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'

Line 211: OKL_API.set_message(

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'

Line 241: x_return_status := OKL_Api.G_RET_STS_UNEXP_ERROR;

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

Line 242: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 243: x_return_status := OKL_API.G_RET_STS_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

Line 245: OKL_API.SET_MESSAGE(p_app_name => g_app_name

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

Line 251: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 856: OKL_API.set_message(

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'