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 169: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

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

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

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

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

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

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

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

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

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

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

Line 269: FND_MSG_PUB.initialize;

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

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

360: COMMIT WORK;
361: END IF;
362:
363: -- Standard call to get message count and if count is 1, get message info.
364: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
365:
366: IF (l_debug = 'Y') THEN
367: okc_debug.log('900: Leaving update_global_var_values', 2);
368: END IF;

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

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

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

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

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

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

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

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

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

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

Line 459: FND_MSG_PUB.initialize;

455: END IF;
456:
457: -- Initialize message list if p_init_msg_list is set to TRUE.
458: IF FND_API.to_Boolean( p_init_msg_list ) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: IF FND_API.To_Boolean( p_validate_commit ) THEN
463:

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

547: COMMIT WORK;
548: END IF;
549:
550: -- Standard call to get message count and if count is 1, get message info.
551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
552:
553: IF (l_debug = 'Y') THEN
554: okc_debug.log('900: Leaving update_local_var_values', 2);
555: END IF;

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

561: END IF;
562:
563: ROLLBACK TO g_upd_article_var_values_GRP;
564: x_return_status := G_RET_STS_ERROR ;
565: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: IF (l_debug = 'Y') THEN
569: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

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

572:
573:
574: ROLLBACK TO g_upd_article_var_values_GRP;
575: x_return_status := G_RET_STS_UNEXP_ERROR ;
576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
577:
578: WHEN OTHERS THEN
579: IF (l_debug = 'Y') THEN
580: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);

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

582:
583:
584: ROLLBACK TO g_upd_article_var_values_GRP;
585: x_return_status := G_RET_STS_UNEXP_ERROR ;
586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
588: END IF;
589:
590: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

583:
584: ROLLBACK TO g_upd_article_var_values_GRP;
585: x_return_status := G_RET_STS_UNEXP_ERROR ;
586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
588: END IF;
589:
590: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
591: END update_local_var_values;

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

586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
588: END IF;
589:
590: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
591: END update_local_var_values;
592:
593: Procedure update_response_var_values(
594: p_api_version IN NUMBER,

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

670: IF (l_debug = 'Y') THEN
671: okc_debug.log('500: Leaving update_response_var_values because of EXCEPTION: '||sqlerrm, 2);
672: END IF;
673: x_return_status := G_RET_STS_UNEXP_ERROR ;
674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
676: END IF;
677: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
678: END update_response_var_values;

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

671: okc_debug.log('500: Leaving update_response_var_values because of EXCEPTION: '||sqlerrm, 2);
672: END IF;
673: x_return_status := G_RET_STS_UNEXP_ERROR ;
674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
676: END IF;
677: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
678: END update_response_var_values;
679:

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

673: x_return_status := G_RET_STS_UNEXP_ERROR ;
674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
676: END IF;
677: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
678: END update_response_var_values;
679:
680:
681: