32: l_api_version_number CONSTANT NUMBER := 1.0;
33: l_return_status_full VARCHAR2(1);
34: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
35: BEGIN
36: -- Standard Start of API savepoint
37: SAVEPOINT CREATE_PARTY_RLTSHIP_PVT;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
35: BEGIN
36: -- Standard Start of API savepoint
37: SAVEPOINT CREATE_PARTY_RLTSHIP_PVT;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
131: --
132: -- End of API body
133: --
134:
135: -- Standard check for p_commit
136: IF FND_API.to_Boolean( p_commit )
137: THEN
138: COMMIT WORK;
139: END IF;
142: -- Debug Message
143: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
144:
145:
146: -- Standard call to get message count and if count is 1, get message info.
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data
150: );
225: l_ref_PARTY_RLTSHIP_rec ASO_quote_pub.PARTY_RLTSHIP_Rec_Type;
226: l_tar_PARTY_RLTSHIP_rec ASO_quote_pub.PARTY_RLTSHIP_Rec_Type := P_PARTY_RLTSHIP_Rec;
227: l_rowid ROWID;
228: BEGIN
229: -- Standard Start of API savepoint
230: SAVEPOINT UPDATE_PARTY_RLTSHIP_PVT;
231:
232: -- Standard call to check for call compatibility.
233: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
228: BEGIN
229: -- Standard Start of API savepoint
230: SAVEPOINT UPDATE_PARTY_RLTSHIP_PVT;
231:
232: -- Standard call to check for call compatibility.
233: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
234: p_api_version_number,
235: l_api_name,
236: G_PKG_NAME)
357: --
358: -- End of API body.
359: --
360:
361: -- Standard check for p_commit
362: IF FND_API.to_Boolean( p_commit )
363: THEN
364: COMMIT WORK;
365: END IF;
368: -- Debug Message
369: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
370:
371:
372: -- Standard call to get message count and if count is 1, get message info.
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count,
375: p_data => x_msg_data
376: );
426: l_api_name CONSTANT VARCHAR2(30) := 'Delete_party_rltship';
427: l_api_version_number CONSTANT NUMBER := 1.0;
428: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
429: BEGIN
430: -- Standard Start of API savepoint
431: SAVEPOINT DELETE_PARTY_RLTSHIP_PVT;
432:
433: -- Standard call to check for call compatibility.
434: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
429: BEGIN
430: -- Standard Start of API savepoint
431: SAVEPOINT DELETE_PARTY_RLTSHIP_PVT;
432:
433: -- Standard call to check for call compatibility.
434: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
435: p_api_version_number,
436: l_api_name,
437: G_PKG_NAME)
464: --
465: -- End of API body
466: --
467:
468: -- Standard check for p_commit
469: IF FND_API.to_Boolean( p_commit )
470: THEN
471: COMMIT WORK;
472: END IF;
475: -- Debug Message
476: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
477:
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get
481: ( p_count => x_msg_count,
482: p_data => x_msg_data
483: );
563: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
564: NULL;
565: END IF;
566:
567: -- Standard call to get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );
609: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
610: NULL;
611: END IF;
612:
613: -- Standard call to get message count and if count is 1, get message info.
614: FND_MSG_PUB.Count_And_Get
615: ( p_count => x_msg_count,
616: p_data => x_msg_data
617: );
655: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
656: NULL;
657: END IF;
658:
659: -- Standard call to get message count and if count is 1, get message info.
660: FND_MSG_PUB.Count_And_Get
661: ( p_count => x_msg_count,
662: p_data => x_msg_data
663: );
701: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
702: NULL;
703: END IF;
704:
705: -- Standard call to get message count and if count is 1, get message info.
706: FND_MSG_PUB.Count_And_Get
707: ( p_count => x_msg_count,
708: p_data => x_msg_data
709: );
747: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
748: NULL;
749: END IF;
750:
751: -- Standard call to get message count and if count is 1, get message info.
752: FND_MSG_PUB.Count_And_Get
753: ( p_count => x_msg_count,
754: p_data => x_msg_data
755: );
793: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
794: NULL;
795: END IF;
796:
797: -- Standard call to get message count and if count is 1, get message info.
798: FND_MSG_PUB.Count_And_Get
799: ( p_count => x_msg_count,
800: p_data => x_msg_data
801: );
838: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
839: NULL;
840: END IF;
841:
842: -- Standard call to get message count and if count is 1, get message info.
843: FND_MSG_PUB.Count_And_Get
844: ( p_count => x_msg_count,
845: p_data => x_msg_data
846: );
891: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
892: NULL;
893: END IF;
894:
895: -- Standard call to get message count and if count is 1, get message info.
896: FND_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count,
898: p_data => x_msg_data
899: );
937: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
938: NULL;
939: END IF;
940:
941: -- Standard call to get message count and if count is 1, get message info.
942: FND_MSG_PUB.Count_And_Get
943: ( p_count => x_msg_count,
944: p_data => x_msg_data
945: );
983: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
984: NULL;
985: END IF;
986:
987: -- Standard call to get message count and if count is 1, get message info.
988: FND_MSG_PUB.Count_And_Get
989: ( p_count => x_msg_count,
990: p_data => x_msg_data
991: );
1036: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1037: NULL;
1038: END IF;
1039:
1040: -- Standard call to get message count and if count is 1, get message info.
1041: FND_MSG_PUB.Count_And_Get
1042: ( p_count => x_msg_count,
1043: p_data => x_msg_data
1044: );
1089: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1090: NULL;
1091: END IF;
1092:
1093: -- Standard call to get message count and if count is 1, get message info.
1094: FND_MSG_PUB.Count_And_Get
1095: ( p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );
1142: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1143: NULL;
1144: END IF;
1145:
1146: -- Standard call to get message count and if count is 1, get message info.
1147: FND_MSG_PUB.Count_And_Get
1148: ( p_count => x_msg_count,
1149: p_data => x_msg_data
1150: );
1195: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1196: NULL;
1197: END IF;
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200: FND_MSG_PUB.Count_And_Get
1201: ( p_count => x_msg_count,
1202: p_data => x_msg_data
1203: );
1237:
1238: -- Debug Message
1239: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: FND_MSG_PUB.Count_And_Get
1243: ( p_count => x_msg_count,
1244: p_data => x_msg_data
1245: );