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 FND_MSG_PUB

Line 11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

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: ---------------------------------------------------------------------
15: -- PROCEDURE

Line 80: FND_MSG_PUB.initialize;

76: END IF;
77: -- Initialize message list if p_init_msg_list is set to TRUE.
78: IF FND_API.to_Boolean( p_init_msg_list )
79: THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Debug Message
84: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');

Line 96: FND_MSG_PUB.add;

92:
93: IF p_user_id IS NULL THEN
94: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
95: FND_MESSAGE.set_token('ID', 'User ID');
96: FND_MSG_PUB.add;
97: RAISE FND_API.G_EXC_ERROR;
98: ELSIF p_process_code IS NULL THEN
99: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
100: FND_MESSAGE.set_token('ID', 'Process Code');

Line 101: FND_MSG_PUB.add;

97: RAISE FND_API.G_EXC_ERROR;
98: ELSIF p_process_code IS NULL THEN
99: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
100: FND_MESSAGE.set_token('ID', 'Process Code');
101: FND_MSG_PUB.add;
102: RAISE FND_API.G_EXC_ERROR;
103: ELSIF p_execution_detail_id IS NULL THEN
104: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
105: FND_MESSAGE.set_token('ID', 'Execution Detail ID');

Line 106: FND_MSG_PUB.add;

102: RAISE FND_API.G_EXC_ERROR;
103: ELSIF p_execution_detail_id IS NULL THEN
104: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
105: FND_MESSAGE.set_token('ID', 'Execution Detail ID');
106: FND_MSG_PUB.add;
107: RAISE FND_API.G_EXC_ERROR;
108: END IF;
109:
110: BEGIN

Line 169: FND_MSG_PUB.add;

165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
168: FND_MESSAGE.set_token('ID', 'Language Code');
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');

Line 176: FND_MSG_PUB.add;

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;
178: END;
179: END IF;
180:

Line 217: FND_MSG_PUB.Count_And_Get

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: );
221:

Line 228: FND_MSG_PUB.Count_And_Get (

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
232: );

Line 235: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

231: p_data => x_msg_data
232: );
233: IF x_msg_count > 1 THEN
234: FOR I IN 1..x_msg_count LOOP
235: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
236: END LOOP;
237: END IF;
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239:

Line 242: FND_MSG_PUB.Count_And_Get (

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
246: );

Line 249: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

245: p_data => x_msg_data
246: );
247: IF x_msg_count > 1 THEN
248: FOR I IN 1..x_msg_count LOOP
249: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
250: END LOOP;
251: END IF;
252: WHEN OTHERS THEN
253:

Line 259: FND_MSG_PUB.ADD;

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));
261:
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (

Line 263: FND_MSG_PUB.Count_And_Get (

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
267: );

Line 270: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

266: p_data => x_msg_data
267: );
268: IF x_msg_count > 1 THEN
269: FOR I IN 1..x_msg_count LOOP
270: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
271: END LOOP;
272: END IF;
273: END Create_FormattedOutput;
274:

Line 323: FND_MSG_PUB.add;

319:
320: IF p_message_name IS NULL THEN
321: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
322: FND_MESSAGE.set_token('ID', 'Message Name');
323: FND_MSG_PUB.add;
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF p_application_short_name IS NULL THEN
326: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
327: FND_MESSAGE.set_token('ID', 'Application Short Name');

Line 328: FND_MSG_PUB.add;

324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF p_application_short_name IS NULL THEN
326: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
327: FND_MESSAGE.set_token('ID', 'Application Short Name');
328: FND_MSG_PUB.add;
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:
332: IF p_language_code IS NOT NULL THEN

Line 352: FND_MSG_PUB.add;

348: EXCEPTION
349: WHEN NO_DATA_FOUND THEN
350: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
351: FND_MESSAGE.set_token('ID', 'Language Code');
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');

Line 359: FND_MSG_PUB.add;

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;
361: END;
362: WHEN OTHERS THEN
363: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 367: FND_MSG_PUB.add;

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;
369: END;
370: --FND_GLOBAL.set_nls(p_nls_language => l_language_code);
371: fnd_global.set_nls_context(p_nls_language => l_language_code);

Line 401: FND_MSG_PUB.Count_And_Get (

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
405: );

Line 408: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);

404: p_data => x_msg_data
405: );
406: IF x_msg_count > 1 THEN
407: FOR I IN 1..x_msg_count LOOP
408: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
409: END LOOP;
410: END IF;
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412:

Line 415: FND_MSG_PUB.Count_And_Get (

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
419: );

Line 422: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);

418: p_data => x_msg_data
419: );
420: IF x_msg_count > 1 THEN
421: FOR I IN 1..x_msg_count LOOP
422: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
423: END LOOP;
424: END IF;
425: WHEN OTHERS THEN
426:

Line 432: FND_MSG_PUB.ADD;

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));
434:
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (

Line 436: FND_MSG_PUB.Count_And_Get (

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
440: );

Line 443: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);

439: p_data => x_msg_data
440: );
441: IF x_msg_count > 1 THEN
442: FOR I IN 1..x_msg_count LOOP
443: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
444: END LOOP;
445: END IF;
446: END Select_Message_Text;
447:

Line 492: FND_MSG_PUB.add;

488:
489: IF p_execution_detail_id IS NULL THEN
490: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
491: FND_MESSAGE.set_token('ID', 'Execution Detail ID');
492: FND_MSG_PUB.add;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: -- x_output_type := fnd_profile.VALUE('DPP_NOTIFICATION_REPORT_TYPE');

Line 506: FND_MSG_PUB.add;

502:
503: IF x_formatted_output IS NULL THEN
504: FND_MESSAGE.set_name('DPP', 'DPP_OUTPUT_NOT_CREATED');
505: FND_MESSAGE.set_token('REQID', p_execution_detail_id); -- change token name later
506: FND_MSG_PUB.add;
507: -- Debug Message
508: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Output was not created by Request');
509:
510: RAISE FND_API.G_EXC_ERROR;

Line 523: FND_MSG_PUB.Count_And_Get (

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
527: );

Line 530: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);

526: p_data => x_msg_data
527: );
528: IF x_msg_count > 1 THEN
529: FOR I IN 1..x_msg_count LOOP
530: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
531: END LOOP;
532: END IF;
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534:

Line 537: FND_MSG_PUB.Count_And_Get (

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
541: );

Line 544: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);

540: p_data => x_msg_data
541: );
542: IF x_msg_count > 1 THEN
543: FOR I IN 1..x_msg_count LOOP
544: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
545: END LOOP;
546: END IF;
547: WHEN OTHERS THEN
548:

Line 554: FND_MSG_PUB.ADD;

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));
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,

Line 557: FND_MSG_PUB.Count_And_Get (

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
561: );

Line 564: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);

560: p_data => x_msg_data
561: );
562: IF x_msg_count > 1 THEN
563: FOR I IN 1..x_msg_count LOOP
564: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
565: END LOOP;
566: END IF;
567: END Get_FormattedOutput;
568: