62: WHEN OTHERS THEN
63: ROLLBACK TO Update_Disposition_PVT;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65:
66: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
67: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
68: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
69: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
70: FND_MSG_PUB.Add;
63: ROLLBACK TO Update_Disposition_PVT;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65:
66: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
67: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
68: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
69: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
70: FND_MSG_PUB.Add;
71: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65:
66: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
67: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
68: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
69: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
70: FND_MSG_PUB.Add;
71: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
72: ,p_count => x_msg_count
65:
66: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
67: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
68: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
69: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
70: FND_MSG_PUB.Add;
71: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
72: ,p_count => x_msg_count
73: ,p_data => x_msg_data);
134: WHEN OTHERS THEN
135: ROLLBACK TO Set_Collaboration_Id_PVT;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137:
138: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
139: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
140: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
141: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
142: FND_MSG_PUB.Add;
135: ROLLBACK TO Set_Collaboration_Id_PVT;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137:
138: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
139: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
140: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
141: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
142: FND_MSG_PUB.Add;
143: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137:
138: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
139: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
140: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
141: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
142: FND_MSG_PUB.Add;
143: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
144: ,p_count => x_msg_count
137:
138: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
139: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
140: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
141: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
142: FND_MSG_PUB.Add;
143: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
144: ,p_count => x_msg_count
145: ,p_data => x_msg_data);
220: WHEN OTHERS THEN
221: ROLLBACK TO Add_Additional_CIC_Info_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223:
224: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
225: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
226: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
227: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
228: FND_MSG_PUB.Add;
221: ROLLBACK TO Add_Additional_CIC_Info_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223:
224: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
225: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
226: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
227: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
228: FND_MSG_PUB.Add;
229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223:
224: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
225: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
226: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
227: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
228: FND_MSG_PUB.Add;
229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
230: ,p_count => x_msg_count
223:
224: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
225: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
226: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
227: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
228: FND_MSG_PUB.Add;
229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
230: ,p_count => x_msg_count
231: ,p_data => x_msg_data);