DBA Data[Home] [Help]

APPS.CSP_ORDERHEADERS_PVT dependencies on STANDARD

Line 37: -- Standard Start of API savepoint

33: l_api_version_number CONSTANT NUMBER := 1.0;
34: l_return_status_full VARCHAR2(1);
35: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
36: BEGIN
37: -- Standard Start of API savepoint
38: SAVEPOINT CREATE_ORDERHEADERS_PVT;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

36: BEGIN
37: -- Standard Start of API savepoint
38: SAVEPOINT CREATE_ORDERHEADERS_PVT;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)

Line 187: -- Standard check for p_commit

183: --
184: -- End of API body
185: --
186:
187: -- Standard check for p_commit
188: IF FND_API.to_Boolean( p_commit )
189: THEN
190: COMMIT WORK;
191: END IF;

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

194: -- Debug Message
195: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
196:
197:
198: -- Standard call to get message count and if count is 1, get message info.
199: FND_MSG_PUB.Count_And_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data
202: );

Line 319: -- Standard Start of API savepoint

315: l_ref_MOH_rec CSP_orderheaders_PVT.MOH_Rec_Type;
316: l_tar_MOH_rec CSP_orderheaders_PVT.MOH_Rec_Type := P_MOH_Rec;
317: l_rowid ROWID;
318: BEGIN
319: -- Standard Start of API savepoint
320: SAVEPOINT UPDATE_ORDERHEADERS_PVT;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

318: BEGIN
319: -- Standard Start of API savepoint
320: SAVEPOINT UPDATE_ORDERHEADERS_PVT;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
324: p_api_version_number,
325: l_api_name,
326: G_PKG_NAME)

Line 532: -- Standard check for p_commit

528: --
529: -- End of API body.
530: --
531:
532: -- Standard check for p_commit
533: IF FND_API.to_Boolean( p_commit )
534: THEN
535: COMMIT WORK;
536: END IF;

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

539: -- Debug Message
540: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
541:
542:
543: -- Standard call to get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get
545: ( p_count => x_msg_count,
546: p_data => x_msg_data
547: );

Line 619: -- Standard Start of API savepoint

615: l_api_name CONSTANT VARCHAR2(30) := 'Delete_orderheaders';
616: l_api_version_number CONSTANT NUMBER := 1.0;
617: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
618: BEGIN
619: -- Standard Start of API savepoint
620: SAVEPOINT DELETE_ORDERHEADERS_PVT;
621:
622: -- Standard call to check for call compatibility.
623: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

618: BEGIN
619: -- Standard Start of API savepoint
620: SAVEPOINT DELETE_ORDERHEADERS_PVT;
621:
622: -- Standard call to check for call compatibility.
623: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
624: p_api_version_number,
625: l_api_name,
626: G_PKG_NAME)

Line 692: -- Standard check for p_commit

688: --
689: -- End of API body
690: --
691:
692: -- Standard check for p_commit
693: IF FND_API.to_Boolean( p_commit )
694: THEN
695: COMMIT WORK;
696: END IF;

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

699: -- Debug Message
700: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
701:
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: FND_MSG_PUB.Count_And_Get
705: ( p_count => x_msg_count,
706: p_data => x_msg_data
707: );

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

1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: end;
1113: END IF;
1114:
1115: -- Standard call to get message count and if count is 1, get message info.
1116: FND_MSG_PUB.Count_And_Get
1117: ( p_count => x_msg_count,
1118: p_data => x_msg_data
1119: );

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

1165: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1166: NULL;
1167: END IF;
1168:
1169: -- Standard call to get message count and if count is 1, get message info.
1170: FND_MSG_PUB.Count_And_Get
1171: ( p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );

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

1212: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1213: NULL;
1214: END IF;
1215:
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: ( p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );

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

1259: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1260: NULL;
1261: END IF;
1262:
1263: -- Standard call to get message count and if count is 1, get message info.
1264: FND_MSG_PUB.Count_And_Get
1265: ( p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );

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

1306: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1307: NULL;
1308: END IF;
1309:
1310: -- Standard call to get message count and if count is 1, get message info.
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );

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

1353: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1354: NULL;
1355: END IF;
1356:
1357: -- Standard call to get message count and if count is 1, get message info.
1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => x_msg_count,
1360: p_data => x_msg_data
1361: );

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

1400: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1401: NULL;
1402: END IF;
1403:
1404: -- Standard call to get message count and if count is 1, get message info.
1405: FND_MSG_PUB.Count_And_Get
1406: ( p_count => x_msg_count,
1407: p_data => x_msg_data
1408: );

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

1447: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1448: NULL;
1449: END IF;
1450:
1451: -- Standard call to get message count and if count is 1, get message info.
1452: FND_MSG_PUB.Count_And_Get
1453: ( p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );

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

1494: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1495: NULL;
1496: END IF;
1497:
1498: -- Standard call to get message count and if count is 1, get message info.
1499: FND_MSG_PUB.Count_And_Get
1500: ( p_count => x_msg_count,
1501: p_data => x_msg_data
1502: );

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

1541: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1542: NULL;
1543: END IF;
1544:
1545: -- Standard call to get message count and if count is 1, get message info.
1546: FND_MSG_PUB.Count_And_Get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );

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

1588: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1589: NULL;
1590: END IF;
1591:
1592: -- Standard call to get message count and if count is 1, get message info.
1593: FND_MSG_PUB.Count_And_Get
1594: ( p_count => x_msg_count,
1595: p_data => x_msg_data
1596: );

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

1635: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1636: NULL;
1637: END IF;
1638:
1639: -- Standard call to get message count and if count is 1, get message info.
1640: FND_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count,
1642: p_data => x_msg_data
1643: );

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

1682: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1683: NULL;
1684: END IF;
1685:
1686: -- Standard call to get message count and if count is 1, get message info.
1687: FND_MSG_PUB.Count_And_Get
1688: ( p_count => x_msg_count,
1689: p_data => x_msg_data
1690: );

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

1729: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1730: NULL;
1731: END IF;
1732:
1733: -- Standard call to get message count and if count is 1, get message info.
1734: FND_MSG_PUB.Count_And_Get
1735: ( p_count => x_msg_count,
1736: p_data => x_msg_data
1737: );

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

1771:
1772: -- Debug Message
1773: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count,
1778: p_data => x_msg_data
1779: );