DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_PVT dependencies on FND_MESSAGE

Line 255: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

251: END IF;
252: WHEN OTHERS THEN
253: ROLLBACK TO Update_ExecutionDetails_PVT;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 256: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ExecutionDetails');

252: WHEN OTHERS THEN
253: ROLLBACK TO Update_ExecutionDetails_PVT;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 257: fnd_message.set_token('ERRNO', sqlcode);

253: ROLLBACK TO Update_ExecutionDetails_PVT;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 (

Line 258: fnd_message.set_token('REASON', sqlerrm);

254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 399: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

395: END IF;
396: WHEN OTHERS THEN
397: ROLLBACK TO Update_ESB_InstanceID_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 400: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ESB_InstanceID');

396: WHEN OTHERS THEN
397: ROLLBACK TO Update_ESB_InstanceID_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 401: fnd_message.set_token('ERRNO', sqlcode);

397: ROLLBACK TO Update_ESB_InstanceID_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 (

Line 402: fnd_message.set_token('REASON', sqlerrm);

398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,