DBA Data[Home] [Help]

APPS.OKL_SETUP_PRCPARAMS_PVT dependencies on OKC_API

Line 534: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

530: ( TO_DATE(l_sppv_rec.date_end, 'DD/MM/YYYY') < TO_DATE(l_sppv_rec.DATE_START, 'DD/MM/YYYY')
531: OR TO_DATE(l_sppv_rec.date_end, 'DD/MM/YYYY') < l_sysdate
532: )
533: THEN
534: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
535: p_msg_name => G_INVALID_VALUE,
536: p_token1 => G_COL_NAME_TOKEN,
537: p_token1_value => 'date_end' );
538: RAISE G_EXCEPTION_ERROR;

Line 558: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

554: -- start date can not be greater than old start date if the record is active
555: IF TO_DATE(l_db_sppv_rec.DATE_START,'DD/MM/YYYY') < l_sysdate
556: AND TO_DATE(l_sppv_rec.DATE_START, 'DD/MM/YYYY') > TO_DATE(l_db_sppv_rec.DATE_START, 'DD/MM/YYYY')
557: THEN
558: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
559: p_msg_name => G_INVALID_VALUE,
560: p_token1 => G_COL_NAME_TOKEN,
561: p_token1_value => 'DATE_START' );
562: RAISE G_EXCEPTION_ERROR;

Line 593: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,

589: IF l_sppv_rec.date_end IS NOT NULL
590: AND to_date(l_sppv_rec.date_end, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY')
591: AND to_date(l_sppv_rec.date_end, 'DD/MM/YYYY') < to_date(l_sppv_rec.date_start, 'DD/MM/YYYY')
592: THEN
593: OKC_API.SET_MESSAGE( p_app_name => OKC_API.G_APP_NAME,
594: p_msg_name => G_INVALID_VALUE,
595: p_token1 => G_COL_NAME_TOKEN,
596: p_token1_value => 'END_DATE' );
597: END IF;