DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on STANDARD

Line 122: -- Standard begin of API savepoint

118:
119: BEGIN
120:
121:
122: -- Standard begin of API savepoint
123: SAVEPOINT Select_CustomerPrice_PVT;
124: -- Standard call to check for call compatibility.
125: IF NOT FND_API.Compatible_API_Call ( l_api_version,
126: p_api_version,

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

120:
121:
122: -- Standard begin of API savepoint
123: SAVEPOINT Select_CustomerPrice_PVT;
124: -- Standard call to check for call compatibility.
125: IF NOT FND_API.Compatible_API_Call ( l_api_version,
126: p_api_version,
127: l_api_name,
128: G_PKG_NAME)

Line 226: -- Standard check for p_commit

222:
223: p_customer_tbl := l_customer_tbl;
224: x_return_status := l_return_status;
225: END IF;
226: -- Standard check for p_commit
227: IF FND_API.to_Boolean( p_commit )
228: THEN
229: COMMIT WORK;
230: END IF;

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

231: -- Debug Message
232:
233: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
234:
235: -- Standard call to get message count and if count is 1, get message info.
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,
238: p_data => x_msg_data
239: );

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

244:
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO Select_CustomerPrice_PVT;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data

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

259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: ROLLBACK TO Select_CustomerPrice_PVT;
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: -- Standard call to get message count and if count=1, get the message
264: FND_MSG_PUB.Count_And_Get (
265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data

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

279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
280: fnd_message.set_token('ERRNO', sqlcode);
281: fnd_message.set_token('REASON', sqlerrm);
282: FND_MSG_PUB.add;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data

Line 363: -- Standard begin of API savepoint

359: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.POPULATE_CUSTOMERPRICE';
360: l_profile_option_value VARCHAR2(20);
361:
362: BEGIN
363: -- Standard begin of API savepoint
364: SAVEPOINT Populate_CustomerPrice_PVT;
365: -- Standard call to check for call compatibility.
366: IF NOT FND_API.Compatible_API_Call ( l_api_version,
367: p_api_version,

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

361:
362: BEGIN
363: -- Standard begin of API savepoint
364: SAVEPOINT Populate_CustomerPrice_PVT;
365: -- Standard call to check for call compatibility.
366: IF NOT FND_API.Compatible_API_Call ( l_api_version,
367: p_api_version,
368: l_api_name,
369: G_PKG_NAME)

Line 651: -- Standard check for p_commit

647: END IF; --l_customer_tbl.EXISTS(1)
648: END IF; --l_cust_hdr_rec.org_id IS NULL
649:
650: x_return_status := l_return_status;
651: -- Standard check for p_commit
652: IF FND_API.to_Boolean( p_commit )
653: THEN
654: COMMIT WORK;
655: END IF;

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

656: -- Debug Message
657:
658: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
659:
660: -- Standard call to get message count and if count is 1, get message info.
661: FND_MSG_PUB.Count_And_Get
662: (p_count => x_msg_count,
663: p_data => x_msg_data
664: );

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

688:
689: WHEN FND_API.G_EXC_ERROR THEN
690: ROLLBACK TO Populate_CustomerPrice_PVT;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: -- Standard call to get message count and if count=1, get the message
693: FND_MSG_PUB.Count_And_Get (
694: p_encoded => FND_API.G_FALSE,
695: p_count => x_msg_count,
696: p_data => x_msg_data

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

703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO Populate_CustomerPrice_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,
711: p_data => x_msg_data

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

725: fnd_message.set_token('REASON', sqlerrm);
726: FND_MSG_PUB.ADD;
727: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);
728:
729: -- Standard call to get message count and if count=1, get the message
730: FND_MSG_PUB.Count_And_Get (
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,
733: p_data => x_msg_data