597: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
598: END IF;
599:
600: x_return_status := G_RET_STS_ERROR ;
601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
607: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
608: END IF;
609:
610: x_return_status := G_RET_STS_UNEXP_ERROR ;
611: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
612:
613: WHEN OTHERS THEN
614: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
616: G_MODULE||l_api_name,
617: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
618: END IF;
619:
620: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
622: END IF;
623: x_return_status := G_RET_STS_UNEXP_ERROR ;
624: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
617: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
618: END IF;
619:
620: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
622: END IF;
623: x_return_status := G_RET_STS_UNEXP_ERROR ;
624: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
625:
620: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
622: END IF;
623: x_return_status := G_RET_STS_UNEXP_ERROR ;
624: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
625:
626: END get_clm_udv;
627:
628:
681: END IF;
682:
683: /* Initialize message list if p_init_msg_list is set to TRUE */
684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: /* Initialize API return status to success */
689: x_return_status := G_RET_STS_SUCCESS;
740: l_previous_var_code := csr_get_clm_udv_rec.variable_code;
741:
742: END LOOP;
743:
744: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN
745:
746: x_return_status := G_RET_STS_ERROR;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
762: CLOSE csr_get_clm_udv;
763: END IF;
764:
765: x_return_status := G_RET_STS_ERROR ;
766: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
775: CLOSE csr_get_clm_udv;
776: END IF;
777:
778: x_return_status := G_RET_STS_UNEXP_ERROR ;
779: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
780:
781: WHEN OTHERS THEN
782:
783: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
788: CLOSE csr_get_clm_udv;
789: END IF;
790:
791: x_return_status := G_RET_STS_UNEXP_ERROR ;
792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
793: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
794: END IF;
795: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
796:
789: END IF;
790:
791: x_return_status := G_RET_STS_UNEXP_ERROR ;
792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
793: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
794: END IF;
795: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
796:
797:
791: x_return_status := G_RET_STS_UNEXP_ERROR ;
792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
793: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
794: END IF;
795: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
796:
797:
798: END set_clm_udv;
799:
1233: END IF;
1234:
1235: x_return_status := G_RET_STS_UNEXP_ERROR ;
1236:
1237: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1239: END IF;
1240:
1241: END clm_remove_dup_sections;
1234:
1235: x_return_status := G_RET_STS_UNEXP_ERROR ;
1236:
1237: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1239: END IF;
1240:
1241: END clm_remove_dup_sections;
1242:
1341: END IF;
1342:
1343: x_return_status := G_RET_STS_UNEXP_ERROR ;
1344:
1345: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1347: END IF;
1348:
1349: END clm_remove_dup_articles;
1342:
1343: x_return_status := G_RET_STS_UNEXP_ERROR ;
1344:
1345: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1347: END IF;
1348:
1349: END clm_remove_dup_articles;
1350: