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: ---------------------------------------------------
521: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
522: END IF;
523:
524: x_return_status := G_RET_STS_ERROR ;
525: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
531: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
532: END IF;
533:
534: x_return_status := G_RET_STS_UNEXP_ERROR ;
535: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
536:
537: WHEN OTHERS THEN
538: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
540: G_MODULE||l_api_name,
541: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
542: END IF;
543:
544: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
546: END IF;
547: x_return_status := G_RET_STS_UNEXP_ERROR ;
548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
541: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
542: END IF;
543:
544: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
546: END IF;
547: x_return_status := G_RET_STS_UNEXP_ERROR ;
548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
549:
544: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
546: END IF;
547: x_return_status := G_RET_STS_UNEXP_ERROR ;
548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
549:
550: END get_user_defined_variables;
551:
552: ---------------------------------------------------
627: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
628: END IF;
629:
630: x_return_status := G_RET_STS_ERROR ;
631: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
632:
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
637: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
638: END IF;
639:
640: x_return_status := G_RET_STS_UNEXP_ERROR ;
641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
642:
643: WHEN OTHERS THEN
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,
647: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
648: END IF;
649:
650: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
652: END IF;
653: x_return_status := G_RET_STS_UNEXP_ERROR ;
654: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
647: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
648: END IF;
649:
650: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
652: END IF;
653: x_return_status := G_RET_STS_UNEXP_ERROR ;
654: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
655:
650: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
652: END IF;
653: x_return_status := G_RET_STS_UNEXP_ERROR ;
654: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
655:
656: END get_constant_values;
657:
658: ---------------------------------------------------
890: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
891: END IF;
892:
893: x_return_status := G_RET_STS_ERROR ;
894: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
900: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
901: END IF;
902:
903: x_return_status := G_RET_STS_UNEXP_ERROR ;
904: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
905:
906: WHEN OTHERS THEN
907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
908: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
909: G_MODULE||l_api_name,
910: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
911: END IF;
912:
913: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
915: END IF;
916: x_return_status := G_RET_STS_UNEXP_ERROR ;
917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
910: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
911: END IF;
912:
913: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
915: END IF;
916: x_return_status := G_RET_STS_UNEXP_ERROR ;
917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
918:
913: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
915: END IF;
916: x_return_status := G_RET_STS_UNEXP_ERROR ;
917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
918:
919: END get_udv_with_procedures;
920:
921:
1342: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1343: END IF;
1344:
1345: x_return_status := G_RET_STS_ERROR ;
1346: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1347:
1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1352: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1353: END IF;
1354:
1355: x_return_status := G_RET_STS_UNEXP_ERROR ;
1356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1357:
1358: WHEN OTHERS THEN
1359: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1361: G_MODULE||l_api_name,
1362: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1363: END IF;
1364:
1365: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1366: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1367: END IF;
1368: x_return_status := G_RET_STS_UNEXP_ERROR ;
1369: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1362: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1363: END IF;
1364:
1365: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1366: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1367: END IF;
1368: x_return_status := G_RET_STS_UNEXP_ERROR ;
1369: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1370:
1365: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1366: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1367: END IF;
1368: x_return_status := G_RET_STS_UNEXP_ERROR ;
1369: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1370:
1371: END get_document_values;
1372:
1373: