210: THEN
211: FND_MESSAGE.SET_NAME ('CN' , 'CN1158_CURR_CONV_ERR');
212: FND_MSG_PUB.Add;
213: END IF;
214: RAISE FND_API.G_EXC_ERROR ;
215: END convert_Amount;
216:
217: BEGIN
218:
218:
219: -- Standard Start of API savepoint
220: SAVEPOINT Get_srp_wksht;
221: -- Standard call to check for call compatibility.
222: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
223: l_api_name, G_PKG_NAME) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226: -- Initialize message list if p_init_msg_list is set to TRUE.
220: SAVEPOINT Get_srp_wksht;
221: -- Standard call to check for call compatibility.
222: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
223: l_api_name, G_PKG_NAME) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
228: FND_MSG_PUB.initialize;
223: l_api_name, G_PKG_NAME) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: -- Initialize API return status to success
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: -- Initialize API return status to success
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: -- API body
234: l_counter := 0;
235: x_total_records := 0;
236:
284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.SET_NAME ('CN','CN_NO_SRP_ACCESS');
286: FND_MSG_PUB.Add;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR ;
289: END;
290: END IF;
291:
292: c_salesrep_name := upper(p_salesrep_name);
420: x_curr_earnings => l_curr_earnings,
421: x_curr_earnings_due => l_current_earnings,
422: x_bb_total => l_bb_total);
423:
424: IF x_return_status <> FND_API.g_ret_sts_success THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: l_view_ced := 'N';
421: x_curr_earnings_due => l_current_earnings,
422: x_bb_total => l_bb_total);
423:
424: IF x_return_status <> FND_API.g_ret_sts_success THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: l_view_ced := 'N';
429:
503: CLOSE wksht_cur;
504:
505: -- End of API body.
506: -- Standard check of p_commit.
507: IF FND_API.To_Boolean( p_commit ) THEN
508: COMMIT WORK;
509: END IF;
510:
511: --
513: --
514: FND_MSG_PUB.Count_And_Get
515: (p_count => x_msg_count,
516: p_data => x_msg_data,
517: p_encoded => FND_API.G_FALSE);
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: ROLLBACK TO Get_srp_wksht;
521: x_return_status := FND_API.G_RET_STS_ERROR ;
515: (p_count => x_msg_count,
516: p_data => x_msg_data,
517: p_encoded => FND_API.G_FALSE);
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: ROLLBACK TO Get_srp_wksht;
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: FND_MSG_PUB.Count_And_Get
523: (p_count => x_msg_count,
517: p_encoded => FND_API.G_FALSE);
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: ROLLBACK TO Get_srp_wksht;
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: FND_MSG_PUB.Count_And_Get
523: (p_count => x_msg_count,
524: p_data => x_msg_data,
525: p_encoded => FND_API.G_FALSE);
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: FND_MSG_PUB.Count_And_Get
523: (p_count => x_msg_count,
524: p_data => x_msg_data,
525: p_encoded => FND_API.G_FALSE);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: ROLLBACK TO Get_srp_wksht;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: FND_MSG_PUB.Count_And_Get
522: FND_MSG_PUB.Count_And_Get
523: (p_count => x_msg_count,
524: p_data => x_msg_data,
525: p_encoded => FND_API.G_FALSE);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: ROLLBACK TO Get_srp_wksht;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
524: p_data => x_msg_data,
525: p_encoded => FND_API.G_FALSE);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: ROLLBACK TO Get_srp_wksht;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
531: p_data => x_msg_data,
532: p_encoded => FND_API.G_FALSE);
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
531: p_data => x_msg_data,
532: p_encoded => FND_API.G_FALSE);
533: WHEN OTHERS THEN
534: ROLLBACK TO Get_srp_wksht;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: p_data => x_msg_data,
532: p_encoded => FND_API.G_FALSE);
533: WHEN OTHERS THEN
534: ROLLBACK TO Get_srp_wksht;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
537: THEN
538: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
539: END IF;
539: END IF;
540: FND_MSG_PUB.Count_And_Get
541: (p_count => x_msg_count,
542: p_data => x_msg_data,
543: p_encoded => FND_API.G_FALSE);
544: END Get_srp_wksht;
545:
546: END Cn_wksht_get_pub ;