APPS.OKL_SETUP_PRCPARAMS_PVT dependencies on OKL_API

Line 21: NVL(DATE_END,OKL_API.G_MISS_DATE) DATE_END,

17: OBJECT_VERSION_NUMBER,
18: NAME,
19: VERSION,
20: DATE_START,
21: NVL(DATE_END,OKL_API.G_MISS_DATE) DATE_END,
22: NVL(DESCRIPTION,G_MISS_CHAR) DESCRIPTION,
23: SPS_CODE,
24: DYP_CODE,
25: ARRAY_YN,

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

98: EXCEPTION
99: WHEN OTHERS THEN
100:
101: -- store SQL error message on message stack
102: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
103: p_msg_name => G_UNEXPECTED_ERROR,
104: p_token1 => G_SQLCODE_TOKEN,
105: p_token1_value => sqlcode,
106: p_token2 => G_SQLERRM_TOKEN,

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

400: NULL;
401:
402: WHEN OTHERS THEN
403: -- store SQL error message on message stack for caller
404: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
405: p_msg_name => G_UNEXPECTED_ERROR,
406: p_token1 => G_SQLCODE_TOKEN,
407: p_token1_value => sqlcode,
408: p_token2 => G_SQLERRM_TOKEN,

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

443: -- mvasudev COMMENTED , 06/13/2002
444: --check for the records with start and end dates less than sysdate
445: IF to_date(l_sppv_rec.date_start, 'DD/MM/YYYY') < l_sysdate OR
446: to_date(l_sppv_rec.date_end, 'DD/MM/YYYY') < l_sysdate THEN
447: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
448: p_msg_name => G_PAST_RECORDS);
449: RAISE G_EXCEPTION_ERROR;
450: END IF;
451: */

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

473: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
474: x_return_status := G_RET_STS_UNEXP_ERROR;
475: WHEN OTHERS THEN
476: -- store SQL error message on message stack for caller
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 614: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

610:
611: -- check for the records if start and end dates are in the past
612: IF to_date(l_db_sppv_rec.date_start,'DD/MM/YYYY') < l_sysdate AND
613: to_date(l_db_sppv_rec.date_end,'DD/MM/YYYY') < l_sysdate THEN
614: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
615: p_msg_name => G_PAST_RECORDS);
616: RAISE G_EXCEPTION_ERROR;
617: END IF;
618:

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

625:
626: -- check for start date greater than sysdate
627: IF to_date(l_upd_sppv_rec.date_start, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY') AND
628: to_date(l_upd_sppv_rec.date_start,'DD/MM/YYYY') < l_sysdate THEN
629: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
630: p_msg_name => G_START_DATE);
631: RAISE G_EXCEPTION_ERROR;
632: END IF;
633:

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

633:
634: -- check for end date greater than sysdate
635: IF to_date(l_upd_sppv_rec.date_end, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY') AND
636: to_date(l_upd_sppv_rec.date_end,'DD/MM/YYYY') < l_sysdate THEN
637: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
638: p_msg_name => G_END_DATE);
639: RAISE G_EXCEPTION_ERROR;
640: END IF;
641:

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

642:
643: -- START_DATE , if changed, can only be later than TODAY
644: IF to_date(l_upd_sppv_rec.date_start, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY') AND
645: to_date(l_upd_sppv_rec.date_start,'DD/MM/YYYY') <= l_sysdate THEN
646: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
647: p_msg_name => G_START_DATE);
648: RAISE G_EXCEPTION_ERROR;
649: END IF;
650:

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

650:
651: -- END_DATE, if changed, cannot be earlier than TODAY
652: IF to_date(l_upd_sppv_rec.date_end, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY') AND
653: to_date(l_upd_sppv_rec.date_end,'DD/MM/YYYY') < l_sysdate THEN
654: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
655: p_msg_name => G_END_DATE);
656: RAISE G_EXCEPTION_ERROR;
657: END IF;
658:

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

840: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
841: x_return_status := G_RET_STS_UNEXP_ERROR;
842: WHEN OTHERS THEN
843: -- store SQL error message on message stack for caller
844: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
845: p_msg_name => G_UNEXPECTED_ERROR,
846: p_token1 => G_SQLCODE_TOKEN,
847: p_token1_value => sqlcode,
848: p_token2 => G_SQLERRM_TOKEN,

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

888: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
889: x_return_status := G_RET_STS_UNEXP_ERROR;
890: WHEN OTHERS THEN
891: -- store SQL error message on message stack for caller
892: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
893: p_msg_name => G_UNEXPECTED_ERROR,
894: p_token1 => G_SQLCODE_TOKEN,
895: p_token1_value => sqlcode,
896: p_token2 => G_SQLERRM_TOKEN,

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

936: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
937: x_return_status := G_RET_STS_UNEXP_ERROR;
938: WHEN OTHERS THEN
939: -- store SQL error message on message stack for caller
940: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
941: p_msg_name => G_UNEXPECTED_ERROR,
942: p_token1 => G_SQLCODE_TOKEN,
943: p_token1_value => sqlcode,
944: p_token2 => G_SQLERRM_TOKEN,