DBA Data[Home] [Help]

APPS.OKC_K_ARTICLES_GRP dependencies on FND_MSG_PUB

Line 129: FND_MSG_PUB.initialize;

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_Boolean( p_init_msg_list ) THEN
129: FND_MSG_PUB.initialize;
130: END IF;
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:

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

271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
276:
277: IF (l_debug = 'Y') THEN
278: okc_debug.log('700: Leaving create_article', 2);
279: END IF;

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

289: END IF;
290:
291: ROLLBACK TO g_create_article_GRP;
292: x_return_status := G_RET_STS_ERROR ;
293: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF (l_debug = 'Y') THEN
297: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

303:
304:
305: ROLLBACK TO g_create_article_GRP;
306: x_return_status := G_RET_STS_UNEXP_ERROR ;
307: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
308:
309: WHEN OTHERS THEN
310: IF (l_debug = 'Y') THEN
311: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);

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

316: END IF;
317:
318: ROLLBACK TO g_create_article_GRP;
319: x_return_status := G_RET_STS_UNEXP_ERROR ;
320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324:

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

317:
318: ROLLBACK TO g_create_article_GRP;
319: x_return_status := G_RET_STS_UNEXP_ERROR ;
320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324:
325: END create_article;

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

319: x_return_status := G_RET_STS_UNEXP_ERROR ;
320: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324:
325: END create_article;
326: ---------------------------------------
327: -- PROCEDURE validate_row --

Line 392: FND_MSG_PUB.initialize;

388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:

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

447: END IF;
448: --------------------------------------------
449:
450: -- Standard call to get message count and if count is 1, get message info.
451: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
452:
453: IF (l_debug = 'Y') THEN
454: okc_debug.log('200: Leaving validate_row', 2);
455: END IF;

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

460: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
461: END IF;
462: ROLLBACK TO g_validate_row_GRP;
463: x_return_status := G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: IF (l_debug = 'Y') THEN
468: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

468: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
469: END IF;
470: ROLLBACK TO g_validate_row_GRP;
471: x_return_status := G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
473:
474: WHEN OTHERS THEN
475: IF (l_debug = 'Y') THEN
476: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);

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

477: END IF;
478:
479: ROLLBACK TO g_validate_row_GRP;
480: x_return_status := G_RET_STS_UNEXP_ERROR ;
481: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
483: END IF;
484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
485:

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

478:
479: ROLLBACK TO g_validate_row_GRP;
480: x_return_status := G_RET_STS_UNEXP_ERROR ;
481: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
483: END IF;
484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
485:
486: END validate_row;

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

480: x_return_status := G_RET_STS_UNEXP_ERROR ;
481: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
483: END IF;
484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
485:
486: END validate_row;
487:
488: ---------------------------------------------------------------------------

Line 516: FND_MSG_PUB.initialize;

512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: -- Initialize message list if p_init_msg_list is set to TRUE.
515: IF FND_API.to_Boolean( p_init_msg_list ) THEN
516: FND_MSG_PUB.initialize;
517: END IF;
518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:

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

534: END IF;
535: --------------------------------------------
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
539:
540: IF (l_debug = 'Y') THEN
541: okc_debug.log('1200: Leaving lock_row', 2);
542: END IF;

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

547: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
548: END IF;
549: ROLLBACK TO g_lock_row_GRP;
550: x_return_status := G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: IF (l_debug = 'Y') THEN
555: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

555: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
556: END IF;
557: ROLLBACK TO g_lock_row_GRP;
558: x_return_status := G_RET_STS_UNEXP_ERROR ;
559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
560:
561: WHEN OTHERS THEN
562: IF (l_debug = 'Y') THEN
563: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);

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

564: END IF;
565:
566: ROLLBACK TO g_lock_row_GRP;
567: x_return_status := G_RET_STS_UNEXP_ERROR ;
568: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
570: END IF;
571: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
572:

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

565:
566: ROLLBACK TO g_lock_row_GRP;
567: x_return_status := G_RET_STS_UNEXP_ERROR ;
568: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
570: END IF;
571: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
572:
573: END lock_row;

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

567: x_return_status := G_RET_STS_UNEXP_ERROR ;
568: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
570: END IF;
571: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
572:
573: END lock_row;
574: ---------------------------------------------------------------------------
575: -- PROCEDURE update_article

Line 725: FND_MSG_PUB.initialize;

721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.
724: IF FND_API.to_Boolean( p_init_msg_list ) THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727:
728: IF FND_API.To_Boolean( p_validate_commit ) THEN
729:

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

922: IF FND_API.To_Boolean( p_commit ) THEN
923: COMMIT WORK;
924: END IF;
925: -- Standard call to get message count and if count is 1, get message info.
926: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
927:
928: IF (l_debug = 'Y') THEN
929: okc_debug.log('1800: Leaving update_article', 2);
930: END IF;

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

956: END IF;
957:
958: ROLLBACK TO g_update_article_grp;
959: x_return_status := G_RET_STS_ERROR ;
960: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963: IF (l_debug = 'Y') THEN
964: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

985: END IF;
986:
987: ROLLBACK TO g_update_article_grp;
988: x_return_status := G_RET_STS_UNEXP_ERROR ;
989: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
990:
991: WHEN OTHERS THEN
992: IF (l_debug = 'Y') THEN
993: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);

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

1014: END IF;
1015:
1016: ROLLBACK TO g_update_article_grp;
1017: x_return_status := G_RET_STS_UNEXP_ERROR ;
1018: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1019: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1020: END IF;
1021: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1022:

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

1015:
1016: ROLLBACK TO g_update_article_grp;
1017: x_return_status := G_RET_STS_UNEXP_ERROR ;
1018: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1019: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1020: END IF;
1021: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1022:
1023: END update_article;

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

1017: x_return_status := G_RET_STS_UNEXP_ERROR ;
1018: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1019: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1020: END IF;
1021: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1022:
1023: END update_article;
1024:
1025: ---------------------------------------------------------------------------

Line 1088: FND_MSG_PUB.initialize;

1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1088: FND_MSG_PUB.initialize;
1089: END IF;
1090:
1091: -- Initialize API return status to success
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1212: IF FND_API.To_Boolean( p_commit ) THEN
1213: COMMIT WORK;
1214: END IF;
1215: -- Standard call to get message count and if count is 1, get message info.
1216: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1217:
1218: IF (l_debug = 'Y') THEN
1219: okc_debug.log('2300: Leaving delete_article', 2);
1220: END IF;

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

1231:
1232:
1233: ROLLBACK TO g_delete_article_grp;
1234: x_return_status := G_RET_STS_ERROR ;
1235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: IF (l_debug = 'Y') THEN
1239: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1245:
1246:
1247: ROLLBACK TO g_delete_article_grp;
1248: x_return_status := G_RET_STS_UNEXP_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1250:
1251: WHEN OTHERS THEN
1252: IF (l_debug = 'Y') THEN
1253: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);

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

1259:
1260:
1261: ROLLBACK TO g_delete_article_grp;
1262: x_return_status := G_RET_STS_UNEXP_ERROR ;
1263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1265: END IF;
1266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1267:

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

1260:
1261: ROLLBACK TO g_delete_article_grp;
1262: x_return_status := G_RET_STS_UNEXP_ERROR ;
1263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1265: END IF;
1266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1267:
1268: END delete_article;

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

1262: x_return_status := G_RET_STS_UNEXP_ERROR ;
1263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1265: END IF;
1266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1267:
1268: END delete_article;
1269:
1270: