40:
41:
42: IF FND_API.to_Boolean ( p_init_msg_list )
43: THEN
44: FND_MSG_PUB.initialize ;
45: END IF;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS ;
48:
283: THEN
284: COMMIT WORK;
285: END IF;
286:
287: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
288: p_data => x_msg_data );
289:
290: EXCEPTION
291:
293: THEN
294:
295: ROLLBACK TO Insert_Row_Pvt ;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
298: p_data => x_msg_data );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
301: THEN
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
301: THEN
302: ROLLBACK TO Insert_Row_Pvt ;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
305: p_data => x_msg_data );
306:
307: WHEN OTHERS
308: THEN
308: THEN
309: ROLLBACK TO Insert_Row_Pvt ;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
315: l_api_name);
316: END IF;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
315: l_api_name);
316: END IF;
317:
318: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
314: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
315: l_api_name);
316: END IF;
317:
318: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
319: p_data => x_msg_data );
320:
321: END Insert_Row;
322: /*-------------------------------------------------------------------------*/
356:
357:
358: IF FND_API.to_Boolean ( p_init_msg_list )
359: THEN
360: FND_MSG_PUB.initialize ;
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS ;
364:
489: THEN
490: COMMIT WORK;
491: END IF;
492:
493: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
494: p_data => x_msg_data );
495:
496: EXCEPTION
497:
499: THEN
500: ROLLBACK TO Update_Row_Pvt ;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
504: p_data => x_msg_data );
505:
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
507: THEN
507: THEN
508:
509: ROLLBACK TO Update_Row_Pvt ;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
512: p_data => x_msg_data );
513:
514: WHEN OTHERS
515: THEN
516:
517: ROLLBACK TO Update_Row_Pvt ;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN
522: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
523: l_api_name);
524: END IF;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN
522: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
523: l_api_name);
524: END IF;
525:
526: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
522: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
523: l_api_name);
524: END IF;
525:
526: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
527: p_data => x_msg_data );
528:
529: END Update_Row;
530: /* ----------------------------------------------------------------------- */