DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_PVT dependencies on STANDARD

Line 56: -- Standard begin of API savepoint

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

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

54: BEGIN
55:
56: -- Standard begin of API savepoint
57: SAVEPOINT Update_ExecutionDetails_PVT;
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version,
60: p_api_version,
61: l_api_name,
62: 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 216: -- Standard call to get message count and if count is 1, get message info.

212: -- Debug Message
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: );

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

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

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

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

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

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,
264: 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 351: -- Standard check for p_commit

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

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

356: -- Debug Message
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: );

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

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

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

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

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

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