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_RULEATTRIBUTE_PVT dependencies on FND_MSG_PUB

Line 77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

73: Begin
74: l_value := to_number(nvl(p_value_1,'0'));
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);

Line 83: fnd_msg_pub.add;

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 ;
87:

Line 94: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

90: Begin
91: l_date_value := nvl(to_date(p_value_1,'DD/MM/RRRR'),sysdate);
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);

Line 100: fnd_msg_pub.add;

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 ;
104:

Line 116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

112: l_value := to_number(nvl(p_value_1,'0'));
113: l_value := to_number(nvl(p_value_2,'0'));
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);

Line 122: fnd_msg_pub.add;

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;
126: end ;

Line 135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

131: l_date_value := nvl(to_date(p_value_1,'DD/MM/RRRR'),sysdate);
132: l_date_value := nvl(to_date(p_value_2,'DD/MM/RRRR'),sysdate);
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);

Line 141: fnd_msg_pub.add;

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 ;
145:

Line 295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

291: OR
292: p_data_flag IS NULL
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;

Line 298: fnd_msg_pub.add;

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;
302: END IF;

Line 307: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

303:
304: IF p_data_flag NOT IN ('O', 'H', 'R')
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;

Line 310: fnd_msg_pub.add;

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;
314: ELSE

Line 320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

316: ((p_value_1 = FND_API.g_miss_char) OR (p_value_1 IS NULL)) OR
317: ((p_object_name = FND_API.g_miss_char) OR (p_object_name IS NULL))
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;

Line 323: fnd_msg_pub.add;

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;
327: ELSIF (p_data_flag IN ('R', 'H') AND

Line 331: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

327: ELSIF (p_data_flag IN ('R', 'H') AND
328: ((p_value_1 = FND_API.G_MISS_CHAR OR p_value_2 = FND_API.G_MISS_CHAR) OR
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;

Line 334: fnd_msg_pub.add;

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;
338: END IF;

Line 355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

351: WHERE name = p_object_name AND org_id=p_org_id
352: AND table_id IN (-11803,-16134);
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;

Line 358: fnd_msg_pub.add;

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;
362: END;

Line 408: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

404: IF p_value_1 IS NOT NULL AND
405: p_value_2 IS NOT NULL AND
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;

Line 411: fnd_msg_pub.add;

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;
415: END IF;

Line 469: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

465: WHERE head_hierarchy_id = p_value_1 and org_id=p_org_id;
466:
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;

Line 472: fnd_msg_pub.add;

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;
476: END;

Line 493: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

489: AND dh.header_dim_hierarchy_id = l_dim_hierarchy_id;
490:
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;

Line 496: fnd_msg_pub.add;

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;
500: END;

Line 537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

533:
534: IF l_counter > 0
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;

Line 540: fnd_msg_pub.add;

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;
544: END IF;

Line 567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

563: RETURN fnd_api.g_true;
564:
565: WHEN OTHERS THEN
566: x_loading_status := 'UNEXPECTED_ERR';
567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
570: END IF;
571: RETURN fnd_api.g_true;

Line 569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

565: WHEN OTHERS THEN
566: x_loading_status := 'UNEXPECTED_ERR';
567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
570: END IF;
571: RETURN fnd_api.g_true;
572: END Check_AttributeRuleParameters;
573:

Line 657: FND_MSG_PUB.initialize;

653:
654: -- Initialize message list if p_init_msg_list is set to TRUE.
655: IF FND_API.to_Boolean( p_init_msg_list )
656: THEN
657: FND_MSG_PUB.initialize;
658: END IF;
659:
660: -- Initialize API return status to success
661: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 849: FND_MSG_PUB.Count_And_Get

845: COMMIT WORK;
846: END IF;
847:
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get
850: (p_count => x_msg_count,
851: p_data => x_msg_data,
852: p_encoded => fnd_api.g_false
853: );

Line 858: FND_MSG_PUB.Count_And_Get

854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO Create_RuleAttribute;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get
859: (p_count => x_msg_count,
860: p_data => x_msg_data,
861: p_encoded => fnd_api.g_false
862: );

Line 867: FND_MSG_PUB.Count_And_Get

863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO Create_RuleAttribute;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866: x_loading_status := 'UNEXPECTED_ERR';
867: FND_MSG_PUB.Count_And_Get
868: (p_count => x_msg_count,
869: p_data => x_msg_data,
870: p_encoded => fnd_api.g_false
871: );

Line 876: IF FND_MSG_PUB.Check_Msg_Level

872: WHEN OTHERS THEN
873: ROLLBACK TO Create_RuleAttribute;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: x_loading_status := 'UNEXPECTED_ERR';
876: IF FND_MSG_PUB.Check_Msg_Level
877: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME,l_api_name);

Line 877: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

873: ROLLBACK TO Create_RuleAttribute;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: x_loading_status := 'UNEXPECTED_ERR';
876: IF FND_MSG_PUB.Check_Msg_Level
877: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME,l_api_name);
881: END IF;

Line 879: FND_MSG_PUB.Add_Exc_Msg

875: x_loading_status := 'UNEXPECTED_ERR';
876: IF FND_MSG_PUB.Check_Msg_Level
877: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME,l_api_name);
881: END IF;
882: FND_MSG_PUB.Count_And_Get
883: (p_count => x_msg_count,

Line 882: FND_MSG_PUB.Count_And_Get

878: THEN
879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME,l_api_name);
881: END IF;
882: FND_MSG_PUB.Count_And_Get
883: (p_count => x_msg_count,
884: p_data => x_msg_data,
885: p_encoded => fnd_api.g_false
886: );

Line 985: FND_MSG_PUB.initialize;

981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list )
984: THEN
985: FND_MSG_PUB.initialize;
986: END IF;
987:
988: -- Initialize API return status to success
989: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1091:
1092: if (l_object_version_number <>
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;

Line 1098: fnd_msg_pub.add;

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';
1102: RAISE FND_API.G_EXC_ERROR;

Line 1192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1188:
1189: EXCEPTION
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;

Line 1195: fnd_msg_pub.add;

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;
1199:

Line 1217: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1213:
1214: EXCEPTION
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;

Line 1220: fnd_msg_pub.add;

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;
1224:

Line 1261: FND_MSG_PUB.Count_And_Get

1257: x_org_id =>p_RuleAttribute_rec.org_id);
1258:
1259:
1260: -- Standard call to get message count and if count is 1, get message info.
1261: FND_MSG_PUB.Count_And_Get
1262: (p_count => x_msg_count,
1263: p_data => x_msg_data,
1264: p_encoded => fnd_api.g_false
1265: );

Line 1270: FND_MSG_PUB.Count_And_Get

1266: EXCEPTION
1267: WHEN FND_API.G_EXC_ERROR THEN
1268: ROLLBACK TO Update_RuleAttribute;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get
1271: (p_count => x_msg_count,
1272: p_data => x_msg_data,
1273: p_encoded => fnd_api.g_false
1274: );

Line 1279: FND_MSG_PUB.Count_And_Get

1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: ROLLBACK TO Update_RuleAttribute;
1277: x_loading_status := 'UNEXPECTED_ERR';
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279: FND_MSG_PUB.Count_And_Get
1280: (p_count => x_msg_count,
1281: p_data => x_msg_data,
1282: p_encoded => fnd_api.g_false
1283: );

Line 1288: IF FND_MSG_PUB.Check_Msg_Level

1284: WHEN OTHERS THEN
1285: ROLLBACK TO Update_RuleAttribute;
1286: x_loading_status := 'UNEXPECTED_ERR';
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1288: IF FND_MSG_PUB.Check_Msg_Level
1289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1290: THEN
1291: FND_MSG_PUB.Add_Exc_Msg
1292: (G_PKG_NAME,

Line 1289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1285: ROLLBACK TO Update_RuleAttribute;
1286: x_loading_status := 'UNEXPECTED_ERR';
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1288: IF FND_MSG_PUB.Check_Msg_Level
1289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1290: THEN
1291: FND_MSG_PUB.Add_Exc_Msg
1292: (G_PKG_NAME,
1293: l_api_name

Line 1291: FND_MSG_PUB.Add_Exc_Msg

1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1288: IF FND_MSG_PUB.Check_Msg_Level
1289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1290: THEN
1291: FND_MSG_PUB.Add_Exc_Msg
1292: (G_PKG_NAME,
1293: l_api_name
1294: );
1295: END IF;

Line 1296: FND_MSG_PUB.Count_And_Get

1292: (G_PKG_NAME,
1293: l_api_name
1294: );
1295: END IF;
1296: FND_MSG_PUB.Count_And_Get
1297: (p_count => x_msg_count,
1298: p_data => x_msg_data,
1299: p_encoded => fnd_api.g_false
1300: );

Line 1397: FND_MSG_PUB.initialize;

1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1400: -- Initialize API return status to success
1401: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1421: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1417:
1418: IF l_count <> 0
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;

Line 1424: fnd_msg_pub.add;

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';
1428: RAISE FND_API.G_EXC_ERROR;

Line 1448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1444:
1445: IF l_count <> 1
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;

Line 1451: fnd_msg_pub.add;

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';
1455: RAISE FND_API.G_EXC_ERROR;

Line 1466: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1462: CLOSE l_ovn_csr;
1463:
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;

Line 1469: fnd_msg_pub.add;

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';
1473: RAISE FND_API.G_EXC_ERROR;

Line 1495: FND_MSG_PUB.Count_And_Get

1491: COMMIT WORK;
1492: END IF;
1493:
1494: -- Standard call to get message count and if count is 1, get message info.
1495: FND_MSG_PUB.Count_And_Get
1496: (p_count => x_msg_count,
1497: p_data => x_msg_data,
1498: p_encoded => fnd_api.g_false
1499: );

Line 1504: FND_MSG_PUB.Count_And_Get

1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR THEN
1502: ROLLBACK TO Delete_RuleAttribute;
1503: x_return_status := FND_API.G_RET_STS_ERROR ;
1504: FND_MSG_PUB.Count_And_Get
1505: (p_count => x_msg_count,
1506: p_data => x_msg_data,
1507: p_encoded => fnd_api.g_false
1508: );

Line 1513: FND_MSG_PUB.Count_And_Get

1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510: ROLLBACK TO Delete_RuleAttribute;
1511: x_loading_status := 'UNEXPECTED_ERR';
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: FND_MSG_PUB.Count_And_Get
1514: (p_count => x_msg_count,
1515: p_data => x_msg_data,
1516: p_encoded => fnd_api.g_false
1517: );

Line 1522: IF FND_MSG_PUB.Check_Msg_Level

1518: WHEN OTHERS THEN
1519: ROLLBACK TO Delete_RuleAttribute;
1520: x_loading_status := 'UNEXPECTED_ERR';
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Add_Exc_Msg
1526: (G_PKG_NAME,

Line 1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1519: ROLLBACK TO Delete_RuleAttribute;
1520: x_loading_status := 'UNEXPECTED_ERR';
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Add_Exc_Msg
1526: (G_PKG_NAME,
1527: l_api_name

Line 1525: FND_MSG_PUB.Add_Exc_Msg

1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Add_Exc_Msg
1526: (G_PKG_NAME,
1527: l_api_name
1528: );
1529: END IF;

Line 1530: FND_MSG_PUB.Count_And_Get

1526: (G_PKG_NAME,
1527: l_api_name
1528: );
1529: END IF;
1530: FND_MSG_PUB.Count_And_Get
1531: (p_count => x_msg_count,
1532: p_data => x_msg_data,
1533: p_encoded => fnd_api.g_false
1534: );