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_COMMISSION_CALC_PVT dependencies on FND_MESSAGE

Line 56: fnd_message.set_name('CN', 'CN_NO_QUOTA_FORMULA');

52:
53: OPEN pe_formula_cr;
54: FETCH pe_formula_cr into l_pe_formula;
55: IF pe_formula_cr%NOTFOUND THEN
56: fnd_message.set_name('CN', 'CN_NO_QUOTA_FORMULA');
57: fnd_message.set_token('QUOTA_NAME', p_quota_name);
58: fnd_msg_pub.add;
59: CLOSE pe_formula_cr;
60: RAISE FND_API.G_EXC_ERROR;

Line 57: fnd_message.set_token('QUOTA_NAME', p_quota_name);

53: OPEN pe_formula_cr;
54: FETCH pe_formula_cr into l_pe_formula;
55: IF pe_formula_cr%NOTFOUND THEN
56: fnd_message.set_name('CN', 'CN_NO_QUOTA_FORMULA');
57: fnd_message.set_token('QUOTA_NAME', p_quota_name);
58: fnd_msg_pub.add;
59: CLOSE pe_formula_cr;
60: RAISE FND_API.G_EXC_ERROR;
61: ELSIF l_pe_formula.formula_status <> 'COMPLETE' THEN

Line 62: fnd_message.set_name('CN', 'CN_INV_CALC_FORMULA');

58: fnd_msg_pub.add;
59: CLOSE pe_formula_cr;
60: RAISE FND_API.G_EXC_ERROR;
61: ELSIF l_pe_formula.formula_status <> 'COMPLETE' THEN
62: fnd_message.set_name('CN', 'CN_INV_CALC_FORMULA');
63: fnd_message.set_token('QUOTA_NAME', p_quota_name);
64: fnd_msg_pub.add;
65: CLOSE pe_formula_cr;
66: RAISE FND_API.G_EXC_ERROR;

Line 63: fnd_message.set_token('QUOTA_NAME', p_quota_name);

59: CLOSE pe_formula_cr;
60: RAISE FND_API.G_EXC_ERROR;
61: ELSIF l_pe_formula.formula_status <> 'COMPLETE' THEN
62: fnd_message.set_name('CN', 'CN_INV_CALC_FORMULA');
63: fnd_message.set_token('QUOTA_NAME', p_quota_name);
64: fnd_msg_pub.add;
65: CLOSE pe_formula_cr;
66: RAISE FND_API.G_EXC_ERROR;
67: END IF;

Line 75: fnd_message.set_name('CN', 'CN_FORMULA_PKG_NOT_VALID');

71: FETCH formula_valid_cr INTO l_formula_count;
72: CLOSE formula_valid_cr;
73:
74: IF l_formula_count <> 2 THEN
75: fnd_message.set_name('CN', 'CN_FORMULA_PKG_NOT_VALID');
76: fnd_message.set_token('FORMULA_NAME', l_pe_formula.formula_name);
77: fnd_msg_pub.add;
78: CLOSE pe_formula_cr;
79: RAISE FND_API.G_EXC_ERROR;

Line 76: fnd_message.set_token('FORMULA_NAME', l_pe_formula.formula_name);

72: CLOSE formula_valid_cr;
73:
74: IF l_formula_count <> 2 THEN
75: fnd_message.set_name('CN', 'CN_FORMULA_PKG_NOT_VALID');
76: fnd_message.set_token('FORMULA_NAME', l_pe_formula.formula_name);
77: fnd_msg_pub.add;
78: CLOSE pe_formula_cr;
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;

Line 238: fnd_message.set_name('CN', 'CN_QUOTA_NOT_MAPPED');

234:
235: OPEN quotadetails_cr(p_proj_comp_rec.salesrep_id,l_revenueclass_id,p_proj_comp_rec.calc_date);
236: FETCH quotadetails_cr INTO l_quotadetails;
237: IF quotadetails_cr%NOTFOUND THEN
238: fnd_message.set_name('CN', 'CN_QUOTA_NOT_MAPPED');
239: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);
240: fnd_msg_pub.add;
241: CLOSE quotadetails_cr;
242: RAISE FND_API.G_EXC_ERROR;

Line 239: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);

235: OPEN quotadetails_cr(p_proj_comp_rec.salesrep_id,l_revenueclass_id,p_proj_comp_rec.calc_date);
236: FETCH quotadetails_cr INTO l_quotadetails;
237: IF quotadetails_cr%NOTFOUND THEN
238: fnd_message.set_name('CN', 'CN_QUOTA_NOT_MAPPED');
239: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);
240: fnd_msg_pub.add;
241: CLOSE quotadetails_cr;
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;

Line 253: fnd_message.set_name('CN', 'CN_PR_CP_NOT_VALID');

249: l_valid_forecast := 1;
250: OPEN compplan_cr(l_srp_plan_assign.comp_plan_id);
251: FETCH compplan_cr INTO l_valid_compplan;
252: IF l_valid_compplan > 0 THEN
253: fnd_message.set_name('CN', 'CN_PR_CP_NOT_VALID');
254: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);
255: fnd_msg_pub.add;
256: CLOSE compplan_cr;
257: RAISE FND_API.G_EXC_ERROR;

Line 254: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);

250: OPEN compplan_cr(l_srp_plan_assign.comp_plan_id);
251: FETCH compplan_cr INTO l_valid_compplan;
252: IF l_valid_compplan > 0 THEN
253: fnd_message.set_name('CN', 'CN_PR_CP_NOT_VALID');
254: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);
255: fnd_msg_pub.add;
256: CLOSE compplan_cr;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;

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

293:
294: END LOOP;
295:
296: IF l_valid_forecast = 0 THEN
297: fnd_message.set_name('CN', 'CN_PR_SRPPLAN_NOT_FOUND');
298: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);
299: fnd_msg_pub.add;
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;

Line 298: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);

294: END LOOP;
295:
296: IF l_valid_forecast = 0 THEN
297: fnd_message.set_name('CN', 'CN_PR_SRPPLAN_NOT_FOUND');
298: fnd_message.set_token('LINE_NO', p_proj_comp_rec.line_id);
299: fnd_msg_pub.add;
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:

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

318: p_proj_comp_rec.currency_code,
319: g_cached_org_id);
320: EXCEPTION
321: WHEN OTHERS THEN
322: fnd_message.set_name('CN','CN_CONV_CURR_FAIL');
323: fnd_msg_pub.ADD;
324: RAISE fnd_api.g_exc_error;
325: END;
326:

Line 519: fnd_message.set_name('CN','CN_INVALID_RES_ID');

515:
516: IF l_salesrep_tbl.count > 0 THEN
517: dbms_utility.table_to_comma(l_salesrep_tbl,tablength,linenos);
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: fnd_message.set_name('CN','CN_INVALID_RES_ID');
520: fnd_message.set_token('LINE_NO', linenos);
521: fnd_msg_pub.ADD;
522: END IF;
523:

Line 520: fnd_message.set_token('LINE_NO', linenos);

516: IF l_salesrep_tbl.count > 0 THEN
517: dbms_utility.table_to_comma(l_salesrep_tbl,tablength,linenos);
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: fnd_message.set_name('CN','CN_INVALID_RES_ID');
520: fnd_message.set_token('LINE_NO', linenos);
521: fnd_msg_pub.ADD;
522: END IF;
523:
524: CLOSE proj_comp_srp_cr;

Line 532: fnd_message.set_name('CN','CN_INVALID_PRD_ID');

528:
529: IF l_period_tbl.count > 0 THEN
530: dbms_utility.table_to_comma(l_period_tbl,tablength,linenos);
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: fnd_message.set_name('CN','CN_INVALID_PRD_ID');
533: fnd_message.set_token('LINE_NO', linenos);
534: fnd_msg_pub.ADD;
535: END IF;
536:

Line 533: fnd_message.set_token('LINE_NO', linenos);

529: IF l_period_tbl.count > 0 THEN
530: dbms_utility.table_to_comma(l_period_tbl,tablength,linenos);
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: fnd_message.set_name('CN','CN_INVALID_PRD_ID');
533: fnd_message.set_token('LINE_NO', linenos);
534: fnd_msg_pub.ADD;
535: END IF;
536:
537: CLOSE proj_comp_prd_cr;

Line 545: fnd_message.set_name('CN','CN_INVALID_RS_ID');

541:
542: IF l_ruleset_tbl.count > 0 THEN
543: dbms_utility.table_to_comma(l_ruleset_tbl,tablength,linenos);
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: fnd_message.set_name('CN','CN_INVALID_RS_ID');
546: fnd_message.set_token('LINE_NO', linenos);
547: fnd_msg_pub.ADD;
548: END IF;
549:

Line 546: fnd_message.set_token('LINE_NO', linenos);

542: IF l_ruleset_tbl.count > 0 THEN
543: dbms_utility.table_to_comma(l_ruleset_tbl,tablength,linenos);
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: fnd_message.set_name('CN','CN_INVALID_RS_ID');
546: fnd_message.set_token('LINE_NO', linenos);
547: fnd_msg_pub.ADD;
548: END IF;
549:
550: CLOSE proj_comp_rs_cr;