254: THEN
255: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
256: THEN
257: --CN_NO_MATCH_CORP_CONV:
258: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_CORP_CONV');
259: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_from_currency );
260: FND_MESSAGE.SET_TOKEN('TO_CURR',p_target_currency_code );
261: FND_MSG_PUB.ADD;
262: END IF;
255: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
256: THEN
257: --CN_NO_MATCH_CORP_CONV:
258: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_CORP_CONV');
259: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_from_currency );
260: FND_MESSAGE.SET_TOKEN('TO_CURR',p_target_currency_code );
261: FND_MSG_PUB.ADD;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR;
256: THEN
257: --CN_NO_MATCH_CORP_CONV:
258: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_CORP_CONV');
259: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_from_currency );
260: FND_MESSAGE.SET_TOKEN('TO_CURR',p_target_currency_code );
261: FND_MSG_PUB.ADD;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
325:
326: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
327: THEN
328: --'CN_NO_MATCH_DATE_RANGE'
329: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_DATE_RANGE');
330: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT1',l_temp_org_name );
331: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT2',rec.operating_unit );
332: FND_MSG_PUB.ADD;
333: END IF;
326: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
327: THEN
328: --'CN_NO_MATCH_DATE_RANGE'
329: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_DATE_RANGE');
330: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT1',l_temp_org_name );
331: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT2',rec.operating_unit );
332: FND_MSG_PUB.ADD;
333: END IF;
334: END IF;
327: THEN
328: --'CN_NO_MATCH_DATE_RANGE'
329: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_DATE_RANGE');
330: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT1',l_temp_org_name );
331: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT2',rec.operating_unit );
332: FND_MSG_PUB.ADD;
333: END IF;
334: END IF;
335: END IF;
341: --Need to raise exception if no salesreps are found in any orgs.
342: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
343: THEN
344: --'CN_NO_MATCH_SALESREP'
345: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_SALESREP');
346: FND_MESSAGE.SET_TOKEN('PERSON_ID',to_char(p_person_id) );
347: FND_MSG_PUB.ADD;
348: END IF;
349:
342: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
343: THEN
344: --'CN_NO_MATCH_SALESREP'
345: FND_MESSAGE.SET_NAME('CN', 'CN_NO_MATCH_SALESREP');
346: FND_MESSAGE.SET_TOKEN('PERSON_ID',to_char(p_person_id) );
347: FND_MSG_PUB.ADD;
348: END IF;
349:
350: RAISE FND_API.G_EXC_ERROR;