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 590: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

586: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving Delete_Doc because of EXCEPTION: '||sqlerrm);
588: END IF;
589:
590: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
592: END IF;
593: x_return_status := G_RET_STS_UNEXP_ERROR ;
594: END Delete_Doc ;

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

587: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving Delete_Doc because of EXCEPTION: '||sqlerrm);
588: END IF;
589:
590: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
592: END IF;
593: x_return_status := G_RET_STS_UNEXP_ERROR ;
594: END Delete_Doc ;
595: /*

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

711: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving delete_doc_version because of EXCEPTION: '||sqlerrm);
713: END IF;
714:
715: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
717: END IF;
718: x_return_status := G_RET_STS_UNEXP_ERROR ;
719: END Delete_Doc_version ;

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

712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4300: Leaving delete_doc_version because of EXCEPTION: '||sqlerrm);
713: END IF;
714:
715: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
717: END IF;
718: x_return_status := G_RET_STS_UNEXP_ERROR ;
719: END Delete_Doc_version ;
720:

Line 759: FND_MSG_PUB.initialize;

755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: -- Initialize message list if p_init_msg_list is set to TRUE.
758: IF FND_API.to_Boolean( p_init_msg_list ) THEN
759: FND_MSG_PUB.initialize;
760: END IF;
761: -- Initialize API return status to success
762: x_return_status := G_RET_STS_SUCCESS;
763:

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

788: --------------------------------------------
789: END LOOP;
790:
791: -- Standard call to get message count and if count is 1, get message info.
792: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
793: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Mark_Amendment');
795: END IF;
796: EXCEPTION

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

799: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Mark_Amendment : OKC_API.G_EXCEPTION_ERROR Exception');
801: END IF;
802: x_return_status := G_RET_STS_ERROR ;
803: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
804:
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ROLLBACK TO g_Mark_Amendment;
807: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

807: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
808: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4800: Leaving Mark_Amendment : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
809: END IF;
810: x_return_status := G_RET_STS_UNEXP_ERROR ;
811: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
812:
813: WHEN OTHERS THEN
814: ROLLBACK TO g_Mark_Amendment;
815: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

816: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4900: Leaving Mark_Amendment because of EXCEPTION: '||sqlerrm);
817: END IF;
818:
819: x_return_status := G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
822: END IF;
823: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
824: END Mark_Amendment;

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

817: END IF;
818:
819: x_return_status := G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
822: END IF;
823: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
824: END Mark_Amendment;
825:

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

819: x_return_status := G_RET_STS_UNEXP_ERROR ;
820: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
822: END IF;
823: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
824: END Mark_Amendment;
825:
826: /*
827: -- PROCEDURE Merge_Template_Working_Copy

Line 886: FND_MSG_PUB.initialize;

882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884: -- Initialize message list if p_init_msg_list is set to TRUE.
885: IF FND_API.to_Boolean( p_init_msg_list ) THEN
886: FND_MSG_PUB.initialize;
887: END IF;
888: -- Initialize API return status to success
889: x_return_status := G_RET_STS_SUCCESS;
890:

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

1176:
1177: -- ================ Actual Procedure Code end =======================
1178:
1179: -- Standard call to get message count and if count is 1, get message info.
1180: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1181: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6100: Leaving Merge_Template_Working_Copy');
1183: END IF;
1184:

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

1188: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1189: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Merge_Template_Working_Copy : OKC_API.G_EXCEPTION_ERROR Exception');
1190: END IF;
1191: x_return_status := G_RET_STS_ERROR ;
1192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO g_Merge_Template_Working_Copy;
1196: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1196: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1197: 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');
1198: END IF;
1199: x_return_status := G_RET_STS_UNEXP_ERROR ;
1200: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1201:
1202: WHEN OTHERS THEN
1203: ROLLBACK TO g_Merge_Template_Working_Copy;
1204: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6400: Leaving Merge_Template_Working_Copy because of EXCEPTION: '||sqlerrm);
1206: END IF;
1207:
1208: x_return_status := G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1211: END IF;
1212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1213: END Merge_Template_Working_Copy ;

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

1206: END IF;
1207:
1208: x_return_status := G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1211: END IF;
1212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1213: END Merge_Template_Working_Copy ;
1214:

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

1208: x_return_status := G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1211: END IF;
1212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1213: END Merge_Template_Working_Copy ;
1214:
1215: /*
1216: -- PROCEDURE Get_System_Variables

Line 1266: FND_MSG_PUB.initialize;

1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264: -- Initialize message list if p_init_msg_list is set to TRUE.
1265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1266: FND_MSG_PUB.initialize;
1267: END IF;
1268: -- Initialize API return status to success
1269: x_return_status := G_RET_STS_SUCCESS;
1270:

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

1385: NULL;
1386: END IF;
1387:
1388: -- Standard call to get message count and if count is 1, get message info.
1389: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1390: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6600: Leaving Get_System_Variables');
1392: END IF;
1393: EXCEPTION

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

1396: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6700: Leaving Get_System_Variables : OKC_API.G_EXCEPTION_ERROR Exception');
1398: END IF;
1399: x_return_status := G_RET_STS_ERROR ;
1400: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1401:
1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1403: ROLLBACK TO g_Get_System_Variables;
1404: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1404: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1405: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6800: Leaving Get_System_Variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1406: END IF;
1407: x_return_status := G_RET_STS_UNEXP_ERROR ;
1408: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1409:
1410: WHEN OTHERS THEN
1411: ROLLBACK TO g_Get_System_Variables;
1412: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1413: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6900: Leaving Get_System_Variables because of EXCEPTION: '||sqlerrm);
1414: END IF;
1415:
1416: x_return_status := G_RET_STS_UNEXP_ERROR ;
1417: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1419: END IF;
1420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1421: END Get_System_Variables ;

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

1414: END IF;
1415:
1416: x_return_status := G_RET_STS_UNEXP_ERROR ;
1417: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1419: END IF;
1420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1421: END Get_System_Variables ;
1422:

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

1416: x_return_status := G_RET_STS_UNEXP_ERROR ;
1417: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1419: END IF;
1420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1421: END Get_System_Variables ;
1422:
1423: /*
1424: -- PROCEDURE Substitute_Var_Value_Globally

Line 1472: FND_MSG_PUB.initialize;

1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1471: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1472: FND_MSG_PUB.initialize;
1473: END IF;
1474: -- Initialize API return status to success
1475: x_return_status := G_RET_STS_SUCCESS;
1476:

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

1551: END LOOP;
1552: END IF;
1553:
1554: -- Standard call to get message count and if count is 1, get message info.
1555: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Substitute_Var_Value_Globally');
1558: END IF;
1559: EXCEPTION

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

1562: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7200: Leaving Substitute_Var_Value_Globally : OKC_API.G_EXCEPTION_ERROR Exception');
1564: END IF;
1565: x_return_status := G_RET_STS_ERROR ;
1566: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1567:
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO g_Subst_Var_Value_Globally;
1570: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1570: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: 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');
1572: END IF;
1573: x_return_status := G_RET_STS_UNEXP_ERROR ;
1574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1575:
1576: WHEN OTHERS THEN
1577: ROLLBACK TO g_Subst_Var_Value_Globally;
1578: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1579: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7400: Leaving Substitute_Var_Value_Globally because of EXCEPTION: '||sqlerrm);
1580: END IF;
1581:
1582: x_return_status := G_RET_STS_UNEXP_ERROR ;
1583: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1585: END IF;
1586: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1587: END Substitute_Var_Value_Globally ;

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

1580: END IF;
1581:
1582: x_return_status := G_RET_STS_UNEXP_ERROR ;
1583: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1585: END IF;
1586: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1587: END Substitute_Var_Value_Globally ;
1588: /*

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

1582: x_return_status := G_RET_STS_UNEXP_ERROR ;
1583: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1585: END IF;
1586: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1587: END Substitute_Var_Value_Globally ;
1588: /*
1589: -- PROCEDURE Create_Unassigned_Section
1590: -- creating un-assigned sections in a document

Line 1630: FND_MSG_PUB.initialize;

1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: END IF;
1628: -- Initialize message list if p_init_msg_list is set to TRUE.
1629: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1630: FND_MSG_PUB.initialize;
1631: END IF;
1632: -- Initialize API return status to success
1633: x_return_status := G_RET_STS_SUCCESS;
1634:

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

1682: IF FND_API.To_Boolean( p_commit ) THEN
1683: COMMIT WORK;
1684: END IF;
1685: -- Standard call to get message count and if count is 1, get message info.
1686: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1687: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1688: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
1689: END IF;
1690: EXCEPTION

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

1698: CLOSE l_get_max_seq_csr;
1699: END IF;
1700:
1701: x_return_status := G_RET_STS_ERROR ;
1702: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: ROLLBACK TO g_Create_Unassigned_Section;
1706: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1711: CLOSE l_get_max_seq_csr;
1712: END IF;
1713:
1714: x_return_status := G_RET_STS_UNEXP_ERROR ;
1715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1716:
1717: WHEN OTHERS THEN
1718: ROLLBACK TO g_Create_Unassigned_Section;
1719: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1724: CLOSE l_get_max_seq_csr;
1725: END IF;
1726:
1727: x_return_status := G_RET_STS_UNEXP_ERROR ;
1728: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1730: END IF;
1731: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1732: END Create_Unassigned_Section ;

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

1725: END IF;
1726:
1727: x_return_status := G_RET_STS_UNEXP_ERROR ;
1728: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1730: END IF;
1731: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1732: END Create_Unassigned_Section ;
1733: /*

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

1727: x_return_status := G_RET_STS_UNEXP_ERROR ;
1728: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1730: END IF;
1731: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1732: END Create_Unassigned_Section ;
1733: /*
1734: -- To Check if document type is valid
1735: */

Line 3181: FND_MSG_PUB.initialize;

3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END IF;
3179: -- Initialize message list if p_init_msg_list is set to TRUE.
3180: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3181: FND_MSG_PUB.initialize;
3182: END IF;
3183: -- Initialize API return status to success
3184: x_return_status := G_RET_STS_SUCCESS;
3185:

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

3278: IF FND_API.To_Boolean( p_commit ) THEN
3279: COMMIT WORK;
3280: END IF;
3281: -- Standard call to get message count and if count is 1, get message info.
3282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3283: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3284: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving get_template_details');
3285: END IF;
3286: EXCEPTION

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

3299: END IF;
3300:
3301:
3302: x_return_status := G_RET_STS_ERROR ;
3303: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3304:
3305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3306: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3307: 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 3318: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3314: CLOSE l_get_dflt_tmpl_dtls_csr;
3315: END IF;
3316:
3317: x_return_status := G_RET_STS_UNEXP_ERROR ;
3318: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3319:
3320: WHEN OTHERS THEN
3321: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3322: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving get_template_details because of EXCEPTION: '||sqlerrm);

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

3329: CLOSE l_get_dflt_tmpl_dtls_csr;
3330: END IF;
3331:
3332: x_return_status := G_RET_STS_UNEXP_ERROR ;
3333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3334: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3335: END IF;
3336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3337: END get_template_details ;

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

3330: END IF;
3331:
3332: x_return_status := G_RET_STS_UNEXP_ERROR ;
3333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3334: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3335: END IF;
3336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3337: END get_template_details ;
3338:

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

3332: x_return_status := G_RET_STS_UNEXP_ERROR ;
3333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3334: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3335: END IF;
3336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3337: END get_template_details ;
3338:
3339:
3340: --Checks if the given section is deleted

Line 3555: IF FND_MSG_PUB.Count_Msg > 0 Then

3551: l_return_status := fnd_api.g_ret_sts_error;
3552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Resource busy exception');
3554: END IF;
3555: IF FND_MSG_PUB.Count_Msg > 0 Then
3556: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3558: END LOOP;
3559:

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

3552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Resource busy exception');
3554: END IF;
3555: IF FND_MSG_PUB.Count_Msg > 0 Then
3556: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3558: END LOOP;
3559:
3560: END IF;

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

3553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Resource busy exception');
3554: END IF;
3555: IF FND_MSG_PUB.Count_Msg > 0 Then
3556: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3558: END LOOP;
3559:
3560: END IF;
3561: FND_MSG_PUB.initialize;

Line 3561: FND_MSG_PUB.initialize;

3557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3558: END LOOP;
3559:
3560: END IF;
3561: FND_MSG_PUB.initialize;
3562: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
3563: WHEN OTHERS THEN
3564: retcode := 2;
3565: errbuf := substr(sqlerrm,1,200);

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

3565: errbuf := substr(sqlerrm,1,200);
3566: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3567: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Other exception');
3568: END IF;
3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3571: END IF;
3572: IF FND_MSG_PUB.Count_Msg > 0 Then
3573: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

3566: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3567: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'200: Other exception');
3568: END IF;
3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3571: END IF;
3572: IF FND_MSG_PUB.Count_Msg > 0 Then
3573: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3574: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 3572: IF FND_MSG_PUB.Count_Msg > 0 Then

3568: END IF;
3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3571: END IF;
3572: IF FND_MSG_PUB.Count_Msg > 0 Then
3573: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3574: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3575: END LOOP;
3576: END IF;

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

3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3571: END IF;
3572: IF FND_MSG_PUB.Count_Msg > 0 Then
3573: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3574: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3575: END LOOP;
3576: END IF;
3577: FND_MSG_PUB.initialize;

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

3570: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3571: END IF;
3572: IF FND_MSG_PUB.Count_Msg > 0 Then
3573: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3574: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3575: END LOOP;
3576: END IF;
3577: FND_MSG_PUB.initialize;
3578:

Line 3577: FND_MSG_PUB.initialize;

3573: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3574: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3575: END LOOP;
3576: END IF;
3577: FND_MSG_PUB.initialize;
3578:
3579: END PURGE_QA_RESULTS;
3580:
3581: ------------------------------------------------------

Line 4315: FND_MSG_PUB.initialize;

4311: END IF;
4312:
4313: -- Initialize message list if p_init_msg_list is set to TRUE.
4314: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4315: FND_MSG_PUB.initialize;
4316: END IF;
4317:
4318: -- Initialize API return status to success
4319: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4344: FND_MSG_PUB.Count_And_Get(

4340:
4341: ROLLBACK TO update_contract_admin;
4342:
4343: x_return_status := FND_API.G_RET_STS_ERROR;
4344: FND_MSG_PUB.Count_And_Get(
4345: p_count => x_msg_count,
4346: p_data => x_msg_data);
4347:
4348:

Line 4560: FND_MSG_PUB.Count_And_Get(

4556: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin because of EXCEPTION: ' || sqlerrm);
4557: END IF;
4558:
4559: x_return_status := FND_API.G_RET_STS_ERROR;
4560: FND_MSG_PUB.Count_And_Get(
4561: p_count => x_msg_count,
4562: p_data => x_msg_data);
4563:
4564: --close cursors

Line 4721: FND_MSG_PUB.initialize;

4717: END IF;
4718:
4719: -- Initialize message list if p_init_msg_list is set to TRUE.
4720: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4721: FND_MSG_PUB.initialize;
4722: END IF;
4723:
4724: x_return_status := G_RET_STS_SUCCESS;
4725: x_def_contract_admin_id := NULL;

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

4732: end if;
4733:
4734:
4735: -- Standard call to get message count and if count is 1, get message info.
4736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4737:
4738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4739: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: get_default_contract_admin');
4740: END IF;

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

4744:
4745: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4746: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving get_default_contract_admin because of EXCEPTION:'||sqlerrm);
4747: END IF;
4748: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4749: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4750: END IF;
4751: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4752: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4745: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4746: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving get_default_contract_admin because of EXCEPTION:'||sqlerrm);
4747: END IF;
4748: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4749: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4750: END IF;
4751: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4752: x_return_status := G_RET_STS_UNEXP_ERROR ;
4753: END get_default_contract_admin;

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

4747: END IF;
4748: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4749: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4750: END IF;
4751: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4752: x_return_status := G_RET_STS_UNEXP_ERROR ;
4753: END get_default_contract_admin;
4754:
4755: -- This is a temporary api that has been created to be

Line 4900: FND_MSG_PUB.initialize;

4896: END IF;
4897:
4898: -- Initialize message list if p_init_msg_list is set to TRUE.
4899: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4900: FND_MSG_PUB.initialize;
4901: END IF;
4902:
4903: x_return_status := G_RET_STS_SUCCESS;
4904: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

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

4915: p_locked_by_user_id => FND_GLOBAL.user_id);
4916:
4917:
4918: -- Standard call to get message count and if count is 1, get message info.
4919: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4920:
4921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');
4923: END IF;

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

4927:
4928: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4929: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4930: END IF;
4931: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4933: END IF;
4934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4935: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4928: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4929: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4930: END IF;
4931: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4933: END IF;
4934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4935: x_return_status := G_RET_STS_UNEXP_ERROR ;
4936: END lock_contract;

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

4930: END IF;
4931: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4933: END IF;
4934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4935: x_return_status := G_RET_STS_UNEXP_ERROR ;
4936: END lock_contract;
4937:
4938: --For R12: MSWord2WaySync

Line 4965: FND_MSG_PUB.initialize;

4961: END IF;
4962:
4963: -- Initialize message list if p_init_msg_list is set to TRUE.
4964: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4965: FND_MSG_PUB.initialize;
4966: END IF;
4967:
4968: x_return_status := G_RET_STS_SUCCESS;
4969: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

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

4979: p_lock_terms_flag => 'N');
4980:
4981:
4982: -- Standard call to get message count and if count is 1, get message info.
4983: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4984:
4985: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4986: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');
4987: END IF;

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

4991:
4992: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4993: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4994: END IF;
4995: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4996: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4997: END IF;
4998: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4999: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4992: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4993: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8200: Leaving lock_contract because of EXCEPTION:'||sqlerrm);
4994: END IF;
4995: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4996: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4997: END IF;
4998: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4999: x_return_status := G_RET_STS_UNEXP_ERROR ;
5000: END unlock_contract;

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

4994: END IF;
4995: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4996: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4997: END IF;
4998: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4999: x_return_status := G_RET_STS_UNEXP_ERROR ;
5000: END unlock_contract;
5001:
5002: FUNCTION get_sys_last_upd_date (

Line 5229: FND_MSG_PUB.initialize;

5225: END IF;
5226:
5227: /* Initialize message list if p_init_msg_list is set to TRUE */
5228: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5229: FND_MSG_PUB.initialize;
5230: END IF;
5231:
5232: /* Initialize API return status to success */
5233: x_return_status := G_RET_STS_SUCCESS;

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

5280: l_previous_var_code := csr_udv_with_procs_rec.variable_code;
5281:
5282: END LOOP;
5283:
5284: IF p_output_error = FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg > 0 THEN
5285:
5286: x_return_status := G_RET_STS_ERROR;
5287: RAISE FND_API.G_EXC_ERROR;
5288: END IF;

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

5302: CLOSE csr_get_udv_with_procs;
5303: END IF;
5304:
5305: x_return_status := G_RET_STS_ERROR ;
5306: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5307:
5308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5309:
5310: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5315: CLOSE csr_get_udv_with_procs;
5316: END IF;
5317:
5318: x_return_status := G_RET_STS_UNEXP_ERROR ;
5319: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5320:
5321: WHEN OTHERS THEN
5322:
5323: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5328: CLOSE csr_get_udv_with_procs;
5329: END IF;
5330:
5331: x_return_status := G_RET_STS_UNEXP_ERROR ;
5332: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5333: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5334: END IF;
5335: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5336:

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

5329: END IF;
5330:
5331: x_return_status := G_RET_STS_UNEXP_ERROR ;
5332: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5333: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5334: END IF;
5335: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5336:
5337: END set_udv_with_procedures ;

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

5331: x_return_status := G_RET_STS_UNEXP_ERROR ;
5332: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5333: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5334: END IF;
5335: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5336:
5337: END set_udv_with_procedures ;
5338:
5339: -- Start of comments

Line 5503: FND_MSG_PUB.ADD;

5499: IF p_output_error = FND_API.G_TRUE THEN
5500: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_EXEC');
5501: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5502: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5503: FND_MSG_PUB.ADD;
5504: END IF;
5505: ELSIF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
5506:
5507: l_variable_value_id := NULL;

Line 5513: FND_MSG_PUB.ADD;

5509: IF p_output_error = FND_API.G_TRUE THEN
5510: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_UNEXP');
5511: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5512: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5513: FND_MSG_PUB.ADD;
5514: END IF;
5515: END IF;
5516:
5517: EXCEPTION

Line 5546: FND_MSG_PUB.ADD;

5542: IF l_dummy <> 'X' THEN
5543: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_NOT_EXIST');
5544: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5545: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5546: FND_MSG_PUB.ADD;
5547: ELSIF l_procedure_spec_status = 'INVALID' OR l_procedure_body_status = 'INVALID' THEN
5548: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_INVALID');
5549: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5550: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);

Line 5551: FND_MSG_PUB.ADD;

5547: ELSIF l_procedure_spec_status = 'INVALID' OR l_procedure_body_status = 'INVALID' THEN
5548: FND_MESSAGE.set_name('OKC','OKC_UDV_PROC_INVALID');
5549: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5550: FND_MESSAGE.set_token('PROC_NAME', l_procedure_name);
5551: FND_MSG_PUB.ADD;
5552: END IF;
5553: END IF;
5554:
5555: END;

Line 5621: FND_MSG_PUB.ADD;

5617:
5618: IF p_output_error = FND_API.G_TRUE THEN
5619: FND_MESSAGE.set_name('OKC','OKC_UDV_VSET_INVALID');
5620: FND_MESSAGE.set_token('VAR_NAME', l_variable_name);
5621: FND_MSG_PUB.ADD;
5622: END IF;
5623: END;
5624:
5625: END IF; /* IF l_variable_value_id IS NOT NULL*/

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

5642: CLOSE csr_get_udv_with_proc_dtls;
5643: END IF;
5644:
5645: x_return_status := G_RET_STS_ERROR ;
5646: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5647:
5648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5649:
5650: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5655: CLOSE csr_get_udv_with_proc_dtls;
5656: END IF;
5657:
5658: x_return_status := G_RET_STS_UNEXP_ERROR ;
5659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5660:
5661: WHEN OTHERS THEN
5662:
5663: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5668: CLOSE csr_get_udv_with_proc_dtls;
5669: END IF;
5670:
5671: x_return_status := G_RET_STS_UNEXP_ERROR ;
5672: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5674: END IF;
5675: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5676:

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

5669: END IF;
5670:
5671: x_return_status := G_RET_STS_UNEXP_ERROR ;
5672: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5674: END IF;
5675: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5676:
5677: END get_udv_with_proc_value;

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

5671: x_return_status := G_RET_STS_UNEXP_ERROR ;
5672: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5674: END IF;
5675: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5676:
5677: END get_udv_with_proc_value;
5678:
5679: