APPS.CCT_VALIDATION_PUB dependencies on FND_NEW_MESSAGES

Line 89: FROM FND_NEW_MESSAGES

85: x_err_msg_count := x_err_msg_count + 1;
86: x_err_msgs.extend();
87: l_msg_code := 'CCT_PARAM_ERR_PREVIEW_WC';
88: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
89: FROM FND_NEW_MESSAGES
90: WHERE LANGUAGE_CODE = p_env_lang
91: -- (SELECT LANGUAGE_CODE
92: -- FROM FND_LANGUAGES
93: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 107: FROM FND_NEW_MESSAGES

103: x_err_msg_count := x_err_msg_count + 1;
104: x_err_msgs.extend();
105: l_msg_code := 'CCT_PARAM_ERR_MAX_PREVIEW_TIME';
106: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
107: FROM FND_NEW_MESSAGES
108: WHERE LANGUAGE_CODE = p_env_lang
109: -- (SELECT LANGUAGE_CODE
110: -- FROM FND_LANGUAGES
111: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 256: FROM FND_NEW_MESSAGES

252: IF l_currVal is NULL THEN
253: x_err_msgs.EXTEND;
254: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
255: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
256: FROM FND_NEW_MESSAGES
257: WHERE LANGUAGE_CODE = p_env_lang
258: -- (SELECT LANGUAGE_CODE
259: -- FROM FND_LANGUAGES
260: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 270: FROM FND_NEW_MESSAGES

266: IF l_currVal = ' ' THEN
267: x_err_msgs.EXTEND;
268: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
269: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
270: FROM FND_NEW_MESSAGES
271: WHERE LANGUAGE_CODE = p_env_lang
272: -- (SELECT LANGUAGE_CODE
273: -- FROM FND_LANGUAGES
274: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 295: FROM FND_NEW_MESSAGES

291: IF l_currVal is NULL THEN
292: x_err_msgs.EXTEND;
293: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
294: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
295: FROM FND_NEW_MESSAGES
296: WHERE LANGUAGE_CODE = p_env_lang
297: -- (SELECT LANGUAGE_CODE
298: -- FROM FND_LANGUAGES
299: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 309: FROM FND_NEW_MESSAGES

305: IF l_currVal = ' ' THEN
306: x_err_msgs.EXTEND;
307: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
308: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
309: FROM FND_NEW_MESSAGES
310: WHERE LANGUAGE_CODE = p_env_lang
311: -- (SELECT LANGUAGE_CODE
312: -- FROM FND_LANGUAGES
313: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 358: FROM FND_NEW_MESSAGES

354: IF l_tempNum > 0 THEN
355: x_err_msgs.EXTEND;
356: l_msg_code := 'CCT_PARAM_ERR_ITS_MW_MONITERED';
357: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
358: FROM FND_NEW_MESSAGES
359: WHERE LANGUAGE_CODE = p_env_lang
360: -- (SELECT LANGUAGE_CODE
361: -- FROM FND_LANGUAGES
362: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 390: FROM FND_NEW_MESSAGES

386: IF l_tempNum > 0 THEN
387: x_err_msgs.EXTEND;
388: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MONITERED';
389: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
390: FROM FND_NEW_MESSAGES
391: WHERE LANGUAGE_CODE = p_env_lang
392: -- (SELECT LANGUAGE_CODE
393: -- FROM FND_LANGUAGES
394: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 407: FROM FND_NEW_MESSAGES

403: -- Has route point defined, but no mw
404: x_err_msgs.EXTEND;
405: l_msg_code := 'CCT_PARAM_ERR_ITS_MW_UNDEFINED';
406: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
407: FROM FND_NEW_MESSAGES
408: WHERE LANGUAGE_CODE = p_env_lang
409: -- (SELECT LANGUAGE_CODE
410: -- FROM FND_LANGUAGES
411: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 428: FROM FND_NEW_MESSAGES

424: --dbms_output.put_line('route pt and mw do not matched!!! rp param:' || l_rp_param_pos);
425: x_err_msgs.EXTEND;
426: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
427: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
428: FROM FND_NEW_MESSAGES
429: WHERE LANGUAGE_CODE = p_env_lang
430: -- (SELECT LANGUAGE_CODE
431: -- FROM FND_LANGUAGES
432: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 452: FROM FND_NEW_MESSAGES

448: -- Route Points taken by some other ITS
449: x_err_msgs.EXTEND;
450: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MONITERED';
451: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
452: FROM FND_NEW_MESSAGES
453: WHERE LANGUAGE_CODE = p_env_lang
454: -- (SELECT LANGUAGE_CODE
455: -- FROM FND_LANGUAGES
456: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 551: FROM FND_NEW_MESSAGES

547: x_err_msg_count := x_err_msg_count + 1;
548: x_err_msgs.extend();
549: l_msg_code := 'CCT_PARAM_ERR_PRIORITY_TIMEOUT';
550: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
551: FROM FND_NEW_MESSAGES
552: WHERE LANGUAGE_CODE = p_env_lang
553: -- (SELECT LANGUAGE_CODE
554: -- FROM FND_LANGUAGES
555: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 605: FROM FND_NEW_MESSAGES

601: x_err_msg_count := x_err_msg_count + 1;
602: x_err_msgs.extend();
603: l_msg_code := 'CCT_PARAM_ERR_WC';
604: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
605: FROM FND_NEW_MESSAGES
606: WHERE LANGUAGE_CODE = p_env_lang
607: AND APPLICATION_ID = 172
608: AND MESSAGE_NAME = l_msg_code;
609: end if;