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 10: x_usage_info := fnd_message.get_string('CN', p_exp_type_code);

6: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
7: , x_usage_info OUT NOCOPY VARCHAR2
8: ) IS
9: BEGIN
10: x_usage_info := fnd_message.get_string('CN', p_exp_type_code);
11: EXCEPTION
12: WHEN OTHERS THEN
13: x_usage_info := NULL;
14: END get_usage_info;

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

45: BEGIN
46: -- parse the expression
47: IF LENGTH(p_sql_select) + LENGTH(p_sql_from) > 4000 THEN
48: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
49: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');
50: fnd_msg_pub.ADD;
51: END IF;
52:
53: RAISE fnd_api.g_exc_error;

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

86: CLOSE dummy_cur;
87: END IF;
88:
89: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
90: fnd_message.set_name('CN', 'CN_INVALID_EXP');
91: fnd_message.set_token('EXPRESSION', SQLERRM);
92: fnd_msg_pub.ADD;
93: END IF;
94:

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

87: END IF;
88:
89: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
90: fnd_message.set_name('CN', 'CN_INVALID_EXP');
91: fnd_message.set_token('EXPRESSION', SQLERRM);
92: fnd_msg_pub.ADD;
93: END IF;
94:
95: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

367: -- API body
368: IF (p_name IS NULL) THEN
369: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
370: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
371: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
372: fnd_message.set_token('OBJ_NAME', l_prompt);
373: fnd_msg_pub.ADD;
374: END IF;
375:

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

368: IF (p_name IS NULL) THEN
369: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
370: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
371: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
372: fnd_message.set_token('OBJ_NAME', l_prompt);
373: fnd_msg_pub.ADD;
374: END IF;
375:
376: RAISE fnd_api.g_exc_error;

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

381: CLOSE exp_exists;
382:
383: IF (l_dummy = 1) THEN
384: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
385: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
386: fnd_msg_pub.ADD;
387: END IF;
388:
389: RAISE fnd_api.g_exc_error;

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

391:
392: -- make sure name isn't too long
393: IF LENGTH(p_name) > 30 THEN
394: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
395: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
396: fnd_message.set_token('LENGTH', 30);
397: fnd_msg_pub.ADD;
398: END IF;
399:

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

392: -- make sure name isn't too long
393: IF LENGTH(p_name) > 30 THEN
394: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
395: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
396: fnd_message.set_token('LENGTH', 30);
397: fnd_msg_pub.ADD;
398: END IF;
399:
400: RAISE fnd_api.g_exc_error;

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

674: -- API body
675: IF (p_name IS NULL) THEN
676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
677: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
678: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
679: fnd_message.set_token('OBJ_NAME', l_prompt);
680: fnd_msg_pub.ADD;
681: END IF;
682:

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

675: IF (p_name IS NULL) THEN
676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
677: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
678: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
679: fnd_message.set_token('OBJ_NAME', l_prompt);
680: fnd_msg_pub.ADD;
681: END IF;
682:
683: RAISE fnd_api.g_exc_error;

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

688: CLOSE exp_exists;
689:
690: IF (l_dummy = 1) THEN
691: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
692: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
693: fnd_msg_pub.ADD;
694: END IF;
695:
696: RAISE fnd_api.g_exc_error;

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

702: CLOSE parent_exist;
703:
704: IF (l_dummy = 1) THEN
705: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
706: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
707: fnd_msg_pub.ADD;
708: END IF;
709:
710: RAISE fnd_api.g_exc_error;

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

979: CLOSE parent_exist;
980:
981: IF (l_dummy = 1) THEN
982: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
983: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
984: fnd_msg_pub.ADD;
985: END IF;
986:
987: RAISE fnd_api.g_exc_error;

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

1535: l_sql_sel VARCHAR2(4000);
1536: l_junk VARCHAR2(4000);
1537: BEGIN
1538: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1539: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1540: fnd_msg_pub.ADD;
1541: RAISE fnd_api.g_exc_error;
1542: END IF;
1543:

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

1677: l_current_id NUMBER;
1678: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1679: BEGIN
1680: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1681: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1682: fnd_msg_pub.ADD;
1683: RAISE fnd_api.g_exc_error;
1684: END IF;
1685:

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

1939: -- get close quote
1940: l_ix := INSTR(l_sql_select_left, '''', 2);
1941:
1942: IF l_ix = 0 THEN
1943: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
1944: fnd_msg_pub.ADD;
1945: RAISE fnd_api.g_exc_error;
1946: END IF;
1947:

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

2029: FETCH get_tbl INTO l_disp_seg, l_table_id, l_table_name;
2030: CLOSE get_tbl;
2031:
2032: IF l_disp_seg IS NULL THEN
2033: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2034: fnd_msg_pub.ADD;
2035: RAISE fnd_api.g_exc_error;
2036: END IF;
2037:

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

2058: FETCH get_col INTO l_disp_seg;
2059: CLOSE get_col;
2060:
2061: IF l_disp_seg IS NULL THEN
2062: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2063: fnd_msg_pub.ADD;
2064: RAISE fnd_api.g_exc_error;
2065: END IF;
2066:

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

2070: success := TRUE;
2071: END IF;
2072:
2073: IF ct = 400 THEN
2074: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2075: fnd_msg_pub.ADD;
2076: RAISE fnd_api.g_exc_unexpected_error;
2077: END IF;
2078:

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

2217: -- Check required field
2218: IF l_api_rec.expression_name IS NULL OR l_api_rec.sql_select IS NULL THEN
2219: l_failed_row := l_failed_row + 1;
2220: l_error_code := 'CN_IMP_MISS_REQUIRED';
2221: l_message := fnd_message.get_string('CN', 'CN_IMP_MISS_REQUIRED');
2222: cn_import_pvt.update_imp_lines(
2223: p_imp_line_id => l_api_rec.imp_line_id
2224: , p_status_code => 'FAIL'
2225: , p_error_code => l_error_code

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

2654: SET status_code = 'COMPLETE'
2655: WHERE imp_header_id = p_imp_header_id;
2656:
2657: -- set failed records - where expression was too long
2658: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');
2659: fnd_message.set_token('LENGTH', g_max_field_length);
2660: my_message := fnd_message.get;
2661:
2662: UPDATE cn_exp_api_imp_v

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

2655: WHERE imp_header_id = p_imp_header_id;
2656:
2657: -- set failed records - where expression was too long
2658: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');
2659: fnd_message.set_token('LENGTH', g_max_field_length);
2660: my_message := fnd_message.get;
2661:
2662: UPDATE cn_exp_api_imp_v
2663: SET status_code = 'FAIL'

Line 2660: my_message := fnd_message.get;

2656:
2657: -- set failed records - where expression was too long
2658: fnd_message.set_name('CN', 'CN_EXPORT_FIELD_TOO_LONG');
2659: fnd_message.set_token('LENGTH', g_max_field_length);
2660: my_message := fnd_message.get;
2661:
2662: UPDATE cn_exp_api_imp_v
2663: SET status_code = 'FAIL'
2664: , error_msg = my_message