27: ) IS
28:
29: BEGIN
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: INSERT INTO EAM_ASSET_SAFETY_TYPES
34: (
35: INSTANCE_ID,
65:
66: EXCEPTION
67:
68: WHEN OTHERS THEN
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: END INSERT_ROW;
72:
73:
79: l_instance_id NUMBER;
80:
81: BEGIN
82:
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: UPDATE EAM_ASSET_SAFETY_TYPES
86: SET
87: eam_safety_type = p_eAM_asset_safety_rec.safety_type,
100:
101:
102: EXCEPTION
103: WHEN NO_DATA_FOUND THEN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: Return;
106:
107: WHEN OTHERS THEN
108: x_return_status := FND_API.G_RET_STS_ERROR;
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: Return;
106:
107: WHEN OTHERS THEN
108: x_return_status := FND_API.G_RET_STS_ERROR;
109:
110: END UPDATE_ROW;
111: END EAM_SAFETY_ASSET_NUMBER_PVT;