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

66: END IF;
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list )
69: THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- Debug Message
74: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');

Line 216: FND_MSG_PUB.Count_And_Get

212: -- Debug Message
213: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');
214:
215: -- Standard call to get message count and if count is 1, get message info.
216: FND_MSG_PUB.Count_And_Get
217: (p_count => x_msg_count,
218: p_data => x_msg_data
219: );
220:

Line 227: FND_MSG_PUB.Count_And_Get (

223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO Update_ExecutionDetails_PVT;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );

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

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

Line 241: FND_MSG_PUB.Count_And_Get (

237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO Update_ExecutionDetails_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: -- Standard call to get message count and if count=1, get the message
241: FND_MSG_PUB.Count_And_Get (
242: p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data
245: );

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

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

Line 258: fnd_msg_pub.add;

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

Line 260: FND_MSG_PUB.Count_And_Get (

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

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

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

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: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');

Line 359: FND_MSG_PUB.Count_And_Get

355: -- Debug Message
356: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');
357:
358: -- Standard call to get message count and if count is 1, get message info.
359: FND_MSG_PUB.Count_And_Get
360: (p_count => x_msg_count,
361: p_data => x_msg_data
362: );
363:

Line 370: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 384: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 401: fnd_msg_pub.add;

397: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
398: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ESB_InstanceID');
399: fnd_message.set_token('ERRNO', sqlcode);
400: fnd_message.set_token('REASON', sqlerrm);
401: fnd_msg_pub.add;
402: -- Standard call to get message count and if count=1, get the message
403: FND_MSG_PUB.Count_And_Get (
404: p_encoded => FND_API.G_FALSE,
405: p_count => x_msg_count,

Line 403: FND_MSG_PUB.Count_And_Get (

399: fnd_message.set_token('ERRNO', sqlcode);
400: fnd_message.set_token('REASON', sqlerrm);
401: fnd_msg_pub.add;
402: -- Standard call to get message count and if count=1, get the message
403: FND_MSG_PUB.Count_And_Get (
404: p_encoded => FND_API.G_FALSE,
405: p_count => x_msg_count,
406: p_data => x_msg_data
407: );

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

406: p_data => x_msg_data
407: );
408: IF x_msg_count > 1 THEN
409: FOR I IN 1..x_msg_count LOOP
410: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
411: END LOOP;
412: END IF;
413: END Update_ESB_InstanceID;
414: