DBA Data[Home] [Help]

APPS.OKC_TERMS_QA_GRP dependencies on FND_MSG_PUB

Line 128: FND_MSG_PUB.initialize;

124: END IF;
125:
126: -- Initialize message list if p_init_msg_list is set to TRUE.
127: IF FND_API.to_Boolean( p_init_msg_list ) THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130: -- Initialize API return status to success
131: x_return_status := G_RET_STS_SUCCESS;
132:

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

384: COMMIT WORK;
385: END IF;
386:
387: -- Standard call to get message count and if count is 1, get message info.
388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
389: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
390: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving QA_Doc');
391: END IF;
392:

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

396: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
398: END IF;
399: x_return_status := G_RET_STS_ERROR ;
400: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: ROLLBACK TO g_QA_Doc;
404: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

404: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
406: END IF;
407: x_return_status := G_RET_STS_UNEXP_ERROR ;
408: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
409:
410: WHEN OTHERS THEN
411: ROLLBACK TO g_QA_Doc;
412: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

413: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
414: END IF;
415:
416: x_return_status := G_RET_STS_UNEXP_ERROR ;
417: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
419: END IF;
420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
421: END qa_doc;

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

414: END IF;
415:
416: x_return_status := G_RET_STS_UNEXP_ERROR ;
417: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
419: END IF;
420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
421: END qa_doc;
422:

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

416: x_return_status := G_RET_STS_UNEXP_ERROR ;
417: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
419: END IF;
420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
421: END qa_doc;
422:
423: ---------------------------------------------------------------------------
424: -- Procedure QA_Doc version 2

Line 490: FND_MSG_PUB.initialize;

486: END IF;
487:
488: -- Initialize message list if p_init_msg_list is set to TRUE.
489: IF FND_API.to_Boolean( p_init_msg_list ) THEN
490: FND_MSG_PUB.initialize;
491: END IF;
492: -- Initialize API return status to success
493: x_return_status := G_RET_STS_SUCCESS;
494:

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

719:
720: END IF;
721:
722: -- Standard call to get message count and if count is 1, get message info.
723: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
724: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving QA_Doc');
726: END IF;
727: END IF; -- Repository Enhancement (For Validate Action)

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

733: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
735: END IF;
736: x_return_status := G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
738:
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: ROLLBACK TO g_QA_Doc;
741: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

741: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
743: END IF;
744: x_return_status := G_RET_STS_UNEXP_ERROR ;
745: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
746:
747: WHEN OTHERS THEN
748: ROLLBACK TO g_QA_Doc;
749: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
751: END IF;
752:
753: x_return_status := G_RET_STS_UNEXP_ERROR ;
754: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
756: END IF;
757: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
758: END qa_doc;

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

751: END IF;
752:
753: x_return_status := G_RET_STS_UNEXP_ERROR ;
754: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
756: END IF;
757: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
758: END qa_doc;
759:

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

753: x_return_status := G_RET_STS_UNEXP_ERROR ;
754: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
756: END IF;
757: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
758: END qa_doc;
759:
760: ---------------------------------------------------------------------------
761: -- Procedure Check_Terms calls QA_doc version 2

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

846: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm);
847: END IF;
848:
849: x_return_status := G_QA_STS_ERROR ;
850: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
852: END IF;
853: END Check_Terms;
854:

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

847: END IF;
848:
849: x_return_status := G_QA_STS_ERROR ;
850: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
852: END IF;
853: END Check_Terms;
854:
855: ---------------------------------------------------------------------------

Line 903: FND_MSG_PUB.initialize;

899: END IF;
900:
901: -- Initialize message list if p_init_msg_list is set to TRUE.
902: IF FND_API.to_Boolean( p_init_msg_list ) THEN
903: FND_MSG_PUB.initialize;
904: END IF;
905:
906: -- Initialize API return status to success
907: x_return_status := G_RET_STS_SUCCESS;

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

981: END IF;
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
986: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving QA_Doc - OVERLOADED ONE ');
988: END IF;
989:

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

993: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
995: END IF;
996: x_return_status := G_RET_STS_ERROR ;
997: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
998:
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: ROLLBACK TO g_QA_Doc;
1001: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1001: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1003: END IF;
1004: x_return_status := G_RET_STS_UNEXP_ERROR ;
1005: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1006:
1007: WHEN OTHERS THEN
1008: ROLLBACK TO g_QA_Doc;
1009: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1010: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
1011: END IF;
1012:
1013: x_return_status := G_RET_STS_UNEXP_ERROR ;
1014: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1016: END IF;
1017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1018: END QA_Doc;

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

1011: END IF;
1012:
1013: x_return_status := G_RET_STS_UNEXP_ERROR ;
1014: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1016: END IF;
1017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1018: END QA_Doc;
1019:

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

1013: x_return_status := G_RET_STS_UNEXP_ERROR ;
1014: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1016: END IF;
1017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1018: END QA_Doc;
1019:
1020:
1021: END OKC_TERMS_QA_GRP;