DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_PVT dependencies on STANDARD

Line 57: -- Standard begin of API savepoint

53: l_process_code VARCHAR2(30);
54:
55: BEGIN
56:
57: -- Standard begin of API savepoint
58: SAVEPOINT Update_ExecutionDetails_PVT;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version,
61: p_api_version,

Line 59: -- Standard call to check for call compatibility.

55: BEGIN
56:
57: -- Standard begin of API savepoint
58: SAVEPOINT Update_ExecutionDetails_PVT;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME)

Line 207: -- Standard check for p_commit

203: END IF;
204: END LOOP;
205:
206: x_return_status := l_return_status;
207: -- Standard check for p_commit
208: IF FND_API.to_Boolean( p_commit )
209: THEN
210: COMMIT WORK;
211: END IF;

Line 215: -- Standard call to get message count and if count is 1, get message info.

211: END IF;
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: );

Line 226: -- Standard call to get message count and if count=1, get the message

222: EXCEPTION
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

Line 240: -- Standard call to get message count and if count=1, get the message

236: END IF;
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

Line 259: -- Standard call to get message count and if count=1, get the message

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,
263: p_data => x_msg_data

Line 311: -- Standard begin of API savepoint

307: l_update_count NUMBER;
308:
309: BEGIN
310:
311: -- Standard begin of API savepoint
312: SAVEPOINT Update_ESB_InstanceID_PVT;
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version,
315: p_api_version,

Line 313: -- Standard call to check for call compatibility.

309: BEGIN
310:
311: -- Standard begin of API savepoint
312: SAVEPOINT Update_ESB_InstanceID_PVT;
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version,
315: p_api_version,
316: l_api_name,
317: G_PKG_NAME)

Line 350: -- Standard check for p_commit

346: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Invalid Execution Detail ID: ' || p_Execution_Detail_ID);
347: END IF;
348:
349: x_return_status := l_return_status;
350: -- Standard check for p_commit
351: IF FND_API.to_Boolean( p_commit )
352: THEN
353: COMMIT WORK;
354: END IF;

Line 358: -- Standard call to get message count and if count is 1, get message info.

354: END IF;
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: );

Line 369: -- Standard call to get message count and if count=1, get the message

365: EXCEPTION
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

Line 383: -- Standard call to get message count and if count=1, get the message

379: END IF;
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

Line 402: -- Standard call to get message count and if count=1, get the message

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,
406: p_data => x_msg_data