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 904: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

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

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

916:
917: -- check for start date greater than sysdate
918: 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
919: to_date(to_char(l_upd_styv_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
920: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
921: p_msg_name => G_START_DATE);
922: RAISE G_EXCEPTION_ERROR;
923: END IF;
924:

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

924:
925: -- check for end date greater than sysdate
926: 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
927: to_date(to_char(l_upd_styv_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
928: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
929: p_msg_name => G_END_DATE);
930: RAISE G_EXCEPTION_ERROR;
931: END IF;
932:

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

934:
935: -- START_DATE , if changed, can only be later than TODAY
936: 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
937: to_date(to_char(l_upd_styv_rec.start_date,'DD/MM/YYYY'),'DD/MM/YYYY') <= l_sysdate THEN
938: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
939: p_msg_name => G_START_DATE);
940: RAISE G_EXCEPTION_ERROR;
941: END IF;
942:

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

942:
943: -- END_DATE, if changed, cannot be earlier than TODAY
944: 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
945: to_date(to_char(l_upd_styv_rec.end_date,'DD/MM/YYYY'),'DD/MM/YYYY') < l_sysdate THEN
946: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
947: p_msg_name => G_END_DATE);
948: RAISE G_EXCEPTION_ERROR;
949: END IF;
950:

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

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

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

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

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

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