eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_UTIL_PVT dependencies on FND_MSG_PUB

Line 131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

127: CLOSE l_get_rec;
128: END IF;
129:
130: x_return_status := G_RET_STS_UNEXP_ERROR ;
131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
133: END IF;
134: END ALLOWED_TMPL_USAGES_Delete_Set;
135: ---

Line 132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

128: END IF;
129:
130: x_return_status := G_RET_STS_UNEXP_ERROR ;
131: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
133: END IF;
134: END ALLOWED_TMPL_USAGES_Delete_Set;
135: ---
136:

Line 216: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

212: CLOSE l_get_rec;
213: END IF;
214:
215: x_return_status := G_RET_STS_UNEXP_ERROR ;
216: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
218: END IF;
219:
220:

Line 217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

213: END IF;
214:
215: x_return_status := G_RET_STS_UNEXP_ERROR ;
216: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
218: END IF;
219:
220:
221: END Update_Allowed_Tmpl_Usages_Id;

Line 549: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

545: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving Delete_Doc because of EXCEPTION: '||sqlerrm);
547: END IF;
548:
549: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
551: END IF;
552: x_return_status := G_RET_STS_UNEXP_ERROR ;
553: END Delete_Doc ;

Line 550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

546: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving Delete_Doc because of EXCEPTION: '||sqlerrm);
547: END IF;
548:
549: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
551: END IF;
552: x_return_status := G_RET_STS_UNEXP_ERROR ;
553: END Delete_Doc ;
554: /*

Line 674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

670: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving delete_doc_version because of EXCEPTION: '||sqlerrm);
672: END IF;
673:
674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
676: END IF;
677: x_return_status := G_RET_STS_UNEXP_ERROR ;
678: END Delete_Doc_version ;

Line 675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

671: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving delete_doc_version because of EXCEPTION: '||sqlerrm);
672: END IF;
673:
674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
676: END IF;
677: x_return_status := G_RET_STS_UNEXP_ERROR ;
678: END Delete_Doc_version ;
679:

Line 718: FND_MSG_PUB.initialize;

714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716: -- Initialize message list if p_init_msg_list is set to TRUE.
717: IF FND_API.to_Boolean( p_init_msg_list ) THEN
718: FND_MSG_PUB.initialize;
719: END IF;
720: -- Initialize API return status to success
721: x_return_status := G_RET_STS_SUCCESS;
722:

Line 751: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

747: --------------------------------------------
748: END LOOP;
749:
750: -- Standard call to get message count and if count is 1, get message info.
751: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
752: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Mark_Amendment');
754: END IF;
755: EXCEPTION

Line 762: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

758: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
759: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Mark_Amendment : OKC_API.G_EXCEPTION_ERROR Exception');
760: END IF;
761: x_return_status := G_RET_STS_ERROR ;
762: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO g_Mark_Amendment;
766: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 770: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

766: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Mark_Amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
768: END IF;
769: x_return_status := G_RET_STS_UNEXP_ERROR ;
770: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
771:
772: WHEN OTHERS THEN
773: ROLLBACK TO g_Mark_Amendment;
774: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 779: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

775: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4900: Leaving Mark_Amendment because of EXCEPTION: '||sqlerrm);
776: END IF;
777:
778: x_return_status := G_RET_STS_UNEXP_ERROR ;
779: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
781: END IF;
782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
783: END Mark_Amendment;

Line 780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

776: END IF;
777:
778: x_return_status := G_RET_STS_UNEXP_ERROR ;
779: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
781: END IF;
782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
783: END Mark_Amendment;
784:

Line 782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

778: x_return_status := G_RET_STS_UNEXP_ERROR ;
779: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
781: END IF;
782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
783: END Mark_Amendment;
784:
785: /*
786: -- PROCEDURE Merge_Template_Working_Copy

Line 845: FND_MSG_PUB.initialize;

841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843: -- Initialize message list if p_init_msg_list is set to TRUE.
844: IF FND_API.to_Boolean( p_init_msg_list ) THEN
845: FND_MSG_PUB.initialize;
846: END IF;
847: -- Initialize API return status to success
848: x_return_status := G_RET_STS_SUCCESS;
849:

Line 1139: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1135:
1136: -- ================ Actual Procedure Code end =======================
1137:
1138: -- Standard call to get message count and if count is 1, get message info.
1139: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6100: Leaving Merge_Template_Working_Copy');
1142: END IF;
1143:

Line 1151: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1147: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Merge_Template_Working_Copy : OKC_API.G_EXCEPTION_ERROR Exception');
1149: END IF;
1150: x_return_status := G_RET_STS_ERROR ;
1151: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1152:
1153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1154: ROLLBACK TO g_Merge_Template_Working_Copy;
1155: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1159: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1155: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6300: Leaving Merge_Template_Working_Copy : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1157: END IF;
1158: x_return_status := G_RET_STS_UNEXP_ERROR ;
1159: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1160:
1161: WHEN OTHERS THEN
1162: ROLLBACK TO g_Merge_Template_Working_Copy;
1163: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1168: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1164: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6400: Leaving Merge_Template_Working_Copy because of EXCEPTION: '||sqlerrm);
1165: END IF;
1166:
1167: x_return_status := G_RET_STS_UNEXP_ERROR ;
1168: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1170: END IF;
1171: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1172: END Merge_Template_Working_Copy ;

Line 1169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1165: END IF;
1166:
1167: x_return_status := G_RET_STS_UNEXP_ERROR ;
1168: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1170: END IF;
1171: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1172: END Merge_Template_Working_Copy ;
1173:

Line 1171: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1167: x_return_status := G_RET_STS_UNEXP_ERROR ;
1168: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1170: END IF;
1171: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1172: END Merge_Template_Working_Copy ;
1173:
1174: /*
1175: -- PROCEDURE Get_System_Variables

Line 1225: FND_MSG_PUB.initialize;

1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1222: END IF;
1223: -- Initialize message list if p_init_msg_list is set to TRUE.
1224: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1225: FND_MSG_PUB.initialize;
1226: END IF;
1227: -- Initialize API return status to success
1228: x_return_status := G_RET_STS_SUCCESS;
1229:

Line 1347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1343: NULL;
1344: END IF;
1345:
1346: -- Standard call to get message count and if count is 1, get message info.
1347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1348: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1349: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6600: Leaving Get_System_Variables');
1350: END IF;
1351: EXCEPTION

Line 1358: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1354: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1355: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6700: Leaving Get_System_Variables : OKC_API.G_EXCEPTION_ERROR Exception');
1356: END IF;
1357: x_return_status := G_RET_STS_ERROR ;
1358: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1359:
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO g_Get_System_Variables;
1362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1366: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6800: Leaving Get_System_Variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1364: END IF;
1365: x_return_status := G_RET_STS_UNEXP_ERROR ;
1366: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1367:
1368: WHEN OTHERS THEN
1369: ROLLBACK TO g_Get_System_Variables;
1370: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1375: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1371: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6900: Leaving Get_System_Variables because of EXCEPTION: '||sqlerrm);
1372: END IF;
1373:
1374: x_return_status := G_RET_STS_UNEXP_ERROR ;
1375: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1377: END IF;
1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1379: END Get_System_Variables ;

Line 1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1372: END IF;
1373:
1374: x_return_status := G_RET_STS_UNEXP_ERROR ;
1375: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1377: END IF;
1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1379: END Get_System_Variables ;
1380:

Line 1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1374: x_return_status := G_RET_STS_UNEXP_ERROR ;
1375: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1377: END IF;
1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1379: END Get_System_Variables ;
1380:
1381: /*
1382: -- PROCEDURE Substitute_Var_Value_Globally

Line 1430: FND_MSG_PUB.initialize;

1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: END IF;
1428: -- Initialize message list if p_init_msg_list is set to TRUE.
1429: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1430: FND_MSG_PUB.initialize;
1431: END IF;
1432: -- Initialize API return status to success
1433: x_return_status := G_RET_STS_SUCCESS;
1434:

Line 1513: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1509: END LOOP;
1510: END IF;
1511:
1512: -- Standard call to get message count and if count is 1, get message info.
1513: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1514: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Substitute_Var_Value_Globally');
1516: END IF;
1517: EXCEPTION

Line 1524: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1520: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Substitute_Var_Value_Globally : OKC_API.G_EXCEPTION_ERROR Exception');
1522: END IF;
1523: x_return_status := G_RET_STS_ERROR ;
1524: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1525:
1526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1527: ROLLBACK TO g_Subst_Var_Value_Globally;
1528: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1532: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1528: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7300: Leaving Substitute_Var_Value_Globally : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1530: END IF;
1531: x_return_status := G_RET_STS_UNEXP_ERROR ;
1532: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1533:
1534: WHEN OTHERS THEN
1535: ROLLBACK TO g_Subst_Var_Value_Globally;
1536: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1541: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1537: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7400: Leaving Substitute_Var_Value_Globally because of EXCEPTION: '||sqlerrm);
1538: END IF;
1539:
1540: x_return_status := G_RET_STS_UNEXP_ERROR ;
1541: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1542: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1543: END IF;
1544: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1545: END Substitute_Var_Value_Globally ;

Line 1542: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1538: END IF;
1539:
1540: x_return_status := G_RET_STS_UNEXP_ERROR ;
1541: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1542: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1543: END IF;
1544: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1545: END Substitute_Var_Value_Globally ;
1546: /*

Line 1544: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1540: x_return_status := G_RET_STS_UNEXP_ERROR ;
1541: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1542: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1543: END IF;
1544: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1545: END Substitute_Var_Value_Globally ;
1546: /*
1547: -- PROCEDURE Create_Unassigned_Section
1548: -- creating un-assigned sections in a document

Line 1588: FND_MSG_PUB.initialize;

1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;
1586: -- Initialize message list if p_init_msg_list is set to TRUE.
1587: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1588: FND_MSG_PUB.initialize;
1589: END IF;
1590: -- Initialize API return status to success
1591: x_return_status := G_RET_STS_SUCCESS;
1592:

Line 1644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1640: IF FND_API.To_Boolean( p_commit ) THEN
1641: COMMIT WORK;
1642: END IF;
1643: -- Standard call to get message count and if count is 1, get message info.
1644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1645: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
1647: END IF;
1648: EXCEPTION

Line 1660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1656: CLOSE l_get_max_seq_csr;
1657: END IF;
1658:
1659: x_return_status := G_RET_STS_ERROR ;
1660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1661:
1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1663: ROLLBACK TO g_Create_Unassigned_Section;
1664: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1669: CLOSE l_get_max_seq_csr;
1670: END IF;
1671:
1672: x_return_status := G_RET_STS_UNEXP_ERROR ;
1673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1674:
1675: WHEN OTHERS THEN
1676: ROLLBACK TO g_Create_Unassigned_Section;
1677: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1686: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1682: CLOSE l_get_max_seq_csr;
1683: END IF;
1684:
1685: x_return_status := G_RET_STS_UNEXP_ERROR ;
1686: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1688: END IF;
1689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1690: END Create_Unassigned_Section ;

Line 1687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1683: END IF;
1684:
1685: x_return_status := G_RET_STS_UNEXP_ERROR ;
1686: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1688: END IF;
1689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1690: END Create_Unassigned_Section ;
1691: /*

Line 1689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1685: x_return_status := G_RET_STS_UNEXP_ERROR ;
1686: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1688: END IF;
1689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1690: END Create_Unassigned_Section ;
1691: /*
1692: -- To Check if document type is valid
1693: */

Line 3139: FND_MSG_PUB.initialize;

3135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3136: END IF;
3137: -- Initialize message list if p_init_msg_list is set to TRUE.
3138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3139: FND_MSG_PUB.initialize;
3140: END IF;
3141: -- Initialize API return status to success
3142: x_return_status := G_RET_STS_SUCCESS;
3143:

Line 3240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3236: IF FND_API.To_Boolean( p_commit ) THEN
3237: COMMIT WORK;
3238: END IF;
3239: -- Standard call to get message count and if count is 1, get message info.
3240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3241: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3242: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving get_template_details');
3243: END IF;
3244: EXCEPTION

Line 3261: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3257: END IF;
3258:
3259:
3260: x_return_status := G_RET_STS_ERROR ;
3261: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3262:
3263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3264: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3265: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving get_template_details : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 3276: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3272: CLOSE l_get_dflt_tmpl_dtls_csr;
3273: END IF;
3274:
3275: x_return_status := G_RET_STS_UNEXP_ERROR ;
3276: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3277:
3278: WHEN OTHERS THEN
3279: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3280: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving get_template_details because of EXCEPTION: '||sqlerrm);

Line 3291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3287: CLOSE l_get_dflt_tmpl_dtls_csr;
3288: END IF;
3289:
3290: x_return_status := G_RET_STS_UNEXP_ERROR ;
3291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3293: END IF;
3294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3295: END get_template_details ;

Line 3292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

3288: END IF;
3289:
3290: x_return_status := G_RET_STS_UNEXP_ERROR ;
3291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3293: END IF;
3294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3295: END get_template_details ;
3296:

Line 3294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3290: x_return_status := G_RET_STS_UNEXP_ERROR ;
3291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3293: END IF;
3294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3295: END get_template_details ;
3296:
3297:
3298: --Checks if the given section is deleted

Line 3513: IF FND_MSG_PUB.Count_Msg > 0 Then

3509: l_return_status := fnd_api.g_ret_sts_error;
3510: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Resource busy exception');
3512: END IF;
3513: IF FND_MSG_PUB.Count_Msg > 0 Then
3514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3515: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3516: END LOOP;
3517:

Line 3514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

3510: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Resource busy exception');
3512: END IF;
3513: IF FND_MSG_PUB.Count_Msg > 0 Then
3514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3515: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3516: END LOOP;
3517:
3518: END IF;

Line 3515: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

3511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Resource busy exception');
3512: END IF;
3513: IF FND_MSG_PUB.Count_Msg > 0 Then
3514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3515: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3516: END LOOP;
3517:
3518: END IF;
3519: FND_MSG_PUB.initialize;

Line 3519: FND_MSG_PUB.initialize;

3515: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3516: END LOOP;
3517:
3518: END IF;
3519: FND_MSG_PUB.initialize;
3520: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
3521: WHEN OTHERS THEN
3522: retcode := 2;
3523: errbuf := substr(sqlerrm,1,200);

Line 3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3523: errbuf := substr(sqlerrm,1,200);
3524: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3525: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Other exception');
3526: END IF;
3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3529: END IF;
3530: IF FND_MSG_PUB.Count_Msg > 0 Then
3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

3524: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3525: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Other exception');
3526: END IF;
3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3529: END IF;
3530: IF FND_MSG_PUB.Count_Msg > 0 Then
3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 3530: IF FND_MSG_PUB.Count_Msg > 0 Then

3526: END IF;
3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3529: END IF;
3530: IF FND_MSG_PUB.Count_Msg > 0 Then
3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3533: END LOOP;
3534: END IF;

Line 3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3529: END IF;
3530: IF FND_MSG_PUB.Count_Msg > 0 Then
3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3533: END LOOP;
3534: END IF;
3535: FND_MSG_PUB.initialize;

Line 3532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

3528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3529: END IF;
3530: IF FND_MSG_PUB.Count_Msg > 0 Then
3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3533: END LOOP;
3534: END IF;
3535: FND_MSG_PUB.initialize;
3536:

Line 3535: FND_MSG_PUB.initialize;

3531: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3533: END LOOP;
3534: END IF;
3535: FND_MSG_PUB.initialize;
3536:
3537: END PURGE_QA_RESULTS;
3538:
3539: ------------------------------------------------------

Line 4266: FND_MSG_PUB.initialize;

4262: END IF;
4263:
4264: -- Initialize message list if p_init_msg_list is set to TRUE.
4265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4266: FND_MSG_PUB.initialize;
4267: END IF;
4268:
4269: -- Initialize API return status to success
4270: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4295: FND_MSG_PUB.Count_And_Get(

4291:
4292: ROLLBACK TO update_contract_admin;
4293:
4294: x_return_status := FND_API.G_RET_STS_ERROR;
4295: FND_MSG_PUB.Count_And_Get(
4296: p_count => x_msg_count,
4297: p_data => x_msg_data);
4298:
4299:

Line 4511: FND_MSG_PUB.Count_And_Get(

4507: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin because of EXCEPTION: ' || sqlerrm);
4508: END IF;
4509:
4510: x_return_status := FND_API.G_RET_STS_ERROR;
4511: FND_MSG_PUB.Count_And_Get(
4512: p_count => x_msg_count,
4513: p_data => x_msg_data);
4514:
4515: --close cursors

Line 4672: FND_MSG_PUB.initialize;

4668: END IF;
4669:
4670: -- Initialize message list if p_init_msg_list is set to TRUE.
4671: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4672: FND_MSG_PUB.initialize;
4673: END IF;
4674:
4675: x_return_status := G_RET_STS_SUCCESS;
4676: x_def_contract_admin_id := NULL;

Line 4687: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4683: end if;
4684:
4685:
4686: -- Standard call to get message count and if count is 1, get message info.
4687: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4688:
4689: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4690: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: get_default_contract_admin');
4691: END IF;

Line 4699: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4695:
4696: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4697: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving get_default_contract_admin because of EXCEPTION:'||sqlerrm);
4698: END IF;
4699: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4700: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4701: END IF;
4702: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4703: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 4700: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4696: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4697: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving get_default_contract_admin because of EXCEPTION:'||sqlerrm);
4698: END IF;
4699: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4700: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4701: END IF;
4702: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4703: x_return_status := G_RET_STS_UNEXP_ERROR ;
4704: END get_default_contract_admin;

Line 4702: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4698: END IF;
4699: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4700: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4701: END IF;
4702: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4703: x_return_status := G_RET_STS_UNEXP_ERROR ;
4704: END get_default_contract_admin;
4705:
4706: -- This is a temporary api that has been created to be

Line 4851: FND_MSG_PUB.initialize;

4847: END IF;
4848:
4849: -- Initialize message list if p_init_msg_list is set to TRUE.
4850: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4851: FND_MSG_PUB.initialize;
4852: END IF;
4853:
4854: x_return_status := G_RET_STS_SUCCESS;
4855: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

Line 4870: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4866: p_locked_by_user_id => FND_GLOBAL.user_id);
4867:
4868:
4869: -- Standard call to get message count and if count is 1, get message info.
4870: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4871:
4872: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4873: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');
4874: END IF;

Line 4882: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4878:
4879: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4880: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4881: END IF;
4882: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4883: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4884: END IF;
4885: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4886: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 4883: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4879: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4880: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4881: END IF;
4882: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4883: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4884: END IF;
4885: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4886: x_return_status := G_RET_STS_UNEXP_ERROR ;
4887: END lock_contract;

Line 4885: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4881: END IF;
4882: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4883: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4884: END IF;
4885: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4886: x_return_status := G_RET_STS_UNEXP_ERROR ;
4887: END lock_contract;
4888:
4889: --For R12: MSWord2WaySync

Line 4916: FND_MSG_PUB.initialize;

4912: END IF;
4913:
4914: -- Initialize message list if p_init_msg_list is set to TRUE.
4915: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4916: FND_MSG_PUB.initialize;
4917: END IF;
4918:
4919: x_return_status := G_RET_STS_SUCCESS;
4920: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

Line 4934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4930: p_lock_terms_flag => 'N');
4931:
4932:
4933: -- Standard call to get message count and if count is 1, get message info.
4934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4935:
4936: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4937: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');
4938: END IF;

Line 4946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4942:
4943: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4944: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4945: END IF;
4946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4948: END IF;
4949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4950: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 4947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

4943: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4944: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4945: END IF;
4946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4948: END IF;
4949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4950: x_return_status := G_RET_STS_UNEXP_ERROR ;
4951: END unlock_contract;

Line 4949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4945: END IF;
4946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4948: END IF;
4949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4950: x_return_status := G_RET_STS_UNEXP_ERROR ;
4951: END unlock_contract;
4952:
4953: FUNCTION get_sys_last_upd_date (

Line 5180: FND_MSG_PUB.initialize;

5176: END IF;
5177:
5178: /* Initialize message list if p_init_msg_list is set to TRUE */
5179: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5180: FND_MSG_PUB.initialize;
5181: END IF;
5182:
5183: /* Initialize API return status to success */
5184: x_return_status := G_RET_STS_SUCCESS;

Line 5235: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN

5231: l_previous_var_code := csr_udv_with_procs_rec.variable_code;
5232:
5233: END LOOP;
5234:
5235: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN
5236:
5237: x_return_status := G_RET_STS_ERROR;
5238: RAISE FND_API.G_EXC_ERROR;
5239: END IF;

Line 5257: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5253: CLOSE csr_get_udv_with_procs;
5254: END IF;
5255:
5256: x_return_status := G_RET_STS_ERROR ;
5257: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5258:
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260:
5261: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5266: CLOSE csr_get_udv_with_procs;
5267: END IF;
5268:
5269: x_return_status := G_RET_STS_UNEXP_ERROR ;
5270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5271:
5272: WHEN OTHERS THEN
5273:
5274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5283: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

5279: CLOSE csr_get_udv_with_procs;
5280: END IF;
5281:
5282: x_return_status := G_RET_STS_UNEXP_ERROR ;
5283: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5284: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5285: END IF;
5286: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5287:

Line 5284: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5280: END IF;
5281:
5282: x_return_status := G_RET_STS_UNEXP_ERROR ;
5283: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5284: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5285: END IF;
5286: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5287:
5288: END set_udv_with_procedures ;

Line 5286: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5282: x_return_status := G_RET_STS_UNEXP_ERROR ;
5283: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5284: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5285: END IF;
5286: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5287:
5288: END set_udv_with_procedures ;
5289:
5290: -- Start of comments

Line 5454: FND_MSG_PUB.ADD;

5450: IF p_output_error = FND_API.G_TRUE THEN
5451: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_EXEC');
5452: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5453: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5454: FND_MSG_PUB.ADD;
5455: END IF;
5456: ELSIF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
5457:
5458: l_variable_value_id := NULL;

Line 5464: FND_MSG_PUB.ADD;

5460: IF p_output_error = FND_API.G_TRUE THEN
5461: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_UNEXP');
5462: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5463: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5464: FND_MSG_PUB.ADD;
5465: END IF;
5466: END IF;
5467:
5468: EXCEPTION

Line 5497: FND_MSG_PUB.ADD;

5493: IF l_dummy <> 'X' THEN
5494: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_NOT_EXIST');
5495: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5496: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5497: FND_MSG_PUB.ADD;
5498: ELSIF l_procedure_spec_status = 'INVALID' OR l_procedure_body_status = 'INVALID' THEN
5499: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_INVALID');
5500: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5501: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);

Line 5502: FND_MSG_PUB.ADD;

5498: ELSIF l_procedure_spec_status = 'INVALID' OR l_procedure_body_status = 'INVALID' THEN
5499: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_INVALID');
5500: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5501: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5502: FND_MSG_PUB.ADD;
5503: END IF;
5504: END IF;
5505:
5506: END;

Line 5572: FND_MSG_PUB.ADD;

5568:
5569: IF p_output_error = FND_API.G_TRUE THEN
5570: FND_MESSAGE.set_name('OKC','OKC_UDV_VSET_INVALID');
5571: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5572: FND_MSG_PUB.ADD;
5573: END IF;
5574: END;
5575:
5576: END IF; /* IF l_variable_value_id IS NOT NULL*/

Line 5597: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5593: CLOSE csr_get_udv_with_proc_dtls;
5594: END IF;
5595:
5596: x_return_status := G_RET_STS_ERROR ;
5597: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5598:
5599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5600:
5601: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5610: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5606: CLOSE csr_get_udv_with_proc_dtls;
5607: END IF;
5608:
5609: x_return_status := G_RET_STS_UNEXP_ERROR ;
5610: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5611:
5612: WHEN OTHERS THEN
5613:
5614: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5623: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

5619: CLOSE csr_get_udv_with_proc_dtls;
5620: END IF;
5621:
5622: x_return_status := G_RET_STS_UNEXP_ERROR ;
5623: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5625: END IF;
5626: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5627:

Line 5624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

5620: END IF;
5621:
5622: x_return_status := G_RET_STS_UNEXP_ERROR ;
5623: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5625: END IF;
5626: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5627:
5628: END get_udv_with_proc_value;

Line 5626: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

5622: x_return_status := G_RET_STS_UNEXP_ERROR ;
5623: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5625: END IF;
5626: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5627:
5628: END get_udv_with_proc_value;
5629:
5630: