[Home] [Help]
98: --write_msg(' test5::' || l_error);
99: RAISE FND_API.G_EXC_ERROR;
100: END;
101:
102: -- Standard check for p_commit
103: IF FND_API.to_Boolean( p_commit) THEN
104: COMMIT WORK;
105: END IF;
106:
107: EXCEPTION
108: WHEN FND_API.G_EXC_ERROR THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_Xml_Source_Lines_Util expected');END IF;
111: -- Standard call to get message count and if count=1, get the message
112: FND_MSG_PUB.Count_And_Get (
113: p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data
116: );
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_Xml_Source_Lines_Util unexpected');END IF;
120: -- Standard call to get message count and if count=1, get the message
121: FND_MSG_PUB.Count_And_Get (
122: p_encoded => FND_API.G_FALSE,
123: p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_Xml_Source_Lines_Util OTHERS');END IF;
129: -- Standard call to get message count and if count=1, get the message
130: FND_MSG_PUB.Count_And_Get (
131: p_encoded => FND_API.G_FALSE,
132: p_count => x_msg_count,
133: p_data => x_msg_data
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines expected');END IF;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines unexpected');END IF;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209: WHEN OTHERS THEN
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines OTHERS');END IF;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines expected');END IF;
307: -- Standard call to get message count and if count=1, get the message
308: FND_MSG_PUB.Count_And_Get (
309: p_encoded => FND_API.G_FALSE,
310: p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines unexpected');END IF;
316: -- Standard call to get message count and if count=1, get the message
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );
322: WHEN OTHERS THEN
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines OTHERS');END IF;
325: -- Standard call to get message count and if count=1, get the message
326: FND_MSG_PUB.Count_And_Get (
327: p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data
384: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
385:
386: BEGIN
387:
388: -- Standard Start of API savepoint
389: SAVEPOINT Update_Error_Xml_Element;
390:
391: -- Standard call to check for call compatibility.
392: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
387:
388: -- Standard Start of API savepoint
389: SAVEPOINT Update_Error_Xml_Element;
390:
391: -- Standard call to check for call compatibility.
392: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
393: p_api_version_number,
394: l_api_name,
395: G_PKG_NAME) THEN
555: END IF;
556: END IF;
557: --END IF; --IF l_ref_xml_element_rec.imp_xml_element_id IS NOT NULL
558:
559: -- Standard check for p_commit
560: IF FND_API.to_Boolean( p_commit) THEN
561: COMMIT WORK;
562: END IF;
563:
566:
567: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
568: END IF;
569:
570: -- Standard call to get message count and if count is 1, get message info.
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: EXCEPTION
582: IF (AMS_DEBUG_HIGH_ON) THEN
583:
584: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_ERROR');
585: END IF;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,
590: p_data => x_msg_data );
595: IF (AMS_DEBUG_HIGH_ON) THEN
596:
597: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_UNEXPECTED_ERROR');
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data
612: END IF;
613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);
653: FROM AMS_IMP_XML_ELEMENTS
654: WHERE IMP_XML_ELEMENT_ID = l_id;
655:
656: BEGIN
657: -- Standard Start of API savepoint
658: SAVEPOINT CREATE_Xml_Element_PVT;
659:
660: -- Standard call to check for call compatibility.
661: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
656: BEGIN
657: -- Standard Start of API savepoint
658: SAVEPOINT CREATE_Xml_Element_PVT;
659:
660: -- Standard call to check for call compatibility.
661: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
662: p_api_version_number,
663: l_api_name,
664: G_PKG_NAME)
768: --
769: -- End of API body
770: --
771:
772: -- Standard check for p_commit
773: IF FND_API.to_Boolean( p_commit )
774: THEN
775: COMMIT WORK;
776: END IF;
780:
781: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
782: END IF;
783:
784: -- Standard call to get message count and if count is 1, get message info.
785: FND_MSG_PUB.Count_And_Get
786: (p_count => x_msg_count,
787: p_data => x_msg_data
788: );
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO CREATE_Xml_Element_PVT;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: -- Standard call to get message count and if count=1, get the message
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
804:
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ROLLBACK TO CREATE_Xml_Element_PVT;
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: -- Standard call to get message count and if count=1, get the message
809: FND_MSG_PUB.Count_And_Get (
810: p_encoded => FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_msg_count,
826: p_data => x_msg_data
877: l_msg_count NUMBER;
878: l_msg_data VARCHAR2 (2000);
879:
880: BEGIN
881: -- Standard Start of API savepoint
882: SAVEPOINT UPDATE_Xml_Element_PVT;
883:
884: -- Standard call to check for call compatibility.
885: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
880: BEGIN
881: -- Standard Start of API savepoint
882: SAVEPOINT UPDATE_Xml_Element_PVT;
883:
884: -- Standard call to check for call compatibility.
885: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
886: p_api_version_number,
887: l_api_name,
888: G_PKG_NAME)
1060: --
1061: -- End of API body.
1062: --
1063:
1064: -- Standard check for p_commit
1065: IF FND_API.to_Boolean( p_commit )
1066: THEN
1067: COMMIT WORK;
1068: END IF;
1072:
1073: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1074: END IF;
1075:
1076: -- Standard call to get message count and if count is 1, get message info.
1077: FND_MSG_PUB.Count_And_Get
1078: (p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1090: IF (AMS_DEBUG_HIGH_ON) THEN
1091:
1092: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_ERROR');
1093: END IF;
1094: -- Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data
1104: IF (AMS_DEBUG_HIGH_ON) THEN
1105:
1106: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_UNEXPECTED_ERROR');
1107: END IF;
1108: -- Standard call to get message count and if count=1, get the message
1109: FND_MSG_PUB.Count_And_Get (
1110: p_encoded => FND_API.G_FALSE,
1111: p_count => x_msg_count,
1112: p_data => x_msg_data
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1125: END IF;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data
1149: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1150: l_object_version_number NUMBER;
1151:
1152: BEGIN
1153: -- Standard Start of API savepoint
1154: SAVEPOINT DELETE_Xml_Element_PVT;
1155:
1156: -- Standard call to check for call compatibility.
1157: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1152: BEGIN
1153: -- Standard Start of API savepoint
1154: SAVEPOINT DELETE_Xml_Element_PVT;
1155:
1156: -- Standard call to check for call compatibility.
1157: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1158: p_api_version_number,
1159: l_api_name,
1160: G_PKG_NAME)
1193: --
1194: -- End of API body
1195: --
1196:
1197: -- Standard check for p_commit
1198: IF FND_API.to_Boolean( p_commit )
1199: THEN
1200: COMMIT WORK;
1201: END IF;
1206:
1207: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1208: END IF;
1209:
1210: -- Standard call to get message count and if count is 1, get message info.
1211: FND_MSG_PUB.Count_And_Get
1212: (p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1220:
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: ROLLBACK TO DELETE_Xml_Element_PVT;
1223: x_return_status := FND_API.G_RET_STS_ERROR;
1224: -- Standard call to get message count and if count=1, get the message
1225: FND_MSG_PUB.Count_And_Get (
1226: p_encoded => FND_API.G_FALSE,
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: ROLLBACK TO DELETE_Xml_Element_PVT;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: -- Standard call to get message count and if count=1, get the message
1235: FND_MSG_PUB.Count_And_Get (
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data
1244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1245: THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data
1294: THEN
1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Standard call to check for call compatibility.
1299: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1300: p_api_version_number,
1301: l_api_name,
1302: G_PKG_NAME)
1350:
1351: WHEN FND_API.G_EXC_ERROR THEN
1352: ROLLBACK TO LOCK_Xml_Element_PVT;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: -- Standard call to get message count and if count=1, get the message
1355: FND_MSG_PUB.Count_And_Get (
1356: p_encoded => FND_API.G_FALSE,
1357: p_count => x_msg_count,
1358: p_data => x_msg_data
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO LOCK_Xml_Element_PVT;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: -- Standard call to get message count and if count=1, get the message
1365: FND_MSG_PUB.Count_And_Get (
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data
1374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data
1724: l_object_version_number NUMBER;
1725: l_xml_element_rec AMS_Xml_Element_PVT.xml_element_rec_type;
1726:
1727: BEGIN
1728: -- Standard Start of API savepoint
1729: SAVEPOINT VALIDATE_Xml_Element_;
1730:
1731: -- Standard call to check for call compatibility.
1732: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1727: BEGIN
1728: -- Standard Start of API savepoint
1729: SAVEPOINT VALIDATE_Xml_Element_;
1730:
1731: -- Standard call to check for call compatibility.
1732: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1733: p_api_version_number,
1734: l_api_name,
1735: G_PKG_NAME)
1794:
1795: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1796: END IF;
1797:
1798: -- Standard call to get message count and if count is 1, get message info.
1799: FND_MSG_PUB.Count_And_Get
1800: (p_count => x_msg_count,
1801: p_data => x_msg_data
1802: );
1808:
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: ROLLBACK TO VALIDATE_Xml_Element_;
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812: -- Standard call to get message count and if count=1, get the message
1813: FND_MSG_PUB.Count_And_Get (
1814: p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count,
1816: p_data => x_msg_data
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: ROLLBACK TO VALIDATE_Xml_Element_;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1822: -- Standard call to get message count and if count=1, get the message
1823: FND_MSG_PUB.Count_And_Get (
1824: p_encoded => FND_API.G_FALSE,
1825: p_count => x_msg_count,
1826: p_data => x_msg_data
1832: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1835: END IF;
1836: -- Standard call to get message count and if count=1, get the message
1837: FND_MSG_PUB.Count_And_Get (
1838: p_encoded => FND_API.G_FALSE,
1839: p_count => x_msg_count,
1840: p_data => x_msg_data
1870: IF (AMS_DEBUG_HIGH_ON) THEN
1871:
1872: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1873: END IF;
1874: -- Standard call to get message count and if count is 1, get message info.
1875: FND_MSG_PUB.Count_And_Get
1876: (p_count => x_msg_count,
1877: p_data => x_msg_data
1878: );