DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on FND_API

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45:
46: BEGIN
47:
48: SAVEPOINT get_Projected_Commission;
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50:
51: x_proj_comm := 0;
52:
53: OPEN pe_formula_cr;

Line 60: RAISE FND_API.G_EXC_ERROR;

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');
63: fnd_message.set_token('QUOTA_NAME', p_quota_name);
64: fnd_msg_pub.add;

Line 66: RAISE FND_API.G_EXC_ERROR;

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;
69:
70: OPEN formula_valid_cr(l_pe_formula.formula_id,l_pe_formula.org_id);

Line 79: RAISE FND_API.G_EXC_ERROR;

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:
82: EXECUTE IMMEDIATE
83: 'BEGIN CN_FORMULA_'||abs(l_pe_formula.formula_id)||'_'||abs(l_pe_formula.org_id)||'_PKG.get_forecast_commission(:1,:2,:3,:4,:5,:6,:7);END;'

Line 87: WHEN FND_API.G_EXC_ERROR THEN

83: 'BEGIN CN_FORMULA_'||abs(l_pe_formula.formula_id)||'_'||abs(l_pe_formula.org_id)||'_PKG.get_forecast_commission(:1,:2,:3,:4,:5,:6,:7);END;'
84: USING p_srp_plan_assign_id, p_salesrep_id, p_start_period_id,p_end_period_id,p_quota_id,p_sales_credit_amt,out x_proj_comm;
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 );

Line 88: x_return_status := FND_API.G_RET_STS_ERROR;

84: USING p_srp_plan_assign_id, p_salesrep_id, p_start_period_id,p_end_period_id,p_quota_id,p_sales_credit_amt,out x_proj_comm;
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:

Line 91: p_encoded => FND_API.G_FALSE );

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
94: x_proj_comm := 0;
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

91: p_encoded => FND_API.G_FALSE );
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:

Line 98: p_encoded => FND_API.G_FALSE );

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
101: x_proj_comm := 0;
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

98: p_encoded => FND_API.G_FALSE );
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:

Line 105: p_encoded => FND_API.G_FALSE );

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;
108:
109: Procedure processRows(p_proj_comp_rec IN cn_proj_compensation_gtt%rowtype,

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: l_msg_data varchar2(2000);
219:
220: BEGIN
221:
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: l_tot_target_amt:=0;
225: l_tot_inp_ach_itd := 0;
226: l_tot_target_itd := 0;

Line 242: RAISE FND_API.G_EXC_ERROR;

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;
245:
246: FOR l_srp_plan_assign IN srpplanassign_cr(p_proj_comp_rec.salesrep_id,p_proj_comp_rec.calc_date,l_quotadetails.quota_id) LOOP

Line 257: RAISE FND_API.G_EXC_ERROR;

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;
260:
261: get_Projected_Commission( p_srp_plan_assign_id => l_srp_plan_assign.srp_plan_assign_id,

Line 277: RAISE FND_API.G_EXC_ERROR;

273: IF l_return_status <> 'S' THEN
274: x_return_status := l_return_status;
275: x_msg_count := l_msg_count;
276: x_msg_data := l_msg_data;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280: OPEN periodquotas_cr(l_srp_plan_assign.srp_plan_assign_id, l_srp_plan_assign.salesrep_id,p_proj_comp_rec.period_id,l_quotadetails.quota_id);
281: FETCH periodquotas_cr INTO l_periodquotas;

Line 300: RAISE FND_API.G_EXC_ERROR;

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

Line 324: RAISE fnd_api.g_exc_error;

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
328: l_quota_achievement := (l_tot_inp_ach_itd + l_tot_proj_comm_amt)/ l_tot_target_itd * 100;

Line 344: WHEN FND_API.G_EXC_ERROR THEN

340: CALC_STATUS = l_return_status
341: WHERE LINE_ID = p_proj_comp_rec.line_id;
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 );

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: WHERE LINE_ID = p_proj_comp_rec.line_id;
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:

Line 348: p_encoded => FND_API.G_FALSE );

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
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 );

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: p_data => x_msg_data,
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:

Line 354: p_encoded => FND_API.G_FALSE );

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
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: p_data => x_msg_data,
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:

Line 360: p_encoded => FND_API.G_FALSE );

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;
363:
364: Procedure calculate_Commission

Line 367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

363:
364: Procedure calculate_Commission
365: (
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: x_inc_plnr_disclaimer OUT NOCOPY cn_repositories.income_planner_disclaimer%TYPE,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2

Line 384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

380:
381: Procedure calculate_Commission
382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_org_id IN NUMBER,
386: x_inc_plnr_disclaimer OUT NOCOPY cn_repositories.income_planner_disclaimer%TYPE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: BEGIN
450:
451: -- Standard Start of API savepoint
452: SAVEPOINT calculate_Commission;
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: --Standard Call to check for call compatibility
456: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 456: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

452: SAVEPOINT calculate_Commission;
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: --Standard Call to check for call compatibility
456: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: -- Initialize message list if p_init_msg_list is set to TRUE

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: --Standard Call to check for call compatibility
456: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 461: IF FND_API.to_Boolean(p_init_msg_list) THEN

457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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);

Line 505: , cpcg.pe_name = FND_API.G_MISS_CHAR

501: WHERE cpcg.calc_date BETWEEN cr.start_date AND nvl(cr.end_date,cpcg.calc_date)
502: AND cr.module_type = 'PECLS'
503: and cr.org_id = g_cached_org_id
504: )
505: , cpcg.pe_name = FND_API.G_MISS_CHAR
506: , cpcg.proj_comp = 0
507: , cpcg.pe_quota = 0
508: , cpcg.pe_achieved = 0
509: , cpcg.pe_credit = 0

Line 510: , cpcg.pe_interval = FND_API.G_MISS_NUM

506: , cpcg.proj_comp = 0
507: , cpcg.pe_quota = 0
508: , cpcg.pe_achieved = 0
509: , cpcg.pe_credit = 0
510: , cpcg.pe_interval = FND_API.G_MISS_NUM
511: , cpcg.calc_status = FND_API.G_RET_STS_ERROR;
512:
513: OPEN proj_comp_srp_cr;
514: FETCH proj_comp_srp_cr BULK COLLECT INTO l_salesrep_tbl;

Line 511: , cpcg.calc_status = FND_API.G_RET_STS_ERROR;

507: , cpcg.pe_quota = 0
508: , cpcg.pe_achieved = 0
509: , cpcg.pe_credit = 0
510: , cpcg.pe_interval = FND_API.G_MISS_NUM
511: , cpcg.calc_status = FND_API.G_RET_STS_ERROR;
512:
513: OPEN proj_comp_srp_cr;
514: FETCH proj_comp_srp_cr BULK COLLECT INTO l_salesrep_tbl;
515:

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: FETCH proj_comp_srp_cr BULK COLLECT INTO l_salesrep_tbl;
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;

Line 531: x_return_status := FND_API.G_RET_STS_ERROR;

527: FETCH proj_comp_prd_cr BULK COLLECT INTO l_period_tbl;
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;

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: FETCH proj_comp_rs_cr BULK COLLECT INTO l_ruleset_tbl;
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;

Line 569: x_inc_plnr_disclaimer := FND_API.G_MISS_CHAR; -- temporarily hardcoded for testing purpose. need to add a new message

565: --FND_PROFILE.GET('CN_CUST_DISCLAIMER',l_inc_plnr_profile);
566: CN_SYSTEM_PARAMETERS.GET_SYSTEM_PARAMETER(P_PROFILE_CODE => 'CN_CUST_DISCLAIMER',P_ORG_ID => g_cached_org_id,X_VALUE => l_inc_plnr_profile);
567:
568: IF NVL(l_inc_plnr_profile,'N') = 'N' THEN
569: x_inc_plnr_disclaimer := FND_API.G_MISS_CHAR; -- temporarily hardcoded for testing purpose. need to add a new message
570: ELSE
571: x_inc_plnr_disclaimer := l_repositories.income_planner_disclaimer ;
572: END IF;
573:

Line 576: p_encoded => FND_API.G_FALSE );

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:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN

Line 580: WHEN FND_API.G_EXC_ERROR THEN

576: p_encoded => FND_API.G_FALSE );
577:
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 );

Line 581: x_return_status := FND_API.G_RET_STS_ERROR;

577:
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:

Line 584: p_encoded => FND_API.G_FALSE );

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:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

583: p_data => x_msg_data,
584: p_encoded => FND_API.G_FALSE );
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 );

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: p_encoded => FND_API.G_FALSE );
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:

Line 591: p_encoded => FND_API.G_FALSE );

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:
594: WHEN OTHERS THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591: p_encoded => FND_API.G_FALSE );
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:

Line 598: p_encoded => FND_API.G_FALSE );

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;
601:
602: