68: FROM AMS_DM_TARGETS_VL
69: WHERE TARGET_ID = l_id;
70:
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT CREATE_Dmtarget_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT CREATE_Dmtarget_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
193: --
194: -- End of API body
195: --
196:
197: -- Standard check for p_commit
198: IF FND_API.to_Boolean( p_commit ) THEN
199: COMMIT WORK;
200: END IF;
201:
205:
206: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
207: END IF;
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,
212: p_data => x_msg_data
213: );
219:
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO CREATE_Dmtarget_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: -- Standard call to get message count and if count=1, get the message
224: FND_MSG_PUB.Count_And_Get (
225: p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
229:
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO CREATE_Dmtarget_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: -- Standard call to get message count and if count=1, get the message
234: FND_MSG_PUB.Count_And_Get (
235: p_encoded => FND_API.G_FALSE,
236: p_count => x_msg_count,
237: p_data => x_msg_data
243: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
246: END IF;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
284: l_rowid ROWID;
285:
286:
287: BEGIN
288: -- Standard Start of API savepoint
289: SAVEPOINT UPDATE_Dmtarget_PVT;
290:
291: -- Standard call to check for call compatibility.
292: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: BEGIN
288: -- Standard Start of API savepoint
289: SAVEPOINT UPDATE_Dmtarget_PVT;
290:
291: -- Standard call to check for call compatibility.
292: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
293: p_api_version_number,
294: l_api_name,
295: G_PKG_NAME)
466: --
467: -- End of API body.
468: --
469:
470: -- Standard check for p_commit
471: IF FND_API.to_Boolean( p_commit )
472: THEN
473: COMMIT WORK;
474: END IF;
479:
480: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
481: END IF;
482:
483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get
485: (p_count => x_msg_count,
486: p_data => x_msg_data
487: );
493:
494: WHEN FND_API.G_EXC_ERROR THEN
495: ROLLBACK TO UPDATE_Dmtarget_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: -- Standard call to get message count and if count=1, get the message
498: FND_MSG_PUB.Count_And_Get (
499: p_encoded => FND_API.G_FALSE,
500: p_count => x_msg_count,
501: p_data => x_msg_data
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO UPDATE_Dmtarget_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: -- Standard call to get message count and if count=1, get the message
508: FND_MSG_PUB.Count_And_Get (
509: p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data
517: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
520: END IF;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
568:
569:
570:
571: BEGIN
572: -- Standard Start of API savepoint
573: SAVEPOINT DELETE_Dmtarget_PVT;
574:
575: -- Standard call to check for call compatibility.
576: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
571: BEGIN
572: -- Standard Start of API savepoint
573: SAVEPOINT DELETE_Dmtarget_PVT;
574:
575: -- Standard call to check for call compatibility.
576: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
577: p_api_version_number,
578: l_api_name,
579: G_PKG_NAME)
678: --
679: -- End of API body
680: --
681:
682: -- Standard check for p_commit
683: IF FND_API.to_Boolean( p_commit )
684: THEN
685: COMMIT WORK;
686: END IF;
691:
692: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
693: END IF;
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get
697: (p_count => x_msg_count,
698: p_data => x_msg_data
699: );
705:
706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO DELETE_Dmtarget_PVT;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717: ROLLBACK TO DELETE_Dmtarget_PVT;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: -- Standard call to get message count and if count=1, get the message
720: FND_MSG_PUB.Count_And_Get (
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data
729: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
732: END IF;
733: -- Standard call to get message count and if count=1, get the message
734: FND_MSG_PUB.Count_And_Get (
735: p_encoded => FND_API.G_FALSE,
736: p_count => x_msg_count,
737: p_data => x_msg_data
779: THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: -- Standard call to check for call compatibility.
784: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
785: p_api_version_number,
786: l_api_name,
787: G_PKG_NAME)
835:
836: WHEN FND_API.G_EXC_ERROR THEN
837: ROLLBACK TO LOCK_Dmtarget_PVT;
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: -- Standard call to get message count and if count=1, get the message
840: FND_MSG_PUB.Count_And_Get (
841: p_encoded => FND_API.G_FALSE,
842: p_count => x_msg_count,
843: p_data => x_msg_data
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: ROLLBACK TO LOCK_Dmtarget_PVT;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: -- Standard call to get message count and if count=1, get the message
850: FND_MSG_PUB.Count_And_Get (
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data
859: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
862: END IF;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data
1310: l_object_version_number NUMBER;
1311: l_dm_target_rec AMS_DM_TARGET_PVT.dm_target_rec_type;
1312:
1313: BEGIN
1314: -- Standard Start of API savepoint
1315: SAVEPOINT VALIDATE_Dmtarget_;
1316:
1317: -- Debug Message
1318: IF (AMS_DEBUG_HIGH_ON) THEN
1320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1321: END IF;
1322:
1323:
1324: -- Standard call to check for call compatibility.
1325: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1326: p_api_version_number,
1327: l_api_name,
1328: G_PKG_NAME)
1376:
1377: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1378: END IF;
1379:
1380: -- Standard call to get message count and if count is 1, get message info.
1381: FND_MSG_PUB.Count_And_Get
1382: (p_count => x_msg_count,
1383: p_data => x_msg_data
1384: );
1390:
1391: WHEN FND_API.G_EXC_ERROR THEN
1392: ROLLBACK TO VALIDATE_Dmtarget_;
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: -- Standard call to get message count and if count=1, get the message
1395: FND_MSG_PUB.Count_And_Get (
1396: p_encoded => FND_API.G_FALSE,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data
1400:
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ROLLBACK TO VALIDATE_Dmtarget_;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: -- Standard call to get message count and if count=1, get the message
1405: FND_MSG_PUB.Count_And_Get (
1406: p_encoded => FND_API.G_FALSE,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data
1414: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1453: -- If data not valid
1454: -- THEN
1455: -- x_return_status := FND_API.G_RET_STS_ERROR;
1456:
1457: -- Standard call to get message count and if count is 1, get message info.
1458: FND_MSG_PUB.Count_And_Get
1459: (p_count => x_msg_count,
1460: p_data => x_msg_data
1461: );