eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_NOTIFICATION_PVT dependencies on DPP_NOTIFICATION_PVT

Line 1: PACKAGE BODY DPP_NOTIFICATION_PVT AS

1: PACKAGE BODY DPP_NOTIFICATION_PVT AS
2: /* $Header: dppvnotb.pls 120.24 2008/05/29 06:21:44 sdasan noship $ */
3:
4: -- Package name : DPP_NOTIFICATION_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_NOTIFICATION_PVT

1: PACKAGE BODY DPP_NOTIFICATION_PVT AS
2: /* $Header: dppvnotb.pls 120.24 2008/05/29 06:21:44 sdasan noship $ */
3:
4: -- Package name : DPP_NOTIFICATION_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_NOTIFICATION_PVT';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_NOTIFICATION_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvnotb.pls';
13:
14: ---------------------------------------------------------------------

Line 175: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');

171: FND_MSG_PUB.add;
172: RAISE FND_API.G_EXC_ERROR;
173: WHEN OTHERS THEN
174: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
175: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');
176: fnd_message.set_token('ERRNO', sqlcode);
177: fnd_message.set_token('REASON', sqlerrm);
178: FND_MSG_PUB.add;
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 259: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Create_FormattedOutput');

255: WHEN OTHERS THEN
256:
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
259: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Create_FormattedOutput');
260: fnd_message.set_token('ERRNO', sqlcode);
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));

Line 263: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));

259: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Create_FormattedOutput');
260: fnd_message.set_token('ERRNO', sqlcode);
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,

Line 311: l_message_token DPP_NOTIFICATION_PVT.message_tokens_tbl_type := p_message_token;

307: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name
308: ||'.'
309: ||l_api_name;
310: l_return_status VARCHAR2(1);
311: l_message_token DPP_NOTIFICATION_PVT.message_tokens_tbl_type := p_message_token;
312: l_language_code VARCHAR2(10);
313:
314: BEGIN
315:

Line 359: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');

355: FND_MSG_PUB.add;
356: RAISE FND_API.G_EXC_ERROR;
357: WHEN OTHERS THEN
358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
359: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');
360: fnd_message.set_token('ERRNO', sqlcode);
361: fnd_message.set_token('REASON', sqlerrm);
362: FND_MSG_PUB.add;
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 367: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');

363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END;
365: WHEN OTHERS THEN
366: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
367: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');
368: fnd_message.set_token('ERRNO', sqlcode);
369: fnd_message.set_token('REASON', sqlerrm);
370: FND_MSG_PUB.add;
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 433: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Select_Message_Text');

429: WHEN OTHERS THEN
430:
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
433: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Select_Message_Text');
434: fnd_message.set_token('ERRNO', sqlcode);
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));

Line 437: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));

433: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Select_Message_Text');
434: fnd_message.set_token('ERRNO', sqlcode);
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,

Line 557: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Get_FormattedOutput');

553: WHEN OTHERS THEN
554:
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
557: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Get_FormattedOutput');
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));

Line 561: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));

557: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Get_FormattedOutput');
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,

Line 575: END DPP_NOTIFICATION_PVT;

571: END LOOP;
572: END IF;
573: END Get_FormattedOutput;
574:
575: END DPP_NOTIFICATION_PVT;