DBA Data[Home] [Help]

APPS.DPP_NOTIFICATION_PVT dependencies on STANDARD

Line 67: -- Standard begin of API savepoint

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

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

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

Line 207: -- Standard check for p_commit

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

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

212:
213: -- Debug Message
214: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');
215:
216: -- Standard call to get message count and if count is 1, get message info.
217: FND_MSG_PUB.Count_And_Get
218: (p_count => x_msg_count,
219: p_data => x_msg_data
220: );

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

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

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

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

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

258: fnd_message.set_token('REASON', sqlerrm);
259: FND_MSG_PUB.ADD;
260: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));
261:
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 400: -- Standard call to get message count and if count=1, get the message

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

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

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

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

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

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

518: --Exception Handling
519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data

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

532: END IF;
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534:
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data

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

552: fnd_message.set_token('ERRNO', sqlcode);
553: fnd_message.set_token('REASON', sqlerrm);
554: FND_MSG_PUB.ADD;
555: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));
556: -- Standard call to get message count and if count=1, get the message
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => FND_API.G_FALSE,
559: p_count => x_msg_count,
560: p_data => x_msg_data