DBA Data[Home] [Help]

APPS.OKC_TERMS_VERSION_GRP dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to success
65: x_return_status := G_RET_STS_SUCCESS;
66:

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

190: IF FND_API.to_Boolean( p_commit ) THEN
191: COMMIT;
192: END IF;
193: -- Standard call to get message count and if count is 1, get message info.
194: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
195: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Version_Doc');
197: END IF;
198:

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

202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Version_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
204: END IF;
205: x_return_status := G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
207:
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO g_Version_Doc;
210: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

210: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
211: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Version_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
212: END IF;
213: x_return_status := G_RET_STS_UNEXP_ERROR ;
214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
215:
216: WHEN OTHERS THEN
217: ROLLBACK TO g_Version_Doc;
218: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

219: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Version_Doc because of EXCEPTION: '||sqlerrm);
220: END IF;
221:
222: x_return_status := G_RET_STS_UNEXP_ERROR ;
223: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
225: END IF;
226: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
227: END Version_Doc ;

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

220: END IF;
221:
222: x_return_status := G_RET_STS_UNEXP_ERROR ;
223: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
225: END IF;
226: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
227: END Version_Doc ;
228:

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

222: x_return_status := G_RET_STS_UNEXP_ERROR ;
223: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
225: END IF;
226: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
227: END Version_Doc ;
228:
229: /*
230: --This API will be used to restore a version terms whenever a version of

Line 260: FND_MSG_PUB.initialize;

256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262: -- Initialize API return status to success
263: x_return_status := G_RET_STS_SUCCESS;
264:

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

308: IF FND_API.to_Boolean( p_commit ) THEN
309: COMMIT;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Restore_Doc_Version');
315: END IF;
316: EXCEPTION

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

319: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception');
321: END IF;
322: x_return_status := G_RET_STS_ERROR ;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324:
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: ROLLBACK TO g_Restore_Doc_Version;
327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Restore_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
329: END IF;
330: x_return_status := G_RET_STS_UNEXP_ERROR ;
331: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
332:
333: WHEN OTHERS THEN
334: ROLLBACK TO g_Restore_Doc_Version;
335: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

336: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Restore_Doc_Version because of EXCEPTION: '||sqlerrm);
337: END IF;
338:
339: x_return_status := G_RET_STS_UNEXP_ERROR ;
340: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
341: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
342: END IF;
343: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
344: END Restore_Doc_Version ;

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

337: END IF;
338:
339: x_return_status := G_RET_STS_UNEXP_ERROR ;
340: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
341: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
342: END IF;
343: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
344: END Restore_Doc_Version ;
345:

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

339: x_return_status := G_RET_STS_UNEXP_ERROR ;
340: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
341: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
342: END IF;
343: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
344: END Restore_Doc_Version ;
345:
346: /*
347: --This API will be used to delete terms whenever a version of document is deleted.

Line 376: FND_MSG_PUB.initialize;

372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list ) THEN
376: FND_MSG_PUB.initialize;
377: END IF;
378: -- Initialize API return status to success
379: x_return_status := G_RET_STS_SUCCESS;
380:

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

450: IF FND_API.to_Boolean( p_commit ) THEN
451: COMMIT;
452: END IF;
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
455: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
456: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Leaving Delete_Doc_Version');
457: END IF;
458: EXCEPTION

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

461: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception');
463: END IF;
464: x_return_status := G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
466:
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: ROLLBACK TO g_Delete_Doc_Version;
469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
470: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
471: END IF;
472: x_return_status := G_RET_STS_UNEXP_ERROR ;
473: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
474:
475: WHEN OTHERS THEN
476: ROLLBACK TO g_Delete_Doc_Version;
477: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

478: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Doc_Version because of EXCEPTION: '||sqlerrm);
479: END IF;
480:
481: x_return_status := G_RET_STS_UNEXP_ERROR ;
482: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
483: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
484: END IF;
485: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
486: END Delete_Doc_Version ;

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

479: END IF;
480:
481: x_return_status := G_RET_STS_UNEXP_ERROR ;
482: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
483: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
484: END IF;
485: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
486: END Delete_Doc_Version ;
487: /* This API will be used to clear amendment related columns */

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

481: x_return_status := G_RET_STS_UNEXP_ERROR ;
482: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
483: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
484: END IF;
485: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
486: END Delete_Doc_Version ;
487: /* This API will be used to clear amendment related columns */
488:
489: Procedure clear_amendment (

Line 521: FND_MSG_PUB.initialize;

517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519: -- Initialize message list if p_init_msg_list is set to TRUE.
520: IF FND_API.to_Boolean( p_init_msg_list ) THEN
521: FND_MSG_PUB.initialize;
522: END IF;
523: -- Initialize API return status to success
524: x_return_status := G_RET_STS_SUCCESS;
525: --------------------------------------------

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

572: IF FND_API.to_Boolean( p_commit ) THEN
573: COMMIT;
574: END IF;
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,'300: Leaving clear_amendment');
579: END IF;
580:

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

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

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

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

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

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

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

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

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

605: x_return_status := G_RET_STS_UNEXP_ERROR ;
606: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
608: END IF;
609: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
610: END clear_amendment;
611:
612: -->>>>>>>>>>>>>>>>>>>>>>>>>>> EXTERNAL PROCEDURES >>>>>>>>>>>>>>>>>>>>>>>>>>>
613: