DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_PVT dependencies on STANDARD

Line 72: -- Standard Start of API savepoint

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,

Line 75: -- Standard call to check for call compatibility.

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)

Line 197: -- Standard check for p_commit

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:

Line 209: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 223: -- Standard call to get message count and if count=1, get the message

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

Line 233: -- Standard call to get message count and if count=1, get the message

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

Line 247: -- Standard call to get message count and if count=1, get the message

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

Line 288: -- Standard Start of API savepoint

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,

Line 291: -- Standard call to check for call compatibility.

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)

Line 470: -- Standard check for p_commit

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;

Line 483: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 497: -- Standard call to get message count and if count=1, get the message

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

Line 507: -- Standard call to get message count and if count=1, get the message

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

Line 521: -- Standard call to get message count and if count=1, get the message

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

Line 572: -- Standard Start of API savepoint

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,

Line 575: -- Standard call to check for call compatibility.

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)

Line 682: -- Standard check for p_commit

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;

Line 695: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 709: -- Standard call to get message count and if count=1, get the message

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

Line 719: -- Standard call to get message count and if count=1, get the message

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

Line 733: -- Standard call to get message count and if count=1, get the message

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

Line 783: -- Standard call to check for call compatibility.

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)

Line 839: -- Standard call to get message count and if count=1, get the message

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

Line 849: -- Standard call to get message count and if count=1, get the message

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

Line 863: -- Standard call to get message count and if count=1, get the message

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

Line 1314: -- Standard Start of API savepoint

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

Line 1324: -- Standard call to check for call compatibility.

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)

Line 1380: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1394: -- Standard call to get message count and if count=1, get the message

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

Line 1404: -- Standard call to get message count and if count=1, get the message

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

Line 1418: -- Standard call to get message count and if count=1, get the message

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

Line 1457: -- Standard call to get message count and if count is 1, get message info.

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: );