1461:
1462:
1463: -- Start API initialization
1464:
1465: FND_MSG_PUB.initialize;
1466:
1467:
1468: x_return_status := FND_API.G_RET_STS_SUCCESS;
1469: -- End API initialization
2108: WHEN FND_API.G_EXC_ERROR THEN
2109: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_ERROR ');
2110: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
2111: ROLLBACK;
2112: FND_MSG_PUB.Count_And_Get
2113: ( p_count => x_msg_count
2114: , p_data => x_msg_data
2115: );
2116: x_return_status := FND_API.g_ret_sts_error;
2118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2119: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');
2120: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
2121: ROLLBACK ;
2122: FND_MSG_PUB.Count_And_Get
2123: ( p_count => x_msg_count
2124: , p_data => x_msg_data
2125: );
2126:
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128:
2129: WHEN OTHERS THEN
2130: ROLLBACK ;
2131: FND_MSG_PUB.Count_And_Get
2132: ( p_count => x_msg_count
2133: , p_data => x_msg_data
2134: );
2135: