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_API

Line 30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

26: ----------------------------------------------------------------------
27:
28: PROCEDURE Create_Formattedoutput
29: (p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,

Line 31: p_commit IN VARCHAR2 := FND_API.G_FALSE,

27:
28: PROCEDURE Create_Formattedoutput
29: (p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2,

Line 32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

28: PROCEDURE Create_Formattedoutput
29: (p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2,
36: p_execution_detail_id IN NUMBER,

Line 69: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: p_api_version,
71: l_api_name,
72: G_PKG_NAME)
73: THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 77: IF FND_API.to_Boolean( p_init_msg_list )

73: THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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:

Line 87: l_return_status := FND_API.G_RET_STS_SUCCESS;

83: IF g_debug THEN
84: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
85: END IF;
86: -- Initialize API return status to sucess
87: l_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: --
90: -- API body
91: --

Line 97: RAISE FND_API.G_EXC_ERROR;

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');
101: FND_MSG_PUB.add;

Line 102: 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');
106: FND_MSG_PUB.add;

Line 107: 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
111: SELECT u.RESPONSIBILITY_ID,

Line 124: RAISE FND_API.G_EXC_ERROR;

120: AND ROWNUM = 1;
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for User');
124: RAISE FND_API.G_EXC_ERROR;
125: END;
126:
127: FND_GLOBAL.APPS_INITIALIZE(p_user_id,l_responsibility_id,l_application_id);
128:

Line 172: RAISE FND_API.G_EXC_ERROR;

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');
176: fnd_message.set_token('ERRNO', sqlcode);

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_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:
183: l_req_id := FND_REQUEST.submit_request(

Line 202: RAISE FND_API.G_EXC_ERROR;

198:
199: IF l_req_id = 0 THEN
200:
201: DPP_UTILITY_PVT.debug_message('Error in Conc Request Submission');
202: RAISE FND_API.G_EXC_ERROR;
203:
204: END IF;
205:
206:

Line 210: IF FND_API.to_Boolean( p_commit )

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

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224:
225:
226: --Exception Handling
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,

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225:
226: --Exception Handling
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,

Line 232: p_encoded => FND_API.G_FALSE,

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: );
236: IF x_msg_count > 1 THEN

Line 241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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:
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 (

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

239: END LOOP;
240: END IF;
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,

Line 246: p_encoded => FND_API.G_FALSE,

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: );
250: IF x_msg_count > 1 THEN

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: END LOOP;
254: END IF;
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);

Line 267: p_encoded => FND_API.G_FALSE,

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: );
271: IF x_msg_count > 1 THEN

Line 321: l_return_status := FND_API.G_RET_STS_SUCCESS;

317: IF g_debug THEN
318: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
319: END IF;
320: -- Initialize API return status to sucess
321: l_return_status := FND_API.G_RET_STS_SUCCESS;
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');

Line 327: RAISE FND_API.G_EXC_ERROR;

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');
331: FND_MSG_PUB.add;

Line 332: 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
336: BEGIN

Line 356: RAISE FND_API.G_EXC_ERROR;

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');
360: fnd_message.set_token('ERRNO', sqlcode);

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_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');
367: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT');

Line 371: RAISE FND_API.G_EXC_UNEXPECTED_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);
375: END IF;

Line 402: WHEN FND_API.G_EXC_ERROR THEN

398: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
399: END IF;
400: --Exception Handling
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,

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

399: END IF;
400: --Exception Handling
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,

Line 406: p_encoded => FND_API.G_FALSE,

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: );
410: IF x_msg_count > 1 THEN

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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:
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 (

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413: END LOOP;
414: END IF;
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,

Line 420: p_encoded => FND_API.G_FALSE,

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: );
424: IF x_msg_count > 1 THEN

Line 431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

427: END LOOP;
428: END IF;
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);

Line 441: p_encoded => FND_API.G_FALSE,

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: );
445: IF x_msg_count > 1 THEN

Line 468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

464: ----------------------------------------------------------------------
465:
466: PROCEDURE Get_FormattedOutput
467: (p_api_version IN NUMBER,
468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
469: p_commit IN VARCHAR2 := FND_API.G_FALSE,
470: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
471: x_return_status OUT NOCOPY VARCHAR2,
472: x_msg_count OUT NOCOPY NUMBER,

Line 469: p_commit IN VARCHAR2 := FND_API.G_FALSE,

465:
466: PROCEDURE Get_FormattedOutput
467: (p_api_version IN NUMBER,
468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
469: p_commit IN VARCHAR2 := FND_API.G_FALSE,
470: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
471: x_return_status OUT NOCOPY VARCHAR2,
472: x_msg_count OUT NOCOPY NUMBER,
473: x_msg_data OUT NOCOPY VARCHAR2,

Line 470: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

466: PROCEDURE Get_FormattedOutput
467: (p_api_version IN NUMBER,
468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
469: p_commit IN VARCHAR2 := FND_API.G_FALSE,
470: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
471: x_return_status OUT NOCOPY VARCHAR2,
472: x_msg_count OUT NOCOPY NUMBER,
473: x_msg_data OUT NOCOPY VARCHAR2,
474: p_execution_detail_id IN NUMBER,

Line 491: l_return_status := FND_API.G_RET_STS_SUCCESS;

487: IF g_debug THEN
488: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
489: END IF;
490: -- Initialize API return status to sucess
491: l_return_status := FND_API.G_RET_STS_SUCCESS;
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');

Line 497: RAISE FND_API.G_EXC_ERROR;

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');
501:

Line 515: RAISE FND_API.G_EXC_ERROR;

511: -- Debug Message
512: IF g_debug THEN
513: DPP_UTILITY_PVT.debug_message('Formatted Output was not created by Request');
514: END IF;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: x_return_status := l_return_status;
519:

Line 526: WHEN FND_API.G_EXC_ERROR THEN

522: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
523: END IF;
524: --Exception Handling
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,

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: END IF;
524: --Exception Handling
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,

Line 530: p_encoded => FND_API.G_FALSE,

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: );
534: IF x_msg_count > 1 THEN

Line 539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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:
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 (

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

537: END LOOP;
538: END IF;
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,

Line 544: p_encoded => FND_API.G_FALSE,

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: );
548: IF x_msg_count > 1 THEN

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: END LOOP;
552: END IF;
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);

Line 564: p_encoded => FND_API.G_FALSE,

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: );
568: IF x_msg_count > 1 THEN