DBA Data[Home] [Help]

APPS.CN_SFP_SRP_UTIL_PVT dependencies on FND_MSG_PUB

Line 217: FND_MSG_PUB.initialize;

213: END IF;
214:
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
217: FND_MSG_PUB.initialize;
218: END IF;
219: -- Initialize API return status to success
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221:

Line 226: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

222: -- API body
223: l_resp_group := FND_PROFILE.VALUE('CN_SFP_RESP_GROUP');
224:
225: IF (l_resp_group is null) THEN
226: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
227: THEN
228: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_RESP_GROUP');
229: FND_MSG_PUB.Add;
230: END IF;

Line 229: FND_MSG_PUB.Add;

225: IF (l_resp_group is null) THEN
226: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
227: THEN
228: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_RESP_GROUP');
229: FND_MSG_PUB.Add;
230: END IF;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:

Line 290: FND_MSG_PUB.Count_And_Get

286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,
294: p_encoded => FND_API.G_FALSE

Line 301: FND_MSG_PUB.Count_And_Get

297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: ROLLBACK TO Get_Valid_Plan_Statuses ;
300: x_return_status := FND_API.G_RET_STS_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE

Line 311: FND_MSG_PUB.Count_And_Get

307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO Get_Valid_Plan_Statuses ;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get
312: (
313: p_count => x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => FND_API.G_FALSE

Line 320: FND_MSG_PUB.Count_And_Get

316: );
317: WHEN OTHERS THEN
318: ROLLBACK TO Get_Valid_Plan_Statuses ;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: FND_MSG_PUB.Count_And_Get
321: (
322: p_count => x_msg_count ,
323: p_data => x_msg_data ,
324: p_encoded => FND_API.G_FALSE

Line 420: FND_MSG_PUB.initialize;

416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422: -- Initialize API return status to success
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424:

Line 427: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424:
425: l_resp_group := fnd_profile.value('CN_SFP_RESP_GROUP');
426: IF l_resp_group IS null THEN
427: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
428: THEN
429: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_RESP_GROUP');
430: FND_MSG_PUB.Add;
431: END IF;

Line 430: FND_MSG_PUB.Add;

426: IF l_resp_group IS null THEN
427: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
428: THEN
429: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_RESP_GROUP');
430: FND_MSG_PUB.Add;
431: END IF;
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434:

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

485: EXCEPTION
486: WHEN FND_API.G_EXC_ERROR THEN
487: ROLLBACK TO Get_All_Groups_Access ;
488: x_return_status := FND_API.G_RET_STS_ERROR ;
489: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
490: p_data => x_msg_data ,
491: p_encoded => FND_API.G_FALSE);
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: ROLLBACK TO Get_All_Groups_Access ;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
497: p_data => x_msg_data ,
498: p_encoded => FND_API.G_FALSE);
499: WHEN OTHERS THEN
500: ROLLBACK TO Get_All_Groups_Access ;

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

498: p_encoded => FND_API.G_FALSE);
499: WHEN OTHERS THEN
500: ROLLBACK TO Get_All_Groups_Access ;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
505: END IF ;
506: cn_message_pkg.debug(G_PKG_NAME || ' ' || l_api_name ||' '||TO_CHAR(SQLCODE)||': '||SQLERRM) ;

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

500: ROLLBACK TO Get_All_Groups_Access ;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
505: END IF ;
506: cn_message_pkg.debug(G_PKG_NAME || ' ' || l_api_name ||' '||TO_CHAR(SQLCODE)||': '||SQLERRM) ;
507: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
508: p_data => x_msg_data ,

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

503: THEN
504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
505: END IF ;
506: cn_message_pkg.debug(G_PKG_NAME || ' ' || l_api_name ||' '||TO_CHAR(SQLCODE)||': '||SQLERRM) ;
507: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
508: p_data => x_msg_data ,
509: p_encoded => FND_API.G_FALSE);
510: END Get_All_Groups_Access;
511:

Line 569: FND_MSG_PUB.initialize;

565: END IF;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.to_Boolean( p_init_msg_list ) THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571: -- Initialize API return status to success
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573:

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

588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO Get_Group_Access ;
591: x_return_status := FND_API.G_RET_STS_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
593: p_data => x_msg_data ,
594: p_encoded => FND_API.G_FALSE);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO Get_Group_Access ;

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

594: p_encoded => FND_API.G_FALSE);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO Get_Group_Access ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
599: p_data => x_msg_data ,
600: p_encoded => FND_API.G_FALSE);
601: WHEN OTHERS THEN
602: ROLLBACK TO Get_Group_Access ;

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

600: p_encoded => FND_API.G_FALSE);
601: WHEN OTHERS THEN
602: ROLLBACK TO Get_Group_Access ;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
605: THEN
606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
607: END IF ;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

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

602: ROLLBACK TO Get_Group_Access ;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
605: THEN
606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
607: END IF ;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
609: p_data => x_msg_data ,
610: p_encoded => FND_API.G_FALSE);

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

604: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
605: THEN
606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
607: END IF ;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
609: p_data => x_msg_data ,
610: p_encoded => FND_API.G_FALSE);
611: END Get_Group_Access;
612: