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 79: FND_MSG_PUB.initialize;

75: END IF;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list )
78: THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:
82: -- Debug Message
83: IF g_debug THEN

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 171: FND_MSG_PUB.add;

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

Line 178: FND_MSG_PUB.add;

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;
180: END;
181: END IF;
182:

Line 220: FND_MSG_PUB.Count_And_Get

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

Line 231: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 245: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 262: FND_MSG_PUB.ADD;

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

Line 266: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 326: FND_MSG_PUB.add;

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

Line 331: FND_MSG_PUB.add;

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

Line 355: FND_MSG_PUB.add;

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

Line 362: FND_MSG_PUB.add;

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;
364: END;
365: WHEN OTHERS THEN
366: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 370: FND_MSG_PUB.add;

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;
372: END;
373: --FND_GLOBAL.set_nls(p_nls_language => l_language_code);
374: fnd_global.set_nls_context(p_nls_language => l_language_code);

Line 405: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 419: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 436: FND_MSG_PUB.ADD;

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

Line 440: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 496: FND_MSG_PUB.add;

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

Line 510: FND_MSG_PUB.add;

506:
507: IF x_formatted_output IS NULL THEN
508: FND_MESSAGE.set_name('DPP', 'DPP_OUTPUT_NOT_CREATED');
509: FND_MESSAGE.set_token('REQID', p_execution_detail_id); -- change token name later
510: FND_MSG_PUB.add;
511: -- Debug Message
512: IF g_debug THEN
513: DPP_UTILITY_PVT.debug_message('Formatted Output was not created by Request');
514: END IF;

Line 529: FND_MSG_PUB.Count_And_Get (

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

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

532: p_data => x_msg_data
533: );
534: IF x_msg_count > 1 THEN
535: FOR I IN 1..x_msg_count LOOP
536: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
537: END LOOP;
538: END IF;
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540:

Line 543: FND_MSG_PUB.Count_And_Get (

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

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

546: p_data => x_msg_data
547: );
548: IF x_msg_count > 1 THEN
549: FOR I IN 1..x_msg_count LOOP
550: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
551: END LOOP;
552: END IF;
553: WHEN OTHERS THEN
554:

Line 560: FND_MSG_PUB.ADD;

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

Line 563: FND_MSG_PUB.Count_And_Get (

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

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

566: p_data => x_msg_data
567: );
568: IF x_msg_count > 1 THEN
569: FOR I IN 1..x_msg_count LOOP
570: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
571: END LOOP;
572: END IF;
573: END Get_FormattedOutput;
574: