[Home] [Help]
78: WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
79: AND organization_id = P_REL_ITEM_rec.organization_id;
80:
81: BEGIN
82: -- Standard Start of API savepoint
83: SAVEPOINT CREATE_REL_ITEM_PVT;
84:
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
81: BEGIN
82: -- Standard Start of API savepoint
83: SAVEPOINT CREATE_REL_ITEM_PVT;
84:
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
87: p_api_version_number,
88: l_api_name,
89: G_PKG_NAME)
242:
243: -- End of API body
244: --
245:
246: -- Standard check for p_commit
247: IF FND_API.to_Boolean( p_commit )
248: THEN
249: COMMIT WORK;
250: END IF;
255:
256: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
257: END IF;
258:
259: -- Standard call to get message count and if count is 1, get message info.
260: FND_MSG_PUB.Count_And_Get
261: (p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: ROLLBACK TO CREATE_REL_ITEM_PVT;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO CREATE_REL_ITEM_PVT;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: -- Standard call to get message count and if count=1, get the message
278: FND_MSG_PUB.Count_And_Get (
279: p_encoded => FND_API.G_FALSE,
280: p_count => x_msg_count,
281: p_data => x_msg_data
286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
289: END IF;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get (
292: p_encoded => FND_API.G_FALSE,
293: p_count => x_msg_count,
294: p_data => x_msg_data
343: l_tar_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type := P_REL_ITEM_Rec;
344: l_rowid ROWID;
345:
346: BEGIN
347: -- Standard Start of API savepoint
348: SAVEPOINT UPDATE_REL_ITEM_PVT;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
346: BEGIN
347: -- Standard Start of API savepoint
348: SAVEPOINT UPDATE_REL_ITEM_PVT;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
352: p_api_version_number,
353: l_api_name,
354: G_PKG_NAME)
459: --
460: -- End of API body.
461: --
462:
463: -- Standard check for p_commit
464: IF FND_API.to_Boolean( p_commit )
465: THEN
466: COMMIT WORK;
467: END IF;
472:
473: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
474: END IF;
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get
478: (p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR THEN
483: ROLLBACK TO UPDATE_REL_ITEM_PVT;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: ROLLBACK TO UPDATE_REL_ITEM_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
503: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
504: THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
506: END IF;
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
548: WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
549: AND organization_id = P_REL_ITEM_rec.organization_id;
550:
551: BEGIN
552: -- Standard Start of API savepoint
553: SAVEPOINT DELETE_REL_ITEM_PVT;
554:
555: -- Standard call to check for call compatibility.
556: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
551: BEGIN
552: -- Standard Start of API savepoint
553: SAVEPOINT DELETE_REL_ITEM_PVT;
554:
555: -- Standard call to check for call compatibility.
556: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
557: p_api_version_number,
558: l_api_name,
559: G_PKG_NAME)
659: --
660: -- End of API body
661: --
662:
663: -- Standard check for p_commit
664: IF FND_API.to_Boolean( p_commit )
665: THEN
666: COMMIT WORK;
667: END IF;
672:
673: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
674: END IF;
675:
676: -- Standard call to get message count and if count is 1, get message info.
677: FND_MSG_PUB.Count_And_Get
678: (p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO DELETE_REL_ITEM_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO DELETE_REL_ITEM_PVT;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,
711: p_data => x_msg_data
821: l_object_version_number NUMBER;
822: l_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type;
823:
824: BEGIN
825: -- Standard Start of API savepoint
826: SAVEPOINT VALIDATE_REL_ITEM_;
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
824: BEGIN
825: -- Standard Start of API savepoint
826: SAVEPOINT VALIDATE_REL_ITEM_;
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
830: p_api_version_number,
831: l_api_name,
832: G_PKG_NAME)
886:
887: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
888: END IF;
889:
890: -- Standard call to get message count and if count is 1, get message info.
891: FND_MSG_PUB.Count_And_Get
892: (p_count => x_msg_count,
893: p_data => x_msg_data
894: );
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: ROLLBACK TO VALIDATE_REL_ITEM_;
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: -- Standard call to get message count and if count=1, get the message
900: FND_MSG_PUB.Count_And_Get (
901: p_encoded => FND_API.G_FALSE,
902: p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: ROLLBACK TO VALIDATE_REL_ITEM_;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: -- Standard call to get message count and if count=1, get the message
909: FND_MSG_PUB.Count_And_Get (
910: p_encoded => FND_API.G_FALSE,
911: p_count => x_msg_count,
912: p_data => x_msg_data
917: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
918: THEN
919: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: -- Standard call to get message count and if count=1, get the message
922: FND_MSG_PUB.Count_And_Get (
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,
925: p_data => x_msg_data