41:
42:
43: IF FND_API.to_Boolean ( p_init_msg_list )
44: THEN
45: FND_MSG_PUB.initialize ;
46: END IF;
47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS ;
49:
252: THEN
253: COMMIT WORK;
254: END IF;
255:
256: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
257: p_data => x_msg_data );
258:
259: EXCEPTION
260:
262: THEN
263:
264: ROLLBACK TO Insert_Row_Pvt ;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
267: p_data => x_msg_data );
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
270: THEN
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
270: THEN
271: ROLLBACK TO Insert_Row_Pvt ;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
274: p_data => x_msg_data );
275:
276: WHEN OTHERS
277: THEN
277: THEN
278: ROLLBACK TO Insert_Row_Pvt ;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280:
281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
282: THEN
283: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
284: l_api_name);
285: END IF;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280:
281: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
282: THEN
283: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
284: l_api_name);
285: END IF;
286:
287: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
283: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
284: l_api_name);
285: END IF;
286:
287: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
288: p_data => x_msg_data );
289:
290: END Insert_Row;
291: /*-------------------------------------------------------------------------*/
325:
326:
327: IF FND_API.to_Boolean ( p_init_msg_list )
328: THEN
329: FND_MSG_PUB.initialize ;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS ;
333:
441: THEN
442: COMMIT WORK;
443: END IF;
444:
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
446: p_data => x_msg_data );
447:
448: EXCEPTION
449:
451: THEN
452: ROLLBACK TO Update_Row_Pvt ;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454:
455: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
456: p_data => x_msg_data );
457:
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
459: THEN
459: THEN
460:
461: ROLLBACK TO Update_Row_Pvt ;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
464: p_data => x_msg_data );
465:
466: WHEN OTHERS
467: THEN
468:
469: ROLLBACK TO Update_Row_Pvt ;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471:
472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END IF;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471:
472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END IF;
477:
478: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END IF;
477:
478: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
479: p_data => x_msg_data );
480:
481: END Update_Row;
482:
516:
517:
518: IF FND_API.to_Boolean ( p_init_msg_list )
519: THEN
520: FND_MSG_PUB.initialize ;
521: END IF;
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS ;
524:
537: THEN
538: COMMIT WORK;
539: END IF;
540:
541: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
542: p_data => x_msg_data );
543:
544: EXCEPTION
545:
547: THEN
548: ROLLBACK TO Delete_Row_Pvt ;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550:
551: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
555: THEN
555: THEN
556:
557: ROLLBACK TO Delete_Row_Pvt ;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
560: p_data => x_msg_data );
561:
562: WHEN OTHERS
563: THEN
564:
565: ROLLBACK TO Delete_Row_Pvt ;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567:
568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
571: l_api_name);
572: END IF;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567:
568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
571: l_api_name);
572: END IF;
573:
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
570: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
571: l_api_name);
572: END IF;
573:
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
575: p_data => x_msg_data );
576:
577: END Delete_Row;
578: