DBA Data[Home] [Help]

APPS.AS_COMPETITOR_PROD_PVT dependencies on STANDARD

Line 119: -- Standard Start of API savepoint

115: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Create_competitor_prods';
116:
117:
118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT CREATE_COMPETITOR_PRODS_PVT;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT CREATE_COMPETITOR_PRODS_PVT;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
124: p_api_version_number,
125: l_api_name,
126: G_PKG_NAME)

Line 370: -- Standard check for p_commit

366: --
367: -- End of API body
368: --
369:
370: -- Standard check for p_commit
371: IF FND_API.to_Boolean( p_commit )
372: THEN
373: COMMIT WORK;
374: END IF;

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

380: 'Private API: ' || l_api_name || ' end');
381: END IF;
382:
383:
384: -- Standard call to get message count and if count is 1, get message info.
385: FND_MSG_PUB.Count_And_Get
386: ( p_count => x_msg_count,
387: p_data => x_msg_data
388: );

Line 504: -- Standard Start of API savepoint

500: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
501: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Update_competitor_prods';
502:
503: BEGIN
504: -- Standard Start of API savepoint
505: SAVEPOINT UPDATE_COMPETITOR_PRODS_PVT;
506:
507: -- Standard call to check for call compatibility.
508: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

503: BEGIN
504: -- Standard Start of API savepoint
505: SAVEPOINT UPDATE_COMPETITOR_PRODS_PVT;
506:
507: -- Standard call to check for call compatibility.
508: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
509: p_api_version_number,
510: l_api_name,
511: G_PKG_NAME)

Line 769: -- Standard check for p_commit

765: --
766: -- End of API body.
767: --
768:
769: -- Standard check for p_commit
770: IF FND_API.to_Boolean( p_commit )
771: THEN
772: COMMIT WORK;
773: END IF;

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

780: END IF;
781:
782:
783:
784: -- Standard call to get message count and if count is 1, get message info.
785: FND_MSG_PUB.Count_And_Get
786: ( p_count => x_msg_count,
787: p_data => x_msg_data
788: );

Line 899: -- Standard Start of API savepoint

895: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
896: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Delete_competitor_prods';
897:
898: BEGIN
899: -- Standard Start of API savepoint
900: SAVEPOINT DELETE_COMPETITOR_PRODS_PVT;
901:
902: -- Standard call to check for call compatibility.
903: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

898: BEGIN
899: -- Standard Start of API savepoint
900: SAVEPOINT DELETE_COMPETITOR_PRODS_PVT;
901:
902: -- Standard call to check for call compatibility.
903: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
904: p_api_version_number,
905: l_api_name,
906: G_PKG_NAME)

Line 1045: -- Standard check for p_commit

1041: --
1042: -- End of API body
1043: --
1044:
1045: -- Standard check for p_commit
1046: IF FND_API.to_Boolean( p_commit )
1047: THEN
1048: COMMIT WORK;
1049: END IF;

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

1055: 'Private API: ' || l_api_name || ' end');
1056: END IF;
1057:
1058:
1059: -- Standard call to get message count and if count is 1, get message info.
1060: FND_MSG_PUB.Count_And_Get
1061: ( p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );

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

1154: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1155: NULL;
1156: END IF;
1157:
1158: -- Standard call to get message count and if count is 1, get message info.
1159: FND_MSG_PUB.Count_And_Get
1160: ( p_count => x_msg_count,
1161: p_data => x_msg_data
1162: );

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

1220:
1221: CLOSE C_WIN_LOSS_STATUS_Exists;
1222: END IF;
1223:
1224: -- Standard call to get message count and if count is 1, get message info.
1225: FND_MSG_PUB.Count_And_Get
1226: ( p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );

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

1286: CLOSE c_competitor_product_exists;
1287: */
1288: END IF;
1289:
1290: -- Standard call to get message count and if count is 1, get message info.
1291: FND_MSG_PUB.Count_And_Get
1292: ( p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );

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

1351: END IF;
1352: CLOSE C_Lead_Line_Id_Exists;
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );

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

1416: END IF;
1417: CLOSE C_Lead_Id_Exists;
1418: END IF;
1419:
1420: -- Standard call to get message count and if count is 1, get message info.
1421: FND_MSG_PUB.Count_And_Get
1422: ( p_count => x_msg_count,
1423: p_data => x_msg_data
1424: );

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

1516: CLOSE C_Lead_CProd_Id_Exists;
1517: END IF;
1518: END IF;
1519:
1520: -- Standard call to get message count and if count is 1, get message info.
1521: FND_MSG_PUB.Count_And_Get
1522: ( p_count => x_msg_count,
1523: p_data => x_msg_data
1524: );

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

1560: -- x_return_status := FND_API.G_RET_STS_ERROR;
1561:
1562: -- Debug Message
1563:
1564: -- Standard call to get message count and if count is 1, get message info.
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );