DBA Data[Home] [Help]

APPS.OKL_FORMULAEVALUATE_PVT dependencies on OKL_API

Line 350: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

346: -- End of comments
347:
348: PROCEDURE EVA_GetParameterValues(
349: p_api_version IN NUMBER
350: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
351: ,x_return_status OUT NOCOPY VARCHAR2
352: ,x_msg_count OUT NOCOPY NUMBER
353: ,x_msg_data OUT NOCOPY VARCHAR2
354: ,p_fma_id IN NUMBER

Line 362: x_return_status := OKL_API.G_RET_STS_SUCCESS;

358: IS
359: l_formula_exist BOOLEAN := FALSE;
360: l_count NUMBER;
361: BEGIN
362: x_return_status := OKL_API.G_RET_STS_SUCCESS;
363:
364: /** SBALASHA001 -
365: INFO: Validate whether the formula
366: has context and the formula exists in

Line 383: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

379: p_ctx_parameter_tbl => x_ctx_parameter_tbl );
380: ELSE
381: /** SBALASHA001 -
382: INFO: raise formula not found exception **/
383: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
384: p_msg_name => G_FORMULA_NOT_FOUND,
385: p_token1 => G_EVALUATE_TOKEN,
386: p_token1_value => p_fma_id);
387: -- notify UNEXPECTED error for calling API.

Line 388: x_return_status := OKL_API.G_RET_STS_ERROR;

384: p_msg_name => G_FORMULA_NOT_FOUND,
385: p_token1 => G_EVALUATE_TOKEN,
386: p_token1_value => p_fma_id);
387: -- notify UNEXPECTED error for calling API.
388: x_return_status := OKL_API.G_RET_STS_ERROR;
389: END IF;
390:
391: /** SBALASHA001 -
392: INFO: Call Evaluate Parameter function to

Line 395: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS )

391: /** SBALASHA001 -
392: INFO: Call Evaluate Parameter function to
393: actually do the evaluation and populate
394: parameter table with values **/
395: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS )
396: THEN
397: x_ctx_parameter_tbl :=
398: EVA_EvaluateParameters(
399: p_contract_id => p_contract_id,

Line 410: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

406: -- no processing necessary;
407: NULL;
408: WHEN OTHERS THEN
409: -- store SQL error message on message stack
410: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
411: p_msg_name => g_unexpected_error,
412: p_token1 => g_sqlcode_token,
413: p_token1_value => sqlcode,
414: p_token2 => g_sqlerrm_token,

Line 417: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

413: p_token1_value => sqlcode,
414: p_token2 => g_sqlerrm_token,
415: p_token2_value => sqlerrm);
416: -- notify UNEXPECTED error for calling API.
417: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
418: END EVA_GetParameterValues;
419:
420:
421: -- Start of comments

Line 436: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

432: -- End of comments
433:
434: PROCEDURE EVA_GetFunctionValue(
435: p_api_version IN NUMBER
436: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
437: ,x_return_status OUT NOCOPY VARCHAR2
438: ,x_msg_count OUT NOCOPY NUMBER
439: ,x_msg_data OUT NOCOPY VARCHAR2
440: ,p_fma_id IN NUMBER

Line 449: x_return_status := OKL_API.G_RET_STS_SUCCESS;

445: IS
446: l_FunctionString VARCHAR2(720);
447: l_dummy NUMBER;
448: BEGIN
449: x_return_status := OKL_API.G_RET_STS_SUCCESS;
450:
451: /** SBALASHA001 -
452: INFO: Get all the PL/SQL function name for the given
453: formula identifier. **/

Line 477: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

473: -- no processing necessary;
474: null;
475: WHEN OTHERS THEN
476: -- store SQL error message on message stack
477: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
478: p_msg_name => g_unexpected_error,
479: p_token1 => g_sqlcode_token,
480: p_token1_value => sqlcode,
481: p_token2 => g_sqlerrm_token,

Line 484: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

480: p_token1_value => sqlcode,
481: p_token2 => g_sqlerrm_token,
482: p_token2_value => sqlerrm);
483: -- notify UNEXPECTED error for calling API.
484: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
485: END EVA_GetFunctionValue;
486:
487: END OKL_FORMULAEVALUATE_PVT;