DBA Data[Home] [Help]

APPS.CN_IMP_HIERARCHY_PVT dependencies on FND_MESSAGE

Line 142: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');

138: EXCEPTION
139: -- Check if has multiple BASE_TABLE_NAME,PRIMARY_KEY,HIERARCHY_VALUE for
140: -- the same hierarchy type within this import
141: WHEN TOO_MANY_ROWS THEN
142: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');
143: l_error_code := 'CN_HIER_MULTI_BTBL';
144: p_hier_record.base_table_name := fnd_api.G_MISS_CHAR ;
145: p_hier_record.primary_key := fnd_api.G_MISS_CHAR ;
146: p_hier_record.hierarchy_value := fnd_api.G_MISS_CHAR ;

Line 159: l_message := fnd_message.get_string('CN','CN_HIER_NF_BTBL');

155: ;
156: EXCEPTION
157: -- base table not exist in cn_obj_tables_v
158: WHEN NO_DATA_FOUND THEN
159: l_message := fnd_message.get_string('CN','CN_HIER_NF_BTBL');
160: l_error_code := 'CN_HIER_NF_BTBL';
161: RAISE FND_API.g_exc_error;
162: END;
163: cn_message_pkg.debug('-- Base table ID = ' || x_base_table_id);

Line 174: l_message := fnd_message.get_string('CN','CN_HIER_NF_PKEY');

170: ;
171: EXCEPTION
172: -- primary_key not exist
173: WHEN NO_DATA_FOUND THEN
174: l_message := fnd_message.get_string('CN','CN_HIER_NF_PKEY');
175: l_error_code := 'CN_HIER_NF_PKEY';
176: RAISE FND_API.g_exc_error;
177: END;
178: cn_message_pkg.debug('-- PK ID = ' || x_primary_key_id);

Line 190: l_message := fnd_message.get_string('CN','CN_HIER_NF_HIERVAL');

186: ;
187: EXCEPTION
188: -- hierarchy_value not exist
189: WHEN NO_DATA_FOUND THEN
190: l_message := fnd_message.get_string('CN','CN_HIER_NF_HIERVAL');
191: l_error_code := 'CN_HIER_NF_HIERVAL';
192: RAISE FND_API.g_exc_error;
193: END;
194: cn_message_pkg.debug('-- Hier value ID = ' || x_hier_value_id);

Line 212: l_message := fnd_message.get_string('CN','CN_HIER_DUP_BTBL');

208: AND name = p_hier_record.base_table_name and org_id=p_org_id
209: ;
210: EXCEPTION
211: WHEN no_data_found THEN
212: l_message := fnd_message.get_string('CN','CN_HIER_DUP_BTBL');
213: l_error_code := 'CN_HIER_DUP_BTBL';
214: RAISE FND_API.g_exc_error;
215: END;
216:

Line 257: l_message := fnd_message.get_string('CN','CN_HIER_NOTMATCH');

253: AND user_column_name = 'Y' and org_id=p_org_id
254: ;
255: EXCEPTION
256: WHEN no_data_found THEN
257: l_message := fnd_message.get_string('CN','CN_HIER_NOTMATCH');
258: l_error_code := 'CN_HIER_NOTMATCH';
259: RAISE FND_API.g_exc_error;
260: END;
261:

Line 646: l_message := fnd_message.get_string('CN','CN_HIER_NN_DFLTNODE');

642:
643: IF l_hierarchy_node_csr.parent_node_name IS NOT NULL THEN
644: -- parent_node_name must be null for default Base Node
645: IF l_hierarchy_node_csr.default_node_flag = 'Y' THEN
646: l_message := fnd_message.get_string('CN','CN_HIER_NN_DFLTNODE');
647: l_error_code := 'CN_HIER_NN_DFLTNODE';
648: RAISE FND_API.g_exc_error;
649: END IF;
650:

Line 670: fnd_message.get_string('CN','CN_HIER_NF_PARENT_NODE');

666: EXCEPTION
667: WHEN no_data_found THEN
668: -- parent_node not exist in cn_hierarchy_nodes
669: l_message :=
670: fnd_message.get_string('CN','CN_HIER_NF_PARENT_NODE');
671: l_error_code := 'CN_HIER_NF_PARENT_NODE';
672: RAISE FND_API.g_exc_error;
673: END;
674: END IF;

Line 700: fnd_message.get_string('CN','CN_HIER_NF_NODE');

696:
697: END LOOP;
698: IF node_csr%rowcount = 0 THEN
699: l_message :=
700: fnd_message.get_string('CN','CN_HIER_NF_NODE');
701: l_error_code := 'CN_HIER_NF_NODE';
702: RAISE FND_API.g_exc_error;
703: END IF;
704: CLOSE node_csr;

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

979: FOR l_miss_required_csr IN c_miss_required_csr LOOP
980: l_failed_row := l_failed_row + 1;
981: l_processed_row := l_processed_row + 1;
982: l_error_code := 'CN_IMP_MISS_REQUIRED';
983: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
984: CN_IMPORT_PVT.update_imp_lines
985: (p_imp_line_id => l_miss_required_csr.imp_line_id,
986: p_status_code => 'FAIL',
987: p_error_code => l_error_code,

Line 1013: l_message := fnd_message.get_string('CN','CN_HIER_ERR_NODEFLAG');

1009: FOR l_err_dflt_node_csr IN c_err_dflt_node_csr LOOP
1010: l_failed_row := l_failed_row + 1;
1011: l_processed_row := l_processed_row + 1;
1012: l_error_code := 'CN_HIER_ERR_NODEFLAG';
1013: l_message := fnd_message.get_string('CN','CN_HIER_ERR_NODEFLAG');
1014: CN_IMPORT_PVT.update_imp_lines
1015: (p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1016: p_status_code => 'FAIL',
1017: p_error_code => l_error_code,

Line 1051: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');

1047: AND BASE_TABLE_NAME = l_base_table_csr.BASE_TABLE_NAME
1048: ;
1049: EXCEPTION
1050: WHEN TOO_MANY_ROWS THEN
1051: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');
1052: seterr_imp_hierarchy
1053: (p_hier_record => l_hier_record,
1054: p_status_code => 'FAIL',
1055: p_error_code => 'CN_HIER_MULTI_BTBL',

Line 1178: fnd_message.get_string('CN','CN_HIER_WRONG_DEFNODE');

1174: ;
1175: -- parent_node_name must be null if default_node_flag = 'Y'
1176: IF l_parent_node_name IS NOT NULL THEN
1177: l_message :=
1178: fnd_message.get_string('CN','CN_HIER_WRONG_DEFNODE');
1179: l_error_code := 'CN_HIER_WRONG_DEFNODE';
1180: seterr_imp_hierarchy
1181: (p_hier_record => l_hier_record,
1182: p_status_code => 'FAIL',

Line 1217: fnd_message.get_string('CN','CN_HIER_MULTI_DEFNODE');

1213: AND external_id IS NULL ;
1214:
1215: WHEN too_many_rows THEN
1216: l_message :=
1217: fnd_message.get_string('CN','CN_HIER_MULTI_DEFNODE');
1218: l_error_code := 'CN_HIER_MULTI_DEFNODE';
1219: seterr_imp_hierarchy
1220: (p_hier_record => l_hier_record,
1221: p_status_code => 'FAIL',