DBA Data[Home] [Help]

APPS.CN_SFP_GROUP_UTIL_PVT dependencies on FND_MSG_PUB

Line 160: FND_MSG_PUB.initialize;

156: END IF;
157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list ) THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162: -- Initialize API return status to success
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:

Line 208: FND_MSG_PUB.Count_And_Get

204: IF FND_API.To_Boolean( p_commit ) THEN
205: COMMIT WORK;
206: END IF;
207: -- Standard call to get message count and if count is 1, get message info.
208: FND_MSG_PUB.Count_And_Get
209: (
210: p_count => x_msg_count ,
211: p_data => x_msg_data ,
212: p_encoded => FND_API.G_FALSE

Line 219: FND_MSG_PUB.Count_And_Get

215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO Get_Descendant_Groups ;
218: x_return_status := FND_API.G_RET_STS_ERROR ;
219: FND_MSG_PUB.Count_And_Get
220: (
221: p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE

Line 229: FND_MSG_PUB.Count_And_Get

225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO Get_Descendant_Groups ;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get
230: (
231: p_count => x_msg_count ,
232: p_data => x_msg_data ,
233: p_encoded => FND_API.G_FALSE

Line 238: FND_MSG_PUB.Count_And_Get

234: );
235: WHEN OTHERS THEN
236: ROLLBACK TO Get_Descendant_Groups ;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: FND_MSG_PUB.Count_And_Get
239: (
240: p_count => x_msg_count ,
241: p_data => x_msg_data ,
242: p_encoded => FND_API.G_FALSE

Line 335: FND_MSG_PUB.initialize;

331: END IF;
332:
333: -- Initialize message list if p_init_msg_list is set to TRUE.
334: IF FND_API.to_Boolean( p_init_msg_list ) THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337: -- Initialize API return status to success
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:

Line 394: FND_MSG_PUB.Count_And_Get

390: IF FND_API.To_Boolean( p_commit ) THEN
391: COMMIT WORK;
392: END IF;
393: -- Standard call to get message count and if count is 1, get message info.
394: FND_MSG_PUB.Count_And_Get
395: (
396: p_count => x_msg_count ,
397: p_data => x_msg_data ,
398: p_encoded => FND_API.G_FALSE

Line 405: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: ROLLBACK TO Get_Salesrep_Roles ;
404: x_return_status := FND_API.G_RET_STS_ERROR ;
405: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
406: p_data => x_msg_data ,
407: p_encoded => FND_API.G_FALSE);
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO Get_Salesrep_Roles ;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
413: p_data => x_msg_data ,
414: p_encoded => FND_API.G_FALSE);
415: WHEN OTHERS THEN
416: ROLLBACK TO Get_Salesrep_Roles ;

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

414: p_encoded => FND_API.G_FALSE);
415: WHEN OTHERS THEN
416: ROLLBACK TO Get_Salesrep_Roles ;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
421: END IF ;
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

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

416: ROLLBACK TO Get_Salesrep_Roles ;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
421: END IF ;
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
423: p_data => x_msg_data ,
424: p_encoded => FND_API.G_FALSE);

Line 422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
421: END IF ;
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
423: p_data => x_msg_data ,
424: p_encoded => FND_API.G_FALSE);
425: END Get_Salesrep_Roles;
426:

Line 506: FND_MSG_PUB.initialize;

502: END IF;
503:
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list ) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508: -- Initialize API return status to success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510:

Line 575: FND_MSG_PUB.Count_And_Get

571: IF FND_API.To_Boolean( p_commit ) THEN
572: COMMIT WORK;
573: END IF;
574: -- Standard call to get message count and if count is 1, get message info.
575: FND_MSG_PUB.Count_And_Get
576: (
577: p_count => x_msg_count ,
578: p_data => x_msg_data ,
579: p_encoded => FND_API.G_FALSE

Line 586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO Get_Grp_Organization_Access ;
585: x_return_status := FND_API.G_RET_STS_ERROR ;
586: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
587: p_data => x_msg_data ,
588: p_encoded => FND_API.G_FALSE);
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO Get_Grp_Organization_Access ;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
594: p_data => x_msg_data ,
595: p_encoded => FND_API.G_FALSE);
596: WHEN OTHERS THEN
597: ROLLBACK TO Get_Grp_Organization_Access ;

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

595: p_encoded => FND_API.G_FALSE);
596: WHEN OTHERS THEN
597: ROLLBACK TO Get_Grp_Organization_Access ;
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
602: END IF ;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

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

597: ROLLBACK TO Get_Grp_Organization_Access ;
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
602: END IF ;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
604: p_data => x_msg_data ,
605: p_encoded => FND_API.G_FALSE);

Line 603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
602: END IF ;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
604: p_data => x_msg_data ,
605: p_encoded => FND_API.G_FALSE);
606: END Get_Grp_Organization_Access;
607: