205: );
206:
207:
208: -- Standard call to get message count and if count is 1, get message info.
209: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
210:
211: -- end debug log
212: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: END IF;
225:
226: x_return_status := G_RET_STS_UNEXP_ERROR ;
227:
228: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
230: END IF;
231:
232: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
225:
226: x_return_status := G_RET_STS_UNEXP_ERROR ;
227:
228: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
230: END IF;
231:
232: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
233:
228: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
230: END IF;
231:
232: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
233:
234:
235: END create_clause_model;
236:
632: );
633:
634:
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
637:
638:
639:
640: -- end debug log
653: END IF;
654:
655: x_return_status := G_RET_STS_UNEXP_ERROR ;
656:
657: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
659: END IF;
660:
661: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
654:
655: x_return_status := G_RET_STS_UNEXP_ERROR ;
656:
657: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
659: END IF;
660:
661: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
662:
657: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
659: END IF;
660:
661: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
662:
663:
664: END create_clause_component;
665:
1060: );
1061:
1062:
1063: -- Standard call to get message count and if count is 1, get message info.
1064: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1065:
1066:
1067: -- end debug log
1068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1080: END IF;
1081:
1082: x_return_status := G_RET_STS_UNEXP_ERROR ;
1083:
1084: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1086: END IF;
1087:
1088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1081:
1082: x_return_status := G_RET_STS_UNEXP_ERROR ;
1083:
1084: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1086: END IF;
1087:
1088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1089:
1084: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1086: END IF;
1087:
1088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1089:
1090:
1091: END create_clause_feature;
1092:
1453:
1454: END IF; -- if row count > 0
1455:
1456: -- Standard call to get message count and if count is 1, get message info.
1457: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1458:
1459:
1460: -- end debug log
1461: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1473: END IF;
1474:
1475: x_return_status := G_RET_STS_UNEXP_ERROR ;
1476:
1477: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1478: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1479: END IF;
1480:
1481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1474:
1475: x_return_status := G_RET_STS_UNEXP_ERROR ;
1476:
1477: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1478: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1479: END IF;
1480:
1481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1482:
1477: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1478: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1479: END IF;
1480:
1481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1482:
1483:
1484: END create_clause_options;
1485:
1880: );
1881:
1882:
1883: -- Standard call to get message count and if count is 1, get message info.
1884: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1885:
1886:
1887: -- end debug log
1888: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1900: END IF;
1901:
1902: x_return_status := G_RET_STS_UNEXP_ERROR ;
1903:
1904: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1905: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1906: END IF;
1907:
1908: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1901:
1902: x_return_status := G_RET_STS_UNEXP_ERROR ;
1903:
1904: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1905: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1906: END IF;
1907:
1908: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1909:
1904: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1905: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1906: END IF;
1907:
1908: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1909:
1910:
1911: END create_variable_model_ref;
1912:
2003: END IF;
2004:
2005: -- Initialize message list if p_init_msg_list is set to TRUE.
2006: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2007: FND_MSG_PUB.initialize;
2008: END IF;
2009:
2010: -- Initialize API return status to success
2011: x_return_status := FND_API.G_RET_STS_SUCCESS;
2286: COMMIT WORK;
2287: END IF;
2288:
2289: -- Standard call to get message count and if count is 1, get message info.
2290: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2291:
2292: -- end debug log
2293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2304: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2305: END IF;
2306:
2307: x_return_status := G_RET_STS_ERROR ;
2308: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2314: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2315: END IF;
2316:
2317: x_return_status := G_RET_STS_UNEXP_ERROR ;
2318: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2319:
2320: WHEN OTHERS THEN
2321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2324: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2325: END IF;
2326:
2327: x_return_status := G_RET_STS_UNEXP_ERROR ;
2328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2330: END IF;
2331: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2332:
2325: END IF;
2326:
2327: x_return_status := G_RET_STS_UNEXP_ERROR ;
2328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2330: END IF;
2331: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2332:
2333:
2327: x_return_status := G_RET_STS_UNEXP_ERROR ;
2328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2330: END IF;
2331: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2332:
2333:
2334: END import_clauses;
2335: