APPS.CN_QUOTA_CATEGORIES_PUB dependencies on FND_MESSAGE

Line 56: FND_MESSAGE.SET_NAME ('CN','CN_QUOTA_CATEGORY_DUP');

52: INTO l_count
53: FROM cn_quota_categories
54: WHERE UPPER(name) = UPPER(l_newrec.name);
55: IF l_count > 0 THEN
56: FND_MESSAGE.SET_NAME ('CN','CN_QUOTA_CATEGORY_DUP');
57: FND_MSG_PUB.Add;
58: RAISE FND_API.G_EXC_ERROR;
59: END IF;
60:

Line 142: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');

138: INTO l_count
139: FROM cn_quota_categories
140: WHERE quota_category_id = p_rec.quota_category_id;
141: IF (l_count = 0) THEN
142: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');
143: FND_MSG_PUB.ADD;
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:

Line 160: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');

156: INTO l_old_name
157: FROM cn_quota_categories
158: WHERE quota_category_id = p_rec.quota_category_id;
159:
160: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
161: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', l_old_name);
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 161: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', l_old_name);

157: FROM cn_quota_categories
158: WHERE quota_category_id = p_rec.quota_category_id;
159:
160: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
161: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', l_old_name);
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 252: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DELETE_REC');

248: INTO l_count
249: FROM cn_quota_categories
250: WHERE quota_category_id = p_quota_category_id;
251: IF (l_count = 0) THEN
252: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DELETE_REC');
253: FND_MSG_PUB.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256: -- check whether this quota_category_id is already assigned

Line 269: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');

265: INTO qc_name
266: FROM CN_QUOTA_CATEGORIES
267: WHERE quota_category_id = p_quota_category_id;
268:
269: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
270: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', qc_name);
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR ;
273: END IF;

Line 270: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', qc_name);

266: FROM CN_QUOTA_CATEGORIES
267: WHERE quota_category_id = p_quota_category_id;
268:
269: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
270: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', qc_name);
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR ;
273: END IF;
274: