DBA Data[Home] [Help]

APPS.OKC_K_ART_VARIABLES_GRP dependencies on FND_MSG_PUB

Line 73: FND_MSG_PUB.initialize;

69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: IF FND_API.To_Boolean( p_validate_commit ) THEN
77:

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

164: COMMIT WORK;
165: END IF;
166:
167: -- Standard call to get message count and if count is 1, get message info.
168: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
169:
170: IF (l_debug = 'Y') THEN
171: okc_debug.log('900: Leaving update_article_var_values', 2);
172: END IF;

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

183: END IF;
184:
185: ROLLBACK TO g_upd_article_var_values_GRP;
186: x_return_status := G_RET_STS_ERROR ;
187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: IF (l_debug = 'Y') THEN
191: okc_debug.log('400: Leavingupdate_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

197:
198:
199: ROLLBACK TO g_upd_article_var_values_GRP;
200: x_return_status := G_RET_STS_UNEXP_ERROR ;
201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
202:
203: WHEN OTHERS THEN
204: IF (l_debug = 'Y') THEN
205: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);

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

211:
212:
213: ROLLBACK TO g_upd_article_var_values_GRP;
214: x_return_status := G_RET_STS_UNEXP_ERROR ;
215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
217: END IF;
218:
219: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

212:
213: ROLLBACK TO g_upd_article_var_values_GRP;
214: x_return_status := G_RET_STS_UNEXP_ERROR ;
215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
217: END IF;
218:
219: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
220: END update_article_var_values;

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

215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
217: END IF;
218:
219: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
220: END update_article_var_values;
221:
222:
223: Procedure update_global_var_values(

Line 267: FND_MSG_PUB.initialize;

263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: IF FND_API.To_Boolean( p_validate_commit ) THEN
271:

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:
363: IF (l_debug = 'Y') THEN
364: okc_debug.log('900: Leaving update_global_var_values', 2);
365: END IF;

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

375: END IF;
376:
377: ROLLBACK TO g_upd_article_var_values_GRP;
378: x_return_status := G_RET_STS_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: IF (l_debug = 'Y') THEN
383: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

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

390:
391:
392: ROLLBACK TO g_upd_article_var_values_GRP;
393: x_return_status := G_RET_STS_UNEXP_ERROR ;
394: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
395:
396: WHEN OTHERS THEN
397: IF (l_debug = 'Y') THEN
398: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);

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

404:
405:
406: ROLLBACK TO g_upd_article_var_values_GRP;
407: x_return_status := G_RET_STS_UNEXP_ERROR ;
408: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
410: END IF;
411:
412: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

405:
406: ROLLBACK TO g_upd_article_var_values_GRP;
407: x_return_status := G_RET_STS_UNEXP_ERROR ;
408: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
410: END IF;
411:
412: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
413: END update_global_var_values;

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

408: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
410: END IF;
411:
412: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
413: END update_global_var_values;
414:
415:
416: Procedure update_local_var_values(

Line 453: FND_MSG_PUB.initialize;

449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: IF FND_API.To_Boolean( p_validate_commit ) THEN
457:

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

540: COMMIT WORK;
541: END IF;
542:
543: -- Standard call to get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
545:
546: IF (l_debug = 'Y') THEN
547: okc_debug.log('900: Leaving update_local_var_values', 2);
548: END IF;

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

554: END IF;
555:
556: ROLLBACK TO g_upd_article_var_values_GRP;
557: x_return_status := G_RET_STS_ERROR ;
558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: IF (l_debug = 'Y') THEN
562: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

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

565:
566:
567: ROLLBACK TO g_upd_article_var_values_GRP;
568: x_return_status := G_RET_STS_UNEXP_ERROR ;
569: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
570:
571: WHEN OTHERS THEN
572: IF (l_debug = 'Y') THEN
573: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);

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

575:
576:
577: ROLLBACK TO g_upd_article_var_values_GRP;
578: x_return_status := G_RET_STS_UNEXP_ERROR ;
579: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
581: END IF;
582:
583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

576:
577: ROLLBACK TO g_upd_article_var_values_GRP;
578: x_return_status := G_RET_STS_UNEXP_ERROR ;
579: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
581: END IF;
582:
583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
584: END update_local_var_values;

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

579: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
581: END IF;
582:
583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
584: END update_local_var_values;
585:
586: Procedure update_response_var_values(
587: p_api_version IN NUMBER,

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

663: IF (l_debug = 'Y') THEN
664: okc_debug.log('500: Leaving update_response_var_values because of EXCEPTION: '||sqlerrm, 2);
665: END IF;
666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
669: END IF;
670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671: END update_response_var_values;

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

664: okc_debug.log('500: Leaving update_response_var_values because of EXCEPTION: '||sqlerrm, 2);
665: END IF;
666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
669: END IF;
670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671: END update_response_var_values;
672:

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

666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
669: END IF;
670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671: END update_response_var_values;
672:
673:
674: