94: -- API body
95: if p_revenue_class_rec.name is NULL THEN
96: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
97: THEN
98: fnd_message.set_name('CN', 'CN_REV_NAME_NOT_NULL');
99: fnd_msg_pub.add;
100: END IF;
101: x_loading_status := 'CN_REV_NAME_NOT_NULL';
102: RAISE FND_API.G_EXC_ERROR;
111: IF l_count >= 1 THEN
112:
113: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
114: THEN
115: fnd_message.set_name('CN', 'CN_REV_CLASS_DUPLICATE');
116: fnd_msg_pub.add;
117: END IF;
118: x_loading_status := 'CN_REV_CLASS_DUPLICATE';
119: RAISE FND_API.G_EXC_ERROR;
274:
275: if p_revenue_class_rec.name is null THEN
276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
277: THEN
278: fnd_message.set_name('CN', 'CN_REV_CLS_NOT_NULL');
279: fnd_msg_pub.add;
280: END IF;
281: x_loading_status := 'CN_REV_CLS_NOT_NULL';
282: RAISE FND_API.G_EXC_ERROR;
284:
285: if p_revenue_class_rec.revenue_Class_id is null THEN
286: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
287: THEN
288: fnd_message.set_name('CN', 'CN_REV_CLS_NOT_NULL');
289: fnd_msg_pub.add;
290: END IF;
291: x_loading_status := 'CN_REV_CLS_NOT_NULL';
292: RAISE FND_API.G_EXC_ERROR;
302: IF l_count >= 1 THEN
303:
304: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
305: THEN
306: fnd_message.set_name('CN', 'CN_REV_CLASS_DUPLICATE');
307: fnd_msg_pub.add;
308: END IF;
309: x_loading_status := 'CN_REV_CLASS_DUPLICATE';
310: RAISE FND_API.G_EXC_ERROR;
320: nvl(p_revenue_class_rec.object_version_number,1)) THEN
321:
322: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
323: THEN
324: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
325: fnd_msg_pub.add;
326: END IF;
327:
328: x_loading_status := 'CN_INVALID_OBJECT_VERSION';
543:
544: IF (l_total_count <> 0) THEN
545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
546: THEN
547: fnd_message.set_name('CN','REV_CLS_EXISTS_SW');
548: fnd_message.set_token('REV', l_revenue_class_name);
549: fnd_message.set_token('RULE_COUNT', l_rule_count);
550: fnd_message.set_token('QUOTA_RULE_COUNT',l_quota_rule_count);
551: fnd_message.set_token('HIERARCHY_COUNT', l_hierarchy_count);
544: IF (l_total_count <> 0) THEN
545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
546: THEN
547: fnd_message.set_name('CN','REV_CLS_EXISTS_SW');
548: fnd_message.set_token('REV', l_revenue_class_name);
549: fnd_message.set_token('RULE_COUNT', l_rule_count);
550: fnd_message.set_token('QUOTA_RULE_COUNT',l_quota_rule_count);
551: fnd_message.set_token('HIERARCHY_COUNT', l_hierarchy_count);
552: fnd_msg_pub.add;
545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
546: THEN
547: fnd_message.set_name('CN','REV_CLS_EXISTS_SW');
548: fnd_message.set_token('REV', l_revenue_class_name);
549: fnd_message.set_token('RULE_COUNT', l_rule_count);
550: fnd_message.set_token('QUOTA_RULE_COUNT',l_quota_rule_count);
551: fnd_message.set_token('HIERARCHY_COUNT', l_hierarchy_count);
552: fnd_msg_pub.add;
553: END IF;
546: THEN
547: fnd_message.set_name('CN','REV_CLS_EXISTS_SW');
548: fnd_message.set_token('REV', l_revenue_class_name);
549: fnd_message.set_token('RULE_COUNT', l_rule_count);
550: fnd_message.set_token('QUOTA_RULE_COUNT',l_quota_rule_count);
551: fnd_message.set_token('HIERARCHY_COUNT', l_hierarchy_count);
552: fnd_msg_pub.add;
553: END IF;
554: x_loading_status := 'REV_CLS_EXISTS_SW';
547: fnd_message.set_name('CN','REV_CLS_EXISTS_SW');
548: fnd_message.set_token('REV', l_revenue_class_name);
549: fnd_message.set_token('RULE_COUNT', l_rule_count);
550: fnd_message.set_token('QUOTA_RULE_COUNT',l_quota_rule_count);
551: fnd_message.set_token('HIERARCHY_COUNT', l_hierarchy_count);
552: fnd_msg_pub.add;
553: END IF;
554: x_loading_status := 'REV_CLS_EXISTS_SW';
555: RAISE FND_API.G_EXC_ERROR;