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.12010000.2 2010/04/21 11:34:32 anbbalas ship $ */
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.12010000.2 2010/04/21 11:34:32 anbbalas ship $ */
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 49: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.CREATE_FORMATTEDOUTPUT';

45: l_api_version CONSTANT NUMBER := 1.0;
46: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME
47: ||'.'
48: ||L_API_NAME;
49: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.CREATE_FORMATTEDOUTPUT';
50: l_return_status VARCHAR2(1);
51: l_req_id NUMBER := 0;
52: l_wait_req BOOLEAN;
53: l_cancel_req_out BOOLEAN;

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

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

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

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

Line 260: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));

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

Line 307: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.SELECT_MESSAGE_TEXT';

303: l_api_version CONSTANT NUMBER := 1.0;
304: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name
305: ||'.'
306: ||l_api_name;
307: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.SELECT_MESSAGE_TEXT';
308: l_return_status VARCHAR2(1);
309: l_message_token DPP_NOTIFICATION_PVT.message_tokens_tbl_type := p_message_token;
310: l_language_code VARCHAR2(10);
311:

Line 309: l_message_token DPP_NOTIFICATION_PVT.message_tokens_tbl_type := p_message_token;

305: ||'.'
306: ||l_api_name;
307: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.SELECT_MESSAGE_TEXT';
308: l_return_status VARCHAR2(1);
309: l_message_token DPP_NOTIFICATION_PVT.message_tokens_tbl_type := p_message_token;
310: l_language_code VARCHAR2(10);
311:
312: BEGIN
313:

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

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

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

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

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

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

Line 433: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));

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

Line 479: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.GET_FORMATTEDOUTPUT';

475: l_api_version CONSTANT NUMBER := 1.0;
476: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name
477: ||'.'
478: ||l_api_name;
479: l_module VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.GET_FORMATTEDOUTPUT';
480: l_return_status VARCHAR2(1);
481: BEGIN
482:
483: -- Debug Message

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

547: WHEN OTHERS THEN
548:
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
551: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Get_FormattedOutput');
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));

Line 555: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));

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

Line 569: END DPP_NOTIFICATION_PVT;

565: END LOOP;
566: END IF;
567: END Get_FormattedOutput;
568:
569: END DPP_NOTIFICATION_PVT;