260: l_upd_date DATE;
261: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Create_sales_credits';
262:
263: BEGIN
264: -- Standard Start of API savepoint
265: SAVEPOINT CREATE_SALES_CREDITS_PVT;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
263: BEGIN
264: -- Standard Start of API savepoint
265: SAVEPOINT CREATE_SALES_CREDITS_PVT;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
269: p_api_version_number,
270: l_api_name,
271: G_PKG_NAME)
725: --
726: -- End of API body
727: --
728:
729: -- Standard check for p_commit
730: IF FND_API.to_Boolean( p_commit )
731: THEN
732: COMMIT WORK;
733: END IF;
739: 'Private API7 ' || l_api_name || 'end');
740: END IF;
741:
742:
743: -- Standard call to get message count and if count is 1, get message info.
744: FND_MSG_PUB.Count_And_Get
745: ( p_count => x_msg_count,
746: p_data => x_msg_data
747: );
953: l_opp_best_forecast_amount NUMBER;
954: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Update_sales_credits';
955:
956: BEGIN
957: -- Standard Start of API savepoint
958: SAVEPOINT UPDATE_SALES_CREDITS_PVT;
959:
960: -- Standard call to check for call compatibility.
961: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
956: BEGIN
957: -- Standard Start of API savepoint
958: SAVEPOINT UPDATE_SALES_CREDITS_PVT;
959:
960: -- Standard call to check for call compatibility.
961: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
962: p_api_version_number,
963: l_api_name,
964: G_PKG_NAME)
1589: --
1590: -- End of API body.
1591: --
1592:
1593: -- Standard check for p_commit
1594: IF FND_API.to_Boolean( p_commit )
1595: THEN
1596: COMMIT WORK;
1597: END IF;
1604: END IF;
1605:
1606:
1607:
1608: -- Standard call to get message count and if count is 1, get message info.
1609: FND_MSG_PUB.Count_And_Get
1610: ( p_count => x_msg_count,
1611: p_data => x_msg_data
1612: );
1731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1732: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.modify_sales_credits';
1733:
1734: BEGIN
1735: -- Standard Start of API savepoint
1736: SAVEPOINT MODIFY_SALES_CREDITS_PVT;
1737:
1738: -- Standard call to check for call compatibility.
1739: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1734: BEGIN
1735: -- Standard Start of API savepoint
1736: SAVEPOINT MODIFY_SALES_CREDITS_PVT;
1737:
1738: -- Standard call to check for call compatibility.
1739: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1740: p_api_version_number,
1741: l_api_name,
1742: G_PKG_NAME)
2141: --
2142: -- End of API body.
2143: --
2144:
2145: -- Standard check for p_commit
2146: IF FND_API.to_Boolean( p_commit )
2147: THEN
2148: COMMIT WORK;
2149: END IF;
2154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2155: 'Private API 28: ' || l_api_name || 'end');
2156: END IF;
2157:
2158: -- Standard call to get message count and if count is 1, get message info.
2159: FND_MSG_PUB.Count_And_Get
2160: ( p_count => x_msg_count,
2161: p_data => x_msg_data
2162: );
2236: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2237: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Delete_sales_credits';
2238:
2239: BEGIN
2240: -- Standard Start of API savepoint
2241: SAVEPOINT DELETE_SALES_CREDITS_PVT;
2242:
2243: -- Standard call to check for call compatibility.
2244: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2239: BEGIN
2240: -- Standard Start of API savepoint
2241: SAVEPOINT DELETE_SALES_CREDITS_PVT;
2242:
2243: -- Standard call to check for call compatibility.
2244: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2245: p_api_version_number,
2246: l_api_name,
2247: G_PKG_NAME)
2404: --
2405: -- End of API body
2406: --
2407:
2408: -- Standard check for p_commit
2409: IF FND_API.to_Boolean( p_commit )
2410: THEN
2411: COMMIT WORK;
2412: END IF;
2417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2418: 'Private API 32: ' || l_api_name || 'end');
2419: END IF;
2420:
2421: -- Standard call to get message count and if count is 1, get message info.
2422: FND_MSG_PUB.Count_And_Get
2423: ( p_count => x_msg_count,
2424: p_data => x_msg_data
2425: );
2558: END IF;
2559:
2560: END IF;
2561:
2562: -- Standard call to get message count and if count is 1, get message info.
2563: FND_MSG_PUB.Count_And_Get
2564: ( p_count => x_msg_count,
2565: p_data => x_msg_data
2566: );
2623: END IF;
2624: CLOSE C_Lead_Id_Exists;
2625: END IF;
2626:
2627: -- Standard call to get message count and if count is 1, get message info.
2628: FND_MSG_PUB.Count_And_Get
2629: ( p_count => x_msg_count,
2630: p_data => x_msg_data
2631: );
2687: END IF;
2688: CLOSE C_Lead_Line_Id_Exists;
2689: END IF;
2690:
2691: -- Standard call to get message count and if count is 1, get message info.
2692: FND_MSG_PUB.Count_And_Get
2693: ( p_count => x_msg_count,
2694: p_data => x_msg_data
2695: );
2751: END IF;
2752: CLOSE C_Salesforce_Id_Exists;
2753: END IF;
2754:
2755: -- Standard call to get message count and if count is 1, get message info.
2756: FND_MSG_PUB.Count_And_Get
2757: ( p_count => x_msg_count,
2758: p_data => x_msg_data
2759: );
2807: END IF;
2808: CLOSE C_PERSON_ID_Exists;
2809: END IF;
2810:
2811: -- Standard call to get message count and if count is 1, get message info.
2812: FND_MSG_PUB.Count_And_Get
2813: ( p_count => x_msg_count,
2814: p_data => x_msg_data
2815: );
2887: END IF;
2888: END IF;
2889:
2890: */
2891: -- Standard call to get message count and if count is 1, get message info.
2892: FND_MSG_PUB.Count_And_Get
2893: ( p_count => x_msg_count,
2894: p_data => x_msg_data
2895: );
2943: END IF;
2944: CLOSE C_PARTNER_CUSTOMER_ID_Exists;
2945: END IF;
2946:
2947: -- Standard call to get message count and if count is 1, get message info.
2948: FND_MSG_PUB.Count_And_Get
2949: ( p_count => x_msg_count,
2950: p_data => x_msg_data
2951: );
2999: END IF;
3000: CLOSE C_PARTNER_ADDRESS_ID_Exists;
3001: END IF;
3002:
3003: -- Standard call to get message count and if count is 1, get message info.
3004: FND_MSG_PUB.Count_And_Get
3005: ( p_count => x_msg_count,
3006: p_data => x_msg_data
3007: );
3069: END IF;
3070: CLOSE C_Credit_Type_Id_Exists;
3071: END IF;
3072:
3073: -- Standard call to get message count and if count is 1, get message info.
3074: FND_MSG_PUB.Count_And_Get
3075: ( p_count => x_msg_count,
3076: p_data => x_msg_data
3077: );
3274: 'Private API 50: ' || l_api_name || ' end');
3275: END IF;
3276:
3277:
3278: -- Standard call to get message count and if count is 1, get message info.
3279: FND_MSG_PUB.Count_And_Get
3280: ( p_count => x_msg_count,
3281: p_data => x_msg_data
3282: );