APPS.OKL_DCT_PVT dependencies on OKL_API

Line 123: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

119: IF ((p_dctv_rec.rmr_id = OKC_API.G_MISS_NUM) OR
120: (p_dctv_rec.rmr_id IS NULL))
121: THEN
122:
123: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
124: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
125: p_token1 => 'PROMPT',
126: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_REMARKETER'));
127:

Line 204: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

200: IF ((p_dctv_rec.ico_id = OKC_API.G_MISS_NUM) OR
201: (p_dctv_rec.ico_id IS NULL))
202: THEN
203:
204: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
205: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
206: p_token1 => 'PROMPT',
207: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_ITEM_CATALOG'));
208:

Line 359: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

355: IF p_dctv_rec.date_effective_from = OKC_API.G_MISS_DATE OR
356: p_dctv_rec.date_effective_from IS NULL
357: THEN
358:
359: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
360: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
361: p_token1 => 'PROMPT',
362: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_EFFECTIVE_FROM'));
363:

Line 471: SELECT NVL(date_effective_to, OKL_API.G_MISS_DATE)

467: -- Asset_Category to check for uniqueness when create of new rec
468: CURSOR okl_dctv_cre_data_csr (
469: p_rmr_id NUMBER := OKC_API.G_MISS_NUM,
470: p_ico_id NUMBER := OKC_API.G_MISS_NUM) IS
471: SELECT NVL(date_effective_to, OKL_API.G_MISS_DATE)
472: FROM OKL_DF_CTGY_RMK_TMS
473: WHERE rmr_id = p_rmr_id
474: AND ico_id = p_ico_id
475: ORDER BY date_effective_from DESC;

Line 483: SELECT NVL(date_effective_to, OKL_API.G_MISS_DATE)

479: CURSOR okl_dctv_upd_data_csr (
480: p_id NUMBER := OKC_API.G_MISS_NUM,
481: p_rmr_id NUMBER := OKC_API.G_MISS_NUM,
482: p_ico_id NUMBER := OKC_API.G_MISS_NUM) IS
483: SELECT NVL(date_effective_to, OKL_API.G_MISS_DATE)
484: FROM OKL_DF_CTGY_RMK_TMS
485: WHERE rmr_id = p_rmr_id
486: AND ico_id = p_ico_id
487: AND id <> p_id

Line 529: IF (l_date_effective_to = OKL_API.G_MISS_DATE)

525: p_dctv_rec.ico_id);
526: FETCH okl_dctv_cre_data_csr INTO l_date_effective_to;
527: IF okl_dctv_cre_data_csr%FOUND THEN
528: -- Error if the previous date_effective_to was null
529: IF (l_date_effective_to = OKL_API.G_MISS_DATE)
530: OR (l_date_effective_to IS NULL) THEN
531: -- Remarketer assignment with same Remarketer and Item Category exists with open Date Effective To, so cannot create a new assignment
532: OKC_API.SET_MESSAGE( p_app_name => 'OKL',
533: p_msg_name => 'OKL_AM_RMK_ASS_EXISTS');

Line 935: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

931: */
932: RETURN(x_return_status);
933: EXCEPTION
934: WHEN OTHERS THEN
935: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
936: ,p_msg_name => G_UNEXPECTED_ERROR
937: ,p_token1 => G_SQLCODE_TOKEN
938: ,p_token1_value => SQLCODE
939: ,p_token2 => G_SQLERRM_TOKEN

Line 941: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

937: ,p_token1 => G_SQLCODE_TOKEN
938: ,p_token1_value => SQLCODE
939: ,p_token2 => G_SQLERRM_TOKEN
940: ,p_token2_value => SQLERRM);
941: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
942: RETURN(x_return_status);
943: END Validate_Attributes;
944:
945: ---------------------------------------------------------------------------