DBA Data[Home] [Help]

APPS.DPP_NOTIFICATION_PVT dependencies on STANDARD

Line 66: -- Standard begin of API savepoint

62: l_notif_territory VARCHAR2(240) := p_notif_territory;
63:
64: BEGIN
65:
66: -- Standard begin of API savepoint
67: SAVEPOINT Create_FormattedOutput_PVT;
68: -- Standard call to check for call compatibility.
69: IF NOT FND_API.Compatible_API_Call ( l_api_version,
70: p_api_version,

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

64: BEGIN
65:
66: -- Standard begin of API savepoint
67: SAVEPOINT Create_FormattedOutput_PVT;
68: -- Standard call to check for call compatibility.
69: IF NOT FND_API.Compatible_API_Call ( l_api_version,
70: p_api_version,
71: l_api_name,
72: G_PKG_NAME)

Line 209: -- Standard check for p_commit

205:
206:
207: x_return_status := l_return_status;
208:
209: -- Standard check for p_commit
210: IF FND_API.to_Boolean( p_commit )
211: THEN
212: COMMIT WORK;
213: END IF;

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

215: -- Debug Message
216: IF g_debug THEN
217: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
218: END IF;
219: -- Standard call to get message count and if count is 1, get message info.
220: FND_MSG_PUB.Count_And_Get
221: (p_count => x_msg_count,
222: p_data => x_msg_data
223: );

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

226: --Exception Handling
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data

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

240: END IF;
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data

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

261: fnd_message.set_token('REASON', sqlerrm);
262: FND_MSG_PUB.ADD;
263: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));
264:
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data

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

400: --Exception Handling
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data

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

414: END IF;
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416:
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: -- Standard call to get message count and if count=1, get the message
419: FND_MSG_PUB.Count_And_Get (
420: p_encoded => FND_API.G_FALSE,
421: p_count => x_msg_count,
422: p_data => x_msg_data

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

435: fnd_message.set_token('REASON', sqlerrm);
436: FND_MSG_PUB.ADD;
437: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));
438:
439: -- Standard call to get message count and if count=1, get the message
440: FND_MSG_PUB.Count_And_Get (
441: p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data

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

524: --Exception Handling
525: EXCEPTION
526: WHEN FND_API.G_EXC_ERROR THEN
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: -- Standard call to get message count and if count=1, get the message
529: FND_MSG_PUB.Count_And_Get (
530: p_encoded => FND_API.G_FALSE,
531: p_count => x_msg_count,
532: p_data => x_msg_data

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

538: END IF;
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540:
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: -- Standard call to get message count and if count=1, get the message
543: FND_MSG_PUB.Count_And_Get (
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data

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

558: fnd_message.set_token('ERRNO', sqlcode);
559: fnd_message.set_token('REASON', sqlerrm);
560: FND_MSG_PUB.ADD;
561: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));
562: -- Standard call to get message count and if count=1, get the message
563: FND_MSG_PUB.Count_And_Get (
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_msg_count,
566: p_data => x_msg_data