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.CN_CALC_SQL_EXPS_PVT dependencies on FND_MESSAGE

Line 17: x_usage_info := fnd_message.get_string('CN', p_exp_type_code);

13: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
14: , x_usage_info OUT NOCOPY VARCHAR2
15: ) IS
16: BEGIN
17: x_usage_info := fnd_message.get_string('CN', p_exp_type_code);
18: EXCEPTION
19: WHEN OTHERS THEN
20: x_usage_info := NULL;
21: END get_usage_info;

Line 55: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');

51: BEGIN
52: -- parse the expression
53: IF LENGTH(p_sql_select) + LENGTH(p_sql_from) > 4000 THEN
54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
55: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');
56: fnd_msg_pub.ADD;
57: END IF;
58:
59: RAISE fnd_api.g_exc_error;

Line 96: fnd_message.set_name('CN', 'CN_INVALID_EXP');

92: CLOSE dummy_cur;
93: END IF;
94:
95: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
96: fnd_message.set_name('CN', 'CN_INVALID_EXP');
97: fnd_message.set_token('EXPRESSION', SQLERRM);
98: fnd_msg_pub.ADD;
99: END IF;
100:

Line 97: fnd_message.set_token('EXPRESSION', SQLERRM);

93: END IF;
94:
95: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
96: fnd_message.set_name('CN', 'CN_INVALID_EXP');
97: fnd_message.set_token('EXPRESSION', SQLERRM);
98: fnd_msg_pub.ADD;
99: END IF;
100:
101: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 377: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

373: -- API body
374: IF (p_name IS NULL) THEN
375: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
376: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
377: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
378: fnd_message.set_token('OBJ_NAME', l_prompt);
379: fnd_msg_pub.ADD;
380: END IF;
381:

Line 378: fnd_message.set_token('OBJ_NAME', l_prompt);

374: IF (p_name IS NULL) THEN
375: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
376: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
377: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
378: fnd_message.set_token('OBJ_NAME', l_prompt);
379: fnd_msg_pub.ADD;
380: END IF;
381:
382: RAISE fnd_api.g_exc_error;

Line 391: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');

387: CLOSE exp_exists;
388:
389: IF (l_dummy = 1) THEN
390: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
391: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
392: fnd_msg_pub.ADD;
393: END IF;
394:
395: RAISE fnd_api.g_exc_error;

Line 401: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');

397:
398: -- make sure name isn't too long
399: IF LENGTH(p_name) > 30 THEN
400: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
401: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
402: fnd_message.set_token('LENGTH', 30);
403: fnd_msg_pub.ADD;
404: END IF;
405:

Line 402: fnd_message.set_token('LENGTH', 30);

398: -- make sure name isn't too long
399: IF LENGTH(p_name) > 30 THEN
400: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
401: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
402: fnd_message.set_token('LENGTH', 30);
403: fnd_msg_pub.ADD;
404: END IF;
405:
406: RAISE fnd_api.g_exc_error;

Line 685: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

681: -- API body
682: IF (p_name IS NULL) THEN
683: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
684: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
685: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
686: fnd_message.set_token('OBJ_NAME', l_prompt);
687: fnd_msg_pub.ADD;
688: END IF;
689:

Line 686: fnd_message.set_token('OBJ_NAME', l_prompt);

682: IF (p_name IS NULL) THEN
683: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
684: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
685: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
686: fnd_message.set_token('OBJ_NAME', l_prompt);
687: fnd_msg_pub.ADD;
688: END IF;
689:
690: RAISE fnd_api.g_exc_error;

Line 699: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');

695: CLOSE exp_exists;
696:
697: IF (l_dummy = 1) THEN
698: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
699: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
700: fnd_msg_pub.ADD;
701: END IF;
702:
703: RAISE fnd_api.g_exc_error;

Line 713: fnd_message.set_name('CN', 'CN_EXP_IN_USE');

709: CLOSE parent_exist;
710:
711: IF (l_dummy = 1) THEN
712: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
713: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
714: fnd_msg_pub.ADD;
715: END IF;
716:
717: RAISE fnd_api.g_exc_error;

Line 991: fnd_message.set_name('CN', 'CN_EXP_IN_USE');

987: CLOSE parent_exist;
988:
989: IF (l_dummy = 1) THEN
990: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
991: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
992: fnd_msg_pub.ADD;
993: END IF;
994:
995: RAISE fnd_api.g_exc_error;

Line 1547: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');

1543: l_sql_sel VARCHAR2(4000);
1544: l_junk VARCHAR2(4000);
1545: BEGIN
1546: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1547: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1548: fnd_msg_pub.ADD;
1549: RAISE fnd_api.g_exc_error;
1550: END IF;
1551:

Line 1688: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');

1684: l_current_id NUMBER;
1685: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1686: BEGIN
1687: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1688: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1689: fnd_msg_pub.ADD;
1690: RAISE fnd_api.g_exc_error;
1691: END IF;
1692:

Line 1962: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');

1958: -- get close quote
1959: l_ix := INSTR(l_sql_select_left, '''', 2);
1960:
1961: IF l_ix = 0 THEN
1962: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
1963: fnd_msg_pub.ADD;
1964: RAISE fnd_api.g_exc_error;
1965: END IF;
1966:

Line 2052: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');

2048: FETCH get_tbl INTO l_disp_seg, l_table_id, l_table_name;
2049: CLOSE get_tbl;
2050:
2051: IF l_disp_seg IS NULL THEN
2052: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2053: fnd_msg_pub.ADD;
2054: RAISE fnd_api.g_exc_error;
2055: END IF;
2056:

Line 2081: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');

2077: FETCH get_col INTO l_disp_seg;
2078: CLOSE get_col;
2079:
2080: IF l_disp_seg IS NULL THEN
2081: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2082: fnd_msg_pub.ADD;
2083: RAISE fnd_api.g_exc_error;
2084: END IF;
2085:

Line 2093: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');

2089: success := TRUE;
2090: END IF;
2091:
2092: IF ct = 400 THEN
2093: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_unexpected_error;
2096: END IF;
2097:

Line 2239: l_message := fnd_message.get_string('CN', 'CN_IMP_MISS_REQUIRED');

2235: -- Check required field
2236: IF l_api_rec.expression_name IS NULL OR l_api_rec.sql_select IS NULL THEN
2237: l_failed_row := l_failed_row + 1;
2238: l_error_code := 'CN_IMP_MISS_REQUIRED';
2239: l_message := fnd_message.get_string('CN', 'CN_IMP_MISS_REQUIRED');
2240: cn_import_pvt.update_imp_lines(
2241: p_imp_line_id => l_api_rec.imp_line_id
2242: , p_status_code => 'FAIL'
2243: , p_error_code => l_error_code

Line 2676: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');

2672: SET status_code = 'COMPLETE'
2673: WHERE imp_header_id = p_imp_header_id;
2674:
2675: -- set failed records - where expression was too long
2676: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');
2677: fnd_message.set_token('LENGTH', g_max_field_length);
2678: my_message := fnd_message.get;
2679:
2680: UPDATE cn_exp_api_imp_v

Line 2677: fnd_message.set_token('LENGTH', g_max_field_length);

2673: WHERE imp_header_id = p_imp_header_id;
2674:
2675: -- set failed records - where expression was too long
2676: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');
2677: fnd_message.set_token('LENGTH', g_max_field_length);
2678: my_message := fnd_message.get;
2679:
2680: UPDATE cn_exp_api_imp_v
2681: SET status_code = 'FAIL'

Line 2678: my_message := fnd_message.get;

2674:
2675: -- set failed records - where expression was too long
2676: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');
2677: fnd_message.set_token('LENGTH', g_max_field_length);
2678: my_message := fnd_message.get;
2679:
2680: UPDATE cn_exp_api_imp_v
2681: SET status_code = 'FAIL'
2682: , error_msg = my_message