DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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