DBA Data[Home] [Help]

APPS.AMS_ST_ASSOC_PVT dependencies on STANDARD

Line 57: -- Standard Start of API savepoint

53: SELECT 1
54: FROM AMS_LIST_SRC_TYPE_ASSOCS
55: WHERE LIST_SOURCE_TYPE_ASSOC_ID = l_id;
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_St_Assoc_PVT;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_St_Assoc_PVT;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
62: p_api_version_number,
63: l_api_name,
64: G_PKG_NAME)

Line 164: -- Standard check for p_commit

160: --
161: -- End of API body
162: --
163:
164: -- Standard check for p_commit
165: IF FND_API.to_Boolean( p_commit )
166: THEN
167: COMMIT WORK;
168: END IF;

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

173:
174: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
175: END IF;
176:
177: -- Standard call to get message count and if count is 1, get message info.
178: FND_MSG_PUB.Count_And_Get
179: (p_count => x_msg_count,
180: p_data => x_msg_data
181: );

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

188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO CREATE_St_Assoc_PVT;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: -- Standard call to get message count and if count=1, get the message
193: FND_MSG_PUB.Count_And_Get (
194: p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data

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

198:
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO CREATE_St_Assoc_PVT;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: -- Standard call to get message count and if count=1, get the message
203: FND_MSG_PUB.Count_And_Get (
204: p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data

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

212: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
215: END IF;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data

Line 257: -- Standard Start of API savepoint

253: l_tar_st_assoc_rec AMS_St_Assoc_PVT.st_assoc_rec_type := P_st_assoc_rec;
254: l_rowid ROWID;
255:
256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT UPDATE_St_Assoc_PVT;
259:
260: -- Standard call to check for call compatibility.
261: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT UPDATE_St_Assoc_PVT;
259:
260: -- Standard call to check for call compatibility.
261: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
262: p_api_version_number,
263: l_api_name,
264: G_PKG_NAME)

Line 377: -- Standard check for p_commit

373: --
374: -- End of API body.
375: --
376:
377: -- Standard check for p_commit
378: IF FND_API.to_Boolean( p_commit )
379: THEN
380: COMMIT WORK;
381: END IF;

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

386:
387: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
388: END IF;
389:
390: -- Standard call to get message count and if count is 1, get message info.
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count,
393: p_data => x_msg_data
394: );

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

400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO UPDATE_St_Assoc_PVT;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data

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

410:
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: ROLLBACK TO UPDATE_St_Assoc_PVT;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: -- Standard call to get message count and if count=1, get the message
415: FND_MSG_PUB.Count_And_Get (
416: p_encoded => FND_API.G_FALSE,
417: p_count => x_msg_count,
418: p_data => x_msg_data

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

424: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data

Line 455: -- Standard Start of API savepoint

451: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
452: l_object_version_number NUMBER;
453:
454: BEGIN
455: -- Standard Start of API savepoint
456: SAVEPOINT DELETE_St_Assoc_PVT;
457:
458: -- Standard call to check for call compatibility.
459: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

454: BEGIN
455: -- Standard Start of API savepoint
456: SAVEPOINT DELETE_St_Assoc_PVT;
457:
458: -- Standard call to check for call compatibility.
459: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
460: p_api_version_number,
461: l_api_name,
462: G_PKG_NAME)

Line 499: -- Standard check for p_commit

495: --
496: -- End of API body
497: --
498:
499: -- Standard check for p_commit
500: IF FND_API.to_Boolean( p_commit )
501: THEN
502: COMMIT WORK;
503: END IF;

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

508:
509: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
510: END IF;
511:
512: -- Standard call to get message count and if count is 1, get message info.
513: FND_MSG_PUB.Count_And_Get
514: (p_count => x_msg_count,
515: p_data => x_msg_data
516: );

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

522:
523: WHEN FND_API.G_EXC_ERROR THEN
524: ROLLBACK TO DELETE_St_Assoc_PVT;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data

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

532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO DELETE_St_Assoc_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data

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

546: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
547: THEN
548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
549: END IF;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data

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

596: THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)

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

652:
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO LOCK_St_Assoc_PVT;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,
660: p_data => x_msg_data

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

662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: ROLLBACK TO LOCK_St_Assoc_PVT;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data

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

676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
679: END IF;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data

Line 1069: -- Standard Start of API savepoint

1065: l_object_version_number NUMBER;
1066: l_st_assoc_rec AMS_St_Assoc_PVT.st_assoc_rec_type;
1067:
1068: BEGIN
1069: -- Standard Start of API savepoint
1070: SAVEPOINT VALIDATE_St_Assoc_;
1071:
1072: -- Standard call to check for call compatibility.
1073: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1068: BEGIN
1069: -- Standard Start of API savepoint
1070: SAVEPOINT VALIDATE_St_Assoc_;
1071:
1072: -- Standard call to check for call compatibility.
1073: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1074: p_api_version_number,
1075: l_api_name,
1076: G_PKG_NAME)

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

1136:
1137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1138: END IF;
1139:
1140: -- Standard call to get message count and if count is 1, get message info.
1141: FND_MSG_PUB.Count_And_Get
1142: (p_count => x_msg_count,
1143: p_data => x_msg_data
1144: );

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

1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO VALIDATE_St_Assoc_;
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: -- Standard call to get message count and if count=1, get the message
1155: FND_MSG_PUB.Count_And_Get (
1156: p_encoded => FND_API.G_FALSE,
1157: p_count => x_msg_count,
1158: p_data => x_msg_data

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

1160:
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: ROLLBACK TO VALIDATE_St_Assoc_;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: -- Standard call to get message count and if count=1, get the message
1165: FND_MSG_PUB.Count_And_Get (
1166: p_encoded => FND_API.G_FALSE,
1167: p_count => x_msg_count,
1168: p_data => x_msg_data

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

1174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1175: THEN
1176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1177: END IF;
1178: -- Standard call to get message count and if count=1, get the message
1179: FND_MSG_PUB.Count_And_Get (
1180: p_encoded => FND_API.G_FALSE,
1181: p_count => x_msg_count,
1182: p_data => x_msg_data

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

1212: IF (AMS_DEBUG_HIGH_ON) THEN
1213:
1214: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1215: END IF;
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: (p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );