244: --
245: -- Initialize message list if p_init_msg_list is set to TRUE.
246: --
247: IF FND_API.to_Boolean( p_init_msg_list ) THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250:
251:
252: OPEN c_get_expert_yes_no('Yes');
558: END IF;
559:
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561:
562: FND_MSG_PUB.Count_And_Get(
563: p_count => x_msg_count,
564: p_data => x_msg_data );
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'450: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
592: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'460: x_return_status = '||x_return_status);
593: END IF;
594:
595: FND_MSG_PUB.Count_And_Get(
596: p_count => x_msg_count,
597: p_data => x_msg_data );
598:
599: WHEN OTHERS THEN
619: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'470: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
620: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: x_return_status = '||x_return_status);
621: END IF;
622:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624: FND_MSG_PUB.Add_Exc_Msg(
625: G_PKG_NAME ,
626: l_api_name );
627: END IF;
620: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'480: x_return_status = '||x_return_status);
621: END IF;
622:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624: FND_MSG_PUB.Add_Exc_Msg(
625: G_PKG_NAME ,
626: l_api_name );
627: END IF;
628:
625: G_PKG_NAME ,
626: l_api_name );
627: END IF;
628:
629: FND_MSG_PUB.Count_And_Get(
630: p_count => x_msg_count,
631: p_data => x_msg_data );
632:
633: END get_clause_variable_values;
684: --
685: -- Initialize message list if p_init_msg_list is set to TRUE.
686: --
687: IF FND_API.to_Boolean( p_init_msg_list ) THEN
688: FND_MSG_PUB.initialize;
689: END IF;
690:
691: l_index := p_variables_tbl.FIRST;
692: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
769: END IF;
770:
771: FND_MSG_PUB.Count_And_Get(
772: p_count => x_msg_count,
773: p_data => x_msg_data );
774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
780: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
781: END IF;
782:
783: FND_MSG_PUB.Count_And_Get(
784: p_count => x_msg_count,
785: p_data => x_msg_data );
786:
787: WHEN OTHERS THEN
791: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
792: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
793: END IF;
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(
797: G_PKG_NAME ,
798: l_api_name );
799: END IF;
792: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
793: END IF;
794:
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
796: FND_MSG_PUB.Add_Exc_Msg(
797: G_PKG_NAME ,
798: l_api_name );
799: END IF;
800:
797: G_PKG_NAME ,
798: l_api_name );
799: END IF;
800:
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data );
804:
805: END Get_clause_Variable_Values;
931: --
932: -- Initialize message list if p_init_msg_list is set to TRUE.
933: --
934: IF FND_API.to_Boolean( p_init_msg_list ) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: OPEN c_get_quote_org_id;
939: FETCH c_get_quote_org_id INTO l_quote_org_id;
1038: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'130: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1039: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'140: x_return_status = '||x_return_status);
1040: END IF;
1041:
1042: FND_MSG_PUB.Count_And_Get(
1043: p_count => x_msg_count,
1044: p_data => x_msg_data );
1045:
1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'150: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'160: x_return_status = '||x_return_status);
1056: END IF;
1057:
1058: FND_MSG_PUB.Count_And_Get(
1059: p_count => x_msg_count,
1060: p_data => x_msg_data );
1061:
1062: WHEN OTHERS THEN
1069: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'170: '||l_package_procedure||' In the OTHERS section');
1070: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
1071: END IF;
1072:
1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1074: FND_MSG_PUB.Add_Exc_Msg(
1075: G_PKG_NAME ,
1076: l_api_name );
1077: END IF;
1070: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: x_return_status = '||x_return_status);
1071: END IF;
1072:
1073: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1074: FND_MSG_PUB.Add_Exc_Msg(
1075: G_PKG_NAME ,
1076: l_api_name );
1077: END IF;
1078:
1075: G_PKG_NAME ,
1076: l_api_name );
1077: END IF;
1078:
1079: FND_MSG_PUB.Count_And_Get(
1080: p_count => x_msg_count,
1081: p_data => x_msg_data );
1082:
1083: END Get_Line_Variable_Values;