DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on STANDARD

Line 121: -- Standard begin of API savepoint

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

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

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

Line 225: -- Standard check for p_commit

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

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

230: -- Debug Message
231: IF g_debug THEN
232: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
233: END IF;
234: -- Standard call to get message count and if count is 1, get message info.
235: FND_MSG_PUB.Count_And_Get
236: (p_count => x_msg_count,
237: p_data => x_msg_data
238: );

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

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

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

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

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

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

Line 360: -- Standard begin of API savepoint

356: l_last_price NUMBER;
357: l_rounding NUMBER := fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION');
358:
359: BEGIN
360: -- Standard begin of API savepoint
361: SAVEPOINT Populate_CustomerPrice_PVT;
362: -- Standard call to check for call compatibility.
363: IF NOT FND_API.Compatible_API_Call ( l_api_version,
364: p_api_version,

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

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

Line 644: -- Standard check for p_commit

640: END IF; --l_customer_tbl.EXISTS(1)
641: END IF; --l_cust_hdr_rec.org_id IS NULL
642:
643: x_return_status := l_return_status;
644: -- Standard check for p_commit
645: IF FND_API.to_Boolean( p_commit )
646: THEN
647: COMMIT WORK;
648: END IF;

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

649: -- Debug Message
650: IF g_debug THEN
651: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
652: END IF;
653: -- Standard call to get message count and if count is 1, get message info.
654: FND_MSG_PUB.Count_And_Get
655: (p_count => x_msg_count,
656: p_data => x_msg_data
657: );

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

681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Populate_CustomerPrice_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data

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

696:
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO Populate_CustomerPrice_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data

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

718: fnd_message.set_token('REASON', sqlerrm);
719: FND_MSG_PUB.ADD;
720: DPP_UTILITY_PVT.debug_message('Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);
721:
722: -- Standard call to get message count and if count=1, get the message
723: FND_MSG_PUB.Count_And_Get (
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data