APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on FND_MSG_PUB

Line 309: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

Line 624: FND_MSG_PUB.initialize;

620: -- Initialize API return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: IF FND_API.to_Boolean( p_init_msg_list ) THEN
624: FND_MSG_PUB.initialize;
625: END IF;
626:
627:
628: IF (p_current_org_id = G_GLOBAL_ORG_ID ) OR

Line 1106: FND_MSG_PUB.initialize;

1102: END IF;
1103: x_return_status := G_RET_STS_SUCCESS;
1104:
1105: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1106: FND_MSG_PUB.initialize;
1107: END IF;
1108: OPEN l_article_version_csr (p_article_version_id);
1109: FETCH l_article_version_csr INTO l_article_version_rec;
1110: l_rownotfound := l_article_version_csr%NOTFOUND;

Line 1420: FND_MSG_PUB.initialize;

1416: END IF;
1417: x_return_status := G_RET_STS_SUCCESS;
1418:
1419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1420: FND_MSG_PUB.initialize;
1421: END IF;
1422: OPEN l_article_version_csr (p_article_version_id);
1423: FETCH l_article_version_csr INTO l_article_version_rec;
1424: l_rownotfound := l_article_version_csr%NOTFOUND;