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 264: FROM FND_NEW_MESSAGES

260: IF l_currVal is NULL THEN
261: x_err_msgs.EXTEND;
262: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
263: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
264: FROM FND_NEW_MESSAGES
265: WHERE LANGUAGE_CODE = p_env_lang
266: -- (SELECT LANGUAGE_CODE
267: -- FROM FND_LANGUAGES
268: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 278: FROM FND_NEW_MESSAGES

274: IF l_currVal = ' ' THEN
275: x_err_msgs.EXTEND;
276: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
277: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
278: FROM FND_NEW_MESSAGES
279: WHERE LANGUAGE_CODE = p_env_lang
280: -- (SELECT LANGUAGE_CODE
281: -- FROM FND_LANGUAGES
282: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 303: FROM FND_NEW_MESSAGES

299: IF l_currVal is NULL THEN
300: x_err_msgs.EXTEND;
301: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
302: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
303: FROM FND_NEW_MESSAGES
304: WHERE LANGUAGE_CODE = p_env_lang
305: -- (SELECT LANGUAGE_CODE
306: -- FROM FND_LANGUAGES
307: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 317: FROM FND_NEW_MESSAGES

313: IF l_currVal = ' ' THEN
314: x_err_msgs.EXTEND;
315: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
316: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
317: FROM FND_NEW_MESSAGES
318: WHERE LANGUAGE_CODE = p_env_lang
319: -- (SELECT LANGUAGE_CODE
320: -- FROM FND_LANGUAGES
321: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 366: FROM FND_NEW_MESSAGES

362: IF l_tempNum > 0 THEN
363: x_err_msgs.EXTEND;
364: l_msg_code := 'CCT_PARAM_ERR_ITS_MW_MONITERED';
365: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
366: FROM FND_NEW_MESSAGES
367: WHERE LANGUAGE_CODE = p_env_lang
368: -- (SELECT LANGUAGE_CODE
369: -- FROM FND_LANGUAGES
370: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 398: FROM FND_NEW_MESSAGES

394: IF l_tempNum > 0 THEN
395: x_err_msgs.EXTEND;
396: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MONITERED';
397: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
398: FROM FND_NEW_MESSAGES
399: WHERE LANGUAGE_CODE = p_env_lang
400: -- (SELECT LANGUAGE_CODE
401: -- FROM FND_LANGUAGES
402: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 415: FROM FND_NEW_MESSAGES

411: -- Has route point defined, but no mw
412: x_err_msgs.EXTEND;
413: l_msg_code := 'CCT_PARAM_ERR_ITS_MW_UNDEFINED';
414: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
415: FROM FND_NEW_MESSAGES
416: WHERE LANGUAGE_CODE = p_env_lang
417: -- (SELECT LANGUAGE_CODE
418: -- FROM FND_LANGUAGES
419: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 436: FROM FND_NEW_MESSAGES

432: --dbms_output.put_line('route pt and mw do not matched!!! rp param:' || l_rp_param_pos);
433: x_err_msgs.EXTEND;
434: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
435: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
436: FROM FND_NEW_MESSAGES
437: WHERE LANGUAGE_CODE = p_env_lang
438: -- (SELECT LANGUAGE_CODE
439: -- FROM FND_LANGUAGES
440: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 460: FROM FND_NEW_MESSAGES

456: -- Route Points taken by some other ITS
457: x_err_msgs.EXTEND;
458: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MONITERED';
459: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
460: FROM FND_NEW_MESSAGES
461: WHERE LANGUAGE_CODE = p_env_lang
462: -- (SELECT LANGUAGE_CODE
463: -- FROM FND_LANGUAGES
464: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 559: FROM FND_NEW_MESSAGES

555: x_err_msg_count := x_err_msg_count + 1;
556: x_err_msgs.extend();
557: l_msg_code := 'CCT_PARAM_ERR_PRIORITY_TIMEOUT';
558: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
559: FROM FND_NEW_MESSAGES
560: WHERE LANGUAGE_CODE = p_env_lang
561: -- (SELECT LANGUAGE_CODE
562: -- FROM FND_LANGUAGES
563: -- WHERE NLS_LANGUAGE = p_env_lang)

Line 613: FROM FND_NEW_MESSAGES

609: x_err_msg_count := x_err_msg_count + 1;
610: x_err_msgs.extend();
611: l_msg_code := 'CCT_PARAM_ERR_WC';
612: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
613: FROM FND_NEW_MESSAGES
614: WHERE LANGUAGE_CODE = p_env_lang
615: AND APPLICATION_ID = 172
616: AND MESSAGE_NAME = l_msg_code;
617: end if;