DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_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_EXECUTIONDETAILS_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) := 'dppvexeb.pls';
13:
14: ---------------------------------------------------------------------
15: -- PROCEDURE

Line 69: FND_MSG_PUB.initialize;

65: END IF;
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.to_Boolean( p_init_msg_list )
68: THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Debug Message
73: IF g_debug THEN

Line 217: FND_MSG_PUB.Count_And_Get

213: IF g_debug THEN
214: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
215: END IF;
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: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO Update_ExecutionDetails_PVT;
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: ROLLBACK TO Update_ExecutionDetails_PVT;

Line 242: FND_MSG_PUB.Count_And_Get (

238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO Update_ExecutionDetails_PVT;
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: ROLLBACK TO Update_ExecutionDetails_PVT;

Line 259: fnd_msg_pub.add;

255: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
256: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ExecutionDetails');
257: fnd_message.set_token('ERRNO', sqlcode);
258: fnd_message.set_token('REASON', sqlerrm);
259: fnd_msg_pub.add;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,

Line 261: FND_MSG_PUB.Count_And_Get (

257: fnd_message.set_token('ERRNO', sqlcode);
258: fnd_message.set_token('REASON', sqlerrm);
259: fnd_msg_pub.add;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );

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

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

Line 324: FND_MSG_PUB.initialize;

320: END IF;
321: -- Initialize message list if p_init_msg_list is set to TRUE.
322: IF FND_API.to_Boolean( p_init_msg_list )
323: THEN
324: FND_MSG_PUB.initialize;
325: END IF;
326:
327: -- Debug Message
328: IF g_debug THEN

Line 361: FND_MSG_PUB.Count_And_Get

357: IF g_debug THEN
358: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
359: END IF;
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: (p_count => x_msg_count,
363: p_data => x_msg_data
364: );
365:

Line 372: FND_MSG_PUB.Count_And_Get (

368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK TO Update_ESB_InstanceID_PVT;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: -- Standard call to get message count and if count=1, get the message
372: FND_MSG_PUB.Count_And_Get (
373: p_encoded => FND_API.G_FALSE,
374: p_count => x_msg_count,
375: p_data => x_msg_data
376: );

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

375: p_data => x_msg_data
376: );
377: IF x_msg_count > 1 THEN
378: FOR I IN 1..x_msg_count LOOP
379: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
380: END LOOP;
381: END IF;
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: ROLLBACK TO Update_ESB_InstanceID_PVT;

Line 386: FND_MSG_PUB.Count_And_Get (

382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: ROLLBACK TO Update_ESB_InstanceID_PVT;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: -- Standard call to get message count and if count=1, get the message
386: FND_MSG_PUB.Count_And_Get (
387: p_encoded => FND_API.G_FALSE,
388: p_count => x_msg_count,
389: p_data => x_msg_data
390: );

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

389: p_data => x_msg_data
390: );
391: IF x_msg_count > 1 THEN
392: FOR I IN 1..x_msg_count LOOP
393: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
394: END LOOP;
395: END IF;
396: WHEN OTHERS THEN
397: ROLLBACK TO Update_ESB_InstanceID_PVT;

Line 403: fnd_msg_pub.add;

399: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
400: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ESB_InstanceID');
401: fnd_message.set_token('ERRNO', sqlcode);
402: fnd_message.set_token('REASON', sqlerrm);
403: fnd_msg_pub.add;
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 405: FND_MSG_PUB.Count_And_Get (

401: fnd_message.set_token('ERRNO', sqlcode);
402: fnd_message.set_token('REASON', sqlerrm);
403: fnd_msg_pub.add;
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, 4000);

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, 4000);
413: END LOOP;
414: END IF;
415: END Update_ESB_InstanceID;
416: