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_K_ARTICLES_GRP dependencies on FND_MSG_PUB

Line 132: FND_MSG_PUB.initialize;

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

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

302: IF FND_API.To_Boolean( p_commit ) THEN
303: COMMIT WORK;
304: END IF;
305: -- Standard call to get message count and if count is 1, get message info.
306: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
307:
308: IF (l_debug = 'Y') THEN
309: okc_debug.log('700: Leaving create_article', 2);
310: END IF;

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

320: END IF;
321:
322: ROLLBACK TO g_create_article_GRP;
323: x_return_status := G_RET_STS_ERROR ;
324: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: IF (l_debug = 'Y') THEN
328: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

334:
335:
336: ROLLBACK TO g_create_article_GRP;
337: x_return_status := G_RET_STS_UNEXP_ERROR ;
338: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
339:
340: WHEN OTHERS THEN
341: IF (l_debug = 'Y') THEN
342: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);

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

347: END IF;
348:
349: ROLLBACK TO g_create_article_GRP;
350: x_return_status := G_RET_STS_UNEXP_ERROR ;
351: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
353: END IF;
354: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
355:

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

348:
349: ROLLBACK TO g_create_article_GRP;
350: x_return_status := G_RET_STS_UNEXP_ERROR ;
351: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
353: END IF;
354: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
355:
356: END create_article;

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

350: x_return_status := G_RET_STS_UNEXP_ERROR ;
351: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
353: END IF;
354: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
355:
356: END create_article;
357: ---------------------------------------
358: -- PROCEDURE validate_row --

Line 424: FND_MSG_PUB.initialize;

420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: -- Initialize message list if p_init_msg_list is set to TRUE.
423: IF FND_API.to_Boolean( p_init_msg_list ) THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426: -- Initialize API return status to success
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:

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

480: END IF;
481: --------------------------------------------
482:
483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
485:
486: IF (l_debug = 'Y') THEN
487: okc_debug.log('200: Leaving validate_row', 2);
488: END IF;

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

493: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
494: END IF;
495: ROLLBACK TO g_validate_row_GRP;
496: x_return_status := G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF (l_debug = 'Y') THEN
501: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

501: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
502: END IF;
503: ROLLBACK TO g_validate_row_GRP;
504: x_return_status := G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
506:
507: WHEN OTHERS THEN
508: IF (l_debug = 'Y') THEN
509: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);

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

510: END IF;
511:
512: ROLLBACK TO g_validate_row_GRP;
513: x_return_status := G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
516: END IF;
517: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
518:

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

511:
512: ROLLBACK TO g_validate_row_GRP;
513: x_return_status := G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
516: END IF;
517: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
518:
519: END validate_row;

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

513: x_return_status := G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
516: END IF;
517: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
518:
519: END validate_row;
520:
521: ---------------------------------------------------------------------------

Line 549: FND_MSG_PUB.initialize;

545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:

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

567: END IF;
568: --------------------------------------------
569:
570: -- Standard call to get message count and if count is 1, get message info.
571: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
572:
573: IF (l_debug = 'Y') THEN
574: okc_debug.log('1200: Leaving lock_row', 2);
575: END IF;

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

580: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
581: END IF;
582: ROLLBACK TO g_lock_row_GRP;
583: x_return_status := G_RET_STS_ERROR ;
584: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: IF (l_debug = 'Y') THEN
588: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

588: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
589: END IF;
590: ROLLBACK TO g_lock_row_GRP;
591: x_return_status := G_RET_STS_UNEXP_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
593:
594: WHEN OTHERS THEN
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);

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

597: END IF;
598:
599: ROLLBACK TO g_lock_row_GRP;
600: x_return_status := G_RET_STS_UNEXP_ERROR ;
601: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
602: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
603: END IF;
604: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
605:

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

598:
599: ROLLBACK TO g_lock_row_GRP;
600: x_return_status := G_RET_STS_UNEXP_ERROR ;
601: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
602: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
603: END IF;
604: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
605:
606: END lock_row;

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

600: x_return_status := G_RET_STS_UNEXP_ERROR ;
601: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
602: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
603: END IF;
604: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
605:
606: END lock_row;
607: ---------------------------------------------------------------------------
608: -- PROCEDURE update_article

Line 761: FND_MSG_PUB.initialize;

757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: -- Initialize message list if p_init_msg_list is set to TRUE.
760: IF FND_API.to_Boolean( p_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF p_document_id IS NULL OR p_document_type IS NULL OR p_orig_system_reference_id1 IS NULL THEN
765: OPEN l_document_id_csr;

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

1028: IF FND_API.To_Boolean( p_commit ) THEN
1029: COMMIT WORK;
1030: END IF;
1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1033:
1034: IF (l_debug = 'Y') THEN
1035: okc_debug.log('1800: Leaving update_article', 2);
1036: END IF;

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

1062: END IF;
1063:
1064: ROLLBACK TO g_update_article_grp;
1065: x_return_status := G_RET_STS_ERROR ;
1066: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (l_debug = 'Y') THEN
1070: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1091: END IF;
1092:
1093: ROLLBACK TO g_update_article_grp;
1094: x_return_status := G_RET_STS_UNEXP_ERROR ;
1095: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1096:
1097: WHEN OTHERS THEN
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);

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

1120: END IF;
1121:
1122: ROLLBACK TO g_update_article_grp;
1123: x_return_status := G_RET_STS_UNEXP_ERROR ;
1124: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1126: END IF;
1127: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1128:

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

1121:
1122: ROLLBACK TO g_update_article_grp;
1123: x_return_status := G_RET_STS_UNEXP_ERROR ;
1124: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1126: END IF;
1127: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1128:
1129: END update_article;

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

1123: x_return_status := G_RET_STS_UNEXP_ERROR ;
1124: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1126: END IF;
1127: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1128:
1129: END update_article;
1130:
1131: ---------------------------------------------------------------------------

Line 1196: FND_MSG_PUB.initialize;

1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194: -- Initialize message list if p_init_msg_list is set to TRUE.
1195: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1196: FND_MSG_PUB.initialize;
1197: END IF;
1198:
1199: -- Initialize API return status to success
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1374: IF FND_API.To_Boolean( p_commit ) THEN
1375: COMMIT WORK;
1376: END IF;
1377: -- Standard call to get message count and if count is 1, get message info.
1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1379:
1380: IF (l_debug = 'Y') THEN
1381: okc_debug.log('2300: Leaving delete_article', 2);
1382: END IF;

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

1393:
1394:
1395: ROLLBACK TO g_delete_article_grp;
1396: x_return_status := G_RET_STS_ERROR ;
1397: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1398:
1399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1400: IF (l_debug = 'Y') THEN
1401: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1407:
1408:
1409: ROLLBACK TO g_delete_article_grp;
1410: x_return_status := G_RET_STS_UNEXP_ERROR ;
1411: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1412:
1413: WHEN OTHERS THEN
1414: IF (l_debug = 'Y') THEN
1415: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);

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

1421:
1422:
1423: ROLLBACK TO g_delete_article_grp;
1424: x_return_status := G_RET_STS_UNEXP_ERROR ;
1425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1427: END IF;
1428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1429:

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

1422:
1423: ROLLBACK TO g_delete_article_grp;
1424: x_return_status := G_RET_STS_UNEXP_ERROR ;
1425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1427: END IF;
1428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1429:
1430: END delete_article;

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

1424: x_return_status := G_RET_STS_UNEXP_ERROR ;
1425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1427: END IF;
1428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1429:
1430: END delete_article;
1431:
1432: