eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_UTIL_GRP dependencies on FND_MSG_PUB

Line 80: FND_MSG_PUB.initialize;

76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82: -- Initialize API return status to success
83: x_return_status := G_RET_STS_SUCCESS;
84:

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

170: IF FND_API.To_Boolean( p_commit ) THEN
171: COMMIT WORK;
172: END IF;
173: -- Standard call to get message count and if count is 1, get message info.
174: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1300: Leaving Delete_Doc');
177: END IF;
178:

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

182: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
183: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving Delete_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
184: END IF;
185: x_return_status := G_RET_STS_ERROR ;
186: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO g_Delete_Doc;
190: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

190: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving Delete_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
192: END IF;
193: x_return_status := G_RET_STS_UNEXP_ERROR ;
194: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
195:
196: WHEN OTHERS THEN
197: ROLLBACK TO g_Delete_Doc;
198:

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

200: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1600: Leaving Delete_Doc because of EXCEPTION: '||sqlerrm);
201: END IF;
202:
203: x_return_status := G_RET_STS_UNEXP_ERROR ;
204: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
206: END IF;
207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
208: END Delete_Doc ;

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

201: END IF;
202:
203: x_return_status := G_RET_STS_UNEXP_ERROR ;
204: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
206: END IF;
207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
208: END Delete_Doc ;
209:

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

203: x_return_status := G_RET_STS_UNEXP_ERROR ;
204: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
206: END IF;
207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
208: END Delete_Doc ;
209:
210: /*
211: -- To be used when doing bulk deletes of document.A very PO specific scenario.

Line 246: FND_MSG_PUB.initialize;

242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean( p_init_msg_list ) THEN
246: FND_MSG_PUB.initialize;
247: END IF;
248: -- Initialize API return status to success
249: x_return_status := G_RET_STS_SUCCESS;
250:

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

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

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

369: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
370: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2200: Leaving Purge_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
371: END IF;
372: x_return_status := G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO g_Purge_Doc;
377: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

377: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2300: Leaving Purge_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
379: END IF;
380: x_return_status := G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN OTHERS THEN
384: ROLLBACK TO g_Purge_Doc;
385:

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

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

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

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

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

390: x_return_status := G_RET_STS_UNEXP_ERROR ;
391: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
392: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
393: END IF;
394: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
395: END Purge_Doc ;
396:
397: /*
398: -- To be used in amend flow to mark articles as amended if any of system

Line 445: FND_MSG_PUB.initialize;

441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443: -- Initialize message list if p_init_msg_list is set to TRUE.
444: IF FND_API.to_Boolean( p_init_msg_list ) THEN
445: FND_MSG_PUB.initialize;
446: END IF;
447: -- Initialize API return status to success
448: x_return_status := G_RET_STS_SUCCESS;
449:

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

572: END LOOP;
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
577: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2700: Leaving Mark_Variable_Based_Amendment');
579: END IF;
580:

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

584: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2800: Leaving Mark_Variable_Based_Amendment : OKC_API.G_EXCEPTION_ERROR Exception');
586: END IF;
587: x_return_status := G_RET_STS_ERROR ;
588: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO g_Get_System_Variables;
592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
593: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2900: Leaving Mark_Variable_Based_Amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
594: END IF;
595: x_return_status := G_RET_STS_UNEXP_ERROR ;
596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
597:
598: WHEN OTHERS THEN
599: ROLLBACK TO g_Get_System_Variables;
600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3000: Leaving Mark_Variable_Based_Amendment because of EXCEPTION: '||sqlerrm);
602: END IF;
603:
604: x_return_status := G_RET_STS_UNEXP_ERROR ;
605: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
606: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
607: END IF;
608: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
609:

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

602: END IF;
603:
604: x_return_status := G_RET_STS_UNEXP_ERROR ;
605: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
606: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
607: END IF;
608: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
609:
610: END Mark_Variable_Based_Amendment;

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

604: x_return_status := G_RET_STS_UNEXP_ERROR ;
605: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
606: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
607: END IF;
608: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
609:
610: END Mark_Variable_Based_Amendment;
611:
612: /*

Line 652: FND_MSG_PUB.initialize;

648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650: -- Initialize message list if p_init_msg_list is set to TRUE.
651: IF FND_API.to_Boolean( p_init_msg_list ) THEN
652: FND_MSG_PUB.initialize;
653: END IF;
654: -- Initialize API return status to success
655: x_return_status := G_RET_STS_SUCCESS;
656:

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

667: l_return_value := G_NON_STANDARD_ART_EXIST;
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,'3200: Result Is_Article_exist? : ['||l_return_value||']');
674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3300: Leaving Is_Article_exist');
675: END IF;

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

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

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

688: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3500: Leaving Is_Article_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
690: END IF;
691: x_return_status := G_RET_STS_UNEXP_ERROR ;
692: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
693: RETURN FND_API.G_FALSE ;
694:
695: WHEN OTHERS THEN
696: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

700: IF find_art_crs%ISOPEN THEN
701: CLOSE find_art_crs;
702: END IF;
703: x_return_status := G_RET_STS_UNEXP_ERROR ;
704: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
706: END IF;
707: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
708: RETURN FND_API.G_FALSE ;

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

701: CLOSE find_art_crs;
702: END IF;
703: x_return_status := G_RET_STS_UNEXP_ERROR ;
704: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
706: END IF;
707: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
708: RETURN FND_API.G_FALSE ;
709: END Is_Article_exist ;

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

703: x_return_status := G_RET_STS_UNEXP_ERROR ;
704: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
706: END IF;
707: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
708: RETURN FND_API.G_FALSE ;
709: END Is_Article_exist ;
710:
711: FUNCTION Is_Article_Exist(

Line 921: FND_MSG_PUB.initialize;

917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919: -- Initialize message list if p_init_msg_list is set to TRUE.
920: IF FND_API.to_Boolean( p_init_msg_list ) THEN
921: FND_MSG_PUB.initialize;
922: END IF;
923: -- Initialize API return status to success
924: x_return_status := G_RET_STS_SUCCESS;
925:

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

941: END IF;
942: END IF;
943:
944: -- Standard call to get message count and if count is 1, get message info.
945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Result Deviation_From_Standard? : ['||l_return_value||']');
948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Deviation_From_Standard');
949: END IF;

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

953: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4000: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_ERROR Exception');
955: END IF;
956: x_return_status := G_RET_STS_ERROR ;
957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
958: RETURN NULL ;
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
961: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

961: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4100: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
963: END IF;
964: x_return_status := G_RET_STS_UNEXP_ERROR ;
965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
966: RETURN NULL ;
967:
968: WHEN OTHERS THEN
969: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

973: IF find_art_crs%ISOPEN THEN
974: CLOSE find_art_crs;
975: END IF;
976: x_return_status := G_RET_STS_UNEXP_ERROR ;
977: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
979: END IF;
980: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
981: RETURN NULL ;

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

974: CLOSE find_art_crs;
975: END IF;
976: x_return_status := G_RET_STS_UNEXP_ERROR ;
977: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
979: END IF;
980: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
981: RETURN NULL ;
982: END Deviation_From_Standard ;

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

976: x_return_status := G_RET_STS_UNEXP_ERROR ;
977: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
979: END IF;
980: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
981: RETURN NULL ;
982: END Deviation_From_Standard ;
983:
984: /*

Line 1028: FND_MSG_PUB.initialize;

1024: END IF;
1025:
1026: -- Initialize message list if p_init_msg_list is set to TRUE.
1027: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:
1031: -- Initialize API return status to success
1032: x_return_status := G_RET_STS_SUCCESS;

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

1039: FETCH find_tmpl_crs INTO l_return_value;
1040: CLOSE find_tmpl_crs ;
1041:
1042: -- Standard call to get message count and if count is 1, get message info.
1043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1044:
1045: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Result Is_Template_Expired? : ['||l_return_value||']');
1047: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Is_Template_Expired');

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

1055: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Is_Template_Expired : OKC_API.G_EXCEPTION_ERROR Exception');
1056: END IF;
1057:
1058: x_return_status := G_RET_STS_ERROR ;
1059: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1060: RETURN NULL ;
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1063: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1064: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Is_Template_Expired : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1065: END IF;
1066:
1067: x_return_status := G_RET_STS_UNEXP_ERROR ;
1068: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1069: RETURN NULL ;
1070:
1071: WHEN OTHERS THEN
1072: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1078: END IF;
1079:
1080: x_return_status := G_RET_STS_UNEXP_ERROR ;
1081:
1082: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1083: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1084: END IF;
1085:
1086: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1079:
1080: x_return_status := G_RET_STS_UNEXP_ERROR ;
1081:
1082: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1083: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1084: END IF;
1085:
1086: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1087: RETURN NULL ;

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

1082: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1083: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1084: END IF;
1085:
1086: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1087: RETURN NULL ;
1088: END Is_Template_Expired;
1089:
1090: /*

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

1131: END IF;
1132:
1133: IF l_return_value IS NULL THEN
1134: x_return_status := G_RET_STS_ERROR ;
1135: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1136: END IF;
1137:
1138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5600: Leaving Is_Deliverable_Exist');

Line 1184: FND_MSG_PUB.initialize;

1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;
1182: -- Initialize message list if p_init_msg_list is set to TRUE.
1183: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1184: FND_MSG_PUB.initialize;
1185: END IF;
1186: -- Initialize API return status to success
1187: x_return_status := G_RET_STS_SUCCESS;
1188:

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

1197: END IF;
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200:
1201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1202:
1203: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1204: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5800: Result Is_Article_AMENDED? : ['||l_return_value||']');
1205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5900: Leaving Is_Article_AMENDED');

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

1212: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1213: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6000: Leaving Is_Article_AMENDED : OKC_API.G_EXCEPTION_ERROR Exception');
1214: END IF;
1215: x_return_status := G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1217: RETURN NULL ;
1218:
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1220:

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

1221: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1222: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Is_Article_AMENDED : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1223: END IF;
1224: x_return_status := G_RET_STS_UNEXP_ERROR ;
1225: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1226: RETURN NULL ;
1227:
1228: WHEN OTHERS THEN
1229: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1235: END IF;
1236:
1237: x_return_status := G_RET_STS_UNEXP_ERROR ;
1238:
1239: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1241: END IF;
1242: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1243: RETURN NULL ;

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

1236:
1237: x_return_status := G_RET_STS_UNEXP_ERROR ;
1238:
1239: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1241: END IF;
1242: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1243: RETURN NULL ;
1244:

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

1238:
1239: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1241: END IF;
1242: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1243: RETURN NULL ;
1244:
1245: END Is_Article_AMENDED;
1246:

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

1287: END IF;
1288:
1289: IF l_return_value IS NULL THEN
1290: x_return_status := G_RET_STS_ERROR ;
1291: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1292: END IF;
1293: Return l_return_value;
1294: END;
1295:

Line 1336: FND_MSG_PUB.initialize;

1332: END IF;
1333:
1334: -- Initialize message list if p_init_msg_list is set to TRUE.
1335: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: -- Initialize API return status to success
1340: x_return_status := G_RET_STS_SUCCESS;

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

1343: FETCH find_tmpl_crs INTO x_template_id, x_template_name;
1344: CLOSE find_tmpl_crs;
1345:
1346: -- Standard call to get message count and if count is 1, get message info.
1347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1348:
1349: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1350: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Get_Terms_Template? : ['||l_return_value||']');
1351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Get_Terms_Template');

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

1357: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1358: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Get_Terms_Template : OKC_API.G_EXCEPTION_ERROR Exception');
1359: END IF;
1360:
1361: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1362: x_return_status := G_RET_STS_ERROR ;
1363:
1364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1365: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1366: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Get_Terms_Template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1367: END IF;
1368:
1369: x_return_status := G_RET_STS_UNEXP_ERROR ;
1370: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1371:
1372: WHEN OTHERS THEN
1373:
1374: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1376: END IF;
1377: IF find_tmpl_crs%ISOPEN THEN
1378: CLOSE find_tmpl_crs;
1379: END IF;
1380: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1382: END IF;
1383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1384: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1377: IF find_tmpl_crs%ISOPEN THEN
1378: CLOSE find_tmpl_crs;
1379: END IF;
1380: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1382: END IF;
1383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1384: x_return_status := G_RET_STS_UNEXP_ERROR ;
1385:

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

1379: END IF;
1380: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1382: END IF;
1383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1384: x_return_status := G_RET_STS_UNEXP_ERROR ;
1385:
1386: END Get_Terms_Template;
1387:

Line 1419: FND_MSG_PUB.initialize;

1415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1416: END IF;
1417: -- Initialize message list if p_init_msg_list is set to TRUE.
1418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1419: FND_MSG_PUB.initialize;
1420: END IF;
1421: -- Initialize API return status to success
1422: x_return_status := G_RET_STS_SUCCESS;
1423:

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

1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:
1432: -- Standard call to get message count and if count is 1, get message info.
1433: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1434: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Result Get_Contract_Document_Type? : ['||l_return_value||']');
1436: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Get_Contract_Document_Type');
1437: END IF;

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

1441: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Get_Contract_Document_Type : OKC_API.G_EXCEPTION_ERROR Exception');
1443: END IF;
1444: x_return_status := G_RET_STS_ERROR ;
1445: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1446: RETURN NULL ;
1447:
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1449: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1450: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Get_Contract_Document_Type : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1451: END IF;
1452: x_return_status := G_RET_STS_UNEXP_ERROR ;
1453: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1454: RETURN NULL ;
1455:
1456: WHEN OTHERS THEN
1457: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1461: IF find_chrtype_crs%ISOPEN THEN
1462: CLOSE find_chrtype_crs;
1463: END IF;
1464: x_return_status := G_RET_STS_UNEXP_ERROR ;
1465: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1467: END IF;
1468: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1469: RETURN NULL ;

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

1462: CLOSE find_chrtype_crs;
1463: END IF;
1464: x_return_status := G_RET_STS_UNEXP_ERROR ;
1465: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1467: END IF;
1468: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1469: RETURN NULL ;
1470: END Get_Contract_Document_Type;

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

1464: x_return_status := G_RET_STS_UNEXP_ERROR ;
1465: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1467: END IF;
1468: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1469: RETURN NULL ;
1470: END Get_Contract_Document_Type;
1471: /*
1472: -- To be used to find out document type/ID when document is of contract family.

Line 1508: FND_MSG_PUB.initialize;

1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: END IF;
1506: -- Initialize message list if p_init_msg_list is set to TRUE.
1507: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1508: FND_MSG_PUB.initialize;
1509: END IF;
1510: -- Initialize API return status to success
1511: x_return_status := G_RET_STS_SUCCESS;
1512:

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

1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1520: END IF;
1521:
1522: -- Standard call to get message count and if count is 1, get message info.
1523: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1524: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8200: Result Document_Type : ['||x_doc_type||']');
1526: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Result Document_ID : ['||x_doc_id||']');
1527: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8400: Leaving Get_Contract_Document_Type');

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

1531: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1532: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8500: Leaving Get_Contract_Document_Type_id : OKC_API.G_EXCEPTION_ERROR Exception');
1533: END IF;
1534: x_return_status := G_RET_STS_ERROR ;
1535: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1536:
1537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1538: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1539: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8600: Leaving Get_Contract_Document_Type_id : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1538: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1539: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8600: Leaving Get_Contract_Document_Type_id : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1540: END IF;
1541: x_return_status := G_RET_STS_UNEXP_ERROR ;
1542: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1543:
1544: WHEN OTHERS THEN
1545: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1546: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8700: Leaving Get_Contract_Document_Type_id because of EXCEPTION: '||sqlerrm);

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

1549: IF find_chrtype_crs%ISOPEN THEN
1550: CLOSE find_chrtype_crs;
1551: END IF;
1552: x_return_status := G_RET_STS_UNEXP_ERROR ;
1553: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1554: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1555: END IF;
1556: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1557: END Get_Contract_Document_Type_Id;

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

1550: CLOSE find_chrtype_crs;
1551: END IF;
1552: x_return_status := G_RET_STS_UNEXP_ERROR ;
1553: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1554: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1555: END IF;
1556: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1557: END Get_Contract_Document_Type_Id;
1558: /*

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

1552: x_return_status := G_RET_STS_UNEXP_ERROR ;
1553: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1554: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1555: END IF;
1556: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1557: END Get_Contract_Document_Type_Id;
1558: /*
1559: -- To be used to find out document type when document is of contract family.
1560: */

Line 1637: FND_MSG_PUB.initialize;

1633: END IF;
1634:
1635: -- Initialize message list if p_init_msg_list is set to TRUE.
1636: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1637: FND_MSG_PUB.initialize;
1638: END IF;
1639: -- Initialize API return status to success
1640: x_return_status := G_RET_STS_SUCCESS;
1641:

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

1727: CLOSE l_get_max_art_date_csr;
1728: END IF;
1729:
1730: x_return_status := G_RET_STS_ERROR ;
1731: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1732:
1733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1734: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'10200: Leaving get_last_update_date : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1739: CLOSE l_get_max_art_date_csr;
1740: END IF;
1741:
1742: x_return_status := G_RET_STS_UNEXP_ERROR ;
1743: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1744:
1745: WHEN OTHERS THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'10300: Leaving get_last_update_date because of EXCEPTION: '||sqlerrm);

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

1752: END IF;
1753:
1754:
1755: x_return_status := G_RET_STS_UNEXP_ERROR ;
1756: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1758: END IF;
1759: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1760: END get_last_update_date;

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

1753:
1754:
1755: x_return_status := G_RET_STS_UNEXP_ERROR ;
1756: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1758: END IF;
1759: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1760: END get_last_update_date;
1761:

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

1755: x_return_status := G_RET_STS_UNEXP_ERROR ;
1756: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1758: END IF;
1759: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1760: END get_last_update_date;
1761:
1762: FUNCTION Ok_To_Commit (
1763: p_api_version IN NUMBER,

Line 1809: FND_MSG_PUB.initialize;

1805: END IF;
1806:
1807: -- Initialize message list if p_init_msg_list is set to TRUE.
1808: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1809: FND_MSG_PUB.initialize;
1810: END IF;
1811:
1812: IF p_doc_type = G_TMPL_DOC_TYPE THEN
1813: OPEN l_tmpl_csr;

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

2034: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2035: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'13900: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
2036: END IF;
2037: x_return_status := G_RET_STS_ERROR ;
2038: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2039: RETURN FND_API.G_FALSE;
2040:
2041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2042: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2042: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2043: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14000: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2044: END IF;
2045: x_return_status := G_RET_STS_UNEXP_ERROR ;
2046: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2047: RETURN FND_API.G_FALSE;
2048:
2049: WHEN OTHERS THEN
2050: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2051: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14100: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);
2052: END IF;
2053:
2054: x_return_status := G_RET_STS_UNEXP_ERROR ;
2055: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2057: END IF;
2058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2059: RETURN FND_API.G_FALSE;

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

2052: END IF;
2053:
2054: x_return_status := G_RET_STS_UNEXP_ERROR ;
2055: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2057: END IF;
2058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2059: RETURN FND_API.G_FALSE;
2060:

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

2054: x_return_status := G_RET_STS_UNEXP_ERROR ;
2055: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2057: END IF;
2058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2059: RETURN FND_API.G_FALSE;
2060:
2061: END ok_to_commit;
2062:

Line 2104: FND_MSG_PUB.initialize;

2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101: END IF;
2102: -- Initialize message list if p_init_msg_list is set to TRUE.
2103: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2104: FND_MSG_PUB.initialize;
2105: END IF;
2106: -- Initialize API return status to success
2107: x_return_status := G_RET_STS_SUCCESS;
2108:

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

2120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: Leaving is_manual_article_exist');
2121: END IF;
2122:
2123: -- Standard call to get message count and if count is 1, get message info.
2124: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2125: RETURN l_return_value ;
2126:
2127: EXCEPTION
2128: WHEN FND_API.G_EXC_ERROR THEN

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

2129: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2130: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14400: Leaving is_manual_article_exist : OKC_API.G_EXCEPTION_ERROR Exception');
2131: END IF;
2132: x_return_status := G_RET_STS_ERROR ;
2133: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2134: RETURN NULL ;
2135:
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2137: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2138: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'14500: Leaving is_manual_article_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2139: END IF;
2140: x_return_status := G_RET_STS_UNEXP_ERROR ;
2141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2142: RETURN NULL ;
2143:
2144: WHEN OTHERS THEN
2145: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2149: IF find_art_crs%ISOPEN THEN
2150: CLOSE find_art_crs;
2151: END IF;
2152: x_return_status := G_RET_STS_UNEXP_ERROR ;
2153: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2155: END IF;
2156: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2157: RETURN NULL ;

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

2150: CLOSE find_art_crs;
2151: END IF;
2152: x_return_status := G_RET_STS_UNEXP_ERROR ;
2153: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2155: END IF;
2156: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2157: RETURN NULL ;
2158: END is_manual_article_exist ;

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

2152: x_return_status := G_RET_STS_UNEXP_ERROR ;
2153: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2155: END IF;
2156: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2157: RETURN NULL ;
2158: END is_manual_article_exist ;
2159:
2160:

Line 2191: FND_MSG_PUB.initialize;

2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2191: FND_MSG_PUB.initialize;
2192: END IF;
2193:
2194: -- Initialize API return status to success
2195: x_return_status := G_RET_STS_SUCCESS;

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

2207: CLOSE c_get_template_name;
2208:
2209:
2210: -- Standard call to get message count and if count is 1, get message info.
2211: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2212:
2213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Result Get_Template_Name : ['||l_return_value||']');
2215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: Leaving Get_Template_Name');

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

2225: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2226: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15100: Leaving Get_Template_Name : OKC_API.G_EXCEPTION_ERROR Exception');
2227: END IF;
2228: x_return_status := G_RET_STS_ERROR ;
2229: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2230: RETURN NULL ;
2231:
2232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2233: IF c_get_template_name%ISOPEN THEN

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

2236: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2237: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving Get_Template_Name : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2238: END IF;
2239: x_return_status := G_RET_STS_UNEXP_ERROR ;
2240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2241: RETURN NULL ;
2242:
2243: WHEN OTHERS THEN
2244: IF c_get_template_name%ISOPEN THEN

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

2248: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving Get_Template_Name because of EXCEPTION: '||sqlerrm);
2249: END IF;
2250:
2251: x_return_status := G_RET_STS_UNEXP_ERROR ;
2252: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2254: END IF;
2255: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2256: RETURN NULL ;

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

2249: END IF;
2250:
2251: x_return_status := G_RET_STS_UNEXP_ERROR ;
2252: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2254: END IF;
2255: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2256: RETURN NULL ;
2257:

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

2251: x_return_status := G_RET_STS_UNEXP_ERROR ;
2252: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2254: END IF;
2255: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2256: RETURN NULL ;
2257:
2258:
2259: END Get_Template_Name;

Line 2320: FND_MSG_PUB.initialize;

2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: END IF;
2318: -- Initialize message list if p_init_msg_list is set to TRUE.
2319: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2320: FND_MSG_PUB.initialize;
2321: END IF;
2322: -- Initialize API return status to success
2323: x_return_status := G_RET_STS_SUCCESS;
2324:

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

2421: NULL;
2422: END IF;
2423:
2424: -- Standard call to get message count and if count is 1, get message info.
2425: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2426: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15500: Leaving get_item_dtl_for_expert');
2428: END IF;
2429: EXCEPTION

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

2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15600: Leaving get_item_dtl_for_expert : OKC_API.G_EXCEPTION_ERROR Exception');
2434: END IF;
2435: x_return_status := G_RET_STS_ERROR ;
2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2437:
2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2439:
2440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15700: Leaving get_item_dtl_for_expert : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2442: END IF;
2443: x_return_status := G_RET_STS_UNEXP_ERROR ;
2444: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2445:
2446: WHEN OTHERS THEN
2447:
2448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15800: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);
2450: END IF;
2451:
2452: x_return_status := G_RET_STS_UNEXP_ERROR ;
2453: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2455: END IF;
2456: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2457:

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

2450: END IF;
2451:
2452: x_return_status := G_RET_STS_UNEXP_ERROR ;
2453: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2455: END IF;
2456: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2457:
2458: END get_item_dtl_for_expert;

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

2452: x_return_status := G_RET_STS_UNEXP_ERROR ;
2453: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2455: END IF;
2456: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2457:
2458: END get_item_dtl_for_expert;
2459:
2460: FUNCTION get_last_signed_revision(

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

2592: END IF;
2593: CLOSE l_get_template_dtl;
2594:
2595: -- Standard call to get message count and if count is 1, get message info.
2596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16500: Leaving Get_Terms_Template_dtl');
2599: END IF;
2600: EXCEPTION

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

2606: IF l_get_template_dtl%ISOPEN THEN
2607: CLOSE l_get_template_dtl;
2608: END IF;
2609: x_return_status := G_RET_STS_ERROR ;
2610: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2611:
2612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2613:
2614: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2617: IF l_get_template_dtl%ISOPEN THEN
2618: CLOSE l_get_template_dtl;
2619: END IF;
2620: x_return_status := G_RET_STS_UNEXP_ERROR ;
2621: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2622:
2623: WHEN OTHERS THEN
2624:
2625: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2628: IF l_get_template_dtl%ISOPEN THEN
2629: CLOSE l_get_template_dtl;
2630: END IF;
2631: x_return_status := G_RET_STS_UNEXP_ERROR ;
2632: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2634: END IF;
2635: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2636:

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

2629: CLOSE l_get_template_dtl;
2630: END IF;
2631: x_return_status := G_RET_STS_UNEXP_ERROR ;
2632: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2634: END IF;
2635: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2636:
2637: END Get_Terms_Template_dtl;

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

2631: x_return_status := G_RET_STS_UNEXP_ERROR ;
2632: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2634: END IF;
2635: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2636:
2637: END Get_Terms_Template_dtl;
2638:
2639: FUNCTION empclob

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

2697:
2698: CLOSE terms_tmpl_csr;
2699:
2700: -- Standard call to get message count and if count is 1, get message info.
2701: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2702: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2703: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Terms_Template_dtl');
2704: END IF;
2705: EXCEPTION

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

2711: IF terms_tmpl_csr%ISOPEN THEN
2712: CLOSE terms_tmpl_csr;
2713: END IF;
2714: x_return_status := G_RET_STS_ERROR ;
2715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2716:
2717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2718:
2719: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2722: IF terms_tmpl_csr%ISOPEN THEN
2723: CLOSE terms_tmpl_csr;
2724: END IF;
2725: x_return_status := G_RET_STS_UNEXP_ERROR ;
2726: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2727:
2728: WHEN OTHERS THEN
2729:
2730: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2733: IF terms_tmpl_csr%ISOPEN THEN
2734: CLOSE terms_tmpl_csr;
2735: END IF;
2736: x_return_status := G_RET_STS_UNEXP_ERROR ;
2737: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2738: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2739: END IF;
2740: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2741:

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

2734: CLOSE terms_tmpl_csr;
2735: END IF;
2736: x_return_status := G_RET_STS_UNEXP_ERROR ;
2737: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2738: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2739: END IF;
2740: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2741:
2742: END Get_Terms_Template_dtl;

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

2736: x_return_status := G_RET_STS_UNEXP_ERROR ;
2737: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2738: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2739: END IF;
2740: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2741:
2742: END Get_Terms_Template_dtl;
2743:
2744: FUNCTION enable_update(

Line 3032: FND_MSG_PUB.initialize;

3028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3029: END IF;
3030: -- Initialize message list if p_init_msg_list is set to TRUE.
3031: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3032: FND_MSG_PUB.initialize;
3033: END IF;
3034: -- Initialize API return status to success
3035: x_return_status := G_RET_STS_SUCCESS;
3036:

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

3071: END IF;
3072: END IF;
3073:
3074: -- Standard call to get message count and if count is 1, get message info.
3075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Contract_Details');
3078: END IF;
3079: EXCEPTION

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

3082: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3083: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17100: Leaving Get_Contract_Details : OKC_API.G_EXCEPTION_ERROR Exception');
3084: END IF;
3085: x_return_status := G_RET_STS_ERROR ;
3086: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3087:
3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3089:
3090: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3090: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17200: Leaving Get_Contract_Details : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3092: END IF;
3093: x_return_status := G_RET_STS_UNEXP_ERROR ;
3094: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3095:
3096: WHEN OTHERS THEN
3097:
3098: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3098: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17300: Leaving Get_Contract_Details because of EXCEPTION: '||sqlerrm);
3100: END IF;
3101: x_return_status := G_RET_STS_UNEXP_ERROR ;
3102: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3104: END IF;
3105: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3106:

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

3099: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17300: Leaving Get_Contract_Details because of EXCEPTION: '||sqlerrm);
3100: END IF;
3101: x_return_status := G_RET_STS_UNEXP_ERROR ;
3102: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3104: END IF;
3105: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3106:
3107: END Get_Contract_Details;

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

3101: x_return_status := G_RET_STS_UNEXP_ERROR ;
3102: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3104: END IF;
3105: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3106:
3107: END Get_Contract_Details;
3108:
3109: --Returns terms details for the document.

Line 3238: FND_MSG_PUB.initialize;

3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: END IF;
3236: -- Initialize message list if p_init_msg_list is set to TRUE.
3237: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3238: FND_MSG_PUB.initialize;
3239: END IF;
3240: -- Initialize API return status to success
3241: x_return_status := G_RET_STS_SUCCESS;
3242:

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

3346: END IF;
3347: END IF;
3348:
3349: -- Standard call to get message count and if count is 1, get message info.
3350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Contract_Details_All');
3353: END IF;
3354: EXCEPTION

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

3357: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3358: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17100: Leaving Get_Contract_Details_All : OKC_API.G_EXCEPTION_ERROR Exception');
3359: END IF;
3360: x_return_status := G_RET_STS_ERROR ;
3361: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3362:
3363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3364:
3365: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3365: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3366: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17200: Leaving Get_Contract_Details_All : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3367: END IF;
3368: x_return_status := G_RET_STS_UNEXP_ERROR ;
3369: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3370:
3371: WHEN OTHERS THEN
3372:
3373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17300: Leaving Get_Contract_Details_All because of EXCEPTION: '||sqlerrm);
3375: END IF;
3376: x_return_status := G_RET_STS_UNEXP_ERROR ;
3377: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3379: END IF;
3380: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3381:

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

3374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'17300: Leaving Get_Contract_Details_All because of EXCEPTION: '||sqlerrm);
3375: END IF;
3376: x_return_status := G_RET_STS_UNEXP_ERROR ;
3377: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3379: END IF;
3380: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3381:
3382: END Get_Contract_Details_All;

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

3376: x_return_status := G_RET_STS_UNEXP_ERROR ;
3377: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3379: END IF;
3380: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3381:
3382: END Get_Contract_Details_All;
3383:
3384: -- Returns AUTHORING_PARTY_CODE for the document

Line 3499: FND_MSG_PUB.initialize;

3495: END IF;
3496:
3497: -- Initialize message list if p_init_msg_list is set to TRUE.
3498: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3499: FND_MSG_PUB.initialize;
3500: END IF;
3501:
3502: x_return_status := G_RET_STS_SUCCESS;
3503:

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

3505: FETCH terms_tmpl_csr INTO l_result;
3506: CLOSE terms_tmpl_csr;
3507:
3508: -- Standard call to get message count and if count is 1, get message info.
3509: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3510:
3511: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3512: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Is_Terms_Template_Valid? : ['||l_result||']');
3513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Is_Terms_Template_Valid');

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

3525: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3526: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Is_Terms_Template_Valid : OKC_API.G_EXCEPTION_ERROR Exception');
3527: END IF;
3528:
3529: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3530: x_return_status := G_RET_STS_ERROR ;
3531:
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3534: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Is_Terms_Template_Valid : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3535: END IF;
3536:
3537: x_return_status := G_RET_STS_UNEXP_ERROR ;
3538: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3539:
3540: WHEN OTHERS THEN
3541:
3542: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3544: END IF;
3545: IF terms_tmpl_csr%ISOPEN THEN
3546: CLOSE terms_tmpl_csr;
3547: END IF;
3548: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3550: END IF;
3551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3552: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3545: IF terms_tmpl_csr%ISOPEN THEN
3546: CLOSE terms_tmpl_csr;
3547: END IF;
3548: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3550: END IF;
3551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3552: x_return_status := G_RET_STS_UNEXP_ERROR ;
3553: END Is_Terms_Template_Valid;

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

3547: END IF;
3548: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3550: END IF;
3551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3552: x_return_status := G_RET_STS_UNEXP_ERROR ;
3553: END Is_Terms_Template_Valid;
3554:
3555:

Line 3605: FND_MSG_PUB.initialize;

3601: END IF;
3602:
3603: -- Initialize message list if p_init_msg_list is set to TRUE.
3604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3605: FND_MSG_PUB.initialize;
3606: END IF;
3607:
3608: x_return_status := G_RET_STS_SUCCESS;
3609:

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

3631: x_template_description := NULL;
3632: END IF;
3633:
3634: -- Standard call to get message count and if count is 1, get message info.
3635: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3636:
3637: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Get_Contract_Defaults? : ['||x_return_status||']');
3639: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Get_Contract_Defaults');

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

3646: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3647: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Get_Contract_Defaults : OKC_API.G_EXCEPTION_ERROR Exception');
3648: END IF;
3649:
3650: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3651: x_return_status := G_RET_STS_ERROR ;
3652:
3653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3654: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3655: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Get_Contract_Defaults : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3656: END IF;
3657:
3658: x_return_status := G_RET_STS_UNEXP_ERROR ;
3659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3660:
3661: WHEN OTHERS THEN
3662:
3663: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3665: END IF;
3666: IF terms_tmpl_csr%ISOPEN THEN
3667: CLOSE terms_tmpl_csr;
3668: END IF;
3669: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3671: END IF;
3672: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3673: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3666: IF terms_tmpl_csr%ISOPEN THEN
3667: CLOSE terms_tmpl_csr;
3668: END IF;
3669: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3671: END IF;
3672: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3673: x_return_status := G_RET_STS_UNEXP_ERROR ;
3674: END Get_Contract_Defaults;

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

3668: END IF;
3669: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3671: END IF;
3672: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3673: x_return_status := G_RET_STS_UNEXP_ERROR ;
3674: END Get_Contract_Defaults;
3675:
3676: PROCEDURE Get_Default_Template(

Line 3728: FND_MSG_PUB.initialize;

3724: END IF;
3725:
3726: -- Initialize message list if p_init_msg_list is set to TRUE.
3727: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3728: FND_MSG_PUB.initialize;
3729: END IF;
3730:
3731: x_return_status := G_RET_STS_SUCCESS;
3732:

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

3734: FETCH terms_tmpl_csr INTO x_template_id,x_template_name,x_template_description;
3735: CLOSE terms_tmpl_csr;
3736:
3737: -- Standard call to get message count and if count is 1, get message info.
3738: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3739:
3740: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3741: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result x_template_id : ['||x_template_id||']');
3742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7010: Result x_template_name : ['||x_template_name||']');

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

3750:
3751: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3752: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Get_Default_Template : OKC_API.G_EXCEPTION_ERROR Exception');
3753: END IF;
3754: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3755: x_return_status := G_RET_STS_ERROR ;
3756:
3757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3758: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3759: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Get_Default_Template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3760: END IF;
3761:
3762: x_return_status := G_RET_STS_UNEXP_ERROR ;
3763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3764:
3765: WHEN OTHERS THEN
3766:
3767: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3769: END IF;
3770: IF terms_tmpl_csr%ISOPEN THEN
3771: CLOSE terms_tmpl_csr;
3772: END IF;
3773: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3775: END IF;
3776: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3777: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3770: IF terms_tmpl_csr%ISOPEN THEN
3771: CLOSE terms_tmpl_csr;
3772: END IF;
3773: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3775: END IF;
3776: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3777: x_return_status := G_RET_STS_UNEXP_ERROR ;
3778: END Get_Default_Template;

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

3772: END IF;
3773: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3775: END IF;
3776: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3777: x_return_status := G_RET_STS_UNEXP_ERROR ;
3778: END Get_Default_Template;
3779:
3780: --Returns 'Y' or 'N' depending on wether the API is able to generate deviation report.

Line 3903: FND_MSG_PUB.initialize;

3899: END IF;
3900:
3901: -- Initialize message list if p_init_msg_list is set to TRUE.
3902: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3903: FND_MSG_PUB.initialize;
3904: END IF;
3905:
3906: x_return_status := G_RET_STS_SUCCESS;
3907:

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

3915: );
3916:
3917:
3918: -- Standard call to get message count and if count is 1, get message info.
3919: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3920:
3921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Has_Uploaded_Deviations_Doc? : ['||x_return_status||']');
3923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'x_contract_source:'||x_contract_source);

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

3931: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3932: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Has_Uploaded_Deviations_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
3933: END IF;
3934:
3935: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3936: x_return_status := G_RET_STS_ERROR ;
3937:
3938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3939: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3940: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Has_Uploaded_Deviations_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3941: END IF;
3942:
3943: x_return_status := G_RET_STS_UNEXP_ERROR ;
3944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3945:
3946: WHEN OTHERS THEN
3947:
3948: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3947:
3948: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3949: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7400: Leaving Has_Uploaded_Deviations_Doc because of EXCEPTION:'||sqlerrm);
3950: END IF;
3951: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3952: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3953: END IF;
3954: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3955: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3948: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3949: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7400: Leaving Has_Uploaded_Deviations_Doc because of EXCEPTION:'||sqlerrm);
3950: END IF;
3951: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3952: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3953: END IF;
3954: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3955: x_return_status := G_RET_STS_UNEXP_ERROR ;
3956: END Has_Uploaded_Deviations_Doc;

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

3950: END IF;
3951: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3952: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3953: END IF;
3954: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3955: x_return_status := G_RET_STS_UNEXP_ERROR ;
3956: END Has_Uploaded_Deviations_Doc;
3957:
3958: -- Returns 'Y' if Deviations report is implemented and enabled for the particular document, else 'N' .

Line 4058: FND_MSG_PUB.initialize;

4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4055: END IF;
4056: -- Initialize message list if p_init_msg_list is set to TRUE.
4057: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4058: FND_MSG_PUB.initialize;
4059: END IF;
4060: -- Initialize API return status to success
4061: x_return_status := G_RET_STS_SUCCESS;
4062:

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

4085: END IF;
4086:
4087: -- Standard call to get message count and if count is 1, get message info.
4088:
4089: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4090:
4091: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4092: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Result Contract_Terms_Amended? : ['||l_return_value||']');
4093: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Contract_Terms_Amended');

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

4100: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4101: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_ERROR Exception');
4102: END IF;
4103: x_return_status := G_RET_STS_ERROR ;
4104: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4105: RETURN NULL ;
4106:
4107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4108:

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

4109: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4110: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4111: END IF;
4112: x_return_status := G_RET_STS_UNEXP_ERROR ;
4113: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4114: RETURN NULL ;
4115:
4116: WHEN OTHERS THEN
4117: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4127: END IF;
4128:
4129: x_return_status := G_RET_STS_UNEXP_ERROR ;
4130:
4131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4133: END IF;
4134: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4135: RETURN NULL ;

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

4128:
4129: x_return_status := G_RET_STS_UNEXP_ERROR ;
4130:
4131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4133: END IF;
4134: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4135: RETURN NULL ;
4136:

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

4130:
4131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4133: END IF;
4134: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4135: RETURN NULL ;
4136:
4137: END Contract_Terms_Amended;
4138:

Line 4195: FND_MSG_PUB.initialize;

4191: END IF;
4192:
4193: -- Initialize message list if p_init_msg_list is set to TRUE.
4194: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4195: FND_MSG_PUB.initialize;
4196: END IF;
4197:
4198: x_return_status := G_RET_STS_SUCCESS;
4199:

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

4244:
4245: CLOSE l_translated_csr;
4246:
4247: -- Standard call to get message count and if count is 1, get message info.
4248: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4249:
4250: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7300: Leaving get_translated_template');
4252: END IF;

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

4256: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4257: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7400: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_ERROR Exception');
4258: END IF;
4259: x_return_status := G_RET_STS_ERROR ;
4260: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4261: RETURN ;
4262:
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264:

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

4265: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4266: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7500: Leaving Contract_Terms_Amended : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4267: END IF;
4268: x_return_status := G_RET_STS_UNEXP_ERROR ;
4269: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4270: RETURN ;
4271: WHEN OTHERS THEN
4272:
4273: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4272:
4273: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4274: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7700: Leaving get_translated_template because of EXCEPTION:'||sqlerrm);
4275: END IF;
4276: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4278: END IF;
4279: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4280: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4273: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4274: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7700: Leaving get_translated_template because of EXCEPTION:'||sqlerrm);
4275: END IF;
4276: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4278: END IF;
4279: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4280: x_return_status := G_RET_STS_UNEXP_ERROR ;
4281: END get_translated_template;

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

4275: END IF;
4276: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4278: END IF;
4279: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4280: x_return_status := G_RET_STS_UNEXP_ERROR ;
4281: END get_translated_template;
4282: --MLS for templates
4283: