APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKC_API

Line 441: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

437: -- History :
438: -- End of comments
439: ------------------------------------------------------------------------------*/
440: PROCEDURE execute_system_validation(p_api_version IN NUMBER
441: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2
445: ,p_function_name IN okl_data_src_fnctns_v.name%TYPE

Line 505: x_return_status := OKC_API.G_RET_STS_SUCCESS;

501:
502: IF l_value IS NULL THEN
503: RAISE FUNCTION_RETURNS_NULL;
504: ELSE
505: x_return_status := OKC_API.G_RET_STS_SUCCESS;
506: x_value := l_value;
507: END IF;
508:
509: EXCEPTION

Line 511: OKC_API.SET_MESSAGE(p_app_name => g_app_name

507: END IF;
508:
509: EXCEPTION
510: WHEN FUNCTION_RETURNS_NULL THEN
511: OKC_API.SET_MESSAGE(p_app_name => g_app_name
512: ,p_msg_name => 'OKL_FUNCTION_RETURNS_NULL'
513: ,p_token1 => 'FUNCTION'
514: ,p_token1_value => l_function_name );
515: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 515: x_return_status := OKC_API.G_RET_STS_ERROR;

511: OKC_API.SET_MESSAGE(p_app_name => g_app_name
512: ,p_msg_name => 'OKL_FUNCTION_RETURNS_NULL'
513: ,p_token1 => 'FUNCTION'
514: ,p_token1_value => l_function_name );
515: x_return_status := OKC_API.G_RET_STS_ERROR;
516:
517: WHEN FUNCTION_DATA_INVALID THEN
518: OKC_API.SET_MESSAGE(p_app_name => g_app_name
519: ,p_msg_name => g_function_data_invalid

Line 518: OKC_API.SET_MESSAGE(p_app_name => g_app_name

514: ,p_token1_value => l_function_name );
515: x_return_status := OKC_API.G_RET_STS_ERROR;
516:
517: WHEN FUNCTION_DATA_INVALID THEN
518: OKC_API.SET_MESSAGE(p_app_name => g_app_name
519: ,p_msg_name => g_function_data_invalid
520: ,p_token1 => 'FUNCTION'
521: ,p_token1_value => l_function_name );
522: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 522: x_return_status := OKC_API.G_RET_STS_ERROR;

518: OKC_API.SET_MESSAGE(p_app_name => g_app_name
519: ,p_msg_name => g_function_data_invalid
520: ,p_token1 => 'FUNCTION'
521: ,p_token1_value => l_function_name );
522: x_return_status := OKC_API.G_RET_STS_ERROR;
523:
524: WHEN NO_DATA_FOUND THEN
525: OKC_API.SET_MESSAGE(p_app_name => g_app_name
526: ,p_msg_name => g_invalid_function

Line 525: OKC_API.SET_MESSAGE(p_app_name => g_app_name

521: ,p_token1_value => l_function_name );
522: x_return_status := OKC_API.G_RET_STS_ERROR;
523:
524: WHEN NO_DATA_FOUND THEN
525: OKC_API.SET_MESSAGE(p_app_name => g_app_name
526: ,p_msg_name => g_invalid_function
527: ,p_token1 => 'FUNCTION'
528: ,p_token1_value => l_function_name );
529: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 529: x_return_status := OKC_API.G_RET_STS_ERROR;

525: OKC_API.SET_MESSAGE(p_app_name => g_app_name
526: ,p_msg_name => g_invalid_function
527: ,p_token1 => 'FUNCTION'
528: ,p_token1_value => l_function_name );
529: x_return_status := OKC_API.G_RET_STS_ERROR;
530:
531: WHEN OTHERS THEN
532: okl_api.set_message(p_app_name => g_app_name
533: ,p_msg_name => 'OKL_SYSTEM_VALIDATION_FAILED'

Line 537: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

533: ,p_msg_name => 'OKL_SYSTEM_VALIDATION_FAILED'
534: ,p_token1 => 'NAME'
535: ,p_token1_value => l_function_name);
536:
537: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
538: END execute_system_validation;
539: /*------------------------------------------------------------------------------
540: -- PROCEDURE populate_result_table
541: ------------------------------------------------------------------------------

Line 871: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

867: p_token2_value => sqlcode,
868: p_token3 => G_SQLERRM_TOKEN,
869: p_token3_value => sqlerrm);
870: -- notify UNEXPECTED error
871: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
872: END validate_payment_options;
873: --------------------------------------------------------------------------------
874: /**
875: This function Check whether the Quote Level Payments Options Enterd or Not

Line 926: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

922: p_token2_value => sqlcode,
923: p_token3 => G_SQLERRM_TOKEN,
924: p_token3_value => sqlerrm);
925: -- notify UNEXPECTED error
926: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
927:
928: END are_qte_pricing_opts_entered;
929: --------------------------------------------------------------------------------
930: /**

Line 1021: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1017: p_token2_value => sqlcode,
1018: p_token3 => G_SQLERRM_TOKEN,
1019: p_token3_value => sqlerrm);
1020: -- notify UNEXPECTED error
1021: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1022:
1023: END are_all_lines_overriden;
1024:
1025: /*------------------------------------------------------------------------------