eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUP_PRD_PRCTEMPL_PVT dependencies on OKL_API

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

78: EXCEPTION
79: WHEN OTHERS THEN
80:
81: -- store SQL error message on message stack
82: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
83: p_msg_name => G_UNEXPECTED_ERROR,
84: p_token1 => G_SQLCODE_TOKEN,
85: p_token1_value => SQLCODE,
86: p_token2 => G_SQLERRM_TOKEN,

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

270: p_attribute_code => 'OKL_PRODUCT'
271: );
272:
273:
274: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
275: p_msg_name => G_DATES_MISMATCH,
276: p_token1 => G_PARENT_TABLE_TOKEN,
277: p_token1_value => l_token1_value,
278: p_token2 => G_CHILD_TABLE_TOKEN,

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

285:
286: EXCEPTION
287: WHEN OTHERS THEN
288: -- store SQL error message on message stack
289: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
290: p_msg_name => G_UNEXPECTED_ERROR,
291: p_token1 => G_SQLCODE_TOKEN,
292: p_token1_value => SQLCODE,
293: p_token2 => G_SQLERRM_TOKEN,

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

366: NULL;
367:
368: WHEN OTHERS THEN
369: -- store SQL error message on message stack for caller
370: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
371: p_msg_name => G_UNEXPECTED_ERROR,
372: p_token1 => G_SQLCODE_TOKEN,
373: p_token1_value => SQLCODE,
374: p_token2 => G_SQLERRM_TOKEN,

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

411: -- mvasudev COMMENTED , 06/13/2002
412: --check for the records with start and end dates less than sysdate
413: IF TO_DATE(l_pitv_rec.start_date, 'DD/MM/YYYY') < l_sysdate OR
414: TO_DATE(l_pitv_rec.end_date, 'DD/MM/YYYY') < l_sysdate THEN
415: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
416: p_msg_name => G_PAST_RECORDS);
417: RAISE G_EXCEPTION_ERROR;
418: END IF;
419: */

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

457: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
458: x_return_status := G_RET_STS_UNEXP_ERROR;
459: WHEN OTHERS THEN
460: -- store SQL error message on message stack for caller
461: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
462: p_msg_name => G_UNEXPECTED_ERROR,
463: p_token1 => G_SQLCODE_TOKEN,
464: p_token1_value => SQLCODE,
465: p_token2 => G_SQLERRM_TOKEN,

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

623:
624: -- check for the records if start and end dates are in the past
625: IF TO_DATE(l_db_pitv_rec.start_date,'DD/MM/YYYY') < l_sysdate AND
626: TO_DATE(l_db_pitv_rec.end_date,'DD/MM/YYYY') < l_sysdate THEN
627: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
628: p_msg_name => G_PAST_RECORDS);
629: RAISE G_EXCEPTION_ERROR;
630: END IF;
631:

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

641: -- mvasudev, 02/17/2002
642: -- check for start date greater than sysdate
643: IF to_date(l_upd_pitv_rec.start_date, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY') AND
644: to_date(l_upd_pitv_rec.start_date,'DD/MM/YYYY') < l_sysdate THEN
645: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
646: p_msg_name => G_START_DATE);
647: RAISE G_EXCEPTION_ERROR;
648: END IF;
649:

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

649:
650: -- check for end date greater than sysdate
651: IF to_date(l_upd_pitv_rec.end_date, 'DD/MM/YYYY') <> to_date(G_MISS_DATE, 'DD/MM/YYYY') AND
652: to_date(l_upd_pitv_rec.end_date,'DD/MM/YYYY') < l_sysdate THEN
653: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
654: p_msg_name => G_END_DATE);
655: RAISE G_EXCEPTION_ERROR;
656: END IF;
657:

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

658:
659: -- START_DATE , if changed, can only be later than TODAY
660: IF TO_DATE(l_upd_pitv_rec.start_date, 'DD/MM/YYYY') <> TO_DATE(G_MISS_DATE, 'DD/MM/YYYY') AND
661: TO_DATE(l_upd_pitv_rec.start_date,'DD/MM/YYYY') <= l_sysdate THEN
662: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
663: p_msg_name => G_START_DATE);
664: RAISE G_EXCEPTION_ERROR;
665: END IF;
666:

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

666:
667: -- END_DATE, if changed, cannot be earlier than TODAY
668: IF TO_DATE(l_upd_pitv_rec.end_date, 'DD/MM/YYYY') <> TO_DATE(G_MISS_DATE, 'DD/MM/YYYY') AND
669: TO_DATE(l_upd_pitv_rec.end_date,'DD/MM/YYYY') < l_sysdate THEN
670: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
671: p_msg_name => G_END_DATE);
672: RAISE G_EXCEPTION_ERROR;
673: END IF;
674:

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

853: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
854: x_return_status := G_RET_STS_UNEXP_ERROR;
855: WHEN OTHERS THEN
856: -- store SQL error message on message stack for caller
857: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
858: p_msg_name => G_UNEXPECTED_ERROR,
859: p_token1 => G_SQLCODE_TOKEN,
860: p_token1_value => SQLCODE,
861: p_token2 => G_SQLERRM_TOKEN,

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

900: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
901: x_return_status := G_RET_STS_UNEXP_ERROR;
902: WHEN OTHERS THEN
903: -- store SQL error message on message stack for caller
904: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
905: p_msg_name => G_UNEXPECTED_ERROR,
906: p_token1 => G_SQLCODE_TOKEN,
907: p_token1_value => SQLCODE,
908: p_token2 => G_SQLERRM_TOKEN,

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

946: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
947: x_return_status := G_RET_STS_UNEXP_ERROR;
948: WHEN OTHERS THEN
949: -- store SQL error message on message stack for caller
950: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
951: p_msg_name => G_UNEXPECTED_ERROR,
952: p_token1 => G_SQLCODE_TOKEN,
953: p_token1_value => SQLCODE,
954: p_token2 => G_SQLERRM_TOKEN,

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

1033: x_return_status := G_RET_STS_UNEXP_ERROR;
1034: WHEN OTHERS THEN
1035: x_validated := G_FALSE;
1036: -- store SQL error message on message stack for caller
1037: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1038: p_msg_name => G_UNEXPECTED_ERROR,
1039: p_token1 => G_SQLCODE_TOKEN,
1040: p_token1_value => SQLCODE,
1041: p_token2 => G_SQLERRM_TOKEN,

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

1095: WHEN OTHERS THEN
1096: x_validated := G_FALSE;
1097: x_return_status := G_RET_STS_UNEXP_ERROR;
1098: -- store SQL error message on message stack for caller
1099: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1100: p_msg_name => G_UNEXPECTED_ERROR,
1101: p_token1 => G_SQLCODE_TOKEN,
1102: p_token1_value => SQLCODE,
1103: p_token2 => G_SQLERRM_TOKEN,