127: AND parent_id = p_parent_id;
128: EXCEPTION
129: WHEN TOO_MANY_ROWS THEN
130: x_return_status := FND_API.g_ret_sts_error;
131: FND_MESSAGE.set_name ('AMS', 'AMS_CSCH_NOT_UNIQUE');
132: FND_MSG_PUB.add;
133: RETURN;
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := FND_API.g_ret_sts_error;
132: FND_MSG_PUB.add;
133: RETURN;
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := FND_API.g_ret_sts_error;
136: FND_MESSAGE.set_name ('AMS', 'AMS_CSCH_NOT_FOUND');
137: FND_MSG_PUB.add;
138: RETURN;
139: END;
140: