515:
516: END LOOP;
517:
518:
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count ,
521: p_data => x_msg_data
522: );
523:
525: WHEN FND_API.G_EXC_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_ERROR;
528:
529: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
530: p_data => x_msg_data);
531: IF (g_excep_level >= g_debug_level ) THEN
532: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
533: END IF;
534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
535:
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537:
538: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
539: p_data => x_msg_data);
540: IF (g_excep_level >= g_debug_level ) THEN
541: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
542: END IF;
543: WHEN OTHERS THEN
544:
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546:
547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
548: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
549: l_api_name);
550: END IF;
551: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
544:
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546:
547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
548: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
549: l_api_name);
550: END IF;
551: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
552: p_data => x_msg_data);
547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
548: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
549: l_api_name);
550: END IF;
551: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
552: p_data => x_msg_data);
553: IF ( g_unexp_level >= g_debug_level ) THEN
554: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
555: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
658: /*WHEN FND_API.G_EXC_ERROR THEN
659: RETURN;*/
660:
661: WHEN OTHERS THEN
662: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
663: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
664: END IF;
665: NULL;
666: RETURN;
659: RETURN;*/
660:
661: WHEN OTHERS THEN
662: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
663: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
664: END IF;
665: NULL;
666: RETURN;
667:
683: IGC_MSGS_PKG.add_message (p_appname => appname,
684: p_msgname => msgname);
685:
686: IF (g_debug_mode = 'Y') THEN
687: Put_Debug_Msg(l_full_path, 'Raising an execution exception: '||fnd_msg_pub.get(1,FND_API.G_FALSE));
688: END IF;
689:
690: END add_message;
691:
703: IF (g_debug_mode = 'Y') THEN
704: Put_Debug_Msg(l_full_path, 'Error during the execution ');
705: END IF;
706:
707: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
708: p_data => l_msg_data );
709:
710: IF l_msg_count >0 THEN
711: l_msg_data :='';
710: IF l_msg_count >0 THEN
711: l_msg_data :='';
712:
713: FOR l_cur IN 1..l_msg_count LOOP
714: --l_msg_data :=l_msg_data||' Mes No'||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
715: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
716: IF(g_error_level >= g_debug_level) THEN
717: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);
718: END IF;
711: l_msg_data :='';
712:
713: FOR l_cur IN 1..l_msg_count LOOP
714: --l_msg_data :=l_msg_data||' Mes No'||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
715: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
716: IF(g_error_level >= g_debug_level) THEN
717: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);
718: END IF;
719: END LOOP;