DBA Data[Home] [Help]

APPS.CN_WKSHT_GET_PUB dependencies on FND_API

Line 214: RAISE FND_API.G_EXC_ERROR ;

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:

Line 222: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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.

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 227: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 232: x_return_status := FND_API.G_RET_STS_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:

Line 288: RAISE FND_API.G_EXC_ERROR ;

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

Line 424: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

Line 425: RAISE FND_API.G_EXC_ERROR;

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:

Line 507: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 517: p_encoded => FND_API.G_FALSE);

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 ;

Line 519: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 521: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 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

Line 526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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,

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

Line 535: x_return_status := FND_API.G_RET_STS_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;

Line 543: p_encoded => FND_API.G_FALSE);

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 ;