DBA Data[Home] [Help]

APPS.CSP_PACKLIST_HEADERS_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_Packlist_Headers_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_Packlist_Headers_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 318: -- Standard Start of API savepoint

314: l_ref_PLH_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
315: l_tar_PLH_rec CSP_packlist_headers_PVT.PLH_Rec_Type := P_PLH_Rec;
316: l_rowid ROWID;
317: BEGIN
318: -- Standard Start of API savepoint
319: SAVEPOINT UPDATE_Packlist_Headers_PVT;
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: p_api_version_number,

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

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

Line 526: -- Standard check for p_commit

522: p_ATTRIBUTE15 => p_PLH_rec.ATTRIBUTE15);
523: --
524: -- End of API body.
525: --
526: -- Standard check for p_commit
527: IF FND_API.to_Boolean( p_commit )
528: THEN
529: COMMIT WORK;
530: END IF;

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

533: -- Debug Message
534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
535:
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get
539: ( p_count => x_msg_count,
540: p_data => x_msg_data
541: );

Line 613: -- Standard Start of API savepoint

609: l_api_name CONSTANT VARCHAR2(30) := 'Delete_packlist_headers';
610: l_api_version_number CONSTANT NUMBER := 1.0;
611: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
612: BEGIN
613: -- Standard Start of API savepoint
614: SAVEPOINT DELETE_Packlist_Headers_PVT;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

612: BEGIN
613: -- Standard Start of API savepoint
614: SAVEPOINT DELETE_Packlist_Headers_PVT;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)

Line 684: -- Standard check for p_commit

680: --
681: -- End of API body
682: --
683:
684: -- Standard check for p_commit
685: IF FND_API.to_Boolean( p_commit )
686: THEN
687: COMMIT WORK;
688: END IF;

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

691: -- Debug Message
692: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
693:
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get
697: ( p_count => x_msg_count,
698: p_data => x_msg_data
699: );

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

1118: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1119: NULL;
1120: END IF;
1121:
1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get
1124: ( p_count => x_msg_count,
1125: p_data => x_msg_data
1126: );

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

1173: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1174: NULL;
1175: END IF;
1176:
1177: -- Standard call to get message count and if count is 1, get message info.
1178: FND_MSG_PUB.Count_And_Get
1179: ( p_count => x_msg_count,
1180: p_data => x_msg_data
1181: );

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

1228: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1229: NULL;
1230: END IF;
1231:
1232: -- Standard call to get message count and if count is 1, get message info.
1233: FND_MSG_PUB.Count_And_Get
1234: ( p_count => x_msg_count,
1235: p_data => x_msg_data
1236: );

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

1283: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1284: NULL;
1285: END IF;
1286:
1287: -- Standard call to get message count and if count is 1, get message info.
1288: FND_MSG_PUB.Count_And_Get
1289: ( p_count => x_msg_count,
1290: p_data => x_msg_data
1291: );

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

1338: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1339: NULL;
1340: END IF;
1341:
1342: -- Standard call to get message count and if count is 1, get message info.
1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data
1346: );

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

1393: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1394: NULL;
1395: END IF;
1396:
1397: -- Standard call to get message count and if count is 1, get message info.
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );

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

1440: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1441: NULL;
1442: END IF;
1443:
1444: -- Standard call to get message count and if count is 1, get message info.
1445: FND_MSG_PUB.Count_And_Get
1446: ( p_count => x_msg_count,
1447: p_data => x_msg_data
1448: );

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

1487: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1488: NULL;
1489: END IF;
1490:
1491: -- Standard call to get message count and if count is 1, get message info.
1492: FND_MSG_PUB.Count_And_Get
1493: ( p_count => x_msg_count,
1494: p_data => x_msg_data
1495: );

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

1534: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1535: NULL;
1536: END IF;
1537:
1538: -- Standard call to get message count and if count is 1, get message info.
1539: FND_MSG_PUB.Count_And_Get
1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );

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

1581: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1582: NULL;
1583: END IF;
1584:
1585: -- Standard call to get message count and if count is 1, get message info.
1586: FND_MSG_PUB.Count_And_Get
1587: ( p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );

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

1628: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1629: NULL;
1630: END IF;
1631:
1632: -- Standard call to get message count and if count is 1, get message info.
1633: FND_MSG_PUB.Count_And_Get
1634: ( p_count => x_msg_count,
1635: p_data => x_msg_data
1636: );

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

1675: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1676: NULL;
1677: END IF;
1678:
1679: -- Standard call to get message count and if count is 1, get message info.
1680: FND_MSG_PUB.Count_And_Get
1681: ( p_count => x_msg_count,
1682: p_data => x_msg_data
1683: );

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

1722: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1723: NULL;
1724: END IF;
1725:
1726: -- Standard call to get message count and if count is 1, get message info.
1727: FND_MSG_PUB.Count_And_Get
1728: ( p_count => x_msg_count,
1729: p_data => x_msg_data
1730: );

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

1763:
1764: -- Debug Message
1765: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1766:
1767: -- Standard call to get message count and if count is 1, get message info.
1768: FND_MSG_PUB.Count_And_Get
1769: ( p_count => x_msg_count,
1770: p_data => x_msg_data
1771: );