[Home] [Help]
59: FROM AMS_COMPETITOR_PRODUCTS_B
60: WHERE COMPETITOR_PRODUCT_ID = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Ams_Comp_Product_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Ams_Comp_Product_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)
188: --
189: -- End of API body
190: --
191:
192: -- Standard check for p_commit
193: IF FND_API.to_Boolean( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;
196: END IF;
197:
198: x_competitor_product_id := l_competitor_product_id;
199:
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count,
203: p_data => x_msg_data
204: );
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
277: l_tar_comp_prod_type_rec Ams_Competitor_Product_Pvt.comp_prod_rec_type := p_comp_prod_rec;
278: l_rowid ROWID;
279:
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_Ams_Comp_Product_PVT;
283:
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_Ams_Comp_Product_PVT;
283:
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
286: p_api_version_number,
287: l_api_name,
288: G_PKG_NAME)
413: --
414: -- End of API body.
415: --
416:
417: -- Standard check for p_commit
418: IF FND_API.to_Boolean( p_commit )
419: THEN
420: COMMIT WORK;
421: END IF;
426:
427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
428: END IF;
429:
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: (p_count => x_msg_count,
433: p_data => x_msg_data
434: );
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data
450:
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
492: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
493: l_object_version_number NUMBER;
494:
495: BEGIN
496: -- Standard Start of API savepoint
497: SAVEPOINT DELETE_Ams_Comp_Product_PVT;
498:
499: -- Standard call to check for call compatibility.
500: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
495: BEGIN
496: -- Standard Start of API savepoint
497: SAVEPOINT DELETE_Ams_Comp_Product_PVT;
498:
499: -- Standard call to check for call compatibility.
500: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
501: p_api_version_number,
502: l_api_name,
503: G_PKG_NAME)
538: --
539: -- End of API body
540: --
541:
542: -- Standard check for p_commit
543: IF FND_API.to_Boolean( p_commit )
544: THEN
545: COMMIT WORK;
546: END IF;
551:
552: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
553: END IF;
554:
555: -- Standard call to get message count and if count is 1, get message info.
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count,
558: p_data => x_msg_data
559: );
565:
566: WHEN FND_API.G_EXC_ERROR THEN
567: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: -- Standard call to get message count and if count=1, get the message
570: FND_MSG_PUB.Count_And_Get (
571: p_encoded => FND_API.G_FALSE,
572: p_count => x_msg_count,
573: p_data => x_msg_data
575:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
579: -- Standard call to get message count and if count=1, get the message
580: FND_MSG_PUB.Count_And_Get (
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_msg_count,
583: p_data => x_msg_data
589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
592: END IF;
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count,
597: p_data => x_msg_data
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
646: p_api_version_number,
647: l_api_name,
648: G_PKG_NAME)
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
706:
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
1159: RAISE FND_API.g_exc_error;
1160: END IF; -- (p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)
1161:
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1184: l_object_version_number NUMBER;
1185: l_comp_prod_rec_type_rec Ams_Competitor_Product_Pvt.comp_prod_rec_type;
1186:
1187: BEGIN
1188: -- Standard Start of API savepoint
1189: SAVEPOINT VALIDATE_Ams_Comp_Product_;
1190:
1191: -- Debug Message
1192: IF (AMS_DEBUG_HIGH_ON) THEN
1197: -- Initialize API return status to SUCCESS
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199:
1200:
1201: -- Standard call to check for call compatibility.
1202: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1203: p_api_version_number,
1204: l_api_name,
1205: G_PKG_NAME)
1254:
1255: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1256: END IF;
1257:
1258: -- Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get
1260: (p_count => x_msg_count,
1261: p_data => x_msg_data
1262: );
1268:
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data
1278:
1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: -- Standard call to get message count and if count=1, get the message
1283: FND_MSG_PUB.Count_And_Get (
1284: p_encoded => FND_API.G_FALSE,
1285: p_count => x_msg_count,
1286: p_data => x_msg_data
1292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data