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:

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

702:
703: END LOOP;
704: IF node_csr%rowcount = 0 THEN
705: l_message :=
706: fnd_message.get_string('CN','CN_HIER_NF_NODE');
707: l_error_code := 'CN_HIER_NF_NODE';
708: RAISE FND_API.g_exc_error;
709: END IF;
710: CLOSE node_csr;

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

985: FOR l_miss_required_csr IN c_miss_required_csr LOOP
986: l_failed_row := l_failed_row + 1;
987: l_processed_row := l_processed_row + 1;
988: l_error_code := 'CN_IMP_MISS_REQUIRED';
989: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
990: CN_IMPORT_PVT.update_imp_lines
991: (p_imp_line_id => l_miss_required_csr.imp_line_id,
992: p_status_code => 'FAIL',
993: p_error_code => l_error_code,

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

1015: FOR l_err_dflt_node_csr IN c_err_dflt_node_csr LOOP
1016: l_failed_row := l_failed_row + 1;
1017: l_processed_row := l_processed_row + 1;
1018: l_error_code := 'CN_HIER_ERR_NODEFLAG';
1019: l_message := fnd_message.get_string('CN','CN_HIER_ERR_NODEFLAG');
1020: CN_IMPORT_PVT.update_imp_lines
1021: (p_imp_line_id => l_err_dflt_node_csr.imp_line_id,
1022: p_status_code => 'FAIL',
1023: p_error_code => l_error_code,

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

1053: AND BASE_TABLE_NAME = l_base_table_csr.BASE_TABLE_NAME
1054: ;
1055: EXCEPTION
1056: WHEN TOO_MANY_ROWS THEN
1057: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');
1058: seterr_imp_hierarchy
1059: (p_hier_record => l_hier_record,
1060: p_status_code => 'FAIL',
1061: p_error_code => 'CN_HIER_MULTI_BTBL',

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

1180: ;
1181: -- parent_node_name must be null if default_node_flag = 'Y'
1182: IF l_parent_node_name IS NOT NULL THEN
1183: l_message :=
1184: fnd_message.get_string('CN','CN_HIER_WRONG_DEFNODE');
1185: l_error_code := 'CN_HIER_WRONG_DEFNODE';
1186: seterr_imp_hierarchy
1187: (p_hier_record => l_hier_record,
1188: p_status_code => 'FAIL',

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

1219: AND external_id IS NULL ;
1220:
1221: WHEN too_many_rows THEN
1222: l_message :=
1223: fnd_message.get_string('CN','CN_HIER_MULTI_DEFNODE');
1224: l_error_code := 'CN_HIER_MULTI_DEFNODE';
1225: seterr_imp_hierarchy
1226: (p_hier_record => l_hier_record,
1227: p_status_code => 'FAIL',