60: END IF;
61: --
62:
63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize ;
65: END IF;
66: --
67: p_return_status := FND_API.G_RET_STS_SUCCESS ;
68: --
115: IF FND_API.To_Boolean ( p_commit ) THEN
116: COMMIT WORK;
117: END iF;
118: --
119: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
120: p_data => p_msg_data );
121: --
122: EXCEPTION
123: --
124: WHEN FND_API.G_EXC_ERROR THEN
125: --
126: ROLLBACK TO Update_Row_Pvt ;
127: p_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
129: p_data => p_msg_data );
130: --
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: --
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: --
133: ROLLBACK TO Update_Row_Pvt ;
134: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
136: p_data => p_msg_data );
137: --
138: WHEN OTHERS THEN
139: --
139: --
140: ROLLBACK TO Update_Row_Pvt ;
141: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: --
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
145: l_api_name);
146: END if;
147: --
140: ROLLBACK TO Update_Row_Pvt ;
141: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: --
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
145: l_api_name);
146: END if;
147: --
148: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
145: l_api_name);
146: END if;
147: --
148: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
149: p_data => p_msg_data );
150: --
151: END Update_Row;
152: /* ----------------------------------------------------------------------- */