[Home] [Help]
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,
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)
250: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:
254: -- Standard check for p_commit
255: IF FND_API.to_Boolean( p_commit )
256: THEN
257: COMMIT WORK;
258: END IF;
259: -- Debug Message
260: IF g_debug THEN
261: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
262: END IF;
263: -- Standard call to get message count and if count is 1, get message info.
264: FND_MSG_PUB.Count_And_Get
265: (p_count => x_msg_count,
266: p_data => x_msg_data
267: );
271:
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO Select_CoveredInventory_PVT;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: -- Standard call to get message count and if count=1, get the message
276: FND_MSG_PUB.Count_And_Get (
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data
287:
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: ROLLBACK TO Select_CoveredInventory_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: -- Standard call to get message count and if count=1, get the message
292: FND_MSG_PUB.Count_And_Get (
293: p_encoded => FND_API.G_FALSE,
294: p_count => x_msg_count,
295: p_data => x_msg_data
307: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Select_CoveredInventory');
308: fnd_message.set_token('ERRNO', sqlcode);
309: fnd_message.set_token('REASON', sqlerrm);
310: FND_MSG_PUB.add;
311: -- Standard call to get message count and if count=1, get the message
312: FND_MSG_PUB.Count_And_Get (
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_msg_count,
315: p_data => x_msg_data
371: ------------------------------------------
372: -- Initialization
373: ------------------------------------------
374:
375: -- Standard begin of API savepoint
376: SAVEPOINT Populate_CoveredInventory_PVT;
377: -- Standard call to check for call compatibility.
378: IF NOT FND_API.Compatible_API_Call ( l_api_version,
379: p_api_version,
373: ------------------------------------------
374:
375: -- Standard begin of API savepoint
376: SAVEPOINT Populate_CoveredInventory_PVT;
377: -- Standard call to check for call compatibility.
378: IF NOT FND_API.Compatible_API_Call ( l_api_version,
379: p_api_version,
380: l_api_name,
381: G_PKG_NAME)
436: );
437:
438: x_return_status := l_return_status;
439:
440: -- Standard check for p_commit
441: IF FND_API.to_Boolean( p_commit )
442: THEN
443: COMMIT WORK;
444: END IF;
445: -- Debug Message
446: IF g_debug THEN
447: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
448: END IF;
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get
451: (p_count => x_msg_count,
452: p_data => x_msg_data
453: );
471:
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO Populate_CoveredInventory_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data
486:
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488: ROLLBACK TO Populate_CoveredInventory_PVT;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
506: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Populate_CoveredInventory');
507: fnd_message.set_token('ERRNO', sqlcode);
508: fnd_message.set_token('REASON', sqlerrm);
509: FND_MSG_PUB.add;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data
558:
559: inventory_details_ids inventory_details_id_tbl;
560:
561: BEGIN
562: -- Standard begin of API savepoint
563: SAVEPOINT Update_CoveredInventory_PVT;
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version,
566: p_api_version,
560:
561: BEGIN
562: -- Standard begin of API savepoint
563: SAVEPOINT Update_CoveredInventory_PVT;
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version,
566: p_api_version,
567: l_api_name,
568: G_PKG_NAME)
819: END IF;
820: END IF;
821:
822: x_return_status := l_return_status;
823: -- Standard check for p_commit
824: IF FND_API.to_Boolean(p_commit) THEN
825: COMMIT WORK;
826: END IF;
827: -- Debug Message
827: -- Debug Message
828: IF g_debug THEN
829: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
830: END IF;
831: -- Standard call to get message count and if count is 1, get message info.
832: FND_MSG_PUB.Count_And_Get
833: (p_count => x_msg_count,
834: p_data => x_msg_data
835: );
853:
854: WHEN FND_API.G_EXC_ERROR THEN
855: ROLLBACK TO Update_CoveredInventory_PVT;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: -- Standard call to get message count and if count=1, get the message
858: FND_MSG_PUB.Count_And_Get (
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data
868:
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: ROLLBACK TO Update_CoveredInventory_PVT;
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
872: -- Standard call to get message count and if count=1, get the message
873: FND_MSG_PUB.Count_And_Get (
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_msg_count,
876: p_data => x_msg_data
888: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory');
889: fnd_message.set_token('ERRNO', sqlcode);
890: fnd_message.set_token('REASON', sqlerrm);
891: FND_MSG_PUB.add;
892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get (
894: p_encoded => FND_API.G_FALSE,
895: p_count => x_msg_count,
896: p_data => x_msg_data