DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_VALUE_PVT dependencies on STANDARD

Line 84: -- Standard Start of API savepoint

80: WHERE target_id = l_tgtId;
81:
82:
83: BEGIN
84: -- Standard Start of API savepoint
85: SAVEPOINT CREATE_Dm_Target_Value_PVT;
86:
87: -- Standard call to check for call compatibility.
88: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

83: BEGIN
84: -- Standard Start of API savepoint
85: SAVEPOINT CREATE_Dm_Target_Value_PVT;
86:
87: -- Standard call to check for call compatibility.
88: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
89: p_api_version_number,
90: l_api_name,
91: G_PKG_NAME)

Line 222: -- Standard check for p_commit

218: --
219: -- End of API body
220: --
221:
222: -- Standard check for p_commit
223: IF FND_API.to_Boolean( p_commit ) THEN
224: COMMIT WORK;
225: END IF;
226:

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

229:
230: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
231: END IF;
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: FND_MSG_PUB.Count_And_Get
235: (p_count => x_msg_count,
236: p_data => x_msg_data
237: );

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

243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Dm_Target_Value_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
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 257: -- Standard call to get message count and if count=1, get the message

253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK TO CREATE_Dm_Target_Value_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data

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

267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data

Line 314: -- Standard Start of API savepoint

310: l_tar_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type := P_dm_target_value_rec;
311: l_rowid ROWID;
312:
313: BEGIN
314: -- Standard Start of API savepoint
315: SAVEPOINT UPDATE_Dm_Target_Value_PVT;
316:
317: -- Debug Message
318: IF (AMS_DEBUG_HIGH_ON) THEN

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

319:
320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
321: END IF;
322:
323: -- Standard call to check for call compatibility.
324: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
325: p_api_version_number,
326: l_api_name,
327: G_PKG_NAME)

Line 448: -- Standard check for p_commit

444: --
445: -- End of API body.
446: --
447:
448: -- Standard check for p_commit
449: IF FND_API.to_Boolean( p_commit )
450: THEN
451: COMMIT WORK;
452: END IF;

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

456:
457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
458: END IF;
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data
464: );

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

470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO UPDATE_Dm_Target_Value_PVT;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data

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

480:
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO UPDATE_Dm_Target_Value_PVT;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data

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

494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data

Line 511: -- Standard Start of API savepoint

507: IS
508: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_TgtValues_For_Target';
509:
510: BEGIN
511: -- Standard Start of API savepoint
512: SAVEPOINT Delete_TgtValues_For_Target;
513:
514: -- Debug Message
515: IF (AMS_DEBUG_HIGH_ON) THEN

Line 605: -- Standard Start of API savepoint

601: WHERE DATA_SOURCE_ID = l_dsId
602: AND ACTIVE_FLAG = 'Y';
603:
604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT DELETE_Dm_Target_Value_PVT;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT DELETE_Dm_Target_Value_PVT;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
610: p_api_version_number,
611: l_api_name,
612: G_PKG_NAME)

Line 698: -- Standard check for p_commit

694: --
695: -- End of API body
696: --
697:
698: -- Standard check for p_commit
699: IF FND_API.to_Boolean( p_commit )
700: THEN
701: COMMIT WORK;
702: END IF;

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

708:
709: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
710: END IF;
711:
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: (p_count => x_msg_count,
715: p_data => x_msg_data
716: );

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

722:
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: -- Standard call to get message count and if count=1, get the message
727: FND_MSG_PUB.Count_And_Get (
728: p_encoded => FND_API.G_FALSE,
729: p_count => x_msg_count,
730: p_data => x_msg_data

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

732:
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data

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

746: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
747: THEN
748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
749: END IF;
750: -- Standard call to get message count and if count=1, get the message
751: FND_MSG_PUB.Count_And_Get (
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_msg_count,
754: p_data => x_msg_data

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

796: THEN
797: FND_MSG_PUB.initialize;
798: END IF;
799:
800: -- Standard call to check for call compatibility.
801: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
802: p_api_version_number,
803: l_api_name,
804: G_PKG_NAME)

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

852:
853: WHEN FND_API.G_EXC_ERROR THEN
854: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: -- Standard call to get message count and if count=1, get the message
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data

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

862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: -- Standard call to get message count and if count=1, get the message
867: FND_MSG_PUB.Count_And_Get (
868: p_encoded => FND_API.G_FALSE,
869: p_count => x_msg_count,
870: p_data => x_msg_data

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

876: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
879: END IF;
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => x_msg_count,
884: p_data => x_msg_data

Line 1249: -- Standard Start of API savepoint

1245: l_object_version_number NUMBER;
1246: -- l_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type;
1247:
1248: BEGIN
1249: -- Standard Start of API savepoint
1250: SAVEPOINT VALIDATE_Dm_Target_Value_;
1251:
1252: -- Standard call to check for call compatibility.
1253: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1248: BEGIN
1249: -- Standard Start of API savepoint
1250: SAVEPOINT VALIDATE_Dm_Target_Value_;
1251:
1252: -- Standard call to check for call compatibility.
1253: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1254: p_api_version_number,
1255: l_api_name,
1256: G_PKG_NAME)

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

1310:
1311: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312: END IF;
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: (p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );

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

1324:
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data

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

1334:
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,
1342: p_data => x_msg_data

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

1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data

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

1453: END;
1454: END IF;
1455: -- end add rosharma 28-Nov-2002
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: );