APPS.OKL_SETUP_STREAMTYPES_PVT dependencies on OKL_API

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

115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: -- store SQL error message on message stack
119: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
120: p_msg_name => G_UNEXPECTED_ERROR,
121: p_token1 => G_SQLCODE_TOKEN,
122: p_token1_value => SQLCODE,
123: p_token2 => G_SQLERRM_TOKEN,

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

646: */
647:
648: WHEN OTHERS THEN
649: -- store SQL error message on message stack for caller
650: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
651: p_msg_name => G_UNEXPECTED_ERROR,
652: p_token1 => G_SQLCODE_TOKEN,
653: p_token1_value => SQLCODE,
654: p_token2 => G_SQLERRM_TOKEN,

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

695: -- mvasudev COMMENTED , 06/13/2002
696: -- check for the records with start and end dates less than sysdate *
697: IF TO_DATE(to_char(l_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate OR
698: TO_DATE(to_char(l_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') < l_sysdate THEN
699: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
700: p_msg_name => G_PAST_RECORDS);
701: RAISE G_EXCEPTION_ERROR;
702: END IF;
703: */

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

727: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := G_RET_STS_UNEXP_ERROR;
729: WHEN OTHERS THEN
730: -- store SQL error message on message stack for caller
731: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
732: p_msg_name => G_UNEXPECTED_ERROR,
733: p_token1 => G_SQLCODE_TOKEN,
734: p_token1_value => SQLCODE,
735: p_token2 => G_SQLERRM_TOKEN,

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

896:
897: /* check for the records if start and end dates are in the past *
898: IF to_date(to_char(l_db_styv_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate AND
899: to_date(to_char(l_db_styv_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => G_PAST_RECORDS);
902: RAISE G_EXCEPTION_ERROR;
903: END IF;
904:

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

912:
913: -- check for start date greater than sysdate
914: IF to_date(to_char(l_upd_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
915: to_date(to_char(l_upd_styv_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
916: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
917: p_msg_name => G_START_DATE);
918: RAISE G_EXCEPTION_ERROR;
919: END IF;
920:

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

920:
921: -- check for end date greater than sysdate
922: IF to_date(to_char(l_upd_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
923: to_date(to_char(l_upd_styv_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
924: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
925: p_msg_name => G_END_DATE);
926: RAISE G_EXCEPTION_ERROR;
927: END IF;
928:

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

930:
931: -- START_DATE , if changed, can only be later than TODAY
932: IF to_date(to_char(l_upd_styv_rec.start_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
933: to_date(to_char(l_upd_styv_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') <= l_sysdate THEN
934: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
935: p_msg_name => G_START_DATE);
936: RAISE G_EXCEPTION_ERROR;
937: END IF;
938:

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

938:
939: -- END_DATE, if changed, cannot be earlier than TODAY
940: IF to_date(to_char(l_upd_styv_rec.end_date,'DD/MM/YYYY'), 'DD/MM/YYYY') <> to_date(to_char(G_MISS_DATE,'DD/MM/YYYY'), 'DD/MM/YYYY') AND
941: to_date(to_char(l_upd_styv_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
942: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
943: p_msg_name => G_END_DATE);
944: RAISE G_EXCEPTION_ERROR;
945: END IF;
946:

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

1127: CLOSE l_okl_styv_pk_csr;
1128: END IF;
1129: WHEN OTHERS THEN
1130: -- store SQL error message on message stack for caller
1131: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1132: p_msg_name => G_UNEXPECTED_ERROR,
1133: p_token1 => G_SQLCODE_TOKEN,
1134: p_token1_value => SQLCODE,
1135: p_token2 => G_SQLERRM_TOKEN,

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

1180: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1181: x_return_status := G_RET_STS_UNEXP_ERROR;
1182: WHEN OTHERS THEN
1183: -- store SQL error message on message stack for caller
1184: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1185: p_msg_name => G_UNEXPECTED_ERROR,
1186: p_token1 => G_SQLCODE_TOKEN,
1187: p_token1_value => SQLCODE,
1188: p_token2 => G_SQLERRM_TOKEN,

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

1232: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1233: x_return_status := G_RET_STS_UNEXP_ERROR;
1234: WHEN OTHERS THEN
1235: -- store SQL error message on message stack for caller
1236: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1237: p_msg_name => G_UNEXPECTED_ERROR,
1238: p_token1 => G_SQLCODE_TOKEN,
1239: p_token1_value => SQLCODE,
1240: p_token2 => G_SQLERRM_TOKEN,