DBA Data[Home] [Help]

APPS.OKC_TERMS_QA_GRP dependencies on FND_MSG_PUB

Line 118: FND_MSG_PUB.initialize;

114: END IF;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120: -- Initialize API return status to success
121: x_return_status := G_RET_STS_SUCCESS;
122:

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

360: COMMIT WORK;
361: END IF;
362:
363: -- Standard call to get message count and if count is 1, get message info.
364: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
365: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
366: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving QA_Doc');
367: END IF;
368:

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

372: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
374: END IF;
375: x_return_status := G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: ROLLBACK TO g_QA_Doc;
380: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

380: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
382: END IF;
383: x_return_status := G_RET_STS_UNEXP_ERROR ;
384: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
385:
386: WHEN OTHERS THEN
387: ROLLBACK TO g_QA_Doc;
388: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

389: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
390: END IF;
391:
392: x_return_status := G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
395: END IF;
396: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
397: END qa_doc;

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

390: END IF;
391:
392: x_return_status := G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
395: END IF;
396: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
397: END qa_doc;
398:

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

392: x_return_status := G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
395: END IF;
396: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
397: END qa_doc;
398:
399: ---------------------------------------------------------------------------
400: -- Procedure QA_Doc version 2

Line 454: FND_MSG_PUB.initialize;

450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: -- Initialize API return status to success
457: x_return_status := G_RET_STS_SUCCESS;
458:

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

667:
668: END IF;
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving QA_Doc');
674: END IF;
675: END IF; -- Repository Enhancement (For Validate Action)

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

681: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
683: END IF;
684: x_return_status := G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO g_QA_Doc;
689: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

689: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
691: END IF;
692: x_return_status := G_RET_STS_UNEXP_ERROR ;
693: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
694:
695: WHEN OTHERS THEN
696: ROLLBACK TO g_QA_Doc;
697: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

698: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
699: END IF;
700:
701: x_return_status := G_RET_STS_UNEXP_ERROR ;
702: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
703: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
704: END IF;
705: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
706: END qa_doc;

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

699: END IF;
700:
701: x_return_status := G_RET_STS_UNEXP_ERROR ;
702: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
703: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
704: END IF;
705: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
706: END qa_doc;
707:

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

701: x_return_status := G_RET_STS_UNEXP_ERROR ;
702: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
703: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
704: END IF;
705: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
706: END qa_doc;
707:
708: ---------------------------------------------------------------------------
709: -- Procedure Check_Terms calls QA_doc version 2

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

794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm);
795: END IF;
796:
797: x_return_status := G_QA_STS_ERROR ;
798: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
799: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
800: END IF;
801: END Check_Terms;
802:

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

795: END IF;
796:
797: x_return_status := G_QA_STS_ERROR ;
798: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
799: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
800: END IF;
801: END Check_Terms;
802:
803: ---------------------------------------------------------------------------

Line 851: FND_MSG_PUB.initialize;

847: END IF;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.to_Boolean( p_init_msg_list ) THEN
851: FND_MSG_PUB.initialize;
852: END IF;
853:
854: -- Initialize API return status to success
855: x_return_status := G_RET_STS_SUCCESS;

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

929: END IF;
930: END IF;
931:
932: -- Standard call to get message count and if count is 1, get message info.
933: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
934: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
935: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving QA_Doc - OVERLOADED ONE ');
936: END IF;
937:

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

941: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
943: END IF;
944: x_return_status := G_RET_STS_ERROR ;
945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
946:
947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
948: ROLLBACK TO g_QA_Doc;
949: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

949: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
950: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
951: END IF;
952: x_return_status := G_RET_STS_UNEXP_ERROR ;
953: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
954:
955: WHEN OTHERS THEN
956: ROLLBACK TO g_QA_Doc;
957: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

958: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
959: END IF;
960:
961: x_return_status := G_RET_STS_UNEXP_ERROR ;
962: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
963: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
964: END IF;
965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
966: END QA_Doc;

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

959: END IF;
960:
961: x_return_status := G_RET_STS_UNEXP_ERROR ;
962: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
963: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
964: END IF;
965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
966: END QA_Doc;
967:

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

961: x_return_status := G_RET_STS_UNEXP_ERROR ;
962: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
963: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
964: END IF;
965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
966: END QA_Doc;
967:
968:
969: END OKC_TERMS_QA_GRP;