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 5092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5088:
5089: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5090: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
5091: END IF;
5092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5093:
5094: EXCEPTION
5095: WHEN FND_API.G_EXC_ERROR THEN
5096: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5119: END IF;
5120: */
5121:
5122: x_return_status := G_RET_STS_ERROR ;
5123: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5124:
5125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5126: ROLLBACK TO g_QA_Doc;
5127: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5149: END IF;
5150: */
5151:
5152: x_return_status := G_RET_STS_UNEXP_ERROR ;
5153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5154:
5155: WHEN OTHERS THEN
5156: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5157: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);

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

5179: END IF;
5180: */
5181:
5182: x_return_status := G_RET_STS_UNEXP_ERROR ;
5183: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5185: END IF;
5186: END QA_Doc;
5187:

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

5180: */
5181:
5182: x_return_status := G_RET_STS_UNEXP_ERROR ;
5183: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5185: END IF;
5186: END QA_Doc;
5187:
5188: END OKC_TERMS_QA_PVT;