DBA Data[Home] [Help]

APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on FND_MSG_PUB

Line 307: FND_MSG_PUB.initialize;

303: okc_debug.log('100: Entered hold_unhold with '||p_hold_yn||'*'||p_article_version_id, 2);
304: END IF;
305:
306: IF FND_API.to_Boolean( p_init_msg_list ) THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309: -- MOAC
310: G_CURRENT_ORG_ID := mo_global.get_current_org_id();
311: /*

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

432: COMMIT;
433: IF (l_debug = 'Y') THEN
434: okc_debug.log('200: Leaving Hold Unhold successfully ', 2);
435: END IF;
436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
437:
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: IF (l_debug = 'Y') THEN

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

440: IF (l_debug = 'Y') THEN
441: okc_debug.log('300: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_ERROR Exception', 2);
442: END IF;
443: x_return_status := G_RET_STS_ERROR ;
444: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: IF (l_debug = 'Y') THEN
448: okc_debug.log('400: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

447: IF (l_debug = 'Y') THEN
448: okc_debug.log('400: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
449: END IF;
450: x_return_status := G_RET_STS_UNEXP_ERROR ;
451: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
452:
453: WHEN OTHERS THEN
454: IF (l_debug = 'Y') THEN
455: okc_debug.log('500: Leaving Hold_Unhold because of EXCEPTION: '||sqlerrm, 2);

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

455: okc_debug.log('500: Leaving Hold_Unhold because of EXCEPTION: '||sqlerrm, 2);
456: END IF;
457:
458: x_return_status := G_RET_STS_UNEXP_ERROR ;
459: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
460:
461: END hold_unhold;
462:
463: ---------------------------------------

Line 612: FND_MSG_PUB.initialize;

608: -- Initialize API return status to success
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610:
611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
612: FND_MSG_PUB.initialize;
613: END IF;
614:
615:
616: IF (p_current_org_id = G_GLOBAL_ORG_ID ) OR

Line 1088: FND_MSG_PUB.initialize;

1084: END IF;
1085: x_return_status := G_RET_STS_SUCCESS;
1086:
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1088: FND_MSG_PUB.initialize;
1089: END IF;
1090: OPEN l_article_version_csr (p_article_version_id);
1091: FETCH l_article_version_csr INTO l_article_version_rec;
1092: l_rownotfound := l_article_version_csr%NOTFOUND;

Line 1398: FND_MSG_PUB.initialize;

1394: END IF;
1395: x_return_status := G_RET_STS_SUCCESS;
1396:
1397: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1398: FND_MSG_PUB.initialize;
1399: END IF;
1400: OPEN l_article_version_csr (p_article_version_id);
1401: FETCH l_article_version_csr INTO l_article_version_rec;
1402: l_rownotfound := l_article_version_csr%NOTFOUND;