DBA Data[Home] [Help]

APPS.OKC_TERMS_COPY_PVT dependencies on FND_MSG_PUB

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

564:
565:
566:
567:
568: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
569:
570: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_article_variables '||x_return_status);
572: END IF;

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

581: IF l_get_variables_csr%ISOPEN THEN
582: CLOSE l_get_variables_csr;
583: END IF;
584: x_return_status := G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588:
589: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

593: IF l_get_variables_csr%ISOPEN THEN
594: CLOSE l_get_variables_csr;
595: END IF;
596: x_return_status := G_RET_STS_UNEXP_ERROR;
597: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
598:
599: WHEN OTHERS THEN
600:
601: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

611: p_token1_value => sqlcode,
612: p_token2 => G_SQLERRM_TOKEN,
613: p_token2_value => sqlerrm);
614: x_return_status := G_RET_STS_UNEXP_ERROR;
615: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
616:
617: END copy_article_variables;
618:
619:

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

1609: END IF;
1610: -------------------- CONC MOD CHANGES END -----------------
1611:
1612:
1613: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1614:
1615: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1616: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_articles '||x_return_status);
1617: END IF;

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

1652: CLOSE l_get_std_csr;
1653: END IF;
1654:
1655: x_return_status := G_RET_STS_ERROR;
1656: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1657:
1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1659:
1660: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1676: CLOSE l_get_org_csr;
1677: END IF;
1678:
1679: x_return_status := G_RET_STS_UNEXP_ERROR;
1680: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1681:
1682: WHEN OTHERS THEN
1683:
1684: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1713: p_token2 => G_SQLERRM_TOKEN,
1714: p_token2_value => sqlerrm);
1715:
1716: x_return_status := G_RET_STS_UNEXP_ERROR;
1717: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1718:
1719: END copy_articles;
1720:
1721: procedure copy_sections(

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

2156: END IF;
2157: END IF;
2158: -------------------- CONC MOD CHANGES -------------
2159:
2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2161:
2162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_sections '||x_return_status);
2164: END IF;

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

2175: CLOSE l_get_scn_csr ;
2176: END IF;
2177:
2178: x_return_status := G_RET_STS_ERROR;
2179: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2180:
2181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2182:
2183: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2188: CLOSE l_get_scn_csr ;
2189: END IF;
2190:
2191: x_return_status := G_RET_STS_UNEXP_ERROR;
2192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2193:
2194: WHEN OTHERS THEN
2195:
2196: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2208: p_token2 => G_SQLERRM_TOKEN,
2209: p_token2_value => sqlerrm);
2210:
2211: x_return_status := G_RET_STS_UNEXP_ERROR;
2212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2213:
2214: END copy_sections;
2215:
2216:

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

2453: ---end clm changes.
2454:
2455: END IF;
2456:
2457: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2458:
2459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving remove_template_based_articles '||x_return_status);
2461: END IF;

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

2522: CLOSE l_check_unassigned_section_csr ;
2523: END IF;
2524:
2525: x_return_status := G_RET_STS_ERROR;
2526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2527:
2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2529:
2530: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2555: CLOSE l_check_unassigned_section_csr ;
2556: END IF;
2557:
2558: x_return_status := G_RET_STS_UNEXP_ERROR;
2559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2560:
2561: WHEN OTHERS THEN
2562:
2563: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2579: p_token2 => G_SQLERRM_TOKEN,
2580: p_token2_value => sqlerrm);
2581:
2582: x_return_status := G_RET_STS_UNEXP_ERROR;
2583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2584:
2585: END remove_template_based_articles;
2586:
2587: PROCEDURE copy_tc(

Line 2730: FND_MSG_PUB.initialize;

2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.
2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2730: FND_MSG_PUB.initialize;
2731: END IF;
2732:
2733: -- Initialize API return status to success
2734: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3623: COMMIT WORK;
3624: END IF;
3625:
3626: -- Standard call to get message count and if count is 1, get message info.
3627: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3628:
3629: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3630: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Leaving copy_tc');
3631: END IF;

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

3704: END IF;
3705:
3706: ROLLBACK TO g_copy_tc_pvt;
3707: x_return_status := G_RET_STS_ERROR ;
3708: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3709:
3710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3711: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_tc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

3741: END IF;
3742:
3743: ROLLBACK TO g_copy_tc_pvt;
3744: x_return_status := G_RET_STS_UNEXP_ERROR ;
3745: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3746:
3747: WHEN OTHERS THEN
3748: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3749: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_tc because of EXCEPTION: '||sqlerrm);

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

3774: END IF;
3775:
3776: ROLLBACK TO g_copy_tc_pvt;
3777: x_return_status := G_RET_STS_UNEXP_ERROR ;
3778: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3780: END IF;
3781: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3782:

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

3775:
3776: ROLLBACK TO g_copy_tc_pvt;
3777: x_return_status := G_RET_STS_UNEXP_ERROR ;
3778: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3780: END IF;
3781: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3782:
3783: END copy_tc;

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

3777: x_return_status := G_RET_STS_UNEXP_ERROR ;
3778: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3780: END IF;
3781: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3782:
3783: END copy_tc;
3784:
3785:

Line 3890: FND_MSG_PUB.initialize;

3886: END IF;
3887:
3888: -- Initialize message list if p_init_msg_list is set to TRUE.
3889: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3890: FND_MSG_PUB.initialize;
3891: END IF;
3892:
3893: -- Initialize API return status to success
3894: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4079: COMMIT WORK;
4080: END IF;
4081:
4082: -- Standard call to get message count and if count is 1, get message info.
4083: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4084:
4085: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4086: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc');
4087: END IF;

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

4109: END IF;
4110:
4111: ROLLBACK TO g_copy_archived_doc_pvt;
4112: x_return_status := G_RET_STS_ERROR ;
4113: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4114:
4115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4116:
4117: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4127: END IF;
4128:
4129: ROLLBACK TO g_copy_archived_doc_pvt;
4130: x_return_status := G_RET_STS_UNEXP_ERROR ;
4131: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4132:
4133: WHEN OTHERS THEN
4134:
4135: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4146:
4147: ROLLBACK TO g_copy_archived_doc_pvt;
4148: x_return_status := G_RET_STS_UNEXP_ERROR ;
4149:
4150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4152: END IF;
4153:
4154: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

4147: ROLLBACK TO g_copy_archived_doc_pvt;
4148: x_return_status := G_RET_STS_UNEXP_ERROR ;
4149:
4150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4152: END IF;
4153:
4154: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4155:

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

4150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4152: END IF;
4153:
4154: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4155:
4156: END copy_archived_doc;
4157:
4158: END OKC_TERMS_COPY_PVT;