APPS.CN_WKSHT_GET_PUB dependencies on FND_MSG_PUB

Line 209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

205: );
206: RETURN l_to_amount;
207: EXCEPTION
208: WHEN OTHERS THEN
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
210: THEN
211: FND_MESSAGE.SET_NAME ('CN' , 'CN1158_CURR_CONV_ERR');
212: FND_MSG_PUB.Add;
213: END IF;

Line 212: FND_MSG_PUB.Add;

208: WHEN OTHERS THEN
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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:

Line 228: FND_MSG_PUB.initialize;

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
232: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

280: AND m1.hierarchy_type IN ('MGR_TO_MGR','REP_TO_REP')
281: AND m1.category <> 'TBH');
282: EXCEPTION
283: WHEN no_data_found THEN
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 ;

Line 286: FND_MSG_PUB.Add;

282: EXCEPTION
283: WHEN no_data_found THEN
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;

Line 514: FND_MSG_PUB.Count_And_Get

510:
511: --
512: -- Standard call to get message count and if count is 1, get message info.
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

Line 522: FND_MSG_PUB.Count_And_Get

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);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 529: FND_MSG_PUB.Count_And_Get

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);
533: WHEN OTHERS THEN

Line 536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
540: FND_MSG_PUB.Count_And_Get

Line 538: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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;
540: FND_MSG_PUB.Count_And_Get
541: (p_count => x_msg_count,
542: p_data => x_msg_data,

Line 540: FND_MSG_PUB.Count_And_Get

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