DBA Data[Home] [Help]

APPS.CN_RULEATTRIBUTE_PVT dependencies on FND_MESSAGE

Line 79: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');

75: exception
76: when value_error then
77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
78: THEN
79: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
80: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
81: fnd_message.set_token('RULE_NAME', l_rule_name);
82: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
83: fnd_msg_pub.add;

Line 80: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);

76: when value_error then
77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
78: THEN
79: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
80: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
81: fnd_message.set_token('RULE_NAME', l_rule_name);
82: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
83: fnd_msg_pub.add;
84: END IF;

Line 81: fnd_message.set_token('RULE_NAME', l_rule_name);

77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
78: THEN
79: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
80: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
81: fnd_message.set_token('RULE_NAME', l_rule_name);
82: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
83: fnd_msg_pub.add;
84: END IF;
85: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';

Line 82: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);

78: THEN
79: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
80: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
81: fnd_message.set_token('RULE_NAME', l_rule_name);
82: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
83: fnd_msg_pub.add;
84: END IF;
85: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';
86: end ;

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

92: exception
93: when others then
94: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
95: THEN
96: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
97: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
98: fnd_message.set_token('RULE_NAME', l_rule_name);
99: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
100: fnd_msg_pub.add;

Line 97: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);

93: when others then
94: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
95: THEN
96: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
97: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
98: fnd_message.set_token('RULE_NAME', l_rule_name);
99: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
100: fnd_msg_pub.add;
101: END IF;

Line 98: fnd_message.set_token('RULE_NAME', l_rule_name);

94: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
95: THEN
96: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
97: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
98: fnd_message.set_token('RULE_NAME', l_rule_name);
99: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
100: fnd_msg_pub.add;
101: END IF;
102: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';

Line 99: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);

95: THEN
96: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
97: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
98: fnd_message.set_token('RULE_NAME', l_rule_name);
99: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
100: fnd_msg_pub.add;
101: END IF;
102: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';
103: end ;

Line 118: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');

114: exception
115: when value_error then
116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
117: THEN
118: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
119: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
120: fnd_message.set_token('RULE_NAME', l_rule_name);
121: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
122: fnd_msg_pub.add;

Line 119: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);

115: when value_error then
116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
117: THEN
118: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
119: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
120: fnd_message.set_token('RULE_NAME', l_rule_name);
121: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
122: fnd_msg_pub.add;
123: END IF;

Line 120: fnd_message.set_token('RULE_NAME', l_rule_name);

116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
117: THEN
118: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
119: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
120: fnd_message.set_token('RULE_NAME', l_rule_name);
121: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
122: fnd_msg_pub.add;
123: END IF;
124: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';

Line 121: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);

117: THEN
118: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
119: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
120: fnd_message.set_token('RULE_NAME', l_rule_name);
121: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
122: fnd_msg_pub.add;
123: END IF;
124: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';
125: RAISE FND_API.G_EXC_ERROR;

Line 137: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');

133: exception
134: when others then
135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
136: THEN
137: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
138: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
139: fnd_message.set_token('RULE_NAME', l_rule_name);
140: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
141: fnd_msg_pub.add;

Line 138: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);

134: when others then
135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
136: THEN
137: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
138: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
139: fnd_message.set_token('RULE_NAME', l_rule_name);
140: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
141: fnd_msg_pub.add;
142: END IF;

Line 139: fnd_message.set_token('RULE_NAME', l_rule_name);

135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
136: THEN
137: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
138: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
139: fnd_message.set_token('RULE_NAME', l_rule_name);
140: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
141: fnd_msg_pub.add;
142: END IF;
143: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';

Line 140: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);

136: THEN
137: fnd_message.set_name('CN', 'CN_DATATYPE_VALUE_MISMATCH');
138: fnd_message.set_token('CLASSIFICATION_RULE_NAME', l_ruleset_name);
139: fnd_message.set_token('RULE_NAME', l_rule_name);
140: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
141: fnd_msg_pub.add;
142: END IF;
143: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';
144: end ;

Line 297: fnd_message.set_name('CN', 'CN_INVALID_RULE_ATTR_TYPE');

293: THEN
294: --Error condition
295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
296: THEN
297: fnd_message.set_name('CN', 'CN_INVALID_RULE_ATTR_TYPE');
298: fnd_msg_pub.add;
299: END IF;
300: x_loading_status := 'CN_INVALID_RULE_ATTR_TYPE';
301: RAISE FND_API.G_EXC_ERROR;

Line 309: fnd_message.set_name('CN', 'CN_INVALID_RULE_ATTR_TYPE');

305: THEN
306: --Error condition
307: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
308: THEN
309: fnd_message.set_name('CN', 'CN_INVALID_RULE_ATTR_TYPE');
310: fnd_msg_pub.add;
311: END IF;
312: x_loading_status := 'CN_INVALID_RULE_ATTR_TYPE';
313: RAISE FND_API.G_EXC_ERROR;

Line 322: fnd_message.set_name('CN', 'CN_INVALID_PARAM_ONE_VAL');

318: THEN
319: --Error condition
320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
321: THEN
322: fnd_message.set_name('CN', 'CN_INVALID_PARAM_ONE_VAL');
323: fnd_msg_pub.add;
324: END IF;
325: x_loading_status := 'CN_INVALID_PARAM_ONE_VAL';
326: RAISE FND_API.G_EXC_ERROR;

Line 333: fnd_message.set_name('CN', 'CN_INVALID_PARAM_R_H');

329: (p_value_1 IS NULL OR p_value_2 IS NULL)))
330: THEN
331: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
332: THEN
333: fnd_message.set_name('CN', 'CN_INVALID_PARAM_R_H');
334: fnd_msg_pub.add;
335: END IF;
336: x_loading_status := 'CN_INVALID_PARAM_R_H';
337: RAISE FND_API.G_EXC_ERROR;

Line 357: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_NAME');

353: EXCEPTION
354: WHEN no_data_found then
355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
356: THEN
357: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_NAME');
358: fnd_msg_pub.add;
359: END IF;
360: x_loading_status := 'CN_INVALID_OBJECT_NAME';
361: RAISE FND_API.G_EXC_ERROR;

Line 410: fnd_message.set_name('CN', 'CN_HIGH_LOW');

406: to_number(p_value_2) < to_number(p_value_1) THEN
407:
408: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
409: THEN
410: fnd_message.set_name('CN', 'CN_HIGH_LOW');
411: fnd_msg_pub.add;
412: END IF;
413: x_loading_status := 'CN_HIGH_LOW';
414: RAISE FND_API.G_EXC_ERROR;

Line 471: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');

467: EXCEPTION
468: WHEN no_data_found then
469: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
470: THEN
471: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
472: fnd_msg_pub.add;
473: END IF;
474: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
475: RAISE FND_API.G_EXC_ERROR;

Line 495: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');

491: EXCEPTION
492: WHEN no_data_found then
493: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
494: THEN
495: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
496: fnd_msg_pub.add;
497: END IF;
498: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
499: RAISE FND_API.G_EXC_ERROR;

Line 539: fnd_message.set_name('CN', 'CN_MULTIPLE_ATTRIBUTES');

535: THEN
536: --Error condition
537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
538: THEN
539: fnd_message.set_name('CN', 'CN_MULTIPLE_ATTRIBUTES');
540: fnd_msg_pub.add;
541: END IF;
542: x_loading_status := 'CN_MULTIPLE_ATTRIBUTES';
543: RAISE FND_API.G_EXC_ERROR;

Line 1097: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');

1093: p_ruleattribute_rec.object_version_number) THEN
1094:
1095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1096: THEN
1097: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1098: fnd_msg_pub.add;
1099: END IF;
1100:
1101: x_loading_status := 'CN_INVALID_OBJECT_VERSION';

Line 1194: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');

1190:
1191: WHEN no_data_found then
1192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1193: THEN
1194: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
1195: fnd_msg_pub.add;
1196: END IF;
1197: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
1198: RAISE FND_API.G_EXC_ERROR;

Line 1219: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');

1215:
1216: WHEN no_data_found then
1217: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1218: THEN
1219: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
1220: fnd_msg_pub.add;
1221: END IF;
1222: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
1223: RAISE FND_API.G_EXC_ERROR;

Line 1423: fnd_message.set_name('CN', 'CN_EXPRESSION_EXISTS');

1419: THEN
1420: --Error condition
1421: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1422: THEN
1423: fnd_message.set_name('CN', 'CN_EXPRESSION_EXISTS');
1424: fnd_msg_pub.add;
1425: END IF;
1426:
1427: x_loading_status := 'CN_EXPRESSION_EXISTS';

Line 1450: fnd_message.set_name('CN', 'CN_INVALID_ATTRIBUTE_RULE');

1446: THEN
1447: --Error condition
1448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1449: THEN
1450: fnd_message.set_name('CN', 'CN_INVALID_ATTRIBUTE_RULE');
1451: fnd_msg_pub.add;
1452: END IF;
1453:
1454: x_loading_status := 'CN_INVALID_ATTRIBUTE_RULE';

Line 1468: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');

1464: if (l_object_version_number <> p_object_version_number) THEN
1465:
1466: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1467: THEN
1468: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1469: fnd_msg_pub.add;
1470: END IF;
1471:
1472: x_loading_status := 'CN_INVALID_OBJECT_VERSION';