58:
59: --
60:
61: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize ;
63: END IF;
64: --
65: p_return_status := FND_API.G_RET_STS_SUCCESS ;
66:
105: IF FND_API.To_Boolean ( p_commit ) THEN
106: COMMIT WORK;
107: END iF;
108: --
109: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
110: p_data => p_msg_data );
111: --
112: EXCEPTION
113: --
114: WHEN FND_API.G_EXC_ERROR THEN
115: --
116: ROLLBACK TO Insert_Row_Pvt ;
117: p_return_status := FND_API.G_RET_STS_ERROR;
118: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
119: p_data => p_msg_data );
120: --
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: --
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: --
123: ROLLBACK TO Insert_Row_Pvt ;
124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
126: p_data => p_msg_data );
127: --
128: WHEN OTHERS THEN
129: --
129: --
130: ROLLBACK TO Insert_Row_Pvt ;
131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: --
133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
135: l_api_name);
136: END if;
137: --
130: ROLLBACK TO Insert_Row_Pvt ;
131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: --
133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
135: l_api_name);
136: END if;
137: --
138: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
134: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
135: l_api_name);
136: END if;
137: --
138: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
139: p_data => p_msg_data );
140: --
141: END Insert_Row;
142: /*-------------------------------------------------------------------------*/
189: END IF;
190: --
191:
192: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
193: FND_MSG_PUB.initialize ;
194: END IF;
195: --
196: p_return_status := FND_API.G_RET_STS_SUCCESS ;
197: --
233: IF FND_API.To_Boolean ( p_commit ) THEN
234: COMMIT WORK;
235: END iF;
236: --
237: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
238: p_data => p_msg_data );
239: --
240: EXCEPTION
241: --
242: WHEN FND_API.G_EXC_ERROR THEN
243: --
244: ROLLBACK TO Update_Row_Pvt ;
245: p_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
247: p_data => p_msg_data );
248: --
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: --
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: --
251: ROLLBACK TO Update_Row_Pvt ;
252: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
254: p_data => p_msg_data );
255: --
256: WHEN OTHERS THEN
257: --
257: --
258: ROLLBACK TO Update_Row_Pvt ;
259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: --
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
262: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
263: l_api_name);
264: END if;
265: --
258: ROLLBACK TO Update_Row_Pvt ;
259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: --
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
262: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
263: l_api_name);
264: END if;
265: --
266: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
262: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
263: l_api_name);
264: END if;
265: --
266: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
267: p_data => p_msg_data );
268: --
269: END Update_Row;
270: /* ----------------------------------------------------------------------- */