DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on FND_MSG_PUB

Line 58: fnd_msg_pub.add;

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
62: fnd_message.set_name('CN', 'CN_INV_CALC_FORMULA');

Line 64: fnd_msg_pub.add;

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;
68: CLOSE pe_formula_cr;

Line 77: fnd_msg_pub.add;

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

Line 89: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

85:
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
90: p_data => x_msg_data,
91: p_encoded => FND_API.G_FALSE );
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 96: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
94: x_proj_comm := 0;
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
97: p_data => x_msg_data,
98: p_encoded => FND_API.G_FALSE );
99:
100: WHEN OTHERS THEN

Line 103: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

99:
100: WHEN OTHERS THEN
101: x_proj_comm := 0;
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
104: p_data => x_msg_data,
105: p_encoded => FND_API.G_FALSE );
106:
107: End get_Projected_Commission;

Line 240: fnd_msg_pub.add;

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;
244: CLOSE quotadetails_cr;

Line 255: fnd_msg_pub.add;

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;
259: CLOSE compplan_cr;

Line 299: fnd_msg_pub.add;

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:
303: l_from_currency := cn_general_utils.get_currency_code;

Line 323: fnd_msg_pub.ADD;

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:
327: IF l_tot_target_itd <> 0 THEN

Line 346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => FND_API.G_FALSE );
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 352: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

348: p_encoded => FND_API.G_FALSE );
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
353: p_data => x_msg_data,
354: p_encoded => FND_API.G_FALSE );
355:
356: WHEN OTHERS THEN

Line 358: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

354: p_encoded => FND_API.G_FALSE );
355:
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
359: p_data => x_msg_data,
360: p_encoded => FND_API.G_FALSE );
361:
362: END processRows;

Line 462: FND_MSG_PUB.initialize;

458: END IF;
459:
460: -- Initialize message list if p_init_msg_list is set to TRUE
461: IF FND_API.to_Boolean(p_init_msg_list) THEN
462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: MO_GLOBAL.SET_POLICY_CONTEXT ('S',p_org_id);
466: g_cached_org_id := p_org_id;

Line 521: fnd_msg_pub.ADD;

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

Line 534: fnd_msg_pub.ADD;

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

Line 547: fnd_msg_pub.ADD;

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

Line 574: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

570: ELSE
571: x_inc_plnr_disclaimer := l_repositories.income_planner_disclaimer ;
572: END IF;
573:
574: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
575: p_data => x_msg_data,
576: p_encoded => FND_API.G_FALSE );
577:
578:

Line 582: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
583: p_data => x_msg_data,
584: p_encoded => FND_API.G_FALSE );
585:
586:

Line 589: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

585:
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
590: p_data => x_msg_data,
591: p_encoded => FND_API.G_FALSE );
592:
593:

Line 596: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

592:
593:
594: WHEN OTHERS THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
597: p_data => x_msg_data,
598: p_encoded => FND_API.G_FALSE );
599:
600: End calculate_Commission;