APPS.OKL_AM_CONSOLIDATED_QTE_PVT dependencies on OKC_API

Line 86: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,

82: OPEN get_quote_values_csr (lp_qtev_tbl(i).id);
83: FETCH get_quote_values_csr INTO get_quote_values_rec;
84: IF get_quote_values_csr%NOTFOUND OR get_quote_values_rec.id IS NULL THEN
85: -- Invalid value for id.
86: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
87: p_msg_name => OKC_API.G_INVALID_VALUE,
88: p_token1 => G_COL_NAME_TOKEN,
89: p_token1_value => 'id');
90: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 87: p_msg_name => OKC_API.G_INVALID_VALUE,

83: FETCH get_quote_values_csr INTO get_quote_values_rec;
84: IF get_quote_values_csr%NOTFOUND OR get_quote_values_rec.id IS NULL THEN
85: -- Invalid value for id.
86: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
87: p_msg_name => OKC_API.G_INVALID_VALUE,
88: p_token1 => G_COL_NAME_TOKEN,
89: p_token1_value => 'id');
90: RAISE G_EXCEPTION_HALT_VALIDATION;
91: END IF;

Line 495: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,

491: -- Check if first quote already part of another consolidated quote
492: IF (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id IS NOT NULL)
493: AND (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id <> OKL_API.G_MISS_NUM) THEN
494: -- Invalid value for consolidated_qte_id.
495: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
496: p_msg_name => OKC_API.G_INVALID_VALUE,
497: p_token1 => G_COL_NAME_TOKEN,
498: p_token1_value => 'consolidated_qte_id');
499:

Line 496: p_msg_name => OKC_API.G_INVALID_VALUE,

492: IF (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id IS NOT NULL)
493: AND (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id <> OKL_API.G_MISS_NUM) THEN
494: -- Invalid value for consolidated_qte_id.
495: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
496: p_msg_name => OKC_API.G_INVALID_VALUE,
497: p_token1 => G_COL_NAME_TOKEN,
498: p_token1_value => 'consolidated_qte_id');
499:
500: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 635: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,

631: -- Check if quote already part of another consolidated quote
632: IF (l_qtev_tbl(i).consolidated_qte_id IS NOT NULL)
633: AND (l_qtev_tbl(i).consolidated_qte_id <> OKL_API.G_MISS_NUM)THEN
634: -- Invalid value for consolidated_qte_id.
635: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
636: p_msg_name => OKC_API.G_INVALID_VALUE,
637: p_token1 => G_COL_NAME_TOKEN,
638: p_token1_value => 'consolidated_qte_id');
639: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 636: p_msg_name => OKC_API.G_INVALID_VALUE,

632: IF (l_qtev_tbl(i).consolidated_qte_id IS NOT NULL)
633: AND (l_qtev_tbl(i).consolidated_qte_id <> OKL_API.G_MISS_NUM)THEN
634: -- Invalid value for consolidated_qte_id.
635: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
636: p_msg_name => OKC_API.G_INVALID_VALUE,
637: p_token1 => G_COL_NAME_TOKEN,
638: p_token1_value => 'consolidated_qte_id');
639: RAISE G_EXCEPTION_HALT_VALIDATION;
640: END IF;