146: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
147: END IF;
148:
149: x_return_status := G_RET_STS_ERROR ;
150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
151:
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
156: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
157: END IF;
158:
159: x_return_status := G_RET_STS_UNEXP_ERROR ;
160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
161:
162: WHEN OTHERS THEN
163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
165: G_MODULE||l_api_name,
166: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
167: END IF;
168:
169: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
170: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
171: END IF;
172: x_return_status := G_RET_STS_UNEXP_ERROR ;
173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
166: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
167: END IF;
168:
169: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
170: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
171: END IF;
172: x_return_status := G_RET_STS_UNEXP_ERROR ;
173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
174:
169: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
170: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
171: END IF;
172: x_return_status := G_RET_STS_UNEXP_ERROR ;
173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
174:
175: END get_system_variables;
176:
177: ---------------------------------------------------
361: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
362: END IF;
363:
364: x_return_status := G_RET_STS_ERROR ;
365: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
371: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
372: END IF;
373:
374: x_return_status := G_RET_STS_UNEXP_ERROR ;
375: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
376:
377: WHEN OTHERS THEN
378: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
380: G_MODULE||l_api_name,
381: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
382: END IF;
383:
384: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
385: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
386: END IF;
387: x_return_status := G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
381: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
382: END IF;
383:
384: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
385: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
386: END IF;
387: x_return_status := G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
389:
384: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
385: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
386: END IF;
387: x_return_status := G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
389:
390: END get_line_system_variables;
391:
392: ---------------------------------------------------
522: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
523: END IF;
524:
525: x_return_status := G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
532: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
533: END IF;
534:
535: x_return_status := G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
537:
538: WHEN OTHERS THEN
539: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
541: G_MODULE||l_api_name,
542: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
543: END IF;
544:
545: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
547: END IF;
548: x_return_status := G_RET_STS_UNEXP_ERROR ;
549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
542: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
543: END IF;
544:
545: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
547: END IF;
548: x_return_status := G_RET_STS_UNEXP_ERROR ;
549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
550:
545: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
547: END IF;
548: x_return_status := G_RET_STS_UNEXP_ERROR ;
549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
550:
551: END get_user_defined_variables;
552:
553: ---------------------------------------------------
628: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
629: END IF;
630:
631: x_return_status := G_RET_STS_ERROR ;
632: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
638: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
639: END IF;
640:
641: x_return_status := G_RET_STS_UNEXP_ERROR ;
642: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
643:
644: WHEN OTHERS THEN
645: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
647: G_MODULE||l_api_name,
648: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
649: END IF;
650:
651: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
653: END IF;
654: x_return_status := G_RET_STS_UNEXP_ERROR ;
655: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
648: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
649: END IF;
650:
651: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
653: END IF;
654: x_return_status := G_RET_STS_UNEXP_ERROR ;
655: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
656:
651: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
653: END IF;
654: x_return_status := G_RET_STS_UNEXP_ERROR ;
655: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
656:
657: END get_constant_values;
658:
659: ---------------------------------------------------
936: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
937: END IF;
938:
939: x_return_status := G_RET_STS_ERROR ;
940: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
946: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
947: END IF;
948:
949: x_return_status := G_RET_STS_UNEXP_ERROR ;
950: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
951:
952: WHEN OTHERS THEN
953: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
955: G_MODULE||l_api_name,
956: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
957: END IF;
958:
959: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
960: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
961: END IF;
962: x_return_status := G_RET_STS_UNEXP_ERROR ;
963: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
956: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
957: END IF;
958:
959: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
960: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
961: END IF;
962: x_return_status := G_RET_STS_UNEXP_ERROR ;
963: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
964:
959: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
960: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
961: END IF;
962: x_return_status := G_RET_STS_UNEXP_ERROR ;
963: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
964:
965: END get_udv_with_procedures;
966:
967:
1481: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1482: END IF;
1483:
1484: x_return_status := G_RET_STS_ERROR ;
1485: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1486:
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1489: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1491: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1492: END IF;
1493:
1494: x_return_status := G_RET_STS_UNEXP_ERROR ;
1495: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1496:
1497: WHEN OTHERS THEN
1498: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1500: G_MODULE||l_api_name,
1501: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1502: END IF;
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1506: END IF;
1507: x_return_status := G_RET_STS_UNEXP_ERROR ;
1508: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1501: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1502: END IF;
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1506: END IF;
1507: x_return_status := G_RET_STS_UNEXP_ERROR ;
1508: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1509:
1504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1506: END IF;
1507: x_return_status := G_RET_STS_UNEXP_ERROR ;
1508: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1509:
1510: END get_document_values;
1511:
1512: