DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on STANDARD

Line 132: -- Standard begin of API savepoint

128: GROUP BY (NVL(moqd.orig_date_received,moqd.date_received));
129:
130: BEGIN
131:
132: -- Standard begin of API savepoint
133: SAVEPOINT Select_CoveredInventory_PVT;
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call ( l_api_version,
136: p_api_version,

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

130: BEGIN
131:
132: -- Standard begin of API savepoint
133: SAVEPOINT Select_CoveredInventory_PVT;
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call ( l_api_version,
136: p_api_version,
137: l_api_name,
138: G_PKG_NAME)

Line 252: -- Standard check for p_commit

248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: -- Standard check for p_commit
253: IF FND_API.to_Boolean( p_commit )
254: THEN
255: COMMIT WORK;
256: END IF;

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

256: END IF;
257:
258: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
259:
260: -- Standard call to get message count and if count is 1, get message info.
261: FND_MSG_PUB.Count_And_Get
262: (p_count => x_msg_count,
263: p_data => x_msg_data
264: );

Line 272: -- Standard call to get message count and if count=1, get the message

268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO Select_CoveredInventory_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data

Line 288: -- Standard call to get message count and if count=1, get the message

284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: ROLLBACK TO Select_CoveredInventory_PVT;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data

Line 308: -- Standard call to get message count and if count=1, get the message

304: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Select_CoveredInventory');
305: fnd_message.set_token('ERRNO', sqlcode);
306: fnd_message.set_token('REASON', sqlerrm);
307: FND_MSG_PUB.add;
308: -- Standard call to get message count and if count=1, get the message
309: FND_MSG_PUB.Count_And_Get (
310: p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,
312: p_data => x_msg_data

Line 372: -- Standard begin of API savepoint

368: ------------------------------------------
369: -- Initialization
370: ------------------------------------------
371:
372: -- Standard begin of API savepoint
373: SAVEPOINT Populate_CoveredInventory_PVT;
374: -- Standard call to check for call compatibility.
375: IF NOT FND_API.Compatible_API_Call ( l_api_version,
376: p_api_version,

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

370: ------------------------------------------
371:
372: -- Standard begin of API savepoint
373: SAVEPOINT Populate_CoveredInventory_PVT;
374: -- Standard call to check for call compatibility.
375: IF NOT FND_API.Compatible_API_Call ( l_api_version,
376: p_api_version,
377: l_api_name,
378: G_PKG_NAME)

Line 434: -- Standard check for p_commit

430: );
431:
432: x_return_status := l_return_status;
433:
434: -- Standard check for p_commit
435: IF FND_API.to_Boolean( p_commit )
436: THEN
437: COMMIT WORK;
438: END IF;

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

437: COMMIT WORK;
438: END IF;
439:
440: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
441: -- Standard call to get message count and if count is 1, get message info.
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data
445: );

Line 467: -- Standard call to get message count and if count=1, get the message

463:
464: WHEN FND_API.G_EXC_ERROR THEN
465: ROLLBACK TO Populate_CoveredInventory_PVT;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: -- Standard call to get message count and if count=1, get the message
468: FND_MSG_PUB.Count_And_Get (
469: p_encoded => FND_API.G_FALSE,
470: p_count => x_msg_count,
471: p_data => x_msg_data

Line 482: -- Standard call to get message count and if count=1, get the message

478:
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: ROLLBACK TO Populate_CoveredInventory_PVT;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: -- Standard call to get message count and if count=1, get the message
483: FND_MSG_PUB.Count_And_Get (
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data

Line 502: -- Standard call to get message count and if count=1, get the message

498: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Populate_CoveredInventory');
499: fnd_message.set_token('ERRNO', sqlcode);
500: fnd_message.set_token('REASON', sqlerrm);
501: FND_MSG_PUB.add;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data

Line 557: -- Standard begin of API savepoint

553:
554: inventory_details_ids inventory_details_id_tbl;
555:
556: BEGIN
557: -- Standard begin of API savepoint
558: SAVEPOINT Update_CoveredInventory_PVT;
559: -- Standard call to check for call compatibility.
560: IF NOT FND_API.Compatible_API_Call ( l_api_version,
561: p_api_version,

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

555:
556: BEGIN
557: -- Standard begin of API savepoint
558: SAVEPOINT Update_CoveredInventory_PVT;
559: -- Standard call to check for call compatibility.
560: IF NOT FND_API.Compatible_API_Call ( l_api_version,
561: p_api_version,
562: l_api_name,
563: G_PKG_NAME)

Line 880: -- Standard check for p_commit

876: END IF;
877:
878:
879: x_return_status := l_return_status;
880: -- Standard check for p_commit
881: IF FND_API.to_Boolean(p_commit) THEN
882: COMMIT WORK;
883: END IF;
884:

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

883: END IF;
884:
885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
886:
887: -- Standard call to get message count and if count is 1, get message info.
888: FND_MSG_PUB.Count_And_Get
889: (p_count => x_msg_count,
890: p_data => x_msg_data
891: );

Line 913: -- Standard call to get message count and if count=1, get the message

909:
910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO Update_CoveredInventory_PVT;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: -- Standard call to get message count and if count=1, get the message
914: FND_MSG_PUB.Count_And_Get (
915: p_encoded => FND_API.G_FALSE,
916: p_count => x_msg_count,
917: p_data => x_msg_data

Line 928: -- Standard call to get message count and if count=1, get the message

924:
925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
926: ROLLBACK TO Update_CoveredInventory_PVT;
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: -- Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data

Line 948: -- Standard call to get message count and if count=1, get the message

944: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: -- Standard call to get message count and if count=1, get the message
949: FND_MSG_PUB.Count_And_Get (
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data