29: ) IS
30:
31: BEGIN
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: INSERT INTO CSI_II_GEOLOCATIONS
36: (
37: INSTANCE_ID,
59:
60: EXCEPTION
61:
62: WHEN OTHERS THEN
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: END INSERT_ROW;
66:
67:
76: l_instance_id NUMBER;
77:
78: BEGIN
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF p_valid_flag = 'N' THEN
83:
84: UPDATE CSI_II_GEOLOCATIONS
106:
107:
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: Return;
112:
113: WHEN OTHERS THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: Return;
112:
113: WHEN OTHERS THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115:
116: END UPDATE_ROW;
117: END CSI_GIS_INSTANCE_GEO_LOC_PVT;