DBA Data[Home] [Help]

APPS.OKC_TERMS_QA_PVT dependencies on FND_MSG_PUB

Line 342: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm);
340: END IF;
341:
342: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
344: END IF;
345:
346: IF l_seq_csr%ISOPEN THEN

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

339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm);
340: END IF;
341:
342: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
344: END IF;
345:
346: IF l_seq_csr%ISOPEN THEN
347: CLOSE l_seq_csr;

Line 457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

453: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Insert_Row:OTHERS Exception');
455: END IF;
456:
457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
458: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
459: END IF;
460:
461: RETURN( G_RET_STS_UNEXP_ERROR );

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

454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Insert_Row:OTHERS Exception');
455: END IF;
456:
457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
458: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
459: END IF;
460:
461: RETURN( G_RET_STS_UNEXP_ERROR );
462:

Line 544: FND_MSG_PUB.add;

540: IF not l_found THEN
541: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
542: FND_MESSAGE.set_token('ARG_NAME', 'p_qa_code');
543: FND_MESSAGE.set_token('ARG_VALUE', p_qa_code);
544: FND_MSG_PUB.add;
545: FND_MSG_PUB.ADD;
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
547: END IF;
548: EXCEPTION

Line 545: FND_MSG_PUB.ADD;

541: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
542: FND_MESSAGE.set_token('ARG_NAME', 'p_qa_code');
543: FND_MESSAGE.set_token('ARG_VALUE', p_qa_code);
544: FND_MSG_PUB.add;
545: FND_MSG_PUB.ADD;
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN

Line 566: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

562: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving get_qa_code_detail:OTHERS Exception');
564: END IF;
565:
566: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
568: END IF;
569: x_return_status := G_RET_STS_UNEXP_ERROR ;
570:

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

563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving get_qa_code_detail:OTHERS Exception');
564: END IF;
565:
566: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
568: END IF;
569: x_return_status := G_RET_STS_UNEXP_ERROR ;
570:
571: END get_qa_code_detail;

Line 666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving Log_QA_Messages because of EXCEPTION: '||sqlerrm);
663: END IF;
664: x_return_status := G_RET_STS_UNEXP_ERROR ;
665:
666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
668: END IF;
669: END log_qa_messages;
670:

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

663: END IF;
664: x_return_status := G_RET_STS_UNEXP_ERROR ;
665:
666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
668: END IF;
669: END log_qa_messages;
670:
671:

Line 5126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5122:
5123: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
5125: END IF;
5126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5127:
5128: EXCEPTION
5129: WHEN FND_API.G_EXC_ERROR THEN
5130: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5157: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5153: END IF;
5154: */
5155:
5156: x_return_status := G_RET_STS_ERROR ;
5157: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5158:
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: ROLLBACK TO g_QA_Doc;
5161: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5183: END IF;
5184: */
5185:
5186: x_return_status := G_RET_STS_UNEXP_ERROR ;
5187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5188:
5189: WHEN OTHERS THEN
5190: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5191: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);

Line 5217: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

5213: END IF;
5214: */
5215:
5216: x_return_status := G_RET_STS_UNEXP_ERROR ;
5217: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5219: END IF;
5220: END QA_Doc;
5221:

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

5214: */
5215:
5216: x_return_status := G_RET_STS_UNEXP_ERROR ;
5217: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5219: END IF;
5220: END QA_Doc;
5221:
5222: END OKC_TERMS_QA_PVT;